#!/bin/bash

if [ -z "$1" ]; then
	echo "Error: Please provide domain name as argument."
	echo ""
	echo "Usage $0 [Domain-Name]"
	exit 22;
fi

#Query the plesk database
dboutput=$(plesk db "select d.name,h.php_handler_id,s.login from domains d join hosting h on h.dom_id=d.id join sys_users s on s.id=h.sys_user_id")

#Search for the corresponding enty
row=$(echo "$dboutput" | grep "$1")

if [ $? -ne 0 ]; then
	echo "Domain '$1' not found. Please enter a valid domain name."
	exit 2;
fi

if [ $(echo "$dboutput" | grep -c "$1") -ne 1 ];then
	echo "Your given domain name '$1' is ambigous. Please be more specific."
	exit 1;
fi

php_handler_id=$(echo "$row" | awk -F'|' '{print $3}')

phpVersion=$(echo $php_handler_id | grep -o '[0-9]\+')
phpVersion=${phpVersion:0:1}.${phpVersion:1}

echo $phpVersion