From 4eb6b0156d7e46fe92e2550ce21ba553c705e0a0 Mon Sep 17 00:00:00 2001 From: Shauren Date: Thu, 16 Nov 2023 21:18:06 +0100 Subject: Core/Instances: Fixed initializing instance id sequence generator --- src/server/game/Instances/InstanceLockMgr.cpp | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'src/server/game/Instances/InstanceLockMgr.cpp') diff --git a/src/server/game/Instances/InstanceLockMgr.cpp b/src/server/game/Instances/InstanceLockMgr.cpp index 44aaeb145ea..bf84985bdea 100644 --- a/src/server/game/Instances/InstanceLockMgr.cpp +++ b/src/server/game/Instances/InstanceLockMgr.cpp @@ -121,8 +121,9 @@ void InstanceLockMgr::Load() } while (result->NextRow()); } + // ORDER BY required by MapManager::RegisterInstanceId // 0 1 2 3 4 5 6 7 8 - if (QueryResult result = CharacterDatabase.Query("SELECT guid, mapId, lockId, instanceId, difficulty, data, completedEncountersMask, expiryTime, extended FROM character_instance_lock")) + if (QueryResult result = CharacterDatabase.Query("SELECT guid, mapId, lockId, instanceId, difficulty, data, completedEncountersMask, expiryTime, extended FROM character_instance_lock ORDER BY instanceId")) { do { -- cgit v1.2.3