aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorSorikoff <46191832+Sorikoff@users.noreply.github.com>2020-01-19 17:36:27 +0200
committerGiacomo Pozzoni <giacomopoz@gmail.com>2020-01-19 16:36:27 +0100
commit07c0bfe11b8164a9132e608e7bee1875467be6b2 (patch)
tree96e60cf03e4ca2e95af3b1cc830bb3b008edc074 /sql/updates
parentf20b147c71c69f196644ab250e5083e9e20eb6de (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>
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/world/3.3.5/2020_01_19_02_world.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2020_01_19_02_world.sql b/sql/updates/world/3.3.5/2020_01_19_02_world.sql
new file mode 100644
index 00000000000..8c6fe833638
--- /dev/null
+++ b/sql/updates/world/3.3.5/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\'');