#!/bin/sh
KEYWORD=WordPress
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
WPINSTPATH=`grep "WordPress" /etc/zyxel/pkg_conf/status |grep "Installed-Rule" |awk -F":" '{print $2}' |sed 's/\/$//g' |sed 's/ //g'`
BACKUP_PATH=/i-data/.system/zy-pkgs/tmp/PKG_Backup
WPDB=${PHPMYSQLPATH}/mysql/data
PKGGUIPATH="/i-data/.system/zy-pkgs/pkggui"

if [ -d $BACKUP_PATH/$KEYWORD ]; then
	cp -a $BACKUP_PATH/$KEYWORD/plugins $WPINSTPATH/gui/$KEYWORD/wp-content/
	cp -a $BACKUP_PATH/$KEYWORD/themes $WPINSTPATH/gui/$KEYWORD/wp-content/
	cp -a $BACKUP_PATH/$KEYWORD/uploads $WPINSTPATH/gui/$KEYWORD/wp-content/
	cp -a $BACKUP_PATH/$KEYWORD/$KEYWORD $PHPMYSQLPATH/mysql/data
	rm -rf $BACKUP_PATH/$KEYWORD
else
	cp -a ${WPINSTPATH}/mysql/var/WordPress ${WPDB}
fi

chmod -R 777 $WPINSTPATH/mysql/var/
chmod -R 777 $WPINSTPATH/gui/$KEYWORD/themes/

#reset siteurl and home ip address in wp DB
EXIP=`/usr/local/upnp/getExtIpAddr.sh`
if [ "$EXIP" != "" ] ; then
	IPADDR=$EXIP
else
	IPADDR=`ifconfig egiga0 | grep "inet addr" | tr -s ' ' | cut -d ' ' -f 3 | cut -d ':' -f 2`
fi

${PHPMYSQLPATH}/mysql/bin/mysql -D WordPress -u root --password=1234 -e "UPDATE wp_options SET option_value='$IPADDR' where option_name='siteurl';UPDATE wp_options SET option_value='$IPADDR' where option_name='home';"			

if [ -e $MYSQLPATH/mysqlcheck ]; then			
#	$MYSQLPATH/mysqlcheck -uzypackage -p1234 --auto-repair --check --optimize --all-databases
	$MYSQLPATH/myisamchk --silent --force --fast --update-state $WPDB/$KEYWORD/*MYI
	# add hei plugin colum
	RESULT=`$MYSQLPATH/mysql -D WordPress -u root --password=1234 -e "SELECT MAX(option_id) from wp_options"`
	MAXID=`echo $RESULT | awk '{print $2}'`
	MAXID=$(($MAXID+1))			
	$MYSQLPATH/mysql -D WordPress -u root --password=1234 -e "INSERT INTO wp_options(option_id,blog_id,option_name,option_value,autoload) VALUES($MAXID,0,'HeiVGallery3PP','a:6:{s:7:\"g3_host\";s:0:\"\";s:15:\"g3_guest_access\";s:4:\"true\";s:7:\"g3_user\";s:0:\"\";s:18:\"g3_ticket_rest_api\";s:0:\"\";s:14:\"g3_valid_skins\";a:4:{i:0;s:10:\"single_img\";i:1;s:13:\"smoothgallery\";i:2;s:9:\"jcarousel\";i:3;s:3:\"dir\";}s:13:\"registry_tree\";b:0;}','')"
else
	sleep 10
#	$MYSQLPATH/mysqlcheck -uzypackage -p1234 --auto-repair --check --optimize --all-databases
	$MYSQLPATH/myisamchk --silent --force --fast --update-state $WPDB/$KEYWORD/*MYI
	# add hei plugin colum
	RESULT=`$MYSQLPATH/mysql -D WordPress -u root --password=1234 -e "SELECT MAX(option_id) from wp_options"`
	MAXID=`echo $RESULT | awk '{print $2}'`
	MAXID=$(($MAXID+1))			
	$MYSQLPATH/mysql -D WordPress -u root --password=1234 -e "INSERT INTO wp_options(option_id,blog_id,option_name,option_value,autoload) VALUES($MAXID,0,'HeiVGallery3PP','a:6:{s:7:\"g3_host\";s:0:\"\";s:15:\"g3_guest_access\";s:4:\"true\";s:7:\"g3_user\";s:0:\"\";s:18:\"g3_ticket_rest_api\";s:0:\"\";s:14:\"g3_valid_skins\";a:4:{i:0;s:10:\"single_img\";i:1;s:13:\"smoothgallery\";i:2;s:9:\"jcarousel\";i:3;s:3:\"dir\";}s:13:\"registry_tree\";b:0;}','')"
fi

chmod -R 777 $WPINSTPATH/gui/$KEYWORD/wp-content/plugins/
chmod -R 777 $WPINSTPATH/gui/$KEYWORD/wp-content/uploads/
chmod -R 777 $WPINSTPATH/gui/$KEYWORD/wp-content/themes/

$WPINSTPATH/etc/init.d/$KEYWORD disable

#Hank add to copy GUI
if [ -e ${PKGGUIPATH}/${KEYWORD} ]; then
	cp -af ${WPINSTPATH}/gui/${KEYWORD}_gui/* ${PKGGUIPATH}/${KEYWORD}
else
	cp -af ${WPINSTPATH}/gui/${KEYWORD}_gui ${PKGGUIPATH}/${KEYWORD}
fi

#Add the portal cmd
/usr/local/upnp/install_upnpDB.sh WORDPRESS_HTTP 5000 'http://ip:port/pkg/WordPress/' 'This allows you to create and manage a blog. Use the NAS administrator credentials to log in. The administrator can then create accounts for other users.'
/usr/local/upnp/install_upnpDB.sh WORDPRESS_HTTPS 5001 'https://ip:port/pkg/WordPress/' 'This allows you to create and manage a blog. Use the NAS administrator credentials to log in. The administrator can then create accounts for other users.'

#Hank add to create the link to call PKG startrp and shutdown script
rm /i-data/.system/zy-pkgs/WordPress
ln -sf $WPINSTPATH/etc/init.d/WordPress /i-data/.system/zy-pkgs/WordPress

