aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorSnapperRy <snapperryen@gmail.com>2016-10-21 15:55:42 +0200
committerSnapperRy <snapperryen@gmail.com>2016-10-21 15:55:42 +0200
commit16cfd59f5b368fd1d05eeeab3afbacfccf0a6870 (patch)
tree72c56d94f86c94870d19be4c7512a787c55874d0 /sql
parente78cb6ac5c96c41dbded43f7f648ab8642eeac09 (diff)
Script/Spell: remove cosmetic effect for Water Bucket item at login if it expired after the player logged out.
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/3.3.5/2016_10_21_01_world.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2016_10_21_01_world.sql b/sql/updates/world/3.3.5/2016_10_21_01_world.sql
new file mode 100644
index 00000000000..3753e8fd9c7
--- /dev/null
+++ b/sql/updates/world/3.3.5/2016_10_21_01_world.sql
@@ -0,0 +1,4 @@
+--
+DELETE FROM `spell_script_names` WHERE `spell_id`=42336;
+INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES
+(42336, "spell_hallows_end_has_water_bucket");