GeorgeS: Request for a Bot back-up tool

[Angelox]

I was wondering if you might can come up with a back up tool for the Bots? the tables needed are 'botinventory', 'botleader', and 'botowner' - then ( heres the catch); from npc_types; 'SELECT * FROM npc_types WHERE isbot=1' . When I dump my databse for download, all these tables need to be clean, if there is any npc_types that are flagged as 'isbot' , it will throw everything. I can easily clean them, but the backing up the bots and re inserting is slow (for me). Would be nice for people getting updates , able to back up their bots also.
Maybe you can make a character back up with bots included?
Thanks!

[GeorgeS]

A bot backup/restore tool is easy to write. In fact I'll add the ability to do the same for accounts and toons as well.

I'll give this a few days to plan out the logic, then code and test it.

I'll default the output to export to .sql

GeorgeS

this will be added to npc&loot editor most likely..

[GeorgeS]

In case you have not tried it, it's done. NPC & Loot Editor has the feature built in now.


GeorgeS

[Angelox]

Originally Posted by GeorgeS

In case you have not tried it, it's done. NPC & Loot Editor has the feature built in now.


GeorgeS

Oh thanks! I almost missed this post, I've been submerged in the Merchant list clean up these past days, I have to say, PoK is a nightmare! I think I must be halfway through.

I'll DL and check it out - Thanks again GeorgeS.

[Angelox]

Hi, Very nice loot editor! so much different from your first one.
Can you include the accounts too with the BOT back up?

account
character_
inventory
character_backup
faction_values
guild_members
guild_ranks
guild_relations
guilds
petitions
player_corpses
player_corpses_backup
sharedbank
zone_flags
botinventory
botleader
botsowners

That's all what I usually back up (and the isbot=1 Npcs)- it's pointless to back up Bots only, as they are related to the accounts and characters.
Thank you!

[GeorgeS]

Your wish is my command

I was going to add this in the next version, but now I'll prioritise it.

Should be relatively easy, but heck I'll find out.

GeorgeS