DB/Uldum: Added Hallows End spawns

Ref #28449

2 files changed, 259 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_11_12_15_world_uldum_oasis_of_virsar.sql b/sql/updates/world/master/2022_11_12_15_world_uldum_oasis_of_virsar.sql
new file mode 100644
index 00000000000..c4d71c6a3ba
--- /dev/null
+++ b/sql/updates/world/master/2022_11_12_15_world_uldum_oasis_of_virsar.sql
@@ -0,0 +1,71 @@
+SET @OGUID := 248107;
+
+-- Gameobject templates
+UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=46366 WHERE `entry`=208178; -- Candy Bucket
+
+UPDATE `gameobject_template_addon` SET `faction`=35 WHERE `entry`=208178; -- Candy Bucket
+
+-- Quests
+UPDATE `quest_offer_reward` SET `VerifiedBuild`=46366 WHERE `ID`=29016;
+
+DELETE FROM `gameobject_queststarter` WHERE `id`=208178;
+INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
+(208178, 29016, 46366);
+
+UPDATE `gameobject_questender` SET `VerifiedBuild`=46366 WHERE (`id`=208178 AND `quest`=29016);
+
+DELETE FROM `game_event_gameobject_quest` WHERE `id`=208178;
+
+-- Old gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 227944 AND 227981;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 227944 AND 227981;
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+20;
+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, 1, 5034, 5670, '0', 0, 0, -8351.7412109375, 793.748291015625, 151.393096923828125, 1.396261811256408691, 0, 0, 0.642786979675292968, 0.766044974327087402, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Oasis of Vir'sar - Difficulty: 0)
+(@OGUID+1, 180406, 1, 5034, 5670, '0', 0, 0, -8330.091796875, 777.4913330078125, 153.266876220703125, 4.537858963012695312, 0, 0, -0.76604366302490234, 0.642788589000701904, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Oasis of Vir'sar - Difficulty: 0)
+(@OGUID+2, 180407, 1, 5034, 5670, '0', 0, 0, -8341.8076171875, 762.5242919921875, 152.337432861328125, 4.345870018005371093, 0, 0, -0.82412624359130859, 0.566406130790710449, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Oasis of Vir'sar - Difficulty: 0)
+(@OGUID+3, 180410, 1, 5034, 5670, '0', 0, 0, -8353.4033203125, 790.16668701171875, 152.741455078125, 5.864306926727294921, 0, 0, -0.20791149139404296, 0.978147625923156738, 120, 255, 1, 46366), -- G_HangingSkeleton_01 (Area: Oasis of Vir'sar - Difficulty: 0)
+(@OGUID+4, 180415, 1, 5034, 5670, '0', 0, 0, -8344.8212890625, 802.84375, 152.3376922607421875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Oasis of Vir'sar - Difficulty: 0)
+(@OGUID+5, 180415, 1, 5034, 5670, '0', 0, 0, -8348.2861328125, 799.77081298828125, 152.1962738037109375, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Oasis of Vir'sar - Difficulty: 0)
+(@OGUID+6, 180415, 1, 5034, 5670, '0', 0, 0, -8347.357421875, 800.78125, 151.5987091064453125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Oasis of Vir'sar - Difficulty: 0)
+(@OGUID+7, 180415, 1, 5034, 5670, '0', 0, 0, -8328.39453125, 789.57464599609375, 153.7097015380859375, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Oasis of Vir'sar - Difficulty: 0)
+(@OGUID+8, 180426, 1, 5034, 5670, '0', 0, 0, -8357.5380859375, 776.5086669921875, 151.1910400390625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Oasis of Vir'sar - Difficulty: 0)
+(@OGUID+9, 180426, 1, 5034, 5670, '0', 0, 0, -8345.48828125, 778.75177001953125, 152.2094268798828125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Oasis of Vir'sar - Difficulty: 0)
+(@OGUID+10, 180426, 1, 5034, 5670, '0', 0, 0, -8336.654296875, 786.87847900390625, 152.3829803466796875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Oasis of Vir'sar - Difficulty: 0)
+(@OGUID+11, 180426, 1, 5034, 5670, '0', 0, 0, -8331.03515625, 792.77777099609375, 152.2923126220703125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Oasis of Vir'sar - Difficulty: 0)
+(@OGUID+12, 180427, 1, 5034, 5670, '0', 0, 0, -8347.6318359375, 769.779541015625, 152.0199737548828125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Oasis of Vir'sar - Difficulty: 0)
+(@OGUID+13, 180427, 1, 5034, 5670, '0', 0, 0, -8348.3095703125, 772.295166015625, 151.9667510986328125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Oasis of Vir'sar - Difficulty: 0)
+(@OGUID+14, 180427, 1, 5034, 5670, '0', 0, 0, -8332.638671875, 784.5555419921875, 152.713165283203125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Oasis of Vir'sar - Difficulty: 0)
+(@OGUID+15, 180453, 1, 5034, 5670, '0', 0, 0, -8323.091796875, 726.4375, -68.7809600830078125, 0.802850961685180664, 0, 0, 0.390730857849121093, 0.920504987239837646, 120, 255, 1, 46366), -- Hive'Regal Glyphed Crystal (Area: Oasis of Vir'sar - Difficulty: 0)
+(@OGUID+16, 180471, 1, 5034, 5670, '0', 0, 0, -8343.2158203125, 805.47393798828125, 153.664886474609375, 0.436331570148468017, 0, 0, 0.216439247131347656, 0.976296067237854003, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Oasis of Vir'sar - Difficulty: 0)
+(@OGUID+17, 180471, 1, 5034, 5670, '0', 0, 0, -8343.03125, 806.140625, 153.6729736328125, 1.623155713081359863, 0, 0, 0.725374221801757812, 0.688354730606079101, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Oasis of Vir'sar - Difficulty: 0)
+(@OGUID+18, 180472, 1, 5034, 5670, '0', 0, 0, -8348.7158203125, 801.57293701171875, 154.4049835205078125, 6.12610626220703125, 0, 0, -0.07845878601074218, 0.996917366981506347, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Oasis of Vir'sar - Difficulty: 0)
+(@OGUID+19, 180523, 1, 5034, 5670, '0', 0, 0, -8333.017578125, 792.58856201171875, 152.48291015625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Apple Bob (Area: Oasis of Vir'sar - Difficulty: 0)
+(@OGUID+20, 208178, 1, 5034, 5670, '0', 0, 0, -8327.9931640625, 795.092041015625, 152.361541748046875, 5.044002056121826171, 0, 0, -0.58070278167724609, 0.814115643501281738, 120, 255, 1, 46366); -- Candy Bucket (Area: Oasis of Vir'sar - Difficulty: 0)
+
+-- Event spawns
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+20;
+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);
diff --git a/sql/updates/world/master/2022_11_12_16_world_uldum_ramkahen.sql b/sql/updates/world/master/2022_11_12_16_world_uldum_ramkahen.sql
new file mode 100644
index 00000000000..fc1ffcfba9b
--- /dev/null
+++ b/sql/updates/world/master/2022_11_12_16_world_uldum_ramkahen.sql
@@ -0,0 +1,188 @@
+SET @OGUID := 248128;
+
+-- Gameobject templates
+UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=46366 WHERE `entry`=208179; -- Candy Bucket
+
+UPDATE `gameobject_template_addon` SET `faction`=35 WHERE `entry`=208179; -- Candy Bucket
+
+-- Quests
+UPDATE `quest_offer_reward` SET `VerifiedBuild`=46366 WHERE `ID`=29017;
+
+DELETE FROM `gameobject_queststarter` WHERE `id`=208179;
+INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
+(208179, 29017, 46366);
+
+UPDATE `gameobject_questender` SET `VerifiedBuild`=46366 WHERE (`id`=208179 AND `quest`=29017);
+
+DELETE FROM `game_event_gameobject_quest` WHERE `id`=208179;
+
+-- Old gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 227982 AND 228057;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 227982 AND 228057;
+DELETE FROM `game_event_gameobject` WHERE `guid`=39519;
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+78;
+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, 1, 5034, 5466, '0', 0, 0, -9434.7158203125, -986.45831298828125, 111.01171875, 5.183629035949707031, 0, 0, -0.52249813079833984, 0.852640450000762939, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+1, 180405, 1, 5034, 5466, '0', 0, 0, -9420.716796875, -953.89410400390625, 114.2311935424804687, 5.183629035949707031, 0, 0, -0.52249813079833984, 0.852640450000762939, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+2, 180405, 1, 5034, 5466, '0', 0, 0, -9475.9375, -1013.65447998046875, 109.2133636474609375, 5.026549339294433593, 0, 0, -0.5877847671508789, 0.809017360210418701, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+3, 180405, 1, 5034, 5466, '0', 0, 0, -9473.158203125, -946.15625, 112.8018264770507812, 5.93412017822265625, 0, 0, -0.17364788055419921, 0.984807789325714111, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+4, 180405, 1, 5034, 5466, '0', 0, 0, -9435.171875, -888.43402099609375, 110.8854827880859375, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+5, 180406, 1, 5034, 5466, '0', 0, 0, -9434.609375, -1002.26739501953125, 111.01171875, 5.096362113952636718, 0, 0, -0.55919265747070312, 0.829037725925445556, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+6, 180406, 1, 5034, 5466, '0', 0, 0, -9420.75, -964.95660400390625, 114.2300491333007812, 5.096362113952636718, 0, 0, -0.55919265747070312, 0.829037725925445556, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+7, 180406, 1, 5034, 5466, '0', 0, 0, -9459.0849609375, -945.79339599609375, 112.8018264770507812, 1.413715124130249023, 0, 0, 0.649447441101074218, 0.760406434535980224, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+8, 180406, 1, 5034, 5466, '0', 0, 0, -9531.7099609375, -938.0382080078125, 104.6939163208007812, 0.069811686873435974, 0, 0, 0.034898757934570312, 0.999390840530395507, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+9, 180406, 1, 5034, 5466, '0', 0, 0, -9450.263671875, -888.217041015625, 110.8888626098632812, 3.176533222198486328, 0, 0, -0.999847412109375, 0.017469281330704689, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+10, 180407, 1, 5034, 5466, '0', 0, 0, -9434.232421875, -1018.0504150390625, 110.9858779907226562, 5.166176319122314453, 0, 0, -0.52991867065429687, 0.84804844856262207, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+11, 180407, 1, 5034, 5466, '0', 0, 0, -9473.2900390625, -929.44793701171875, 112.8018264770507812, 4.380776405334472656, 0, 0, -0.81411552429199218, 0.580702960491180419, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+12, 180407, 1, 5034, 5466, '0', 0, 0, -9459.2548828125, -928.95489501953125, 112.8018264770507812, 2.967041015625, 0, 0, 0.996193885803222656, 0.087165042757987976, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+13, 180407, 1, 5034, 5466, '0', 0, 0, -9549.595703125, -973.592041015625, 100.2708206176757812, 4.48549652099609375, 0, 0, -0.7826080322265625, 0.622514784336090087, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+14, 180411, 1, 5034, 5466, '0', 0, 0, -9426.388671875, -968.546875, 117.5698928833007812, 4.276057243347167968, 0, 0, -0.84339141845703125, 0.537299633026123046, 120, 255, 1, 46366), -- G_Ghost_01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+15, 180411, 1, 5034, 5466, '0', 0, 0, -9428.71875, -943.26739501953125, 121.6532363891601562, 1.658061861991882324, 0, 0, 0.737277030944824218, 0.67559051513671875, 120, 255, 1, 46366), -- G_Ghost_01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+16, 180411, 1, 5034, 5466, '0', 0, 0, -9480.625, -966.296875, 120.7756271362304687, 4.398232460021972656, 0, 0, -0.80901622772216796, 0.587786316871643066, 120, 255, 1, 46366), -- G_Ghost_01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+17, 180411, 1, 5034, 5466, '0', 0, 0, -9560.06640625, -950.8819580078125, 112.9897384643554687, 2.617989301681518554, 0, 0, 0.965925216674804687, 0.258821308612823486, 120, 255, 1, 46366), -- G_Ghost_01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+18, 180415, 1, 5034, 5466, '0', 0, 0, -9401.1845703125, -973.59552001953125, 114.107940673828125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+19, 180415, 1, 5034, 5466, '0', 0, 0, -9411.0244140625, -955.01043701171875, 114.10809326171875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+20, 180415, 1, 5034, 5466, '0', 0, 0, -9398.017578125, -973.63543701171875, 114.1080322265625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+21, 180415, 1, 5034, 5466, '0', 0, 0, -9404.4931640625, -944.89239501953125, 114.1078872680664062, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+22, 180415, 1, 5034, 5466, '0', 0, 0, -9411.1875, -963.56768798828125, 114.1080703735351562, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+23, 180415, 1, 5034, 5466, '0', 0, 0, -9408.23828125, -963.5850830078125, 114.1081466674804687, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+24, 180415, 1, 5034, 5466, '0', 0, 0, -9404.298828125, -973.63543701171875, 114.1080169677734375, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+25, 180415, 1, 5034, 5466, '0', 0, 0, -9376.0380859375, -953.6180419921875, 114.7446670532226562, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+26, 180415, 1, 5034, 5466, '0', 0, 0, -9401.1025390625, -944.779541015625, 114.1080169677734375, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+27, 180415, 1, 5034, 5466, '0', 0, 0, -9408.2783203125, -954.998291015625, 114.1080703735351562, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+28, 180415, 1, 5034, 5466, '0', 0, 0, -9376.0380859375, -964.45660400390625, 114.7446670532226562, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+29, 180415, 1, 5034, 5466, '0', 0, 0, -9397.890625, -944.72222900390625, 114.1080322265625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+30, 180426, 1, 5034, 5466, '0', 0, 0, -9462.142578125, -973.52606201171875, 114.3721771240234375, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+31, 180426, 1, 5034, 5466, '0', 0, 0, -9457.8349609375, -978.920166015625, 114.3002700805664062, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+32, 180426, 1, 5034, 5466, '0', 0, 0, -9446.4638671875, -957.53125, 114.3002700805664062, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+33, 180426, 1, 5034, 5466, '0', 0, 0, -9463.6357421875, -952.58856201171875, 114.2300262451171875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+34, 180426, 1, 5034, 5466, '0', 0, 0, -9490.326171875, -959.015625, 117.790069580078125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+35, 180426, 1, 5034, 5466, '0', 0, 0, -9466.328125, -937.47052001953125, 116.256103515625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+36, 180426, 1, 5034, 5466, '0', 0, 0, -9450.8837890625, -934.05206298828125, 115.8839797973632812, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+37, 180426, 1, 5034, 5466, '0', 0, 0, -9446.5986328125, -919.1007080078125, 115.8287506103515625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+38, 180426, 1, 5034, 5466, '0', 0, 0, -9518.7451171875, -957.078125, 107.9824676513671875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+39, 180426, 1, 5034, 5466, '0', 0, 0, -9554.171875, -960.2899169921875, 103.559356689453125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+40, 180427, 1, 5034, 5466, '0', 0, 0, -9463.5419921875, -977.375, 110.9856109619140625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+41, 180427, 1, 5034, 5466, '0', 0, 0, -9460.611328125, -976.13018798828125, 114.3002700805664062, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+42, 180427, 1, 5034, 5466, '0', 0, 0, -9451.2861328125, -968.76214599609375, 111.01171875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+43, 180427, 1, 5034, 5466, '0', 0, 0, -9472.158203125, -958.11285400390625, 109.2133636474609375, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+44, 180427, 1, 5034, 5466, '0', 0, 0, -9447.1845703125, -938.68402099609375, 111.01171875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+45, 180471, 1, 5034, 5466, '0', 0, 0, -9473.81640625, -1017.685791015625, 114.1821823120117187, 4.572763919830322265, 0, 0, -0.75470924377441406, 0.656059443950653076, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+46, 180471, 1, 5034, 5466, '0', 0, 0, -9473.876953125, -1016.36981201171875, 114.1821823120117187, 4.694936752319335937, 0, 0, -0.71325016021728515, 0.700909554958343505, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+47, 180471, 1, 5034, 5466, '0', 0, 0, -9473.8994140625, -1015.10772705078125, 114.1821823120117187, 4.834563255310058593, 0, 0, -0.66261959075927734, 0.748956084251403808, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+48, 180471, 1, 5034, 5466, '0', 0, 0, -9415.2099609375, -963.0711669921875, 122.569091796875, 4.817109584808349609, 0, 0, -0.66913032531738281, 0.74314504861831665, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+49, 180471, 1, 5034, 5466, '0', 0, 0, -9487.6845703125, -986.05731201171875, 113.9404373168945312, 1.413715124130249023, 0, 0, 0.649447441101074218, 0.760406434535980224, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+50, 180471, 1, 5034, 5466, '0', 0, 0, -9415.314453125, -956.5399169921875, 122.5311737060546875, 4.799657344818115234, 0, 0, -0.67558956146240234, 0.737277925014495849, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+51, 180471, 1, 5034, 5466, '0', 0, 0, -9487.685546875, -987.2257080078125, 113.9383392333984375, 1.658061861991882324, 0, 0, 0.737277030944824218, 0.67559051513671875, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+52, 180471, 1, 5034, 5466, '0', 0, 0, -9415.359375, -954.3975830078125, 122.5984420776367187, 4.782202720642089843, 0, 0, -0.68199825286865234, 0.731353819370269775, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+53, 180471, 1, 5034, 5466, '0', 0, 0, -9487.8173828125, -984.763916015625, 113.9404373168945312, 1.32644820213317871, 0, 0, 0.615660667419433593, 0.788011372089385986, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+54, 180471, 1, 5034, 5466, '0', 0, 0, -9415.203125, -961.98614501953125, 122.5012893676757812, 5.009094715118408203, 0, 0, -0.59482288360595703, 0.80385679006576538, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+55, 180471, 1, 5034, 5466, '0', 0, 0, -9415.265625, -960.8975830078125, 122.4408798217773437, 4.9218292236328125, 0, 0, -0.62932014465332031, 0.77714616060256958, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+56, 180471, 1, 5034, 5466, '0', 0, 0, -9415.2412109375, -957.70489501953125, 122.4472808837890625, 4.799657344818115234, 0, 0, -0.67558956146240234, 0.737277925014495849, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+57, 180471, 1, 5034, 5466, '0', 0, 0, -9415.3369140625, -955.3680419921875, 122.6055679321289062, 4.782202720642089843, 0, 0, -0.68199825286865234, 0.731353819370269775, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+58, 180471, 1, 5034, 5466, '0', 0, 0, -9415.1767578125, -964.046875, 122.5145111083984375, 4.782202720642089843, 0, 0, -0.68199825286865234, 0.731353819370269775, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+59, 180471, 1, 5034, 5466, '0', 0, 0, -9526.5, -986.80206298828125, 109.893463134765625, 1.658061861991882324, 0, 0, 0.737277030944824218, 0.67559051513671875, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+60, 180471, 1, 5034, 5466, '0', 0, 0, -9526.5, -987.9600830078125, 109.893463134765625, 1.658061861991882324, 0, 0, 0.737277030944824218, 0.67559051513671875, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+61, 180471, 1, 5034, 5466, '0', 0, 0, -9526.5, -985.54339599609375, 109.893463134765625, 1.658061861991882324, 0, 0, 0.737277030944824218, 0.67559051513671875, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+62, 180471, 1, 5034, 5466, '0', 0, 0, -9488.96875, -928.51214599609375, 114.1068801879882812, 1.32644820213317871, 0, 0, 0.615660667419433593, 0.788011372089385986, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+63, 180471, 1, 5034, 5466, '0', 0, 0, -9462.7880859375, -912.8125, 117.7845077514648437, 6.056293010711669921, 0, 0, -0.11320304870605468, 0.993571877479553222, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+64, 180471, 1, 5034, 5466, '0', 0, 0, -9488.8349609375, -929.8055419921875, 114.0665664672851562, 1.413715124130249023, 0, 0, 0.649447441101074218, 0.760406434535980224, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+65, 180471, 1, 5034, 5466, '0', 0, 0, -9464.0673828125, -912.85418701171875, 117.8243179321289062, 6.14356088638305664, 0, 0, -0.06975555419921875, 0.997564136981964111, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+66, 180471, 1, 5034, 5466, '0', 0, 0, -9461.53515625, -912.78472900390625, 117.84423828125, 5.986480236053466796, 0, 0, -0.14780902862548828, 0.989015936851501464, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+67, 180471, 1, 5034, 5466, '0', 0, 0, -9488.8369140625, -930.97393798828125, 114.0994033813476562, 1.658061861991882324, 0, 0, 0.737277030944824218, 0.67559051513671875, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+68, 180471, 1, 5034, 5466, '0', 0, 0, -9526.919921875, -924.58856201171875, 110.2437591552734375, 1.658061861991882324, 0, 0, 0.737277030944824218, 0.67559051513671875, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+69, 180471, 1, 5034, 5466, '0', 0, 0, -9526.919921875, -927.17364501953125, 110.2437591552734375, 1.658061861991882324, 0, 0, 0.737277030944824218, 0.67559051513671875, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+70, 180471, 1, 5034, 5466, '0', 0, 0, -9526.919921875, -925.94268798828125, 110.2437591552734375, 1.658061861991882324, 0, 0, 0.737277030944824218, 0.67559051513671875, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+71, 180472, 1, 5034, 5466, '0', 0, 0, -9485.9169921875, -992.22393798828125, 115.3963088989257812, 6.195919513702392578, 0, 0, -0.04361915588378906, 0.999048233032226562, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+72, 180472, 1, 5034, 5466, '0', 0, 0, -9415.44140625, -959.357666015625, 123.052642822265625, 3.089183330535888671, 0, 0, 0.99965667724609375, 0.026201646775007247, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+73, 180472, 1, 5034, 5466, '0', 0, 0, -9422.388671875, -947.33856201171875, 119.12896728515625, 3.333590030670166015, 0, 0, -0.99539566040039062, 0.095851235091686248, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+74, 180472, 1, 5034, 5466, '0', 0, 0, -9522.3505859375, -980.31597900390625, 112.230926513671875, 0.715584874153137207, 0, 0, 0.350207328796386718, 0.936672210693359375, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+75, 180472, 1, 5034, 5466, '0', 0, 0, -9469.498046875, -917.1007080078125, 120.2274322509765625, 4.328419685363769531, 0, 0, -0.82903671264648437, 0.559194147586822509, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+76, 180472, 1, 5034, 5466, '0', 0, 0, -9532.37890625, -946.60418701171875, 114.448516845703125, 5.969027042388916015, 0, 0, -0.1564340591430664, 0.987688362598419189, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Ramkahen - Difficulty: 0)
+(@OGUID+77, 180523, 1, 5034, 5466, '0', 0, 0, -9385.734375, -945.0555419921875, 114.2168502807617187, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Apple Bob (Area: Ramkahen - Difficulty: 0)
+(@OGUID+78, 208179, 1, 5034, 5466, '0', 0, 0, -9392.01953125, -945.32293701171875, 113.7635726928710937, 0, 0, 0, 0, 1, 120, 255, 1, 46366); -- Candy Bucket (Area: Ramkahen - Difficulty: 0)
+
+-- Event spawns
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+78;
+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),
+(12, @OGUID+33),
+(12, @OGUID+34),
+(12, @OGUID+35),
+(12, @OGUID+36),
+(12, @OGUID+37),
+(12, @OGUID+38),
+(12, @OGUID+39),
+(12, @OGUID+40),
+(12, @OGUID+41),
+(12, @OGUID+42),
+(12, @OGUID+43),
+(12, @OGUID+44),
+(12, @OGUID+45),
+(12, @OGUID+46),
+(12, @OGUID+47),
+(12, @OGUID+48),
+(12, @OGUID+49),
+(12, @OGUID+50),
+(12, @OGUID+51),
+(12, @OGUID+52),
+(12, @OGUID+53),
+(12, @OGUID+54),
+(12, @OGUID+55),
+(12, @OGUID+56),
+(12, @OGUID+57),
+(12, @OGUID+58),
+(12, @OGUID+59),
+(12, @OGUID+60),
+(12, @OGUID+61),
+(12, @OGUID+62),
+(12, @OGUID+63),
+(12, @OGUID+64),
+(12, @OGUID+65),
+(12, @OGUID+66),
+(12, @OGUID+67),
+(12, @OGUID+68),
+(12, @OGUID+69),
+(12, @OGUID+70),
+(12, @OGUID+71),
+(12, @OGUID+72),
+(12, @OGUID+73),
+(12, @OGUID+74),
+(12, @OGUID+75),
+(12, @OGUID+76),
+(12, @OGUID+77),
+(12, @OGUID+78);