From e7088d6ec82a0db15d87b9657eb6e7e21be07c50 Mon Sep 17 00:00:00 2001 From: Malcrom Date: Mon, 28 Jul 2014 13:27:27 -0230 Subject: Rename 2014_07_28_07_world_misc.sql to 2014_07_28_08_world_misc.sql --- sql/updates/world/2014_07_28_07_world_misc.sql | 160 ------------------------- sql/updates/world/2014_07_28_08_world_misc.sql | 160 +++++++++++++++++++++++++ 2 files changed, 160 insertions(+), 160 deletions(-) delete mode 100644 sql/updates/world/2014_07_28_07_world_misc.sql create mode 100644 sql/updates/world/2014_07_28_08_world_misc.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2014_07_28_07_world_misc.sql b/sql/updates/world/2014_07_28_07_world_misc.sql deleted file mode 100644 index f1f13e76eec..00000000000 --- a/sql/updates/world/2014_07_28_07_world_misc.sql +++ /dev/null @@ -1,160 +0,0 @@ --- Pathing for Sparik Entry: 19012 -SET @NPC := 68323; -SET @PATH := @NPC * 10; -UPDATE `creature` SET `equipment_id`=1,`spawndist`=0,`MovementType`=2,`position_x`=-2539.584,`position_y`=7356.25,`position_z`=7.047175 WHERE `guid`=@NPC; -DELETE FROM `creature_addon` WHERE `guid`=@NPC; -INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`,`emote`) VALUES (@NPC,@PATH,257,0, '', 233); -DELETE FROM `waypoint_data` WHERE `id`=@PATH; -INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES -(@PATH,1,-2539.584,7356.25,7.047175,0,0,0,0,100,0), -(@PATH,2,-2542.437,7364.194,7.077205,0,0,0,0,100,0), -(@PATH,3,-2541.9,7364.772,7.012752,0,45000,0,0,100,0), -(@PATH,4,-2539.584,7356.25,7.047175,0,0,0,0,100,0), -(@PATH,5,-2533.325,7352.424,9.283463,0,0,0,0,100,0), -(@PATH,6,-2530.663,7354.053,9.283456,0,60000,0,0,100,0); - -DELETE FROM `creature_equip_template` WHERE `entry` IN (19012,17134); -INSERT INTO `creature_equip_template` (`entry`,`id`,`itemEntry1`,`itemEntry2`,`itemEntry3`,`VerifiedBuild`) VALUES -(19012,1,5956,13611,0,18414), -(17134,1,3326,0,0,18414), -(17134,2,5292,0,0,18414), -(17134,3,5293,0,0,18414), -(17134,4,5300,0,0,18414), -(17134,5,5301,0,0,18414), -(17134,6,5491,0,0,18414), -(17134,7,17942,0,0,18414); - --- Pathing for Boulderfist Crusher Entry: 17134 -SET @NPC := 60060; -SET @PATH := @NPC * 10; -UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-2257.554,`position_y`=6220.683,`position_z`=44.19547 WHERE `guid`=@NPC; -DELETE FROM `creature_addon` WHERE `guid`=@NPC; -INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, ''); -DELETE FROM `waypoint_data` WHERE `id`=@PATH; -INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES -(@PATH,1,-2257.554,6220.683,44.19547,0,0,0,0,100,0), -(@PATH,2,-2269.54,6185.135,50.54529,0,0,0,0,100,0), -(@PATH,3,-2300.504,6160.397,57.35026,0,0,0,0,100,0), -(@PATH,4,-2333.537,6174.551,51.46076,0,0,0,0,100,0), -(@PATH,5,-2354.695,6165.477,54.33383,0,0,0,0,100,0), -(@PATH,6,-2353.252,6135.473,60.3641,0,0,0,0,100,0), -(@PATH,7,-2345.113,6126.771,60.89935,0,0,0,0,100,0), -(@PATH,8,-2353.252,6135.473,60.3641,0,0,0,0,100,0), -(@PATH,9,-2354.915,6165.381,54.32211,0,0,0,0,100,0), -(@PATH,10,-2333.537,6174.551,51.46076,0,0,0,0,100,0), -(@PATH,11,-2300.504,6160.397,57.35026,0,0,0,0,100,0), -(@PATH,12,-2269.54,6185.135,50.54529,0,0,0,0,100,0); - --- Pathing for Boulderfist Crusher Entry: 17134 -SET @NPC := 60059; -SET @PATH := @NPC * 10; -UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-2399.844,`position_y`=6147.982,`position_z`=71.06328 WHERE `guid`=@NPC; -DELETE FROM `creature_addon` WHERE `guid`=@NPC; -INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, ''); -DELETE FROM `waypoint_data` WHERE `id`=@PATH; -INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES -(@PATH,1,-2399.844,6147.982,71.06328,0,0,0,0,100,0), -(@PATH,2,-2432.956,6121.422,83.23274,0,0,0,0,100,0), -(@PATH,3,-2466.083,6121.511,88.61314,0,0,0,0,100,0), -(@PATH,4,-2481.856,6120.785,91.89808,0,0,0,0,100,0), -(@PATH,5,-2498.95,6129.08,92.34127,0,0,0,0,100,0), -(@PATH,6,-2509.331,6142.653,93.18784,0,0,0,0,100,0), -(@PATH,7,-2498.272,6119,92.22591,0,0,0,0,100,0), -(@PATH,8,-2478.536,6077.883,93.76772,0,0,0,0,100,0), -(@PATH,9,-2465.792,6100.151,92.3082,0,0,0,0,100,0), -(@PATH,10,-2448.861,6127.569,83.04636,0,0,0,0,100,0), -(@PATH,11,-2448.847,6140.451,77.72874,0,0,0,0,100,0), -(@PATH,12,-2474.902,6153.139,63.35086,0,0,0,0,100,0), -(@PATH,13,-2500.071,6186.787,60.56055,0,0,0,0,100,0), -(@PATH,14,-2533.038,6182.577,60.19934,0,0,0,0,100,0), -(@PATH,15,-2541.146,6187.5,60.79309,0,0,0,0,100,0), -(@PATH,16,-2500.569,6181.5,60.06873,0,0,0,0,100,0), -(@PATH,17,-2466.607,6169.582,58.25665,0,0,0,0,100,0), -(@PATH,18,-2447.577,6166.336,54.24046,0,0,0,0,100,0), -(@PATH,19,-2450.868,6199.792,31.97747,0,0,0,0,100,0), -(@PATH,20,-2470.541,6233.041,30.6633,0,0,0,0,100,0), -(@PATH,21,-2466.961,6261.01,31.04571,0,0,0,0,100,0), -(@PATH,22,-2499.331,6266.069,27.68829,0,0,0,0,100,0), -(@PATH,23,-2466.961,6261.01,31.04571,0,0,0,0,100,0), -(@PATH,24,-2470.675,6233.3,30.707,0,0,0,0,100,0), -(@PATH,25,-2450.868,6199.792,31.97747,0,0,0,0,100,0), -(@PATH,26,-2447.577,6166.336,54.24046,0,0,0,0,100,0), -(@PATH,27,-2466.316,6169.527,58.25665,0,0,0,0,100,0), -(@PATH,28,-2500.569,6181.5,60.06873,0,0,0,0,100,0), -(@PATH,29,-2541.146,6187.5,60.79309,0,0,0,0,100,0), -(@PATH,30,-2533.038,6182.577,60.19934,0,0,0,0,100,0), -(@PATH,31,-2500.071,6186.787,60.56055,0,0,0,0,100,0), -(@PATH,32,-2475.183,6153.281,63.52248,0,0,0,0,100,0), -(@PATH,33,-2449.129,6140.594,77.34264,0,0,0,0,100,0), -(@PATH,34,-2448.861,6127.569,83.04636,0,0,0,0,100,0), -(@PATH,35,-2465.792,6100.151,92.3082,0,0,0,0,100,0), -(@PATH,36,-2478.536,6077.883,93.76772,0,0,0,0,100,0), -(@PATH,37,-2498.272,6119,92.22591,0,0,0,0,100,0), -(@PATH,38,-2509.331,6142.653,93.18784,0,0,0,0,100,0), -(@PATH,39,-2498.95,6129.08,92.34127,0,0,0,0,100,0), -(@PATH,40,-2466.666,6121.875,88.72591,0,0,0,0,100,0), -(@PATH,41,-2432.956,6121.422,83.23274,0,0,0,0,100,0), -(@PATH,42,-2399.844,6147.982,71.06328,0,0,0,0,100,0), -(@PATH,43,-2367.009,6154.886,59.9362,0,0,0,0,100,0); - --- Pathing for Boulderfist Crusher Entry: 17134 -SET @NPC := 60064; -SET @PATH := @NPC * 10; -UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-2241.646,`position_y`=6073.002,`position_z`=73.11702 WHERE `guid`=@NPC; -DELETE FROM `creature_addon` WHERE `guid`=@NPC; -INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, ''); -DELETE FROM `waypoint_data` WHERE `id`=@PATH; -INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES -(@PATH,1,-2241.646,6073.002,73.11702,0,0,0,0,100,0), -(@PATH,2,-2251.782,6080.446,76.50385,0,0,0,0,100,0), -(@PATH,3,-2257.793,6097.254,77.32147,0,0,0,0,100,0), -(@PATH,4,-2269.76,6109.586,74.90349,0,0,0,0,100,0), -(@PATH,5,-2298.05,6128.994,63.42472,0,0,0,0,100,0), -(@PATH,6,-2269.76,6109.586,74.90349,0,0,0,0,100,0), -(@PATH,7,-2258.203,6097.282,77.32253,0,0,0,0,100,0), -(@PATH,8,-2251.782,6080.446,76.50385,0,0,0,0,100,0), -(@PATH,9,-2241.646,6073.002,73.11702,0,0,0,0,100,0), -(@PATH,10,-2219.986,6071.252,71.84301,0,0,0,0,100,0), -(@PATH,11,-2189.278,6094.729,72.98857,0,0,0,0,100,0), -(@PATH,12,-2207.289,6076.843,72.2662,0,0,0,0,100,0), -(@PATH,13,-2203.843,6069.921,72.09104,0,0,0,0,100,0), -(@PATH,14,-2215.665,6058.173,68.39651,0,0,0,0,100,0), -(@PATH,15,-2210.043,6046.705,67.68399,0,0,0,0,100,0), -(@PATH,16,-2199.021,6048.374,68.0714,0,0,0,0,100,0), -(@PATH,17,-2187.256,6042.542,67.49065,0,0,0,0,100,0), -(@PATH,18,-2185.898,6029.625,66.28046,0,0,0,0,100,0), -(@PATH,19,-2197.731,6020.948,66.3587,0,0,0,0,100,0), -(@PATH,20,-2216.761,6010.768,67.10131,0,0,0,0,100,0), -(@PATH,21,-2197.731,6020.948,66.3587,0,0,0,0,100,0), -(@PATH,22,-2185.898,6029.625,66.28046,0,0,0,0,100,0), -(@PATH,23,-2187.256,6042.542,67.49065,0,0,0,0,100,0), -(@PATH,24,-2199.021,6048.374,68.0714,0,0,0,0,100,0), -(@PATH,25,-2210.043,6046.705,67.68399,0,0,0,0,100,0), -(@PATH,26,-2215.665,6058.173,68.39651,0,0,0,0,100,0), -(@PATH,27,-2203.843,6069.921,72.09104,0,0,0,0,100,0), -(@PATH,28,-2207.289,6076.843,72.2662,0,0,0,0,100,0), -(@PATH,29,-2189.263,6094.723,72.98553,0,0,0,0,100,0), -(@PATH,30,-2219.709,6071.23,71.80058,0,0,0,0,100,0); - -UPDATE `creature` SET `spawndist`=5,`MovementType`=1 WHERE `guid` IN (60048,60049,60061,60089,60073); -UPDATE `creature` SET `position_x`=-2254.501,`position_y`=6228.208,`position_z`=43.00068,`orientation`=4.066617 WHERE `guid`=60070; -UPDATE `creature` SET `position_x`=-2258.156,`position_y`=6223.644,`position_z`=43.70845,`orientation`=0.8377581 WHERE `guid`=60071; -UPDATE `creature` SET `id`=17135,`position_x`=-2353.576,`position_y`=6196.409,`position_z`=49.09693,`orientation`=0 WHERE `guid`=60069; - --- Boulderfist Crusher SAI -SET @ENTRY := 17134; -UPDATE `creature` SET `equipment_id`=-1 WHERE `id`=@ENTRY; -UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; -DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 -(@ENTRY,0,0,0,0,0,100,0,15000,15000,12000,12000,11,2676,0,0,0,0,0,2,0,0,0,0,0,0,0,"Boulderfist Crusher - In Combat - Cast 'Pulverize'"); - --- Boulderfist Mystic SAI -SET @ENTRY := 17135; -UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; -DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 -(@ENTRY,0,0,0,1,0,100,0,4000,8000,4000,8000,5,1,0,0,0,0,0,9,17135,4,7,0,0,0,0,"Boulderfist Mystic - Out of Combat - Emote talk"), -(@ENTRY,0,1,0,0,0,100,0,6000,6000,8000,12000,11,9532,0,0,0,0,0,2,0,0,0,0,0,0,0,"Boulderfist Mystic - In Combat - Cast 'Lightning Bolt'"), -(@ENTRY,0,2,0,0,0,100,0,9000,9000,12000,16000,11,13281,0,0,0,0,0,2,0,0,0,0,0,0,0,"Boulderfist Mystic - In Combat - Cast 'Earth Shock'"), -(@ENTRY,0,3,0,2,0,100,0,0,49,22000,22000,11,11431,0,0,0,0,0,1,0,0,0,0,0,0,0,"Boulderfist Mystic - Hp below 50 - Cast 'Healing Touch'"); diff --git a/sql/updates/world/2014_07_28_08_world_misc.sql b/sql/updates/world/2014_07_28_08_world_misc.sql new file mode 100644 index 00000000000..f1f13e76eec --- /dev/null +++ b/sql/updates/world/2014_07_28_08_world_misc.sql @@ -0,0 +1,160 @@ +-- Pathing for Sparik Entry: 19012 +SET @NPC := 68323; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `equipment_id`=1,`spawndist`=0,`MovementType`=2,`position_x`=-2539.584,`position_y`=7356.25,`position_z`=7.047175 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`,`emote`) VALUES (@NPC,@PATH,257,0, '', 233); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-2539.584,7356.25,7.047175,0,0,0,0,100,0), +(@PATH,2,-2542.437,7364.194,7.077205,0,0,0,0,100,0), +(@PATH,3,-2541.9,7364.772,7.012752,0,45000,0,0,100,0), +(@PATH,4,-2539.584,7356.25,7.047175,0,0,0,0,100,0), +(@PATH,5,-2533.325,7352.424,9.283463,0,0,0,0,100,0), +(@PATH,6,-2530.663,7354.053,9.283456,0,60000,0,0,100,0); + +DELETE FROM `creature_equip_template` WHERE `entry` IN (19012,17134); +INSERT INTO `creature_equip_template` (`entry`,`id`,`itemEntry1`,`itemEntry2`,`itemEntry3`,`VerifiedBuild`) VALUES +(19012,1,5956,13611,0,18414), +(17134,1,3326,0,0,18414), +(17134,2,5292,0,0,18414), +(17134,3,5293,0,0,18414), +(17134,4,5300,0,0,18414), +(17134,5,5301,0,0,18414), +(17134,6,5491,0,0,18414), +(17134,7,17942,0,0,18414); + +-- Pathing for Boulderfist Crusher Entry: 17134 +SET @NPC := 60060; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-2257.554,`position_y`=6220.683,`position_z`=44.19547 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-2257.554,6220.683,44.19547,0,0,0,0,100,0), +(@PATH,2,-2269.54,6185.135,50.54529,0,0,0,0,100,0), +(@PATH,3,-2300.504,6160.397,57.35026,0,0,0,0,100,0), +(@PATH,4,-2333.537,6174.551,51.46076,0,0,0,0,100,0), +(@PATH,5,-2354.695,6165.477,54.33383,0,0,0,0,100,0), +(@PATH,6,-2353.252,6135.473,60.3641,0,0,0,0,100,0), +(@PATH,7,-2345.113,6126.771,60.89935,0,0,0,0,100,0), +(@PATH,8,-2353.252,6135.473,60.3641,0,0,0,0,100,0), +(@PATH,9,-2354.915,6165.381,54.32211,0,0,0,0,100,0), +(@PATH,10,-2333.537,6174.551,51.46076,0,0,0,0,100,0), +(@PATH,11,-2300.504,6160.397,57.35026,0,0,0,0,100,0), +(@PATH,12,-2269.54,6185.135,50.54529,0,0,0,0,100,0); + +-- Pathing for Boulderfist Crusher Entry: 17134 +SET @NPC := 60059; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-2399.844,`position_y`=6147.982,`position_z`=71.06328 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-2399.844,6147.982,71.06328,0,0,0,0,100,0), +(@PATH,2,-2432.956,6121.422,83.23274,0,0,0,0,100,0), +(@PATH,3,-2466.083,6121.511,88.61314,0,0,0,0,100,0), +(@PATH,4,-2481.856,6120.785,91.89808,0,0,0,0,100,0), +(@PATH,5,-2498.95,6129.08,92.34127,0,0,0,0,100,0), +(@PATH,6,-2509.331,6142.653,93.18784,0,0,0,0,100,0), +(@PATH,7,-2498.272,6119,92.22591,0,0,0,0,100,0), +(@PATH,8,-2478.536,6077.883,93.76772,0,0,0,0,100,0), +(@PATH,9,-2465.792,6100.151,92.3082,0,0,0,0,100,0), +(@PATH,10,-2448.861,6127.569,83.04636,0,0,0,0,100,0), +(@PATH,11,-2448.847,6140.451,77.72874,0,0,0,0,100,0), +(@PATH,12,-2474.902,6153.139,63.35086,0,0,0,0,100,0), +(@PATH,13,-2500.071,6186.787,60.56055,0,0,0,0,100,0), +(@PATH,14,-2533.038,6182.577,60.19934,0,0,0,0,100,0), +(@PATH,15,-2541.146,6187.5,60.79309,0,0,0,0,100,0), +(@PATH,16,-2500.569,6181.5,60.06873,0,0,0,0,100,0), +(@PATH,17,-2466.607,6169.582,58.25665,0,0,0,0,100,0), +(@PATH,18,-2447.577,6166.336,54.24046,0,0,0,0,100,0), +(@PATH,19,-2450.868,6199.792,31.97747,0,0,0,0,100,0), +(@PATH,20,-2470.541,6233.041,30.6633,0,0,0,0,100,0), +(@PATH,21,-2466.961,6261.01,31.04571,0,0,0,0,100,0), +(@PATH,22,-2499.331,6266.069,27.68829,0,0,0,0,100,0), +(@PATH,23,-2466.961,6261.01,31.04571,0,0,0,0,100,0), +(@PATH,24,-2470.675,6233.3,30.707,0,0,0,0,100,0), +(@PATH,25,-2450.868,6199.792,31.97747,0,0,0,0,100,0), +(@PATH,26,-2447.577,6166.336,54.24046,0,0,0,0,100,0), +(@PATH,27,-2466.316,6169.527,58.25665,0,0,0,0,100,0), +(@PATH,28,-2500.569,6181.5,60.06873,0,0,0,0,100,0), +(@PATH,29,-2541.146,6187.5,60.79309,0,0,0,0,100,0), +(@PATH,30,-2533.038,6182.577,60.19934,0,0,0,0,100,0), +(@PATH,31,-2500.071,6186.787,60.56055,0,0,0,0,100,0), +(@PATH,32,-2475.183,6153.281,63.52248,0,0,0,0,100,0), +(@PATH,33,-2449.129,6140.594,77.34264,0,0,0,0,100,0), +(@PATH,34,-2448.861,6127.569,83.04636,0,0,0,0,100,0), +(@PATH,35,-2465.792,6100.151,92.3082,0,0,0,0,100,0), +(@PATH,36,-2478.536,6077.883,93.76772,0,0,0,0,100,0), +(@PATH,37,-2498.272,6119,92.22591,0,0,0,0,100,0), +(@PATH,38,-2509.331,6142.653,93.18784,0,0,0,0,100,0), +(@PATH,39,-2498.95,6129.08,92.34127,0,0,0,0,100,0), +(@PATH,40,-2466.666,6121.875,88.72591,0,0,0,0,100,0), +(@PATH,41,-2432.956,6121.422,83.23274,0,0,0,0,100,0), +(@PATH,42,-2399.844,6147.982,71.06328,0,0,0,0,100,0), +(@PATH,43,-2367.009,6154.886,59.9362,0,0,0,0,100,0); + +-- Pathing for Boulderfist Crusher Entry: 17134 +SET @NPC := 60064; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-2241.646,`position_y`=6073.002,`position_z`=73.11702 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-2241.646,6073.002,73.11702,0,0,0,0,100,0), +(@PATH,2,-2251.782,6080.446,76.50385,0,0,0,0,100,0), +(@PATH,3,-2257.793,6097.254,77.32147,0,0,0,0,100,0), +(@PATH,4,-2269.76,6109.586,74.90349,0,0,0,0,100,0), +(@PATH,5,-2298.05,6128.994,63.42472,0,0,0,0,100,0), +(@PATH,6,-2269.76,6109.586,74.90349,0,0,0,0,100,0), +(@PATH,7,-2258.203,6097.282,77.32253,0,0,0,0,100,0), +(@PATH,8,-2251.782,6080.446,76.50385,0,0,0,0,100,0), +(@PATH,9,-2241.646,6073.002,73.11702,0,0,0,0,100,0), +(@PATH,10,-2219.986,6071.252,71.84301,0,0,0,0,100,0), +(@PATH,11,-2189.278,6094.729,72.98857,0,0,0,0,100,0), +(@PATH,12,-2207.289,6076.843,72.2662,0,0,0,0,100,0), +(@PATH,13,-2203.843,6069.921,72.09104,0,0,0,0,100,0), +(@PATH,14,-2215.665,6058.173,68.39651,0,0,0,0,100,0), +(@PATH,15,-2210.043,6046.705,67.68399,0,0,0,0,100,0), +(@PATH,16,-2199.021,6048.374,68.0714,0,0,0,0,100,0), +(@PATH,17,-2187.256,6042.542,67.49065,0,0,0,0,100,0), +(@PATH,18,-2185.898,6029.625,66.28046,0,0,0,0,100,0), +(@PATH,19,-2197.731,6020.948,66.3587,0,0,0,0,100,0), +(@PATH,20,-2216.761,6010.768,67.10131,0,0,0,0,100,0), +(@PATH,21,-2197.731,6020.948,66.3587,0,0,0,0,100,0), +(@PATH,22,-2185.898,6029.625,66.28046,0,0,0,0,100,0), +(@PATH,23,-2187.256,6042.542,67.49065,0,0,0,0,100,0), +(@PATH,24,-2199.021,6048.374,68.0714,0,0,0,0,100,0), +(@PATH,25,-2210.043,6046.705,67.68399,0,0,0,0,100,0), +(@PATH,26,-2215.665,6058.173,68.39651,0,0,0,0,100,0), +(@PATH,27,-2203.843,6069.921,72.09104,0,0,0,0,100,0), +(@PATH,28,-2207.289,6076.843,72.2662,0,0,0,0,100,0), +(@PATH,29,-2189.263,6094.723,72.98553,0,0,0,0,100,0), +(@PATH,30,-2219.709,6071.23,71.80058,0,0,0,0,100,0); + +UPDATE `creature` SET `spawndist`=5,`MovementType`=1 WHERE `guid` IN (60048,60049,60061,60089,60073); +UPDATE `creature` SET `position_x`=-2254.501,`position_y`=6228.208,`position_z`=43.00068,`orientation`=4.066617 WHERE `guid`=60070; +UPDATE `creature` SET `position_x`=-2258.156,`position_y`=6223.644,`position_z`=43.70845,`orientation`=0.8377581 WHERE `guid`=60071; +UPDATE `creature` SET `id`=17135,`position_x`=-2353.576,`position_y`=6196.409,`position_z`=49.09693,`orientation`=0 WHERE `guid`=60069; + +-- Boulderfist Crusher SAI +SET @ENTRY := 17134; +UPDATE `creature` SET `equipment_id`=-1 WHERE `id`=@ENTRY; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,0,0,100,0,15000,15000,12000,12000,11,2676,0,0,0,0,0,2,0,0,0,0,0,0,0,"Boulderfist Crusher - In Combat - Cast 'Pulverize'"); + +-- Boulderfist Mystic SAI +SET @ENTRY := 17135; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,1,0,100,0,4000,8000,4000,8000,5,1,0,0,0,0,0,9,17135,4,7,0,0,0,0,"Boulderfist Mystic - Out of Combat - Emote talk"), +(@ENTRY,0,1,0,0,0,100,0,6000,6000,8000,12000,11,9532,0,0,0,0,0,2,0,0,0,0,0,0,0,"Boulderfist Mystic - In Combat - Cast 'Lightning Bolt'"), +(@ENTRY,0,2,0,0,0,100,0,9000,9000,12000,16000,11,13281,0,0,0,0,0,2,0,0,0,0,0,0,0,"Boulderfist Mystic - In Combat - Cast 'Earth Shock'"), +(@ENTRY,0,3,0,2,0,100,0,0,49,22000,22000,11,11431,0,0,0,0,0,1,0,0,0,0,0,0,0,"Boulderfist Mystic - Hp below 50 - Cast 'Healing Touch'"); -- cgit v1.2.3