<?

require("config.php");

class Two {
	var $key;
	var $value;
	function Two($k,$v){
		$this->key=$k;
		$this->value=$v;
	}
}
$objects = array();
$names = array("name","lat","lon","alt","type","day","description");
foreach ($names as $i){
	$o = new Two($i,$HTTP_GET_VARS[$i]);
	$objects[] = $o;
}
//print_r($objects);

$id = $HTTP_GET_VARS['id'];

function execute($sql){
	$result = mysql_query($sql);
	if ($result) return true;
	else {
		$err = mysql_error();
		return "Error on $sql: $err ";
	}
}

function SetString($obs){
	$set = " ";
	foreach ($obs as $o) {
		if ( strlen($o->value)>0 )
			$set .= "$o->key='$o->value',";
		else {
			switch ($o->key){
				case "day":
					$d = date("Y:m:d H:i:s");
					$set .= "day='$d',";
					break;
			}
		}
	}
	$set = substr($set,0,strlen($set)-1);
	return $set;
}


//------------------------------------------------------
$Set = SetString($objects);
if ( strlen($Set)<1 ) {
	echo "No info";
	exit;
}

if  ( $id!="0" ) {
	$query = "insert into gps (id) values (null);";
	$tmp = execute($query);
	if ($tmp == "1"){
		$query = "UPDATE ".$table." set $Set where lat='0' AND lon='0' AND alt='0' AND type is NULL";
		echo execute($query);
	}
	else echo $tmp;
}
else { //Update the current psition (id=0)
	$query = "UPDATE ".$table." set $Set where id='0' ";
	echo execute($query);
}

mysql_close($conn);
?>