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!
|