
<?

$_SESSION['db_name'] = 'oddychDB';
$_SESSION['db_user'] = 'oddychDB';
$_SESSION['db_pw'] = 'DBprievoz32!';

$_SESSION['casovyposun'] = 8;

$_SESSION['path_webroot'] = '/home/mo0dcpde18zs/public_html/oddych.sk';

$_SESSION['path_media'] = 'media'; // Pri zobrazovani obsahu lokalne
#$_SESSION['path_media'] = 'http://media.super.sk/oddych'; // Pri zobrazovani obsahu z media servera
$_SESSION['path_media'] = 'media'; // Pri indexacii obsahu
$_SESSION['path_media_physical'] = 'media'; // Pri indexacii obsahu
$_SESSION['path_upload'] = '/data/wwwroot/clients/euronet/nonpublic/oddych/upload/'; // Kam ukladat uploadovane subory

$_SESSION['FTP_active'] = 0;
$_SESSION['FTP_host'] = 'media.super.sk';
$_SESSION['FTP_uid'] = 'media';
$_SESSION['FTP_pw'] = 'prievoz32';

$_SESSION['mail_active'] = 1;

$_SESSION['kvalita_limit'] = 3;

$_SESSION['publikuj_obrazky'] = 1;
$_SESSION['publikuj_tapety'] = 1;
$_SESSION['publikuj_videa'] = 1;
$_SESSION['publikuj_flashvidea'] = 1;
$_SESSION['publikuj_flashhry'] = 1;
$_SESSION['publikuj_kamery'] = 1;
$_SESSION['publikuj_texty'] = 1;
$_SESSION['nahladovNaStranu'] = 6;

// Jazykovy filter na obsah
#$_SESSION['jazykfilter_SK'] = "a.SK in (0,1) and a.CZ in (0,1) and a.EN in(0,1) and a.ES in(0) and a.FR in(0)";
$_SESSION['jazykfilter_SK'] = "(a.SK=1 or a.CZ=1 or a.EN=1 or (a.sk=0 and a.cz=0 and a.en=0 and a.fr=0 and a.es=0))";
#$_SESSION['jazykfilter_CZ'] = "a.SK in (0,1) and a.CZ in (0,1) and a.EN in(0,1) and a.ES in(0) and a.FR in(0)";
$_SESSION['jazykfilter_CZ'] = "(a.SK=1 or a.CZ=1 or a.EN=1 or (a.sk=0 and a.cz=0 and a.en=0 and a.fr=0 and a.es=0))";
#$_SESSION['jazykfilter_EN'] = "a.SK in (0) and a.CZ in (0) and a.EN in(0,1) and a.ES in(0) and a.FR in(0)";
#$_SESSION['jazykfilter_EN'] = "a.EN in(1) and a.ES in(0) and a.FR in(0)";
$_SESSION['jazykfilter_EN'] = "(a.EN=1 or (a.sk=0 and a.cz=0 and a.en=0 and a.fr=0 and a.es=0))";
#$_SESSION['jazykfilter_ES'] = "a.SK in (0) and a.CZ in (0) and a.EN in(0,1) and a.ES in(0,1) and a.FR in(0)";
$_SESSION['jazykfilter_ES'] = "(a.ES=1 OR a.EN=1 or (a.sk=0 and a.cz=0 and a.en=0 and a.fr=0 and a.es=0))";
#$_SESSION['jazykfilter_FR'] = "a.SK in (0) and a.CZ in (0) and a.EN in(0,1) and a.ES in(0) and a.FR in(0,1)";
$_SESSION['jazykfilter_FR'] = "(a.FR=1 OR a.EN=1 or (a.sk=0 and a.cz=0 and a.en=0 and a.fr=0 and a.es=0))";

?><?

error_reporting(E_ALL & ~E_NOTICE & ~E_DEPRECATED);

class db{

	var $status;
	var $error;
	var $db;
	var $dbname;
	var $result;
	var $rows = 0;
	var $rs = array();
		
#	var $dbhost = 'localhost';
	var $dbhost = 'sxb1plcpnl0058.prod.sxb1.secureserver.net';
	var $dbusername; 
	var $dbpassword; 


	//=== init =========================
	function db($dbname,$user,$pass){
		$this->dbname = $dbname;
		$this->dbusername = $user;
		$this->dbpassword = $pass;
		
		ini_set("memory_limit","16M");
	}
	
	//=== login =========================
	function login($user,$pass){
		$this->dbusername = $user;
		$this->dbpassword = $pass;	
	}

	//=== execute ==========================
	function execute($query){

		$this->db = mysql_connect(
					$this->dbhost,
					$this->dbusername,
					$this->dbpassword);
		mysql_select_db($this->dbname,$this->db);
		mysql_query("SET CHARACTER SET utf8_general_ci");
//    mysql_query("SET CHARACTER SET utf8_unicode_ci");
    mysql_query('SET COLLATION_CONNECTION=utf8_general_ci');
    mysql_query("SET character_set_client=utf8_general_ci");
	  mysql_query("SET character_set_connection=utf8_general_ci");
	  mysql_query("SET character_set_results=utf8_general_ci");
		$this->status = 1;
		$this->result = mysql_query($query) or $this->oops();
		$this->rows = mysql_affected_rows();
		mysql_close();
	}

	//=== request query ==========================
	function query($query){

		$this->db = mysql_connect(
					$this->dbhost,
					$this->dbusername,
					$this->dbpassword);
		mysql_select_db($this->dbname,$this->db);
		mysql_query("SET CHARACTER SET utf8");
		$this->status = 1;
		$this->result = mysql_query($query) or $this->oops();
		//... if no error create array
		if($this->status){
			$this->makearray();
			mysql_free_result($this->result);
		}
		mysql_close();
	}

	//--- create RS array
	function makearray(){

		//---init vars
		$this->rs = array();
		$this->rows = 0;

		//---make array
		if (is_resource($this->result)){
			while ($row=mysql_fetch_assoc($this->result)){
				$this->rs[]=$row;
				$this->rows++;
			}
		}

	}


	//=== error handling ==========================
	function oops(){
		$this->status = 0;
		$this->error = mysql_error();
	}



}


?>