From 40ba1b7030c0614a8cad8bdce8e9f51d5282a314 Mon Sep 17 00:00:00 2001
From: Drahy <none@none>
Date: Wed, 29 Apr 2009 18:35:08 +0200
Subject: * Used trinity sql coding style

--HG--
branch : trunk
---
 sql/updates/2932_mangos_7714_01_world_command.sql        | 5 +++++
 sql/updates/2938_mangos_7720_01_world_trinity_string.sql | 7 +++++++
 sql/updates/7714_01_mangos_command.sql                   | 6 ------
 sql/updates/7720_01_mangos_mangos_string.sql             | 7 -------
 4 files changed, 12 insertions(+), 13 deletions(-)
 create mode 100644 sql/updates/2932_mangos_7714_01_world_command.sql
 create mode 100644 sql/updates/2938_mangos_7720_01_world_trinity_string.sql
 delete mode 100644 sql/updates/7714_01_mangos_command.sql
 delete mode 100644 sql/updates/7720_01_mangos_mangos_string.sql

(limited to 'sql')

diff --git a/sql/updates/2932_mangos_7714_01_world_command.sql b/sql/updates/2932_mangos_7714_01_world_command.sql
new file mode 100644
index 00000000000..15de76894bc
--- /dev/null
+++ b/sql/updates/2932_mangos_7714_01_world_command.sql
@@ -0,0 +1,5 @@
+/*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.');
\ 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/7714_01_mangos_command.sql b/sql/updates/7714_01_mangos_command.sql
deleted file mode 100644
index a5eeec48b13..00000000000
--- a/sql/updates/7714_01_mangos_command.sql
+++ /dev/null
@@ -1,6 +0,0 @@
-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.');
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);
-- 
cgit v1.2.3