EQoffline, bots and more..

[sonicvt]

Mag,

When I tell a bot to remove an inventory slot but don't have one targeted it kills EQEmu. Is this something fixable on your end or just something that it part of the game? Thanks.

[Wanderin]

Got my bots up and running with only a few snags so far. Made a lvl 51 human(male) monk bot and gave him the monk epic 1.0 fistwraps, soon as he would engage in combat the zone would crash. Then i made a 51 barbarian(female) beserker and tried to give her various 2hs weapons including the epic 1.0 and the bot would just eat them saying she couldnt use. Im running a Emu ver of 992 with the latest peq database and the current downloads from your website for the bots, did i miss something or are these just a few bugs to be worked on

[aneriel]

Would like to post a few things on this as I've spent days banging my head.

First, regarding the readme.txt that tells you to delete your npc_spells_entries table. never ever do this. When working with databases it can be very easy to overlook something and can cause major headaches while you spend hours trying to figure out why something doesn't work. Always rename the table before making any changes (you wouldn't just overwrite a file without backing it up first would you?). Even if it's something as simple as adding one column. It's much easier to look at your tables and know what is what:
npc_spell_entries_bots
npc_spell_entries_prebots

npc_types_bots
npc_types_prebots
etc, etc

Now I have a working table of both versions. I work with databases on a regular basis, so I knew to do this before-hand.

With that said, ever since I installed BOTs on my server I've been experiencing random disconnects (doing GM commands brings my zones down) and cannot group with other players. So I decided to roll back to pre-bots days. Now if I wouldn't have done what I stated above, I would be resourcing my database to get my npc_spell_types back. To source in my DB the first time took over 4 hours (don't ask why). This would have sucked. At any rate, I just want those out there not to have to do this if it can be easily avoided

Though that's not what I banged my head over, the issue I started having (after copying my orginal world.exe, zone.exe, and that dll back over) was that the zone would launch and then close right back down. I tried a different combination of things and in the end all i needed to do was the

mysql > set password for 'root'@'localhost' = old_password('newpw');

command. just wanted to give everyone a heads up.

[drakelord]

It's weird that I don't get any of these problems mentioned above, :\

[aneriel]

i don't have the time to find it again, but I figured out that the BOTs were causing all my woes from this thread. It's in the last 7-8 pages i know. So I guess it doesn't happen very often, but when it does it can be very frustrating. Just sucks I can't use BOTs now, I was using the crap out of them in befallen.

Now this goes to say that I didn't fully test this as I didn't have the time. What I would like to have done is install a fresh copy of bots, try out everything to see if it still works (GM commands, grouping with PCs). If so, then go on to create a bot, test again, give bots weapons, test again, etc, etc. Someone was logged on one night creating a lot of BOTs, this too could have caused some issues. So just because you don't have these troubles, doesn't mean they aren't there. You just may not have completed the correct step to spawn these issues. At any rate, i'll give them another go when I get some time to see if it's just my setup, or something did go wrong after a certain combination.

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

[sonicvt]

Soulscry,

I routinely update the peq_db (drop_system.sql and load_system.sql) and when it do so it kills the bot names and classes for the bot but keeps the bot inventory lists (as an aside, when it drops the name and class for the bot it is a great time when you re-#bot create them to choose new classes and names if the ones you used before aren't suiting your purposes instead of just making more bots that jack up the number of bots you have) I've never had the bots not keep their inventory items before though. I know when I give the bots new items it won't show the new appearance for the item (e.g. breastplate or weapon) until I respawn and group them.

Mag,

I noticed that if I do #bot attack and I myself don't engage in combat that the mob won't be agroed on me (won't get faction hits, won't attack me if the 5 bots wipe). I'm not sure if this was intended but it was just something I noticed while searching for named in zomes I'm not KOS in, for example Chardok.

Also, if you are agroed your bots go into auto attack mode but if you are in a raid only the bots in your group do this. Is this intentional or should the other raid groups also auto agro on the mob that agroed you?

Thanks and great work.

[Soulscry]

I sourced in the Botinventory sql file with cmd promp smysql... load up eqemu server and fire up eq client... log in .. spawn a bot .. equip it and kill it... respawn .. gear stayed ... woot woot ... but in combat i randomly crash now... happened 3 times in 20 min ... not sure exacly what caused it ... im thinking once was when i lost LoS with the mob... once happend when i turned off auto attack mid fight ... and once when i was backing away from a mob so the bottank could taunt/ hold aggro away from me.... this is the Worlddebug.exe cmd lines of the errors when i crash... any ideas would be great ... thanks guys =)

[Magoth78]

You can download the latest version (1.03f) : http://eqoffline.free.fr/Build.rar

Shouldn't crash anymore when using a weapon that have a lesser delay than the dmg.
Reworked damage formulas.
Fixed random crashes on deaths.