From 05ccd476be9bf9047aff2d4ff8f5fc5d02dc81f1 Mon Sep 17 00:00:00 2001 From: Shauren Date: Thu, 16 Sep 2010 19:58:06 +0200 Subject: Core/Quests: Added index column for quest poi points forcing them to load in certain order --HG-- branch : trunk --- sql/base/world_database.sql | 1 + sql/updates/9958_world_quest_poi_points.sql | 1 + src/server/game/Globals/ObjectMgr.cpp | 2 +- 3 files changed, 3 insertions(+), 1 deletion(-) create mode 100644 sql/updates/9958_world_quest_poi_points.sql 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) { -- cgit v1.2.3