Yes I have downloaded and sourced all your info into the db already....I am seeing an error when I run zone.exe (not a critical error that keeps it from loading). This is what it reads:
Loading items & NPCs...DB Query Error
Error #1054: Unknonw colum 'merchant_id' in field 'field list'
Error in LoadNPCTypes query 'SELECT id,name,level,race,class,hp,genger,texture,helmtex tured,size,lootable_id, merchant _id FROM npc_typs' #1054: Unknown column 'merchant_id' in 'field list'
BTW before I sourced your npc_type info I dropped the table and sourced this in to recreate the table. Maybe there is an error in it.
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 tinyint(2) unsigned 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',
PRIMARY KEY (id)
) TYPE=MyISAM;
|