diff options
| author | DDuarte <dnpd.dd@gmail.com> | 2014-11-10 23:10:02 +0000 |
|---|---|---|
| committer | DDuarte <dnpd.dd@gmail.com> | 2014-11-10 23:10:02 +0000 |
| commit | 9c55d9fdebb821ac102a2b7e7a2a1ef0b92ac26c (patch) | |
| tree | f01891ad20342ad1509e21430f419359b70176dc /src/server/scripts/Commands | |
| parent | a74b7228b8c28f0cc6762816ea33be2ec8a2266e (diff) | |
Core/Commands: implement .pvpstats command
Shows number of battleground victories in the last 7 days
Closes #13460
Conflicts:
sql/base/auth_database.sql
sql/updates/auth/2014_11_10_00_auth.sql
src/server/game/Accounts/RBAC.h
(cherry picked from commit fd0b96178174e624510a10f5bc27b60af406d901)
Diffstat (limited to 'src/server/scripts/Commands')
| -rw-r--r-- | src/server/scripts/Commands/cs_misc.cpp | 30 |
1 files changed, 30 insertions, 0 deletions
diff --git a/src/server/scripts/Commands/cs_misc.cpp b/src/server/scripts/Commands/cs_misc.cpp index 4c2b7d40a89..0ebf05f74ad 100644 --- a/src/server/scripts/Commands/cs_misc.cpp +++ b/src/server/scripts/Commands/cs_misc.cpp @@ -78,6 +78,7 @@ public: { "pinfo", rbac::RBAC_PERM_COMMAND_PINFO, true, &HandlePInfoCommand, "", NULL }, { "playall", rbac::RBAC_PERM_COMMAND_PLAYALL, false, &HandlePlayAllCommand, "", NULL }, { "possess", rbac::RBAC_PERM_COMMAND_POSSESS, false, &HandlePossessCommand, "", NULL }, + { "pvpstats", rbac::RBAC_PERM_COMMAND_PVPSTATS, true, &HandlePvPstatsCommand, "", NULL }, { "recall", rbac::RBAC_PERM_COMMAND_RECALL, false, &HandleRecallCommand, "", NULL }, { "repairitems", rbac::RBAC_PERM_COMMAND_REPAIRITEMS, true, &HandleRepairitemsCommand, "", NULL }, { "respawn", rbac::RBAC_PERM_COMMAND_RESPAWN, false, &HandleRespawnCommand, "", NULL }, @@ -100,6 +101,35 @@ public: return commandTable; } + static bool HandlePvPstatsCommand(ChatHandler * handler, char const* /*args*/) + { + if (sWorld->getBoolConfig(CONFIG_BATTLEGROUND_STORE_STATISTICS_ENABLE)) + { + PreparedStatement* stmt = CharacterDatabase.GetPreparedStatement(CHAR_SEL_PVPSTATS_FACTIONS_OVERALL); + PreparedQueryResult result = CharacterDatabase.Query(stmt); + + if (result) + { + Field* fields = result->Fetch(); + uint32 horde_victories = fields[1].GetUInt32(); + + if (!(result->NextRow())) + return false; + + fields = result->Fetch(); + uint32 alliance_victories = fields[1].GetUInt32(); + + handler->PSendSysMessage(LANG_PVPSTATS, alliance_victories, horde_victories); + } + else + return false; + } + else + handler->PSendSysMessage(LANG_PVPSTATS_DISABLED); + + return true; + } + static bool HandleDevCommand(ChatHandler* handler, char const* args) { if (!*args) |