[DiscordArchive] Isn't this `Interface/Reforging/`?
[DiscordArchive] Isn't this `Interface/Reforging/`?
Archived author: Deleted User • Posted: 2021-11-13T16:20:17.698000+00:00
Original source
Isn't this `Interface/Reforging/`?
Archived author: <o> • Posted: 2021-11-13T16:40:22.097000+00:00
Original source
what set of Effect ABCs depends on which effect you're checking, because they can target different spells. Effect1 can target a different spell from Effect2 etc. So you only want to use ABC's of a single effect
Archived author: <o> • Posted: 2021-11-13T16:41:29.569000+00:00
Original source
the different mask numbers in the spell would be:
Effect1 ABC (single number, 96 bits)
Effect2 ABC (single number, 96 bits)
Effect3 ABC (single number, 96 bits)
Family (single number)
SpellABC (single number)
Archived author: <o> • Posted: 2021-11-13T16:42:31.668000+00:00
Original source
so if your naming scheme is EffectSpellClassMaskA1 etc, then you'd want to check (for effect 1)
EffectSpellClassMaskA1 against SpellMaskA
EffectSpellClassMaskB1 against SpellMaskB
EffectSpellClassMaskC1 against SpellMaskC
Archived author: stoneharry • Posted: 2021-11-13T16:47:56.367000+00:00
Original source
Ah yes, durp. I forgot the fields were spread out over 3 effects. I'm hungover and it's been a while since I've looked at this... not sure I can make many excuses for that.
Archived author: <o> • Posted: 2021-11-13T16:50:56.703000+00:00
Original source
dunno what they needed that many combinations for, unique families and still 96 bits
Archived author: stoneharry • Posted: 2021-11-13T16:51:49.336000+00:00
Original source
So for the tree of life example, where values > 0, it would be:
```sql
SELECT id, SpellName0 FROM spell WHERE
SpellFamilyName = 7 AND
(
(
-- Effect1
(SpellFamilyFlags & 80) > 0 OR
(SpellFamilyFlags1 & 0) > 0 OR
(SpellFamilyFlags2 & 80) > 0
) OR
(
-- Effect2
(SpellFamilyFlags & 0) > 0 OR
(SpellFamilyFlags1 & 67108880) > 0 OR
(SpellFamilyFlags2 & 67108880) > 0
)
);
```
And that does seem to return data that looks correct
Archived author: stoneharry • Posted: 2021-11-13T16:52:34.817000+00:00
Original source
Need to try and come up with some way to graphically show this, it's not very nice having to mouseover each flag to see what spells it would target and it doesn't show from the UI how it interacts with the family flags