From fe85f521424656dedfb2fa189987be7ccb304ee7 Mon Sep 17 00:00:00 2001
From: megamage <none@none>
Date: Tue, 10 Feb 2009 00:59:10 -0600
Subject:     [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
---
 sql/updates/7252_01_mangos_command.sql       |  6 ++++++
 sql/updates/7252_02_mangos_mangos_string.sql | 14 ++++++++++++++
 2 files changed, 20 insertions(+)
 create mode 100644 sql/updates/7252_01_mangos_command.sql
 create mode 100644 sql/updates/7252_02_mangos_mangos_string.sql

(limited to 'sql/updates')

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);
-- 
cgit v1.2.3