@echo off
rem OPTION Will update, the EQ2Emu World DB. 1 for on, anything else for off.
rem Variables and Data
SET NAME=ZekLabs.com
TITLE %NAME%
COLOR 0E

echo [Downloading SQL Wipe.]
echo [Download of SQL Wipe Complete.]
echo [Removing SQL Database.]
copy dangerous.sql ..\mariadb\bin
cd ..\mariadb\bin\
mysql -ueq2emu -peq2emu <dangerous.sql
del dangerous.sql
cd ..\..
echo [You now have an empty database.]

echo [Getting a NEW DB to fill it with.]
wget -q -N --show-progress --progress=bar:force:noscroll https://zeklabs.com/dl/eq2emudb.rar
echo [Extracting NEW DB]
unrar x -y -inul eq2emudb.rar

echo [Importing New DB.]
cd mariadb\bin\
mysql -ueq2emu -peq2emu --database=eq2emu < ..\..\eq2emu.sql
cd ..\..
del eq2emudb.rar
del eq2emu.sql
echo [DB Import Completed.]

echo [Removing LUA files.]
cd server\lua
rmdir . /s /q
cd ..\..
echo [The Above error is expected and will not cause issues]
echo [All LUA files Deleted.]

echo [Getting LUA Files.]
echo [This will take a moment due to number of files]
cd server
wget -q -N https://zeklabs.com/dl/eq2emulua.rar
..\unrar x -y -inul eq2emulua.rar
del eq2emulua.rar
echo [Completed LUA Updates]
cd ..

echo [Removing old Maps and Navs.]
cd server\maps
del /q *.eq2map
rmdir nav /q
cd ..\..
echo [All Maps/Navs Deleted.]

echo [Checking for MAP Updates]
echo [This will take a moment due to LARGE map size]
cd server
..\wget -q -N --show-progress --progress=bar:force:noscroll https://zeklabs.com/dl/eq2emumaps.rar
echo [Begining Extraction of MAPs]
..\unrar x -y -inul eq2emumaps.rar
del eq2emumaps.rar
echo [Completed MAP Updates]
cd ..\