diff options
| -rw-r--r-- | sql/updates/2932_mangos_7714_01_world_command.sql (renamed from sql/updates/7714_01_mangos_command.sql) | 5 | ||||
| -rw-r--r-- | sql/updates/2938_mangos_7720_01_world_trinity_string.sql | 7 | ||||
| -rw-r--r-- | sql/updates/7720_01_mangos_mangos_string.sql | 7 |
3 files changed, 9 insertions, 10 deletions
diff --git a/sql/updates/7714_01_mangos_command.sql b/sql/updates/2932_mangos_7714_01_world_command.sql index a5eeec48b13..15de76894bc 100644 --- a/sql/updates/7714_01_mangos_command.sql +++ b/sql/updates/2932_mangos_7714_01_world_command.sql @@ -1,6 +1,5 @@ -ALTER TABLE db_version CHANGE COLUMN required_7706_01_mangos_command required_7714_01_mangos_command bit; +/*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.'); +('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.');
\ No newline at end of file diff --git a/sql/updates/2938_mangos_7720_01_world_trinity_string.sql b/sql/updates/2938_mangos_7720_01_world_trinity_string.sql new file mode 100644 index 00000000000..67907163fed --- /dev/null +++ b/sql/updates/2938_mangos_7720_01_world_trinity_string.sql @@ -0,0 +1,7 @@ +/*ALTER TABLE db_version CHANGE COLUMN required_7714_01_mangos_command required_7720_01_mangos_mangos_string bit;*/ + +DELETE FROM trinity_string WHERE entry IN(557,558,559); +INSERT INTO trinity_string VALUES +(557,'%s level up you to (%i)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(558,'%s level down you to (%i)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(559,'%s reset your level progress.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
\ No newline at end of file diff --git a/sql/updates/7720_01_mangos_mangos_string.sql b/sql/updates/7720_01_mangos_mangos_string.sql deleted file mode 100644 index 41435c0e81f..00000000000 --- a/sql/updates/7720_01_mangos_mangos_string.sql +++ /dev/null @@ -1,7 +0,0 @@ -ALTER TABLE db_version CHANGE COLUMN required_7714_01_mangos_command required_7720_01_mangos_mangos_string bit; - -DELETE FROM mangos_string WHERE entry IN(557,558,559); -INSERT INTO mangos_string VALUES -(557,'%s level up you to (%i)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(558,'%s level down you to (%i)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(559,'%s reset your level progress.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); |