diff options
| -rw-r--r-- | sql/updates/world/master/2022_10_28_02_world.sql | 437 |
1 files changed, 437 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_10_28_02_world.sql b/sql/updates/world/master/2022_10_28_02_world.sql new file mode 100644 index 00000000000..3299d439730 --- /dev/null +++ b/sql/updates/world/master/2022_10_28_02_world.sql @@ -0,0 +1,437 @@ +SET @CGUID := 395822; +SET @OGUID := 242528; +SET @NPCTEXTID := 530001; + +-- Creature templates +UPDATE `creature_template` SET `gossip_menu_id`=8973, `minlevel`=30, `maxlevel`=30, `speed_walk`=1 WHERE `entry`=24491; -- Deathguard Florence +UPDATE `creature_template` SET `gossip_menu_id`=12942, `minlevel`=60, `maxlevel`=60 WHERE `entry`=53977; -- Darkcaller Yanka + +DELETE FROM `creature_template_addon` WHERE `entry` IN (24491, 53977); +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(24491, 0, 0, 0, 257, 0, 0, 0, 0, 0, ''), -- 24491 (Deathguard Florence) +(53977, 0, 0, 0, 257, 0, 0, 0, 0, 0, ''); -- 53977 (Darkcaller Yanka) + +-- Gossips +DELETE FROM `npc_text` WHERE `ID`=@NPCTEXTID+0; +INSERT INTO `npc_text` (`ID`, `Probability0`, `Probability1`, `Probability2`, `Probability3`, `Probability4`, `Probability5`, `Probability6`, `Probability7`, `BroadcastTextId0`, `BroadcastTextId1`, `BroadcastTextId2`, `BroadcastTextId3`, `BroadcastTextId4`, `BroadcastTextId5`, `BroadcastTextId6`, `BroadcastTextId7`, `VerifiedBuild`) VALUES +(@NPCTEXTID+0, 1, 0, 0, 0, 0, 0, 0, 0, 52637, 0, 0, 0, 0, 0, 0, 0, 45745); -- 53977 (Darkcaller Yanka) + +DELETE FROM `gossip_menu` WHERE (`MenuID`=8973 AND `TextID`=12108) OR (`MenuID`=12942 AND `TextID`=@NPCTEXTID+0); +INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES +(8973, 12108, 45745), -- 24491 (Deathguard Florence) +(12942, @NPCTEXTID+0, 45745); -- 53977 (Darkcaller Yanka) + +UPDATE `gossip_menu` SET `VerifiedBuild`=45745 WHERE (`MenuID`=8843 AND `TextID`=11477) OR (`MenuID`=9470 AND `TextID` IN (11473,11177)); + +DELETE FROM `gossip_menu_option` WHERE (`MenuID`=9470 AND `OptionID`=0); +INSERT INTO `gossip_menu_option` (`MenuID`, `OptionID`, `OptionNpc`, `OptionText`, `OptionBroadcastTextId`, `Language`, `ActionMenuID`, `ActionPoiID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `VerifiedBuild`) VALUES +(9470, 0, 0, 'Who is the Headless Horseman?', 22620, 0, 8880, 0, 0, 0, NULL, 0, 45745); + +-- Scaling +DELETE FROM `creature_template_scaling` WHERE `DifficultyID`=0 AND `Entry` IN (24491, 53977); +INSERT INTO `creature_template_scaling` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `VerifiedBuild`) VALUES +(24491, 0, 0, 0, 75, 45745), +(53977, 0, 0, 0, 425, 45745); + +-- Gameobject templates +UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=45745 WHERE `entry`=190066; -- Candy Bucket + +UPDATE `gameobject_template_addon` SET `faction`=1735 WHERE `entry`=190066; -- Candy Bucket + +-- Quests +UPDATE `quest_offer_reward` SET `VerifiedBuild`=45745 WHERE `ID`=12363; + +UPDATE `gameobject_questender` SET `VerifiedBuild`=45745 WHERE `id`=190066 AND `quest`=12363; + +-- Old creature spawns +DELETE FROM `creature` WHERE `guid` BETWEEN 362034 AND 362075; +DELETE FROM `creature` WHERE `guid` BETWEEN 362081 AND 362087; +DELETE FROM `game_event_creature` WHERE `guid` BETWEEN 362034 AND 362075; +DELETE FROM `game_event_creature` WHERE `guid` BETWEEN 362081 AND 362087; + +-- Creature spawns +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+49; +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, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2240.095458984375, 459.133697509765625, 38.630889892578125, 4.694935798645019531, 120, 0, 0, 9433, 5751, 0, 0, 0, 0, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) +(@CGUID+1, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2261.326416015625, 347.430572509765625, 43.05722808837890625, 0.541052043437957763, 120, 0, 0, 9433, 5751, 0, 0, 0, 0, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+2, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2254.84033203125, 314.2257080078125, 41.2130584716796875, 1.448623299598693847, 120, 0, 0, 9433, 5751, 0, 0, 0, 0, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+3, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2235.05322265625, 472.6627197265625, 38.12391281127929687, 4.380776405334472656, 120, 0, 0, 9433, 5751, 0, 0, 0, 0, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) +(@CGUID+4, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2230.423583984375, 464.6475830078125, 40.73132705688476562, 2.373647689819335937, 120, 0, 0, 9433, 5751, 0, 0, 0, 0, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) +(@CGUID+5, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2257.7431640625, 317.984375, 41.88471221923828125, 5.410520553588867187, 120, 0, 0, 9433, 5751, 0, 0, 0, 0, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42091 - Headless Horseman - Fire Size, 42154 - Headless Horseman - Dim Fire) +(@CGUID+6, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2251.34375, 337.368072509765625, 42.2274017333984375, 3.298672199249267578, 120, 0, 0, 9433, 5751, 0, 0, 0, 0, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42091 - Headless Horseman - Fire Size, 42154 - Headless Horseman - Dim Fire) +(@CGUID+7, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2254.84716796875, 323.204864501953125, 42.45365142822265625, 2.775073528289794921, 120, 0, 0, 9433, 5751, 0, 0, 0, 0, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+8, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2252.361083984375, 331.067718505859375, 42.41402053833007812, 3.298672199249267578, 120, 0, 0, 9433, 5751, 0, 0, 0, 0, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42091 - Headless Horseman - Fire Size, 42154 - Headless Horseman - Dim Fire) +(@CGUID+9, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2239.493408203125, 487.851959228515625, 37.7115020751953125, 1.239183783531188964, 120, 0, 0, 9433, 5751, 0, 0, 0, 0, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42096 - Headless Horseman - Fire onSpawn, Size, 42074 - Headless Horseman - Fire) +(@CGUID+10, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2231.300048828125, 482.617034912109375, 40.07016372680664062, 3.124139308929443359, 120, 0, 0, 9433, 5751, 0, 0, 0, 0, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) +(@CGUID+11, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2252.342041015625, 309.69964599609375, 44.13006210327148437, 4.066617012023925781, 120, 0, 0, 9433, 5751, 0, 0, 0, 0, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+12, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2246.005126953125, 303.354156494140625, 43.400665283203125, 0.959931075572967529, 120, 0, 0, 9433, 5751, 0, 0, 0, 0, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+13, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2238.9150390625, 304.5, 44.37771987915039062, 3.071779489517211914, 120, 0, 0, 9433, 5751, 0, 0, 0, 0, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+14, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2300.70654296875, 303.961822509765625, 46.98241424560546875, 1.361356854438781738, 120, 0, 0, 9433, 5751, 0, 0, 0, 0, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+15, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2284.486083984375, 291.9288330078125, 46.61287689208984375, 0.541052043437957763, 120, 0, 0, 9433, 5751, 0, 0, 0, 0, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+16, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2231.848876953125, 309.005218505859375, 43.41153717041015625, 3.071779489517211914, 120, 0, 0, 9433, 5751, 0, 0, 0, 0, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+17, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2278.322998046875, 291.321197509765625, 40.31996917724609375, 0.541052043437957763, 120, 0, 0, 9433, 5751, 0, 0, 0, 0, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+18, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2274.392333984375, 289.6944580078125, 48.61417388916015625, 0.541052043437957763, 120, 0, 0, 9433, 5751, 0, 0, 0, 0, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+19, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2293.942626953125, 297.873260498046875, 46.41251373291015625, 2.408554315567016601, 120, 0, 0, 9433, 5751, 0, 0, 0, 0, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+20, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2278.8125, 294.53472900390625, 47.22496795654296875, 0.541052043437957763, 120, 0, 0, 9433, 5751, 0, 0, 0, 0, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+21, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2290.505126953125, 293.51910400390625, 45.98954010009765625, 0.541052043437957763, 120, 0, 0, 9433, 5751, 0, 0, 0, 0, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+22, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2279.421875, 301.767364501953125, 36.4935760498046875, 0.541052043437957763, 120, 0, 0, 9433, 5751, 0, 0, 0, 0, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+23, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2295.428955078125, 303.126739501953125, 47.12674713134765625, 0.418879032135009765, 120, 0, 0, 9433, 5751, 0, 0, 0, 0, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+24, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2260.09375, 269.25347900390625, 40.70278549194335937, 0.541052043437957763, 120, 0, 0, 9433, 5751, 0, 0, 0, 0, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+25, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2280.515625, 275.111114501953125, 49.28763580322265625, 4.328416347503662109, 120, 0, 0, 9433, 5751, 0, 0, 0, 0, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+26, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2274.296875, 271.305572509765625, 37.42652130126953125, 1.553343057632446289, 120, 0, 0, 9433, 5751, 0, 0, 0, 0, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+27, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2273.189208984375, 285.73785400390625, 48.31700897216796875, 4.415682792663574218, 120, 0, 0, 9433, 5751, 0, 0, 0, 0, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+28, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2285.73779296875, 270.548614501953125, 50.0669708251953125, 3.822271108627319335, 120, 0, 0, 9433, 5751, 0, 0, 0, 0, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+29, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2228.833251953125, 292.661468505859375, 42.8594512939453125, 0.541052043437957763, 120, 0, 0, 9433, 5751, 0, 0, 0, 0, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+30, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2274.55029296875, 279.1788330078125, 48.409698486328125, 0.366519153118133544, 120, 0, 0, 9433, 5751, 0, 0, 0, 0, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+31, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2293.850830078125, 257.7257080078125, 44.3997650146484375, 3.577924966812133789, 120, 0, 0, 9433, 5751, 0, 0, 0, 0, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+32, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2287.6494140625, 259.76214599609375, 45.74924087524414062, 6.056292533874511718, 120, 0, 0, 9433, 5751, 0, 0, 0, 0, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+33, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2241.072998046875, 268.640625, 35.41741180419921875, 0.541052043437957763, 120, 0, 0, 9433, 5751, 0, 0, 0, 0, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+34, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2290.99658203125, 257.970489501953125, 41.21030807495117187, 0.244346097111701965, 120, 0, 0, 9433, 5751, 0, 0, 0, 0, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+35, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2286.732666015625, 263.130218505859375, 49.06853485107421875, 5.759586334228515625, 120, 0, 0, 9433, 5751, 0, 0, 0, 0, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+36, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2243.270751953125, 243.640625, 46.15302658081054687, 0.383972436189651489, 120, 0, 0, 9433, 5751, 0, 0, 0, 0, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+37, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2248.6181640625, 243.6458282470703125, 43.66082382202148437, 3.50811171531677246, 120, 0, 0, 9433, 5751, 0, 0, 0, 0, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+38, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2240.4931640625, 242.982635498046875, 48.13275909423828125, 2.007128715515136718, 120, 0, 0, 9433, 5751, 0, 0, 0, 0, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+39, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2234.392333984375, 237.579864501953125, 43.66956710815429687, 4.450589656829833984, 120, 0, 0, 9433, 5751, 0, 0, 0, 0, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+40, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2252.62841796875, 235.0885467529296875, 43.33164596557617187, 2.076941728591918945, 120, 0, 0, 9433, 5751, 0, 0, 0, 0, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+41, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2238.380126953125, 241.4809112548828125, 46.202789306640625, 3.141592741012573242, 120, 0, 0, 9433, 5751, 0, 0, 0, 0, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+42, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2230.328125, 232.3715362548828125, 43.55051422119140625, 2.687807083129882812, 120, 0, 0, 9433, 5751, 0, 0, 0, 0, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+43, 23971, 0, 85, 159, '0', 0, 0, 0, 0, 2224.717041015625, 278.857635498046875, 33.7032012939453125, 2.181661605834960937, 120, 0, 0, 27, 0, 0, 0, 0, 0, 45745), -- Traveling Orphan (Area: Brill - Difficulty: 0) +(@CGUID+44, 23971, 0, 85, 159, '0', 0, 0, 0, 0, 2225.18408203125, 280.41839599609375, 33.70176315307617187, 3.246312379837036132, 120, 0, 0, 27, 0, 0, 0, 0, 0, 45745), -- Traveling Orphan (Area: Brill - Difficulty: 0) +(@CGUID+45, 23971, 0, 85, 159, '0', 0, 0, 0, 0, 2223.236083984375, 278.833343505859375, 33.88888931274414062, 1.2042771577835083, 120, 0, 0, 27, 0, 0, 0, 0, 0, 45745), -- Traveling Orphan (Area: Brill - Difficulty: 0) +(@CGUID+46, 23971, 0, 85, 159, '0', 0, 0, 0, 0, 2224.944580078125, 281.713531494140625, 33.7413177490234375, 3.979350566864013671, 120, 0, 0, 34, 0, 0, 0, 0, 0, 45745), -- Traveling Orphan (Area: Brill - Difficulty: 0) +(@CGUID+47, 23973, 0, 85, 159, '0', 0, 0, 0, 0, 2223.42529296875, 280.708343505859375, 33.82149124145507812, 5.637413501739501953, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45745), -- Masked Orphan Matron (Area: Brill - Difficulty: 0) +(@CGUID+48, 24491, 0, 85, 159, '0', 0, 0, 0, 1, 2256.2353515625, 471.555084228515625, 34.11893463134765625, 0.296705961227416992, 120, 0, 0, 3208, 0, 0, 0, 0, 0, 45745), -- Deathguard Florence (Area: Brill - Difficulty: 0) +(@CGUID+49, 53977, 0, 14046, 0, '0', 0, 0, 0, 1, 2070.704833984375, 285.623260498046875, 97.1148681640625, 2.827433347702026367, 120, 0, 0, 58955, 0, 0, 0, 0, 0, 45745); -- Darkcaller Yanka (Area: 0 - Difficulty: 0) + +-- Old gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN 229499 AND 229709; +DELETE FROM `gameobject` WHERE `guid` BETWEEN 230023 AND 230029; +DELETE FROM `gameobject` WHERE `guid` IN (229455, 229768, 229769); +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 229499 AND 229709; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 230023 AND 230029; +DELETE FROM `game_event_gameobject` WHERE `guid` IN (229455, 229768, 229769); + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+131; +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, 85, 159, '0', 0, 0, 2268.817626953125, 422.5069580078125, 34.3983154296875, 3.368495941162109375, 0, 0, -0.99357128143310546, 0.113208353519439697, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Brill - Difficulty: 0) +(@OGUID+1, 180405, 0, 85, 159, '0', 0, 0, 2269.35595703125, 376.489593505859375, 46.12230682373046875, 1.32644820213317871, 0, 0, 0.615660667419433593, 0.788011372089385986, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Brill - Difficulty: 0) +(@OGUID+2, 180405, 0, 85, 159, '0', 0, 0, 2271.475830078125, 377.70660400390625, 35.9481201171875, 1.518436193466186523, 0, 0, 0.6883544921875, 0.725374460220336914, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Brill - Difficulty: 0) +(@OGUID+3, 180405, 0, 85, 159, '0', 0, 0, 2277.2744140625, 291.432281494140625, 48.373809814453125, 4.468043327331542968, 0, 0, -0.7880105972290039, 0.615661680698394775, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Brill - Difficulty: 0) +(@OGUID+4, 180405, 0, 85, 159, '0', 0, 0, 2247.513916015625, 296.4444580078125, 36.89109420776367187, 0.907570242881774902, 0, 0, 0.438370704650878906, 0.898794233798980712, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Brill - Difficulty: 0) +(@OGUID+5, 180405, 0, 85, 159, '0', 0, 0, 2272.166748046875, 278.348968505859375, 35.35729217529296875, 4.712389945983886718, 0, 0, -0.70710659027099609, 0.707106947898864746, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Brill - Difficulty: 0) +(@OGUID+6, 180405, 0, 85, 159, '0', 0, 0, 2259.62841796875, 269.189239501953125, 40.6492462158203125, 4.328419685363769531, 0, 0, -0.82903671264648437, 0.559194147586822509, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Brill - Difficulty: 0) +(@OGUID+7, 180405, 0, 85, 159, '0', 0, 0, 2244.390625, 253.44097900390625, 33.58501434326171875, 0.942476630210876464, 0, 0, 0.453989982604980468, 0.891006767749786376, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Brill - Difficulty: 0) +(@OGUID+8, 180405, 0, 85, 159, '0', 0, 0, 2326.239501953125, 242.013885498046875, 29.50647735595703125, 1.884953022003173828, 0, 0, 0.809016227722167968, 0.587786316871643066, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Brill - Difficulty: 0) +(@OGUID+9, 180405, 0, 85, 159, '0', 0, 0, 2295.84033203125, 205.829864501953125, 34.25822067260742187, 4.310965538024902343, 0, 0, -0.83388519287109375, 0.55193793773651123, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Brill - Difficulty: 0) +(@OGUID+10, 180405, 0, 85, 159, '0', 0, 0, 2173.7431640625, 236.9739532470703125, 38.3304595947265625, 6.108653545379638671, 0, 0, -0.08715534210205078, 0.996194720268249511, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Brill - Difficulty: 0) +(@OGUID+11, 180405, 0, 14046, 0, '0', 0, 0, 2093.842041015625, 318.810760498046875, 54.18476486206054687, 2.076939344406127929, 0, 0, 0.861628532409667968, 0.50753939151763916, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: 0 - Difficulty: 0) +(@OGUID+12, 180405, 0, 14046, 0, '0', 0, 0, 2069.526611328125, 282.1065673828125, 97.03143310546875, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: 0 - Difficulty: 0) +(@OGUID+13, 180405, 0, 14046, 0, '0', 0, 0, 2055.904541015625, 248.9583282470703125, 99.768707275390625, 0.436331570148468017, 0, 0, 0.216439247131347656, 0.976296067237854003, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: 0 - Difficulty: 0) +(@OGUID+14, 180405, 0, 14046, 0, '0', 0, 0, 2059.69091796875, 308.01910400390625, 54.52080917358398437, 5.131268978118896484, 0, 0, -0.54463863372802734, 0.838670849800109863, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: 0 - Difficulty: 0) +(@OGUID+15, 180405, 0, 14046, 0, '0', 0, 0, 2047.3214111328125, 280.66290283203125, 56.46856689453125, 4.904376029968261718, 0, 0, -0.636077880859375, 0.771624863147735595, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: 0 - Difficulty: 0) +(@OGUID+16, 180406, 0, 85, 159, '0', 0, 0, 2313.342041015625, 401.7413330078125, 33.9480133056640625, 5.375615119934082031, 0, 0, -0.4383707046508789, 0.898794233798980712, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Brill - Difficulty: 0) +(@OGUID+17, 180406, 0, 85, 159, '0', 0, 0, 2261.1650390625, 339.638885498046875, 34.18529129028320312, 1.675513744354248046, 0, 0, 0.743144035339355468, 0.669131457805633544, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Brill - Difficulty: 0) +(@OGUID+18, 180406, 0, 85, 159, '0', 0, 0, 2284.876708984375, 425.3194580078125, 34.33960342407226562, 3.630291461944580078, 0, 0, -0.97029495239257812, 0.241925001144409179, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Brill - Difficulty: 0) +(@OGUID+19, 180406, 0, 85, 159, '0', 0, 0, 2272.126708984375, 285.973968505859375, 55.36051177978515625, 4.747295856475830078, 0, 0, -0.69465827941894531, 0.719339847564697265, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Brill - Difficulty: 0) +(@OGUID+20, 180406, 0, 85, 159, '0', 0, 0, 2270.401123046875, 281.10589599609375, 48.33415985107421875, 4.607671737670898437, 0, 0, -0.74314403533935546, 0.669131457805633544, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Brill - Difficulty: 0) +(@OGUID+21, 180406, 0, 85, 159, '0', 0, 0, 2239.37841796875, 270.883697509765625, 35.32658767700195312, 3.473210096359252929, 0, 0, -0.98628520965576171, 0.165049895644187927, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Brill - Difficulty: 0) +(@OGUID+22, 180406, 0, 85, 159, '0', 0, 0, 2340.810791015625, 271.513885498046875, 34.49287796020507812, 3.473210096359252929, 0, 0, -0.98628520965576171, 0.165049895644187927, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Brill - Difficulty: 0) +(@OGUID+23, 180406, 0, 85, 159, '0', 0, 0, 2217.239501953125, 270.196197509765625, 38.78445053100585937, 1.448621988296508789, 0, 0, 0.662619590759277343, 0.748956084251403808, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Brill - Difficulty: 0) +(@OGUID+24, 180406, 0, 85, 159, '0', 0, 0, 2239.432373046875, 245.84722900390625, 50.15337753295898437, 3.9793548583984375, 0, 0, -0.9135446548461914, 0.406738430261611938, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Brill - Difficulty: 0) +(@OGUID+25, 180406, 0, 85, 159, '0', 0, 0, 2297.3212890625, 208.298614501953125, 33.93912506103515625, 4.433136463165283203, 0, 0, -0.79863548278808593, 0.60181504487991333, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Brill - Difficulty: 0) +(@OGUID+26, 180406, 0, 85, 159, '0', 0, 0, 2183.5400390625, 224.453125, 37.49752426147460937, 5.096362113952636718, 0, 0, -0.55919265747070312, 0.829037725925445556, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Brill - Difficulty: 0) +(@OGUID+27, 180406, 0, 14046, 0, '0', 0, 0, 2082.337158203125, 273.5054931640625, 56.9151763916015625, 1.745326757431030273, 0, 0, 0.766043663024902343, 0.642788589000701904, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: 0 - Difficulty: 0) +(@OGUID+28, 180406, 0, 14046, 0, '0', 0, 0, 2091.30908203125, 327.592010498046875, 54.47382354736328125, 1.902408957481384277, 0, 0, 0.814115524291992187, 0.580702960491180419, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: 0 - Difficulty: 0) +(@OGUID+29, 180406, 0, 14046, 0, '0', 0, 0, 2049.03466796875, 289.130218505859375, 56.72039031982421875, 4.886923789978027343, 0, 0, -0.64278697967529296, 0.766044974327087402, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: 0 - Difficulty: 0) +(@OGUID+30, 180406, 0, 14046, 0, '0', 0, 0, 2063.32470703125, 342.52777099609375, 82.36009979248046875, 2.059488296508789062, 0, 0, 0.857167243957519531, 0.515038192272186279, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: 0 - Difficulty: 0) +(@OGUID+31, 180407, 0, 85, 159, '0', 0, 0, 2313.015625, 394.001739501953125, 33.90306472778320312, 4.886923789978027343, 0, 0, -0.64278697967529296, 0.766044974327087402, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Brill - Difficulty: 0) +(@OGUID+32, 180407, 0, 85, 159, '0', 0, 0, 2276.77783203125, 389.90625, 34.37842178344726562, 2.111847877502441406, 0, 0, 0.870355606079101562, 0.492423713207244873, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Brill - Difficulty: 0) +(@OGUID+33, 180407, 0, 85, 159, '0', 0, 0, 2262.20654296875, 320.3038330078125, 33.58481597900390625, 1.256635904312133789, 0, 0, 0.587784767150878906, 0.809017360210418701, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Brill - Difficulty: 0) +(@OGUID+34, 180407, 0, 85, 159, '0', 0, 0, 2284.595458984375, 299.557281494140625, 37.51879501342773437, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Brill - Difficulty: 0) +(@OGUID+35, 180407, 0, 85, 159, '0', 0, 0, 2272.421875, 290.62847900390625, 48.33542251586914062, 4.886923789978027343, 0, 0, -0.64278697967529296, 0.766044974327087402, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Brill - Difficulty: 0) +(@OGUID+36, 180407, 0, 85, 159, '0', 0, 0, 2274.7744140625, 278.2413330078125, 48.36402130126953125, 5.410521507263183593, 0, 0, -0.42261791229248046, 0.906307935714721679, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Brill - Difficulty: 0) +(@OGUID+37, 180407, 0, 85, 159, '0', 0, 0, 2205.4375, 296.526031494140625, 39.30980300903320312, 2.687806606292724609, 0, 0, 0.974370002746582031, 0.224951311945915222, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Brill - Difficulty: 0) +(@OGUID+38, 180407, 0, 85, 159, '0', 0, 0, 2279.710205078125, 252.6145782470703125, 35.49803543090820312, 5.410521507263183593, 0, 0, -0.42261791229248046, 0.906307935714721679, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Brill - Difficulty: 0) +(@OGUID+39, 180407, 0, 85, 159, '0', 0, 0, 2234.15283203125, 254.84722900390625, 33.57361602783203125, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Brill - Difficulty: 0) +(@OGUID+40, 180407, 0, 85, 159, '0', 0, 0, 2293.0087890625, 205.046875, 33.8228912353515625, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Brill - Difficulty: 0) +(@OGUID+41, 180407, 0, 85, 159, '0', 0, 0, 2326.578125, 223.53472900390625, 28.71483802795410156, 2.303830623626708984, 0, 0, 0.913544654846191406, 0.406738430261611938, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Brill - Difficulty: 0) +(@OGUID+42, 180407, 0, 14046, 0, '0', 0, 0, 2084.196533203125, 281.981964111328125, 57.29332733154296875, 1.745326757431030273, 0, 0, 0.766043663024902343, 0.642788589000701904, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: 0 - Difficulty: 0) +(@OGUID+43, 180407, 0, 14046, 0, '0', 0, 0, 2057.39404296875, 315.552093505859375, 54.15450286865234375, 5.6897735595703125, 0, 0, -0.29237174987792968, 0.956304728984832763, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: 0 - Difficulty: 0) +(@OGUID+44, 180407, 0, 14046, 0, '0', 0, 0, 2062.645751953125, 247.611114501953125, 99.76775360107421875, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: 0 - Difficulty: 0) +(@OGUID+45, 180407, 0, 14046, 0, '0', 0, 0, 2062.9306640625, 283.673919677734375, 97.03136444091796875, 2.792518377304077148, 0, 0, 0.984807014465332031, 0.173652306199073791, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: 0 - Difficulty: 0) +(@OGUID+46, 180408, 0, 85, 159, '0', 0, 0, 2238.963623046875, 269.270843505859375, 46.97807693481445312, 2.879789113998413085, 0, 0, 0.991444587707519531, 0.130528271198272705, 120, 255, 1, 45745), -- G_WitchHat_01 (Area: Brill - Difficulty: 0) +(@OGUID+47, 180410, 0, 85, 159, '0', 0, 0, 2252.017333984375, 311.052093505859375, 34.86345291137695312, 1.047197580337524414, 0, 0, 0.5, 0.866025388240814208, 120, 255, 1, 45745), -- G_HangingSkeleton_01 (Area: Brill - Difficulty: 0) +(@OGUID+48, 180410, 0, 85, 159, '0', 0, 0, 2287.73095703125, 290.611114501953125, 35.64279937744140625, 4.293513298034667968, 0, 0, -0.8386697769165039, 0.544640243053436279, 120, 255, 1, 45745), -- G_HangingSkeleton_01 (Area: Brill - Difficulty: 0) +(@OGUID+49, 180410, 0, 85, 159, '0', 0, 0, 2272.585205078125, 282.177093505859375, 35.02240371704101562, 2.146752834320068359, 0, 0, 0.878816604614257812, 0.477159708738327026, 120, 255, 1, 45745), -- G_HangingSkeleton_01 (Area: Brill - Difficulty: 0) +(@OGUID+50, 180410, 0, 85, 159, '0', 0, 0, 2307.703125, 285.130218505859375, 34.674072265625, 3.124123096466064453, 0, 0, 0.99996185302734375, 0.008734640665352344, 120, 255, 1, 45745), -- G_HangingSkeleton_01 (Area: Brill - Difficulty: 0) +(@OGUID+51, 180410, 0, 85, 159, '0', 0, 0, 2304.954833984375, 272.111114501953125, 34.550872802734375, 2.775068521499633789, 0, 0, 0.983254432678222656, 0.182238012552261352, 120, 255, 1, 45745), -- G_HangingSkeleton_01 (Area: Brill - Difficulty: 0) +(@OGUID+52, 180410, 0, 85, 159, '0', 0, 0, 2284.260498046875, 275.414947509765625, 34.68327713012695312, 1.308995485305786132, 0, 0, 0.608760833740234375, 0.793353796005249023, 120, 255, 1, 45745), -- G_HangingSkeleton_01 (Area: Brill - Difficulty: 0) +(@OGUID+53, 180410, 0, 85, 159, '0', 0, 0, 2242.65625, 245.0121612548828125, 35.51081085205078125, 2.792518377304077148, 0, 0, 0.984807014465332031, 0.173652306199073791, 120, 255, 1, 45745), -- G_HangingSkeleton_01 (Area: Brill - Difficulty: 0) +(@OGUID+54, 180411, 0, 85, 159, '0', 0, 0, 2260.7119140625, 314.29339599609375, 43.70012283325195312, 5.654868602752685546, 0, 0, -0.30901622772216796, 0.95105677843093872, 120, 255, 1, 45745), -- G_Ghost_01 (Area: Brill - Difficulty: 0) +(@OGUID+55, 180411, 0, 85, 159, '0', 0, 0, 2258, 309.598968505859375, 43.64711380004882812, 5.35816192626953125, 0, 0, -0.446197509765625, 0.894934535026550292, 120, 255, 1, 45745), -- G_Ghost_01 (Area: Brill - Difficulty: 0) +(@OGUID+56, 180411, 0, 85, 159, '0', 0, 0, 2272.2744140625, 290.774322509765625, 40.96544265747070312, 5.969027042388916015, 0, 0, -0.1564340591430664, 0.987688362598419189, 120, 255, 1, 45745), -- G_Ghost_01 (Area: Brill - Difficulty: 0) +(@OGUID+57, 180411, 0, 85, 159, '0', 0, 0, 2300.557373046875, 281.4375, 36.82360458374023437, 0.698131442070007324, 0, 0, 0.342020034790039062, 0.939692676067352294, 120, 255, 1, 45745), -- G_Ghost_01 (Area: Brill - Difficulty: 0) +(@OGUID+58, 180411, 0, 85, 159, '0', 0, 0, 2270.46875, 281.274322509765625, 40.94758987426757812, 1.431168079376220703, 0, 0, 0.656058311462402343, 0.754710197448730468, 120, 255, 1, 45745), -- G_Ghost_01 (Area: Brill - Difficulty: 0) +(@OGUID+59, 180411, 0, 85, 159, '0', 0, 0, 2243.123291015625, 246.8993072509765625, 36.92656326293945312, 3.665196180343627929, 0, 0, -0.96592521667480468, 0.258821308612823486, 120, 255, 1, 45745), -- G_Ghost_01 (Area: Brill - Difficulty: 0) +(@OGUID+60, 180411, 0, 85, 159, '0', 0, 0, 2236.14404296875, 244.00347900390625, 36.92360687255859375, 2.129300594329833984, 0, 0, 0.874619483947753906, 0.484810054302215576, 120, 255, 1, 45745), -- G_Ghost_01 (Area: Brill - Difficulty: 0) +(@OGUID+61, 180415, 0, 85, 159, '0', 0, 0, 2270.81591796875, 287.732635498046875, 33.69063186645507812, 4.45059061050415039, 0, 0, -0.79335308074951171, 0.608761727809906005, 120, 255, 1, 45745), -- CandleBlack01 (Area: Brill - Difficulty: 0) +(@OGUID+62, 180415, 0, 85, 159, '0', 0, 0, 2273.079833984375, 286.541656494140625, 33.96987533569335937, 3.90954136848449707, 0, 0, -0.92718315124511718, 0.37460830807685852, 120, 255, 1, 45745), -- CandleBlack01 (Area: Brill - Difficulty: 0) +(@OGUID+63, 180415, 0, 85, 159, '0', 0, 0, 2272.6875, 284.44097900390625, 34.00270462036132812, 3.961898565292358398, 0, 0, -0.91705989837646484, 0.398749500513076782, 120, 255, 1, 45745), -- CandleBlack01 (Area: Brill - Difficulty: 0) +(@OGUID+64, 180415, 0, 85, 159, '0', 0, 0, 2270.91845703125, 282.420135498046875, 33.92834091186523437, 0.017452461645007133, 0, 0, 0.008726119995117187, 0.999961912631988525, 120, 255, 1, 45745), -- CandleBlack01 (Area: Brill - Difficulty: 0) +(@OGUID+65, 180415, 0, 85, 159, '0', 0, 0, 2268.94091796875, 282.901031494140625, 33.82201004028320312, 2.67034769058227539, 0, 0, 0.972369194030761718, 0.233448356389999389, 120, 255, 1, 45745), -- CandleBlack01 (Area: Brill - Difficulty: 0) +(@OGUID+66, 180425, 0, 85, 159, '0', 0, 0, 2262.538330078125, 329.243072509765625, 34.74338531494140625, 0.122172988951206207, 0, 0, 0.061048507690429687, 0.998134791851043701, 120, 255, 1, 45745), -- SkullCandle01 (Area: Brill - Difficulty: 0) +(@OGUID+67, 180425, 0, 85, 159, '0', 0, 0, 2267.710205078125, 290.73785400390625, 35.65375900268554687, 0.750490784645080566, 0, 0, 0.3665008544921875, 0.93041771650314331, 120, 255, 1, 45745), -- SkullCandle01 (Area: Brill - Difficulty: 0) +(@OGUID+68, 180425, 0, 85, 159, '0', 0, 0, 2267.09033203125, 290.15277099609375, 35.63885116577148437, 4.049167633056640625, 0, 0, -0.89879322052001953, 0.438372820615768432, 120, 255, 1, 45745), -- SkullCandle01 (Area: Brill - Difficulty: 0) +(@OGUID+69, 180425, 0, 85, 159, '0', 0, 0, 2241.39404296875, 272.229156494140625, 35.33657073974609375, 1.308995485305786132, 0, 0, 0.608760833740234375, 0.793353796005249023, 120, 255, 1, 45745), -- SkullCandle01 (Area: Brill - Difficulty: 0) +(@OGUID+70, 180425, 0, 85, 159, '0', 0, 0, 2239.83154296875, 272.664947509765625, 35.36143112182617187, 1.186823248863220214, 0, 0, 0.559192657470703125, 0.829037725925445556, 120, 255, 1, 45745), -- SkullCandle01 (Area: Brill - Difficulty: 0) +(@OGUID+71, 180426, 0, 85, 159, '0', 0, 0, 2263.7275390625, 288.914947509765625, 44.90937042236328125, 3.351046562194824218, 0, 0, -0.99452114105224609, 0.104535527527332305, 120, 255, 1, 45745), -- Bat01 (Area: Brill - Difficulty: 0) +(@OGUID+72, 180426, 0, 85, 159, '0', 0, 0, 2260.861083984375, 292.28125, 45.84617996215820312, 1.134462952613830566, 0, 0, 0.537299156188964843, 0.843391716480255126, 120, 255, 1, 45745), -- Bat01 (Area: Brill - Difficulty: 0) +(@OGUID+73, 180426, 0, 85, 159, '0', 0, 0, 2262.803955078125, 290.63714599609375, 45.96056365966796875, 4.869470596313476562, 0, 0, -0.64944744110107421, 0.760406434535980224, 120, 255, 1, 45745), -- Bat01 (Area: Brill - Difficulty: 0) +(@OGUID+74, 180426, 0, 85, 159, '0', 0, 0, 2261.6806640625, 289.217010498046875, 47.07680130004882812, 4.520402908325195312, 0, 0, -0.77162456512451171, 0.636078238487243652, 120, 255, 1, 45745), -- Bat01 (Area: Brill - Difficulty: 0) +(@OGUID+75, 180426, 0, 85, 159, '0', 0, 0, 2260.68408203125, 289.57464599609375, 54.01663589477539062, 4.084071159362792968, 0, 0, -0.8910064697265625, 0.453990638256072998, 120, 255, 1, 45745), -- Bat01 (Area: Brill - Difficulty: 0) +(@OGUID+76, 180426, 0, 85, 159, '0', 0, 0, 2260.53466796875, 285.626739501953125, 45.98318099975585937, 0.645771682262420654, 0, 0, 0.317304611206054687, 0.948323667049407958, 120, 255, 1, 45745), -- Bat01 (Area: Brill - Difficulty: 0) +(@OGUID+77, 180426, 0, 85, 159, '0', 0, 0, 2260.9306640625, 287.453125, 45.70987319946289062, 3.961898565292358398, 0, 0, -0.91705989837646484, 0.398749500513076782, 120, 255, 1, 45745), -- Bat01 (Area: Brill - Difficulty: 0) +(@OGUID+78, 180426, 0, 85, 159, '0', 0, 0, 2263.53466796875, 286.48785400390625, 45.85614395141601562, 5.462882041931152343, 0, 0, -0.39874839782714843, 0.917060375213623046, 120, 255, 1, 45745), -- Bat01 (Area: Brill - Difficulty: 0) +(@OGUID+79, 180426, 0, 85, 159, '0', 0, 0, 2262.95654296875, 287.760406494140625, 45.75661849975585937, 4.712389945983886718, 0, 0, -0.70710659027099609, 0.707106947898864746, 120, 255, 1, 45745), -- Bat01 (Area: Brill - Difficulty: 0) +(@OGUID+80, 180426, 0, 85, 159, '0', 0, 0, 2264.888916015625, 287.03125, 51.21295547485351562, 3.071766138076782226, 0, 0, 0.999390602111816406, 0.034906134009361267, 120, 255, 1, 45745), -- Bat01 (Area: Brill - Difficulty: 0) +(@OGUID+81, 180427, 0, 85, 159, '0', 0, 0, 2260.732666015625, 291.78125, 45.87396621704101562, 4.869470596313476562, 0, 0, -0.64944744110107421, 0.760406434535980224, 120, 255, 1, 45745), -- Bat02 (Area: Brill - Difficulty: 0) +(@OGUID+82, 180427, 0, 85, 159, '0', 0, 0, 2257.78125, 290.126739501953125, 45.70293426513671875, 4.345870018005371093, 0, 0, -0.82412624359130859, 0.566406130790710449, 120, 255, 1, 45745), -- Bat02 (Area: Brill - Difficulty: 0) +(@OGUID+83, 180427, 0, 85, 159, '0', 0, 0, 2259.41845703125, 290.055572509765625, 41.71333694458007812, 3.490667104721069335, 0, 0, -0.98480701446533203, 0.173652306199073791, 120, 255, 1, 45745), -- Bat02 (Area: Brill - Difficulty: 0) +(@OGUID+84, 180427, 0, 85, 159, '0', 0, 0, 2261.864501953125, 291.34375, 51.23927688598632812, 6.195919513702392578, 0, 0, -0.04361915588378906, 0.999048233032226562, 120, 255, 1, 45745), -- Bat02 (Area: Brill - Difficulty: 0) +(@OGUID+85, 180427, 0, 85, 159, '0', 0, 0, 2261.73779296875, 290.5069580078125, 47.17763137817382812, 0.24434557557106018, 0, 0, 0.121869087219238281, 0.9925462007522583, 120, 255, 1, 45745), -- Bat02 (Area: Brill - Difficulty: 0) +(@OGUID+86, 180427, 0, 85, 159, '0', 0, 0, 2259.001708984375, 291.609375, 45.74871063232421875, 3.351046562194824218, 0, 0, -0.99452114105224609, 0.104535527527332305, 120, 255, 1, 45745), -- Bat02 (Area: Brill - Difficulty: 0) +(@OGUID+87, 180427, 0, 85, 159, '0', 0, 0, 2259.4306640625, 288.4757080078125, 45.70293426513671875, 2.967041015625, 0, 0, 0.996193885803222656, 0.087165042757987976, 120, 255, 1, 45745), -- Bat02 (Area: Brill - Difficulty: 0) +(@OGUID+88, 180427, 0, 85, 159, '0', 0, 0, 2257.505126953125, 288.4913330078125, 41.71333694458007812, 2.687806606292724609, 0, 0, 0.974370002746582031, 0.224951311945915222, 120, 255, 1, 45745), -- Bat02 (Area: Brill - Difficulty: 0) +(@OGUID+89, 180427, 0, 85, 159, '0', 0, 0, 2259.5087890625, 286.65277099609375, 48.82779312133789062, 1.256635904312133789, 0, 0, 0.587784767150878906, 0.809017360210418701, 120, 255, 1, 45745), -- Bat02 (Area: Brill - Difficulty: 0) +(@OGUID+90, 180427, 0, 85, 159, '0', 0, 0, 2258.489501953125, 287.513885498046875, 48.70108413696289062, 3.141592741012573242, 0, 0, -1, 0, 120, 255, 1, 45745), -- Bat02 (Area: Brill - Difficulty: 0) +(@OGUID+91, 180428, 0, 85, 159, '0', 0, 0, 2272.263916015625, 283.392364501953125, 33.96635055541992187, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 120, 255, 1, 45745), -- G_WitchBroom_01 scale 0.5 (Area: Brill - Difficulty: 0) +(@OGUID+92, 180471, 0, 85, 159, '0', 0, 0, 2288.29345703125, 391.09027099609375, 35.74422073364257812, 2.007128477096557617, 0, 0, 0.84339141845703125, 0.537299633026123046, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Brill - Difficulty: 0) +(@OGUID+93, 180471, 0, 85, 159, '0', 0, 0, 2273.23779296875, 422.072906494140625, 35.44816970825195312, 0.767943859100341796, 0, 0, 0.374606132507324218, 0.927184045314788818, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Brill - Difficulty: 0) +(@OGUID+94, 180471, 0, 85, 159, '0', 0, 0, 2269.43408203125, 374.76910400390625, 43.201812744140625, 5.305802345275878906, 0, 0, -0.46947097778320312, 0.882947921752929687, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Brill - Difficulty: 0) +(@OGUID+95, 180471, 0, 85, 159, '0', 0, 0, 2280.43408203125, 422.508697509765625, 35.49641799926757812, 0.366517573595046997, 0, 0, 0.182234764099121093, 0.98325502872467041, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Brill - Difficulty: 0) +(@OGUID+96, 180471, 0, 85, 159, '0', 0, 0, 2255.104248046875, 314.03125, 39.51722335815429687, 4.852017402648925781, 0, 0, -0.65605831146240234, 0.754710197448730468, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Brill - Difficulty: 0) +(@OGUID+97, 180471, 0, 85, 159, '0', 0, 0, 2267.272705078125, 319.501739501953125, 35.19652175903320312, 4.572763919830322265, 0, 0, -0.75470924377441406, 0.656059443950653076, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Brill - Difficulty: 0) +(@OGUID+98, 180471, 0, 85, 159, '0', 0, 0, 2268.376708984375, 292.3819580078125, 35.31812667846679687, 1.186823248863220214, 0, 0, 0.559192657470703125, 0.829037725925445556, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Brill - Difficulty: 0) +(@OGUID+99, 180471, 0, 85, 159, '0', 0, 0, 2295.763916015625, 291.114593505859375, 39.42935562133789062, 0.785396754741668701, 0, 0, 0.38268280029296875, 0.923879802227020263, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Brill - Difficulty: 0) +(@OGUID+100, 180471, 0, 85, 159, '0', 0, 0, 2256.24658203125, 299.130218505859375, 35.34776687622070312, 2.984498262405395507, 0, 0, 0.996916770935058593, 0.078466430306434631, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Brill - Difficulty: 0) +(@OGUID+101, 180471, 0, 85, 159, '0', 0, 0, 2299.0556640625, 290.432281494140625, 39.32700347900390625, 6.03883981704711914, 0, 0, -0.12186908721923828, 0.9925462007522583, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Brill - Difficulty: 0) +(@OGUID+102, 180471, 0, 85, 159, '0', 0, 0, 2293.848876953125, 270.4444580078125, 39.62081146240234375, 1.169368624687194824, 0, 0, 0.551936149597167968, 0.833886384963989257, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Brill - Difficulty: 0) +(@OGUID+103, 180471, 0, 85, 159, '0', 0, 0, 2294.842041015625, 269.989593505859375, 39.54152297973632812, 1.466075778007507324, 0, 0, 0.669130325317382812, 0.74314504861831665, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Brill - Difficulty: 0) +(@OGUID+104, 180471, 0, 85, 159, '0', 0, 0, 2264.032958984375, 280.7100830078125, 35.255340576171875, 3.52557229995727539, 0, 0, -0.98162651062011718, 0.190812408924102783, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Brill - Difficulty: 0) +(@OGUID+105, 180471, 0, 85, 159, '0', 0, 0, 2293.100830078125, 270.182281494140625, 39.17103958129882812, 1.48352813720703125, 0, 0, 0.675589561462402343, 0.737277925014495849, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Brill - Difficulty: 0) +(@OGUID+106, 180471, 0, 85, 159, '0', 0, 0, 2242.59375, 255.0069427490234375, 35.3006591796875, 1.867502212524414062, 0, 0, 0.803856849670410156, 0.594822824001312255, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Brill - Difficulty: 0) +(@OGUID+107, 180471, 0, 85, 159, '0', 0, 0, 2325.6962890625, 237.013885498046875, 30.36153793334960937, 4.433136463165283203, 0, 0, -0.79863548278808593, 0.60181504487991333, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Brill - Difficulty: 0) +(@OGUID+108, 180471, 0, 85, 159, '0', 0, 0, 2324.482666015625, 228.5989532470703125, 30.03060531616210937, 4.433136463165283203, 0, 0, -0.79863548278808593, 0.60181504487991333, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Brill - Difficulty: 0) +(@OGUID+109, 180471, 0, 85, 159, '0', 0, 0, 2185.1806640625, 242.9791717529296875, 37.70568084716796875, 3.054326534271240234, 0, 0, 0.999048233032226562, 0.043619260191917419, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Brill - Difficulty: 0) +(@OGUID+110, 180471, 0, 85, 159, '0', 0, 0, 2192.90625, 231.84375, 37.04900741577148437, 0.541050612926483154, 0, 0, 0.267237663269042968, 0.96363067626953125, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Brill - Difficulty: 0) +(@OGUID+111, 180472, 0, 85, 159, '0', 0, 0, 2263.897705078125, 344.836822509765625, 38.86483001708984375, 2.216565132141113281, 0, 0, 0.894933700561523437, 0.44619917869567871, 120, 255, 1, 45745), -- HangingSkullLight02 (Area: Brill - Difficulty: 0) +(@OGUID+112, 180472, 0, 85, 159, '0', 0, 0, 2256.123291015625, 316.041656494140625, 40.66569900512695312, 3.001946926116943359, 0, 0, 0.997563362121582031, 0.069766148924827575, 120, 255, 1, 45745), -- HangingSkullLight02 (Area: Brill - Difficulty: 0) +(@OGUID+113, 180472, 0, 85, 159, '0', 0, 0, 2253.87841796875, 312.16839599609375, 40.70804977416992187, 2.391098499298095703, 0, 0, 0.930417060852050781, 0.366502493619918823, 120, 255, 1, 45745), -- HangingSkullLight02 (Area: Brill - Difficulty: 0) +(@OGUID+114, 180472, 0, 85, 159, '0', 0, 0, 2310.4375, 277.75, 31.71162986755371093, 6.09120035171508789, 0, 0, -0.09584522247314453, 0.995396256446838378, 120, 255, 1, 45745), -- HangingSkullLight02 (Area: Brill - Difficulty: 0) +(@OGUID+115, 180472, 0, 85, 159, '0', 0, 0, 2255.69091796875, 268.942718505859375, 38.70105361938476562, 0.052358884364366531, 0, 0, 0.02617645263671875, 0.999657332897186279, 120, 255, 1, 45745), -- HangingSkullLight02 (Area: Brill - Difficulty: 0) +(@OGUID+116, 180472, 0, 85, 159, '0', 0, 0, 2241.947998046875, 239.3506927490234375, 40.92840576171875, 5.305802345275878906, 0, 0, -0.46947097778320312, 0.882947921752929687, 120, 255, 1, 45745), -- HangingSkullLight02 (Area: Brill - Difficulty: 0) +(@OGUID+117, 180523, 0, 85, 159, '0', 0, 0, 2289.8369140625, 286.477447509765625, 33.24811553955078125, 0.24434557557106018, 0, 0, 0.121869087219238281, 0.9925462007522583, 120, 255, 1, 45745), -- Apple Bob (Area: Brill - Difficulty: 0) +(@OGUID+118, 186234, 0, 85, 159, '0', 0, 0, 2221.625, 275.9288330078125, 33.71171951293945312, 3.263772249221801757, 0, 0, -0.99813461303710937, 0.061051756143569946, 120, 255, 1, 45745), -- Water Barrel (Area: Brill - Difficulty: 0) +(@OGUID+119, 186234, 0, 85, 159, '0', 0, 0, 2254.413330078125, 474.39410400390625, 33.878875732421875, 2.792518377304077148, 0, 0, 0.984807014465332031, 0.173652306199073791, 120, 255, 1, 45745), -- Water Barrel (Area: Brill - Difficulty: 0) +(@OGUID+120, 186614, 0, 85, 159, '0', 0, 0, 2255.53125, 476.2725830078125, 33.83548355102539062, 4.310965538024902343, 0, 0, -0.83388519287109375, 0.55193793773651123, 120, 255, 1, 45745), -- Water Bucket (Area: Brill - Difficulty: 0) +(@OGUID+121, 186614, 0, 85, 159, '0', 0, 0, 2255.864501953125, 473.28472900390625, 33.88770294189453125, 4.171337604522705078, 0, 0, -0.87035560607910156, 0.492423713207244873, 120, 255, 1, 45745), -- Water Bucket (Area: Brill - Difficulty: 0) +(@OGUID+122, 186614, 0, 85, 159, '0', 0, 0, 2222.963623046875, 277.90277099609375, 33.5111083984375, 1.797688722610473632, 0, 0, 0.7826080322265625, 0.622514784336090087, 120, 255, 1, 45745), -- Water Bucket (Area: Brill - Difficulty: 0) +(@OGUID+123, 186614, 0, 85, 159, '0', 0, 0, 2222.435791015625, 273.6319580078125, 33.48462295532226562, 2.70525527000427246, 0, 0, 0.97629547119140625, 0.216442063450813293, 120, 255, 1, 45745), -- Water Bucket (Area: Brill - Difficulty: 0) +(@OGUID+124, 186615, 0, 85, 159, '0', 0, 0, 2254.22216796875, 476.39410400390625, 33.8637542724609375, 1.448621988296508789, 0, 0, 0.662619590759277343, 0.748956084251403808, 120, 255, 1, 45745), -- Water Buckets (Area: Brill - Difficulty: 0) +(@OGUID+125, 186615, 0, 85, 159, '0', 0, 0, 2224.244873046875, 275.385406494140625, 33.46975326538085937, 5.84685373306274414, 0, 0, -0.21643924713134765, 0.976296067237854003, 120, 255, 1, 45745), -- Water Buckets (Area: Brill - Difficulty: 0) +(@OGUID+126, 186720, 0, 85, 159, '0', 0, 0, 2240.4375, 459.15972900390625, 38.43698883056640625, 0.820303261280059814, 0, 0, 0.398748397827148437, 0.917060375213623046, 120, 255, 1, 45745), -- Fire Effigy (Area: Brill - Difficulty: 0) +(@OGUID+127, 186720, 0, 85, 159, '0', 0, 0, 2230.421875, 464.664947509765625, 40.62353134155273437, 0.401424884796142578, 0, 0, 0.199367523193359375, 0.979924798011779785, 120, 255, 1, 45745), -- Fire Effigy (Area: Brill - Difficulty: 0) +(@OGUID+128, 186720, 0, 85, 159, '0', 0, 0, 2235.046875, 472.654510498046875, 37.98011398315429687, 0.104719325900077819, 0, 0, 0.052335739135742187, 0.998629570007324218, 120, 255, 1, 45745), -- Fire Effigy (Area: Brill - Difficulty: 0) +(@OGUID+129, 186720, 0, 85, 159, '0', 0, 0, 2239.491455078125, 487.861114501953125, 37.34464263916015625, 5.567600727081298828, 0, 0, -0.35020732879638671, 0.936672210693359375, 120, 255, 1, 45745), -- Fire Effigy (Area: Brill - Difficulty: 0) +(@OGUID+130, 186720, 0, 85, 159, '0', 0, 0, 2231.30029296875, 482.6163330078125, 39.66044235229492187, 5.95157480239868164, 0, 0, -0.16504669189453125, 0.986285746097564697, 120, 255, 1, 45745), -- Fire Effigy (Area: Brill - Difficulty: 0) +(@OGUID+131, 190066, 0, 85, 159, '0', 0, 0, 2288.75341796875, 277.498260498046875, 33.25130081176757812, 3.735006093978881835, 0, 0, -0.95630455017089843, 0.292372345924377441, 120, 255, 1, 45745); -- Candy Bucket (Area: Brill - Difficulty: 0) + +-- Event spawns +DELETE FROM `game_event_creature` WHERE `eventEntry`=12 AND `guid` BETWEEN @CGUID+0 AND @CGUID+49; +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), +(12, @CGUID+48), +(12, @CGUID+49); + +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+131; +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), +(12, @OGUID+125), +(12, @OGUID+126), +(12, @OGUID+127), +(12, @OGUID+128), +(12, @OGUID+129), +(12, @OGUID+130), +(12, @OGUID+131); |