BOT Help

[pfyon]

You can download a specific revision from the svn and compile it yourself. Not sure on whether the DB would be an issue (if the revision is older than your db schema), it would depend on what was added between your server code and the db revision.

[zdh]

So is this a bug with 1180? Anyone running 1180 able to get bots to work?

[Akkadius]

If you can compile your own source, use SVN to pull down a previous revision known to work and compile the bot system from there if you are wanting to use bots that bad. I know Wildcard does most of the work for bots IIRC but if something isn't working I'm sure they'll look into logs to figure it out soon.

[Derision]

I just tested the 1180a bots code I uploaded and #bot create works fine for me.

If you are getting the 'The name xxx is already being used.' for every name you try, it suggests an issue with the database view vwBotCharacterMobs, as an error in that query is the only way a name will be rejected.

What do you get if you issue this command:

mysql> describe vwBotCharacterMobs;
+------------+-----------------------+------+-----+---------+-------+
| Field      | Type                  | Null | Key | Default | Extra |
+------------+-----------------------+------+-----+---------+-------+
| mobtype    | varchar(1)            | NO   |     |         |       |
| id         | int(11)               | NO   |     | 0       |       |
| name       | varchar(64)           | NO   |     |         |       |
| class      | tinyint(4)            | NO   |     | 0       |       |
| level      | mediumint(8) unsigned | NO   |     | 0       |       |
| timelaston | bigint(20) unsigned   | YES  |     | NULL    |       |
| zoneid     | smallint(6)           | NO   |     | 0       |       |
+------------+-----------------------+------+-----+---------+-------+
7 rows in set (0.00 sec)

If it doesn't match my output, I would source in this sql:

http://code.google.com/p/projecteqem...l/svn/bots.sql

(You will lose any existing bots if you do that).

[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!