aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorDr-J <daniel.jarrott0@gmail.com>2016-06-15 13:57:33 +0100
committerGitHub <noreply@github.com>2016-06-15 13:57:33 +0100
commitb89113d6534e273a832040e005323b9cb3c075e3 (patch)
treefa451da86734df3eacdd3be30e5768a54ef15e34
parent4bf9f0b73c4a8b8e9a5d903faabed2747e64b90b (diff)
DB/Quest: Zandalarian Shadow Talisman/Zandalarian Shadow Mastery Talisman
Add quest starter/ender data for some missing class specific quests (Rogue), http://wotlk.openwow.com/quest=8143/zandalarian-shadow-talisman and http://wotlk.openwow.com/quest=8144/zandalarian-shadow-mastery-talisman Also set correct races for http://wotlk.openwow.com/quest=8144/zandalarian-shadow-mastery-talisman as previously allowable races was set so this quest was only available to Nightelve, Undead and Troll Rogues (even though could not be taken.
-rw-r--r--sql/updates/world/3.3.5/2016_06_15_08_world_335.sql11
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2016_06_15_08_world_335.sql b/sql/updates/world/3.3.5/2016_06_15_08_world_335.sql
new file mode 100644
index 00000000000..51ab052ef56
--- /dev/null
+++ b/sql/updates/world/3.3.5/2016_06_15_08_world_335.sql
@@ -0,0 +1,11 @@
+DELETE FROM `creature_queststarter` WHERE `quest`IN(8143,8144);
+INSERT INTO `creature_queststarter` (`id`, `quest`) VALUES
+(14905, 8143),
+(14905, 8144);
+
+DELETE FROM `creature_questender` WHERE `quest`IN(8143,8144);
+INSERT INTO `creature_questender` (`id`, `quest`) VALUES
+(14905, 8143),
+(14905, 8144);
+
+UPDATE `quest_template` SET `AllowableRaces`=0 WHERE `ID`=8144;