aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authornihal <none@none>2010-01-24 15:59:10 +0100
committernihal <none@none>2010-01-24 15:59:10 +0100
commit08e4346ab2f840b777bffb494e8153e0144f1561 (patch)
tree38f3397e3cf657491c4152c48615d6a92ded6dfb /sql/updates
parent81321b390a828ce5f25f9f70502d831f49595e66 (diff)
Some good old fashioned proper Trinity Standard sql renaming and formatting.
Also added missing data to world.sql. --HG-- branch : trunk
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/7090_world_scriptname.sql1
-rw-r--r--sql/updates/7134_world_command.sql2
-rw-r--r--sql/updates/7147_world_creature_classlevelstats.sql1
-rw-r--r--sql/updates/7147_world_creature_template.sql1
-rw-r--r--sql/updates/7167_world_spell_stack_masks.sql (renamed from sql/updates/7168_world_spell_stack_masks.sql)0
5 files changed, 1 insertions, 4 deletions
diff --git a/sql/updates/7090_world_scriptname.sql b/sql/updates/7090_world_scriptname.sql
index a67bc5cbceb..7f6bf7cfa32 100644
--- a/sql/updates/7090_world_scriptname.sql
+++ b/sql/updates/7090_world_scriptname.sql
@@ -1,2 +1 @@
UPDATE `item_template` SET `ScriptName`='item_petrov_cluster_bombs' WHERE `entry`=33098;
-
diff --git a/sql/updates/7134_world_command.sql b/sql/updates/7134_world_command.sql
index a0727046d48..528e8d776dd 100644
--- a/sql/updates/7134_world_command.sql
+++ b/sql/updates/7134_world_command.sql
@@ -7,4 +7,4 @@ VALUES
('titles current',2,'Syntax: .titles current #title\r\nSet title #title (id or shift-link) as current selected titl for selected player. If title not in known title list for player then it will be added to list.'),
('titles remove',2,'Syntax: .titles remove #title\r\nRemove title #title (id or shift-link) from known titles list for selected player.'),
('titles setmask',2,'Syntax: .titles setmask #mask\r\n\r\nAllows user to use all titles from #mask.\r\n\r\n #mask=0 disables the title-choose-field'),
-('lookup title',2,'Syntax: .lookup title $$namepart\r\n\r\nLooks up a title by $namepart, and returns all matches with their title ID\'s and index\'s.'); \ No newline at end of file
+('lookup title',2,'Syntax: .lookup title $$namepart\r\n\r\nLooks up a title by $namepart, and returns all matches with their title ID\'s and index\'s.');
diff --git a/sql/updates/7147_world_creature_classlevelstats.sql b/sql/updates/7147_world_creature_classlevelstats.sql
index 6b10bb9806c..dff9eb89316 100644
--- a/sql/updates/7147_world_creature_classlevelstats.sql
+++ b/sql/updates/7147_world_creature_classlevelstats.sql
@@ -1,4 +1,3 @@
ALTER TABLE `creature_classlevelstats`
DROP COLUMN `basedmg`,
DROP COLUMN `baserangeddmg`;
-
diff --git a/sql/updates/7147_world_creature_template.sql b/sql/updates/7147_world_creature_template.sql
index 7202edab18a..9c92fa05388 100644
--- a/sql/updates/7147_world_creature_template.sql
+++ b/sql/updates/7147_world_creature_template.sql
@@ -7,4 +7,3 @@ ADD COLUMN `attackpower` int(10) unsigned NOT NULL DEFAULT '0' AFTER `dmgschool`
ADD COLUMN `minrangedmg` float NOT NULL DEFAULT '0' AFTER `trainer_race`,
ADD COLUMN `maxrangedmg` float NOT NULL DEFAULT '0' AFTER `minrangedmg`,
ADD COLUMN `rangedattackpower` smallint(5) unsigned NOT NULL DEFAULT '0' AFTER `maxrangedmg`;
-
diff --git a/sql/updates/7168_world_spell_stack_masks.sql b/sql/updates/7167_world_spell_stack_masks.sql
index 2e7d449593c..2e7d449593c 100644
--- a/sql/updates/7168_world_spell_stack_masks.sql
+++ b/sql/updates/7167_world_spell_stack_masks.sql