diff options
| -rw-r--r-- | sql/updates/world/master/2021_11_14_12_world_2018_10_11_11_world_335.sql | 59 |
1 files changed, 59 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_11_14_12_world_2018_10_11_11_world_335.sql b/sql/updates/world/master/2021_11_14_12_world_2018_10_11_11_world_335.sql new file mode 100644 index 00000000000..e069e599a30 --- /dev/null +++ b/sql/updates/world/master/2021_11_14_12_world_2018_10_11_11_world_335.sql @@ -0,0 +1,59 @@ +-- +-- DELETE FROM `creature` WHERE `guid` IN (87931,87932,87933,87934,87935,87936,87937,87960,87961,87989,88013,88020,88021,88063,88064,88068,88069,88070,88071,88103,88109,88167,88206,88209,88253,88282,88369,88485,88539,88540,88541,88542,88543,88544,88545,88546,88547,88638,88639,88640,88641,88642,88643,88644,88645,88646,88647,88648,88649,88650,88651); +-- INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`,`spawndist`, `MovementType`) VALUES +-- (87931, 4386, 1, 1, 1, 0, 0, -4860, -3370, 29.02, 5.973, 600, 9, 1), +-- (87932, 4386, 1, 1, 1, 0, 0, -4542, -3135, 28.523, 4.748, 600, 9, 1), +-- (87933, 4386, 1, 1, 1, 0, 0, -4428, -3627, 28.522, 0.806, 600, 9, 1), +-- (87934, 4386, 1, 1, 1, 0, 0, -4354, -3618, 28.597, 5.973, 600, 9, 1), +-- (87935, 4386, 1, 1, 1, 0, 0, -4219, -3214, 28.915, 0.629, 600, 9, 1), +-- (87936, 4386, 1, 1, 1, 0, 0, -4168, -3371, 29.988, 5.226, 600, 9, 1), +-- (87937, 4386, 1, 1, 1, 0, 0, -4120, -3610, 31.442, 0.396, 600, 9, 1), +-- (87960, 4386, 1, 1, 1, 0, 0, -3920, -3003, 28.535, 4.686, 600, 9, 1), +-- (87961, 4386, 1, 1, 1, 0, 0, -3852, -3064, 29.099, 5.758, 600, 9, 1), +-- (87989, 4386, 1, 1, 1, 0, 0, -3789, -3003, 30.307, 4.829, 600, 9, 1), +-- (88013, 4386, 1, 1, 1, 0, 0, -3773, -3311, 28.523, 2.188, 600, 9, 1), +-- (88020, 4386, 1, 1, 1, 0, 0, -3738, -2795, 28.528, 2.731, 600, 9, 1), +-- (88021, 4386, 1, 1, 1, 0, 0, -3720, -2864, 29.603, 5.555, 600, 9, 1), +-- (88063, 4386, 1, 1, 1, 0, 0, -3691, -3273, 28.623, 4.139, 600, 9, 1), +-- (88064, 4386, 1, 1, 1, 0, 0, -3690, -2985, 29.749, 3.748, 600, 9, 1), +-- (88068, 4386, 1, 1, 1, 0, 0, -3659, -3349, 28.707, 0.287, 600, 9, 1), +-- (88069, 4386, 1, 1, 1, 0, 0, -3628, -2797, 30.547, 6.223, 600, 7, 1), +-- (88070, 4386, 1, 1, 1, 0, 0, -3581, -3076, 29.193, 0.375, 600, 6, 1), +-- (88071, 4386, 1, 1, 1, 0, 0, -3574, -3285, 28.523, 2.313, 600, 9, 1), +-- (88103, 4386, 1, 1, 1, 0, 0, -3559, -3029, 29.209, 3.638, 600, 6, 1), +-- (88109, 4386, 1, 1, 1, 0, 0, -3542, -2899, 29.537, 5.688, 600, 6, 1), +-- (88167, 4386, 1, 1, 1, 0, 0, -3527, -3079, 29.748, 0.318, 600, 6, 1), +-- (88206, 4386, 1, 1, 1, 0, 0, -3505, -3078, 29.388, 2.642, 600, 7, 1), +-- (88209, 4386, 1, 1, 1, 0, 0, -3496, -2950, 29.51, 0.991, 600, 6, 1), +-- (88253, 4386, 1, 1, 1, 0, 0, -3489, -3145, 28.522, 5.113, 600, 9, 1), +-- (88282, 4386, 1, 1, 1, 0, 0, -3484, -2923, 29.657, 1.276, 600, 7, 1), +-- (88369, 4386, 1, 1, 1, 0, 0, -3350.7, -2856.9, 29.24, 1.5, 600, 7, 1), +-- (88485, 4386, 1, 1, 1, 0, 0, -3340, -2916, 29.184, 5.499, 600, 9, 1), +-- (88539, 4386, 1, 1, 1, 0, 0, -3321, -3208, 29.681, 5.26, 600, 7, 1), +-- (88540, 4386, 1, 1, 1, 0, 0, -3302, -2854, 29.468, 0.269, 600, 4, 1), +-- (88541, 4386, 1, 1, 1, 0, 0, -3247, -2883, 32.616, 0.748, 600, 9, 1), +-- (88542, 4386, 1, 1, 1, 0, 0, -3184, -3853, 27.792, 4.052, 600, 7, 1), +-- (88543, 4386, 1, 1, 1, 0, 0, -3107, -3816, 28.761, 3.802, 600, 7, 1), +-- (88544, 4386, 1, 1, 1, 0, 0, -3070, -3748, 29.918, 4.941, 600, 7, 1), +-- (88545, 4386, 1, 1, 1, 0, 0, -3018, -3932, 28.942, 4.227, 600, 9, 1), +-- (88546, 4386, 1, 1, 1, 0, 0, -2970, -3950, 28.864, 4.7534, 600, 7, 1), +-- (88547, 4386, 1, 1, 1, 0, 0, -2915, -3825, 28.522, 3.876, 600, 4, 1), +-- (88638, 4386, 1, 1, 1, 0, 0, -2902, -3034, 29.309, 0.743, 600, 7, 1), +-- (88639, 4386, 1, 1, 1, 0, 0, -2870, -3809, 28.772, 3.057, 600, 7, 1), +-- (88640, 4386, 1, 1, 1, 0, 0, -2859, -2937, 29.114, 0.259, 600, 7, 1), +-- (88641, 4386, 1, 1, 1, 0, 0, -2843, -3646, 29.243, 3.906, 600, 6, 1), +-- (88642, 4386, 1, 1, 1, 0, 0, -2826, -3722, 29.318, 5.833, 600, 7, 1), +-- (88643, 4386, 1, 1, 1, 0, 0, -2820, -3794, 28.642, 3.715, 600, 9, 1), +-- (88644, 4386, 1, 1, 1, 0, 0, -2818, -3604, 28.938, 4.394, 600, 7, 1), +-- (88645, 4386, 1, 1, 1, 0, 0, -2805, -3479, 28.522, 4.373, 600, 9, 1), +-- (88646, 4386, 1, 1, 1, 0, 0, -2794, -3328, 29.294, 3.529, 600, 7, 1), +-- (88647, 4386, 1, 1, 1, 0, 0, -2776, -3598, 28.838, 5.653, 600, 9, 1), +-- (88648, 4386, 1, 1, 1, 0, 0, -2748, -3379, 28.523, 4.114, 600, 9, 1), +-- (88649, 4386, 1, 1, 1, 0, 0, -2744, -3210, 29.783, 2.963, 600, 7, 1), +-- (88650, 4386, 1, 1, 1, 0, 0, -2693, -3661, 28.523, 5.915, 600, 9, 1), +-- (88651, 4386, 1, 1, 1, 0, 0, -2604, -3214, 28.918, 4.231, 600, 7, 1); + +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=4386; +DELETE FROM `smart_scripts` WHERE `entryorguid`=4386 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`,`event_param5`,`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 +(4386,0,0,0,0,0,100,0,2000,3000,5000,8000,0,11,6016,0,0,0,0,0,2,0,0,0,0,0,0,0,"Withervine Bark Ripper - IC - Cast Pierce Armor"); |