| @echo off
|
| setlocal EnableExtensions
|
| title Download Server Tools (MariaDB / HeidiSQL / WinRAR)
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| set "DEST=%USERPROFILE%\Desktop\Server-Tools"
|
| if not exist "%DEST%" mkdir "%DEST%"
|
|
|
| set "OK=0"
|
| set "BAD=0"
|
|
|
| echo.
|
| echo Saving to: %DEST%
|
| echo ------------------------------------------------------------
|
|
|
| call :Get "https://mirrors.aliyun.com/mariadb//mariadb-12.3.3/winx64-packages/mariadb-12.3.3-winx64.msi" "%DEST%\mariadb-12.3.3-winx64.msi" "MariaDB 12.3.3 x64"
|
|
|
| call :Get "https://github.com/HeidiSQL/HeidiSQL/releases/download/v12.21/HeidiSQL_12.21.0.7344_Setup.exe" "%DEST%\HeidiSQL_12.21.0.7344_Setup.exe" "HeidiSQL 12.21"
|
| |
|
|
|
|
| set "WRDONE="
|
| for %%V in (721 720 713 712 711 710) do (
|
| if not defined WRDONE (
|
| call :TryWinrar %%V
|
| if not errorlevel 1 set "WRDONE=1"
|
| )
|
| )
|
| if not defined WRDONE (
|
| echo [FAIL] WinRAR - no version URL responded
|
| set /a BAD+=1
|
| )
|
|
|
| echo ------------------------------------------------------------
|
| echo.
|
| echo Downloaded OK : %OK%
|
| echo Failed : %BAD%
|
| echo.
|
| echo Files in %DEST%:
|
| echo.
|
| dir /b "%DEST%" 2>nul
|
| echo.
|
| echo ------------------------------------------------------------
|
| echo INSTALL ORDER (run each as Administrator):
|
| echo 1. WinRAR - plain Next / Next
|
| echo 2. MariaDB .msi - set a root password, tick "UTF8 as default"
|
| echo keep port 3306, install as a service
|
| echo 3. HeidiSQL - connect to 127.0.0.1 : 3306 with that root password
|
| echo ------------------------------------------------------------
|
| echo.
|
|
|
| choice /c YN /n /m " Open the folder now? [Y/N] "
|
| if %errorlevel% equ 1 start "" explorer.exe "%DEST%"
|
| exit /b 0
|
| |
| |
|
|
|
|
|
|
| :Get
|
| set "URL=%~1"
|
| set "OUT=%~2"
|
| set "LBL=%~3"
|
|
|
| set "HAVE="
|
| if exist "%OUT%" for %%F in ("%OUT%") do if %%~zF GTR 1000000 set "HAVE=1"
|
| if defined HAVE (
|
| echo [SKIP] %LBL% - already downloaded
|
| set /a OK+=1
|
| exit /b 0
|
| )
|
|
|
| echo.
|
| echo [ .. ] %LBL%
|
| if exist "%OUT%.part" del /q "%OUT%.part" >nul 2>&1
|
|
|
| where curl.exe >nul 2>&1
|
| if %errorlevel% equ 0 (
|
| curl.exe -L --fail --retry 3 --retry-delay 3 --connect-timeout 25 --progress-bar -o "%OUT%.part" "%URL%"
|
| ) else (
|
| powershell -NoProfile -ExecutionPolicy Bypass -Command "$ProgressPreference='SilentlyContinue'; [Net.ServicePointManager]::SecurityProtocol=[Net.SecurityProtocolType]::Tls12; try { Invoke-WebRequest -Uri '%URL%' -OutFile '%OUT%.part' -UseBasicParsing } catch { exit 1 }"
|
| )
|
|
|
| if not exist "%OUT%.part" (
|
| echo [FAIL] %LBL% - download failed
|
| set /a BAD+=1
|
| exit /b 1
|
| )
|
| for %%F in ("%OUT%.part") do if %%~zF LSS 100000 (
|
| del /q "%OUT%.part" >nul 2>&1
|
| echo [FAIL] %LBL% - file too small, link probably dead
|
| set /a BAD+=1
|
| exit /b 1
|
| )
|
|
|
| move /y "%OUT%.part" "%OUT%" >nul
|
| echo [ OK ] %LBL%
|
| set /a OK+=1
|
| exit /b 0
|
| |
| |
|
|
|
|
|
|
| :TryWinrar
|
| set "WV=%~1"
|
| set "WURL=https://www.win-rar.com/fileadmin/winrar-versions/winrar/winrar-x64-%WV%.exe"
|
|
|
| where curl.exe >nul 2>&1
|
| if %errorlevel% equ 0 (
|
| curl.exe -sfIL --connect-timeout 15 "%WURL%" >nul 2>&1
|
| if errorlevel 1 exit /b 1
|
| )
|
|
|
| call :Get "%WURL%" "%DEST%\winrar-x64-%WV%.exe" "WinRAR 64-bit (v%WV%)"
|
| exit /b %errorlevel%
|
|
|
