View Single Post
  #8  
Old 12-24-2003, 04:45 AM
maethwyn
Fire Beetle
 
Join Date: Dec 2002
Posts: 11
Default

...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 );
Reply With Quote