<?php
include 'common.php';



function GetRestoreGold($dbhandle, $level)
{
	$stmt = $dbhandle->prepare("select gold from reset_skill_restore where level=?");	
	$stmt->bind_param("i", $level);
	$stmt->execute();
	$result = $stmt->get_result();

	mysqli_stmt_free_result($stmt);
			
	$error = "";
	
	if($row = $result->fetch_assoc())
	{
		if($row["gold"] > 0)
		{
			return $row["gold"];
		}
	}
	
	return 0;
}

function GetRestoreSkillBook($dbhandle, $level)
{
	$stmt = $dbhandle->prepare("select skill_book from reset_skill_restore where level=?");	
	$stmt->bind_param("i", $level);
	$stmt->execute();
	$result = $stmt->get_result();

	mysqli_stmt_free_result($stmt);
			
	$error = "";
	
	if($row = $result->fetch_assoc())
	{
		if($row["skill_book"] > 0)
		{
			return $row["skill_book"];
		}
	}
	
	return 0;
}

function PrintDebug($response, $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(array('result'=>$response,'error'=>$error));
	exit; 
}


function DeleteOwnedSkill($dbhandle, $character_uid)
{

	$stmt = $dbhandle->prepare("delete from owned_skill where character_uid=? and is_passive=0");
	$stmt->bind_param("i",  $character_uid);
	$result = $stmt->execute();
	$stmt->close();	
	
	if($result)
	{
		
		$stmt = $dbhandle->prepare("update character_list set skill_slot_0=-1, skill_slot_1=-1, skill_slot_2=-1, skill_slot_3=-1 where character_uid=?");
		$stmt->bind_param("i",  $character_uid);
		$result = $stmt->execute();
		$stmt->close();	
		
		
		return true;
	}
	
	return false;
}


function RestoreGold($dbhandle,$account_id, $character_uid, $gold)
{
			//add gold
			//add skill_book
			
	$stmt = $dbhandle->prepare("update character_list set gold=gold+? where user_id=? and character_uid=?");
	$stmt->bind_param("isi",  $gold , $account_id,$character_uid);
	$result = $stmt->execute();
	$stmt->close();	
	
	if($result)
	{
		return true;
	}
	
	return false;
	
}

function RestoreSkillBook($dbhandle,$account_id, $character_uid, $skill_book)
{
	
	
	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;");
	
	$now = new DateTime();
	$now->setTimezone(new DateTimeZone('UTC'));
	$strTime =  date_format($now, "Y-m-d H:i:s");
	  
	  
	$mail_title = "스킬 초기화로 스킬북을 돌려받았습니다";
	$mail_content = "스킬 초기화로 스킬북을 돌려받았습니다";
	$item_uid = 30110;
	$item_count = $skill_book;
	
	$strQuery = "INSERT INTO mail_box_character (character_id, title, content, item_id, item_count, time_limit, time_send) VALUES (".$character_uid.", '".$mail_title."', '".$mail_content."', ".$item_uid.", ".$item_count.", 720, '".$strTime."')";
	if($result = @mysqli_query($dbhandle, $strQuery))
	{
		return true;
	}
	
	return false;
		
}

function AlreadyResetFree($dbhandle, $character_uid)
{

	$stmt = $dbhandle->prepare("select count(*) as cnt from reset_skill_log where character_uid=? and price=0");	
	$stmt->bind_param("i", $character_uid);
	$stmt->execute();
	$result = $stmt->get_result();

	mysqli_stmt_free_result($stmt);
			
	$error = "";
	
	if($row = $result->fetch_assoc())
	{
		if($row["cnt"] > 0)
		{
			return true;
		}
	}
	

    return false;
}

function IsResetCharacter($dbhandle, $character_uid)
{
	$stmt = $dbhandle->prepare("select count(*) as cnt from character_list where character_uid=? and DATE(created_time) <= DATE('2020-11-16')");	
	$stmt->bind_param("i", $character_uid);
	$stmt->execute();
	$result = $stmt->get_result();
	$num = $result->fetch_assoc();
	
	mysqli_stmt_free_result($stmt);
	
	if($num["cnt"] > 0)
	{				
		
		return true;
	}

    return false;
}

function ResetSkill($dbhandle, $account_id,$character_uid)
{
	
	if(AlreadyResetFree($dbhandle, $character_uid))
	{
		return;
	}


    $stmt = $dbhandle->prepare("select *  from owned_skill where character_uid=? and is_passive=0");	
	$stmt->bind_param("i", $character_uid );
	$stmt->execute();
	$result = $stmt->get_result();
	
	
	//mysqli_stmt_free_result($stmt);
			

	
	if($result)
	{
		
		
		$gold =0;
		$skill_book=0;		
		while($row = $result->fetch_assoc())
		{			
			$skill_level = $row["level"];
			//echo "skill_level :".$skill_level;
			
			$gold += GetRestoreGold($dbhandle,$skill_level);
			$skill_book += GetRestoreSkillBook($dbhandle,$skill_level);
		}
		
		
		
		if($gold !=0 && $skill_book !=0)
		{
			if(ResetSkillLog($dbhandle, $account_id, $character_uid, $gold, $skill_book))
			{

				if(DeleteOwnedSkill($dbhandle, $character_uid))
				{					
					
					if(RestoreGold($dbhandle,$account_id, $character_uid, $gold))
					{
						RestoreSkillBook($dbhandle,$account_id, $character_uid, $skill_book);
						
						$response = "RESET_SKILL_OK";
						$error = "gold:".$gold .", skill_book:".$skill_book;
						
						
					}	
				}
			
			}
		}
		else	
		{
			$response = "RESET_SKILL_FAILED";
			$error = "no skill";//"보유한 스킬이 없습니다";
			
		}	
		
	}
   
}


	  
//ResetSkill($dbhandle,$account_id,$character_uid);

function InsertInvenPotion($dbhandle, $account_id, $char_uid, $item_uid,$count,$parts_type)
{
	
	if(AlreadyExistsItem($dbhandle, $char_uid,$item_uid ))
	{
		$query = "UPDATE owned_item set count=count+".$count." where character_uid=".$char_uid." and item_uid=".$item_uid;
	}
	else
	{
		$query = "INSERT INTO owned_item (character_uid, item_uid, count, is_equiped, parts_type) VALUES (".$char_uid.",".$item_uid.",".$count.",0,".$parts_type." )";
		
	}
	
	
	//Query Result
	$result = @mysqli_query($dbhandle,$query);
	
	if($result)
	{
		return true;
	}
	else
	{
		//$error = mysqli_error($dbhandle);
		return false;
	}
	
}

function ResetSkillLog($dbhandle, $account_id, $character_uid, $gold, $skill_book)
{
	
	$now = new DateTime();
	$now->setTimezone(new DateTimeZone('UTC'));
	$login_log_time =  date_format($now, "Y-m-d H:i:s");

	$stmt = $dbhandle->prepare("insert into reset_skill_log (user_id, character_uid, restore_gold, restore_book, log_time) values(?,?,?,?,?)");
	$stmt->bind_param("siiis", $account_id, $character_uid, $gold, $skill_book, $login_log_time);
	$result = $stmt->execute();
	$stmt->close();	
	
	if($result)
	{
		return true;
	}
	
	return false;
}


function Available_PotionDailyEvent($dbhandle,$account_id, $char_uid)
{
	$now = new DateTime();
	$now->setTimezone(new DateTimeZone('UTC'));
	$login_time =  date_format($now, "Y-m-d");
	
	
	//기간체크
	$time_now = strtotime($login_time);
	$event_start = strtotime('2020-11-10 00:00:00');
	$event_end = strtotime('2020-11-15 23:59:59');
	if($time_now >= $event_start &&  $time_now <= $event_end)
	{
		
		
		$stmt = $dbhandle->prepare("select count(*) as cnt from potion_event_log where user_id=? and character_uid=? and DATE_FORMAT(log_time,'%Y-%m-%d') =?");	
		$stmt->bind_param("sis", $account_id, $char_uid, $login_time);
		$stmt->execute();
		$result = $stmt->get_result();
		$num = $result->fetch_assoc();
		
		mysqli_stmt_free_result($stmt);
		
		if($num["cnt"] > 0)
		{				
			
			return false;
		}
		else
		{
			
			
			return true;
		}
	
	}
	else
	{
		
		return false;
	}
	
}

function UpdatePotionAndLog($dbhandle,$account_id, $char_uid, $item_uid,$count,$parts_type)
{
	//$amount =200;		
	//$stmt = $dbhandle->prepare("update owned_item set count where user_id=?");
	//$stmt->bind_param("ss", $amount,$account_id);
	//$result = $stmt->execute();
	//$stmt->close();
	
	
	$now = new DateTime();
	$now->setTimezone(new DateTimeZone('UTC'));
	$login_time =  date_format($now, "Y-m-d");
	
	
	//기간체크
	$time_now = strtotime($login_time);
	$event_start = strtotime('2020-11-11 00:00:00');
	$event_end = strtotime('2020-11-15 23:59:59');
	if($time_now >= $event_start &&  $time_now <= $event_end)
	{
		$count = 1000;
	}
	
	InsertInvenPotion($dbhandle, $account_id, $char_uid, $item_uid,$count,$parts_type);
	
	
	$now = new DateTime();
	$now->setTimezone(new DateTimeZone('UTC'));
	$login_time =  date_format($now, "Y-m-d H:i:s");
	
	
	
	$stmt = $dbhandle->prepare("insert into potion_event_log (user_id, character_uid, amount, log_time) values(?,?,?,?)");
	$stmt->bind_param("siis", $account_id, $char_uid, $count, $login_time);
	
	$result = $stmt->execute();
	$stmt->close();
	
	
}


function GetPrevQuestRewardRef($dbhandle,$account_id, $char_uid, $version_update_date)
{	
	//current_quest_id
	//current_quest_state
	//quest_is_rewarded

	
	$stmt = $dbhandle->prepare("select current_quest_id, current_quest_state, quest_is_rewarded from character_list where user_id=? and character_uid=? and DATE_FORMAT(created_time,'%Y-%m-%d') < ?");	
	$stmt->bind_param("sis", $account_id, $char_uid, $version_update_date);
	$stmt->execute();
	$result = $stmt->get_result();
	$row = $result->fetch_assoc();
	
	mysqli_stmt_free_result($stmt);
	
	$current_quest_id =  $row["current_quest_id"];
	$current_quest_state =  $row["current_quest_state"];
	$quest_is_rewarded =  $row["quest_is_rewarded"];
	
	$reward_quest_id = 0;
	
	if($current_quest_state == 3 &&  $quest_is_rewarded ==1)
	{
		$reward_quest_id =$current_quest_id;
	}
	else
	{
		$reward_quest_id =$current_quest_id - 1;
	}
	
	if($reward_quest_id < 0)
	{
		$reward_quest_id = 0;
	}
	
	if($reward_quest_id > 64)
	{
		$reward_quest_id = 64;
	}
	
	$stmt = $dbhandle->prepare("select final_reward from prev_quest_reward_ref where id=?");	
	$stmt->bind_param("i", $reward_quest_id);
	$stmt->execute();
	$result = $stmt->get_result();
	$row = $result->fetch_assoc();
	
	return $row["final_reward"];
	
}


function IsAlreadyRewareded_PrevQuest($dbhandle,$account_id, $char_uid)
{	
		
	$stmt = $dbhandle->prepare("select count(*) as cnt from prev_quest_reward_log where user_id=? and character_uid=?");	
	$stmt->bind_param("si", $account_id, $char_uid);
	$stmt->execute();
	$result = $stmt->get_result();
	$num = $result->fetch_assoc();
	
	mysqli_stmt_free_result($stmt);
	
	if($num["cnt"] > 0)
	{
		return true;
	}
	else
	{
		return false;
	}
}

function Reward_PrevQuest($dbhandle,$account_id, $char_uid, $reward_items, $version)
{
	
	//Log 존재하는지 (이미 보상 받았는지 체크)
	
	
	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;");
			
	$now = new DateTime();
	$now->setTimezone(new DateTimeZone('UTC'));
	$strTime =  date_format($now, "Y-m-d H:i:s");
			
	if(PrevQuestRewardLog($dbhandle,$account_id, $char_uid, $reward_items, $version))
	{
		//$reward_items
		$items = explode( '&', $reward_items );
		$items_count = count($items);
		for($i=0;$i < $items_count;$i++)
		{
			$item = explode( ':', $items[$i] );
			$item_uid = $item[0];
			$item_count = $item[1];
			  
			  
			$mail_title = "이전 퀘스트 완료 보상";
			$mail_content = "퀘스트 보상 변경에 따른 이전 퀘스트를 이미 완료한 모험가를 위한 보상입니다";			
			
			$strQuery = "INSERT INTO mail_box_character (character_id, title, content, item_id, item_count, time_limit, time_send) VALUES (".$char_uid.", '".$mail_title."', '".$mail_content."', ".$item_uid.", ".$item_count.", 720, '".$strTime."')";
			if($result = @mysqli_query($dbhandle, $strQuery))
			{
				continue;
			}
			else
			{
				return false;
			}
			
		}	
		
	}
	else
	{
		return false;
	}
	
	return true;
		
}

function PrevQuestRewardLog($dbhandle, $account_id, $char_uid, $reward_items, $version)
{
	
	$now = new DateTime();
	$now->setTimezone(new DateTimeZone('UTC'));
	$log_time =  date_format($now, "Y-m-d H:i:s");

	$stmt = $dbhandle->prepare("insert into prev_quest_reward_log (user_id, character_uid, reward_items,version,log_time) values(?,?,?,?,?)");
	$stmt->bind_param("sisss", $account_id, $char_uid, $reward_items,$version,$log_time);
	$result = $stmt->execute();
	$stmt->close();	
	
	if($result)
	{
		return true;
	}
	
	return false;
}


function PrevBuyerSkillBookRewardLog($dbhandle, $account_id, $char_uid, $rewarded_count, $version)
{
	
	$now = new DateTime();
	$now->setTimezone(new DateTimeZone('UTC'));
	$log_time =  date_format($now, "Y-m-d H:i:s");

	$stmt = $dbhandle->prepare("insert into prev_skill_book_buyer_reward_log (user_id, character_uid, rewarded_count,version,log_time) values(?,?,?,?,?)");
	$stmt->bind_param("siiss", $account_id, $char_uid, $rewarded_count,$version,$log_time);
	$result = $stmt->execute();
	$stmt->close();	
	
	if($result)
	{
		return true;
	}
	
	return false;
}






function GetPrevPurchasedSkillBookCount($dbhandle,$account_id, $char_uid, $version_update_date)
{	

	
	$stmt = $dbhandle->prepare("select sum(item_count) as cnt from purchase_log where user_id=? and character_uid=? and item_uid=30110 and DATE_FORMAT(log_time,'%Y-%m-%d') < ?");	
	$stmt->bind_param("sis", $account_id, $char_uid,$version_update_date);
	$stmt->execute();
	$result = $stmt->get_result();
	$num = $result->fetch_assoc();
	
	mysqli_stmt_free_result($stmt);
	
	return $num["cnt"];
}

function IsAlreadyRewareded_PrevBuyer_SkillBook($dbhandle,$account_id, $char_uid)
{	
		
	$stmt = $dbhandle->prepare("select count(*) as cnt from prev_skill_book_buyer_reward_log where user_id=? and character_uid=?");	
	$stmt->bind_param("si", $account_id, $char_uid);
	$stmt->execute();
	$result = $stmt->get_result();
	$num = $result->fetch_assoc();
	
	mysqli_stmt_free_result($stmt);
	
	if($num["cnt"] > 0)
	{
		return true;
	}
	else
	{
		return false;
	}
}

function Reward_PrevBuyer_SkillBook($dbhandle,$account_id, $char_uid, $reward_count, $version)
{
	
	
	
	if(PrevBuyerSkillBookRewardLog($dbhandle,$account_id, $char_uid, $reward_count, $version))
	{
		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;");
		
		$now = new DateTime();
		$now->setTimezone(new DateTimeZone('UTC'));
		$strTime =  date_format($now, "Y-m-d H:i:s");
		  
		  
		$mail_title = "상점 가격 변경 이전 구매 스킬북 보상";
		$mail_content = "상점 가격 변경 이전에 구매한 스킬북 보상입니다.";
		$item_uid = 30110;
		$item_count = $reward_count;
		
		$strQuery = "INSERT INTO mail_box_character (character_id, title, content, item_id, item_count, time_limit, time_send) VALUES (".$char_uid.", '".$mail_title."', '".$mail_content."', ".$item_uid.", ".$item_count.", 720, '".$strTime."')";
		if($result = @mysqli_query($dbhandle, $strQuery))
		{
			return true;
		}
	}
	
	
	
	return false;
		
}



function GetLang($dbhandle, $account_id)
{
	//$strQuery = "select count(*),cash from account where user_id='".$account_id."'"; 
	$lang ="en";
	$stmt = $dbhandle->prepare("select lang from account where user_id=?");	
	$stmt->bind_param("s", $account_id);
	$stmt->execute();
	$result = $stmt->get_result();	
	if($result)
	{		
		if($row = $result->fetch_assoc())
		{
			$lang = $row["lang"];
			mysqli_stmt_free_result($stmt);
		}
	}
	else{
		$error = mysqli_error($dbhandle);
	}
	
	
	return $lang;
}

function GetOpenedZoneID($dbhandle, $char_uid)
{
	$opened_zone_id = 0;
	
	
	
	$stmt = $dbhandle->prepare("select opened_zone_id from character_list where character_uid=?");	
	$stmt->bind_param("i", $char_uid);
	$stmt->execute();
	$result = $stmt->get_result();	
	if($result)
	{		
		if($row = $result->fetch_assoc())
		{
			$opened_zone_id = $row["opened_zone_id"];
			mysqli_stmt_free_result($stmt);
		}
	}
	else{
		$error = mysqli_error($dbhandle);
	}
	
	
	return $opened_zone_id;
}

function SubUpdateOpenedZoneID($dbhandle, $char_uid, $zone_id) {	
	
	$update_query = "update character_list set opened_zone_id=".$zone_id." where character_uid=".$char_uid." and deleted=false";
	

	//Query Result
	$result = @mysqli_query($dbhandle,$update_query);
	if($result != 1)
	{
		return false;		
	}
	
	return true;
}

function SubUpdateZoneID($dbhandle, $char_uid, $zone_id, $lang) {	
	
	
	$now = new DateTime();
	$now->setTimezone(new DateTimeZone('UTC'));
	$strTime =  date_format($now, "Y-m-d H:i:s");
	
	$update_query = "update character_list set zone_id=".$zone_id." , lang='".$lang."' , login_time='".$strTime."' where character_uid=".$char_uid." and deleted=false";
	

	//Query Result
	$result = @mysqli_query($dbhandle,$update_query);
	if($result != 1)
	{
		return false;		
	}
	
	return true;
}

function SubGetCharacterLevel($dbhandle,$char_uid, $zone_id,$cash) {

	$response = "LOGIN_FAILED";
	$level = 1;
	$exp = 0;
	
	$strQuery = "select level, character_exp, current_quest_id, current_quest_state, quest_is_rewarded, quest_kill_count, character_uid, class_id, parts_head_uid, parts_body_uid, parts_leg_uid, parts_weapon_uid, parts_shield_uid, parts_quiver_uid, parts_arm_uid, gold, inven_extra_count, stat_strength, stat_intellect, stat_agility, stat_wisdom, stat_health, skill_slot_0, skill_slot_1, skill_slot_2, skill_slot_3, stat_point, opened_zone_id, chaos_point from character_list where character_uid=".$char_uid." and deleted=false";
	if($query_result = mysqli_query($dbhandle, $strQuery))
	{
		$data = mysqli_fetch_row($query_result);
		if(count($data) > 0)
		{
			$response = "LOGIN_OK";
			$error = "";
			$level = $data[0];
			$exp = $data[1];
			$quest_id = $data[2];
			$quest_state = $data[3];
			$quest_is_rewarded = $data[4];
			$quest_kill_count = $data[5];			
			$character_uid = $data[6];
			$class_id = $data[7];			
			$parts_head_uid = $data[8];
			$parts_body_uid = $data[9];
			$parts_leg_uid = $data[10];
			$parts_weapon_uid = $data[11];
			$parts_shield_uid = $data[12];
			$parts_quiver_uid = $data[13];
			$parts_arm_uid = $data[14];
			$gold = $data[15];
			$inven_extra_count = $data[16];
			$stat_strength = $data[17];
			$stat_intellect = $data[18];
			$stat_agility = $data[19];
			$stat_wisdom = $data[20];
			$stat_health = $data[21];
			$skill_slot_0 = $data[22];
			$skill_slot_1 = $data[23];
			$skill_slot_2 = $data[24];
			$skill_slot_3 = $data[25];
			$stat_point = $data[26];
			$opened_zone_id = $data[27];
			$chaos_point = $data[28];
		}
	}
	else{
		$error = mysqli_error($dbhandle);
	}
	
	
	
	
	
	$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');
 
    //$error = get_ip(); //TEST
 
	echo json_encode(array(
	'result'=>$response,
	'error'=>$error,
	'level'=>$level,
	'exp'=>$exp,
	'quest_id'=>$quest_id,
	'quest_state'=>$quest_state,
	'quest_is_rewarded'=>$quest_is_rewarded,
	'quest_kill_count'=>$quest_kill_count,
	'character_uid'=>$character_uid,
	'class_id'=>$class_id,	
	'parts_head_uid'=>$parts_head_uid,
	'parts_body_uid'=>$parts_body_uid,
	'parts_leg_uid'=>$parts_leg_uid,
	'parts_weapon_uid'=>$parts_weapon_uid,
	'parts_shield_uid'=>$parts_shield_uid,
	'parts_quiver_uid'=>$parts_quiver_uid,
	'parts_arm_uid'=>$parts_arm_uid,
	'gold'=>$gold,
	'inven_extra_count'=>$inven_extra_count,
	'cash'=>$cash,
	'stat_strength'=>$stat_strength,
	'stat_intellect'=>$stat_intellect,
	'stat_agility'=>$stat_agility,
	'stat_wisdom'=>$stat_wisdom,
	'stat_health'=>$stat_health,
	'skill_slot_0'=>$skill_slot_0,
	'skill_slot_1'=>$skill_slot_1,
	'skill_slot_2'=>$skill_slot_2,
	'skill_slot_3'=>$skill_slot_3,
	'stat_point'=>$stat_point,
	'opened_zone_id'=>$opened_zone_id,
	'chaos_point'=>$chaos_point));
}

function LoginQuery($account_id,$login_key, $char_uid, $zone_id, $version){
	$dbhandle = DB_Connect();
	
	//Select DB
	$db_selected = mysqli_select_db($dbhandle, DB_NAME)
	or die("Could not select db");
	
	
	
	
	

	$strQuery = "select count(*),cash from account where user_id='".$account_id."' and login_key='".$login_key."'"; 
    
	
	$error = "";
	//Query Result
	if($query_result = mysqli_query($dbhandle, $strQuery))
	{
		
		$data = mysqli_fetch_row($query_result);	

		if( count($data) > 0 )
		{
			if($data[0] > 0)
			{	
				$lang = GetLang($dbhandle,$account_id);
		
				SubUpdateZoneID($dbhandle,$char_uid,$zone_id, $lang);
				
				$opened_zone_id = GetOpenedZoneID($dbhandle, $char_uid);
				if($opened_zone_id < $zone_id)
				{
					SubUpdateOpenedZoneID($dbhandle, $char_uid, $zone_id);					
				}
				
				$cash = $data[1];
				SubGetCharacterLevel($dbhandle,$char_uid, $zone_id, $cash);					
		
				$response = "LOGIN_OK";
				
				//if(Available_PotionDailyEvent($dbhandle,$account_id, $char_uid))
				//{
				//	UpdatePotionAndLog($dbhandle,$account_id, $char_uid, 30000,500,20);
				//}
				
				
				//if(IsResetCharacter($dbhandle, $char_uid))
				//{										
				//	ResetSkill($dbhandle,$account_id,$char_uid);
				//}
				
				//////////////////////////////////////////////////////////////////////
				//0.22.200 퀘스트 보상 변경 , 스킬북 상점 가격 50%로 변경하여 기존 구매 유저에게 구매한 만큼 보상
				////////////////////////////////////////////////////////////////////
				$version_update_date = "2021-05-21";  //todo:버전 업데이트 날짜 수정해서 디플로이 할것
				
				if(!IsAlreadyRewareded_PrevBuyer_SkillBook($dbhandle,$account_id, $char_uid))
				{
					
					$count = GetPrevPurchasedSkillBookCount($dbhandle,$account_id, $char_uid, $version_update_date);
					if($count > 0)//리워드 할게 있으면,
					{
						Reward_PrevBuyer_SkillBook($dbhandle,$account_id, $char_uid,$count, $version);
					}
					//PrintDebug("GetPrevPurchasedSkillBookCount",$count);
					
				}
				
				if(!IsAlreadyRewareded_PrevQuest($dbhandle,$account_id, $char_uid))
				{
					$quest_reward = GetPrevQuestRewardRef($dbhandle,$account_id, $char_uid, $version_update_date);				
					if($quest_reward !="")
					{					
						Reward_PrevQuest($dbhandle,$account_id, $char_uid, $quest_reward, $version);
						
					}
				}
				
				
			}		
			else 
			{
				$response = "LOGIN_FAILED";
				$error = "ERROR : 021";
			}					
		}
		else 
		{
			$response = "LOGIN_FAILED";
			$error = "ERROR : 020";
		}
		
		mysqli_free_result($query_result);
	}
	

    mysqli_close($dbhandle);
 


}

$json = json_decode(file_get_contents('php://input'));
$account_id = $json->account_id;
$login_key = $json->login_key;
$char_uid = $json->char_uid;
$start_zone_id = $json->start_zone_id;
$login_zone_id = $json->login_zone_id;
$version  = $json->version;


//if(CheckValidatedServerIP())
//{
	LoginQuery($account_id, $login_key, $char_uid, $start_zone_id, $version);
//}
//else
//{
//	$response = "INVALIDATED_SERVER";
//	$error = "CheckValidatedServerIP 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(array(	'result'=>$response,'error'=>$error	));
//}



?>