@echo off rem The following are the variables used, what they do, and the settings available. rem All settings on by default. rem SQLUPDATE Will update, the EQ2Emu World DB. 1 for on, 2 for updates only. anything else for off. rem ******** SETTING SQLUPDATE = 1 WILL ERASE ALL DATA IN THE DATABASE use 2 TO SAVE CHARACTERS/GUILDS ************ rem EXEUPDATE Will update, EXE files. 1 for on, anything else for off. rem LUAUPDATE Will update, LUA files. 1 for on, anything else for off. rem MAPUPDATE Will update, MAP files. 1 for on, anything else for off. rem SENDBUGS Will send your bug reports to an offsite server to be reviewed by staff. 1 for on, anything else is off. rem STRUCTCHK Will check for new Structs. 1 for on 0 for off. If you have EXE updates enabled this will run automatically. rem LSUPDATE Will check for new Loginserver updates SQL SET NAME=Zeklabs.com TITLE %NAME% SET SQLUPDATE=1 SET EXEUPDATE=1 SET LUAUPDATE=1 SET MAPUPDATE=1 SET SENDBUGS=1 SET STRUCTCHK=1 SET LSUPDATE=1 if /I "%SQLUPDATE%" EQU "1" powershell write-host -fore Red ******** SETTING SQLUPDATE = 1 WILL ERASE ALL DATA IN THE DATABASE use 2 TO SAVE CHARACTERS/GUILDS ************ if /I "%SQLUPDATE%" EQU "1" echo [Checking for SQL Full Update and Downloading] if /I "%SQLUPDATE%" EQU "1" wget -q -N --no-check-certificate https://zeklabs.com/dl/eq2emudb.rar if /I "%SQLUPDATE%" EQU "1" unrar x -y -inul eq2emudb.rar if /I "%SQLUPDATE%" EQU "1" del eq2emudb.rar if /I "%SQLUPDATE%" EQU "1" echo [Completed Download of SQL Full Update] if /I "%SQLUPDATE%" EQU "2" echo [Checking for SQL Update and Downloading] if /I "%SQLUPDATE%" EQU "2" wget -q -N --no-check-certificate https://zeklabs.com/dl/eq2dbupdate.rar if /I "%SQLUPDATE%" EQU "2" unrar x -y -inul eq2dbupdate.rar if /I "%SQLUPDATE%" EQU "2" del eq2dbupdate.rar if /I "%SQLUPDATE%" EQU "2" echo [Completed Download of SQL Update] if /I "%EXEUPDATE%" EQU "1" echo [Checking for EXE Updates. **NOTE** If something goes wrong, backups files can be found in the oldfiles folder] if /I "%EXEUPDATE%" EQU "1" cd server if /I "%EXEUPDATE%" EQU "1" mkdir oldfiles if /I "%EXEUPDATE%" EQU "1" move eq2*.exe oldfiles if /I "%EXEUPDATE%" EQU "1" wget -q -nc http://cutpon.com:3000/devn00b/EQ2EMu/raw/master/server/EQ2Login__Debug64.exe if /I "%EXEUPDATE%" EQU "1" wget -q -nc http://cutpon.com:3000/devn00b/EQ2EMu/raw/master/server/EQ2World__Debug_x64.exe if /I "%EXEUPDATE%" EQU "1" echo [New EXE Could Mean NEW Structs. Checking...] if /I "%EXEUPDATE%" EQU "1" move SpawnStructs.xml oldfiles/ if /I "%EXEUPDATE%" EQU "1" move WorldStructs.xml oldfiles/ if /I "%EXEUPDATE%" EQU "1" move EQ2_Structs.xml oldfiles/ if /I "%EXEUPDATE%" EQU "1" move ItemStructs.xml oldfiles/ if /I "%EXEUPDATE%" EQU "1" move LoginStructs.xml oldfiles/ if /I "%EXEUPDATE%" EQU "1" wget -q -nc http://cutpon.com:3000/devn00b/EQ2EMu/raw/master/server/SpawnStructs.xml if /I "%EXEUPDATE%" EQU "1" wget -q -nc http://cutpon.com:3000/devn00b/EQ2EMu/raw/master/server/WorldStructs.xml if /I "%EXEUPDATE%" EQU "1" wget -q -nc http://cutpon.com:3000/devn00b/EQ2EMu/raw/master/server/EQ2_Structs.xml if /I "%EXEUPDATE%" EQU "1" wget -q -nc http://cutpon.com:3000/devn00b/EQ2EMu/raw/master/server/ItemStructs.xml if /I "%EXEUPDATE%" EQU "1" wget -q -nc http://cutpon.com:3000/devn00b/EQ2EMu/raw/master/server/LoginStructs.xml if /I "%EXEUPDATE%" EQU "1" echo [Completed Struct Updates] if /I "%EXEUPDATE%" EQU "1" echo [Completed EXE Updates] if /I "%EXEUPDATE%" EQU "1" cd .. if /I "%LUAUPDATE%" EQU "1" echo [Checking for LUA Updates] if /I "%LUAUPDATE%" EQU "1" echo [This will take a moment due to number of files] if /I "%LUAUPDATE%" EQU "1" cd server if /I "%LUAUPDATE%" EQU "1" wget -q -N --no-check-certificate https://zeklabs.com/dl/eq2emulua.rar if /I "%LUAUPDATE%" EQU "1" ..\unrar x -y -inul eq2emulua.rar if /I "%LUAUPDATE%" EQU "1" del eq2emulua.rar if /I "%LUAUPDATE%" EQU "1" echo [Completed LUA Updates] if /I "%LUAUPDATE%" EQU "1" cd .. if /I "%MAPUPDATE%" EQU "1" echo [Checking for MAP Updates] if /I "%MAPUPDATE%" EQU "1" echo [This will take a moment due to LARGE map size] if /I "%MAPUPDATE%" EQU "1" cd server if /I "%MAPUPDATE%" EQU "1" ..\wget -q -N --no-check-certificate https://zeklabs.com/dl/eq2emumaps.rar if /I "%MAPUPDATE%" EQU "1" ..\unrar x -y -inul eq2emumaps.rar if /I "%MAPUPDATE%" EQU "1" del eq2emumaps.rar if /I "%MAPUPDATE%" EQU "1" echo [Completed MAP Updates] if /I "%MAPUPDATE%" EQU "1" cd .. if /I "%LSUPDATE%" EQU "1" echo [Updating LoginServer SQL] if /I "%LSUPDATE%" EQU "1" cd server if /I "%LSUPDATE%" EQU "1" mkdir oldfiles if /I "%LSUPDATE%" EQU "1" wget -q -N --no-check-certificate https://zeklabs.com/dl/eq2emulssql.rar if /I "%LSUPDATE%" EQU "1" ..\unrar x -y -inul eq2emumlssql.rar if /I "%LSUPDATE%" EQU "1" mysql -ueq2emu -peq2emu --database=eq2emu < eq2emulssql.sql if /I "%LSUPDATE%" EQU "1" move eq2emuls* oldfiles/ if /I "%LSUPDATE%" EQU "1" echo [Completed Updating LoginServer SQL] if /I "%LSUPDATE%" 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 ..\.. if /I "%SENDBUGS%" EQU "1" echo [Uploading BUG Reports to Devn00b] if /I "%SENDBUGS%" EQU "1" cd mariadb\bin\ if /I "%SENDBUGS%" EQU "1" mysqldump -ueq2emu -peq2emu --no-create-db --no-create-info --complete-insert --skip-add-locks --skip-add-drop-table --skip-comments --compact eq2emu bugs >bugs.sql if /I "%SENDBUGS%" EQU "1" mysql -ueq2emu -pidontgive2shits --host=eq2db.devn00b.com --database=eq2emu