Go Back   EQEmulator Home > EQEmulator Forums > Misc > Misc::Off Topic

Misc::Off Topic Want to talk about something that has nothing to do with EverQuest or the emulator? Post here.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 10-24-2020, 08:13 PM
Taleason's Avatar
Taleason
Fire Beetle
 
Join Date: May 2011
Location: USA
Posts: 15
Smile A few more tweaks for solo play

Code:
-- This makes monsters easier for solo play

UPDATE npc_types SET AC=CEIL(level*20) WHERE level>19 AND AC>(level*20);
UPDATE npc_types SET maxdmg=(level) WHERE level>19 AND maxdmg>(level) AND id>1000 AND id<800000;
UPDATE npc_types SET mindmg=CEIL(level/10) WHERE level>19 AND mindmg>(level/10) AND id>1000 AND id<800000;
UPDATE npc_types SET hp=CEIL(level*35) WHERE level>19 AND hp>(level*35) AND id>1000 AND id<800000;
UPDATE npc_types SET STR=CEIL(level*4) WHERE level>19 AND STR>(level*4) AND id>1000 AND id<800000;
UPDATE npc_types SET STA=CEIL(level*4) WHERE level>19 AND STA>(level*4) AND id>1000 AND id<800000;
UPDATE npc_types SET DEX=CEIL(level*4) WHERE level>19 AND DEX>(level*4) AND id>1000 AND id<800000;
UPDATE npc_types SET AGI=CEIL(level*4) WHERE level>19 AND AGI>(level*4) AND id>1000 AND id<800000;
UPDATE npc_types SET _INT=CEIL(level*4) WHERE level>19 AND _INT>(level*4) AND id>1000 AND id<800000;
UPDATE npc_types SET WIS=CEIL(level*4) WHERE level>19 AND WIS>(level*4) AND id>1000 AND id<800000;
UPDATE npc_types SET CHA=CEIL(level*4) WHERE level>19 AND CHA>(level*4) AND id>1000 AND id<800000;
UPDATE npc_types SET ATK=CEIL(level*(9+(level/10))) WHERE level>19 AND ATK>(level*(9+(level/10))) AND id>1000 AND id<800000;
UPDATE npc_types SET MR=CEIL(level*1.50) WHERE level>19 AND MR>(level*1.50) AND id>1000 AND id<800000;
UPDATE npc_types SET CR=CEIL(level*1.50) WHERE level>19 AND CR>(level*1.50) AND id>1000 AND id<800000;
UPDATE npc_types SET DR=CEIL(level*1.50) WHERE level>19 AND DR>(level*1.50) AND id>1000 AND id<800000;
UPDATE npc_types SET FR=CEIL(level*1.50) WHERE level>19 AND FR>(level*1.50) AND id>1000 AND id<800000;
UPDATE npc_types SET PR=CEIL(level*1.50) WHERE level>19 AND PR>(level*1.50) AND id>1000 AND id<800000;
UPDATE items SET name=REPLACE(name, '(Test)', '');
These were taken from the following .SQL file, which I run on a basic server install to make it solo friendly. Feel free to change it to meet your own needs.
https://drive.google.com/file/d/16iq...ew?usp=sharing

Last edited by Taleason; 10-24-2020 at 08:23 PM.. Reason: added link to google drive containing .SQL file
Reply With Quote
 


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 03:29 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 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3