diff options
| author | Shauren <none@none> | 2010-09-16 19:58:06 +0200 |
|---|---|---|
| committer | Shauren <none@none> | 2010-09-16 19:58:06 +0200 |
| commit | 05ccd476be9bf9047aff2d4ff8f5fc5d02dc81f1 (patch) | |
| tree | 1f13fc2d565d955aa3c354d54cf8c81ff3ad7f96 | |
| parent | 502a81372078b3ec864ea98969f8afa9c53fd4dc (diff) | |
Core/Quests: Added index column for quest poi points forcing them to load in certain order
--HG--
branch : trunk
| -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) { |