View Single Post
  #1  
Old 04-22-2002, 08:06 PM
Wiz
Dragon
 
Join Date: Feb 2002
Posts: 583
Default NPC/item DB arrangement

Exactly how are the values for items and NPC's arranged in the DB?

I know NPC's is something like:

(id, name, level, race, class, hp, gender, texture, helmtexture, size, hp_regen_rate, mana_regen_rate, loottable_id, merchant_id, mindmg, maxdmg, usedspells, npcspecialattks, banish, aggroradius, social, face, luclin_hairstyle, luclin_haircolor, luclin_eyecolor, luclin_beardcolor)

Though this gives me an error with latest release. No real clue how items are arranged though. Is there a simple way to find this out with mySQL? Otherwise I'd appreciate an answer. Thanks
Reply With Quote