Going solo - suggestions for where to start?

[GeorgeS]

Actually making NPC's a bit easier is not that hard.
What makes it possible is to reduce their MR resists, HP and max/min damage.

In combat I can take on a tough NPC but die due to not having enough DPS, or rather NPC has too many hp's etc..

To make it better, you can create a SQL like this

UPDATE npc_types SET hp=FLOOR(-5 + (25 * level) + 1.12 * (level ^ 2)) WHERE level<50;


This will in effect change the hp of all NPC's less<50 level to a predetermined value. It's a simple polynomial nth prder equation. Put it in Excel and see it's plot

I routinely use this in my database -

aNormal = Int(-5 + (25 * lvl) + 1.12 * (lvl ^ 2#))
boss = Int(-50 + 80 * lvl + 0.6 * (lvl ^ 2))
normal_aggressive = Int(0 + 31.6 * lvl + 1.16 * (lvl ^ 2.1))
boss_aggressive = Int(-50 + 80 * lvl + 0.6 * (lvl ^ 2.4))


This comes from my NPC editor under user tools.
NORMAL:BOSS NORMAL2:BOSS2
LVL HP HP HP HP
@1 21 30 32 30
@2 49 112 68 113
@3 80 195 106 198
@4 112 279 147 286
@5 148 365 192 378
@6 185 451 239 474
@7 224 539 290 574
@8 266 628 344 678
@9 310 718 401 787
@10 357 810 462 900
@11 405 902 525 1019
@12 456 996 593 1143
@13 509 1091 664 1272
@14 564 1187 738 1407
@15 622 1285 816 1548
@16 681 1383 897 1695
@17 743 1483 982 1848
@18 807 1584 1070 2007
@19 874 1686 1162 2173
@20 943 1790 1258 2345
@21 1013 1894 1357 2524
@22 1087 2000 1459 2709
@23 1162 2107 1566 2902
@24 1240 2215 1676 3102
@25 1320 2325 1790 3308
@26 1402 2435 1907 3523
@27 1486 2547 2028 3744
@28 1573 2660 2153 3973
@29 1661 2774 2282 4210
@30 1753 2890 2414 4454
@31 1846 3006 2551 4707
@32 1941 3124 2691 4967
@33 2039 3243 2834 5235
@34 2139 3363 2982 5512
@35 2242 3485 3133 5797
@36 2346 3607 3288 6090
@37 2453 3731 3447 6392
@38 2562 3856 3610 6702
@39 2673 3982 3777 7020
@40 2787 4110 3948 7348
@41 2902 4238 4122 7684
@42 3020 4368 4300 8030
@43 3140 4499 4483 8384
@44 3263 4631 4669 8747
@45 3388 4765 4859 9120
@46 3514 4899 5053 9501
@47 3644 5035 5251 9892
@48 3775 5172 5452 10293
@49 3909 5310 5658 10703
@50 4045 5450 5868 11122
@51 4183 5590 6082 11551
@52 4323 5732 6299 11990
@53 4466 5875 6521 12439
@54 4610 6019 6747 12897
@55 4758 6165 6976 13366
@56 4907 6311 7210 13844
@57 5058 6459 7447 14333
@58 5212 6608 7689 14831
@59 5368 6758 7935 15340
@60 5527 6910 8184 15860
@61 5687 7062 8438 16389
@62 5850 7216 8696 16929
@63 6015 7371 8958 17480
@64 6182 7527 9224 18041
@65 6352 7685 9494 18613
@66 6523 7843 9768 19195
@67 6697 8003 10046 19788
@68 6873 8164 10328 20392
@69 7052 8326 10614 21007
@70 7233 8490 10904 21633


GeorgeS

[GeorgeS]

Another possibility is to vary the equation by factoring into it a bit of randomness -


UPDATE npc_types SET hp=FLOOR(-5 + (25 * level) + 1.12 * (level ^ 2)+RAND()*level*2) WHERE level<50;

This add's a slight variance by level

GeorgeS

[John Adams]

GeorgeS, you are truly brilliant. I had never really considered doing the math in the SQL statements themselves... could save me hours of script writing. Hehe!

[Rhodan]

Are the NPCs really all that similar? I had thought they would have been a lot different - making en-mass changes like that impractical.

I'll have to dig into the NPC tables and have a look - so far I was just looking at zones and some scripting.

I really wish I could buff my GTW resist up to 200+...


(GTW= go to work).

[paaco]

man George you are rediculous with MySQL. I would never even attempt to come up with something like that or all the mobs on my server would be messed up lol :(

[Rhodan]

Originally Posted by paaco

man George you are rediculous with MySQL. I would never even attempt to come up with something like that or all the mobs on my server would be messed up lol :(

Thats where making a copy of the DB to practice on comes in handy

[GeorgeS]

To make a quick backup, copy the npc_types files (.frm .MYD , .MYI)These are found in C:\mysql\data\

GeorgeS