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