EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Development::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=596)
-   -   how do I edit npc dmg with mysql pls? (https://www.eqemulator.org/forums/showthread.php?t=29503)

robert19 09-09-2009 09:00 PM

how do I edit npc dmg with mysql pls?
 
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 09-09-2009 10:25 PM

There's plenty of examples about this

http://www.eqemulator.net/forums/sho...ypes+level+sql


GeorgeS

Davood 09-11-2009 07:08 PM

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 09-11-2009 09:55 PM

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


All times are GMT -4. The time now is 10:11 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.