mkdir -p /home/csikasz/[DOMAIN]
cd /web/[DOMAIN]/
tar -cpvzf /home/csikasz/[DOMAIN]/stat_folder.tar.gz statisztika

mkdir /home/csikasz/[DOMAIN]/rrd
cp -R /var/lib/awstats/awstats*[STATNAME]* /home/csikasz/[DOMAIN]/rrd
cd /home/csikasz/[DOMAIN]/
tar -cpvzf /home/csikasz/[DOMAIN]/rrd.tar.gz rrd

mkdir /home/csikasz/[DOMAIN]/logs
for x in `ls /web/[DOMAIN]/log | grep -v "htaccess" | grep -v "apache2"` ; do \
cp "/web/[DOMAIN]/log/$x" "/home/csikasz/[DOMAIN]/logs"; \
done
mkdir /home/csikasz/[DOMAIN]/logs/apache2
cp -R "/web/[DOMAIN]/log/apache2" "/home/csikasz/[DOMAIN]/logs/apache2"
#for x in `ls /var/log/apache2 | grep "[DOMAIN]"` ; do \
#cp "/var/log/apache2/$x" "/home/csikasz/[DOMAIN]/logs/apache2"; \
#done
cd /home/csikasz/[DOMAIN]/
tar -cpvzf /home/csikasz/[DOMAIN]/logs.tar.gz logs

tar -cpvzf /home/csikasz/[DOMAIN]/images_uploaded.tar.gz /web/[DOMAIN]/images/uploaded/
tar -cpvzf /home/csikasz/[DOMAIN]/cache.tar.gz /web/[DOMAIN]/cache/

vacuumdb -p 5433 -zf [DBNAME]
nice -n 10 pg_dump_8.1 -i -p 5433 -d -D [DBNAME] > /home/csikasz/[DOMAIN]/database.sql

ssh www "mkdir -p /home/csikasz/[DOMAIN]/"

scp /home/csikasz/[DOMAIN]/rrd.tar.gz www:/home/csikasz/[DOMAIN]/rrd.tar.gz
scp /home/csikasz/[DOMAIN]/logs.tar.gz www:/home/csikasz/[DOMAIN]/logs.tar.gz
scp /home/csikasz/[DOMAIN]/stat_folder.tar.gz www:/home/csikasz/[DOMAIN]/stat_folder.tar.gz
scp /home/csikasz/[DOMAIN]/images_uploaded.tar.gz www:/home/csikasz/[DOMAIN]/images_uploaded.tar.gz
scp /home/csikasz/[DOMAIN]/cache.tar.gz www:/home/csikasz/[DOMAIN]/cache.tar.gz
scp /home/csikasz/[DOMAIN]/database.sql www:/home/csikasz/[DOMAIN]/database.sql

cd /home/csikasz/[DOMAIN]

# Remove dev logs manually

tar -xpvzf logs.tar.gz
cp -R /home/csikasz/[DOMAIN]/logs/* /web/common-sites/web/[DOMAIN]/log
chown -R common-sites.common-sites-web /web/common-sites/web/[DOMAIN]/log/*
find /web/common-sites/web/[DOMAIN]/log/ -type d -exec chmod 2771 {} \;
find /web/common-sites/web/[DOMAIN]/log/ -type f -exec chmod 664 {} \;
find /web/common-sites/web/[DOMAIN]/log/ -type d -iregex '.*\.svn' -exec chown -R csikaszsvn.svnusers {} \;
find /web/common-sites/web/[DOMAIN]/log/ -type d -iregex '.*\.svn.*' -exec chmod 770 {} \;
find /web/common-sites/web/[DOMAIN]/log/ -type f -iregex '.*\.svn.*' -exec chmod 660 {} \;

# Check apache log filenames !!!

tar -xpvzf rrd.tar.gz
cp -R /home/csikasz/[DOMAIN]/rrd/* /var/lib/awstats/[DOMAIN]
chown -R root.root /var/lib/awstats/[DOMAIN]/*
chmod 644 /var/lib/awstats/[DOMAIN]/*

tar -xpvzf stat_folder.tar.gz
cp -R /home/csikasz/[DOMAIN]/statisztika /home/csikasz/[DOMAIN]/statisztika.old
for x in `find /home/csikasz/[DOMAIN]/statisztika -type f -name '*.html'` ; do \
echo "$x"; \
iconv -f "ISO-8859-2" -t "UTF-8" "$x" > "$x.utf8"; \
rm "$x"; \
mv "$x.utf8" "$x"; \
sed -i 's/text\/html; charset=iso-8859-2/text\/html; charset=utf-8/g' $x; \
done

rm -rf "/home/csikasz/[DOMAIN]/statisztika/icon";
rm -rf "/home/csikasz/[DOMAIN]/statisztika/lang";
rm -rf "/home/csikasz/[DOMAIN]/statisztika/lib";
rm -rf "/home/csikasz/[DOMAIN]/statisztika/plugins";
rm -rf "/home/csikasz/[DOMAIN]/statisztika/htaccess";
rm -rf "/home/csikasz/[DOMAIN]/statisztika/datumlista.php";
rm -rf "/home/csikasz/[DOMAIN]/statisztika/datumlista_sess.php";
rm -rf "/home/csikasz/[DOMAIN]/statisztika/index.php";
rm -rf "/home/csikasz/[DOMAIN]/statisztika/index_sess.php";
ln -s "../../../usr/share/awstats/icon" "/home/csikasz/[DOMAIN]/statisztika/icon"
ln -s "../../../usr/share/awstats/lang" "/home/csikasz/[DOMAIN]/statisztika/lang"
ln -s "../../../usr/share/awstats/lib" "/home/csikasz/[DOMAIN]/statisztika/lib"
ln -s "../../../usr/share/awstats/plugins" "/home/csikasz/[DOMAIN]/statisztika/plugins"
ln -s "../../../common/stat/datumlista.php" "/home/csikasz/[DOMAIN]/statisztika/datumlista.php"
ln -s "../../../common/stat/index.php" "/home/csikasz/[DOMAIN]/statisztika/index.php"
ln -s "../../../common/stat/index.php" "/home/csikasz/[DOMAIN]/statisztika/index_sess.php"

for x in `ls /home/csikasz/[DOMAIN]/statisztika` ; \
do \
if test -d "/home/csikasz/[DOMAIN]/statisztika/$x/"; then \
echo "/home/csikasz/[DOMAIN]/statisztika/$x/"; \
rm "/home/csikasz/[DOMAIN]/statisztika/$x/.htaccess"; \
rm "/home/csikasz/[DOMAIN]/statisztika/$x/index.php"; \
rm "/home/csikasz/[DOMAIN]/statisztika/$x/subpage.php"; \
rm -rf "/home/csikasz/[DOMAIN]/statisztika/$x/icon"; \
rm -rf "/home/csikasz/[DOMAIN]/statisztika/$x/lang"; \
rm -rf "/home/csikasz/[DOMAIN]/statisztika/$x/lib"; \
rm -rf "/home/csikasz/[DOMAIN]/statisztika/$x/plugins"; \
ln -s "../icon" "/home/csikasz/[DOMAIN]/statisztika/$x/icon"; \
ln -s "../lang" "/home/csikasz/[DOMAIN]/statisztika/$x/lang"; \
ln -s "../lib" "/home/csikasz/[DOMAIN]/statisztika/$x/lib"; \
ln -s "../plugins" "/home/csikasz/[DOMAIN]/statisztika/$x/plugins"; \
ln -s "../../../../common/stat/datefolders/.htaccess" "/home/csikasz/[DOMAIN]/statisztika/$x/.htaccess"; \
ln -s "../../../../common/stat/datefolders/index.php" "/home/csikasz/[DOMAIN]/statisztika/$x/index.php"; \
ln -s "../../../../common/stat/datefolders/subpage.php" "/home/csikasz/[DOMAIN]/statisztika/$x/subpage.php"; \
fi
done

mv /web/common-sites/web/[DOMAIN]/statisztika /web/common-sites/web/[DOMAIN]/statisztika.old
mkdir /web/common-sites/web/[DOMAIN]/statisztika
#	CHECK PROCESSED STATS DIR
cp -R /home/csikasz/[DOMAIN]/statisztika/* /web/common-sites/web/[DOMAIN]/statisztika
chown -R common-sites.common-sites-src /web/common-sites/web/[DOMAIN]/statisztika
find /web/common-sites/web/[DOMAIN]/statisztika -type d -exec chmod 2571 {} \;
find /web/common-sites/web/[DOMAIN]/statisztika -type f -exec chmod 464 {} \;

/usr/bin/perl /usr/lib/cgi-bin/awstats.pl -config=[DOMAIN] -update >> /var/log/awstats.log
/usr/bin/perl /usr/lib/cgi-bin/awstats.pl -config=[DOMAIN] -output -staticlinks >                /web/common-sites/web/[DOMAIN]/statisztika/2017-12/index.html;
/usr/bin/perl /usr/lib/cgi-bin/awstats.pl -config=[DOMAIN] -output=alldomains -staticlinks >         /web/common-sites/web/[DOMAIN]/statisztika/2017-12/awstats.[DOMAIN].alldomains.html
/usr/bin/perl /usr/lib/cgi-bin/awstats.pl -config=[DOMAIN] -output=allhosts -staticlinks >           /web/common-sites/web/[DOMAIN]/statisztika/2017-12/awstats.[DOMAIN].allhosts.html
/usr/bin/perl /usr/lib/cgi-bin/awstats.pl -config=[DOMAIN] -output=lasthosts -staticlinks >      /web/common-sites/web/[DOMAIN]/statisztika/2017-12/awstats.[DOMAIN].lasthosts.html
/usr/bin/perl /usr/lib/cgi-bin/awstats.pl -config=[DOMAIN] -output=unknownip -staticlinks >      /web/common-sites/web/[DOMAIN]/statisztika/2017-12/awstats.[DOMAIN].unknownip.html
/usr/bin/perl /usr/lib/cgi-bin/awstats.pl -config=[DOMAIN] -output=alllogins -staticlinks >      /web/common-sites/web/[DOMAIN]/statisztika/2017-12/awstats.[DOMAIN].alllogins.html
/usr/bin/perl /usr/lib/cgi-bin/awstats.pl -config=[DOMAIN] -output=lastlogins -staticlinks >     /web/common-sites/web/[DOMAIN]/statisztika/2017-12/awstats.[DOMAIN].lastlogins.html
/usr/bin/perl /usr/lib/cgi-bin/awstats.pl -config=[DOMAIN] -output=allrobots -staticlinks >      /web/common-sites/web/[DOMAIN]/statisztika/2017-12/awstats.[DOMAIN].allrobots.html
/usr/bin/perl /usr/lib/cgi-bin/awstats.pl -config=[DOMAIN] -output=lastrobots -staticlinks >         /web/common-sites/web/[DOMAIN]/statisztika/2017-12/awstats.[DOMAIN].lastrobots.html
/usr/bin/perl /usr/lib/cgi-bin/awstats.pl -config=[DOMAIN] -output=urldetail -staticlinks >      /web/common-sites/web/[DOMAIN]/statisztika/2017-12/awstats.[DOMAIN].urldetail.html
/usr/bin/perl /usr/lib/cgi-bin/awstats.pl -config=[DOMAIN] -output=urlentry -staticlinks >           /web/common-sites/web/[DOMAIN]/statisztika/2017-12/awstats.[DOMAIN].urlentry.html
/usr/bin/perl /usr/lib/cgi-bin/awstats.pl -config=[DOMAIN] -output=urlexit -staticlinks >            /web/common-sites/web/[DOMAIN]/statisztika/2017-12/awstats.[DOMAIN].urlexit.html
/usr/bin/perl /usr/lib/cgi-bin/awstats.pl -config=[DOMAIN] -output=browserdetail -staticlinks >      /web/common-sites/web/[DOMAIN]/statisztika/2017-12/awstats.[DOMAIN].browserdetail.html
/usr/bin/perl /usr/lib/cgi-bin/awstats.pl -config=[DOMAIN] -output=osdetail -staticlinks >           /web/common-sites/web/[DOMAIN]/statisztika/2017-12/awstats.[DOMAIN].osdetail.html
/usr/bin/perl /usr/lib/cgi-bin/awstats.pl -config=[DOMAIN] -output=unknownbrowser -staticlinks >         /web/common-sites/web/[DOMAIN]/statisztika/2017-12/awstats.[DOMAIN].unknownbrowser.html
/usr/bin/perl /usr/lib/cgi-bin/awstats.pl -config=[DOMAIN] -output=unknownos -staticlinks >      /web/common-sites/web/[DOMAIN]/statisztika/2017-12/awstats.[DOMAIN].unknownos.html
/usr/bin/perl /usr/lib/cgi-bin/awstats.pl -config=[DOMAIN] -output=refererse -staticlinks >      /web/common-sites/web/[DOMAIN]/statisztika/2017-12/awstats.[DOMAIN].refererse.html
/usr/bin/perl /usr/lib/cgi-bin/awstats.pl -config=[DOMAIN] -output=refererpages -staticlinks >       /web/common-sites/web/[DOMAIN]/statisztika/2017-12/awstats.[DOMAIN].refererpages.html
/usr/bin/perl /usr/lib/cgi-bin/awstats.pl -config=[DOMAIN] -output=keyphrases -staticlinks >         /web/common-sites/web/[DOMAIN]/statisztika/2017-12/awstats.[DOMAIN].keyphrases.html
/usr/bin/perl /usr/lib/cgi-bin/awstats.pl -config=[DOMAIN] -output=keywords -staticlinks >           /web/common-sites/web/[DOMAIN]/statisztika/2017-12/awstats.[DOMAIN].keywords.html
/usr/bin/perl /usr/lib/cgi-bin/awstats.pl -config=[DOMAIN] -output=errors404 -staticlinks >      /web/common-sites/web/[DOMAIN]/statisztika/2017-12/awstats.[DOMAIN].errors404.html
chown -R common-sites.common-sites-src /web/common-sites/web/[DOMAIN]/statisztika/2017-12
echo "[DOMAIN] (config: [DOMAIN]) end";
date

sed "s/ //g" /home/csikasz/[DOMAIN]/database.sql > /home/csikasz/[DOMAIN]/database_stupid_chars_removed.sql

psql template1 -c "DROP DATABASE [DBNAME];"
psql template1 -c "CREATE DATABASE [DBNAME] WITH OWNER = [DBNAME] ENCODING = 'UTF8' TABLESPACE = pg_default LC_COLLATE = 'hu_HU.UTF-8' LC_CTYPE = 'hu_HU.UTF-8' CONNECTION LIMIT = -1;"
cat /web/common-sites/web/[DOMAIN]/database/init.php 
psql [DBNAME] -U [DBNAME] -c "\i /home/csikasz/[DOMAIN]/database_stupid_chars_removed.sql"
#cat /web/common-sites/web/[DOMAIN]/database/init.php 
#psql [DBNAME] -U [DBNAME] -c "\i /home/csikasz/[DBNAME]/2018-02-01/post_import.sql"

cd /home/csikasz/[DOMAIN]
tar -xpvzf cache.tar.gz
cp -R /home/csikasz/[DOMAIN]/web/[DOMAIN]/cache/* /web/common-sites/web/[DOMAIN]/cache

cd /home/csikasz/[DOMAIN]
tar -xpvzf images_uploaded.tar.gz
cp -R /home/csikasz/[DOMAIN]/web/[DOMAIN]/images/uploaded/* /web/common-sites/web/[DOMAIN]/images/uploaded

/home/csikasz/bin/portal_full_permission_set.sh "[DOMAIN]"
/home/csikasz/bin/svn_folder_perm.sh "[DOMAIN]"
#	NEM KELL for x in `psql template1 -c "\\d" | grep [DBNAME] | grep "table" | awk '{print $3}'`; do echo "$x";psql template1 -c "DROP TABLE $x;";done;
#	NEM KELL for x in `psql template1 -c "\\d" | grep [DBNAME] | grep "sequence" | awk '{print $3}'`; do echo "$x";psql template1 -c "DROP SEQUENCE $x;";done;

#    VHOST FILE COMMENT
#    is_liw DB ben update
#    web mappából törölni