DB/Winterspring: Added Love is in the Air spawns

1 files changed, 40 insertions, 0 deletions

diff --git a/sql/updates/world/master/2024_02_28_01_world.sql b/sql/updates/world/master/2024_02_28_01_world.sql
new file mode 100644
index 00000000000..55a18c1d837
--- /dev/null
+++ b/sql/updates/world/master/2024_02_28_01_world.sql
@@ -0,0 +1,40 @@
+SET @OGUID := 9800019;
+SET @EVENT := 8;
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+14;
+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, 1, 618, 2246, '0', 0, 0, 6886.07568359375, -2376.053955078125, 556.484375, 3.517868995666503906, 0, 0, -0.98235416412353515, 0.187030211091041564, 120, 255, 1, 53262), -- Lovely Candle (Area: Frostfire Hot Springs - Difficulty: 0) CreateObject1
+(@OGUID+1, 181060, 1, 618, 2246, '0', 0, 0, 6887.08349609375, -2382.9375, 556.888916015625, 3.010171413421630859, 0, 0, 0.997841835021972656, 0.065663389861583709, 120, 255, 1, 53262), -- Lovely Candle (Area: Frostfire Hot Springs - Difficulty: 0) CreateObject1
+(@OGUID+2, 181060, 1, 618, 2246, '0', 0, 0, 6890.12255859375, -2379.11279296875, 558.828125, 3.260446548461914062, 0, 0, -0.99823474884033203, 0.059391941875219345, 120, 255, 1, 53262), -- Lovely Candle (Area: Frostfire Hot Springs - Difficulty: 0) CreateObject1
+(@OGUID+3, 181060, 1, 618, 2246, '0', 0, 0, 6883.3349609375, -2379.866455078125, 555.71527099609375, 3.264177560806274414, 0, 0, -0.99812221527099609, 0.061254002153873443, 120, 255, 1, 53262), -- Lovely Candle (Area: Frostfire Hot Springs - Difficulty: 0) CreateObject1
+(@OGUID+4, 181060, 1, 618, 2246, '0', 0, 0, 6889.095703125, -2381.507080078125, 557.93231201171875, 3.115680694580078125, 0, 0, 0.99991607666015625, 0.012955565936863422, 120, 255, 1, 53262), -- Lovely Candle (Area: Frostfire Hot Springs - Difficulty: 0) CreateObject1
+(@OGUID+5, 181060, 1, 618, 2246, '0', 0, 0, 6884.64599609375, -2382.428955078125, 556.11572265625, 3.030164003372192382, 0, 0, 0.998448371887207031, 0.055685475468635559, 120, 255, 1, 53262), -- Lovely Candle (Area: Frostfire Hot Springs - Difficulty: 0) CreateObject1
+(@OGUID+6, 181060, 1, 618, 2246, '0', 0, 0, 6888.50244140625, -2377.114501953125, 557.640625, 3.394780397415161132, 0, 0, -0.99199771881103515, 0.126255884766578674, 120, 255, 1, 53262), -- Lovely Candle (Area: Frostfire Hot Springs - Difficulty: 0) CreateObject1
+(@OGUID+7, 181060, 1, 618, 2246, '0', 0, 0, 6884.0234375, -2377.46875, 555.89068603515625, 3.46560072898864746, 0, 0, -0.98690605163574218, 0.161296233534812927, 120, 255, 1, 53262), -- Lovely Candle (Area: Frostfire Hot Springs - Difficulty: 0) CreateObject1
+(@OGUID+8, 187266, 1, 618, 2246, '0', 0, 0, 6871.22900390625, -2407.257080078125, 553.12481689453125, 2.229541301727294921, -0.15789794921875, -0.02077198028564453, 0.891504287719726562, 0.424095392227172851, 120, 255, 1, 53262), -- Romantic Blanket (Area: Frostfire Hot Springs - Difficulty: 0) CreateObject1
+(@OGUID+9, 187266, 1, 618, 2246, '0', 0, 0, 6879.13525390625, -2373.427001953125, 555.6219482421875, 2.557805538177490234, -0.07586669921875, -0.07475757598876953, 0.953624725341796875, 0.281523466110229492, 120, 255, 1, 53262), -- Romantic Blanket (Area: Frostfire Hot Springs - Difficulty: 0) CreateObject1
+(@OGUID+10, 335930, 1, 618, 2246, '0', 0, 0, 6879.11376953125, -2374.84375, 555.61846923828125, 2.279323101043701171, 0, 0, 0.908492088317871093, 0.417902082204818725, 120, 255, 1, 53262), -- Picnic Basket (scale x0.75) (Area: Frostfire Hot Springs - Difficulty: 0) CreateObject1
+(@OGUID+11, 335930, 1, 618, 2246, '0', 0, 0, 6872.02001953125, -2408.015625, 553.46435546875, 1.795279145240783691, 0, 0, 0.781857490539550781, 0.623457193374633789, 120, 255, 1, 53262), -- Picnic Basket (scale x0.75) (Area: Frostfire Hot Springs - Difficulty: 0) CreateObject1
+(@OGUID+12, 411616, 1, 618, 2246, '0', 0, 0, 6886.6884765625, -2379.50341796875, 556.30029296875, 2.278584003448486328, 0, 0, 0.908337593078613281, 0.418237745761871337, 120, 255, 1, 53262), -- Portal to Stormwind (Area: Frostfire Hot Springs - Difficulty: 0) CreateObject1
+(@OGUID+13, 414929, 1, 618, 2246, '0', 0, 0, 6886.6884765625, -2379.50341796875, 556.30029296875, 2.278584003448486328, 0, 0, 0.908337593078613281, 0.418237745761871337, 120, 255, 1, 53262), -- Portal to Orgrimmar (Area: Frostfire Hot Springs - Difficulty: 0) CreateObject1
+(@OGUID+14, 415631, 1, 618, 2246, '0', 0, 0, 6887.04931640625, -2379.489501953125, 556.6309814453125, 3.298957347869873046, 0.131905555725097656, -0.00875473022460937, -0.98835182189941406, 0.075398750603199005, 120, 255, 1, 53262); -- Valentine Arch (x1.5) (Area: Frostfire Hot Springs - Difficulty: 0) CreateObject1
+
+-- Event spawns
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @OGUID+0 AND @OGUID+14;
+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);