EQoffline, bots and more..

[Magoth78]

aneriel> I'm sorry but:
I'm not a professionnal programmer,
I'm not a professionnal DB admin,
I'm not an computer specialist.

I do that for free and it was supposed to be EQoffline. Offline also meant a single player version. I've never wanted to make this project so you can have a live eqemu server with a lot of peeps creating bots.
Now, if it's too buggy for you then don't use it.

What I can say is that two friends and me are playing on the server EQoffline dev 1.02 (wich is 1.03e in fact). We leveleved legitly from 1 to 60 and we're still playing. I've fixed almost all the bugs we've found. Some bugs are left and they are all writed on a paper. I will work on them when i will have the time.
It's very playable though.

[aneriel]

Hey mag, sorry if i came off as complaining about eqoffline. That wasn't my intentions. I was merely posting what happened to me so if someone else experiences it, they will be able to find some help in the forums. like I said, i only noticed that one post about some guy having the same issues as me, so it's very rare. I spent hours searching these forums (Tho to be honest, this post kept coming up as top on the list, I just didn't think it had anything to do with it.). I finally just got to the point where I had to post a question about some of my issues
http://www.eqemulator.net/forums/sho...563#post137563


i love eqoffline. i used the hell out of it. and to be honest I don't remember having any problems with it at first. Something else happened to trigger all my hishaps.

[Soulscry]

First off... I love the bots... after alil trial and error on my part i managed to get them going and do alil leveling... I can do groups and raids .. update the bots to get there new spells n stuff ... 2 questions though.

1: Is Update supposed to level up my bots to my level? cuz I still have to kill them and respawn them to get them to level up...

2: For some reason i cant get the bots to keep there gear... Dieing, me logging, zoneing, me #kill ing them ... if for any reason i despawn them they lose all there gear ... i tried #bot update ing them but to no avail ... im sure its some simple mistake that only i dont understand lol ... but yet here i am .. with my level 5 naked bot warrior trying to tank for me =/ ...

anyway .. thanks again for all the hard work... This is a dream come true for me ... I couldnt play eq much anymore for lack of time needed to get raids togeather or even groups... with the Bot-armada I can play in my free time and still do the things i enjoy ... Your my hero =) ... Cheers!

[Magoth78]

Soulcry>

1) When you do a "#bot update", their level become the same as your. Don't worry about them staying blue, I just don't update their consider color.

2) When you do a "#bot inventory list" on your bots, what do you see ? Is the botinventory table created in your database as mentionned on the README (http://eqoffline.free.fr/README.txt) ?

[Soulscry]

The Bot Inventory sql that came with peq is what i have .... sence cavedude already had it in i didnt mess with it ... do i need to change it?

Botinventory
SQL file
2kb



-- MySQL dump 10.11
--
-- Host: localhost Database: PEQ_CVS
-- ------------------------------------------------------
-- Server version 5.0.38-Ubuntu_0ubuntu1-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `botinventory`
--

DROP TABLE IF EXISTS `botinventory`;
CREATE TABLE `botinventory` (
`npctypeid` int(11) NOT NULL default '0',
`botslotid` int(11) default NULL,
`itemid` int(11) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `botinventory`
--

LOCK TABLES `botinventory` WRITE;
/*!40000 ALTER TABLE `botinventory` DISABLE KEYS */;
/*!40000 ALTER TABLE `botinventory` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2007-07-27 20:48:25

[Soulscry]

The #bot inventory list says all the bots slots are empty ... even after i give them an item ... and the item is showing on the bot ... ( armor on and sword in hand )...

[cavedude]

I just realized there was an error in the load_player.sql script. Source in botinventory.sql manually and I'd bet it will work for you.