aboutsummaryrefslogtreecommitdiff
path: root/src/game/Level3.cpp
diff options
context:
space:
mode:
Diffstat (limited to 'src/game/Level3.cpp')
-rw-r--r--src/game/Level3.cpp15
1 files changed, 4 insertions, 11 deletions
diff --git a/src/game/Level3.cpp b/src/game/Level3.cpp
index bf25943ea46..64021b3708b 100644
--- a/src/game/Level3.cpp
+++ b/src/game/Level3.cpp
@@ -4824,25 +4824,18 @@ bool ChatHandler::HandleBanInfoCommand(const char* args)
return false;
}
- loginDatabase.escape_string(nameOrIP);
- QueryResult *result = CharacterDatabase.PQuery("SELECT account FROM characters WHERE name = '%s'", nameOrIP.c_str());
- if (!result)
+ accountid = objmgr.GetPlayerAccountIdByPlayerName (nameOrIP);
+ if (!accountid)
{
PSendSysMessage(LANG_BANINFO_NOCHARACTER);
return true;
}
- fields = result->Fetch();
- accountid = fields[0].GetUInt32();
- delete result;
- result = loginDatabase.PQuery("SELECT username FROM account WHERE id = '%u'", accountid);
- if (!result)
+
+ if (!accmgr.GetName (accountid,accountname))
{
PSendSysMessage(LANG_BANINFO_NOCHARACTER);
return true;
}
- fields = result->Fetch();
- accountname = fields[0].GetCppString();
- delete result;
}
else
return false;