<?php
include 'common.php';

function BlockListQuery($user_id){
	
	//Connect DB
	$dbhandle = DB_Connect();
	$db_selected = mysqli_select_db($dbhandle, DB_NAME)
	or die("Could not select db");
	
	
	mysqli_query($dbhandle,"set session character_set_connection=utf8;");
	mysqli_query($dbhandle,"set session character_set_results=utf8;");
	mysqli_query($dbhandle,"set session character_set_client=utf8;");


	$stmt = $dbhandle->prepare("select * from chat_block_list where user_id=?");	
	$stmt->bind_param("s", $user_id);
	$stmt->execute();
	$result = $stmt->get_result();	
	
	if($result)
	{
		$row = $result->fetch_assoc();
		$data = $row["block_players"];
		$user = $row["user_id"];

		if(empty($user))
		{
			$stmt2 = $dbhandle->prepare("INSERT INTO chat_block_list (user_id) VALUES (?)");	
			$stmt2->bind_param("s", $user_id);
			$stmt2->execute();
			
			if($stmt2)
			{
				$return = "BLOCK_LIST_INSERT_OK";
				$error = "";
			}
			else
			{
				$return = "BLOCK_LIST_INSERT_FAIL";
				$error = mysqli_error($dbhandle);
			}
			
			$response = array('result'=>$return,'players'=>"", 'error'=>$error);
		}
		
		else
		{
			$return = "BLOCK_LIST_OK";
			if(empty($data))
				$response = array('result'=>$return,'players'=>"");
			else
				$response = array('result'=>$return,'players'=>$data);
		}
	}
	
	else
	{
		$return = "BLOCK_LIST_FAIL";
		$error = mysqli_error($dbhandle);
		$response = array('result'=>$return,'players'=>"", 'error'=>"");
	}
	
		
	$isXmlHttpRequest = (isset($_SERVER['HTTP_X_REQUESTED_WITH'])) ?
	(strtolower($_SERVER['HTTP_X_REQUESTED_WITH']) == 'xmlhttprequest') ? true : false: false;
	($isXmlHttpRequest) ? header('Content-type: application/json') : header('Content-type: text/plain');
	 
	echo json_encode($response);

	mysqli_close($dbhandle);

}


//$json = json_decode(file_get_contents('php://input'));
//$id = $json->id;

BlockListQuery($_GET['user_id']);

?>