can't figure out this bot thing

[mjolnir001]

sorry bout that, it was late and i was getting frustrated.

i did not compile the server source myself. i just downloaded the 1410 from the google code page. i sourced in all 7 bot sql files in the 'player_tables' directory of the peqdatabase rev 1410 in this order:
source player_tables/botguildmembers.sql;
source player_tables/bots.sql;
source player_tables/botinventory.sql;
source player_tables/botgroups.sql;
source player_tables/botbuffs.sql;
source player_tables/botpetstatepersists.sql;
source player_tables/botadventuring.sql;

the only error i recieved on sourcing is: "error 1091 (42000): can't DROP 'PRIMARY'; check that column/key exists."

this shows up between the 5th and 4th from the bottom when sourcing in the bots.sql file.

*Edit. I think i figured this part out. it looks like it's dropping the primary key on the 'guild_members' table, however, since i've tried sourcing this a few times that key does not exist already. as long as the 'guild_members' table is not supposed to have a primary key, i imagine this error is irrelevant.

when starting the server i recieve:
[Debug] [RULES__ERROR] Unable to find rule 'Bots:BotGroupBuffing'
[Debug] [RULES__ERROR] Unable to interpret rule record for Bots:BotGroupBuffing
[Debug] [RULES__ERROR] Unable to find rule 'Bots:SpawnBotCount'
[Debug] [RULES__ERROR] Unable to interpret rule record for Bots:SpawnBotCount
[Debug] [RULES__ERROR] Unable to find rule 'Bots:BotQuest'
[Debug] [RULES__ERROR] Unable to interpret rule record for Bots:BotQuest
[Debug] [RULES__ERROR] Unable to find rule 'Bots:BotManaRegen'
[Debug] [RULES__ERROR] Unable to interpret rule record for Bots:BotManaRegen
[Debug] [RULES__ERROR] Unable to find rule 'Bots:BotFinishBuffing'
[Debug] [RULES__ERROR] Unable to interpret rule record for Bots:BotFinishBuffing
[Debug] [RULES__ERROR] Unable to find rule 'Bots:CreateBotCount'
[Debug] [RULES__ERROR] Unable to interpret rule record for Bots:CreateBotCount
[Debug] [RULES__ERROR] Unable to find rule 'Bots:BotSpellQuest'
[Debug] [RULES__ERROR] Unable to interpret rule record for Bots:BotSpellQuest

everything else seems to start normally.

[Capheus]

I don't think 1410 supports bots. Try getting 1316 and do it again.

[Frosef]

Originally Posted by Capheus

I don't think 1410 supports bots. Try getting 1316 and do it again.

My thoughts as well, although I couldn't get 1316 with bots to work either (Perl errors) which is what led me to compile the source myself.

Also, as far as I can tell, bots.sql is the only one you need to source in, although I could be mistaken and it can't hurt to source in the others. But it looks like bots.sql create all those same tables, the other files may simply be if you need to re-create an individual table.

[Frosef]

Originally Posted by Frosef

Also, as far as I can tell, bots.sql is the only one you need to source in, although I could be mistaken and it can't hurt to source in the others. But it looks like bots.sql create all those same tables, the other files may simply be if you need to re-create an individual table.

Ignore that bit, I was looking at the bots.sql that comes with the server source code under the utils\sql folder, not the one that comes with the PEQ Database!