Created
December 30, 2013 15:09
-
-
Save zabustak/8183165 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| * Copyright (C) 2008-2013 TrinityCore <http://www.trinitycore.org/> | |
| * | |
| * This program is free software; you can redistribute it and/or modify it | |
| * under the terms of the GNU General Public License as published by the | |
| * Free Software Foundation; either version 2 of the License, or (at your | |
| * option) any later version. | |
| * | |
| * This program is distributed in the hope that it will be useful, but WITHOUT | |
| * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or | |
| * FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for | |
| * more details. | |
| * | |
| * You should have received a copy of the GNU General Public License along | |
| * with this program. If not, see <http://www.gnu.org/licenses/>. | |
| */ | |
| /* ScriptData | |
| Name: ban_commandscript | |
| %Complete: 100 | |
| Comment: All ban related commands | |
| Category: commandscripts | |
| EndScriptData */ | |
| #include "AccountMgr.h" | |
| #include "Chat.h" | |
| #include "Language.h" | |
| #include "ObjectAccessor.h" | |
| #include "ObjectMgr.h" | |
| #include "Player.h" | |
| #include "ScriptMgr.h" | |
| class ban_commandscript : public CommandScript | |
| { | |
| public: | |
| ban_commandscript() : CommandScript("ban_commandscript") { } | |
| ChatCommand* GetCommands() const OVERRIDE | |
| { | |
| static ChatCommand unbanCommandTable[] = | |
| { | |
| { "account", rbac::RBAC_PERM_COMMAND_UNBAN_ACCOUNT, true, &HandleUnBanAccountCommand, "", NULL }, | |
| { "character", rbac::RBAC_PERM_COMMAND_UNBAN_CHARACTER, true, &HandleUnBanCharacterCommand, "", NULL }, | |
| { "playeraccount", rbac::RBAC_PERM_COMMAND_UNBAN_PLAYERACCOUNT, true, &HandleUnBanAccountByCharCommand, "", NULL }, | |
| { "ip", rbac::RBAC_PERM_COMMAND_UNBAN_IP, true, &HandleUnBanIPCommand, "", NULL }, | |
| { NULL, 0, false, NULL, "", NULL } | |
| }; | |
| static ChatCommand banlistCommandTable[] = | |
| { | |
| { "account", rbac::RBAC_PERM_COMMAND_BANLIST_ACCOUNT, true, &HandleBanListAccountCommand, "", NULL }, | |
| { "character", rbac::RBAC_PERM_COMMAND_BANLIST_CHARACTER, true, &HandleBanListCharacterCommand, "", NULL }, | |
| { "ip", rbac::RBAC_PERM_COMMAND_BANLIST_IP, true, &HandleBanListIPCommand, "", NULL }, | |
| { NULL, 0, false, NULL, "", NULL } | |
| }; | |
| static ChatCommand baninfoCommandTable[] = | |
| { | |
| { "account", rbac::RBAC_PERM_COMMAND_BANINFO_ACCOUNT, true, &HandleBanInfoAccountCommand, "", NULL }, | |
| { "character", rbac::RBAC_PERM_COMMAND_BANINFO_CHARACTER, true, &HandleBanInfoCharacterCommand, "", NULL }, | |
| { "ip", rbac::RBAC_PERM_COMMAND_BANINFO_IP, true, &HandleBanInfoIPCommand, "", NULL }, | |
| { NULL, 0, false, NULL, "", NULL } | |
| }; | |
| static ChatCommand banCommandTable[] = | |
| { | |
| { "account", rbac::RBAC_PERM_COMMAND_BAN_ACCOUNT, true, &HandleBanAccountCommand, "", NULL }, | |
| { "character", rbac::RBAC_PERM_COMMAND_BAN_CHARACTER, true, &HandleBanCharacterCommand, "", NULL }, | |
| { "playeraccount", rbac::RBAC_PERM_COMMAND_BAN_PLAYERACCOUNT, true, &HandleBanAccountByCharCommand, "", NULL }, | |
| { "ip", rbac::RBAC_PERM_COMMAND_BAN_IP, true, &HandleBanIPCommand, "", NULL }, | |
| { NULL, 0, false, NULL, "", NULL } | |
| }; | |
| static ChatCommand commandTable[] = | |
| { | |
| { "ban", rbac::RBAC_PERM_COMMAND_BAN, true, NULL, "", banCommandTable }, | |
| { "baninfo", rbac::RBAC_PERM_COMMAND_BANINFO, true, NULL, "", baninfoCommandTable }, | |
| { "banlist", rbac::RBAC_PERM_COMMAND_BANLIST, true, NULL, "", banlistCommandTable }, | |
| { "unban", rbac::RBAC_PERM_COMMAND_UNBAN, true, NULL, "", unbanCommandTable }, | |
| { NULL, 0, false, NULL, "", NULL } | |
| }; | |
| return commandTable; | |
| } | |
| static bool HandleBanAccountCommand(ChatHandler* handler, char const* args) | |
| { | |
| return HandleBanHelper(BAN_ACCOUNT, args, handler); | |
| } | |
| static bool HandleBanCharacterCommand(ChatHandler* handler, char const* args) | |
| { | |
| if (!*args) | |
| return false; | |
| char* nameStr = strtok((char*)args, " "); | |
| if (!nameStr) | |
| return false; | |
| std::string name = nameStr; | |
| char* durationStr = strtok(NULL, " "); | |
| if (!durationStr || !atoi(durationStr)) | |
| return false; | |
| char* reasonStr = strtok(NULL, ""); | |
| if (!reasonStr) | |
| return false; | |
| if (!normalizePlayerName(name)) | |
| { | |
| handler->SendSysMessage(LANG_PLAYER_NOT_FOUND); | |
| handler->SetSentErrorMessage(true); | |
| return false; | |
| } | |
| switch (sWorld->BanCharacter(name, durationStr, reasonStr, handler->GetSession() ? handler->GetSession()->GetPlayerName().c_str() : "")) | |
| { | |
| case BAN_SUCCESS: | |
| { | |
| if (atoi(durationStr) > 0) | |
| if (sWorld->getBoolConfig(CONFIG_SHOW_BAN_IN_WORLD)) | |
| { | |
| sWorld->SendWorldText(LANG_BAN_CHARACTER_YOUBANNEDMESSAGE_WORLD, handler->GetSession()->GetPlayerName().c_str(), name.c_str(), secsToTimeString(TimeStringToSecs(durationStr), true).c_str(), reasonStr); | |
| } | |
| else | |
| { | |
| handler->PSendSysMessage(LANG_BAN_YOUBANNED, name.c_str(), secsToTimeString(TimeStringToSecs(durationStr), true).c_str(), reasonStr); | |
| } | |
| else | |
| if (sWorld->getBoolConfig(CONFIG_SHOW_BAN_IN_WORLD)) | |
| { | |
| sWorld->SendWorldText(LANG_BAN_CHARACTER_YOUPERMBANNEDMESSAGE_WORLD, handler->GetSession()->GetPlayerName().c_str(), name.c_str(), reasonStr); | |
| } | |
| else | |
| { | |
| handler->PSendSysMessage(LANG_BAN_YOUPERMBANNED, name.c_str(), reasonStr); | |
| } | |
| break; | |
| } | |
| case BAN_NOTFOUND: | |
| { | |
| handler->PSendSysMessage(LANG_BAN_NOTFOUND, "character", name.c_str()); | |
| handler->SetSentErrorMessage(true); | |
| return false; | |
| } | |
| default: | |
| break; | |
| } | |
| return true; | |
| } | |
| static bool HandleBanAccountByCharCommand(ChatHandler* handler, char const* args) | |
| { | |
| return HandleBanHelper(BAN_CHARACTER, args, handler); | |
| } | |
| static bool HandleBanIPCommand(ChatHandler* handler, char const* args) | |
| { | |
| return HandleBanHelper(BAN_IP, args, handler); | |
| } | |
| static bool HandleBanHelper(BanMode mode, char const* args, ChatHandler* handler) | |
| { | |
| if (!*args) | |
| return false; | |
| char* cnameOrIP = strtok((char*)args, " "); | |
| if (!cnameOrIP) | |
| return false; | |
| std::string nameOrIP = cnameOrIP; | |
| char* durationStr = strtok(NULL, " "); | |
| if (!durationStr || !atoi(durationStr)) | |
| return false; | |
| char* reasonStr = strtok(NULL, ""); | |
| if (!reasonStr) | |
| return false; | |
| switch (mode) | |
| { | |
| case BAN_ACCOUNT: | |
| if (!AccountMgr::normalizeString(nameOrIP)) | |
| { | |
| handler->PSendSysMessage(LANG_ACCOUNT_NOT_EXIST, nameOrIP.c_str()); | |
| handler->SetSentErrorMessage(true); | |
| return false; | |
| } | |
| break; | |
| case BAN_CHARACTER: | |
| if (!normalizePlayerName(nameOrIP)) | |
| { | |
| handler->SendSysMessage(LANG_PLAYER_NOT_FOUND); | |
| handler->SetSentErrorMessage(true); | |
| return false; | |
| } | |
| break; | |
| case BAN_IP: | |
| if (!IsIPAddress(nameOrIP.c_str())) | |
| return false; | |
| break; | |
| } | |
| switch (sWorld->BanAccount(mode, nameOrIP, durationStr, reasonStr, handler->GetSession() ? handler->GetSession()->GetPlayerName().c_str() : "")) | |
| { | |
| case BAN_SUCCESS: | |
| if (atoi(durationStr) > 0) | |
| if (sWorld->getBoolConfig(CONFIG_SHOW_BAN_IN_WORLD)) | |
| { | |
| sWorld->SendWorldText(LANG_BAN_ACCOUNT_YOUBANNEDMESSAGE_WORLD, handler->GetSession()->GetPlayerName().c_str(), nameOrIP.c_str(), secsToTimeString(TimeStringToSecs(durationStr), true).c_str(), reasonStr); | |
| } | |
| else | |
| { | |
| handler->PSendSysMessage(LANG_BAN_YOUBANNED, nameOrIP.c_str(), secsToTimeString(TimeStringToSecs(durationStr), true).c_str(), reasonStr); | |
| } | |
| else | |
| if (sWorld->getBoolConfig(CONFIG_SHOW_BAN_IN_WORLD)) | |
| { | |
| sWorld->SendWorldText(LANG_BAN_ACCOUNT_YOUPERMBANNEDMESSAGE_WORLD, handler->GetSession()->GetPlayerName().c_str(), nameOrIP.c_str(), reasonStr); | |
| } | |
| else | |
| { | |
| handler->PSendSysMessage(LANG_BAN_YOUPERMBANNED, nameOrIP.c_str(), reasonStr); | |
| } | |
| break; | |
| case BAN_SYNTAX_ERROR: | |
| return false; | |
| case BAN_NOTFOUND: | |
| switch (mode) | |
| { | |
| default: | |
| handler->PSendSysMessage(LANG_BAN_NOTFOUND, "account", nameOrIP.c_str()); | |
| break; | |
| case BAN_CHARACTER: | |
| handler->PSendSysMessage(LANG_BAN_NOTFOUND, "character", nameOrIP.c_str()); | |
| break; | |
| case BAN_IP: | |
| handler->PSendSysMessage(LANG_BAN_NOTFOUND, "ip", nameOrIP.c_str()); | |
| break; | |
| } | |
| handler->SetSentErrorMessage(true); | |
| return false; | |
| } | |
| return true; | |
| } | |
| static bool HandleBanInfoAccountCommand(ChatHandler* handler, char const* args) | |
| { | |
| if (!*args) | |
| return false; | |
| char* nameStr = strtok((char*)args, ""); | |
| if (!nameStr) | |
| return false; | |
| std::string accountName = nameStr; | |
| if (!AccountMgr::normalizeString(accountName)) | |
| { | |
| handler->PSendSysMessage(LANG_ACCOUNT_NOT_EXIST, accountName.c_str()); | |
| handler->SetSentErrorMessage(true); | |
| return false; | |
| } | |
| uint32 accountId = AccountMgr::GetId(accountName); | |
| if (!accountId) | |
| { | |
| handler->PSendSysMessage(LANG_ACCOUNT_NOT_EXIST, accountName.c_str()); | |
| return true; | |
| } | |
| return HandleBanInfoHelper(accountId, accountName.c_str(), handler); | |
| } | |
| static bool HandleBanInfoHelper(uint32 accountId, char const* accountName, ChatHandler* handler) | |
| { | |
| QueryResult result = LoginDatabase.PQuery("SELECT FROM_UNIXTIME(bandate), unbandate-bandate, active, unbandate, banreason, bannedby FROM account_banned WHERE id = '%u' ORDER BY bandate ASC", accountId); | |
| if (!result) | |
| { | |
| handler->PSendSysMessage(LANG_BANINFO_NOACCOUNTBAN, accountName); | |
| return true; | |
| } | |
| handler->PSendSysMessage(LANG_BANINFO_BANHISTORY, accountName); | |
| do | |
| { | |
| Field* fields = result->Fetch(); | |
| time_t unbanDate = time_t(fields[3].GetUInt32()); | |
| bool active = false; | |
| if (fields[2].GetBool() && (fields[1].GetUInt64() == uint64(0) || unbanDate >= time(NULL))) | |
| active = true; | |
| bool permanent = (fields[1].GetUInt64() == uint64(0)); | |
| std::string banTime = permanent ? handler->GetTrinityString(LANG_BANINFO_INFINITE) : secsToTimeString(fields[1].GetUInt64(), true); | |
| handler->PSendSysMessage(LANG_BANINFO_HISTORYENTRY, | |
| fields[0].GetCString(), banTime.c_str(), active ? handler->GetTrinityString(LANG_BANINFO_YES) : handler->GetTrinityString(LANG_BANINFO_NO), fields[4].GetCString(), fields[5].GetCString()); | |
| } | |
| while (result->NextRow()); | |
| return true; | |
| } | |
| static bool HandleBanInfoCharacterCommand(ChatHandler* handler, char const* args) | |
| { | |
| if (!*args) | |
| return false; | |
| Player* target = sObjectAccessor->FindPlayerByName(args); | |
| uint32 targetGuid = 0; | |
| std::string name(args); | |
| if (!target) | |
| { | |
| PreparedStatement* stmt = CharacterDatabase.GetPreparedStatement(CHAR_SEL_GUID_BY_NAME); | |
| stmt->setString(0, name); | |
| PreparedQueryResult resultCharacter = CharacterDatabase.Query(stmt); | |
| if (!resultCharacter) | |
| { | |
| handler->PSendSysMessage(LANG_BANINFO_NOCHARACTER); | |
| return false; | |
| } | |
| targetGuid = (*resultCharacter)[0].GetUInt32(); | |
| } | |
| else | |
| targetGuid = target->GetGUIDLow(); | |
| PreparedStatement* stmt = CharacterDatabase.GetPreparedStatement(CHAR_SEL_BANINFO); | |
| stmt->setUInt32(0, targetGuid); | |
| PreparedQueryResult result = CharacterDatabase.Query(stmt); | |
| if (!result) | |
| { | |
| handler->PSendSysMessage(LANG_CHAR_NOT_BANNED, name.c_str()); | |
| return true; | |
| } | |
| handler->PSendSysMessage(LANG_BANINFO_BANHISTORY, name.c_str()); | |
| do | |
| { | |
| Field* fields = result->Fetch(); | |
| time_t unbanDate = time_t(fields[3].GetUInt32()); | |
| bool active = false; | |
| if (fields[2].GetUInt8() && (!fields[1].GetUInt32() || unbanDate >= time(NULL))) | |
| active = true; | |
| bool permanent = (fields[1].GetUInt32() == uint32(0)); | |
| std::string banTime = permanent ? handler->GetTrinityString(LANG_BANINFO_INFINITE) : secsToTimeString(fields[1].GetUInt32(), true); | |
| handler->PSendSysMessage(LANG_BANINFO_HISTORYENTRY, | |
| fields[0].GetCString(), banTime.c_str(), active ? handler->GetTrinityString(LANG_BANINFO_YES) : handler->GetTrinityString(LANG_BANINFO_NO), fields[4].GetCString(), fields[5].GetCString()); | |
| } | |
| while (result->NextRow()); | |
| return true; | |
| } | |
| static bool HandleBanInfoIPCommand(ChatHandler* handler, char const* args) | |
| { | |
| if (!*args) | |
| return false; | |
| char* ipStr = strtok((char*)args, ""); | |
| if (!ipStr) | |
| return false; | |
| if (!IsIPAddress(ipStr)) | |
| return false; | |
| std::string IP = ipStr; | |
| LoginDatabase.EscapeString(IP); | |
| QueryResult result = LoginDatabase.PQuery("SELECT ip, FROM_UNIXTIME(bandate), FROM_UNIXTIME(unbandate), unbandate-UNIX_TIMESTAMP(), banreason, bannedby, unbandate-bandate FROM ip_banned WHERE ip = '%s'", IP.c_str()); | |
| if (!result) | |
| { | |
| handler->PSendSysMessage(LANG_BANINFO_NOIP); | |
| return true; | |
| } | |
| Field* fields = result->Fetch(); | |
| bool permanent = !fields[6].GetUInt64(); | |
| handler->PSendSysMessage(LANG_BANINFO_IPENTRY, | |
| fields[0].GetCString(), fields[1].GetCString(), permanent ? handler->GetTrinityString(LANG_BANINFO_NEVER) : fields[2].GetCString(), | |
| permanent ? handler->GetTrinityString(LANG_BANINFO_INFINITE) : secsToTimeString(fields[3].GetUInt64(), true).c_str(), fields[4].GetCString(), fields[5].GetCString()); | |
| return true; | |
| } | |
| static bool HandleBanListAccountCommand(ChatHandler* handler, char const* args) | |
| { | |
| PreparedStatement* stmt = LoginDatabase.GetPreparedStatement(LOGIN_DEL_EXPIRED_IP_BANS); | |
| LoginDatabase.Execute(stmt); | |
| char* filterStr = strtok((char*)args, " "); | |
| std::string filter = filterStr ? filterStr : ""; | |
| PreparedQueryResult result; | |
| if (filter.empty()) | |
| { | |
| PreparedStatement* stmt = LoginDatabase.GetPreparedStatement(LOGIN_SEL_ACCOUNT_BANNED_ALL); | |
| result = LoginDatabase.Query(stmt); | |
| } | |
| else | |
| { | |
| PreparedStatement* stmt = LoginDatabase.GetPreparedStatement(LOGIN_SEL_ACCOUNT_BANNED_BY_USERNAME); | |
| stmt->setString(0, filter); | |
| result = LoginDatabase.Query(stmt); | |
| } | |
| if (!result) | |
| { | |
| handler->PSendSysMessage(LANG_BANLIST_NOACCOUNT); | |
| return true; | |
| } | |
| return HandleBanListHelper(result, handler); | |
| } | |
| static bool HandleBanListHelper(PreparedQueryResult result, ChatHandler* handler) | |
| { | |
| handler->PSendSysMessage(LANG_BANLIST_MATCHINGACCOUNT); | |
| // Chat short output | |
| if (handler->GetSession()) | |
| { | |
| do | |
| { | |
| Field* fields = result->Fetch(); | |
| uint32 accountid = fields[0].GetUInt32(); | |
| QueryResult banResult = LoginDatabase.PQuery("SELECT account.username FROM account, account_banned WHERE account_banned.id='%u' AND account_banned.id=account.id", accountid); | |
| if (banResult) | |
| { | |
| Field* fields2 = banResult->Fetch(); | |
| handler->PSendSysMessage("%s", fields2[0].GetCString()); | |
| } | |
| } | |
| while (result->NextRow()); | |
| } | |
| // Console wide output | |
| else | |
| { | |
| handler->SendSysMessage(LANG_BANLIST_ACCOUNTS); | |
| handler->SendSysMessage(" ==============================================================================="); | |
| handler->SendSysMessage(LANG_BANLIST_ACCOUNTS_HEADER); | |
| do | |
| { | |
| handler->SendSysMessage("-------------------------------------------------------------------------------"); | |
| Field* fields = result->Fetch(); | |
| uint32 accountId = fields[0].GetUInt32(); | |
| std::string accountName; | |
| // "account" case, name can be get in same query | |
| if (result->GetFieldCount() > 1) | |
| accountName = fields[1].GetString(); | |
| // "character" case, name need extract from another DB | |
| else | |
| AccountMgr::GetName(accountId, accountName); | |
| // No SQL injection. id is uint32. | |
| QueryResult banInfo = LoginDatabase.PQuery("SELECT bandate, unbandate, bannedby, banreason FROM account_banned WHERE id = %u ORDER BY unbandate", accountId); | |
| if (banInfo) | |
| { | |
| Field* fields2 = banInfo->Fetch(); | |
| do | |
| { | |
| time_t timeBan = time_t(fields2[0].GetUInt32()); | |
| tm tmBan; | |
| ACE_OS::localtime_r(&timeBan, &tmBan); | |
| if (fields2[0].GetUInt32() == fields2[1].GetUInt32()) | |
| { | |
| handler->PSendSysMessage("|%-15.15s|%02d-%02d-%02d %02d:%02d| permanent |%-15.15s|%-15.15s|", | |
| accountName.c_str(), tmBan.tm_year%100, tmBan.tm_mon+1, tmBan.tm_mday, tmBan.tm_hour, tmBan.tm_min, | |
| fields2[2].GetCString(), fields2[3].GetCString()); | |
| } | |
| else | |
| { | |
| time_t timeUnban = time_t(fields2[1].GetUInt32()); | |
| tm tmUnban; | |
| ACE_OS::localtime_r(&timeUnban, &tmUnban); | |
| handler->PSendSysMessage("|%-15.15s|%02d-%02d-%02d %02d:%02d|%02d-%02d-%02d %02d:%02d|%-15.15s|%-15.15s|", | |
| accountName.c_str(), tmBan.tm_year%100, tmBan.tm_mon+1, tmBan.tm_mday, tmBan.tm_hour, tmBan.tm_min, | |
| tmUnban.tm_year%100, tmUnban.tm_mon+1, tmUnban.tm_mday, tmUnban.tm_hour, tmUnban.tm_min, | |
| fields2[2].GetCString(), fields2[3].GetCString()); | |
| } | |
| } | |
| while (banInfo->NextRow()); | |
| } | |
| } | |
| while (result->NextRow()); | |
| handler->SendSysMessage(" ==============================================================================="); | |
| } | |
| return true; | |
| } | |
| static bool HandleBanListCharacterCommand(ChatHandler* handler, char const* args) | |
| { | |
| if (!*args) | |
| return false; | |
| char* filterStr = strtok((char*)args, " "); | |
| if (!filterStr) | |
| return false; | |
| std::string filter(filterStr); | |
| PreparedStatement* stmt = CharacterDatabase.GetPreparedStatement(CHAR_SEL_GUID_BY_NAME_FILTER); | |
| stmt->setString(0, filter); | |
| PreparedQueryResult result = CharacterDatabase.Query(stmt); | |
| if (!result) | |
| { | |
| handler->PSendSysMessage(LANG_BANLIST_NOCHARACTER); | |
| return true; | |
| } | |
| handler->PSendSysMessage(LANG_BANLIST_MATCHINGCHARACTER); | |
| // Chat short output | |
| if (handler->GetSession()) | |
| { | |
| do | |
| { | |
| Field* fields = result->Fetch(); | |
| PreparedStatement* stmt2 = CharacterDatabase.GetPreparedStatement(CHAR_SEL_BANNED_NAME); | |
| stmt2->setUInt32(0, fields[0].GetUInt32()); | |
| PreparedQueryResult banResult = CharacterDatabase.Query(stmt2); | |
| if (banResult) | |
| handler->PSendSysMessage("%s", (*banResult)[0].GetCString()); | |
| } | |
| while (result->NextRow()); | |
| } | |
| // Console wide output | |
| else | |
| { | |
| handler->SendSysMessage(LANG_BANLIST_CHARACTERS); | |
| handler->SendSysMessage(" =============================================================================== "); | |
| handler->SendSysMessage(LANG_BANLIST_CHARACTERS_HEADER); | |
| do | |
| { | |
| handler->SendSysMessage("-------------------------------------------------------------------------------"); | |
| Field* fields = result->Fetch(); | |
| std::string char_name = fields[1].GetString(); | |
| PreparedStatement* stmt2 = CharacterDatabase.GetPreparedStatement(CHAR_SEL_BANINFO_LIST); | |
| stmt2->setUInt32(0, fields[0].GetUInt32()); | |
| PreparedQueryResult banInfo = CharacterDatabase.Query(stmt2); | |
| if (banInfo) | |
| { | |
| Field* banFields = banInfo->Fetch(); | |
| do | |
| { | |
| time_t timeBan = time_t(banFields[0].GetUInt32()); | |
| tm tmBan; | |
| ACE_OS::localtime_r(&timeBan, &tmBan); | |
| if (banFields[0].GetUInt32() == banFields[1].GetUInt32()) | |
| { | |
| handler->PSendSysMessage("|%-15.15s|%02d-%02d-%02d %02d:%02d| permanent |%-15.15s|%-15.15s|", | |
| char_name.c_str(), tmBan.tm_year%100, tmBan.tm_mon+1, tmBan.tm_mday, tmBan.tm_hour, tmBan.tm_min, | |
| banFields[2].GetCString(), banFields[3].GetCString()); | |
| } | |
| else | |
| { | |
| time_t timeUnban = time_t(banFields[1].GetUInt32()); | |
| tm tmUnban; | |
| ACE_OS::localtime_r(&timeUnban, &tmUnban); | |
| handler->PSendSysMessage("|%-15.15s|%02d-%02d-%02d %02d:%02d|%02d-%02d-%02d %02d:%02d|%-15.15s|%-15.15s|", | |
| char_name.c_str(), tmBan.tm_year%100, tmBan.tm_mon+1, tmBan.tm_mday, tmBan.tm_hour, tmBan.tm_min, | |
| tmUnban.tm_year%100, tmUnban.tm_mon+1, tmUnban.tm_mday, tmUnban.tm_hour, tmUnban.tm_min, | |
| banFields[2].GetCString(), banFields[3].GetCString()); | |
| } | |
| } | |
| while (banInfo->NextRow()); | |
| } | |
| } | |
| while (result->NextRow()); | |
| handler->SendSysMessage(" =============================================================================== "); | |
| } | |
| return true; | |
| } | |
| static bool HandleBanListIPCommand(ChatHandler* handler, char const* args) | |
| { | |
| PreparedStatement* stmt = LoginDatabase.GetPreparedStatement(LOGIN_DEL_EXPIRED_IP_BANS); | |
| LoginDatabase.Execute(stmt); | |
| char* filterStr = strtok((char*)args, " "); | |
| std::string filter = filterStr ? filterStr : ""; | |
| LoginDatabase.EscapeString(filter); | |
| PreparedQueryResult result; | |
| if (filter.empty()) | |
| { | |
| PreparedStatement* stmt = LoginDatabase.GetPreparedStatement(LOGIN_SEL_IP_BANNED_ALL); | |
| result = LoginDatabase.Query(stmt); | |
| } | |
| else | |
| { | |
| PreparedStatement* stmt = LoginDatabase.GetPreparedStatement(LOGIN_SEL_IP_BANNED_BY_IP); | |
| stmt->setString(0, filter); | |
| result = LoginDatabase.Query(stmt); | |
| } | |
| if (!result) | |
| { | |
| handler->PSendSysMessage(LANG_BANLIST_NOIP); | |
| return true; | |
| } | |
| handler->PSendSysMessage(LANG_BANLIST_MATCHINGIP); | |
| // Chat short output | |
| if (handler->GetSession()) | |
| { | |
| do | |
| { | |
| Field* fields = result->Fetch(); | |
| handler->PSendSysMessage("%s", fields[0].GetCString()); | |
| } | |
| while (result->NextRow()); | |
| } | |
| // Console wide output | |
| else | |
| { | |
| handler->SendSysMessage(LANG_BANLIST_IPS); | |
| handler->SendSysMessage(" ==============================================================================="); | |
| handler->SendSysMessage(LANG_BANLIST_IPS_HEADER); | |
| do | |
| { | |
| handler->SendSysMessage("-------------------------------------------------------------------------------"); | |
| Field* fields = result->Fetch(); | |
| time_t timeBan = time_t(fields[1].GetUInt32()); | |
| tm tmBan; | |
| ACE_OS::localtime_r(&timeBan, &tmBan); | |
| if (fields[1].GetUInt32() == fields[2].GetUInt32()) | |
| { | |
| handler->PSendSysMessage("|%-15.15s|%02d-%02d-%02d %02d:%02d| permanent |%-15.15s|%-15.15s|", | |
| fields[0].GetCString(), tmBan.tm_year%100, tmBan.tm_mon+1, tmBan.tm_mday, tmBan.tm_hour, tmBan.tm_min, | |
| fields[3].GetCString(), fields[4].GetCString()); | |
| } | |
| else | |
| { | |
| time_t timeUnban = time_t(fields[2].GetUInt32()); | |
| tm tmUnban; | |
| ACE_OS::localtime_r(&timeUnban, &tmUnban); | |
| handler->PSendSysMessage("|%-15.15s|%02d-%02d-%02d %02d:%02d|%02d-%02d-%02d %02d:%02d|%-15.15s|%-15.15s|", | |
| fields[0].GetCString(), tmBan.tm_year%100, tmBan.tm_mon+1, tmBan.tm_mday, tmBan.tm_hour, tmBan.tm_min, | |
| tmUnban.tm_year%100, tmUnban.tm_mon+1, tmUnban.tm_mday, tmUnban.tm_hour, tmUnban.tm_min, | |
| fields[3].GetCString(), fields[4].GetCString()); | |
| } | |
| } | |
| while (result->NextRow()); | |
| handler->SendSysMessage(" ==============================================================================="); | |
| } | |
| return true; | |
| } | |
| static bool HandleUnBanAccountCommand(ChatHandler* handler, char const* args) | |
| { | |
| return HandleUnBanHelper(BAN_ACCOUNT, args, handler); | |
| } | |
| static bool HandleUnBanCharacterCommand(ChatHandler* handler, char const* args) | |
| { | |
| if (!*args) | |
| return false; | |
| char* nameStr = strtok((char*)args, " "); | |
| if (!nameStr) | |
| return false; | |
| std::string name = nameStr; | |
| if (!normalizePlayerName(name)) | |
| { | |
| handler->SendSysMessage(LANG_PLAYER_NOT_FOUND); | |
| handler->SetSentErrorMessage(true); | |
| return false; | |
| } | |
| if (!sWorld->RemoveBanCharacter(name)) | |
| { | |
| handler->SendSysMessage(LANG_PLAYER_NOT_FOUND); | |
| handler->SetSentErrorMessage(true); | |
| return false; | |
| } | |
| return true; | |
| } | |
| static bool HandleUnBanAccountByCharCommand(ChatHandler* handler, char const* args) | |
| { | |
| return HandleUnBanHelper(BAN_CHARACTER, args, handler); | |
| } | |
| static bool HandleUnBanIPCommand(ChatHandler* handler, char const* args) | |
| { | |
| return HandleUnBanHelper(BAN_IP, args, handler); | |
| } | |
| static bool HandleUnBanHelper(BanMode mode, char const* args, ChatHandler* handler) | |
| { | |
| if (!*args) | |
| return false; | |
| char* nameOrIPStr = strtok((char*)args, " "); | |
| if (!nameOrIPStr) | |
| return false; | |
| std::string nameOrIP = nameOrIPStr; | |
| switch (mode) | |
| { | |
| case BAN_ACCOUNT: | |
| if (!AccountMgr::normalizeString(nameOrIP)) | |
| { | |
| handler->PSendSysMessage(LANG_ACCOUNT_NOT_EXIST, nameOrIP.c_str()); | |
| handler->SetSentErrorMessage(true); | |
| return false; | |
| } | |
| break; | |
| case BAN_CHARACTER: | |
| if (!normalizePlayerName(nameOrIP)) | |
| { | |
| handler->SendSysMessage(LANG_PLAYER_NOT_FOUND); | |
| handler->SetSentErrorMessage(true); | |
| return false; | |
| } | |
| break; | |
| case BAN_IP: | |
| if (!IsIPAddress(nameOrIP.c_str())) | |
| return false; | |
| break; | |
| } | |
| if (sWorld->RemoveBanAccount(mode, nameOrIP)) | |
| handler->PSendSysMessage(LANG_UNBAN_UNBANNED, nameOrIP.c_str()); | |
| else | |
| handler->PSendSysMessage(LANG_UNBAN_ERROR, nameOrIP.c_str()); | |
| return true; | |
| } | |
| }; | |
| void AddSC_ban_commandscript() | |
| { | |
| new ban_commandscript(); | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment