From a0a6efd89e75ac4f85b7179bcca60fd81198b492 Mon Sep 17 00:00:00 2001 From: Drahy Date: Wed, 13 May 2009 12:42:56 +0200 Subject: * Completely redone trinityscript_script_texts sql - never again :-) * Cleaned up world_scripts_full * Used trinity sql coding style for sql updates --HG-- branch : trunk --- sql/updates/3233_world_scripts_naxx.sql | 3 +-- sql/updates/3235_characters.sql | 2 +- sql/updates/3235_world.sql | 3 +-- sql/updates/3263_world_scripts_(missing in full).sql | 2 +- 4 files changed, 4 insertions(+), 6 deletions(-) (limited to 'sql/updates') 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 -- cgit v1.2.3