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.
Quote:
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;
|