Mass NPC Edit by zone

[Warking]

Hello,

I have been playing around a while and I still have to edit each NPC manually and one at a time.

If I wanted to revamp a zone and change the level of all the NPC's in the zone at once; then change their HP / dmg output all at once is there a way to do it for all the mobs in that one zone?

Thanks

[GeorgeS]

Very simple to do - you will need the npc&loot editor available here. Load in a zone, then in drop down menu use field utilities to modify stats by zone.

GeorgeS

[wolfwalkereci]

Could run some sql queries if you didn't want to use one of the GUI tools and knew what you wanted to do.
Update npc_types set level = x, mindmg = x, maxdmg = x where (id>=8000 and id<=8999);

Using zone 8 as the example there and of course that is a sledgehammer approach. Would want to refine it a little.

[Warking]

Thanks! This helped a ton. Now I need to learn more on quest creation, event triggering, and instances. Trying to customize an expansion :o)

[jsr]

Might not need it now, but this type of query might help you.

update
zone
inner join spawn2 on zone.short_name = spawn2.zone
inner join spawngroup on spawn2.spawngroupID = spawngroup.id
inner join spawnentry on spawngroup.id = spawnentry.spawngroupID
inner join npc_types on spawnentry.npcID = npc_types.id
inner join npc_stats_template on npc_types.level = npc_stats_template.level

set
npc_types.ac = npc_stats_template.ac,
npc_types.hp = npc_stats_template.hp,
npc_types.mindmg = npc_stats_template.mindmg,
npc_types.maxdmg = npc_stats_template.maxdmg

where zone.short_name = [$zone]
and npc_types.lastname <> "Mini Boss"
and npc_types.lastname <> "Boss"

It works on the principle that you setup a table (npc_stats_template) containing key stats for each mob level, and identify bosses and minibosses in the npc_types table using npc_types.lastname.

Then when balancing mob stats you can update the npc_stats_template table for the levels you want, and rebalance mobs across 1 or more zones with one query.