diff options
| author | Shauren <none@none> | 2010-12-03 13:36:14 +0100 |
|---|---|---|
| committer | Shauren <none@none> | 2010-12-03 13:36:14 +0100 |
| commit | bd4b47af0e1e63ecf4c2cde2a3422b190d8c5921 (patch) | |
| tree | bc700f8b2bc157623ba43347ad17d06e68d09d4f | |
| parent | 1ec9f7b82893c82226a3a9b28bc8a3f5c3e86129 (diff) | |
Core/SQL: Added missing scriptnames to full sql, fixed typos and corrected delete statement in 10418_world_spell_script_names.sql (no need to reapply)
--HG--
branch : trunk
| -rw-r--r-- | sql/base/world_database.sql | 18 | ||||
| -rw-r--r-- | sql/updates/10418_world_spell_script_names.sql | 5 |
2 files changed, 13 insertions, 10 deletions
diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql index 94079a37c6d..974bfcd249b 100644 --- a/sql/base/world_database.sql +++ b/sql/base/world_database.sql @@ -26708,6 +26708,7 @@ LOCK TABLES `spell_script_names` WRITE; INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES -- generic ( 6962, 'spell_gen_pet_summoned'), +( 10848, 'spell_gen_shroud_of_death'), ( 24750, 'spell_gen_trick'), ( 24751, 'spell_gen_trick_or_treat'), ( 29266, 'spell_creature_permanent_feign_death'), @@ -26747,14 +26748,14 @@ INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES ( 70835, 'spell_marrowgar_bone_storm'), ( 70836, 'spell_marrowgar_bone_storm'), ( 70842, 'spell_deathwhisper_mana_barrier'), -( 70903, 'spell_cultist_dark_martyrdrom'), -( 72498, 'spell_cultist_dark_martyrdrom'), -( 72499, 'spell_cultist_dark_martyrdrom'), -( 72500, 'spell_cultist_dark_martyrdrom'), -( 71236, 'spell_cultist_dark_martyrdrom'), -( 72495, 'spell_cultist_dark_martyrdrom'), -( 72496, 'spell_cultist_dark_martyrdrom'), -( 72497, 'spell_cultist_dark_martyrdrom'), +( 70903, 'spell_cultist_dark_martyrdom'), +( 72498, 'spell_cultist_dark_martyrdom'), +( 72499, 'spell_cultist_dark_martyrdom'), +( 72500, 'spell_cultist_dark_martyrdom'), +( 71236, 'spell_cultist_dark_martyrdom'), +( 72495, 'spell_cultist_dark_martyrdom'), +( 72496, 'spell_cultist_dark_martyrdom'), +( 72497, 'spell_cultist_dark_martyrdom'), ( 72202, 'spell_deathbringer_blood_link'), ( 72178, 'spell_deathbringer_blood_link_aura'), ( 72371, 'spell_deathbringer_blood_power'), @@ -26892,6 +26893,7 @@ INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES -- priest ( 47948, 'spell_pri_pain_and_suffering_proc'), (-47540, 'spell_pri_penance'), +( -8129, 'spell_pri_mana_burn'), -- death knight (-49158, 'spell_dk_corpse_explosion'), ( 50524, 'spell_dk_runic_power_feed'), diff --git a/sql/updates/10418_world_spell_script_names.sql b/sql/updates/10418_world_spell_script_names.sql index d7cdab5c376..321fda46450 100644 --- a/sql/updates/10418_world_spell_script_names.sql +++ b/sql/updates/10418_world_spell_script_names.sql @@ -1,2 +1,3 @@ -DELETE FROM spell_script_names WHERE spell_id = 10848; -INSERT INTO spell_script_names VALUES (10848, "spell_gen_shroud_of_death"); +DELETE FROM spell_script_names WHERE spell_id = 10848 AND `ScriptName`='spell_gen_shroud_of_death'; +INSERT INTO spell_script_names (`spell_id`,`ScriptName`) VALUES +(10848, 'spell_gen_shroud_of_death'); |
