Recreating Bots

[WildcardX]

Its too bad no one was able to step up and write an import script. I've had my hands full coding, I really don't have the time to write somethign any number of people have the skills to do.

Basically, if you feel you have to recreate your bots, you can attempt to blunt the pain by renaming your exisiting botinventory table to another name like "botinventoryOLD".. then do something like:

insert into botinventory (BotID, SlotID, ItemID) select npctypeid, slotid, itemid from botinventoryOLD;

update botinventory set BotID = *TODO: Add your bot id from your bots table here for your bot* where BotID = *Your Old Bot ID from EQBOTS*;

MAKE SURE YOU BACKUP YOUR DATABASE FIRST. I am not responsible for tears or emotional damage.

[laxative]

Hi,

I did a little mysql research, while not completed automated, I did get all my bots back with full inventory.

Further, I find they are easier to deal with and are not doing some of the annoyances that I found before; appearing to lose inventory after database updates, not accepting items unless grouped, poofing during raid creations...

I need to fix up my macros now

[djeryv]

I had a little trouble myself, but I was kinda lucky. I only had 3 bots total on the server. I just recreated them from scratch and move the botinventory back into the db so they had all their stuff back.

-Djeryv

[gaeorn]

Just committed to SVN a new sql to use that will convert the old style bots and their inventory to the new schema. You can find the file in utils/sql/svn/botsconvert.sql. Use this instead of bots.sql if you wish to convert.

Please be sure to back up your DB before attempting this.