Rev 1052 bots multi bugs SOLVED

[Bitesys]

hi everyone,

I am new to the eqemu, just got it for a week, got me 3 days to get it running. I found a few problems for bots from rev 1052 database :
- missing LastZoneID when creating
- take bots pass zone and they disappear, ever spawn again they do not follow
- invite bots to guild
- bring bots to start a advanture


after spend some time in the web, I figure out the problems for those problems, the bots database in rev 1052 is outdated !! the table is missing field LastZoneID, missing table botguildmembers etc. I solved some of it manually, but I found the best way to solved those problems is to source this file trunk\EQEmuServer\utils\sql\svn\bots.sql . This will create new bots tables, so all bots will be gone, and their items. There is also a file trunk\EQEmuServer\utils\sql\svn\botsconvert.sql, which suppose will convert your bots tabls and keep all your items, but I didn't test it, I suppose it will work, backup or whatever if you are not sure.

after the created the new bots tables, I can do this with bots :
- create bots (of cause)
- group bots
- fight in group with bots
- bring bots pass zone, and group function normal, they still follow me
- invite bots to guild, list bots in guild roster
- accept advanture with bots group (too bad the instant mistmoore catacomb is not in the game yet)
- create bots group, and raid some tought mob

Hope this will help anyone have same problems.