diff options
| -rw-r--r-- | sql/updates/world/master/2022_12_05_02_world.sql | 188 |
1 files changed, 188 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_12_05_02_world.sql b/sql/updates/world/master/2022_12_05_02_world.sql new file mode 100644 index 00000000000..9464e53980a --- /dev/null +++ b/sql/updates/world/master/2022_12_05_02_world.sql @@ -0,0 +1,188 @@ +SET @CGUID := 396431; +SET @OGUID := 248302; +SET @EVENT := 26; + +-- Creature templates +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=34644; -- Edward Winslow +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=34645; -- Elizabeth Barker Winslow +UPDATE `creature_template` SET `gossip_menu_id`=10569, `minlevel`=60, `maxlevel`=60 WHERE `entry`=34708; -- Caitrin Ironkettle +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `unit_flags`=2147746560 WHERE `entry`=35340; -- Bountiful Barrel + +-- Scaling +DELETE FROM `creature_template_scaling` WHERE `DifficultyID`=0 AND `Entry` IN (34644, 34645, 34708, 35340); +INSERT INTO `creature_template_scaling` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `VerifiedBuild`) VALUES +(34644, 0, 0, 0, 389, 46741), +(34645, 0, 0, 0, 389, 46741), +(34708, 0, 0, 0, 389, 46741), +(35340, 0, 0, 0, 389, 46741); + +-- Trainer +DELETE FROM `creature_trainer` WHERE `CreatureID`=34708; +INSERT INTO `creature_trainer` (`CreatureID`, `TrainerID`, `MenuID`, `OptionID`) VALUES +(34708, 136, 10569, 0); + +-- Quests +UPDATE `quest_poi_points` SET `VerifiedBuild`=46741 WHERE (`QuestID`=14051 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=14051 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=14048 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=14048 AND `Idx1`=0 AND `Idx2`=0); + +UPDATE `quest_details` SET `VerifiedBuild`=46741 WHERE `ID` IN (14051, 14048); + +UPDATE `quest_request_items` SET `EmoteOnIncomplete`=1 WHERE `ID` IN (14051, 14048); + +UPDATE `creature_queststarter` SET `VerifiedBuild`=46741 WHERE (`id`=34708 AND `quest` IN (14051,14048)); + +UPDATE `creature_questender` SET `VerifiedBuild`=46741 WHERE (`id`=34708 AND `quest` IN (14051,14048)); + +-- Creature spawns +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+9; +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, 32823, 0, 1, 809, '0', 0, 0, 0, 0, -5072.61962890625, -797.685791015625, 495.21044921875, 1.047197580337524414, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: Gates of Ironforge - Difficulty: 0) (Auras: ) +(@CGUID+1, 32823, 0, 1, 809, '0', 0, 0, 0, 0, -5093.845703125, -796.42706298828125, 495.21044921875, 0.05235987901687622, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: Gates of Ironforge - Difficulty: 0) (Auras: ) +(@CGUID+2, 32823, 0, 1, 809, '0', 0, 0, 0, 0, -5083.28466796875, -797.29168701171875, 495.297149658203125, 1.762782573699951171, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: Gates of Ironforge - Difficulty: 0) +(@CGUID+3, 34644, 0, 1, 809, '0', 0, 0, 0, 1, -5062.74462890625, -791.94097900390625, 495.79791259765625, 0.01745329238474369, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Edward Winslow (Area: Gates of Ironforge - Difficulty: 0) +(@CGUID+4, 34645, 0, 1, 809, '0', 0, 0, 0, 0, -5062.7587890625, -789.94097900390625, 495.784149169921875, 0.209439516067504882, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Elizabeth Barker Winslow (Area: Gates of Ironforge - Difficulty: 0) +(@CGUID+5, 34653, 0, 1, 809, '0', 0, 0, 0, 0, -5075.27978515625, -789.80206298828125, 495.37744140625, 6.0737457275390625, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table Hostess (Area: Gates of Ironforge - Difficulty: 0) +(@CGUID+6, 34708, 0, 1, 809, '0', 0, 0, 0, 1, -5061.73095703125, -803.34552001953125, 495.81610107421875, 1.413716673851013183, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Caitrin Ironkettle (Area: Gates of Ironforge - Difficulty: 0) (Auras: ) +(@CGUID+7, 35340, 0, 1, 809, '0', 0, 0, 0, 0, -5065.533203125, -789.8524169921875, 495.123382568359375, 3.019419670104980468, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Barrel (Area: Gates of Ironforge - Difficulty: 0) (Auras: ) +(@CGUID+8, 35340, 0, 1, 809, '0', 0, 0, 0, 0, -5062.578125, -788.59722900390625, 495.062896728515625, 2.0245819091796875, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Barrel (Area: Gates of Ironforge - Difficulty: 0) +(@CGUID+9, 35340, 0, 1, 809, '0', 0, 0, 0, 0, -5064.38037109375, -788.28125, 495.032012939453125, 3.892084121704101562, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741); -- Bountiful Barrel (Area: Gates of Ironforge - Difficulty: 0) + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+59; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES +(@OGUID+0, 179968, 0, 1, 809, '0', 0, 0, -5064.15283203125, -791.8663330078125, 495.115875244140625, 3.036838293075561523, 0, 0, 0.998628616333007812, 0.052353221923112869, 120, 255, 1, 46741), -- Haystack 01 (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+1, 179968, 0, 1, 809, '0', 0, 0, -5064.564453125, -796.0555419921875, 495.127105712890625, 3.106652259826660156, 0, 0, 0.999847412109375, 0.017469281330704689, 120, 255, 1, 46741), -- Haystack 01 (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+2, 179968, 0, 1, 809, '0', 0, 0, -5064.1337890625, -789.92364501953125, 495.076507568359375, 3.106652259826660156, 0, 0, 0.999847412109375, 0.017469281330704689, 120, 255, 1, 46741), -- Haystack 01 (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+3, 179968, 0, 1, 809, '0', 0, 0, -5079.015625, -801.65972900390625, 495.127105712890625, 1.48352813720703125, 0, 0, 0.675589561462402343, 0.737277925014495849, 120, 255, 1, 46741), -- Haystack 01 (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+4, 179968, 0, 1, 809, '0', 0, 0, -5064.58349609375, -797.998291015625, 495.127105712890625, 3.036838293075561523, 0, 0, 0.998628616333007812, 0.052353221923112869, 120, 255, 1, 46741), -- Haystack 01 (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+5, 179968, 0, 1, 809, '0', 0, 0, -5087.4375, -789.0225830078125, 495.572265625, 4.607671737670898437, 0, 0, -0.74314403533935546, 0.669131457805633544, 120, 255, 1, 46741), -- Haystack 01 (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+6, 179968, 0, 1, 809, '0', 0, 0, -5062.921875, -803.07464599609375, 495.127105712890625, 3.036838293075561523, 0, 0, 0.998628616333007812, 0.052353221923112869, 120, 255, 1, 46741), -- Haystack 01 (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+7, 179968, 0, 1, 809, '0', 0, 0, -5089.99462890625, -788.8194580078125, 495.42584228515625, 4.555310726165771484, 0, 0, -0.76040554046630859, 0.649448513984680175, 120, 255, 1, 46741), -- Haystack 01 (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+8, 179968, 0, 1, 809, '0', 0, 0, -5060.626953125, -803.404541015625, 495.127105712890625, 3.036838293075561523, 0, 0, 0.998628616333007812, 0.052353221923112869, 120, 255, 1, 46741), -- Haystack 01 (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+9, 179968, 0, 1, 809, '0', 0, 0, -5078.66162109375, -789.6475830078125, 495.649322509765625, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 46741), -- Haystack 01 (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+10, 179968, 0, 1, 809, '0', 0, 0, -5063.41845703125, -791.953125, 495.124237060546875, 3.036838293075561523, 0, 0, 0.998628616333007812, 0.052353221923112869, 120, 255, 1, 46741), -- Haystack 01 (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+11, 179968, 0, 1, 809, '0', 0, 0, -5062.67724609375, -789.97222900390625, 495.076507568359375, 3.106652259826660156, 0, 0, 0.999847412109375, 0.017469281330704689, 120, 255, 1, 46741), -- Haystack 01 (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+12, 179968, 0, 1, 809, '0', 0, 0, -5076.79150390625, -789.859375, 495.47222900390625, 4.660029888153076171, 0, 0, -0.72537422180175781, 0.688354730606079101, 120, 255, 1, 46741), -- Haystack 01 (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+13, 179968, 0, 1, 809, '0', 0, 0, -5062.673828125, -792.04168701171875, 495.1236572265625, 3.036838293075561523, 0, 0, 0.998628616333007812, 0.052353221923112869, 120, 255, 1, 46741), -- Haystack 01 (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+14, 179968, 0, 1, 809, '0', 0, 0, -5063.41162109375, -789.94964599609375, 495.0826416015625, 3.106652259826660156, 0, 0, 0.999847412109375, 0.017469281330704689, 120, 255, 1, 46741), -- Haystack 01 (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+15, 179968, 0, 1, 809, '0', 0, 0, -5062.126953125, -803.18927001953125, 495.127105712890625, 3.036838293075561523, 0, 0, 0.998628616333007812, 0.052353221923112869, 120, 255, 1, 46741), -- Haystack 01 (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+16, 179968, 0, 1, 809, '0', 0, 0, -5077.21875, -801.61456298828125, 495.127105712890625, 1.48352813720703125, 0, 0, 0.675589561462402343, 0.737277925014495849, 120, 255, 1, 46741), -- Haystack 01 (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+17, 179968, 0, 1, 809, '0', 0, 0, -5061.3837890625, -803.28302001953125, 495.127105712890625, 3.036838293075561523, 0, 0, 0.998628616333007812, 0.052353221923112869, 120, 255, 1, 46741), -- Haystack 01 (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+18, 179968, 0, 1, 809, '0', 0, 0, -5089.546875, -801.55731201171875, 495.127105712890625, 4.660029888153076171, 0, 0, -0.72537422180175781, 0.688354730606079101, 120, 255, 1, 46741), -- Haystack 01 (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+19, 179968, 0, 1, 809, '0', 0, 0, -5087.671875, -801.560791015625, 495.127105712890625, 1.553341388702392578, 0, 0, 0.700908660888671875, 0.713251054286956787, 120, 255, 1, 46741), -- Haystack 01 (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+20, 179968, 0, 1, 809, '0', 0, 0, -5100.3056640625, -794.28302001953125, 495.31597900390625, 5.986480236053466796, 0, 0, -0.14780902862548828, 0.989015936851501464, 120, 255, 1, 46741), -- Haystack 01 (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+21, 179968, 0, 1, 809, '0', 0, 0, -5100.84716796875, -796.0086669921875, 495.348968505859375, 6.003933906555175781, 0, 0, -0.13917255401611328, 0.990268170833587646, 120, 255, 1, 46741), -- Haystack 01 (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+22, 180353, 0, 1, 809, '0', 0, 0, -5059.5, -806.65972900390625, 495.127349853515625, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+23, 180353, 0, 1, 809, '0', 0, 0, -5078.08837890625, -801.765625, 495.127105712890625, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+24, 180353, 0, 1, 809, '0', 0, 0, -5064.6005859375, -806.17706298828125, 495.395233154296875, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+25, 180353, 0, 1, 809, '0', 0, 0, -5088.4755859375, -788.82989501953125, 495.5167236328125, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+26, 180353, 0, 1, 809, '0', 0, 0, -5077.658203125, -789.80902099609375, 495.555572509765625, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+27, 180353, 0, 1, 809, '0', 0, 0, -5064.455078125, -796.98614501953125, 495.127105712890625, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+28, 180353, 0, 1, 809, '0', 0, 0, -5064.0244140625, -790.85418701171875, 495.108062744140625, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+29, 180353, 0, 1, 809, '0', 0, 0, -5100.564453125, -795.11285400390625, 495.40386962890625, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+30, 180353, 0, 1, 809, '0', 0, 0, -5088.6875, -801.7117919921875, 495.127105712890625, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+31, 195164, 0, 1, 809, '0', 0, 0, -5064.220703125, -791.795166015625, 495.8145751953125, 3.054326534271240234, 0, 0, 0.999048233032226562, 0.043619260191917419, 120, 255, 1, 46741), -- Pumpkin (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+32, 195164, 0, 1, 809, '0', 0, 0, -5079.0712890625, -801.58856201171875, 495.792877197265625, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+33, 195164, 0, 1, 809, '0', 0, 0, -5060.69287109375, -805.232666015625, 496.026641845703125, 4.014260292053222656, 0, 0, -0.90630722045898437, 0.422619491815567016, 120, 255, 1, 46741), -- Pumpkin (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+34, 195164, 0, 1, 809, '0', 0, 0, -5064.65087890625, -797.92706298828125, 495.792877197265625, 3.054326534271240234, 0, 0, 0.999048233032226562, 0.043619260191917419, 120, 255, 1, 46741), -- Pumpkin (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+35, 195164, 0, 1, 809, '0', 0, 0, -5087.45654296875, -789.06768798828125, 496.23577880859375, 4.625123500823974609, 0, 0, -0.73727703094482421, 0.67559051513671875, 120, 255, 1, 46741), -- Pumpkin (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+36, 195164, 0, 1, 809, '0', 0, 0, -5064.08154296875, -789.87847900390625, 495.755157470703125, 3.124123096466064453, 0, 0, 0.99996185302734375, 0.008734640665352344, 120, 255, 1, 46741), -- Pumpkin (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+37, 195164, 0, 1, 809, '0', 0, 0, -5076.9287109375, -789.87152099609375, 496.151031494140625, 4.694936752319335937, 0, 0, -0.71325016021728515, 0.700909554958343505, 120, 255, 1, 46741), -- Pumpkin (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+38, 195164, 0, 1, 809, '0', 0, 0, -5064.51220703125, -796.01043701171875, 495.792877197265625, 3.124123096466064453, 0, 0, 0.99996185302734375, 0.008734640665352344, 120, 255, 1, 46741), -- Pumpkin (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+39, 195164, 0, 1, 809, '0', 0, 0, -5078.70166015625, -789.7430419921875, 496.316802978515625, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+40, 195164, 0, 1, 809, '0', 0, 0, -5089.8974609375, -788.86456298828125, 496.097320556640625, 4.520402908325195312, 0, 0, -0.77162456512451171, 0.636078238487243652, 120, 255, 1, 46741), -- Pumpkin (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+41, 195164, 0, 1, 809, '0', 0, 0, -5077.35595703125, -801.7586669921875, 495.792877197265625, 1.396261811256408691, 0, 0, 0.642786979675292968, 0.766044974327087402, 120, 255, 1, 46741), -- Pumpkin (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+42, 195164, 0, 1, 809, '0', 0, 0, -5100.20849609375, -794.328125, 495.9366455078125, 5.986480236053466796, 0, 0, -0.14780902862548828, 0.989015936851501464, 120, 255, 1, 46741), -- Pumpkin (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+43, 195164, 0, 1, 809, '0', 0, 0, -5089.63720703125, -801.5850830078125, 495.792877197265625, 4.677483558654785156, 0, 0, -0.71933937072753906, 0.694658815860748291, 120, 255, 1, 46741), -- Pumpkin (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+44, 195164, 0, 1, 809, '0', 0, 0, -5100.75, -796.0538330078125, 495.968048095703125, 6.003933906555175781, 0, 0, -0.13917255401611328, 0.990268170833587646, 120, 255, 1, 46741), -- Pumpkin (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+45, 195164, 0, 1, 809, '0', 0, 0, -5087.533203125, -801.44097900390625, 495.792877197265625, 1.623155713081359863, 0, 0, 0.725374221801757812, 0.688354730606079101, 120, 255, 1, 46741), -- Pumpkin (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+46, 195191, 0, 1, 809, '0', 0, 0, -5062.0869140625, -805.50518798828125, 495.13134765625, 1.518436193466186523, 0, 0, 0.6883544921875, 0.725374460220336914, 120, 255, 1, 46741), -- Dwarven Table Simple 05 (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+47, 195192, 0, 1, 809, '0', 0, 0, -5063.34033203125, -804.935791015625, 496.03607177734375, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 46741), -- Basket of Corn (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+48, 195194, 0, 1, 809, '0', 0, 0, -5063.56103515625, -805.90106201171875, 496.00592041015625, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 46741), -- Small Basket 01 (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+49, 195195, 0, 1, 809, '0', 0, 0, -5060.9912109375, -806.17706298828125, 495.885955810546875, 2.862335443496704101, 0, 0, 0.990267753601074218, 0.139175355434417724, 120, 255, 1, 46741), -- Cranberry Masher (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+50, 195196, 0, 1, 809, '0', 0, 0, -5059.03125, -805.3038330078125, 495.127166748046875, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 46741), -- Large Basket 03 (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+51, 195197, 0, 1, 809, '0', 0, 0, -5061.283203125, -807.59722900390625, 495.12744140625, 5.096362113952636718, 0, 0, -0.55919265747070312, 0.829037725925445556, 120, 255, 1, 46741), -- Grain Sack 02 (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+52, 195198, 0, 1, 809, '0', 0, 0, -5063.8818359375, -807.35418701171875, 495.31494140625, 1.012289404869079589, 0, 0, 0.484808921813964843, 0.87462007999420166, 120, 255, 1, 46741), -- Crate 01 (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+53, 195199, 0, 1, 809, '0', 0, 0, -5062.5380859375, -808.54864501953125, 495.128143310546875, 1.012289404869079589, 0, 0, 0.484808921813964843, 0.87462007999420166, 120, 255, 1, 46741), -- Cranberry Bush (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+54, 195199, 0, 1, 809, '0', 0, 0, -5065.55712890625, -807.85589599609375, 495.19097900390625, 6.09120035171508789, 0, 0, -0.09584522247314453, 0.995396256446838378, 120, 255, 1, 46741), -- Cranberry Bush (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+55, 195199, 0, 1, 809, '0', 0, 0, -5064.07275390625, -808.83331298828125, 495.128204345703125, 6.09120035171508789, 0, 0, -0.09584522247314453, 0.995396256446838378, 120, 255, 1, 46741), -- Cranberry Bush (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+56, 195200, 0, 1, 809, '0', 0, 0, -5066.08837890625, -804.046875, 495.11627197265625, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pilgrim's Bounty Cooking Fire (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+57, 195664, 0, 1, 809, '0', 0, 0, -5072.6494140625, -797.68927001953125, 495.127105712890625, 1.047197580337524414, 0, 0, 0.5, 0.866025388240814208, 120, 255, 1, 46741), -- [DND] Collision Thanksgiving Table Size (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+58, 195664, 0, 1, 809, '0', 0, 0, -5083.3193359375, -797.29168701171875, 495.2149658203125, 1.762782454490661621, 0, 0, 0.771624565124511718, 0.636078238487243652, 120, 255, 1, 46741), -- [DND] Collision Thanksgiving Table Size (Area: Gates of Ironforge - Difficulty: 0) +(@OGUID+59, 195664, 0, 1, 809, '0', 0, 0, -5093.87841796875, -796.42364501953125, 495.127105712890625, 0.052358884364366531, 0, 0, 0.02617645263671875, 0.999657332897186279, 120, 255, 1, 46741); -- [DND] Collision Thanksgiving Table Size (Area: Gates of Ironforge - Difficulty: 0) + +-- Event spawns +DELETE FROM `game_event_creature` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @CGUID+0 AND @CGUID+9; +INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES +(@EVENT, @CGUID+0), +(@EVENT, @CGUID+1), +(@EVENT, @CGUID+2), +(@EVENT, @CGUID+3), +(@EVENT, @CGUID+4), +(@EVENT, @CGUID+5), +(@EVENT, @CGUID+6), +(@EVENT, @CGUID+7), +(@EVENT, @CGUID+8), +(@EVENT, @CGUID+9); + +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @OGUID+0 AND @OGUID+59; +INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES +(@EVENT, @OGUID+0), +(@EVENT, @OGUID+1), +(@EVENT, @OGUID+2), +(@EVENT, @OGUID+3), +(@EVENT, @OGUID+4), +(@EVENT, @OGUID+5), +(@EVENT, @OGUID+6), +(@EVENT, @OGUID+7), +(@EVENT, @OGUID+8), +(@EVENT, @OGUID+9), +(@EVENT, @OGUID+10), +(@EVENT, @OGUID+11), +(@EVENT, @OGUID+12), +(@EVENT, @OGUID+13), +(@EVENT, @OGUID+14), +(@EVENT, @OGUID+15), +(@EVENT, @OGUID+16), +(@EVENT, @OGUID+17), +(@EVENT, @OGUID+18), +(@EVENT, @OGUID+19), +(@EVENT, @OGUID+20), +(@EVENT, @OGUID+21), +(@EVENT, @OGUID+22), +(@EVENT, @OGUID+23), +(@EVENT, @OGUID+24), +(@EVENT, @OGUID+25), +(@EVENT, @OGUID+26), +(@EVENT, @OGUID+27), +(@EVENT, @OGUID+28), +(@EVENT, @OGUID+29), +(@EVENT, @OGUID+30), +(@EVENT, @OGUID+31), +(@EVENT, @OGUID+32), +(@EVENT, @OGUID+33), +(@EVENT, @OGUID+34), +(@EVENT, @OGUID+35), +(@EVENT, @OGUID+36), +(@EVENT, @OGUID+37), +(@EVENT, @OGUID+38), +(@EVENT, @OGUID+39), +(@EVENT, @OGUID+40), +(@EVENT, @OGUID+41), +(@EVENT, @OGUID+42), +(@EVENT, @OGUID+43), +(@EVENT, @OGUID+44), +(@EVENT, @OGUID+45), +(@EVENT, @OGUID+46), +(@EVENT, @OGUID+47), +(@EVENT, @OGUID+48), +(@EVENT, @OGUID+49), +(@EVENT, @OGUID+50), +(@EVENT, @OGUID+51), +(@EVENT, @OGUID+52), +(@EVENT, @OGUID+53), +(@EVENT, @OGUID+54), +(@EVENT, @OGUID+55), +(@EVENT, @OGUID+56), +(@EVENT, @OGUID+57), +(@EVENT, @OGUID+58), +(@EVENT, @OGUID+59); |