Jump to content

[9916][FIX] error when using .account onlinelist


Auntie Mangos

Recommended Posts

What bug does the patch fix? What features does the patch add?

This fixes an error when using .account onlinelist

the error will popup that the column "realm" doesn't exist in the realmd.account table

For which repository revision was the patch created?

9913

Is there a thread in the bug report section or at lighthouse?

http://getmangos.eu/community/showthread.php?13901-Error-warning-when-using-.account-onlinelist

Who has been writing this patch?

Splash

diff --git a/src/mangosd/CliRunnable.cpp b/src/mangosd/CliRunnable.cpp
index 1f11037..549d578 100644
--- a/src/mangosd/CliRunnable.cpp
+++ b/src/mangosd/CliRunnable.cpp
@@ -483,7 +483,7 @@ bool ChatHandler::HandleAccountOnlineListCommand(const char* args)

    ///- Get the list of accounts ID logged to the realm
    //                                                 0   1         2        3        4
-    QueryResult *result = loginDatabase.PQuery("SELECT id, username, last_ip, gmlevel, expansion FROM account WHERE realm = %u", realmID);
+    QueryResult *result = loginDatabase.PQuery("SELECT id, username, last_ip, gmlevel, expansion FROM account WHERE active_realm_id = %u", realmID);

    return ShowAccountListHelper(result,&limit);
}

Link to comment
Share on other sites

  • 40 years later...
Guest
This topic is now closed to further replies.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use