NPC/item DB arrangement

[Wiz]

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

[Lurker_005]

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.

[theCoder]

Try the describe mysql command.


mysql> describe npc_types;
+-------------------+---------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+---------------------+------+-----+---------+----------------+
| id | int(11) | | PRI | NULL | auto_increment |
| name | text | | | | |
| level | tinyint(2) unsigned | | | 0 | |
| race | tinyint(2) unsigned | | | 0 | |
| class | tinyint(2) unsigned | | | 0 | |
| hp | int(11) | | | 0 | |
| gender | tinyint(2) unsigned | | | 0 | |
| texture | tinyint(2) unsigned | | | 0 | |
| helmtexture | tinyint(2) unsigned | | | 0 | |
| size | float | | | 0 | |
| hp_regen_rate | int(11) unsigned | | | 0 | |
| mana_regen_rate | int(11) unsigned | | | 0 | |
| loottable_id | int(11) unsigned | | | 0 | |
| merchant_id | int(11) unsigned | | | 0 | |
| mindmg | int(10) unsigned | | | 0 | |
| maxdmg | int(10) unsigned | | | 0 | |
| usedspells | varchar(70) | | | | |
| npcspecialattks | char(1) | | | | |
| banish | int(10) unsigned | | | 0 | |
| aggroradius | int(10) unsigned | | | 0 | |
| social | int(10) unsigned | | | 0 | |
| face | int(10) unsigned | | | 1 | |
| luclin_hairstyle | int(10) unsigned | | | 1 | |
| luclin_haircolor | int(10) unsigned | | | 1 | |
| luclin_eyecolor | int(10) unsigned | | | 1 | |
| luclin_beardcolor | int(10) unsigned | | | 1 | |
| fixedz | tinyint(2) unsigned | | | 0 | |
| d_meele_texture1 | int(10) unsigned | | | 0 | |
| d_meele_texture2 | int(10) unsigned | | | 0 | |
| walkspeed | float | | | 0 | |
| runspeed | float | | | 0 | |
+-------------------+---------------------+------+-----+---------+----------------+
31 rows in set (0.01 sec)