View Single Post
  #8  
Old 08-14-2018, 10:06 PM
John C
Sarnak
 
Join Date: Jul 2018
Location: Atlanta, GA
Posts: 49
Default

Quote:
Originally Posted by djeryv View Post
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.
Reply With Quote