how do I edit npc dmg with mysql pls?

[robert19]

as the title above states how can I mass edit npcs min and max dmg using mysql based off their level? thanks for any help in advance.

[GeorgeS]

There's plenty of examples about this

http://www.eqemulator.net/forums/showthread.php?t=28966&highlight=npc_types+level+sql


GeorgeS

[Davood]

UPDATE npc_types SET min_damage = min_damage * 1.5 WHERE min_damage > 0
UPDATE npc_types SET max_damage = max_damage * 1.5 WHERE max_damage > 0

that will increase min and max damage by 1.5 (50%) for all records in npc_types

obviously you can modify that to your desires

[robert19]

thanks for the help, this is exactly what I was looking for! :)