<?php
include 'header.php';

include 'common.php';
function ServerListQuery($server_version,$lang, $platform){
	$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 server_list where server_version=?");		
	$stmt->bind_param("i", $server_version);
	$stmt->execute();
	$result = $stmt->get_result();	
	if($result)
	{
		$server_count = 0;
		while($row = $result->fetch_assoc())
		{
			$server_count++;

			if($lang == 'kr')
			{
				$server_name = $row["name_kr"];
			}
			else
			{
				$server_name = $row["name_en"];
			}
			$max_ccu = 200;
			$dataArray[] = $row["server_group_id"].",".$server_name.", ".$row["web_url_public"].",".$row["web_url_private"].", ".$row["lang"].", ".$row["ccu"].", ".$max_ccu.",".$row["new"].",".$row["config_version"].",".$row["web_url_google_iap"].",".$row["web_url_onestore_iap"].",".$row["iap_url"].",".$row["allserver_chat_channel"] .",".$row["force_update_version"] .",".$row["download_url"];
		}

		if($server_count <= 0  )
		{
			$return = "NOT_EXIST_SERVER";
			$response = array('result'=>$return,'list'=>"");
		}
		else
		{
			$return = "SERVER_LIST_OK";
			$response = array('result'=>$return,'list'=>$dataArray);
		}

		mysqli_stmt_free_result($stmt);

		$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);
	}



	// $strQuery = "select * from server_list where server_version=".$server_version;
	
	// //Query Result
	// if ($query_result = mysqli_query($dbhandle, $strQuery)) {
		
	// 	$server_count = 0;
	// 	while($row=mysqli_fetch_array($query_result, MYSQLI_ASSOC))
	// 	{
	// 		$server_count++;
			
	// 		$server_name = null;
	// 		if($lang == 'kr')
	// 		{
	// 			$server_name = $row["name_kr"];
	// 		}
	// 		else
	// 		{
	// 			$server_name = $row["name_en"];
	// 		}
	// 		$max_ccu = 200;
	// 		$dataArray[] = $row["server_group_id"].",".$server_name.", ".$row["web_url_public"].",".$row["web_url_private"].", ".$row["lang"].", ".$row["ccu"].", ".$max_ccu.",".$row["new"].",".$row["config_version"].",".$row["web_url_google_iap"].",".$row["web_url_onestore_iap"].",".$row["iap_url"].",".$row["allserver_chat_channel"] .",".$row["force_update_version"] .",".$row["download_url"];
	// 	}
		
	// 	if($server_count <= 0  )
	// 	{
	// 		$return = "NOT_EXIST_SERVER";
	// 		$response = array('result'=>$return,'list'=>"");
	// 	}
	// 	else
	// 	{
	// 		$return = "SERVER_LIST_OK";
	// 		$response = array('result'=>$return,'list'=>$dataArray);
	// 	}
		
	// 	mysqli_free_result($query_result);
		

	
	 
	// 	$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;

ServerListQuery($_GET['server_version'], $_GET['lang'], $_GET['platform'] );

?>