#!/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 ); 
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";
my $config_file = "${root_dir}/config.php";

# 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}\" ";
    }
}

# regenerate 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;

# 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_site_desc = '';
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'});

if (defined $params{'site_desc'}){
	$m_site_desc = mysql_quote($params{'site_desc'});
}
	
my $query;
print MYSQL_FILE <<EOT;
UPDATE phpbb_config SET config_value='${m_domain_name}' WHERE config_name='server_name';
UPDATE phpbb_config SET config_value='${m_domain_name}' WHERE config_name='sitename';

UPDATE phpbb_config SET config_value='${m_site_desc}' WHERE config_name='site_desc';

UPDATE phpbb_config SET config_value='${m_install_prefix}' WHERE config_name='script_path';

UPDATE phpbb_config SET config_value='${m_admin_email}' WHERE config_name='board_email';


UPDATE phpbb_users SET username='${m_admin_login}', user_password = MD5('${m_admin_passwd}'), user_email='${m_admin_email}'  WHERE user_id=2;
EOT

close MYSQL_FILE;

my $mysql_cmd = "${mysql_bin} ${dbremote_params}  -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;
