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.
Threaded Mode
