<?php

$fullname = $_POST['fullname'];
$username = $_POST['username'];
$pass = md5($_POST['pass']);
$repass = md5($_POST['repass']);

if (empty($fullname)){
	echo "<script>
	    alert('Preencha o Nome Completo');
	    history.go(-1);
	</script>";
exit;
}

if (empty($username)){
	echo "<script>
	    alert('Preencha o Nome de usuário(login)');
	    history.go(-1);
	</script>";
exit;
}

if ($pass != $repass){
	echo "<script>
	    alert('Senhas diferentes!');
	    history.go(-1);
	</script>";
exit;
}

$bdcon = pg_connect("host=200.137.66.7 port=5432 dbname=bocadb user=postgres password=123456") or die('connection failed: '. pg_last_error());

pg_query($bdcon, "SET NAMES 'utf8'");
pg_query($bdcon, 'SET character_set_connection=utf8');
pg_query($bdcon, 'SET character_set_client=utf8');
pg_query($bdcon, 'SET character_set_results=utf8');

$query3 = "SELECT * FROM usertable WHERE username = '$username'";
$result3 = pg_query($bdcon, $query3) or die('Query failed: ' . pg_last_error());

if(pg_num_rows($result3)!=0)
{
	echo "<script>
	    alert('username já existe!');
	    history.go(-1);
	</script>";
exit;
}

$query2 = "SELECT * FROM usertable ORDER BY usernumber DESC LIMIT 2";
$result2 = pg_query($bdcon, $query2) or die('Query failed: ' . pg_last_error());

while($row2 = pg_fetch_array($result2, null, PGSQL_ASSOC)){
	$un = $row2['usernumber'];
}

$query = "INSERT INTO usertable (usernumber, username, userfullname, usertype, usermultilogin, userpassword, usersitenumber, contestnumber) VALUES ($un + 1, '$username', '$fullname', 'team', TRUE, '$pass', 1, 1)";
$result = pg_query($bdcon, $query) or die('Query failed: ' . pg_last_error());

if(!$result)
{
	$response_array = array('status' => "0");
	break;
}

if(!isset($response_array)){

}
else{
	echo "<script>
		alert('Falha no processo de inscrição. Tente novamente!');
		window.location.href='http://200.137.66.71/~pet/topcom14/treinamento.php';
		</script>";
}

pg_free_result($result);
pg_close($bdcon);
?>