DB/TheExodar: Added Pilgrim's Bounty spawns

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);