Attn: Hunter Necromance 4.0 pet resistances.

User

Welcome, Guest. Please login or register.
Did you miss your activation email?

September 21, 2024, 03:37:28 am

EZ Server > Forum > General Category > Suggestions > Attn: Hunter Necromance 4.0 pet resistances.

Pages: [1]

« previous next »

Author

Topic: Attn: Hunter Necromance 4.0 pet resistances. (Read 5093 times)

Raden

Newbie

Posts: 2

Attn: Hunter Necromance 4.0 pet resistances.

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


	Logged

Hunter

EZ Server GM
Legend

Posts: 8100

EZ Server GM

Re: Attn: Hunter Necromance 4.0 pet resistances.

« Reply #1 on: April 03, 2012, 12:30:39 pm »

I don't know?


	Logged

Hunter - EZ Server GM

hateborne

Legend

Posts: 2282

Don't nerf me bro!

Re: Attn: Hunter Necromance 4.0 pet resistances.

« Reply #2 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;
UPDATE npc_types SET MR = @TV, CR = @TV, DR = @TV, FR = @TV, PR = @TV WHERE name = 'NecroPet40';

I understand this is an easy query, but saving the boss some work.

-Hate


	Logged

I'm so sorry Hunter, I tried...

Hunter

EZ Server GM
Legend

Posts: 8100

EZ Server GM

Re: Attn: Hunter Necromance 4.0 pet resistances.

« Reply #3 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


	Logged

Hunter - EZ Server GM

hateborne

Legend

Posts: 2282

Don't nerf me bro!

Re: Attn: Hunter Necromance 4.0 pet resistances.

« Reply #4 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