<?php

// update client note

    // init database name
	$database = DB_PREFIX;	
    
    // process request
	if ($sid != '')
	{
		// sid check
		require "includes/session/sidck.php";
        
        // init return value
		$rv = '<root>' . PHP_EOL;
	
	
		// fetch database name / open db
		$dbname = '';
		if ( isset($_POST['db']) ) $dbname = $_POST['db'];
		if ( isset($_GET['db']) ) $dbname = $_GET['db'];
		
		if ($dbname == '') die();
		
		$database .= $dbname;
        
        require "includes/db.php";
        
        
        // fetch / validate params
		$valid = true;
        
        $note = getvar($db, 'note', 'string');
        if (strlen($note) < 4) $valid = false;
        
        $per = getvar($db, 'per', 'int');
        if ($per <= 0) $valid = false;
        
        $id = getvar($db, 'id', 'int');
        
        
        if ($valid)
		{
		  $query = "UPDATE notes_client SET cnot_note = '" . $note . "', cnot_per = " . $per . " WHERE cnot_id = " . $id;
          
          if ($result = $db->query($query))
		  {
			if ($db->affected_rows == 1)
			{
				$rv .= "<success>true</success>" . PHP_EOL;
                
            }
            else
            {
                $rv .= "<success></success>" . PHP_EOL;
            }  
		  }
		  else
		  {
			 $rv .= "<success></success>" . PHP_EOL;
          }
        }
        else
        {
            $rv .= "<success></success>" . PHP_EOL;
        }
		
			
		// finish output
		$rv .= '</root>' . PHP_EOL;
        
        
		// return data
		echo $rv;
        
        die;
	}
	else
	{
		header('Server: ');
		header('X-Powered-By: ');
		header("HTTP/1.0 404 Not Found");
	}

?>