DB/Valsharah: Added Love is in the Air spawns

1 files changed, 32 insertions, 0 deletions

diff --git a/sql/updates/world/master/2024_02_28_03_world.sql b/sql/updates/world/master/2024_02_28_03_world.sql
new file mode 100644
index 00000000000..377d69587f3
--- /dev/null
+++ b/sql/updates/world/master/2024_02_28_03_world.sql
@@ -0,0 +1,32 @@
+SET @OGUID := 9800046;
+SET @EVENT := 8;
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+10;
+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, 181060, 1220, 7558, 7677, '0', 0, 0, 2810.69091796875, 6745.3974609375, 211.3227386474609375, 1.116188526153564453, 0, 0, 0.529570579528808593, 0.848265886306762695, 120, 255, 1, 53262), -- Lovely Candle (Area: Temple of Elune - Difficulty: 0) CreateObject1
+(@OGUID+1, 181060, 1220, 7558, 7677, '0', 0, 0, 2807.197021484375, 6750.2568359375, 211.3520050048828125, 0.731604218482971191, 0, 0, 0.357698440551757812, 0.933837175369262695, 120, 255, 1, 53262), -- Lovely Candle (Area: Temple of Elune - Difficulty: 0) CreateObject1
+(@OGUID+2, 181060, 1220, 7558, 7677, '0', 0, 0, 2808.126708984375, 6745.4599609375, 210.692718505859375, 0.981835722923278808, 0, 0, 0.471435546875, 0.881900489330291748, 120, 255, 1, 53262), -- Lovely Candle (Area: Temple of Elune - Difficulty: 0) CreateObject1
+(@OGUID+3, 181060, 1220, 7558, 7677, '0', 0, 0, 2806.9697265625, 6747.80029296875, 210.8098297119140625, 0.83722090721130371, 0, 0, 0.406491279602050781, 0.913654685020446777, 120, 255, 1, 53262), -- Lovely Candle (Area: Temple of Elune - Difficulty: 0) CreateObject1
+(@OGUID+4, 181060, 1220, 7558, 7677, '0', 0, 0, 2813.07470703125, 6746.5458984375, 212.236328125, 1.239279389381408691, 0, 0, 0.58074188232421875, 0.814087748527526855, 120, 255, 1, 53262), -- Lovely Candle (Area: Temple of Elune - Difficulty: 0) CreateObject1
+(@OGUID+5, 181060, 1220, 7558, 7677, '0', 0, 0, 2809.1640625, 6751.775390625, 211.8814697265625, 0.75159996747970581, 0, 0, 0.367016792297363281, 0.930214345455169677, 120, 255, 1, 53262), -- Lovely Candle (Area: Temple of Elune - Difficulty: 0) CreateObject1
+(@OGUID+6, 181060, 1220, 7558, 7677, '0', 0, 0, 2811.963623046875, 6751.10400390625, 212.496490478515625, 0.985581398010253906, 0, 0, 0.473086357116699218, 0.881016075611114501, 120, 255, 1, 53262), -- Lovely Candle (Area: Temple of Elune - Difficulty: 0) CreateObject1
+(@OGUID+7, 181060, 1220, 7558, 7677, '0', 0, 0, 2813.342041015625, 6749.02001953125, 212.720733642578125, 1.187007427215576171, 0, 0, 0.559268951416015625, 0.828986287117004394, 120, 255, 1, 53262), -- Lovely Candle (Area: Temple of Elune - Difficulty: 0) CreateObject1
+(@OGUID+8, 411616, 1220, 7558, 7677, '0', 0, 0, 2809.861083984375, 6748.4228515625, 211.2455596923828125, 0, 0, 0, 0, 1, 120, 255, 1, 53262), -- Portal to Stormwind (Area: Temple of Elune - Difficulty: 0) CreateObject1
+(@OGUID+9, 414929, 1220, 7558, 7677, '0', 0, 0, 2809.861083984375, 6748.4228515625, 211.2455596923828125, 0, 0, 0, 0, 1, 120, 255, 1, 53262), -- Portal to Orgrimmar (Area: Temple of Elune - Difficulty: 0) CreateObject1
+(@OGUID+10, 415631, 1220, 7558, 7677, '0', 0, 0, 2810.1650390625, 6748.3818359375, 211.6234130859375, 1.073047757148742675, -0.04596233367919921, -0.05719757080078125, 0.508252143859863281, 0.858076751232147216, 120, 255, 1, 53262); -- Valentine Arch (x1.5) (Area: Temple of Elune - Difficulty: 0) CreateObject1
+
+-- Event spawns
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @OGUID+0 AND @OGUID+10;
+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);