EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)
-   -   Database and Bots (https://www.eqemulator.org/forums/showthread.php?t=36924)

jshows1 06-06-2013 01:59 PM

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.

Burningsoul 06-06-2013 02:41 PM

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.

jshows1 06-06-2013 03:21 PM

Quote:

Originally Posted by Burningsoul (Post 221474)
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.

jshows1 06-06-2013 04:07 PM

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?

bad_captain 06-07-2013 10:43 AM

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.


All times are GMT -4. The time now is 09:23 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.