EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   General::Server Discussion (https://www.eqemulator.org/forums/forumdisplay.php?f=601)
-   -   My Solo Server Settings (https://www.eqemulator.org/forums/showthread.php?t=41768)

Havoc550 02-15-2018 09:38 PM

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.

Havoc550 02-15-2018 11:42 PM

I am already finding some differences in the way the newer database works compared to the changes I have made. Bard spells are requiring level 255 to scribe for some reason and then sort of break the GUI: no targeting, opening inventory, etc. In other words, be careful with these alterations.

Ignore that, it's only a specific spell/song that is screwed up. I just fixed it:

UPDATE spells_new SET classes8 = 3 WHERE id = 722;

Apparently it's no longer in LIVE and was disabled in PEQ by making the required Bard level 255.

Mistmaker 03-09-2018 10:22 AM

Thanks for posting this. I will give this a try on a new server I'm testing. :)

Have you noticed any other problems? Just checking before I give a try.

Gnowm 03-24-2018 09:19 PM

Long time lurker..
 
Hey, this looks nice.
Im reading through it, keeping bits i want dropping bits i don't.

I wonder why you allow equip all items all classes? Battle Wizard I suppose.

Thankyou for sharing/inspiring.

GnowmDePlume (not my real name)

Mistmaker 03-25-2018 03:34 AM

Keep in mind these changes will also get all pets. :) I tweaked mine afterward to be better than live and tougher.

All/All is really nice. One slight change i made is also to add those left handed slot item to be able to be used in primary slots too. Its actually fun to play thinking that whatever drops may be an upgrade.

I agree though. Thanks for sharing this its inspirational in the changes I made on Midgard.

John C 07-23-2018 01:46 AM

Quote:

Originally Posted by Mistmaker (Post 257891)
Keep in mind these changes will also get all pets. :) I tweaked mine afterward to be better than live and tougher.

All/All is really nice. One slight change i made is also to add those left handed slot item to be able to be used in primary slots too. Its actually fun to play thinking that whatever drops may be an upgrade.

I agree though. Thanks for sharing this its inspirational in the changes I made on Midgard.

Right you are Mistmaker. I modified Havoc's scripts and added "AND ID > 999" to all the monster nerfing where clauses. That will save the pets from any downgrades. Good catch.


And thanks Havoc. This was incredibly useful. I still don't understand the rules that are references at the bottom or even what you are trying to accomplish with all of the timers, but I was able to directly leverage the top half and hopefully the rest will make more sense as I continue to play with this stuff.

djeryv 08-14-2018 07:50 PM

I tried these settings, and I found that I could be a level 1 character and I could kill the lizardmen with 1 hit.

I noticed that monsters can be soloed up to level 20, where the difficulty then starts to get hit and miss whether you can fight it alone. Maybe you want to focus your queries on level 20+?

John C 08-14-2018 10:06 PM

Quote:

Originally Posted by djeryv (Post 259706)
I tried these settings, and I found that I could be a level 1 character and I could kill the lizardmen with 1 hit.

I noticed that monsters can be soloed up to level 20, where the difficulty then starts to get hit and miss whether you can fight it alone. Maybe you want to focus your queries on level 20+?


Agree. I started with his script, but then modified it. It was way too easy. I'm still tweaking as this is still a little too easy, but here's what I currently use:


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

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 recskill = 0;
UPDATE items SET reclevel = 0;
UPDATE items SET reqlevel = 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 rule_values SET rule_value = 175 WHERE ruleSET_id = 1 AND rule_name = 'Character:HPRegenMultiplier';
UPDATE rule_values SET rule_value = 275 WHERE ruleSET_id = 1 AND rule_name = 'Character:ManaRegenMultiplier';
UPDATE rule_values SET rule_value = 175 WHERE ruleSET_id = 1 AND rule_name = 'Character:EnduranceRegenMultiplier';

UPDATE faction_list_mod SET `mod` = 0 where mod_name like 'd%';
UPDATE faction_list_mod SET `mod` = 0 where mod_name like 'c%';
UPDATE faction_list_mod SET `mod` = `mod` * 0.697 where mod_name like 'r%' AND `mod` < 0;


That last section is definitely a cheat. I don't much care for faction grind, so I eliminated faction impact of class and diety and reduced racial faction so that even in the worst case scenario, you are just shy of KOS. My Ogre can go to Freeport and my High Elf can visit his dark brethren. Just remove those last three lines if that's not your cup of tea. And I edited the monster nerfs to not include ID's < 999 as those seem to be the pets. So NPCs are nerfed, but pets are not.

Havoc550 08-17-2018 12:15 PM

Quote:

Originally Posted by Mistmaker (Post 257803)
Thanks for posting this. I will give this a try on a new server I'm testing. :)

Have you noticed any other problems? Just checking before I give a try.

There are still things that need to be tweaked, so always make a backup first. I see others have uncovered some issues below, glad to see the group effort here.

Quote:

Originally Posted by Gnowm (Post 257882)
Hey, this looks nice.
Im reading through it, keeping bits i want dropping bits i don't.

I wonder why you allow equip all items all classes? Battle Wizard I suppose.

Thankyou for sharing/inspiring.

GnowmDePlume (not my real name)

I feel every item should be equipable by everyone whether they can make real use of it or not. This also makes a solo-able server more solo-able in my opinion.

Quote:

Originally Posted by John C (Post 259476)
Right you are Mistmaker. I modified Havoc's scripts and added "AND ID > 999" to all the monster nerfing where clauses. That will save the pets from any downgrades. Good catch.


And thanks Havoc. This was incredibly useful. I still don't understand the rules that are references at the bottom or even what you are trying to accomplish with all of the timers, but I was able to directly leverage the top half and hopefully the rest will make more sense as I continue to play with this stuff.

The timers were adjusted so certain skills could be used much more often. A lot of these tweaks were made years ago and I am not sure how many apply at this point.

jakaleca 08-17-2018 10:15 PM

Some very good work. Thank you for sharing. Wondering how well this might scale if extended to level 80, or even 100.

Cheers

GlassDeviant 10-04-2018 03:22 AM

Exactly what I needed, even though it wasn't what I wanted/was looking for.

I was only looking for confirmation of whether you could run your own server at all. :)


All times are GMT -4. The time now is 03:26 PM.

Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.