[7252] Move all world global broadcast string (all arena/bg related) to `mangos_string`.

    PLEASE, NOT USE string world broadcasts in real code. This function _only_ for debug purposes.

    Really allow with .debug bg start bg with 1 player.
    Added helps for some existed .debug commands.

Author: VladimirMangos

--HG--
branch : trunk

2 files changed, 20 insertions, 0 deletions

diff --git a/sql/updates/7252_01_mangos_command.sql b/sql/updates/7252_01_mangos_command.sql
new file mode 100644
index 00000000000..4d1ff984f96
--- /dev/null
+++ b/sql/updates/7252_01_mangos_command.sql
@@ -0,0 +1,6 @@
+ALTER TABLE db_version CHANGE COLUMN required_7251_01_mangos_spell_chain required_7252_01_mangos_command bit;
+
+DELETE FROM `command` WHERE `name` IN ('debug arena','debug bg');
+INSERT INTO `command` VALUES
+('debug arena',3,'Syntax: .debug arena\r\n\r\nToggle debug mode for arenas. In debug mode GM can start arena with single player.'),
+('debug bg',3,'Syntax: .debug bg\r\n\r\nToggle debug mode for battlegrounds. In debug mode GM can start battleground with single player.');
diff --git a/sql/updates/7252_02_mangos_mangos_string.sql b/sql/updates/7252_02_mangos_mangos_string.sql
new file mode 100644
index 00000000000..3b5a2d5b6b1
--- /dev/null
+++ b/sql/updates/7252_02_mangos_mangos_string.sql
@@ -0,0 +1,14 @@
+ALTER TABLE db_version CHANGE COLUMN required_7252_01_mangos_command required_7252_02_mangos_mangos_string bit;
+
+DELETE FROM `mangos_string` WHERE entry IN (737,738,739,740,741,742,743,744,745,746);
+INSERT INTO `mangos_string` VALUES
+(737,'Arenas are set to 1v1 for debugging. So, don\'t join as group.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
+(738,'Arenas are set to normal playercount.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
+(739,'Battlegrounds are set to 1v0 for debugging.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
+(740,'Battlegrounds are set to normal playercount.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
+(741,'Flushing Arena points based on team ratings, this may take a few minutes. Please stand by...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
+(742,'Distributing arena points to players...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
+(743,'Finished setting arena points for online players.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
+(744,'Modifying played count, arena points etc. for loaded arena teams, sending updated stats to online players...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
+(745,'Modification done.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
+(746,'Done flushing Arena points.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);