Increase Mobs HP

[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

[JIV]

in db - table npc, column hp.

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

[Charus]

UPDATE `npc` SET `hp` = 'hp * 2' WHERE `type` = 'L2Monster';

I think this will give duble hp to mobs.

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

[janiii]

Code: Select all

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

[Chiripa]

Thank you very much! It worked perfectly