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 |
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. |
Quote:
I'll update my spell files for the bots and get them to the database guys. It's been a while since I had the databases updated with the bot spells and I've had many other spell changes that need to go in. |
Quote:
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 ? |
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.
|
Just an update, Mark of Kings is spellid 3469. It should be changed from 8 to 256 as well.
Unless the numbers are different for SoF of course... |
For the PEQ DB (Titanium if it matters):
Code:
update npc_spells_entries set type=256 where spellid=3469; |
The fix I had was for titanium. I was just updating by the npc_entries id instead of the spell id. So both should work identically I think for a stock DB.
But if someone had modified their DB to add those spells to another npc cast list, your queries would be more comprehensive. Thanks! |
All times are GMT -4. The time now is 05:32 PM. |
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.