aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorDrahy <none@none>2009-04-29 18:35:08 +0200
committerDrahy <none@none>2009-04-29 18:35:08 +0200
commit40ba1b7030c0614a8cad8bdce8e9f51d5282a314 (patch)
tree91b5a9dd63409a69717d2fbe21fc0349baac9286
parent7897fc16f0abb6d2043a595352236836070b8cd3 (diff)
* Used trinity sql coding style
--HG-- branch : trunk
-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.sql7
-rw-r--r--sql/updates/7720_01_mangos_mangos_string.sql7
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);