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:

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

[neiv2]

Here is what I'm experiencing in-game:

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

[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 (http://wiki.eqemulator.org/p?Akkas_PEQ_Server_Installer&frm=Main#from-scratch-installation-instructions-windows)))


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 (http://wiki.eqemulator.org/p?Complete_Windows-based_Server_Setup_Guide&frm=Main) 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
http://scinc.com/download/Picture1.png


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


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

[Uleat]

This is a link to the git repo's bot schema files: https://github.com/EQEmu/Server/tree/master/utils/sql/git/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.

[neiv2]

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

[neiv2]

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

[Uleat]

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

[DanCanDo]

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.

[neiv2]

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_PEQ_Server_Installer&frm=Main#from-scratch-installation-instructions-windows

[DanCanDo]

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.

Enter numbered option and press enter...

> 4
Retrieving latest bots database manifest...
[URL] :: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/bo
ts/bots_db_update_manifest.txt
[Saved] :: db_update/db_update_manifest.txt
Reading manifest...

DB up to date with: 9008 - '2016_06_28_bots_inventory_charges_update.sql'
Missing DB Update 9007 '2016_06_23_bots_camel_case_name_rule.sql'
[URL] :: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/bo
ts/required/2016_06_23_bots_camel_case_name_rule.sql
[Saved] :: db_update/2016_06_23_bots_camel_case_name_rule.sql
ERROR 1146 (42S02) at line 1: Table 'peqtest.bot_command_settings' doesn't exist

Missing DB Update 9006 '2016_04_12_bots_inventory_window.sql'
[URL] :: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/bo
ts/required/2016_04_12_bots_inventory_window.sql
[Saved] :: db_update/2016_04_12_bots_inventory_window.sql
Missing DB Update 9005 '2016_04_08_bots_heal_rotations.sql'
[URL] :: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/bo
ts/required/2016_04_08_bots_heal_rotations.sql
[Saved] :: db_update/2016_04_08_bots_heal_rotations.sql
ERROR 1146 (42S02) at line 1: Table 'peqtest.bot_command_settings' doesn't exist

Missing DB Update 9004 '2016_04_07_bots_heal_override_target.sql'
[URL] :: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/bo
ts/required/2016_04_07_bots_heal_override_target.sql
[Saved] :: db_update/2016_04_07_bots_heal_override_target.sql
ERROR 1146 (42S02) at line 1: Table 'peqtest.bot_pets' doesn't exist
DB up to date with: 9003 - '2016_04_05_bots_pet_spell_id_field.sql'
Missing DB Update 9002 '2016_03_24_bots_command_rules.sql'
[URL] :: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/bo
ts/required/2016_03_24_bots_command_rules.sql
[Saved] :: db_update/2016_03_24_bots_command_rules.sql
Missing DB Update 9001 '2016_03_24_bots_command_settings.sql'
[URL] :: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/bo
ts/required/2016_03_24_bots_command_settings.sql
[Saved] :: db_update/2016_03_24_bots_command_settings.sql

================================================== ==========
#::: EQEmu Update Utility Menu: (eqemu_update.pl)
================================================== ==========
1) [Backup Database] :: (Saves to Backups folder)
2) [Backup Database Compressed] :: (Saves to Backups folder)
3) [EQEmu DB Schema] :: Check and stage pending REQUIRED Database updates
4) [EQEmu DB Bots Schema] Run pending REQUIRED updates... (6)
5) [OPCodes] :: Download latest opcodes for each EQ Client
6) [Maps] :: Download latest map and water files
7) [Plugins (Perl)] :: Download latest Perl plugins
8) [Quests (Perl/LUA)] :: Download latest PEQ quests and stage updates
9) [LUA Modules] :: Download latest LUA Modules (Required for Lua)
10) [DB Data : Alternate Advancement] :: Download Latest AA's from PEQ (This ov
erwrites existing data)
11) [Windows Server Build] :: Download Latest and Stable Server Build (Overwrit
es existing .exe's, includes .dll's)
12) [Windows Server .dll's] :: Download Pre-Requisite Server .dll's
13) [Windows Server Loginserver Setup] :: Download and install Windows Loginser
ver
14) [Remove Duplicate Rule Values] :: Looks for redundant rule_values entries a
nd removes them
15) [Fetch Utility Scripts] :: Fetches server management utility scripts
18) [Windows Server Build Bots] :: Download Latest and Stable Server Build with
Bots
19) [EQEmu DB Drop Bots Schema] :: Remove Bots schema and return database to no
rmal state
20) [Update the updater] Force update this script (Redownload)
0) Exit

Enter numbered option and press enter...

> 4
Running Update: 9001 - 2016_03_24_bots_command_settings.sql
Running Update: 9002 - 2016_03_24_bots_command_rules.sql
Running Update: 9004 - 2016_04_07_bots_heal_override_target.sql
Running Update: 9005 - 2016_04_08_bots_heal_rotations.sql
ERROR 1005 (HY000) at line 1: Can't create table 'peqtest.bot_heal_rotations' (e
rrno: 150)
ERROR 1005 (HY000) at line 22: Can't create table 'peqtest.bot_heal_rotation_mem
bers' (errno: 150)
ERROR 1005 (HY000) at line 31: Can't create table 'peqtest.bot_heal_rotation_tar
gets' (errno: 150)
Running Update: 9006 - 2016_04_12_bots_inventory_window.sql
Running Update: 9007 - 2016_06_23_bots_camel_case_name_rule.sql
DB up to date with: 9008 - '2016_06_28_bots_inventory_charges_update.sql'
DB up to date with: 9007 - '2016_06_23_bots_camel_case_name_rule.sql'
DB up to date with: 9006 - '2016_04_12_bots_inventory_window.sql'
Missing DB Update 9005 '2016_04_08_bots_heal_rotations.sql'
[URL] :: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/bo
ts/required/2016_04_08_bots_heal_rotations.sql
[Saved] :: db_update/2016_04_08_bots_heal_rotations.sql
DB up to date with: 9004 - '2016_04_07_bots_heal_override_target.sql'
ERROR 1146 (42S02) at line 1: Table 'peqtest.bot_pets' doesn't exist
DB up to date with: 9003 - '2016_04_05_bots_pet_spell_id_field.sql'
DB up to date with: 9002 - '2016_03_24_bots_command_rules.sql'
DB up to date with: 9001 - '2016_03_24_bots_command_settings.sql'

================================================== ==========
#::: EQEmu Update Utility Menu: (eqemu_update.pl)
================================================== ==========
1) [Backup Database] :: (Saves to Backups folder)
2) [Backup Database Compressed] :: (Saves to Backups folder)
3) [EQEmu DB Schema] :: Check and stage pending REQUIRED Database updates
4) [EQEmu DB Bots Schema] Run pending REQUIRED updates... (1)
5) [OPCodes] :: Download latest opcodes for each EQ Client
6) [Maps] :: Download latest map and water files
7) [Plugins (Perl)] :: Download latest Perl plugins
8) [Quests (Perl/LUA)] :: Download latest PEQ quests and stage updates
9) [LUA Modules] :: Download latest LUA Modules (Required for Lua)
10) [DB Data : Alternate Advancement] :: Download Latest AA's from PEQ (This ov
erwrites existing data)
11) [Windows Server Build] :: Download Latest and Stable Server Build (Overwrit
es existing .exe's, includes .dll's)
12) [Windows Server .dll's] :: Download Pre-Requisite Server .dll's
13) [Windows Server Loginserver Setup] :: Download and install Windows Loginser
ver
14) [Remove Duplicate Rule Values] :: Looks for redundant rule_values entries a
nd removes them
15) [Fetch Utility Scripts] :: Fetches server management utility scripts
18) [Windows Server Build Bots] :: Download Latest and Stable Server Build with
Bots
19) [EQEmu DB Drop Bots Schema] :: Remove Bots schema and return database to no
rmal state
20) [Update the updater] Force update this script (Redownload)
0) Exit

Enter numbered option and press enter...

> 4
Running Update: 9005 - 2016_04_08_bots_heal_rotations.sql
ERROR 1005 (HY000) at line 1: Can't create table 'peqtest.bot_heal_rotations' (e
rrno: 150)
ERROR 1005 (HY000) at line 22: Can't create table 'peqtest.bot_heal_rotation_mem
bers' (errno: 150)
ERROR 1005 (HY000) at line 31: Can't create table 'peqtest.bot_heal_rotation_tar
gets' (errno: 150)
ERROR 1062 (23000) at line 39: Duplicate entry 'healrotationdelete' for key 'PRI
MARY'
DB up to date with: 9008 - '2016_06_28_bots_inventory_charges_update.sql'
DB up to date with: 9007 - '2016_06_23_bots_camel_case_name_rule.sql'
DB up to date with: 9006 - '2016_04_12_bots_inventory_window.sql'
Missing DB Update 9005 '2016_04_08_bots_heal_rotations.sql'
[URL] :: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/bo
ts/required/2016_04_08_bots_heal_rotations.sql
[Saved] :: db_update/2016_04_08_bots_heal_rotations.sql
DB up to date with: 9004 - '2016_04_07_bots_heal_override_target.sql'
ERROR 1146 (42S02) at line 1: Table 'peqtest.bot_pets' doesn't exist
DB up to date with: 9003 - '2016_04_05_bots_pet_spell_id_field.sql'
DB up to date with: 9002 - '2016_03_24_bots_command_rules.sql'
DB up to date with: 9001 - '2016_03_24_bots_command_settings.sql'

================================================== ==========
#::: EQEmu Update Utility Menu: (eqemu_update.pl)
================================================== ==========
1) [Backup Database] :: (Saves to Backups folder)
2) [Backup Database Compressed] :: (Saves to Backups folder)
3) [EQEmu DB Schema] :: Check and stage pending REQUIRED Database updates
4) [EQEmu DB Bots Schema] Run pending REQUIRED updates... (1)
5) [OPCodes] :: Download latest opcodes for each EQ Client
6) [Maps] :: Download latest map and water files
7) [Plugins (Perl)] :: Download latest Perl plugins
8) [Quests (Perl/LUA)] :: Download latest PEQ quests and stage updates
9) [LUA Modules] :: Download latest LUA Modules (Required for Lua)
10) [DB Data : Alternate Advancement] :: Download Latest AA's from PEQ (This ov
erwrites existing data)
11) [Windows Server Build] :: Download Latest and Stable Server Build (Overwrit
es existing .exe's, includes .dll's)
12) [Windows Server .dll's] :: Download Pre-Requisite Server .dll's
13) [Windows Server Loginserver Setup] :: Download and install Windows Loginser
ver
14) [Remove Duplicate Rule Values] :: Looks for redundant rule_values entries a
nd removes them
15) [Fetch Utility Scripts] :: Fetches server management utility scripts
18) [Windows Server Build Bots] :: Download Latest and Stable Server Build with
Bots
19) [EQEmu DB Drop Bots Schema] :: Remove Bots schema and return database to no
rmal state
20) [Update the updater] Force update this script (Redownload)
0) Exit

Enter numbered option and press enter...

>

[neiv2]

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

[Uleat]

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/master/utils/sql/git/bots/bots_db_update_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)

[DanCanDo]

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.

[Warkral]

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

http://img.photobucket.com/albums/v635/Razzlam/bots_zpsyfjxms9q.jpg (http://smg.photobucket.com/user/Razzlam/media/bots_zpsyfjxms9q.jpg.html)

[Uleat]

http://www.eqemulator.org/forums/showpost.php?p=250512&postcount=23

[DanCanDo]

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

[Warkral]

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