[7568][Fix / SQL] Natures Grace

[Auntie Mangos]

DELETE FROM spell_proc_event WHERE entry IN ('16880','61346','61345');
INSERT INTO spell_proc_event VALUES
('16880','0','0','0','0','0','65536','2','0','33','0');
INSERT INTO spell_proc_event VALUES
('61345','0','0','0','0','0','65536','2','0','66','0');
INSERT INTO spell_proc_event VALUES
('61346','0','0','0','0','0','65536','2','0','100','0');

This will fix all ranks of Natures Grace(will only be triggered on casting crits)

Bugreport: http://getmangos.eu/community/showthread.php?p=64754#post64754

Written by: Cha0S aka Splash

[jorooo]

Hm, procflag_ex is already set to 2 for Rank 1. I thought if you set procflag for 1 spell in chain it applies for all spells in chain.

Also there is no need to set the procflag and cooldown columns. They are loaded from dbc afaik.

[Cha0S2]

No the Proc Events doesnt hand up the stuff to higher ranks. And i posted it so becauso it work for me and hadn't enough time to test every posibility(maybe only the procex must be changed by the database from DBC).

[Graftal]

Thank you for the patch, I hope devs will include it soon

edit: forgot to say that it works fine for me

[Sephiroth1983]

You forgot to add ; in the end of the delete query, but looks good.

[Cha0S2]

A Version without Percentage was added in [7568]

[DiSlord]

in 7568 thanks

i collect sql fixes from forums