My Solo Server Settings

Havoc550 · #1 02-15-2018, 09:38 PM

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.