View Single Post
  #2  
Old 09-07-2008, 02:20 PM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,474
Default

I think the problem comes from if you have a bot field "isbot" or not.

I added a check in the program for bots.

Code:
CREATE TABLE `botinventory` (
  `npctypeid` int(11) NOT NULL default '0',
  `botslotid` int(11) default NULL,
  `itemid` int(11) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `botleader` (
  `botid` int(11) NOT NULL default '0',
  `leaderid` int(11) default NULL,
  PRIMARY KEY  (`botid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ALTER TABLE npc_types add `isbot` tinyint(4) NOT NULL;
GeorgeS
__________________
Your source for EQ database tools
Toolshop is open for business


http://www.georgestools.chrsschb.com//

Last edited by GeorgeS; 09-07-2008 at 10:38 PM..
Reply With Quote