View Single Post
  #4  
Old 02-26-2002, 08:07 AM
Trumpcard
Demi-God
 
Join Date: Jan 2002
Location: Charlotte, NC
Posts: 2,614
Default

Thats the old version of the npc_types struct..

It should look like this.. Yours is missing the merchant_id field.

#
# Table structure for table 'npc_types'
#

CREATE TABLE npc_types (
id int(11) NOT NULL auto_increment,
name text NOT NULL,
level tinyint(2) unsigned NOT NULL default '0',
race tinyint(2) unsigned NOT NULL default '0',
class tinyint(2) unsigned NOT NULL default '0',
hp int(11) NOT NULL default '0',
gender tinyint(2) unsigned NOT NULL default '0',
texture tinyint(2) unsigned NOT NULL default '0',
helmtexture tinyint(2) unsigned NOT NULL default '0',
size float NOT NULL default '0',
hp_regen_rate int(11) unsigned NOT NULL default '0',
mana_regen_rate int(11) unsigned NOT NULL default '0',
loottable_id int(11) unsigned NOT NULL default '0',
merchant_id int(11) unsigned NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;
Reply With Quote