From 9ad59e806cd2331e444e8698506d29317f27dcd8 Mon Sep 17 00:00:00 2001 From: Killyana Date: Sat, 26 Sep 2015 22:05:03 +0200 Subject: DB/Creature: Eversong Ranger SAI fix Closes #15602 (cherry picked from commit 706053129ac82dc3e143fb40b931afa9926c0de1) --- sql/updates/world/2015_10_31_13_world_2015_09_26_02.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 sql/updates/world/2015_10_31_13_world_2015_09_26_02.sql (limited to 'sql') diff --git a/sql/updates/world/2015_10_31_13_world_2015_09_26_02.sql b/sql/updates/world/2015_10_31_13_world_2015_09_26_02.sql new file mode 100644 index 00000000000..c5cee6530d0 --- /dev/null +++ b/sql/updates/world/2015_10_31_13_world_2015_09_26_02.sql @@ -0,0 +1,6 @@ +-- Eversong Ranger +DELETE FROM `smart_scripts` WHERE `entryorguid`=15938 AND `source_type`=0 AND `id`<14; +UPDATE `smart_scripts` SET `id`= `id`-12 WHERE `entryorguid`=15938 AND `source_type`=0 AND `id`>13; +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 +(15938,0,0,0,0,0,100,0,0,0,2200,3800,11,6660,64,0,0,0,0,2,0,0,0,0,0,0,0,"Eversong Ranger - In Combat CMC - Cast 'Shoot'"), +(15938,0,1,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Eversong Ranger - Between 0-15% Health - Flee For Assist (No Repeat)"); -- cgit v1.2.3