Database and Bots
 

Hey guys. I recently got a new pc and to get a new server setup going. After following the windows server guide, I have my server up and running. Everything seems to be pretty smooth.

I have a couple of issues however. And maybe I missed something. But when I spawn bots, it gives me a red error message stating that botsinventory table doesn't exist.

Is there a way I can add the bots inventory table to the peq database through Navicat or another front end? or is there another way to fix this? I would like to be able to give my bots gear and weapons and have them keep them.


I appreciate any help you guys can give me.

EDIT: I was able to sift through several posts and finally found the info on the experience rate. Could still use a hand or even a pointer to a post that gives information on adding the bots inventory.

When you sourced your peqDB.sql, you followed it by sourcing load_player.sql and load_bots.sql correct? The load_bots should have added the proper tables, since you're missing it something went wrong along the way.

Yeah that's what's weird. I followed it step by step to the T. I sourced peqrev_2506.sql then did load_player.sql followed by load_bots.sql. I can actually summon bots, and they seem to work fine. It just gives me the error about not having inventory. Not sure what I did wrong.

the exact error I get is
"Database Error #1146: Table 'peq.botinventory' doesn't exist"

Did I forget to source something in perhaps? And I wonder if there is a way to add in that entry into the database?

load_bots.sql includes player_tables/botinventory.sql, so you should have it. Otherwise, run botinventory.sql from the player_tables folder, then check to make sure the table is in there.