diff options
| author | ZenoX92 <ZenoX92@users.noreply.github.com> | 2019-05-13 01:12:53 +0200 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2019-05-13 01:12:53 +0200 |
| commit | b22ef1addeedb83397ecfa42efc65314b29c8a7b (patch) | |
| tree | 6b084326e31ee7edf98e7af57ee6d31cab1b6b31 | |
| parent | 1d1ca24b865e5b8ce7a7f759b6caa94aa0a50972 (diff) | |
DB/SAI: Windfury Harpies
Closes #23265
| -rw-r--r-- | sql/updates/world/3.3.5/2019_05_13_01_world_335.sql | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2019_05_13_01_world_335.sql b/sql/updates/world/3.3.5/2019_05_13_01_world_335.sql new file mode 100644 index 00000000000..f44bc6fa5f4 --- /dev/null +++ b/sql/updates/world/3.3.5/2019_05_13_01_world_335.sql @@ -0,0 +1,20 @@ +-- Windfury Wind Witch +DELETE FROM `smart_scripts` WHERE `entryorguid`=2963 AND `source_type`=0 AND `id`=2; +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 +(2963,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,"Windfury Wind Witch - Between 0-15% Health - Flee For Assist (No Repeat)"); + +-- Windfury Sorceress +DELETE FROM `smart_scripts` WHERE `entryorguid`=2964 AND `source_type`=0 AND `id`=1; +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 +(2964,0,1,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,"Windfury Sorceress - Between 0-15% Health - Flee For Assist (No Repeat)"); + +-- Windfury Matriarch +DELETE FROM `smart_scripts` WHERE `entryorguid`=2965 AND `source_type`=0 AND `id`=2; +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 +(2965,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,"Windfury Matriarch - Between 0-15% Health - Flee For Assist (No Repeat)"); + +-- Windfury Harpy +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=2962; +DELETE FROM `smart_scripts` WHERE `entryorguid`=2962 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 +(2962,0,0,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,"Windfury Harpy - Between 0-15% Health - Flee For Assist (No Repeat)"); |