|
Title: Attn: Hunter Necromance 4.0 pet resistances. Post by: Raden on April 03, 2012, 08:32:01 am I've noticed that my necromancer's 4.0 pet gets hit debuffs/dispells from lower level npcs in time and ldon zones much more than my 3.0 pet which hardly ever was debuffed in these situations. Is this intended? Seems odd that my pet which is 5 levels higher that my last has a greater disadvantage against the same mobs.
Title: Re: Attn: Hunter Necromance 4.0 pet resistances. Post by: Hunter on April 03, 2012, 12:30:39 pm I don't know?
Title: Re: Attn: Hunter Necromance 4.0 pet resistances. Post by: hateborne on April 03, 2012, 05:51:44 pm This will show the relevant information on pets.
Code: SELECT id, name, MR, CR, DR, FR, PR FROM npc_types WHERE name = 'blood_skeleton30' or name = 'NecroEpic40'; This will return the Necro 4.0 and 3.0 pet. If the values for the 4.0 pet ARE lower, then run the one below. *If* the values are low, replace X with a number: Code: SET @TV = X; I understand this is an easy query, but saving the boss some work. -Hate Title: Re: Attn: Hunter Necromance 4.0 pet resistances. Post by: Hunter on June 03, 2012, 02:20:10 am [SQL]
UPDATE npc_types SET MR = @TV, CR = @TV, DR = @TV, FR = @TV, PR = @TV WHERE name = 'NecroEpic40'; Affected rows: 1 Time: 0.981ms The blood_skeleton30 had resist at 500, and NecroEpic40 has resist at 0. Its been fixed. By the way, the 2nd query you gave me didn't work cause it says NecroPet40 instead of NecroEpic40 lol, took me about 30 seconds to figure it out though. Sorry I missed this post earlier. Been extremely busy lately and now trying to play catch up with some of your updates. Your help is very much appreciated as always :) Title: Re: Attn: Hunter Necromance 4.0 pet resistances. Post by: hateborne on June 03, 2012, 01:20:02 pm LoL that's pretty typical. I can do all kinds of fun, complex stuff...but I am the 'forget to plug it in' type.
Thanks for the fix Hunter. Maybe the necros will stop leaving burning bags of dog shi...crap on my doorstep now. -Hate |