EQoffline, bots and more..

[sonicvt]

Is there any issue with the Bot code for if you update (source into MySQL) to a newer version of the PEQ database? Will they still work since the database was modified (create table botinventory, botleader, and botsowners)? I'm not a coder and wouldn't want to source the most recent PEQ database and have all the information (equipment) on the bots be lost. Thanks and great work.

[Zengez]

The PEQ updater only drops the tables it replaces, so if you use the update system files rather than the create new database tables you should be fine. At least so far as I remember of how PEQ works...

[cavedude]

Yes, the newest PEQ database is compatible with eqoffline. However, if you have existing bot data then you do not want to run drop_player.sql. I would suggest running drop_system.sql and then load_system.sql against your current db (back it up first before doing this of course) and then you should be set. The bot tables are considered player and not system, so sourcing drop_player.sql will destroy that data.

[John Adams]

Will it actually drop the bot* tables? That would mean someone would have added those tables to drop_players.sql. If they did not, the PEQ drop_players.sql should just skip anything it is not told to drop? Or is that sql a "drop everything"? I can't remember.

[cavedude]

Yes, it'll drop them because I added them to the file. By newest PEQ I assume the CVS is meant.

If the older Luclin package is implied, then no those bot tables will remain after running drop_player.sql.

[John Adams]

Originally Posted by cavedude

Yes, it'll drop them because I added them to the file.

Oooh, do I sense a Bots-Core merge?

/rumor on

[Blakine]

Has anyone had an issue where your bots stop responding to anything but the attack order?

Normally I dont have this problem, but the last couple of night I have been camping spawns in Charasis and at some point my bots will:

- Quit buffing and/or healing
- Stop following me

I can summon them and use the "attack" order, which they will respond to. But nothing else. Not sure why this dungeon seems to be the one place this happens in, I did fall through some of the pit traps. Anyway, thought I would mention it.