diff options
| author | Meji <alvaro.megias@outlook.com> | 2024-05-22 20:58:37 +0200 |
|---|---|---|
| committer | Ovahlord <dreadkiller@gmx.de> | 2024-05-28 17:12:33 +0200 |
| commit | f9b82b2222eb08af6bb19db21b296863cfa11b59 (patch) | |
| tree | 1c0d9fe436ea44b3a5d80173d4cda7df97b64815 | |
| parent | c99fb5df4d87c5285108ebbcdfd77bf6cbcaa1a3 (diff) | |
DB/Quests: Init ProvidedItemCount for quests using StartItem
(cherry picked from commit 0c809efd8692826d961b9638ca8c5b77db48075d)
| -rw-r--r-- | sql/updates/world/master/2024_05_22_04_world.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/master/2024_05_22_04_world.sql b/sql/updates/world/master/2024_05_22_04_world.sql new file mode 100644 index 00000000000..be7cf02d729 --- /dev/null +++ b/sql/updates/world/master/2024_05_22_04_world.sql @@ -0,0 +1,4 @@ +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); |