aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorSorikoff <46191832+Sorikoff@users.noreply.github.com>2020-01-19 17:36:27 +0200
committerShauren <shauren.trinity@gmail.com>2021-12-20 23:06:17 +0100
commita4b8371c9333bca86105c9e45090b78fbc104378 (patch)
treedb6a93134166cac71c4580a6e73ddff17307be71 /sql
parent97c28f4a429757edbf135326288400dd5aff79dc (diff)
Scripts/Violet Stand: Warmages (#24084)
* Scripts/Violet Stand: Warmages * Rename 9999_99_99_99_world.sql to 2020_01_19_02_world.sql Co-authored-by: Giacomo Pozzoni <giacomopoz@gmail.com> (cherry picked from commit 07c0bfe11b8164a9132e608e7bee1875467be6b2)
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2021_12_20_24_world_2020_01_19_02_world.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_12_20_24_world_2020_01_19_02_world.sql b/sql/updates/world/master/2021_12_20_24_world_2020_01_19_02_world.sql
new file mode 100644
index 00000000000..8c6fe833638
--- /dev/null
+++ b/sql/updates/world/master/2021_12_20_24_world_2020_01_19_02_world.sql
@@ -0,0 +1,6 @@
+UPDATE `creature_template` SET `ScriptName`='',`AIName`='SmartAI' WHERE `entry` IN (27306,32369,32371,32372);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (32369,32371,32372) 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
+(32369,0,0,0,25,0,100,0,0,0,0,0,0,11,48310,0,0,0,0,0,10,72404,27306,0,0,0,0,0,0,'Warmage Sarina - On Reset - Cast \'Transitus Shield Beam\''),
+(32371,0,0,0,25,0,100,0,0,0,0,0,0,11,48310,0,0,0,0,0,10,77844,27306,0,0,0,0,0,0,'Warmage Halister - On Reset - Cast \'Transitus Shield Beam\''),
+(32372,0,0,0,25,0,100,0,0,0,0,0,0,11,48310,0,0,0,0,0,10,72403,27306,0,0,0,0,0,0,'Warmage Ilsudria - On Reset - Cast \'Transitus Shield Beam\'');