diff options
| -rw-r--r-- | sql/updates/world/master/2017_07_09_00_world.sql | 2 | ||||
| -rw-r--r-- | src/server/game/Globals/ObjectMgr.cpp | 2 |
2 files changed, 3 insertions, 1 deletions
diff --git a/sql/updates/world/master/2017_07_09_00_world.sql b/sql/updates/world/master/2017_07_09_00_world.sql new file mode 100644 index 00000000000..43730904c3e --- /dev/null +++ b/sql/updates/world/master/2017_07_09_00_world.sql @@ -0,0 +1,2 @@ +-- Note: quest_objectives need new full parse to get proper Order +ALTER TABLE `quest_objectives` ADD COLUMN `Order` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `Type`; diff --git a/src/server/game/Globals/ObjectMgr.cpp b/src/server/game/Globals/ObjectMgr.cpp index 9acb9f6b5de..fd7f7da0020 100644 --- a/src/server/game/Globals/ObjectMgr.cpp +++ b/src/server/game/Globals/ObjectMgr.cpp @@ -4015,7 +4015,7 @@ void ObjectMgr::LoadQuests() // Load `quest_objectives` // 0 1 2 3 4 5 6 7 8 9 - result = WorldDatabase.Query("SELECT ID, QuestID, Type, StorageIndex, ObjectID, Amount, Flags, Flags2, ProgressBarWeight, Description FROM quest_objectives ORDER BY StorageIndex ASC"); + result = WorldDatabase.Query("SELECT ID, QuestID, Type, StorageIndex, ObjectID, Amount, Flags, Flags2, ProgressBarWeight, Description FROM quest_objectives ORDER BY Order ASC, StorageIndex ASC"); if (!result) { |