Thread:Fandyllic/@comment-204.52.135.190-20170515192141/@comment-135.84.127.135-20170516004535

UnitAura returns all "auras"

UnitBuff  returns all but as if you had filtered UnitAura with "HELPFUL"

UnitDebuff returns all but as if you had filtered UnitAura with "HARMFUL"

UnitBuff and UnitDebuff are just wrappers for UnitAura with the filters preset.

What I mean by "harmful aura" is what Blizzard means by "harmful aura" - any aura that would be returned by UnitAura if it were present on the subject of the function and the function was run with the "HARMFUL" filter applied OR any aura that would be returned by UnitDebuff if it were present on the subject of the function.

Wowhead has no ability to select spells by Buff or Debuff applied. I can run a filter against the database, but the results were worse than useless (defined as "producing results that appear to be less useful than just going in one spell at a time"). Plus, many, many of the spells in its inventory are badly out of date or obsolete.

If WowHead were current (or had a clearly identifiable tag in an article that indicated that it had been updated to information relevant to the current release of the game) and if it had the ability to produce a list based on Aura applied, I could simply look for spells that apply "slow", spells that apply "root", spells that apply "disorient", etc. But the lack of currency, the failure to remove clearly obsolete entries, and the inabiltiy to effectively select from the database by filtering on aura applied, it's pretty useless.

I thought perhaps there was a way to get to the raw data behind it all. Even a raw-but-complete table of spellIDs and names would be at least a little useful, although it would just drive the mind-numbingly slow process of checking them one by one on four or five different wiki-ish sites trying to find most-current data from which to develop the final list.