Changing str and agl and dex of mobs in DB

[HurtinuDaily]

if anyone really cares this is what I used to alter the statistics for my mobs, this is just basic it changes the strength of the mobs depending on level, not sure how it effects lower level mobs as far as tuning them to the right strength for the lvl. can easily be changed to adjust agl and dex too.

UPDATE npc_types SET str=20 WHERE Level >= 1 and level <= 10;
UPDATE npc_types SET str=50 WHERE Level >= 11 and level <= 20;
UPDATE npc_types SET str=100 WHERE Level >= 21 and level <= 30;
UPDATE npc_types SET str=160 WHERE Level >= 31 and level <= 40;
UPDATE npc_types SET str=180 WHERE Level >= 41 and level <= 50;
UPDATE npc_types SET str=200 WHERE Level >= 51 and level <= 60;
UPDATE npc_types SET str=230 WHERE Level >= 61 and level <= 65;
UPDATE npc_types SET str=252 WHERE Level >= 66

I tried to do this to make dragons hard, as they usually are... but it didnt seem to work, 0 rows effected and this bodytype according to the guidebook is kunark dragons UPDATE npc_types SET str=252 WHERE bodytype = 184

of course if ya just wanna have str based on level which I did, I used this formula:

update npc_types set str=level*3.6; --at level 70 str would be 252
update npc_types set agi=level*3.6; -- only problem is npc str is not
update npc_types set dex=level*3.6;-- linear, but it works...
--and of course check and make sure no str is over 252 for 71+ mobs
update npc_types set str=252 where str > 252;
update npc_types set agi=252 where agi > 252;
update npc_types set dex=252 where dex > 252;


anyway.... is 184 the wrong bodytype for dragons????

edit #1: lol woops its agi not agl....

[HurtinuDaily]

lol, answered my own question again

UPDATE npc_types SET str=252 WHERE race = 184

guess its race not bodytype ))))

[fathernitwit]

Have you tested these stats adjustments for playability? I have been looking for formulas to apply to all the stats, as well as resist, regen, etc... (all the crap we cant collect) for PEQ..


BTW, some body types:
BT_Dragon = 26,
BT_Summoned2 = 27,
BT_Summoned3 = 28,
// 29
BT_VeliousDragon = 30, //might not be a tight set
// ...
BT_Dragon3 = 32,

[HurtinuDaily]

I tested some higher end mobs last night and they are much better, not missing as much, I am going to test it more this weekend by starting a lvl one toon and etting the exp modifier really high and testing it on my way to lvl 60. Like I said in the first post the stats of mobs are not linear on the way to lvl 60, but this is way better then it was before with all mobs having 75 to all stats. at level one the mobs are actually killable, before I couldnt even kill one mob with a brand new toon. It would be much easier to test if I could actually see mob misses.... not sure if its just a bug with my server or all servers but I cannot see when the mob mises me it just says nothing at all.

As far as resists I am just manually adjusting them in my db by bodytype and level, if dont want a mob snareable do I just set mr really high or is there soemthing else? I cannot find anything saying what the npc special attacks are.

Also what factor does the does stamina variable play?

I am also working on adding cavedudes db to peq's on my server, but lots of factions to adjust and loot tables/loots to add... only done one zone so far, vex thal!!!! and its pretty fun to play in with my monk ))

[HurtinuDaily]

a non linear equasion that I ill also test, or someone else can if they want...

str = 15 + (level*1.5) + (level*level)/25

lvl 01 = 17
lvl 10 = 34
lvl 20 = 61
lvl 30 = 96
lvl 40 = 139
lvl 50 = 190
lvl 60 = 249
lvl 61+ = 252

code:
update npc_types set str=15+level*1.5+((level*level)/25);
update npc_types set agi=15+level*1.5+((level*level)/25);
update npc_types set dex=15+level*1.5+((level*level)/25);

update npc_types set str=252 where str > 252;
update npc_types set agi=252 where agi > 252;
update npc_types set dex=252 where dex > 252;

[HurtinuDaily]

The first one worked good, but the raid mobs are still missing toomuch