From 0e7b60bf19babf8dfa1a424fb08c50c5fb4bfdc0 Mon Sep 17 00:00:00 2001 From: Liberate Date: Sun, 30 Jan 2011 18:22:30 +0100 Subject: Quests: Fixes quest "Going Bearback". Needs DB support to work. ref ticket:472 --- sql/updates/2011_01_30_0_world_spell_script_names.sql | 3 +++ sql/updates/2011_01_30_1_world_scriptnames.sql | 1 + 2 files changed, 4 insertions(+) create mode 100644 sql/updates/2011_01_30_0_world_spell_script_names.sql create mode 100644 sql/updates/2011_01_30_1_world_scriptnames.sql (limited to 'sql') 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; -- cgit v1.2.3