GeorgeS: Request for a Bot back-up tool

[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

[Angelox]

Thanks, I hope you didn't go by that list I posted, already I saw where I left the inventory table out.
This will be a great help, as it's very hard to explain new users, how to back up those bots, and I'm going crazy trying to make core updates and not interfere with the npc_types bots.
Soon I'll be 'that crazy old guy' that walks barefoot down the street with a sack and a stick, collecting garbage and talking to invisible people

[GeorgeS]

Finished the backup/restore tool

NPC and Loot Editor
08.21.09 - Added support for Backing up your Account and Toons, Inventory and many other tables. Restore is also built in!

Hope it works for you.


GeorgeS

[Angelox]

Hi and thanks for the tool!
I have a problem;
I always use your tools from a windows client over the LAN to a Linux server.
This time around, when I try to back up Accounts or Bots, it gives me an error 'access denied' to the user@machine I deduct from the MySql. But is is entering the database, as I can edit NPCs and loots.
Here's the runtime error;
-21477217871(80040e31)
It then crashes to desktop

[GeorgeS]

The access issue is odd because I never touched the bot backup code..
The code to backup Bots is

SELECT * FROM npc_types WHERE isbot=1 INTO OUTFILE 'c:/bots.txt'
FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n'"

GeorgeS

[Angelox]

whats breaking it is this;

INTO OUTFILE 'c:/bots.txt'

and I already tried without the c:\
Probably a Linux issue, let me look around some