EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Development::Feature Requests (https://www.eqemulator.org/forums/forumdisplay.php?f=612)
-   -   Way to mass weaken monsters (https://www.eqemulator.org/forums/showthread.php?t=27358)

Randymarsh9 01-31-2009 07:32 PM

Way to mass weaken monsters
 
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 01-31-2009 07:41 PM

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 01-31-2009 08:15 PM

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

ChaosSlayer 01-31-2009 08:42 PM

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 01-31-2009 09:05 PM

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

Yeormom 01-31-2009 11:45 PM

Quote:

Originally Posted by Randymarsh9 (Post 163650)
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 02-08-2009 02:37 PM

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 02-08-2009 03:22 PM

Code:

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

Randymarsh9 02-08-2009 03:24 PM

Thank You!


All times are GMT -4. The time now is 08:58 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.