You should probably do a query with what you think you want to change and look at the results to make sure there's nothing in it you don't want to change first.
Something like this:
Code:
SELECT `id`,`name`,`hp` FROM `npc_types` WHERE `level` = 50 && `merchant_id` = 0 && `name` NOT LIKE "Guard%" AND `id` NOT IN (SELECT `npcid` FROM `pets`) ORDER BY `hp` DESC;
It looks like you might want to exclude Priest of Discord, some bankers, maybe the defenders, boats, spires, bouncers, etc. You could probably limit it to not change anything over a particular hp value except there's some fabled mobs mixed in with the high hp stuff that you might want to change. *shrug*
The method I used to exclude pets is exact but a little less efficient that the id range. It also may not be what you want since there's a few NPC pets "#Pixtt_%" in the table that would get skipped. My pet table appears to have all of the player pets in the range of 500 to 685, but my database is a little old. You can check yours like this:
Code:
SELECT `type`,`npcid` FROM `pets` ORDER BY `npcid` DESC;
There's not that many, so you can just scroll through the list and see where to start and stop, or if there are any you do want to reduce in that range. I'm not entirely sure how some of them are summoned.
Threaded Mode
