#!/bin/sh

# webcalendar postinstall script
# required parameters: dbname, dbuser, dbpasswd, admin_email, admin_login, admin_passwd
#
#
# here is also some standard parameters, that must be specified:
# vhost_path - full path to vhost root directory
# domain_name - name of domain
# install_prefix - path of application inside vhost directory
# ssl_target_directory - true, if application is in httpsdocs

check_standard_parameters()
{
	if [ "X${vhost_path}" = "X" ]; then
		echo "postinstall: no vhost_path parameter specified for application"
		exit 1
	fi
	if [ "X${domain_name}" = "X" ]; then
		echo "postinstall: no domain_name parameter specified for application"
		exit 1
	fi
	if [ "X${install_prefix}" = "X" ]; then
		echo "postinstall: no install_prefix parameter specified for application"
		exit 1
	fi
	if [ "X${ssl_target_directory}" = "X" ]; then
		echo "postinstall: no ssl_target_directory parameter specified for application"
		exit 1
	fi
};

edit_conf_file()
{
	regexp1="s/@@DB_USER@@/${dbuser}/g"
	regexp2="s/@@DB_PASSWD@@/${dbpasswd}/g"
	regexp3="s/@@DB_NAME@@/${dbname}/g"
	sed -e "${regexp1}" -e "${regexp2}" -e "${regexp3}" $1 >${vhost_path}/${documents_directory}/${install_prefix}/includes/settings.php
};

edit_mysql_datafile()
{
	regexp1="s/@@USERNAME@@/${admin_login}/g"
	regexp2="s/@@PASSWORD@@/${admin_passwd}/g"
	
	sed -e "${regexp1}" -e "${regexp2}" $1 > ${vhost_path}/${documents_directory}/${install_prefix}/tables-mysql.dist.sql
	mv -f ${vhost_path}/${documents_directory}/${install_prefix}/tables-mysql.dist.sql ${vhost_path}/${documents_directory}/${install_prefix}/tables-mysql.sql 
};

parse_standard_parameters()
{
	if [ "X${ssl_target_directory}" = "Xtrue" ]; then
		proto="https"
		documents_directory="httpsdocs"
	else
		proto="http"
		documents_directory="httpdocs"
	fi
};

read_conf()
{
	if test -r /etc/psa/psa.conf; then
		while read var val; do
			case "$var" in
				[A-Z]*) eval "$var"='"$val"';;
			esac; 
		done </etc/psa/psa.conf
	else
		echo /etc/psa/psa.conf not found
		exit 1
	fi
}



var=`cat | awk '{
	eqpos=index($0, "=");
	if (eqpos>1) {
		var=substr($0, 1, eqpos-1);
		val=substr($0, eqpos+1);

		tmp="[\x5c\x5c]";
		tmp2="\x5c\x5c\x5c\x5c";
		gsub(tmp,tmp2,val);


		tmp2="\x5c\x5c\x5c\x22";
		gsub("\"",tmp2,val);
		print var "=\"" val "\"";
	};
}'`

eval $var

# now we have full set of parameters, stored in variables

read_conf
check_standard_parameters
parse_standard_parameters


cd ${vhost_path}/${documents_directory}/${install_prefix}

webcalendar_config=${vhost_path}/${documents_directory}/${install_prefix}/includes/settings.php.orig
mysql_schema=${vhost_path}/${documents_directory}/${install_prefix}/tables-mysql.sql

edit_conf_file ${webcalendar_config}
edit_mysql_datafile ${mysql_schema}

${MYSQL_BIN_D}/mysql -u${dbuser} -p${dbpasswd} ${dbname} < ${mysql_schema}

#echo "INSERT INTO webcal_user ( cal_login, cal_passwd, cal_lastname, cal_firstname, cal_is_admin ) VALUES ( '${admin_login}', '${admin_passwd}', 'Administrator', 'Default', 'Y' );" > ${vhost_path}/${documents_directory}/${install_prefix}/insert_admin.sql

#${MYSQL_BIN_D}/mysql -u${dbuser} -p${dbpasswd} ${dbname} < ${vhost_path}/${documents_directory}/${install_prefix}/insert_admin.sql

#rm -rf insert_admin.sql
echo "php_flag magic_quotes_gpc On" >>.htaccess

exit 0
