<?php
include "config.php";

mysql_query("SET NAMES 'cp1251'");
mysql_query("SET CHARACTER SET 'cp1251'");


$seriall = $_GET["serial"];
$keyy = $_GET["key"];
$imei = isset($_GET["imei"]);
$deviceName = isset($_GET["deviceName"]);
if($seriall == null)
{
	return;
}

$json = array();

$ath = mysql_query("Select * FROM  `devices` WHERE serial = '$seriall';");

$num_rows = mysql_num_rows( $ath );
if($num_rows == 0) {
    $json["error"] = "Cant find";
    echo json_encode($json);
}

if($ath)
{
     while ($user = mysql_fetch_array($ath)) {
		 if(strlen($user["date"]) == 0)
		 {
			 if(strlen($user['imei']) >0 )
			 {
				if($user['key'] == $keyy && $user['imei'] == $imei && $user["deviceName"] == $deviceName)
				{
						$json["id"] = $user['id'];
						$json["active"] = $user['active'];

						if(strlen($user['date'])==0)
						{
							$date = date('m/d/Y h:i:s a', time());
							mysql_query("UPDATE `devices` SET `date`='$date' WHERE serial = '$seriall';");
						}
				}else
				{
						$json["error"] = "Cant find";
				}
			 }else
			 {
				if($user['key'] == $keyy)
				{
						$json["id"] = $user['id'];
						$json["active"] = $user['active'];

						if(strlen($user['date'])==0)
						{
							$date = date('m/d/Y h:i:s a', time());
							mysql_query("UPDATE `devices` SET `date`='$date' WHERE serial = '$seriall';");
						}
						mysql_query("UPDATE `devices` SET `imei`='$imei',`deviceName`='$deviceName' WHERE serial = '$seriall';");

				}else
				{
						$json["error"] = "Cant find";
				}
			 }
		 }else{
			 if($user['key'] == $keyy)
				{
						$json["id"] = $user['id'];
						$json["active"] = $user['active'];

						if(strlen($user['date'])==0)
						{
							$date = date('m/d/Y h:i:s a', time());
							mysql_query("UPDATE `devices` SET `date`='$date' WHERE serial = '$seriall';");
						}
				}else
				{
						$json["error"] = "Cant find";
				}
		 }

        echo json_encode($json);
    }
}
else
{
    echo "<p><b>Error: ".mysql_error()."</b><p>";
    exit();
}

?>