My Siren's Grotto

[zergling]

Noticed that Mark of Kings and some of the other spells in the line were set up as damage shields instead of reverse damage shields. They were all flagged as non-beneficial already though.

I fixed all that, but unfortunately he still cast it on himself. Does anyone have any idea of how you control what spells an NPC casts on themself?

Seems like this would be a problem with any NPC that is a cleric of sufficient level.

[Shendare]

Potentially relevant database tables include:

- damageshieldtypes
- npc_spells
- npc_spells_entries

[zergling]

Mark of Kings is set as 8 ( SpellType_Buff ) for type in npc_spells_entries. Where those constants are defined I do not see any that is SpellType_Debuff that I can change it to. The list I see is:

const int SpellType_Nuke=1;
const int SpellType_Heal=2;
const int SpellType_Root=4;
const int SpellType_Buff=8;
const int SpellType_Escape=16;
const int SpellType_Pet=32;
const int SpellType_Lifetap=64;
const int SpellType_Snare=128;
const int SpellType_DOT=256;
const int SpellType_Dispel=512;
const int SpellType_InCombatBuff=1024;
const int SpellType_Mez=2048;

What should a debuff be coded as? Just like a nuke?

[gaeorn]

Maybe more like a DOT since it has a fixed duration where there is no point in recasting until it fades. Tho, I would have to look at the server code to see if that is really the best option. Maybe someone else knows already.

[ChaosSlayerZ]

technicly its a debuff, but since we don't have such property, the DoT should do.
I just realised I why I don't have problem with this on my server - I have turned off npc buffing each other a while ago =)

[Shendare]

Yeah, if there isn't a debuff category, it's hard to say. It's probably actually closer to a DoT than a nuke, since it'll be causing damage over time as the hits land.

Edit: Oops, must have left the tab open longer than I thought. Others already answered. :P

[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.

[provocating]

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 ?

[provocating]

I just rebooted and everything is now fixed. I ran the two SQL statements, bounced the server and all is well now. It was the Mark line of spells causing it.