<?php
include ('config/database.default.config.php');

$conn = mysqli_connect($db_server, $db_username, $db_password, $db_name);
$sql = "select value from nesote_inoutse_cache_settings where name='db_name'";
$result = mysqli_query($conn, $sql);
$row = $result->fetch_row();
$cache_dbname = $row[0];

$sql2 = "select value from nesote_inoutse_cache_settings where name='db_driver'";
$result2 = mysqli_query($conn, $sql2);
$row2 = $result2->fetch_row();
$cache_driver = $row2[0];

$sql2 = "select value from nesote_inoutse_cache_settings where name='db_server'";
$result2 = mysqli_query($conn, $sql2);
$row2 = $result2->fetch_row();
$cache_db_server = $row2[0];

$sql2 = "select value from nesote_inoutse_cache_settings where name='db_username'";
$result2 = mysqli_query($conn, $sql2);
$row2 = $result2->fetch_row();
$cache_db_username = $row2[0];

$sql2 = "select value from nesote_inoutse_cache_settings where name='db_password'";
$result2 = mysqli_query($conn, $sql2);
$row2 = $result2->fetch_row();
$cache_db_password = $row2[0];

define('SERVER', $cache_db_server);
define('USER', $cache_db_username);
define('PASSWORD', $cache_db_password);
//define('DBASE', 'inout_searchengine_cachestorage');
define('DBASE', $cache_dbname);
//define('Driver', $cache_driver);
define('cache_driver', $cache_driver);
error_reporting($__error_reporting_level);

class cachestorage
{

    public $server = SERVER;
    public $user = USER;
    public $password = PASSWORD;
    public $dbase = DBASE;
    public $cache_driver = cache_driver;

    public function getcache($cacheindex, $id)
    {
    	if($this->cache_driver == "MYSQL")
        {
	        $conn = mysqli_connect($this->server, $this->user, $this->password, $this->dbase);
	        $sql = "select *  from nesote_inoutse_cachestorage_cache$cacheindex where cache_index='$id'";
	        $result = mysqli_query($conn, $sql);
	        $row = $result->fetch_row();
	        return $row[2];
	    }
	    else
	    {

	    }

    }
    public function storecache($content, $cacheindex, $id, $source)
    {
    	if($this->cache_driver == "MYSQL")
        {
	        $conn = mysqli_connect($this->server, $this->user, $this->password, $this->dbase);
	        $content = addslashes($content);
	        $sql = "INSERT INTO nesote_inoutse_cachestorage_cache$cacheindex(cache_index,content,source)
					VALUES ('$id', '$content','$source')";
					mysqli_query($conn, $sql);
		}
		
    }
    public function storestarcache($content, $cacheindex, $id, $engineid, $uid)
    {
    	if($this->cache_driver == "MYSQL")
        {
	        $conn = mysqli_connect($this->server, $this->user, $this->password, $this->dbase);
	        $content = addslashes($content);
	        $sql = "INSERT INTO nesote_inoutse_cachestorage_starredcache$cacheindex(uid,cache_index,content,source)
					VALUES ('$uid','$id', '$content','$engineid')";
					mysqli_query($conn, $sql);
		}
		
    }
    public function storemixcache($content, $cacheindex, $id, $source)
    {
    	if($this->cache_driver == "MYSQL")
        {
	        $conn = mysqli_connect($this->server, $this->user, $this->password, $this->dbase);
	        $content = addslashes($content);
	        $sql = "INSERT INTO nesote_inoutse_cachestorage_mixcache$cacheindex(cache_index,content,source)
					VALUES ('$id', '$content','$source')";
					mysqli_query($conn, $sql);
		}
		
    }
    public function getmixcache($cacheindex, $id)
    {
        if($this->cache_driver == "MYSQL")
        {
            $conn = mysqli_connect($this->server, $this->user, $this->password, $this->dbase);
            $sql = "select *  from nesote_inoutse_cachestorage_mixcache$cacheindex where cache_index='$id'";
            //echo $sql;exit;
            $result = mysqli_query($conn, $sql);
            $row = $result->fetch_row();
            return $row[2];
        }
       

    }
    public function getstarcache($cacheindex, $id, $uid, $engineid)
    {
		if ($this->cache_driver == "MYSQL")
        {
	        $conn = mysqli_connect($this->server, $this->user, $this->password, $this->dbase);
	        $sql = "select *  from nesote_inoutse_cachestorage_starredcache$cacheindex where cache_index='$id'
					and uid='$uid' and source='$engineid'";
	        //echo $sql;exit;
	        $result = mysqli_query($conn, $sql);
	        $row = $result->fetch_row();
	        return $row[3];
	     }
	     

    }
    public function getsource($cacheindex, $id)
    {
    	if ($this->cache_driver == "MYSQL")
        {
	        $conn = mysqli_connect($this->server, $this->user, $this->password, $this->dbase);
	        $sql = "select *  from nesote_inoutse_cachestorage_mixcache$cacheindex where cache_index='$id'";
	        $result = mysqli_query($conn, $sql);
	        $row = $result->fetch_row();
	        return $row[3];
        }
       

    }

}//END OF CLASS