Way to mass weaken monsters

[Randymarsh9]

I'm not sure if there is already a way to do this, but I haven't been able to find anything. The monsters in the planes are really overpowered and I want to be able to lower all of their stats without having to individually edit them.

[ChaosSlayer]

I don't think this belongs in Feature Request section - more like in "working with mysql" =P

update peq.npctypes set hp=level*10;

this will set hp of a mob =lev*10 for all mobs in db

you can make it more complex if you wish with soemthing like that:

update peq.npc_types set
attack_speed=0,
hp=level*8+(level-1)*(level-1)/4, ac=(level-1)*(level-1)/5+8,
mindmg=(level/10), maxdmg=(level/2+1),
str=(48+(level*2)),sta=(48+(level*2)),dex=(48+(lev el*2)),agi=(48+(level*2)),
wis=(48+(level*2))+25,_int=(48+(level*2))+25,cha=( 48+(level*2))+25,
mr=level/2, fr=level, cr=level, dr=level, pr=level,
hp_regen_rate=(level/10), mana_regen_rate=(level/5);


this will set hp, ac, resists etc for all all mobs based on the their level

[Randymarsh9]

Haha, maybe they should make a tool for doing that simpler.

[ChaosSlayer]

you can't realy make this more simpler other than editing specific mob by hand

if you WANT to affect 100s of mobs at same time- you will have to enter crap load of spec data anyway - which means specifying actual formulas and stat increase progression - so no there is no real way to make this any more simpler

[Randymarsh9]

Alright, I will probably just do it in the database. It's mainly only the planes that are overpowered.

[Yeormom]

Haha, maybe they should make a tool for doing that simpler.
Get one started for us then! As ChaosSlayer pointed out, this would be clearly out of scope for the eqemulator project as it is a MySQL topic. There is a tool development forum as well. :)

[Randymarsh9]

A lot of people are complaining about mobs having too much AC, so is there a way I can minus like 200 AC from all mobs 50+?

[cavedude]

update npc_types set AC = AC-200 where level > 49;

[Randymarsh9]

Thank You!