Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Feature Requests

Development::Feature Requests Post suggestions/feature requests here.

Reply
 
Thread Tools Display Modes
  #1  
Old 01-31-2009, 07:32 PM
Randymarsh9
Dragon
 
Join Date: Dec 2007
Posts: 658
Default 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.
Reply With Quote
  #2  
Old 01-31-2009, 07:41 PM
ChaosSlayer
Demi-God
 
Join Date: May 2007
Posts: 1,032
Default

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
Reply With Quote
  #3  
Old 01-31-2009, 08:15 PM
Randymarsh9
Dragon
 
Join Date: Dec 2007
Posts: 658
Default

Haha, maybe they should make a tool for doing that simpler.
Reply With Quote
  #4  
Old 01-31-2009, 08:42 PM
ChaosSlayer
Demi-God
 
Join Date: May 2007
Posts: 1,032
Default

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
Reply With Quote
  #5  
Old 01-31-2009, 09:05 PM
Randymarsh9
Dragon
 
Join Date: Dec 2007
Posts: 658
Default

Alright, I will probably just do it in the database. It's mainly only the planes that are overpowered.
Reply With Quote
  #6  
Old 01-31-2009, 11:45 PM
Yeormom
Discordant
 
Join Date: Apr 2004
Location: 127.0.0.1
Posts: 402
Default

Quote:
Originally Posted by Randymarsh9 View Post
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.
__________________
Yeorwned
Bane of Life [Custom Classic/PvP]
Reply With Quote
  #7  
Old 02-08-2009, 02:37 PM
Randymarsh9
Dragon
 
Join Date: Dec 2007
Posts: 658
Default

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+?
Reply With Quote
  #8  
Old 02-08-2009, 03:22 PM
cavedude's Avatar
cavedude
The PEQ Dude
 
Join Date: Apr 2003
Location: -
Posts: 1,988
Default

Code:
update npc_types set AC = AC-200 where level > 49;
Reply With Quote
  #9  
Old 02-08-2009, 03:24 PM
Randymarsh9
Dragon
 
Join Date: Dec 2007
Posts: 658
Default

Thank You!
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 01:15 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3