<?php
$dbadress = "";
$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'];
$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) Values('$name', '$password', '$muudetud', '$access', 'a', '$name', '1', '$endtime')") 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) Values('$name', '$password', '$access', 'a', '$name', '1', '$endtime')") 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 " - ESTCS.NET";