[4.0.6a] Spell.dbc -> Dispel type? School of spell?

[Tanaris4]

So I've been poking around in Spell.dbc - WoW.Dev Wiki and have come quite a ways in pulling all spell information directly from the Spell DBC.

I was hoping I could et some help on the last few things I need to stop using wowhead completely (yes I used to pull all spell information directly from wowhead, sucks, but it worked).

Specifically, I'm looking for dispel type/spell type (meaning: Magic, Poison, Curse, Disease). Pre-4.x there was a dispelType, which I no longer see. And it looks like looking at the Category is a dead end (it was for me).

And lastly, school (i.e. Holy, Shadow, etc...). I thought schoolMask may help, but unfortunately I couldn't find a pattern. For a priest it seemed most holy spells were of category 2, and shadow as 32 or 48. But then when I log onto a rogue, all spells are a 1. So I don't think this is conclusive.

Does anyone have any ideas or know where these items are w/in the DBC? Even pointing me towards a function to reverse would be helpful, I couldn't find any lua functions that return this info.

Thanks in advance!

[caytchen]

With Cataclysm, lots of this stuff has been removed from the big-ass Spell.dbc and split off into smaller DBCs. See attached screenshot (just take the route down from the UnitAura LUA function).

[Scorpiona]

Dispel type can be found using the SpellCategories DBC (Spell.dbc records should have an index to their SpellCategories entry)

edit: Caytchen beat me to it

[Tanaris4]

Thanks for the quick response, I'll check again. Guess I was doing something wrong in what I was writing.

Any idea on the spell school?

Edit: SpellCategoriesDBTable vs. SpellCategoryDBTable is important

[TOM_RUS]

Any idea on the spell school?

Isn't there still SchoolMask in Spell struct (struct may be a bit outdated, but not much)?

[Tanaris4]

There is a SchoolMask, but it doesn't really make a lot of sense, or I haven't figured it out. I printed out the school mask along w/the spell name and it semi-worked. But you don't know what mask means what.

For example, all shadow priest spells have a SchoolMask of 32. Yet Mind Spike (also shadow, right?) is 48.

Then if you look at rogue spells, they're all 1. So I'm a bit confused as to what it means.

Ideally I'd like to be able to separate them based on which tab they are in on the spell book. (i.e. Holy vs. Disc vs. Shadow). Think this is possible w/o hard coding a table?

[TOM_RUS]

There is a SchoolMask, but it doesn't really make a lot of sense, or I haven't figured it out. I printed out the school mask along w/the spell name and it semi-worked. But you don't know what mask means what.

For example, all shadow priest spells have a SchoolMask of 32. Yet Mind Spike (also shadow, right?) is 48.

Then if you look at rogue spells, they're all 1. So I'm a bit confused as to what it means.

Ideally I'd like to be able to separate them based on which tab they are in on the spell book. (i.e. Holy vs. Disc vs. Shadow). Think this is possible w/o hard coding a table?

48=32+16

SCHOOL_MASK_NONE = 0x00;
SCHOOL_MASK_PHYSICAL = 0x01;
SCHOOL_MASK_HOLY = 0x02;
SCHOOL_MASK_FIRE = 0x04;
SCHOOL_MASK_NATURE = 0x08;
SCHOOL_MASK_FROST = 0x10;
SCHOOL_MASK_SHADOW = 0x20;
SCHOOL_MASK_ARCANE = 0x40;

[Tanaris4]

I love you, so much, sir.