NPC ATTACK TABLE
Here is a quick table I built anyone have any closer values to use ?
update npc_types set maxdmg=9 where level=1; update npc_types set maxdmg=21 where level=2; update npc_types set maxdmg=39 where level=3; update npc_types set maxdmg=44 where level=4; update npc_types set maxdmg=55 where level=5; update npc_types set maxdmg=64 where level=6; update npc_types set maxdmg=79 where level=7; update npc_types set maxdmg=84 where level=8; update npc_types set maxdmg=99 where level=9; update npc_types set maxdmg=105 where level=10; update npc_types set maxdmg=119 where level=11; update npc_types set maxdmg=121 where level=12; update npc_types set maxdmg=131 where level=13; update npc_types set maxdmg=144 where level=14; update npc_types set maxdmg=159 where level=15; update npc_types set maxdmg=165 where level=16; update npc_types set maxdmg=170 where level=17; update npc_types set maxdmg=175 where level=18; update npc_types set maxdmg=180 where level=19; update npc_types set maxdmg=185 where level=20; update npc_types set maxdmg=190 where level=21; update npc_types set maxdmg=195 where level=22; update npc_types set maxdmg=200 where level=23; update npc_types set maxdmg=205 where level=24; update npc_types set maxdmg=210 where level=25; update npc_types set maxdmg=215 where level=26; update npc_types set maxdmg=220 where level=27; update npc_types set maxdmg=225 where level=28; update npc_types set maxdmg=230 where level=29; update npc_types set maxdmg=235 where level=30; update npc_types set maxdmg=240 where level=31; update npc_types set maxdmg=245 where level=32; update npc_types set maxdmg=250 where level=33; update npc_types set maxdmg=255 where level=34; update npc_types set maxdmg=260 where level=35; update npc_types set maxdmg=265 where level=36; update npc_types set maxdmg=270 where level=37; update npc_types set maxdmg=275 where level=38; update npc_types set maxdmg=280 where level=39; update npc_types set maxdmg=285 where level=40; update npc_types set maxdmg=290 where level=41; update npc_types set maxdmg=295 where level=42; update npc_types set maxdmg=300 where level=43; update npc_types set maxdmg=305 where level=44; update npc_types set maxdmg=310 where level=45; update npc_types set maxdmg=315 where level=46; update npc_types set maxdmg=320 where level=47; update npc_types set maxdmg=325 where level=48; update npc_types set maxdmg=330 where level=49; update npc_types set maxdmg=344 where level=50; update npc_types set maxdmg=359 where level=51; update npc_types set maxdmg=360 where level=52; update npc_types set maxdmg=370 where level=53; update npc_types set maxdmg=380 where level=54; update npc_types set maxdmg=390 where level=55; update npc_types set maxdmg=400 where level=156; update npc_types set maxdmg=450 where level=257; update npc_types set maxdmg=500 where level=358; update npc_types set maxdmg=550 where level=459; update npc_types set maxdmg=600 where level=560; comments or sugesstions welcome. |
Ouch, those values are going to be hitting pretty hard in the mid-levels. I'm seeing values that run to ~150 for 55-57 for normal mobs. Of course, some things will be out of line there, but that seems about right for normal, no-flurry, etc. mobs.
--Veto |
...I was thinking more along these lines:
update npc_types set maxdmg=3 where level=1; update npc_types set maxdmg=6 where level=2; update npc_types set maxdmg=9 where level=3; update npc_types set maxdmg=12 where level=4; update npc_types set maxdmg=13 where level=5; update npc_types set maxdmg=13 where level=6; update npc_types set maxdmg=14 where level=7; update npc_types set maxdmg=14 where level=8; update npc_types set maxdmg=14 where level=9; update npc_types set maxdmg=25 where level=10; update npc_types set maxdmg=25 where level=11; update npc_types set maxdmg=26 where level=12; update npc_types set maxdmg=26 where level=13; update npc_types set maxdmg=27 where level=14; update npc_types set maxdmg=37 where level=15; update npc_types set maxdmg=38 where level=16; update npc_types set maxdmg=38 where level=17; update npc_types set maxdmg=38 where level=18; update npc_types set maxdmg=39 where level=19; update npc_types set maxdmg=49 where level=20; update npc_types set maxdmg=50 where level=21; update npc_types set maxdmg=50 where level=22; update npc_types set maxdmg=51 where level=23; update npc_types set maxdmg=51 where level=24; update npc_types set maxdmg=62 where level=25; update npc_types set maxdmg=62 where level=26; update npc_types set maxdmg=62 where level=27; update npc_types set maxdmg=63 where level=28; update npc_types set maxdmg=63 where level=29; update npc_types set maxdmg=74 where level=30; update npc_types set maxdmg=74 where level=31; update npc_types set maxdmg=75 where level=32; update npc_types set maxdmg=75 where level=33; update npc_types set maxdmg=76 where level=34; update npc_types set maxdmg=86 where level=35; update npc_types set maxdmg=86 where level=36; update npc_types set maxdmg=87 where level=37; update npc_types set maxdmg=87 where level=38; update npc_types set maxdmg=88 where level=39; update npc_types set maxdmg=98 where level=40; update npc_types set maxdmg=99 where level=41; update npc_types set maxdmg=99 where level=42; update npc_types set maxdmg=100 where level=43; update npc_types set maxdmg=100 where level=44; update npc_types set maxdmg=110 where level=45; update npc_types set maxdmg=111 where level=46; update npc_types set maxdmg=111 where level=47; update npc_types set maxdmg=112 where level=48; update npc_types set maxdmg=112 where level=49; update npc_types set maxdmg=123 where level=50; update npc_types set maxdmg=123 where level=51; update npc_types set maxdmg=124 where level=52; update npc_types set maxdmg=124 where level=53; update npc_types set maxdmg=124 where level=54; update npc_types set maxdmg=135 where level=55; |
ouch if those values were true in EQLive id never make level 53! i like maethwyn's a bit better but ive seen level 50+ mobs hit a bit higher.
|
Yeah, I don't think there is a magic formula for fitting all instances... but so far (played my new ranjah) up to lvl 20 in qeynos2, crushbone, kurns, and paludal... and with the values I gave, they seem to be hitting right about where eqlive was... a little softer at the beginning levels... but I always hated dying 20 times until my 1HS went up enough to land a hit :)
I think on mobs 47+ (i.e. - no longer Dire charmable), the formula should increase a bit more... I'll know for sure when I test those levels out! |
I wouldnt run this sql fix.
I think you have to take care of the mob classes. And this will overwrite settings made for certain spawns (nameds for example). you could perhaps save the particularities of your npc before updating their maxdmg, and restore em after, or only update the npcs which have a name starting by 'a ' or 'an '... update ... where (name like 'a %') or (name like 'an %'); L8rs |
Quote:
right now theres all these spawns hitting for 400 and i needed a quick fix. if someone could make a SQL for your way it would help a lot but I for one do not have the time required for such a task. |
...or maybe just update if level < 47 AND maxdmg=400, that way the ones in question/bad vals are the only ones changed regardless of Named/normal status.
UPDATE npc_types SET maxdmg='yourcalcedvalueforthislevel' WHERE (level<47 AND maxdmg=400); Though the level check is redundant above as the maxdmg value entered would be based on level. I am redoing my MOB HP/maxdmg tables and will post up with what I have... I am splitting the tables into 6 categories for class consideration purposes: 01 - WAR 02 - PAL, SHD 03 - RNG, BRD 04 - BST, MNK, ROG 05 - CLR, DRU, SHM 06 - ENC, NEC, MAG, WIZ HPs go down as group ID goes up; maxdmg is a bit of my own thoughts... MNK group highest DPS, then WAR, PAL/SHD, BRD... et cetera - though WAR has highest HP, then PAL/SHD, et cetera... I always hated being hit as hard by a WIZ MOB as his more-hp WAR friend. Here are my proposed HP catch-alls: Code:
LVL CID01 CID02 CID03 CID04 CID05 CID06 UPDATE npc_types SET hp = ( level * ( (TRUNCATE( level / 10, 0 )+1) * 3.30 * 2 + 35 ) ) WHERE class IN ( 1 ) AND ( level < 50 ); UPDATE npc_types SET hp = ( level * ( (TRUNCATE( level / 10, 0 )+1) * 3.00 * 2 + 35 ) ) WHERE class IN ( 3, 5 ) AND ( level < 50 ); UPDATE npc_types SET hp = ( level * ( (TRUNCATE( level / 10, 0 )+1) * 2.75 * 2 + 35 ) ) WHERE class IN ( 4, 8 ) AND ( level < 50 ); UPDATE npc_types SET hp = ( level * ( (TRUNCATE( level / 10, 0 )+1) * 2.25 * 2 + 35 ) ) WHERE class IN ( 7, 9, 15 ) AND ( level < 50 ); UPDATE npc_types SET hp = ( level * ( (TRUNCATE( level / 10, 0 )+1) * 1.50 * 2 + 35 ) ) WHERE class IN ( 2, 6, 10 ) AND ( level < 50 ); UPDATE npc_types SET hp = ( level * ( (TRUNCATE( level / 10, 0 )+1) * 1.00 * 2 + 35 ) ) WHERE class IN ( 11, 12, 13, 14 ) AND ( level < 50 ); |
And here is the maxdmg table I came up with (same heading as HP model above (i.e. - level cid01 cid02...):
Code:
5 5 5 5 4 3 UPDATE npc_types SET maxdmg = ( 3.90 * (( level * (TRUNCATE(level / 10, 0)+1)) + 8 ) / 7 ) WHERE class IN ( 1 ) AND ( level < 50 ); UPDATE npc_types SET maxdmg = ( 3.70 * (( level * (TRUNCATE(level / 10, 0)+1)) + 8 ) / 7 ) WHERE class IN ( 3, 5 ) AND ( level < 50 ); UPDATE npc_types SET maxdmg = ( 3.50 * (( level * (TRUNCATE(level / 10, 0)+1)) + 8 ) / 7 ) WHERE class IN ( 4, 8 ) AND ( level < 50 ); UPDATE npc_types SET maxdmg = ( 4.10 * (( level * (TRUNCATE(level / 10, 0)+1)) + 8 ) / 7 ) WHERE class IN ( 7, 9, 15 ) AND ( level < 50 ); UPDATE npc_types SET maxdmg = ( 2.90 * (( level * (TRUNCATE(level / 10, 0)+1)) + 8 ) / 7 ) WHERE class IN ( 2, 6, 10 ) AND ( level < 50 ); UPDATE npc_types SET maxdmg = ( 2.60 * (( level * (TRUNCATE(level / 10, 0)+1)) + 8 ) / 7 ) WHERE class IN ( 11, 12, 13, 14 ) AND ( level < 50 ); |
I highly recomend finding formulas like these to globably set a lot of the default values. Then also making another sql script that goes back and sets things like named spawns or other exceptions to the rules.
Something similar to Code:
UPDATE npc_types SET maxdmg = 500 where (name like '%sleeper%' and zone like 'sleepers'); Code:
UPDATE npc_types SET loottable_id = 30 where (name like '%skeleton%' and level < 20); It will add a tremendous consistancy to the DB, and still keep the customized stuff. |
All times are GMT -4. The time now is 06:04 PM. |
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.