Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Database/World Building

Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #9  
Old 10-29-2006, 05:21 AM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,474
Default

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





__________________
Your source for EQ database tools
Toolshop is open for business


http://www.georgestools.chrsschb.com//
Reply With Quote
 


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 10:27 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3