#!/bin/sh

#backup MySQL before running this script

SITE_LIST=''
iPath=/www/20060309-120243-opals/htdocs/theme/opals/image
opalsCurrent=20060602-133336-opals
opalsRoot=/www/$opalsCurrent
service=/sbin/service
#$service httpd stop

#cd /www
#\rm -f opals
#ln -s $opalsCurrent opals


echo -n "Enter SQL root password: "
read -s sqlroot
echo
for i in $SITE_LIST; do
    echo -n "Update SQL database for $i... "
    mysql -uroot -p$sqlroot $i < $opalsRoot/install/update.sql
    mysql -uroot -p$sqlroot $i < $opalsRoot/install/opl_file.sql
    echo done.
done


cd $opalsRoot/script/update/
for i in $SITE_LIST; do
    echo -n "Create SQL-update scripts for $i... "
    cp -p itemInfo.ztest itemInfo.$i
    perl -pi -e "s/ztest/$i/g" itemInfo.$i
    cp -p itemTypeParam.ztest itemTypeParam.$i
    perl -pi -e "s/ztest/$i/g" itemTypeParam.$i
    echo done.
done


for i in $SITE_LIST; do
    echo -n "Update SQL database (item info) for $i... "
    $opalsRoot/script/update/itemInfo.$i > $opalsRoot/log/update_itemInfo.$i.log 2>&1
    echo done.
done


for i in $SITE_LIST; do
    echo -n "Update SQL database (item type parameters) for $i... "
    $opalsRoot/script/update/itemTypeParam.$i > $opalsRoot/log/update_itemTypeParam.$i.log 2>&1
    echo done.
done


for i in $SITE_LIST; do
    echo -n "Update configuration file for $i... "
    echo imex=/data/opals >> /etc/opals/conf/$i
    echo done.
done

if [ ! -d /etc/opals/script/site ]; then
    mkdir -p /etc/opals/script/site
fi
for i in $SITE_LIST; do
    echo -n "Update cron script for $i... "
    cp -p /tmp/ztest /etc/opals/script/site/$i
    perl -pi -e "s/ztest/$i/g" /etc/opals/script/site/$i
    echo done.
done

$service httpd start

#for i in `grep '^    ServerName' /etc/httpd/conf/httpd.conf | grep -v dummyhost | sort | uniq | cut -d ' ' -f6`; do
#    echo -n "Restore logo for $i... "
#    wget -q http://$i/bin/.update/setlogo?iPath=$iPath -O dummyfile
#    echo done.
#done

exit 0