DB/Quest: Fix Black Knight of ... Chain

also fix startuperrors

1 files changed, 17 insertions, 0 deletions

diff --git a/sql/updates/world/2011_04_14_01_world_quest_template.sql b/sql/updates/world/2011_04_14_01_world_quest_template.sql
new file mode 100644
index 00000000000..0602d814fe8
--- /dev/null
+++ b/sql/updates/world/2011_04_14_01_world_quest_template.sql
@@ -0,0 +1,17 @@
+-- Chain the Black Knight Quest Series
+UPDATE `quest_template` SET `PrevQuestId`=0,`NextQuestId`=13641 WHERE `entry`=13633; -- The Black Knight of Westfall? (Ally)
+UPDATE `quest_template` SET `PrevQuestId`=0,`NextQuestId`=13641 WHERE `entry`=13634; -- The Black Knight of Silverpine (Horde)
+UPDATE `quest_template` SET `PrevQuestId`=0,`NextQuestId`=13643 WHERE `entry`=13641; -- The Seer's Crystal
+UPDATE `quest_template` SET `PrevQuestId`=13641,`NextQuestId`=0 WHERE `entry`=13643; -- The Stories Dead Men Tell
+UPDATE `quest_template` SET `PrevQuestId`=13643,`NextQuestId`=0 WHERE `entry`=13654; -- There's Something About the Squire
+UPDATE `quest_template` SET `PrevQuestId`=13654,`NextQuestId`=0 WHERE `entry`=13663; -- The Black Knight's Orders
+UPDATE `quest_template` SET `PrevQuestId`=13663,`NextQuestId`=0 WHERE `entry`=13664; -- The Black Knight's Fall
+UPDATE `quest_template` SET `PrevQuestId`=13664,`NextQuestId`=0 WHERE `entry`=14016; -- The Black Knight's Curse
+UPDATE `quest_template` SET `PrevQuestId`=14016,`NextQuestId`=0 WHERE `entry`=14017; -- The Black Knight's Fate
+-- Thread from Above only after The Black Knight's Fall
+UPDATE `quest_template` SET `PrevQuestId`=13664 WHERE `entry`=13682; -- Thread from Above only after The Black Knights Fall
+UPDATE `quest_template` SET `PrevQuestId`=13664 WHERE `entry`=13788; -- Thread from Above only after The Black Knights Fall
+UPDATE `quest_template` SET `PrevQuestId`=13664 WHERE `entry`=13809; -- Thread from Above only after The Black Knights Fall
+UPDATE `quest_template` SET `PrevQuestId`=13664 WHERE `entry`=13812; -- Thread from Above only after The Black Knights Fall
+-- Fix some startuperrors:
+UPDATE `creature_template` SET `npcflag`=`npcflag`|128 WHERE `entry` IN (32405,32407);