(Aura / Stacking) Ferocious Inspiration / Sanctified Retribution / Arcane Empowerment

[EnteringCombat]

Hello,
Please notice that the previous issue presented regarding those auras stacking was lacking alot of information.

FI = Ferocious Inspiration, SR = Sanctified Retribution, AE = Arcane Empowerment
There's an existing problem with the following auras stacking:
FI (Beast Mastery hunter) aura stacks with SR (Retribution Paladin talent) along with AE (Arcane Mage's aura).

What should happen:
-The raid must benefit from one aura and gain 3% damage, even if all three auras are available in the raid by the three following classes with the given specs. (Notice how Retribution Aura should be a buff anyhow, but shouldn't boost 3% additional damage if a BM/Arcane mage are in the raid).

What happens instead:
-The raid benefits from all three auras, having FI and AE auras stacking together while only one of them should be active as a buff for raid members.
Notice that SR is a talent that boosts the Retribution Aura. This means that a retadin with this talent should still give the raid the Retribution Aura buff , but this aura shouldn't boost the raid's damage by 3% as long as there's an arcane mage or a BM hunter presence in the raid.

Bottom line - the raid gains 3% damage from FI, 3% damage from AE, and 3% damage from SR.
Relevant links:
Sanctified Retribution - http://wotlk.openwow.com/?spell=31869
Ferocious Inspiration 3/3 - http://wotlk.openwow.com/?spell=34460
Arcane Empowerment 3/3 - http://wotlk.openwow.com/?spell=31583

We use hash a8a5b5a
Thanks in advance,
EnteringCombat.

[durrrr]

duplicate of:
#4295

[Pitcrawler]

To fix this there should be an entry in spell_group table containing the three spells. Then there should be an additional entry in spell_group_stack_rules table with stack rule SPELL_GROUP_STACK_RULE_EXCLUSIVE_SAME_EFFECT = 3.
That way all the group-/raidmembers will have the buffs but the 3% damage increase won't stack.

[EnteringCombat]

The report linked above by durrrr was closed, furthermore lacking information regarding SR.

[Amit86]

DELETE FROM spell_group WHERE id=1056;
INSERT INTO spell_group VALUES
(1056,31583),
(1056,31869),
(1056,34460);

DELETE FROM spell_group_stack_rules WHERE group_id=1056;
INSERT INTO spell_group_stack_rules VALUES
(1056,3);

Tried this - Didn't work.. any other advise?

[Pitcrawler]

Checked the spell effects and as they are different for the three spells spell_group was a bad idea... Sorry about that

[Xanvial]

i think we should use spell that linked to the talents which give damage % mod only
like http://wotlk.openwow.com/?spell=75447 (Ferocious Inspiration rank 3)
and use group stack rules 1

[Pitcrawler]

Hm nice catch but I'm not sure about stack rule 1. If we set it that way all party and raidmembers will only have one of these auras on them. I think on retail everyone would have all three auras (if there is a player in the group/raid with this talent specced) but there would be just a 3% damage increase in total. And that is what stack rule 3 is for.

Can anyone test this

DELETE FROM `spell_group` WHERE `id`=1117;
INSERT INTO `spell_group` (`id`,`spell_id`) VALUES
(1117,31579),
(1117,63531),
(1117,75446),
(1117,75447),
(1117,75593);

DELETE FROM `spell_group_stack_rules` WHERE `group_id`=1117;
INSERT INTO `spell_group_stack_rules` (`group_id`,`stack_rule`) VALUES
(1117,3);

[Star-lion]

stack rule 3 is having some issues. once its fixed all these will work

[Aokromes]

This was fixed no?

[Lat89]

Nope, not fixed, newer report here #7667