@echo off
SET NAME=Zeklabs.com
rem SQLDATE Will update, the EQ2Emu World DB. 1 for on, anything else for off.
rem EXEDATE Wull update, EXE files. 1 for on, anything else for off.
rem LUADATE Wull update, LUA files. 1 for on, anything else for off.
rem MAPDATE Wull update, MAP files. 1 for on, anything else for off.
rem strange name, It was supposed to be SQLUDATE etc but u got lost in the black whole that is my mind.
rem ALL UPDATE OPTIONS ARE DESTRUCTIVE AND WILL DELETE YOUR DATA
SET SQLDATE=1
SET EXEDATE=1
SET LUADATE=1
SET MAPDATE=1
TITLE %NAME%
COLOR 0E

if /I "%SQLDATE%" EQU "1" echo [Checking for SQL Updates and Downloading]
if /I "%SQLDATE%" EQU "1" wget -q -N https://zeklabs.com/dl/eq2emudb.rar
if /I "%SQLDATE%" EQU "1" unrar x -y -inul eq2emudb.rar
if /I "%SQLDATE%" EQU "1" echo [Completed Dwonload of SQL Updates]

if /I "%EXEDATE%" EQU "1" echo [Checking for EXE Updates]
if /I "%EXEDATE%" EQU "1" cd server
if /I "%EXEDATE%" EQU "1" wget -q -nc http://cutpon.com:3000/devn00b/EQ2EMu/raw/master/server/EQ2Login__Debug64.exe
if /I "%EXEDATE%" EQU "1" wget -q -nc http://cutpon.com:3000/devn00b/EQ2EMu/raw/master/server/ EQ2World__Debug_x64.exe
if /I "%EXEDATE%" EQU "1" echo [Completed EXE Updates]
if /I "%EXEDATE%" EQU "1" cd ..

if /I "%LUADATE%" EQU "1" echo [Checking for LUA Updates]
if /I "%LUADATE%" EQU "1" echo [This will take a moment due to number of files]
if /I "%LUADATE%" EQU "1" cd server
if /I "%LUADATE%" EQU "1" wget -q -N https://zeklabs.com/dl/eq2emulua.rar
if /I "%LUADATE%" EQU "1" ..\unrar x -y -inul eq2emulua.rar
if /I "%LUADATE%" EQU "1" del eq2emulua.rar
if /I "%LUADATE%" EQU "1" echo [Completed LUA Updates]
if /I "%LUADATE%" EQU "1" cd ..

if /I "%MAPDATE%" EQU "1" echo [Checking for MAP Updates]
if /I "%MAPDATE%" EQU "1" echo [This will take a moment due to LARGE map size]
if /I "%MAPDATE%" EQU "1" cd server
if /I "%MAPDATE%" EQU "1" ..\wget -q -N https://zeklabs.com/dl/eq2emumaps.rar
if /I "%MAPDATE%" EQU "1" ..\unrar x -y -inul eq2emumaps.rar
if /I "%MAPDATE%" EQU "1" del eq2emumaps.rar
if /I "%MAPDATE%" EQU "1" echo [Completed MAP Updates]
if /I "%MAPDATE%" EQU "1" cd ..\


echo [Loading MariaDB]
cd mariadb\bin
start db.bat
echo [You Can Press Any Key To Continue Once MYSQL has Completed Loading]
timeout /t 60
echo [MariaDB Loaded]
cd ..
cd..

if /I "%SQLDATE%" EQU "1" echo [Importing DB Update]
if /I "%SQLDATE%" EQU "1" cd mariadb\bin\
if /I "%SQLDATE%" EQU "1" mysql -ueq2emu -peq2emu --database=eq2emu <..\..\eq2emu.sql
if /I "%SQLDATE%" EQU "1" cd ..
if /I "%SQLDATE%" EQU "1" cd ..
if /I "%SQLDATE%" EQU "1" del eq2emudb.rar
if /I "%SQLDATE%" EQU "1" del eq2emu.sql
if /I "%SQLDATE%" EQU "1" echo [Completed DB Update]


echo [Starting World And Login]
start srvls.bat
start srvwrld.bat

rem exit