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.

Reply
 
Thread Tools Display Modes
  #1  
Old 05-10-2019, 03:10 PM
Spike
Discordant
 
Join Date: Mar 2004
Location: Florida
Posts: 362
Default EverQuest Single Player

I have had this idea of playing EQ alone for several years now, before I knew about EQEmu. But recently I wanted to start putting this plan into action.

You can play with bots if you want, this does make the game a lot easier. But if you want to solo a character from start to finish, here are some server rules I have made up. So far I've gone from level 1 - 40 without any issues and it has been a ton of fun.

If you have any ideas to add to this list, please let me know!

## Server Rule Changes

- Faster HP/MP/Endurance regen in and out of combat.
- Reduce NPC hit rate to something more fair.
- Slower food consumption.
- Remove corpse retrieval (very difficult when playing alone).
- Remove XP loss (you may die often and not be able to get out alive).
- Lower chance of NPC's running away when getting lower in HP .
- Allow binding anywhere (you may die often).
- Remove re-mem spells on respawn.
- Remove NPC enraging.
- Let monks have AC bonus with higher weight.
- Heal on level up (this is what most action RPGs do).
- Lower kick/bash stun level from 55 to 10.

## The MySQL Script

Code:
UPDATE rule_values SET rule_value = 999 WHERE rule_name = 'Character:DeathItemLossLevel';
UPDATE rule_values SET rule_value = 1 WHERE rule_name = 'Character:DeathExpLossMaxLevel';
UPDATE rule_values SET rule_value = false WHERE rule_name = 'Character:UnmemSpellsOnDeath';
UPDATE rule_values SET rule_value = 300 WHERE rule_name = 'Character:HPRegenMultiplier';
UPDATE rule_values SET rule_value = 300 WHERE rule_name = 'Character:ManaRegenMultiplier';
UPDATE rule_values SET rule_value = 300 WHERE rule_name = 'Character:EnduranceRegenMultiplier';
UPDATE rule_values SET rule_value = 300 WHERE rule_name = 'Character:ConsumptionMultiplier';
UPDATE rule_values SET rule_value = true WHERE rule_name = 'Character:HealOnLevel';
UPDATE rule_values SET rule_value = true WHERE rule_name = 'Character:BindAnywhere';
UPDATE rule_values SET rule_value = 15 WHERE rule_name = 'Character:RestRegenPercent';
UPDATE rule_values SET rule_value = 180 WHERE rule_name = 'Character:BaseRunSpeedCap' AND ruleset_id = 1;
UPDATE rule_values SET rule_value = 180 WHERE rule_name = 'Character:BaseRunSpeedCap' AND ruleset_id = 10;
UPDATE rule_values SET rule_value = true WHERE rule_name = 'Mercs:AllowMercs';
UPDATE rule_values SET rule_value = 0 WHERE rule_name = 'Combat:FleeMultiplier';
UPDATE rule_values SET rule_value = 75 WHERE rule_name = 'Combat:BaseHitChance';
UPDATE rule_values SET rule_value = 0 WHERE rule_name = 'Combat:NPCBonusHitChance';
UPDATE rule_values SET rule_value = 15 WHERE rule_name = 'Combat:MinChancetoHit';
UPDATE rule_values SET rule_value = 40 WHERE rule_name = 'Combat:MinRangedAttackDist';
UPDATE rule_values SET rule_value = 10 WHERE rule_name = 'Combat:ClientStunLevel';
UPDATE rule_values SET rule_value = 50 WHERE rule_name = 'Combat:MonkACBonusWeight';
UPDATE rule_values SET rule_value = true WHERE rule_name = 'NPC:LiveLikeEnrage';
UPDATE rule_values SET rule_value = 5 WHERE rule_name = 'Combat:FleeGrayHPRatio';
UPDATE rule_values SET rule_value = 5 WHERE rule_name = 'Combat:FleeHPRatio' AND ruleset_id = 1;
UPDATE rule_values SET rule_value = 5 WHERE rule_name = 'Combat:FleeHPRatio' AND ruleset_id = 10;
__________________
Reply With Quote
  #2  
Old 10-23-2020, 08:18 AM
Aporia
Fire Beetle
 
Join Date: Oct 2020
Posts: 2
Default

Thanks for posting this
Reply With Quote
  #3  
Old 10-24-2020, 08:13 PM
Taleason
Fire Beetle
 
Join Date: May 2011
Location: USA
Posts: 13
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
  #4  
Old 10-26-2020, 07:47 AM
hayward6
Forum Guide
 
Join Date: Jul 2005
Posts: 468
Default

This is good work man, thanks. I run The Sandbox in a very similar manner, but I've always just made these edits manually one by one in query browser, and some of them I have simply never thought to mess with. Between this and the tweaks I made to pets in another thread, my Necro is going to have a lot of fun. Now with these changes I don't have to stick with a pet class if I don't want to. I'll try it out tonight.

Thank you!
__________________
Sayin Silverwolf
Server Op of The Sandbox (Non-Legit)
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 03:09 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 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3