DB/WesternPlaguelands: Added missing Hallow's End spawns (Scholomance)

1 files changed, 74 insertions, 0 deletions

diff --git a/sql/updates/world/master/2024_11_05_05_world.sql b/sql/updates/world/master/2024_11_05_05_world.sql
new file mode 100644
index 00000000000..d7766a23664
--- /dev/null
+++ b/sql/updates/world/master/2024_11_05_05_world.sql
@@ -0,0 +1,74 @@
+SET @OGUID := 3808497;
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+32;
+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, 180405, 0, 28, 2298, '0', 0, 0, 1255.0816650390625, -2592.901123046875, 98.19570159912109375, 5.288348197937011718, 0, 0, -0.4771585464477539, 0.878817260265350341, 120, 255, 1, 57388), -- G_Pumpkin_01 (Area: Caer Darrow - Difficulty: 0) CreateObject1
+(@OGUID+1, 180405, 0, 28, 2298, '0', 0, 0, 1177.8975830078125, -2558.61279296875, 74.29367828369140625, 4.642575740814208984, 0, 0, -0.731353759765625, 0.681998312473297119, 120, 255, 1, 57388), -- G_Pumpkin_01 (Area: Caer Darrow - Difficulty: 0) CreateObject1
+(@OGUID+2, 180405, 0, 28, 2298, '0', 0, 0, 1167.1805419921875, -2582.376708984375, 74.27860260009765625, 4.642575740814208984, 0, 0, -0.731353759765625, 0.681998312473297119, 120, 255, 1, 57388), -- G_Pumpkin_01 (Area: Caer Darrow - Difficulty: 0) CreateObject1
+(@OGUID+3, 180405, 0, 28, 2298, '0', 0, 0, 1198.7708740234375, -2607.35595703125, 79.6026611328125, 4.48549652099609375, 0, 0, -0.7826080322265625, 0.622514784336090087, 120, 255, 1, 57388), -- G_Pumpkin_01 (Area: Caer Darrow - Difficulty: 0) CreateObject1
+(@OGUID+4, 180405, 0, 28, 2298, '0', 0, 0, 1240.5555419921875, -2585.022705078125, 97.214385986328125, 5.497788906097412109, 0, 0, -0.38268280029296875, 0.923879802227020263, 120, 255, 1, 57388), -- G_Pumpkin_01 (Area: Caer Darrow - Difficulty: 0) CreateObject1
+(@OGUID+5, 180405, 0, 28, 2298, '0', 0, 0, 1139.796875, -2522.710205078125, 61.6352081298828125, 5.986480236053466796, 0, 0, -0.14780902862548828, 0.989015936851501464, 120, 255, 1, 57388), -- G_Pumpkin_01 (Area: Caer Darrow - Difficulty: 0) CreateObject1
+(@OGUID+6, 180405, 0, 28, 2298, '0', 0, 0, 1204.6007080078125, -2612.713623046875, 81.40390777587890625, 1.343901276588439941, 0, 0, 0.622513771057128906, 0.78260880708694458, 120, 255, 1, 57388), -- G_Pumpkin_01 (Area: Caer Darrow - Difficulty: 0) CreateObject1
+(@OGUID+7, 180405, 0, 28, 2298, '0', 0, 0, 1218.8072509765625, -2558.564208984375, 92.92095184326171875, 4.642575740814208984, 0, 0, -0.731353759765625, 0.681998312473297119, 120, 255, 1, 57388), -- G_Pumpkin_01 (Area: Caer Darrow - Difficulty: 0) CreateObject1
+(@OGUID+8, 180406, 0, 28, 2298, '0', 0, 0, 1223.18408203125, -2549.65283203125, 92.95278167724609375, 4.59021615982055664, 0, 0, -0.74895572662353515, 0.662620067596435546, 120, 255, 1, 57388), -- G_Pumpkin_02 (Area: Caer Darrow - Difficulty: 0) CreateObject1
+(@OGUID+9, 180406, 0, 28, 2298, '0', 0, 0, 1201.2117919921875, -2606.116455078125, 80.345245361328125, 3.543023586273193359, 0, 0, -0.97992420196533203, 0.199370384216308593, 120, 255, 1, 57388), -- G_Pumpkin_02 (Area: Caer Darrow - Difficulty: 0) CreateObject1
+(@OGUID+10, 180406, 0, 28, 2298, '0', 0, 0, 1249.232666015625, -2581.585205078125, 98.20404052734375, 5.619962215423583984, 0, 0, -0.32556724548339843, 0.945518851280212402, 120, 255, 1, 57388), -- G_Pumpkin_02 (Area: Caer Darrow - Difficulty: 0) CreateObject1
+(@OGUID+11, 180406, 0, 28, 2298, '0', 0, 0, 1199.9010009765625, -2613.54345703125, 79.16400146484375, 5.6897735595703125, 0, 0, -0.29237174987792968, 0.956304728984832763, 120, 255, 1, 57388), -- G_Pumpkin_02 (Area: Caer Darrow - Difficulty: 0) CreateObject1
+(@OGUID+12, 180406, 0, 28, 2298, '0', 0, 0, 1110.3038330078125, -2548.604248046875, 68.108123779296875, 4.886923789978027343, 0, 0, -0.64278697967529296, 0.766044974327087402, 120, 255, 1, 57388), -- G_Pumpkin_02 (Area: Caer Darrow - Difficulty: 0) CreateObject1
+(@OGUID+13, 180406, 0, 28, 2298, '0', 0, 0, 1132.9444580078125, -2514.970458984375, 61.14870071411132812, 5.6897735595703125, 0, 0, -0.29237174987792968, 0.956304728984832763, 120, 255, 1, 57388), -- G_Pumpkin_02 (Area: Caer Darrow - Difficulty: 0) CreateObject1
+(@OGUID+14, 180406, 0, 28, 2298, '0', 0, 0, 1170.7447509765625, -2574.670166015625, 74.29409027099609375, 4.59021615982055664, 0, 0, -0.74895572662353515, 0.662620067596435546, 120, 255, 1, 57388), -- G_Pumpkin_02 (Area: Caer Darrow - Difficulty: 0) CreateObject1
+(@OGUID+15, 180407, 0, 28, 2298, '0', 0, 0, 1198.6041259765625, -2610.572998046875, 78.86474609375, 5.078907966613769531, 0, 0, -0.56640625, 0.824126183986663818, 120, 255, 1, 57388), -- G_Pumpkin_03 (Area: Caer Darrow - Difficulty: 0) CreateObject1
+(@OGUID+16, 180407, 0, 28, 2298, '0', 0, 0, 1203.7899169921875, -2607.51220703125, 81.01184844970703125, 2.583080768585205078, 0, 0, 0.961260795593261718, 0.275640487670898437, 120, 255, 1, 57388), -- G_Pumpkin_03 (Area: Caer Darrow - Difficulty: 0) CreateObject1
+(@OGUID+17, 180407, 0, 28, 2298, '0', 0, 0, 1227.1597900390625, -2541.546875, 92.96691131591796875, 4.712389945983886718, 0, 0, -0.70710659027099609, 0.707106947898864746, 120, 255, 1, 57388), -- G_Pumpkin_03 (Area: Caer Darrow - Difficulty: 0) CreateObject1
+(@OGUID+18, 180407, 0, 28, 2298, '0', 0, 0, 1174.5572509765625, -2566.442626953125, 74.31658172607421875, 4.712389945983886718, 0, 0, -0.70710659027099609, 0.707106947898864746, 120, 255, 1, 57388), -- G_Pumpkin_03 (Area: Caer Darrow - Difficulty: 0) CreateObject1
+(@OGUID+19, 180407, 0, 28, 2298, '0', 0, 0, 1214.126708984375, -2567.37158203125, 93.15206146240234375, 4.712389945983886718, 0, 0, -0.70710659027099609, 0.707106947898864746, 120, 255, 1, 57388), -- G_Pumpkin_03 (Area: Caer Darrow - Difficulty: 0) CreateObject1
+(@OGUID+20, 180407, 0, 28, 2298, '0', 0, 0, 1247.185791015625, -2597.76220703125, 96.53269195556640625, 5.550147056579589843, 0, 0, -0.358367919921875, 0.933580458164215087, 120, 255, 1, 57388), -- G_Pumpkin_03 (Area: Caer Darrow - Difficulty: 0) CreateObject1
+(@OGUID+21, 180426, 0, 28, 2298, '0', 0, 0, 1188.09033203125, -2611.007080078125, 107.815032958984375, 1.640606880187988281, 0, 0, 0.731352806091308593, 0.6819993257522583, 120, 255, 1, 57388), -- Bat01 (Area: Caer Darrow - Difficulty: 0) CreateObject1
+(@OGUID+22, 180426, 0, 28, 2298, '0', 0, 0, 1179.28125, -2611.265625, 101.0729827880859375, 2.094393253326416015, 0, 0, 0.866024971008300781, 0.50000077486038208, 120, 255, 1, 57388), -- Bat01 (Area: Caer Darrow - Difficulty: 0) CreateObject1
+(@OGUID+23, 180426, 0, 28, 2298, '0', 0, 0, 1182.71533203125, -2581.9375, 106.422332763671875, 0.052358884364366531, 0, 0, 0.02617645263671875, 0.999657332897186279, 120, 255, 1, 57388), -- Bat01 (Area: Caer Darrow - Difficulty: 0) CreateObject1
+(@OGUID+24, 180426, 0, 28, 2298, '0', 0, 0, 1191.57470703125, -2597.390625, 95.70162200927734375, 2.094393253326416015, 0, 0, 0.866024971008300781, 0.50000077486038208, 120, 255, 1, 57388), -- Bat01 (Area: Caer Darrow - Difficulty: 0) CreateObject1
+(@OGUID+25, 180426, 0, 28, 2298, '0', 0, 0, 1168.3367919921875, -2602.05908203125, 94.45709228515625, 2.094393253326416015, 0, 0, 0.866024971008300781, 0.50000077486038208, 120, 255, 1, 57388), -- Bat01 (Area: Caer Darrow - Difficulty: 0) CreateObject1
+(@OGUID+26, 180426, 0, 28, 2298, '0', 0, 0, 1186.3819580078125, -2598.84033203125, 106.3577499389648437, 1.762782454490661621, 0, 0, 0.771624565124511718, 0.636078238487243652, 120, 255, 1, 57388), -- Bat01 (Area: Caer Darrow - Difficulty: 0) CreateObject1
+(@OGUID+27, 180427, 0, 28, 2298, '0', 0, 0, 1181.6632080078125, -2610.35595703125, 111.7726364135742187, 3.124123096466064453, 0, 0, 0.99996185302734375, 0.008734640665352344, 120, 255, 1, 57388), -- Bat02 (Area: Caer Darrow - Difficulty: 0) CreateObject1
+(@OGUID+28, 180427, 0, 28, 2298, '0', 0, 0, 1174.2083740234375, -2596.7275390625, 85.554840087890625, 3.612837791442871093, 0, 0, -0.97236919403076171, 0.233448356389999389, 120, 255, 1, 57388), -- Bat02 (Area: Caer Darrow - Difficulty: 0) CreateObject1
+(@OGUID+29, 180427, 0, 28, 2298, '0', 0, 0, 1195.8055419921875, -2607.51904296875, 118.358551025390625, 3.560472726821899414, 0, 0, -0.97814750671386718, 0.207912087440490722, 120, 255, 1, 57388), -- Bat02 (Area: Caer Darrow - Difficulty: 0) CreateObject1
+(@OGUID+30, 180427, 0, 28, 2298, '0', 0, 0, 1191.8021240234375, -2607.491455078125, 99.16400909423828125, 2.809975385665893554, 0, 0, 0.986285209655761718, 0.165049895644187927, 120, 255, 1, 57388), -- Bat02 (Area: Caer Darrow - Difficulty: 0) CreateObject1
+(@OGUID+31, 180427, 0, 28, 2298, '0', 0, 0, 1188.4913330078125, -2592.944580078125, 102.7464370727539062, 2.478367090225219726, 0, 0, 0.94551849365234375, 0.325568377971649169, 120, 255, 1, 57388), -- Bat02 (Area: Caer Darrow - Difficulty: 0) CreateObject1
+(@OGUID+32, 180427, 0, 28, 2298, '0', 0, 0, 1199.1875, -2596.32470703125, 115.97601318359375, 5.95157480239868164, 0, 0, -0.16504669189453125, 0.986285746097564697, 120, 255, 1, 57388); -- Bat02 (Area: Caer Darrow - Difficulty: 0) CreateObject1
+
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+32;
+INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES
+(12, @OGUID+0),
+(12, @OGUID+1),
+(12, @OGUID+2),
+(12, @OGUID+3),
+(12, @OGUID+4),
+(12, @OGUID+5),
+(12, @OGUID+6),
+(12, @OGUID+7),
+(12, @OGUID+8),
+(12, @OGUID+9),
+(12, @OGUID+10),
+(12, @OGUID+11),
+(12, @OGUID+12),
+(12, @OGUID+13),
+(12, @OGUID+14),
+(12, @OGUID+15),
+(12, @OGUID+16),
+(12, @OGUID+17),
+(12, @OGUID+18),
+(12, @OGUID+19),
+(12, @OGUID+20),
+(12, @OGUID+21),
+(12, @OGUID+22),
+(12, @OGUID+23),
+(12, @OGUID+24),
+(12, @OGUID+25),
+(12, @OGUID+26),
+(12, @OGUID+27),
+(12, @OGUID+28),
+(12, @OGUID+29),
+(12, @OGUID+30),
+(12, @OGUID+31),
+(12, @OGUID+32);