Quote:
Originally Posted by zergling
Cool deal, I will try setting them as DoTs when I get home.
For reference, this should catch the cleric "Mark" line
UPDATE `npc_spells_entries` SET `type` = '256' WHERE `npc_spells_entries`.`id` =3157 LIMIT 1 ;
UPDATE `npc_spells_entries` SET `type` = '256' WHERE `npc_spells_entries`.`id` =3159 LIMIT 1 ;
Looks like only two of the spells in that line appear on cast lists. Those two statements will set them as DoTs instead of buffs.
Also, Prov, Apathy of the Nihil was set as 1 (nuke), so I would think it would still be detrimental, but I'm probably going to go ahead and set it to Mez ( 2048 ) since there is a specific category for mezzes.
UPDATE `npc_spells_entries` SET `type` = '2048' WHERE `npc_spells_entries`.`id` =3851 LIMIT 1 ;
There may be others, but me may have to just find them through trial and error.
|
Well I was about to post something similar but you beat me to it. I am standing in front of Semkak Prophet of Vallon in Kael and right when he cast Mark of Karn the two guards in front of him beat him down like he is a level 1 newbie.
I backed up my database, then ran those two MySQL lines and zoned back in, repopped the zone. They are still doing it, do you have to bounce the server for that to work ?