BOT Help

[zdh]

Derision,

Thank you very much for the reply. That view did not exist and looking at my load_bot.sql file it is not contained in there.

So I sourced the file you specified and now the view exists.

So I tried a new #bot create and receive a new error message.

#bot create cleric 2 6 female
#1054: Unknown column 'LastZoneId' in field list
Unable to save cleric as bot

Any thoughts?

[Derision]

Originally Posted by zdh

#1054: Unknown column 'LastZoneId' in field list
Unable to save cleric as bot
Any thoughts?

I don't know why you are seeing that error. The bots.sql I linked has the LastZoneID field right at the end of the CREATE statement for the bots table:

CREATE TABLE IF NOT EXISTS `bots` (
  `BotID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `BotOwnerCharacterID` int(10) unsigned NOT NULL,
  `BotSpellsID` int(10) unsigned NOT NULL DEFAULT '0',
  `Name` varchar(64) NOT NULL,
  `LastName` varchar(32) DEFAULT NULL,
  `BotLevel` tinyint(2) unsigned NOT NULL DEFAULT '0',
  `Race` smallint(5) NOT NULL DEFAULT '0',
  `Class` tinyint(2) NOT NULL DEFAULT '0',
  `Gender` tinyint(2) NOT NULL DEFAULT '0',
  `Size` float NOT NULL DEFAULT '0',
  `Face` int(10) NOT NULL DEFAULT '1',
  `LuclinHairStyle` int(10) NOT NULL DEFAULT '1',
  `LuclinHairColor` int(10) NOT NULL DEFAULT '1',
  `LuclinEyeColor` int(10) NOT NULL DEFAULT '1',
  `LuclinEyeColor2` int(10) NOT NULL DEFAULT '1',
  `LuclinBeardColor` int(10) NOT NULL DEFAULT '1',
  `LuclinBeard` int(10) NOT NULL DEFAULT '0',
  `DrakkinHeritage` int(10) NOT NULL DEFAULT '0',
  `DrakkinTattoo` int(10) NOT NULL DEFAULT '0',
  `DrakkinDetails` int(10) NOT NULL DEFAULT '0',
  `MR` smallint(5) NOT NULL DEFAULT '0',
  `CR` smallint(5) NOT NULL DEFAULT '0',
  `DR` smallint(5) NOT NULL DEFAULT '0',
  `FR` smallint(5) NOT NULL DEFAULT '0',
  `PR` smallint(5) NOT NULL DEFAULT '0',
  `AC` smallint(5) NOT NULL DEFAULT '0',
  `STR` mediumint(8) NOT NULL DEFAULT '75',
  `STA` mediumint(8) NOT NULL DEFAULT '75',
  `DEX` mediumint(8) NOT NULL DEFAULT '75',
  `AGI` mediumint(8) NOT NULL DEFAULT '75',
  `_INT` mediumint(8) NOT NULL DEFAULT '80',
  `WIS` mediumint(8) NOT NULL DEFAULT '75',
  `CHA` mediumint(8) NOT NULL DEFAULT '75',
  `ATK` mediumint(9) NOT NULL DEFAULT '0',
  `BotCreateDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `LastSpawnDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `TotalPlayTime` int(10) unsigned NOT NULL DEFAULT '0',
  `LastZoneId` smallint(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (`BotID`)
) ENGINE=InnoDB;

[zdh]

The bots table I had did not have that field. Once I got the new table right, it all worked great.


Many thanks for your help!