diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2019_04_10_04_world.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2019_04_10_04_world.sql b/sql/updates/world/3.3.5/2019_04_10_04_world.sql new file mode 100644 index 00000000000..17580415692 --- /dev/null +++ b/sql/updates/world/3.3.5/2019_04_10_04_world.sql @@ -0,0 +1,14 @@ +-- +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (19) AND `SourceEntry`IN (1275,1841, 1846, 1840, 1844, 1839, 1842, 2865, 6383, 13226, 13227); + +DELETE FROM `quest_template_addon` WHERE `ID` IN (3765,2864,13226,13227); +INSERT INTO `quest_template_addon` (`ID`,`BreadcrumbForQuestId`) VALUES +(3765, 1275), +(2864, 2865), +(13226,13036), +(13227,13036); + +UPDATE `quest_template_addon` SET `BreadcrumbForQuestId`=1846 WHERE `ID` IN (1841); +UPDATE `quest_template_addon` SET `BreadcrumbForQuestId`=1844 WHERE `ID` IN (1840); +UPDATE `quest_template_addon` SET `BreadcrumbForQuestId`=1842 WHERE `ID` IN (1839); +UPDATE `quest_template_addon` SET `PrevQuestID`=0,`ExclusiveGroup`=0, `BreadcrumbForQuestId`=6383 WHERE `ID` IN (742,6382,235); |