BOT Help

[zdh]

So I followed this guide for windows
http://www.eqemulator.net/wiki/wikka.php?wakka=ws1129r222

And the install went very smoothly and am easily able to start up a game and have others connect it. Everything seems fine with one exception, BOTS.

Every time I try to create a bot I get the name already exists error.

I searched the forum for this and the other solution I found was to source the load_bots.sql file, which I did during the initial install.

I'm running EQEMU 1180a-bots with the latest PEQ DB(1052)(I'm pretty sure this is the latest).

I've gone through all the logs and the command does not even get registered in the zone log and no errors, around BOT, in any logs at all.

Any help would be greatly appreciated.

[Rykeau]

Same situation here. This started after updating to EQEMU 1180a-bots. Any ideas?

[zdh]

sudo bump

but also a question. Since I'm, apparently, not the only one having bot problems with 1180. Are there archived versions of the emu some place for download?

And if so, I assume I can just down load and run with my current 1052 PEQ DB?

thanks

[ltflyr2]

Unless I'm mistaken, you need to source in the updated SQL files from the SVN. They can be found in the utlis/sql/svn folder. You'll want to source anything that's got a rev of 1052+ if you're using the 1052 database.

[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/projecteqemu/source/browse/trunk/EQEmuServer/utils/sql/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]

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

[erikowens91]

so...

if you're not the one who deals with all this and you're playing on a server where the person running it has pretty much completely neglected the whole thing are you pretty much screwed?

[Terethian2]

This has also happened to my server, I attempted to fix it by sourcing bots.sql which only gives a list of errors. I am also unable to revert to a previous bot code because when I try that I get perl errors..... I need to SAVE all bots people already have and fix the issue with new players being unable to create bots.

[Terethian2]

Nevermind, I was able to fix it on my own without dropping the existing tables. Upgrading to new versions has caused me so many problems. /sigh

[WilLes]

I just got my server up and running and I am running into this same problem. I was wonder how to go about sourcing in this .sql? sorry for such a dumb question but im new to all this. Thanks in advance!

[Rifmaz]

This site is really tight on info, makes this very unfun sometimes

[reddogut]

This site really isn't all that tight on info... it just isn't always super easy to find. But it is all here. This is the nature of the beast with this kind of project. It just takes patience.

[TheTrilobyte]

Yeah, you find the info eventually.

I was frustrated to begin with, but then I begun to appreciate the time those who are actually qualified in SQL/Perl etc spent learning those things.

I finally got my personal server up and running with working bots after about 2 days. Although it still scares the crapola out of me in regards to how little I know about what is 'actually' going on.

One things I would suggest is that the search engine on this forum makes it difficult sometimes.

If you search for 'bot problem' it filters out bot as a short word :P

[loglos]

To search eqemu I use google. Just go to google, type in site:eqemulator.org and your query criteria, i.e.

site:eqemulator.org "bot problem"

Works nicely. I hate the defaut forum search.

Just a note, "bot problem" only turned up 2 hits, this thread being one of them. ;-)

[reddogut]

Thats Nice!