Looking to scale damage with stats

[Azrealvect]

I know this has been done before, but I cannot find the post's for it. I am looking to scale melee and spell damage with Str and Int respectively. Also I know there was one where bard songs were scaled off dex. Anyone know how to do this or have the coding for it? Any help would be most appreciated.

[dagulus2]

This thread http://www.eqemulator.org/forums/showthread.php?t=27567 has some ideas on the Int part of that.

[Nibiuno]

Here is an example of how I did my initial setup of Imperium server. You can easily adjust the SQL query for spell damage to hit on STR using this as an example. Just make sure you adjust the stats in the order you want, otherwise things wont be as predictable. You should adjust base stats before adjusting any stats that are then adjusted from those.

UPDATE items SET aagi = aagi * 3;
UPDATE items SET acha = acha * 3;
UPDATE items SET ac = ac * 3;
UPDATE items SET adex = adex * 3;
UPDATE items SET aint = aint * 3;
UPDATE items SET asta = asta * 3;
UPDATE items SET astr = astr * 3;
UPDATE items SET awis = awis * 3;
UPDATE items SET hp = hp * 4;
UPDATE items SET mana = mana * 4;
UPDATE items SET cr = cr * 2;
UPDATE items SET dr = dr * 2;
UPDATE items SET fr = fr * 2;
UPDATE items SET mr = mr * 2;
UPDATE items SET pr = pr * 2;
UPDATE items SET svcorruption = svcorruption * 2;
UPDATE items SET banedmgamt = banedmgamt * 5;
UPDATE items SET banedmgraceamt = banedmgraceamt * 5;
UPDATE items SET casttime = casttime * .33;
UPDATE items SET casttime_ = casttime_ * .33;
UPDATE items SET damage = damage * 1.3;
UPDATE items SET delay = delay * .8;
UPDATE items SET spelldmg = spelldmg + (aint * 6) WHERE aint > awis AND aint > 0;
UPDATE items SET spelldmg = spelldmg + (awis * 6) WHERE awis > aint AND awis > 0;
UPDATE items SET spelldmg = spelldmg + (aint * 6) WHERE aint = awis AND (aint > 0 OR awis > 0);
UPDATE items SET healamt = healamt + (awis * 6);
UPDATE items SET regen = regen + (asta * .05) WHERE asta > 20 AND asta < 50;
UPDATE items SET regen = regen + (asta * .10) WHERE asta >= 50;
UPDATE items SET manaregen = manaregen + (aint * .05) WHERE aint > awis AND aint > 20 AND aint < 50;
UPDATE items SET manaregen = manaregen + (aint * .10) WHERE aint > awis AND aint >= 50;
UPDATE items SET manaregen = manaregen + (awis * .05) WHERE awis > aint AND awis > 20 AND awis < 50;
UPDATE items SET manaregen = manaregen + (awis * .10) WHERE awis > aint AND awis >= 50;
UPDATE items SET manaregen = manaregen + (awis * .05) WHERE awis = aint AND (awis > 20 AND awis < 50 OR aint > 20 AND aint < 50);
UPDATE items SET manaregen = manaregen + (awis * .10) WHERE awis = aint AND (awis >= 50 OR aint >= 50);
UPDATE items SET enduranceregen = enduranceregen * 2;
UPDATE items SET elemdmgamt = elemdmgamt * 5;
UPDATE items SET skillmodvalue = skillmodvalue * 2;
UPDATE items SET reclevel = reqlevel;
UPDATE items SET reqlevel = 0;
UPDATE items SET focuslevel = 0;
UPDATE items SET wornlevel = 0;
UPDATE items SET proclevel = 0;
UPDATE items SET nodrop = 1;
UPDATE items SET loregroup = 0;
UPDATE items SET recastdelay = recastdelay * .33;
UPDATE items SET heroic_str = heroic_str + (astr * .15) WHERE astr >= 50;
UPDATE items SET heroic_int = heroic_int + (aint * .15) WHERE aint >= 50;
UPDATE items SET heroic_wis = heroic_wis + (awis * .15) WHERE awis >= 50;
UPDATE items SET heroic_agi = heroic_agi + (aagi * .15) WHERE aagi >= 50;
UPDATE items SET heroic_dex = heroic_dex + (adex * .15) WHERE adex >= 50;
UPDATE items SET heroic_sta = heroic_sta + (asta * .15) WHERE asta >= 50;
UPDATE items SET heroic_cha = heroic_cha + (acha * .15) WHERE acha >= 50;
UPDATE items SET heroic_pr = heroic_pr + (pr * .15) WHERE pr >= 50;
UPDATE items SET heroic_dr = heroic_dr + (dr * .15) WHERE dr >= 50;
UPDATE items SET heroic_fr = heroic_fr + (fr * .15) WHERE fr >= 50;
UPDATE items SET heroic_cr = heroic_cr + (cr * .15) WHERE cr >= 50;
UPDATE items SET heroic_mr = heroic_mr + (mr * .15) WHERE mr >= 50;
UPDATE items SET heroic_svcorrup = heroic_svcorrup + (svcorruption * .15) WHERE svcorruption >= 25;
UPDATE items SET avoidance = avoidance + (aagi * .05) WHERE aagi >= 50;
UPDATE items SET attack = attack + (astr * .05) WHERE astr >= 50;
UPDATE items SET damageshield = damageshield + (asta * .05) WHERE asta >= 50;
UPDATE items SET dotshielding = dotshielding + (awis * .05) WHERE awis >= 50;
UPDATE items SET shielding = shielding + (asta * .05) WHERE asta >= 50;
UPDATE items SET spellshield = spellshield + (aint * .05) WHERE aint >= 50;
UPDATE items SET strikethrough = strikethrough + (adex * .05) WHERE adex >= 50;
UPDATE items SET stunresist = stunresist + (asta * .05) WHERE asta >= 50;
UPDATE items SET clairvoyance = clairvoyance + (acha * .05) WHERE acha >= 50;
UPDATE items SET accuracy = accuracy + (adex * .05) WHERE adex >= 50;
UPDATE items SET dsmitigation = dsmitigation + (astr * .05) WHERE astr >= 50;
UPDATE items SET aagi = 127 WHERE aagi > 127;
UPDATE items SET acha = 127 WHERE acha > 127;
UPDATE items SET adex = 127 WHERE adex > 127;
UPDATE items SET aint = 127 WHERE aint > 127;
UPDATE items SET asta = 127 WHERE asta > 127;
UPDATE items SET astr = 127 WHERE astr > 127;
UPDATE items SET awis = 127 WHERE awis > 127;
UPDATE items SET clicktype = 1 WHERE clicktype = 4;
UPDATE items SET cr = 127 WHERE cr > 127;
UPDATE items SET dr = 127 WHERE dr > 127;
UPDATE items SET fr = 127 WHERE fr > 127;
UPDATE items SET mr = 127 WHERE mr > 127;
UPDATE items SET pr = 127 WHERE pr > 127;
UPDATE items SET svcorruption = 127 WHERE svcorruption > 127;
UPDATE items SET races = 65535 WHERE races >= 1;

[Azrealvect]

that looks amazing and almost exactly what I was looking for. already had the stats *3 just like this. thank you. I see that this will scale spell dmg to the stat but does this also scale melee dmg to the str stat without modifying the items original damage stat?

[Kingly_Krab]

Keep in mind though, heroic_agi will make your avoidance rather crazy, so avoid making it too high.

[chrsschb]

Originally Posted by Azrealvect

I know this has been done before, but I cannot find the post's for it. I am looking to scale melee and spell damage with Str and Int respectively. Also I know there was one where bard songs were scaled off dex. Anyone know how to do this or have the coding for it? Any help would be most appreciated.

Good luck man. I tried a while back with no luck. Certain code is heavily protected in this community.

Originally Posted by Azrealvect

that looks amazing and almost exactly what I was looking for. already had the stats *3 just like this. thank you. I see that this will scale spell dmg to the stat but does this also scale melee dmg to the str stat without modifying the items original damage stat?

If what you're looking for is dynamic, on the fly increases in damage based on a stat then KC's sql is not what you're looking for. It's a one time, run it and it's done. Think of it as a baseline for his server. The on the fly, dynamic increase from say equipping an item with 10 int gives you 10% more spell damage, is a compiled source edit.