diff options
| author | Subv2112 <s.v.h21@hotmail.com> | 2012-01-28 16:03:36 -0500 |
|---|---|---|
| committer | Subv2112 <s.v.h21@hotmail.com> | 2012-01-28 16:03:36 -0500 |
| commit | 03953930f91915cfa128f44dbb298c482e7589bd (patch) | |
| tree | 552ea0d0d883fd6d06b44b9c2c432a2b78f0d580 /src/server/game/Chat | |
| parent | 7d0ec97910890f8c3b0a2ff180c29db8a8292e82 (diff) | |
Scripts/Commands: Adjust .pinfo and .gm list to respect the realmid in account_access table.
closes #1306
Signed-off-by: Subv2112 <s.v.h21@hotmail.com>
Diffstat (limited to 'src/server/game/Chat')
| -rwxr-xr-x | src/server/game/Chat/Commands/Level2.cpp | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/server/game/Chat/Commands/Level2.cpp b/src/server/game/Chat/Commands/Level2.cpp index 31942d9e2fa..68961b9de61 100755 --- a/src/server/game/Chat/Commands/Level2.cpp +++ b/src/server/game/Chat/Commands/Level2.cpp @@ -332,8 +332,8 @@ bool ChatHandler::HandlePInfoCommand(const char* args) QueryResult result = LoginDatabase.PQuery("SELECT a.username, aa.gmlevel, a.email, a.last_ip, a.last_login, a.mutetime " "FROM account a " "LEFT JOIN account_access aa " - "ON (a.id = aa.id) " - "WHERE a.id = '%u'", accId); + "ON (a.id = aa.id AND (aa.RealmID = -1 OR aa.RealmID = %u)) " + "WHERE a.id = '%u'", realmID, accId); if (result) { Field* fields = result->Fetch(); |