aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoroffl <offl@users.noreply.github.com>2021-10-29 03:40:23 +0300
committerShauren <shauren.trinity@gmail.com>2022-03-20 23:47:45 +0100
commit281b0a867ef8f32447d6855d22f6a976c9e8d02f (patch)
tree3f06e66fdfe79e40c02e0d398430816723b98894
parente037dea94e0bad0b6e3acd3099a5394ec09b16ca (diff)
DB/Creature: Fenissa the Assassin
Closes #27203 (cherry picked from commit ecc348e70ddfbe18a1267cad49c17b68838df717)
-rw-r--r--sql/updates/world/master/2022_03_20_22_world_2021_10_29_01_world.sql11
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_03_20_22_world_2021_10_29_01_world.sql b/sql/updates/world/master/2022_03_20_22_world_2021_10_29_01_world.sql
new file mode 100644
index 00000000000..0a638955498
--- /dev/null
+++ b/sql/updates/world/master/2022_03_20_22_world_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;