diff options
| -rw-r--r-- | sql/updates/7324_01_characters_character_spell.sql | 13 | ||||
| -rw-r--r-- | sql/updates/7324_02_characters_character_aura.sql | 13 | ||||
| -rw-r--r-- | src/shared/revision_nr.h | 2 |
3 files changed, 27 insertions, 1 deletions
diff --git a/sql/updates/7324_01_characters_character_spell.sql b/sql/updates/7324_01_characters_character_spell.sql new file mode 100644 index 00000000000..d4917ec4814 --- /dev/null +++ b/sql/updates/7324_01_characters_character_spell.sql @@ -0,0 +1,13 @@ +ALTER TABLE character_db_version CHANGE COLUMN required_7314_01_characters_guild_rank required_7324_01_characters_character_spell bit; + +/* remove some deleted spells or ranks from characters */ +/* Mana Tap no longer Blood Elf Racial */ +DELETE FROM `character_spell` WHERE `spell` = '28734'; +/* Hamstring is only one rank now, need to delete these zzOLDRank spells */ +DELETE FROM `character_spell` WHERE `spell` IN ('7373', '7372', '25212'); +/* Intercept is only one rank now, need to delete these zzOLDRank spells */ +DELETE FROM `character_spell` WHERE `spell` IN ('20616', '20617', '25272', '25275'); +/* Overpower is only one rank now, need to delete these zzOLDRank spells */ +DELETE FROM `character_spell` WHERE `spell` IN ('7887', '11584', '11585'); +/* Shield Bash is only one rank now, need to delete these zzOLDRank spells */ +DELETE FROM `character_spell` WHERE `spell` IN ('1671', '1672', '29704'); diff --git a/sql/updates/7324_02_characters_character_aura.sql b/sql/updates/7324_02_characters_character_aura.sql new file mode 100644 index 00000000000..c9379d25788 --- /dev/null +++ b/sql/updates/7324_02_characters_character_aura.sql @@ -0,0 +1,13 @@ +ALTER TABLE character_db_version CHANGE COLUMN required_7324_01_characters_character_spell required_7324_02_characters_character_aura bit; + +/* remove some deleted spells or ranks from characters auras */ +/* Mana Tap no longer Blood Elf Racial */ +DELETE FROM `character_aura` WHERE `spell` = '28734'; +/* Hamstring is only one rank now, need to delete these zzOLDRank spells */ +DELETE FROM `character_aura` WHERE `spell` IN ('7373', '7372', '25212'); +/* Intercept is only one rank now, need to delete these zzOLDRank spells */ +DELETE FROM `character_aura` WHERE `spell` IN ('20616', '20617', '25272', '25275'); +/* Overpower is only one rank now, need to delete these zzOLDRank spells */ +DELETE FROM `character_aura` WHERE `spell` IN ('7887', '11584', '11585'); +/* Shield Bash is only one rank now, need to delete these zzOLDRank spells */ +DELETE FROM `character_aura` WHERE `spell` IN ('1671', '1672', '29704'); diff --git a/src/shared/revision_nr.h b/src/shared/revision_nr.h index ae44645b3f5..83f103e2b16 100644 --- a/src/shared/revision_nr.h +++ b/src/shared/revision_nr.h @@ -1,4 +1,4 @@ #ifndef __REVISION_NR_H__ #define __REVISION_NR_H__ - #define REVISION_NR "7323" + #define REVISION_NR "7324" #endif // __REVISION_NR_H__ |