[3.0.2+][7324] Spells deleted from characters

[Sephiroth1983]

• * What bug does the patch fix? What features does the patch add?
  It removes the Blood Elf racial Mana Tap no longer used and also some old outdated ranks of Intercept, Shield Bash, Overpower and Hamstring, since now are unique ranked spells.
  * For which repository revision was the patch created?
  7255 (all)
  * Who has been writing this patch?
  Me but this is not such a patch
  

-- 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');
-- lets also clear character_aura
DELETE FROM `character_aura` WHERE `spell` IN ('28734', '7373', '7372', '25212', '20616', '20617', '25272', '25275', '7887', '11584', '11585', '1671', '1672', '29704');

spell_chain are already deleted, I don't remember if mangos accepts characters DB correctness fixes, but this can help to avoid some bug reports.

[Sephiroth1983]

Any toughts?

[throneinc]

obvious fix is obvious, thanks mate

[VladimirMangos]

In [7324]. Thank you

[Sephiroth1983]

If your testers have problem of Intercept not visibile in spell book is because before fix only last rank was shown, fixed with this:

UPDATE `character_spell` SET `active` = '1' WHERE `spell` = '20252';

[merlinus]

Thanks Sephiroth. And the same fix for the others spells (hamstring, overpower,shield bash) is needed, I think.

[Sephiroth1983]

Thanks Sephiroth. And the same fix for the others spells (hamstring, overpower,shield bash) is needed, I think.

On my level 70 character only Intercept had this problem, other spells became unique ranked (first rank) and visible without additions.