From 01997cba4790dc72d8ad557d9c68b9da8dde6719 Mon Sep 17 00:00:00 2001 From: Gacko Date: Sat, 29 Dec 2012 07:57:30 +0100 Subject: DB/Quest: Citadel footsteps questline. Thx @Exodius This, together with - 007461b6d8112a36b792aef990e05a94c192637d - 90200840968be40da717d256ef4e4eac770e5415 - f1d960a589e1477532aae224ef8a573716ad6d9a solves #7707. Any suggestions/improvements in this issue. --- .../2012_12_28_01_world_citadel_footsteps.sql | 77 ++++++++++++++++++++++ 1 file changed, 77 insertions(+) create mode 100644 sql/updates/world/2012_12_28_01_world_citadel_footsteps.sql (limited to 'sql') diff --git a/sql/updates/world/2012_12_28_01_world_citadel_footsteps.sql b/sql/updates/world/2012_12_28_01_world_citadel_footsteps.sql new file mode 100644 index 00000000000..3d0ad779dc2 --- /dev/null +++ b/sql/updates/world/2012_12_28_01_world_citadel_footsteps.sql @@ -0,0 +1,77 @@ +-- Do your worst +UPDATE `quest_template` SET `PrevQuestId`=13393 WHERE `Id`=13394; +-- Where dragons fell +UPDATE `quest_template` SET `PrevQuestId`=13397 WHERE `Id`=13398; +-- Argent aid +UPDATE `quest_template` SET `PrevQuestId`=13362 WHERE `Id`=13363; +-- Where dragons fell +UPDATE `quest_template` SET `PrevQuestId`=13349 WHERE `Id`=13359; +-- Time for answers +UPDATE `quest_template` SET `PrevQuestId`=13359 WHERE `Id`=13360; +-- Do your worst +UPDATE `quest_template` SET `PrevQuestId`=13304 WHERE `Id`=13305; +-- A short fuse +UPDATE `quest_template` SET `NextQuestId`=13168 WHERE `Id` IN (13389,13263); +-- Several quest group conditions... +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (19,20) AND `SourceEntry` IN (13172,13174); +INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`Comment`) VALUES +(19,13172,0,8,13169,'Accepting Seeds of Chaos requires An Undeads Best Friend to be rewarded'), +(19,13172,1,8,13170,'Accepting Seeds of Chaos requires Honor is for the Weak to be rewarded'), +(19,13172,2,8,13171,'Accepting Seeds of Chaos requires From Whence They Came to be rewarded'), +(20,13172,0,8,13169,'Seeing quest mark for Seeds of Chaos requires An Undeads Best Friend to be rewarded'), +(20,13172,1,8,13170,'Seeing quest mark for Seeds of Chaos requires Honor is for the Weak to be rewarded'), +(20,13172,2,8,13171,'Seeing quest mark for Seeds of Chaos requires From Whence They Came to be rewarded'), +(19,13174,0,8,13169,'Accepting Amidst the Confusion requires An Undeads Best Friend to be rewarded'), +(19,13174,1,8,13170,'Accepting Amidst the Confusion requires Honor is for the Weak to be rewarded'), +(19,13174,2,8,13171,'Accepting Amidst the Confusion requires From Whence They Came to be rewarded'), +(20,13174,0,8,13169,'Seeing quest mark for Amidst the Confusion requires An Undeads Best Friend to be rewarded'), +(20,13174,1,8,13170,'Seeing quest mark for Amidst the Confusion requires Honor is for the Weak to be rewarded'), +(20,13174,2,8,13171,'Seeing quest mark for Amidst the Confusion requires From Whence They Came to be rewarded'); +-- Seeds of Chaos / Admist the Confusion +UPDATE `quest_template` SET `NextQuestId`=13155,`ExclusiveGroup`=-13155 WHERE `Id` IN (13172,13174); +-- Generosity Abounds / Matchmaker / Stunning View +UPDATE `quest_template` SET `PrevQuestId`=13145 WHERE `Id` IN (13146,13160,13147); +-- Several quest group conditions... +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (19,20) AND `SourceEntry` IN (13161,13163,13162); +INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`Comment`) VALUES +(19,13161,0,8,13146,'Accepting The Rider of the Unholy requires Generosity Abounds to be rewarded'), +(19,13161,1,8,13160,'Accepting The Rider of the Unholy requires Stunning View to be rewarded'), +(19,13161,2,8,13147,'Accepting The Rider of the Unholy requires Matchmaker to be rewarded'), +(20,13161,0,8,13146,'Seeing quest mark for The Rider of the Unholy requires Generosity Abounds to be rewarded'), +(20,13161,1,8,13160,'Seeing quest mark for The Rider of the Unholy requires Stunning View to be rewarded'), +(20,13161,2,8,13147,'Seeing quest mark for The Rider of the Unholy requires Matchmaker to be rewarded'), +(19,13163,0,8,13146,'Accepting The Rider of Blood requires Generosity Abounds to be rewarded'), +(19,13163,1,8,13160,'Accepting The Rider of Blood requires Stunning View to be rewarded'), +(19,13163,2,8,13147,'Accepting The Rider of Blood requires Matchmaker to be rewarded'), +(20,13163,0,8,13146,'Seeing quest mark for The Rider of Blood requires Generosity Abounds to be rewarded'), +(20,13163,1,8,13160,'Seeing quest mark for The Rider of Blood requires Stunning View to be rewarded'), +(20,13163,2,8,13147,'Seeing quest mark for The Rider of Blood requires Matchmaker to be rewarded'), +(19,13162,0,8,13146,'Accepting The Rider of Frost requires Generosity Abounds to be rewarded'), +(19,13162,1,8,13160,'Accepting The Rider of Frost requires Stunning View to be rewarded'), +(19,13162,2,8,13147,'Accepting The Rider of Frost requires Matchmaker to be rewarded'), +(20,13162,0,8,13146,'Seeing quest mark for The Rider of Frost requires Generosity Abounds to be rewarded'), +(20,13162,1,8,13160,'Seeing quest mark for The Rider of Frost requires Stunning View to be rewarded'), +(20,13162,2,8,13147,'Seeing quest mark for The Rider of Frost requires Matchmaker to be rewarded'); +-- The Rider of Blood / ... Frost / ... the Unholy +UPDATE `quest_template` SET `NextQuestId`=13164,`ExclusiveGroup`=-13164 WHERE `Id` IN (13161,13163,13162); +-- Where Are They Coming From? +UPDATE `quest_template` SET `PrevQuestId`=13106 WHERE `Id`=13117; +-- Destroying the Altars / Death's Gaze +UPDATE `quest_template` SET `PrevQuestId`=13117,`NextQuestId`=13134,`ExclusiveGroup`=-13134 WHERE `Id` IN (13119,13120); +-- Jagged Shards +UPDATE `quest_template` SET `PrevQuestId`=13134 WHERE `Id`=13136; +-- Several quest group conditions... +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (19,20) AND `SourceEntry` IN (13211,13152); +INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`Comment`) VALUES +(19,13152,0,8,13140,'Accepting A Visit to the Doctor requires The Runesmiths of Malykriss to be rewarded'), +(19,13152,1,8,13138,'Accepting A Visit to the Doctor requires Im Smelting... Smelting! to be rewarded'), +(20,13152,0,8,13140,'Seeing quest mark for A Visit to the Doctor requires The Runesmiths of Malykriss to be rewarded'), +(20,13152,1,8,13138,'Seeing quest mark for A Visit to the Doctor requires Im Smelting... Smelting! to be rewarded'), +(19,13211,0,8,13140,'Accepting By Fire Be Purged requires The Runesmiths of Malykriss to be rewarded'), +(19,13211,1,8,13138,'Accepting By Fire Be Purged requires Im Smelting... Smelting! to be rewarded'), +(20,13211,0,8,13140,'Seeing quest mark for By Fire Be Purged requires The Runesmiths of Malykriss to be rewarded'), +(20,13211,1,8,13138,'Seeing quest mark for By Fire Be Purged requires Im Smelting... Smelting! to be rewarded'); +-- A Visit to the Doctor / By Fire Be Purged +UPDATE `quest_template` SET `NextQuestId`=13144,`ExclusiveGroup`=-13144 WHERE `Id` IN (13211,13152); +-- Let's Get Out of Here! / Let's Get Out of Here / He's Gone to Pieces +UPDATE `quest_template` SET `PrevQuestId`=13144 WHERE `Id` IN (13481,13482,13212); -- cgit v1.2.3 From 204887774646a2e91b828a01e85efc39830bea15 Mon Sep 17 00:00:00 2001 From: Gacko Date: Sat, 29 Dec 2012 08:03:00 +0100 Subject: Rename SQL ... forgot again... --- .../2012_12_28_01_world_citadel_footsteps.sql | 77 ---------------------- .../2012_12_28_04_world_citadel_footsteps.sql | 77 ++++++++++++++++++++++ 2 files changed, 77 insertions(+), 77 deletions(-) delete mode 100644 sql/updates/world/2012_12_28_01_world_citadel_footsteps.sql create mode 100644 sql/updates/world/2012_12_28_04_world_citadel_footsteps.sql (limited to 'sql') diff --git a/sql/updates/world/2012_12_28_01_world_citadel_footsteps.sql b/sql/updates/world/2012_12_28_01_world_citadel_footsteps.sql deleted file mode 100644 index 3d0ad779dc2..00000000000 --- a/sql/updates/world/2012_12_28_01_world_citadel_footsteps.sql +++ /dev/null @@ -1,77 +0,0 @@ --- Do your worst -UPDATE `quest_template` SET `PrevQuestId`=13393 WHERE `Id`=13394; --- Where dragons fell -UPDATE `quest_template` SET `PrevQuestId`=13397 WHERE `Id`=13398; --- Argent aid -UPDATE `quest_template` SET `PrevQuestId`=13362 WHERE `Id`=13363; --- Where dragons fell -UPDATE `quest_template` SET `PrevQuestId`=13349 WHERE `Id`=13359; --- Time for answers -UPDATE `quest_template` SET `PrevQuestId`=13359 WHERE `Id`=13360; --- Do your worst -UPDATE `quest_template` SET `PrevQuestId`=13304 WHERE `Id`=13305; --- A short fuse -UPDATE `quest_template` SET `NextQuestId`=13168 WHERE `Id` IN (13389,13263); --- Several quest group conditions... -DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (19,20) AND `SourceEntry` IN (13172,13174); -INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`Comment`) VALUES -(19,13172,0,8,13169,'Accepting Seeds of Chaos requires An Undeads Best Friend to be rewarded'), -(19,13172,1,8,13170,'Accepting Seeds of Chaos requires Honor is for the Weak to be rewarded'), -(19,13172,2,8,13171,'Accepting Seeds of Chaos requires From Whence They Came to be rewarded'), -(20,13172,0,8,13169,'Seeing quest mark for Seeds of Chaos requires An Undeads Best Friend to be rewarded'), -(20,13172,1,8,13170,'Seeing quest mark for Seeds of Chaos requires Honor is for the Weak to be rewarded'), -(20,13172,2,8,13171,'Seeing quest mark for Seeds of Chaos requires From Whence They Came to be rewarded'), -(19,13174,0,8,13169,'Accepting Amidst the Confusion requires An Undeads Best Friend to be rewarded'), -(19,13174,1,8,13170,'Accepting Amidst the Confusion requires Honor is for the Weak to be rewarded'), -(19,13174,2,8,13171,'Accepting Amidst the Confusion requires From Whence They Came to be rewarded'), -(20,13174,0,8,13169,'Seeing quest mark for Amidst the Confusion requires An Undeads Best Friend to be rewarded'), -(20,13174,1,8,13170,'Seeing quest mark for Amidst the Confusion requires Honor is for the Weak to be rewarded'), -(20,13174,2,8,13171,'Seeing quest mark for Amidst the Confusion requires From Whence They Came to be rewarded'); --- Seeds of Chaos / Admist the Confusion -UPDATE `quest_template` SET `NextQuestId`=13155,`ExclusiveGroup`=-13155 WHERE `Id` IN (13172,13174); --- Generosity Abounds / Matchmaker / Stunning View -UPDATE `quest_template` SET `PrevQuestId`=13145 WHERE `Id` IN (13146,13160,13147); --- Several quest group conditions... -DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (19,20) AND `SourceEntry` IN (13161,13163,13162); -INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`Comment`) VALUES -(19,13161,0,8,13146,'Accepting The Rider of the Unholy requires Generosity Abounds to be rewarded'), -(19,13161,1,8,13160,'Accepting The Rider of the Unholy requires Stunning View to be rewarded'), -(19,13161,2,8,13147,'Accepting The Rider of the Unholy requires Matchmaker to be rewarded'), -(20,13161,0,8,13146,'Seeing quest mark for The Rider of the Unholy requires Generosity Abounds to be rewarded'), -(20,13161,1,8,13160,'Seeing quest mark for The Rider of the Unholy requires Stunning View to be rewarded'), -(20,13161,2,8,13147,'Seeing quest mark for The Rider of the Unholy requires Matchmaker to be rewarded'), -(19,13163,0,8,13146,'Accepting The Rider of Blood requires Generosity Abounds to be rewarded'), -(19,13163,1,8,13160,'Accepting The Rider of Blood requires Stunning View to be rewarded'), -(19,13163,2,8,13147,'Accepting The Rider of Blood requires Matchmaker to be rewarded'), -(20,13163,0,8,13146,'Seeing quest mark for The Rider of Blood requires Generosity Abounds to be rewarded'), -(20,13163,1,8,13160,'Seeing quest mark for The Rider of Blood requires Stunning View to be rewarded'), -(20,13163,2,8,13147,'Seeing quest mark for The Rider of Blood requires Matchmaker to be rewarded'), -(19,13162,0,8,13146,'Accepting The Rider of Frost requires Generosity Abounds to be rewarded'), -(19,13162,1,8,13160,'Accepting The Rider of Frost requires Stunning View to be rewarded'), -(19,13162,2,8,13147,'Accepting The Rider of Frost requires Matchmaker to be rewarded'), -(20,13162,0,8,13146,'Seeing quest mark for The Rider of Frost requires Generosity Abounds to be rewarded'), -(20,13162,1,8,13160,'Seeing quest mark for The Rider of Frost requires Stunning View to be rewarded'), -(20,13162,2,8,13147,'Seeing quest mark for The Rider of Frost requires Matchmaker to be rewarded'); --- The Rider of Blood / ... Frost / ... the Unholy -UPDATE `quest_template` SET `NextQuestId`=13164,`ExclusiveGroup`=-13164 WHERE `Id` IN (13161,13163,13162); --- Where Are They Coming From? -UPDATE `quest_template` SET `PrevQuestId`=13106 WHERE `Id`=13117; --- Destroying the Altars / Death's Gaze -UPDATE `quest_template` SET `PrevQuestId`=13117,`NextQuestId`=13134,`ExclusiveGroup`=-13134 WHERE `Id` IN (13119,13120); --- Jagged Shards -UPDATE `quest_template` SET `PrevQuestId`=13134 WHERE `Id`=13136; --- Several quest group conditions... -DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (19,20) AND `SourceEntry` IN (13211,13152); -INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`Comment`) VALUES -(19,13152,0,8,13140,'Accepting A Visit to the Doctor requires The Runesmiths of Malykriss to be rewarded'), -(19,13152,1,8,13138,'Accepting A Visit to the Doctor requires Im Smelting... Smelting! to be rewarded'), -(20,13152,0,8,13140,'Seeing quest mark for A Visit to the Doctor requires The Runesmiths of Malykriss to be rewarded'), -(20,13152,1,8,13138,'Seeing quest mark for A Visit to the Doctor requires Im Smelting... Smelting! to be rewarded'), -(19,13211,0,8,13140,'Accepting By Fire Be Purged requires The Runesmiths of Malykriss to be rewarded'), -(19,13211,1,8,13138,'Accepting By Fire Be Purged requires Im Smelting... Smelting! to be rewarded'), -(20,13211,0,8,13140,'Seeing quest mark for By Fire Be Purged requires The Runesmiths of Malykriss to be rewarded'), -(20,13211,1,8,13138,'Seeing quest mark for By Fire Be Purged requires Im Smelting... Smelting! to be rewarded'); --- A Visit to the Doctor / By Fire Be Purged -UPDATE `quest_template` SET `NextQuestId`=13144,`ExclusiveGroup`=-13144 WHERE `Id` IN (13211,13152); --- Let's Get Out of Here! / Let's Get Out of Here / He's Gone to Pieces -UPDATE `quest_template` SET `PrevQuestId`=13144 WHERE `Id` IN (13481,13482,13212); diff --git a/sql/updates/world/2012_12_28_04_world_citadel_footsteps.sql b/sql/updates/world/2012_12_28_04_world_citadel_footsteps.sql new file mode 100644 index 00000000000..3d0ad779dc2 --- /dev/null +++ b/sql/updates/world/2012_12_28_04_world_citadel_footsteps.sql @@ -0,0 +1,77 @@ +-- Do your worst +UPDATE `quest_template` SET `PrevQuestId`=13393 WHERE `Id`=13394; +-- Where dragons fell +UPDATE `quest_template` SET `PrevQuestId`=13397 WHERE `Id`=13398; +-- Argent aid +UPDATE `quest_template` SET `PrevQuestId`=13362 WHERE `Id`=13363; +-- Where dragons fell +UPDATE `quest_template` SET `PrevQuestId`=13349 WHERE `Id`=13359; +-- Time for answers +UPDATE `quest_template` SET `PrevQuestId`=13359 WHERE `Id`=13360; +-- Do your worst +UPDATE `quest_template` SET `PrevQuestId`=13304 WHERE `Id`=13305; +-- A short fuse +UPDATE `quest_template` SET `NextQuestId`=13168 WHERE `Id` IN (13389,13263); +-- Several quest group conditions... +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (19,20) AND `SourceEntry` IN (13172,13174); +INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`Comment`) VALUES +(19,13172,0,8,13169,'Accepting Seeds of Chaos requires An Undeads Best Friend to be rewarded'), +(19,13172,1,8,13170,'Accepting Seeds of Chaos requires Honor is for the Weak to be rewarded'), +(19,13172,2,8,13171,'Accepting Seeds of Chaos requires From Whence They Came to be rewarded'), +(20,13172,0,8,13169,'Seeing quest mark for Seeds of Chaos requires An Undeads Best Friend to be rewarded'), +(20,13172,1,8,13170,'Seeing quest mark for Seeds of Chaos requires Honor is for the Weak to be rewarded'), +(20,13172,2,8,13171,'Seeing quest mark for Seeds of Chaos requires From Whence They Came to be rewarded'), +(19,13174,0,8,13169,'Accepting Amidst the Confusion requires An Undeads Best Friend to be rewarded'), +(19,13174,1,8,13170,'Accepting Amidst the Confusion requires Honor is for the Weak to be rewarded'), +(19,13174,2,8,13171,'Accepting Amidst the Confusion requires From Whence They Came to be rewarded'), +(20,13174,0,8,13169,'Seeing quest mark for Amidst the Confusion requires An Undeads Best Friend to be rewarded'), +(20,13174,1,8,13170,'Seeing quest mark for Amidst the Confusion requires Honor is for the Weak to be rewarded'), +(20,13174,2,8,13171,'Seeing quest mark for Amidst the Confusion requires From Whence They Came to be rewarded'); +-- Seeds of Chaos / Admist the Confusion +UPDATE `quest_template` SET `NextQuestId`=13155,`ExclusiveGroup`=-13155 WHERE `Id` IN (13172,13174); +-- Generosity Abounds / Matchmaker / Stunning View +UPDATE `quest_template` SET `PrevQuestId`=13145 WHERE `Id` IN (13146,13160,13147); +-- Several quest group conditions... +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (19,20) AND `SourceEntry` IN (13161,13163,13162); +INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`Comment`) VALUES +(19,13161,0,8,13146,'Accepting The Rider of the Unholy requires Generosity Abounds to be rewarded'), +(19,13161,1,8,13160,'Accepting The Rider of the Unholy requires Stunning View to be rewarded'), +(19,13161,2,8,13147,'Accepting The Rider of the Unholy requires Matchmaker to be rewarded'), +(20,13161,0,8,13146,'Seeing quest mark for The Rider of the Unholy requires Generosity Abounds to be rewarded'), +(20,13161,1,8,13160,'Seeing quest mark for The Rider of the Unholy requires Stunning View to be rewarded'), +(20,13161,2,8,13147,'Seeing quest mark for The Rider of the Unholy requires Matchmaker to be rewarded'), +(19,13163,0,8,13146,'Accepting The Rider of Blood requires Generosity Abounds to be rewarded'), +(19,13163,1,8,13160,'Accepting The Rider of Blood requires Stunning View to be rewarded'), +(19,13163,2,8,13147,'Accepting The Rider of Blood requires Matchmaker to be rewarded'), +(20,13163,0,8,13146,'Seeing quest mark for The Rider of Blood requires Generosity Abounds to be rewarded'), +(20,13163,1,8,13160,'Seeing quest mark for The Rider of Blood requires Stunning View to be rewarded'), +(20,13163,2,8,13147,'Seeing quest mark for The Rider of Blood requires Matchmaker to be rewarded'), +(19,13162,0,8,13146,'Accepting The Rider of Frost requires Generosity Abounds to be rewarded'), +(19,13162,1,8,13160,'Accepting The Rider of Frost requires Stunning View to be rewarded'), +(19,13162,2,8,13147,'Accepting The Rider of Frost requires Matchmaker to be rewarded'), +(20,13162,0,8,13146,'Seeing quest mark for The Rider of Frost requires Generosity Abounds to be rewarded'), +(20,13162,1,8,13160,'Seeing quest mark for The Rider of Frost requires Stunning View to be rewarded'), +(20,13162,2,8,13147,'Seeing quest mark for The Rider of Frost requires Matchmaker to be rewarded'); +-- The Rider of Blood / ... Frost / ... the Unholy +UPDATE `quest_template` SET `NextQuestId`=13164,`ExclusiveGroup`=-13164 WHERE `Id` IN (13161,13163,13162); +-- Where Are They Coming From? +UPDATE `quest_template` SET `PrevQuestId`=13106 WHERE `Id`=13117; +-- Destroying the Altars / Death's Gaze +UPDATE `quest_template` SET `PrevQuestId`=13117,`NextQuestId`=13134,`ExclusiveGroup`=-13134 WHERE `Id` IN (13119,13120); +-- Jagged Shards +UPDATE `quest_template` SET `PrevQuestId`=13134 WHERE `Id`=13136; +-- Several quest group conditions... +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (19,20) AND `SourceEntry` IN (13211,13152); +INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`Comment`) VALUES +(19,13152,0,8,13140,'Accepting A Visit to the Doctor requires The Runesmiths of Malykriss to be rewarded'), +(19,13152,1,8,13138,'Accepting A Visit to the Doctor requires Im Smelting... Smelting! to be rewarded'), +(20,13152,0,8,13140,'Seeing quest mark for A Visit to the Doctor requires The Runesmiths of Malykriss to be rewarded'), +(20,13152,1,8,13138,'Seeing quest mark for A Visit to the Doctor requires Im Smelting... Smelting! to be rewarded'), +(19,13211,0,8,13140,'Accepting By Fire Be Purged requires The Runesmiths of Malykriss to be rewarded'), +(19,13211,1,8,13138,'Accepting By Fire Be Purged requires Im Smelting... Smelting! to be rewarded'), +(20,13211,0,8,13140,'Seeing quest mark for By Fire Be Purged requires The Runesmiths of Malykriss to be rewarded'), +(20,13211,1,8,13138,'Seeing quest mark for By Fire Be Purged requires Im Smelting... Smelting! to be rewarded'); +-- A Visit to the Doctor / By Fire Be Purged +UPDATE `quest_template` SET `NextQuestId`=13144,`ExclusiveGroup`=-13144 WHERE `Id` IN (13211,13152); +-- Let's Get Out of Here! / Let's Get Out of Here / He's Gone to Pieces +UPDATE `quest_template` SET `PrevQuestId`=13144 WHERE `Id` IN (13481,13482,13212); -- cgit v1.2.3