aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorDrahy <none@none>2009-05-13 12:42:56 +0200
committerDrahy <none@none>2009-05-13 12:42:56 +0200
commita0a6efd89e75ac4f85b7179bcca60fd81198b492 (patch)
tree8e1e9810d434b2a62b1217a5bdc9cb07e23e9c81 /sql/updates
parent1fbc7377d1acfcee7397771c9d0def5ae345da8a (diff)
* Completely redone trinityscript_script_texts sql - never again :-)
* Cleaned up world_scripts_full * Used trinity sql coding style for sql updates --HG-- branch : trunk
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/3233_world_scripts_naxx.sql3
-rw-r--r--sql/updates/3235_characters.sql2
-rw-r--r--sql/updates/3235_world.sql3
-rw-r--r--sql/updates/3263_world_scripts_(missing in full).sql2
4 files changed, 4 insertions, 6 deletions
diff --git a/sql/updates/3233_world_scripts_naxx.sql b/sql/updates/3233_world_scripts_naxx.sql
index 8b8140c17fe..54d6c49a82b 100644
--- a/sql/updates/3233_world_scripts_naxx.sql
+++ b/sql/updates/3233_world_scripts_naxx.sql
@@ -43,7 +43,6 @@ INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES
(27935, 1, 16060), # To Anchor 1 - Gothik
(27936, 1, 16060); # To Anchor 2 - Gothik
-
INSERT INTO creature_template (entry, spell1, spell2, spell3, spell4, spell5, spell6, spell7, spell8) VALUES
(16573, 15284, 28991, 28969, 34970, 28864, 0, 0, 0), # Crypt Guard
(29256, 15284, 28991, 56098, 34970, 28864, 0, 0, 0), # Crypt Guard (H)
@@ -63,4 +62,4 @@ spell4 = VALUES(spell4),
spell5 = VALUES(spell5),
spell6 = VALUES(spell6),
spell7 = VALUES(spell7),
-spell8 = VALUES(spell8);
+spell8 = VALUES(spell8); \ No newline at end of file
diff --git a/sql/updates/3235_characters.sql b/sql/updates/3235_characters.sql
index 814b2dda67c..c99cfb01db6 100644
--- a/sql/updates/3235_characters.sql
+++ b/sql/updates/3235_characters.sql
@@ -1,4 +1,4 @@
DELETE FROM `character_action` WHERE `type` = 0 AND `action` = 28734;
DELETE FROM `character_aura` WHERE `spell` = 28734;
DELETE FROM `character_spell` WHERE `spell` = 28734;
-DELETE FROM `character_spell_cooldown` WHERE `spell` = 28734;
+DELETE FROM `character_spell_cooldown` WHERE `spell` = 28734; \ No newline at end of file
diff --git a/sql/updates/3235_world.sql b/sql/updates/3235_world.sql
index 68c18dfc886..719530b4150 100644
--- a/sql/updates/3235_world.sql
+++ b/sql/updates/3235_world.sql
@@ -1,6 +1,5 @@
DELETE FROM `playercreateinfo_action` WHERE `type` = 0 AND `action` = 28734;
DELETE FROM `playercreateinfo_spell` WHERE `spell` = 28734;
DELETE FROM `playercreateinfo_spell_custom` WHERE `spell` = 28734;
-
UPDATE `playercreateinfo_action` SET `button` = 3 WHERE `race` = 10 AND `class` IN (2, 3, 5, 8, 9) AND `action` = 28730 AND `type` = 0;
-UPDATE `playercreateinfo_action` SET `button` = 4 WHERE `race` = 10 AND `class` = 4 AND `action` = 25046 AND `type` = 0;
+UPDATE `playercreateinfo_action` SET `button` = 4 WHERE `race` = 10 AND `class` = 4 AND `action` = 25046 AND `type` = 0; \ No newline at end of file
diff --git a/sql/updates/3263_world_scripts_(missing in full).sql b/sql/updates/3263_world_scripts_(missing in full).sql
index aab3dea7080..942ffd1ccfd 100644
--- a/sql/updates/3263_world_scripts_(missing in full).sql
+++ b/sql/updates/3263_world_scripts_(missing in full).sql
@@ -11,4 +11,4 @@ UPDATE creature_template SET scriptname = 'boss_sathrovarr' WHERE entry = 24892;
UPDATE creature_template SET scriptname = 'boss_kalec' WHERE entry = 24891;
UPDATE creature_template SET scriptname = 'npc_blackhole' WHERE entry = 25855;
UPDATE creature_template SET scriptname = 'boss_archavon' WHERE entry = 31125;
-UPDATE creature_template SET scriptname = 'mob_archavon_warder' WHERE entry = 32353;
+UPDATE creature_template SET scriptname = 'mob_archavon_warder' WHERE entry = 32353; \ No newline at end of file