Lost my bots during upgrade
 

I have not upgraded in months, I just upgraded and seem to have lost the bots, inventory, etc. I notice the database structure on the bots is much different now. So what is the correct procedure to not lose the bots during an upgrade ?

Second question, is the lfaydark camp for LDoN there ? I cannot seem to find it but it looks to be the only one that has LDoN adventure templates.

Okay fixed the first problem, bots are working.

Still need an answer on the second question about Mistmoore LDoN, where is the wayfarer camp ?

Just past 19 on this map is where the LDON camp is located.

Mind posting your fix for the first problem in case others come across this thread in a search? I'm assuming it has something to do with sql updates? I have seen others with this problem though it may be helpful.

That is the BB camp. The recruiter there does not show any quest. The MMC is Mistmoore, that is the one I was asking about.

As far as my fix, this is what worked for me. The original SQL columns did not match up in my DB so I kind of modified it to read this way.

INSERT INTO bots SELECT NULL, bo.botleadercharacterid, nt.npc_spells_id, nt.name, nt.lastname, nt.level, nt.race, nt.class, nt.gender, nt.size, nt.face, nt.luclin_hairstyle, nt.luclin_haircolor, nt.luclin_eyecolor, nt.luclin_eyecolor2, nt.luclin_beardcolor, nt.luclin_beard, nt.drakkin_heritage, nt.drakkin_tattoo, nt.drakkin_details, nt.MR, nt.CR, nt.DR, nt.FR, nt.PR, nt.AC, nt.STR, nt.STA, nt.DEX, nt.AGI, nt._INT, nt.WIS, nt.CHA, nt.ATK,null,null,null, nt.id FROM botsowners bo, npc_types nt WHERE nt.isbot = 1 AND nt.id = bo.botnpctypeid;

The butcherblock camp is the MMC theme, and it does work. Make sure you are running the newest PEQ DB SVN.

you need to click on the recruiter not hail, and see Cavedude's post ...