From 0d3235f56969a6e414071edbb669ac63b4398958 Mon Sep 17 00:00:00 2001 From: Shauren Date: Sun, 9 Jan 2022 21:40:27 +0100 Subject: Core/Guilds: Separate guild rank id from guild rank order Co-authored-by: aquadeus --- src/server/game/Guilds/GuildMgr.cpp | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'src/server/game/Guilds/GuildMgr.cpp') diff --git a/src/server/game/Guilds/GuildMgr.cpp b/src/server/game/Guilds/GuildMgr.cpp index e7ac7df19c0..a497d20b652 100644 --- a/src/server/game/Guilds/GuildMgr.cpp +++ b/src/server/game/Guilds/GuildMgr.cpp @@ -168,8 +168,8 @@ void GuildMgr::LoadGuilds() // Delete orphaned guild rank entries before loading the valid ones CharacterDatabase.DirectExecute("DELETE gr FROM guild_rank gr LEFT JOIN guild g ON gr.guildId = g.guildId WHERE g.guildId IS NULL"); - // 0 1 2 3 4 - QueryResult result = CharacterDatabase.Query("SELECT guildid, rid, rname, rights, BankMoneyPerDay FROM guild_rank ORDER BY guildid ASC, rid ASC"); + // 0 1 2 3 4 5 + QueryResult result = CharacterDatabase.Query("SELECT guildid, rid, RankOrder, rname, rights, BankMoneyPerDay FROM guild_rank ORDER BY guildid ASC, rid ASC"); if (!result) { -- cgit v1.2.3