Where to start

[neiv2]

I just installed the server and option 18 on the update to enable bots. I also experimented with commands (which are recognized). My question is, where do I get the bots? Is it ^botcreate? Cause when I do that I get an error message. Is there is bot vendor as was the case on the PEQ repack I played years ago? I read the wikki -- lots of help on commands -- no help on where to start.

[ghanja]

Search popped up these:

http://www.eqemulator.org/forums/showthread.php?t=28608

and in the news subforum:

...start with '^help' and see where that takes you

I suspect (I dont use/toy around with bots personally), that #bot has been replaced with simply ^

^create maybe? Dunno, as recommended in the above quote, do ^help

and go from there.

[neiv2]

Thanks, ghanja. The link you posted references commands I already know from the Ax-Classic repack. They are all perl commands, and were connected with a bot vendor in major towns. Apparently, all that has changed. ^bothelp just repeats what's n the wiki -- doesn't explain how one acquires bots. ^botcreate is the command that failed for me, so there must be something else to it.

[DanCanDo]

Did you run number 4 on the update script after you grabbed the bot executables ?
When it's working properly, you can simply ^help and it should spit out a list of 198
commands. But it's not just the executables compiled for bots that you need, the
bot tables have to be in the databse as well. (check to see if they are there).
To create a bot, type ^botcreate help
I am not familiar with the "installer", as I don't use it. But I do run the update script.

[neiv2]

Dan, when I run option 4, it returns errors:

[neiv2]

Here is what I'm experiencing in-game:

[Breur]

I also had a very hard time adding the bots. Try looking in your \EQ\SQL\ folder for a file called 'load_bots.sql' it should add the missing stuff to database. Also I had to run the eqemu_update.pl a bunch of times till everything got updated without errors some updates needed several runs for it to get everything in place. It was very complicated to get it running if I remember correct there were also some problems with the load_bots.sql and I had to manually do some stuff. I hope they find a simpler way to get it done in the future.

[neiv2]

Hmmm ... that file and folder doesn't seem to be part of the install (I used this procedure)


I do know that load_bots.sql is part of the PEQ-EQ (I downloaded that file too but did not install it).

[Breur]

I did not use that installer it was not out yet. I used the Complete Windows-based Server Setup Guide Have a read through it and see if it gives you any idea of something that can help you with the bot problem.

[N0ctrnl]

Do NOT run bot SQL scripts from anywhere but the official github repo or the update script. There are bout 10 different versions floating around out there that do about 10 different things. Uleat spent a lot of time making everything right, so do yourself a huge favor and use the update script to do it.

If you run #4 twice, does it report the same thing again?

[neiv2]

Actually, no. They are different. See three examples below:

First Run



Second Run



Third Run

[Uleat]

This is a link to the git repo's bot schema files: https://github.com/EQEmu/Server/tree.../bots/required


I would start with the oldest file and go through each one to ensure that the table/view/function was added and then move on.

You shouldn't need to verify all of the data entries..just make sure that if it's a schema addition/change, that it is there. Should only take about 5 minutes
if you do it manually.


I'm not sure what the problem is..but, it did work correctly when I implemented the versioning system.

If nothing else, drop the bots schema and apply 2015_09_30_bots.sql manually, then run the update script and select '4' again.


EDIT: Looking at your update script errors, you are definitely missing 'base' schema...

[neiv2]

Thanks, I'll try that at halftime.

[neiv2]

I assume I should run 18 before running 4 since I previously dropped the bot schema?

[Uleat]

19? Probably...

But, I would still manually install the 2015_09_30_bots.sql script manually before proceeding to option 4.

That seems to be where the current 'snag' is.