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)