diff options
author | offl <offl@users.noreply.github.com> | 2021-10-29 03:40:23 +0300 |
---|---|---|
committer | offl <offl@users.noreply.github.com> | 2021-10-29 03:40:23 +0300 |
commit | ecc348e70ddfbe18a1267cad49c17b68838df717 (patch) | |
tree | df665ec6db61596c41de3c4e84df0caa3ae00e4b | |
parent | a0feb39180d8b5989773174c0da1ce8cdeb89267 (diff) |
DB/Creature: Fenissa the Assassin
Closes #27203
-rw-r--r-- | sql/updates/world/3.3.5/2021_10_29_01_world.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2021_10_29_01_world.sql b/sql/updates/world/3.3.5/2021_10_29_01_world.sql new file mode 100644 index 00000000000..0a638955498 --- /dev/null +++ b/sql/updates/world/3.3.5/2021_10_29_01_world.sql @@ -0,0 +1,11 @@ +-- +UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 22060; +DELETE FROM `smart_scripts` WHERE `entryorguid` = 22060 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_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(22060,0,0,0,0,0,100,0,5000,7000,7000,10000,0,11,14873,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"Fenissa the Assassin - In Combat - Cast 'Sinister Strike'"), +(22060,0,1,0,0,0,100,0,10000,15000,15000,20000,0,11,38863,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"Fenissa the Assassin - In Combat - Cast 'Gouge'"), +(22060,0,2,0,2,0,100,1,0,15,0,0,0,25,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Fenissa the Assassin - Between 0-15% Health - Flee For Assist (No Repeat)"); + +UPDATE `creature_template_addon` SET `auras` = '30982 34189' WHERE `entry` = 22060; +UPDATE `creature_addon` SET `auras` = '30982 34189' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` = 22060); +UPDATE `creature_template` SET `speed_walk` = 1 WHERE `entry` = 22060; |