DB/Misc: Steel Gate area

From https://github.com/cmangos/wotlk-db/commit/17d717a70492840f75ba60abe7713b46a583a8b6 by Grz3s

(cherry picked from commit c8278cddeb49bd3cf6beeb4acbca1258c07cf131)

1 files changed, 269 insertions, 0 deletions

diff --git a/sql/updates/world/master/2021_12_16_25_world_2019_07_21_02_world.sql b/sql/updates/world/master/2021_12_16_25_world_2019_07_21_02_world.sql
new file mode 100644
index 00000000000..53656d1bdb3
--- /dev/null
+++ b/sql/updates/world/master/2021_12_16_25_world_2019_07_21_02_world.sql
@@ -0,0 +1,269 @@
+-- Steel Gate - Howling Fjord
+-- Engineer Feknut 24227
+DELETE FROM `creature_addon` WHERE `guid` IN (111278);
+INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes1`, `bytes2`, `auras`) VALUES
+(111278,1112780,0,1,"");
+UPDATE `creature` SET `spawndist` = 0, `MovementType` = 2 WHERE `guid` = 111278;
+DELETE FROM `waypoint_data` WHERE `id` IN (1112780);
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `move_type`, `orientation`, `action_chance`) VALUES
+(1112780,1,1956.69,-3227.61,153.658,1000,0,5.08746,100),
+(1112780,2,1954.59,-3223.99,153.706,0,0,1.63485,100),
+(1112780,3,1956.9,-3217.39,153.708,0,0,0.967256,100),
+(1112780,4,1962.33,-3214.47,153.659,1000,0,0.53136,100),
+(1112780,5,1957.11,-3217.13,153.702,0,0,4.13398,100),
+(1112780,6,1954.55,-3223.45,153.712,0,0,4.39552,100);
+-- Westguard Rifleman 24197
+DELETE FROM `creature_template_addon` WHERE `entry` = 24197;
+INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES 
+(24197,0,0,2,214,"");
+-- Lead Archaeologist Malzie
+-- in 3.x.x can also start q.5387 'Portents of Uldum'
+DELETE FROM `creature_queststarter` WHERE `quest` = 2963 AND `id`=24473;
+INSERT INTO `creature_queststarter` (`id`, `quest`) VALUES
+(24473,2963);
+-- Steel Gate Excavator 24398
+-- missing spawns
+DELETE FROM `creature` WHERE `guid` IN (10200, 81641, 111222, 111229, 111230, 111260, 111261, 111262, 111263, 111266, 111267, 111277, 111300, 111314);
+INSERT INTO `creature` (`guid`, `id`, `map`, `spawnDifficulties`, `phaseId`,  `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES
+(10200, 24398,571,'0',0,1,2104.12,-3284.06,82.42,5.934119,300,0,0),         -- 141282
+(81641, 24398,571,'0',0,1,2104.97,-3244.748,83.32822,6.213372,300,0,0),     -- 141283
+(111222,24398,571,'0',0,1,2098.949,-3309.101,82.50323,0.5585054,300,0,0),   -- 141284
+(111229,24398,571,'0',0,1,2099.512,-3303.403,82.50323,0.03490658,300,0,0),  -- 141285
+(111230,24398,571,'0',0,1,2090.313,-3328.637,100.0479,6.021386,300,0,0),    -- 141286
+(111260,24398,571,'0',0,1,2092.307,-3321.509,100.0998,5.759586,300,0,0),    -- 141287
+(111261,24398,571,'0',0,1,2076.246,-3299.2,82.5799,4.310963,300,0,0),       -- 141288
+(111262,24398,571,'0',0,1,2085.542,-3298.925,82.50323,4.869469,300,0,0),    -- 141289
+(111263,24398,571,'0',0,1,2081.665,-3254.051,58.29612,5.323254,300,0,0),    -- 141290
+(111266,24398,571,'0',0,1,2059.83,-3291.766,78.55433,3.717551,300,0,0),     -- 141291
+(111267,24398,571,'0',0,1,2008.042,-3340.932,123.5842,4.520403,300,0,0),    -- 141292
+(111277,24398,571,'0',0,1,1992.135,-3267.33,135.0446,5.689773,300,0,0),     -- 141293
+(111300,24398,571,'0',0,1,1980.234,-3297.31,110.0423,3.525565,300,0,0),     -- 141294
+(111314,24398,571,'0',0,1,2036.64,-3267.56,81.8777,4.66247,300,0,0);        -- 141295
+UPDATE `creature` SET `position_x` = 2038.469971, `position_y` = -3214.354980, `position_z` = 59.843475, `orientation` = 1.850049, `spawndist` = 0, `MovementType` = 0 WHERE `guid` = 102775;
+UPDATE `creature` SET `position_x` = 2028.204956, `position_y` = -3240.998047, `position_z` = 67.813362, `orientation` = 3.543018, `spawndist` = 0, `MovementType` = 0 WHERE `guid` = 102797;
+UPDATE `creature` SET `position_x` = 2036.865967, `position_y` = -3241.322998, `position_z` = 67.813652, `orientation` = 0.733038, `spawndist` = 0, `MovementType` = 0 WHERE `guid` = 102795;
+UPDATE `creature` SET `position_x` = 2088.439697, `position_y` = -3202.135986, `position_z` = 147.61650, `orientation` = 5.561528, `spawndist` = 0, `MovementType` = 0 WHERE `guid` = 102799;
+DELETE FROM `creature_addon` WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` = 24398);
+DELETE FROM `creature_template_addon` WHERE `entry` = 24398;
+INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES 
+(24398,0,0,1,233,"");
+-- individual addons for 2 spawns
+DELETE FROM `creature_addon` WHERE `guid` IN (102799,111277,111314);
+INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES 
+(102799,1027990,0,1,0,""),
+(111277,0,0,1,0,""),
+(111314,0,0,1,69,"");
+-- waypoints
+UPDATE `creature` SET `spawndist` = 0, `MovementType` = 2 WHERE `guid` IN (102799);
+DELETE FROM `waypoint_data` WHERE `id` IN (1027990);
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `action`, `move_type`, `orientation`, `action_chance`) VALUES
+-- #102799
+(1027990,1,2088.439,-3202.136,147.61650,2000,0,0,5.561528,100),
+(1027990,2,2092.02,-3205.23,148.374,0,0,0,5.25522,100),
+(1027990,3,2093.2,-3208.12,147.216,2000,0,0,0.792189,100),
+(1027990,4,2093.55,-3214.07,136.595,0,0,0,0.792189,100),
+(1027990,5,2088.3,-3218.37,97.5587,2000,0,0,1.5124,100),
+(1027990,6,2085.46,-3214.51,96.5808,0,0,0,2.34257,100),
+(1027990,7,2079.99,-3208.92,91.754,2000,0,0,0.60762,100),
+(1027990,8,2082.48,-3207.11,109.552,0,0,0,0.74428,100),
+(1027990,9,2083.79,-3204.8,125.653,0,0,0,0.775696,100),
+(1027990,10,2086.77,-3204.47,142.163,0,0,0,0.559716,100);
+SET @ENTRY := 24398;
+UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (-102799,-102808,-111277,24398) 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`,`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
+(-111277,0,0,0,1,0,100,0,45000,55000,45000,55000,11,43754,0,0,0,0,0,10,102808,24398,0,0,0,0,0,"Steel Gate Excavator - Out of Combat - Cast 'throw dynamit'"),
+(-111277,0,1,0,0,0,100,0,1000,2000,1000,3000,11,6660,64,0,0,0,0,2,0,0,0,0,0,0,0,"Steel Gate Excavator - In combat - cast shot'"),
+(-102808,0,0,0,8,0,100,0,43754,0,10000,10000,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Steel Gate Excavator - On spell hit - say text'"),
+(-102808,0,1,0,0,0,100,0,1000,2000,1000,3000,11,6660,64,0,0,0,0,2,0,0,0,0,0,0,0,"Steel Gate Excavator - In combat - cast shot'"),
+(-102799,0,0,0,25,0,100,0,0,0,0,0,11,43834,0,0,0,0,0,19,23033,0,0,0,0,0,0,"Steel Gate Excavator - On reset - cast rope'"),
+(-102799,0,1,0,1,0,100,0,4000,4000,4000,7000,11,43754,0,0,0,0,0,1,0,0,0,0,0,0,0,"Steel Gate Excavator - Out of Combat - cast dynamit'"),
+(-102799,0,2,0,0,0,100,0,1000,2000,1000,3000,11,6660,64,0,0,0,0,2,0,0,0,0,0,0,0,"Steel Gate Excavator - In combat - cast shot'"),
+(24398,0,0,0,0,0,100,0,1000,2000,1000,3000,11,6660,64,0,0,0,0,2,0,0,0,0,0,0,0,"Steel Gate Excavator - In combat - cast shot'");
+DELETE FROM `creature_text` WHERE `CreatureID`=24398;
+INSERT INTO `creature_text` (`CreatureID`,`GroupID`,`ID`,`Text`,`Type`,`Language`,`Probability`,`Emote`,`Duration`,`Sound`, `BroadcastTextId`, `comment`) VALUES
+(24398, 0, 0, 'Yeouch! Watch where you throw that stuff!', 14, 7, 100, 0, 0, 0, 23370, 'Steel Gate Excavator');
+-- Steel Gate Archaeologist 24400
+-- missing spawns added -- Free WoTLKDB guids reused
+DELETE FROM `creature` WHERE `guid` IN (111315, 111317, 111318, 111319);
+INSERT INTO `creature` (`guid`, `id`, `map`, `spawnDifficulties`, `phaseId`,  `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES
+(111315,24400,571,'0',0,1,2099.83,-3292.81,94.2685,4.66242,300,0,0), -- 141296
+(111317,24400,571,'0',0,1,2095.28,-3280.96,100.9218,0.3839,300,0,0), -- 141297
+(111318,24400,571,'0',0,1,2029.32,-3267.26,81.9263,0.04347,300,0,0), -- 141298
+(111319,24400,571,'0',0,1,2007.54,-3298.29,98.36,4.65436,300,0,0);   -- 141299
+UPDATE `creature` SET `position_x` = 2022.290039, `position_y` = -3224.247070, `position_z` = 74.995354, `orientation` = 1.623156, `spawndist` = 0, `MovementType` = 0 WHERE `guid` = 103169;
+DELETE FROM `creature_addon` WHERE `guid` IN (103169,111315,103161,103170,111317,111319);
+INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
+(103169,0,0,1,69,""),
+(111315,1113150,0,1,69,""),
+(103161,1031610,0,1,0,""),
+(103170,1031700,0,1,0,""),
+(111317,1113170,0,1,0,""),
+(111319,1113190,0,1,0,"");
+-- waypoints
+UPDATE `creature` SET `spawndist` = 0, `MovementType` = 2 WHERE `guid` IN (111315,103161,103170,111317,111319);
+DELETE FROM `waypoint_data` WHERE `id` IN (1113150,1031610,1031700,1113170,1113190);
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `action`, `orientation`, `move_type`, `action_chance`) VALUES
+-- #111315
+(1113150,1,2099.47,-3297.85,94.2646,0,0,4.72132,0,100),
+(1113150,2,2099.31,-3303.86,98.0294,0,0,4.69384,0,100),
+(1113150,3,2099.04,-3309.97,101.932,0,0,4.67027,0,100),
+(1113150,4,2092.52,-3310.6,101.944,5000,1078,4.07337,0,100),
+(1113150,5,2100.86,-3310.02,101.931,0,0,1.48155,0,100),
+(1113150,6,2101.51,-3298.2,94.2991,0,0,1.49333,0,100),
+(1113150,7,2102.21,-3288.87,94.2991,0,0,1.46584,0,100),
+(1113150,8,2102.42,-3280.19,88.5465,0,0,1.56009,0,100),
+(1113150,9,2103.18,-3272.71,88.5465,0,0,2.31643,0,100),
+(1113150,10,2097.19,-3271.69,89.161,5000,50,3.03271,0,100),
+(1113150,11,2095.74,-3277.43,88.5465,5000,1078,4.69775,0,100),
+(1113150,12,2097.42,-3276.47,88.5465,0,0,0.374916,0,100),
+(1113150,13,2100.02,-3277.85,88.5465,0,0,5.04891,0,100),
+(1113150,14,2100.07,-3280.19,88.712,0,0,4.68292,0,100),
+(1113150,15,2099.76,-3288.49,94.2646,0,0,4.66328,0,100),
+(1113150,16,2099.82,-3292.42,94.2672,0,0,4.68684,0,100),
+-- 103161
+(1031610,1,2034.88,-3221.48,60.926,0,0,4.93695,0,100),
+(1031610,2,2036.7,-3226.98,64.5278,0,0,5.08319,0,100),
+(1031610,3,2038.3,-3231.62,67.7058,0,0,5.14209,0,100),
+(1031610,4,2040.14,-3240.92,67.8137,5000,1078,4.42032,0,100),
+(1031610,5,2038.39,-3232,67.8139,0,0,1.82547,0,100),
+(1031610,6,2034.94,-3221.95,61.066,0,0,1.68017,0,100),
+(1031610,7,2041.35,-3216.55,60.0549,0,0,0.647368,0,100),
+(1031610,8,2047.17,-3214.4,60.8103,0,0,0.0993457,0,100),
+(1031610,9,2053.65,-3214,61.6133,0,0,5.78042,0,100),
+(1031610,10,2058.86,-3221.44,65.3129,0,0,5.34498,0,100),
+(1031610,11,2065.34,-3229.19,69.871,0,0,5.4769,0,100),
+(1031610,12,2074.73,-3238.66,75.8445,0,0,5.51224,0,100),
+(1031610,13,2086.32,-3249.59,83.04,0,0,5.61041,0,100),
+(1031610,14,2092.98,-3252.53,83.3759,0,0,5.86959,0,100),
+(1031610,15,2094.65,-3255.16,82.4199,0,0,4.76053,0,100),
+(1031610,16,2094.05,-3256.96,82.4199,0,0,4.3859,0,100),
+(1031610,17,2087.68,-3264.09,82.4199,0,0,4.29401,0,100),
+(1031610,18,2086.7,-3269.7,82.4199,0,0,4.6867,0,100),
+(1031610,19,2086.56,-3275.95,82.4188,0,0,4.41181,0,100),
+(1031610,20,2082.05,-3285.79,82.3876,0,0,4.29793,0,100),
+(1031610,21,2078.81,-3295.5,82.4206,0,0,4.71419,0,100),
+(1031610,22,2086.5,-3286.6,82.4206,0,0,0.97569,0,100),
+(1031610,23,2090.77,-3267.14,82.4206,0,0,1.32912,0,100),
+(1031610,24,2097.78,-3255.81,82.4206,0,0,1.02104,0,100),
+(1031610,25,2098.65,-3254.19,83.3131,0,0,1.36898,0,100),
+(1031610,26,2098.66,-3249.58,83.2708,0,0,1.95647,0,100),
+(1031610,27,2094.79,-3245.91,83.2692,0,0,2.63583,0,100),
+(1031610,28,2090.06,-3243.67,82.4822,0,0,2.64369,0,100),
+(1031610,29,2082.45,-3236.93,77.7866,0,0,2.38843,0,100),
+(1031610,30,2073.3,-3228.06,71.9082,0,0,2.3256,0,100),
+(1031610,31,2063.71,-3217.03,65.3118,0,0,2.31382,0,100),
+(1031610,32,2058.36,-3211.16,61.8037,0,0,2.30989,0,100),
+(1031610,33,2055.02,-3208.81,62.1954,0,0,3.11179,0,100),
+(1031610,34,2049.27,-3210.3,61.3492,0,0,3.55554,0,100),
+(1031610,35,2045.61,-3213.91,60.4871,0,0,3.88148,0,100),
+-- 103170
+(1031700,1,1990.61,-3264.58,90.2218,0,0,6.13234,0,100),
+(1031700,2,1998.67,-3266.03,86.425,0,0,0.0180159,0,100),
+(1031700,3,2007.08,-3265.01,82.2729,0,0,0.104347,0,100),
+(1031700,4,2013.07,-3264.52,81.9951,0,0,0.0622537,0,100),
+(1031700,5,2023.46,-3264.67,81.9936,0,0,6.24177,0,100),
+(1031700,6,2038.69,-3265.67,82.0066,0,0,6.13241,0,100),
+(1031700,7,2046.75,-3266.53,84.7738,0,0,6.21881,0,100),
+(1031700,8,2058.11,-3266.74,89.803,0,0,6.27306,0,100),
+(1031700,9,2062.41,-3269.18,90.2362,0,0,4.78081,0,100),
+(1031700,10,2061.98,-3278.35,94.3574,0,0,4.82008,0,100),
+(1031700,11,2062.99,-3287.62,98.9268,0,0,4.77704,0,100),
+(1031700,12,2063.03,-3296.12,98.9259,0,0,6.15541,0,100),
+(1031700,13,2072.44,-3297.16,99.3635,0,0,0.0450122,0,100),
+(1031700,14,2079.59,-3297.19,100.04,0,0,6.23788,0,100),
+(1031700,15,2088.53,-3296.54,100.968,0,0,0.131406,0,100),
+(1031700,16,2093.89,-3295.45,101.35,0,0,1.51596,0,100),
+(1031700,17,2094.93,-3279.18,100.787,5000,0,1.50811,0,100),
+(1031700,18,2092.76,-3289.91,101.193,0,0,3.33023,0,100),
+(1031700,19,2084.51,-3290.25,100.526,0,0,3.14174,0,100),
+(1031700,20,2069.18,-3290.03,99.2225,0,0,1.5945,0,100),
+(1031700,21,2069.21,-3287.71,99.2271,0,0,1.53167,0,100),
+(1031700,22,2069.21,-3269.16,90.2411,0,0,1.64555,0,100),
+(1031700,23,2070.26,-3266.28,89.9244,0,0,2.29743,0,100),
+(1031700,24,2064.92,-3260.41,89.8614,0,0,3.14959,0,100),
+(1031700,25,2058.48,-3260.53,89.7806,0,0,3.1653,0,100),
+(1031700,26,2044.05,-3259.11,83.2618,0,0,3.04356,0,100),
+(1031700,27,2038.09,-3258.7,82.0189,0,0,3.09461,0,100),
+(1031700,28,2036.22,-3261.32,81.8782,0,0,3.19671,0,100),
+(1031700,29,2031.6,-3261.91,81.9211,0,0,3.15744,0,100),
+(1031700,30,2023.03,-3258.37,81.9894,0,0,2.98858,0,100),
+(1031700,31,2009.72,-3258.07,82.0524,0,0,3.12285,0,100),
+(1031700,32,2000.53,-3258.25,85.5968,0,0,3.18176,0,100),
+(1031700,33,1995.95,-3258.43,87.8547,0,0,4.5083,0,100),
+(1031700,34,1994.17,-3261.37,88.4903,0,0,3.82893,0,100),
+(1031700,35,1992.04,-3262.14,89.4742,0,0,3.09458,0,100),
+(1031700,36,1985.7,-3260.74,90.2983,5000,1078,2.83147,0,100),
+-- #111317
+(1113170,1,2039.21,-3266.84,82.1112,0,0,6.2599,0,100),
+(1113170,2,2047.7,-3267.73,85.3028,0,0,6.19707,0,100),
+(1113170,3,2058.32,-3267.68,89.8097,0,0,0.00813388,0,100),
+(1113170,4,2068.78,-3265.22,89.9119,10000,0,0.40476,0,100),
+(1113170,5,2058.66,-3260.52,89.7829,0,0,3.09475,0,100),
+(1113170,6,2049.14,-3260.26,85.6893,0,0,3.13402,0,100),
+(1113170,7,2040.92,-3260.42,82.2698,0,0,3.05548,0,100),
+(1113170,8,2037.47,-3259.99,81.9481,10000,0,2.78072,0,100),
+(1113170,9,2029.74,-3263.37,81.9415,0,0,3.46401,0,100),
+(1113170,10,2015.95,-3267.57,81.9616,10000,0,3.38074,0,100),
+(1113170,11,2028.55,-3267.3,81.9373,0,0,0.0663566,0,100),
+-- #111319
+(1113190,1,2006.75,-3305.48,99.8282,0,0,4.59938,0,100),
+(1113190,2,2005.31,-3312.08,101.45,0,0,4.28129,0,100),
+(1113190,3,1998.97,-3320.71,100.394,5000,1078,4.77452,0,100),
+(1113190,4,2005.68,-3314.45,101.164,5000,1078,0.0244323,0,100),
+(1113190,5,2009.04,-3300.02,98.4657,0,0,1.55596,0,100),
+(1113190,6,2006.13,-3289.24,97.1838,0,0,1.96437,0,100),
+(1113190,7,2000.52,-3277.6,92.6132,0,0,2.0391,0,100),
+(1113190,8,1994.25,-3270.49,89.612,0,0,2.45143,0,100),
+(1113190,9,1988.77,-3268.44,90.1637,0,0,2.73417,0,100),
+(1113190,10,1987.51,-3262.49,90.264,0,0,2.74203,0,100),
+(1113190,11,1983.62,-3262.39,90.269,0,0,3.15043,0,100),
+(1113190,12,1981.84,-3261.74,90.6345,0,0,2.80486,0,100),
+(1113190,13,1984.58,-3262.71,90.2645,0,0,5.95431,0,100),
+(1113190,14,1984.31,-3264.53,90.2305,5000,1078,4.37959,0,100),
+(1113190,15,1984.31,-3264.53,90.2305,10000,0,4.37959,0,100),
+(1113190,16,1992.61,-3271.15,89.6702,0,0,5.69906,0,100),
+(1113190,17,1998.98,-3277.69,92.645,0,0,5.41239,0,100),
+(1113190,18,2002.13,-3282.93,94.7443,0,0,5.22389,0,100),
+(1113190,19,2005.62,-3288.76,97.655,0,0,5.18855,0,100),
+(1113190,20,2007.42,-3297.69,98.2873,0,0,4.87832,0,100);
+-- Steel Gate Flying Machine 24418
+DELETE FROM `creature_template_movement` WHERE `CreatureId` IN (24418);
+INSERT INTO `creature_template_movement` (`CreatureId`, `Ground`, `Swim`, `Flight`, `Rooted`) VALUES
+(24418, 1, 0, 0, 0);
+DELETE FROM `creature_addon` WHERE `guid` =104704;
+DELETE FROM `creature_template_addon` WHERE `entry` = 24418;
+INSERT INTO `creature_template_addon` (`entry`, `path_id`, `bytes1`, `bytes2`, `emote`, `auras`)  VALUES 
+(24418,0,0,0,0,'43775 43889');
+UPDATE creature SET position_z = 134.825241, spawndist = 0, MovementType = 0 WHERE guid = 104704;
+UPDATE `creature` SET `id` = 24526 WHERE `id` = 15214 AND `guid` IN (105997,105998);
+DELETE FROM `creature_addon` WHERE `guid` IN (105997, 105998);
+DELETE FROM `creature_template_addon` WHERE `entry`=24526;
+INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
+(24526, 0, 0, 65536, 1, 0, '43890 43891'); -- 24526 - 43890, 43891
+-- Gjalerbron Gargoyle 24440
+UPDATE `creature` SET `position_x` = 2040.79, `position_y` = -3293.16, `position_z` = 191.582, `orientation` = 4.32726 WHERE `guid` =107082  AND `id`=24440;
+UPDATE `creature` SET `position_x` = 2063.86, `position_y` = -3284.81, `position_z` = 172.590, `orientation` = 4.20218 WHERE `guid` =107083  AND `id`=24440;
+UPDATE `creature` SET `position_x` = 2088.80, `position_y` = -3295.57, `position_z` = 159.146, `orientation` = 5.59627 WHERE `guid` =107084  AND `id`=24440;
+UPDATE `creature` SET `position_x` = 2038.98, `position_y` = -3240.64, `position_z` = 168.500, `orientation` = 1.44151 WHERE `guid` =107085  AND `id`=24440;
+UPDATE `creature` SET `position_x` = 2048.58, `position_y` = -3246.85, `position_z` = 154.027, `orientation` = 3.94694 WHERE `guid` =107086  AND `id`=24440;
+UPDATE `creature` SET `position_x` = 2074.32, `position_y` = -3254.61, `position_z` = 151.285, `orientation` = 0.62470 WHERE `guid` =107087  AND `id`=24440;
+UPDATE `creature` SET `position_x` = 2016.23, `position_y` = -3220.88, `position_z` = 145.701, `orientation` = 0.19272 WHERE `guid` =107088  AND `id`=24440;
+UPDATE `creature` SET `position_x` = 2011.83, `position_y` = -3329.83, `position_z` = 171.795, `orientation` = 4.36712 WHERE `guid` =107089  AND `id`=24440;
+UPDATE `creature` SET `position_x` = 2036.12, `position_y` = -3271.50, `position_z` = 166.222, `orientation` = 3.90373 WHERE `guid` =107090  AND `id`=24440;
+UPDATE `creature` SET `position_x` = 2043.44, `position_y` = -3293.74, `position_z` = 155.987, `orientation` = 2.94947 WHERE `guid` =107092  AND `id`=24440;
+UPDATE `creature` SET `position_x` = 2029.06, `position_y` = -3237.62, `position_z` = 144.454, `orientation` = 1.76353 WHERE `guid` =107093  AND `id`=24440;
+UPDATE `creature` SET `position_x` = 2037.42, `position_y` = -3329.45, `position_z` = 152.021, `orientation` = 4.59488 WHERE `guid` =107094  AND `id`=24440;
+UPDATE `creature` SET `position_x` = 2048.38, `position_y` = -3219.60, `position_z` = 136.214, `orientation` = 1.94809 WHERE `guid` =107095  AND `id`=24440;
+UPDATE `creature` SET `position_x` = 2017.61, `position_y` = -3300.57, `position_z` = 161.711, `orientation` = 3.89588 WHERE `guid` =107096  AND `id`=24440;
+UPDATE `creature` SET `position_x` = 2049.23, `position_y` = -3309.59, `position_z` = 162.568, `orientation` = 2.27010 WHERE `guid` =107097  AND `id`=24440;
+UPDATE `creature` SET `position_x` = 2066.48, `position_y` = -3326.53, `position_z` = 152.303, `orientation` = 0.09847 WHERE `guid` =107098  AND `id`=24440;
+UPDATE `creature` SET `position_x` = 2045.28, `position_y` = -3274.34, `position_z` = 148.676, `orientation` = 2.69029 WHERE `guid` =107099  AND `id`=24440;
+UPDATE `creature` SET `position_x` = 2073.01, `position_y` = -3278.07, `position_z` = 148.988, `orientation` = 3.56994 WHERE `guid` =107100  AND `id`=24440;
+UPDATE `creature` SET `position_x` = 2075.15, `position_y` = -3301.94, `position_z` = 145.242, `orientation` = 1.18626 WHERE `guid` =107101  AND `id`=24440;
+UPDATE `creature` SET `position_x` = 2069.84, `position_y` = -3233.68, `position_z` = 139.911, `orientation` = 0.88681 WHERE `guid` =107102  AND `id`=24440;
+UPDATE `creature` SET `position_x` = 2036.56, `position_y` = -3267.03, `position_z` = 182.720, `orientation` = 0.14167 WHERE `guid` =107111  AND `id`=24440;
+UPDATE `creature_template_addon` SET `auras`="60921" WHERE `entry` = 24440;
+DELETE FROM `spell_area` WHERE `spell` IN (60922) AND `area`=3999;
+INSERT INTO `spell_area` (`spell`,`area`,`quest_start`,`quest_end`,`aura_spell`,`racemask`,`gender`,`flags`,`quest_start_status`,`quest_end_status`) VALUES
+(60922,3999,11391,0,0,0,2,3,10,0);