Go Back   EQEmulator Home > EQEmulator Forums > General > General::Server Discussion

General::Server Discussion Discussion about emulator servers.
Do not post support topics here.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 02-15-2018, 09:38 PM
Havoc550
Fire Beetle
 
Join Date: Feb 2018
Location: San Antonio, TX
Posts: 3
Default My Solo Server Settings

I have been messing with EQ EMU off and on for several years now, even back when the entire server creation was manual. I just put a new server up and thought I would list my SOLO server tweaks which may help out some of the first time server admins.

I tweaked a lot of mob settings, made every item available to every class and race, eliminated all no drop, no rent, skill and level requirements, etc. I don't remember what some of these tweaks further down do, but I am re-learning everything as I go.

Code:
UPDATE npc_types SET hp = hp/3 where hp < 50 * level;
UPDATE npc_types SET hp = hp/4 where hp between (50 * level) and (99 * level);
UPDATE npc_types SET hp = hp/5 where hp between (100 * level) and (199 * level);
UPDATE npc_types SET hp = hp/6 where hp between (200 * level) and (299 * level);
UPDATE npc_types SET hp = hp/7 where hp between (300 * level) and (399 * level);
UPDATE npc_types SET hp = hp/8 where hp between (400 * level) and (499 * level);
UPDATE npc_types SET hp = hp/9 where hp between (500 * level) and (999 * level);
UPDATE npc_types SET hp = hp/10 where hp between (1000 * level) and (2499 * level);
UPDATE npc_types SET hp = hp/25 where hp between (2500 * level) and (4999 * level);
UPDATE npc_types SET hp = hp/50 where hp between (5000 * level) and (10000 * level);
UPDATE npc_types SET hp = hp/100 where hp > 10000 * level;
UPDATE npc_types SET ac = ac/2 where level <= 10;
UPDATE npc_types SET ac = ac/2.5 where level > 10 AND level <= 20;
UPDATE npc_types SET ac = ac/3 where level > 20 AND level <= 30;
UPDATE npc_types SET ac = ac/3.5 where level > 30 AND level <= 40;
UPDATE npc_types SET ac = ac/4 where level > 40 AND level <= 50;
UPDATE npc_types SET ac = ac/4.5 where level > 50 AND level <= 60;
UPDATE npc_types SET ac = ac/5 where level > 60 AND level <= 70;
UPDATE npc_types SET ac = ac/5.5 where level > 70;
UPDATE npc_types SET mindmg = mindmg/2 where level <= 10;
UPDATE npc_types SET mindmg = mindmg/2.5 where level > 10 AND level <= 20;
UPDATE npc_types SET mindmg = mindmg/3 where level > 20 AND level <= 30;
UPDATE npc_types SET mindmg = mindmg/3.5 where level > 30 AND level <= 40;
UPDATE npc_types SET mindmg = mindmg/4 where level > 40 AND level <= 50;
UPDATE npc_types SET mindmg = mindmg/4.5 where level > 50 AND level <= 60;
UPDATE npc_types SET mindmg = mindmg/5 where level > 60 AND level <= 70;
UPDATE npc_types SET mindmg = mindmg/5.5 where level > 70;
UPDATE npc_types SET maxdmg = maxdmg/2 where level <= 10;
UPDATE npc_types SET maxdmg = maxdmg/2.5 where level > 10 AND level <= 20;
UPDATE npc_types SET maxdmg = maxdmg/3 where level > 20 AND level <= 30;
UPDATE npc_types SET maxdmg = maxdmg/3.5 where level > 30 AND level <= 40;
UPDATE npc_types SET maxdmg = maxdmg/4 where level > 40 AND level <= 50;
UPDATE npc_types SET maxdmg = maxdmg/4.5 where level > 50 AND level <= 60;
UPDATE npc_types SET maxdmg = maxdmg/5 where level > 60 AND level <= 70;
UPDATE npc_types SET maxdmg = maxdmg/5.5 where level > 70;
UPDATE npc_types SET str = str/2 where level <= 10;
UPDATE npc_types SET str = str/2.5 where level > 10 AND level <= 20;
UPDATE npc_types SET str = str/3 where level > 20 AND level <= 30;
UPDATE npc_types SET str = str/3.5 where level > 30 AND level <= 40;
UPDATE npc_types SET str = str/4 where level > 40 AND level <= 50;
UPDATE npc_types SET str = str/4.5 where level > 50 AND level <= 60;
UPDATE npc_types SET str = str/5 where level > 60 AND level <= 70;
UPDATE npc_types SET str = str/5.5 where level > 70;
UPDATE npc_types SET sta = sta/2 where level <= 10;
UPDATE npc_types SET sta = sta/2.5 where level > 10 AND level <= 20;
UPDATE npc_types SET sta = sta/3 where level > 20 AND level <= 30;
UPDATE npc_types SET sta = sta/3.5 where level > 30 AND level <= 40;
UPDATE npc_types SET sta = sta/4 where level > 40 AND level <= 50;
UPDATE npc_types SET sta = sta/4.5 where level > 50 AND level <= 60;
UPDATE npc_types SET sta = sta/5 where level > 60 AND level <= 70;
UPDATE npc_types SET sta = sta/5.5 where level > 70;
UPDATE npc_types SET dex = dex/2 where level <= 10;
UPDATE npc_types SET dex = dex/2.5 where level > 10 AND level <= 20;
UPDATE npc_types SET dex = dex/3 where level > 20 AND level <= 30;
UPDATE npc_types SET dex = dex/3.5 where level > 30 AND level <= 40;
UPDATE npc_types SET dex = dex/4 where level > 40 AND level <= 50;
UPDATE npc_types SET dex = dex/4.5 where level > 50 AND level <= 60;
UPDATE npc_types SET dex = dex/5 where level > 60 AND level <= 70;
UPDATE npc_types SET dex = dex/5.5 where level > 70;
UPDATE npc_types SET agi = agi/2 where level <= 10;
UPDATE npc_types SET agi = agi/2.5 where level > 10 AND level <= 20;
UPDATE npc_types SET agi = agi/3 where level > 20 AND level <= 30;
UPDATE npc_types SET agi = agi/3.5 where level > 30 AND level <= 40;
UPDATE npc_types SET agi = agi/4 where level > 40 AND level <= 50;
UPDATE npc_types SET agi = agi/4.5 where level > 50 AND level <= 60;
UPDATE npc_types SET agi = agi/5 where level > 60 AND level <= 70;
UPDATE npc_types SET agi = agi/5.5 where level > 70;
UPDATE npc_types SET wis = wis/2 where level <= 10;
UPDATE npc_types SET wis = wis/2.5 where level > 10 AND level <= 20;
UPDATE npc_types SET wis = wis/3 where level > 20 AND level <= 30;
UPDATE npc_types SET wis = wis/3.5 where level > 30 AND level <= 40;
UPDATE npc_types SET wis = wis/4 where level > 40 AND level <= 50;
UPDATE npc_types SET wis = wis/4.5 where level > 50 AND level <= 60;
UPDATE npc_types SET wis = wis/5 where level > 60 AND level <= 70;
UPDATE npc_types SET wis = wis/5.5 where level > 70;
UPDATE npc_types SET _int = _int/2 where level <= 10;
UPDATE npc_types SET _int = _int/2.5 where level > 10 AND level <= 20;
UPDATE npc_types SET _int = _int/3 where level > 20 AND level <= 30;
UPDATE npc_types SET _int = _int/3.5 where level > 30 AND level <= 40;
UPDATE npc_types SET _int = _int/4 where level > 40 AND level <= 50;
UPDATE npc_types SET _int = _int/4.5 where level > 50 AND level <= 60;
UPDATE npc_types SET _int = _int/5 where level > 60 AND level <= 70;
UPDATE npc_types SET _int = _int/5.5 where level > 70;
UPDATE npc_types SET cha = cha/2 where level <= 10;
UPDATE npc_types SET cha = cha/2.5 where level > 10 AND level <= 20;
UPDATE npc_types SET cha = cha/3 where level > 20 AND level <= 30;
UPDATE npc_types SET cha = cha/3.5 where level > 30 AND level <= 40;
UPDATE npc_types SET cha = cha/4 where level > 40 AND level <= 50;
UPDATE npc_types SET cha = cha/4.5 where level > 50 AND level <= 60;
UPDATE npc_types SET cha = cha/5 where level > 60 AND level <= 70;
UPDATE npc_types SET cha = cha/5.5 where level > 70;
UPDATE npc_types SET mr = mr/2 where level <= 10;
UPDATE npc_types SET mr = mr/2.5 where level > 10 AND level <= 20;
UPDATE npc_types SET mr = mr/3 where level > 20 AND level <= 30;
UPDATE npc_types SET mr = mr/3.5 where level > 30 AND level <= 40;
UPDATE npc_types SET mr = mr/4 where level > 40 AND level <= 50;
UPDATE npc_types SET mr = mr/4.5 where level > 50 AND level <= 60;
UPDATE npc_types SET mr = mr/5 where level > 60 AND level <= 70;
UPDATE npc_types SET mr = mr/5.5 where level > 70;
UPDATE npc_types SET fr = fr/2 where level <= 10;
UPDATE npc_types SET fr = fr/2.5 where level > 10 AND level <= 20;
UPDATE npc_types SET fr = fr/3 where level > 20 AND level <= 30;
UPDATE npc_types SET fr = fr/3.5 where level > 30 AND level <= 40;
UPDATE npc_types SET fr = fr/4 where level > 40 AND level <= 50;
UPDATE npc_types SET fr = fr/4.5 where level > 50 AND level <= 60;
UPDATE npc_types SET fr = fr/5 where level > 60 AND level <= 70;
UPDATE npc_types SET fr = fr/5.5 where level > 70;
UPDATE npc_types SET cr = cr/2 where level <= 10;
UPDATE npc_types SET cr = cr/2.5 where level > 10 AND level <= 20;
UPDATE npc_types SET cr = cr/3 where level > 20 AND level <= 30;
UPDATE npc_types SET cr = cr/3.5 where level > 30 AND level <= 40;
UPDATE npc_types SET cr = cr/4 where level > 40 AND level <= 50;
UPDATE npc_types SET cr = cr/4.5 where level > 50 AND level <= 60;
UPDATE npc_types SET cr = cr/5 where level > 60 AND level <= 70;
UPDATE npc_types SET cr = cr/5.5 where level > 70;
UPDATE npc_types SET dr = dr/2 where level <= 10;
UPDATE npc_types SET dr = dr/2.5 where level > 10 AND level <= 20;
UPDATE npc_types SET dr = dr/3 where level > 20 AND level <= 30;
UPDATE npc_types SET dr = dr/3.5 where level > 30 AND level <= 40;
UPDATE npc_types SET dr = dr/4 where level > 40 AND level <= 50;
UPDATE npc_types SET dr = dr/4.5 where level > 50 AND level <= 60;
UPDATE npc_types SET dr = dr/5 where level > 60 AND level <= 70;
UPDATE npc_types SET dr = dr/5.5 where level > 70;
UPDATE npc_types SET pr = pr/2 where level <= 10;
UPDATE npc_types SET pr = pr/2.5 where level > 10 AND level <= 20;
UPDATE npc_types SET pr = pr/3 where level > 20 AND level <= 30;
UPDATE npc_types SET pr = pr/3.5 where level > 30 AND level <= 40;
UPDATE npc_types SET pr = pr/4 where level > 40 AND level <= 50;
UPDATE npc_types SET pr = pr/4.5 where level > 50 AND level <= 60;
UPDATE npc_types SET pr = pr/5 where level > 60 AND level <= 70;
UPDATE npc_types SET pr = pr/5.5 where level > 70;
UPDATE npc_types SET hp_regen_rate = hp_regen_rate/2 where level <= 10;
UPDATE npc_types SET hp_regen_rate = hp_regen_rate/2.5 where level > 10 AND level <= 20;
UPDATE npc_types SET hp_regen_rate = hp_regen_rate/3 where level > 20 AND level <= 30;
UPDATE npc_types SET hp_regen_rate = hp_regen_rate/3.5 where level > 30 AND level <= 40;
UPDATE npc_types SET hp_regen_rate = hp_regen_rate/4 where level > 40 AND level <= 50;
UPDATE npc_types SET hp_regen_rate = hp_regen_rate/4.5 where level > 50 AND level <= 60;
UPDATE npc_types SET hp_regen_rate = hp_regen_rate/5 where level > 60 AND level <= 70;
UPDATE npc_types SET hp_regen_rate = hp_regen_rate/5.5 where level > 70;
UPDATE npc_types SET mana_regen_rate = mana_regen_rate/2 where level <= 10;
UPDATE npc_types SET mana_regen_rate = mana_regen_rate/2.5 where level > 10 AND level <= 20;
UPDATE npc_types SET mana_regen_rate = mana_regen_rate/3 where level > 20 AND level <= 30;
UPDATE npc_types SET mana_regen_rate = mana_regen_rate/3.5 where level > 30 AND level <= 40;
UPDATE npc_types SET mana_regen_rate = mana_regen_rate/4 where level > 40 AND level <= 50;
UPDATE npc_types SET mana_regen_rate = mana_regen_rate/4.5 where level > 50 AND level <= 60;
UPDATE npc_types SET mana_regen_rate = mana_regen_rate/5 where level > 60 AND level <= 70;
UPDATE npc_types SET mana_regen_rate = mana_regen_rate/5.5 where level > 70;

UPDATE items SET races = 65535 WHERE itemtype <= 10;
UPDATE items SET classes = 65535 WHERE itemtype <= 10;
UPDATE items SET races = 65535 WHERE itemtype in (35, 45);
UPDATE items SET classes = 65535 WHERE itemtype in (35, 45);
UPDATE items SET slots = 24576 WHERE slots = 8192;
UPDATE items SET recskill = 0;
UPDATE items SET reclevel = 0;
UPDATE items SET reqlevel = 0;
UPDATE items SET loregroup = 0;
UPDATE items SET nodrop = 1;
UPDATE items SET norent = 1;
UPDATE items SET notransfer = 0;
UPDATE items SET clicklevel = 0;
UPDATE items SET clicklevel2 = 0;
UPDATE items SET wornlevel = 0;
UPDATE items SET wornlevel2 = 0;
UPDATE items SET proclevel = 0;
UPDATE items SET proclevel2 = 0;
UPDATE items SET focuslevel = 0;
UPDATE items SET focuslevel2 = 0;
UPDATE items SET haste = haste * 2;
UPDATE items SET hp = hp * 2;
UPDATE items SET regen = regen * 2;
UPDATE items SET manaregen = manaregen * 2;
UPDATE items SET `range` = `range` * 2;
UPDATE spawn2 SET respawntime = 3600 where respawntime > 3250;
UPDATE spawn2 SET variance = 1800 where respawntime > 3250;
UPDATE aa_actions SET reuse_time = 3600 WHERE reuse_time > 2160;
UPDATE altadv_vars SET spell_refresh = 3600 WHERE spell_refresh > 2160;
UPDATE aa_actions SET reuse_time = reuse_time/10 WHERE reuse_time < 3600;
UPDATE altadv_vars SET spell_refresh = spell_refresh/10 WHERE spell_refresh < 3600;
UPDATE aa_actions SET reuse_time = 60 WHERE aaid = 1375 AND rank = 0;
UPDATE altadv_vars SET spell_refresh = 60 WHERE skill_id = 1375;
UPDATE spells_new SET effect_base_value1 = -1000 WHERE id = 982;
UPDATE rule_values SET rule_value = 'false' WHERE ruleSET_id = 1 AND rule_name ='World:EnableTutorialButton';
UPDATE rule_values SET rule_value = 70 WHERE ruleSET_id = 1 AND rule_name = 'Character:MaxLevel';
UPDATE rule_values SET rule_value = 70 WHERE ruleSET_id = 10 AND rule_name = 'Character:MaxLevel';
UPDATE rule_values SET rule_value = 2.5 WHERE ruleSET_id = 1 AND rule_name = 'Character:ExpMultiplier';
UPDATE rule_values SET rule_value = 2.5 WHERE ruleSET_id = 1 AND rule_name = 'Character:AAExpMultiplier';
UPDATE rule_values SET rule_value = 1.5 WHERE ruleSET_id = 1 AND rule_name = 'Character:GroupExpMultiplier';
UPDATE rule_values SET rule_value = 1 WHERE ruleSET_id = 1 AND rule_name = 'Character:RaidExpMultiplier';
UPDATE rule_values SET rule_value = 500 WHERE ruleSET_id = 1 AND rule_name = 'Character:HPRegenMultiplier';
UPDATE rule_values SET rule_value = 500 WHERE ruleSET_id = 1 AND rule_name = 'Character:ManaRegenMultiplier';
UPDATE rule_values SET rule_value = 500 WHERE ruleSET_id = 1 AND rule_name = 'Character:EnduranceRegenMultiplier';
UPDATE rule_values SET rule_value = 'false' WHERE ruleSET_id = 1 AND rule_name = 'World:UseBannedIPsTable';
UPDATE rule_values SET rule_value = 'true' WHERE ruleSET_id = 1 AND rule_name = 'Character:HealOnLevel';
UPDATE rule_values SET rule_value = .50 WHERE ruleSET_id = 1 AND rule_name = 'Merchant:SellCostMod';
UPDATE rule_values SET rule_value = 1 WHERE ruleSET_id = 1 AND rule_name = 'Merchant:BuyCostMod';
UPDATE rule_values SET rule_value = .01 WHERE ruleSET_id = 1 AND rule_name = 'Combat:AgiHitFactor';
UPDATE rule_values SET rule_value = 138 WHERE ruleSET_id = 1 AND rule_name = 'Combat:BaseHitChance';
UPDATE rule_values SET rule_value = 0 WHERE ruleSET_id = 1 AND rule_name = 'Combat:NPCBonusHitChance';
UPDATE rule_values SET rule_value = 1 WHERE ruleSET_id = 1 AND rule_name = 'Character:MaxFearDurationForPlayerCharacter';
UPDATE rule_values SET rule_value = 200 WHERE ruleSET_id = 1 AND rule_name = 'Character:ItemManaRegenCap';
UPDATE rule_values SET rule_value = 200 WHERE ruleSET_id = 1 AND rule_name = 'Character:ItemHealthRegenCap';
UPDATE rule_values SET rule_value = 400 WHERE ruleSET_id = 1 AND rule_name = 'Character:SkillUpModifier';
UPDATE rule_values SET rule_value = 60 WHERE ruleSET_id = 1 AND rule_name = 'World:MinOfflineTimeToReturnHome';
UPDATE rule_values SET rule_value = 'true' WHERE ruleSET_id = 1 AND rule_name = 'Character:BindAnywhere';
UPDATE rule_values SET rule_value = 200 WHERE ruleSET_id = 1 AND rule_name = 'Character:ItemDamageShieldCap';
UPDATE rule_values SET rule_value = 300 WHERE ruleSET_id = 1 AND rule_name = 'Character:ItemAccuracyCap';
UPDATE rule_values SET rule_value = 200 WHERE ruleSET_id = 1 AND rule_name = 'Character:ItemAvoidanceCap';
UPDATE rule_values SET rule_value = 200 WHERE ruleSET_id = 1 AND rule_name = 'Character:ItemCombatEffectsCap';
UPDATE rule_values SET rule_value = 100 WHERE ruleSET_id = 1 AND rule_name = 'Character:ItemShieldingCap';
UPDATE rule_values SET rule_value = 100 WHERE ruleSET_id = 1 AND rule_name = 'Character:ItemSpellShieldingCap';
UPDATE rule_values SET rule_value = 100 WHERE ruleSET_id = 1 AND rule_name = 'Character:ItemDoTShieldingCap';
UPDATE rule_values SET rule_value = 100 WHERE ruleSET_id = 1 AND rule_name = 'Character:ItemStunResistCap';
UPDATE rule_values SET rule_value = 100 WHERE ruleSET_id = 1 AND rule_name = 'Character:ItemStrikethroughCap';
UPDATE rule_values SET rule_value = 20 WHERE ruleSET_id = 1 AND rule_name = 'Character:RestRegenPercent';
UPDATE rule_values SET rule_value = 1 WHERE ruleSET_id = 1 AND rule_name = 'Adventure:MinNumberForGroup';
UPDATE rule_values SET rule_value = 100 WHERE ruleSET_id = 1 AND rule_name = 'Combat:MaxRampageTargets';
UPDATE variables SET value = 'Have you paid your dues? Yes sir, the check is in the mail.' WHERE varname = 'MOTD';
Here was an alternate HP tweak I was working on at some point:

Code:
UPDATE npc_types SET hp = hp/3 where hp > level * 20;
UPDATE npc_types SET hp = hp/(level/4) where hp < 50 * level;
UPDATE npc_types SET hp = hp/(level/3) where hp => 50 * level and < 100 * level;
UPDATE npc_types SET hp = hp/(level/2) where hp => 100 * level and < 200 * level;
UPDATE npc_types SET hp = hp/(level) where hp => 200 * level and < 300 * level;
UPDATE npc_types SET hp = hp/(level*2) where hp => 300 * level and < 400 * level;
UPDATE npc_types SET hp = hp/(level*3) where hp => 400 * level and < 500 * level;
I don't recompile code and have never tried Akkadius's zone scaling script. I try to do as much as possible in SQL and am always open to new ideas. Although I have had some success fooling around with these settings with friends on my LAN, they have never been part of a living, breathing server with it's own community behind it.

Let me know what you guys think. Thanks.
Reply With Quote
 

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 07:43 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 - 2018, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3