Core/Commands: implement .pvpstats command

Shows number of battleground victories in the last 7 days

Closes #13460

1 files changed, 8 insertions, 0 deletions

diff --git a/sql/updates/world/2014_11_10_04_world.sql b/sql/updates/world/2014_11_10_04_world.sql
new file mode 100644
index 00000000000..1b4857e4724
--- /dev/null
+++ b/sql/updates/world/2014_11_10_04_world.sql
@@ -0,0 +1,8 @@
+DELETE FROM `trinity_string` WHERE entry IN (80, 81);
+INSERT INTO `trinity_string` (`entry`, `content_default`) VALUES 
+(80, 'BattleGround victories in the last 7 days\nAlliance: %d\nHorde: %d'),
+(81, 'BattleGround scores storing is disabled!');
+
+DELETE FROM `command` WHERE `name`='pvpstats';
+INSERT INTO `command` (`name`, `permission`, `help`) VALUES
+('pvpstats', 797, 'Shows number of battleground victories in the last 7 days');