###########################################################
if [ $EUID -ne 0 ]
then
    echo Aborted: Only root can add a site.
    exit -1
fi
############################################################

# Source global settings
if [ -f /etc/opals/opalsrc ]
then
    . /etc/opals/opalsrc
else
    echo ERROR: /etc/opals/opalsrc not found.
    exit -2
fi
############################################################

function checkSqlAdminLogin() {
    testFile=$opals_www/$opals_link/install/sql/test.sql

    echo -n 'Check SQL login... '
    mysql -h$sql_server_host -u$sql_addsite_user -p$sql_addsite_pass < $testFile
    if [ $? -ne 0 ]
    then
        echo $abort_msg
        exit $ERROR_INVALID_SQL_ROOT_PASSWD
    fi

    echo OK.
}



for site  in  `ls /etc/opals/conf`  ;
do 
    u=$(grep "type=union" /etc/opals/conf/$site) ;
    if [ -z $u ] ;then 
    a=$(mysql -u$sql_addsite_user -p$sql_addsite_pass -h$sql_server_host -e "select val from opl_preference where var = 'slipPrinter' && val=1" $site);
    if [[ $a =~  val ]]; then 
        url=$(grep $site /etc/httpd/conf.d/opals/*|grep SetEnv); 
        url=$(echo $url | sed 's/\/.*d.opals\///' |sed 's/.conf: SetEnv OP.*//');
        email=$(mysql -u$sql_addsite_user -p$sql_addsite_pass  -h$sql_server_host  -e "select val from opl_preference where var='emailAddress'" $site);
        libName=$(mysql -u$sql_addsite_user -p$sql_addsite_pass  -h$sql_server_host  -e "select val from opl_preference where var='libname'" $site);

        email=$(echo $email | sed 's/val //');
        libName=$(echo $libName | sed 's/val //');
        echo -e "Library: $libName\nURL:\t $url\nEmail:\t $email\n\n" ;
    fi;
    fi;
done;