<?php
include('connect.php')//check

//set variable
$passkey=$_GET['passkey'];

$sql1="SELECT * FROM temp WHERE code='$passkey'";
$result1=mysql_query($sql1);

//if sucessfully queried
if($result1){

	//how many rows have key
	$count=mysql_num_rows($result1);

	//if passkey in database, retrieve data
	if($count==1){

	$rows=mysql_fetch_array($result1);
	$namex=$rows['username'];
	$emailx=$rows['email'];
	$passwordx=$rows['password'];

	//takeoutspace
	$name=str_replace(' ','',$namex);
	$email=str_replace(' ','',$emailx);
	$passwoed=str_replace(' ','',$passwordx);

	//insert into users table
	$sql2="INSERT INTO game SET username='$name', email='$email='$email', password='$password'";
	$result2=mysql_query($sql2);

	//gamestats table
	$sql3="INSERT into gamestats SET username='$name'";//finish!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
	$result3=mysql_query($sql3);

	}else{
	echo "wrong confirmation code";
	}

	if($result2){
	header("location:confirmation2.html");

	//remove from temp
	$sql5="DELETE FROM temp WHERE code='$passkey'";
	$result 5=mysql_query($sql5);
	}

}


?>