@echo off
if "%1" == "" goto usage
echo.
echo Inserting images into pubs database on server %1
textcopy -I -Usa -P%2 -S%1 -Dpubs -Tpub_info -Clogo -W"where pub_id = '1389'" -Falgodata.bmp
textcopy -I -Usa -P%2 -S%1 -Dpubs -Tpub_info -Clogo -W"where pub_id = '0877'" -Fbinnet.bmp
textcopy -I -Usa -P%2 -S%1 -Dpubs -Tpub_info -Clogo -W"where pub_id = '9901'" -Fgggg.bmp
textcopy -I -Usa -P%2 -S%1 -Dpubs -Tpub_info -Clogo -W"where pub_id = '1622'" -F5lakes.bmp
textcopy -I -Usa -P%2 -S%1 -Dpubs -Tpub_info -Clogo -W"where pub_id = '0736'" -Fnewmoon.bmp
textcopy -I -Usa -P%2 -S%1 -Dpubs -Tpub_info -Clogo -W"where pub_id = '9999'" -Flucerne.bmp
textcopy -I -Usa -P%2 -S%1 -Dpubs -Tpub_info -Clogo -W"where pub_id = '1756'" -Framona.bmp
textcopy -I -Usa -P%2 -S%1 -Dpubs -Tpub_info -Clogo -W"where pub_id = '9952'" -Fscootney.bmp
echo Image update complete!
echo.
goto done
:usage
echo.
echo Usage: pubimage ServerName [SAPassword]
echo.
:done