diff options
| -rw-r--r-- | sql/updates/world/master/2022_12_05_06_world.sql | 173 |
1 files changed, 173 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_12_05_06_world.sql b/sql/updates/world/master/2022_12_05_06_world.sql new file mode 100644 index 00000000000..b59a0998486 --- /dev/null +++ b/sql/updates/world/master/2022_12_05_06_world.sql @@ -0,0 +1,173 @@ +SET @CGUID := 396459; +SET @OGUID := 248521; +SET @EVENT := 26; + +-- Creature templates +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=34783; -- Ranisa Whitebough +UPDATE `creature_template` SET `gossip_menu_id`=10569, `minlevel`=60, `maxlevel`=60, `npcflag`=81, `unit_flags`=33536 WHERE `entry`=34785; -- Alnar Whitebough + +-- Scaling +DELETE FROM `creature_template_scaling` WHERE `DifficultyID`=0 AND `Entry` IN (34783, 34785); +INSERT INTO `creature_template_scaling` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `VerifiedBuild`) VALUES +(34783, 0, 0, 0, 389, 46741), +(34785, 0, 0, 0, 389, 46741); + +-- Trainer +DELETE FROM `creature_trainer` WHERE `CreatureID`=34785; +INSERT INTO `creature_trainer` (`CreatureID`, `TrainerID`, `MenuID`, `OptionID`) VALUES +(34785, 136, 10569, 0); + +-- Old creature spawns +DELETE FROM `creature` WHERE `guid` BETWEEN 138346 AND 138349; +DELETE FROM `creature` WHERE `guid` BETWEEN 138370 AND 138373; +DELETE FROM `game_event_creature` WHERE `guid` BETWEEN 138346 AND 138349; +DELETE FROM `game_event_creature` WHERE `guid` BETWEEN 138370 AND 138373; + +-- Creature spawns +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+6; +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, 530, 3557, 3557, '0', 0, 0, 0, 0, -3983.451416015625, -11882.845703125, 0.513425350189208984, 2.042035102844238281, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: The Exodar - Difficulty: 0) +(@CGUID+1, 32823, 530, 3557, 3557, '0', 0, 0, 0, 0, -3978.157958984375, -11867.6005859375, 0.525727331638336181, 1.274090290069580078, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: The Exodar - Difficulty: 0) +(@CGUID+2, 32823, 530, 3557, 3557, '0', 0, 0, 0, 0, -3965.34716796875, -11867.595703125, 0.761884331703186035, 2.042035102844238281, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: The Exodar - Difficulty: 0) (Auras: ) +(@CGUID+3, 32823, 530, 3557, 3557, '0', 0, 0, 0, 0, -3971.795166015625, -11879.7255859375, 0.705299317836761474, 0, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: The Exodar - Difficulty: 0) +(@CGUID+4, 34653, 530, 3557, 3557, '0', 0, 0, 0, 0, -3985.220458984375, -11871.1806640625, 0.450035333633422851, 2.234021425247192382, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table Hostess (Area: The Exodar - Difficulty: 0) +(@CGUID+5, 34783, 530, 3557, 3557, '0', 0, 0, 0, 0, -4019.364501953125, -11861.6611328125, 0.735240340232849121, 0.541052043437957763, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Ranisa Whitebough (Area: The Exodar - Difficulty: 0) +(@CGUID+6, 34785, 530, 3557, 3557, '0', 0, 0, 0, 1, -4007.119873046875, -11839.8857421875, 0.896734297275543212, 4.15388345718383789, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741); -- Alnar Whitebough (Area: The Exodar - Difficulty: 0) (Auras: ) + +-- Old gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN 76167 AND 76199; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 76167 AND 76199; + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+57; +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, 530, 3557, 3557, '0', 0, 0, -4023.3681640625, -11850.314453125, -0.01728500053286552, 3.194002151489257812, 0, 0, -0.99965667724609375, 0.026201646775007247, 120, 255, 1, 46741), -- Haystack 01 (Area: The Exodar - Difficulty: 0) +(@OGUID+1, 179968, 530, 3557, 3557, '0', 0, 0, -4023.45654296875, -11847.853515625, -0.01446899957954883, 0.069811686873435974, 0, 0, 0.034898757934570312, 0.999390840530395507, 120, 255, 1, 46741), -- Haystack 01 (Area: The Exodar - Difficulty: 0) +(@OGUID+2, 179968, 530, 3557, 3557, '0', 0, 0, -3954.882080078125, -11863.265625, 0.841229975223541259, 3.43830275535583496, 0, 0, -0.98901557922363281, 0.147811368107795715, 120, 255, 1, 46741), -- Haystack 01 (Area: The Exodar - Difficulty: 0) +(@OGUID+3, 179968, 530, 3557, 3557, '0', 0, 0, -3989.704833984375, -11873.890625, 0.31319400668144226, 5.95157480239868164, 0, 0, -0.16504669189453125, 0.986285746097564697, 120, 255, 1, 46741), -- Haystack 01 (Area: The Exodar - Difficulty: 0) +(@OGUID+4, 179968, 530, 3557, 3557, '0', 0, 0, -4007.154541015625, -11839.90625, 0.183230996131896972, 5.759587764739990234, 0, 0, -0.25881862640380859, 0.965925931930541992, 120, 255, 1, 46741), -- Haystack 01 (Area: The Exodar - Difficulty: 0) +(@OGUID+5, 179968, 530, 3557, 3557, '0', 0, 0, -4006.51904296875, -11840.271484375, 0.188604995608329772, 2.617989301681518554, 0, 0, 0.965925216674804687, 0.258821308612823486, 120, 255, 1, 46741), -- Haystack 01 (Area: The Exodar - Difficulty: 0) +(@OGUID+6, 179968, 530, 3557, 3557, '0', 0, 0, -3955.944580078125, -11860.5087890625, 0.793404996395111083, 3.543023586273193359, 0, 0, -0.97992420196533203, 0.199370384216308593, 120, 255, 1, 46741), -- Haystack 01 (Area: The Exodar - Difficulty: 0) +(@OGUID+7, 179968, 530, 3557, 3557, '0', 0, 0, -3992.65966796875, -11883.75, 0.249393001198768615, 5.84685373306274414, 0, 0, -0.21643924713134765, 0.976296067237854003, 120, 255, 1, 46741), -- Haystack 01 (Area: The Exodar - Difficulty: 0) +(@OGUID+8, 179968, 530, 3557, 3557, '0', 0, 0, -4007.49658203125, -11863.2431640625, 0.134553998708724975, 1.500982880592346191, 0, 0, 0.681998252868652343, 0.731353819370269775, 120, 255, 1, 46741), -- Haystack 01 (Area: The Exodar - Difficulty: 0) +(@OGUID+9, 179968, 530, 3557, 3557, '0', 0, 0, -3976.236083984375, -11894.00390625, 0.601652979850769042, 1.413715124130249023, 0, 0, 0.649447441101074218, 0.760406434535980224, 120, 255, 1, 46741), -- Haystack 01 (Area: The Exodar - Difficulty: 0) +(@OGUID+10, 179968, 530, 3557, 3557, '0', 0, 0, -4004.57470703125, -11864.0361328125, 0.164826005697250366, 1.082102894783020019, 0, 0, 0.51503753662109375, 0.857167601585388183, 120, 255, 1, 46741), -- Haystack 01 (Area: The Exodar - Difficulty: 0) +(@OGUID+11, 179968, 530, 3557, 3557, '0', 0, 0, -4019.588623046875, -11861.8701171875, -0.00016100000357255, 1.082102894783020019, 0, 0, 0.51503753662109375, 0.857167601585388183, 120, 255, 1, 46741), -- Haystack 01 (Area: The Exodar - Difficulty: 0) +(@OGUID+12, 179968, 530, 3557, 3557, '0', 0, 0, -4020.451416015625, -11832.0087890625, 0.088124997913837432, 6.03883981704711914, 0, 0, -0.12186908721923828, 0.9925462007522583, 120, 255, 1, 46741), -- Haystack 01 (Area: The Exodar - Difficulty: 0) +(@OGUID+13, 179968, 530, 3557, 3557, '0', 0, 0, -4007.770751953125, -11839.5107421875, 0.178123995661735534, 5.759587764739990234, 0, 0, -0.25881862640380859, 0.965925931930541992, 120, 255, 1, 46741), -- Haystack 01 (Area: The Exodar - Difficulty: 0) +(@OGUID+14, 179968, 530, 3557, 3557, '0', 0, 0, -4019.720458984375, -11860.982421875, -0.0001429999974789, 1.082102894783020019, 0, 0, 0.51503753662109375, 0.857167601585388183, 120, 255, 1, 46741), -- Haystack 01 (Area: The Exodar - Difficulty: 0) +(@OGUID+15, 179968, 530, 3557, 3557, '0', 0, 0, -4018.642333984375, -11861.5361328125, 0.011126000434160232, 1.082102894783020019, 0, 0, 0.51503753662109375, 0.857167601585388183, 120, 255, 1, 46741), -- Haystack 01 (Area: The Exodar - Difficulty: 0) +(@OGUID+16, 179968, 530, 3557, 3557, '0', 0, 0, -3979.072998046875, -11892.7451171875, 0.540421009063720703, 1.134462952613830566, 0, 0, 0.537299156188964843, 0.843391716480255126, 120, 255, 1, 46741), -- Haystack 01 (Area: The Exodar - Difficulty: 0) +(@OGUID+17, 179968, 530, 3557, 3557, '0', 0, 0, -4017.515625, -11830.66015625, 0.121440999209880828, 1.082102894783020019, 0, 0, 0.51503753662109375, 0.857167601585388183, 120, 255, 1, 46741), -- Haystack 01 (Area: The Exodar - Difficulty: 0) +(@OGUID+18, 179968, 530, 3557, 3557, '0', 0, 0, -4019.51904296875, -11863.294921875, -0.00182100001256912, 1.082102894783020019, 0, 0, 0.51503753662109375, 0.857167601585388183, 120, 255, 1, 46741), -- Haystack 01 (Area: The Exodar - Difficulty: 0) +(@OGUID+19, 179968, 530, 3557, 3557, '0', 0, 0, -3991.939208984375, -11886.978515625, 0.262340009212493896, 1.117009282112121582, 0, 0, 0.529918670654296875, 0.84804844856262207, 120, 255, 1, 46741), -- Haystack 01 (Area: The Exodar - Difficulty: 0) +(@OGUID+20, 179968, 530, 3557, 3557, '0', 0, 0, -3990.60595703125, -11871.2587890625, 0.301728010177612304, 1.134462952613830566, 0, 0, 0.537299156188964843, 0.843391716480255126, 120, 255, 1, 46741), -- Haystack 01 (Area: The Exodar - Difficulty: 0) +(@OGUID+21, 180353, 530, 3557, 3557, '0', 0, 0, -3955.38720703125, -11861.8076171875, 0.817112982273101806, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: The Exodar - Difficulty: 0) +(@OGUID+22, 180353, 530, 3557, 3557, '0', 0, 0, -3989.295166015625, -11872.2783203125, 0.315988987684249877, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: The Exodar - Difficulty: 0) +(@OGUID+23, 180353, 530, 3557, 3557, '0', 0, 0, -4002.882080078125, -11838.6201171875, 0.229010999202728271, 3.700104713439941406, 0, 0, -0.96126079559326171, 0.275640487670898437, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: The Exodar - Difficulty: 0) +(@OGUID+24, 180353, 530, 3557, 3557, '0', 0, 0, -3977.78125, -11893.5595703125, 0.569688022136688232, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: The Exodar - Difficulty: 0) +(@OGUID+25, 180353, 530, 3557, 3557, '0', 0, 0, -3993.395751953125, -11886.1513671875, 0.233521997928619384, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: The Exodar - Difficulty: 0) +(@OGUID+26, 180353, 530, 3557, 3557, '0', 0, 0, -4023.29345703125, -11849.125, -0.01464200019836425, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: The Exodar - Difficulty: 0) +(@OGUID+27, 180353, 530, 3557, 3557, '0', 0, 0, -4005.979248046875, -11863.45703125, 0.150845006108283996, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: The Exodar - Difficulty: 0) +(@OGUID+28, 180353, 530, 3557, 3557, '0', 0, 0, -4007.51904296875, -11835.3076171875, 0.191512003540992736, 3.752462387084960937, 0, 0, -0.95371627807617187, 0.300707906484603881, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: The Exodar - Difficulty: 0) +(@OGUID+29, 180353, 530, 3557, 3557, '0', 0, 0, -4020.923583984375, -11862.7158203125, -0.01675100065767765, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: The Exodar - Difficulty: 0) +(@OGUID+30, 180353, 530, 3557, 3557, '0', 0, 0, -4019.963623046875, -11829.2001953125, 0.119457997381687164, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: The Exodar - Difficulty: 0) +(@OGUID+31, 195164, 530, 3557, 3557, '0', 0, 0, -4019.442626953125, -11863.2236328125, 0.714635014533996582, 1.082102894783020019, 0, 0, 0.51503753662109375, 0.857167601585388183, 120, 255, 1, 46741), -- Pumpkin (Area: The Exodar - Difficulty: 0) +(@OGUID+32, 195164, 530, 3557, 3557, '0', 0, 0, -4007.447998046875, -11863.421875, 0.850269973278045654, 1.535889506340026855, 0, 0, 0.694658279418945312, 0.719339847564697265, 120, 255, 1, 46741), -- Pumpkin (Area: The Exodar - Difficulty: 0) +(@OGUID+33, 195164, 530, 3557, 3557, '0', 0, 0, -4020.229248046875, -11831.7744140625, 0.807295024394989013, 1.535889506340026855, 0, 0, 0.694658279418945312, 0.719339847564697265, 120, 255, 1, 46741), -- Pumpkin (Area: The Exodar - Difficulty: 0) +(@OGUID+34, 195164, 530, 3557, 3557, '0', 0, 0, -4017.439208984375, -11830.5888671875, 0.838163018226623535, 1.082102894783020019, 0, 0, 0.51503753662109375, 0.857167601585388183, 120, 255, 1, 46741), -- Pumpkin (Area: The Exodar - Difficulty: 0) +(@OGUID+35, 195164, 530, 3557, 3557, '0', 0, 0, -3990.741455078125, -11871.404296875, 1.015535950660705566, 1.099556446075439453, 0, 0, 0.522498130798339843, 0.852640450000762939, 120, 255, 1, 46741), -- Pumpkin (Area: The Exodar - Difficulty: 0) +(@OGUID+36, 195164, 530, 3557, 3557, '0', 0, 0, -3955.640625, -11860.5244140625, 1.515169024467468261, 1.553341388702392578, 0, 0, 0.700908660888671875, 0.713251054286956787, 120, 255, 1, 46741), -- Pumpkin (Area: The Exodar - Difficulty: 0) +(@OGUID+37, 195164, 530, 3557, 3557, '0', 0, 0, -4007.147705078125, -11837.2275390625, 1.117460012435913085, 3.52557229995727539, 0, 0, -0.98162651062011718, 0.190812408924102783, 120, 255, 1, 46741), -- Pumpkin (Area: The Exodar - Difficulty: 0) +(@OGUID+38, 195164, 530, 3557, 3557, '0', 0, 0, -4004.498291015625, -11863.9658203125, 0.881223022937774658, 1.082102894783020019, 0, 0, 0.51503753662109375, 0.857167601585388183, 120, 255, 1, 46741), -- Pumpkin (Area: The Exodar - Difficulty: 0) +(@OGUID+39, 195164, 530, 3557, 3557, '0', 0, 0, -3992.67529296875, -11883.55078125, 0.96467900276184082, 0.052358884364366531, 0, 0, 0.02617645263671875, 0.999657332897186279, 120, 255, 1, 46741), -- Pumpkin (Area: The Exodar - Difficulty: 0) +(@OGUID+40, 195164, 530, 3557, 3557, '0', 0, 0, -3954.703125, -11863.205078125, 1.559762001037597656, 3.43830275535583496, 0, 0, -0.98901557922363281, 0.147811368107795715, 120, 255, 1, 46741), -- Pumpkin (Area: The Exodar - Difficulty: 0) +(@OGUID+41, 195164, 530, 3557, 3557, '0', 0, 0, -3976.005126953125, -11894.095703125, 1.322070956230163574, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 46741), -- Pumpkin (Area: The Exodar - Difficulty: 0) +(@OGUID+42, 195164, 530, 3557, 3557, '0', 0, 0, -3979.038330078125, -11892.8056640625, 1.256886005401611328, 1.047197580337524414, 0, 0, 0.5, 0.866025388240814208, 120, 255, 1, 46741), -- Pumpkin (Area: The Exodar - Difficulty: 0) +(@OGUID+43, 195164, 530, 3557, 3557, '0', 0, 0, -3991.826416015625, -11887.1650390625, 0.981033027172088623, 0.069811686873435974, 0, 0, 0.034898757934570312, 0.999390840530395507, 120, 255, 1, 46741), -- Pumpkin (Area: The Exodar - Difficulty: 0) +(@OGUID+44, 195164, 530, 3557, 3557, '0', 0, 0, -4023.59375, -11847.8662109375, 0.699485003948211669, 0.069811686873435974, 0, 0, 0.034898757934570312, 0.999390840530395507, 120, 255, 1, 46741), -- Pumpkin (Area: The Exodar - Difficulty: 0) +(@OGUID+45, 195164, 530, 3557, 3557, '0', 0, 0, -4023.407958984375, -11850.41015625, 0.697601974010467529, 3.176533222198486328, 0, 0, -0.999847412109375, 0.017469281330704689, 120, 255, 1, 46741), -- Pumpkin (Area: The Exodar - Difficulty: 0) +(@OGUID+46, 195164, 530, 3557, 3557, '0', 0, 0, -3989.51904296875, -11874.01953125, 1.032209038734436035, 5.986480236053466796, 0, 0, -0.14780902862548828, 0.989015936851501464, 120, 255, 1, 46741), -- Pumpkin (Area: The Exodar - Difficulty: 0) +(@OGUID+47, 195191, 530, 3557, 3557, '0', 0, 0, -4006.015625, -11838.2431640625, 0.187720999121665954, 4.1538848876953125, 0, 0, -0.8746194839477539, 0.484810054302215576, 120, 255, 1, 46741), -- Dwarven Table Simple 05 (Area: The Exodar - Difficulty: 0) +(@OGUID+48, 195192, 530, 3557, 3557, '0', 0, 0, -4007.192626953125, -11838.0537109375, 1.093829989433288574, 3.508116960525512695, 0, 0, -0.98325443267822265, 0.182238012552261352, 120, 255, 1, 46741), -- Basket of Corn (Area: The Exodar - Difficulty: 0) +(@OGUID+49, 195194, 530, 3557, 3557, '0', 0, 0, -4004.788330078125, -11838.501953125, 1.111768007278442382, 3.385940074920654296, 0, 0, -0.99254608154296875, 0.121869951486587524, 120, 255, 1, 46741), -- Small Basket 01 (Area: The Exodar - Difficulty: 0) +(@OGUID+50, 195196, 530, 3557, 3557, '0', 0, 0, -4021.642333984375, -11860.8857421875, -0.02176300063729286, 3.735006093978881835, 0, 0, -0.95630455017089843, 0.292372345924377441, 120, 255, 1, 46741), -- Large Basket 03 (Area: The Exodar - Difficulty: 0) +(@OGUID+51, 195197, 530, 3557, 3557, '0', 0, 0, -4005.079833984375, -11834.9619140625, 0.216630995273590087, 3.368495941162109375, 0, 0, -0.99357128143310546, 0.113208353519439697, 120, 255, 1, 46741), -- Grain Sack 02 (Area: The Exodar - Difficulty: 0) +(@OGUID+52, 195198, 530, 3557, 3557, '0', 0, 0, -4003.89404296875, -11836.5126953125, 0.224408000707626342, 3.141592741012573242, 0, 0, -1, 0, 120, 255, 1, 46741), -- Crate 01 (Area: The Exodar - Difficulty: 0) +(@OGUID+53, 195200, 530, 3557, 3557, '0', 0, 0, -4002.55908203125, -11840.4267578125, 0.227538004517555236, 2.757613182067871093, 0, 0, 0.981626510620117187, 0.190812408924102783, 120, 255, 1, 46741), -- Pilgrim's Bounty Cooking Fire (Area: The Exodar - Difficulty: 0) +(@OGUID+54, 195664, 530, 3557, 3557, '0', 0, 0, -3971.795166015625, -11879.7255859375, 0.621966004371643066, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- [DND] Collision Thanksgiving Table Size (Area: The Exodar - Difficulty: 0) +(@OGUID+55, 195664, 530, 3557, 3557, '0', 0, 0, -3983.451416015625, -11882.845703125, 0.430092006921768188, 2.042035102844238281, 0, 0, 0.852640151977539062, 0.522498607635498046, 120, 255, 1, 46741), -- [DND] Collision Thanksgiving Table Size (Area: The Exodar - Difficulty: 0) +(@OGUID+56, 195664, 530, 3557, 3557, '0', 0, 0, -3965.34716796875, -11867.595703125, 0.678551018238067626, 2.042035102844238281, 0, 0, 0.852640151977539062, 0.522498607635498046, 120, 255, 1, 46741), -- [DND] Collision Thanksgiving Table Size (Area: The Exodar - Difficulty: 0) +(@OGUID+57, 195664, 530, 3557, 3557, '0', 0, 0, -3978.157958984375, -11867.6005859375, 0.442393988370895385, 1.274088263511657714, 0, 0, 0.594821929931640625, 0.80385744571685791, 120, 255, 1, 46741); -- [DND] Collision Thanksgiving Table Size (Area: The Exodar - Difficulty: 0) + +-- Event spawns +DELETE FROM `game_event_creature` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @CGUID+0 AND @CGUID+6; +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); + +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @OGUID+0 AND @OGUID+57; +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); |