<?php
include 'common.php';

function CharacterListQuery($id, $server_group_id,$client_elios_version){
	
	//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;");

if($client_elios_version == 1)
{
	//v1으로 실행시에는 model_version_is_set == 1 인 캐릭터는 캐릭터 이전이 완료 됬으므로 0 인 캐릭터만 리스트업한다.
	$stmt = $dbhandle->prepare("select * from character_list where user_id=? and server_group_id=? and deleted=false and model_version_is_set=0");	
}
else
{
	$stmt = $dbhandle->prepare("select * from character_list where user_id=? and server_group_id=? and deleted=false");	
}

	//$stmt = $dbhandle->prepare("select * from character_list where user_id=? and server_group_id=? and deleted=false");	
	$stmt->bind_param("si", $id, $server_group_id);
	$stmt->execute();
	$result = $stmt->get_result();	
	if($result)
	{
		$character_count = 0;
		while($row = $result->fetch_assoc())
		{
			$character_count++;
			$dataArray[] = $row["user_id"].",".$row["class_id"].", ".$row["level"].",". $row["character_uid"].",".$row["character_name"] .",".$row["stat_strength"] .",".$row["stat_intellect"] .",".$row["stat_agility"] .",".$row["stat_wisdom"] .",".$row["stat_health"] .",".$row["custom_hair_uid"].",".$row["custom_face_uid"].",".$row["parts_head_uid"] . ",". $row["parts_body_uid"] . "," . $row["parts_leg_uid"].",".$row["parts_weapon_uid"].",".$row["parts_shield_uid"].",".$row["parts_quiver_uid"].",".$row["parts_arm_uid"].",".$row["costume_uid"].",".$row["costume_view"].",".$row["zone_id"].",".$row["block"].",".$row["server_group_id"].",".$row["model_version"].",".$row["model_version_is_set"];
		}
		
		if($character_count <= 0  )
		{
			$return = "NOT_EXIST_CHARACTER";
			$response = array('result'=>$return,'list'=>"");
		}
		else
		{
			$return = "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 character_list where user_id='".$id."' and deleted=false";
	//$strQuery = "select * from character_list where user_id='jack'";


	
	//Query Result
	if ($query_result = mysqli_query($dbhandle, $strQuery)) {
		
		$character_count = 0;
		while($row=mysqli_fetch_array($query_result, MYSQLI_ASSOC))
		{
			$character_count++;
			//$data .= $row["user_id"].",".$row["class_id"].",". $row["character_uid"].",".$row["character_name"] .",".$row["parts_head_uid"] . ",". $row["parts_body_uid"] . "," . $row["parts_leg_uid"].",".$row["parts_weapon_uid"].",".$row["parts_shield_uid"].",".$row["parts_quiver_uid"].",".$row["parts_arm_uid"]."&";
			//$data[] = array("user_id"=>$row['user_id'], "class_id"=>$row['class_id'],"character_uid"=>$row['character_uid'],"character_name"=>$row['character_name'],"parts_head_uid"=>$row['parts_head_uid'],"parts_body_uid"=>$row['parts_body_uid'],"parts_leg_uid"=>$row['parts_leg_uid'],"parts_weapon_uid"=>$row['parts_weapon_uid'],"parts_shield_uid"=>$row['parts_shield_uid'],"parts_quiver_uid"=>$row['parts_quiver_uid'],"parts_arm_uid"=>$row['parts_arm_uid']);
			$dataArray[] = $row["user_id"].",".$row["class_id"].", ".$row["level"].",". $row["character_uid"].",".$row["character_name"] .",".$row["stat_strength"] .",".$row["stat_intellect"] .",".$row["stat_agility"] .",".$row["stat_wisdom"] .",".$row["stat_health"] .",".$row["custom_hair_uid"].",".$row["custom_face_uid"].",".$row["parts_head_uid"] . ",". $row["parts_body_uid"] . "," . $row["parts_leg_uid"].",".$row["parts_weapon_uid"].",".$row["parts_shield_uid"].",".$row["parts_quiver_uid"].",".$row["parts_arm_uid"].",".$row["zone_id"].",".$row["block"];
		}
		
		if($character_count <= 0  )
		{
			$return = "NOT_EXIST_CHARACTER";
			$response = array('result'=>$return,'list'=>"");
		}
		else
		{
			$return = "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;

CharacterListQuery($_GET['id'],$_GET['server_group_id'],$_GET['client_elios_version']);

?>