DB/ElwynnForest: Update Hallows End spawns

1 files changed, 382 insertions, 0 deletions

diff --git a/sql/updates/world/master/2023_11_08_12_world_elwynn_forest_goldshire.sql b/sql/updates/world/master/2023_11_08_12_world_elwynn_forest_goldshire.sql
new file mode 100644
index 00000000000..ed42e2e7206
--- /dev/null
+++ b/sql/updates/world/master/2023_11_08_12_world_elwynn_forest_goldshire.sql
@@ -0,0 +1,382 @@
+SET @CGUID := 3000299;
+SET @OGUID := 3004769;
+
+-- Old creature spawns
+DELETE FROM `creature` WHERE `guid` BETWEEN 222620 AND 222667;
+DELETE FROM `game_event_creature` WHERE `guid` BETWEEN 222620 AND 222667;
+
+-- Creature spawns
+DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+47;
+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`, `unit_flags2`, `unit_flags3`, `VerifiedBuild`) VALUES
+(@CGUID+0, 1423, 0, 12, 87, '0', 0, 0, 0, 1, -9371.11328125, 51.56602859497070312, 61.38856887817382812, 0.296705961227416992, 120, 0, 0, 3208, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Stormwind Guard (Area: Goldshire - Difficulty: 0)
+(@CGUID+1, 22816, 0, 12, 87, '0', 0, 0, 0, 0, -9429.0869140625, 79.37326812744140625, 56.55406951904296875, 0, 120, 10, 0, 118, 0, 1, NULL, NULL, NULL, NULL, 45745), -- Black Cat (Area: 0 - Difficulty: 0)
+(@CGUID+2, 23537, 0, 12, 87, '0', 0, 0, 0, 0, -9470.216796875, 40.7396392822265625, 64.3475341796875, 4.729842185974121093, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Goldshire - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+3, 23537, 0, 12, 87, '0', 0, 0, 0, 0, -9461.7177734375, 83.192169189453125, 63.09781646728515625, 1.448623299598693847, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Goldshire - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+4, 23537, 0, 12, 87, '0', 0, 0, 0, 0, -9469.8564453125, 89.61669921875, 63.21298980712890625, 2.775073528289794921, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Goldshire - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+5, 23537, 0, 12, 87, '0', 0, 0, 0, 0, -9450.4970703125, 51.66840362548828125, 57.217529296875, 2.460914134979248046, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Goldshire - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire, 42091 - Headless Horseman - Fire Size)
+(@CGUID+6, 23537, 0, 12, 87, '0', 0, 0, 0, 0, -9452.2763671875, 39.51980209350585937, 61.44594955444335937, 0.314159274101257324, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Goldshire - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+7, 23537, 0, 12, 87, '0', 0, 0, 0, 0, -9479.0673828125, 30.18218421936035156, 60.66395950317382812, 0.383972436189651489, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Goldshire - Difficulty: 0) (Auras: 42091 - Headless Horseman - Fire Size, 42154 - Headless Horseman - Dim Fire)
+(@CGUID+8, 23537, 0, 12, 87, '0', 0, 0, 0, 0, -9461.4580078125, 39.54513931274414062, 64.415679931640625, 1.989675283432006835, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Goldshire - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+9, 23537, 0, 12, 87, '0', 0, 0, 0, 0, -9460.5849609375, 44.2098541259765625, 63.6614227294921875, 2.076941728591918945, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Goldshire - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+10, 23537, 0, 12, 87, '0', 0, 0, 0, 0, -9465.33984375, 81.3040618896484375, 66.3204345703125, 5.410520553588867187, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Goldshire - Difficulty: 0) (Auras: 42091 - Headless Horseman - Fire Size, 42154 - Headless Horseman - Dim Fire)
+(@CGUID+11, 23537, 0, 12, 87, '0', 0, 0, 0, 0, -9456.8505859375, 40.07416534423828125, 62.51924514770507812, 2.408554315567016601, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Goldshire - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+12, 23537, 0, 12, 87, '0', 0, 0, 0, 0, -9479.0830078125, 33.50499343872070312, 70.159027099609375, 0.541052043437957763, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Goldshire - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+13, 23537, 0, 12, 87, '0', 0, 0, 0, 0, -9479.5009765625, 38.35199737548828125, 68.57891082763671875, 4.450589656829833984, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Goldshire - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+14, 23537, 0, 12, 87, '0', 0, 0, 0, 0, -9467.072265625, 102.9497909545898437, 66.50400543212890625, 2.234021425247192382, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Goldshire - Difficulty: 0) (Auras: 42091 - Headless Horseman - Fire Size, 42154 - Headless Horseman - Dim Fire)
+(@CGUID+15, 23537, 0, 12, 87, '0', 0, 0, 0, 0, -9458.228515625, 39.66292190551757812, 68.1999664306640625, 3.50811171531677246, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Goldshire - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+16, 23537, 0, 12, 87, '0', 0, 0, 0, 0, -9467.0908203125, 95.07050323486328125, 69.1271514892578125, 5.497786998748779296, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Goldshire - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+17, 23537, 0, 12, 87, '0', 0, 0, 0, 0, -9446.341796875, 94.4713287353515625, 69.16121673583984375, 1.361356854438781738, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Goldshire - Difficulty: 0) (Auras: 42091 - Headless Horseman - Fire Size, 42154 - Headless Horseman - Dim Fire)
+(@CGUID+18, 23537, 0, 12, 87, '0', 0, 0, 0, 0, -9449.4287109375, 100.1325531005859375, 65.4443206787109375, 4.555309295654296875, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Goldshire - Difficulty: 0) (Auras: 42091 - Headless Horseman - Fire Size, 42154 - Headless Horseman - Dim Fire)
+(@CGUID+19, 23537, 0, 12, 87, '0', 0, 0, 0, 0, -9479.4755859375, 43.13444137573242187, 59.15894699096679687, 1.117010712623596191, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Goldshire - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+20, 23537, 0, 12, 87, '0', 0, 0, 0, 0, -9480.767578125, 28.77642250061035156, 68.43679046630859375, 0.366519153118133544, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Goldshire - Difficulty: 0) (Auras: 42091 - Headless Horseman - Fire Size, 42154 - Headless Horseman - Dim Fire)
+(@CGUID+21, 23537, 0, 12, 87, '0', 0, 0, 0, 0, -9463.048828125, 40.64567184448242187, 67.860321044921875, 0.244346097111701965, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Goldshire - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+22, 23537, 0, 12, 87, '0', 0, 0, 0, 0, -9467.830078125, 90.83428192138671875, 67.7136688232421875, 3.298672199249267578, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Goldshire - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+23, 23537, 0, 12, 87, '0', 0, 0, 0, 0, -9453.26171875, 81.70697784423828125, 66.21205902099609375, 4.066617012023925781, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Goldshire - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+24, 23537, 0, 12, 87, '0', 0, 0, 0, 0, -9478.806640625, 43.3040924072265625, 68.7129974365234375, 0.418879032135009765, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Goldshire - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+25, 23537, 0, 12, 87, '0', 0, 0, 0, 0, -9472.3857421875, 40.63113021850585937, 61.37183761596679687, 3.071779489517211914, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Goldshire - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+26, 23537, 0, 12, 87, '0', 0, 0, 0, 0, -9451.7314453125, 38.38438796997070312, 68.476806640625, 6.195918560028076171, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Goldshire - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+27, 23537, 0, 12, 87, '0', 0, 0, 0, 0, -9471.0263671875, 45.1131744384765625, 73.466094970703125, 0.122173048555850982, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Goldshire - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+28, 23537, 0, 12, 87, '0', 0, 0, 0, 0, -9478.4501953125, 38.6229400634765625, 57.32666015625, 2.687807083129882812, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Goldshire - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+29, 23537, 0, 12, 87, '0', 0, 0, 0, 0, -9459.1630859375, 80.10346221923828125, 69.16994476318359375, 5.759586334228515625, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Goldshire - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+30, 23537, 0, 12, 87, '0', 0, 0, 0, 0, -9468.5517578125, 85.29633331298828125, 65.75853729248046875, 6.056292533874511718, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Goldshire - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+31, 23537, 0, 12, 87, '0', 0, 0, 0, 0, -9449.26953125, 89.892852783203125, 66.166046142578125, 1.239183783531188964, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Goldshire - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+32, 23537, 0, 12, 87, '0', 0, 0, 0, 0, -9456.7373046875, 34.47954559326171875, 71.27692413330078125, 3.892084121704101562, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Goldshire - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+33, 23537, 0, 12, 87, '0', 0, 0, 0, 0, -9461.8330078125, 106.3341217041015625, 69.32807159423828125, 3.577924966812133789, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Goldshire - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+34, 23537, 0, 12, 87, '0', 0, 0, 0, 0, -9450.6669921875, 86.8271484375, 65.59152984619140625, 0.959931075572967529, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Goldshire - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+35, 23537, 0, 12, 87, '0', 0, 0, 0, 0, -9470.0126953125, 98.6307525634765625, 66.50199127197265625, 1.553343057632446289, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Goldshire - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+36, 23537, 0, 12, 87, '0', 0, 0, 0, 0, -9451.15234375, 83.90695953369140625, 65.818756103515625, 3.124139308929443359, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Goldshire - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+37, 23537, 0, 12, 87, '0', 0, 0, 0, 0, -9478.9033203125, 35.96294403076171875, 63.61331558227539062, 4.415682792663574218, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Goldshire - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+38, 23537, 0, 12, 87, '0', 0, 0, 0, 0, -9321.349609375, 64.154571533203125, 67.34832000732421875, 0, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Goldshire - Difficulty: 0)
+(@CGUID+39, 23537, 0, 12, 87, '0', 0, 0, 0, 0, -9328.2568359375, 55.92361068725585937, 62.85633087158203125, 0, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Goldshire - Difficulty: 0) (Auras: 42112 - Headless Horseman - Update Size)
+(@CGUID+40, 23537, 0, 12, 87, '0', 0, 0, 0, 0, -9313.662109375, 52.94249343872070312, 77.0829620361328125, 0, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Goldshire - Difficulty: 0) (Auras: 42112 - Headless Horseman - Update Size)
+(@CGUID+41, 23537, 0, 12, 87, '0', 0, 0, 0, 0, -9313.228515625, 58.63737106323242187, 75.74405670166015625, 0, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Goldshire - Difficulty: 0) (Auras: 42112 - Headless Horseman - Update Size)
+(@CGUID+42, 23537, 0, 12, 87, '0', 0, 0, 0, 0, -9314.0712890625, 45.91433334350585937, 72.608642578125, 0, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Goldshire - Difficulty: 0)
+(@CGUID+43, 23712, 0, 12, 87, '0', 0, 0, 0, 0, -9431.0107421875, 58.32785415649414062, 56.88041305541992187, 5.480333805084228515, 120, 0, 0, 41, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Touring Orphan (Area: Goldshire - Difficulty: 0)
+(@CGUID+44, 23712, 0, 12, 87, '0', 0, 0, 0, 0, -9428.7177734375, 54.05712890625, 56.81895828247070312, 1.919862151145935058, 120, 0, 0, 27, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Touring Orphan (Area: Goldshire - Difficulty: 0)
+(@CGUID+45, 23712, 0, 12, 87, '0', 0, 0, 0, 0, -9431.3212890625, 55.05235671997070312, 56.68706130981445312, 3.385938644409179687, 120, 0, 0, 41, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Touring Orphan (Area: Goldshire - Difficulty: 0)
+(@CGUID+46, 23712, 0, 12, 87, '0', 0, 0, 0, 0, -9431.984375, 56.71072006225585937, 56.69958114624023437, 6.161012172698974609, 120, 0, 0, 34, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Touring Orphan (Area: Goldshire - Difficulty: 0)
+(@CGUID+47, 24519, 0, 12, 87, '0', 0, 0, 0, 0, -9429.923828125, 56.13547134399414062, 56.79131317138671875, 2.984513044357299804, 120, 0, 0, 11791, 0, 0, NULL, NULL, NULL, NULL, 45745); -- Costumed Orphan Matron (Area: Goldshire - Difficulty: 0)
+
+-- Old gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 166096 AND 166220;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 166096 AND 166220;
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+124;
+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, 12, 87, '0', 0, 0, -9471.2783203125, 41.24137496948242187, 58.04854202270507812, 3.403396368026733398, 0, 0, -0.99144458770751953, 0.130528271198272705, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+1, 180405, 0, 12, 87, '0', 0, 0, -9452.9345703125, 42.23991012573242187, 56.92788314819335937, 2.583080768585205078, 0, 0, 0.961260795593261718, 0.275640487670898437, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+2, 180405, 0, 12, 87, '0', 0, 0, -9485.525390625, 20.35525131225585937, 57.5647735595703125, 5.026549339294433593, 0, 0, -0.5877847671508789, 0.809017360210418701, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+3, 180405, 0, 12, 87, '0', 0, 0, -9462.4580078125, 24.28521156311035156, 56.98764419555664062, 4.97418975830078125, 0, 0, -0.60876083374023437, 0.793353796005249023, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+4, 180405, 0, 12, 87, '0', 0, 0, -9454.533203125, 14.36577701568603515, 58.04854202270507812, 1.85004889965057373, 0, 0, 0.798635482788085937, 0.60181504487991333, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+5, 180405, 0, 12, 87, '0', 0, 0, -9456.982421875, 96.8743743896484375, 73.82578277587890625, 2.792518377304077148, 0, 0, 0.984807014465332031, 0.173652306199073791, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+6, 180405, 0, 12, 87, '0', 0, 0, -9469.91796875, 106.844757080078125, 57.39889907836914062, 4.363324165344238281, 0, 0, -0.81915187835693359, 0.573576688766479492, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+7, 180406, 0, 12, 87, '0', 0, 0, -9461.0625, 46.7900390625, 56.60628128051757812, 2.932138919830322265, 0, 0, 0.994521141052246093, 0.104535527527332305, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Goldshire - Difficulty: 0)
+(@OGUID+8, 180406, 0, 12, 87, '0', 0, 0, -9477.197265625, 33.58078384399414062, 63.82046890258789062, 1.815141916275024414, 0, 0, 0.788010597229003906, 0.615661680698394775, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Goldshire - Difficulty: 0)
+(@OGUID+9, 180406, 0, 12, 87, '0', 0, 0, -9470.3017578125, 86.570831298828125, 57.09816360473632812, 5.061456203460693359, 0, 0, -0.57357597351074218, 0.819152355194091796, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Goldshire - Difficulty: 0)
+(@OGUID+10, 180406, 0, 12, 87, '0', 0, 0, -9483.6357421875, 32.77219009399414062, 57.8729248046875, 4.939284324645996093, 0, 0, -0.6225137710571289, 0.78260880708694458, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Goldshire - Difficulty: 0)
+(@OGUID+11, 180406, 0, 12, 87, '0', 0, 0, -9439.232421875, 83.657989501953125, 57.00046157836914062, 1.675513744354248046, 0, 0, 0.743144035339355468, 0.669131457805633544, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Goldshire - Difficulty: 0)
+(@OGUID+12, 180406, 0, 12, 87, '0', 0, 0, -9457.2607421875, 30.92578125, 56.96610641479492187, 4.97418975830078125, 0, 0, -0.60876083374023437, 0.793353796005249023, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Goldshire - Difficulty: 0)
+(@OGUID+13, 180406, 0, 12, 87, '0', 0, 0, -9493.396484375, 86.60991668701171875, 56.50654983520507812, 1.500982880592346191, 0, 0, 0.681998252868652343, 0.731353819370269775, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Goldshire - Difficulty: 0)
+(@OGUID+14, 180406, 0, 12, 87, '0', 0, 0, -9463.064453125, 91.52181243896484375, 73.8284759521484375, 5.794494152069091796, 0, 0, -0.24192142486572265, 0.970295846462249755, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Goldshire - Difficulty: 0)
+(@OGUID+15, 180406, 0, 12, 87, '0', 0, 0, -9475.6416015625, 28.21766471862792968, 56.97832107543945312, 1.343901276588439941, 0, 0, 0.622513771057128906, 0.78260880708694458, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Goldshire - Difficulty: 0)
+(@OGUID+16, 180406, 0, 12, 87, '0', 0, 0, -9466.890625, 0.882866978645324707, 63.82046890258789062, 1.762782454490661621, 0, 0, 0.771624565124511718, 0.636078238487243652, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Goldshire - Difficulty: 0)
+(@OGUID+17, 180407, 0, 12, 87, '0', 0, 0, -9464.63671875, 79.0191497802734375, 57.25791549682617187, 0.471238493919372558, 0, 0, 0.233445167541503906, 0.972369968891143798, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Goldshire - Difficulty: 0)
+(@OGUID+18, 180407, 0, 12, 87, '0', 0, 0, -9471.16796875, 32.35991668701171875, 56.96610641479492187, 2.565631866455078125, 0, 0, 0.958819389343261718, 0.284016460180282592, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Goldshire - Difficulty: 0)
+(@OGUID+19, 180407, 0, 12, 87, '0', 0, 0, -9452.75390625, 31.37630271911621093, 58.04854965209960937, 1.867502212524414062, 0, 0, 0.803856849670410156, 0.594822824001312255, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Goldshire - Difficulty: 0)
+(@OGUID+20, 180407, 0, 12, 87, '0', 0, 0, -9484.7119140625, 26.72602081298828125, 57.55510711669921875, 4.97418975830078125, 0, 0, -0.60876083374023437, 0.793353796005249023, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Goldshire - Difficulty: 0)
+(@OGUID+21, 180407, 0, 12, 87, '0', 0, 0, -9456.859375, 91.65738677978515625, 73.83017730712890625, 1.186823248863220214, 0, 0, 0.559192657470703125, 0.829037725925445556, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Goldshire - Difficulty: 0)
+(@OGUID+22, 180407, 0, 12, 87, '0', 0, 0, -9455.3798828125, 93.4061431884765625, 58.34375762939453125, 5.148722648620605468, 0, 0, -0.53729915618896484, 0.843391716480255126, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Goldshire - Difficulty: 0)
+(@OGUID+23, 180407, 0, 12, 87, '0', 0, 0, -9478.970703125, 13.21446418762207031, 60.18495559692382812, 2.809975385665893554, 0, 0, 0.986285209655761718, 0.165049895644187927, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Goldshire - Difficulty: 0)
+(@OGUID+24, 180407, 0, 12, 87, '0', 0, 0, -9495.908203125, 79.73784637451171875, 56.35814285278320312, 1.85004889965057373, 0, 0, 0.798635482788085937, 0.60181504487991333, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Goldshire - Difficulty: 0)
+(@OGUID+25, 180407, 0, 12, 87, '0', 0, 0, -9463.0205078125, 96.659698486328125, 73.83648681640625, 4.380776405334472656, 0, 0, -0.81411552429199218, 0.580702960491180419, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Goldshire - Difficulty: 0)
+(@OGUID+26, 180407, 0, 12, 87, '0', 0, 0, -9430.6044921875, 90.51041412353515625, 57.06767654418945312, 0.506144583225250244, 0, 0, 0.250379562377929687, 0.968147754669189453, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Goldshire - Difficulty: 0)
+(@OGUID+27, 180408, 0, 12, 87, '0', 0, 0, -9439.2294921875, 83.72222137451171875, 58.67627716064453125, 1.692969322204589843, 0, 0, 0.748955726623535156, 0.662620067596435546, 120, 255, 1, 45745), -- G_WitchHat_01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+28, 180408, 0, 12, 87, '0', 0, 0, -9430.669921875, 90.640625, 58.74462127685546875, 0.226892471313476562, 0, 0, 0.113203048706054687, 0.993571877479553222, 120, 255, 1, 45745), -- G_WitchHat_01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+29, 180410, 0, 12, 87, '0', 0, 0, -9460.201171875, 33.16840362548828125, 58.3619384765625, 4.572763919830322265, 0, 0, -0.75470924377441406, 0.656059443950653076, 120, 255, 1, 45745), -- G_HangingSkeleton_01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+30, 180410, 0, 12, 87, '0', 0, 0, -9477.0400390625, 35.77604293823242187, 58.32027053833007812, 6.195919513702392578, 0, 0, -0.04361915588378906, 0.999048233032226562, 120, 255, 1, 45745), -- G_HangingSkeleton_01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+31, 180410, 0, 12, 87, '0', 0, 0, -9469.814453125, 27.02430534362792968, 64.63297271728515625, 4.572763919830322265, 0, 0, -0.75470924377441406, 0.656059443950653076, 120, 255, 1, 45745), -- G_HangingSkeleton_01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+32, 180410, 0, 12, 87, '0', 0, 0, -9467.8017578125, 18.27278709411621093, 64.8760223388671875, 0.191985160112380981, 0, 0, 0.095845222473144531, 0.995396256446838378, 120, 255, 1, 45745), -- G_HangingSkeleton_01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+33, 180411, 0, 12, 87, '0', 0, 0, -9471.15625, 44.05729293823242187, 65.78702545166015625, 4.276057243347167968, 0, 0, -0.84339141845703125, 0.537299633026123046, 120, 255, 1, 45745), -- G_Ghost_01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+34, 180411, 0, 12, 87, '0', 0, 0, -9459.7080078125, 80.0777740478515625, 62.75640106201171875, 1.48352813720703125, 0, 0, 0.675589561462402343, 0.737277925014495849, 120, 255, 1, 45745), -- G_Ghost_01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+35, 180411, 0, 12, 87, '0', 0, 0, -9475.44140625, 12.28548145294189453, 64.14418792724609375, 4.537858963012695312, 0, 0, -0.76604366302490234, 0.642788589000701904, 120, 255, 1, 45745), -- G_Ghost_01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+36, 180411, 0, 12, 87, '0', 0, 0, -9475.763671875, 6.548611164093017578, 65.95102691650390625, 1.029743075370788574, 0, 0, 0.492423057556152343, 0.870355963706970214, 120, 255, 1, 45745), -- G_Ghost_01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+37, 180415, 0, 12, 87, '0', 0, 0, -9468.498046875, 35.2240142822265625, 65.3135223388671875, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 45745), -- CandleBlack01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+38, 180415, 0, 12, 87, '0', 0, 0, -9465.826171875, 37.11458206176757812, 64.65380096435546875, 5.969027042388916015, 0, 0, -0.1564340591430664, 0.987688362598419189, 120, 255, 1, 45745), -- CandleBlack01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+39, 180415, 0, 12, 87, '0', 0, 0, -9459.01953125, 19.05457878112792968, 57.45594024658203125, 1.85004889965057373, 0, 0, 0.798635482788085937, 0.60181504487991333, 120, 255, 1, 45745), -- CandleBlack01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+40, 180415, 0, 12, 87, '0', 0, 0, -9462.6708984375, 26.46207618713378906, 57.0362548828125, 2.565631866455078125, 0, 0, 0.958819389343261718, 0.284016460180282592, 120, 255, 1, 45745), -- CandleBlack01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+41, 180415, 0, 12, 87, '0', 0, 0, -9467.2568359375, 15.05344009399414062, 64.74407958984375, 4.48549652099609375, 0, 0, -0.7826080322265625, 0.622514784336090087, 120, 255, 1, 45745), -- CandleBlack01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+42, 180415, 0, 12, 87, '0', 0, 0, -9456.966796875, 26.20833396911621093, 64.792694091796875, 0.104719325900077819, 0, 0, 0.052335739135742187, 0.998629570007324218, 120, 255, 1, 45745), -- CandleBlack01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+43, 180415, 0, 12, 87, '0', 0, 0, -9460.607421875, 17.47743034362792968, 64.792694091796875, 3.700104713439941406, 0, 0, -0.96126079559326171, 0.275640487670898437, 120, 255, 1, 45745), -- CandleBlack01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+44, 180415, 0, 12, 87, '0', 0, 0, -9458.9814453125, 20.04530143737792968, 57.4895782470703125, 3.717553615570068359, 0, 0, -0.95881938934326171, 0.284016460180282592, 120, 255, 1, 45745), -- CandleBlack01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+45, 180415, 0, 12, 87, '0', 0, 0, -9456.939453125, 26.609375, 64.88991546630859375, 5.270895957946777343, 0, 0, -0.48480892181396484, 0.87462007999420166, 120, 255, 1, 45745), -- CandleBlack01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+46, 180415, 0, 12, 87, '0', 0, 0, -9458.123046875, 26.82584571838378906, 57.48297882080078125, 2.042035102844238281, 0, 0, 0.852640151977539062, 0.522498607635498046, 120, 255, 1, 45745), -- CandleBlack01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+47, 180415, 0, 12, 87, '0', 0, 0, -9457.8955078125, 27.70198631286621093, 57.44475173950195312, 1.012289404869079589, 0, 0, 0.484808921813964843, 0.87462007999420166, 120, 255, 1, 45745), -- CandleBlack01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+48, 180415, 0, 12, 87, '0', 0, 0, -9461.7236328125, 16.72140884399414062, 64.89685821533203125, 5.550147056579589843, 0, 0, -0.358367919921875, 0.933580458164215087, 120, 255, 1, 45745), -- CandleBlack01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+49, 180425, 0, 12, 87, '0', 0, 0, -9475.2529296875, 39.24788284301757812, 64.74407958984375, 4.9218292236328125, 0, 0, -0.62932014465332031, 0.77714616060256958, 120, 255, 1, 45745), -- SkullCandle01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+50, 180425, 0, 12, 87, '0', 0, 0, -9468.3369140625, 34.98958206176757812, 65.31575775146484375, 3.822272777557373046, 0, 0, -0.94264125823974609, 0.333807557821273803, 120, 255, 1, 45745), -- SkullCandle01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+51, 180425, 0, 12, 87, '0', 0, 0, -9455.6953125, 26.51600456237792968, 64.93157958984375, 2.513273954391479492, 0, 0, 0.951056480407714843, 0.309017121791839599, 120, 255, 1, 45745), -- SkullCandle01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+52, 180425, 0, 12, 87, '0', 0, 0, -9466.74609375, 29.17697525024414062, 64.76491546630859375, 5.84685373306274414, 0, 0, -0.21643924713134765, 0.976296067237854003, 120, 255, 1, 45745), -- SkullCandle01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+53, 180425, 0, 12, 87, '0', 0, 0, -9457.9892578125, 27.28683853149414062, 57.45777130126953125, 2.932138919830322265, 0, 0, 0.994521141052246093, 0.104535527527332305, 120, 255, 1, 45745), -- SkullCandle01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+54, 180425, 0, 12, 87, '0', 0, 0, -9446.3017578125, 97.421875, 57.71246337890625, 5.811946868896484375, 0, 0, -0.2334451675415039, 0.972369968891143798, 120, 255, 1, 45745), -- SkullCandle01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+55, 180425, 0, 12, 87, '0', 0, 0, -9458.982421875, 20.58241081237792968, 57.51729202270507812, 3.089183330535888671, 0, 0, 0.99965667724609375, 0.026201646775007247, 120, 255, 1, 45745), -- SkullCandle01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+56, 180425, 0, 12, 87, '0', 0, 0, -9458.2333984375, 26.39887237548828125, 57.50690460205078125, 2.914689540863037109, 0, 0, 0.993571281433105468, 0.113208353519439697, 120, 255, 1, 45745), -- SkullCandle01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+57, 180425, 0, 12, 87, '0', 0, 0, -9471.5068359375, 21.84027862548828125, 57.24092483520507812, 1.256635904312133789, 0, 0, 0.587784767150878906, 0.809017360210418701, 120, 255, 1, 45745), -- SkullCandle01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+58, 180425, 0, 12, 87, '0', 0, 0, -9457.7919921875, 28.2236328125, 57.47201919555664062, 3.001946926116943359, 0, 0, 0.997563362121582031, 0.069766148924827575, 120, 255, 1, 45745), -- SkullCandle01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+59, 180425, 0, 12, 87, '0', 0, 0, -9459.0107421875, 18.65440559387207031, 57.4671173095703125, 3.001946926116943359, 0, 0, 0.997563362121582031, 0.069766148924827575, 120, 255, 1, 45745), -- SkullCandle01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+60, 180425, 0, 12, 87, '0', 0, 0, -9458.9580078125, 19.52696418762207031, 57.46222686767578125, 3.036838293075561523, 0, 0, 0.998628616333007812, 0.052353221923112869, 120, 255, 1, 45745), -- SkullCandle01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+61, 180425, 0, 12, 87, '0', 0, 0, -9478.142578125, 24.5458984375, 57.131103515625, 0.052358884364366531, 0, 0, 0.02617645263671875, 0.999657332897186279, 120, 255, 1, 45745), -- SkullCandle01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+62, 180425, 0, 12, 87, '0', 0, 0, -9464.763671875, 7.331596851348876953, 64.917694091796875, 5.497788906097412109, 0, 0, -0.38268280029296875, 0.923879802227020263, 120, 255, 1, 45745), -- SkullCandle01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+63, 180426, 0, 12, 87, '0', 0, 0, -9457.0830078125, 61.80729293823242187, 66.903106689453125, 3.612837791442871093, 0, 0, -0.97236919403076171, 0.233448356389999389, 120, 255, 1, 45745), -- Bat01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+64, 180426, 0, 12, 87, '0', 0, 0, -9456.982421875, 61.90625, 58.219970703125, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 45745), -- Bat01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+65, 180426, 0, 12, 87, '0', 0, 0, -9457.1357421875, 62.02257156372070312, 66.9685211181640625, 2.809975385665893554, 0, 0, 0.986285209655761718, 0.165049895644187927, 120, 255, 1, 45745), -- Bat01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+66, 180426, 0, 12, 87, '0', 0, 0, -9457.892578125, 59.58507156372070312, 67.4950103759765625, 4.1538848876953125, 0, 0, -0.8746194839477539, 0.484810054302215576, 120, 255, 1, 45745), -- Bat01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+67, 180426, 0, 12, 87, '0', 0, 0, -9456.84765625, 61.98611068725585937, 64.01755523681640625, 5.009094715118408203, 0, 0, -0.59482288360595703, 0.80385679006576538, 120, 255, 1, 45745), -- Bat01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+68, 180426, 0, 12, 87, '0', 0, 0, -9458.2392578125, 60.82465362548828125, 65.467315673828125, 3.52557229995727539, 0, 0, -0.98162651062011718, 0.190812408924102783, 120, 255, 1, 45745), -- Bat01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+69, 180426, 0, 12, 87, '0', 0, 0, -9455.455078125, 63.61632156372070312, 64.2530975341796875, 1.32644820213317871, 0, 0, 0.615660667419433593, 0.788011372089385986, 120, 255, 1, 45745), -- Bat01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+70, 180426, 0, 12, 87, '0', 0, 0, -9455.169921875, 60.9774322509765625, 65.3062744140625, 2.024578809738159179, 0, 0, 0.848047256469726562, 0.529920578002929687, 120, 255, 1, 45745), -- Bat01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+71, 180426, 0, 12, 87, '0', 0, 0, -9456.9482421875, 62.0243072509765625, 67.28455352783203125, 2.478367090225219726, 0, 0, 0.94551849365234375, 0.325568377971649169, 120, 255, 1, 45745), -- Bat01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+72, 180426, 0, 12, 87, '0', 0, 0, -9458.4375, 63.4305572509765625, 63.88681411743164062, 4.084071159362792968, 0, 0, -0.8910064697265625, 0.453990638256072998, 120, 255, 1, 45745), -- Bat01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+73, 180427, 0, 12, 87, '0', 0, 0, -9455.111328125, 62.234375, 70.22748565673828125, 0.383971005678176879, 0, 0, 0.190808296203613281, 0.981627285480499267, 120, 255, 1, 45745), -- Bat02 (Area: Goldshire - Difficulty: 0)
+(@OGUID+74, 180427, 0, 12, 87, '0', 0, 0, -9456.8994140625, 61.91319656372070312, 65.7767791748046875, 3.194002151489257812, 0, 0, -0.99965667724609375, 0.026201646775007247, 120, 255, 1, 45745), -- Bat02 (Area: Goldshire - Difficulty: 0)
+(@OGUID+75, 180427, 0, 12, 87, '0', 0, 0, -9458.6533203125, 62.09201431274414062, 71.08200836181640625, 3.368495941162109375, 0, 0, -0.99357128143310546, 0.113208353519439697, 120, 255, 1, 45745), -- Bat02 (Area: Goldshire - Difficulty: 0)
+(@OGUID+76, 180427, 0, 12, 87, '0', 0, 0, -9452.7236328125, 61.9774322509765625, 69.19318389892578125, 4.799657344818115234, 0, 0, -0.67558956146240234, 0.737277925014495849, 120, 255, 1, 45745), -- Bat02 (Area: Goldshire - Difficulty: 0)
+(@OGUID+77, 180427, 0, 12, 87, '0', 0, 0, -9456.7236328125, 60.13194656372070312, 71.7592926025390625, 5.95157480239868164, 0, 0, -0.16504669189453125, 0.986285746097564697, 120, 255, 1, 45745), -- Bat02 (Area: Goldshire - Difficulty: 0)
+(@OGUID+78, 180427, 0, 12, 87, '0', 0, 0, -9460.669921875, 62.18402862548828125, 66.9638671875, 1.919861555099487304, 0, 0, 0.819151878356933593, 0.573576688766479492, 120, 255, 1, 45745), -- Bat02 (Area: Goldshire - Difficulty: 0)
+(@OGUID+79, 180427, 0, 12, 87, '0', 0, 0, -9457.013671875, 61.92534637451171875, 67.107330322265625, 4.555310726165771484, 0, 0, -0.76040554046630859, 0.649448513984680175, 120, 255, 1, 45745), -- Bat02 (Area: Goldshire - Difficulty: 0)
+(@OGUID+80, 180427, 0, 12, 87, '0', 0, 0, -9455.2470703125, 60.8211822509765625, 69.284393310546875, 0.959929943084716796, 0, 0, 0.461748123168945312, 0.887011110782623291, 120, 255, 1, 45745), -- Bat02 (Area: Goldshire - Difficulty: 0)
+(@OGUID+81, 180427, 0, 12, 87, '0', 0, 0, -9457.048828125, 61.70833206176757812, 69.05425262451171875, 2.321286916732788085, 0, 0, 0.917059898376464843, 0.398749500513076782, 120, 255, 1, 45745), -- Bat02 (Area: Goldshire - Difficulty: 0)
+(@OGUID+82, 180427, 0, 12, 87, '0', 0, 0, -9458.1875, 62.92361068725585937, 65.9785003662109375, 0.104719325900077819, 0, 0, 0.052335739135742187, 0.998629570007324218, 120, 255, 1, 45745), -- Bat02 (Area: Goldshire - Difficulty: 0)
+(@OGUID+83, 180428, 0, 12, 87, '0', 0, 0, -9477.029296875, 34.60725784301757812, 56.96610641479492187, 0.139624491333961486, 0, 0, 0.06975555419921875, 0.997564136981964111, 120, 255, 1, 45745), -- G_WitchBroom_01 scale 0.5 (Area: Goldshire - Difficulty: 0)
+(@OGUID+84, 180429, 0, 12, 87, '0', 0, 0, -9473.25390625, 35.55826950073242187, 57.69527053833007812, 6.021387100219726562, 0, 0, -0.13052558898925781, 0.991444945335388183, 120, 255, 1, 45745), -- G_WitchHat_01 scale 0.5 (Area: Goldshire - Difficulty: 0)
+(@OGUID+85, 180471, 0, 12, 87, '0', 0, 0, -9479.138671875, 43.82986068725585937, 65.955841064453125, 2.775068521499633789, 0, 0, 0.983254432678222656, 0.182238012552261352, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+86, 180471, 0, 12, 87, '0', 0, 0, -9483.451171875, 16.17881965637207031, 72.5328369140625, 4.625123500823974609, 0, 0, -0.73727703094482421, 0.67559051513671875, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+87, 180471, 0, 12, 87, '0', 0, 0, -9482.0712890625, 26.06770896911621093, 72.56974029541015625, 4.660029888153076171, 0, 0, -0.72537422180175781, 0.688354730606079101, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+88, 180471, 0, 12, 87, '0', 0, 0, -9480.7919921875, 35.9461822509765625, 72.558258056640625, 4.607671737670898437, 0, 0, -0.74314403533935546, 0.669131457805633544, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+89, 180471, 0, 12, 87, '0', 0, 0, -9450.419921875, 39.09375, 65.899932861328125, 3.194002151489257812, 0, 0, -0.99965667724609375, 0.026201646775007247, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+90, 180471, 0, 12, 87, '0', 0, 0, -9496.1298828125, 87.27951812744140625, 59.73714065551757812, 2.862335443496704101, 0, 0, 0.990267753601074218, 0.139175355434417724, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+91, 180471, 0, 12, 87, '0', 0, 0, -9464.5673828125, -12.390625, 71.78488922119140625, 6.03883981704711914, 0, 0, -0.12186908721923828, 0.9925462007522583, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+92, 180471, 0, 12, 87, '0', 0, 0, -9456.7783203125, -12.0763893127441406, 66.11444854736328125, 1.32644820213317871, 0, 0, 0.615660667419433593, 0.788011372089385986, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+93, 180471, 0, 12, 87, '0', 0, 0, -9483.419921875, 8.895833015441894531, 65.992095947265625, 5.061456203460693359, 0, 0, -0.57357597351074218, 0.819152355194091796, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+94, 180471, 0, 12, 87, '0', 0, 0, -9473.685546875, -10.1163196563720703, 66.03614044189453125, 5.288348197937011718, 0, 0, -0.4771585464477539, 0.878817260265350341, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+95, 180472, 0, 12, 87, '0', 0, 0, -9459.0908203125, 44.88541793823242187, 63.45039749145507812, 1.605701684951782226, 0, 0, 0.719339370727539062, 0.694658815860748291, 120, 255, 1, 45745), -- HangingSkullLight02 (Area: Goldshire - Difficulty: 0)
+(@OGUID+96, 180472, 0, 12, 87, '0', 0, 0, -9479.5205078125, 33.88194656372070312, 66.98166656494140625, 3.089183330535888671, 0, 0, 0.99965667724609375, 0.026201646775007247, 120, 255, 1, 45745), -- HangingSkullLight02 (Area: Goldshire - Difficulty: 0)
+(@OGUID+97, 180472, 0, 12, 87, '0', 0, 0, -9471.7900390625, 39.89529037475585937, 71.10187530517578125, 4.782202720642089843, 0, 0, -0.68199825286865234, 0.731353819370269775, 120, 255, 1, 45745), -- HangingSkullLight02 (Area: Goldshire - Difficulty: 0)
+(@OGUID+98, 180472, 0, 12, 87, '0', 0, 0, -9481.4580078125, 18.32291603088378906, 66.96250152587890625, 3.054326534271240234, 0, 0, 0.999048233032226562, 0.043619260191917419, 120, 255, 1, 45745), -- HangingSkullLight02 (Area: Goldshire - Difficulty: 0)
+(@OGUID+99, 180472, 0, 12, 87, '0', 0, 0, -9475.466796875, 9.111111640930175781, 68.44257354736328125, 4.694936752319335937, 0, 0, -0.71325016021728515, 0.700909554958343505, 120, 255, 1, 45745), -- HangingSkullLight02 (Area: Goldshire - Difficulty: 0)
+(@OGUID+100, 180472, 0, 12, 87, '0', 0, 0, -9452.8037109375, 31.12326431274414062, 68.45298004150390625, 0.104719325900077819, 0, 0, 0.052335739135742187, 0.998629570007324218, 120, 255, 1, 45745), -- HangingSkullLight02 (Area: Goldshire - Difficulty: 0)
+(@OGUID+101, 180472, 0, 12, 87, '0', 0, 0, -9461.6220703125, 12.20448112487792968, 71.80532073974609375, 2.007128477096557617, 0, 0, 0.84339141845703125, 0.537299633026123046, 120, 255, 1, 45745), -- HangingSkullLight02 (Area: Goldshire - Difficulty: 0)
+(@OGUID+102, 180472, 0, 12, 87, '0', 0, 0, -9454.7275390625, 14.67881965637207031, 68.40435028076171875, 0.069811686873435974, 0, 0, 0.034898757934570312, 0.999390840530395507, 120, 255, 1, 45745), -- HangingSkullLight02 (Area: Goldshire - Difficulty: 0)
+(@OGUID+103, 180472, 0, 12, 87, '0', 0, 0, -9464.3125, -9.875, 68.32068634033203125, 4.660029888153076171, 0, 0, -0.72537422180175781, 0.688354730606079101, 120, 255, 1, 45745), -- HangingSkullLight02 (Area: Goldshire - Difficulty: 0)
+(@OGUID+104, 180523, 0, 12, 87, '0', 0, 0, -9460.017578125, 14.81423664093017578, 57.55287551879882812, 4.991643905639648437, 0, 0, -0.60181427001953125, 0.798636078834533691, 120, 255, 1, 45745), -- Apple Bob (Area: Goldshire - Difficulty: 0)
+(@OGUID+105, 180700, 0, 12, 87, '0', 0, 0, -9321.7236328125, 64.5672760009765625, 65.57032012939453125, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 120, 255, 1, 45745), -- Hay Bale 1 (Area: Goldshire - Difficulty: 0)
+(@OGUID+106, 180700, 0, 12, 87, '0', 0, 0, -9328.7705078125, 55.66232681274414062, 61.90797805786132812, 1.239183306694030761, 0, 0, 0.580702781677246093, 0.814115643501281738, 120, 255, 1, 45745), -- Hay Bale 1 (Area: Goldshire - Difficulty: 0)
+(@OGUID+107, 180700, 0, 12, 87, '0', 0, 0, -9321.041015625, 64.51958465576171875, 65.01959991455078125, 1.85004889965057373, 0, 0, 0.798635482788085937, 0.60181504487991333, 120, 255, 1, 45745), -- Hay Bale 1 (Area: Goldshire - Difficulty: 0)
+(@OGUID+108, 180700, 0, 12, 87, '0', 0, 0, -9320.7861328125, 63.76144790649414062, 65.38401031494140625, 2.775068521499633789, 0, 0, 0.983254432678222656, 0.182238012552261352, 120, 255, 1, 45745), -- Hay Bale 1 (Area: Goldshire - Difficulty: 0)
+(@OGUID+109, 180700, 0, 12, 87, '0', 0, 0, -9327.9072265625, 55.87261199951171875, 61.5200958251953125, 3.368495941162109375, 0, 0, -0.99357128143310546, 0.113208353519439697, 120, 255, 1, 45745), -- Hay Bale 1 (Area: Goldshire - Difficulty: 0)
+(@OGUID+110, 180700, 0, 12, 87, '0', 0, 0, -9314.115234375, 52.74272918701171875, 76.76042938232421875, 4.066620349884033203, 0, 0, -0.89493370056152343, 0.44619917869567871, 120, 255, 1, 45745), -- Hay Bale 1 (Area: Goldshire - Difficulty: 0)
+(@OGUID+111, 180700, 0, 12, 87, '0', 0, 0, -9313.3291015625, 46.60671615600585937, 72.58071136474609375, 4.45059061050415039, 0, 0, -0.79335308074951171, 0.608761727809906005, 120, 255, 1, 45745), -- Hay Bale 1 (Area: Goldshire - Difficulty: 0)
+(@OGUID+112, 180700, 0, 12, 87, '0', 0, 0, -9314.1640625, 45.1346588134765625, 72.42285919189453125, 2.024578809738159179, 0, 0, 0.848047256469726562, 0.529920578002929687, 120, 255, 1, 45745), -- Hay Bale 1 (Area: Goldshire - Difficulty: 0)
+(@OGUID+113, 180700, 0, 12, 87, '0', 0, 0, -9313.451171875, 59.1375885009765625, 75.6411285400390625, 3.94444584846496582, 0, 0, -0.92050457000732421, 0.3907318115234375, 120, 255, 1, 45745), -- Hay Bale 1 (Area: Goldshire - Difficulty: 0)
+(@OGUID+114, 186234, 0, 12, 87, '0', 0, 0, -9432.3642578125, 60.296875, 56.40962600708007812, 3.263772249221801757, 0, 0, -0.99813461303710937, 0.061051756143569946, 120, 255, 1, 45745), -- Water Barrel (Area: Goldshire - Difficulty: 0)
+(@OGUID+115, 186234, 0, 12, 87, '0', 0, 0, -9374.9619140625, 52.44444656372070312, 60.75905227661132812, 2.792518377304077148, 0, 0, 0.984807014465332031, 0.173652306199073791, 120, 255, 1, 45745), -- Water Barrel (Area: Goldshire - Difficulty: 0)
+(@OGUID+116, 186614, 0, 12, 87, '0', 0, 0, -9433.3798828125, 61.65451431274414062, 56.49617385864257812, 2.321286916732788085, 0, 0, 0.917059898376464843, 0.398749500513076782, 120, 255, 1, 45745), -- Water Bucket (Area: Goldshire - Difficulty: 0)
+(@OGUID+117, 186614, 0, 12, 87, '0', 0, 0, -9433.419921875, 62.27604293823242187, 56.48929977416992187, 2.164205789566040039, 0, 0, 0.882946968078613281, 0.469472706317901611, 120, 255, 1, 45745), -- Water Bucket (Area: Goldshire - Difficulty: 0)
+(@OGUID+118, 186615, 0, 12, 87, '0', 0, 0, -9432.5419921875, 62.31770706176757812, 56.53895950317382812, 4.310965538024902343, 0, 0, -0.83388519287109375, 0.55193793773651123, 120, 255, 1, 45745), -- Water Buckets (Area: Goldshire - Difficulty: 0)
+(@OGUID+119, 186720, 0, 12, 87, '0', 0, 0, -9321.9033203125, 64.38889312744140625, 65.790313720703125, 2.757613182067871093, 0, 0, 0.981626510620117187, 0.190812408924102783, 120, 255, 1, 45745), -- Fire Effigy (Area: Goldshire - Difficulty: 0)
+(@OGUID+120, 186720, 0, 12, 87, '0', 0, 0, -9328.25, 56.27777862548828125, 62.25088882446289062, 2.600535154342651367, 0, 0, 0.963629722595214843, 0.26724100112915039, 120, 255, 1, 45745), -- Fire Effigy (Area: Goldshire - Difficulty: 0)
+(@OGUID+121, 186720, 0, 12, 87, '0', 0, 0, -9314.1015625, 52.45621871948242187, 76.734344482421875, 2.932138919830322265, 0, 0, 0.994521141052246093, 0.104535527527332305, 120, 255, 1, 45745), -- Fire Effigy (Area: Goldshire - Difficulty: 0)
+(@OGUID+122, 186720, 0, 12, 87, '0', 0, 0, -9313.2646484375, 58.74604034423828125, 75.66614532470703125, 2.827429771423339843, 0, 0, 0.987688064575195312, 0.156436234712600708, 120, 255, 1, 45745), -- Fire Effigy (Area: Goldshire - Difficulty: 0)
+(@OGUID+123, 186720, 0, 12, 87, '0', 0, 0, -9313.744140625, 45.86735153198242187, 72.55771636962890625, 4.136432647705078125, 0, 0, -0.87881660461425781, 0.477159708738327026, 120, 255, 1, 45745), -- Fire Effigy (Area: Goldshire - Difficulty: 0)
+(@OGUID+124, 189303, 0, 12, 87, '0', 0, 0, -9464.7646484375, 17.40554428100585937, 56.9626007080078125, 5.393068790435791015, 0, 0, -0.43051052093505859, 0.902585566043853759, 120, 255, 1, 45745); -- Candy Bucket (Area: Goldshire - Difficulty: 0)
+
+DELETE FROM `creature_addon` WHERE `guid`=9004070;
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES
+(9004070, 0, 0, 0, 0, 0, 1, 0, 69, 0, 0, 0, 0, ''); -- 51934 (Gretchen Fenlow)
+
+-- Event spawns
+DELETE FROM `game_event_creature` WHERE `eventEntry`=12 AND `guid` BETWEEN @CGUID+0 AND @CGUID+47;
+INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES
+(12, @CGUID+0), 
+(12, @CGUID+1), 
+(12, @CGUID+2), 
+(12, @CGUID+3), 
+(12, @CGUID+4), 
+(12, @CGUID+5), 
+(12, @CGUID+6), 
+(12, @CGUID+7), 
+(12, @CGUID+8), 
+(12, @CGUID+9), 
+(12, @CGUID+10),
+(12, @CGUID+11),
+(12, @CGUID+12),
+(12, @CGUID+13),
+(12, @CGUID+14),
+(12, @CGUID+15),
+(12, @CGUID+16),
+(12, @CGUID+17),
+(12, @CGUID+18),
+(12, @CGUID+19),
+(12, @CGUID+20),
+(12, @CGUID+21),
+(12, @CGUID+22),
+(12, @CGUID+23),
+(12, @CGUID+24),
+(12, @CGUID+25),
+(12, @CGUID+26),
+(12, @CGUID+27),
+(12, @CGUID+28),
+(12, @CGUID+29),
+(12, @CGUID+30),
+(12, @CGUID+31),
+(12, @CGUID+32),
+(12, @CGUID+33),
+(12, @CGUID+34),
+(12, @CGUID+35),
+(12, @CGUID+36),
+(12, @CGUID+37),
+(12, @CGUID+38),
+(12, @CGUID+39),
+(12, @CGUID+40),
+(12, @CGUID+41),
+(12, @CGUID+42),
+(12, @CGUID+43),
+(12, @CGUID+44),
+(12, @CGUID+45),
+(12, @CGUID+46),
+(12, @CGUID+47);
+
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+124;
+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),
+(12, @OGUID+79),
+(12, @OGUID+80),
+(12, @OGUID+81),
+(12, @OGUID+82),
+(12, @OGUID+83),
+(12, @OGUID+84),
+(12, @OGUID+85),
+(12, @OGUID+86),
+(12, @OGUID+87),
+(12, @OGUID+88),
+(12, @OGUID+89),
+(12, @OGUID+90),
+(12, @OGUID+91),
+(12, @OGUID+92),
+(12, @OGUID+93),
+(12, @OGUID+94),
+(12, @OGUID+95),
+(12, @OGUID+96),
+(12, @OGUID+97),
+(12, @OGUID+98),
+(12, @OGUID+99),
+(12, @OGUID+100),
+(12, @OGUID+101),
+(12, @OGUID+102),
+(12, @OGUID+103),
+(12, @OGUID+104),
+(12, @OGUID+105),
+(12, @OGUID+106),
+(12, @OGUID+107),
+(12, @OGUID+108),
+(12, @OGUID+109),
+(12, @OGUID+110),
+(12, @OGUID+111),
+(12, @OGUID+112),
+(12, @OGUID+113),
+(12, @OGUID+114),
+(12, @OGUID+115),
+(12, @OGUID+116),
+(12, @OGUID+117),
+(12, @OGUID+118),
+(12, @OGUID+119),
+(12, @OGUID+120),
+(12, @OGUID+121),
+(12, @OGUID+122),
+(12, @OGUID+123),
+(12, @OGUID+124);
+
+-- SAI
+UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=51699;
+
+DELETE FROM `smart_scripts` WHERE `entryorguid`=51699;
+INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `event_param5`, `event_param_string`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `action_param7`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
+(51699,0,0,0,1,0,100,0,0,10000,6000,11000,0,'',10,6,273,274,396,0,0,0,1,0,0,0,0,0,0,0,0,'Wickerman Reveler - Out of combat (6 - 11 seconds) - Play random emote');