DB/DalaranBrokenIsles: Added Day of the Dead spawns

Ref #28478

1 files changed, 119 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_11_10_11_world_dalaran_legion.sql b/sql/updates/world/master/2022_11_10_11_world_dalaran_legion.sql
new file mode 100644
index 00000000000..138afa58154
--- /dev/null
+++ b/sql/updates/world/master/2022_11_10_11_world_dalaran_legion.sql
@@ -0,0 +1,119 @@
+SET @CGUID := 651513;
+SET @OGUID := 400428;
+
+-- Creature spawns
+DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+11;
+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, 34382, 1220, 7502, 7581, '0', 0, 0, 0, 1, -799.23614501953125, 4594.18408203125, 728.5025634765625, 4.468042850494384765, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Chapman (Area: Dalaran City - Difficulty: 0)
+(@CGUID+1, 34383, 1220, 7502, 7581, '0', 0, 0, 0, 1, -797.0867919921875, 4591.38916015625, 728.98388671875, 3.909537553787231445, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Catrina (Area: Dalaran City - Difficulty: 0)
+(@CGUID+2, 35254, 1220, 7502, 0, '0', 0, 0, 0, 0, -788.8680419921875, 4593.28466796875, 728.3111572265625, 4.066617012023925781, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Ghostly Dalaran Celebrant (Area: 0 - Difficulty: 0) (Auras: 4986 - Unseen, 33900 - Shroud of Death)
+(@CGUID+3, 35254, 1220, 7502, 0, '0', 0, 0, 0, 0, -800.70489501953125, 4598.42041015625, 728.11053466796875, 5.445427417755126953, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Ghostly Dalaran Celebrant (Area: 0 - Difficulty: 0) (Auras: 4986 - Unseen, 33900 - Shroud of Death)
+(@CGUID+4, 35254, 1220, 7502, 0, '0', 0, 0, 0, 0, -801.576416015625, 4600.76220703125, 727.95977783203125, 4.939281940460205078, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Ghostly Dalaran Celebrant (Area: 0 - Difficulty: 0) (Auras: 4986 - Unseen, 33900 - Shroud of Death)
+(@CGUID+5, 35254, 1220, 7502, 0, '0', 0, 0, 0, 0, -798.55902099609375, 4602.8349609375, 728.0391845703125, 4.590215682983398437, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Ghostly Dalaran Celebrant (Area: 0 - Difficulty: 0) (Auras: 4986 - Unseen, 33900 - Shroud of Death)
+(@CGUID+6, 35254, 1220, 7502, 0, '0', 0, 0, 0, 0, -795.04168701171875, 4590.35791015625, 728.670654296875, 3.31612563133239746, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Ghostly Dalaran Celebrant (Area: 0 - Difficulty: 0) (Auras: 4986 - Unseen, 33900 - Shroud of Death)
+(@CGUID+7, 35254, 1220, 7502, 0, '0', 0, 0, 0, 0, -794.72222900390625, 4597.8125, 728.8067626953125, 4.15388345718383789, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Ghostly Dalaran Celebrant (Area: 0 - Difficulty: 0) (Auras: 4986 - Unseen, 33900 - Shroud of Death)
+(@CGUID+8, 35254, 1220, 7502, 0, '0', 0, 0, 0, 0, -792.96875, 4591.875, 728.75323486328125, 6.038839340209960937, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Ghostly Dalaran Celebrant (Area: 0 - Difficulty: 0) (Auras: 4986 - Unseen, 33900 - Shroud of Death)
+(@CGUID+9, 35254, 1220, 7502, 0, '0', 0, 0, 0, 0, -799.1319580078125, 4597.8662109375, 728.3209228515625, 3.106686115264892578, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Ghostly Dalaran Celebrant (Area: 0 - Difficulty: 0) (Auras: 4986 - Unseen, 33900 - Shroud of Death)
+(@CGUID+10, 35254, 1220, 7502, 0, '0', 0, 0, 0, 0, -791.232666015625, 4591.015625, 728.45733642578125, 2.548180580139160156, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Ghostly Dalaran Celebrant (Area: 0 - Difficulty: 0) (Auras: 4986 - Unseen, 33900 - Shroud of Death)
+(@CGUID+11, 35256, 1220, 7502, 0, '0', 0, 0, 0, 0, -793.74652099609375, 4594.42529296875, 729.08734130859375, 3.787364482879638671, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366); -- Cheerful Dalaran Spirit (Area: 0 - Difficulty: 0) (Auras: 4986 - Unseen, 33900 - Shroud of Death)
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+38;
+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, 180338, 1220, 7502, 7581, '0', 0, 0, -792.62152099609375, 4594.51220703125, 728.85382080078125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: Dalaran City - Difficulty: 0)
+(@OGUID+1, 180338, 1220, 7502, 7581, '0', 0, 0, -793.857666015625, 4591.10791015625, 728.62579345703125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: Dalaran City - Difficulty: 0)
+(@OGUID+2, 180338, 1220, 7502, 7581, '0', 0, 0, -793.3194580078125, 4590.48095703125, 729.4803466796875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: Dalaran City - Difficulty: 0)
+(@OGUID+3, 180338, 1220, 7502, 7581, '0', 0, 0, -791.32293701171875, 4592.71728515625, 728.57537841796875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: Dalaran City - Difficulty: 0)
+(@OGUID+4, 180338, 1220, 7502, 7581, '0', 0, 0, -797.20489501953125, 4596.2568359375, 728.559814453125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: Dalaran City - Difficulty: 0)
+(@OGUID+5, 180338, 1220, 7502, 7581, '0', 0, 0, -794.2430419921875, 4594.9931640625, 728.96014404296875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: Dalaran City - Difficulty: 0)
+(@OGUID+6, 180338, 1220, 7502, 7581, '0', 0, 0, -794.80206298828125, 4595.88916015625, 728.84796142578125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: Dalaran City - Difficulty: 0)
+(@OGUID+7, 180338, 1220, 7502, 7581, '0', 0, 0, -791.62152099609375, 4594.58154296875, 728.72052001953125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: Dalaran City - Difficulty: 0)
+(@OGUID+8, 180338, 1220, 7502, 7581, '0', 0, 0, -797.7882080078125, 4598.7880859375, 728.32061767578125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: Dalaran City - Difficulty: 0)
+(@OGUID+9, 180338, 1220, 7502, 7581, '0', 0, 0, -797.263916015625, 4598.48095703125, 728.39923095703125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: Dalaran City - Difficulty: 0)
+(@OGUID+10, 180338, 1220, 7502, 7581, '0', 0, 0, -796.73614501953125, 4595.67041015625, 728.65167236328125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: Dalaran City - Difficulty: 0)
+(@OGUID+11, 180338, 1220, 7502, 7581, '0', 0, 0, -799.763916015625, 4599.79541015625, 728.0347900390625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: Dalaran City - Difficulty: 0)
+(@OGUID+12, 180339, 1220, 7502, 7581, '0', 0, 0, -793.82293701171875, 4590.66845703125, 728.55145263671875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 02 (Area: Dalaran City - Difficulty: 0)
+(@OGUID+13, 180339, 1220, 7502, 7581, '0', 0, 0, -797.62152099609375, 4598.40283203125, 728.36553955078125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 02 (Area: Dalaran City - Difficulty: 0)
+(@OGUID+14, 180340, 1220, 7502, 7581, '0', 0, 0, -793.25347900390625, 4590.875, 729.63885498046875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 03 (Area: Dalaran City - Difficulty: 0)
+(@OGUID+15, 180340, 1220, 7502, 7581, '0', 0, 0, -792.90625, 4592.69091796875, 728.7965087890625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 03 (Area: Dalaran City - Difficulty: 0)
+(@OGUID+16, 180340, 1220, 7502, 7581, '0', 0, 0, -797.420166015625, 4595.62841796875, 728.57989501953125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 03 (Area: Dalaran City - Difficulty: 0)
+(@OGUID+17, 180885, 1220, 7502, 7581, '0', 0, 0, -800.4930419921875, 4595.76416015625, 728.14215087890625, 0.750490784645080566, 0, 0, 0.3665008544921875, 0.93041771650314331, 120, 255, 1, 46366), -- InnTableTiny (Area: Dalaran City - Difficulty: 0)
+(@OGUID+18, 182807, 1220, 7502, 7581, '0', 0, 0, -793.3367919921875, 4593.6806640625, 728.9364013671875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bottle (Area: Dalaran City - Difficulty: 0)
+(@OGUID+19, 182807, 1220, 7502, 7581, '0', 0, 0, -799.59722900390625, 4599.3369140625, 728.08477783203125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bottle (Area: Dalaran City - Difficulty: 0)
+(@OGUID+20, 195063, 1220, 7502, 7581, '0', 0, 0, -792.2117919921875, 4592.88916015625, 728.72125244140625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Orange Marigolds (Area: Dalaran City - Difficulty: 0)
+(@OGUID+21, 195063, 1220, 7502, 7581, '0', 0, 0, -792.51739501953125, 4594.1025390625, 728.83282470703125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Orange Marigolds (Area: Dalaran City - Difficulty: 0)
+(@OGUID+22, 195063, 1220, 7502, 7581, '0', 0, 0, -799.28125, 4599.796875, 728.08740234375, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Orange Marigolds (Area: Dalaran City - Difficulty: 0)
+(@OGUID+23, 195063, 1220, 7502, 7581, '0', 0, 0, -800.5694580078125, 4596.265625, 729.2236328125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Orange Marigolds (Area: Dalaran City - Difficulty: 0)
+(@OGUID+24, 195063, 1220, 7502, 7581, '0', 0, 0, -797.05206298828125, 4595.83154296875, 728.60595703125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Orange Marigolds (Area: Dalaran City - Difficulty: 0)
+(@OGUID+25, 195063, 1220, 7502, 7581, '0', 0, 0, -800.08331298828125, 4600.08154296875, 727.97998046875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Orange Marigolds (Area: Dalaran City - Difficulty: 0)
+(@OGUID+26, 195066, 1220, 7502, 7581, '0', 0, 0, -792.64239501953125, 4593.43408203125, 728.81646728515625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bread of the Dead (Area: Dalaran City - Difficulty: 0)
+(@OGUID+27, 195066, 1220, 7502, 7581, '0', 0, 0, -797.31597900390625, 4599.18603515625, 729.01422119140625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bread of the Dead (Area: Dalaran City - Difficulty: 0)
+(@OGUID+28, 195067, 1220, 7502, 7581, '0', 0, 0, -794.8194580078125, 4595.21728515625, 728.89263916015625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Mixed Fruit Bowl (Area: Dalaran City - Difficulty: 0)
+(@OGUID+29, 195068, 1220, 7502, 7581, '0', 0, 0, -792.670166015625, 4593.42041015625, 728.82012939453125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Offering Bowl (Area: Dalaran City - Difficulty: 0)
+(@OGUID+30, 195068, 1220, 7502, 7581, '0', 0, 0, -797.32293701171875, 4599.17529296875, 729.0040283203125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Offering Bowl (Area: Dalaran City - Difficulty: 0)
+(@OGUID+31, 195069, 1220, 7502, 7581, '0', 0, 0, -801.0555419921875, 4595.81591796875, 729.25421142578125, 6.12610626220703125, 0, 0, -0.07845878601074218, 0.996917366981506347, 120, 255, 1, 46366), -- Candy Skulls (Area: Dalaran City - Difficulty: 0)
+(@OGUID+32, 195069, 1220, 7502, 7581, '0', 0, 0, -800.02777099609375, 4595.69091796875, 729.25811767578125, 2.548179388046264648, 0, 0, 0.956304550170898437, 0.292372345924377441, 120, 255, 1, 46366), -- Candy Skulls (Area: Dalaran City - Difficulty: 0)
+(@OGUID+33, 195069, 1220, 7502, 7581, '0', 0, 0, -800.5242919921875, 4595.22216796875, 729.2568359375, 5.393068790435791015, 0, 0, -0.43051052093505859, 0.902585566043853759, 120, 255, 1, 46366), -- Candy Skulls (Area: Dalaran City - Difficulty: 0)
+(@OGUID+34, 195087, 1220, 7502, 7581, '0', 0, 0, -797.38543701171875, 4593.79345703125, 728.6734619140625, 2.548179388046264648, 0, 0, 0.956304550170898437, 0.292372345924377441, 120, 255, 1, 46366), -- Ghostly Cooking Fire (Area: Dalaran City - Difficulty: 0)
+(@OGUID+35, 195090, 1220, 7502, 7581, '0', 0, 0, -791.6319580078125, 4593.625, 728.67120361328125, 3.263772249221801757, 0, 0, -0.99813461303710937, 0.061051756143569946, 120, 255, 1, 46366), -- Spirit Candle (Area: Dalaran City - Difficulty: 0)
+(@OGUID+36, 195090, 1220, 7502, 7581, '0', 0, 0, -796.66668701171875, 4596.21728515625, 729.5350341796875, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 46366), -- Spirit Candle (Area: Dalaran City - Difficulty: 0)
+(@OGUID+37, 195307, 1220, 7502, 7581, '0', 0, 0, -796.46527099609375, 4596.07666015625, 729.6492919921875, 3.001946926116943359, 0, 0, 0.997563362121582031, 0.069766148924827575, 120, 255, 1, 46366), -- Orange Marigolds (Area: Dalaran City - Difficulty: 0)
+(@OGUID+38, 195307, 1220, 7502, 7581, '0', 0, 0, -800.125, 4595.35791015625, 729.24786376953125, 3.9793548583984375, 0, 0, -0.9135446548461914, 0.406738430261611938, 120, 255, 1, 46366); -- Orange Marigolds (Area: Dalaran City - Difficulty: 0)
+
+-- Event spawns
+DELETE FROM `game_event_creature` WHERE `eventEntry`=51 AND `guid` BETWEEN @CGUID+0 AND @CGUID+11;
+INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES
+(51, @CGUID+0), 
+(51, @CGUID+1), 
+(51, @CGUID+2), 
+(51, @CGUID+3), 
+(51, @CGUID+4), 
+(51, @CGUID+5), 
+(51, @CGUID+6), 
+(51, @CGUID+7), 
+(51, @CGUID+8), 
+(51, @CGUID+9), 
+(51, @CGUID+10),
+(51, @CGUID+11);
+
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=51 AND `guid` BETWEEN @OGUID+0 AND @OGUID+38;
+INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES
+(51, @OGUID+0),
+(51, @OGUID+1),
+(51, @OGUID+2),
+(51, @OGUID+3),
+(51, @OGUID+4),
+(51, @OGUID+5),
+(51, @OGUID+6),
+(51, @OGUID+7),
+(51, @OGUID+8),
+(51, @OGUID+9),
+(51, @OGUID+10),
+(51, @OGUID+11),
+(51, @OGUID+12),
+(51, @OGUID+13),
+(51, @OGUID+14),
+(51, @OGUID+15),
+(51, @OGUID+16),
+(51, @OGUID+17),
+(51, @OGUID+18),
+(51, @OGUID+19),
+(51, @OGUID+20),
+(51, @OGUID+21),
+(51, @OGUID+22),
+(51, @OGUID+23),
+(51, @OGUID+24),
+(51, @OGUID+25),
+(51, @OGUID+26),
+(51, @OGUID+27),
+(51, @OGUID+28),
+(51, @OGUID+29),
+(51, @OGUID+30),
+(51, @OGUID+31),
+(51, @OGUID+32),
+(51, @OGUID+33),
+(51, @OGUID+34),
+(51, @OGUID+35),
+(51, @OGUID+36),
+(51, @OGUID+37),
+(51, @OGUID+38);