<?php include("session.php");
 require_once("class_functions.php");
require_once("class_db.php");
$db = new dbquery();

 if($_POST['action'] == "creation")
 {
	if(isset($_POST['name']) && !empty($_POST['name']))
	{
		$name = ereg_replace('[\'"]', '', $_POST['name']);
		$db->connect();
		$db->query("select query_id from ".$_SESSION['tablename']['saved_queries']." where user_id ='".$_SESSION['user']['UserId']."' and query_name='".addslashes($_POST['name'])."'");
		
		if($db->nb_result() < 1)
		{
			$db->query("insert into ".$_SESSION['tablename']['saved_queries']." (user_id, query_name, creation_date, created_by, query_type, query_txt) 
		values ('".$_SESSION['user']['UserId']."', '".addslashes($_POST['name'])."', now(),'".$_SESSION['user']['UserId']."', 'my_search', '".addslashes($_SESSION['current_search_query'])."' )", true);	
		}
		else
		{
			$res = $db->fetch_object();
			$id = $res->query_id;
			$db->query("update ".$_SESSION['tablename']['saved_queries']." set query_txt = '".addslashes($_SESSION['current_search_query'])."', last_modification_date = now() where user_id ='".$_SESSION['user']['UserId']."' and query_name='".addslashes($_POST['name'])."'", true);
		}
		if(!$db->query )
		{
			echo "{status : 2}";
			exit();
		}
		else
		{
			echo "{status : 0}";
			exit();
		}
	}
	else
	{
		echo "{status : 3}";
	}
 }
 else if($_POST['action'] == "load")
 {
	if(isset($_POST['id']) && !empty($_POST['id']))
	{
		$db->connect();
		$db->query("select query_txt from ".$_SESSION['tablename']['saved_queries']." where query_id = ".$_POST['id'], true);	
	}
	if(!$db->query )
	{
		echo "{'status' : 2, 'query':'".$db->show()."'}";
	}
	else
	{
		$res = $db->fetch_object();
		echo "{'status' : 0, 'query':".$res->query_txt."}";
	}
 }
 else if($_POST['action'] == "delete")
 {
	if(isset($_POST['id']) && !empty($_POST['id']))
	{
		$db->connect();
		$db->query("delete from ".$_SESSION['tablename']['saved_queries']." where query_id = ".$_POST['id'], true);	
	}
	if(!$db->query )
	{
		echo "{'status' : 2}";
	}
	else
	{
		echo "{'status' : 0}";
	}
 }
 else
 {
	echo "{status : 1}";
	//echo 1;
 }
?>