diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2022_12_05_04_world.sql | 190 |
1 files changed, 190 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_12_05_04_world.sql b/sql/updates/world/master/2022_12_05_04_world.sql new file mode 100644 index 00000000000..9e88e36e700 --- /dev/null +++ b/sql/updates/world/master/2022_12_05_04_world.sql @@ -0,0 +1,190 @@ +SET @CGUID := 396445; +SET @OGUID := 248410; +SET @EVENT := 26; + +-- Creature templates +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=34676; -- Isaac Allerton +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=34681; -- Ikaneba Summerset +UPDATE `creature_template` SET `gossip_menu_id`=10569, `minlevel`=60, `maxlevel`=60 WHERE `entry`=34711; -- Mary Allerton +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `unit_flags`=2147746560 WHERE `entry`=35338; -- Bountiful Barrel + +-- Scaling +DELETE FROM `creature_template_scaling` WHERE `DifficultyID`=0 AND `Entry` IN (34676, 34681, 34711, 35338); +INSERT INTO `creature_template_scaling` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `VerifiedBuild`) VALUES +(34676, 0, 0, 0, 389, 46741), +(34681, 0, 0, 0, 389, 46741), +(34711, 0, 0, 0, 389, 46741), +(35338, 0, 0, 0, 389, 46741); + +-- Trainer +DELETE FROM `creature_trainer` WHERE `CreatureID`=34711; +INSERT INTO `creature_trainer` (`CreatureID`, `TrainerID`, `MenuID`, `OptionID`) VALUES +(34711, 136, 10569, 0); + +-- Quests +UPDATE `quest_poi` SET `VerifiedBuild`=46741 WHERE (`QuestID`=14054 AND `BlobIndex`=1 AND `Idx1`=2) OR (`QuestID`=14054 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=14054 AND `BlobIndex`=0 AND `Idx1`=0); + +DELETE FROM `quest_details` WHERE `ID`=14054; +INSERT INTO `quest_details` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `VerifiedBuild`) VALUES +(14054, 1, 1, 0, 0, 0, 0, 0, 0, 46741); -- Easy As Pie + +UPDATE `quest_request_items` SET `EmoteOnIncomplete`=1 WHERE `ID`=14054; + +UPDATE `creature_queststarter` SET `VerifiedBuild`=46741 WHERE (`id`=34711 AND `quest`=14054); + +UPDATE `creature_questender` SET `VerifiedBuild`=46741 WHERE (`id`=34711 AND `quest`=14054); + +-- Creature spawns +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+10; +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, 1, 1657, 1657, '0', 0, 0, 0, 0, 9969.5810546875, 2219.484375, 1329.6641845703125, 1.274090290069580078, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: Darnassus - Difficulty: 0) +(@CGUID+1, 32823, 1, 1657, 1657, '0', 0, 0, 0, 0, 9967.9287109375, 2202.5400390625, 1328.907470703125, 0, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: Darnassus - Difficulty: 0) +(@CGUID+2, 32823, 1, 1657, 1657, '0', 0, 0, 0, 0, 9984.1142578125, 2219.63720703125, 1328.7196044921875, 2.042035102844238281, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: Darnassus - Difficulty: 0) (Auras: ) +(@CGUID+3, 32823, 1, 1657, 1657, '0', 0, 0, 0, 0, 9983.890625, 2202.319580078125, 1328.6611328125, 2.042035102844238281, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: Darnassus - Difficulty: 0) (Auras: ) +(@CGUID+4, 34653, 1, 1657, 1657, '0', 0, 0, 0, 0, 9975.640625, 2211.302001953125, 1329.3121337890625, 3.106686115264892578, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table Hostess (Area: Darnassus - Difficulty: 0) +(@CGUID+5, 34676, 1, 1657, 1657, '0', 0, 0, 0, 1, 9960.447265625, 2241.05029296875, 1333.9410400390625, 3.228859186172485351, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Isaac Allerton (Area: Darnassus - Difficulty: 0) +(@CGUID+6, 34681, 1, 1657, 1657, '0', 0, 0, 0, 0, 9960.2060546875, 2238.427001953125, 1333.58349609375, 2.984513044357299804, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Ikaneba Summerset (Area: Darnassus - Difficulty: 0) +(@CGUID+7, 34711, 1, 1657, 1657, '0', 0, 0, 0, 1, 9990.419921875, 2234.536376953125, 1331.2042236328125, 3.159045934677124023, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Mary Allerton (Area: Darnassus - Difficulty: 0) (Auras: ) +(@CGUID+8, 35338, 1, 1657, 1657, '0', 0, 0, 0, 0, 9960.31640625, 2236.973876953125, 1332.883056640625, 0, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Barrel (Area: Darnassus - Difficulty: 0) +(@CGUID+9, 35338, 1, 1657, 1657, '0', 0, 0, 0, 0, 9961.9775390625, 2236.779541015625, 1332.889892578125, 3.385938644409179687, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Barrel (Area: Darnassus - Difficulty: 0) +(@CGUID+10, 35338, 1, 1657, 1657, '0', 0, 0, 0, 0, 9962.9033203125, 2238.0556640625, 1333.0186767578125, 4.764749050140380859, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741); -- Bountiful Barrel (Area: Darnassus - Difficulty: 0) (Auras: ) + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+58; +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, 1, 1657, 1657, '0', 0, 0, 9961.5888671875, 2238.329833984375, 1332.903076171875, 3.106652259826660156, 0, 0, 0.999847412109375, 0.017469281330704689, 120, 255, 1, 46741), -- Haystack 01 (Area: Darnassus - Difficulty: 0) +(@OGUID+1, 179968, 1, 1657, 1657, '0', 0, 0, 9960.8095703125, 2238.375, 1332.8931884765625, 3.106652259826660156, 0, 0, 0.999847412109375, 0.017469281330704689, 120, 255, 1, 46741), -- Haystack 01 (Area: Darnassus - Difficulty: 0) +(@OGUID+2, 179968, 1, 1657, 1657, '0', 0, 0, 9992.2255859375, 2213.4619140625, 1328.2369384765625, 0.017452461645007133, 0, 0, 0.008726119995117187, 0.999961912631988525, 120, 255, 1, 46741), -- Haystack 01 (Area: Darnassus - Difficulty: 0) +(@OGUID+3, 179968, 1, 1657, 1657, '0', 0, 0, 9960.125, 2241.038330078125, 1333.27783203125, 6.230826377868652343, 0, 0, -0.02617645263671875, 0.999657332897186279, 120, 255, 1, 46741), -- Haystack 01 (Area: Darnassus - Difficulty: 0) +(@OGUID+4, 179968, 1, 1657, 1657, '0', 0, 0, 9977.4912109375, 2228.904541015625, 1329.3697509765625, 4.712389945983886718, 0, 0, -0.70710659027099609, 0.707106947898864746, 120, 255, 1, 46741), -- Haystack 01 (Area: Darnassus - Difficulty: 0) +(@OGUID+5, 179968, 1, 1657, 1657, '0', 0, 0, 9976.6728515625, 2195.81591796875, 1328.9478759765625, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 46741), -- Haystack 01 (Area: Darnassus - Difficulty: 0) +(@OGUID+6, 179968, 1, 1657, 1657, '0', 0, 0, 9990.234375, 2234.6962890625, 1330.4951171875, 6.230826377868652343, 0, 0, -0.02617645263671875, 0.999657332897186279, 120, 255, 1, 46741), -- Haystack 01 (Area: Darnassus - Difficulty: 0) +(@OGUID+7, 179968, 1, 1657, 1657, '0', 0, 0, 9959.9130859375, 2213.0556640625, 1329.4652099609375, 6.230826377868652343, 0, 0, -0.02617645263671875, 0.999657332897186279, 120, 255, 1, 46741), -- Haystack 01 (Area: Darnassus - Difficulty: 0) +(@OGUID+8, 179968, 1, 1657, 1657, '0', 0, 0, 9960.0908203125, 2238.420166015625, 1332.8853759765625, 3.106652259826660156, 0, 0, 0.999847412109375, 0.017469281330704689, 120, 255, 1, 46741), -- Haystack 01 (Area: Darnassus - Difficulty: 0) +(@OGUID+9, 179968, 1, 1657, 1657, '0', 0, 0, 9960.0888671875, 2209.89404296875, 1329.0875244140625, 3.176533222198486328, 0, 0, -0.999847412109375, 0.017469281330704689, 120, 255, 1, 46741), -- Haystack 01 (Area: Darnassus - Difficulty: 0) +(@OGUID+10, 179968, 1, 1657, 1657, '0', 0, 0, 9974.400390625, 2195.692626953125, 1328.934326171875, 4.712389945983886718, 0, 0, -0.70710659027099609, 0.707106947898864746, 120, 255, 1, 46741), -- Haystack 01 (Area: Darnassus - Difficulty: 0) +(@OGUID+11, 179968, 1, 1657, 1657, '0', 0, 0, 9961.6220703125, 2240.947998046875, 1333.232421875, 6.230826377868652343, 0, 0, -0.02617645263671875, 0.999657332897186279, 120, 255, 1, 46741), -- Haystack 01 (Area: Darnassus - Difficulty: 0) +(@OGUID+12, 179968, 1, 1657, 1657, '0', 0, 0, 9975.4287109375, 2229.036376953125, 1329.484375, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 120, 255, 1, 46741), -- Haystack 01 (Area: Darnassus - Difficulty: 0) +(@OGUID+13, 179968, 1, 1657, 1657, '0', 0, 0, 9992.1123046875, 2210.3056640625, 1328.140625, 0.017452461645007133, 0, 0, 0.008726119995117187, 0.999961912631988525, 120, 255, 1, 46741), -- Haystack 01 (Area: Darnassus - Difficulty: 0) +(@OGUID+14, 179968, 1, 1657, 1657, '0', 0, 0, 9990.294921875, 2235.880126953125, 1330.4976806640625, 6.230826377868652343, 0, 0, -0.02617645263671875, 0.999657332897186279, 120, 255, 1, 46741), -- Haystack 01 (Area: Darnassus - Difficulty: 0) +(@OGUID+15, 179968, 1, 1657, 1657, '0', 0, 0, 9960.84375, 2240.9931640625, 1333.2552490234375, 6.230826377868652343, 0, 0, -0.02617645263671875, 0.999657332897186279, 120, 255, 1, 46741), -- Haystack 01 (Area: Darnassus - Difficulty: 0) +(@OGUID+16, 179968, 1, 1657, 1657, '0', 0, 0, 9990.2861328125, 2233.522705078125, 1330.47705078125, 3.176533222198486328, 0, 0, -0.999847412109375, 0.017469281330704689, 120, 255, 1, 46741), -- Haystack 01 (Area: Darnassus - Difficulty: 0) +(@OGUID+17, 179968, 1, 1657, 1657, '0', 0, 0, 9961.3994140625, 2195.057373046875, 1328.15625, 3.106652259826660156, 0, 0, 0.999847412109375, 0.017469281330704689, 120, 255, 1, 46741), -- Haystack 01 (Area: Darnassus - Difficulty: 0) +(@OGUID+18, 179968, 1, 1657, 1657, '0', 0, 0, 9961.1728515625, 2192.432373046875, 1328.2525634765625, 0.017452461645007133, 0, 0, 0.008726119995117187, 0.999961912631988525, 120, 255, 1, 46741), -- Haystack 01 (Area: Darnassus - Difficulty: 0) +(@OGUID+19, 180353, 1, 1657, 1657, '0', 0, 0, 9992.49609375, 2212.013916015625, 1328.1802978515625, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Darnassus - Difficulty: 0) +(@OGUID+20, 180353, 1, 1657, 1657, '0', 0, 0, 9961.55078125, 2239.6806640625, 1333.0538330078125, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Darnassus - Difficulty: 0) +(@OGUID+21, 180353, 1, 1657, 1657, '0', 0, 0, 9959.984375, 2211.553955078125, 1329.2899169921875, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Darnassus - Difficulty: 0) +(@OGUID+22, 180353, 1, 1657, 1657, '0', 0, 0, 9976.45703125, 2228.854248046875, 1329.4097900390625, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Darnassus - Difficulty: 0) +(@OGUID+23, 180353, 1, 1657, 1657, '0', 0, 0, 9994.2041015625, 2228.501708984375, 1329.9305419921875, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Darnassus - Difficulty: 0) +(@OGUID+24, 180353, 1, 1657, 1657, '0', 0, 0, 9993.8330078125, 2238.109375, 1330.4830322265625, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Darnassus - Difficulty: 0) +(@OGUID+25, 180353, 1, 1657, 1657, '0', 0, 0, 9961.2802734375, 2193.795166015625, 1328.2022705078125, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Darnassus - Difficulty: 0) +(@OGUID+26, 180353, 1, 1657, 1657, '0', 0, 0, 9975.4365234375, 2195.723876953125, 1328.94873046875, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Darnassus - Difficulty: 0) +(@OGUID+27, 195164, 1, 1657, 1657, '0', 0, 0, 9992.205078125, 2213.416748046875, 1328.8983154296875, 0.034906249493360519, 0, 0, 0.017452239990234375, 0.999847710132598876, 120, 255, 1, 46741), -- Pumpkin (Area: Darnassus - Difficulty: 0) +(@OGUID+28, 195164, 1, 1657, 1657, '0', 0, 0, 9974.3427734375, 2195.763916015625, 1329.5924072265625, 4.764749526977539062, 0, 0, -0.6883544921875, 0.725374460220336914, 120, 255, 1, 46741), -- Pumpkin (Area: Darnassus - Difficulty: 0) +(@OGUID+29, 195164, 1, 1657, 1657, '0', 0, 0, 9959.8505859375, 2213.013916015625, 1330.1253662109375, 6.248279094696044921, 0, 0, -0.01745223999023437, 0.999847710132598876, 120, 255, 1, 46741), -- Pumpkin (Area: Darnassus - Difficulty: 0) +(@OGUID+30, 195164, 1, 1657, 1657, '0', 0, 0, 9975.5244140625, 2228.991455078125, 1330.1357421875, 1.675513744354248046, 0, 0, 0.743144035339355468, 0.669131457805633544, 120, 255, 1, 46741), -- Pumpkin (Area: Darnassus - Difficulty: 0) +(@OGUID+31, 195164, 1, 1657, 1657, '0', 0, 0, 9961.4541015625, 2238.185791015625, 1333.5587158203125, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 46741), -- Pumpkin (Area: Darnassus - Difficulty: 0) +(@OGUID+32, 195164, 1, 1657, 1657, '0', 0, 0, 9961.5654296875, 2241.01904296875, 1333.9119873046875, 6.230826377868652343, 0, 0, -0.02617645263671875, 0.999657332897186279, 120, 255, 1, 46741), -- Pumpkin (Area: Darnassus - Difficulty: 0) +(@OGUID+33, 195164, 1, 1657, 1657, '0', 0, 0, 9977.5888671875, 2228.859375, 1330.01953125, 4.607671737670898437, 0, 0, -0.74314403533935546, 0.669131457805633544, 120, 255, 1, 46741), -- Pumpkin (Area: Darnassus - Difficulty: 0) +(@OGUID+34, 195164, 1, 1657, 1657, '0', 0, 0, 9976.537109375, 2195.671875, 1329.6131591796875, 4.904376029968261718, 0, 0, -0.636077880859375, 0.771624863147735595, 120, 255, 1, 46741), -- Pumpkin (Area: Darnassus - Difficulty: 0) +(@OGUID+35, 195164, 1, 1657, 1657, '0', 0, 0, 9961.1328125, 2192.3369140625, 1328.9117431640625, 0.017452461645007133, 0, 0, 0.008726119995117187, 0.999961912631988525, 120, 255, 1, 46741), -- Pumpkin (Area: Darnassus - Difficulty: 0) +(@OGUID+36, 195164, 1, 1657, 1657, '0', 0, 0, 9992.208984375, 2210.260498046875, 1328.7969970703125, 0.017452461645007133, 0, 0, 0.008726119995117187, 0.999961912631988525, 120, 255, 1, 46741), -- Pumpkin (Area: Darnassus - Difficulty: 0) +(@OGUID+37, 195164, 1, 1657, 1657, '0', 0, 0, 9992.7412109375, 2233.30029296875, 1331.1549072265625, 6.178466320037841796, 0, 0, -0.05233573913574218, 0.998629570007324218, 120, 255, 1, 46741), -- Pumpkin (Area: Darnassus - Difficulty: 0) +(@OGUID+38, 195164, 1, 1657, 1657, '0', 0, 0, 9960.140625, 2209.939208984375, 1329.7520751953125, 3.194002151489257812, 0, 0, -0.99965667724609375, 0.026201646775007247, 120, 255, 1, 46741), -- Pumpkin (Area: Darnassus - Difficulty: 0) +(@OGUID+39, 195164, 1, 1657, 1657, '0', 0, 0, 9961.2626953125, 2195.045166015625, 1328.8111572265625, 3.089183330535888671, 0, 0, 0.99965667724609375, 0.026201646775007247, 120, 255, 1, 46741), -- Pumpkin (Area: Darnassus - Difficulty: 0) +(@OGUID+40, 195191, 1, 1657, 1657, '0', 0, 0, 9992.783203125, 2234.6650390625, 1330.3138427734375, 3.159062385559082031, 0, 0, -0.99996185302734375, 0.008734640665352344, 120, 255, 1, 46741), -- Dwarven Table Simple 05 (Area: Darnassus - Difficulty: 0) +(@OGUID+41, 195192, 1, 1657, 1657, '0', 0, 0, 9993.0810546875, 2235.944580078125, 1331.2213134765625, 5.777040958404541015, 0, 0, -0.25037956237792968, 0.968147754669189453, 120, 255, 1, 46741), -- Basket of Corn (Area: Darnassus - Difficulty: 0) +(@OGUID+42, 195194, 1, 1657, 1657, '0', 0, 0, 9992.1640625, 2235.94091796875, 1331.2017822265625, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 46741), -- Small Basket 01 (Area: Darnassus - Difficulty: 0) +(@OGUID+43, 195195, 1, 1657, 1657, '0', 0, 0, 9993.162109375, 2233.248291015625, 1331.1094970703125, 3.298687219619750976, 0, 0, -0.99691677093505859, 0.078466430306434631, 120, 255, 1, 46741), -- Cranberry Masher (Area: Darnassus - Difficulty: 0) +(@OGUID+44, 195196, 1, 1657, 1657, '0', 0, 0, 9991.75390625, 2237.9619140625, 1330.768310546875, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 46741), -- Large Basket 03 (Area: Darnassus - Difficulty: 0) +(@OGUID+45, 195197, 1, 1657, 1657, '0', 0, 0, 9996.41796875, 2231.651123046875, 1330.16943359375, 3.9793548583984375, 0, 0, -0.9135446548461914, 0.406738430261611938, 120, 255, 1, 46741), -- Grain Sack 02 (Area: Darnassus - Difficulty: 0) +(@OGUID+46, 195198, 1, 1657, 1657, '0', 0, 0, 9994.83203125, 2232.52783203125, 1330.235595703125, 5.811946868896484375, 0, 0, -0.2334451675415039, 0.972369968891143798, 120, 255, 1, 46741), -- Crate 01 (Area: Darnassus - Difficulty: 0) +(@OGUID+47, 195200, 1, 1657, 1657, '0', 0, 0, 9993.107421875, 2230.94091796875, 1330.155029296875, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pilgrim's Bounty Cooking Fire (Area: Darnassus - Difficulty: 0) +(@OGUID+48, 195215, 1, 1657, 1657, '0', 0, 0, 9995.3701171875, 2236.9462890625, 1330.28955078125, 6.108653545379638671, 0, 0, -0.08715534210205078, 0.996194720268249511, 120, 255, 1, 46741), -- Sweet Potato (Area: Darnassus - Difficulty: 0) +(@OGUID+49, 195215, 1, 1657, 1657, '0', 0, 0, 9995.5185546875, 2236.3681640625, 1330.2763671875, 0.349065244197845458, 0, 0, 0.173647880554199218, 0.984807789325714111, 120, 255, 1, 46741), -- Sweet Potato (Area: Darnassus - Difficulty: 0) +(@OGUID+50, 195215, 1, 1657, 1657, '0', 0, 0, 9995.1123046875, 2235.96875, 1330.3131103515625, 0.820303261280059814, 0, 0, 0.398748397827148437, 0.917060375213623046, 120, 255, 1, 46741), -- Sweet Potato (Area: Darnassus - Difficulty: 0) +(@OGUID+51, 195215, 1, 1657, 1657, '0', 0, 0, 9994.9736328125, 2236.232666015625, 1330.32568359375, 0.855210542678833007, 0, 0, 0.414692878723144531, 0.909961462020874023, 120, 255, 1, 46741), -- Sweet Potato (Area: Darnassus - Difficulty: 0) +(@OGUID+52, 195215, 1, 1657, 1657, '0', 0, 0, 9994.8544921875, 2236.458251953125, 1330.3363037109375, 1.937312245368957519, 0, 0, 0.824125289916992187, 0.566407561302185058, 120, 255, 1, 46741), -- Sweet Potato (Area: Darnassus - Difficulty: 0) +(@OGUID+53, 195215, 1, 1657, 1657, '0', 0, 0, 9995.5263671875, 2236.6181640625, 1330.275634765625, 1.937312245368957519, 0, 0, 0.824125289916992187, 0.566407561302185058, 120, 255, 1, 46741), -- Sweet Potato (Area: Darnassus - Difficulty: 0) +(@OGUID+54, 195215, 1, 1657, 1657, '0', 0, 0, 9994.9951171875, 2236.710205078125, 1330.2353515625, 6.195919513702392578, 0, 0, -0.04361915588378906, 0.999048233032226562, 120, 255, 1, 46741), -- Sweet Potato (Area: Darnassus - Difficulty: 0) +(@OGUID+55, 195664, 1, 1657, 1657, '0', 0, 0, 9983.8896484375, 2202.320068359375, 1328.5799560546875, 2.042035102844238281, 0, 0, 0.852640151977539062, 0.522498607635498046, 120, 255, 1, 46741), -- [DND] Collision Thanksgiving Table Size (Area: Darnassus - Difficulty: 0) +(@OGUID+56, 195664, 1, 1657, 1657, '0', 0, 0, 9984.1103515625, 2219.639892578125, 1328.6400146484375, 2.042035102844238281, 0, 0, 0.852640151977539062, 0.522498607635498046, 120, 255, 1, 46741), -- [DND] Collision Thanksgiving Table Size (Area: Darnassus - Difficulty: 0) +(@OGUID+57, 195664, 1, 1657, 1657, '0', 0, 0, 9969.580078125, 2219.47998046875, 1329.5799560546875, 1.274088263511657714, 0, 0, 0.594821929931640625, 0.80385744571685791, 120, 255, 1, 46741), -- [DND] Collision Thanksgiving Table Size (Area: Darnassus - Difficulty: 0) +(@OGUID+58, 195664, 1, 1657, 1657, '0', 0, 0, 9967.9296875, 2202.5400390625, 1328.8199462890625, 0, 0, 0, 0, 1, 120, 255, 1, 46741); -- [DND] Collision Thanksgiving Table Size (Area: Darnassus - Difficulty: 0) + +-- Event spawns +DELETE FROM `game_event_creature` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @CGUID+0 AND @CGUID+10; +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), +(@EVENT, @CGUID+10); + +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @OGUID+0 AND @OGUID+58; +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); |