DB/Misc: Re-script the quest What the Soul Sees, respawn Ancient Orc Ancestor, and fix invisibility aura

1 files changed, 420 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2019_12_27_01_world.sql b/sql/updates/world/3.3.5/2019_12_27_01_world.sql
new file mode 100644
index 00000000000..719c9f20608
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_12_27_01_world.sql
@@ -0,0 +1,420 @@
+--
+-- 
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (1868800) AND `source_type`=9;
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (18688,19480) 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
+(18688,0,0,0,8,0,100,1,34063,0,0,0,80,1868800,0,0,0,0,0,1,0,0,0,0,0,0,0,"Ancient Orc Ancestor - On Spellhit Soul Mirror - Action list"),
+(1868800,9,0,0,0,0,100,0,0,0,0,0,1,0,0,0,0,0,0,7,0,0,0,0,0,0,0,"Ancient Orc Ancesto - Action list - Say text"),
+(1868800,9,1,0,0,0,100,0,1000,1000,0,0,11,34064,0,0,0,0,0,1,0,0,0,0,0,0,0,"Ancient Orc Ancesto - Action list - cast Soul Split"),
+(1868800,9,2,0,0,0,100,0,0,0,0,0,116,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Ancient Orc Ancesto - Action list - Set corpse delay"),
+(1868800,9,3,0,0,0,100,0,0,0,0,0,51,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Ancient Orc Ancesto - Action list - Kill Self"),
+(19480,0,0,0,0,0,100,0,5000,7000,11000,15000,11,31293,0,0,0,0,0,2,0,0,0,0,0,0,0,"Darkened Spirit - In Combat - Cast 'Consuming Shadows'"),
+(19480,0,1,0,54,0,100,0,0,0,0,0,11,17321,0,0,0,0,0,1,0,0,0,0,0,0,0,"Darkened Spirit - On just summoned - Cast Spirit Spawn");
+
+UPDATE `creature_template_addon` SET `auras`="32648" WHERE `entry` IN (18688,18043);
+DELETE FROM `creature_template_movement` WHERE `CreatureId`=18662;
+INSERT INTO `creature_template_movement` (`CreatureId`, `Ground`, `Swim`, `Flight`, `Rooted`) VALUES
+(18662,0,0,1,0);
+
+DELETE FROM `creature_template_addon` WHERE `entry`=18687;
+INSERT INTO `creature_template_addon` (`entry`, `bytes2`, `auras`) VALUES (18687,1,"32648");
+
+DELETE FROM `creature_text` WHERE `CreatureID` IN (18688, 19480);
+INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES
+(18688, 0, 0, "Ancestors watch over you,, kind one...", 12, 0, 100, 0, 0, 0, 16841, 0, "Ancient Orc Ancestor"),
+(18688, 0, 1, "Cease your crying! STOP!", 12, 0, 100, 0, 0, 0, 15706, 0, "Ancient Orc Ancestor"),
+(18688, 0, 2, "I remember everything...", 12, 0, 100, 0, 0, 0, 15701, 0, "Ancient Orc Ancestor"),
+(18688, 0, 3, "It cannot be...", 12, 0, 100, 0, 0, 0, 16839, 0, "Ancient Orc Ancestor"),
+(18688, 0, 4, "It comes for you...", 12, 0, 100, 0, 0, 0, 16838, 0, "Ancient Orc Ancestor"),
+(18688, 0, 5, "The spirits call... I am consumed.", 12, 0, 100, 0, 0, 0, 15704, 0, "Ancient Orc Ancestor"),
+(18688, 0, 6, "Cannot control... It draws me in... The void grows...", 12, 0, 100, 0, 0, 0, 15710, 0, "Ancient Orc Ancestor"),
+(18688, 0, 7, "It is dying. It is dying. It is dying.", 12, 0, 100, 0, 0, 0, 15707, 0, "Ancient Orc Ancestor"),
+(18688, 0, 8, "The cold embrace awaits...", 12, 0, 100, 0, 0, 0, 16837, 0, "Ancient Orc Ancestor"),
+(18688, 0, 9, "The pain is unbearable.", 12, 0, 100, 0, 0, 0, 15705, 0, "Ancient Orc Ancestor"),
+(18688, 0, 10, "What is happening to me?", 12, 0, 100, 0, 0, 0, 15703, 0, "Ancient Orc Ancestor"),
+(18688, 0, 11, "What is this trickery? I... ARGH...", 12, 0, 100, 0, 0, 0, 16840, 0, "Ancient Orc Ancestor"),
+(18688, 0, 12, "What will become of us when it falls?", 12, 0, 100, 0, 0, 0, 15709, 0, "Ancient Orc Ancestor"),
+(18688, 0, 13, "What... What have I become? Arrrgghhh...", 12, 0, 100, 0, 0, 0, 16835, 0, "Ancient Orc Ancestor"),
+(18688, 0, 14, "Thank you...", 12, 0, 100, 0, 0, 0, 16836, 0, "Ancient Orc Ancestor");
+
+DELETE FROM `creature_addon` WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (18688));
+DELETE FROM `creature` WHERE `id` IN (18688);
+INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `curhealth`, `curmana`, dynamicflags, `MovementType`) VALUES 
+(14337,18688,530,1,1,0,0,-2225.73,8586.74,-10.361,0.261799,60,0,6326,0,0,0), 
+(14338,18688,530,1,1,0,0,-1452.95,8533.52,12.8692,3.33358,60,0,6326,0,0,0),  
+(14339,18688,530,1,1,0,0,-2407.95,8655.04,-19.7505,4.45405,60,0,6542,0,0,2), 
+(14340,18688,530,1,1,0,0,-2300.29,8571.08,-22.0957,3.86735,60,0,6326,0,0,2), 
+(14341,18688,530,1,1,0,0,-1637.01,8569.54,-12.3352,5.65003,60,10,6326,0,0,1),
+(14342,18688,530,1,1,0,0,-2530.94,8629.31,-25.5884,4.80198,60,0,6326,0,0,2), 
+(14343,18688,530,1,1,0,0,-1452.95,8533.52,12.8692,3.33358,60,10,6542,0,0,1), 
+(14977,18688,530,1,1,0,0,-2225.73,8586.74,-10.361,0.261799,60,0,6542,0,0,2), 
+(14978,18688,530,1,1,0,0,-2218.21,8513.48,-17.1368,3.84753,60,0,6542,0,0,2), 
+(14979,18688,530,1,1,0,0,-1541.97,8697.41,26.0591,3.2847,60,10,6326,0,0,1),  
+(14980,18688,530,1,1,0,0,-1653.31,8494.49,-12.8156,6.13478,60,10,6542,0,0,1),
+(14981,18688,530,1,1,0,0,-1579.32,8426.67,-9.33804,6.13478,60,10,6326,0,0,1),
+(14982,18688,530,1,1,0,0,-1040.87,7895.8,22.8202,6.13478,60,10,6326,0,0,1),  
+(14983,18688,530,1,1,0,0,-1059.54,7750.35,25.8758,6.13478,60,10,6326,0,0,1), 
+(14984,18688,530,1,1,0,0,-625.605,7785.77,80.742,1.5277,60,10,6326,0,0,1),   
+(14985,18688,530,1,1,0,0,-886.413,7824.75,40.0754,6.13478,60,10,6542,0,0,1), 
+(20556,18688,530,1,1,0,0,-878.863,7881.25,38.6467,6.13478,60,10,6326,0,0,1), 
+(21776,18688,530,1,1,0,0,-1866.27,8098.74,-20.3459,6.13478,60,10,6542,0,0,1),
+(23111,18688,530,1,1,0,0,-2106.82,8191.13,-15.5604,3.02552,60,0,6542,0,0,2), 
+(24670,18688,530,1,1,0,0,-2084.75,8286.22,-11.4935,3.19831,60,0,6542,0,0,2), 
+(24761,18688,530,1,1,0,0,-2206.14,8306.9,-26.191,3.28627,60,0,6542,0,0,2),   
+(24794,18688,530,1,1,0,0,-2256,8478.68,-24.6155,3.72008,60,0,6542,0,0,2),    
+(25100,18688,530,1,1,0,0,-2336.12,8477.34,-30.3842,4.01413,60,0,6326,0,0,2), 
+(26559,18688,530,1,1,0,0,-2350.53,8641.59,-15.5674,4.33614,60,0,6326,0,0,2), 
+(26564,18688,530,1,1,0,0,-2336.04,8288.74,-36.3567,2.91457,60,0,6326,0,0,2), 
+(31807,18688,530,1,1,0,0,-2336.11,8225.27,-35.7699,2.54936,60,0,6326,0,0,2), 
+(31833,18688,530,1,1,0,0,-2258.45,8221.08,-31.2193,2.9185,60,0,6326,0,0,2),  
+(32072,18688,530,1,1,0,0,-2203.79,8149.55,-25.1002,2.51794,60,0,6326,0,0,2), 
+(40475,18688,530,1,1,0,0,-2184.8,8029.08,-17.6373,2.41427,60,0,6542,0,0,2),  
+(40476,18688,530,1,1,0,0,-2297.12,7848.94,-30.4255,1.92025,60,0,6326,0,0,2), 
+(40703,18688,530,1,1,0,0,-2053.2575,8155.302,-5.692453,3.01005,60,0,6326,0,0,2),
+(40716,18688,530,1,1,0,0,-2061.5180,8151.761,-7.437994,3.01005,60,0,6326,0,0,2),
+(40725,18688,530,1,1,0,0,-2068.1757,8148.957,-8.296552,3.01005,60,0,6326,0,0,2),
+(40727,18688,530,1,1,0,0,-2072.9716,8147.135,-8.763002,3.01005,60,0,6326,0,0,2),
+(42893,18688,530,1,1,0,0,-2077.1628,8145.699,-9.109463,3.01005,60,0,6326,0,0,2),
+(45204,18688,530,1,1,0,0,-2082.3554,8144.425,-9.395660,3.01005,60,0,6326,0,0,2);
+
+DELETE FROM `creature_addon` WHERE `guid` IN (40703,40716,40725,40727,42893,14339,14340,14342,14977,14978,23111,24670,24761,24794,25100,26559,26564,31807,31833,32072,40475,40476,45204);
+INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`auras`) VALUES
+(14339,143390,1,"32648"),
+(14340,143400,1,"32648"),
+(14342,143420,1,"32648"),
+(14977,149770,1,"32648"),
+(14978,149780,1,"32648"),
+(23111,231110,1,"32648"),
+(24670,246700,1,"32648"),
+(24761,247610,1,"32648"),
+(24794,247940,1,"32648"),
+(25100,251000,1,"32648"),
+(26559,265590,1,"32648"),
+(26564,265640,1,"32648"),
+(31807,318070,1,"32648"),
+(31833,318330,1,"32648"),
+(32072,320720,1,"32648"),
+(40475,404750,1,"32648"),
+(40476,404760,1,"32648"),
+(45204,452040,1,"32648"),
+(40703,452040,1,"32648"),
+(40716,452040,1,"32648"),
+(40725,452040,1,"32648"),
+(40727,452040,1,"32648"),
+(42893,452040,1,"32648");
+
+-- Waypoints
+DELETE FROM `waypoint_data` WHERE `id` IN (407030, 407160, 407250, 407270, 428930, 143390, 143400, 143420, 149770, 149780, 231110, 246700, 247610, 247940, 251000, 265590, 265640, 318070, 318330, 320720, 404750, 404760, 452040);
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`action`,`orientation`,`action_chance`,`move_type`,`wpguid`) VALUES
+-- 
+(143390,1,-2407.95,8655.04,-19.7505,1000,0,4.45405,100,0,0),
+(143390,2,-2413.04,8633.92,-25.1324,1000,0,4.45405,100,0,0),
+(143390,3,-2421.09,8603.46,-26.7298,0,0,4.45405,100,0,0),
+(143390,4,-2430.6,8575.63,-29.4027,0,0,4.381,100,0,0),
+(143390,5,-2437.78,8552.97,-31.1736,0,0,4.45405,100,0,0),
+(143390,6,-2444.38,8533.11,-30.9924,0,0,4.33231,100,0,0),
+(143390,7,-2448.27,8523.36,-33.7466,0,0,4.33231,100,0,0),
+(143390,8,-2453.47,8510.36,-34.1572,0,0,4.33231,100,0,0),
+(143390,9,-2458.66,8497.35,-34.0185,0,0,4.33231,100,0,0),
+(143390,10,-2462.55,8487.6,-36.7164,0,0,4.33231,100,0,0),
+(143390,11,-2469.78,8465.87,-35.8689,0,0,4.45404,100,0,0),
+(143390,12,-2474.9,8449.76,-36.479,3000,1188,4.32446,100,0,0),
+-- 
+(143400,1,-2300.29,8571.08,-22.0957,1000,0,3.86735,100,0,0),
+(143400,2,-2307.18,8565.63,-23.3747,1000,0,3.86735,100,0,0),
+(143400,3,-2323.42,8554.27,-25.1835,0,0,3.69849,100,0,0),
+(143400,4,-2341.53,8541.17,-29.3958,0,0,3.83201,100,0,0),
+(143400,5,-2358.69,8529.71,-29.4675,0,0,3.83201,100,0,0),
+(143400,6,-2365.34,8522.38,-31.3395,0,0,4.06762,100,0,0),
+(143400,7,-2375.63,8506.19,-30.7447,0,0,4.15009,100,0,0),
+(143400,8,-2381.94,8488.06,-31.5676,0,0,4.37,100,0,0),
+(143400,9,-2388.99,8470.31,-33.0737,0,0,4.30324,100,0,0),
+(143400,10,-2401.01,8449.19,-35.7696,0,0,4.14224,100,0,0),
+(143400,11,-2410.79,8433.93,-39.0449,0,0,4.14224,100,0,0),
+(143400,12,-2423.53,8416.24,-37.8244,0,0,4.02443,100,0,0),
+(143400,13,-2438.91,8397.78,-39.061,3000,1188,4.01265,100,0,0),
+-- 
+(143420,1,-2530.94,8629.31,-25.5884,1000,0,4.80198,100,0,0),
+(143420,2,-2530.28,8621.36,-26.2077,1000,0,4.80198,100,0,0),
+(143420,3,-2529.15,8604.47,-28.1857,0,0,4.77841,100,0,0),
+(143420,4,-2528.22,8590.5,-29.769,0,0,4.77841,100,0,0),
+(143420,5,-2527.07,8573.04,-29.9964,0,0,4.77841,100,0,0),
+(143420,6,-2525.38,8555.63,-31.5614,0,0,4.83732,100,0,0),
+(143420,7,-2523.27,8540.79,-32.4796,0,0,4.87266,100,0,0),
+(143420,8,-2521.41,8529.25,-33.6232,0,0,4.87266,100,0,0),
+(143420,9,-2518.41,8514.83,-36.519,0,0,4.94334,100,0,0),
+(143420,10,-2514.23,8497.08,-37.413,0,0,4.94334,100,0,0),
+(143420,11,-2511.41,8485.07,-35.6668,0,0,4.94334,100,0,0),
+(143420,12,-2507.94,8465.34,-37.5257,3000,1188,4.82946,100,0,0),
+-- 
+(149770,1,-2225.73,8586.74,-10.361,1000,0,0.261799,100,0,0),
+(149770,2,-2230.86,8579.38,-11.4502,1000,0,4.03619,100,0,0),
+(149770,3,-2239.71,8567.45,-13.0879,0,0,4.07153,100,0,0),
+(149770,4,-2248.5,8553.74,-15.3954,0,0,4.07939,100,0,0),
+(149770,5,-2261.12,8533.93,-21.6073,0,0,4.05582,100,0,0),
+(149770,6,-2270.2,8517.26,-24.1489,0,0,4.10059,100,0,0),
+(149770,7,-2279.27,8499.49,-27.908,0,0,4.03069,100,0,0),
+(149770,8,-2293,8485.29,-27.7969,0,0,3.90896,100,0,0),
+(149770,9,-2313.97,8468.41,-30.5916,0,0,3.81471,100,0,0),
+(149770,10,-2327.14,8456.77,-32.0345,0,0,3.88539,100,0,0),
+(149770,11,-2342.04,8442.35,-34.5414,0,0,3.9443,100,0,0),
+(149770,12,-2353.98,8430.83,-35.9558,0,0,3.86183,100,0,0),
+(149770,13,-2365.67,8421.51,-36.6551,0,0,3.83042,100,0,0),
+(149770,14,-2376.82,8411.01,-37.0926,0,0,3.86183,100,0,0),
+(149770,15,-2387.63,8399.56,-39.9234,0,0,3.91681,100,0,0),
+(149770,16,-2400.03,8389.21,-39.5322,0,0,3.82649,100,0,0),
+(149770,17,-2410.54,8381.85,-39.0444,0,0,3.62621,100,0,0),
+(149770,18,-2427.22,8372.09,-38.2585,3000,1188,3.67726,100,0,0),
+-- 
+(149780,1,-2218.21,8513.48,-17.1368,1000,0,3.84753,100,0,0),
+(149780,2,-2225.9,8506.7,-18.3157,1000,0,3.84753,100,0,0),
+(149780,3,-2241.69,8495.19,-21.2608,0,0,3.74543,100,0,0),
+(149780,4,-2254.02,8485.29,-23.6365,0,0,3.85146,100,0,0),
+(149780,5,-2266.7,8474.26,-26.624,0,0,3.90251,100,0,0),
+(149780,6,-2282.53,8460.96,-29.9073,0,0,3.83575,100,0,0),
+(149780,7,-2293.64,8450.78,-32.2739,0,0,3.89858,100,0,0),
+(149780,8,-2312.77,8434.41,-34.4343,0,0,3.80041,100,0,0),
+(149780,9,-2329,8420.96,-34.6316,0,0,3.83968,100,0,0),
+(149780,10,-2342.3,8410.75,-36.3513,0,0,3.78863,100,0,0),
+(149780,11,-2352.85,8402.78,-35.9703,0,0,3.78863,100,0,0),
+(149780,12,-2368.62,8390.19,-37.4839,0,0,3.93471,100,0,0),
+(149780,13,-2377.66,8381.81,-39.9896,0,0,3.86402,100,0,0),
+(149780,14,-2388.56,8372.21,-40.392,0,0,3.86402,100,0,0),
+(149780,15,-2398.68,8364.43,-39.9869,0,0,3.76978,100,0,0),
+(149780,16,-2413.6,8353.59,-39.7226,0,0,3.76978,100,0,0),
+(149780,17,-2422.74,8346.85,-40.09,3000,1188,3.78156,100,0,0),
+-- 
+(231110,1,-2106.82,8191.13,-15.5604,1000,0,3.02552,100,0,0),
+(231110,2,-2112.65,8192.04,-16.7948,1000,0,3.02552,100,0,0),
+(231110,3,-2121.32,8193.06,-18.1025,0,0,3.02552,100,0,0),
+(231110,4,-2138.71,8195.08,-20.6668,0,0,3.02552,100,0,0),
+(231110,5,-2152.45,8196.68,-23.1558,0,0,3.02552,100,0,0),
+(231110,6,-2169.23,8199.54,-25.8568,0,0,2.91949,100,0,0),
+(231110,7,-2186.44,8204.07,-28.6804,0,0,2.8763,100,0,0),
+(231110,8,-2198.97,8208.21,-29.0413,0,0,2.78598,100,0,0),
+(231110,9,-2210.4,8212.23,-28.0244,0,0,2.81346,100,0,0),
+(231110,10,-2226.21,8218.56,-26.739,0,0,2.75063,100,0,0),
+(231110,11,-2238.35,8223.76,-27.498,0,0,2.731,100,0,0),
+(231110,12,-2251.97,8229.42,-29.0346,0,0,2.75849,100,0,0),
+(231110,13,-2265.74,8235.78,-30.4832,0,0,2.6878,100,0,0),
+(231110,14,-2282.11,8243.3,-30.8119,0,0,2.71529,100,0,0),
+(231110,15,-2299.43,8248.93,-33.1635,0,0,2.85666,100,0,0),
+(231110,16,-2314.23,8251.73,-36.0716,0,0,2.97447,100,0,0),
+(231110,17,-2328.3,8254.83,-35.9723,0,0,2.91949,100,0,0),
+(231110,18,-2347.02,8257.81,-38.1012,0,0,3.05694,100,0,0),
+(231110,19,-2365.63,8259.31,-40.5246,0,0,3.06479,100,0,0),
+(231110,20,-2384.29,8263.58,-39.357,0,0,2.77812,100,0,0),
+(231110,21,-2405.55,8270.21,-37.7358,3000,1188,2.84881,100,0,0),
+-- 
+(246700,1,-2084.75,8286.22,-11.4935,1000,0,3.19831,100,0,0),
+(246700,2,-2091.1,8286.06,-12.3958,1000,0,3.19831,100,0,0),
+(246700,3,-2106.99,8288.47,-15.4028,0,0,2.90378,100,0,0),
+(246700,4,-2119.97,8292.25,-18.4454,0,0,2.84881,100,0,0),
+(246700,5,-2136.66,8296.48,-19.3693,0,0,2.8763,100,0,0),
+(246700,6,-2154.37,8301.18,-20.9227,0,0,3.01767,100,0,0),
+(246700,7,-2170.51,8301.82,-22.6604,0,0,3.1237,100,0,0),
+(246700,8,-2189.94,8301.98,-24.2471,0,0,3.15511,100,0,0),
+(246700,9,-2206.32,8302.08,-25.8035,0,0,3.12762,100,0,0),
+(246700,10,-2221.69,8303.03,-26.126,0,0,3.09228,100,0,0),
+(246700,11,-2234.13,8303.57,-28.4319,0,0,3.10799,100,0,0),
+(246700,12,-2248.53,8303.48,-29.4753,0,0,3.1826,100,0,0),
+(246700,13,-2262.85,8305.04,-29.8504,0,0,3.08914,100,0,0),
+(246700,14,-2276.84,8305.46,-30.8176,0,0,3.14804,100,0,0),
+(246700,15,-2290.82,8304.94,-32.4245,0,0,3.19909,100,0,0),
+(246700,16,-2304.81,8304.44,-33.9312,0,0,3.14412,100,0,0),
+(246700,17,-2322.31,8304.53,-36.2386,0,0,3.13234,100,0,0),
+(246700,18,-2336.31,8304.66,-37.9441,0,0,3.13234,100,0,0),
+(246700,19,-2352.01,8304.31,-37.699,0,0,3.18731,100,0,0),
+(246700,20,-2365.59,8305.15,-40.1673,0,0,3.04594,100,0,0),
+(246700,21,-2383.63,8306.82,-38.712,0,0,3.03023,100,0,0),
+(246700,22,-2401.23,8308.73,-38.554,0,0,3.03416,100,0,0),
+(246700,23,-2423.32,8310.51,-38.1534,3000,1188,3.08128,100,0,0),
+-- 
+(247610,1,-2206.14,8306.9,-26.191,1000,0,3.28627,100,0,0),
+(247610,2,-2212.08,8306.59,-26.1231,1000,0,3.28627,100,0,0),
+(247610,3,-2223.2,8304.77,-26.3483,0,0,3.31561,100,0,0),
+(247610,4,-2236.38,8301.02,-28.5661,0,0,3.32346,100,0,0),
+(247610,5,-2248.5,8299.47,-28.7971,0,0,3.27241,100,0,0),
+(247610,6,-2266.04,8297.18,-29.6781,0,0,3.27634,100,0,0),
+(247610,7,-2282.35,8295.87,-31.8415,0,0,3.18602,100,0,0),
+(247610,8,-2297.05,8294.86,-33.8225,0,0,3.23707,100,0,0),
+(247610,9,-2314.94,8295.12,-35.8822,0,0,3.0957,100,0,0),
+(247610,10,-2326.35,8296.19,-37.6473,0,0,3.0525,100,0,0),
+(247610,11,-2340.74,8297.08,-36.9042,0,0,3.09177,100,0,0),
+(247610,12,-2359.08,8297.76,-39.7544,0,0,3.10748,100,0,0),
+(247610,13,-2377.33,8298.04,-39.5022,0,0,3.10748,100,0,0),
+(247610,14,-2394.15,8298.36,-39.518,0,0,3.12712,100,0,0),
+(247610,15,-2425.05,8298.74,-39.8907,3000,1188,3.17817,100,0,0),
+-- 
+(247940,1,-2256,8478.68,-24.6155,1000,0,3.72008,100,0,0),
+(247940,2,-2261.14,8475.37,-25.8232,1000,0,3.72008,100,0,0),
+(247940,3,-2272.51,8467.21,-28.3968,0,0,3.80648,100,0,0),
+(247940,4,-2285.8,8455.84,-30.6126,0,0,3.88109,100,0,0),
+(247940,5,-2300.34,8442.98,-33.4702,0,0,3.91879,100,0,0),
+(247940,6,-2312.62,8430.52,-35.257,0,0,3.95413,100,0,0),
+(247940,7,-2324.73,8415.52,-35.6384,0,0,4.08765,100,0,0),
+(247940,8,-2334.41,8400.94,-36.4277,0,0,4.15048,100,0,0),
+(247940,9,-2343.83,8385.63,-38.5498,0,0,4.21331,100,0,0),
+(247940,10,-2365.02,8369.27,-39.7285,0,0,3.66353,100,0,0),
+(247940,11,-2378.88,8360.32,-40.392,0,0,3.69495,100,0,0),
+(247940,12,-2391.93,8351.75,-38.8548,0,0,3.73029,100,0,0),
+(247940,13,-2406.44,8339.74,-38.2314,0,0,3.84417,100,0,0),
+(247940,14,-2422.92,8329.23,-37.6123,3000,1188,3.68317,100,0,0),
+-- 
+(251000,1,-2336.12,8477.34,-30.3842,1000,0,4.01413,100,0,0),
+(251000,2,-2349.93,8462.18,-33.0847,1000,0,4.01413,100,0,0),
+(251000,3,-2366.12,8445.55,-34.8728,0,0,3.94344,100,0,0),
+(251000,4,-2373.97,8435.66,-37.0363,0,0,4.01648,100,0,0),
+(251000,5,-2380.55,8426.95,-36.2271,0,0,4.08952,100,0,0),
+(251000,6,-2390.7,8414.94,-39.51,0,0,3.8327,100,0,0),
+(251000,7,-2401.49,8406.01,-40.1447,0,0,3.8327,100,0,0),
+(251000,8,-2410.17,8396.76,-38.5437,0,0,4.05183,100,0,0),
+(251000,9,-2425.49,8379.5,-38.4966,3000,1188,3.94344,100,0,0),
+-- 
+(265590,1,-2350.53,8641.59,-15.5674,1000,0,4.33614,100,0,0),
+(265590,2,-2352.89,8636.14,-16.3244,1000,0,4.33614,100,0,0),
+(265590,3,-2357.5,8623.99,-18.0005,0,0,4.36363,100,0,0),
+(265590,4,-2362.76,8609.52,-19.8936,0,0,4.36363,100,0,0),
+(265590,5,-2366.35,8599.65,-21.8037,0,0,4.36363,100,0,0),
+(265590,6,-2369.94,8589.79,-23.7659,0,0,4.36363,100,0,0),
+(265590,7,-2375.45,8576.94,-26.2606,0,0,4.24189,100,0,0),
+(265590,8,-2381.59,8564.36,-28.3376,0,0,4.26938,100,0,0),
+(265590,9,-2387.13,8551.14,-28.6318,0,0,4.33614,100,0,0),
+(265590,10,-2392.13,8540.34,-28.5545,0,0,4.26546,100,0,0),
+(265590,11,-2398.71,8527.99,-28.765,0,0,4.20262,100,0,0),
+(265590,12,-2406.03,8511.94,-30.638,0,0,4.3165,100,0,0),
+(265590,13,-2411.22,8498.94,-32.6872,0,0,4.33614,100,0,0),
+(265590,14,-2417.87,8484,-34.7147,0,0,4.27724,100,0,0),
+(265590,15,-2425.59,8468.94,-36.5487,0,0,4.23404,100,0,0),
+(265590,16,-2433.41,8452.95,-38.3402,0,0,4.26153,100,0,0),
+(265590,17,-2439.51,8440.35,-36.7726,0,0,4.26153,100,0,0),
+(265590,18,-2451.02,8423.42,-37.3139,3000,1188,4.08482,100,0,0),
+-- 
+(265640,1,-2336.04,8288.74,-36.3567,1000,0,2.91457,100,0,0),
+(265640,2,-2342.21,8290.03,-36.0686,1000,0,2.91457,100,0,0),
+(265640,3,-2354.03,8291.55,-38.2599,0,0,3.02452,100,0,0),
+(265640,4,-2375.94,8295.73,-39.9772,0,0,3.00096,100,0,0),
+(265640,5,-2396.58,8299.53,-39.806,0,0,2.94598,100,0,0),
+(265640,6,-2419.92,8304.59,-38.8306,3000,1188,2.92635,100,0,0),
+-- 
+(318070,1,-2336.11,8225.27,-35.7699,1000,0,2.54936,100,0,0),
+(318070,2,-2340.34,8228.06,-35.889,1000,0,2.54936,100,0,0),
+(318070,3,-2358.71,8238.23,-38.7513,0,0,2.72214,100,0,0),
+(318070,4,-2369.57,8242.53,-40.8813,0,0,2.77712,100,0,0),
+(318070,5,-2382.45,8246.73,-39.914,0,0,2.83995,100,0,0),
+(318070,6,-2394.95,8250.99,-39.4445,0,0,2.84781,100,0,0),
+(318070,7,-2419.48,8255.91,-38.5315,3000,1188,3.04416,100,0,0),
+-- 
+(318330,1,-2258.45,8221.08,-31.2193,1000,0,2.9185,100,0,0),
+(318330,2,-2264.59,8222.61,-30.8688,1000,0,2.9185,100,0,0),
+(318330,3,-2279.19,8226.34,-30.9118,0,0,2.88315,100,0,0),
+(318330,4,-2294.29,8229.86,-32.502,0,0,2.93421,100,0,0),
+(318330,5,-2302.79,8232.62,-33.6875,0,0,2.75749,100,0,0),
+(318330,6,-2311.76,8236.52,-36.218,0,0,2.73393,100,0,0),
+(318330,7,-2328.46,8243.79,-37.3536,0,0,2.76534,100,0,0),
+(318330,8,-2346.61,8249.73,-38.4788,0,0,2.83996,100,0,0),
+(318330,9,-2358.44,8255.57,-39.1873,0,0,2.65146,100,0,0),
+(318330,10,-2372.51,8261.68,-40.7349,0,0,2.84388,100,0,0),
+(318330,11,-2389.28,8266.69,-38.6213,0,0,2.85567,100,0,0),
+(318330,12,-2405.67,8270.19,-37.7384,3000,1188,2.9774,100,0,0),
+-- 
+(320720,1,-2203.79,8149.55,-25.1002,1000,0,2.51794,100,0,0),
+(320720,2,-2210.85,8154.53,-26.8673,1000,0,2.51794,100,0,0),
+(320720,3,-2223.12,8161.02,-30.405,0,0,2.56507,100,0,0),
+(320720,4,-2233,8167.85,-31.2388,0,0,2.52972,100,0,0),
+(320720,5,-2243.01,8174.87,-33.5484,0,0,2.52972,100,0,0),
+(320720,6,-2257.05,8184.72,-34.9053,0,0,2.52972,100,0,0),
+(320720,7,-2270.59,8191.99,-36.1858,0,0,2.71037,100,0,0),
+(320720,8,-2283.26,8197.29,-36.6298,0,0,2.7732,100,0,0),
+(320720,9,-2296.8,8202.52,-36.0711,0,0,2.7732,100,0,0),
+(320720,10,-2309.64,8207.47,-36.8004,0,0,2.7732,100,0,0),
+(320720,11,-2320.94,8211.83,-36.1317,0,0,2.7732,100,0,0),
+(320720,12,-2333.98,8216.87,-35.3284,0,0,2.7732,100,0,0),
+(320720,13,-2348.95,8223.85,-35.9928,0,0,2.55172,100,0,0),
+(320720,14,-2367.19,8235.63,-40.6976,0,0,2.54779,100,0,0),
+(320720,15,-2381.4,8243.44,-40.6753,0,0,2.79912,100,0,0),
+(320720,16,-2394.08,8247.13,-38.7973,0,0,2.88551,100,0,0),
+(320720,17,-2415.85,8252.83,-38.9504,3000,1188,2.88551,100,0,0),
+-- 
+(404750,1,-2184.8,8029.08,-17.6373,1000,0,2.41427,100,0,0),
+(404750,2,-2189.89,8033.31,-18.7028,1000,0,2.41427,100,0,0),
+(404750,3,-2201.12,8043.03,-21.2763,0,0,2.44961,100,0,0),
+(404750,4,-2210.96,8051.17,-23.9013,0,0,2.45354,100,0,0),
+(404750,5,-2220.19,8059.87,-28.1386,0,0,2.44569,100,0,0),
+(404750,6,-2228.35,8066.62,-31.2971,0,0,2.45354,100,0,0),
+(404750,7,-2243.75,8073.69,-33.0466,0,0,2.51716,100,0,0),
+(404750,8,-2256.64,8084.78,-34.8378,0,0,2.37579,100,0,0),
+(404750,9,-2269.54,8096.88,-35.8722,0,0,2.40327,100,0,0),
+(404750,10,-2274.08,8100.97,-34.4774,0,0,2.43076,100,0,0),
+(404750,11,-2285.13,8110.73,-35.2784,0,0,2.4072,100,0,0),
+(404750,12,-2293.23,8118.05,-36.6003,0,0,2.4072,100,0,0),
+(404750,13,-2303.37,8127.19,-37.9431,0,0,2.4072,100,0,0),
+(404750,14,-2313.27,8135.21,-37.7228,0,0,2.59099,100,0,0),
+(404750,15,-2326.01,8147.27,-38.0687,0,0,2.33966,100,0,0),
+(404750,16,-2337.12,8156.41,-38.4812,0,0,2.48888,100,0,0),
+(404750,17,-2347.76,8168.32,-39.0334,0,0,2.2729,100,0,0),
+(404750,18,-2358.32,8180.11,-38.6665,0,0,2.31217,100,0,0),
+(404750,19,-2368.77,8189.27,-37.5052,0,0,2.45825,100,0,0),
+(404750,20,-2384.14,8199.83,-40.8323,0,0,2.57999,100,0,0),
+(404750,21,-2395.97,8207.08,-41.4856,0,0,2.5957,100,0,0),
+(404750,22,-2404.42,8212.29,-39.4423,0,0,2.58784,100,0,0),
+(404750,23,-2415.06,8217.57,-38.0044,3000,1188,2.65853,100,0,0),
+-- 
+(404760,1,-2297.12,7848.94,-30.4255,1000,0,1.92025,100,0,0),
+(404760,2,-2299.1,7855.22,-31.5119,1000,0,1.92025,100,0,0),
+(404760,3,-2304.97,7869.3,-33.6264,0,0,2.10404,100,0,0),
+(404760,4,-2310.6,7885.7,-36.7148,0,0,1.89591,100,0,0),
+(404760,5,-2315.58,7897.69,-36.2731,0,0,1.9823,100,0,0),
+(404760,6,-2322.29,7913.85,-35.4619,0,0,1.97445,100,0,0),
+(404760,7,-2324.87,7930.59,-36.2939,0,0,1.75846,100,0,0),
+(404760,8,-2326.62,7941.83,-37.0868,0,0,1.9391,100,0,0),
+(404760,9,-2332.33,7954.6,-38.5053,0,0,2.03335,100,0,0),
+(404760,10,-2337.86,7965.23,-40.3403,0,0,2.06084,100,0,0),
+(404760,11,-2342.11,7973.1,-41.8945,0,0,2.06869,100,0,0),
+(404760,12,-2350.94,7987.8,-43.8866,0,0,2.11975,100,0,0),
+(404760,13,-2360.01,8000.48,-44.3554,0,0,2.15509,100,0,0),
+(404760,14,-2364.95,8009.58,-42.1108,0,0,2.02157,100,0,0),
+(404760,15,-2371.6,8018.86,-42.377,0,0,2.26112,100,0,0),
+(404760,16,-2377.15,8026.67,-43.9684,0,0,2.09618,100,0,0),
+(404760,17,-2383.49,8038.39,-43.2112,0,0,2.05299,100,0,0),
+(404760,18,-2389.7,8051.49,-44.9951,0,0,2.05691,100,0,0),
+(404760,19,-2397.24,8065.66,-45.2933,0,0,2.06084,100,0,0),
+(404760,20,-2400.62,8071.78,-43.7882,0,0,2.06477,100,0,0),
+(404760,21,-2405.28,8080.43,-44.8051,0,0,2.06477,100,0,0),
+(404760,22,-2414.09,8096.78,-42.7268,0,0,2.06477,100,0,0),
+(404760,23,-2414.19,8107.76,-43.7943,0,0,1.56211,100,0,0),
+(404760,24,-2416.34,8128.6,-41.3327,0,0,1.75846,100,0,0),
+(404760,25,-2421.42,8140.34,-40.3193,0,0,1.97838,100,0,0),
+(404760,26,-2426.74,8151.71,-40.4096,0,0,2.0255,100,0,0),
+(404760,27,-2440.01,8173.9,-38.1841,3000,1188,2.08833,100,0,0),
+-- 
+(452040,1,-2082.11,8144.33,-9.38167,0,0,3.01005,100,0,0),
+(452040,2,-2090.07,8144.3,-9.68601,0,0,3.01005,100,0,0),
+(452040,3,-2104.75,8146.88,-11.5349,0,0,2.82469,100,0,0),
+(452040,4,-2117.46,8150.49,-13.9854,0,0,2.82469,100,0,0),
+(452040,5,-2132.37,8154.47,-16.5653,0,0,2.86396,100,0,0),
+(452040,6,-2162.07,8159.93,-22.7686,0,0,2.8993,100,0,0),
+(452040,7,-2181.45,8166.97,-24.183,0,0,2.86003,100,0,0),
+(452040,8,-2198.64,8173.96,-25.4028,0,0,2.75008,100,0,0),
+(452040,9,-2217.2,8192.97,-27.2827,0,0,2.62834,100,0,0),
+(452040,10,-2228.8,8200.04,-28.4579,0,0,2.76422,100,0,0),
+(452040,11,-2246.08,8207.95,-30.9994,0,0,2.73673,100,0,0),
+(452040,12,-2258.95,8213.47,-31.4389,0,0,2.73673,100,0,0),
+(452040,13,-2271.81,8218.98,-30.8967,0,0,2.73673,100,0,0),
+(452040,14,-2287.73,8223.45,-32.2008,0,0,2.82705,100,0,0),
+(452040,15,-2300.97,8228.01,-33.8134,0,0,2.80349,100,0,0),
+(452040,16,-2312.92,8233.68,-36.2357,0,0,2.64641,100,0,0),
+(452040,17,-2326.3,8240.15,-37.6111,0,0,2.70924,100,0,0),
+(452040,18,-2342.98,8249.96,-38.1975,0,0,2.74458,100,0,0),
+(452040,19,-2355.6,8256.92,-38.9036,0,0,2.61892,100,0,0),
+(452040,20,-2366.56,8262.79,-40.5378,0,0,2.68175,100,0,0),
+(452040,21,-2377.26,8267.13,-40.3544,0,0,2.80349,100,0,0),
+(452040,22,-2390.06,8270.31,-38.3435,0,0,2.99591,100,0,0),
+(452040,23,-2407.86,8275.86,-37.7765,0,1188,2.8781,100,0,0);
+
+DELETE FROM `spell_area` WHERE `spell` IN (32649);
+INSERT INTO `spell_area` (`spell`,`area`,`quest_start`,`quest_end`,`aura_spell`,`racemask`,`gender`,`autocast`,`quest_start_status`,`quest_end_status`) VALUES
+(32649,3518,10252,0,0,0,2,1,64,11),
+(32649,3688,10252,0,0,0,2,1,64,11),
+(32649,3518,10045,0,0,0,2,1,64,11),
+(32649,3688,10045,0,0,0,2,1,64,11);