ban_commandscript Class Reference

Public Member Functions
	ban_commandscript ()
std::vector< ChatCommand >	GetCommands () const override
Public Member Functions inherited from ScriptObject
const std::string &	GetName () const

Static Public Member Functions
static bool	HandleBanAccountCommand (ChatHandler *handler, char const *args)
static bool	HandleBanCharacterCommand (ChatHandler *handler, char const *args)
static bool	HandleBanAccountByCharCommand (ChatHandler *handler, char const *args)
static bool	HandleBanIPCommand (ChatHandler *handler, char const *args)
static bool	HandleBanHelper (BanMode mode, char const *args, ChatHandler *handler)
static bool	HandleBanInfoAccountCommand (ChatHandler *handler, char const *args)
static bool	HandleBanInfoHelper (uint32 accountId, char const *accountName, ChatHandler *handler)
static bool	HandleBanInfoCharacterCommand (ChatHandler *handler, char const *args)
static bool	HandleBanInfoIPCommand (ChatHandler *handler, char const *args)
static bool	HandleBanListAccountCommand (ChatHandler *handler, char const *args)
static bool	HandleBanListHelper (PreparedQueryResult result, ChatHandler *handler)
static bool	HandleBanListCharacterCommand (ChatHandler *handler, char const *args)
static bool	HandleBanListIPCommand (ChatHandler *handler, char const *args)
static bool	HandleUnBanAccountCommand (ChatHandler *handler, char const *args)
static bool	HandleUnBanCharacterCommand (ChatHandler *handler, char const *args)
static bool	HandleUnBanAccountByCharCommand (ChatHandler *handler, char const *args)
static bool	HandleUnBanIPCommand (ChatHandler *handler, char const *args)
static bool	HandleUnBanHelper (BanMode mode, char const *args, ChatHandler *handler)

Additional Inherited Members
Protected Member Functions inherited from CommandScript
	CommandScript (const char *name)
Protected Member Functions inherited from ScriptObject
	ScriptObject (const char *name)
virtual	~ScriptObject ()

Constructor & Destructor Documentation

ban_commandscript::ban_commandscript ( )

inline

: CommandScript("ban_commandscript") { }

Member Function Documentation

std::vector<ChatCommand> ban_commandscript::GetCommands ( ) const

inlineoverridevirtual

Implements CommandScript.

 {
 static std::vector<ChatCommand> unbanCommandTable =
 {
 { "account", rbac::RBAC_PERM_COMMAND_UNBAN_ACCOUNT, true, &HandleUnBanAccountCommand, "" },
 { "character", rbac::RBAC_PERM_COMMAND_UNBAN_CHARACTER, true, &HandleUnBanCharacterCommand, "" },
 { "playeraccount", rbac::RBAC_PERM_COMMAND_UNBAN_PLAYERACCOUNT, true, &HandleUnBanAccountByCharCommand, "" },
 { "ip", rbac::RBAC_PERM_COMMAND_UNBAN_IP, true, &HandleUnBanIPCommand, "" },
 };
 static std::vector<ChatCommand> banlistCommandTable =
 {
 { "account", rbac::RBAC_PERM_COMMAND_BANLIST_ACCOUNT, true, &HandleBanListAccountCommand, "" },
 { "character", rbac::RBAC_PERM_COMMAND_BANLIST_CHARACTER, true, &HandleBanListCharacterCommand, "" },
 { "ip", rbac::RBAC_PERM_COMMAND_BANLIST_IP, true, &HandleBanListIPCommand, "" },
 };
 static std::vector<ChatCommand> baninfoCommandTable =
 {
 { "account", rbac::RBAC_PERM_COMMAND_BANINFO_ACCOUNT, true, &HandleBanInfoAccountCommand, "" },
 { "character", rbac::RBAC_PERM_COMMAND_BANINFO_CHARACTER, true, &HandleBanInfoCharacterCommand, "" },
 { "ip", rbac::RBAC_PERM_COMMAND_BANINFO_IP, true, &HandleBanInfoIPCommand, "" },
 };
 static std::vector<ChatCommand> banCommandTable =
 {
 { "account", rbac::RBAC_PERM_COMMAND_BAN_ACCOUNT, true, &HandleBanAccountCommand, "" },
 { "character", rbac::RBAC_PERM_COMMAND_BAN_CHARACTER, true, &HandleBanCharacterCommand, "" },
 { "playeraccount", rbac::RBAC_PERM_COMMAND_BAN_PLAYERACCOUNT, true, &HandleBanAccountByCharCommand, "" },
 { "ip", rbac::RBAC_PERM_COMMAND_BAN_IP, true, &HandleBanIPCommand, "" },
 };
 static std::vector<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 },
 };
 return commandTable;
 }

Here is the call graph for this function:

static bool ban_commandscript::HandleBanAccountByCharCommand ( ChatHandler *  handler, char const *  args  )

inlinestatic

 {
 return HandleBanHelper(BAN_CHARACTER, args, handler);
 }

Here is the call graph for this function:

Here is the caller graph for this function:

static bool ban_commandscript::HandleBanAccountCommand ( ChatHandler *  handler, char const *  args  )

inlinestatic

 {
 return HandleBanHelper(BAN_ACCOUNT, args, handler);
 }

Here is the call graph for this function:

Here is the caller graph for this function:

static bool ban_commandscript::HandleBanCharacterCommand ( ChatHandler *  handler, char const *  args  )

inlinestatic

 {
 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;
 }

 std::string author = handler->GetSession() ? handler->GetSession()->GetPlayerName() : "Server";

 switch (sWorld->BanCharacter(name, durationStr, reasonStr, author))
 {
 case BAN_SUCCESS:
 {
 if (atoi(durationStr) > 0)
 {
 if (sWorld->getBoolConfig(CONFIG_SHOW_BAN_IN_WORLD))
 sWorld->SendWorldText(LANG_BAN_CHARACTER_YOUBANNEDMESSAGE_WORLD, author.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, author.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;
 }

Here is the call graph for this function:

Here is the caller graph for this function:

static bool ban_commandscript::HandleBanHelper ( BanMode  mode, char const *  args, ChatHandler *  handler  )

inlinestatic

 {
 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 (!Utf8ToUpperOnlyLatin(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;
 }

 std::string author = handler->GetSession() ? handler->GetSession()->GetPlayerName() : "Server";

 switch (sWorld->BanAccount(mode, nameOrIP, durationStr, reasonStr, author))
 {
 case BAN_SUCCESS:
 if (atoi(durationStr) > 0)
 {
 if (sWorld->getBoolConfig(CONFIG_SHOW_BAN_IN_WORLD))
 sWorld->SendWorldText(LANG_BAN_ACCOUNT_YOUBANNEDMESSAGE_WORLD, author.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, author.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;
 }

Here is the call graph for this function:

Here is the caller graph for this function:

static bool ban_commandscript::HandleBanInfoAccountCommand ( ChatHandler *  handler, char const *  args  )

inlinestatic

 {
 if (!*args)
 return false;

 char* nameStr = strtok((char*)args, "");
 if (!nameStr)
 return false;

 std::string accountName = nameStr;
 if (!Utf8ToUpperOnlyLatin(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);
 }

Here is the call graph for this function:

Here is the caller graph for this function:

static bool ban_commandscript::HandleBanInfoCharacterCommand ( ChatHandler *  handler, char const *  args  )

inlinestatic

 {
 if (!*args)
 return false;

 Player* target = ObjectAccessor::FindPlayerByName(args);
 ObjectGuid targetGuid;
 std::string name(args);

 if (!target)
 {
 targetGuid = ObjectMgr::GetPlayerGUIDByName(name);
 if (targetGuid.IsEmpty())
 {
 handler->PSendSysMessage(LANG_BANINFO_NOCHARACTER);
 return false;
 }
 }
 else
 targetGuid = target->GetGUID();

 PreparedStatement* stmt = CharacterDatabase.GetPreparedStatement(CHAR_SEL_BANINFO);
 stmt->setUInt64(0, targetGuid.GetCounter());
 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,
 TimeToTimestampStr(fields[0].GetUInt32()).c_str(), banTime.c_str(), active ? handler->GetTrinityString(LANG_YES) : handler->GetTrinityString(LANG_NO), fields[4].GetCString(), fields[5].GetCString());
 }
 while (result->NextRow());

 return true;
 }

Here is the call graph for this function:

Here is the caller graph for this function:

static bool ban_commandscript::HandleBanInfoHelper ( uint32  accountId, char const *  accountName, ChatHandler *  handler  )

inlinestatic

 {
 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_YES) : handler->GetTrinityString(LANG_NO), fields[4].GetCString(), fields[5].GetCString());
 }
 while (result->NextRow());

 return true;
 }

Here is the call graph for this function:

Here is the caller graph for this function:

static bool ban_commandscript::HandleBanInfoIPCommand ( ChatHandler *  handler, char const *  args  )

inlinestatic

 {
 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;
 }

Here is the call graph for this function:

Here is the caller graph for this function:

static bool ban_commandscript::HandleBanIPCommand ( ChatHandler *  handler, char const *  args  )

inlinestatic

 {
 return HandleBanHelper(BAN_IP, args, handler);
 }

Here is the call graph for this function:

Here is the caller graph for this function:

static bool ban_commandscript::HandleBanListAccountCommand ( ChatHandler *  handler, char const *  args  )

inlinestatic

 {
 PreparedStatement* stmt = NULL;

 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())
 {
 stmt = LoginDatabase.GetPreparedStatement(LOGIN_SEL_ACCOUNT_BANNED_ALL);
 result = LoginDatabase.Query(stmt);
 }
 else
 {
 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);
 }

Here is the call graph for this function:

Here is the caller graph for this function:

static bool ban_commandscript::HandleBanListCharacterCommand ( ChatHandler *  handler, char const *  args  )

inlinestatic

 {
 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->setUInt64(0, fields[0].GetUInt64());
 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->setUInt64(0, fields[0].GetUInt64());
 PreparedQueryResult banInfo = CharacterDatabase.Query(stmt2);
 if (banInfo)
 {
 Field* banFields = banInfo->Fetch();
 do
 {
 time_t timeBan = time_t(banFields[0].GetUInt32());
 tm tmBan;
 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;
 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;
 }

Here is the call graph for this function:

Here is the caller graph for this function:

static bool ban_commandscript::HandleBanListHelper ( PreparedQueryResult  result, ChatHandler *  handler  )

inlinestatic

 {
 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;
 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;
 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;
 }

Here is the call graph for this function:

Here is the caller graph for this function:

static bool ban_commandscript::HandleBanListIPCommand ( ChatHandler *  handler, char const *  args  )

inlinestatic

 {
 PreparedStatement* stmt = NULL;
 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())
 {
 stmt = LoginDatabase.GetPreparedStatement(LOGIN_SEL_IP_BANNED_ALL);
 result = LoginDatabase.Query(stmt);
 }
 else
 {
 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;
 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;
 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;
 }

Here is the call graph for this function:

Here is the caller graph for this function:

static bool ban_commandscript::HandleUnBanAccountByCharCommand ( ChatHandler *  handler, char const *  args  )

inlinestatic

    {
        return HandleUnBanHelper(BAN_CHARACTER, args, handler);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

static bool ban_commandscript::HandleUnBanAccountCommand ( ChatHandler *  handler, char const *  args  )

inlinestatic

    {
        return HandleUnBanHelper(BAN_ACCOUNT, args, handler);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

static bool ban_commandscript::HandleUnBanCharacterCommand ( ChatHandler *  handler, char const *  args  )

inlinestatic

    {
        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;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

static bool ban_commandscript::HandleUnBanHelper ( BanMode  mode, char const *  args, ChatHandler *  handler  )

inlinestatic

    {
        if (!*args)
            return false;

        char* nameOrIPStr = strtok((char*)args, " ");
        if (!nameOrIPStr)
            return false;

        std::string nameOrIP = nameOrIPStr;

        switch (mode)
        {
            case BAN_ACCOUNT:
                if (!Utf8ToUpperOnlyLatin(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;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

static bool ban_commandscript::HandleUnBanIPCommand ( ChatHandler *  handler, char const *  args  )

inlinestatic

    {
        return HandleUnBanHelper(BAN_IP, args, handler);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

---

The documentation for this class was generated from the following file:

• src/server/scripts/Commands/cs_ban.cpp