malufett 247 Posted March 27, 2015 (edited) 'job_db1.txt' Redesign What is it? The file has been upgrade to achieve 2 goals: make it easier for us to update the file and for our users to customize it better. The old hp/sp computation has been drop and replace by hp/sp tables. job_db.conf Format: Job_Name: { // Job names as in src/map/pc.c (they are hardcoded at the moment so if you want to add a new job you should add it there) Inherit: ( "Other_Job_Name" ); // Base job from which this job will inherit its max weight, base ASPD set and HP/SP table. InheritHP: ( "Other_Job_Name" );// Base job from which this job will inherit its HP table. InheritSP: ( "Other_Job_Name" );// Base job from which this job will inherit its SP table. Weight: Max Weight (int, defaults to 20000, units in Weight/10) BaseASPD: { // Base ASPD for specific weapon type Fist: 0~200 (int, defaults to 200) Dagger: 0~200 (int, defaults to 200) Sword: 0~200 (int, defaults to 200) TwoHandSword: 0~200 (int, defaults to 200) Spear: 0~200 (int, defaults to 200) TwoHandSpear: 0~200 (int, defaults to 200) Axe: 0~200 (int, defaults to 200) TwoHandAxe: 0~200 (int, defaults to 200) Mace: 0~200 (int, defaults to 200) TwoHandMace: 0~200 (int, defaults to 200) Rod: 0~200 (int, defaults to 200) Bow: 0~200 (int, defaults to 200) Knuckle: 0~200 (int, defaults to 200) Instrumen: 0~200 (int, defaults to 200) Whip: 0~200 (int, defaults to 200) Book: 0~200 (int, defaults to 200) Katar: 0~200 (int, defaults to 200) Revolver: 0~200 (int, defaults to 200) Rifle: 0~200 (int, defaults to 200) GatlingGun: 0~200 (int, defaults to 200) Shotgun: 0~200 (int, defaults to 200) GrenadeLauncher: 0~200 (int, defaults to 200) FuumaShuriken: 0~200 (int, defaults to 200) TwoHandRod: 0~200 (int, defaults to 200) Shield: 0~200 (int, defaults to 0) } HPTable:[ 1, .... 150 ] (int[]) Reference table for base HP per level SPTable:[ 1, .... 150 ] (int[]) Reference table for base SP per level // Note: If table index size is smaller than the max level the server will automatically generate the missing index based on the average increase per level.} Benefit? You can now easily specify a class base weight, base aspd for specific weapon types and HP/SP per level. Lessen redundant entries and good for the eyes.. RE ASPD formula is improved to compatibly(less/no more conversion) accept aegis database. Tools? http://herc.ws/board/files/file/202-hercules-hpsp-table-generator/Special Thanks to: Awesome @Yommy Best @Michi Incredible @Ind Nice @Beret Links Commit: https://github.com/HerculesWS/Hercules/commit/b59b9d1ab4c5a21081cdd2af126997ed7093d743 File: https://github.com/HerculesWS/Hercules/blob/master/db/re/job_db.conf Edited February 7, 2017 by Ridley 13 evilpuncker, Beret, Nebraskka and 10 others reacted to this Quote Share this post Link to post Share on other sites
Michi 101 Posted April 10, 2015 Awesome !!!!!!!!!! Quote Share this post Link to post Share on other sites
zackdreaver 90 Posted April 10, 2015 this is awesome! Quote Share this post Link to post Share on other sites
Jezu 25 Posted April 10, 2015 Awesomely awesome! Quote Share this post Link to post Share on other sites
evilpuncker 503 Posted April 10, 2015 great!! but what about job_db2.txt? Quote Share this post Link to post Share on other sites
malufett 247 Posted April 10, 2015 great!! but what about job_db2.txt? I don't have any better idea for its redesign... Quote Share this post Link to post Share on other sites
evilpuncker 503 Posted April 10, 2015 (edited) great!! but what about job_db2.txt? I don't have any better idea for its redesign... lets just move it to something like the Lua files structures pseudo code/example: [JobID.Novice] = { Str = { 0, 6, 5, 0, 2, 3, 0, 1, 4, 0 }, Agi = { 0, 6, 5, 0, 2, 3, 0, 1, 4, 0 }, Vit = { 0, 6, 5, 0, 2, 3, 0, 1, 4, 0 }, Int = { 0, 6, 5, 0, 2, 3, 0, 1, 4, 0 }, Dex = { 0, 6, 5, 0, 2, 3, 0, 1, 4, 0 }, Luk = { 0, 6, 5, 0, 2, 3, 0, 1, 4, 0 }} Edited April 10, 2015 by evilpuncker 2 Jedzkie and JulioCF reacted to this Quote Share this post Link to post Share on other sites
Litro 45 Posted April 19, 2015 (edited) // Note: If table index size is smaller than the max level the server will automatically generate the missing index based on the average increase per level. my test server have high level set, BaseLevel = 255 and the sp amount is insanely high and what is average number per level can you help enlighten me and i try to create my own sp table for wizard class, coz warlock(trans) iherited it and it got me near the previous job_db result (sp amount) Wizard: { Weight: 24000 BaseASPD: { Fist: 500 Dagger: 575 Rod: 625 TwoHandRod: 625 } HPTable:[ 40, 46, 53, 60, 68, 76, 85, 94, 104, 115, // 1 - 10 126, 138, 150, 163, 176, 190, 204, 219, 234, 250, // 11 - 20 267, 284, 302, 320, 339, 358, 378, 398, 419, 441, // 21 - 30 463, 486, 509, 533, 557, 582, 607, 633, 659, 686, // 31 - 40 714, 742, 771, 800, 830, 860, 891, 922, 954, 987, // 41 - 50 1020, 1054, 1088, 1123, 1158, 1194, 1230, 1267, 1304, 1342, // 51 - 60 1381, 1420, 1460, 1500, 1541, 1582, 1624, 1666, 1709, 1753, // 61 - 70 1797, 1842, 1887, 1933, 1979, 2026, 2073, 2121, 2169, 2218, // 71 - 80 2268, 2318, 2369, 2420, 2472, 2524, 2577, 2630, 2684, 2739, // 81 - 90 2794, 2850, 2906, 2963, 3020, 3078, 3136, 3195, 3254, 3313, // 91 - 100 3372, 3431, 3490, 3549, 3608, 3667, 3726, 3785, 3844, 3903, // 101 - 110 3962, 4021, 4080, 4139, 4198, 4257, 4316, 4375, 4434, 4493, // 111 - 120 4552, 4611, 4670, 4729, 4788, 4847, 4906, 4965, 5024, 5083, // 121 - 130 5142, 5201, 5260, 5319, 5378, 5437, 5496, 5555, 5614, 5673, // 131 - 140 5732, 5791, 5850, 5909, 5968, 6027, 6086, 6145, 6204, 6263] // 141 - 150 SPTable:[ 19, 28, 37, 46, 55, 64, 73, 82, 91, 100, // 1 - 10 109, 118, 127, 136, 145, 154, 163, 172, 181, 190, // 11 - 20 199, 208, 217, 226, 235, 244, 253, 262, 271, 280, // 21 - 30 289, 298, 307, 316, 325, 334, 343, 352, 361, 370, // 31 - 40 379, 388, 397, 406, 415, 424, 433, 442, 451, 460, // 41 - 50 469, 478, 487, 496, 505, 514, 523, 532, 541, 550, // 51 - 60 559, 568, 577, 586, 595, 604, 613, 622, 631, 640, // 61 - 70 649, 658, 667, 676, 685, 694, 703, 712, 721, 730, // 71 - 80 739, 748, 757, 766, 775, 784, 793, 802, 811, 820, // 81 - 90 829, 838, 847, 856, 865, 874, 883, 892, 901, 910, // 91 - 100 919, 928, 937, 946, 955, 964, 973, 982, 991, 1000, // 101 - 110 1009, 1018, 1027, 1036, 1045, 1054, 1063, 1072, 1081, 1090, // 111 - 120 1099, 1108, 1117, 1126, 1135, 1144, 1153, 1162, 1171, 1180, // 121 - 130 1189, 1198, 1207, 1216, 1225, 1234, 1243, 1252, 1261, 1270, // 131 - 140 1279, 1288, 1297, 1306, 1315, 1324, 1333, 1342, 1351, 1360, // 141 - 150 1369, 1378, 1387, 1396, 1405, 1414, 1423, 1432, 1441, 1450, // 151 - 160 1459, 1468, 1477, 1486, 1495, 1504, 1513, 1522, 1531, 1540, // 161 - 170 1549, 1558, 1567, 1576, 1585, 1594, 1603, 1612, 1621, 1630, // 171 - 180 1639, 1648, 1657, 1666, 1675, 1684, 1693, 1702, 1711, 1720, // 181 - 190 1729, 1738, 1747, 1756, 1765, 1774, 1783, 1792, 1801, 1810, // 191 - 200 1819, 1828, 1837, 1846, 1855, 1864, 1873, 1882, 1891, 1900, // 201 - 210 1909, 1918, 1927, 1936, 1945, 1954, 1963, 1972, 1981, 1990, // 211 - 220 1999, 2008, 2017, 2026, 2035, 2044, 2053, 2062, 2071, 2080, // 221 - 230 2089, 2098, 2107, 2116, 2125, 2134, 2143, 2152, 2161, 2170, // 231 - 240 2179, 2188, 2197, 2206, 2215, 2224, 2233, 2242, 2251, 2260, // 241 - 250 2269, 2278, 2287, 2296, 2305] // 251 - 255} using revision before job_db redesign using revision after job_db redesign and adding sp table and hp table seems lowered from previous Edited April 19, 2015 by Litro Quote Share this post Link to post Share on other sites
malufett 247 Posted April 19, 2015 my test server have high level set, BaseLevel = 255 and the sp amount is insanely high and what is average number per level can you help enlighten me example: Defined Table Level 1 = 10 Level 2 = 20 Level 3 = 30 Stops at 3 but your max level for a specific job is 10 then let's compute for the average increase 0-10 = abs(-10) 10-20 = abs(-10) 20-30 = abs(-10) total = 30 average = 30/10 = 10 it means in every level the hp increases 10 per level now let's compute for the succeeding level Level 4 = 4 * 10 = 40 . . Level 10 = 10 * 10 = 1000 Hope you understand... Quote Share this post Link to post Share on other sites
Litro 45 Posted April 20, 2015 thanks @@malufett, but it still weird have you seen my screenshot it have sp 784707 and Warlock SP Table inherited from Wizard and wizard all level on sp table increased by 9 per level (if i calculate it corectly so the average is 9), basically the automatically generated missing index will have same result with sp table that i manualy generated and the question is why and how the automaticaly generated give me 784707 SP and the manualy generated give me 10294 SP? Original Wizard SPTable 1-150 SPTable:[ 19, 28, 37, 46, 55, 64, 73, 82, 91, 100, // 1 - 10 109, 118, 127, 136, 145, 154, 163, 172, 181, 190, // 11 - 20 199, 208, 217, 226, 235, 244, 253, 262, 271, 280, // 21 - 30 289, 298, 307, 316, 325, 334, 343, 352, 361, 370, // 31 - 40 379, 388, 397, 406, 415, 424, 433, 442, 451, 460, // 41 - 50 469, 478, 487, 496, 505, 514, 523, 532, 541, 550, // 51 - 60 559, 568, 577, 586, 595, 604, 613, 622, 631, 640, // 61 - 70 649, 658, 667, 676, 685, 694, 703, 712, 721, 730, // 71 - 80 739, 748, 757, 766, 775, 784, 793, 802, 811, 820, // 81 - 90 829, 838, 847, 856, 865, 874, 883, 892, 901, 910, // 91 - 100 919, 928, 937, 946, 955, 964, 973, 982, 991, 1000, // 101 - 110 1009, 1018, 1027, 1036, 1045, 1054, 1063, 1072, 1081, 1090, // 111 - 120 1099, 1108, 1117, 1126, 1135, 1144, 1153, 1162, 1171, 1180, // 121 - 130 1189, 1198, 1207, 1216, 1225, 1234, 1243, 1252, 1261, 1270, // 131 - 140 1279, 1288, 1297, 1306, 1315, 1324, 1333, 1342, 1351, 1360] // 141 - 150 manualy generated Wizard SPTable - Level 151 - 255 1369, 1378, 1387, 1396, 1405, 1414, 1423, 1432, 1441, 1450, // 151 - 160 1459, 1468, 1477, 1486, 1495, 1504, 1513, 1522, 1531, 1540, // 161 - 170 1549, 1558, 1567, 1576, 1585, 1594, 1603, 1612, 1621, 1630, // 171 - 180 1639, 1648, 1657, 1666, 1675, 1684, 1693, 1702, 1711, 1720, // 181 - 190 1729, 1738, 1747, 1756, 1765, 1774, 1783, 1792, 1801, 1810, // 191 - 200 1819, 1828, 1837, 1846, 1855, 1864, 1873, 1882, 1891, 1900, // 201 - 210 1909, 1918, 1927, 1936, 1945, 1954, 1963, 1972, 1981, 1990, // 211 - 220 1999, 2008, 2017, 2026, 2035, 2044, 2053, 2062, 2071, 2080, // 221 - 230 2089, 2098, 2107, 2116, 2125, 2134, 2143, 2152, 2161, 2170, // 231 - 240 2179, 2188, 2197, 2206, 2215, 2224, 2233, 2242, 2251, 2260, // 241 - 250 2269, 2278, 2287, 2296, 2305, // 251 - 255 automatically generated Wizard SPTable ?? Quote Share this post Link to post Share on other sites
vBrenth 39 Posted April 21, 2015 thanks @@malufett, but it still weird have you seen my screenshot it have sp 784707 and Warlock SP Table inherited from Wizard and wizard all level on sp table increased by 9 per level (if i calculate it corectly so the average is 9), basically the automatically generated missing index will have same result with sp table that i manualy generated and the question is why and how the automaticaly generated give me 784707 SP and the manualy generated give me 10294 SP? Original Wizard SPTable 1-150 SPTable:[ 19, 28, 37, 46, 55, 64, 73, 82, 91, 100, // 1 - 10 109, 118, 127, 136, 145, 154, 163, 172, 181, 190, // 11 - 20 199, 208, 217, 226, 235, 244, 253, 262, 271, 280, // 21 - 30 289, 298, 307, 316, 325, 334, 343, 352, 361, 370, // 31 - 40 379, 388, 397, 406, 415, 424, 433, 442, 451, 460, // 41 - 50 469, 478, 487, 496, 505, 514, 523, 532, 541, 550, // 51 - 60 559, 568, 577, 586, 595, 604, 613, 622, 631, 640, // 61 - 70 649, 658, 667, 676, 685, 694, 703, 712, 721, 730, // 71 - 80 739, 748, 757, 766, 775, 784, 793, 802, 811, 820, // 81 - 90 829, 838, 847, 856, 865, 874, 883, 892, 901, 910, // 91 - 100 919, 928, 937, 946, 955, 964, 973, 982, 991, 1000, // 101 - 110 1009, 1018, 1027, 1036, 1045, 1054, 1063, 1072, 1081, 1090, // 111 - 120 1099, 1108, 1117, 1126, 1135, 1144, 1153, 1162, 1171, 1180, // 121 - 130 1189, 1198, 1207, 1216, 1225, 1234, 1243, 1252, 1261, 1270, // 131 - 140 1279, 1288, 1297, 1306, 1315, 1324, 1333, 1342, 1351, 1360] // 141 - 150 manualy generated Wizard SPTable - Level 151 - 255 1369, 1378, 1387, 1396, 1405, 1414, 1423, 1432, 1441, 1450, // 151 - 160 1459, 1468, 1477, 1486, 1495, 1504, 1513, 1522, 1531, 1540, // 161 - 170 1549, 1558, 1567, 1576, 1585, 1594, 1603, 1612, 1621, 1630, // 171 - 180 1639, 1648, 1657, 1666, 1675, 1684, 1693, 1702, 1711, 1720, // 181 - 190 1729, 1738, 1747, 1756, 1765, 1774, 1783, 1792, 1801, 1810, // 191 - 200 1819, 1828, 1837, 1846, 1855, 1864, 1873, 1882, 1891, 1900, // 201 - 210 1909, 1918, 1927, 1936, 1945, 1954, 1963, 1972, 1981, 1990, // 211 - 220 1999, 2008, 2017, 2026, 2035, 2044, 2053, 2062, 2071, 2080, // 221 - 230 2089, 2098, 2107, 2116, 2125, 2134, 2143, 2152, 2161, 2170, // 231 - 240 2179, 2188, 2197, 2206, 2215, 2224, 2233, 2242, 2251, 2260, // 241 - 250 2269, 2278, 2287, 2296, 2305, // 251 - 255 automatically generated Wizard SPTable ?? Where did you calculate it ? my server got 1/1 sp/hp im using 255/120 Quote Share this post Link to post Share on other sites
malufett 247 Posted April 21, 2015 Where did you calculate it ? my server got 1/1 sp/hp im using 255/120 you can use excel..since it can do auto increment based on average increase per row.... Quote Share this post Link to post Share on other sites
evilpuncker 503 Posted May 12, 2015 (edited) @@malufett any chance to make a config in order to we choose the old calculation instead? I guess that everyone that uses a higher level than the official one is having issues right now, or at least provide us a tool to generate new tables, or at least provide generated tables to 1000 lvl since our exp_db goes up to this... look what I'm talking about: vs Edited May 13, 2015 by evilpuncker 1 Litro reacted to this Quote Share this post Link to post Share on other sites
malufett 247 Posted May 13, 2015 @evilpunker sorry I've been busy this past days..if I have a chance next week I'll create a tool that will have many options for computing the table like: 1st option use ea coefficient increase algorithm 2nd option average increase algorithm 3rd your own algorithm 2 evilpuncker and Litro reacted to this Quote Share this post Link to post Share on other sites
evilpuncker 503 Posted May 13, 2015 after @@Haru change it really didn't changed anything beside SP lol :'( Quote Share this post Link to post Share on other sites
malufett 247 Posted May 13, 2015 after @@Haru change it really didn't changed anything beside SP lol :'( he just fixed possible server crash and derive the formula,,, just wondering why people ignoring this? // Players' maximum HP rate? (Default is 100) hp_rate: 100 // Players' maximum SP rate? (Default is 100) sp_rate: 100 Quote Share this post Link to post Share on other sites
evilpuncker 503 Posted May 13, 2015 @@malufett I did not forgot this setting, but it is so much unbalanced since it still make us have low hp at lower level and make us reach the hp limit very easily, and I messed up with this for like 1 hour straight Quote Share this post Link to post Share on other sites
Kong 9 Posted May 14, 2015 after @@Haru change it really didn't changed anything beside SP lol :'( he just fixed possible server crash and derive the formula,,, just wondering why people ignoring this? > // Players' maximum HP rate? (Default is 100) hp_rate: 100 // Players' maximum SP rate? (Default is 100) sp_rate: 100 I have the same issues with them the reason why I didn't update up to this revision yet. The new HP calculation is different and there's no way you can convert the old hp multiplier to the current one and get the same result. In my opinion, the old HP configuration is easier to adjust and you can way more balance it per job class. // Players' maximum HP rate? (Default is 100) hp_rate: 100 // Players' maximum SP rate? (Default is 100) sp_rate: 100 To be honest, I never used this to increase player hp/sp rate specially in Renewal. It simply makes other job go way higher in HP/SP than the others specially if you are playing in High Rates (255+). And the job_db gives you more freedom on adjusting these rates per job classes. Quote Share this post Link to post Share on other sites
astralprojection 35 Posted May 15, 2015 (edited) Will you check Knight HP Table? i think this is not right.. HP increment from lvl 99-150 is only 75. At this rate, Assassin Cross will have more HP than knight at lvl 255. Knight Assassin Edited May 15, 2015 by jawbreaker Quote Share this post Link to post Share on other sites
evilpuncker 503 Posted May 20, 2015 @evilpunker sorry I've been busy this past days..if I have a chance next week I'll create a tool that will have many options for computing the table like: 1st option use ea coefficient increase algorithm 2nd option average increase algorithm 3rd your own algorithm great, waiting for it (I guess everyone is lol) Quote Share this post Link to post Share on other sites
Litro 45 Posted May 23, 2015 while waiting for @@malufett tool, i try make my own generator but it always fail to make same hp pool with revision befor new job_db patch, can some one help me make it right ? <?php $MAX_LEVEL = 250; $HPFactor = 70; $HPMultiplicator = 500; for ($i = 2; $i <= $MAX_LEVEL; $i++) { $j += ($HPFactor / 100) * $i; $k = 35 + $i * ($HPMultiplicator / 100) + $j; echo round($k); echo "<br>"; }?> Quote Share this post Link to post Share on other sites
malufett 247 Posted May 24, 2015 @evilpunker sorry I've been busy this past days..if I have a chance next week I'll create a tool that will have many options for computing the table like: 1st option use ea coefficient increase algorithm 2nd option average increase algorithm 3rd your own algorithm great, waiting for it (I guess everyone is lol) http://herc.ws/board/topic/9687-hercules-hpsp-table-generator/ 1 evilpuncker reacted to this Quote Share this post Link to post Share on other sites
koko24 1 Posted May 31, 2015 (edited) Archieve Corrupted File Relink please ==================== Turned off Anti-Virus = Works How do i revert back to the old Formulas? using eA Formula what are the Multiplicator and Factor for each job? Edited June 1, 2015 by koko24 Quote Share this post Link to post Share on other sites
evilpuncker 503 Posted June 1, 2015 Archieve Corrupted File Relink please ==================== Turned off Anti-Virus = Works How do i revert back to the old Formulas? using eA Formula what are the Multiplicator and Factor for each job? https://raw.githubusercontent.com/HerculesWS/Hercules/df1bcac8ef95885019adc1ee03cb2ed9c663c0df/db/re/job_db1.txt // Structure of Database:// JobID,Weight,HPFactor,HPMultiplicator,SPFactor 1 koko24 reacted to this Quote Share this post Link to post Share on other sites
