Where to start
 

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.

Search popped up these:

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

and in the news subforum:

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.

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.

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.

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

http://scinc.com/download/Picture1.png

Here is what I'm experiencing in-game:

http://scinc.com/download/Picture2.png

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.

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).

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.

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?

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

First Run
http://scinc.com/download/Picture1.png


Second Run
http://scinc.com/download/Picture2a.png


Third Run
http://scinc.com/download/Picture3.png

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...

Thanks, I'll try that at halftime.

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

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.

No, I meant 18. I did 19 to drop the bot schema. Isn't reloading 18 required to "enable" bots prior to running 4?

And just to clarify, manually installing the sql in Heidi consists of File > Load SQL File ... ?

If you're using the pre-built binaries..and you don't already have it currently downloaded, then yes.

Option 19 will not change your binaries back to non-BOTS enabled..only revert the database schema.


(And, yes, on the '> Load SQL File')

I'm going to setup a seperate non-bot server folder/db and try and replicate this whole
scenario of converting over to a bot enabled server to see how it goes.
Never tried it that way before (chuckle). Maybe I can get some insight on this.

Still no dice. Think I'll uninstall it and reinstall. Can you confirm this is the right place to be?

http://wiki.eqemulator.org/p?Akkas_P...ctions-windows

After using option 18 and getting the executables, this is what I got running
#4 on the update script (a few times) It showed 6 updates to grab from first
run and 1 update after 2nd and 3rd run, but all came with errors.

Yeah, that looks like what I'm experiencing too.

Not sure why the list is iterating backwards..it's checking for things before they have been installed...


you can do a manual install..

https://github.com/EQEmu/Server/blob...e_manifest.txt

Just install those sqls from 9000 to 9008..then run the updater to ensure that the other changes are made.


EDIT: ACTUALLY... Did you hit 4 again to apply the updates? (Needs to be hit twice..first for queuing and second for application)

One thing that did happen, after grabbing the executables, the first time I hit #4, it told
me I did not have bots enabled and the script closed. I simply started the script up again,
hit 4 and it continued on.

Having same problem here. Ran 18, then 4 twice. Bots still a no go:

http://img.photobucket.com/albums/v6...psyfjxms9q.jpg

I gave him a little help (in pm) which fixed the problem for him (one of my past solutions)
(chuckle)

Opps sorry, forgot to update the post. Thanks again to DanCanDo!!!