From f4e2dccacb0b6e9f78327f46188cefcede699995 Mon Sep 17 00:00:00 2001
From: megamage <none@none>
Date: Fri, 24 Apr 2009 11:45:25 -0500
Subject:     [7705] Rename some account/character related commands.

    * .lockaccount -> .account lock
    * .password    -> .account password
    * .chardelete  -> .character delete
    * .customize   -> .character customize
    * .rename      -> .character rename
    [7706] Rename command .plimit -> .server plimit

Author: VladimirMangos

--HG--
branch : trunk
---
 sql/updates/7705_01_mangos_command.sql | 13 +++++++++++++
 sql/updates/7706_01_mangos_command.sql |  6 ++++++
 2 files changed, 19 insertions(+)
 create mode 100644 sql/updates/7705_01_mangos_command.sql
 create mode 100644 sql/updates/7706_01_mangos_command.sql

(limited to 'sql/updates')

diff --git a/sql/updates/7705_01_mangos_command.sql b/sql/updates/7705_01_mangos_command.sql
new file mode 100644
index 00000000000..4e6b8ff31ea
--- /dev/null
+++ b/sql/updates/7705_01_mangos_command.sql
@@ -0,0 +1,13 @@
+ALTER TABLE db_version CHANGE COLUMN required_7662_02_mangos_spell_bonus_data required_7705_01_mangos_command bit;
+
+DELETE FROM `command` WHERE `name` IN (
+  'account lock','account password','chardelete','character customize','character delete',
+  'character rename','customize','lockaccount','password','rename'
+);
+
+INSERT INTO `command` VALUES
+('account lock',0,'Syntax: .account lock [on|off]\r\n\r\nAllow login from account only from current used IP or remove this requirement.'),
+('account password',0,'Syntax: .account password $old_password $new_password $new_password\r\n\r\nChange your account password.'),
+('character customize',2,'Syntax: .character customize [$name]\r\n\r\nMark selected in game or by $name in command character for customize at next login.'),
+('character delete',4,'Syntax: .character delete $name\r\n\r\nDelete character $name.'),
+('character rename',2,'Syntax: .character rename [$name]\r\n\r\nMark selected in game or by $name in command character for rename at next login.');
diff --git a/sql/updates/7706_01_mangos_command.sql b/sql/updates/7706_01_mangos_command.sql
new file mode 100644
index 00000000000..a57ddcc566f
--- /dev/null
+++ b/sql/updates/7706_01_mangos_command.sql
@@ -0,0 +1,6 @@
+ALTER TABLE db_version CHANGE COLUMN required_7705_01_mangos_command required_7706_01_mangos_command bit;
+
+DELETE FROM `command` WHERE `name` IN ('plimit','server plimit');
+
+INSERT INTO `command` VALUES
+('server plimit',3,'Syntax: .server plimit [#num|-1|-2|-3|reset|player|moderator|gamemaster|administrator]\r\n\r\nWithout arg show current player amount and security level limitations for login to server, with arg set player linit ($num > 0) or securiti limitation ($num < 0 or security leme name. With `reset` sets player limit to the one in the config file');
-- 
cgit v1.2.3