Editing all NPC hp and damage

[Found]

how can I do this without editing every single npc.. I need it so it matches the 255 and 5000% attributes on my server.

Thanks in advance

-l0st

[stoneharry]

UPDATE `creature_proto` SET `mindamage` = mindamage*50;
UPDATE `creature_proto` SET `maxdamage` = maxdamage*50;

Add your own formulas or write a formula in there to * by 5000%. That's basically how you would edit it all though with a single query.

[Found]

Thank you very much SH!

[Harambeqt]

You may also use:

UPDATE `creature_proto` SET `mindamage`  = mindamage*50 where 'creature_level' = > 5;
 UPDATE `creature_proto` SET `maxdamage` = maxdamage*50 where 'creature_level' = > 5;

This should work if you only want to do it on npcs above level 5.