aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authormegamage <none@none>2009-03-28 17:31:27 -0600
committermegamage <none@none>2009-03-28 17:31:27 -0600
commit2ab52aa2a12edf8411a8231101957c59f2ec2bc1 (patch)
tree852bf860928ba21915ea8c5bbf79e56b7363b0f2 /sql/updates
parentb72b2a2f5ede384150e586539750dc0e6ce0bd40 (diff)
[7565] Move all hardcoded strings used in .account onlinelist to DB. Author: VladimirMangos
Also update format as originally suggested by Cha0S2. --HG-- branch : trunk
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/7565_01_mangos_mangos_string.sql9
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/7565_01_mangos_mangos_string.sql b/sql/updates/7565_01_mangos_mangos_string.sql
new file mode 100644
index 00000000000..4557d196665
--- /dev/null
+++ b/sql/updates/7565_01_mangos_mangos_string.sql
@@ -0,0 +1,9 @@
+ALTER TABLE db_version CHANGE COLUMN required_7560_01_mangos_gameobject_template required_7565_01_mangos_mangos_string bit;
+
+DELETE FROM mangos_string WHERE entry IN(1010,1011,1012,1013,1014);
+INSERT INTO mangos_string VALUES
+(1010,'| Account | Character | IP | GM | Expansion |',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
+(1011,'|<Error> | %20s |<Error> |<Er>| <Error> |',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
+(1012,'===========================================================================',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
+(1013,'|%15s| %20s | %15s |%4d| %9d |',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
+(1014,'No online players.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);