#!/bin/sh
HTTPCONF=/etc/pkg_service_conf/httpd2.conf
TMPCONF=/etc/pkg_service_conf/httpd2.conf.bak
PKGCONF=/etc/pkg_service_conf/WordPress.conf
TMPPKGCONF=/etc/pkg_service_conf/WordPress.conf.bak
KEYWORD=WordPress
WPINSTPATH=`grep "WordPress" /etc/zyxel/pkg_conf/status |grep "Installed-Rule" |awk -F":" '{print $2}' |sed 's/\/$//g' |sed 's/ //g'`
PHPMYSQLPATH=`grep "PHP-MySQL-phpMyAdmin" /etc/zyxel/pkg_conf/status |grep "Installed-Rule" |awk -F":" '{print $2}' |sed 's/\/$//g' |sed 's/ //g'`
MYSQLPATH=${PHPMYSQLPATH}/mysql/bin
BACKUP_PATH=/i-data/.system/zy-pkgs/tmp/PKG_Backup

rm -rf /etc/pkg_service_conf/WordPress.conf

dobackup() {	
	# backup the /plugins, /themes and /uploads to /usr/local/zy-pkgs/backup/WordPress
	mkdir -p $BACKUP_PATH/$KEYWORD
	cp -a $WPINSTPATH/gui/$KEYWORD/wp-content/plugins $BACKUP_PATH/$KEYWORD/
	cp -a $WPINSTPATH/gui/$KEYWORD/wp-content/themes $BACKUP_PATH/$KEYWORD/
	cp -a $WPINSTPATH/gui/$KEYWORD/wp-content/uploads $BACKUP_PATH/$KEYWORD/
	cp -a $PHPMYSQLPATH/mysql/data/$KEYWORD $BACKUP_PATH/$KEYWORD/
}

if [ -e /tmp/PKGUPGRADE.WordPress ]; then
	dobackup
fi

# remove "WordPress" in AuthZyxelSkipPattern
sed 's/ \/WordPress / /' $HTTPCONF > $TMPCONF
mv $TMPCONF $HTTPCONF

# remove the line which contains "WordPress" in httpd_package2.conf
RESULT=`grep -n $KEYWORD /etc/pkg_service_conf/httpd_package2.conf |awk -F":" '{print $1}'`

if [ "$RESULT" != "" ] ; then
	STR="`echo ${RESULT}`d"
	sed $STR /etc/pkg_service_conf/httpd_package2.conf > /etc/pkg_service_conf/httpd_package2.conf.bak
	mv /etc/pkg_service_conf/httpd_package2.conf.bak /etc/pkg_service_conf/httpd_package2.conf
fi

touch /tmp/restart_httpd

#Remove the pkg of portal DB
/usr/local/upnp/remove_upnpDB.sh WORDPRESS_HTTP
/usr/local/upnp/remove_upnpDB.sh WORDPRESS_HTTPS

$MYSQLPATH/mysql -D $KEYWORD -u zyadmin --password=1234 -e "DROP DATABASE $KEYWORD"

cd $WPINSTPATH
lsof -n | grep $KEYWORD | grep -v $KEYWORD.prerm | awk -F' ' '{print $2}' > /tmp/PKG_UMNT_CHECK
if [ "$?" = "0" ]; then
	cat /tmp/PKG_UMNT_CHECK | ( while read ZZZ ; do
		kill -9 $ZZZ
	done )
fi
sleep 2

rm /tmp/PKG_UMNT_CHECK
