diff options
| author | Drahy <none@none> | 2009-05-13 12:42:56 +0200 |
|---|---|---|
| committer | Drahy <none@none> | 2009-05-13 12:42:56 +0200 |
| commit | a0a6efd89e75ac4f85b7179bcca60fd81198b492 (patch) | |
| tree | 8e1e9810d434b2a62b1217a5bdc9cb07e23e9c81 /sql/updates | |
| parent | 1fbc7377d1acfcee7397771c9d0def5ae345da8a (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.sql | 3 | ||||
| -rw-r--r-- | sql/updates/3235_characters.sql | 2 | ||||
| -rw-r--r-- | sql/updates/3235_world.sql | 3 | ||||
| -rw-r--r-- | sql/updates/3263_world_scripts_(missing in full).sql | 2 |
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 |
