<?php
$dbadress = "localhost";
$dbname = "";
$dbuser = "";
$dbpass = "";
$password_length = 5;

mysql_connect($dbadress, $dbuser, $dbpass) or die("Couldn't connect to mysql server!");
mysql_select_db($dbname);

if (!in_array($_SERVER['REMOTE_ADDR'], array('81.20.151.38', '81.20.148.122' , '79.125.125.1'))) {
    die("Error: Unknown IP");
}

$script_name = $_SERVER["SCRIPT_NAME"];
$script_id = preg_replace("/[^0-9]/", '', $script_name);

$script_info_query = mysql_query("Select * From amx_scripts Where id = '".$script_id."' ") or die(mysql_error());
$script_info = mysql_fetch_assoc($script_info_query);

$name = $_GET['message'];
$muudetud = "0";
$access = $script_info['access'];
$auaste = $script_info['auaste'];
$length = $script_info['lenght'];
$server_id = $script_info['server_id'];
$password_type = $script_info['password'];

$endtime = date("Y-m-d H:i:s", time()+(60*60*24*$length));

function make_seed() {
    list($usec, $sec) = explode(' ', microtime());
    return (float) $sec + ((float) $usec * 100000);
}
srand(make_seed());

if($password_type == "1"){
    $alfa = "1234567890";
} elseif($password_type == "2"){
    $alfa = "qwertyuiopasdfghjklzxcvbnmQWERTYUIOPASDFGHJKLZXCVBNM";
} elseif($password_type == "3"){
    $alfa = "1234567890qwertyuiopasdfghjklzxcvbnmQWERTYUIOPASDFGHJKLZXCVBNM";
}

$password = "";
for($i = 0; $i < $password_length; $i ++) {
    $password .= $alfa[rand(0, strlen($alfa))];
}

$is_admin = mysql_query("Select * From amx_amxadmins Where username = '".$name."'") or die(mysql_error);
$search_for_admin = mysql_num_rows($is_admin);

if($search_for_admin == "0"){
    mysql_query("Insert Into amx_amxadmins (username, password, muudetud, access, flags, nickname, ashow, endtime, auaste) Values('$name', '$password', '$muudetud', '$access', 'a', '$name', '1', '$endtime', '$auaste')") or die(mysql_error);
    $vastus .= "Täname! Teie nick: $name Parool: $password";

    $new_admin_id_search = mysql_query("Select id From amx_amxadmins Where username = '".$name."' AND password = '".$password."'");
    $new_admin_id = mysql_fetch_assoc($new_admin_id_search);
    $admin_id = $new_admin_id['id'];

    mysql_query("Insert Into amx_admins_servers (admin_id, server_id) Values('$admin_id', '$server_id')");
}

if($search_for_admin >= "1"){
    while($row = mysql_fetch_assoc($is_admin)){
        $admin_id = $row['id'];
        $admin_access = $row['access'];
        $admin_endtime = $row['endtime'];

        $admin_in_server = mysql_query("Select server_id From amx_admins_servers Where admin_id = '".$admin_id."' ");

        while($row0 = mysql_fetch_assoc($admin_in_server)){
            $admin_server_id = $row0['server_id'];

            if($server_id == $admin_server_id && $access == $admin_access){
                $admin_endtime_unix = strtotime("$admin_endtime");
                $admin_endtime_unix += 24 * 60 * 60 * $length;
                $admin_new_endtime = date("Y-m-d H:i:s", $admin_endtime_unix);

                mysql_query("Update amx_amxadmins Set endtime = '".$admin_new_endtime."' Where id = '".$admin_id."'") or die(mysql_error());
                $vastus .= "Täname! Pikendasite oma adminiaega $length päeva võrra. Parool on sama mis enne!";
            } elseif($server_id == $admin_server_id && $access != $admin_access){
                $admin_new_rights = array_unique(array_merge(str_split($admin_access),str_split($access)));
                sort($admin_new_rights);
                $admin_new_access = implode("", $admin_new_rights);

                mysql_query("Update amx_amxadmins Set access = '".$admin_new_access."', new_endtime = '".$endtime."', new_access = '".$access."' Where id = '".$admin_id."' ") or die(mysql_error());
                $vastus .= "Täname! Teie õigused liideti kokku. Parool on sama mis enne!";
            } else {
                mysql_query("Insert Into amx_amxadmins (username, password, access, flags, nickname, ashow, endtime, auaste) Values('$name', '$password', '$access', 'a', '$name', '1', '$endtime', $auaste)") or die(mysql_error);
                $vastus .= "Täname! Teie Nick: $name Parool: $password";

                $new_admin_id_search = mysql_query("Select id From amx_amxadmins Where username = '".$name."' AND password = '".$password."'") or die(mysql_error());
                $new_admin_id = mysql_fetch_assoc($new_admin_id_search);
                $admin_id = $new_admin_id['id'];

                mysql_query("Insert Into amx_admins_servers (admin_id, server_id) Values('$admin_id', '$server_id')");
            }
        }
    }
}
echo $vastus;

echo "";
?>