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.
|