<?php
session_start();
date_default_timezone_set('Europe/Minsk');

class myFunctions
{
	//public $path		= "https://www.ekspar.com.tr/onarim/";
	//var $dbHost			= "localhost";
	//var $dbName			= "garantili";
	//var $dbUserName		= "root";
	//var $dbPassword		= "";
	//var $dbCharSet		= "utf8";
	public $path		= "https://tubisad.ekspar.dev/";
	var $dbHost			= "localhost";
	var $dbName			= "ekspardev_tubisad";
	var $dbUserName		= "ekspardev_tubisad";
	var $dbPassword		= "S1cV1q3}3fC)";
	var $dbCharSet		= "utf8";


	public function __construct($session = false)
	{
		try
		{
			$this->db = new PDO("mysql:host=".$this->dbHost.";dbname=".$this->dbName.";charset=".$this->dbCharSet, $this->dbUserName, $this->dbPassword);
			$this->db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
			$this->db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_OBJ);
		}
		catch (PDOException $e)
		{
			die("Veri tabanı bağlantı hatası:<br /><br />" . $e->getMessage());
		}
	}




	public function sessionKontrol(){
		if(($_SESSION['yetki'] == "" or $_SESSION['uye_id'] == "" or $_SESSION['email'] == "") and ($_REQUEST['sk']!="1"))
		{
			header("location:index.php");
		}
	}
	public function ToPass($sifre){
		return md5(sha1(base64_encode(trim($sifre))));
	}
	
	public function atiktipigetir($atiktipi){
		
		$row = "select * from wasteTypes_atikTipleri where id='$atiktipi'";
		$row = $this->query($row); 
		$row=$row->fetch();
		
		return $row->name;
	}
	
	public function bagislanacakprojeyigetir($proje){
		
		$row = "select * from donatedProjects_bagisProjeleri where id='$proje'";
		$row = $this->query($row); 
		$row=$row->fetch();
		
		return $row->name;
	}
	
	public function uyegetir($id){
		
		$row = "select * from users where id='$id'";
		$row = $this->query($row); 
		$row=$row->fetch();
		
		return $row->name." ".$row->surname;
	}
	
	
	public function statusgetir($status){
		
		$row = "select * from talepler_status where id='$status'";
		$row = $this->query($row); 
		$row=$row->fetch();
		 
		if(!$row->id){
		    
		    $row = "select * from talepler_status where id='1'";
		    $row = $this->query($row); 
		    $row=$row->fetch();
		    
		}
		return $row->status;
	}
	
	
	public function hash($metin){
        
        $iv = chr(0x0) . chr(0x0) . chr(0x0) . chr(0x0) . chr(0x0) . chr(0x0) . chr(0x0) . chr(0x0) . chr(0x0) . chr(0x0) . chr(0x0) . chr(0x0) . chr(0x0) . chr(0x0) . chr(0x0) . chr(0x0);
        $password   = "A472c47Ad52a";
        $method     = "aes-256-cbc";
        $key = substr(hash('sha256', $password, true), 0, 32);
        
        return base64_encode(openssl_encrypt($metin, $method, $key, OPENSSL_RAW_DATA, $iv));
        
    }
	
	
	public function query($sql, $params = null){



		try {

		
			$query = $this->db->prepare($sql, array(PDO::ATTR_CURSOR => PDO::CURSOR_FWDONLY));
			$query->execute($params);
			
			
			

			return $query;

		} catch (PDOException $e) {
			die("Hatalı:<br /><br />" . $e->getMessage());
		}


	}
 
	  
 


	public function __destruct(){
		$this->db = null;
	}
}


$func		= new myFunctions;

function gunceltarihsaat()
{
	return date("Y-m-d"." "."H:i:s");
}
 
  
function p($request) {
	return str_replace("'","\'",strip_tags(trim($_REQUEST[$request])));
	//KULLANIMI:  $xxxxx=p("xxxxx");	 //trim eklendi
}
 

setlocale(LC_MONETARY, 'tr_TR');
 
 



	

?>