diff options
| -rw-r--r-- | sql/base/world_database.sql | 1 | ||||
| -rw-r--r-- | sql/updates/9958_world_quest_poi_points.sql | 1 | ||||
| -rw-r--r-- | src/server/game/Globals/ObjectMgr.cpp | 2 |
3 files changed, 3 insertions, 1 deletions
diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql index e73a3b1aab4..607278675fb 100644 --- a/sql/base/world_database.sql +++ b/sql/base/world_database.sql @@ -16255,6 +16255,7 @@ DROP TABLE IF EXISTS `quest_poi_points`; CREATE TABLE `quest_poi_points` ( `questId` int(10) UNSIGNED NOT NULL DEFAULT '0', `id` int(10) UNSIGNED NOT NULL DEFAULT '0', + `idx` int(10) unsigned NOT NULL DEFAULT '0', `x` int(10) NOT NULL DEFAULT '0', `y` int(10) NOT NULL DEFAULT '0', KEY `questId_id` (`questId`,`id`) diff --git a/sql/updates/9958_world_quest_poi_points.sql b/sql/updates/9958_world_quest_poi_points.sql new file mode 100644 index 00000000000..fa1962878a0 --- /dev/null +++ b/sql/updates/9958_world_quest_poi_points.sql @@ -0,0 +1 @@ +ALTER TABLE `quest_poi_points` ADD COLUMN `idx` int(10) unsigned NOT NULL DEFAULT '0' AFTER `id`; diff --git a/src/server/game/Globals/ObjectMgr.cpp b/src/server/game/Globals/ObjectMgr.cpp index 0d314b39c6b..7255f56808b 100644 --- a/src/server/game/Globals/ObjectMgr.cpp +++ b/src/server/game/Globals/ObjectMgr.cpp @@ -7090,7 +7090,7 @@ void ObjectMgr::LoadQuestPOI() QuestPOI POI(id, objIndex, mapId, WorldMapAreaId, FloorId, unk3, unk4); - QueryResult points = WorldDatabase.PQuery("SELECT x, y FROM quest_poi_points WHERE questId='%u' AND id='%i'", questId, id); + QueryResult points = WorldDatabase.PQuery("SELECT x, y FROM quest_poi_points WHERE questId='%u' AND id='%i' ORDER BY idx", questId, id); if (points) { |