#!/bin/bash
set -e
user="moffy"
passwd="oscerciv"
db="moffy"
mysqladmin -uroot -p create $db
echo "GRANT ALL ON $db.* TO '$user@localhost' IDENTIFIED BY '$passwd' WITH GRANT OPTION;" | mysql -uroot -p
#mysql -u$user -p$passwd $db < $basedir/sql/publish.sql
dbstring="INSERT INTO eZUser_User VALUES (1,'$user',password('$passwd'),'$user@$domain','admin','user','false','',0,0);"
cat $basedir/sql/publish.sql | sed "s/^INSERT INTO eZUser_User VALUES.*\$/$dbstring/" | mysql -u$user -p$passwd $db
su $user -c "zcat $basedir/data.tar.gz | tar -xv -C $basedir"
mysql -u$user -p$passwd $db < $basedir/sql/data.sql
#su $user -c "cd $basedir && ./modfix.sh"
#su $user -c "cd $basedir && ./secure_clearcache.sh"
#su $user -c "echo \"
#RewriteEngine On
#RewriteRule ^/stats/store/(.*).gif\\\$ $basedir/ezstats/user/storestats.php [S=2]
#RewriteRule ^/filemanager/filedownload/([^/]+)/(.*)\\\$ $basedir/ezfilemanager/files/\\\$1 [T=\\\"application/oct-stream\\\",S=1]
#RewriteRule \!\.(gif|css|jpg|png)\\\$ $basedir/index.php
#\" > $basedir/.htaccess"
#su $user -c "echo \"
#RewriteEngine On
#RewriteRule \!\.(gif|css|jpg|png)\\\$ $basedir/index_admin.php
#\" > $adminbasedir/.htaccess"
su $user -c "
cd $basedir
./modfix.sh
./secure_modfix.sh $user $group
./clearcache.sh
./secure_clearcache.sh
cat site.ini | sed 's/^SiteURL=publish.ez.no\$/SiteURL=$host/' > site.ini.tmp && mv site.ini.tmp site.ini
cat site.ini | sed 's/^Database=publish\$/Database=$db/' > site.ini.tmp && mv site.ini.tmp site.ini
cat site.ini | sed 's/^User=publish\$/User=$user/' > site.ini.tmp && mv site.ini.tmp site.ini
cat site.ini | sed 's/^Password=publish\$/Password=$passwd/' > site.ini.tmp && mv site.ini.tmp site.ini
cat site.ini | sed 's/^Database=publish\$/Database=$db/' > site.ini.tmp && mv site.ini.tmp site.ini
"
echo "
ServerName $host
ServerAdmin $user@$domain
DocumentRoot $basedir
user $user
group $group
php_flag magic_quotes_gpc off
RewriteEngine On
RewriteRule ^/stats/store/(.*).gif\$ $basedir/ezstats/user/storestats.php [S=2]
RewriteRule ^/filemanager/filedownload/([^/]+)/(.*)\$ $basedir/ezfilemanager/files/\$1 [T="application/oct-stream",S=1]
RewriteRule !\.(gif|css|jpg|png)\$ $basedir/index.php
ServerName $adminhost
ServerAdmin $user@$domain
DocumentRoot $basedir
user $user
group $group
php_flag magic_quotes_gpc off
RewriteEngine On
RewriteRule !\.(gif|css|jpg|png)\$ $basedir/index_admin.php
" > $webcfg
echo "Remember to reload Apache..."