@echo off

:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
:: CONFIG - begin
set mysql_exe_path="C:\xampp\mysql\bin"
:: CONFIG - end
:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::


:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
:: Run MySQL database maintenance scripts
cd /d %mysql_exe_path%
mysql.exe --user=overpoch_cherno --password=overpoch_cherno --host=127.0.0.1 --port=3306 --database=overpoch_cherno < D:\Servers\Dayz_Cherno\sql\removeemptyplayers.sql
mysql.exe --user=overpoch_cherno --password=overpoch_cherno --host=127.0.0.1 --port=3306 --database=overpoch_cherno < D:\Servers\Dayz_Cherno\sql\safes0000.sql
mysql.exe --user=overpoch_cherno --password=overpoch_cherno --host=127.0.0.1 --port=3306 --database=overpoch_cherno < D:\Servers\Dayz_Cherno\sql\red00.sql
::mysql.exe --user=overpoch_cherno --password=overpoch_cherno --host=127.0.0.1 --port=3306 --database=overpoch_cherno < D:\Servers\Dayz_Cherno\sql\unlocknonkeyvehicles.sql
mysql.exe --user=overpoch_cherno --password=overpoch_cherno --host=127.0.0.1 --port=3306 --database=overpoch_cherno < D:\Servers\Dayz_Cherno\sql\bodyremoval.sql
::mysql.exe --user=overpoch_cherno --password=overpoch_cherno --host=127.0.0.1 --port=3306 --database=overpoch_cherno < D:\Servers\Dayz_Cherno\sql\.sql
::mysql.exe --user=overpoch_cherno --password=overpoch_cherno --host=127.0.0.1 --port=3306 --database=overpoch_cherno < D:\Servers\Dayz_Cherno\sql\.sql

:: Apply damage  to buildable objects
mysql.exe --user=overpoch_cherno --password=overpoch_cherno --host=127.0.0.1 --port=3306 --database=overpoch_cherno < D:\Servers\Dayz_Cherno\sql\setDamageOnAge.sql

:: Cleanup completely damaged buildables
mysql.exe --user=overpoch_cherno --password=overpoch_cherno --host=127.0.0.1 --port=3306 --database=overpoch_cherno < D:\Servers\Dayz_Cherno\sql\removeold.sql

:: Delete "No Key Left" Vehicles
mysql.exe --user=overpoch_cherno --password=overpoch_cherno --host=127.0.0.1 --port=3306 --database=overpoch_cherno < D:\Servers\Dayz_Cherno\sql\unlocknonkeyvehicles.sql

:: with file based traders, no need for this any more
::mysql.exe --user=dbadminCHANGETHIS --password=passwordCHANGETHIS --host=127.0.0.1 --port=3306 --database=overpochcher < C:\dayz_mod_server\__SQL_scripts\Modify_Trader_Data.Replenish_Stocks.sql
:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::


:: We're done here.
@exit