EQoffline, bots and more..

[Congdar]

I will be downloading the fix direct from sourceforge since this website seems to be broken as far as build updates go. I only have the Beastlord spell list left to do and I'm still debugging the level 44 enchanter zone aggro issue. Before I start the beastlord spell list, I'll get the fixes to The Realm.

[Congdar]

I've posted my latest bots release in the official release thread, check it out!

[cavedude]

I merged the spells into PEQ.

[Congdar]

Thanks Cavedude!

[gygelly]

Thanks for the update Congdar...the last one was kind of crashy and the group bug was a pain, so my guild and I have just been using a previous version for the time being.

We'll get right to playing with this new version tonight.

Since you are nearly done with the spells, I have a request for your next priority, along the same vein. We need to get the bot info into it's own table, rather than npc_types. Every time I update peq, I have to jump through a bunch of hoops to ensure that player's bots aren't lost...which is a pretty big deal as players put effort into equipping their bots.

Previously, it wasn't THAT bad, I just had to be sure to backup the rows from npc_types that were bots before sourcing in drop_system. But recently, the peq guys have been adding more entries to npc types, the ids of which overlap with the ids of the bots. This means I have to not only assign the bots new ids in npc_types, but also update the botinventory and botowners tables.

Again, thanks for the update!

[Congdar]

Cavedude made a batch file that backs up the bots to a sql file you can source in with a new database. The id's are supposed to be in a range that doesn't conflict with existing or new npc's. Not sure why you are having issues there. The inventory and owners tables are not touched during a drop_system.sql (is that the name?) so only the npc_types needs to be backed up with CD's batch file.
I'm not sure moving them to their own table would work with the spawn code. CD?

[gygelly]

Yeah, like I said, it's just recently I started having trouble.

Basically, I started having problems when npc_type.id 999137 (#Xegony the Quenn of Air) was added into the database, as 999137 was the id of the first bot I made. Obviously, they can't have the same id, so I just changed the id of my bot to 999237 before adding his row back to the npc_types table.

Since then, as npcs have been added, I've had to manually bump the ids of my bots higher. right now, the last one was 999145, Ragrua Protector. Each update, I only have to fix a few bots.

And yeah, the botowners and inventory aren't dropped, that's not the problem. I just have to manually update the ids in those tables to match up with the id change I have to make in npc_types. So again, using my first bot as an example, when I changed his id to 999237 from 999137, I had to update all the entries with the bot.id 999137 to 999237 in the bot inventory table so that he still had his items, and in the botowner table so I could still summon him.