diff options
| -rw-r--r-- | sql/updates/world/master/2021_11_06_03_world.sql | 490 |
1 files changed, 490 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_11_06_03_world.sql b/sql/updates/world/master/2021_11_06_03_world.sql new file mode 100644 index 00000000000..702df5a9a28 --- /dev/null +++ b/sql/updates/world/master/2021_11_06_03_world.sql @@ -0,0 +1,490 @@ +-- +SET @CGUID := 850146; +SET @OGUID := 500306; +SET @ATID := 4; +SET @ATGUID := 4; + +-- Queststarter +DELETE FROM `creature_queststarter` WHERE `id` = 159587 AND `quest` = 58146; +INSERT INTO `creature_queststarter`(`id`, `quest`) VALUES +(159587, 58146); + +-- Questender +DELETE FROM `creature_questender` WHERE `id` = 133362 AND `quest` = 58146; +INSERT INTO `creature_questender`(`id`, `quest`) VALUES +(133362, 58146); + +-- Phasing +DELETE FROM `phase_area` WHERE `AreaId` IN (12825, 1519) AND `PhaseId` IN (14313, 14601); +INSERT INTO `phase_area`(`AreaId`, `PhaseId`, `Comment`) VALUES +(12825, 14313, 'Allied Race: Mechagnome Default Phase'), +(1519, 14601, 'Cosmetic: Mechagon City Teleporter in Stormwind'); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 26 AND `SourceGroup`=14601 AND `SourceEntry`=1519; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `Comment`) VALUES +(26, 14601, 1519, 0, 0, 16, 0, 0x4000, 0, 0, 0, 'Player is race Mechagnome'); + +-- Spell Target Position +DELETE FROM `spell_target_position` WHERE `ID` IN (312593, 315958); +INSERT INTO `spell_target_position`(`ID`, `EffectIndex`, `MapID`, `PositionX`, `PositionY`, `PositionZ`, `VerifiedBuild`) VALUES +(312593, 0, 0, -8186.72, 782.7, 72.67, 0), -- (Spell: 312593 - Dust in the Stormwind) +(315958, 0, 2268, 712.04, 606.05, -238.53, 0); -- (Spell: 315968 - Teleport to Mechagon City) + +-- Areatrigger Data +DELETE FROM `areatrigger_template` WHERE `IsServerSide`=1 AND `Id` BETWEEN @ATID+0 AND @ATID+1; +INSERT INTO `areatrigger_template` (`Id`, `IsServerSide`, `Type`, `Flags`, `Data0`, `Data1`, `Data2`, `Data3`, `Data4`, `Data5`, `ScriptName`, `VerifiedBuild`) VALUES +(@ATID+0, 1, 4, 0, 0.5, 0.5, 3, 3, 0, 0, '', 0), +(@ATID+1, 1, 4, 0, 40, 40, 10, 10, 0, 0, '', 0); + +DELETE FROM `areatrigger_template_actions` WHERE `IsServerSide`=1 AND `AreaTriggerId` BETWEEN @ATID+0 AND @ATID+1; +INSERT INTO `areatrigger_template_actions` (`AreaTriggerId`, `IsServerSide`, `ActionType`, `ActionParam`, `TargetType`) VALUES +(@ATID+0, 1, 0, 315958, 5), +(@ATID+1, 1, 0, 315958, 5); + +DELETE FROM `areatrigger` WHERE `SpawnId` BETWEEN @ATGUID+0 AND @ATGUID+1; +INSERT INTO `areatrigger` (`SpawnId`, `AreaTriggerId`, `IsServerSide`, `MapId`, `PosX`, `PosY`, `PosZ`, `Orientation`, `PhaseUseFlags`, `PhaseId`, `PhaseGroup`, `Shape`, `ShapeData0`, `ShapeData1`, `ShapeData2`, `ShapeData3`, `ShapeData4`, `ShapeData5`, `Comment`) VALUES +(@ATGUID+0, @ATID+0, 1, 0, -8179.578125, 808.4600830078125, 74.7435150146484375, 4.1512298583984375, 0, 14601, 0, 4, 0.5, 0.5, 3, 3, 0, 0, 'Stormwind Embassy - Mechagnome Teleporter to Mechagon City'), +(@ATGUID+1, @ATID+1, 1, 2268, 712.039978, 606.049988, -253.527344, 2.229833, 0, 0, 0, 4, 40, 40, 10, 10, 0, 0, 'Mechagon City - Teleporter when jumping down'); + +-- Creature Spawns & Addon Data +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+37; +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES +(@CGUID+0, 159523, 2268, 12825, 12825, '0', '14313', 0, 0, 0, 850.170166015625, 448.828125, -301.870697021484375, 3.188158512115478515, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 40725), -- Lanna Statiglow (Area: -Unknown- - Difficulty: 0) +(@CGUID+1, 159523, 2268, 12825, 12825, '0', '14313', 0, 0, 0, 709.6944580078125, 600.47052001953125, -238.336380004882812, 2.246310234069824218, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 40725), -- Lanna Statiglow (Area: -Unknown- - Difficulty: 0) +(@CGUID+2, 159549, 2268, 12825, 12825, '0', '14313', 0, 0, 0, 713.637939453125, 402.74969482421875, -312.394866943359375, 5.75928497314453125, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 40725), -- Shim Crankturner (Area: -Unknown- - Difficulty: 0) +(@CGUID+3, 160578, 2268, 12825, 12825, '0', '14313', 0, 0, 0, 718.53643798828125, 603.93231201171875, -238.31134033203125, 1.400491952896118164, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 40725), -- Quimby Sparklighter (Area: -Unknown- - Difficulty: 0) +(@CGUID+4, 159530, 2268, 12825, 12825, '0', '14313', 0, 0, 0, 775.2413330078125, 366.723968505859375, -312.05206298828125, 3.315182447433471679, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 40725), -- Twyla Flickspring (Area: -Unknown- - Difficulty: 0) +(@CGUID+5, 159528, 2268, 12825, 12825, '0', '14313', 0, 0, 0, 716.3125, 386.453125, -311.91192626953125, 4.673531532287597656, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 40725), -- Drusilla Zapwell (Area: -Unknown- - Difficulty: 0) +(@CGUID+6, 159587, 2268, 12825, 12825, '0', '14313', 0, 0, 0, 702.125, 619.15625, -238.12701416015625, 5.364857673645019531, 7200, 0, 0, 4008940, 0, 0, 0, 0, 0, 40725), -- Gelbin Mekkatorque (Area: -Unknown- - Difficulty: 0) +(@CGUID+7, 159550, 2268, 12825, 12825, '0', '14313', 0, 0, 0, 849.984375, 450.0850830078125, -301.870697021484375, 3.849838495254516601, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 40725), -- Lelu Multipass (Area: -Unknown- - Difficulty: 0) +(@CGUID+8, 159524, 2268, 12825, 12825, '0', '14313', 0, 0, 0, 722.19525146484375, 399.050811767578125, -312.516265869140625, 5.664293289184570312, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 40725), -- Briony Vandercog (Area: -Unknown- - Difficulty: 0) +(@CGUID+9, 159486, 2268, 12825, 12825, '0', '14313', 0, 0, 0, 751.27777099609375, 364.12847900390625, -312.657501220703125, 2.045322418212890625, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 40725), -- Raz L. Dazzle (Area: -Unknown- - Difficulty: 0) +(@CGUID+10, 159552, 2268, 12825, 12825, '0', '14313', 0, 0, 0, 720.42535400390625, 376.602447509765625, -312.1063232421875, 5.834784507751464843, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 40725), -- Noden Gyrozap (Area: -Unknown- - Difficulty: 0) +(@CGUID+11, 159471, 2268, 12825, 12825, '0', '14313', 0, 0, 0, 713.19793701171875, 377.05035400390625, -312.18731689453125, 2.437668085098266601, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 40725), -- Alvin Teasprocket (Area: -Unknown- - Difficulty: 0) +(@CGUID+12, 157997, 2268, 12825, 12825, '0', '14313', 0, 0, 0, 708.8524169921875, 623.77777099609375, -238.15240478515625, 4.778178215026855468, 7200, 0, 0, 35373, 0, 0, 0, 0, 0, 40725), -- Kelsey Steelspark (Area: -Unknown- - Difficulty: 0) +(@CGUID+13, 159568, 2268, 12825, 12825, '0', '14313', 0, 0, 0, 691.29864501953125, 447.7725830078125, -320.98419189453125, 3.47837686538696289, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 40725), -- Endora Enginator (Area: -Unknown- - Difficulty: 0) (Auras: 313603 - -Unknown-) +(@CGUID+14, 159487, 2268, 12825, 12825, '0', '14313', 0, 0, 0, 823.31768798828125, 343.197906494140625, -301.958343505859375, 2.815706968307495117, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 40725), -- Petra Cogwenne (Area: -Unknown- - Difficulty: 0) +(@CGUID+15, 159559, 2268, 12825, 12825, '0', '14313', 0, 0, 0, 712.39129638671875, 370.2803955078125, -311.990631103515625, 1.139183998107910156, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 40725), -- Elya Codepunch (Area: -Unknown- - Difficulty: 0) +(@CGUID+16, 160273, 2268, 12825, 12825, '0', '14313', 0, 0, 0, 483.657989501953125, 916.95660400390625, -247.825149536132812, 0.254377692937850952, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 40725), -- Projection (Area: -Unknown- - Difficulty: 0) +(@CGUID+17, 158145, 2268, 12825, 12825, '0', '14313', 0, 0, 0, 699.1961669921875, 616.94793701171875, -238.133956909179687, 5.834698200225830078, 7200, 0, 0, 117910, 0, 0, 0, 0, 0, 40725), -- Prince Erazmin (Area: -Unknown- - Difficulty: 0) +(@CGUID+18, 160628, 2268, 12825, 12825, '0', '14313', 0, 0, 0, 821.248291015625, 343.736114501953125, -301.955902099609375, 0.090853206813335418, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 40725), -- Milnar Danspark (Area: -Unknown- - Difficulty: 0) +(@CGUID+19, 160628, 2268, 12825, 12825, '0', '14313', 0, 0, 0, 720.1961669921875, 593.04168701171875, -238.1170654296875, 0.090853206813335418, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 40725), -- Milnar Danspark (Area: -Unknown- - Difficulty: 0) +(@CGUID+20, 159571, 2268, 12825, 12825, '0', '14313', 0, 0, 0, 773.19207763671875, 367.317138671875, -311.98419189453125, 3.731470108032226562, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 40725), -- Flouresce Brightgear (Area: -Unknown- - Difficulty: 0) +(@CGUID+21, 159529, 2268, 12825, 12825, '0', '14313', 0, 0, 0, 711.51214599609375, 380.5382080078125, -310.428924560546875, 5.018309593200683593, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 40725), -- Heidi Mitercone (Area: -Unknown- - Difficulty: 0) +(@CGUID+22, 159571, 2268, 12825, 12825, '0', '14313', 0, 0, 0, 733.73089599609375, 614.8211669921875, -238.2415771484375, 4.957872867584228515, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 40725), -- Flouresce Brightgear (Area: -Unknown- - Difficulty: 0) +(@CGUID+23, 159558, 2268, 12825, 12825, '0', '14313', 0, 0, 0, 747.29168701171875, 365.895843505859375, -310.9921875, 6.179775714874267578, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 40725), -- Pegi Cogster (Area: -Unknown- - Difficulty: 0) +(@CGUID+24, 159550, 2268, 12825, 12825, '0', '14313', 0, 0, 0, 710.6024169921875, 601.35589599609375, -238.3681640625, 2.907990694046020507, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 40725), -- Lelu Multipass (Area: -Unknown- - Difficulty: 0) +(@CGUID+25, 159530, 2268, 12825, 12825, '0', '14313', 0, 0, 0, 734.95660400390625, 612.75518798828125, -238.249298095703125, 1.80664682388305664, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 40725), -- Twyla Flickspring (Area: -Unknown- - Difficulty: 0) +(@CGUID+26, 159545, 2268, 12825, 12825, '0', '14313', 0, 0, 0, 761.63018798828125, 524.01910400390625, -247.74810791015625, 0.568804323673248291, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 40725), -- Stuard Sharpsprocket (Area: -Unknown- - Difficulty: 0) +(@CGUID+27, 159487, 2268, 12825, 12825, '0', '14313', 0, 0, 0, 722.265625, 592.50347900390625, -238.1419677734375, 2.815706968307495117, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 40725), -- Petra Cogwenne (Area: -Unknown- - Difficulty: 0) +(@CGUID+28, 159551, 2268, 12825, 12825, '0', '14313', 0, 0, 0, 652.5538330078125, 352.864593505859375, -328.390411376953125, 2.197803974151611328, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 40725), -- Spark Nimblecog (Area: -Unknown- - Difficulty: 0) +(@CGUID+29, 159470, 2268, 12825, 12825, '0', '14313', 0, 0, 0, 795.24481201171875, 366.40972900390625, -312.657470703125, 5.930068016052246093, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 40725), -- Jonian Monkash (Area: -Unknown- - Difficulty: 0) +(@CGUID+30, 159485, 2268, 12825, 12825, '0', '14313', 0, 0, 0, 763.15277099609375, 524.560791015625, -247.686065673828125, 4.012735843658447265, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 40725), -- Tera Geotorque (Area: -Unknown- - Difficulty: 0) +(@CGUID+31, 159572, 2268, 12825, 12825, '0', '14313', 0, 0, 0, 848.27777099609375, 448.7569580078125, -301.870697021484375, 0.336062163114547729, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 40725), -- Luka Morespark (Area: -Unknown- - Difficulty: 0) +(@CGUID+32, 159543, 2268, 12825, 12825, '0', '14313', 0, 0, 0, 822.68402099609375, 345.017364501953125, -301.961517333984375, 4.542830944061279296, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 40725), -- Pete Mixelgear (Area: -Unknown- - Difficulty: 0) +(@CGUID+33, 159468, 2268, 12825, 12825, '0', '14313', 0, 0, 0, 680.7899169921875, 451.173614501953125, -316.984161376953125, 0.792916834354400634, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 40725), -- Abel Camhorn (Area: -Unknown- - Difficulty: 0) +(@CGUID+34, 159572, 2268, 12825, 12825, '0', '14313', 0, 0, 0, 708.53472900390625, 601.95831298828125, -238.357696533203125, 5.677399158477783203, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 40725), -- Luka Morespark (Area: -Unknown- - Difficulty: 0) +(@CGUID+35, 159569, 2268, 12825, 12825, '0', '14313', 0, 0, 0, 757.6683349609375, 320.833740234375, -308.148223876953125, 0.384584426879882812, 7200, 10, 0, 11791, 0, 1, 0, 0, 0, 40725), -- Yergin Galvaquad (Area: -Unknown- - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+36, 159543, 2268, 12825, 12825, '0', '14313', 0, 0, 0, 718.6649169921875, 605.17535400390625, -238.315872192382812, 4.542830944061279296, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 40725), -- Pete Mixelgear (Area: -Unknown- - Difficulty: 0) +(@CGUID+37, 159567, 2268, 12825, 12825, '0', '14313', 0, 0, 0, 749.11981201171875, 301.482635498046875, -307.87213134765625, 2.044833660125732421, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 40725); -- Idee Quickcoil (Area: -Unknown- - Difficulty: 0) +DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+37; +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `auras`) VALUES +(@CGUID+0, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- Lanna Statiglow +(@CGUID+1, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- Lanna Statiglow +(@CGUID+2, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- Shim Crankturner +(@CGUID+3, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- Quimby Sparklighter +(@CGUID+4, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- Twyla Flickspring +(@CGUID+5, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- Drusilla Zapwell +(@CGUID+6, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- Gelbin Mekkatorque +(@CGUID+7, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- Lelu Multipass +(@CGUID+8, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- Briony Vandercog +(@CGUID+9, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- Raz L. Dazzle +(@CGUID+10, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- Noden Gyrozap +(@CGUID+11, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- Alvin Teasprocket +(@CGUID+12, 0, 0, 0, 0, 0, 0, 0, 0, ''), -- Kelsey Steelspark +(@CGUID+13, 0, 0, 0, 1, 0, 0, 0, 0, '313603'), -- Endora Enginator - 313603 - -Unknown- +(@CGUID+14, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- Petra Cogwenne +(@CGUID+15, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- Elya Codepunch +(@CGUID+16, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- Projection +(@CGUID+17, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- Prince Erazmin +(@CGUID+18, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- Milnar Danspark +(@CGUID+19, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- Milnar Danspark +(@CGUID+20, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- Flouresce Brightgear +(@CGUID+21, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- Heidi Mitercone +(@CGUID+22, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- Flouresce Brightgear +(@CGUID+23, 0, 0, 50331648, 1, 0, 14000, 0, 0, ''), -- Pegi Cogster +(@CGUID+24, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- Lelu Multipass +(@CGUID+25, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- Twyla Flickspring +(@CGUID+26, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- Stuard Sharpsprocket +(@CGUID+27, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- Petra Cogwenne +(@CGUID+28, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- Spark Nimblecog +(@CGUID+29, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- Jonian Monkash +(@CGUID+30, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- Tera Geotorque +(@CGUID+31, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- Luka Morespark +(@CGUID+32, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- Pete Mixelgear +(@CGUID+33, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- Abel Camhorn +(@CGUID+34, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- Luka Morespark +(@CGUID+35, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- Yergin Galvaquad +(@CGUID+36, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- Pete Mixelgear +(@CGUID+37, 0, 0, 1, 1, 0, 0, 0, 0, ''); -- Idee Quickcoil + +-- GameObject spawns & Addon Data +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+84; +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, 335532, 2268, 12825, 12825, '0', '14313', 0, 785.4808349609375, 333.69622802734375, -311.30718994140625, 2.917418718338012695, 0, 0, 0.993724822998046875, 0.111852385103702545, 7200, 255, 1, 40725), -- Doodad_8DU_Mechagon_HedgeTrap005 (Area: -Unknown- - Difficulty: 0) +(@OGUID+1, 335573, 2268, 12825, 12825, '0', '14313', 0, 740.687744140625, 567.94842529296875, -238.43060302734375, 2.200127601623535156, 0, 0, 0.891236305236816406, 0.453539222478866577, 7200, 255, 0, 40725), -- Energy Door (Area: -Unknown- - Difficulty: 0) +(@OGUID+2, 335539, 2268, 12825, 12825, '0', '14313', 0, 737.33746337890625, 366.94427490234375, -312.07427978515625, 0.590612351894378662, 0, 0, 0.291032791137695312, 0.956713080406188964, 7200, 255, 1, 40725), -- Doodad_8DU_Mechagon_HedgeTrap012 (Area: -Unknown- - Difficulty: 0) +(@OGUID+3, 335513, 2268, 12825, 12825, '0', '14313', 0, 652.4356689453125, 447.67340087890625, -320.96929931640625, 2.03925323486328125, 0, 0, 0.851912498474121093, 0.523684144020080566, 7200, 255, 1, 40725), -- Doodad_8GN_GNOME_CHAIR001 (Area: -Unknown- - Difficulty: 0) +(@OGUID+4, 335533, 2268, 12825, 12825, '0', '14313', 0, 785.4808349609375, 333.69622802734375, -311.30718994140625, 2.917418718338012695, 0, 0, 0.993724822998046875, 0.111852385103702545, 7200, 255, 1, 40725), -- Doodad_8DU_Mechagon_HedgeTrap006 (Area: -Unknown- - Difficulty: 0) +(@OGUID+5, 335514, 2268, 12825, 12825, '0', '14313', 0, 651.7105712890625, 431.68603515625, -313.1566162109375, 0.670598924160003662, 0, 0, 0.329051971435546875, 0.944311797618865966, 7200, 255, 1, 40725), -- Doodad_8GN_GNOME_CHAIR002 (Area: -Unknown- - Difficulty: 0) +(@OGUID+6, 335525, 2268, 12825, 12825, '0', '14313', 0, 685.1097412109375, 410.589447021484375, -321.003204345703125, 2.280592679977416992, 0, 0, 0.908757209777832031, 0.417325258255004882, 7200, 255, 1, 40725), -- Doodad_8DU_Mechagon_HologramProjector001 (Area: -Unknown- - Difficulty: 0) +(@OGUID+7, 335534, 2268, 12825, 12825, '0', '14313', 0, 757.784912109375, 398.30572509765625, -311.30718994140625, 6.105648994445800781, 0, 0, -0.08865165710449218, 0.996062695980072021, 7200, 255, 1, 40725), -- Doodad_8DU_Mechagon_HedgeTrap007 (Area: -Unknown- - Difficulty: 0) +(@OGUID+8, 335575, 2268, 12825, 12825, '0', '14313', 0, 622.390869140625, 247.6560211181640625, -352.086761474609375, 3.253772497177124023, 0, 0, -0.99842739105224609, 0.056060452014207839, 7200, 255, 0, 40725), -- Junkyard Door (Area: -Unknown- - Difficulty: 0) +(@OGUID+9, 335515, 2268, 12825, 12825, '0', '14313', 0, 718.1893310546875, 320.6605224609375, -304.793609619140625, 6.136990547180175781, 0, 0, -0.07303237915039062, 0.997329592704772949, 7200, 255, 1, 40725), -- Doodad_8GN_GNOME_CHAIR004 (Area: -Unknown- - Difficulty: 0) +(@OGUID+10, 335535, 2268, 12825, 12825, '0', '14313', 0, 757.784912109375, 398.30572509765625, -311.30718994140625, 6.105648994445800781, 0, 0, -0.08865165710449218, 0.996062695980072021, 7200, 255, 1, 40725), -- Doodad_8DU_Mechagon_HedgeTrap008 (Area: -Unknown- - Difficulty: 0) +(@OGUID+11, 335541, 2268, 12825, 12825, '0', '14313', 0, 692.59381103515625, 630.0113525390625, -240.49237060546875, 2.216885805130004882, 0, 0, 0.895005226135253906, 0.446055680513381958, 7200, 255, 0, 40725), -- Overlook Door (Area: -Unknown- - Difficulty: 0) +(@OGUID+12, 335527, 2268, 12825, 12825, '0', '14313', 0, 707.86358642578125, 407.024810791015625, -322.5518798828125, 2.556593894958496093, 0, 0, 0.957526206970214843, 0.288346290588378906, 7200, 255, 0, 40725), -- Garden Bridge (Area: -Unknown- - Difficulty: 0) +(@OGUID+13, 335528, 2268, 12825, 12825, '0', '14313', 0, 806.87890625, 367.37066650390625, -311.30718994140625, 3.837580680847167968, 0, 0, -0.94005870819091796, 0.341012626886367797, 7200, 255, 1, 40725), -- Doodad_8DU_Mechagon_HedgeTrap001 (Area: -Unknown- - Difficulty: 0) +(@OGUID+14, 335516, 2268, 12825, 12825, '0', '14313', 0, 710.2598876953125, 380.939178466796875, -301.139434814453125, 3.695965528488159179, 0, 0, -0.96182918548583984, 0.273650497198104858, 7200, 255, 1, 40725), -- Doodad_8GN_GNOME_CHAIR005 (Area: -Unknown- - Difficulty: 0) +(@OGUID+15, 335520, 2268, 12825, 12825, '0', '14313', 0, 651.006103515625, 446.2642822265625, -320.983734130859375, 2.665502548217773437, 0, 0, 0.971800804138183593, 0.235803321003913879, 7200, 255, 1, 40725), -- Doodad_8GN_GNOME_CHAIR009 (Area: -Unknown- - Difficulty: 0) +(@OGUID+16, 335529, 2268, 12825, 12825, '0', '14313', 0, 806.87890625, 367.37066650390625, -311.30718994140625, 3.837580680847167968, 0, 0, -0.94005870819091796, 0.341012626886367797, 7200, 255, 1, 40725), -- Doodad_8DU_Mechagon_HedgeTrap002 (Area: -Unknown- - Difficulty: 0) +(@OGUID+17, 335517, 2268, 12825, 12825, '0', '14313', 0, 651.0069580078125, 450.89105224609375, -320.69866943359375, 5.75298929214477539, 0, 0, -0.26200389862060546, 0.965066790580749511, 7200, 255, 1, 40725), -- Doodad_8GN_GNOME_CHAIR006 (Area: -Unknown- - Difficulty: 0) +(@OGUID+18, 335521, 2268, 12825, 12825, '0', '14313', 0, 798.26806640625, 427.28411865234375, -302.1783447265625, 4.75458526611328125, 0, 0, -0.6920318603515625, 0.721866965293884277, 7200, 255, 1, 40725), -- Doodad_8GN_GNOME_CHAIR010 (Area: -Unknown- - Difficulty: 0) +(@OGUID+19, 335530, 2268, 12825, 12825, '0', '14313', 0, 806.87890625, 367.37066650390625, -311.30718994140625, 3.837580680847167968, 0, 0, -0.94005870819091796, 0.341012626886367797, 7200, 255, 1, 40725), -- Doodad_8DU_Mechagon_HedgeTrap003 (Area: -Unknown- - Difficulty: 0) +(@OGUID+20, 335536, 2268, 12825, 12825, '0', '14313', 0, 757.784912109375, 398.30572509765625, -311.30718994140625, 6.105648994445800781, 0, 0, -0.08865165710449218, 0.996062695980072021, 7200, 255, 1, 40725), -- Doodad_8DU_Mechagon_HedgeTrap009 (Area: -Unknown- - Difficulty: 0) +(@OGUID+21, 335518, 2268, 12825, 12825, '0', '14313', 0, 649.05078125, 445.87689208984375, -320.983734130859375, 0.391032516956329345, 0, 0, 0.194272994995117187, 0.980947494506835937, 7200, 255, 1, 40725), -- Doodad_8GN_GNOME_CHAIR007 (Area: -Unknown- - Difficulty: 0) +(@OGUID+22, 335571, 2268, 12825, 12825, '0', '14313', 0, 744.397216796875, 384.72613525390625, -312.816986083984375, 5.702358722686767578, 0, 0, -0.28634834289550781, 0.958125591278076171, 7200, 255, 0, 40725), -- Energy Door (Area: -Unknown- - Difficulty: 0) +(@OGUID+23, 335531, 2268, 12825, 12825, '0', '14313', 0, 785.4808349609375, 333.69622802734375, -311.30718994140625, 2.917418718338012695, 0, 0, 0.993724822998046875, 0.111852385103702545, 7200, 255, 1, 40725), -- Doodad_8DU_Mechagon_HedgeTrap004 (Area: -Unknown- - Difficulty: 0) +(@OGUID+24, 335537, 2268, 12825, 12825, '0', '14313', 0, 737.33746337890625, 366.94427490234375, -312.07427978515625, 0.590612351894378662, 0, 0, 0.291032791137695312, 0.956713080406188964, 7200, 255, 1, 40725), -- Doodad_8DU_Mechagon_HedgeTrap010 (Area: -Unknown- - Difficulty: 0) +(@OGUID+25, 335519, 2268, 12825, 12825, '0', '14313', 0, 653.6851806640625, 449.382080078125, -320.96929931640625, 2.902401685714721679, 0, 0, 0.992856979370117187, 0.11931060254573822, 7200, 255, 1, 40725), -- Doodad_8GN_GNOME_CHAIR008 (Area: -Unknown- - Difficulty: 0) +(@OGUID+26, 335572, 2268, 12825, 12825, '0', '14313', 0, 787.7103271484375, 391.7105712890625, -312.72412109375, 0.983241736888885498, 0, 0, 0.472055435180664062, 0.881568849086761474, 7200, 255, 0, 40725), -- Energy Shield (Area: -Unknown- - Difficulty: 0) +(@OGUID+27, 335538, 2268, 12825, 12825, '0', '14313', 0, 737.33746337890625, 366.94427490234375, -312.07427978515625, 0.590612351894378662, 0, 0, 0.291032791137695312, 0.956713080406188964, 7200, 255, 1, 40725), -- Doodad_8DU_Mechagon_HedgeTrap011 (Area: -Unknown- - Difficulty: 0) +(@OGUID+28, 335535, 2268, 12825, 12825, '0', '14313', 0, 757.784912109375, 398.30572509765625, -311.30718994140625, 6.105648994445800781, 0, 0, -0.08865165710449218, 0.996062695980072021, 7200, 255, 1, 40725), -- Doodad_8DU_Mechagon_HedgeTrap008 (Area: -Unknown- - Difficulty: 0) +(@OGUID+29, 339762, 2268, 12825, 12825, '0', '14313', 0, 771.94268798828125, 365.727447509765625, -312.382659912109375, 0, 0, 0, 0, 1, 7200, 255, 1, 40725), -- Flower (Area: -Unknown- - Difficulty: 0) +(@OGUID+30, 335536, 2268, 12825, 12825, '0', '14313', 0, 757.784912109375, 398.30572509765625, -311.30718994140625, 6.105648994445800781, 0, 0, -0.08865165710449218, 0.996062695980072021, 7200, 255, 1, 40725), -- Doodad_8DU_Mechagon_HedgeTrap009 (Area: -Unknown- - Difficulty: 0) +(@OGUID+31, 339758, 2268, 12825, 12825, '0', '14313', 0, 771.73614501953125, 365.251739501953125, -312.558807373046875, 0, 0, 0, 0, 1, 7200, 255, 1, 40725), -- Flower (Area: -Unknown- - Difficulty: 0) +(@OGUID+32, 339761, 2268, 12825, 12825, '0', '14313', 0, 771.51910400390625, 365.40625, -312.438385009765625, 0, 0, 0, 0, 1, 7200, 255, 1, 40725), -- Flower (Area: -Unknown- - Difficulty: 0) +(@OGUID+33, 335527, 2268, 12825, 12825, '0', '14313', 0, 707.86358642578125, 407.024810791015625, -322.5518798828125, 2.556593894958496093, 0, 0, 0.957526206970214843, 0.288346290588378906, 7200, 255, 0, 40725), -- Garden Bridge (Area: -Unknown- - Difficulty: 0) +(@OGUID+34, 335528, 2268, 12825, 12825, '0', '14313', 0, 806.87890625, 367.37066650390625, -311.30718994140625, 3.837580680847167968, 0, 0, -0.94005870819091796, 0.341012626886367797, 7200, 255, 1, 40725), -- Doodad_8DU_Mechagon_HedgeTrap001 (Area: -Unknown- - Difficulty: 0) +(@OGUID+35, 339337, 2268, 12825, 12825, '0', '14313', 0, 729.515625, 609.68231201171875, -238.236251831054687, 2.836383819580078125, 0, 0, 0.988378524780273437, 0.152012780308723449, 7200, 255, 1, 40725), -- Stormwind Teleportation Unit (Area: -Unknown- - Difficulty: 0) +(@OGUID+36, 335537, 2268, 12825, 12825, '0', '14313', 0, 737.33746337890625, 366.94427490234375, -312.07427978515625, 0.590612351894378662, 0, 0, 0.291032791137695312, 0.956713080406188964, 7200, 255, 1, 40725), -- Doodad_8DU_Mechagon_HedgeTrap010 (Area: -Unknown- - Difficulty: 0) +(@OGUID+37, 335516, 2268, 12825, 12825, '0', '14313', 0, 710.2598876953125, 380.939178466796875, -301.139434814453125, 3.695965528488159179, 0, 0, -0.96182918548583984, 0.273650497198104858, 7200, 255, 1, 40725), -- Doodad_8GN_GNOME_CHAIR005 (Area: -Unknown- - Difficulty: 0) +(@OGUID+38, 335520, 2268, 12825, 12825, '0', '14313', 0, 651.006103515625, 446.2642822265625, -320.983734130859375, 2.665502548217773437, 0, 0, 0.971800804138183593, 0.235803321003913879, 7200, 255, 1, 40725), -- Doodad_8GN_GNOME_CHAIR009 (Area: -Unknown- - Difficulty: 0) +(@OGUID+39, 339757, 2268, 12825, 12825, '0', '14313', 0, 771.638916015625, 367.373260498046875, -312.48651123046875, 0, 0, 0, 0, 1, 7200, 255, 1, 40725), -- Flower (Area: -Unknown- - Difficulty: 0) +(@OGUID+40, 335529, 2268, 12825, 12825, '0', '14313', 0, 806.87890625, 367.37066650390625, -311.30718994140625, 3.837580680847167968, 0, 0, -0.94005870819091796, 0.341012626886367797, 7200, 255, 1, 40725), -- Doodad_8DU_Mechagon_HedgeTrap002 (Area: -Unknown- - Difficulty: 0) +(@OGUID+41, 335575, 2268, 12825, 12825, '0', '14313', 0, 622.390869140625, 247.6560211181640625, -352.086761474609375, 3.253772497177124023, 0, 0, -0.99842739105224609, 0.056060452014207839, 7200, 255, 0, 40725), -- Junkyard Door (Area: -Unknown- - Difficulty: 0) +(@OGUID+42, 339757, 2268, 12825, 12825, '0', '14313', 0, 771.86285400390625, 367.536468505859375, -312.523223876953125, 0, 0, 0, 0, 1, 7200, 255, 1, 40725), -- Flower (Area: -Unknown- - Difficulty: 0) +(@OGUID+43, 335538, 2268, 12825, 12825, '0', '14313', 0, 737.33746337890625, 366.94427490234375, -312.07427978515625, 0.590612351894378662, 0, 0, 0.291032791137695312, 0.956713080406188964, 7200, 255, 1, 40725), -- Doodad_8DU_Mechagon_HedgeTrap011 (Area: -Unknown- - Difficulty: 0) +(@OGUID+44, 335517, 2268, 12825, 12825, '0', '14313', 0, 651.0069580078125, 450.89105224609375, -320.69866943359375, 5.75298929214477539, 0, 0, -0.26200389862060546, 0.965066790580749511, 7200, 255, 1, 40725), -- Doodad_8GN_GNOME_CHAIR006 (Area: -Unknown- - Difficulty: 0) +(@OGUID+45, 335521, 2268, 12825, 12825, '0', '14313', 0, 798.26806640625, 427.28411865234375, -302.1783447265625, 4.75458526611328125, 0, 0, -0.6920318603515625, 0.721866965293884277, 7200, 255, 1, 40725), -- Doodad_8GN_GNOME_CHAIR010 (Area: -Unknown- - Difficulty: 0) +(@OGUID+46, 339761, 2268, 12825, 12825, '0', '14313', 0, 772.45489501953125, 365.859375, -312.658355712890625, 0, 0, 0, 0, 1, 7200, 255, 1, 40725), -- Flower (Area: -Unknown- - Difficulty: 0) +(@OGUID+47, 335530, 2268, 12825, 12825, '0', '14313', 0, 806.87890625, 367.37066650390625, -311.30718994140625, 3.837580680847167968, 0, 0, -0.94005870819091796, 0.341012626886367797, 7200, 255, 1, 40725), -- Doodad_8DU_Mechagon_HedgeTrap003 (Area: -Unknown- - Difficulty: 0) +(@OGUID+48, 339757, 2268, 12825, 12825, '0', '14313', 0, 771.65625, 366.130218505859375, -312.647857666015625, 0, 0, 0, 0, 1, 7200, 255, 1, 40725), -- Flower (Area: -Unknown- - Difficulty: 0) +(@OGUID+49, 339758, 2268, 12825, 12825, '0', '14313', 0, 771.2569580078125, 366.609375, -312.62823486328125, 0, 0, 0, 0, 1, 7200, 255, 1, 40725), -- Flower (Area: -Unknown- - Difficulty: 0) +(@OGUID+50, 335539, 2268, 12825, 12825, '0', '14313', 0, 737.33746337890625, 366.94427490234375, -312.07427978515625, 0.590612351894378662, 0, 0, 0.291032791137695312, 0.956713080406188964, 7200, 255, 1, 40725), -- Doodad_8DU_Mechagon_HedgeTrap012 (Area: -Unknown- - Difficulty: 0) +(@OGUID+51, 335518, 2268, 12825, 12825, '0', '14313', 0, 649.05078125, 445.87689208984375, -320.983734130859375, 0.391032516956329345, 0, 0, 0.194272994995117187, 0.980947494506835937, 7200, 255, 1, 40725), -- Doodad_8GN_GNOME_CHAIR007 (Area: -Unknown- - Difficulty: 0) +(@OGUID+52, 338477, 2268, 12825, 12825, '0', '14313', 0, 628.92706298828125, 552.54339599609375, -266.912994384765625, 5.892563343048095703, 0, 0, -0.19407176971435546, 0.980987310409545898, 7200, 255, 1, 40725), -- Mechagon City Teleporter (Area: -Unknown- - Difficulty: 0) +(@OGUID+53, 335531, 2268, 12825, 12825, '0', '14313', 0, 785.4808349609375, 333.69622802734375, -311.30718994140625, 2.917418718338012695, 0, 0, 0.993724822998046875, 0.111852385103702545, 7200, 255, 1, 40725), -- Doodad_8DU_Mechagon_HedgeTrap004 (Area: -Unknown- - Difficulty: 0) +(@OGUID+54, 339758, 2268, 12825, 12825, '0', '14313', 0, 771.15625, 365.51214599609375, -312.57073974609375, 0, 0, 0, 0, 1, 7200, 255, 1, 40725), -- Flower (Area: -Unknown- - Difficulty: 0) +(@OGUID+55, 335519, 2268, 12825, 12825, '0', '14313', 0, 653.6851806640625, 449.382080078125, -320.96929931640625, 2.902401685714721679, 0, 0, 0.992856979370117187, 0.11931060254573822, 7200, 255, 1, 40725), -- Doodad_8GN_GNOME_CHAIR008 (Area: -Unknown- - Difficulty: 0) +(@OGUID+56, 339757, 2268, 12825, 12825, '0', '14313', 0, 772.15802001953125, 365.33160400390625, -312.47723388671875, 0, 0, 0, 0, 1, 7200, 255, 1, 40725), -- Flower (Area: -Unknown- - Difficulty: 0) +(@OGUID+57, 339757, 2268, 12825, 12825, '0', '14313', 0, 771.11114501953125, 366.217010498046875, -312.382080078125, 0, 0, 0, 0, 1, 7200, 255, 1, 40725), -- Flower (Area: -Unknown- - Difficulty: 0) +(@OGUID+58, 339761, 2268, 12825, 12825, '0', '14313', 0, 772.27081298828125, 366.53472900390625, -312.62744140625, 0, 0, 0, 0, 1, 7200, 255, 1, 40725), -- Flower (Area: -Unknown- - Difficulty: 0) +(@OGUID+59, 339758, 2268, 12825, 12825, '0', '14313', 0, 772.7586669921875, 366.739593505859375, -312.419464111328125, 0, 0, 0, 0, 1, 7200, 255, 1, 40725), -- Flower (Area: -Unknown- - Difficulty: 0) +(@OGUID+60, 335532, 2268, 12825, 12825, '0', '14313', 0, 785.4808349609375, 333.69622802734375, -311.30718994140625, 2.917418718338012695, 0, 0, 0.993724822998046875, 0.111852385103702545, 7200, 255, 1, 40725), -- Doodad_8DU_Mechagon_HedgeTrap005 (Area: -Unknown- - Difficulty: 0) +(@OGUID+61, 339757, 2268, 12825, 12825, '0', '14313', 0, 772.0711669921875, 366.96875, -312.337188720703125, 0, 0, 0, 0, 1, 7200, 255, 1, 40725), -- Flower (Area: -Unknown- - Difficulty: 0) +(@OGUID+62, 335541, 2268, 12825, 12825, '0', '14313', 0, 692.59381103515625, 630.0113525390625, -240.49237060546875, 2.216885805130004882, 0, 0, 0.895005226135253906, 0.446055680513381958, 7200, 255, 0, 40725), -- Overlook Door (Area: -Unknown- - Difficulty: 0) +(@OGUID+63, 339762, 2268, 12825, 12825, '0', '14313', 0, 772.6492919921875, 366.625, -312.368072509765625, 3.036256313323974609, 0, 0, 0.998613357543945312, 0.052643876522779464, 7200, 255, 1, 40725), -- Flower (Area: -Unknown- - Difficulty: 0) +(@OGUID+64, 335513, 2268, 12825, 12825, '0', '14313', 0, 652.4356689453125, 447.67340087890625, -320.96929931640625, 2.03925323486328125, 0, 0, 0.851912498474121093, 0.523684144020080566, 7200, 255, 1, 40725), -- Doodad_8GN_GNOME_CHAIR001 (Area: -Unknown- - Difficulty: 0) +(@OGUID+65, 341828, 2268, 12825, 12825, '0', '14313', 0, 831.44793701171875, 461.3663330078125, -300.6529541015625, 5.581120967864990234, 0, 0, -0.34386730194091796, 0.93901824951171875, 7200, 255, 1, 40725), -- Mechagon City Teleporter (Area: -Unknown- - Difficulty: 0) +(@OGUID+66, 335533, 2268, 12825, 12825, '0', '14313', 0, 785.4808349609375, 333.69622802734375, -311.30718994140625, 2.917418718338012695, 0, 0, 0.993724822998046875, 0.111852385103702545, 7200, 255, 1, 40725), -- Doodad_8DU_Mechagon_HedgeTrap006 (Area: -Unknown- - Difficulty: 0) +(@OGUID+67, 339758, 2268, 12825, 12825, '0', '14313', 0, 772.23089599609375, 366.0069580078125, -312.699371337890625, 0, 0, 0, 0, 1, 7200, 255, 1, 40725), -- Flower (Area: -Unknown- - Difficulty: 0) +(@OGUID+68, 335525, 2268, 12825, 12825, '0', '14313', 0, 685.1097412109375, 410.589447021484375, -321.003204345703125, 2.280592679977416992, 0, 0, 0.908757209777832031, 0.417325258255004882, 7200, 255, 1, 40725), -- Doodad_8DU_Mechagon_HologramProjector001 (Area: -Unknown- - Difficulty: 0) +(@OGUID+69, 339763, 2268, 12825, 12825, '0', '14313', 0, 771.90802001953125, 366.939239501953125, -312.312652587890625, 0, 0, 0, 0, 1, 7200, 255, 1, 40725), -- Flower (Area: -Unknown- - Difficulty: 0) +(@OGUID+70, 335514, 2268, 12825, 12825, '0', '14313', 0, 651.7105712890625, 431.68603515625, -313.1566162109375, 0.670598924160003662, 0, 0, 0.329051971435546875, 0.944311797618865966, 7200, 255, 1, 40725), -- Doodad_8GN_GNOME_CHAIR002 (Area: -Unknown- - Difficulty: 0) +(@OGUID+71, 335534, 2268, 12825, 12825, '0', '14313', 0, 757.784912109375, 398.30572509765625, -311.30718994140625, 6.105648994445800781, 0, 0, -0.08865165710449218, 0.996062695980072021, 7200, 255, 1, 40725), -- Doodad_8DU_Mechagon_HedgeTrap007 (Area: -Unknown- - Difficulty: 0) +(@OGUID+72, 338477, 2268, 12825, 12825, '0', '14313', 0, 631.0850830078125, 375.9132080078125, -328.398773193359375, 5.720658302307128906, 0, 0, -0.27756977081298828, 0.960705459117889404, 7200, 255, 1, 40725), -- Mechagon City Teleporter (Area: -Unknown- - Difficulty: 0) +(@OGUID+73, 335572, 2268, 12825, 12825, '0', '14313', 0, 787.7103271484375, 391.7105712890625, -312.72412109375, 0.983241736888885498, 0, 0, 0.472055435180664062, 0.881568849086761474, 7200, 255, 0, 40725), -- Energy Shield (Area: -Unknown- - Difficulty: 0) +(@OGUID+74, 339761, 2268, 12825, 12825, '0', '14313', 0, 771.50177001953125, 366.29339599609375, -312.643280029296875, 0, 0, 0, 0, 1, 7200, 255, 1, 40725), -- Flower (Area: -Unknown- - Difficulty: 0) +(@OGUID+75, 339757, 2268, 12825, 12825, '0', '14313', 0, 770.888916015625, 365.94964599609375, -312.524627685546875, 0, 0, 0, 0, 1, 7200, 255, 1, 40725), -- Flower (Area: -Unknown- - Difficulty: 0) +(@OGUID+76, 339757, 2268, 12825, 12825, '0', '14313', 0, 771.8211669921875, 367.317718505859375, -312.446441650390625, 0, 0, 0, 0, 1, 7200, 255, 1, 40725), -- Flower (Area: -Unknown- - Difficulty: 0) +(@OGUID+77, 339757, 2268, 12825, 12825, '0', '14313', 0, 771.248291015625, 367.060760498046875, -312.659271240234375, 0, 0, 0, 0, 1, 7200, 255, 1, 40725), -- Flower (Area: -Unknown- - Difficulty: 0) +(@OGUID+78, 335515, 2268, 12825, 12825, '0', '14313', 0, 718.1893310546875, 320.6605224609375, -304.793609619140625, 6.136990547180175781, 0, 0, -0.07303237915039062, 0.997329592704772949, 7200, 255, 1, 40725), -- Doodad_8GN_GNOME_CHAIR004 (Area: -Unknown- - Difficulty: 0) +(@OGUID+79, 335522, 2268, 12825, 12825, '0', '14313', 0, 810.018798828125, 298.86944580078125, -295.092926025390625, 3.856938123703002929, 0, 0, -0.93671417236328125, 0.350095093250274658, 7200, 255, 1, 40725), -- Doodad_8GN_GNOME_CHAIR013 (Area: -Unknown- - Difficulty: 0) +(@OGUID+80, 335523, 2268, 12825, 12825, '0', '14313', 0, 807.93365478515625, 297.89251708984375, -295.092926025390625, 0.072413042187690734, 0, 0, 0.036198616027832031, 0.999344587326049804, 7200, 255, 1, 40725), -- Doodad_8GN_GNOME_CHAIR014 (Area: -Unknown- - Difficulty: 0) +(@OGUID+81, 335524, 2268, 12825, 12825, '0', '14313', 0, 809.2244873046875, 296.546142578125, -295.126556396484375, 1.520346045494079589, 0, 0, 0.689046859741210937, 0.724716782569885253, 7200, 255, 1, 40725), -- Doodad_8GN_GNOME_CHAIR015 (Area: -Unknown- - Difficulty: 0) +(@OGUID+82, 335526, 2268, 12825, 12825, '0', '14313', 0, 777.9285888671875, 291.972900390625, -308.00469970703125, 6.000570297241210937, 0, 0, -0.14083766937255859, 0.990032732486724853, 7200, 255, 1, 40725), -- Doodad_8DU_Mechagon_HologramProjector003 (Area: -Unknown- - Difficulty: 0) +(@OGUID+83, 335574, 2268, 12825, 12825, '0', '14313', 0, 603.58837890625, 281.461456298828125, -352.370758056640625, 4.481809616088867187, 0, 0, -0.78375434875488281, 0.6210709810256958, 7200, 255, 1, 40725), -- Doodad_8GN_GNOME_CHAIR016 (Area: -Unknown- - Difficulty: 0) +(@OGUID+84, 341363, 0, 1519, 9171, '0', 14601, 0, -8179.578125, 808.4600830078125, 74.7435150146484375, 4.1512298583984375, 0, 0, -0.87526226043701171, 0.483648627996444702, 120, 255, 1, 40725); -- Mechagon City Teleporter (Area: Stormwind Embassy - Difficulty: 0) +DELETE FROM `gameobject_addon` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+83; +INSERT INTO `gameobject_addon` (`guid`, `parent_rotation0`, `parent_rotation1`, `parent_rotation2`, `parent_rotation3`, `WorldEffectID`, `AIAnimKitID`) VALUES +(@OGUID+0, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Doodad_8DU_Mechagon_HedgeTrap005 +(@OGUID+1, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Energy Door +(@OGUID+2, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Doodad_8DU_Mechagon_HedgeTrap012 +(@OGUID+3, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Doodad_8GN_GNOME_CHAIR001 +(@OGUID+4, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Doodad_8DU_Mechagon_HedgeTrap006 +(@OGUID+5, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Doodad_8GN_GNOME_CHAIR002 +(@OGUID+6, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Doodad_8DU_Mechagon_HologramProjector001 +(@OGUID+7, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Doodad_8DU_Mechagon_HedgeTrap007 +(@OGUID+8, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Junkyard Door +(@OGUID+9, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Doodad_8GN_GNOME_CHAIR004 +(@OGUID+10, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Doodad_8DU_Mechagon_HedgeTrap008 +(@OGUID+11, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Overlook Door +(@OGUID+12, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Garden Bridge +(@OGUID+13, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Doodad_8DU_Mechagon_HedgeTrap001 +(@OGUID+14, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Doodad_8GN_GNOME_CHAIR005 +(@OGUID+15, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Doodad_8GN_GNOME_CHAIR009 +(@OGUID+16, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Doodad_8DU_Mechagon_HedgeTrap002 +(@OGUID+17, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Doodad_8GN_GNOME_CHAIR006 +(@OGUID+18, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Doodad_8GN_GNOME_CHAIR010 +(@OGUID+19, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Doodad_8DU_Mechagon_HedgeTrap003 +(@OGUID+20, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Doodad_8DU_Mechagon_HedgeTrap009 +(@OGUID+21, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Doodad_8GN_GNOME_CHAIR007 +(@OGUID+22, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Energy Door +(@OGUID+23, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Doodad_8DU_Mechagon_HedgeTrap004 +(@OGUID+24, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Doodad_8DU_Mechagon_HedgeTrap010 +(@OGUID+25, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Doodad_8GN_GNOME_CHAIR008 +(@OGUID+26, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Energy Shield +(@OGUID+27, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Doodad_8DU_Mechagon_HedgeTrap011 +(@OGUID+28, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Doodad_8DU_Mechagon_HedgeTrap008 +(@OGUID+29, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Energy Door +(@OGUID+30, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Doodad_8DU_Mechagon_HedgeTrap009 +(@OGUID+33, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Garden Bridge +(@OGUID+34, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Doodad_8DU_Mechagon_HedgeTrap001 +(@OGUID+36, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Doodad_8DU_Mechagon_HedgeTrap010 +(@OGUID+37, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Doodad_8GN_GNOME_CHAIR005 +(@OGUID+38, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Doodad_8GN_GNOME_CHAIR009 +(@OGUID+40, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Doodad_8DU_Mechagon_HedgeTrap002 +(@OGUID+41, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Junkyard Door +(@OGUID+43, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Doodad_8DU_Mechagon_HedgeTrap011 +(@OGUID+44, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Doodad_8GN_GNOME_CHAIR006 +(@OGUID+45, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Doodad_8GN_GNOME_CHAIR010 +(@OGUID+47, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Doodad_8DU_Mechagon_HedgeTrap003 +(@OGUID+50, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Doodad_8DU_Mechagon_HedgeTrap012 +(@OGUID+51, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Doodad_8GN_GNOME_CHAIR007 +(@OGUID+53, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Doodad_8DU_Mechagon_HedgeTrap004 +(@OGUID+55, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Doodad_8GN_GNOME_CHAIR008 +(@OGUID+60, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Doodad_8DU_Mechagon_HedgeTrap005 +(@OGUID+62, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Overlook Door +(@OGUID+64, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Doodad_8GN_GNOME_CHAIR001 +(@OGUID+66, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Doodad_8DU_Mechagon_HedgeTrap006 +(@OGUID+68, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Doodad_8DU_Mechagon_HologramProjector001 +(@OGUID+70, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Doodad_8GN_GNOME_CHAIR002 +(@OGUID+71, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Doodad_8DU_Mechagon_HedgeTrap007 +(@OGUID+73, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Energy Shield +(@OGUID+78, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Doodad_8GN_GNOME_CHAIR004 +(@OGUID+79, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Doodad_8GN_GNOME_CHAIR013 +(@OGUID+80, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Doodad_8GN_GNOME_CHAIR014 +(@OGUID+81, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Doodad_8GN_GNOME_CHAIR015 +(@OGUID+82, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0), -- Doodad_8DU_Mechagon_HologramProjector003 +(@OGUID+83, 0, 0, 0.882947325706481933, 0.469472050666809082, 0, 0); -- Doodad_8GN_GNOME_CHAIR016 +-- GameObject_Template_Addon +DELETE FROM `gameobject_template_addon` WHERE `entry` IN (335572 /*Energy Shield*/, 335571 /*Energy Door*/, 335527 /*Garden Bridge*/, 335541 /*Overlook Door*/, 335575 /*Junkyard Door*/, 335573 /*Energy Door*/); +INSERT INTO `gameobject_template_addon` (`entry`, `faction`, `flags`, `WorldEffectID`, `AIAnimKitID`) VALUES +(335572, 0, 32, 0, 0), -- Energy Shield +(335571, 0, 32, 0, 0), -- Energy Door +(335527, 0, 32, 0, 0), -- Garden Bridge +(335541, 0, 48, 0, 0), -- Overlook Door +(335575, 0, 32, 0, 0), -- Junkyard Door +(335573, 0, 32, 0, 0); -- Energy Door + +-- Creature Template Data +DELETE FROM `creature_template_addon` WHERE `entry` IN (159567 /*159567 (Idee Quickcoil)*/, 159569 /*159569 (Yergin Galvaquad)*/, 159468 /*159468 (Abel Camhorn)*/, 159543 /*159543 (Pete Mixelgear)*/, 159572 /*159572 (Luka Morespark)*/, 159485 /*159485 (Tera Geotorque)*/, 159470 /*159470 (Jonian Monkash)*/, 159551 /*159551 (Spark Nimblecog)*/, 159545 /*159545 (Stuard Sharpsprocket)*/, 159558 /*159558 (Pegi Cogster)*/, 159529 /*159529 (Heidi Mitercone)*/, 159571 /*159571 (Flouresce Brightgear)*/, 160628 /*160628 (Milnar Danspark)*/, 158145 /*158145 (Prince Erazmin)*/, 160273 /*160273 (Projection)*/, 159559 /*159559 (Elya Codepunch)*/, 159487 /*159487 (Petra Cogwenne)*/, 159568 /*159568 (Endora Enginator) - -Unknown-*/, 157997 /*157997 (Kelsey Steelspark)*/, 159471 /*159471 (Alvin Teasprocket)*/, 159552 /*159552 (Noden Gyrozap)*/, 159486 /*159486 (Raz L. Dazzle)*/, 159524 /*159524 (Briony Vandercog)*/, 159550 /*159550 (Lelu Multipass)*/, 159587 /*159587 (Gelbin Mekkatorque)*/, 159528 /*159528 (Drusilla Zapwell)*/, 159530 /*159530 (Twyla Flickspring)*/, 160578 /*160578 (Quimby Sparklighter)*/, 159549 /*159549 (Shim Crankturner)*/, 159523 /*159523 (Lanna Statiglow)*/); +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `auras`) VALUES +(159567, 0, 0, 1, 1, 0, 0, 0, 0, ''), -- 159567 (Idee Quickcoil) +(159569, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 159569 (Yergin Galvaquad) +(159468, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 159468 (Abel Camhorn) +(159543, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 159543 (Pete Mixelgear) +(159572, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 159572 (Luka Morespark) +(159485, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 159485 (Tera Geotorque) +(159470, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 159470 (Jonian Monkash) +(159551, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 159551 (Spark Nimblecog) +(159545, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 159545 (Stuard Sharpsprocket) +(159558, 0, 0, 50331648, 1, 0, 14000, 0, 0, ''), -- 159558 (Pegi Cogster) +(159529, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 159529 (Heidi Mitercone) +(159571, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 159571 (Flouresce Brightgear) +(160628, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 160628 (Milnar Danspark) +(158145, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 158145 (Prince Erazmin) +(160273, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 160273 (Projection) +(159559, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 159559 (Elya Codepunch) +(159487, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 159487 (Petra Cogwenne) +(159568, 0, 0, 0, 1, 0, 0, 0, 0, '313603'), -- 159568 (Endora Enginator) - -Unknown- +(157997, 0, 0, 0, 0, 0, 0, 0, 0, ''), -- 157997 (Kelsey Steelspark) +(159471, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 159471 (Alvin Teasprocket) +(159552, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 159552 (Noden Gyrozap) +(159486, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 159486 (Raz L. Dazzle) +(159524, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 159524 (Briony Vandercog) +(159550, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 159550 (Lelu Multipass) +(159587, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 159587 (Gelbin Mekkatorque) +(159528, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 159528 (Drusilla Zapwell) +(159530, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 159530 (Twyla Flickspring) +(160578, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 160578 (Quimby Sparklighter) +(159549, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 159549 (Shim Crankturner) +(159523, 0, 0, 0, 1, 0, 0, 0, 0, ''); -- 159523 (Lanna Statiglow) + +-- Creature Scaling +DELETE FROM `creature_template_scaling` WHERE (`DifficultyID`=0 AND `Entry` IN (159567,159569,159468,159543,159572,159485,159470,159551,159545,159558,159529,159571,160628,158145,160273,159559,159487,159568,157997,159471,159552,159486,159524,159550,159587,159528,159530,160578,159549,159523)); +INSERT INTO `creature_template_scaling` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `VerifiedBuild`) VALUES +(159567, 0, 0, 0, 782, 40725), +(159569, 0, 0, 0, 782, 40725), +(159468, 0, 0, 0, 782, 40725), +(159543, 0, 0, 0, 782, 40725), +(159572, 0, 0, 0, 782, 40725), +(159485, 0, 0, 0, 782, 40725), +(159470, 0, 0, 0, 782, 40725), +(159551, 0, 0, 0, 782, 40725), +(159545, 0, 0, 0, 782, 40725), +(159558, 0, 0, 0, 782, 40725), +(159529, 0, 0, 0, 782, 40725), +(159571, 0, 0, 0, 782, 40725), +(160628, 0, 0, 0, 782, 40725), +(158145, 0, 0, 0, 782, 40725), +(160273, 0, 0, 0, 782, 40725), +(159559, 0, 0, 0, 782, 40725), +(159487, 0, 0, 0, 782, 40725), +(159568, 0, 0, 0, 782, 40725), +(157997, 0, 0, 0, 782, 40725), +(159471, 0, 0, 0, 782, 40725), +(159552, 0, 0, 0, 782, 40725), +(159486, 0, 0, 0, 782, 40725), +(159524, 0, 0, 0, 782, 40725), +(159550, 0, 0, 0, 782, 40725), +(159587, 0, 0, 0, 782, 40725), +(159528, 0, 0, 0, 782, 40725), +(159530, 0, 0, 0, 782, 40725), +(160578, 0, 0, 0, 782, 40725), +(159549, 0, 0, 0, 782, 40725), +(159523, 0, 0, 0, 782, 40725); + +-- Creature Model infp +DELETE FROM `creature_model_info` WHERE `DisplayID` IN (94028, 94030, 93995, 93960, 94033, 93917, 92263, 93986, 94013, 94032, 94301, 94026, 93932, 94029, 93921, 93924, 93942, 94040, 93957, 94031, 93940); +INSERT INTO `creature_model_info` (`DisplayID`, `BoundingRadius`, `CombatReach`, `DisplayID_Other_Gender`, `VerifiedBuild`) VALUES +(94028, 0.305999994277954101, 1.5, 0, 40725), +(94030, 0.305999994277954101, 1.5, 0, 40725), +(93995, 0.305999994277954101, 1.5, 0, 40725), +(93960, 0.305999994277954101, 1.5, 0, 40725), +(94033, 0.305999994277954101, 1.5, 0, 40725), +(93917, 0.305999994277954101, 1.5, 0, 40725), +(92263, 0.305999994277954101, 1.5, 0, 40725), +(93986, 0.305999994277954101, 1.5, 0, 40725), +(94013, 0.305999994277954101, 1.5, 0, 40725), +(94032, 0.305999994277954101, 1.5, 0, 40725), +(94301, 0.305999994277954101, 1.5, 0, 40725), +(94026, 0.305999994277954101, 1.5, 0, 40725), +(93932, 0.305999994277954101, 1.5, 0, 40725), +(94029, 0.305999994277954101, 1.5, 0, 40725), +(93921, 0.305999994277954101, 1.5, 0, 40725), +(93924, 0.305999994277954101, 1.5, 0, 40725), +(93942, 0.305999994277954101, 1.5, 0, 40725), +(94040, 0.305999994277954101, 1.5, 0, 40725), +(93957, 0.305999994277954101, 1.5, 0, 40725), +(94031, 0.305999994277954101, 1.5, 0, 40725), +(93940, 0.305999994277954101, 1.5, 0, 40725); + +UPDATE `creature_model_info` SET `VerifiedBuild`=40725 WHERE `DisplayID`=93920; +UPDATE `creature_model_info` SET `VerifiedBuild`=40725 WHERE `DisplayID`=93956; +UPDATE `creature_model_info` SET `VerifiedBuild`=40725 WHERE `DisplayID`=90798; +UPDATE `creature_model_info` SET `BoundingRadius`=19.979827880859375, `VerifiedBuild`=40725 WHERE `DisplayID`=91922; +UPDATE `creature_model_info` SET `BoundingRadius`=0.305999994277954101, `CombatReach`=1.5, `VerifiedBuild`=40725 WHERE `DisplayID`=93865; +UPDATE `creature_model_info` SET `BoundingRadius`=0.305999994277954101, `CombatReach`=1.5, `VerifiedBuild`=40725 WHERE `DisplayID`=92106; +UPDATE `creature_model_info` SET `VerifiedBuild`=40725 WHERE `DisplayID`=94037; +UPDATE `creature_model_info` SET `VerifiedBuild`=40725 WHERE `DisplayID`=93943; +UPDATE `creature_model_info` SET `BoundingRadius`=0.305999994277954101, `CombatReach`=1.5, `VerifiedBuild`=40725 WHERE `DisplayID`=93521; + +-- Update Creature Template +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `faction`=35, `npcflag`=1, `BaseAttackTime`=2000, `unit_flags`=33024, `unit_flags2`=2048 WHERE `entry`=159567; -- Idee Quickcoil +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `faction`=35, `BaseAttackTime`=2000, `unit_flags`=33024, `unit_flags2`=2048 WHERE `entry`=159569; -- Yergin Galvaquad +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `faction`=35, `BaseAttackTime`=2000, `unit_flags`=33024, `unit_flags2`=2048 WHERE `entry`=159468; -- Abel Camhorn +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `faction`=35, `BaseAttackTime`=2000, `unit_flags`=33024, `unit_flags2`=2048 WHERE `entry`=159543; -- Pete Mixelgear +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `faction`=35, `BaseAttackTime`=2000, `unit_flags`=33024, `unit_flags2`=2048 WHERE `entry`=159572; -- Luka Morespark +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `faction`=35, `BaseAttackTime`=2000, `unit_flags`=33024, `unit_flags2`=2048 WHERE `entry`=159485; -- Tera Geotorque +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=159470; -- Jonian Monkash +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `faction`=35, `BaseAttackTime`=2000, `unit_flags`=33024, `unit_flags2`=2048 WHERE `entry`=159551; -- Spark Nimblecog +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `faction`=35, `BaseAttackTime`=2000, `unit_flags`=33024, `unit_flags2`=2048 WHERE `entry`=159545; -- Stuard Sharpsprocket +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `faction`=35, `npcflag`=1, `BaseAttackTime`=2000, `unit_flags`=33024, `unit_flags2`=34816 WHERE `entry`=159558; -- Pegi Cogster +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=159529; -- Heidi Mitercone +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `faction`=35, `BaseAttackTime`=2000, `unit_flags`=33024, `unit_flags2`=2048 WHERE `entry`=159571; -- Flouresce Brightgear +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `faction`=35, `BaseAttackTime`=2000, `unit_flags`=33024, `unit_flags2`=2048 WHERE `entry`=160628; -- Milnar Danspark +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `faction`=3137, `npcflag`=2, `BaseAttackTime`=2000, `unit_flags`=33536, `unit_flags2`=2048 WHERE `entry`=158145; -- Prince Erazmin +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `faction`=35, `speed_run`=1, `BaseAttackTime`=2000, `unit_flags`=33555200, `unit_flags2`=73402368 WHERE `entry`=160273; -- Projection +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `faction`=35, `npcflag`=1, `BaseAttackTime`=2000, `unit_flags`=33024, `unit_flags2`=2048 WHERE `entry`=159559; -- Elya Codepunch +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `faction`=35, `BaseAttackTime`=2000, `unit_flags`=33024, `unit_flags2`=2048 WHERE `entry`=159487; -- Petra Cogwenne +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `faction`=35, `BaseAttackTime`=2000, `unit_flags`=33024, `unit_flags2`=2048 WHERE `entry`=159568; -- Endora Enginator +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=157997; -- Kelsey Steelspark +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `faction`=35, `BaseAttackTime`=2000, `unit_flags`=33024, `unit_flags2`=2048 WHERE `entry`=159471; -- Alvin Teasprocket +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `faction`=3175, `BaseAttackTime`=2000, `unit_flags`=33024, `unit_flags2`=2048 WHERE `entry`=159552; -- Noden Gyrozap +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `faction`=35, `BaseAttackTime`=2000, `unit_flags`=33024, `unit_flags2`=2048 WHERE `entry`=159486; -- Raz L. Dazzle +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `faction`=35, `BaseAttackTime`=2000, `unit_flags`=33024, `unit_flags2`=2048 WHERE `entry`=159524; -- Briony Vandercog +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `faction`=35, `BaseAttackTime`=2000, `unit_flags`=33024, `unit_flags2`=2048 WHERE `entry`=159550; -- Lelu Multipass +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `faction`=534, `npcflag`=2, `BaseAttackTime`=2000, `unit_flags`=33536, `unit_flags2`=2048, `unit_flags3`=1 WHERE `entry`=159587; -- Gelbin Mekkatorque +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=159528; -- Drusilla Zapwell +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `faction`=35, `BaseAttackTime`=2000, `unit_flags`=33024, `unit_flags2`=2048 WHERE `entry`=159530; -- Twyla Flickspring +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `faction`=35, `BaseAttackTime`=2000, `unit_flags`=33024, `unit_flags2`=2048 WHERE `entry`=160578; -- Quimby Sparklighter +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `faction`=3175, `BaseAttackTime`=2000, `unit_flags`=33024, `unit_flags2`=2048 WHERE `entry`=159549; -- Shim Crankturner +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `faction`=35, `BaseAttackTime`=2000, `unit_flags`=33024, `unit_flags2`=2048 WHERE `entry`=159523; -- Lanna Statiglow + +-- GameObject Template +DELETE FROM `gameobject_template` WHERE `entry` IN (335574 /*Doodad_8GN_GNOME_CHAIR016*/, 335526 /*Doodad_8DU_Mechagon_HologramProjector003*/, 335524 /*Doodad_8GN_GNOME_CHAIR015*/, 335523 /*Doodad_8GN_GNOME_CHAIR014*/, 335522 /*Doodad_8GN_GNOME_CHAIR013*/, 335519 /*Doodad_8GN_GNOME_CHAIR008*/, 335573 /*Energy Door*/, 335515 /*Doodad_8GN_GNOME_CHAIR004*/, 335532 /*Doodad_8DU_Mechagon_HedgeTrap005*/, 335513 /*Doodad_8GN_GNOME_CHAIR001*/, 335537 /*Doodad_8DU_Mechagon_HedgeTrap010*/, 335529 /*Doodad_8DU_Mechagon_HedgeTrap002*/, 335539 /*Doodad_8DU_Mechagon_HedgeTrap012*/, 335538 /*Doodad_8DU_Mechagon_HedgeTrap011*/, 335535 /*Doodad_8DU_Mechagon_HedgeTrap008*/, 335533 /*Doodad_8DU_Mechagon_HedgeTrap006*/, 335518 /*Doodad_8GN_GNOME_CHAIR007*/, 335521 /*Doodad_8GN_GNOME_CHAIR010*/, 335534 /*Doodad_8DU_Mechagon_HedgeTrap007*/, 335528 /*Doodad_8DU_Mechagon_HedgeTrap001*/, 335572 /*Energy Shield*/, 335575 /*Junkyard Door*/, 335531 /*Doodad_8DU_Mechagon_HedgeTrap004*/, 335527 /*Garden Bridge*/, 335517 /*Doodad_8GN_GNOME_CHAIR006*/, 335530 /*Doodad_8DU_Mechagon_HedgeTrap003*/, 335520 /*Doodad_8GN_GNOME_CHAIR009*/, 335536 /*Doodad_8DU_Mechagon_HedgeTrap009*/, 335541 /*Overlook Door*/, 339763 /*Flower*/, 341828 /*Mechagon City Teleporter*/, 339761 /*Flower*/, 339757 /*Flower*/, 339762 /*Flower*/, 339337 /*Stormwind Teleportation Unit*/, 339758 /*Flower*/, 335514 /*Doodad_8GN_GNOME_CHAIR002*/, 335571 /*Energy Door*/, 335516 /*Doodad_8GN_GNOME_CHAIR005*/, 335525 /*Doodad_8DU_Mechagon_HologramProjector001*/); +INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `size`, `Data0`, `Data1`, `Data2`, `Data3`, `Data4`, `Data5`, `Data6`, `Data7`, `Data8`, `Data9`, `Data10`, `Data11`, `Data12`, `Data13`, `Data14`, `Data15`, `Data16`, `Data17`, `Data18`, `Data19`, `Data20`, `Data21`, `Data22`, `Data23`, `Data24`, `Data25`, `Data26`, `Data27`, `Data28`, `Data29`, `Data30`, `Data31`, `Data32`, `Data33`, `ContentTuningId`, `VerifiedBuild`) VALUES +(335574, 5, 51446, 'Doodad_8GN_GNOME_CHAIR016', '', '', '', 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40725), -- Doodad_8GN_GNOME_CHAIR016 +(335526, 5, 55661, 'Doodad_8DU_Mechagon_HologramProjector003', '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40725), -- Doodad_8DU_Mechagon_HologramProjector003 +(335524, 5, 51446, 'Doodad_8GN_GNOME_CHAIR015', '', '', '', 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40725), -- Doodad_8GN_GNOME_CHAIR015 +(335523, 5, 51446, 'Doodad_8GN_GNOME_CHAIR014', '', '', '', 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40725), -- Doodad_8GN_GNOME_CHAIR014 +(335522, 5, 51446, 'Doodad_8GN_GNOME_CHAIR013', '', '', '', 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40725), -- Doodad_8GN_GNOME_CHAIR013 +(335519, 5, 51446, 'Doodad_8GN_GNOME_CHAIR008', '', '', '', 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40725), -- Doodad_8GN_GNOME_CHAIR008 +(335573, 0, 56750, 'Energy Door', '', '', '', 1, 1, 0, 2147483647, 0, 0, 0, 0, 5793, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40725), -- Energy Door +(335515, 5, 51446, 'Doodad_8GN_GNOME_CHAIR004', '', '', '', 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40725), -- Doodad_8GN_GNOME_CHAIR004 +(335532, 5, 55738, 'Doodad_8DU_Mechagon_HedgeTrap005', '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40725), -- Doodad_8DU_Mechagon_HedgeTrap005 +(335513, 5, 51446, 'Doodad_8GN_GNOME_CHAIR001', '', '', '', 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40725), -- Doodad_8GN_GNOME_CHAIR001 +(335537, 5, 55737, 'Doodad_8DU_Mechagon_HedgeTrap010', '', '', '', 0.999999940395355224, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40725), -- Doodad_8DU_Mechagon_HedgeTrap010 +(335529, 5, 55738, 'Doodad_8DU_Mechagon_HedgeTrap002', '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40725), -- Doodad_8DU_Mechagon_HedgeTrap002 +(335539, 5, 55739, 'Doodad_8DU_Mechagon_HedgeTrap012', '', '', '', 0.999999940395355224, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40725), -- Doodad_8DU_Mechagon_HedgeTrap012 +(335538, 5, 55738, 'Doodad_8DU_Mechagon_HedgeTrap011', '', '', '', 0.999999940395355224, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40725), -- Doodad_8DU_Mechagon_HedgeTrap011 +(335535, 5, 55738, 'Doodad_8DU_Mechagon_HedgeTrap008', '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40725), -- Doodad_8DU_Mechagon_HedgeTrap008 +(335533, 5, 55739, 'Doodad_8DU_Mechagon_HedgeTrap006', '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40725), -- Doodad_8DU_Mechagon_HedgeTrap006 +(335518, 5, 51446, 'Doodad_8GN_GNOME_CHAIR007', '', '', '', 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40725), -- Doodad_8GN_GNOME_CHAIR007 +(335521, 5, 51446, 'Doodad_8GN_GNOME_CHAIR010', '', '', '', 1.241874933242797851, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40725), -- Doodad_8GN_GNOME_CHAIR010 +(335534, 5, 55737, 'Doodad_8DU_Mechagon_HedgeTrap007', '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40725), -- Doodad_8DU_Mechagon_HedgeTrap007 +(335528, 5, 55737, 'Doodad_8DU_Mechagon_HedgeTrap001', '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40725), -- Doodad_8DU_Mechagon_HedgeTrap001 +(335572, 0, 56694, 'Energy Shield', '', '', '', 0.991377115249633789, 1, 0, 2147483645, 0, 0, 0, 0, 5793, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40725), -- Energy Shield +(335575, 0, 56860, 'Junkyard Door', '', '', '', 1, 1, 0, 2147483647, 0, 0, 0, 0, 5793, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40725), -- Junkyard Door +(335531, 5, 55737, 'Doodad_8DU_Mechagon_HedgeTrap004', '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40725), -- Doodad_8DU_Mechagon_HedgeTrap004 +(335527, 0, 55727, 'Garden Bridge', '', '', '', 1, 1, 0, 0, 0, 0, 0, 0, 5793, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40725), -- Garden Bridge +(335517, 5, 51446, 'Doodad_8GN_GNOME_CHAIR006', '', '', '', 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40725), -- Doodad_8GN_GNOME_CHAIR006 +(335530, 5, 55739, 'Doodad_8DU_Mechagon_HedgeTrap003', '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40725), -- Doodad_8DU_Mechagon_HedgeTrap003 +(335520, 5, 51446, 'Doodad_8GN_GNOME_CHAIR009', '', '', '', 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40725), -- Doodad_8GN_GNOME_CHAIR009 +(335536, 5, 55739, 'Doodad_8DU_Mechagon_HedgeTrap009', '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40725), -- Doodad_8DU_Mechagon_HedgeTrap009 +(335541, 0, 55834, 'Overlook Door', '', '', '', 0.999999940395355224, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40725), -- Overlook Door +(339763, 5, 59749, 'Flower', '', '', '', 0.419999986886978149, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40725), -- Flower +(341828, 5, 56536, 'Mechagon City Teleporter', '', '', '', 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40725), -- Mechagon City Teleporter +(339761, 5, 59747, 'Flower', '', '', '', 0.419999986886978149, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40725), -- Flower +(339757, 5, 59747, 'Flower', '', '', '', 0.25, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40725), -- Flower +(339762, 5, 59748, 'Flower', '', '', '', 0.419999986886978149, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40725), -- Flower +(339337, 5, 56536, 'Stormwind Teleportation Unit', '', '', '', 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40725), -- Stormwind Teleportation Unit +(339758, 5, 59747, 'Flower', '', '', '', 0.5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40725), -- Flower +(335514, 5, 51446, 'Doodad_8GN_GNOME_CHAIR002', '', '', '', 1.241874933242797851, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40725), -- Doodad_8GN_GNOME_CHAIR002 +(335571, 0, 56693, 'Energy Door', '', '', '', 1, 1, 0, 2147483645, 0, 0, 0, 0, 5793, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40725), -- Energy Door +(335516, 5, 51446, 'Doodad_8GN_GNOME_CHAIR005', '', '', '', 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40725), -- Doodad_8GN_GNOME_CHAIR005 +(335525, 5, 55661, 'Doodad_8DU_Mechagon_HologramProjector001', '', '', '', 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40725); -- Doodad_8DU_Mechagon_HologramProjector001 + +DELETE FROM `gameobject_template` WHERE `entry` IN (341363 /*Mechagon City Teleporter*/); +INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `size`, `Data0`, `Data1`, `Data2`, `Data3`, `Data4`, `Data5`, `Data6`, `Data7`, `Data8`, `Data9`, `Data10`, `Data11`, `Data12`, `Data13`, `Data14`, `Data15`, `Data16`, `Data17`, `Data18`, `Data19`, `Data20`, `Data21`, `Data22`, `Data23`, `Data24`, `Data25`, `Data26`, `Data27`, `Data28`, `Data29`, `Data30`, `Data31`, `Data32`, `Data33`, `ContentTuningId`, `VerifiedBuild`) VALUES +(341363, 5, 56536, 'Mechagon City Teleporter', '', '', '', 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40725); -- Mechagon City Teleporter +UPDATE `gameobject_template` SET `VerifiedBuild`=40725 WHERE `entry`=338477; -- Mechagon City Teleporter + +-- SAI & Scripts +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry` IN (159572, 159523, 159550, 160578, 159543, 159571, 159530, 159487, 160628, 159485, 159545); + +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (-(@CGUID+22), -(@CGUID+25), -(@CGUID+36), -(@CGUID+3), -(@CGUID+24), -(@CGUID+1), -(@CGUID+34), -(@CGUID+27), -(@CGUID+19), -(@CGUID+30), -(@CGUID+26)) AND `source_type` = 0; +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`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(-(@CGUID+22), 0, 0, 0, 1, 0, 100, 0, 5000, 10000, 10000, 20000, 0, '', 10, 6, 603, 3, 273, 25, 4, 1, 0, 0, 0, 0, 0, 0, 0, 'After 5s - 10s and Repeat every 10s - 20s - use Rnd Emote - to self'), +(-(@CGUID+25), 0, 0, 0, 1, 0, 100, 0, 5000, 10000, 10000, 20000, 0, '', 10, 6, 603, 3, 273, 25, 4, 1, 0, 0, 0, 0, 0, 0, 0, 'After 5s - 10s and Repeat every 10s - 20s - use Rnd Emote - to self'), +(-(@CGUID+36), 0, 0, 0, 1, 0, 100, 0, 5000, 10000, 10000, 20000, 0, '', 10, 6, 603, 3, 273, 25, 4, 1, 0, 0, 0, 0, 0, 0, 0, 'After 5s - 10s and Repeat every 10s - 20s - use Rnd Emote - to self'), +(-(@CGUID+3), 0, 0, 0, 1, 0, 100, 0, 5000, 10000, 10000, 20000, 0, '', 10, 6, 603, 3, 273, 25, 4, 1, 0, 0, 0, 0, 0, 0, 0, 'After 5s - 10s and Repeat every 10s - 20s - use Rnd Emote - to self'), +(-(@CGUID+24), 0, 0, 0, 1, 0, 100, 0, 5000, 10000, 10000, 20000, 0, '', 10, 6, 603, 3, 273, 25, 4, 1, 0, 0, 0, 0, 0, 0, 0, 'After 5s - 10s and Repeat every 10s - 20s - use Rnd Emote - to self'), +(-(@CGUID+1), 0, 0, 0, 1, 0, 100, 0, 5000, 10000, 10000, 20000, 0, '', 10, 6, 603, 3, 273, 25, 4, 1, 0, 0, 0, 0, 0, 0, 0, 'After 5s - 10s and Repeat every 10s - 20s - use Rnd Emote - to self'), +(-(@CGUID+34), 0, 0, 0, 1, 0, 100, 0, 5000, 10000, 10000, 20000, 0, '', 10, 6, 603, 3, 273, 25, 4, 1, 0, 0, 0, 0, 0, 0, 0, 'After 5s - 10s and Repeat every 10s - 20s - use Rnd Emote - to self'), +(-(@CGUID+27), 0, 0, 0, 1, 0, 100, 0, 5000, 10000, 10000, 20000, 0, '', 10, 6, 603, 3, 273, 25, 4, 1, 0, 0, 0, 0, 0, 0, 0, 'After 5s - 10s and Repeat every 10s - 20s - use Rnd Emote - to self'), +(-(@CGUID+19), 0, 0, 0, 1, 0, 100, 0, 5000, 10000, 10000, 20000, 0, '', 10, 6, 603, 3, 273, 25, 4, 1, 0, 0, 0, 0, 0, 0, 0, 'After 5s - 10s and Repeat every 10s - 20s - use Rnd Emote - to self'), +(-(@CGUID+30), 0, 0, 0, 1, 0, 100, 0, 5000, 10000, 10000, 20000, 0, '', 10, 6, 603, 3, 273, 25, 4, 1, 0, 0, 0, 0, 0, 0, 0, 'After 5s - 10s and Repeat every 10s - 20s - use Rnd Emote - to self'), +(-(@CGUID+26), 0, 0, 0, 1, 0, 100, 0, 5000, 10000, 10000, 20000, 0, '', 10, 6, 603, 3, 273, 25, 4, 1, 0, 0, 0, 0, 0, 0, 0, 'After 5s - 10s and Repeat every 10s - 20s - use Rnd Emote - to self'); |