Changing str and agl and dex of mobs in DB
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....
|