@ECHO OFF
CLS
REM -------------------------------------------------
REM This section evaluates what got passed to CHECK.BAT
REM -------------------------------------------------
IF %1%A==A (
	SET DB=Master
	SET DEVICE=0
	SET SERVER=rds
	SET USER=admin
	SET PASS=secret
	GOTO START_WORK
	)

IF %2%A==A GOTO NO_SERVERNAME
IF %3%A==A GOTO NO_USERNAME
IF %4%A==A GOTO NO_PASSWORD

IF /I %1==master ( SET DEVICE=0
                   SET DB=Master
                   )
IF /I %1==demo   ( SET DEVICE=1
                   SET DB=Demo
                   )
IF /I %1==pros   ( SET DEVICE=2
                   SET DB=Pros
                   )

SET SERVER=%2%
SET USER=%3%
SET PASS=%4%

:START_WORK
@ECHO This batch file checks for errors in Collect! databases.
@ECHO -----------------------------------------------------
@ECHO WARNING!!!
@ECHO.
@ECHO 1. BACKUP YOUR DATABASE BEFORE RUNNING THIS PROGRAM!
@ECHO 2. DO NOT RUN THIS OVER A NETWORK, OR MAPPED DRIVE!
@ECHO 3. YOU HAVE TO RUN THIS FROM A MS-DOS PROMPT!
@ECHO 4. DO NOT STOP THIS ROUTINE WHILE IT IS FIXING YOUR DATABASE!
@ECHO.
@ECHO.
@PAUSE

SET LOG_FILE=%DB%Check.txt
	
@ECHO.
@ECHO *************** RUNNING DATABASE CHECK ** Phase 1 of 1
@ECHO *************** RUNNING DATABASE CHECK ** Phase 1 of 1 >%LOG_FILE% 
@ECHO.

dbcheck -a -p16384 -L %SERVER%;%USER%;%PASS% d0%DEVICE%_collect >>%LOG_FILE%
dbcheck -a -p16384 -L %SERVER%;%USER%;%PASS% d0%DEVICE%_impex >>%LOG_FILE%  
dbcheck -a -p16384 -L %SERVER%;%USER%;%PASS% d0%DEVICE%_nxuser >>%LOG_FILE% 
dbcheck -a -p16384 -L %SERVER%;%USER%;%PASS% d0%DEVICE%_rates >>%LOG_FILE%  
dbcheck -a -p16384 -L %SERVER%;%USER%;%PASS% d0%DEVICE%_report >>%LOG_FILE% 
dbcheck -a -p16384 -L %SERVER%;%USER%;%PASS% w0%DEVICE%_impex >>%LOG_FILE%  
dbcheck -a -p16384 -L %SERVER%;%USER%;%PASS% w0%DEVICE%_report >>%LOG_FILE% 
         
@ECHO.
@ECHO *************** CHECK UTILITY COMPLETE!
@ECHO *************** CHECK UTILITY COMPLETE!  >>%LOG_FILE%
@PAUSE
start notepad.exe %LOG_FILE%
GOTO END

:NO_SERVERNAME
@ECHO No server name specified.
@ECHO check [device] [server name] [username] [password]
GOTO END

:NO_USERNAME
@ECHO No user name specified.
@ECHO check [device] [server name] [username] [password]
GOTO END

:NO_PASSWORD
@ECHO No password specified.
@ECHO check [device] [server name] [username] [password]
GOTO END

:END