#!/usr/bin/perl -w

use File::Path;

my %params;
my %psa_params;
my @imp_params = qw( vhost_path domain_name install_prefix ssl_target_directory  dbuser dbpasswd dbname admin_email admin_login admin_passwd );
my $is_error=0;

sub print_out
{
	my ($text) = @_;
	print STDERR $text;
}

sub check_parameter
{
    my ($param) = @_;
    unless (defined $params{$param}){
        return 0;
    } else {
        return 1;
    }
}
sub modify_file
{
    my ($fname, $fparams) = @_;

    unless (open F, $fname){
        print_out "postinstall: can't open file `$fname` for reading\n";
        return 0;
    }

    my $file_content;
    while (<F>){
        $file_content .= $_;
    }
    close F;

    my ($k,$v);
    while (($k,$v)=each(%$fparams)){
        $file_content =~ s/\@\@${k}\@\@/$v/g;
    }

    unless (open F, ">$fname"){
        print_out "postinstall: can't open file `$fname` for writing\n";
        return 0;
    }
    print F $file_content;
    close F;
    return 1;
}
sub mysql_quote
{
    my ($qstr) = @_;
    # replace ' for \'
    # replace \ for \\
    $qstr =~ s/\\/\\\\/g;
    $qstr =~ s/'/\\'/g;
    return $qstr;
}
sub php_quote
{
    my ($qstr) = @_;
    # replace ' for \'
    # replace \ for \\
    $qstr =~ s/\\/\\\\/g;
    $qstr =~ s/'/\\'/g;
    return $qstr;
}
sub shell_quote
{
    my ($qstr) = @_;
    # replace ' for \'
    # replace \ for \\
    $qstr =~ s/\\/\\\\/g;
    $qstr =~ s/"/\\\"/g;
    $qstr =~ s/\$/\\\$/g;
    return $qstr;
}

# parse input to hash
while (<STDIN>){
    my ($k,$v);
    if (/^([^=]+)=(.+)$/){
        $v = $2;
        chomp $v;
        $k = $1;
        $params{"$k"} = $v;
        print_out $_;
    }
}

# parse plesk config file

open PSACONF, '/etc/psa/psa.conf';
print_out "opening psa config\n";
while (<PSACONF>){
    chomp;
    unless (/^#/){
        if (/^(\s*[_a-zA-Z]+)\s+(.+?)\s*$/){
            # print "$1 : $2\n";
            $psa_params{$1} = $2;
        }
    }
}
close PSACONF;

# check important parameters
foreach (@imp_params){
    unless (check_parameter($_)){
        print_out "postinstall: no parameter $_ specified for application\n";
        $is_error = 1;
    }
}
if ($is_error){
    exit 1;
}

# remote DB checking
my ($dbhost, $dbport, $dbremote_params, $dbhostport);
$dbremote_params = '';
$dbhost = 'localhost';
$dbhostport = $dbhost;

if (defined $params{'dbhost'} && $params{'dbhost'} ne '') {
    my ($m_dbhost, $m_dbport);

    $dbhost = $params{'dbhost'};
    $m_dbhost = shell_quote($dbhost);
    $dbremote_params = " --host=\"${m_dbhost}\" ";
    $dbhostport = $dbhost;

    if (defined $params{'dbport'} && $params{'dbport'} ne '') {
        $dbport = $params{'dbport'};
        $dbhostport .= ":${dbport}";
        $m_dbport = shell_quote($dbport);
        $dbremote_params .= " --port=\"${m_dbport}\" ";
    }
}



my $ssl_enable;
my $documents_directory;
if ($params{'ssl_target_directory'} eq 'true'){
    $documents_directory = 'httpsdocs';
    $ssl_enable = "1";
} else {
    $documents_directory = 'httpdocs';
    $ssl_enable = "0";
}

my $root_dir = $params{'vhost_path'}.'/'.$documents_directory.'/'.$params{'install_prefix'};
my $config_file = "${root_dir}/config.php";

# generate config file
unless (open CONFIG, ">${config_file}"){
	print_out "unable to open file `${config_file}` for writing\n";
	exit 1;
}
print CONFIG "<?php\n";
print CONFIG "\$dbms = 'mysql';\n";
print CONFIG "\$dbhost = '${dbhostport}';\n";
print CONFIG "\$dbname = '".php_quote($params{'dbname'})."';\n";
print CONFIG "\$dbuser = '".php_quote($params{'dbuser'})."';\n";
print CONFIG "\$dbpasswd = '".php_quote($params{'dbpasswd'})."';\n";
print CONFIG "\$table_prefix = 'phpbb_';\n";
print CONFIG "define('PHPBB_INSTALLED', true);\n?>";
close CONFIG;

# import initial database
my $sql_schema_file = "${root_dir}/schema.sql";


my %sql_params = (
	'USERNAME' => mysql_quote($params{'admin_login'}),
	'PASSWORD' => mysql_quote($params{'admin_passwd'}),
	'EMAIL' => mysql_quote($params{'admin_email'}),
	'DOMAIN_NAME' => mysql_quote($params{'domain_name'}),
	'INSTALL_PREFIX' => mysql_quote($params{'install_prefix'}),
	'SSL_ENABLE' => mysql_quote($ssl_enable),
	'SITE_DESC' => ''
);

if (defined $params{'site_desc'}){
	$sql_params{'SITE_DESC'} = $params{'site_desc'};
}

unless (modify_file($sql_schema_file, \%sql_params)){
	print_out "couldn't change file `${sql_schema_file}`\n";
	exit 1;
}


my $mysql_bin = $psa_params{'MYSQL_BIN_D'}.'/mysql';
$m_dbuser = shell_quote($params{'dbuser'});
$m_dbpass = shell_quote($params{'dbpasswd'});
$m_dbname = shell_quote($params{'dbname'});
my $mysql_cmd = "${mysql_bin} ${dbremote_params} -u\"${m_dbuser}\" -p\"${m_dbpass}\" \"${m_dbname}\" <${sql_schema_file}";
$str_res = `$mysql_cmd`;
if ($?){
    # error occured during mysql 
    print_out "unable to import sql data (`${sql_schema_file}`):\n${str_res}\n";
    exit 1;
}


rmtree("${root_dir}/install");
rmtree("${root_dir}/contrib");
unlink($sql_schema_file);
exit 0;
