diff options
| -rw-r--r-- | sql/updates/world/master/2024_09_09_01_world.sql | 427 |
1 files changed, 427 insertions, 0 deletions
diff --git a/sql/updates/world/master/2024_09_09_01_world.sql b/sql/updates/world/master/2024_09_09_01_world.sql new file mode 100644 index 00000000000..a0c1582f39a --- /dev/null +++ b/sql/updates/world/master/2024_09_09_01_world.sql @@ -0,0 +1,427 @@ +SET @CGUID := 10001835; +SET @OGUID := 10000313; + +SET @ATID := 93; +SET @ATCP := 80; +SET @ATSPAWNID := 94; + +SET @WORLDSAFELOC := 100066; + +-- Creature +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+92; +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`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `VerifiedBuild`) VALUES +(@CGUID+0, 210930, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 0, 2768.453125, -2100.595458984375, 249.5719146728515625, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Path Helper (Area: Keepers Terrace - Difficulty: 0) CreateObject1 (Auras: 422354 - Bot AI Follow Advert) +(@CGUID+1, 207197, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 1, 2790.546875, -2085.439208984375, 249.5719146728515625, 4.875698089599609375, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Cursed Rookguard (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@CGUID+2, 217118, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 0, 2843.87158203125, -1738.15625, 198.5966644287109375, 4.776163578033447265, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Skardyn Bomber (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@CGUID+3, 207198, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 1, 2785.58154296875, -2087.0400390625, 249.5719146728515625, 4.924534320831298828, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Cursed Thunderer (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@CGUID+4, 221296, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 1, 2855.28564453125, -2105.232666015625, 249.56976318359375, 2.147530555725097656, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Stormrider Cadet (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@CGUID+5, 221384, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 1, 2774.463623046875, -2086.507080078125, 249.5719146728515625, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Stormrider Cadet (Area: Keepers Terrace - Difficulty: 0) CreateObject1 (Auras: 443779 - Permanent Feign Death) +(@CGUID+6, 209538, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 0, 2799.475830078125, -2066.835205078125, 249.7407684326171875, 1.650404572486877441, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Stormrook (Area: Keepers Terrace - Difficulty: 0) CreateObject1 (Auras: 447082 - Bot AI Follow Advert, 434402 - Void Bound) +(@CGUID+7, 221296, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 1, 2768.7890625, -2096.21533203125, 249.5719146728515625, 3.243904829025268554, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Stormrider Cadet (Area: Keepers Terrace - Difficulty: 0) CreateObject1 (Auras: ) +(@CGUID+8, 221296, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 1, 2785.146728515625, -2176.248291015625, 266.919921875, 1.63180243968963623, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Stormrider Cadet (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@CGUID+9, 209538, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 0, 2803.329833984375, -2055.026123046875, 249.4253997802734375, 1.843489766120910644, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Stormrook (Area: Keepers Terrace - Difficulty: 0) CreateObject1 (Auras: 447082 - Bot AI Follow Advert, 434402 - Void Bound) +(@CGUID+10, 217118, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 0, 2783.428955078125, -1766.7535400390625, 198.583709716796875, 4.986763954162597656, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Skardyn Bomber (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@CGUID+11, 211152, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 0, 2795.14501953125, -2164.345458984375, 266.919921875, 1.922815561294555664, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Path Helper (Area: Keepers Terrace - Difficulty: 0) CreateObject1 (Auras: 424283 - Passive) +(@CGUID+12, 207198, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 1, 2810.692626953125, -2080.97216796875, 249.5711822509765625, 3.084811925888061523, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Cursed Thunderer (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@CGUID+13, 221296, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 1, 2807.26904296875, -2156.213623046875, 266.919921875, 4.718156337738037109, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Stormrider Cadet (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@CGUID+14, 228238, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 0, 2795.491455078125, -2123.4931640625, 258.65655517578125, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Path Helper (Area: Keepers Terrace - Difficulty: 0) CreateObject1 (Auras: 459757 - Advert) +(@CGUID+15, 221384, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 1, 2833.757080078125, -2118.057373046875, 249.569793701171875, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Stormrider Cadet (Area: Keepers Terrace - Difficulty: 0) CreateObject1 (Auras: 443779 - Permanent Feign Death) +(@CGUID+16, 211137, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 0, 2797.7275390625, -2160.326416015625, 266.919921875, 1.544129014015197753, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Path Helper (Area: Keepers Terrace - Difficulty: 0) CreateObject1 (Auras: 424283 - Passive) +(@CGUID+17, 207197, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 1, 2855.32470703125, -2102.65966796875, 249.56976318359375, 4.805169582366943359, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Cursed Rookguard (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@CGUID+18, 209538, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 0, 2796.5625, -2054.87158203125, 249.4253997802734375, 1.848643183708190917, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Stormrook (Area: Keepers Terrace - Difficulty: 0) CreateObject1 (Auras: 447082 - Bot AI Follow Advert, 434402 - Void Bound) +(@CGUID+19, 221296, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 1, 2833.173583984375, -2111.1181640625, 249.56982421875, 1.693514227867126464, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Stormrider Cadet (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@CGUID+20, 221296, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 1, 2790.127685546875, -2171.8837890625, 266.919921875, 1.63180243968963623, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Stormrider Cadet (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@CGUID+21, 207197, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 1, 2832.8359375, -2108.442626953125, 249.56982421875, 4.76571512222290039, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Cursed Rookguard (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@CGUID+22, 211150, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 0, 2805.8994140625, -2166.046875, 266.919921875, 0.941480696201324462, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Path Helper (Area: Keepers Terrace - Difficulty: 0) CreateObject1 (Auras: 424283 - Passive) +(@CGUID+23, 221296, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 1, 2803.913330078125, -2152.9462890625, 266.919921875, 4.798534870147705078, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Stormrider Cadet (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@CGUID+24, 207198, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 1, 2762.8828125, -2096.694580078125, 249.571929931640625, 0.274075478315353393, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Cursed Thunderer (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@CGUID+25, 207197, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 1, 2814.64404296875, -2084.354248046875, 249.5708465576171875, 4.92860269546508789, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Cursed Rookguard (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@CGUID+26, 217118, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 0, 2800.694580078125, -1727.3541259765625, 204.025146484375, 4.908718109130859375, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Skardyn Bomber (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@CGUID+27, 222896, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 0, 2800.295166015625, -2093.47216796875, 249.5708465576171875, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Path Helper (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@CGUID+28, 221296, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 1, 2841.1875, -2118.651123046875, 249.569732666015625, 1.693514227867126464, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Stormrider Cadet (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@CGUID+29, 221296, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 1, 2810.358642578125, -2171.33154296875, 266.919921875, 1.58337712287902832, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Stormrider Cadet (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@CGUID+30, 209538, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 0, 2792.819580078125, -2066.46533203125, 249.7407684326171875, 1.576322317123413085, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Stormrook (Area: Keepers Terrace - Difficulty: 0) CreateObject1 (Auras: 447082 - Bot AI Follow Advert, 434402 - Void Bound) +(@CGUID+31, 211149, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 0, 2802.44970703125, -2163.29345703125, 266.919921875, 1.55671083927154541, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Path Helper (Area: Keepers Terrace - Difficulty: 0) CreateObject1 (Auras: 424283 - Passive) +(@CGUID+32, 211151, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 0, 2791.3046875, -2162.5244140625, 266.919921875, 1.78464972972869873, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Path Helper (Area: Keepers Terrace - Difficulty: 0) CreateObject1 (Auras: 424283 - Passive) +(@CGUID+33, 207197, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 1, 2841.151123046875, -2115.5400390625, 249.5694427490234375, 4.7616119384765625, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Cursed Rookguard (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@CGUID+34, 221296, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 1, 2810.0322265625, -2176.098876953125, 266.919921875, 1.58337712287902832, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Stormrider Cadet (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@CGUID+35, 217118, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 0, 2811.460205078125, -1757.7603759765625, 198.5837249755859375, 4.975326061248779296, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Skardyn Bomber (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@CGUID+36, 221384, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 1, 2839.8212890625, -2102.685791015625, 249.569793701171875, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Stormrider Cadet (Area: Keepers Terrace - Difficulty: 0) CreateObject1 (Auras: 443779 - Permanent Feign Death) +(@CGUID+37, 207198, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 1, 2789.225830078125, -2080.098876953125, 249.5719146728515625, 0.335040569305419921, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Cursed Thunderer (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@CGUID+38, 221296, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 1, 2814.983642578125, -2171.369873046875, 266.919921875, 1.58337712287902832, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Stormrider Cadet (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@CGUID+39, 221384, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 1, 2805.65283203125, -2093.916748046875, 249.5708770751953125, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Stormrider Cadet (Area: Keepers Terrace - Difficulty: 0) CreateObject1 (Auras: 443779 - Permanent Feign Death) +(@CGUID+40, 221296, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 1, 2808.704833984375, -2152.28125, 266.919921875, 4.723114013671875, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Stormrider Cadet (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@CGUID+41, 211111, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 0, 2799.884521484375, -2167.05908203125, 266.919921875, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Path Helper (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@CGUID+42, 221296, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 1, 2790.259521484375, -2176.376708984375, 266.919921875, 1.63180243968963623, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Stormrider Cadet (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@CGUID+43, 210930, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 0, 2802.315185546875, -2070.619873046875, 249.5719146728515625, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Path Helper (Area: Keepers Terrace - Difficulty: 0) CreateObject1 (Auras: 422354 - Bot AI Follow Advert) +(@CGUID+44, 207198, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 1, 2813.177001953125, -2078.201416015625, 249.5711822509765625, 1.312993764877319335, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Cursed Thunderer (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@CGUID+45, 217118, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 0, 2761.876708984375, -1741.388916015625, 198.58355712890625, 5.014073848724365234, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Skardyn Bomber (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@CGUID+46, 221296, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 1, 2815.118896484375, -2176.140625, 266.919921875, 1.58337712287902832, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Stormrider Cadet (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@CGUID+47, 209538, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 0, 2806.455810546875, -2066.77783203125, 249.7407684326171875, 1.60890352725982666, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Stormrook (Area: Keepers Terrace - Difficulty: 0) CreateObject1 (Auras: 447082 - Bot AI Follow Advert, 434402 - Void Bound) +(@CGUID+48, 207197, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 1, 2848.1806640625, -2110.185791015625, 249.56976318359375, 4.720962047576904296, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Cursed Rookguard (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@CGUID+49, 209801, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 1, 2787.6201171875, -2093.300048828125, 249.4886016845703125, 0.841249048709869384, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Quartermaster Koratite (Area: Keepers Terrace - Difficulty: 0) CreateObject1 (Auras: 422358 - Bot AI Follow Advert) +(@CGUID+50, 221296, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 1, 2784.990478515625, -2171.921875, 266.919921875, 1.63180243968963623, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Stormrider Cadet (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@CGUID+51, 212786, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 0, 2751.637939453125, -2077.210205078125, 253.9727630615234375, 5.3907623291015625, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Voidrider (Area: Keepers Terrace - Difficulty: 0) CreateObject1 (Auras: ) +(@CGUID+52, 210930, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 0, 2823.78125, -2122.032958984375, 249.5738067626953125, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Path Helper (Area: Keepers Terrace - Difficulty: 0) CreateObject1 (Auras: 422354 - Bot AI Follow Advert) +(@CGUID+53, 215967, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 1, 2793.7578125, -2154.578125, 266.919921875, 4.727211475372314453, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Stormrider Vokmar (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@CGUID+54, 221296, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 1, 2848.150146484375, -2113.58154296875, 249.56976318359375, 1.736614823341369628, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Stormrider Cadet (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@CGUID+55, 218839, 2648, 14771, 15042, '1,2,8,23', 0, 0, 0, 0, 2800.052001953125, -2075.098876953125, 252.5548248291015625, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Dark Fragment (Area: Keepers Terrace - Difficulty: 0) CreateObject1 (Auras: 462125 - Spawn) +(@CGUID+56, 212786, 2648, 14938, 15328, '1,2,8,23', 0, 0, 0, 0, 2766.080810546875, -1650.1910400390625, 331.670440673828125, 6.235808849334716796, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Voidrider (Area: The Rookery Landing - Difficulty: Normal) CreateObject1 (Auras: ) +(@CGUID+57, 229690, 2648, 14938, 15328, '1,2,8,23', 0, 0, 0, 0, 2820.064208984375, -1714.8646240234375, 331.58880615234375, 2.711475133895874023, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Stormrook Beacon (Area: The Rookery Landing - Difficulty: Normal) CreateObject1 +(@CGUID+58, 207197, 2648, 14938, 15328, '1,2,8,23', 0, 0, 0, 1, 2762.65283203125, -1643.0382080078125, 331.667999267578125, 0.305273890495300292, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Cursed Rookguard (Area: The Rookery Landing - Difficulty: Normal) CreateObject1 +(@CGUID+59, 207198, 2648, 14938, 15328, '1,2,8,23', 0, 0, 0, 1, 2754.315185546875, -1650.5504150390625, 331.6566162109375, 6.235808849334716796, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Cursed Thunderer (Area: The Rookery Landing - Difficulty: Normal) CreateObject1 +(@CGUID+60, 210930, 2648, 14938, 15328, '1,2,8,23', 0, 0, 0, 0, 2787.303955078125, -1654.8038330078125, 331.675811767578125, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Path Helper (Area: The Rookery Landing - Difficulty: Normal) CreateObject1 (Auras: 422354 - Bot AI Follow Advert) +(@CGUID+61, 207199, 2648, 14938, 15328, '1,2,8,23', 0, 0, 0, 1, 2844.27783203125, -1655.4617919921875, 331.657470703125, 0.184982642531394958, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Cursed Rooktender (Area: The Rookery Landing - Difficulty: Normal) CreateObject1 +(@CGUID+62, 212786, 2648, 14938, 15328, '1,2,8,23', 0, 0, 0, 0, 2830.09033203125, -1574, 331.674560546875, 4.020925045013427734, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Voidrider (Area: The Rookery Landing - Difficulty: Normal) CreateObject1 (Auras: ) +(@CGUID+63, 207186, 2648, 14938, 15328, '1,2,8,23', 0, 0, 0, 0, 2792.029541015625, -1642.392333984375, 330.3995361328125, 2.988294601440429687, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Unruly Stormrook (Area: The Rookery Landing - Difficulty: Normal) CreateObject1 +(@CGUID+64, 207199, 2648, 14938, 15328, '1,2,8,23', 0, 0, 0, 1, 2787.1416015625, -1639.154541015625, 330.178955078125, 5.422444820404052734, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Cursed Rooktender (Area: The Rookery Landing - Difficulty: Normal) CreateObject1 +(@CGUID+65, 207198, 2648, 14938, 15328, '1,2,8,23', 0, 0, 0, 1, 2792.609375, -1646.626708984375, 330.397308349609375, 1.4249345064163208, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Cursed Thunderer (Area: The Rookery Landing - Difficulty: Normal) CreateObject1 +(@CGUID+66, 207186, 2648, 14938, 15328, '1,2,8,23', 0, 0, 0, 0, 2861.369873046875, -1653.3819580078125, 337.66156005859375, 4.1450653076171875, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Unruly Stormrook (Area: The Rookery Landing - Difficulty: Normal) CreateObject1 +(@CGUID+67, 207197, 2648, 14938, 15328, '1,2,8,23', 0, 0, 0, 1, 2841.14501953125, -1649.0382080078125, 331.662506103515625, 0.184982642531394958, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Cursed Rookguard (Area: The Rookery Landing - Difficulty: Normal) CreateObject1 +(@CGUID+68, 211149, 2648, 14938, 15328, '1,2,8,23', 0, 0, 0, 0, 2775.710205078125, -1619.579833984375, 330.91534423828125, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Path Helper (Area: The Rookery Landing - Difficulty: Normal) CreateObject1 (Auras: 424283 - Passive) +(@CGUID+69, 211151, 2648, 14938, 15328, '1,2,8,23', 0, 0, 0, 0, 2778.154541015625, -1626.99658203125, 330.911163330078125, 0.780132532119750976, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Path Helper (Area: The Rookery Landing - Difficulty: Normal) CreateObject1 (Auras: 424283 - Passive) +(@CGUID+70, 207197, 2648, 14938, 15328, '1,2,8,23', 0, 0, 0, 1, 2758.197998046875, -1617.0035400390625, 331.681732177734375, 2.59535384178161621, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Cursed Rookguard (Area: The Rookery Landing - Difficulty: Normal) CreateObject1 +(@CGUID+71, 210930, 2648, 14938, 15328, '1,2,8,23', 0, 0, 0, 0, 2758.4072265625, -1633.4930419921875, 331.640167236328125, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Path Helper (Area: The Rookery Landing - Difficulty: Normal) CreateObject1 (Auras: 422354 - Bot AI Follow Advert) +(@CGUID+72, 211152, 2648, 14938, 15328, '1,2,8,23', 0, 0, 0, 0, 2775.673583984375, -1613.41845703125, 330.915435791015625, 6.246951580047607421, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Path Helper (Area: The Rookery Landing - Difficulty: Normal) CreateObject1 (Auras: 424283 - Passive) +(@CGUID+73, 210930, 2648, 14938, 15328, '1,2,8,23', 0, 0, 0, 0, 2757.979248046875, -1598.3646240234375, 331.688812255859375, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Path Helper (Area: The Rookery Landing - Difficulty: Normal) CreateObject1 (Auras: 422354 - Bot AI Follow Advert) +(@CGUID+74, 207199, 2648, 14938, 15328, '1,2,8,23', 0, 0, 0, 1, 2844.58935546875, -1613.642333984375, 331.7958984375, 6.259288311004638671, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Cursed Rooktender (Area: The Rookery Landing - Difficulty: Normal) CreateObject1 +(@CGUID+75, 207197, 2648, 14938, 15328, '1,2,8,23', 0, 0, 0, 1, 2838.690185546875, -1611.986083984375, 331.856048583984375, 6.259288311004638671, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Cursed Rookguard (Area: The Rookery Landing - Difficulty: Normal) CreateObject1 +(@CGUID+76, 211137, 2648, 14938, 15328, '1,2,8,23', 0, 0, 0, 0, 2775.6962890625, -1608.4478759765625, 330.915313720703125, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Path Helper (Area: The Rookery Landing - Difficulty: Normal) CreateObject1 (Auras: 424283 - Passive) +(@CGUID+77, 211150, 2648, 14938, 15328, '1,2,8,23', 0, 0, 0, 0, 2777.794189453125, -1601.125, 330.91363525390625, 5.253554821014404296, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Path Helper (Area: The Rookery Landing - Difficulty: Normal) CreateObject1 (Auras: 424283 - Passive) +(@CGUID+78, 207186, 2648, 14938, 15328, '1,2,8,23', 0, 0, 0, 0, 2737.052001953125, -1613.8177490234375, 339.22027587890625, 5.879273414611816406, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Unruly Stormrook (Area: The Rookery Landing - Difficulty: Normal) CreateObject1 +(@CGUID+79, 207199, 2648, 14938, 15328, '1,2,8,23', 0, 0, 0, 1, 2754.161376953125, -1613.43408203125, 331.807098388671875, 2.59535384178161621, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Cursed Rooktender (Area: The Rookery Landing - Difficulty: Normal) CreateObject1 +(@CGUID+80, 207186, 2648, 14938, 15328, '1,2,8,23', 0, 0, 0, 0, 2862.537353515625, -1613.5555419921875, 339.879425048828125, 4.611938953399658203, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Unruly Stormrook (Area: The Rookery Landing - Difficulty: Normal) CreateObject1 +(@CGUID+81, 222922, 2648, 14938, 15328, '1,2,8,23', 0, 0, 0, 0, 2799.338623046875, -1616.4478759765625, 329.03759765625, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Path Helper (Area: The Rookery Landing - Difficulty: Normal) CreateObject1 +(@CGUID+82, 221556, 2648, 14938, 15328, '1,2,8,23', 0, 0, 0, 0, 2770.7900390625, -1614.076416015625, 330.403106689453125, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Lightning Torrent Stalker - South Walk West (Area: The Rookery Landing - Difficulty: Normal) CreateObject1 +(@CGUID+83, 221553, 2648, 14938, 15328, '1,2,8,23', 0, 0, 0, 0, 2828.811767578125, -1614.076416015625, 330.403106689453125, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Lightning Torrent Stalker - North Walk East (Area: The Rookery Landing - Difficulty: Normal) CreateObject1 +(@CGUID+84, 221555, 2648, 14938, 15328, '1,2,8,23', 0, 0, 0, 0, 2770.7900390625, -1614.076416015625, 330.403106689453125, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Lightning Torrent Stalker - South Walk East (Area: The Rookery Landing - Difficulty: Normal) CreateObject1 +(@CGUID+85, 221554, 2648, 14938, 15328, '1,2,8,23', 0, 0, 0, 0, 2828.811767578125, -1614.076416015625, 330.403106689453125, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Lightning Torrent Stalker - North Walk West (Area: The Rookery Landing - Difficulty: Normal) CreateObject1 +(@CGUID+86, 207186, 2648, 14938, 15328, '1,2,8,23', 0, 0, 0, 0, 2738.197998046875, -1573.767333984375, 337.590362548828125, 4.849386215209960937, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Unruly Stormrook (Area: The Rookery Landing - Difficulty: Normal) CreateObject1 +(@CGUID+87, 207199, 2648, 14938, 15328, '1,2,8,23', 0, 0, 0, 1, 2762.838623046875, -1582.2222900390625, 331.68603515625, 3.042886257171630859, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Cursed Rooktender (Area: The Rookery Landing - Difficulty: Normal) CreateObject1 +(@CGUID+88, 207197, 2648, 14938, 15328, '1,2,8,23', 0, 0, 0, 1, 2766.052978515625, -1585.91845703125, 331.5498046875, 2.266695737838745117, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Cursed Rookguard (Area: The Rookery Landing - Difficulty: Normal) CreateObject1 +(@CGUID+89, 207197, 2648, 14938, 15328, '1,2,8,23', 0, 0, 0, 1, 2831.890625, -1582.71533203125, 331.6748046875, 4.034930229187011718, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Cursed Rookguard (Area: The Rookery Landing - Difficulty: Normal) CreateObject1 +(@CGUID+90, 207198, 2648, 14938, 15328, '1,2,8,23', 0, 0, 0, 1, 2838.693603515625, -1575.279541015625, 331.664794921875, 4.020925045013427734, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Cursed Thunderer (Area: 0 - Difficulty: Normal) CreateObject1 +(@CGUID+91, 228238, 2648, 14938, 15328, '1,2,8,23', 0, 0, 0, 0, 2773.134521484375, -1613.9166259765625, 330.403594970703125, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Path Helper (Area: 0 - Difficulty: Normal) CreateObject2 (Auras: 459757 - Advert) +(@CGUID+92, 209230, 2648, 14938, 15328, '1,2,8,23', 0, 0, 0, 0, 2799.384521484375, -1579.7725830078125, 330.017547607421875, 4.772686958312988281, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421); -- Kyrioss (Area: 0 - Difficulty: Normal) CreateObject2 (Auras: 422356 - Bot AI Follow Advert) +DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+92; +INSERT INTO `creature_addon` (`guid`, `PathId`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(@CGUID+1, 0, 0, 0, 0, 0, 1, 0, 333, 0, 0, 0, 0, ''), -- Cursed Rookguard +(@CGUID+6, 0, 0, 3, 0, 0, 1, 0, 0, 0, 0, 0, 4, '447082 434402'), -- Stormrook - 447082 - Bot AI Follow Advert, 434402 - Void Bound +(@CGUID+7, 0, 0, 8, 0, 0, 1, 0, 0, 0, 0, 0, 4, ''), -- Stormrider Cadet +(@CGUID+8, 0, 0, 0, 0, 0, 1, 0, 333, 0, 0, 0, 4, ''), -- Stormrider Cadet +(@CGUID+9, 0, 0, 3, 0, 0, 1, 0, 0, 0, 0, 0, 4, '447082 434402'), -- Stormrook - 447082 - Bot AI Follow Advert, 434402 - Void Bound +(@CGUID+18, 0, 0, 3, 0, 0, 1, 0, 0, 0, 0, 0, 4, '447082 434402'), -- Stormrook - 447082 - Bot AI Follow Advert, 434402 - Void Bound +(@CGUID+20, 0, 0, 0, 0, 0, 1, 0, 333, 0, 0, 0, 4, ''), -- Stormrider Cadet +(@CGUID+25, 0, 0, 0, 0, 0, 1, 0, 333, 0, 0, 0, 0, ''), -- Cursed Rookguard +(@CGUID+29, 0, 0, 0, 0, 0, 1, 0, 333, 0, 0, 0, 4, ''), -- Stormrider Cadet +(@CGUID+30, 0, 0, 3, 0, 0, 1, 0, 0, 0, 0, 0, 4, '447082 434402'), -- Stormrook - 447082 - Bot AI Follow Advert, 434402 - Void Bound +(@CGUID+34, 0, 0, 0, 0, 0, 1, 0, 333, 0, 0, 0, 4, ''), -- Stormrider Cadet +(@CGUID+38, 0, 0, 0, 0, 0, 1, 0, 333, 0, 0, 0, 4, ''), -- Stormrider Cadet +(@CGUID+42, 0, 0, 0, 0, 0, 1, 0, 333, 0, 0, 0, 4, ''), -- Stormrider Cadet +(@CGUID+46, 0, 0, 0, 0, 0, 1, 0, 333, 0, 0, 0, 4, ''), -- Stormrider Cadet +(@CGUID+47, 0, 0, 3, 0, 0, 1, 0, 0, 0, 0, 0, 4, '447082 434402'), -- Stormrook - 447082 - Bot AI Follow Advert, 434402 - Void Bound +(@CGUID+50, 0, 0, 0, 0, 0, 1, 0, 333, 0, 0, 0, 4, ''), -- Stormrider Cadet +(@CGUID+51, 0, 0, 0, 3, 0, 1, 0, 0, 0, 0, 0, 3, ''), -- Voidrider - +(@CGUID+66, 0, 0, 3, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- Unruly Stormrook +(@CGUID+78, 0, 0, 3, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- Unruly Stormrook +(@CGUID+80, 0, 0, 3, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- Unruly Stormrook +(@CGUID+86, 0, 0, 3, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''); -- Unruly Stormrook + +UPDATE `creature` SET `StringId`='cursed_thunderer_dark_fragment' WHERE `guid` IN (@CGUID+37, @CGUID+12); +UPDATE `creature` SET `StringId`='cursed_thunderer_stormrider_cadet' WHERE `guid` = @CGUID+24; +UPDATE `creature` SET `curHealthPct`=20 WHERE `guid` IN (@CGUID+7, @CGUID+19, @CGUID+28, @CGUID+54, @CGUID+4); + +-- Gameobject +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+94; +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, 465916, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2778.9296875, -2400.220458984375, 231.01513671875, 3.141592741012573242, 0, 0, -1, 0, 7200, 255, 1, 56421), -- Bench (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+1, 452663, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2965.107421875, -2277.404296875, 252.4530487060546875, 0.32288438081741333, 0, 0, 0.160741806030273437, 0.98699653148651123, 7200, 255, 1, 56421), -- Chair (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+2, 437583, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2581.483154296875, -2134.02392578125, 182.4420013427734375, 0.829353392124176025, 0, 0, 0.402894020080566406, 0.915246665477752685, 7200, 255, 1, 56421), -- Chair (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+3, 452662, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2967.564453125, -2278.76171875, 252.4530487060546875, 2.015855789184570312, 0, 0, 0.845727920532226562, 0.533614337444305419, 7200, 255, 1, 56421), -- Chair (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+4, 465920, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2824.424560546875, -2208.76220703125, 266.835296630859375, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 7200, 255, 1, 56421), -- Bench (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+5, 446228, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2675.9677734375, -2396.797119140625, 205.954132080078125, 3.682650327682495117, 0, 0, -0.96362972259521484, 0.26724100112915039, 7200, 255, 1, 56421), -- Chair (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+6, 437582, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2584.690185546875, -2130.816650390625, 182.452850341796875, 3.867594718933105468, 0, 0, -0.93483543395996093, 0.355081290006637573, 7200, 255, 1, 56421), -- Chair (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+7, 465923, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2718.225830078125, -2425.522705078125, 231.0150299072265625, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 7200, 255, 1, 56421), -- Bench (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+8, 450180, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2260.7744140625, -2670.944580078125, 265.40557861328125, 0.785396754741668701, 0, 0, 0.38268280029296875, 0.923879802227020263, 7200, 255, 1, 56421), -- 450180 (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+9, 466061, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2761.807373046875, -2445.46875, 231.015625, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 7200, 255, 1, 56421), -- Bench (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+10, 466060, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2778.75, -2414.65966796875, 231.015625, 3.141592741012573242, 0, 0, -1, 0, 7200, 255, 1, 56421), -- Bench (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+11, 398729, 2648, 14771, 15042, '1,2,8,23', 0, 0, 1685.556396484375, -1459.82177734375, 5.405548572540283203, 0.751515924930572509, 0, 0, 0.366977691650390625, 0.930229723453521728, 7200, 255, 1, 56421), -- Chair (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+12, 432823, 2648, 14771, 15042, '1,2,8,23', 0, 0, 3227.093505859375, -2847.00244140625, 371.299407958984375, 5.492420196533203125, 0, 0, -0.38516139984130859, 0.922849237918853759, 7200, 255, 1, 56421), -- Door (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+13, 440938, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2593.3876953125, -2556.132080078125, 181.9781036376953125, 1.588251471519470214, 0, 0, 0.713251113891601562, 0.700908601284027099, 7200, 255, 1, 56421), -- Gate (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+14, 466062, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2760.064208984375, -2382.34716796875, 231.0146484375, 3.141592741012573242, 0, 0, -1, 0, 7200, 255, 1, 56421), -- Bench (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+15, 450650, 2648, 14771, 15042, '1,2,8,23', 0, 0, 1894.6302490234375, -2687.361083984375, 138.7619476318359375, 5.988606452941894531, 0.140343189239501953, -0.25971031188964843, -0.09673690795898437, 0.950524210929870605, 7200, 255, 1, 56421), -- Dormant Rock Giant (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+16, 452669, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2967.662109375, -2259.3359375, 252.4336700439453125, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 7200, 255, 1, 56421), -- Chair (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+17, 430493, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2800.541259765625, -1722.738037109375, 203.8399505615234375, 1.575784087181091308, 0, 0, 0.708868026733398437, 0.705341160297393798, 7200, 255, 1, 56421), -- Earthen Door (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+18, 466057, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2833.749267578125, -2351.54345703125, 258.19183349609375, 2.356189966201782226, 0, 0, 0.923878669738769531, 0.38268551230430603, 7200, 255, 1, 56421), -- Bench (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+19, 452668, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2973.1298828125, -2279.076171875, 252.4653472900390625, 1.448621988296508789, 0, 0, 0.662619590759277343, 0.748956084251403808, 7200, 255, 1, 56421), -- Chair (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+20, 452670, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2587.15234375, -2282.125, 164.4348297119140625, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 7200, 255, 1, 56421), -- Chair (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+21, 465928, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2818.298583984375, -2252.30908203125, 266.83746337890625, 2.356189966201782226, 0, 0, 0.923878669738769531, 0.38268551230430603, 7200, 255, 1, 56421), -- Bench (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+22, 452665, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2970.626953125, -2257.48046875, 252.5463104248046875, 4.773476600646972656, 0, 0, -0.68518257141113281, 0.728371381759643554, 7200, 255, 1, 56421), -- Chair (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+23, 452664, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2973.181640625, -2259.3984375, 252.39544677734375, 3.176533222198486328, 0, 0, -0.999847412109375, 0.017469281330704689, 7200, 255, 1, 56421), -- Chair (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+24, 452667, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2975.6904296875, -2276.6171875, 252.4704132080078125, 3.141592741012573242, 0, 0, -1, 0, 7200, 255, 1, 56421), -- Chair (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+25, 450828, 2648, 14771, 15042, '1,2,8,23', 0, 0, 1790.7586669921875, -1323.0416259765625, -2.18679475784301757, 3.630291461944580078, 0, 0, -0.97029495239257812, 0.241925001144409179, 7200, 255, 1, 56421), -- -Unknown- (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+26, 452666, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2970.607421875, -2261.1328125, 252.5745086669921875, 1.544615507125854492, 0, 0, 0.697790145874023437, 0.716302275657653808, 7200, 255, 1, 56421), -- Chair (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+27, 466097, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2840.264892578125, -2345.31591796875, 258.19183349609375, 2.356189966201782226, 0, 0, 0.923878669738769531, 0.38268551230430603, 7200, 255, 1, 56421), -- Bench (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+28, 466853, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2926.971435546875, -2323.74365234375, 349.087432861328125, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 7200, 255, 1, 56421), -- Fire (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+29, 466032, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2748.09375, -2445.442626953125, 231.015625, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 7200, 255, 1, 56421), -- Bench (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+30, 465971, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2759.802001953125, -2341.991455078125, 266.9361572265625, 3.141592741012573242, 0, 0, -1, 0, 7200, 255, 1, 56421), -- Bench (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+31, 450638, 2648, 14771, 15042, '1,2,8,23', 0, 0, 1709.1788330078125, -1462.78125, -0.7358059287071228, 5.977754592895507812, 0, 0, -0.15212249755859375, 0.988361656665802001, 7200, 255, 1, 56421), -- -Unknown- (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+32, 466852, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2863.93701171875, -2386.778076171875, 348.995269775390625, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 7200, 255, 1, 56421), -- Fire (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+33, 446215, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2724.09716796875, -2441.42626953125, 208.86956787109375, 3.961898565292358398, 0, 0, -0.91705989837646484, 0.398749500513076782, 7200, 255, 1, 56421), -- Chair (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+34, 450699, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2260.7744140625, -2670.944580078125, 265.40557861328125, 0.785396754741668701, 0, 0, 0.38268280029296875, 0.923879802227020263, 7200, 255, 1, 56421), -- 450699 (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+35, 465983, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2776.99560546875, -2209.32470703125, 266.83551025390625, 5.497788906097412109, 0, 0, -0.38268280029296875, 0.923879802227020263, 7200, 255, 1, 56421), -- Bench (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+36, 465982, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2827.255126953125, -2243.132080078125, 266.83746337890625, 2.356189966201782226, 0, 0, 0.923878669738769531, 0.38268551230430603, 7200, 255, 1, 56421), -- Bench (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+37, 466851, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2992.27978515625, -2387.436279296875, 348.596710205078125, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 7200, 255, 1, 56421), -- Fire (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+38, 465976, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2759.451416015625, -2290.083251953125, 266.95574951171875, 3.141592741012573242, 0, 0, -1, 0, 7200, 255, 1, 56421), -- Bench (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+39, 437601, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2538.237548828125, -2123.151123046875, 182.40570068359375, 1.424145460128784179, 0, 0, 0.65340423583984375, 0.75700920820236206, 7200, 255, 1, 56421), -- Chair (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+40, 446223, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2720.120361328125, -2445.610595703125, 208.84490966796875, 1.047197580337524414, 0, 0, 0.5, 0.866025388240814208, 7200, 255, 1, 56421), -- Chair (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+41, 437600, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2539.70703125, -2118.91748046875, 182.4210662841796875, 4.3317108154296875, 0, 0, -0.82811546325683593, 0.560557544231414794, 7200, 255, 1, 56421), -- Chair (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+42, 446222, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2671.779296875, -2401.174072265625, 205.9116668701171875, 0.855210542678833007, 0, 0, 0.414692878723144531, 0.909961462020874023, 7200, 255, 1, 56421), -- Chair (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+43, 437603, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2563.38134765625, -2148.50048828125, 182.4405059814453125, 0.933147966861724853, 0, 0, 0.4498291015625, 0.893114686012268066, 7200, 255, 1, 56421), -- Chair (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+44, 466021, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2778.671142578125, -2428.3125, 231.013885498046875, 3.141592741012573242, 0, 0, -1, 0, 7200, 255, 1, 56421), -- Bench (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+45, 437602, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2566.3486328125, -2145.28662109375, 182.3824462890625, 3.899442911148071289, 0, 0, -0.9290628433227539, 0.369921952486038208, 7200, 255, 1, 56421), -- Chair (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+46, 465952, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2833.260498046875, -2229.345458984375, 266.837249755859375, 3.106652259826660156, 0, 0, 0.999847412109375, 0.017469281330704689, 7200, 255, 1, 56421), -- Bench (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+47, 450535, 2648, 14771, 15042, '1,2,8,23', 0, 0, 1711.44970703125, -1375.4254150390625, 0.299031585454940795, 5.672322273254394531, 0, 0, -0.3007049560546875, 0.953717231750488281, 7200, 255, 1, 56421), -- -Unknown- (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+48, 466082, 2648, 14771, 15042, '1,2,8,23', 0, 0, 3581.064208984375, -2438.5, 957.498046875, 3.593750715255737304, -0.2376718521118164, -0.18511867523193359, -0.92043018341064453, 0.249101221561431884, 7200, 255, 1, 56421), -- Dormant Rock Giant (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+49, 465886, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2788.0712890625, -2430.302001953125, 239.2948455810546875, 0, 0, 0, 0, 1, 7200, 255, 1, 56421), -- Bench (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+50, 465881, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2833.447998046875, -2217.182373046875, 266.8370361328125, 3.106652259826660156, 0, 0, 0.999847412109375, 0.017469281330704689, 7200, 255, 1, 56421), -- Bench (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+51, 398729, 2648, 14771, 15042, '1,2,8,23', 0, 0, 1689.810546875, -1365.49951171875, 6.440386295318603515, 0.446083664894104003, 0, 0, 0.221197128295898437, 0.975229144096374511, 7200, 255, 1, 56421), -- Chair (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+52, 466018, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2759.8046875, -2331.96875, 266.9361572265625, 3.141592741012573242, 0, 0, -1, 0, 7200, 255, 1, 56421), -- Bench (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+53, 465965, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2729.6015625, -2437.578125, 231.0150299072265625, 6.230826377868652343, 0, 0, -0.02617645263671875, 0.999657332897186279, 7200, 255, 1, 56421), -- Bench (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+54, 437589, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2571.8828125, -2118.716064453125, 182.511260986328125, 2.384893417358398437, 0, 0, 0.9292755126953125, 0.369387358427047729, 7200, 255, 1, 56421), -- Chair (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+55, 440938, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2464.394775390625, -2209.784912109375, 163.361175537109375, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 7200, 255, 1, 56421), -- Gate (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+56, 437588, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2567.01611328125, -2113.849365234375, 182.511260986328125, 5.703861236572265625, 0, 0, -0.28562831878662109, 0.958340466022491455, 7200, 255, 1, 56421), -- Chair (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+57, 466088, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2759.447998046875, -2300.10595703125, 266.95574951171875, 3.141592741012573242, 0, 0, -1, 0, 7200, 255, 1, 56421), -- Bench (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+58, 437591, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2574.644287109375, -2103.356201171875, 183.14990234375, 3.036147356033325195, 0, 0, 0.998610496520996093, 0.052698194980621337, 7200, 255, 1, 56421), -- Chair (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+59, 437590, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2571.361328125, -2100.596435546875, 183.152008056640625, 4.907143115997314453, 0, 0, -0.635009765625, 0.772504091262817382, 7200, 255, 1, 56421), -- Chair (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+60, 437585, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2576.6455078125, -2138.861328125, 182.4554595947265625, 0.789511024951934814, 0, 0, 0.38458251953125, 0.923090636730194091, 7200, 255, 1, 56421), -- Chair (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+61, 437584, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2579.69970703125, -2135.80712890625, 182.460968017578125, 3.938778877258300781, 0, 0, -0.92160797119140625, 0.388122081756591796, 7200, 255, 1, 56421), -- Chair (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+62, 437587, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2570.110107421875, -2113.664306640625, 182.511260986328125, 3.938778877258300781, 0, 0, -0.92160797119140625, 0.388122081756591796, 7200, 255, 1, 56421), -- Chair (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+63, 437586, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2572.115234375, -2115.52880859375, 182.511260986328125, 3.938778877258300781, 0, 0, -0.92160797119140625, 0.388122081756591796, 7200, 255, 1, 56421), -- Chair (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+64, 437596, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2581.599609375, -2130.701416015625, 182.522064208984375, 5.486405849456787109, 0, 0, -0.38793468475341796, 0.921686887741088867, 7200, 255, 1, 56421), -- Chair (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+65, 429308, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2625.126708984375, -1555.9296875, 162.71282958984375, 4.712392330169677734, 0, 0, -0.70710563659667968, 0.707107901573181152, 7200, 255, 1, 56421), -- Earthen Door (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+66, 437599, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2576.676513671875, -2135.85888671875, 182.4426116943359375, 5.486405849456787109, 0, 0, -0.38793468475341796, 0.921686887741088867, 7200, 255, 1, 56421), -- Chair (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+67, 465939, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2775.646728515625, -2291.6962890625, 266.836578369140625, 1.562069892883300781, 0, 0, 0.704014778137207031, 0.71018528938293457, 7200, 255, 1, 56421), -- Meeting Stone (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+68, 437593, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2585.7880859375, -2114.60546875, 183.172882080078125, 2.423875808715820312, 0, 0, 0.936298370361328125, 0.35120558738708496, 7200, 255, 1, 56421), -- Chair (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+69, 429305, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2745.821044921875, -1624.751708984375, 147.4341583251953125, 3.141592741012573242, 0, 0, -1, 0, 7200, 255, 1, 56421), -- Earthen Door (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+70, 437592, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2583.428466796875, -2111.706787109375, 183.158843994140625, 5.678173065185546875, 0, 0, -0.2979135513305664, 0.954592823982238769, 7200, 255, 1, 56421), -- Chair (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+71, 429304, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2838.474365234375, -1663.0074462890625, 174.160369873046875, 3.141592741012573242, 0, 0, -1, 0, 7200, 255, 1, 56421), -- Earthen Door (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+72, 467461, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2893.125732421875, -2386.2216796875, 266.332916259765625, 5.497788906097412109, 0, 0, -0.38268280029296875, 0.923879802227020263, 7200, 255, 1, 56421), -- Chair (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+73, 465949, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2788.028564453125, -2415.1650390625, 239.3368072509765625, 0, 0, 0, 0, 1, 7200, 255, 1, 56421), -- Bench (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+74, 437595, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2574.4609375, -2090.057861328125, 183.1757354736328125, 2.472295045852661132, 0, 0, 0.944525718688964843, 0.328437477350234985, 7200, 255, 1, 56421), -- Chair (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+75, 429307, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2674.8349609375, -1555.9993896484375, 162.6305084228515625, 4.712392330169677734, 0, 0, -0.70710563659667968, 0.707107901573181152, 7200, 255, 1, 56421), -- Earthen Door (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+76, 467460, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2896.569580078125, -2386.203857421875, 266.31744384765625, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 7200, 255, 1, 56421), -- Chair (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+77, 437594, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2571.792236328125, -2087.022216796875, 183.159515380859375, 5.606167793273925781, 0, 0, -0.33208084106445312, 0.943250954151153564, 7200, 255, 1, 56421), -- Chair (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+78, 429306, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2827.63232421875, -1602.6278076171875, 142.294158935546875, 3.141592741012573242, 0, 0, -1, 0, 7200, 255, 1, 56421), -- Earthen Door (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+79, 467463, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2883.58447265625, -2395.762939453125, 266.332916259765625, 5.497788906097412109, 0, 0, -0.38268280029296875, 0.923879802227020263, 7200, 255, 1, 56421), -- Chair (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+80, 467462, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2884.08984375, -2400.25634765625, 266.447235107421875, 0.785396754741668701, 0, 0, 0.38268280029296875, 0.923879802227020263, 7200, 255, 1, 56421), -- Chair (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+81, 466015, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2727.6796875, -2323.751708984375, 266.648681640625, 3.141592741012573242, 0, 0, -1, 0, 7200, 255, 1, 56421), -- Mailbox (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+82, 467457, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2929.533203125, -2422.629150390625, 266.332916259765625, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 7200, 255, 1, 56421), -- Chair (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+83, 450129, 2648, 14771, 15042, '1,2,8,23', 0, 0, 1866.0504150390625, -1305.8055419921875, -2.82093644142150878, 4.014260292053222656, 0, 0, -0.90630722045898437, 0.422619491815567016, 7200, 255, 1, 56421), -- -Unknown- (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+84, 467456, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2929.498291015625, -2419.13232421875, 266.31744384765625, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 7200, 255, 1, 56421), -- Chair (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+85, 467459, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2915.8876953125, -2432.05419921875, 266.447235107421875, 0.785396754741668701, 0, 0, 0.38268280029296875, 0.923879802227020263, 7200, 255, 1, 56421), -- Chair (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+86, 467458, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2919.964111328125, -2431.871826171875, 266.33282470703125, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 7200, 255, 1, 56421), -- Chair (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+87, 465033, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2825.37890625, -1680.68994140625, 337.0501708984375, 4.712388992309570312, 0.499999523162841796, -0.5, -0.5, 0.500000476837158203, 7200, 255, 0, 56421), -- Wind Wall (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+88, 465907, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2755.7431640625, -2247.4619140625, 266.841644287109375, 3.141592741012573242, 0, 0, -1, 0, 7200, 255, 1, 56421), -- Bench (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+89, 465925, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2771.317626953125, -2393.875, 231.01513671875, 4.712389945983886718, 0, 0, -0.70710659027099609, 0.707106947898864746, 7200, 255, 1, 56421), -- Bench (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+90, 465989, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2733.1416015625, -2445.515625, 231.0150299072265625, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 7200, 255, 1, 56421), -- Bench (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+91, 465034, 2648, 14771, 15042, '1,2,8,23', 0, 0, 2825.37890625, -1547.38232421875, 337.0501708984375, 4.712388992309570312, 0.499999523162841796, -0.5, -0.5, 0.500000476837158203, 7200, 255, 0, 56421), -- Wind Wall (Area: Keepers Terrace - Difficulty: 0) CreateObject1 +(@OGUID+92, 446230, 2648, 14938, 15328, '1,2,8,23', 0, 0, 2656.2001953125, -2439.456787109375, 220.71710205078125, 3.961898565292358398, 0, 0, -0.91705989837646484, 0.398749500513076782, 7200, 255, 1, 56421), -- Booth (Area: The Rookery Landing - Difficulty: Normal) CreateObject1 +(@OGUID+93, 446212, 2648, 14938, 15328, '1,2,8,23', 0, 0, 2669.941650390625, -2448.155517578125, 218.43145751953125, 5.523968696594238281, 0, 0, -0.37055683135986328, 0.928809821605682373, 7200, 255, 1, 56421), -- Chair (Area: The Rookery Landing - Difficulty: Normal) CreateObject1 +(@OGUID+94, 446208, 2648, 14938, 15328, '1,2,8,23', 0, 0, 2676.38232421875, -2453.995849609375, 218.452392578125, 2.871063947677612304, 0, 0, 0.990865707397460937, 0.134852290153503417, 7200, 255, 1, 56421); -- Chair (Area: The Rookery Landing - Difficulty: Normal) CreateObject1 + +-- Template Addon +DELETE FROM `creature_template_addon` WHERE `entry` IN (210930, 217118, 221296, 221384, 218839, 211152, 228238, 211137, 209538, 211151, 211149, 209801, 212786, 209230, 207186, 215967); +INSERT INTO `creature_template_addon` (`entry`, `PathId`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(210930, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '422354'), -- 210930 (Path Helper) - Bot AI Follow Advert +(217118, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 4, ''), -- 217118 (Skardyn Bomber) +(221296, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 4, ''), -- 221296 (Stormrider Cadet) +(221384, 0, 0, 0, 0, 4, 1, 0, 0, 0, 0, 0, 0, '443779'), -- 221384 (Stormrider Cadet) - Permanent Feign Death +(218839, 0, 0, 0, 2, 0, 1, 0, 0, 0, 0, 0, 0, '462125'), -- 218839 (Dark Fragment) - Spawn, Void Chain +(211152, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '424283'), -- 211152 (Path Helper) - Passive +(228238, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '459757'), -- 228238 (Path Helper) - Advert +(211137, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '424283'), -- 211137 (Path Helper) - Passive +(209538, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 4, ''), -- 209538 (Stormrook) - Bot AI Follow Advert, Void Bound +(211151, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '424283'), -- 211151 (Path Helper) - Passive +(211149, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '424283'), -- 211149 (Path Helper) - Passive +(209801, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '422358'), -- 209801 (Quartermaster Koratite) - Bot AI Follow Advert +(212786, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 3, ''), -- 212786 (Voidrider) +(209230, 0, 0, 0, 3, 0, 1, 0, 0, 0, 0, 0, 3, '422356'), -- 209230 (Kyrioss) - Bot AI Follow Advert +(207186, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- 207186 (Unruly Stormrook) +(215967, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 4, ''); -- 215967 (Stormrider Vokmar) + +DELETE FROM `gameobject_template_addon` WHERE `entry` IN (429308 /*Earthen Door*/, 450699 /*450699*/, 465034 /*Wind Wall*/, 450180 /*450180*/, 429306 /*Earthen Door*/, 429307 /*Earthen Door*/, 429305 /*Earthen Door*/, 465033 /*Wind Wall*/, 430493 /*Earthen Door*/, 429304 /*Earthen Door*/, 450650 /*Dormant Rock Giant*/, 466082 /*Dormant Rock Giant*/); +INSERT INTO `gameobject_template_addon` (`entry`, `faction`, `flags`, `WorldEffectID`, `AIAnimKitID`) VALUES +(429308, 1375, 48, 0, 0), -- Earthen Door +(450699, 0, 32, 0, 0), -- 450699 +(465034, 1375, 32, 0, 0), -- Wind Wall +(450180, 0, 32, 0, 0), -- 450180 +(429306, 1375, 48, 0, 0), -- Earthen Door +(429307, 1375, 48, 0, 0), -- Earthen Door +(429305, 1375, 48, 0, 0), -- Earthen Door +(465033, 1375, 32, 0, 0), -- Wind Wall +(430493, 1375, 48, 0, 0), -- Earthen Door +(429304, 1375, 48, 0, 0), -- Earthen Door +(450650, 0, 1048608, 0, 0), -- Dormant Rock Giant +(466082, 0, 1048608, 0, 0); -- Dormant Rock Giant + +-- Template +UPDATE `creature_template` SET `faction`=16, `speed_walk`=2.40000009536743164, `speed_run`=2.571428537368774414, `BaseAttackTime`=2000, `unit_flags`=64, `VehicleId`=8235 WHERE `entry`=209230; -- Kyrioss +UPDATE `creature_template` SET `faction`=35, `BaseAttackTime`=2000, `unit_flags`=33555200, `unit_flags2`=67108864, `unit_flags3`=1090551809, `flags_extra` = 128 WHERE `entry` IN (222922, 222896); -- Path Helper +UPDATE `creature_template` SET `faction`=16, `BaseAttackTime`=2000, `unit_flags`=64, `unit_flags2`=2048 WHERE `entry`=207197; -- Cursed Rookguard +UPDATE `creature_template` SET `faction`=16, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=217118; -- Skardyn Bomber +UPDATE `creature_template` SET `faction`=16, `BaseAttackTime`=2000, `unit_flags`=64, `unit_flags2`=2048 WHERE `entry`=207198; -- Cursed Thunderer +UPDATE `creature_template` SET `faction`=35, `BaseAttackTime`=2000, `unit_flags2`=2048, `unit_flags3`=8388608, `RegenHealth`=0 WHERE `entry`=221296; -- Stormrider Cadet +UPDATE `creature_template` SET `faction`=35, `BaseAttackTime`=2000, `unit_flags`=768, `unit_flags2`=2048, `RegenHealth`=0 WHERE `entry`=221384; -- Stormrider Cadet +UPDATE `creature_template` SET `faction`=16, `npcflag`=16777216, `speed_run`=1, `BaseAttackTime`=2000, `unit_flags`=33555200, `unit_flags2`=16384, `unit_flags3`=1090519041 WHERE `entry`=218839; -- Dark Fragment +UPDATE `creature_template` SET `faction`=16, `BaseAttackTime`=2000, `unit_flags`=33554752, `unit_flags2`=67110912 WHERE `entry`=212714; -- Void rider +UPDATE `creature_template` SET `faction`=35, `BaseAttackTime`=2000, `unit_flags`=33555200, `unit_flags2`=67108864, `unit_flags3`=1090551809, `flags_extra` = 128 WHERE `entry` = 228238; -- Path Helper +UPDATE `creature_template` SET `faction`=35, `speed_run`=1, `BaseAttackTime`=2000, `unit_flags2`=2048, `unit_flags3`=1, `VehicleId`=8316 WHERE `entry`=209538; -- Stormrook +UPDATE `creature_template` SET `faction`=16, `BaseAttackTime`=2000, `unit_flags`=64, `unit_flags2`=2048 WHERE `entry`=209801; -- Quartermaster Koratite +UPDATE `creature_template` SET `faction`=16, `speed_run`=1, `BaseAttackTime`=2000, `unit_flags`=64, `unit_flags2`=2048, `VehicleId`=8277 WHERE `entry`=212786; -- Voidrider +UPDATE `creature_template` SET `faction`=35, `npcflag`=1, `speed_run`=1, `BaseAttackTime`=2000, `unit_flags`=256, `unit_flags2`=2048, `unit_flags3`=16777217 WHERE `entry`=229690; -- Stormrook Beacon +UPDATE `creature_template` SET `faction`=16, `BaseAttackTime`=2000, `unit_flags`=64, `unit_flags2`=2048 WHERE `entry`=207199; -- Cursed Rooktender +UPDATE `creature_template` SET `faction`=14, `speed_walk`=2, `speed_run`=1.428571462631225585, `BaseAttackTime`=2000, `unit_flags`=33554432, `unit_flags2`=2048, `unit_flags3`=25165825, `flags_extra` = 128 WHERE `entry`=221554; -- Lightning Torrent Stalker - North Walk West +UPDATE `creature_template` SET `faction`=14, `speed_walk`=2, `speed_run`=1.428571462631225585, `BaseAttackTime`=2000, `unit_flags`=33554432, `unit_flags2`=2048, `unit_flags3`=25165825, `flags_extra` = 128 WHERE `entry`=221555; -- Lightning Torrent Stalker - South Walk East +UPDATE `creature_template` SET `faction`=14, `speed_walk`=2, `speed_run`=1.428571462631225585, `BaseAttackTime`=2000, `unit_flags`=33554432, `unit_flags2`=2048, `unit_flags3`=25165825, `flags_extra` = 128 WHERE `entry`=221553; -- Lightning Torrent Stalker - North Walk East +UPDATE `creature_template` SET `faction`=14, `speed_walk`=2, `speed_run`=1.428571462631225585, `BaseAttackTime`=2000, `unit_flags`=33554432, `unit_flags2`=2048, `unit_flags3`=25165825, `flags_extra` = 128 WHERE `entry`=221556; -- Lightning Torrent Stalker - South Walk West +UPDATE `creature_template` SET `faction`=16, `speed_run`=1, `BaseAttackTime`=2000, `unit_flags`=64, `unit_flags2`=2048 WHERE `entry`=207186; -- Unruly Stormrook + +-- Difficulty +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2973, `StaticFlags1`=268435456, `VerifiedBuild`=56421 WHERE (`Entry`=212786 AND `DifficultyID`=0); -- 212786 (Voidrider) - CanSwim, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2973, `StaticFlags1`=268435456, `VerifiedBuild`=56421 WHERE (`Entry`=207186 AND `DifficultyID`=0); -- 207186 (Unruly Stormrook) - CanSwim, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2973, `StaticFlags1`=805306368, `VerifiedBuild`=56421 WHERE (`Entry`=209230 AND `DifficultyID`=0); -- 209230 (Kyrioss) - CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2973, `VerifiedBuild`=56421 WHERE (`Entry`=221554 AND `DifficultyID`=0); -- 221554 (Lightning Torrent Stalker - North Walk West) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2973, `VerifiedBuild`=56421 WHERE (`Entry`=221555 AND `DifficultyID`=0); -- 221555 (Lightning Torrent Stalker - South Walk East) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2973, `VerifiedBuild`=56421 WHERE (`Entry`=221553 AND `DifficultyID`=0); -- 221553 (Lightning Torrent Stalker - North Walk East) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2973, `VerifiedBuild`=56421 WHERE (`Entry`=221556 AND `DifficultyID`=0); -- 221556 (Lightning Torrent Stalker - South Walk West) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2702, `StaticFlags1`=805306624, `VerifiedBuild`=56421 WHERE (`Entry`=229416 AND `DifficultyID`=0); -- 229416 (Path Helper) - Sessile, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2702, `StaticFlags1`=805306624, `VerifiedBuild`=56421 WHERE (`Entry`=222922 AND `DifficultyID`=0); -- 222922 (Path Helper) - Sessile, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2973, `StaticFlags1`=268435456, `VerifiedBuild`=56421 WHERE (`Entry`=207199 AND `DifficultyID`=0); -- 207199 (Cursed Rooktender) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2973, `VerifiedBuild`=56421 WHERE (`Entry`=215967 AND `DifficultyID`=0); -- 215967 (Stormrider Vokmar) - +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2973, `StaticFlags1`=268435456, `VerifiedBuild`=56421 WHERE (`Entry`=209801 AND `DifficultyID`=0); -- 209801 (Quartermaster Koratite) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2702, `StaticFlags1`=805306624, `VerifiedBuild`=56421 WHERE (`Entry`=211111 AND `DifficultyID`=0); -- 211111 (Path Helper) - Sessile, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2702, `StaticFlags1`=805306624, `VerifiedBuild`=56421 WHERE (`Entry`=211151 AND `DifficultyID`=0); -- 211151 (Path Helper) - Sessile, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2702, `StaticFlags1`=805306624, `VerifiedBuild`=56421 WHERE (`Entry`=211149 AND `DifficultyID`=0); -- 211149 (Path Helper) - Sessile, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2702, `StaticFlags1`=805306624, `VerifiedBuild`=56421 WHERE (`Entry`=222896 AND `DifficultyID`=0); -- 222896 (Path Helper) - Sessile, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2702, `StaticFlags1`=805306624, `VerifiedBuild`=56421 WHERE (`Entry`=211150 AND `DifficultyID`=0); -- 211150 (Path Helper) - Sessile, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2973, `VerifiedBuild`=56421 WHERE (`Entry`=209538 AND `DifficultyID`=0); -- 209538 (Stormrook) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2702, `StaticFlags1`=805306624, `VerifiedBuild`=56421 WHERE (`Entry`=228238 AND `DifficultyID`=0); -- 228238 (Path Helper) - Sessile, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2551, `StaticFlags1`=536871168, `StaticFlags3`=33554432, `VerifiedBuild`=56421 WHERE (`Entry`=218839 AND `DifficultyID`=0); -- 218839 (Dark Fragment) - Sessile, Floating - CannotTurn +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2973, `StaticFlags1`=268435456, `VerifiedBuild`=56421 WHERE (`Entry`=221384 AND `DifficultyID`=0); -- 221384 (Stormrider Cadet) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2973, `StaticFlags1`=268435456, `VerifiedBuild`=56421 WHERE (`Entry`=221296 AND `DifficultyID`=0); -- 221296 (Stormrider Cadet) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2973, `StaticFlags1`=268435456, `VerifiedBuild`=56421 WHERE (`Entry`=207198 AND `DifficultyID`=0); -- 207198 (Cursed Thunderer) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2973, `StaticFlags1`=805306624, `VerifiedBuild`=56421 WHERE (`Entry`=212714 AND `DifficultyID`=0); -- 212714 (Void rider) - Sessile, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2973, `VerifiedBuild`=56421 WHERE (`Entry`=217118 AND `DifficultyID`=0); -- 217118 (Skardyn Bomber) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2973, `StaticFlags1`=268435456, `VerifiedBuild`=56421 WHERE (`Entry`=207197 AND `DifficultyID`=0); -- 207197 (Cursed Rookguard) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2973, `StaticFlags1`=268435456, `StaticFlags3`=33554432, `VerifiedBuild`=56421 WHERE (`Entry`=229690 AND `DifficultyID`=0); -- 229690 (Stormrook Beacon) - CanSwim - CannotTurn + +-- Static Flags override +DELETE FROM `creature_static_flags_override` WHERE `SpawnId` IN (@CGUID+51, @CGUID+63) AND `DifficultyId`=0; +INSERT INTO `creature_static_flags_override` (`SpawnId`, `DifficultyId`, `StaticFlags1`, `StaticFlags2`, `StaticFlags3`, `StaticFlags4`, `StaticFlags5`, `StaticFlags6`, `StaticFlags7`, `StaticFlags8`) VALUES +(@CGUID+51, 0, 805306368, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(@CGUID+63, 0, 805306368, NULL, NULL, NULL, NULL, NULL, NULL, NULL); + +-- Areatrigger +DELETE FROM `areatrigger_template` WHERE `Id` BETWEEN @ATID+0 AND @ATID+1; +INSERT INTO `areatrigger_template` (`Id`, `IsCustom`, `Flags`, `ActionSetId`, `ActionSetFlags`, `VerifiedBuild`) VALUES +(@ATID+0, 1, 1, 0, 0, 0), +(@ATID+1, 1, 1, 0, 0, 0); + +DELETE FROM `areatrigger_template_actions` WHERE `AreaTriggerId` BETWEEN @ATID+0 AND @ATID+1; +INSERT INTO `areatrigger_template_actions` (`AreaTriggerId`, `IsCustom`, `ActionType`, `ActionParam`, `TargetType`) VALUES +(@ATID+0, 1, 2, @WORLDSAFELOC+0, 5), +(@ATID+1, 1, 2, @WORLDSAFELOC+1, 5); + +DELETE FROM `areatrigger_create_properties` WHERE `Id` BETWEEN @ATCP+0 AND @ATCP+1; +INSERT INTO `areatrigger_create_properties` (`Id`, `IsCustom`, `AreaTriggerId`, `IsAreatriggerCustom`, `Flags`, `MoveCurveId`, `ScaleCurveId`, `MorphCurveId`, `FacingCurveId`, `AnimId`, `AnimKitId`, `DecalPropertiesId`, `SpellForVisuals`, `TimeToTarget`, `TimeToTargetScale`, `Shape`, `ShapeData0`, `ShapeData1`, `ShapeData2`, `ShapeData3`, `ShapeData4`, `ShapeData5`, `ShapeData6`, `ShapeData7`, `ScriptName`, `VerifiedBuild`) VALUES +(@ATCP+0, 1, @ATID+0, 1, 0, 0, 0, 0, 0, -1, 0, 0, NULL, 0, 0, 1, 6, 12, 20, 6, 12, 20, 0, 0, '', 0), +(@ATCP+1, 1, @ATID+1, 1, 0, 0, 0, 0, 0, -1, 0, 0, NULL, 0, 0, 1, 4, 12, 50, 4, 12, 50, 0, 0, '', 0); + +DELETE FROM `areatrigger` WHERE `SpawnId` BETWEEN @ATSPAWNID+0 AND @ATSPAWNID+1; +INSERT INTO `areatrigger` (`SpawnId`, `AreaTriggerCreatePropertiesId`, `IsCustom`, `MapId`, `SpawnDifficulties`, `PosX`, `PosY`, `PosZ`, `Orientation`, `PhaseUseFlags`, `PhaseId`, `PhaseGroup`, `ScriptName`, `Comment`, `VerifiedBuild`) VALUES +(@ATSPAWNID+0, @ATCP+0, 1, 2648, '1,2,23,8', 2800.09, -2189.74, 266.837, 4.720446, 0, 0, 0, '', '11.x Dungeon - The Rookery - Exit', 0), +(@ATSPAWNID+1, @ATCP+1, 1, 2552, '0', 2800.05, -2190.16, 266.836, 1.570882, 0, 0, 0, '', '11.x Dungeon - The Rookery - Entrance', 0); + +DELETE FROM `world_safe_locs` WHERE `ID` BETWEEN @WORLDSAFELOC+0 AND @WORLDSAFELOC+1; +INSERT INTO `world_safe_locs` (`ID`, `MapID`, `LocX`, `LocY`, `LocZ`, `Facing`, `TransportSpawnId`, `Comment`) VALUES +(@WORLDSAFELOC+0, 2552, 2800.15, -2215.06, 267.331, 4.729947/(2 * PI() / 360), NULL, '11.x Dungeon - The Rookery - Exit'), +(@WORLDSAFELOC+1, 2648, 2799.96, -2174.89, 266.837, 1.586368/(2 * PI() / 360), NULL, '11.x Dungeon - The Rookery - Entrance'); + +-- Boss Areatrigger +DELETE FROM `areatrigger_template` WHERE (`IsCustom`=0 AND `Id` = 33509); +INSERT INTO `areatrigger_template` (`Id`, `IsCustom`, `Flags`, `VerifiedBuild`) VALUES +(33509, 0, 0, 56421); + +DELETE FROM `areatrigger_create_properties` WHERE (`Id`=@ATCP+2 AND `IsCustom`=1); +INSERT INTO `areatrigger_create_properties` (`Id`, `IsCustom`, `AreaTriggerId`, `IsAreatriggerCustom`, `Flags`, `MoveCurveId`, `ScaleCurveId`, `MorphCurveId`, `FacingCurveId`, `AnimId`, `AnimKitId`, `DecalPropertiesId`, `SpellForVisuals`, `TimeToTarget`, `TimeToTargetScale`, `Shape`, `ShapeData0`, `ShapeData1`, `ShapeData2`, `ShapeData3`, `ShapeData4`, `ShapeData5`, `ShapeData6`, `ShapeData7`, `VerifiedBuild`) VALUES +(@ATCP+2, 1, 33509, 0, 0, 0, 0, 0, 0, -1, 0, 0, 420610, 0, 0, 4, 45, 45, 160, 160, 160, 160, 0, 0, 56421); + +DELETE FROM `areatrigger` WHERE `SpawnId`=@ATSPAWNID+2; +INSERT INTO `areatrigger` (`SpawnId`, `AreaTriggerCreatePropertiesId`, `IsCustom`, `MapId`, `SpawnDifficulties`, `PosX`, `PosY`, `PosZ`, `Orientation`, `PhaseUseFlags`, `PhaseId`, `PhaseGroup`, `ScriptName`, `Comment`, `VerifiedBuild`) VALUES +(@ATSPAWNID+2, @ATCP+2, 1, 2648, '1,2,23,8', 2798.88, -1612.43, 324.503, 0, 0, 0, 0, '', '', 56421); + +-- Conditions +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry` IN (438232, 443690, 444512); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ConditionStringValue1`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(13, 1, 438232, 0, 0, 51, 0, 5, 209538, 0, '', 0, 0, 0, '', 'Spell \'Void Chain\' can only hit \'Stormrook\''), +(13, 1, 443690, 0, 0, 51, 0, 5, 218839, 0, '', 0, 0, 0, '', 'Spell \'Void Beam - Cosmetic [DNT]\' can only hit \'Dark Fragment\''), +(13, 1, 444512, 0, 0, 51, 0, 5, 221296, 0, '', 0, 0, 0, '', 'Spell \'Void Beam - Cosmetic [DNT]\' can only hit \'Stormrider Cadet\''); + +-- Vehicle +DELETE FROM `vehicle_template_accessory` WHERE (`seat_id`=0 AND `entry` IN (209230,212786)); +INSERT INTO `vehicle_template_accessory` (`entry`, `accessory_entry`, `seat_id`, `minion`, `description`, `summontype`, `summontimer`) VALUES +(209230, 218708, 0, 1, 'Kyrioss - Stormguard Gorren', 8, 0), -- Kyrioss - Stormguard Gorren +(212786, 212714, 0, 1, 'Voidrider - Void rider', 8, 0); -- Voidrider - Void rider + +DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN (209230,212786) AND `spell_id`=46598; +INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `cast_flags`, `user_type`) VALUES +(209230, 46598, 0, 0), +(212786, 46598, 0, 0); + +-- Cursed Thunderer smart ai +SET @ENTRY := 207198; +UPDATE `creature_template` SET `AIName` = 'SmartAI', `ScriptName` = '' WHERE `entry` = @ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type` = 0 AND `entryOrGuid` = @ENTRY; +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`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `action_param7`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`, `Difficulties`) VALUES +(@ENTRY, 0, 0, 0, 63, 0, 100, 0, 0, 0, 0, 0, 0, 11, 443690, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On just created - Self: Cast spell 443690 on Self', ''), +(@ENTRY, 0, 1, 0, 63, 0, 100, 0, 0, 0, 0, 0, 0, 11, 444512, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On just created - Self: Cast spell 444512 on Self', ''); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 22 AND `SourceEntry` = 207198 AND `SourceId` = 0; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ConditionStringValue1`, `NegativeCondition`, `Comment`) VALUES +(22, 1, 207198, 0, 0, 58, 1, 0, 0, 0, 'cursed_thunderer_dark_fragment', 0, 'Scripted creature has StringId \'cursed_thunderer_dark_fragment\''), +(22, 2, 207198, 0, 0, 58, 1, 0, 0, 0, 'cursed_thunderer_stormrider_cadet', 0, 'Scripted creature has StringId \'cursed_thunderer_stormrider_cadet\''); + +-- Dark Fragment smart ai +SET @ENTRY := 218839; +UPDATE `creature_template` SET `AIName` = 'SmartAI', `ScriptName` = '' WHERE `entry` = @ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type` = 0 AND `entryOrGuid` = @ENTRY; +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`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `action_param7`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`, `Difficulties`) VALUES +(@ENTRY, 0, 0, 0, 1, 0, 100, 1, 1000, 1000, 0, 0, 0, 11, 438232, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Time = 1 seconds (OOC) - Self: Cast spell 438232 on Self', ''); + +-- Quartermaster Koratite smart ai +SET @ENTRY := 209801; +UPDATE `creature_template` SET `AIName` = 'SmartAI', `ScriptName` = '' WHERE `entry` = @ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type` = 0 AND `entryOrGuid` = @ENTRY; +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`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `action_param7`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`, `Difficulties`) VALUES +(@ENTRY, 0, 0, 0, 34, 0, 100, 0, 2, 0, 0, 0, 0, 10, 1, 5, 273, 456, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On movement of type WAYPOINT_MOTION_TYPE inform, point 0 - Self: Play random emote: 1, 5, 273, 456,', ''), +(@ENTRY, 0, 1, 0, 34, 0, 100, 0, 2, 1, 0, 0, 0, 10, 1, 5, 273, 456, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On movement of type WAYPOINT_MOTION_TYPE inform, point 1 - Self: Play random emote: 1, 5, 273, 456,', ''); + +-- Path for Quartermaster Koratite +SET @MOVERGUID := @CGUID+49; +SET @ENTRY := 209801; +SET @PATHOFFSET := 0; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0, NULL, 'Quartermaster Koratite - Scripted Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 2816.35, -2091.56, 249.4872, 2.58783, 3087), +(@PATH, 1, 2787.62, -2093.3, 249.4886, 0.84124, 3080); + +UPDATE `creature` SET `position_x`= 2816.35, `position_y`= -2091.56, `position_z`= 249.4872, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`= @MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); |