Page 1 of 1

Increase Mobs HP

Posted: Sat Jan 23, 2010 5:24 pm
by Chiripa
If you want to receive support we need this info to help you properly.
ยป Find Revision
L2J Revision Number: 3829
L2JDP Revision Number: 6912

Hi,

I made my test server and has been running for a while now.
The only thing i need to do now and i dont know how is increase the mobs hp, not all but almost all.
I see the players killing in aden's cementery mobs lv 52+ with a top D weapon in 3/4 hits (for spellsinger for example).
Mobs lv 71+ are ok with their hp but i see that mobs below these levels are just too weak (Don't know if I should change their defense stats or increse their health, i think the hp increase is the best solution).

My question is. Is there a way to increase the hp of all 60- or 70- mobs and below withouth having to do it manually mob per mob on the db?
Like to increase their health x2 or x3.

Thank you very much

Re: Increase Mobs HP

Posted: Sat Jan 23, 2010 5:32 pm
by JIV
in db - table npc, column hp.

Re: Increase Mobs HP

Posted: Sat Jan 23, 2010 6:24 pm
by Chiripa
Can I make like a sql file that tells the db to increase from x line to z line the column value of hp to the double?

Re: Increase Mobs HP

Posted: Sat Jan 23, 2010 6:28 pm
by Charus
UPDATE `npc` SET `hp` = 'hp * 2' WHERE `type` = 'L2Monster';

I think this will give duble hp to mobs.

Re: Increase Mobs HP

Posted: Sat Jan 23, 2010 6:41 pm
by Chiripa
Yes, but i need only lv 60 and below mobs to increase the hp, Is there a way that i tell the sql just to update these ones?

Re: Increase Mobs HP

Posted: Sat Jan 23, 2010 6:47 pm
by janiii

Code: Select all

UPDATE `npc` SET `hp` = `hp` * 2 WHERE `type` = 'L2Monster' AND `level` <= 60;

Re: Increase Mobs HP

Posted: Sun Jan 24, 2010 6:37 pm
by Chiripa
Thank you very much! It worked perfectly ;)