diff options
| author | Shauren <shauren.trinity@gmail.com> | 2016-12-18 12:35:27 +0100 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2016-12-18 12:35:27 +0100 |
| commit | b633d61899bbbd723d4c0b2cbc850d5b686be46c (patch) | |
| tree | d7a79b34779399be1ab823d39572500794038cb8 /src/server/scripts/Commands | |
| parent | bc758991140e961ceac46b17b766b0d54b8129fb (diff) | |
Core/Commands: Added new 'bnetaccount listgameaccounts' command to display all `account` table entries linked to a given battle.net email
* Also fixed errors about bad commands in db
Closes #18474
Diffstat (limited to 'src/server/scripts/Commands')
| -rw-r--r-- | src/server/scripts/Commands/cs_battlenet_account.cpp | 49 |
1 files changed, 42 insertions, 7 deletions
diff --git a/src/server/scripts/Commands/cs_battlenet_account.cpp b/src/server/scripts/Commands/cs_battlenet_account.cpp index beca60abc10..fea267822d8 100644 --- a/src/server/scripts/Commands/cs_battlenet_account.cpp +++ b/src/server/scripts/Commands/cs_battlenet_account.cpp @@ -43,13 +43,14 @@ public: static std::vector<ChatCommand> accountCommandTable = { - { "create", rbac::RBAC_PERM_COMMAND_BNET_ACCOUNT_CREATE, true, &HandleAccountCreateCommand, "" }, - { "gameaccountcreate", rbac::RBAC_PERM_COMMAND_BNET_ACCOUNT_CREATE_GAME, true, &HandleGameAccountCreateCommand, "" }, - { "lock", rbac::RBAC_PERM_COMMAND_BNET_ACCOUNT, false, NULL, "", accountLockCommandTable }, - { "set", rbac::RBAC_PERM_COMMAND_BNET_ACCOUNT_SET, true, NULL, "", accountSetCommandTable }, - { "password", rbac::RBAC_PERM_COMMAND_BNET_ACCOUNT_PASSWORD, false, &HandleAccountPasswordCommand, "" }, - { "link", rbac::RBAC_PERM_COMMAND_BNET_ACCOUNT_LINK, true, &HandleAccountLinkCommand, "" }, - { "unlink", rbac::RBAC_PERM_COMMAND_BNET_ACCOUNT_UNLINK, true, &HandleAccountUnlinkCommand, "" }, + { "create", rbac::RBAC_PERM_COMMAND_BNET_ACCOUNT_CREATE, true, &HandleAccountCreateCommand, "" }, + { "gameaccountcreate", rbac::RBAC_PERM_COMMAND_BNET_ACCOUNT_CREATE_GAME, true, &HandleGameAccountCreateCommand, "" }, + { "lock", rbac::RBAC_PERM_COMMAND_BNET_ACCOUNT, false, NULL, "", accountLockCommandTable }, + { "set", rbac::RBAC_PERM_COMMAND_BNET_ACCOUNT_SET, true, NULL, "", accountSetCommandTable }, + { "password", rbac::RBAC_PERM_COMMAND_BNET_ACCOUNT_PASSWORD, false, &HandleAccountPasswordCommand, "" }, + { "link", rbac::RBAC_PERM_COMMAND_BNET_ACCOUNT_LINK, true, &HandleAccountLinkCommand, "" }, + { "unlink", rbac::RBAC_PERM_COMMAND_BNET_ACCOUNT_UNLINK, true, &HandleAccountUnlinkCommand, "" }, + { "listgameaccounts", rbac::RBAC_PERM_COMMAND_BNET_ACCOUNT_LIST_GAME_ACCOUTNS, true, &HandleListGameAccountsCommand, "" } }; static std::vector<ChatCommand> commandTable = @@ -460,6 +461,40 @@ public: return true; } + + static bool HandleListGameAccountsCommand(ChatHandler* handler, char const* args) + { + if (!*args) + return false; + + char* battlenetAccountName = strtok((char*)args, " "); + PreparedStatement* stmt = LoginDatabase.GetPreparedStatement(LOGIN_SEL_BNET_GAME_ACCOUNT_LIST); + stmt->setString(0, battlenetAccountName); + if (PreparedQueryResult accountList = LoginDatabase.Query(stmt)) + { + auto formatDisplayName = [](char const* name) -> std::string + { + if (char const* hashPos = strchr(name, '#')) + return std::string("WoW") + ++hashPos; + else + return name; + }; + + handler->SendSysMessage("----------------------------------------------------"); + handler->SendSysMessage(LANG_ACCOUNT_BNET_LIST_HEADER); + handler->SendSysMessage("----------------------------------------------------"); + do + { + Field* fields = accountList->Fetch(); + handler->PSendSysMessage("| %10u | %-16.16s | %-16.16s |", fields[0].GetUInt32(), fields[1].GetCString(), formatDisplayName(fields[1].GetCString()).c_str()); + } while (accountList->NextRow()); + handler->SendSysMessage("----------------------------------------------------"); + } + else + handler->PSendSysMessage(LANG_ACCOUNT_BNET_LIST_NO_ACCOUNTS, battlenetAccountName); + + return true; + } }; void AddSC_battlenet_account_commandscript() |