aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorLiberate <tbaart@gmail.com>2011-01-30 18:22:30 +0100
committerLiberate <tbaart@gmail.com>2011-01-30 18:22:30 +0100
commit0e7b60bf19babf8dfa1a424fb08c50c5fb4bfdc0 (patch)
tree7133d40182400c11ebead20c961be0bf87357bc5 /sql
parent840d2eac625117d4da798f8f6c1e61531d24ec9e (diff)
Quests: Fixes quest "Going Bearback". Needs DB support to work.
ref ticket:472
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/2011_01_30_0_world_spell_script_names.sql3
-rw-r--r--sql/updates/2011_01_30_1_world_scriptnames.sql1
2 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/2011_01_30_0_world_spell_script_names.sql b/sql/updates/2011_01_30_0_world_spell_script_names.sql
new file mode 100644
index 00000000000..56f3a7a2186
--- /dev/null
+++ b/sql/updates/2011_01_30_0_world_spell_script_names.sql
@@ -0,0 +1,3 @@
+DELETE FROM `spell_script_names` WHERE `spell_id` = 54798 AND `ScriptName`='spell_q12851_going_bearback';
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
+(54798,'spell_q12851_going_bearback');
diff --git a/sql/updates/2011_01_30_1_world_scriptnames.sql b/sql/updates/2011_01_30_1_world_scriptnames.sql
new file mode 100644
index 00000000000..55532c44f1f
--- /dev/null
+++ b/sql/updates/2011_01_30_1_world_scriptnames.sql
@@ -0,0 +1 @@
+UPDATE `creature_template` SET `ScriptName`='npc_icefang' WHERE `entry`=29602;