...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
1 50 50 50 40 40 40
2 90 90 90 80 80 80
3 130 130 130 120 120 120
4 170 170 170 160 160 150
5 210 210 210 200 190 190
6 250 250 250 240 230 230
7 300 290 290 280 270 260
8 340 330 330 320 310 300
9 380 370 370 360 350 340
10 490 470 460 440 410 390
11 540 520 510 490 460 430
12 580 570 560 530 500 470
13 630 620 600 580 540 510
14 680 660 650 620 580 550
15 730 710 690 660 620 590
16 780 760 740 710 660 630
17 820 800 790 750 700 670
18 870 850 830 800 740 710
19 920 900 880 840 780 750
20 1100 1060 1030 970 880 820
21 1160 1120 1090 1020 930 870
22 1210 1170 1140 1070 970 910
23 1270 1220 1190 1120 1020 950
24 1320 1280 1240 1170 1060 990
25 1370 1330 1290 1220 1100 1030
26 1430 1380 1340 1270 1150 1070
27 1480 1440 1400 1310 1190 1110
28 1540 1490 1450 1360 1240 1150
29 1590 1540 1500 1410 1280 1190
30 1850 1770 1710 1590 1410 1290
31 1910 1830 1770 1650 1460 1340
32 1970 1890 1830 1700 1510 1380
33 2030 1950 1890 1750 1560 1420
34 2090 2010 1940 1810 1600 1470
35 2150 2070 2000 1860 1650 1510
36 2220 2130 2060 1910 1700 1550
37 2280 2190 2110 1970 1740 1600
38 2340 2250 2170 2020 1790 1640
39 2400 2310 2230 2070 1840 1680
40 2720 2600 2500 2300 2000 1800
41 2790 2670 2570 2360 2050 1850
42 2860 2730 2630 2420 2100 1890
43 2930 2800 2690 2480 2150 1940
44 3000 2860 2750 2530 2200 1980
45 3060 2930 2820 2590 2250 2030
46 3130 2990 2880 2650 2300 2070
47 3200 3060 2940 2710 2350 2120
48 3270 3120 3000 2760 2400 2160
49 3340 3190 3070 2820 2450 2210
And here is the SQL:
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 );