diff options
| -rw-r--r-- | sql/updates/world/master/2020_07_17_19_world_2017_06_25_07_world.sql | 128 |
1 files changed, 128 insertions, 0 deletions
diff --git a/sql/updates/world/master/2020_07_17_19_world_2017_06_25_07_world.sql b/sql/updates/world/master/2020_07_17_19_world_2017_06_25_07_world.sql new file mode 100644 index 00000000000..ed6f35b66c8 --- /dev/null +++ b/sql/updates/world/master/2020_07_17_19_world_2017_06_25_07_world.sql @@ -0,0 +1,128 @@ +-- Right and Left Camp Attack +DELETE FROM `creature_addon` WHERE `guid` IN(SELECT `guid` FROM `creature` WHERE `id` IN(38493, 38505)); +DELETE FROM `creature_formations` WHERE `leaderGUID` IN(111997,112005); +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(111997, 111997, 0, 0, 3, 0, 0), +(111997, 111992, 0, 0, 3, 0, 0), +(111997, 111993, 0, 0, 3, 0, 0), +(111997, 111994, 0, 0, 3, 0, 0), +(111997, 111996, 0, 0, 3, 0, 0), +(111997, 111998, 0, 0, 3, 0, 0), +(111997, 111999, 0, 0, 3, 0, 0), +(112005, 112005, 0, 0, 3, 0, 0), +(112005, 112000, 0, 0, 3, 0, 0), +(112005, 112001, 0, 0, 3, 0, 0), +(112005, 112002, 0, 0, 3, 0, 0), +(112005, 112003, 0, 0, 3, 0, 0), +(112005, 112004, 0, 0, 3, 0, 0); + +DELETE FROM `creature` WHERE `id` IN(38493, 38505); +DELETE FROM `creature_addon` WHERE `guid` IN(123535, 123528); +DELETE FROM `creature` WHERE `id`=31139 AND `guid` IN(123535, 123528); +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnDifficulties`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `curhealth`, `curmana`, `MovementType`) VALUES +(111992, 38493, 571, '0', 0, 0, 0, 0, 1, 5834.96, 2190.04, 636.042, 5.70036, 300, 0, 0, 0, 0), +(111993, 38493, 571, '0', 0, 0, 0, 0, 1, 5831.74, 2177.88, 636.042, 0.646328, 300, 0, 0, 0, 0), +(111994, 38493, 571, '0', 0, 0, 0, 0, 1, 5849.19, 2175.6, 636.042, 1.54954, 300, 0, 0, 0, 0), +(111995, 38493, 571, '0', 0, 0, 0, 0, 1, 5847.05, 2145.87, 636.042, 6.27764, 300, 0, 0, 0, 0), +(111996, 38493, 571, '0', 0, 0, 0, 0, 1, 5838.32, 2201.24, 636.042, 5.67288, 300, 0, 0, 0, 0), +(111997, 38493, 571, '0', 0, 0, 0, 0, 1, 5872.86, 2142.04, 636.042, 2.01685, 300, 0, 0, 0, 2), +(111998, 38505, 571, '0', 0, 0, 0, 0, 1, 5845.64, 2183.07, 636.042, 2.91221, 300, 0, 0, 0, 0), +(111999, 38505, 571, '0', 0, 0, 0, 0, 1, 5842.6, 2189.15, 636.042, 4.322, 300, 0, 0, 0, 0), +(112000, 38505, 571, '0', 0, 0, 0, 0, 1, 5922.95, 2039.25, 636.041, 1.52037, 300, 0, 0, 0, 0), +(112001, 38505, 571, '0', 0, 0, 0, 0, 1, 5908.02, 2033.22, 636.041, 1.69708, 300, 0, 0, 0, 0), +(112002, 38505, 571, '0', 0, 0, 0, 0, 1, 5894.38, 2032.71, 636.041, 0.428661, 300, 0, 0, 0, 0), +(112003, 38505, 571, '0', 0, 0, 0, 0, 1, 5882.94, 2054.38, 636.041, 1.33187, 300, 0, 0, 0, 0), +(112004, 38505, 571, '0', 0, 0, 0, 0, 1, 5905.04, 2055.25, 636.041, 4.88187, 300, 0, 0, 0, 0), +(112005, 38493, 571, '0', 0, 0, 0, 0, 1, 5910.19, 2068.75, 636.041, 5.33347, 300, 0, 0, 0, 2); + +DELETE FROM `creature_addon` WHERE `guid` IN(111996, 111997, 112005); +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(111996, 0, 29937, 0, 4097, 0, ''), +(111997, 1119970, 29937, 0, 4097, 0, ''), +(112005, 1120050, 29937, 0, 4097, 0, ''); + +DELETE FROM `waypoint_data` WHERE `id` IN (1119970,1120050); +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(1119970, 1, 5870.29, 2147.65, 636.042, 0, 0, 0, 0, 100, 0), +(1119970, 2, 5867.22, 2155.17, 636.042, 0, 0, 0, 0, 100, 0), +(1119970, 3, 5865.35, 2163.15, 636.042, 0, 0, 0, 0, 100, 0), +(1119970, 4, 5864.42, 2172.41, 636.042, 0, 0, 0, 0, 100, 0), +(1119970, 5, 5865.06, 2179.38, 636.042, 0, 0, 0, 0, 100, 0), +(1119970, 6, 5867.25, 2189.65, 636.042, 0, 0, 0, 0, 100, 0), +(1119970, 7, 5870.01, 2198.61, 636.042, 0, 0, 0, 0, 100, 0), +(1119970, 8, 5874.43, 2205.42, 636.042, 0, 0, 0, 0, 100, 0), +(1119970, 9, 5882.62, 2205.31, 636.042, 0, 0, 0, 0, 100, 0), +(1119970, 10, 5889.66, 2201.28, 636.042, 0, 0, 0, 0, 100, 0), +(1119970, 11, 5893.07, 2195.17, 636.042, 0, 0, 0, 0, 100, 0), +(1119970, 12, 5890.64, 2188.6, 636.042, 0, 0, 0, 0, 100, 0), +(1119970, 13, 5887.31, 2182.44, 636.042, 0, 0, 0, 0, 100, 0), +(1119970, 14, 5881.91, 2174.78, 636.042, 0, 0, 0, 0, 100, 0), +(1119970, 15, 5879.15, 2167.14, 636.042, 0, 0, 0, 0, 100, 0), +(1119970, 16, 5880.75, 2159.18, 636.042, 0, 0, 0, 0, 100, 0), +(1119970, 17, 5882.9, 2155.02, 636.042, 0, 0, 0, 0, 100, 0), +(1119970, 18, 5887.01, 2146.66, 636.042, 0, 0, 0, 0, 100, 0), +(1119970, 19, 5886.56, 2142.06, 636.042, 0, 0, 0, 0, 100, 0), +(1119970, 20, 5884.42, 2136.59, 636.042, 0, 0, 0, 0, 100, 0), +(1119970, 21, 5880.85, 2133.55, 636.042, 0, 0, 0, 0, 100, 0), +(1119970, 22, 5878.56, 2133.22, 636.042, 0, 0, 0, 0, 100, 0), +(1119970, 23, 5875.22, 2134.27, 636.042, 0, 0, 0, 0, 100, 0), +(1119970, 24, 5873.69, 2135.99, 636.042, 0, 0, 0, 0, 100, 0), +(1119970, 25, 5872.12, 2140.42, 636.042, 0, 0, 0, 0, 100, 0), +(1120050, 1, 5913.05, 2065.04, 636.041, 0, 0, 0, 0, 100, 0), +(1120050, 2, 5917.99, 2060.07, 636.041, 0, 0, 0, 0, 100, 0), +(1120050, 3, 5925.71, 2054.87, 636.041, 0, 0, 0, 0, 100, 0), +(1120050, 4, 5936.31, 2049.94, 636.041, 0, 0, 0, 0, 100, 0), +(1120050, 5, 5946.34, 2046.82, 636.041, 0, 0, 0, 0, 100, 0), +(1120050, 6, 5954.52, 2046.6, 636.041, 0, 0, 0, 0, 100, 0), +(1120050, 7, 5960.7, 2050.03, 636.041, 0, 0, 0, 0, 100, 0), +(1120050, 8, 5963.44, 2055.16, 636.041, 0, 0, 0, 0, 100, 0), +(1120050, 9, 5963.36, 2059.85, 636.041, 0, 0, 0, 0, 100, 0), +(1120050, 10, 5961.52, 2065.36, 636.041, 0, 0, 0, 0, 100, 0), +(1120050, 11, 5954.64, 2069.68, 636.041, 0, 0, 0, 0, 100, 0), +(1120050, 12, 5946.58, 2070.59, 636.041, 0, 0, 0, 0, 100, 0), +(1120050, 13, 5937.28, 2071.07, 636.041, 0, 0, 0, 0, 100, 0), +(1120050, 14, 5929.96, 2074.59, 636.041, 0, 0, 0, 0, 100, 0), +(1120050, 15, 5923.44, 2081.23, 636.041, 0, 0, 0, 0, 100, 0), +(1120050, 16, 5918.98, 2089.4, 636.041, 0, 0, 0, 0, 100, 0), +(1120050, 17, 5916.49, 2093.29, 636.041, 0, 0, 0, 0, 100, 0), +(1120050, 18, 5913.62, 2095.3, 636.041, 0, 0, 0, 0, 100, 0), +(1120050, 19, 5910.21, 2096.08, 636.041, 0, 0, 0, 0, 100, 0), +(1120050, 20, 5908.02, 2095.35, 636.041, 0, 0, 0, 0, 100, 0), +(1120050, 21, 5905.89, 2094.44, 636.041, 0, 0, 0, 0, 100, 0), +(1120050, 22, 5903.17, 2092.24, 636.041, 0, 0, 0, 0, 100, 0), +(1120050, 23, 5901.87, 2089.06, 636.041, 0, 0, 0, 0, 100, 0), +(1120050, 24, 5901.34, 2085.6, 636.041, 0, 0, 0, 0, 100, 0), +(1120050, 25, 5903.01, 2079.96, 636.041, 0, 0, 0, 0, 100, 0), +(1120050, 26, 5905.72, 2074.75, 636.041, 0, 0, 0, 0, 100, 0), +(1120050, 27, 5909.18, 2070.08, 636.041, 0, 0, 0, 0, 100, 0); + +UPDATE `creature_template` SET `AIName`='SmartAI', `ScriptName`='' WHERE `entry` IN(38493, 31139, 31147); +DELETE FROM `smart_scripts` WHERE `entryorguid` IN(31139, 31147, 38493, -111996, -112005, -111992, -111993, -111994, -111998, -111999, -111997) AND `source_type`=0; +DELETE FROM `smart_scripts` WHERE `entryorguid` IN(38493*100, 38493*100+1) AND `source_type`=9; +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 +(-111996, 0, 0, 0, 60, 0, 100, 0, 180000, 180000, 180000, 180000, 80, 38493*100, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Cruasder - On Update - Run Script'), +(38493*100, 9, 7, 0, 0, 0, 100, 0, 8000, 8000, 0, 0, 12, 31139, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 5940.53, 2227.89, 636.05, 3.58, 'Argent Cruasder - On Script - Summon Creature Pustulent Horror'), +(38493*100, 9, 8, 0, 0, 0, 100, 0, 6000, 6000, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 5940.53, 2227.89, 636.05, 3.58, 'Argent Cruasder - On Script - Summon Creature Vicious Geist'), +(38493*100, 9, 9, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 5940.53, 2227.89, 636.05, 3.58, 'Argent Cruasder - On Script - Summon Creature Vicious Geist'), +(38493*100, 9, 10, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 5943.53, 2227.89, 636.05, 3.58, 'Argent Cruasder - On Script - Summon Creature Vicious Geist'), +(38493*100, 9, 11, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 5937.53, 2227.89, 636.05, 3.58, 'Argent Cruasder - On Script - Summon Creature Vicious Geist'), +(38493*100, 9, 12, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 5940.53, 2230.89, 636.05, 3.58, 'Argent Cruasder - On Script - Summon Creature Vicious Geist'), +(38493*100, 9, 13, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 5940.53, 2224.89, 636.05, 3.58, 'Argent Cruasder - On Script - Summon Creature Vicious Geist'), +(38493*100, 9, 14, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 5943.53, 2230.89, 636.05, 3.58, 'Argent Cruasder - On Script - Summon Creature Vicious Geist'), +(38493*100, 9, 15, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 5935.53, 2225.89, 636.05, 3.58, 'Argent Cruasder - On Script - Summon Creature Vicious Geist'), +(38493*100, 9, 16, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 5941.53, 2222.89, 636.05, 3.58, 'Argent Cruasder - On Script - Summon Creature Vicious Geist'), +(-112005, 0, 0, 0, 60, 0, 100, 0, 180000, 180000, 180000, 180000, 80, 38493*100+1, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Cruasder - On Update - Run Script'), +(38493*100+1, 9, 0, 0, 0, 0, 100, 0, 8000, 8000, 0, 0, 12, 31139, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 6018.40, 2091.17, 636.05, 3.47, 'Argent Cruasder - On Script - Summon Creature Pustulent Horror'), +(38493*100+1, 9, 1, 0, 0, 0, 100, 0, 6000, 6000, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 6018.40, 2091.17, 636.05, 3.47, 'Argent Cruasder - On Script - Summon Creature Vicious Geist'), +(38493*100+1, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 6018.40, 2093.17, 636.05, 3.47, 'Argent Cruasder - On Script - Summon Creature Vicious Geist'), +(38493*100+1, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 6015.40, 2092.17, 636.05, 3.47, 'Argent Cruasder - On Script - Summon Creature Vicious Geist'), +(38493*100+1, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 6022.40, 2091.17, 636.05, 3.47, 'Argent Cruasder - On Script - Summon Creature Vicious Geist'), +(38493*100+1, 9, 5, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 6019.40, 2088.17, 636.05, 3.47, 'Argent Cruasder - On Script - Summon Creature Vicious Geist'), +(38493*100+1, 9, 6, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 6017.40, 2094.17, 636.05, 3.47, 'Argent Cruasder - On Script - Summon Creature Vicious Geist'), +(38493*100+1, 9, 7, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 6020.40, 2095.17, 636.05, 3.47, 'Argent Cruasder - On Script - Summon Creature Vicious Geist'), +(38493*100+1, 9, 8, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 6014.40, 2090.17, 636.05, 3.47, 'Argent Cruasder - On Script - Summon Creature Vicious Geist'), +(38493*100+1, 9, 9, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 6015.40, 2087.17, 636.05, 3.47, 'Argent Cruasder - On Script - Summon Creature Vicious Geist'), +(31139, 0, 0, 0, 54, 0, 100, 0, 0, 0, 0, 0, 114, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 100, 0, 0, 'Pustulent Horror - Is Summoned - Move offset'), +(31139, 0, 1, 0, 0, 0, 100, 512, 3000, 5000, 3000, 7000, 11, 28405, 2, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Pustulent Horror - IC - Cast Knock Back'), +(31139, 0, 2, 0, 0, 0, 100, 512, 4000, 6000, 5000, 9000, 11, 63546, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Pustulent Horror - IC - Cast Stomp'), +(31147, 0, 0, 0, 54, 0, 100, 0, 0, 0, 0, 0, 114, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 100, 0, 0, 'Vicious Geist - Is Summoned - Move offset'); |