DB/Misc: Death Knights starting area

1 files changed, 439 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2019_07_19_04_world.sql b/sql/updates/world/3.3.5/2019_07_19_04_world.sql
new file mode 100644
index 00000000000..b606b9bbaf7
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_07_19_04_world.sql
@@ -0,0 +1,439 @@
+-- 
+UPDATE `creature_template` SET `unit_flags` = `unit_flags`|2 WHERE `entry` IN (28642,28647);
+-- Dark Rider of Acherus
+UPDATE `creature_template` SET `mechanic_immune_mask` = `mechanic_immune_mask`|32 WHERE `entry` = 28768; 
+-- Scarlet Fleet Defender
+UPDATE `creature_addon` SET `auras` = "48356" WHERE `guid` IN (129130, 129114, 129154);
+-- Scourge Gryphon
+UPDATE `creature_template` SET `minlevel` = 56, `maxlevel` = 56 WHERE `entry` = 28864;
+-- crusaders models
+UPDATE `creature` SET `modelid`=0 WHERE `id` IN (29102, 29103);
+-- Rain of Darkness
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=17 AND `SourceEntry`=52149;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
+(17,0,52149,0,31,1,3,28576,0,0,'','Spell 52149 targets entry 28576');
+UPDATE `creature_addon` SET `auras`="52180" WHERE `guid` IN  (SELECT `guid` FROM `creature` WHERE `id` IN (28577, 28576)); 
+UPDATE `creature_addon` SET `auras`="" WHERE `guid` IN  (SELECT `guid` FROM `creature` WHERE `id`=28821); 
+UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=28643;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=28643 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
+(28643,0,0,0,54,0,20,0,0,0,0,0,11,52149,0,0,0,0,0,7,0,0,0,0,0,0,0,"Rain of Darkness Dummy - On just summoned - Cast 'Rain of Darkness'");
+-- All targets for s.52638 'Cowardly Peasant Trigger'
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=52638;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
+(13,1,52638,0,31,3,28576,0,0,'','Spell 52638 targets entry 28576'),
+(13,1,52638,1,31,3,28577,0,0,'','Spell 52638 targets entry 28577'),
+(13,1,52638,1,31,3,28557,0,0,'','Spell 52638 targets entry 28557');
+-- All targets for s.52732 'Cowardly Citizen Trigger'
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=52732;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
+(13,1,52732,0,31,3,28942,0,0,'','Spell 52732 targets entry 28942'),
+(13,1,52732,1,31,3,28941,0,0,'','Spell 52732 targets entry 28941');
+-- spell ID - 52637 See Acherus Invisibility: starts after player completes: q.12657 'The Might Of The Scourge' finishes after player completes: q.12706 'Victory At Death's Breach!'
+DELETE FROM `spell_area` WHERE `spell` = 52637;
+INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`, `quest_start_status`, `quest_end_status`) VALUES
+(52637,4298,12657,12706,0,0,2,1,64,11);
+-- spell ID - 52598 Ebon Hold: Chapter II, Skybox must finish after player completes: q.12801 'The Light of Dawn'
+UPDATE `spell_area` SET `quest_end` = 12801 WHERE `spell` = 52598;
+-- missing spawn
+DELETE FROM `creature` WHERE `guid` = 111203 AND `id`=28557;
+INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`) VALUES
+(111203,28557,609,1,1,0,1,2243.8,-5751.91,101.717,3.86353,360,0,0,924,0,0);
+DELETE FROM `creature_addon` WHERE `guid` = 111203;
+INSERT INTO `creature_addon` (`guid`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES 
+(111203,0,0,1,234,'48356');
+-- Scarlet Miners
+DELETE FROM `creature` WHERE `guid` IN (128861, 128862, 128863, 128865, 128866, 128867, 128871, 128872, 128875, 128877, 128878, 128881, 128882, 128883, 128884, 128886, 128887, 128888, 128890, 128891, 128892, 128896, 128897, 128900, 128902, 128903, 128906, 128907, 128908, 128909) AND `id` IN (28822,28821);
+DELETE FROM `creature_addon` WHERE `guid` IN (128861, 128862, 128863, 128865, 128866, 128867, 128871, 128872, 128875, 128877, 128878, 128881, 128882, 128883, 128884, 128886, 128887, 128888, 128890, 128891, 128892, 128896, 128897, 128900, 128902, 128903, 128906, 128907, 128908, 128909);
+UPDATE `creature` SET `spawntimesecs` = 10 WHERE `id` = 28822;
+UPDATE `creature` SET `spawntimesecs` = 2 WHERE `id` = 28821;
+-- Scarlet Miner #1 
+UPDATE `creature` SET `position_x` = 2216.001709, `position_y` = -6019.908203, `position_z` = 8.945984, `orientation` = 4.067243, `MovementType` = 2, `spawndist` = 0 WHERE `guid` = 128904;
+DELETE FROM `creature_addon` WHERE `guid` IN (128904);
+INSERT INTO `creature_addon` (`guid`, `mount`, `bytes1`, `bytes2`, `path_id`, auras) VALUES 
+(128904,0,0,1,1289040, "48356");
+DELETE FROM `waypoint_data` WHERE `id` IN (1289040);
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `action`, `orientation`, `action_chance`, `move_type`) VALUES
+(1289040,1,2216.001709,-6019.908203,8.945984,2000,0,4.35549,100,0),
+(1289040,2,2206.69,-6050.58,6.27707,0,0,4.35549,100,0),
+(1289040,3,2191.11,-6087.17,2.79132,0,0,4.38298,100,0),
+(1289040,4,2179.79,-6133.88,1.93313,0,0,4.33271,100,0),
+(1289040,5,2169.92,-6152.61,1.19506,0,0,3.57002,100,0),
+(1289040,6,2134.24,-6167,0.419345,0,0,4.10802,100,0),
+(1289040,7,2122.31,-6186.06,14.0377,0,0,4.17085,100,0),
+(1289040,8,2118.87,-6192.96,13.3049,2000,1188,4.06482,100,0);
+-- Scarlet Miner #2
+UPDATE `creature` SET `position_x` = 2300.483643, `position_y` = -5910.774902, `position_z` = 86.692505, `orientation` = 4.1, `MovementType` = 2, `spawndist` = 0 WHERE `guid` = 128905;
+DELETE FROM `creature_addon` WHERE `guid` IN (128905);
+INSERT INTO `creature_addon` (`guid`, `mount`, `bytes1`, `bytes2`, `path_id`, auras) VALUES 
+(128905,0,0,1,1289050, "48356");
+DELETE FROM `waypoint_data` WHERE `id` IN (1289050);
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `action`, `orientation`, `action_chance`, `move_type`) VALUES
+(1289050,1,2300.483643,-5910.774902,86.692505,2000,0,4.1,100,0),
+(1289050,2,2293.55,-5917.05,82.6056,0,0,4.5,100,0),
+(1289050,3,2291.99,-5937.86,68.6884,0,0,4.4,100,0),
+(1289050,4,2285.03,-5954.97,58.3396,0,0,4.11897,100,0),
+(1289050,5,2271.14,-5968.92,48.9592,0,0,3.69171,100,0),
+(1289050,6,2250.53,-5976.27,38.1416,0,0,3.80481,100,0),
+(1289050,7,2235.15,-5990.82,28.9556,0,0,4.26348,100,0),
+(1289050,8,2230.64,-5998.63,23.2568,0,0,4.21792,100,0),
+(1289050,9,2222.41,-6016.41,10.5581,0,0,4.24148,100,0),
+(1289050,10,2210.8,-6041.32,6.66781,0,0,4.29646,100,0),
+(1289050,11,2197.73,-6067.8,5.00293,0,0,4.1708,100,0),
+(1289050,12,2181.79,-6096.56,1.5113,0,0,4.23363,100,0),
+(1289050,13,2176.28,-6119.68,1.27137,0,0,4.6224,100,0),
+(1289050,14,2178.41,-6143.14,1.49253,0,0,5.04965,100,0),
+(1289050,15,2186.09,-6157.27,2.71064,0,0,5.61592,100,0),
+(1289050,16,2202.49,-6165.09,1.20293,0,0,6.13977,100,0),
+(1289050,17,2232.58,-6165.21,0.876994,0,0,0.0332994,100,0),
+(1289050,18,2258.76,-6162.07,1.12015,0,0,5.8476,100,0),
+(1289050,19,2268.92,-6167.7,1.24728,0,0,4.96325,100,0),
+(1289050,20,2271.04,-6187.32,13.9861,0,0,4.81639,100,0),
+(1289050,21,2271.88,-6195.34,13.2237,2000,1188,4.81639,100,0);
+-- Scarlet Miner & Mine car #3  
+UPDATE `creature` SET `position_x` = 2416.258057, `position_y` = -5891.284668, `position_z` = 104.595085, `orientation` = 0.440682 WHERE `guid` = 128869;
+UPDATE `creature` SET `position_x` = 2416.258057, `position_y` = -5891.284668, `position_z` = 104.595085, `orientation` = 0.440682, `MovementType` = 2, `spawndist` = 0 WHERE `guid` = 128894;
+DELETE FROM `creature_addon` WHERE `guid` IN (128894);
+INSERT INTO `creature_addon` (`guid`, `mount`, `bytes1`, `bytes2`, `path_id`, auras) VALUES 
+(128894,0,0,1,1288940, "48356");
+DELETE FROM `waypoint_data` WHERE `id` IN (1288940);
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `action`, `orientation`, `action_chance`, `move_type`) VALUES
+(1288940,1,2416.258057,-5891.284668,104.595085,2000,0,0.44,100,0),
+(1288940,2,2430.03,-5884.64,104.602,0,0,5.75,100,0),
+(1288940,3,2434.08,-5888.33,104.883,0,0,4.99,100,0),
+(1288940,4,2437.97,-5899.35,103.585,0,0,4.9803,100,0),
+(1288940,5,2442.79,-5912.86,102.113,0,0,4.87427,100,0),
+(1288940,6,2440.3,-5926.62,97.3613,0,0,4.28602,100,0),
+(1288940,7,2427.87,-5938.68,95.1745,0,0,3.7276,100,0),
+(1288940,8,2422.66,-5942.83,96.5461,0,0,4.17449,100,0),
+(1288940,9,2419.94,-5957.54,97.6666,0,0,5.02036,100,0),
+(1288940,10,2428.03,-5967.78,95.4582,0,0,5.59683,100,0),
+(1288940,11,2437.99,-5971.81,95.8846,0,0,6.05236,100,0),
+(1288940,12,2447.36,-5970.5,94.5749,0,0,0.566349,100,0),
+(1288940,13,2453.66,-5955.88,95.6707,2000,1188,1.38709,100,0);
+-- Scarlet Miner & Mine car #4 
+UPDATE `creature` SET `position_x` = 2410.756348, `position_y` = -5939.629395, `position_z` = 97.339973, `orientation` = 5.943231 WHERE `guid` = 128860;
+UPDATE `creature` SET `position_x` = 2410.756348, `position_y` = -5939.629395, `position_z` = 97.339973, `orientation` = 5.943231, `MovementType` = 2, `spawndist` = 0 WHERE `guid` = 128885;
+DELETE FROM `creature_addon` WHERE `guid` IN (128885);
+INSERT INTO `creature_addon` (`guid`, `mount`, `bytes1`, `bytes2`, `path_id`, auras) VALUES 
+(128885,0,0,1,1288850, "48356");
+DELETE FROM `waypoint_data` WHERE `id` IN (1288850);
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `action`, `orientation`, `action_chance`, `move_type`) VALUES
+(1288850,1,2410.756348,-5939.629395,97.339973,2000,0,5.94,100,0),
+(1288850,2,2418.29,-5945.4,96.7502,0,0,5.04,100,0),
+(1288850,3,2418.23,-5953.19,97.8662,0,0,5.15,100,0),
+(1288850,4,2423.57,-5963.65,96.3384,0,0,5.53484,100,0),
+(1288850,5,2437.87,-5970.48,96.0122,0,0,6.24955,100,0),
+(1288850,6,2474.32,-5975.1,96.276,0,0,5.99508,100,0),
+(1288850,7,2494.78,-5978.27,95.4998,0,0,5.71626,100,0),
+(1288850,8,2502.53,-5986.94,95.9192,0,0,5.42567,100,0),
+(1288850,9,2515.76,-5995.49,102.375,0,0,6.18436,100,0),
+(1288850,10,2523.18,-5991.62,103.452,0,0,0.858627,100,0),
+(1288850,11,2528.24,-5981.97,103.248,0,0,1.94326,100,0),
+(1288850,12,2521.05,-5969.02,105.047,0,0,1.68433,100,0),
+(1288850,13,2522.14,-5957.16,107.549,0,0,1.33718,100,0),
+(1288850,14,2522.25,-5950.23,109.716,0,0,2.07624,100,0),
+(1288850,15,2514.35,-5940.16,111.123,0,0,2.31107,100,0),
+(1288850,16,2504.78,-5932.21,115.134,0,0,3.00222,100,0),
+(1288850,17,2487.73,-5936.38,116.357,0,0,3.65803,100,0),
+(1288850,18,2473.76,-5938.02,115.203,0,0,2.57418,100,0),
+(1288850,19,2469.85,-5932.18,115.978,0,0,1.88931,100,0),
+(1288850,20,2465.38,-5916.21,113.31,0,0,2.5514,100,0),
+(1288850,21,2453.98,-5909.97,112.809,0,0,3.11693,100,0),
+(1288850,22,2437,-5915.94,112.788,0,0,3.14599,100,0),
+(1288850,23,2428.36,-5912.56,112.956,0,0,3.47665,100,0),
+(1288850,24,2419.72,-5916.33,111.72,0,0,3.57089,100,0),
+(1288850,25,2407.87,-5920.25,110.704,0,0,3.09023,100,0),
+(1288850,26,2382.72,-5912.66,109.618,0,0,2.8012,100,0),
+(1288850,27,2360.63,-5906.09,105.863,0,0,2.87974,100,0),
+(1288850,28,2339.74,-5900.61,102.166,0,0,3.0164,100,0),
+(1288850,29,2320.65,-5901.12,96.3481,0,0,3.36748,100,0),
+(1288850,30,2302.29,-5906.91,88.4851,0,0,3.71462,100,0),
+(1288850,31,2298.87,-5912.52,85.7672,0,0,4.15602,100,0),
+(1288850,32,2294.47,-5920.02,80.6317,0,0,4.48588,100,0),
+(1288850,33,2295.5,-5927.8,75.0694,0,0,4.50787,100,0),
+(1288850,34,2289.38,-5936.56,68.8048,0,0,4.35394,100,0),
+(1288850,35,2281.71,-5954.08,57.7201,0,0,4.07015,100,0),
+(1288850,36,2273.67,-5964.09,51.0012,0,0,3.82197,100,0),
+(1288850,37,2263.62,-5972.28,44.9642,0,0,3.50074,100,0),
+(1288850,38,2250.32,-5978.05,37.1378,0,0,3.68923,100,0),
+(1288850,39,2242.16,-5986.44,32.0029,0,0,3.9759,100,0),
+(1288850,40,2236.48,-5994.7,27.2984,0,0,4.15654,100,0),
+(1288850,41,2232.02,-6001.88,21.9415,0,0,4.15654,100,0),
+(1288850,42,2222.59,-6018.69,9.85442,0,0,4.25079,100,0),
+(1288850,43,2210.65,-6043.1,6.58405,0,0,4.27435,100,0),
+(1288850,44,2195.04,-6068.81,4.8415,0,0,4.29006,100,0),
+(1288850,45,2184.79,-6100.61,0.801771,0,0,4.45499,100,0),
+(1288850,46,2180.3,-6117.91,1.28701,0,0,4.35368,100,0),
+(1288850,47,2176.49,-6139.76,1.21043,0,0,4.53432,100,0),
+(1288850,48,2168.43,-6148.86,1.24682,0,0,3.76777,100,0),
+(1288850,49,2151.16,-6153.96,1.24645,0,0,3.43005,100,0),
+(1288850,50,2134,-6167.23,0.364198,0,0,4.12905,100,0),
+(1288850,51,2122.69,-6185.79,14.1288,0,0,4.1801,100,0),
+(1288850,52,2119.26,-6191.63,13.2701,2000,1188,4.1801,100,0);
+-- Scarlet Miner & Mine car #5 
+UPDATE `creature` SET `position_x` = 2477.604004, `position_y` = -5931.103027, `position_z` = 115.977074, `orientation` = 3.842377, `MovementType` = 2, `spawndist` = 0 WHERE `guid` = 128893;
+DELETE FROM `creature_addon` WHERE `guid` IN (128893);
+INSERT INTO `creature_addon` (`guid`, `mount`, `bytes1`, `bytes2`, `path_id`, auras) VALUES 
+(128893,0,0,1,1288930, "48356");
+DELETE FROM `waypoint_data` WHERE `id` IN (1288930);
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `action`, `orientation`, `action_chance`, `move_type`) VALUES
+(1288930,1,2477.604004,-5931.103027,115.977074,2000,0,3.84,100,0),
+(1288930,2,2469.85,-5932.18,115.978,0,0,1.9,100,0),
+(1288930,3,2465.38,-5916.21,113.31,0,0,2.6,100,0),
+(1288930,4,2453.98,-5909.97,112.809,0,0,3.11693,100,0),
+(1288930,5,2437,-5915.94,112.788,0,0,3.14599,100,0),
+(1288930,6,2428.36,-5912.56,112.956,0,0,3.47665,100,0),
+(1288930,7,2419.72,-5916.33,111.72,0,0,3.57089,100,0),
+(1288930,8,2407.87,-5920.25,110.704,0,0,3.09023,100,0),
+(1288930,9,2382.72,-5912.66,109.618,0,0,2.8012,100,0),
+(1288930,10,2360.63,-5906.09,105.863,0,0,2.87974,100,0),
+(1288930,11,2339.74,-5900.61,102.166,0,0,3.0164,100,0),
+(1288930,12,2320.65,-5901.12,96.3481,0,0,3.36748,100,0),
+(1288930,13,2302.29,-5906.91,88.4851,0,0,3.71462,100,0),
+(1288930,14,2298.87,-5912.52,85.7672,0,0,4.15602,100,0),
+(1288930,15,2294.47,-5920.02,80.6317,0,0,4.48588,100,0),
+(1288930,16,2295.5,-5927.8,75.0694,0,0,4.50787,100,0),
+(1288930,17,2289.38,-5936.56,68.8048,0,0,4.35394,100,0),
+(1288930,18,2281.71,-5954.08,57.7201,0,0,4.07015,100,0),
+(1288930,19,2273.67,-5964.09,51.0012,0,0,3.82197,100,0),
+(1288930,20,2263.62,-5972.28,44.9642,0,0,3.50074,100,0),
+(1288930,21,2250.32,-5978.05,37.1378,0,0,3.68923,100,0),
+(1288930,22,2242.16,-5986.44,32.0029,0,0,3.9759,100,0),
+(1288930,23,2236.48,-5994.7,27.2984,0,0,4.15654,100,0),
+(1288930,24,2232.02,-6001.88,21.9415,0,0,4.15654,100,0),
+(1288930,25,2222.59,-6018.69,9.85442,0,0,4.25079,100,0),
+(1288930,26,2210.65,-6043.1,6.58405,0,0,4.27435,100,0),
+(1288930,27,2195.04,-6068.81,4.8415,0,0,4.29006,100,0),
+(1288930,28,2184.79,-6100.61,0.801771,0,0,4.45499,100,0),
+(1288930,29,2180.3,-6117.91,1.28701,0,0,4.35368,100,0),
+(1288930,30,2176.49,-6139.76,1.21043,0,0,4.53432,100,0),
+(1288930,31,2168.43,-6148.86,1.24682,0,0,3.76777,100,0),
+(1288930,32,2151.16,-6153.96,1.24645,0,0,3.43005,100,0),
+(1288930,33,2134,-6167.23,0.364198,0,0,4.12905,100,0),
+(1288930,34,2122.69,-6185.79,14.1288,0,0,4.1801,100,0),
+(1288930,35,2119.26,-6191.63,13.2701,2000,1188,4.1801,100,0);
+-- Scarlet Miner & Mine car #6 
+UPDATE `creature` SET `position_x` = 2406.754639, `position_y` = -5931.366211, `position_z` = 112.795784, `orientation` = 1.730102 WHERE `guid` = 128873;
+UPDATE `creature` SET `position_x` = 2406.754639, `position_y` = -5931.366211, `position_z` = 112.795784, `orientation` = 1.730102, `MovementType` = 2, `spawndist` = 0 WHERE `guid` = 128898;
+DELETE FROM `creature_addon` WHERE `guid` IN (128898);
+INSERT INTO `creature_addon` (`guid`, `mount`, `bytes1`, `bytes2`, `path_id`, auras) VALUES 
+(128898,0,0,1,1288980, "48356");
+DELETE FROM `waypoint_data` WHERE `id` IN (1288980);
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `action`, `orientation`, `action_chance`, `move_type`) VALUES
+(1288980,1,2406.754639,-5931.366211,112.795784,2000,0,1.73,100,0),
+(1288980,2,2408.93,-5923.46,111.244,0,0,0.75,100,0),
+(1288980,3,2420.15,-5915.89,111.804,0,0,0.6,100,0),
+(1288980,4,2424.12,-5913.94,112.944,0,0,0.322753,100,0),
+(1288980,5,2429.91,-5913.57,112.917,0,0,6.02989,100,0),
+(1288980,6,2436.71,-5915.68,112.756,0,0,0.164542,100,0),
+(1288980,7,2454.24,-5910.7,112.815,0,0,6.00319,100,0),
+(1288980,8,2461.68,-5912.38,112.696,0,0,5.52956,100,0),
+(1288980,9,2466.62,-5920.92,113.937,0,0,5.10781,100,0),
+(1288980,10,2470.2,-5931.9,115.936,0,0,4.94288,100,0),
+(1288980,11,2471.25,-5946.04,114.238,0,0,3.91009,100,0),
+(1288980,12,2461.91,-5945.94,115.98,0,0,2.90478,100,0),
+(1288980,13,2442.28,-5941.64,118.664,2000,1188,3.00295,100,0);
+-- Scarlet Miner & Mine car #7
+UPDATE `creature` SET `position_x` = 2419.589111, `position_y` = -5899.963867, `position_z` = 113.110573, `orientation` = 5.496583 WHERE `guid` = 128874;
+UPDATE `creature` SET `position_x` = 2419.589111, `position_y` = -5899.963867, `position_z` = 113.110573, `orientation` = 5.496583, `MovementType` = 2, `spawndist` = 0 WHERE `guid` = 128899;
+DELETE FROM `creature_addon` WHERE `guid` IN (128899);
+INSERT INTO `creature_addon` (`guid`, `mount`, `bytes1`, `bytes2`, `path_id`, auras) VALUES 
+(128899,0,0,1,1288990, "48356");
+DELETE FROM `waypoint_data` WHERE `id` IN (1288990);
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `action`, `orientation`, `action_chance`, `move_type`) VALUES
+(1288990,1,2419.589111,-5899.963867,113.110573,2000,0,5.49658,100,0),
+(1288990,2,2424.73,-5905.68,113.469,0,0,4.6017,100,0),
+(1288990,3,2423.05,-5913.57,112.85,0,0,3.9,100,0),
+(1288990,4,2419.72,-5916.33,111.72,0,0,3.57089,100,0),
+(1288990,5,2407.87,-5920.25,110.704,0,0,3.09023,100,0),
+(1288990,6,2382.72,-5912.66,109.618,0,0,2.8012,100,0),
+(1288990,7,2360.63,-5906.09,105.863,0,0,2.87974,100,0),
+(1288990,8,2339.74,-5900.61,102.166,0,0,3.0164,100,0),
+(1288990,9,2320.65,-5901.12,96.3481,0,0,3.36748,100,0),
+(1288990,10,2302.29,-5906.91,88.4851,0,0,3.71462,100,0),
+(1288990,11,2298.87,-5912.52,85.7672,0,0,4.15602,100,0),
+(1288990,12,2294.47,-5920.02,80.6317,0,0,4.48588,100,0),
+(1288990,13,2295.5,-5927.8,75.0694,0,0,4.50787,100,0),
+(1288990,14,2289.38,-5936.56,68.8048,0,0,4.35394,100,0),
+(1288990,15,2281.71,-5954.08,57.7201,0,0,4.07015,100,0),
+(1288990,16,2273.67,-5964.09,51.0012,0,0,3.82197,100,0),
+(1288990,17,2263.62,-5972.28,44.9642,0,0,3.50074,100,0),
+(1288990,18,2250.32,-5978.05,37.1378,0,0,3.68923,100,0),
+(1288990,19,2242.16,-5986.44,32.0029,0,0,3.9759,100,0),
+(1288990,20,2236.48,-5994.7,27.2984,0,0,4.15654,100,0),
+(1288990,21,2232.02,-6001.88,21.9415,0,0,4.15654,100,0),
+(1288990,22,2222.59,-6018.69,9.85442,0,0,4.25079,100,0),
+(1288990,23,2210.65,-6043.1,6.58405,0,0,4.27435,100,0),
+(1288990,24,2195.04,-6068.81,4.8415,0,0,4.29006,100,0),
+(1288990,25,2184.79,-6100.61,0.801771,0,0,4.45499,100,0),
+(1288990,26,2180.3,-6117.91,1.28701,0,0,4.35368,100,0),
+(1288990,27,2176.49,-6139.76,1.21043,0,0,4.53432,100,0),
+(1288990,28,2168.43,-6148.86,1.24682,0,0,3.76777,100,0),
+(1288990,29,2151.16,-6153.96,1.24645,0,0,3.43005,100,0),
+(1288990,30,2134,-6167.23,0.364198,0,0,4.12905,100,0),
+(1288990,31,2122.69,-6185.79,14.1288,0,0,4.1801,100,0),
+(1288990,32,2119.26,-6191.63,13.2701,2000,1188,4.1801,100,0);
+-- Scarlet Miner & Mine car #8
+UPDATE `creature` SET `position_x` = 2535.325195, `position_y` = -5944.641602, `position_z` = 109.437996, `orientation` = 3.43 WHERE `guid` = 128864;
+UPDATE `creature` SET `position_x` = 2535.325195, `position_y` = -5944.641602, `position_z` = 109.437996, `orientation` = 3.43, `MovementType` = 2, `spawndist` = 0 WHERE `guid` = 128889;
+DELETE FROM `creature_addon` WHERE `guid` IN (128889);
+INSERT INTO `creature_addon` (`guid`, `mount`, `bytes1`, `bytes2`, `path_id`, auras) VALUES 
+(128889,0,0,1,1288890, "48356");
+DELETE FROM `waypoint_data` WHERE `id` IN (1288890);
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `action`, `orientation`, `action_chance`, `move_type`) VALUES
+(1288890,1,2535.325195,-5944.641602,109.438,2000,0,3.43,100,0),
+(1288890,2,2524.54,-5946.4,109.71,0,0,2.77,100,0),
+(1288890,3,2514.45,-5939.26,111.185,0,0,2.47,100,0),
+(1288890,4,2505.28,-5932.11,115.146,0,0,3.02253,100,0),
+(1288890,5,2487.64,-5937.46,116.247,0,0,3.55975,100,0),
+(1288890,6,2476.57,-5939.55,114.837,0,0,2.58585,100,0),
+(1288890,7,2470.52,-5935.27,115.852,0,0,1.92881,100,0),
+(1288890,8,2469.85,-5932.18,115.978,0,0,1.88931,100,0),
+(1288890,9,2465.38,-5916.21,113.31,0,0,2.5514,100,0),
+(1288890,10,2453.98,-5909.97,112.809,0,0,3.11693,100,0),
+(1288890,11,2437,-5915.94,112.788,0,0,3.14599,100,0),
+(1288890,12,2428.36,-5912.56,112.956,0,0,3.47665,100,0),
+(1288890,13,2419.72,-5916.33,111.72,0,0,3.57089,100,0),
+(1288890,14,2407.87,-5920.25,110.704,0,0,3.09023,100,0),
+(1288890,15,2382.72,-5912.66,109.618,0,0,2.8012,100,0),
+(1288890,16,2360.63,-5906.09,105.863,0,0,2.87974,100,0),
+(1288890,17,2339.74,-5900.61,102.166,0,0,3.0164,100,0),
+(1288890,18,2320.65,-5901.12,96.3481,0,0,3.36748,100,0),
+(1288890,19,2302.29,-5906.91,88.4851,0,0,3.71462,100,0),
+(1288890,20,2298.87,-5912.52,85.7672,0,0,4.15602,100,0),
+(1288890,21,2294.47,-5920.02,80.6317,0,0,4.48588,100,0),
+(1288890,22,2295.5,-5927.8,75.0694,0,0,4.50787,100,0),
+(1288890,23,2289.38,-5936.56,68.8048,0,0,4.35394,100,0),
+(1288890,24,2281.71,-5954.08,57.7201,0,0,4.07015,100,0),
+(1288890,25,2273.67,-5964.09,51.0012,0,0,3.82197,100,0),
+(1288890,26,2263.62,-5972.28,44.9642,0,0,3.50074,100,0),
+(1288890,27,2250.32,-5978.05,37.1378,0,0,3.68923,100,0),
+(1288890,28,2242.16,-5986.44,32.0029,0,0,3.9759,100,0),
+(1288890,29,2236.48,-5994.7,27.2984,0,0,4.15654,100,0),
+(1288890,30,2232.02,-6001.88,21.9415,0,0,4.15654,100,0),
+(1288890,31,2222.59,-6018.69,9.85442,0,0,4.25079,100,0),
+(1288890,32,2210.65,-6043.1,6.58405,0,0,4.27435,100,0),
+(1288890,33,2195.04,-6068.81,4.8415,0,0,4.29006,100,0),
+(1288890,34,2184.79,-6100.61,0.801771,0,0,4.45499,100,0),
+(1288890,35,2180.3,-6117.91,1.28701,0,0,4.35368,100,0),
+(1288890,36,2176.49,-6139.76,1.21043,0,0,4.53432,100,0),
+(1288890,37,2168.43,-6148.86,1.24682,0,0,3.76777,100,0),
+(1288890,38,2151.16,-6153.96,1.24645,0,0,3.43005,100,0),
+(1288890,39,2134,-6167.23,0.364198,0,0,4.12905,100,0),
+(1288890,40,2122.69,-6185.79,14.1288,0,0,4.1801,100,0),
+(1288890,41,2119.26,-6191.63,13.2701,2000,1188,4.1801,100,0);
+-- Scarlet Miner & Mine car #9
+UPDATE `creature` SET `position_x` = 2453.786133, `position_y` = -5953.487793, `position_z` = 95.258797, `orientation` = 4.55 WHERE `guid` = 128870;
+UPDATE `creature` SET `position_x` = 2453.786133, `position_y` = -5953.487793, `position_z` = 95.258797, `orientation` = 4.55, `MovementType` = 2, `spawndist` = 0 WHERE `guid` = 128895;
+DELETE FROM `creature_addon` WHERE `guid` IN (128895);
+INSERT INTO `creature_addon` (`guid`, `mount`, `bytes1`, `bytes2`, `path_id`, auras) VALUES 
+(128895,0,0,1,1288950, "48356");
+DELETE FROM `waypoint_data` WHERE `id` IN (1288950);
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `action`, `orientation`, `action_chance`, `move_type`) VALUES
+(1288950,1,2453.786133,-5953.487793,95.258797,2000,0,4.55,100,0),
+(1288950,2,2452.72,-5967.06,94.948,0,0,3.58,100,0),
+(1288950,3,2437.21,-5970.83,95.8699,0,0,2.94,100,0),
+(1288950,4,2423.33,-5964.13,96.3004,0,0,2.34035,100,0),
+(1288950,5,2418.46,-5954.75,98.1128,0,0,1.57615,100,0),
+(1288950,6,2421.02,-5945.06,96.5866,0,0,0.982392,100,0),
+(1288950,7,2424.15,-5940.43,95.9135,0,0,0.759339,100,0),
+(1288950,8,2438.46,-5930.17,96.4525,0,0,0.831971,100,0),
+(1288950,9,2443.21,-5922.16,99.5292,0,0,1.45604,100,0),
+(1288950,10,2442.92,-5913.71,102.054,0,0,1.88668,100,0),
+(1288950,11,2440.51,-5904.33,103.104,0,0,1.76965,100,0),
+(1288950,12,2435.25,-5889.95,104.966,0,0,2.12387,100,0),
+(1288950,13,2431.46,-5885.3,104.595,0,0,2.69687,100,0),
+(1288950,14,2424.06,-5886.49,104.586,0,0,3.56276,100,0),
+(1288950,15,2416.01,-5891.31,104.585,2000,1188,3.657,100,0);
+-- Scarlet Miner & Mine car #10
+UPDATE `creature` SET `position_x` = 2538.022949, `position_y` = -5995.528809, `position_z` = 103.005615, `orientation` = 2.9 WHERE `guid` = 128876;
+UPDATE `creature` SET `position_x` = 2538.022949, `position_y` = -5995.528809, `position_z` = 103.005615, `orientation` = 2.9, `MovementType` = 2, `spawndist` = 0 WHERE `guid` = 128901;
+DELETE FROM `creature_addon` WHERE `guid` IN (128901);
+INSERT INTO `creature_addon` (`guid`, `mount`, `bytes1`, `bytes2`, `path_id`, auras) VALUES 
+(128901,0,0,1,1289010, "48356");
+DELETE FROM `waypoint_data` WHERE `id` IN (1289010);
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `action`, `orientation`, `action_chance`, `move_type`) VALUES
+(1289010,1,2538.022949,-5995.528809,103.005615,2000,0,2.9,100,0),
+(1289010,2,2531.93,-5989.03,102.994,0,0,2.24,100,0),
+(1289010,3,2523.14,-5974.86,104.929,0,0,1.94,100,0),
+(1289010,4,2520.59,-5965.89,105.946,0,0,1.59666,100,0),
+(1289010,5,2521.93,-5958.41,107.339,0,0,1.40423,100,0),
+(1289010,6,2522.63,-5951.68,109.591,0,0,1.71447,100,0),
+(1289010,7,2518.94,-5943.86,110.237,0,0,2.42133,100,0),
+(1289010,8,2509.7,-5935.12,113.338,0,0,2.58704,100,0),
+(1289010,9,2504.82,-5932.35,115.145,0,0,2.85644,100,0),
+(1289010,10,2494.22,-5933.43,115.605,0,0,3.53504,100,0),
+(1289010,11,2488.27,-5937.53,116.217,0,0,3.72668,100,0),
+(1289010,12,2481.15,-5940.7,115.362,0,0,2.90044,100,0),
+(1289010,13,2473.54,-5938.41,115.133,0,0,2.57702,100,0),
+(1289010,14,2469.97,-5932.41,115.97,0,0,1.90066,100,0),
+(1289010,15,2469.85,-5932.18,115.978,0,0,1.88931,100,0),
+(1289010,16,2465.38,-5916.21,113.31,0,0,2.5514,100,0),
+(1289010,17,2453.98,-5909.97,112.809,0,0,3.11693,100,0),
+(1289010,18,2437,-5915.94,112.788,0,0,3.14599,100,0),
+(1289010,19,2428.36,-5912.56,112.956,0,0,3.47665,100,0),
+(1289010,20,2419.72,-5916.33,111.72,0,0,3.57089,100,0),
+(1289010,21,2407.87,-5920.25,110.704,0,0,3.09023,100,0),
+(1289010,22,2382.72,-5912.66,109.618,0,0,2.8012,100,0),
+(1289010,23,2360.63,-5906.09,105.863,0,0,2.87974,100,0),
+(1289010,24,2339.74,-5900.61,102.166,0,0,3.0164,100,0),
+(1289010,25,2320.65,-5901.12,96.3481,0,0,3.36748,100,0),
+(1289010,26,2302.29,-5906.91,88.4851,0,0,3.71462,100,0),
+(1289010,27,2298.87,-5912.52,85.7672,0,0,4.15602,100,0),
+(1289010,28,2294.47,-5920.02,80.6317,0,0,4.48588,100,0),
+(1289010,29,2295.5,-5927.8,75.0694,0,0,4.50787,100,0),
+(1289010,30,2289.38,-5936.56,68.8048,0,0,4.35394,100,0),
+(1289010,31,2281.71,-5954.08,57.7201,0,0,4.07015,100,0),
+(1289010,32,2273.67,-5964.09,51.0012,0,0,3.82197,100,0),
+(1289010,33,2263.62,-5972.28,44.9642,0,0,3.50074,100,0),
+(1289010,34,2250.32,-5978.05,37.1378,0,0,3.68923,100,0),
+(1289010,35,2242.16,-5986.44,32.0029,0,0,3.9759,100,0),
+(1289010,36,2236.48,-5994.7,27.2984,0,0,4.15654,100,0),
+(1289010,37,2232.02,-6001.88,21.9415,0,0,4.15654,100,0),
+(1289010,38,2222.59,-6018.69,9.85442,0,0,4.25079,100,0),
+(1289010,39,2210.65,-6043.1,6.58405,0,0,4.27435,100,0),
+(1289010,40,2195.04,-6068.81,4.8415,0,0,4.29006,100,0),
+(1289010,41,2184.79,-6100.61,0.801771,0,0,4.45499,100,0),
+(1289010,42,2180.3,-6117.91,1.28701,0,0,4.35368,100,0),
+(1289010,43,2176.49,-6139.76,1.21043,0,0,4.53432,100,0),
+(1289010,44,2168.43,-6148.86,1.24682,0,0,3.76777,100,0),
+(1289010,45,2151.16,-6153.96,1.24645,0,0,3.43005,100,0),
+(1289010,46,2134,-6167.23,0.364198,0,0,4.12905,100,0),
+(1289010,47,2122.69,-6185.79,14.1288,0,0,4.1801,100,0),
+(1289010,48,2119.26,-6191.63,13.2701,2000,1188,4.1801,100,0);
+-- Mine Car
+UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=28821;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=28821 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
+(28821,0,0,0,1,0,100,0,5000,5000,5000,5000,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Mine Car - Ooc - Despawn"),
+(28821,0,1,0,23,0,100,0,52414,0,5000,5000,86,52414,0,19,28822,0,0,1,0,0,0,0,0,0,0,"Mine Car - On missing aura 52414 - cross cast 52414"),
+(28821,0,2,0,8,0,100,0,52414,0,5000,5000,29,0,3,0,0,0,0,7,0,0,0,0,0,0,0,"Mine Car - On spell hit - follow");
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceEntry`=28821;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(22, 1, 28821, 0, 0, 29, 1, 28822, 10, 0, 1, 0, 0, '', 'Mine Car Despawn if no miner at 10 yards');
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=52414;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
+(13,1,52414,0,31,3,28821,0,0,'','Spell ffect 52414 targets entry 28821');
+DELETE FROM `creature_formations` WHERE `leaderGUID` IN (128885, 128889, 128893, 128894, 128895, 128898, 128899, 128901, 128904, 128905);
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES
+(128885,128885,0,0,512,0,0),
+(128885,128860,3,0,512,0,0),
+(128889,128889,0,0,512,0,0),
+(128889,128864,3,0,512,0,0),
+(128893,128893,0,0,512,0,0),
+(128893,128868,3,0,512,0,0),
+(128894,128894,0,0,512,0,0),
+(128894,128869,3,0,512,0,0),
+(128895,128895,0,0,512,0,0),
+(128895,128870,3,0,512,0,0),
+(128898,128898,0,0,512,0,0),
+(128898,128873,3,0,512,0,0),
+(128899,128899,0,0,512,0,0),
+(128899,128874,3,0,512,0,0),
+(128901,128901,0,0,512,0,0),
+(128901,128876,3,0,512,0,0),
+(128904,128904,0,0,512,0,0),
+(128904,128879,3,0,512,0,0),
+(128905,128905,0,0,512,0,0),
+(128905,128880,3,0,512,0,0);