<?php
include 'common.php';

function DeleteBlockPlayerQuery($user_id, $nickname){
	
	//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;");
	
	$error = "";
	
	$stmt = $dbhandle->prepare("select block_players 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"];
		
		// 해당 유저 있을때
		if(strpos($data, $nickname.'/') !== false)
		{
			$return = "DeleteBlockPlayer_OK";
			$players = str_replace($nickname.'/', '', $data);
			
			$stmt = $dbhandle->prepare("update chat_block_list set block_players = ? where user_id = ?");	
			$stmt->bind_param("ss", $players, $user_id);
			$stmt->execute();
			
			if($stmt)
			{
				$return = "DeleteBlockPlayer_OK";
			}
			
			else
			{
				$return = "DeleteBlockPlayer_Fail";
				$error = mysqli_error($dbhandle);
			}
		}
		
		// 해당 유저가 없을때
		else
		{
			$return = "Not_Exist_Player";
			//$return = "DeleteBlockPlayer_Fail";
		}
	}
	
	else
	{
		$return = "DeleteBlockPlayer_Fail";
		$error = mysqli_error($dbhandle);
	}
	
	$response = array('result'=>$return, 'error'=>$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;

DeleteBlockPlayerQuery($_GET['user_id'], $_GET['nickname']);

?>