diff options
| -rw-r--r-- | sql/updates/world/master/2022_12_25_00_world.sql | 359 |
1 files changed, 359 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_12_25_00_world.sql b/sql/updates/world/master/2022_12_25_00_world.sql new file mode 100644 index 00000000000..d5aeb15f218 --- /dev/null +++ b/sql/updates/world/master/2022_12_25_00_world.sql @@ -0,0 +1,359 @@ +SET @CGUID := 1250427; + +SET @NPCTEXTID := 590018; + +-- Creature +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+185; +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES +(@CGUID+0, 183997, 2444, 13646, 13852, '0', 18098, 0, 0, 0, -2442.83154296875, 3729.799560546875, 486.34130859375, 1.094881415367126464, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Gnoll Mon-Ark (Area: Creektooth Den - Difficulty: 0) (Auras: 368258 - Add Crown) +(@CGUID+1, 183997, 2444, 13646, 13852, '0', 18097, 0, 0, 0, -2318.317626953125, 3780.303955078125, 464.796173095703125, 1.094881415367126464, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Gnoll Mon-Ark (Area: Creektooth Den - Difficulty: 0) +(@CGUID+2, 189840, 2444, 13646, 13852, '0', 18471, 0, 0, 0, -2325.505126953125, 3782.936767578125, 465.154754638671875, 3.502516984939575195, 120, 0, 0, 335920, 34410, 0, 0, 0, 0, 47213), -- Purified Slime (Area: Creektooth Den - Difficulty: 0) +(@CGUID+3, 186139, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2350.73779296875, 3760.1171875, 478.13238525390625, 0.874214589595794677, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Brackenhide Warrior (Area: Creektooth Den - Difficulty: 0) +(@CGUID+4, 186142, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2387.3681640625, 3787.234375, 490.30340576171875, 2.561675548553466796, 120, 0, 0, 35312, 0, 0, 0, 0, 0, 47213), -- Brackenhide Whelp (Area: Creektooth Den - Difficulty: 0) +(@CGUID+5, 186140, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2353.8369140625, 3760.682373046875, 478.592193603515625, 1.020093441009521484, 120, 0, 0, 53747, 6882, 0, 0, 0, 0, 47213), -- Brackenhide Shaman (Area: Creektooth Den - Difficulty: 0) +(@CGUID+6, 186139, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2350.515625, 3843.520751953125, 463.699005126953125, 0.874214589595794677, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Brackenhide Warrior (Area: Creektooth Den - Difficulty: 0) +(@CGUID+7, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2355.026123046875, 3758.842041015625, 479.66851806640625, 0.861368536949157714, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+8, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2347.24658203125, 3746.491455078125, 480.64300537109375, 0, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+9, 186139, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2352.132080078125, 3735.123291015625, 481.293426513671875, 0.874214589595794677, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Brackenhide Warrior (Area: Creektooth Den - Difficulty: 0) (Auras: 368927 - Cosmetic - Sleep Zzz (With Aggro Change) - Breath) +(@CGUID+10, 186142, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2369.232666015625, 3743.69091796875, 482.488189697265625, 0.751501441001892089, 120, 0, 0, 35312, 0, 0, 0, 0, 0, 47213), -- Brackenhide Whelp (Area: Creektooth Den - Difficulty: 0) +(@CGUID+11, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2352.82470703125, 3758.6328125, 479.053009033203125, 1.697882890701293945, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+12, 186137, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2354.901123046875, 3759.5, 479.458953857421875, 0.86542665958404541, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Decay Totem (Area: Creektooth Den - Difficulty: 0) +(@CGUID+13, 186139, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2354.47216796875, 3763.768310546875, 478.148284912109375, 0.874214589595794677, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Brackenhide Warrior (Area: Creektooth Den - Difficulty: 0) +(@CGUID+14, 186139, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2368.529296875, 3740.361328125, 482.497467041015625, 0.874214589595794677, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Brackenhide Warrior (Area: Creektooth Den - Difficulty: 0) +(@CGUID+15, 186140, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2347.37841796875, 3749.703125, 480.64300537109375, 0, 120, 0, 0, 53747, 6882, 0, 0, 0, 0, 47213), -- Brackenhide Shaman (Area: Creektooth Den - Difficulty: 0) +(@CGUID+16, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2356.59033203125, 3759.998291015625, 480.09674072265625, 0.594685971736907958, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+17, 186140, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2349.600830078125, 3841.309814453125, 463.90008544921875, 0.611854851245880126, 120, 0, 0, 53747, 6882, 0, 0, 0, 0, 47213), -- Brackenhide Shaman (Area: Creektooth Den - Difficulty: 0) +(@CGUID+18, 186139, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2348.717041015625, 3838.3994140625, 464.043243408203125, 0.874214589595794677, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Brackenhide Warrior (Area: Creektooth Den - Difficulty: 0) +(@CGUID+19, 186142, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2344.876708984375, 3749.357666015625, 480.64300537109375, 0, 120, 0, 0, 35312, 0, 0, 0, 0, 0, 47213), -- Brackenhide Whelp (Area: Creektooth Den - Difficulty: 0) +(@CGUID+20, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2355.739501953125, 3761.453125, 479.366180419921875, 0.746908009052276611, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+21, 186142, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2384.49658203125, 3767.55029296875, 490.532989501953125, 0, 120, 0, 0, 35312, 0, 0, 0, 0, 0, 47213), -- Brackenhide Whelp (Area: Creektooth Den - Difficulty: 0) +(@CGUID+22, 186139, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2373.744873046875, 3741.756103515625, 483.394439697265625, 0.6340523362159729, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Brackenhide Warrior (Area: Creektooth Den - Difficulty: 0) +(@CGUID+23, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2354.107666015625, 3757.619873046875, 479.620941162109375, 1.130970954895019531, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+24, 186140, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2386.079833984375, 3770.623291015625, 490.532989501953125, 5.313592433929443359, 120, 0, 0, 53747, 6882, 0, 0, 0, 0, 47213), -- Brackenhide Shaman (Area: Creektooth Den - Difficulty: 0) +(@CGUID+25, 186139, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2375.40283203125, 3738.278564453125, 483.827423095703125, 0.874214589595794677, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Brackenhide Warrior (Area: Creektooth Den - Difficulty: 0) +(@CGUID+26, 186140, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2425.72216796875, 3763.7275390625, 488.011505126953125, 5.940517902374267578, 120, 0, 0, 53747, 6882, 0, 0, 0, 0, 47213), -- Brackenhide Shaman (Area: Creektooth Den - Difficulty: 0) +(@CGUID+27, 186142, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2386.734375, 3764.52783203125, 490.526763916015625, 5.849551200866699218, 120, 0, 0, 35312, 0, 0, 0, 0, 0, 47213), -- Brackenhide Whelp (Area: Creektooth Den - Difficulty: 0) +(@CGUID+28, 186142, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2376.428955078125, 3743.262939453125, 484.219757080078125, 0.506528973579406738, 120, 0, 0, 35312, 0, 0, 0, 0, 0, 47213), -- Brackenhide Whelp (Area: Creektooth Den - Difficulty: 0) +(@CGUID+29, 186142, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2388.404541015625, 3769.328125, 490.407989501953125, 5.849551200866699218, 120, 0, 0, 35312, 0, 0, 0, 0, 0, 47213), -- Brackenhide Whelp (Area: Creektooth Den - Difficulty: 0) +(@CGUID+30, 186140, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2423.757080078125, 3804.776123046875, 492.00250244140625, 4.757121086120605468, 120, 0, 0, 53747, 6882, 0, 0, 0, 0, 47213), -- Brackenhide Shaman (Area: Creektooth Den - Difficulty: 0) +(@CGUID+31, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2434.73779296875, 3801.52685546875, 492.56610107421875, 0, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+32, 186140, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2423.67529296875, 3760.546875, 487.837310791015625, 0, 120, 0, 0, 53747, 6882, 0, 0, 0, 0, 47213), -- Brackenhide Shaman (Area: Creektooth Den - Difficulty: 0) +(@CGUID+33, 186139, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2391.1962890625, 3742.076416015625, 485.622467041015625, 0.874214589595794677, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Brackenhide Warrior (Area: Creektooth Den - Difficulty: 0) +(@CGUID+34, 186140, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2381.08154296875, 3734.271728515625, 485.52197265625, 1.020093441009521484, 120, 0, 0, 53747, 6882, 0, 0, 0, 0, 47213), -- Brackenhide Shaman (Area: Creektooth Den - Difficulty: 0) +(@CGUID+35, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2378.826416015625, 3734.0390625, 485.072998046875, 1.697882890701293945, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+36, 186140, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2421.185791015625, 3764.482666015625, 488.056549072265625, 0, 120, 0, 0, 53747, 6882, 0, 0, 0, 0, 47213), -- Brackenhide Shaman (Area: Creektooth Den - Difficulty: 0) +(@CGUID+37, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2381.39404296875, 3735.556396484375, 485.332275390625, 1.697882890701293945, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+38, 186139, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2371.78466796875, 3738.03466796875, 482.975982666015625, 1.144076943397521972, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Brackenhide Warrior (Area: Creektooth Den - Difficulty: 0) +(@CGUID+39, 186139, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2379.036376953125, 3740.973876953125, 484.28228759765625, 0.445002496242523193, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Brackenhide Warrior (Area: Creektooth Den - Difficulty: 0) +(@CGUID+40, 186142, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2395.966796875, 3779.498046875, 490.282989501953125, 5.58262491226196289, 120, 0, 0, 35312, 0, 0, 0, 0, 0, 47213), -- Brackenhide Whelp (Area: Creektooth Den - Difficulty: 0) +(@CGUID+41, 186139, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2383.4150390625, 3738.87841796875, 485.206298828125, 0.874214589595794677, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Brackenhide Warrior (Area: Creektooth Den - Difficulty: 0) +(@CGUID+42, 186139, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2427.3525390625, 3745.5546875, 488.61083984375, 4.243900299072265625, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Brackenhide Warrior (Area: Creektooth Den - Difficulty: 0) +(@CGUID+43, 186137, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2429.814208984375, 3804.010498046875, 491.77294921875, 5.306643009185791015, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Decay Totem (Area: Creektooth Den - Difficulty: 0) +(@CGUID+44, 186142, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2429.4931640625, 3801.47314453125, 491.518310546875, 5.282771110534667968, 120, 0, 0, 35312, 0, 0, 0, 0, 0, 47213), -- Brackenhide Whelp (Area: Creektooth Den - Difficulty: 0) +(@CGUID+45, 186142, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2425.545166015625, 3802.923583984375, 491.606231689453125, 5.019095420837402343, 120, 0, 0, 35312, 0, 0, 0, 0, 0, 47213), -- Brackenhide Whelp (Area: Creektooth Den - Difficulty: 0) +(@CGUID+46, 186139, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2428.4375, 3804.960205078125, 491.82330322265625, 5.528970718383789062, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Brackenhide Warrior (Area: Creektooth Den - Difficulty: 0) +(@CGUID+47, 186142, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2427.814208984375, 3801.740478515625, 491.493072509765625, 4.930703163146972656, 120, 0, 0, 35312, 0, 0, 0, 0, 0, 47213), -- Brackenhide Whelp (Area: Creektooth Den - Difficulty: 0) +(@CGUID+48, 186142, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2431.350830078125, 3801.131103515625, 491.7509765625, 5.3477325439453125, 120, 0, 0, 35312, 0, 0, 0, 0, 0, 47213), -- Brackenhide Whelp (Area: Creektooth Den - Difficulty: 0) +(@CGUID+49, 186139, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2432.171875, 3804.7431640625, 491.90887451171875, 5.321416378021240234, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Brackenhide Warrior (Area: Creektooth Den - Difficulty: 0) +(@CGUID+50, 186140, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2433.6962890625, 3802.69091796875, 492.143341064453125, 5.628420829772949218, 120, 0, 0, 53747, 6882, 0, 0, 0, 0, 47213), -- Brackenhide Shaman (Area: Creektooth Den - Difficulty: 0) +(@CGUID+51, 186139, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2432.975830078125, 3747.1494140625, 488.1597900390625, 5.111589431762695312, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Brackenhide Warrior (Area: Creektooth Den - Difficulty: 0) +(@CGUID+52, 186139, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2405.13671875, 3855.9521484375, 494.73150634765625, 0.658201336860656738, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Brackenhide Warrior (Area: Creektooth Den - Difficulty: 0) +(@CGUID+53, 186142, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2435.498291015625, 3839.244873046875, 493.513397216796875, 2.649654150009155273, 120, 0, 0, 35312, 0, 0, 0, 0, 0, 47213), -- Brackenhide Whelp (Area: Creektooth Den - Difficulty: 0) +(@CGUID+54, 186142, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2438.217041015625, 3837.407958984375, 493.513397216796875, 2.569562196731567382, 120, 0, 0, 35312, 0, 0, 0, 0, 0, 47213), -- Brackenhide Whelp (Area: Creektooth Den - Difficulty: 0) +(@CGUID+55, 186142, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2442.432373046875, 3842.634521484375, 493.567108154296875, 0.024140490218997001, 120, 0, 0, 35312, 0, 0, 0, 0, 0, 47213), -- Brackenhide Whelp (Area: Creektooth Den - Difficulty: 0) +(@CGUID+56, 186142, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2442.491455078125, 3840.90966796875, 493.638397216796875, 0, 120, 0, 0, 35312, 0, 0, 0, 0, 0, 47213), -- Brackenhide Whelp (Area: Creektooth Den - Difficulty: 0) +(@CGUID+57, 186142, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2435.739501953125, 3844.856689453125, 493.638397216796875, 4.085095405578613281, 120, 0, 0, 35312, 0, 0, 0, 0, 0, 47213), -- Brackenhide Whelp (Area: Creektooth Den - Difficulty: 0) +(@CGUID+58, 186142, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2440.06591796875, 3846.087646484375, 493.763397216796875, 4.854411125183105468, 120, 0, 0, 35312, 0, 0, 0, 0, 0, 47213), -- Brackenhide Whelp (Area: Creektooth Den - Difficulty: 0) +(@CGUID+59, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2463.03466796875, 3892.8916015625, 495.7763671875, 4.684942245483398437, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+60, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2466.989501953125, 3892.2890625, 495.80364990234375, 5.38873291015625, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+61, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2465.092041015625, 3894.06591796875, 495.7518310546875, 4.684942245483398437, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+62, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2460.09375, 3895.2509765625, 495.877685546875, 4.684942245483398437, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+63, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2465.1337890625, 3896.841064453125, 495.7763671875, 4.986704349517822265, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+64, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2461.65625, 3897.7109375, 495.7763671875, 4.684942245483398437, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+65, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2462.845458984375, 3895.47314453125, 495.7763671875, 5.134770393371582031, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+66, 186139, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2507.58154296875, 3830.915771484375, 480.066650390625, 2.821946144104003906, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Brackenhide Warrior (Area: Creektooth Den - Difficulty: 0) +(@CGUID+67, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2467.361083984375, 3895.38720703125, 495.92291259765625, 0, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+68, 186139, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2417.99658203125, 3882.913330078125, 502.221160888671875, 5.449938774108886718, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Brackenhide Warrior (Area: Creektooth Den - Difficulty: 0) +(@CGUID+69, 186139, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2419.12841796875, 3880.140625, 501.727325439453125, 5.516218185424804687, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Brackenhide Warrior (Area: Creektooth Den - Difficulty: 0) +(@CGUID+70, 186139, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2416.163330078125, 3880.53564453125, 501.77899169921875, 4.580235481262207031, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Brackenhide Warrior (Area: Creektooth Den - Difficulty: 0) +(@CGUID+71, 186139, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2420.630126953125, 3882.47216796875, 502.17095947265625, 5.286113262176513671, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Brackenhide Warrior (Area: Creektooth Den - Difficulty: 0) +(@CGUID+72, 186139, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2421.307373046875, 3879.309814453125, 501.702880859375, 5.376831531524658203, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Brackenhide Warrior (Area: Creektooth Den - Difficulty: 0) +(@CGUID+73, 186139, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2510.076416015625, 3835.341064453125, 480.249847412109375, 5.101552009582519531, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Brackenhide Warrior (Area: Creektooth Den - Difficulty: 0) +(@CGUID+74, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2510.489501953125, 3925.1650390625, 498.981201171875, 5.707297801971435546, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+75, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2405.28466796875, 3941.467041015625, 495.41705322265625, 1.901330828666687011, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+76, 186139, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2434.723876953125, 3904.55908203125, 501.7703857421875, 2.87140965461730957, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Brackenhide Warrior (Area: Creektooth Den - Difficulty: 0) +(@CGUID+77, 186139, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2440.345458984375, 3908.51123046875, 500.253173828125, 3.337145805358886718, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Brackenhide Warrior (Area: Creektooth Den - Difficulty: 0) +(@CGUID+78, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2512.97216796875, 3925.126708984375, 499.22418212890625, 5.689587116241455078, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+79, 186140, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2463.919921875, 3900.72265625, 495.8233642578125, 5.168548583984375, 120, 0, 0, 53747, 6882, 0, 0, 0, 0, 47213), -- Brackenhide Shaman (Area: Creektooth Den - Difficulty: 0) +(@CGUID+80, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2405.447998046875, 3946.401123046875, 497.09674072265625, 2.014777898788452148, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+81, 186140, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2466.427001953125, 3899.624267578125, 495.7763671875, 5.279862403869628906, 120, 0, 0, 53747, 6882, 0, 0, 0, 0, 47213), -- Brackenhide Shaman (Area: Creektooth Den - Difficulty: 0) +(@CGUID+82, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2414.583984375, 3942.1337890625, 494.0477294921875, 1.843142867088317871, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+83, 186139, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2444.080078125, 3907.3740234375, 499.77392578125, 4.261514186859130859, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Brackenhide Warrior (Area: Creektooth Den - Difficulty: 0) +(@CGUID+84, 186140, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2440.828125, 3910.624267578125, 500.2745361328125, 3.781269788742065429, 120, 0, 0, 53747, 6882, 0, 0, 0, 0, 47213), -- Brackenhide Shaman (Area: Creektooth Den - Difficulty: 0) +(@CGUID+85, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2509.7119140625, 3927.41845703125, 499.024810791015625, 5.707297801971435546, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+86, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2406.845458984375, 3944.78125, 495.487152099609375, 2.078269004821777343, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+87, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2511.87841796875, 3926.61376953125, 499.10076904296875, 5.707297801971435546, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+88, 186139, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2444.333251953125, 3910.343017578125, 499.6832275390625, 3.22089552879333496, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Brackenhide Warrior (Area: Creektooth Den - Difficulty: 0) +(@CGUID+89, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2511.350830078125, 3919.275146484375, 499.1298828125, 1.000400424003601074, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+90, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2408.076416015625, 3940.9462890625, 495.0894775390625, 1.901330828666687011, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+91, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2416.0185546875, 3941.343994140625, 494.827880859375, 1.843142867088317871, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+92, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2417.167236328125, 3942.392333984375, 493.499847412109375, 1.843142867088317871, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+93, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2407.678955078125, 3943.060791015625, 495.209930419921875, 2.078269004821777343, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+94, 186142, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2419.5400390625, 3907.045166015625, 504.37127685546875, 4.150528430938720703, 120, 0, 0, 35312, 0, 0, 0, 0, 0, 47213), -- Brackenhide Whelp (Area: Creektooth Den - Difficulty: 0) +(@CGUID+95, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2511.432373046875, 3929.205810546875, 499.12353515625, 5.707297801971435546, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+96, 186139, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2429.850830078125, 3928.045166015625, 498.177764892578125, 1.976143836975097656, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Brackenhide Warrior (Area: Creektooth Den - Difficulty: 0) +(@CGUID+97, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2511.8056640625, 3930.718017578125, 499.341583251953125, 4.684942245483398437, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+98, 186142, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2409.763916015625, 3919.927978515625, 504.41668701171875, 1.275413990020751953, 120, 0, 0, 35312, 0, 0, 0, 0, 0, 47213), -- Brackenhide Whelp (Area: Creektooth Den - Difficulty: 0) +(@CGUID+99, 186139, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2428.276123046875, 3929.58251953125, 497.668853759765625, 1.727551579475402832, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Brackenhide Warrior (Area: Creektooth Den - Difficulty: 0) +(@CGUID+100, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2440.407958984375, 3977.979248046875, 485.251739501953125, 4.30217742919921875, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+101, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2464.673583984375, 3972.248291015625, 485.95166015625, 1.036871910095214843, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+102, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2442.859375, 3977.5556640625, 485.44927978515625, 4.302943229675292968, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+103, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2464.967041015625, 3974.17529296875, 485.82666015625, 1.036871910095214843, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+104, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2462.757080078125, 3972.3916015625, 485.95166015625, 1.036871910095214843, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+105, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2444.6806640625, 3976.75, 485.66510009765625, 4.675941944122314453, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+106, 186139, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2431.857666015625, 3929.585205078125, 497.623321533203125, 2.276350259780883789, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Brackenhide Warrior (Area: Creektooth Den - Difficulty: 0) +(@CGUID+107, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2441.55029296875, 3978.975830078125, 485.23785400390625, 4.194675922393798828, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+108, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2467.348876953125, 3975.040771484375, 485.900543212890625, 1.036871910095214843, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+109, 186142, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2499.8525390625, 3921.03564453125, 498.824127197265625, 2.102281808853149414, 120, 0, 0, 35312, 0, 0, 0, 0, 0, 47213), -- Brackenhide Whelp (Area: Creektooth Den - Difficulty: 0) +(@CGUID+110, 186142, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2501.78466796875, 3924.846435546875, 498.824127197265625, 4.843295097351074218, 120, 0, 0, 35312, 0, 0, 0, 0, 0, 47213), -- Brackenhide Whelp (Area: Creektooth Den - Difficulty: 0) +(@CGUID+111, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2464.892333984375, 3976.208251953125, 485.85205078125, 0.523279190063476562, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+112, 185751, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2481.19921875, 4032.6435546875, 494.0374755859375, 5.117939472198486328, 120, 0, 0, 523080, 0, 0, 0, 0, 0, 47213), -- The Chonker (Area: Creektooth Den - Difficulty: 0) +(@CGUID+113, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2466.533203125, 3979.3369140625, 485.79443359375, 5.98708200454711914, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+114, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2468.442626953125, 3983.259521484375, 485.926177978515625, 6.18253183364868164, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+115, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2468.083251953125, 3977.185791015625, 485.900543212890625, 0.581942260265350341, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+116, 186140, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2401.373291015625, 3942.338623046875, 495.77642822265625, 0.782186388969421386, 120, 0, 0, 53747, 6882, 0, 0, 0, 0, 47213), -- Brackenhide Shaman (Area: Creektooth Den - Difficulty: 0) +(@CGUID+117, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2399.34033203125, 3993.163330078125, 484.493621826171875, 2.156599283218383789, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+118, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2390.98095703125, 3994.776123046875, 485.272247314453125, 1.036871910095214843, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+119, 186140, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2469, 3956.142333984375, 495.968658447265625, 6.186953544616699218, 120, 0, 0, 53747, 6882, 0, 0, 0, 0, 47213), -- Brackenhide Shaman (Area: Creektooth Den - Difficulty: 0) +(@CGUID+120, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2409.991455078125, 4008.107666015625, 485.353851318359375, 1.036871910095214843, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+121, 186142, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2500.947998046875, 3941.2587890625, 498.898193359375, 4.845283031463623046, 120, 0, 0, 35312, 0, 0, 0, 0, 0, 47213), -- Brackenhide Whelp (Area: Creektooth Den - Difficulty: 0) +(@CGUID+122, 186137, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2443.239501953125, 3979.799560546875, 485.286407470703125, 4.9031829833984375, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Decay Totem (Area: Creektooth Den - Difficulty: 0) +(@CGUID+123, 186142, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2440.279541015625, 3979.850830078125, 485.102447509765625, 5.633120059967041015, 120, 0, 0, 35312, 0, 0, 0, 0, 0, 47213), -- Brackenhide Whelp (Area: Creektooth Den - Difficulty: 0) +(@CGUID+124, 186142, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2444.895751953125, 3978.600830078125, 485.489990234375, 0, 120, 0, 0, 35312, 0, 0, 0, 0, 0, 47213), -- Brackenhide Whelp (Area: Creektooth Den - Difficulty: 0) +(@CGUID+125, 186140, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2466.382568359375, 3974.705810546875, 495.27972412109375, 0.619765520095825195, 120, 0, 0, 53747, 6882, 0, 0, 0, 0, 47213), -- Brackenhide Shaman (Area: Creektooth Den - Difficulty: 0) +(@CGUID+126, 186142, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2441.892333984375, 3981.64404296875, 485.085235595703125, 5.333904266357421875, 120, 0, 0, 35312, 0, 0, 0, 0, 0, 47213), -- Brackenhide Whelp (Area: Creektooth Den - Difficulty: 0) +(@CGUID+127, 186140, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2442.69091796875, 3983.612060546875, 485.105712890625, 5.185547828674316406, 120, 0, 0, 53747, 6882, 0, 0, 0, 0, 47213), -- Brackenhide Shaman (Area: Creektooth Den - Difficulty: 0) +(@CGUID+128, 186140, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2445.116455078125, 3981.947998046875, 485.1802978515625, 5.460284233093261718, 120, 0, 0, 53747, 6882, 0, 0, 0, 0, 47213), -- Brackenhide Shaman (Area: Creektooth Den - Difficulty: 0) +(@CGUID+129, 186140, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2464.376708984375, 3994.67529296875, 487.48876953125, 6.134643077850341796, 120, 0, 0, 53747, 6882, 0, 0, 0, 0, 47213), -- Brackenhide Shaman (Area: Creektooth Den - Difficulty: 0) +(@CGUID+130, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2492.366455078125, 4037.65185546875, 496.941925048828125, 5.341378688812255859, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+131, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2490.80908203125, 4035.193603515625, 496.147003173828125, 5.702906131744384765, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+132, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2492.14404296875, 4039.643310546875, 497.665802001953125, 5.120913028717041015, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+133, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2488.807373046875, 4042.623291015625, 498.001739501953125, 5.341378688812255859, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+134, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2481.12158203125, 4043.132080078125, 497.656768798828125, 5.666232109069824218, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+135, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2491.69091796875, 4042.451416015625, 498.632232666015625, 5.341378688812255859, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+136, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2483.34033203125, 4044.212646484375, 498.41656494140625, 5.341378688812255859, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+137, 186142, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2516.538330078125, 3988.31591796875, 494.63494873046875, 1.747197866439819335, 120, 0, 0, 35312, 0, 0, 0, 0, 0, 47213), -- Brackenhide Whelp (Area: Creektooth Den - Difficulty: 0) +(@CGUID+138, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2490.21533203125, 4038.71435546875, 497.057647705078125, 5.341378688812255859, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+139, 186140, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2449.817626953125, 4002.318603515625, 498.34423828125, 6.108733177185058593, 120, 0, 0, 53747, 6882, 0, 0, 0, 0, 47213), -- Brackenhide Shaman (Area: Creektooth Den - Difficulty: 0) +(@CGUID+140, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2493.75, 4036.14404296875, 496.956329345703125, 5.795009613037109375, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+141, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2479.22216796875, 4044.150146484375, 497.626983642578125, 5.341378688812255859, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+142, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2493.8525390625, 4033.48779296875, 496.343536376953125, 5.341378688812255859, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+143, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2493.317626953125, 4051.8671875, 502.152130126953125, 5.341378688812255859, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+144, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2488.053955078125, 4045.12060546875, 498.8399658203125, 5.341378688812255859, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+145, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2479.298583984375, 4045.90966796875, 498.153594970703125, 4.614782333374023437, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+146, 186140, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2407.10595703125, 3994.108642578125, 484.61962890625, 1.21177983283996582, 120, 0, 0, 53747, 6882, 0, 0, 0, 0, 47213), -- Brackenhide Shaman (Area: Creektooth Den - Difficulty: 0) +(@CGUID+147, 186142, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2518.6494140625, 3992.608642578125, 494.63494873046875, 0, 120, 0, 0, 35312, 0, 0, 0, 0, 0, 47213), -- Brackenhide Whelp (Area: Creektooth Den - Difficulty: 0) +(@CGUID+148, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2482.279541015625, 4045.861083984375, 498.896453857421875, 5.341378688812255859, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+149, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2490.803955078125, 4051.0546875, 501.557769775390625, 5.341378688812255859, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+150, 186142, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2516.234375, 3994.362060546875, 494.63494873046875, 5.536291122436523437, 120, 0, 0, 35312, 0, 0, 0, 0, 0, 47213), -- Brackenhide Whelp (Area: Creektooth Den - Difficulty: 0) +(@CGUID+151, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2489.944580078125, 4047.411376953125, 500.0162353515625, 5.341378688812255859, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+152, 186142, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2402.177001953125, 3991.58251953125, 484.668487548828125, 2.562829256057739257, 120, 0, 0, 35312, 0, 0, 0, 0, 0, 47213), -- Brackenhide Whelp (Area: Creektooth Den - Difficulty: 0) +(@CGUID+153, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2495.854248046875, 4053.09033203125, 503.218048095703125, 5.341378688812255859, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+154, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2490.9921875, 4052.93359375, 502.156524658203125, 5.341378688812255859, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+155, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2494.720458984375, 4051.236083984375, 502.490020751953125, 5.341378688812255859, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+156, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2483.197998046875, 4045.440185546875, 498.949615478515625, 5.341378688812255859, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+157, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2489.875, 4044.631103515625, 499.060302734375, 5.341378688812255859, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+158, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2492.92529296875, 4048.994873046875, 501.3414306640625, 5.341378688812255859, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+159, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2492.423583984375, 4046.158935546875, 500.259674072265625, 5.341378688812255859, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+160, 186142, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2400.55029296875, 3999.084228515625, 484.484222412109375, 4.724308013916015625, 120, 0, 0, 35312, 0, 0, 0, 0, 0, 47213), -- Brackenhide Whelp (Area: Creektooth Den - Difficulty: 0) +(@CGUID+161, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2489.984375, 4054.97216796875, 503.626007080078125, 5.341378688812255859, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+162, 186142, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2404.866455078125, 3999.08154296875, 484.617156982421875, 5.158361434936523437, 120, 0, 0, 35312, 0, 0, 0, 0, 0, 47213), -- Brackenhide Whelp (Area: Creektooth Den - Difficulty: 0) +(@CGUID+163, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2494.442626953125, 4055.085205078125, 503.763946533203125, 5.341378688812255859, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+164, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2496.4462890625, 4059.076416015625, 505.156524658203125, 5.341378688812255859, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+165, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2497.060791015625, 4056.2900390625, 504.929718017578125, 5.341378688812255859, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+166, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2493.015625, 4056.9296875, 504.406524658203125, 5.341378688812255859, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+167, 190052, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2575.678955078125, 4078.83935546875, 522.4892578125, 0.031133951619267463, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- [DNT] Decaying Root (Area: Creektooth Den - Difficulty: 0) (Auras: ) +(@CGUID+168, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2465.1337890625, 3896.841064453125, 495.759033203125, 4.986704349517822265, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+169, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2460.09375, 3895.2509765625, 495.908172607421875, 4.684942245483398437, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+170, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2462.845458984375, 3895.47314453125, 495.75634765625, 5.134770393371582031, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+171, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2467.361083984375, 3895.38720703125, 495.9605712890625, 0, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+172, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2461.65625, 3897.7109375, 495.81365966796875, 4.684942245483398437, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+173, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2465.092041015625, 3894.06591796875, 495.751708984375, 4.684942245483398437, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+174, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2463.03466796875, 3892.8916015625, 495.75634765625, 4.684942245483398437, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+175, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2466.989501953125, 3892.2890625, 495.741973876953125, 5.38873291015625, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+176, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2442.859375, 3977.5556640625, 485.44927978515625, 4.302943229675292968, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+177, 186142, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2444.895751953125, 3978.600830078125, 485.489990234375, 0, 120, 0, 0, 35312, 0, 0, 0, 0, 0, 47213), -- Brackenhide Whelp (Area: Creektooth Den - Difficulty: 0) +(@CGUID+178, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2444.6806640625, 3976.75, 485.66510009765625, 4.675941944122314453, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+179, 186142, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2440.279541015625, 3979.850830078125, 485.102447509765625, 5.633120059967041015, 120, 0, 0, 35312, 0, 0, 0, 0, 0, 47213), -- Brackenhide Whelp (Area: Creektooth Den - Difficulty: 0) +(@CGUID+180, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2440.407958984375, 3977.979248046875, 485.251739501953125, 4.30217742919921875, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+181, 186140, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2445.116455078125, 3981.947998046875, 485.26910400390625, 5.460284233093261718, 120, 0, 0, 53747, 6882, 0, 0, 0, 0, 47213), -- Brackenhide Shaman (Area: Creektooth Den - Difficulty: 0) +(@CGUID+182, 186141, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2441.55029296875, 3978.975830078125, 485.23785400390625, 4.194675922393798828, 120, 0, 0, 28249, 0, 0, 0, 0, 0, 47213), -- Errant Rot (Area: Creektooth Den - Difficulty: 0) +(@CGUID+183, 186142, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2441.892333984375, 3981.64404296875, 485.085235595703125, 5.333904266357421875, 120, 0, 0, 35312, 0, 0, 0, 0, 0, 47213), -- Brackenhide Whelp (Area: Creektooth Den - Difficulty: 0) +(@CGUID+184, 186140, 2444, 13646, 13852, '0', 18099, 0, 0, 0, -2442.69091796875, 3983.612060546875, 485.015625, 5.185547828674316406, 120, 0, 0, 53747, 6882, 0, 0, 0, 0, 47213), -- Brackenhide Shaman (Area: Creektooth Den - Difficulty: 0) +(@CGUID+185, 183997, 2444, 13646, 13852, '0', 18109, 0, 0, 0, -2524.65625, 4093.2041015625, 523.15863037109375, 6.132799625396728515, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213); -- Gnoll Mon-Ark (Area: Creektooth Den - Difficulty: 0) (Auras: 368258 - Add Crown, 369274 - Force Equip Gnoll Lance) + +-- Creature Template Addon +DELETE FROM `creature_template_addon` WHERE `entry` IN (185749, 183997); +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(185749, 0, 0, 0, 1, 0, 0, 0, 0, 0, '368258'), -- 185749 (Gnoll Mon-Ark) - Add Crown +(183997, 0, 0, 0, 1, 0, 0, 0, 0, 0, '368258'); -- 183997 (Gnoll Mon-Ark) - Add Crown + +-- Creature/Gob Template +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `faction`=35, `npcflag`=3, `BaseAttackTime`=2000, `unit_flags`=33536, `unit_flags2`=2048 WHERE `entry`=185753; -- Gnoll Mon-Ark +UPDATE `creature_template` SET `gossip_menu_id`=27489, `minlevel`=70, `maxlevel`=70, `faction`=35, `npcflag`=3, `BaseAttackTime`=2000, `unit_flags`=33536, `unit_flags2`=2048 WHERE `entry`=185749; -- Gnoll Mon-Ark +UPDATE `creature_template` SET `gossip_menu_id`=27489 WHERE `entry`=183997; -- Gnoll Mon-Ark +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `faction`=35, `speed_walk`=6, `speed_run`=2.142857074737548828, `BaseAttackTime`=2000, `unit_flags`=33536, `unit_flags2`=2048, `VehicleId`=7734 WHERE `entry`=186063; -- Purified Slime +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `faction`=35, `speed_walk`=4.800000190734863281, `speed_run`=1.714285731315612792, `BaseAttackTime`=2000, `unit_flags`=32768, `VehicleId`=7720 WHERE `entry`=185762; -- Purified Slime +UPDATE `creature_template` SET `minlevel`=68, `maxlevel`=68, `faction`=190, `npcflag`=16777216, `speed_walk`=4.800000190734863281, `speed_run`=1.714285731315612792, `BaseAttackTime`=2000, `unit_flags`=33536, `unit_flags2`=2048 WHERE `entry`=189840; -- Purified Slime +UPDATE `creature_template` SET `minlevel`=67, `maxlevel`=67, `faction`=16, `BaseAttackTime`=1500, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=186141; -- Errant Rot +UPDATE `creature_template` SET `minlevel`=68, `maxlevel`=68, `faction`=16, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=186140; -- Brackenhide Shaman +UPDATE `creature_template` SET `minlevel`=67, `maxlevel`=67, `faction`=16, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=186142; -- Brackenhide Whelp +UPDATE `creature_template` SET `minlevel`=68, `maxlevel`=68, `faction`=16, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=186139; -- Brackenhide Warrior +UPDATE `creature_template` SET `minlevel`=68, `maxlevel`=68, `faction`=190, `BaseAttackTime`=250, `unit_flags`=512, `unit_flags2`=32768, `unit_flags3`=1 WHERE `entry`=186137; -- Decay Totem +UPDATE `creature_template` SET `minlevel`=68, `maxlevel`=68, `faction`=35, `BaseAttackTime`=2000, `unit_flags`=33555200, `unit_flags2`=34818, `unit_flags3`=16777216 WHERE `entry`=190052; -- [DNT] Decaying Root +UPDATE `creature_template` SET `minlevel`=69, `maxlevel`=69, `faction`=16, `BaseAttackTime`=1500, `unit_flags`=32832, `unit_flags2`=2048, `dynamicflags`=4 WHERE `entry`=185751; -- The Chonker +UPDATE `creature_template` SET `minlevel`=69, `maxlevel`=69, `faction`=16, `speed_run`=0.992062866687774658, `BaseAttackTime`=2000, `unit_flags`=67141696, `unit_flags2`=2048, `dynamicflags`=128 WHERE `entry`=185326; -- Root of Decay + +DELETE FROM `gameobject_template` WHERE `entry` IN (376960 /*Meat Storage*/, 375266 /*Rotting Sap*/, 376959 /*Meat Storage*/); +INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `size`, `Data0`, `Data1`, `Data2`, `Data3`, `Data4`, `Data5`, `Data6`, `Data7`, `Data8`, `Data9`, `Data10`, `Data11`, `Data12`, `Data13`, `Data14`, `Data15`, `Data16`, `Data17`, `Data18`, `Data19`, `Data20`, `Data21`, `Data22`, `Data23`, `Data24`, `Data25`, `Data26`, `Data27`, `Data28`, `Data29`, `Data30`, `Data31`, `Data32`, `Data33`, `Data34`, `ContentTuningId`, `VerifiedBuild`) VALUES +(376960, 10, 73954, 'Meat Storage', 'questinteract', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 376854, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 47213), -- Meat Storage +(375266, 3, 72787, 'Rotting Sap', 'questinteract', 'Gathering Goop', '', 1, 57, 0, 1, 0, 0, 0, 0, 0, 65306, 0, 0, 0, 0, 0, 216585, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 109517, 1, 0, 0, 0, 2153, 47213), -- Rotting Sap +(376959, 10, 73954, 'Meat Storage', 'questinteract', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 373215, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 47213); -- Meat Storage + +-- Phasing +DELETE FROM `phase_area` WHERE (`AreaId` IN (13646, 13852) AND `PhaseId` IN (18098, 18097, 18471, 18099, 18109)); +INSERT INTO `phase_area` (`AreaId`, `PhaseId`, `Comment`) VALUES +(13646, 18098, 'Cosmetic - See Gnoll Mon-Ark at the doors of Creektooth Den'), +(13646, 18097, 'Cosmetic - See Gnoll Mon-Ark at Creektooth Den lake'), +(13646, 18471, 'Cosmetic - See Purified Slime Vehicle'), +(13852, 18099, 'Creektooth Den decay Phase'), +(13852, 18109, 'Cosmetic - See Gnoll Mon-Ark at Creektooth Den cave'); + +DELETE FROM `phase_name` WHERE `ID` IN (18098, 18097, 18471, 18099, 18109); +INSERT INTO `phase_name` (`ID`, `Name`) VALUES +(18098, 'Cosmetic - See Gnoll Mon-Ark at the doors of Creektooth Den'), +(18097, 'Cosmetic - See Gnoll Mon-Ark at Creektooth Den lake'), +(18471, 'Cosmetic - See Purified Slime Vehicle'), +(18099, 'Creektooth Den decay Phase'), +(18109, 'Cosmetic - See Gnoll Mon-Ark at Creektooth Den cave'); + +DELETE FROM `conditions` WHERE (`SourceTypeOrReferenceId` = 26 AND `SourceGroup` IN (18098, 18097, 18471, 18099, 18109) AND `SourceEntry` IN (13646, 13852)); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `Comment`) VALUES +(26, 18098, 13646, 0, 0, 47, 0, 65306, 2 | 8 | 64, 0, 1, 'Apply Phase 18098 If Quest 65306 is not in progess | complete | rewarded'), +(26, 18098, 13646, 0, 0, 47, 0, 65279, 2 | 8 | 64, 0, 1, 'Apply Phase 18098 If Quest 65279 is not in progress | complete | rewarded'), +-- Phase 18097 +(26, 18097, 13646, 0, 0, 47, 0, 65302, 2 | 64, 0, 0, 'Apply Phase 18097 If Quest 65302 is complete | rewarded'), +-- Phase 18471 +(26, 18471, 13646, 0, 0, 47, 0, 65594, 8, 0, 0, 'Apply Phase 18471 If Quest 65594 is in progress'), +-- Phase 18099 +(26, 18099, 13852, 0, 0, 47, 0, 65594, 2 | 8, 0, 0, 'Apply Phase 18099 If Quest 65594 is in progress | complete'), +-- Phase 18109 +(26, 18109, 13852, 0, 0, 47, 0, 65594, 2 | 64, 0, 0, 'Apply Phase 18109 If Quest 65594 is complete | rewarded'), +(26, 18109, 13852, 0, 0, 47, 0, 65595, 2 | 8, 0, 1, 'Apply Phase 18109 If Quest 65595 is not in progress | rewarded'); + +-- Gossip +DELETE FROM `npc_text` WHERE `ID` BETWEEN @NPCTEXTID+0 AND @NPCTEXTID+2; +INSERT INTO `npc_text` (`ID`, `Probability0`, `Probability1`, `Probability2`, `Probability3`, `Probability4`, `Probability5`, `Probability6`, `Probability7`, `BroadcastTextId0`, `BroadcastTextId1`, `BroadcastTextId2`, `BroadcastTextId3`, `BroadcastTextId4`, `BroadcastTextId5`, `BroadcastTextId6`, `BroadcastTextId7`, `VerifiedBuild`) VALUES +(@NPCTEXTID+0, 1, 0, 0, 0, 0, 0, 0, 0, 214467, 0, 0, 0, 0, 0, 0, 0, 47213), -- 183997 (Gnoll Mon-Ark) +(@NPCTEXTID+1, 1, 0, 0, 0, 0, 0, 0, 0, 218564, 0, 0, 0, 0, 0, 0, 0, 47213), -- 189979 (Friendly Gnoll) +(@NPCTEXTID+2, 1, 1, 1, 0, 0, 0, 0, 0, 214466, 214463, 214465, 0, 0, 0, 0, 0, 47213); -- 183997 (Gnoll Mon-Ark) + +DELETE FROM `gossip_menu` WHERE (`MenuID`=27667 AND `TextID`=@NPCTEXTID+0) OR (`MenuID`=28073 AND `TextID`=@NPCTEXTID+1) OR (`MenuID`=27489 AND `TextID`=@NPCTEXTID+2); +INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES +(27667, @NPCTEXTID+0, 47213), -- 183997 (Gnoll Mon-Ark) +(28073, @NPCTEXTID+1, 47213), -- 189979 (Friendly Gnoll) +(27489, @NPCTEXTID+2, 47213); -- 183997 (Gnoll Mon-Ark) + +DELETE FROM `gossip_menu_option` WHERE (`OptionID`=0 AND `MenuID` IN (28073,27667)) OR (`OptionID`=1 AND `MenuID`=27489); +INSERT INTO `gossip_menu_option` (`GossipOptionID`, `MenuID`, `OptionID`, `OptionNpc`, `OptionText`, `OptionBroadcastTextId`, `Language`, `ActionMenuID`, `ActionPoiID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `SpellID`, `Flags`, `OverrideIconID`, `GossipNpcOptionID`, `VerifiedBuild`) VALUES +(55422, 28073, 0, 0, 'If I open this cage, will you try to eat me?', 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 47213), +(54672, 27667, 0, 0, '<Accept their sovereign authority.>', 0, 0, 27489, 0, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 47213), +(54626, 27489, 1, 0, '<Ask Mon-Ark if they are a king or a queen>', 0, 0, 27667, 0, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 47213); + +-- Queststuff +DELETE FROM `creature_queststarter` WHERE (`id`=183997 AND `quest` IN (65594,65306,65595,65279)) OR (`id`=185749 AND `quest` IN (65279,65302,65306)); +INSERT INTO `creature_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES +(183997, 65594, 47213), -- Making a Mountain Out of a Gnoll Hill offered Gnoll Mon-Ark +(185749, 65279, 47213), -- By Royal Decree offered Gnoll Mon-Ark +(183997, 65306, 47213), -- Rot Rancher offered Gnoll Mon-Ark +(183997, 65595, 47213), -- One Bad Apple offered Gnoll Mon-Ark +(185749, 65302, 47213), -- Keys to the Kingdom offered Gnoll Mon-Ark +(185749, 65306, 47213), -- Rot Rancher offered Gnoll Mon-Ark +(183997, 65279, 47213); -- By Royal Decree offered Gnoll Mon-Ark + +DELETE FROM `creature_questender` WHERE (`id`=185749 AND `quest` IN (65595,65279,65306)) OR (`id`=183997 AND `quest` IN (65594,65302)); +INSERT INTO `creature_questender` (`id`, `quest`, `VerifiedBuild`) VALUES +(185749, 65595, 47213), -- One Bad Apple ended by Gnoll Mon-Ark +(183997, 65594, 47213), -- Making a Mountain Out of a Gnoll Hill ended by Gnoll Mon-Ark +(183997, 65302, 47213), -- Keys to the Kingdom ended by Gnoll Mon-Ark +(185749, 65279, 47213), -- By Royal Decree ended by Gnoll Mon-Ark +(185749, 65306, 47213); -- Rot Rancher ended by Gnoll Mon-Ark + +DELETE FROM `quest_details` WHERE `ID` IN (65594 /*Making a Mountain Out of a Gnoll Hill*/, 65279 /*By Royal Decree*/, 65306 /*Rot Rancher*/, 65595 /*One Bad Apple*/, 65302 /*Keys to the Kingdom*/); +INSERT INTO `quest_details` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `VerifiedBuild`) VALUES +(65594, 669, 0, 0, 0, 0, 0, 0, 0, 47213), -- Making a Mountain Out of a Gnoll Hill +(65279, 669, 0, 0, 0, 0, 0, 0, 0, 47213), -- By Royal Decree +(65306, 669, 0, 0, 0, 0, 0, 0, 0, 47213), -- Rot Rancher +(65595, 669, 0, 0, 0, 0, 0, 0, 0, 47213), -- One Bad Apple +(65302, 669, 0, 0, 0, 0, 0, 0, 0, 47213); -- Keys to the Kingdom + +DELETE FROM `quest_request_items` WHERE `ID` IN (65279 /*By Royal Decree*/, 65306 /*Rot Rancher*/); +INSERT INTO `quest_request_items` (`ID`, `EmoteOnComplete`, `EmoteOnIncomplete`, `EmoteOnCompleteDelay`, `EmoteOnIncompleteDelay`, `CompletionText`, `VerifiedBuild`) VALUES +(65279, 0, 53, 0, 0, 'GET WITH KILLING!', 47213), -- By Royal Decree +(65306, 53, 53, 0, 0, 'NEED MORE OOZE!', 47213); -- Rot Rancher + +DELETE FROM `quest_offer_reward` WHERE `ID` IN (65595 /*One Bad Apple*/, 65594 /*Making a Mountain Out of a Gnoll Hill*/, 65302 /*Keys to the Kingdom*/, 65279 /*By Royal Decree*/, 65306 /*Rot Rancher*/); +INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES +(65595, 669, 0, 0, 0, 0, 0, 0, 0, 'Me lead gnolls to better hunt now. You... not so bad. Gnolls hungry though, and you still meat.\n\nLeave. Me no chase.', 47213), -- One Bad Apple +(65594, 669, 0, 0, 0, 0, 0, 0, 0, 'You live this long? Good meat.', 47213), -- Making a Mountain Out of a Gnoll Hill +(65302, 669, 0, 0, 0, 0, 0, 0, 0, 'Always wanted power stick!\n\nMON-ARK PROVIDES!', 47213), -- Keys to the Kingdom +(65279, 669, 153, 0, 0, 0, 300, 0, 0, 'Good start... but have bigger plans.', 47213), -- By Royal Decree +(65306, 669, 0, 0, 0, 0, 0, 0, 0, 'Squishy toe junk. Very nice.', 47213); -- Rot Rancher + +DELETE FROM `gameobject_questitem` WHERE (`GameObjectEntry`=375266 AND `Idx`=0); +INSERT INTO `gameobject_questitem` (`GameObjectEntry`, `Idx`, `ItemId`, `VerifiedBuild`) VALUES +(375266, 0, 189183, 47213); -- Rotting Sap + +DELETE FROM `quest_template_addon` WHERE `ID` IN (65279, 65306, 65594, 65595); +INSERT INTO `quest_template_addon` (`ID`, `MaxLevel`, `AllowableClasses`, `SourceSpellID`, `PrevQuestID`, `NextQuestID`, `ExclusiveGroup`, `BreadcrumbForQuestId`, `RewardMailTemplateID`, `RewardMailDelay`, `RequiredSkillID`, `RequiredSkillPoints`, `RequiredMinRepFaction`, `RequiredMaxRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepValue`, `ProvidedItemCount`, `SpecialFlags`, `ScriptName`) VALUES +(65279, 0, 0, 0, 0, 65302, -65279, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, ''), +(65306, 0, 0, 0, 0, 65302, -65279, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, ''), +(65594, 0, 0, 0, 65302, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, ''), +(65595, 0, 0, 0, 65594, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, ''); + +-- Creature Equipment +DELETE FROM `creature_equip_template` WHERE (`ID`=1 AND `CreatureID` IN (185753,186140,186139,186054,186053)); +INSERT INTO `creature_equip_template` (`CreatureID`, `ID`, `ItemID1`, `AppearanceModID1`, `ItemVisual1`, `ItemID2`, `AppearanceModID2`, `ItemVisual2`, `ItemID3`, `AppearanceModID3`, `ItemVisual3`, `VerifiedBuild`) VALUES +(185753, 1, 191068, 0, 0, 0, 0, 0, 0, 0, 0, 47213), -- Gnoll Mon-Ark +(186140, 1, 4938, 0, 0, 0, 0, 0, 0, 0, 0, 47213), -- Brackenhide Shaman +(186139, 1, 189549, 0, 0, 0, 0, 0, 0, 0, 0, 47213), -- Brackenhide Warrior +(186054, 1, 4938, 0, 0, 0, 0, 0, 0, 0, 0, 47213), -- Ambushing Shaman +(186053, 1, 189555, 0, 0, 0, 0, 0, 0, 0, 0, 47213); -- Ambushing Warrior + +-- GameObject Loot +DELETE FROM `gameobject_loot_template` WHERE (`Entry` = 109441 AND `Item` = 188959) OR (`Entry` = 109442 AND `Item` = 189126); +INSERT INTO `gameobject_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(109441, 188959, 0, 100, 1, 1, 0, 1, 1, 'Sticky Gnoll Key for Quest: 65302'), +(109442, 189126, 0, 100, 1, 1, 0, 1, 1, 'Gnoll "Lances" for Quest: 65302'); + +-- Scaling Data +DELETE FROM `creature_template_scaling` WHERE (`DifficultyID`=0 AND `Entry` IN (19668,185326,189979,189981,189953,185751,186063,185753,186137,185762,186141,186140,186142,186139,189840,186054,186053,185749)); +INSERT INTO `creature_template_scaling` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `VerifiedBuild`) VALUES +(19668, 0, 0, 0, 482, 47213), +(185326, 0, 1, 1, 2319, 47213), +(189979, 0, 0, 0, 2319, 47213), +(189981, 0, 0, 0, 2319, 47213), +(189953, 0, 0, 0, 2319, 47213), +(185751, 0, 1, 1, 2153, 47213), +(186063, 0, 0, 0, 2319, 47213), +(185753, 0, 0, 0, 2319, 47213), +(186137, 0, 0, 0, 2153, 47213), +(185762, 0, 0, 0, 2153, 47213), +(186141, 0, -1, -1, 2153, 47213), +(186140, 0, 0, 0, 2319, 47213), +(186142, 0, -1, -1, 2319, 47213), +(186139, 0, 0, 0, 2319, 47213), +(189840, 0, 0, 0, 2153, 47213), +(186054, 0, 0, 0, 2319, 47213), +(186053, 0, 0, 0, 2319, 47213), +(185749, 0, 0, 0, 2319, 47213); |