#!/bin/sh
KEYWORD=WordPress
PKGPATH=/usr/local/zy-pkgs
ADMINPATH=/i-data/md0/admin/zy-pkgs
MYSQLPATH=/usr/local/zy-pkgs/mysql/bin

# restore WordPress DB if exists
if [ -f $PKGPATH/backup/$KEYWORD/$KEYWORD.tgz ]; then
	cd $PKGPATH/mysql/var
	mv $KEYWORD tmpDB
	tar zxvf $PKGPATH/backup/$KEYWORD/$KEYWORD.tgz
	rm -rf tmpDB
fi

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

if `test -d $PKGPATH/backup/$KEYWORD/themes`; then
	mv $PKGPATH/gui/$KEYWORD/wp-content/themes $PKGPATH/gui/$KEYWORD/wp-content/themes.bak
	mv $PKGPATH/backup/$KEYWORD/themes $PKGPATH/gui/$KEYWORD/wp-content/themes
	if [ $? -ne 0 ]; then
		mv $PKGPATH/gui/$KEYWORD/wp-content/themes.bak $PKGPATH/gui/$KEYWORD/wp-content/themes
	else
		if [ -f $PKGPATH/mysql/var/$KEYWORD/wp_Version ]; then
			rm -rf $PKGPATH/gui/$KEYWORD/wp-content/themes.bak
		else
			rm -rf $PKGPATH/gui/$KEYWORD/wp-content/themes
			mv $PKGPATH/gui/$KEYWORD/wp-content/themes.bak $PKGPATH/gui/$KEYWORD/wp-content/themes
		fi
	fi
fi

if `test -d $PKGPATH/backup/$KEYWORD/uploads`; then
	mv $PKGPATH/gui/$KEYWORD/wp-content/uploads $PKGPATH/gui/$KEYWORD/wp-content/uploads.bak
	mv $PKGPATH/backup/$KEYWORD/uploads $PKGPATH/gui/$KEYWORD/wp-content/uploads
	if [ $? -ne 0 ] ; then
		mv $PKGPATH/gui/$KEYWORD/wp-content/uploads.bak $PKGPATH/gui/$KEYWORD/wp-content/uploads
	else
		rm -rf $PKGPATH/gui/$KEYWORD/wp-content/uploads.bak
	fi
fi

# move /usr/local/zy-pkgs/backup/WordPress/plugins, /themes, /uploads to /usr/local/zy-pkgs/gui/WordPress/wp-content/plugins, /themes, /uploads
if `test -d $PKGPATH/backup/$KEYWORD/plugins`; then
  #back up new plugins 
	mv $PKGPATH/gui/$KEYWORD/wp-content/plugins $PKGPATH/gui/$KEYWORD/wp-content/plugins.bak
	#bak up old plugins to new place
	mv $PKGPATH/backup/$KEYWORD/plugins $PKGPATH/gui/$KEYWORD/wp-content/plugins
	#no back up data
	if [ $? -ne 0 ]; then
		#new		
		mv $PKGPATH/gui/$KEYWORD/wp-content/plugins.bak $PKGPATH/gui/$KEYWORD/wp-content/plugins
	else		
		if [ -f $PKGPATH/mysql/var/$KEYWORD/wp_Version ]; then
			rm -rf $PKGPATH/gui/$KEYWORD/wp-content/plugins.bak
		else	
			rm -rf $PKGPATH/gui/$KEYWORD/wp-content/plugins
			mv $PKGPATH/gui/$KEYWORD/wp-content/plugins.bak $PKGPATH/gui/$KEYWORD/wp-content/plugins
			
			$MYSQLPATH/mysqlcheck -uzypackage -p1234 --auto-repair --check --optimize --all-databases
			# add hei plugin colum
			RESULT=`/usr/local/zy-pkgs/mysql/bin/mysql -D WordPress -u root --password=1234 -e "SELECT MAX(option_id) from wp_options"`
			MAXID=`echo $RESULT | awk '{print $2}'`
			MAXID=$(($MAXID+1))			
			/usr/local/zy-pkgs/mysql/bin/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;}','')"
			python /usr/local/zy-pkgs/zypkg_conf/info/WordPress.update_WPDB3.py
		fi
		
	fi
fi

#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
if [ -d /usr/local/apache/htdocs/zyxel/ ]; then
	IPADDR=/zyxel/pkg/WordPress/
else
	IPADDR=/adv,/pkg/WordPress/
fi
/usr/local/zy-pkgs/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';"			

#make the folder in /i-data/md0/admin
mkdir $ADMINPATH/$KEYWORD

mkdir $ADMINPATH/$KEYWORD/plugins
mkdir $ADMINPATH/$KEYWORD/themes
mkdir $ADMINPATH/$KEYWORD/uploads

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

# mount bind from /usr/local/zy-pkgs to /i-data/md0/admin
mount --bind $PKGPATH/gui/$KEYWORD/wp-content/plugins $ADMINPATH/$KEYWORD/plugins
mount --bind $PKGPATH/gui/$KEYWORD/wp-content/uploads $ADMINPATH/$KEYWORD/uploads
mount --bind $PKGPATH/gui/$KEYWORD/wp-content/themes $ADMINPATH/$KEYWORD/themes

$MYSQLPATH/mysqlcheck -uzypackage -p1234 --auto-repair --check --optimize --all-databases

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