Thread: Recreating Bots
View Single Post
  #2  
Old 08-04-2009, 11:28 AM
WildcardX
Developer
 
Join Date: Apr 2003
Posts: 589
Default

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:

Code:
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.
__________________
Read my developer notes at my blog.

Quote:
If it's not on IRC, it ain't l33t!
Reply With Quote