[7714] Implement new command .character level for set level provided level. Author: VladimirMangos

--HG--
branch : trunk

1 files changed, 6 insertions, 0 deletions

diff --git a/sql/updates/7714_01_mangos_command.sql b/sql/updates/7714_01_mangos_command.sql
new file mode 100644
index 00000000000..a5eeec48b13
--- /dev/null
+++ b/sql/updates/7714_01_mangos_command.sql
@@ -0,0 +1,6 @@
+ALTER TABLE db_version CHANGE COLUMN required_7706_01_mangos_command required_7714_01_mangos_command bit;
+
+DELETE FROM `command` WHERE `name` IN ('character level');
+
+INSERT INTO `command` VALUES
+('character level',3,'Syntax: .character level [$playername] [#level]\r\n\r\nSet the level of character with $playername (or the selected if not name provided) by #numberoflevels Or +1 if no #numberoflevels provided). If #numberoflevels is omitted, the level will be increase by 1. If #numberoflevels is 0, the same level will be restarted. If no character is selected and name not provided, increase your level. Command can be used for offline character. All stats and dependent values recalculated. At level decrease talents can be reset if need. Also at level decrease equipped items with greater level requirement can be lost.');