aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorMeji <alvaro.megias@outlook.com>2022-10-31 12:47:16 +0100
committerNaddley <NaddleyTC@gmail.com>2022-10-31 12:47:19 +0100
commit6bd40a31dea586088f3e1d1efe251103aef8a895 (patch)
tree33b6c755ebf8e589c422d41cee6038a8c6bc26f5 /sql
parent2a3fd6221bfe87e0a46b2077578b7d69b40b9339 (diff)
DB/Durotar: Added spawns for Hallows End
Closes #28423
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2022_10_31_02_world.sql288
1 files changed, 288 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_10_31_02_world.sql b/sql/updates/world/master/2022_10_31_02_world.sql
new file mode 100644
index 00000000000..32377fab279
--- /dev/null
+++ b/sql/updates/world/master/2022_10_31_02_world.sql
@@ -0,0 +1,288 @@
+SET @CGUID := 395960;
+SET @OGUID := 243704;
+
+-- Creature templates
+UPDATE `creature_template` SET `minlevel`=30, `maxlevel`=30 WHERE `entry`=5953; -- Razor Hill Grunt
+UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=63063; -- Shifty
+
+DELETE FROM `creature_template_addon` WHERE `entry`=5953;
+INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES
+(5953, 0, 0, 0, 257, 0, 0, 0, 0, 0, ''); -- 5953 (Razor Hill Grunt)
+
+-- Gossips
+DELETE FROM `gossip_menu` WHERE (`MenuID`=8842 AND `TextID` IN (11473,11474));
+INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES
+(8842, 11473, 46340), -- 23973 (Masked Orphan Matron)
+(8842, 11474, 46340); -- 23973 (Masked Orphan Matron)
+
+DELETE FROM `gossip_menu_option` WHERE `MenuID`=8842 AND `OptionID`=0;
+INSERT INTO `gossip_menu_option` (`MenuID`, `OptionID`, `OptionNpc`, `OptionText`, `OptionBroadcastTextId`, `Language`, `ActionMenuID`, `ActionPoiID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `VerifiedBuild`) VALUES
+(8842, 0, 0, 'Who is the Headless Horseman?', 22620, 0, 8880, 0, 0, 0, NULL, 0, 46340);
+
+-- Scaling
+DELETE FROM `creature_template_scaling` WHERE `DifficultyID`=0 AND `Entry`=5953;
+INSERT INTO `creature_template_scaling` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `VerifiedBuild`) VALUES
+(5953, 0, 0, 0, 2108, 46340);
+
+UPDATE `creature_template_scaling` SET `LevelScalingDeltaMin`=0, `LevelScalingDeltaMax`=0, `VerifiedBuild`=46340 WHERE (`Entry`=63063 AND `DifficultyID`=0);
+
+-- Gameobject templates
+UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=46340 WHERE `entry`=190064; -- Candy Bucket
+
+UPDATE `gameobject_template_addon` SET `faction`=1735 WHERE `entry`=190064; -- Candy Bucket
+
+-- Quests
+UPDATE `quest_offer_reward` SET `VerifiedBuild`=46340 WHERE `ID`=12361;
+
+DELETE FROM `gameobject_queststarter` WHERE `id`=190064;
+INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
+(190064, 12361, 46340);
+
+UPDATE `gameobject_questender` SET `VerifiedBuild`=46340 WHERE (`id`=190064 AND `quest`=12361);
+
+DELETE FROM `game_event_gameobject_quest` WHERE `id`=190064;
+
+-- Old creature spawns
+DELETE FROM `creature` WHERE `guid` BETWEEN 361993 AND 362033;
+DELETE FROM `game_event_creature` WHERE `guid` BETWEEN 361993 AND 362033;
+
+-- Creature spawns
+DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+46;
+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`, `dynamicflags`, `VerifiedBuild`) VALUES
+(@CGUID+0, 5953, 1, 14, 362, '0', 0, 0, 0, 1, 241.359375, -4562.96875, 18.58214569091796875, 5.8817596435546875, 120, 0, 0, 3412, 0, 0, 0, 0, 0, 46340), -- Razor Hill Grunt (Area: Razor Hill - Difficulty: 0)
+(@CGUID+1, 23537, 1, 14, 362, '0', 0, 0, 0, 0, 320.015625, -4694.52783203125, 29.4495086669921875, 5.497786998748779296, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46340), -- Headless Horseman - Fire (DND) (Area: Razor Hill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+2, 23537, 1, 14, 362, '0', 0, 0, 0, 0, 328.9674072265625, -4767.37548828125, 12.65957260131835937, 4.555309295654296875, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46340), -- Headless Horseman - Fire (DND) (Area: Razor Hill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+3, 23537, 1, 14, 362, '0', 0, 0, 0, 0, 314.915679931640625, -4774.04248046875, 17.21193504333496093, 3.246312379837036132, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46340), -- Headless Horseman - Fire (DND) (Area: Razor Hill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+4, 23537, 1, 14, 362, '0', 0, 0, 0, 0, 301.627777099609375, -4776.4580078125, 19.42165946960449218, 5.009094715118408203, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46340), -- Headless Horseman - Fire (DND) (Area: Razor Hill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+5, 23537, 1, 14, 362, '0', 0, 0, 0, 0, 283.484375, -4701.048828125, 16.75503921508789062, 2.879793167114257812, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46340), -- Headless Horseman - Fire (DND) (Area: Razor Hill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+6, 23537, 1, 14, 362, '0', 0, 0, 0, 0, 274.395843505859375, -4716.43408203125, 21.21046638488769531, 1.989675283432006835, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46340), -- Headless Horseman - Fire (DND) (Area: Razor Hill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+7, 23537, 1, 14, 362, '0', 0, 0, 0, 0, 317.086334228515625, -4772.23291015625, 25.44216156005859375, 3.298672199249267578, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46340), -- Headless Horseman - Fire (DND) (Area: Razor Hill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+8, 23537, 1, 14, 362, '0', 0, 0, 0, 0, 311.118072509765625, -4689.25341796875, 17.54905319213867187, 4.729842185974121093, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46340), -- Headless Horseman - Fire (DND) (Area: Razor Hill - Difficulty: 0) (Auras: 42091 - Headless Horseman - Fire Size, 42154 - Headless Horseman - Dim Fire)
+(@CGUID+9, 23537, 1, 14, 362, '0', 0, 0, 0, 0, 302.1212158203125, -4776.34912109375, 10.57410621643066406, 4.066617012023925781, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46340), -- Headless Horseman - Fire (DND) (Area: Razor Hill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+10, 23537, 1, 14, 362, '0', 0, 0, 0, 0, 269.633697509765625, -4718.5087890625, 18.58950614929199218, 2.687807083129882812, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46340), -- Headless Horseman - Fire (DND) (Area: Razor Hill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+11, 23537, 1, 14, 362, '0', 0, 0, 0, 0, 282.0538330078125, -4709.189453125, 15.38826847076416015, 5.410520553588867187, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46340), -- Headless Horseman - Fire (DND) (Area: Razor Hill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+12, 23537, 1, 14, 362, '0', 0, 0, 0, 0, 285.630218505859375, -4700.109375, 13.22489070892333984, 2.460914134979248046, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46340), -- Headless Horseman - Fire (DND) (Area: Razor Hill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+13, 23537, 1, 14, 362, '0', 0, 0, 0, 0, 298.276214599609375, -4773.83349609375, 10.92465877532958984, 1.239183783531188964, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46340), -- Headless Horseman - Fire (DND) (Area: Razor Hill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+14, 23537, 1, 14, 362, '0', 0, 0, 0, 0, 303.8984375, -4773.7353515625, 27.47631263732910156, 4.031710624694824218, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46340), -- Headless Horseman - Fire (DND) (Area: Razor Hill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+15, 23537, 1, 14, 362, '0', 0, 0, 0, 0, 277.154510498046875, -4698.765625, 18.67828941345214843, 0.314159274101257324, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46340), -- Headless Horseman - Fire (DND) (Area: Razor Hill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+16, 23537, 1, 14, 362, '0', 0, 0, 0, 0, 275.420135498046875, -4718.0400390625, 15.38826847076416015, 0.541052043437957763, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46340), -- Headless Horseman - Fire (DND) (Area: Razor Hill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+17, 23537, 1, 14, 362, '0', 0, 0, 0, 0, 311.313751220703125, -4772.89013671875, 26.594024658203125, 4.660028934478759765, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46340), -- Headless Horseman - Fire (DND) (Area: Razor Hill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+18, 23537, 1, 14, 362, '0', 0, 0, 0, 0, 327.84722900390625, -4699.2412109375, 27.41243934631347656, 1.553343057632446289, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46340), -- Headless Horseman - Fire (DND) (Area: Razor Hill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+19, 23537, 1, 14, 362, '0', 0, 0, 0, 0, 293.19964599609375, -4708.68408203125, 13.19225120544433593, 1.448623299598693847, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46340), -- Headless Horseman - Fire (DND) (Area: Razor Hill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+20, 23537, 1, 14, 362, '0', 0, 0, 0, 0, 320.01214599609375, -4697.533203125, 16.79498481750488281, 6.056292533874511718, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46340), -- Headless Horseman - Fire (DND) (Area: Razor Hill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+21, 23537, 1, 14, 362, '0', 0, 0, 0, 0, 310.052093505859375, -4692.51416015625, 17.39514350891113281, 0.244346097111701965, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46340), -- Headless Horseman - Fire (DND) (Area: Razor Hill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+22, 23537, 1, 14, 362, '0', 0, 0, 0, 0, 313.395782470703125, -4698.97509765625, 15.42339229583740234, 0.122173048555850982, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46340), -- Headless Horseman - Fire (DND) (Area: Razor Hill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+23, 23537, 1, 14, 362, '0', 0, 0, 0, 0, 315.166015625, -4770.603515625, 11.82738018035888671, 3.577924966812133789, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46340), -- Headless Horseman - Fire (DND) (Area: Razor Hill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+24, 23537, 1, 14, 362, '0', 0, 0, 0, 0, 318.645843505859375, -4692.5, 20.45223426818847656, 2.408554315567016601, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46340), -- Headless Horseman - Fire (DND) (Area: Razor Hill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+25, 23537, 1, 14, 362, '0', 0, 0, 0, 0, 292.488067626953125, -4768.1298828125, 11.77597808837890625, 2.076941728591918945, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46340), -- Headless Horseman - Fire (DND) (Area: Razor Hill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+26, 23537, 1, 14, 362, '0', 0, 0, 0, 0, 312.780059814453125, -4771.0009765625, 11.3687744140625, 0.383972436189651489, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46340), -- Headless Horseman - Fire (DND) (Area: Razor Hill - Difficulty: 0) (Auras: 42091 - Headless Horseman - Fire Size, 42154 - Headless Horseman - Dim Fire)
+(@CGUID+27, 23537, 1, 14, 362, '0', 0, 0, 0, 0, 271.07464599609375, -4722.43603515625, 14.23592948913574218, 4.415682792663574218, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46340), -- Headless Horseman - Fire (DND) (Area: Razor Hill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+28, 23537, 1, 14, 362, '0', 0, 0, 0, 0, 324.720855712890625, -4768.03466796875, 12.421783447265625, 3.124139308929443359, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46340), -- Headless Horseman - Fire (DND) (Area: Razor Hill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+29, 23537, 1, 14, 362, '0', 0, 0, 0, 0, 317.743072509765625, -4690.56103515625, 29.57596206665039062, 1.361356854438781738, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46340), -- Headless Horseman - Fire (DND) (Area: Razor Hill - Difficulty: 0) (Auras: 42091 - Headless Horseman - Fire Size, 42154 - Headless Horseman - Dim Fire)
+(@CGUID+30, 23537, 1, 14, 362, '0', 0, 0, 0, 0, 283.125, -4706.24462890625, 15.45350933074951171, 3.50811171531677246, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46340), -- Headless Horseman - Fire (DND) (Area: Razor Hill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+31, 23537, 1, 14, 362, '0', 0, 0, 0, 0, 275.927093505859375, -4712.82666015625, 19.05101585388183593, 4.450589656829833984, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46340), -- Headless Horseman - Fire (DND) (Area: Razor Hill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+32, 23537, 1, 14, 362, '0', 0, 0, 0, 0, 339.46087646484375, -4711.14892578125, 16.30143165588378906, 0.157079637050628662, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46340), -- Headless Horseman - Fire (DND) (Area: Razor Hill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+33, 23537, 1, 14, 362, '0', 0, 0, 0, 0, 343.46527099609375, -4708.6806640625, 29.74063491821289062, 2.234021425247192382, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46340), -- Headless Horseman - Fire (DND) (Area: Razor Hill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+34, 23537, 1, 14, 362, '0', 0, 0, 0, 0, 338.38714599609375, -4705.84716796875, 27.86400604248046875, 3.071779489517211914, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46340), -- Headless Horseman - Fire (DND) (Area: Razor Hill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+35, 23537, 1, 14, 362, '0', 0, 0, 0, 0, 341.05902099609375, -4708.51220703125, 21.40582275390625, 6.195918560028076171, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46340), -- Headless Horseman - Fire (DND) (Area: Razor Hill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire)
+(@CGUID+36, 23537, 1, 14, 362, '0', 0, 0, 0, 0, 344.83160400390625, -4710.359375, 27.25813484191894531, 3.892084121704101562, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46340), -- Headless Horseman - Fire (DND) (Area: Razor Hill - Difficulty: 0) (Auras: 42091 - Headless Horseman - Fire Size, 42154 - Headless Horseman - Dim Fire)
+(@CGUID+37, 23537, 1, 14, 362, '0', 0, 0, 0, 0, 296.083343505859375, -4565.27978515625, 39.0418853759765625, 1.989675283432006835, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46340), -- Headless Horseman - Fire (DND) (Area: Razor Hill - Difficulty: 0)
+(@CGUID+38, 23537, 1, 14, 362, '0', 0, 0, 0, 0, 286.576385498046875, -4561.42529296875, 30.2720489501953125, 2.426007747650146484, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46340), -- Headless Horseman - Fire (DND) (Area: Razor Hill - Difficulty: 0)
+(@CGUID+39, 23537, 1, 14, 362, '0', 0, 0, 0, 0, 289.557281494140625, -4568.09033203125, 39.06153106689453125, 3.577924966812133789, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46340), -- Headless Horseman - Fire (DND) (Area: Razor Hill - Difficulty: 0)
+(@CGUID+40, 23537, 1, 14, 362, '0', 0, 0, 0, 0, 277.961822509765625, -4568.71337890625, 27.27142333984375, 4.118977069854736328, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46340), -- Headless Horseman - Fire (DND) (Area: Razor Hill - Difficulty: 0)
+(@CGUID+41, 23537, 1, 14, 362, '0', 0, 0, 0, 0, 292.838531494140625, -4558.986328125, 31.27065467834472656, 2.39110112190246582, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46340), -- Headless Horseman - Fire (DND) (Area: Razor Hill - Difficulty: 0)
+(@CGUID+42, 23971, 1, 14, 362, '0', 0, 0, 0, 0, 358.94384765625, -4742.3623046875, 9.72699737548828125, 3.385938644409179687, 120, 0, 0, 27, 0, 0, 0, 0, 0, 46340), -- Traveling Orphan (Area: Razor Hill - Difficulty: 0)
+(@CGUID+43, 23971, 1, 14, 362, '0', 0, 0, 0, 0, 358.99462890625, -4744.30029296875, 9.672590255737304687, 2.007128715515136718, 120, 0, 0, 41, 0, 0, 0, 0, 0, 46340), -- Traveling Orphan (Area: Razor Hill - Difficulty: 0)
+(@CGUID+44, 23971, 1, 14, 362, '0', 0, 0, 0, 0, 357.807525634765625, -4740.90087890625, 9.787995338439941406, 4.15388345718383789, 120, 0, 0, 34, 0, 0, 0, 0, 0, 46340), -- Traveling Orphan (Area: Razor Hill - Difficulty: 0)
+(@CGUID+45, 23971, 1, 14, 362, '0', 0, 0, 0, 0, 356.287811279296875, -4740.259765625, 9.8579864501953125, 4.555309295654296875, 120, 0, 0, 41, 0, 0, 0, 0, 0, 46340), -- Traveling Orphan (Area: Razor Hill - Difficulty: 0)
+(@CGUID+46, 23973, 1, 14, 362, '0', 0, 0, 0, 0, 356.1212158203125, -4742.24462890625, 9.828121185302734375, 0.558505356311798095, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46340); -- Masked Orphan Matron (Area: Razor Hill - Difficulty: 0)
+
+-- Old gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 227182 AND 227240;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 227182 AND 227240;
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+63;
+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, 14, 362, '0', 0, 0, 262.71875, -4826.955078125, 20.02585029602050781, 5.427974700927734375, 0, 0, -0.41469287872314453, 0.909961462020874023, 120, 255, 1, 46340), -- G_Pumpkin_01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+1, 180405, 1, 14, 362, '0', 0, 0, 324.9395751953125, -4702.18212890625, 16.15880393981933593, 6.213373661041259765, 0, 0, -0.03489875793457031, 0.999390840530395507, 120, 255, 1, 46340), -- G_Pumpkin_01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+2, 180405, 1, 14, 362, '0', 0, 0, 303.71771240234375, -4777.11572265625, 10.40552997589111328, 3.630291461944580078, 0, 0, -0.97029495239257812, 0.241925001144409179, 120, 255, 1, 46340), -- G_Pumpkin_01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+3, 180405, 1, 14, 362, '0', 0, 0, 242.533172607421875, -4747.6796875, 22.02905082702636718, 4.991643905639648437, 0, 0, -0.60181427001953125, 0.798636078834533691, 120, 255, 1, 46340), -- G_Pumpkin_01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+4, 180405, 1, 14, 362, '0', 0, 0, 376.12152099609375, -4761.78466796875, 20.65706443786621093, 2.775068521499633789, 0, 0, 0.983254432678222656, 0.182238012552261352, 120, 255, 1, 46340), -- G_Pumpkin_01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+5, 180405, 1, 14, 362, '0', 0, 0, 343.784576416015625, -4850.2763671875, 10.35805797576904296, 2.70525527000427246, 0, 0, 0.97629547119140625, 0.216442063450813293, 120, 255, 1, 46340), -- G_Pumpkin_01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+6, 180406, 1, 14, 362, '0', 0, 0, 260.7100830078125, -4821.8349609375, 20.33803558349609375, 5.078907966613769531, 0, 0, -0.56640625, 0.824126183986663818, 120, 255, 1, 46340), -- G_Pumpkin_02 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+7, 180406, 1, 14, 362, '0', 0, 0, 332.858917236328125, -4706.8291015625, 16.07183074951171875, 6.14356088638305664, 0, 0, -0.06975555419921875, 0.997564136981964111, 120, 255, 1, 46340), -- G_Pumpkin_02 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+8, 180406, 1, 14, 362, '0', 0, 0, 277.689239501953125, -4716.71875, 15.30509662628173828, 1.466075778007507324, 0, 0, 0.669130325317382812, 0.74314504861831665, 120, 255, 1, 46340), -- G_Pumpkin_02 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+9, 180406, 1, 14, 362, '0', 0, 0, 359.141693115234375, -4712.2080078125, 14.3102264404296875, 5.427974700927734375, 0, 0, -0.41469287872314453, 0.909961462020874023, 120, 255, 1, 46340), -- G_Pumpkin_02 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+10, 180406, 1, 14, 362, '0', 0, 0, 361.7879638671875, -4772.04833984375, 13.61752891540527343, 4.118979454040527343, 0, 0, -0.88294696807861328, 0.469472706317901611, 120, 255, 1, 46340), -- G_Pumpkin_02 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+11, 180406, 1, 14, 362, '0', 0, 0, 375.951385498046875, -4819.75341796875, 23.02544784545898437, 1.448621988296508789, 0, 0, 0.662619590759277343, 0.748956084251403808, 120, 255, 1, 46340), -- G_Pumpkin_02 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+12, 180407, 1, 14, 362, '0', 0, 0, 309.7706298828125, -4776.31298828125, 10.41299343109130859, 3.735006093978881835, 0, 0, -0.95630455017089843, 0.292372345924377441, 120, 255, 1, 46340), -- G_Pumpkin_03 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+13, 180407, 1, 14, 362, '0', 0, 0, 329.970489501953125, -4702.31787109375, 24.03918647766113281, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 46340), -- G_Pumpkin_03 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+14, 180407, 1, 14, 362, '0', 0, 0, 282.473968505859375, -4709.3525390625, 15.30509662628173828, 1.32644820213317871, 0, 0, 0.615660667419433593, 0.788011372089385986, 120, 255, 1, 46340), -- G_Pumpkin_03 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+15, 180407, 1, 14, 362, '0', 0, 0, 241.7309112548828125, -4724.486328125, 24.23617744445800781, 5.096362113952636718, 0, 0, -0.55919265747070312, 0.829037725925445556, 120, 255, 1, 46340), -- G_Pumpkin_03 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+16, 180407, 1, 14, 362, '0', 0, 0, 387.92333984375, -4712.044921875, 16.460357666015625, 1.832594871520996093, 0, 0, 0.793353080749511718, 0.608761727809906005, 120, 255, 1, 46340), -- G_Pumpkin_03 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+17, 180407, 1, 14, 362, '0', 0, 0, 370.258697509765625, -4831.361328125, 22.14643478393554687, 1.553341388702392578, 0, 0, 0.700908660888671875, 0.713251054286956787, 120, 255, 1, 46340), -- G_Pumpkin_03 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+18, 180411, 1, 14, 362, '0', 0, 0, 324.651031494140625, -4690.10791015625, 44.97956085205078125, 1.012289404869079589, 0, 0, 0.484808921813964843, 0.87462007999420166, 120, 255, 1, 46340), -- G_Ghost_01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+19, 180411, 1, 14, 362, '0', 0, 0, 306.708343505859375, -4775.13525390625, 18.32283210754394531, 4.817109584808349609, 0, 0, -0.66913032531738281, 0.74314504861831665, 120, 255, 1, 46340), -- G_Ghost_01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+20, 180411, 1, 14, 362, '0', 0, 0, 342.49652099609375, -4702.61474609375, 44.81528854370117187, 1.012289404869079589, 0, 0, 0.484808921813964843, 0.87462007999420166, 120, 255, 1, 46340), -- G_Ghost_01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+21, 180411, 1, 14, 362, '0', 0, 0, 329.618072509765625, -4670.66162109375, 45.30430221557617187, 1.012289404869079589, 0, 0, 0.484808921813964843, 0.87462007999420166, 120, 255, 1, 46340), -- G_Ghost_01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+22, 180411, 1, 14, 362, '0', 0, 0, 359.845489501953125, -4687.861328125, 44.27567672729492187, 1.012289404869079589, 0, 0, 0.484808921813964843, 0.87462007999420166, 120, 255, 1, 46340), -- G_Ghost_01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+23, 180411, 1, 14, 362, '0', 0, 0, 352.104156494140625, -4668.8193359375, 44.89104080200195312, 1.012289404869079589, 0, 0, 0.484808921813964843, 0.87462007999420166, 120, 255, 1, 46340), -- G_Ghost_01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+24, 180415, 1, 14, 362, '0', 0, 0, 340.6475830078125, -4684.65283203125, 17.26699638366699218, 1.012289404869079589, 0, 0, 0.484808921813964843, 0.87462007999420166, 120, 255, 1, 46340), -- CandleBlack01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+25, 180425, 1, 14, 362, '0', 0, 0, 340.87847900390625, -4684.75537109375, 17.42671966552734375, 1.012289404869079589, 0, 0, 0.484808921813964843, 0.87462007999420166, 120, 255, 1, 46340), -- SkullCandle01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+26, 180426, 1, 14, 362, '0', 0, 0, 310.6875, -4735.705078125, 19.75810050964355468, 0.069811686873435974, 0, 0, 0.034898757934570312, 0.999390840530395507, 120, 255, 1, 46340), -- Bat01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+27, 180426, 1, 14, 362, '0', 0, 0, 306.317718505859375, -4741.59033203125, 24.0594329833984375, 0.663223206996917724, 0, 0, 0.325567245483398437, 0.945518851280212402, 120, 255, 1, 46340), -- Bat01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+28, 180426, 1, 14, 362, '0', 0, 0, 306.196197509765625, -4741.705078125, 24.37141990661621093, 4.206246376037597656, 0, 0, -0.86162853240966796, 0.50753939151763916, 120, 255, 1, 46340), -- Bat01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+29, 180426, 1, 14, 362, '0', 0, 0, 306.265625, -4741.6650390625, 24.54196357727050781, 5.585053920745849609, 0, 0, -0.34202003479003906, 0.939692676067352294, 120, 255, 1, 46340), -- Bat01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+30, 180426, 1, 14, 362, '0', 0, 0, 306.201385498046875, -4741.65966796875, 21.97466278076171875, 3.054326534271240234, 0, 0, 0.999048233032226562, 0.043619260191917419, 120, 255, 1, 46340), -- Bat01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+31, 180426, 1, 14, 362, '0', 0, 0, 310.755218505859375, -4747.109375, 19.05256843566894531, 0.471238493919372558, 0, 0, 0.233445167541503906, 0.972369968891143798, 120, 255, 1, 46340), -- Bat01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+32, 180426, 1, 14, 362, '0', 0, 0, 302.140625, -4736.734375, 23.53999137878417968, 5.288348197937011718, 0, 0, -0.4771585464477539, 0.878817260265350341, 120, 255, 1, 46340), -- Bat01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+33, 180426, 1, 14, 362, '0', 0, 0, 307.73785400390625, -4743.66650390625, 21.15434837341308593, 0.680676698684692382, 0, 0, 0.333806037902832031, 0.942641794681549072, 120, 255, 1, 46340), -- Bat01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+34, 180426, 1, 14, 362, '0', 0, 0, 301.755218505859375, -4745.12353515625, 24.77006912231445312, 3.298687219619750976, 0, 0, -0.99691677093505859, 0.078466430306434631, 120, 255, 1, 46340), -- Bat01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+35, 180426, 1, 14, 362, '0', 0, 0, 306.2100830078125, -4741.751953125, 25.09734535217285156, 4.712389945983886718, 0, 0, -0.70710659027099609, 0.707106947898864746, 120, 255, 1, 46340), -- Bat01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+36, 180427, 1, 14, 362, '0', 0, 0, 306.18402099609375, -4741.77783203125, 22.59886741638183593, 2.251473426818847656, 0, 0, 0.902585029602050781, 0.430511653423309326, 120, 255, 1, 46340), -- Bat02 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+37, 180427, 1, 14, 362, '0', 0, 0, 306.1875, -4741.67724609375, 29.95493507385253906, 5.201082706451416015, 0, 0, -0.51503753662109375, 0.857167601585388183, 120, 255, 1, 46340), -- Bat02 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+38, 180427, 1, 14, 362, '0', 0, 0, 306.173614501953125, -4741.77978515625, 24.17817878723144531, 0.680676698684692382, 0, 0, 0.333806037902832031, 0.942641794681549072, 120, 255, 1, 46340), -- Bat02 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+39, 180427, 1, 14, 362, '0', 0, 0, 302.2882080078125, -4737.72412109375, 21.08327674865722656, 0.593410074710845947, 0, 0, 0.292370796203613281, 0.95630502700805664, 120, 255, 1, 46340), -- Bat02 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+40, 180427, 1, 14, 362, '0', 0, 0, 306.26910400390625, -4741.74658203125, 28.42695999145507812, 0.314158439636230468, 0, 0, 0.156434059143066406, 0.987688362598419189, 120, 255, 1, 46340), -- Bat02 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+41, 180427, 1, 14, 362, '0', 0, 0, 306.177093505859375, -4741.79541015625, 24.33597373962402343, 1.274088263511657714, 0, 0, 0.594821929931640625, 0.80385744571685791, 120, 255, 1, 46340), -- Bat02 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+42, 180427, 1, 14, 362, '0', 0, 0, 311.4913330078125, -4741.93212890625, 21.98396110534667968, 5.253442287445068359, 0, 0, -0.49242305755615234, 0.870355963706970214, 120, 255, 1, 46340), -- Bat02 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+43, 180427, 1, 14, 362, '0', 0, 0, 306.126739501953125, -4741.6962890625, 25.80809402465820312, 6.213373661041259765, 0, 0, -0.03489875793457031, 0.999390840530395507, 120, 255, 1, 46340), -- Bat02 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+44, 180427, 1, 14, 362, '0', 0, 0, 306.161468505859375, -4741.703125, 25.15346717834472656, 2.111847877502441406, 0, 0, 0.870355606079101562, 0.492423713207244873, 120, 255, 1, 46340), -- Bat02 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+45, 180427, 1, 14, 362, '0', 0, 0, 302.104156494140625, -4746.546875, 20.136871337890625, 5.410521507263183593, 0, 0, -0.42261791229248046, 0.906307935714721679, 120, 255, 1, 46340), -- Bat02 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+46, 180471, 1, 14, 362, '0', 0, 0, 325.01214599609375, -4700.67529296875, 20.89887237548828125, 1.012289404869079589, 0, 0, 0.484808921813964843, 0.87462007999420166, 120, 255, 1, 46340), -- HangingSkullLight01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+47, 180471, 1, 14, 362, '0', 0, 0, 334.21527099609375, -4706.158203125, 20.72696685791015625, 1.012289404869079589, 0, 0, 0.484808921813964843, 0.87462007999420166, 120, 255, 1, 46340), -- HangingSkullLight01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+48, 180472, 1, 14, 362, '0', 0, 0, 330.916656494140625, -4688.34716796875, 24.17425155639648437, 1.012289404869079589, 0, 0, 0.484808921813964843, 0.87462007999420166, 120, 255, 1, 46340), -- HangingSkullLight02 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+49, 180472, 1, 14, 362, '0', 0, 0, 334.33160400390625, -4674.82275390625, 24.21859550476074218, 1.012289404869079589, 0, 0, 0.484808921813964843, 0.87462007999420166, 120, 255, 1, 46340), -- HangingSkullLight02 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+50, 180472, 1, 14, 362, '0', 0, 0, 341.217010498046875, -4695.40966796875, 24.19691658020019531, 1.012289404869079589, 0, 0, 0.484808921813964843, 0.87462007999420166, 120, 255, 1, 46340), -- HangingSkullLight02 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+51, 180472, 1, 14, 362, '0', 0, 0, 353.671875, -4686.4462890625, 24.18587684631347656, 1.012289404869079589, 0, 0, 0.484808921813964843, 0.87462007999420166, 120, 255, 1, 46340), -- HangingSkullLight02 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+52, 180472, 1, 14, 362, '0', 0, 0, 346.6319580078125, -4673.5693359375, 24.17764472961425781, 1.012289404869079589, 0, 0, 0.484808921813964843, 0.87462007999420166, 120, 255, 1, 46340), -- HangingSkullLight02 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+53, 180523, 1, 14, 362, '0', 0, 0, 340.696197509765625, -4697.91162109375, 16.76005172729492187, 1.012289404869079589, 0, 0, 0.484808921813964843, 0.87462007999420166, 120, 255, 1, 46340), -- Apple Bob (Area: Razor Hill - Difficulty: 0)
+(@OGUID+54, 186234, 1, 14, 362, '0', 0, 0, 239.62847900390625, -4562.0087890625, 18.42517280578613281, 2.792518377304077148, 0, 0, 0.984807014465332031, 0.173652306199073791, 120, 255, 1, 46340), -- Water Barrel (Area: Razor Hill - Difficulty: 0)
+(@OGUID+55, 186234, 1, 14, 362, '0', 0, 0, 352.680572509765625, -4740.74658203125, 9.621239662170410156, 3.263772249221801757, 0, 0, -0.99813461303710937, 0.061051756143569946, 120, 255, 1, 46340), -- Water Barrel (Area: Razor Hill - Difficulty: 0)
+(@OGUID+56, 186614, 1, 14, 362, '0', 0, 0, 353.998260498046875, -4739.2568359375, 9.802014350891113281, 2.251473426818847656, 0, 0, 0.902585029602050781, 0.430511653423309326, 120, 255, 1, 46340), -- Water Bucket (Area: Razor Hill - Difficulty: 0)
+(@OGUID+57, 186615, 1, 14, 362, '0', 0, 0, 354.798614501953125, -4740.95166015625, 9.819157600402832031, 2.513273954391479492, 0, 0, 0.951056480407714843, 0.309017121791839599, 120, 255, 1, 46340), -- Water Buckets (Area: Razor Hill - Difficulty: 0)
+(@OGUID+58, 186720, 1, 14, 362, '0', 0, 0, 286.564239501953125, -4561.45166015625, 30.18912696838378906, 2.426007747650146484, 0, 0, 0.936672210693359375, 0.350207358598709106, 120, 255, 1, 46340), -- Fire Effigy (Area: Razor Hill - Difficulty: 0)
+(@OGUID+59, 186720, 1, 14, 362, '0', 0, 0, 289.557281494140625, -4568.09033203125, 38.97819900512695312, 2.251473426818847656, 0, 0, 0.902585029602050781, 0.430511653423309326, 120, 255, 1, 46340), -- Fire Effigy (Area: Razor Hill - Difficulty: 0)
+(@OGUID+60, 186720, 1, 14, 362, '0', 0, 0, 278.171875, -4568.798828125, 26.74064064025878906, 1.640606880187988281, 0, 0, 0.731352806091308593, 0.6819993257522583, 120, 255, 1, 46340), -- Fire Effigy (Area: Razor Hill - Difficulty: 0)
+(@OGUID+61, 186720, 1, 14, 362, '0', 0, 0, 296.095489501953125, -4565.25341796875, 38.96109771728515625, 1.343901276588439941, 0, 0, 0.622513771057128906, 0.78260880708694458, 120, 255, 1, 46340), -- Fire Effigy (Area: Razor Hill - Difficulty: 0)
+(@OGUID+62, 186720, 1, 14, 362, '0', 0, 0, 292.40972900390625, -4558.6474609375, 30.90425682067871093, 3.281238555908203125, 0, 0, -0.99756336212158203, 0.069766148924827575, 120, 255, 1, 46340), -- Fire Effigy (Area: Razor Hill - Difficulty: 0)
+(@OGUID+63, 190064, 1, 14, 362, '0', 0, 0, 342.447906494140625, -4687.626953125, 16.48921394348144531, 5.166176319122314453, 0, 0, -0.52991867065429687, 0.84804844856262207, 120, 255, 1, 46340); -- Candy Bucket (Area: Razor Hill - Difficulty: 0)
+
+-- Event spawns
+DELETE FROM `game_event_creature` WHERE `eventEntry`=12 AND `guid` BETWEEN @CGUID+0 AND @CGUID+46;
+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);
+
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+63;
+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);