#!/usr/bin/perl -w

use IO::Socket;

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 gallery_language gallery_theme );

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 "reconfigure: 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 "reconfigure: 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 "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 "reconfigure: no parameter $_ specified for application\n";
        $is_error = 1;
    }
}
if ($is_error){
    exit 1;
}

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

my $root_dir = $params{'vhost_path'}.'/'.$documents_directory.'/'.$params{'install_prefix'};
my $mysql_query_file = "${root_dir}/mysql-reconfig.sql";

# perform database changes

unless(open (MYSQL_FILE, ">${mysql_query_file}")){
    print_out "couldn't init mysql queries file\n";
    exit 1;
}

my $mysql_bin = $psa_params{'MYSQL_BIN_D'}.'/mysql';
my $m_dbuser = shell_quote($params{'dbuser'});
my $m_dbpass = shell_quote($params{'dbpasswd'});
my $m_dbname = shell_quote($params{'dbname'});

my $m_domain_name = mysql_quote($params{'domain_name'});
my $m_install_prefix = mysql_quote($params{'install_prefix'});
my $m_admin_email = mysql_quote($params{'admin_email'});
my $m_admin_login = mysql_quote($params{'admin_login'});
my $m_admin_passwd = mysql_quote($params{'admin_passwd'});
my $m_gallery_name = '';
my $m_gallery_desc = '';
my $m_gallery_language = mysql_quote($params{'gallery_language'});
my $m_gallery_theme = mysql_quote($params{'gallery_theme'});

if (defined $params{'gallery_name'}){
	$m_gallery_name = mysql_quote($params{'gallery_name'});
}

if (defined $params{'gallery_description'}){
	$m_gallery_desc = mysql_quote($params{'gallery_description'});
}

if (defined $params{'url'}){
}
	
my $query;
$query = "UPDATE cpg133_users SET user_name = '${m_admin_login}'";
if ('None' ne $params{'admin_passwd'}){
	$query .= ", user_password='${m_admin_passwd}'";
}
$query .= ", user_email='${m_admin_email}' WHERE user_id='1';\n";
$query .= "UPDATE cpg133_config SET value='${m_gallery_name}' where name='gallery_name';\n";
$query .= "UPDATE cpg133_config SET value='${m_gallery_desc}' where name='gallery_description';\n";
$query .= "UPDATE cpg133_config SET value='${m_admin_email}' where name='gallery_admin_email';\n";
$query .= "UPDATE cpg133_config SET value='${m_gallery_language}' where name='lang';\n";
$query .= "UPDATE cpg133_config SET value='${m_gallery_theme}' where name='theme';\n";

print MYSQL_FILE $query;
close MYSQL_FILE;

my $mysql_cmd = "${mysql_bin} -u\"${m_dbuser}\" -p\"${m_dbpass}\" \"${m_dbname}\" <${mysql_query_file}";
my $mysql_res = `$mysql_cmd`;
unlink($mysql_query_file);
if ($?){
    print_out "couldn't modify data in the database:\n${mysql_res}\n";
	exit 1;
}

exit 0;
