aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2022_12_29_05_world.sql168
1 files changed, 168 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_12_29_05_world.sql b/sql/updates/world/master/2022_12_29_05_world.sql
new file mode 100644
index 00000000000..b4396e1095a
--- /dev/null
+++ b/sql/updates/world/master/2022_12_29_05_world.sql
@@ -0,0 +1,168 @@
+SET @CGUID := 396691;
+SET @OGUID := 253005;
+SET @EVENT := 2;
+
+-- Old creature spawns
+DELETE FROM `creature` WHERE `guid` IN (78301, 78302);
+DELETE FROM `game_event_creature` WHERE `guid` IN (78301, 78302);
+
+-- Creature spawns
+DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+4;
+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
+-- Brill
+(@CGUID+0, 15730, 0, 14046, 0, '0', 0, 0, 0, 0, 2051.358642578125, 272.456695556640625, 57.25214385986328125, 0, 120, 0, 0, 152441, 0, 0, 0, 0, 0, 47213), -- Pat's Snowcloud Guy (Area: 0 - Difficulty: 0)
+(@CGUID+1, 15730, 0, 14046, 0, '0', 0, 0, 0, 0, 2051.342529296875, 272.455474853515625, 57.25122833251953125, 0, 120, 0, 0, 152441, 0, 0, 0, 0, 0, 47213), -- Pat's Snowcloud Guy (Area: 0 - Difficulty: 0)
+(@CGUID+2, 15732, 0, 14046, 0, '0', 0, 0, 0, 0, 2049.5078125, 275.711761474609375, 56.9341278076171875, 3.298672199249267578, 120, 0, 0, 118565, 0, 0, 0, 0, 0, 47213), -- Wonderform Operator (Area: 0 - Difficulty: 0)
+(@CGUID+3, 15760, 0, 85, 159, '0', 0, 0, 0, 1, 2306.83154296875, 284.789947509765625, 44.24895095825195312, 3.054326057434082031, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 47213), -- Winter Reveler (Area: Brill - Difficulty: 0) (Auras: )
+(@CGUID+4, 15760, 0, 85, 159, '0', 0, 0, 0, 1, 2304.6181640625, 285.520843505859375, 44.27643585205078125, 6.143558979034423828, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 47213); -- Winter Reveler (Area: Brill - Difficulty: 0) (Auras: )
+
+DELETE FROM `creature_addon` WHERE `guid` IN (@CGUID+3, @CGUID+4);
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES
+(@CGUID+3, 0, 0, 0, 257, 0, 0, 0, 0, 0, '26253'), -- 15760 (Winter Reveler)
+(@CGUID+4, 0, 0, 0, 257, 0, 0, 0, 0, 0, '26254'); -- 15760 (Winter Reveler)
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+62;
+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
+-- Brill
+(@OGUID+0, 178434, 0, 14046, 0, '0', 0, 0, 2049.07470703125, 271.458343505859375, 62.23524856567382812, 3.089183330535888671, 0, 0, 0.99965667724609375, 0.026201646775007247, 120, 255, 1, 47213), -- XMasStocking01 (Area: 0 - Difficulty: 0)
+(@OGUID+1, 178435, 0, 14046, 0, '0', 0, 0, 2049.3369140625, 273.79339599609375, 62.1127471923828125, 2.44346022605895996, 0, 0, 0.939692497253417968, 0.34202045202255249, 120, 255, 1, 47213), -- XMasStocking02 (Area: 0 - Difficulty: 0)
+(@OGUID+2, 178667, 0, 14046, 0, '0', 0, 0, 2049.80859375, 266.66790771484375, 57.1444244384765625, 1.431168079376220703, 0, 0, 0.656058311462402343, 0.754710197448730468, 120, 255, 1, 47213), -- Christmas Tree (Medium) (Area: 0 - Difficulty: 0)
+(@OGUID+3, 178746, 0, 14046, 0, '0', 0, 0, 2048.38134765625, 270.00201416015625, 56.9913482666015625, 2.70525527000427246, 0, 0, 0.97629547119140625, 0.216442063450813293, 120, 255, 1, 47213), -- Smokywood Pastures (Area: 0 - Difficulty: 0)
+(@OGUID+4, 180796, 0, 14046, 0, '0', 0, 0, 2051.28125, 272.46875, 56.91361618041992187, 3.839725255966186523, 0, 0, -0.93969249725341796, 0.34202045202255249, 120, 255, 1, 47213), -- PX-238 Winter Wondervolt (Area: 0 - Difficulty: 0)
+(@OGUID+5, 180797, 0, 14046, 0, '0', 0, 0, 2051.409912109375, 272.412994384765625, 57.17399978637695312, 5.148722648620605468, 0, 0, -0.53729915618896484, 0.843391716480255126, 120, 255, 1, 47213), -- PX-238 Winter Wondervolt TRAP (Area: 0 - Difficulty: 0)
+(@OGUID+6, 180798, 0, 14046, 0, '0', 0, 0, 2049.700439453125, 270.4454345703125, 57.14134597778320312, 4.223697185516357421, 0, 0, -0.85716724395751953, 0.515038192272186279, 120, 255, 1, 47213), -- Present BIG (Area: 0 - Difficulty: 0)
+(@OGUID+7, 180799, 0, 14046, 0, '0', 0, 0, 2050.563720703125, 270.023590087890625, 57.16301727294921875, 4.241150379180908203, 0, 0, -0.85264015197753906, 0.522498607635498046, 120, 255, 1, 47213), -- Present BIG (Area: 0 - Difficulty: 0)
+(@OGUID+8, 180844, 0, 85, 159, '0', 0, 0, 2305.927001953125, 285.098968505859375, 49.16773605346679687, 3.630291461944580078, 0, 0, -0.97029495239257812, 0.241925001144409179, 120, 255, 1, 47213), -- Mistletoe (Area: Brill - Difficulty: 0)
+(@OGUID+9, 187194, 0, 85, 159, '0', 0, 0, 2300.679931640625, 254.9010009765625, 59.64569854736328125, 4.904376029968261718, 0, 0, -0.636077880859375, 0.771624863147735595, 120, 255, 1, 47213), -- Hanging, Streamer x3 - Xmas (Area: Brill - Difficulty: 0)
+(@OGUID+10, 187194, 0, 85, 159, '0', 0, 0, 2254.890625, 236.173614501953125, 50.18280029296875, 0.401424884796142578, 0, 0, 0.199367523193359375, 0.979924798011779785, 120, 255, 1, 47213), -- Hanging, Streamer x3 - Xmas (Area: Brill - Difficulty: 0)
+(@OGUID+11, 187194, 0, 85, 159, '0', 0, 0, 2298.30908203125, 305.65972900390625, 59.64093017578125, 1.762782454490661621, 0, 0, 0.771624565124511718, 0.636078238487243652, 120, 255, 1, 47213), -- Hanging, Streamer x3 - Xmas (Area: Brill - Difficulty: 0)
+(@OGUID+12, 187194, 0, 85, 159, '0', 0, 0, 2287.850830078125, 257.197906494140625, 59.37849807739257812, 4.171337604522705078, 0, 0, -0.87035560607910156, 0.492423713207244873, 120, 255, 1, 47213), -- Hanging, Streamer x3 - Xmas (Area: Brill - Difficulty: 0)
+(@OGUID+13, 187194, 0, 85, 159, '0', 0, 0, 2248.550048828125, 222.6840057373046875, 41.815399169921875, 5.096362113952636718, 0, 0, -0.55919265747070312, 0.829037725925445556, 120, 255, 1, 47213), -- Hanging, Streamer x3 - Xmas (Area: Brill - Difficulty: 0)
+(@OGUID+14, 187194, 0, 85, 159, '0', 0, 0, 2230.550048828125, 225.938995361328125, 54.43090057373046875, 3.52557229995727539, 0, 0, -0.98162651062011718, 0.190812408924102783, 120, 255, 1, 47213), -- Hanging, Streamer x3 - Xmas (Area: Brill - Difficulty: 0)
+(@OGUID+15, 187194, 0, 85, 159, '0', 0, 0, 2310.704833984375, 302.880218505859375, 59.51275634765625, 0.942476630210876464, 0, 0, 0.453989982604980468, 0.891006767749786376, 120, 255, 1, 47213), -- Hanging, Streamer x3 - Xmas (Area: Brill - Difficulty: 0)
+(@OGUID+16, 187194, 0, 85, 159, '0', 0, 0, 2252, 235.1336822509765625, 41.72713470458984375, 0.383971005678176879, 0, 0, 0.190808296203613281, 0.981627285480499267, 120, 255, 1, 47213), -- Hanging, Streamer x3 - Xmas (Area: Brill - Difficulty: 0)
+(@OGUID+17, 187235, 0, 85, 159, '0', 0, 0, 2234.8701171875, 244.615997314453125, 33.573699951171875, 0.994837164878845214, 0, 0, 0.477158546447753906, 0.878817260265350341, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: Brill - Difficulty: 0)
+(@OGUID+18, 187235, 0, 85, 159, '0', 0, 0, 2259.192626953125, 273.942718505859375, 33.69063186645507812, 1.745326757431030273, 0, 0, 0.766043663024902343, 0.642788589000701904, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: Brill - Difficulty: 0)
+(@OGUID+19, 187235, 0, 85, 159, '0', 0, 0, 2256.300048828125, 306.52398681640625, 33.57360076904296875, 6.161012649536132812, 0, 0, -0.06104850769042968, 0.998134791851043701, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: Brill - Difficulty: 0)
+(@OGUID+20, 187235, 0, 85, 159, '0', 0, 0, 2261.3837890625, 320.645843505859375, 33.61780548095703125, 0.034906249493360519, 0, 0, 0.017452239990234375, 0.999847710132598876, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: Brill - Difficulty: 0)
+(@OGUID+21, 187235, 0, 85, 159, '0', 0, 0, 2263.5400390625, 333.89801025390625, 33.57360076904296875, 5.742135047912597656, 0, 0, -0.26723766326904296, 0.96363067626953125, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: Brill - Difficulty: 0)
+(@OGUID+22, 187235, 0, 85, 159, '0', 0, 0, 2334.930908203125, 403.952545166015625, 33.80598068237304687, 5.427974700927734375, 0, 0, -0.41469287872314453, 0.909961462020874023, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: Brill - Difficulty: 0)
+(@OGUID+23, 187235, 0, 85, 159, '0', 0, 0, 2275.8798828125, 395.10198974609375, 34.36539840698242187, 0.052358884364366531, 0, 0, 0.02617645263671875, 0.999657332897186279, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: Brill - Difficulty: 0)
+(@OGUID+24, 187235, 0, 14046, 0, '0', 0, 0, 2094.260498046875, 317.633697509765625, 54.18476486206054687, 0.541050612926483154, 0, 0, 0.267237663269042968, 0.96363067626953125, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+25, 187235, 0, 14046, 0, '0', 0, 0, 2084.211669921875, 282.063232421875, 57.2977447509765625, 5.794494152069091796, 0, 0, -0.24192142486572265, 0.970295846462249755, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+26, 187235, 0, 14046, 0, '0', 0, 0, 2090.697998046875, 329.39410400390625, 54.62982177734375, 6.213373661041259765, 0, 0, -0.03489875793457031, 0.999390840530395507, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+27, 187235, 0, 14046, 0, '0', 0, 0, 2082.238037109375, 273.511932373046875, 56.91861343383789062, 6.161012649536132812, 0, 0, -0.06104850769042968, 0.998134791851043701, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+28, 187235, 0, 14046, 0, '0', 0, 0, 2056.0556640625, 316.51214599609375, 54.15087127685546875, 3.78736734390258789, 0, 0, -0.94832324981689453, 0.317305892705917358, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+29, 187235, 0, 14046, 0, '0', 0, 0, 2048.75, 289.079864501953125, 56.6565704345703125, 3.333590030670166015, 0, 0, -0.99539566040039062, 0.095851235091686248, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+30, 187235, 0, 14046, 0, '0', 0, 0, 2047.138427734375, 280.67059326171875, 56.42036819458007812, 2.775068521499633789, 0, 0, 0.983254432678222656, 0.182238012552261352, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+31, 187235, 0, 14046, 0, '0', 0, 0, 2063.98779296875, 340.98785400390625, 82.36017608642578125, 0.418878614902496337, 0, 0, 0.207911491394042968, 0.978147625923156738, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+32, 187567, 0, 85, 159, '0', 0, 0, 2244.580078125, 245.47900390625, 43.10940170288085937, 0.767943859100341796, 0, 0, 0.374606132507324218, 0.927184045314788818, 120, 255, 1, 47213), -- Hanging, Streamer - Xmas (Area: Brill - Difficulty: 0)
+(@OGUID+33, 187567, 0, 85, 159, '0', 0, 0, 2240.169921875, 244.5989990234375, 41.98099899291992187, 1.954769015312194824, 0, 0, 0.829037666320800781, 0.559192776679992675, 120, 255, 1, 47213), -- Hanging, Streamer - Xmas (Area: Brill - Difficulty: 0)
+(@OGUID+34, 187567, 0, 85, 159, '0', 0, 0, 2236.080078125, 241.9759979248046875, 43.20270156860351562, 3.124123096466064453, 0, 0, 0.99996185302734375, 0.008734640665352344, 120, 255, 1, 47213), -- Hanging, Streamer - Xmas (Area: Brill - Difficulty: 0)
+(@OGUID+35, 187567, 0, 85, 159, '0', 0, 0, 2254.94970703125, 313.977447509765625, 39.90959930419921875, 5.759587764739990234, 0, 0, -0.25881862640380859, 0.965925931930541992, 120, 255, 1, 47213), -- Hanging, Streamer - Xmas (Area: Brill - Difficulty: 0)
+(@OGUID+36, 187567, 0, 85, 159, '0', 0, 0, 2239.414794921875, 306.4716796875, 40.42378616333007812, 5.637413978576660156, 0, 0, -0.31730461120605468, 0.948323667049407958, 120, 255, 1, 47213), -- Hanging, Streamer - Xmas (Area: Brill - Difficulty: 0)
+(@OGUID+37, 187567, 0, 85, 159, '0', 0, 0, 2263.300048828125, 349.42401123046875, 36.89350128173828125, 0.890116631984710693, 0, 0, 0.430510520935058593, 0.902585566043853759, 120, 255, 1, 47213), -- Hanging, Streamer - Xmas (Area: Brill - Difficulty: 0)
+(@OGUID+38, 187567, 0, 85, 159, '0', 0, 0, 2379.330078125, 349.816009521484375, 45.83810043334960937, 2.216565132141113281, 0, 0, 0.894933700561523437, 0.44619917869567871, 120, 255, 1, 47213), -- Hanging, Streamer - Xmas (Area: Brill - Difficulty: 0)
+(@OGUID+39, 187567, 0, 14046, 0, '0', 0, 0, 2082.529541015625, 320.005218505859375, 61.95344924926757812, 0.366517573595046997, 0, 0, 0.182234764099121093, 0.98325502872467041, 120, 255, 1, 47213), -- Hanging, Streamer - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+40, 187567, 0, 14046, 0, '0', 0, 0, 2072.677490234375, 279.202728271484375, 65.41193389892578125, 6.09120035171508789, 0, 0, -0.09584522247314453, 0.995396256446838378, 120, 255, 1, 47213), -- Hanging, Streamer - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+41, 187567, 0, 14046, 0, '0', 0, 0, 2068.6875, 315.526031494140625, 62.07224655151367187, 3.490667104721069335, 0, 0, -0.98480701446533203, 0.173652306199073791, 120, 255, 1, 47213), -- Hanging, Streamer - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+42, 187567, 0, 14046, 0, '0', 0, 0, 2058.600341796875, 282.822265625, 65.5201568603515625, 2.967041015625, 0, 0, 0.996193885803222656, 0.087165042757987976, 120, 255, 1, 47213), -- Hanging, Streamer - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+43, 187567, 0, 14046, 0, '0', 0, 0, 2060.982177734375, 257.691650390625, 103.6666030883789062, 4.502951622009277343, 0, 0, -0.7771453857421875, 0.629321098327636718, 120, 255, 1, 47213), -- Hanging, Streamer - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+44, 187567, 0, 14046, 0, '0', 0, 0, 2060.613525390625, 255.76641845703125, 75.142181396484375, 4.433136463165283203, 0, 0, -0.79863548278808593, 0.60181504487991333, 120, 255, 1, 47213), -- Hanging, Streamer - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+45, 187567, 0, 14046, 0, '0', 0, 0, 2067.807373046875, 340.192718505859375, 89.05030059814453125, 1.937312245368957519, 0, 0, 0.824125289916992187, 0.566407561302185058, 120, 255, 1, 47213), -- Hanging, Streamer - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+46, 187567, 0, 14046, 0, '0', 0, 0, 2063.374267578125, 269.648529052734375, 97.77622222900390625, 1.413715124130249023, 0, 0, 0.649447441101074218, 0.760406434535980224, 120, 255, 1, 47213), -- Hanging, Streamer - Xmas (Area: 0 - Difficulty: 0)
+-- The Bulwark
+(@OGUID+47, 187234, 0, 85, 152, '0', 0, 0, 1771.94970703125, -724.19964599609375, 65.1058807373046875, 2.862335443496704101, 0, 0, 0.990267753601074218, 0.139175355434417724, 120, 255, 1, 47213), -- Tall/Thin Medium - Xmas (Area: The Bulwark - Difficulty: 0)
+(@OGUID+48, 187234, 0, 85, 152, '0', 0, 0, 1724.029541015625, -702.8194580078125, 57.421630859375, 1.640606880187988281, 0, 0, 0.731352806091308593, 0.6819993257522583, 120, 255, 1, 47213), -- Tall/Thin Medium - Xmas (Area: The Bulwark - Difficulty: 0)
+(@OGUID+49, 187234, 0, 85, 152, '0', 0, 0, 1685.109375, -727.6649169921875, 63.69380569458007812, 0.855210542678833007, 0, 0, 0.414692878723144531, 0.909961462020874023, 120, 255, 1, 47213), -- Tall/Thin Medium - Xmas (Area: The Bulwark - Difficulty: 0)
+(@OGUID+50, 187234, 0, 85, 152, '0', 0, 0, 1695.5416259765625, -703.40972900390625, 56.10264968872070312, 1.553341388702392578, 0, 0, 0.700908660888671875, 0.713251054286956787, 120, 255, 1, 47213), -- Tall/Thin Medium - Xmas (Area: The Bulwark - Difficulty: 0)
+(@OGUID+51, 187235, 0, 85, 152, '0', 0, 0, 1772.07470703125, -718.11981201171875, 60.06526565551757812, 3.630291461944580078, 0, 0, -0.97029495239257812, 0.241925001144409179, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: The Bulwark - Difficulty: 0)
+(@OGUID+52, 187235, 0, 85, 152, '0', 0, 0, 1738.6910400390625, -740.513916015625, 60.06462860107421875, 2.932138919830322265, 0, 0, 0.994521141052246093, 0.104535527527332305, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: The Bulwark - Difficulty: 0)
+(@OGUID+53, 187235, 0, 85, 152, '0', 0, 0, 1696.01220703125, -692.57989501953125, 50.60410308837890625, 0.785396754741668701, 0, 0, 0.38268280029296875, 0.923879802227020263, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: The Bulwark - Difficulty: 0)
+(@OGUID+54, 187235, 0, 85, 152, '0', 0, 0, 1717.0103759765625, -690.59893798828125, 51.36687850952148437, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: The Bulwark - Difficulty: 0)
+(@OGUID+55, 187567, 0, 85, 152, '0', 0, 0, 1758.7916259765625, -731.092041015625, 62.84638214111328125, 1.535889506340026855, 0, 0, 0.694658279418945312, 0.719339847564697265, 120, 255, 1, 47213), -- Hanging, Streamer - Xmas (Area: The Bulwark - Difficulty: 0)
+(@OGUID+56, 187567, 0, 85, 152, '0', 0, 0, 1667.78125, -722.35418701171875, 65.4082794189453125, 1.029743075370788574, 0, 0, 0.492423057556152343, 0.870355963706970214, 120, 255, 1, 47213), -- Hanging, Streamer - Xmas (Area: The Bulwark - Difficulty: 0)
+-- Calston Estate
+(@OGUID+57, 187234, 0, 14046, 4916, '0', 0, 0, 2219.796875, 1026.3785400390625, 40.33202362060546875, 0.890116631984710693, 0, 0, 0.430510520935058593, 0.902585566043853759, 120, 255, 1, 47213), -- Tall/Thin Medium - Xmas (Area: Calston Estate - Difficulty: 0)
+(@OGUID+58, 187567, 0, 14046, 4916, '0', 0, 0, 2232.79345703125, 1025.4566650390625, 44.66791152954101562, 0.855210542678833007, 0, 0, 0.414692878723144531, 0.909961462020874023, 120, 255, 1, 47213), -- Hanging, Streamer - Xmas (Area: Calston Estate - Difficulty: 0)
+-- Deathknell
+(@OGUID+59, 187194, 0, 6454, 154, '0', 0, 0, 1860.689208984375, 1579.21533203125, 97.0259552001953125, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 47213), -- Hanging, Streamer x3 - Xmas (Area: Deathknell - Difficulty: 0)
+(@OGUID+60, 187194, 0, 6454, 154, '0', 0, 0, 1838.5, 1577.763916015625, 99.56858062744140625, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 47213), -- Hanging, Streamer x3 - Xmas (Area: Deathknell - Difficulty: 0)
+(@OGUID+61, 187234, 0, 6454, 154, '0', 0, 0, 1843.2552490234375, 1612.703125, 104.1179962158203125, 4.764749526977539062, 0, 0, -0.6883544921875, 0.725374460220336914, 120, 255, 1, 47213), -- Tall/Thin Medium - Xmas (Area: Deathknell - Difficulty: 0)
+(@OGUID+62, 187235, 0, 6454, 154, '0', 0, 0, 1848.173583984375, 1606.54345703125, 94.6925811767578125, 4.276057243347167968, 0, 0, -0.84339141845703125, 0.537299633026123046, 120, 255, 1, 47213); -- Standing, Exterior, Medium - Xmas (Area: Deathknell - Difficulty: 0)
+
+-- Event spawns
+DELETE FROM `game_event_creature` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @CGUID+0 AND @CGUID+4;
+INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES
+(@EVENT, @CGUID+0),
+(@EVENT, @CGUID+1),
+(@EVENT, @CGUID+2),
+(@EVENT, @CGUID+3),
+(@EVENT, @CGUID+4);
+
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @OGUID+0 AND @OGUID+62;
+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),
+(@EVENT, @OGUID+60),
+(@EVENT, @OGUID+61),
+(@EVENT, @OGUID+62);