aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/7349_world_spell_linked_spell.sql3
-rw-r--r--sql/updates/7373_world_item_template.sql2
-rw-r--r--sql/updates/7373_world_scriptname.sql (renamed from sql/updates/7373_world_creature_template.sql)2
3 files changed, 3 insertions, 4 deletions
diff --git a/sql/updates/7349_world_spell_linked_spell.sql b/sql/updates/7349_world_spell_linked_spell.sql
index df64792e941..9afd55d4d50 100644
--- a/sql/updates/7349_world_spell_linked_spell.sql
+++ b/sql/updates/7349_world_spell_linked_spell.sql
@@ -1,2 +1,3 @@
-- Summon Water Elemental
-INSERT INTO `spell_linked_spell`(`spell_trigger`,`spell_effect`,`type`,`comment`) VALUES (31687, 70907, 0,'Summon Water Elemental'); \ No newline at end of file
+DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=31687 AND `spell_effect`=70907;
+INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment`) VALUES (31687, 70907, 0,'Summon Water Elemental');
diff --git a/sql/updates/7373_world_item_template.sql b/sql/updates/7373_world_item_template.sql
deleted file mode 100644
index e9c51195524..00000000000
--- a/sql/updates/7373_world_item_template.sql
+++ /dev/null
@@ -1,2 +0,0 @@
-UPDATE `item_template` SET `scriptname`='item_dehta_trap_smasher' WHERE `entry`=35228;
-
diff --git a/sql/updates/7373_world_creature_template.sql b/sql/updates/7373_world_scriptname.sql
index 86904783abe..3588b9b3604 100644
--- a/sql/updates/7373_world_creature_template.sql
+++ b/sql/updates/7373_world_scriptname.sql
@@ -1,2 +1,2 @@
UPDATE `creature_template` SET `scriptname`='npc_trapped_mammoth_calf' WHERE `entry`=25850;
-
+UPDATE `item_template` SET `scriptname`='item_dehta_trap_smasher' WHERE `entry`=35228;