#!/bin/bash
#yum install wget curl -y
echo
current_version=`cat /usr/local/cwpsrv/var/services/pma/README | grep Version | cut -d " " -f 2`
url=`curl -Ss "https://www.phpmyadmin.net/files/" | grep "btn btn-success download_popup" | cut -d " " -f 9 | cut -d "=" -f 2 | sed 's/\"//g'`
echo
new_version=`echo $url | cut -d "/" -f 5`
phpMyAdminZip=$(echo $url | cut -d "/" -f 6)
phpMyAdmin=$(basename $(echo $url | cut -d "/" -f 6) .zip)
Date=`date "+%d-%m-%Y"`
current_version_1=`echo $current_version | cut -d "." -f 1`
current_version_2=`echo $current_version | cut -d "." -f 2`
current_version_3=`echo $current_version | cut -d "." -f 3`
new_version_1=`echo $new_version | cut -d "." -f 1`
new_version_2=`echo $new_version | cut -d "." -f 2`
new_version_3=`echo $new_version | cut -d "." -f 3`

if [ $new_version_1 -ge $current_version_1 ];then
	if [ $new_version_2 -ge $current_version_2 ];then
		if [ $new_version_3 -eq $current_version_3 ];then
			echo "################################"
			echo "phpMyAdmin is already up-to-date"
			echo "################################"
		else
			echo "Updating phpMyAdmin to version $new_version"
			mv /usr/local/cwpsrv/var/services/pma /usr/local/cwpsrv/var/services/pma_$Date.bak
			cd /usr/local/cwpsrv/var/services/
			wget $url
			unzip $phpMyAdminZip

			if [ "$phpMyAdminZip" != "/" ];then
				rm -rf $phpMyAdminZip
			fi

			mv $phpMyAdmin pma
			chown -R cwpsvc:cwpsvc pma
			rm -rf /usr/local/cwpsrv/var/services/pma/setup
			mv /usr/local/cwpsrv/var/services/pma/config.sample.inc.php /usr/local/cwpsrv/var/services/pma/config.inc.php
			ran_password=$(</dev/urandom tr -dc A-Za-z0-9 | head -c32)
			sed -i "s|\['blowfish_secret'\] = ''|\['blowfish_secret'\] = '${ran_password}'|" /usr/local/cwpsrv/var/services/pma/config.inc.php
			#service httpd restart
			echo "####################################"
			echo "phpMyAdmin is updated to new version"
			echo "####################################"
		fi
	fi
fi
