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 :)

I think this is correct (off the top of my head), but it isn't the only way to find the info.

In mysql:
mysql> use {database}
show table npc_types


If it is wrong, just look in the mysql documentation for something like show table.

You can also take a prrk at the db.sql file. Search for "create table npc_types"

also look at spawn2, spawngroup, and spawnentry.

Try the describe mysql command.