aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorBroodWyrm <none@none>2009-05-01 09:45:51 +0200
committerBroodWyrm <none@none>2009-05-01 09:45:51 +0200
commitdb977d7005d0982ab672cfa0c7758b0d480b06b2 (patch)
tree7594076355436651090a07f4c62e11f728cdbe5b /sql/updates
parent94e896ebd6aaf4cf0be661fa8250ad90d89f9b5c (diff)
parent85fbe3ada2bf9fd08acb97e40e2dddefc6e38e0a (diff)
*Merge.
--HG-- branch : trunk
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/2.4.3_updates/1437_TC1_world_scripts.sql14
-rw-r--r--sql/updates/3018_spell_linked_spell.sql5
2 files changed, 19 insertions, 0 deletions
diff --git a/sql/updates/2.4.3_updates/1437_TC1_world_scripts.sql b/sql/updates/2.4.3_updates/1437_TC1_world_scripts.sql
new file mode 100644
index 00000000000..7d53254cc5b
--- /dev/null
+++ b/sql/updates/2.4.3_updates/1437_TC1_world_scripts.sql
@@ -0,0 +1,14 @@
+UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_prison' WHERE `entry` = 184418 LIMIT 1;
+UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_prison' WHERE `entry` = 184419 LIMIT 1;
+UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_prison' WHERE `entry` = 184420 LIMIT 1;
+UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_prison' WHERE `entry` = 184421 LIMIT 1;
+UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_prison' WHERE `entry` = 184422 LIMIT 1;
+UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_prison' WHERE `entry` = 184423 LIMIT 1;
+UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_prison' WHERE `entry` = 184424 LIMIT 1;
+UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_prison' WHERE `entry` = 184425 LIMIT 1;
+UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_prison' WHERE `entry` = 184426 LIMIT 1;
+UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_prison' WHERE `entry` = 184427 LIMIT 1;
+UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_prison' WHERE `entry` = 184428 LIMIT 1;
+UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_prison' WHERE `entry` = 184429 LIMIT 1;
+UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_prison' WHERE `entry` = 184430 LIMIT 1;
+UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_prison' WHERE `entry` = 184431 LIMIT 1; \ No newline at end of file
diff --git a/sql/updates/3018_spell_linked_spell.sql b/sql/updates/3018_spell_linked_spell.sql
new file mode 100644
index 00000000000..6f9610cf8cf
--- /dev/null
+++ b/sql/updates/3018_spell_linked_spell.sql
@@ -0,0 +1,5 @@
+DELETE FROM `spell_linked_spell` WHERE `spell_trigger` = 38528;
+
+INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES
+( 38528,-31984, 2, 'Protection of Elune - Finger of Death'),
+( 38528,-32111, 2, 'Protection of Elune - Finger of Death'); \ No newline at end of file