Updated Bot Backup Batch File

[nosfentora]

Here's an updated .bat file to save *all* the bot info when doing a backup

@echo off
cls
REM Change these variables to suit your setup

REM the name of your database
set db=peq

REM the ip of your MySQL server, leave as is if local
REM -h prefix is needed if remote
set ip=-h127.0.0.1

REM Your database password, leave blank to enter manually
set pass=changeme

REM the folder to backup to (created in the current folder), set to . to not create a folder
set backupdir=bot_backup
REM the name of the bot backup file to create
set backupfile=bot_npcs.sql

echo **************************************
echo ***        Backing up Bots         ***
echo **************************************
if backupdir==. goto :end
dir .\ /a:d | find /i "%backupdir%" > nul
if errorlevel 1 goto notfound
goto :end
:notfound
md %backupdir%
:end
echo *** Dumping Bots from NPC_Types... ***
mysqldump -u root -p%pass% %ip% "--where=id in (select botnpctypeid from botsowners)" -x -t %db% npc_types > %backupdir%\%backupfile%
echo *** Dumping Bot Groups...          ***
mysqldump -u root -p%pass% %ip% -x -t %db% botgroups >> %backupdir%\%backupfile%
echo *** Dumping Bot Inventory...       ***
mysqldump -u root -p%pass% %ip% -x -t %db% botinventory >> %backupdir%\%backupfile%
echo *** Dumping Bot Leader...          ***
mysqldump -u root -p%pass% %ip% -x -t %db% botleader >> %backupdir%\%backupfile%
echo *** Dumping Bots Owners...         ***
mysqldump -u root -p%pass% %ip% -x -t %db% botsowners >> %backupdir%\%backupfile%
echo ***          Done dumping!         ***
echo **************************************
echo To re-source the bots source '%backupdir%\%backupfile%'
pause