EQEmulator Forums - Mass NPC Edit by zone

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - Mass NPC Edit by zone (https://www.eqemulator.org/forums/showthread.php?t=35818)

Mass NPC Edit by zone

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

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

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.

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

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

Code:

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.