View Single Post
  #3  
Old 01-15-2020, 03:19 PM
Sturm
Hill Giant
 
Join Date: Dec 2015
Posts: 116
Default

UPDATE npc_types SET hp = hp * 0.3 WHERE id >= '1001';

All the pets should be in the lower than 1000 range. At least they are in my database.

Remember to back up your npc_types table before running queries that effect such a large amount of data so you can easily revert should something go horribly wrong!

You can always further define the query if needed aswell. Hope this helps!
__________________
Developer of the Imperium Server.
https://imperium-eq.com/
Reply With Quote