Here is list of spells that don't work at all, and possible reasons why:

1) Ruin

Doesn't decrease enemy health, not heals the caster.

Also, both heal and drain visuals are shown on the target.

Reason: Probably StealUnitStat attribute is bugged.

2) Crush Spirit

Doesn't decrease enemy morale at all.

Reason: AdjustUnitStat attribute just doesn't work with CurMorale as string parameter

Solution: see Fear spell. It uses IncreaseMorale as attribute, which properly decreases moral (also ModType needs to be TacticalUnit in that case)

3) Bravery

Doesn't increase morale at all.

Reason: same as above

Solution: same above. Only difference is that using IncreaseMorale as attribute only works if there is no set duration (so it needs to work for whole combat, not just 3 rounds).

4) Berserk

Doesn't work at all.

Reason: Probably IncreaseDecreaseUnitStats attribute is non-functional

Solution: Can be worked around by using two modifiers with AdjustUnitStat attribute

5) Slow

Not workiiiing!

Reason: SetUnitStat is not functional

Solution: Can be worked around by using AdjustUnitStat attribute

6) Burning Blade

nothing

Reason: Missing parameter for AdjustUnitStat, so game doesn't know which stat to modify

Also, calculation is way off (multiplications instead adding static bonus to attack), and there is no duration set.

7) Shield of Fire

same as above

.

As a bonus, spells that work but with some bugs:

1) Confusion

Wrong calculation when applied to stack

Reason: penalty is applied per units inside group, but calculation uses total combined attack rating.

So unit with 4 guys at total attack of 40 will get penalty of -20attack to every unit inside. That means 10-20=-10 attack rating per unit, or final attack rating of -40 for group.

Also: wrong calculation when applied to strong creatures

Reason: penalty is applied to unit base attack, but calculation uses total attack rating. So if troll with strength of 30 has attack of 30, his base attack is 10 (10*300%=30). And when 1/2 of 30 is deduced from base of 10, you get -5 base attack, or negative total of -15.

2) Bunch of damage spells

shard damage bonus not working

Reason: It's not defined properly if shard bonus stat is pulled from spell target or caster (missing ValueOwner parameter in final calculation)

3) Bunch of morale spells

shard bonus not working

Reason: same as above