<?php

// openclient list
	usleep(50000);

	// set database name
	$database = DB_PREFIX . 'system';
		
	
	
	// process request
	if ($sid != '')
	{
		// open db connection
		require "includes/db.php";
		
		
		// validate session	/ die if necessary
		$sid = $db->real_escape_string($sid);

		$query = "UPDATE sessions SET ses_refresh = NOW() WHERE ses_id = '" . $sid . "' AND ISNULL(ses_end)";

		if ($result = $db->query($query)) 
		{
			if ($db->affected_rows != 1)
			{
				die();
			}
		}
		else
		{
			die();
		}
	
		
		// init return value
		$rv = '<root>' . PHP_EOL;
        
        $cid = getvar($db, 'id', 'int');
	
		
		// update client
		$query = "UPDATE clients set cln_open = NULL, cln_openby = 0, cln_openinstall = 0 WHERE cln_id = " . $cid;
		

		if ($result = $db->query($query))
		{
			$rv .= '<success>true</success>' . PHP_EOL;
		}
		else
		{
			header('Server: ');
			header('X-Powered-By: ');
			header("HTTP/1.0 404 Not Found");
            
            die();
		}
	

		// finish list
		$rv .= '</root>' . PHP_EOL;
				
		
		// return data
		echo $rv;
		
		die();
	}
	else
	{
		header('Server: ');
		header('X-Powered-By: ');
		header("HTTP/1.0 404 Not Found");
	}

?>