diff options
| -rw-r--r-- | sql/updates/world/master/2023_10_23_03_world.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_10_23_03_world.sql b/sql/updates/world/master/2023_10_23_03_world.sql new file mode 100644 index 00000000000..b3b46e71aeb --- /dev/null +++ b/sql/updates/world/master/2023_10_23_03_world.sql @@ -0,0 +1,6 @@ +UPDATE `quest_template_addon` SET `ProvidedItemCount`=1 WHERE `ID` IN (11332,26248,26766,26861,26876,31514,31516,34422,40195,40541,41148,48016,54951,59930,72424,72644,75265); + +INSERT INTO `quest_template_addon` (`ID`, `ProvidedItemCount`) +(SELECT qt.`ID`, 1 FROM `quest_template` qt +LEFT JOIN `quest_template_addon` qta ON qta.`ID` = qt.`ID` +WHERE qt.`StartItem`!=0 AND qta.`ProvidedItemCount` IS NULL); |