";
echo realpath(ROOTPATH.'../config')."
";
echo realpath(dirname(__FILE__))."
";
echo realpath($_SERVER['SCRIPT_FILENAME'])."
";
echo __FILE__."
";
echo getcwd();
*/
?>sql("select title2 from seo where tipus='".$tipus."' and tid=".id($id)." and nyelv_id=".id($_SESSION["nyelvId"]));
$row=$db->fetch_array($query);
return $row["title2"];
}
function CValue($nev){
global $db;
$query=$db->sql("select v from config where k='$nev'");
$row=$db->fetch_array($query);
return $row[0];
}
function FtBe($ft){
$a = array(' ',',','.');
return str_replace($a, '', $ft);
}
function FtKi($ft){
return number_format($ft,0,'','.');
}
function id($id){
return is_int((int)$id)?(int)$id:0;
}
function Kod($db=7){
$kod = "0123456789QWERTZUIOPASDFGHJKLXCVBNMqwertzuiopasdfghjklyxcvbnm";
srand((double) microtime() * 1000000);
$cucc = "";
for ($i = 0; $i < $db; $i++) {
$cucc .= $kod{rand(0, strlen($kod)-1)};
}
return $cucc;
}
function Tordeles($db,$dbig,$lepes,$url){
$tordeles=intval($db/$dbig);
if(($db%$dbig)!=0) $tordeles++;
if($tordeles>1){
for($i=1;$i<=$tordeles;$i++){
if(($i==$lepes) or ($i==1 and !isset($lepes))){
echo ''.$i.' ';
}else{
$tol=($i*$dbig)-$dbig;
echo ''.$i.' ';
}
}
}
}
function szam_kirak($szam){
$tmp=array();
$tmp=explode('.',$szam);
return intval($szam).'.'.substr(end($tmp),0,2);
//return number_format($szam,3,',',' ');
}
function SeoNev($nev){
$nev=strtolower($nev);
$a = array(' - ','ö','ü','ű','ő','á','é','í','ú','ó','Ö','Ü','Ű','Ő','Á','É','Í','Ú','Ó');
$b = array('-','o','u','u','o','a','e','i','u','o','o','u','u','o','a','e','i','u','o');
$nev=str_replace($a, $b, $nev);
$string = preg_replace("/[^a-zA-Z0-9 _-]/", "", $nev);
$string = strtolower($string);
$string = preg_replace("/[ ]+/", " ", $string);
$string = str_replace(" ", '-', $string);
return $string;
}
function FileNev2($nev){
$nev=strtolower($nev);
$a = array(' - ','ö','ü','ű','ő','á','é','í','ú','ó','Ö','Ü','Ű','Ő','Á','É','Í','Ú','Ó');
$b = array('-','o','u','u','o','a','e','i','u','o','o','u','u','o','a','e','i','u','o');
$str=str_replace($a, $b, $nev);
$str = preg_replace("/[^a-zA-Z0-9 _-]/", " ", $str);
$str = preg_replace("/[ ]+/", " ", $str);
$str = strip_tags($str);
$str = preg_replace('/[\r\n\t ]+/', ' ', $str);
$str = preg_replace('/[\"\*\/\:\<\>\?\'\|]+/', ' ', $str);
$str = html_entity_decode( $str, ENT_QUOTES, "utf-8" );
$str = htmlentities($str, ENT_QUOTES, "utf-8");
$str = preg_replace("/(&)([a-z])([a-z]+;)/i", '$2', $str);
$str = str_replace(' ', '_', $str);
$str = rawurlencode($str);
$str = str_replace('%', '_', $str);
return $str;
}
function FileNev($nev){
$nev=strtolower($nev);
$a = array(' ',',','ö','ü','ű','ő','á','é','í','ú','ó','Ö','Ü','Ű','Ő','Á','É','Í','Ú','Ó','$','%','!');
$b = array('_','_','o','u','u','o','a','e','i','u','o','o','u','u','o','a','e','i','u','o','','','');
return str_replace($a, $b, $nev);
}
function FileTipus($filename) {
preg_match( "/.*\.([a-zA-z0-9]{0,5})$/", $filename, $regs );
return strtolower($regs[1]);
}
function KotelezoOk($kotelezo,$mezo){
$hiba=array();
foreach($kotelezo as $a){
//if(array_key_exists($a,$mezo) and !trim($mezo[$a])) $hiba[]=$a;
if(!array_key_exists($a,$mezo)) $hiba[]=$a;
elseif(!trim($mezo[$a])) $hiba[]=$a;
}
return $hiba;
}
function HibasMezo($valtozo,$hiba){
if(is_array($hiba) and in_array($valtozo,$hiba)) return 'error';
}
function Value($value){
global $action;
global $row;
if($_GET["action"]=='none') return;
if($_GET["action"]=="modosit"){
return szki($row[$value]);
}else{
if(isset($_POST[$value]) or isset($_GET[$value])){
if($_POST[$value]) return szki($_POST[$value]); else return szki($_GET[$value]);
}
}
}
function tovabb($tomb){
if(sizeof($tomb)){
foreach ($tomb as $key=>$value){
$tovabb.="&$key=".$value;
}
}
return $tovabb;
}
function email_ok($address) {
return (ereg('^[-!#$%&\'*+\\./0-9=?A-Z^_`a-z{|}~]+'.
'@'.
'[-!#$%&\'*+\\/0-9=?A-Z^_`a-z{|}~]+\.'.
'[-!#$%&\'*+\\./0-9=?A-Z^_`a-z{|}~]+$',
$address));
}
function megye($id, $style=''){
?>
dir=$dir;
}
public function isPDF($path) {
$a = mime_content_type($path);
echo $a;
}
public function isImage($path) {
$a = getimagesize($path);
$image_type = $a[2];
if(in_array($image_type , array(IMAGETYPE_JPEG ,IMAGETYPE_PNG))){
return true;
}
return false;
}
public function getFileType($file){
return mime_content_type( '/tmp/'.$_FILES[$file]['name']);
}
private function Kod($db=5){
$kod = "0123456789QWERTZUIOPASDFGHJKLXCVBNMqwertzuiopasdfghjklyxcvbnm";
srand((double) microtime() * 1000000);
$cucc = "";
for ($i = 0; $i < $db; $i++) {
$cucc .= $kod{rand(0, strlen($kod)-1)};
}
return $cucc;
}
private function FileExt($file){
preg_match( "/.*\.([a-zA-z0-9]{0,5})$/", $file, $regs );
return strtolower($regs[1]);
}
public function Error(){
switch($this->error){
case 10: return 'A feltöltött file formátuma nem megfelelő'; break;
case 20: return 'A feltöltött file mérete nem megfelelő'; break;
case 30: return 'A file feltöltés nem sikerült.'; break;
case 40: return 'A file feltöltés nem sikerült!'; break;
}
}
public function FileNev($nev){
$nev=strtolower($nev);
$a = array(' - ','ö','ü','ű','ő','á','é','í','ú','ó','Ö','Ü','Ű','Ő','Á','É','Í','Ú','Ó');
$b = array('-','o','u','u','o','a','e','i','u','o','o','u','u','o','a','e','i','u','o');
$str=str_replace($a, $b, $nev);
$str = preg_replace("/[^a-zA-Z0-9 _-]/", " ", $str);
$str = preg_replace("/[ ]+/", " ", $str);
$str = strip_tags($str);
$str = preg_replace('/[\r\n\t ]+/', ' ', $str);
$str = preg_replace('/[\"\*\/\:\<\>\?\'\|]+/', ' ', $str);
$str = html_entity_decode( $str, ENT_QUOTES, "utf-8" );
$str = htmlentities($str, ENT_QUOTES, "utf-8");
$str = preg_replace("/(&)([a-z])([a-z]+;)/i", '$2', $str);
$str = str_replace(' ', '_', $str);
$str = rawurlencode($str);
$str = str_replace('%', '_', $str);
return $str;
}
public function CheckFileUpload($file, $size=0, $ext=''){
if($size) $this->maxFileSize=$size;
if (is_uploaded_file($_FILES[$file]['tmp_name'])){
$mime_type = mime_content_type($_FILES[$file]['tmp_name']);
if($ext){
if($mime_type!=$ext) $this->error=10;
}else{
if (!in_array($mime_type, $this->allowed_file_types)) {
$this->error=10;
}
}
if($_FILES[$file]['size'] > ($this->maxFileSize * 1024 * 1024)) {
$this->error=20;
}
return $this->error;
}
}
public function FileUpload($file, $file_name='', $size=0, $ext=''){
if($size) $this->maxFileSize=$size;
if (is_uploaded_file($_FILES[$file]['tmp_name'])) {
$mime_type = mime_content_type($_FILES[$file]['tmp_name']);
if($ext){
if($mime_type!=$ext and $mime_type!='image/jpeg') $this->error=10;
}else{
if (!in_array($mime_type, $this->allowed_file_types)) {
$this->error=10;
}
}
if($_FILES[$file]['size'] > ($this->maxFileSize * 1024 * 1024)) {
$this->error=20;
}
if($file_name){
$file_name=$this->FileNev($file_name).'.'.$this->FileExt($_FILES[$file]['name']);
}else{
$file_name=Kod(4).'-'.$this->FileNev($_FILES[$file]['name']);
}
if(!$this->error){
//echo $_FILES[$file]['tmp_name']." / ".$_FILES[$file]['name']." / ".$this->dir.$file_name."
";
if (move_uploaded_file($_FILES[$file]['tmp_name'] , $this->dir.$file_name)) {
return $file_name;
}else $this->error=30;
}
echo $ext." - ".$mime_type." - ".$_FILES[$file]['size']." - ".$this->maxFileSize." - ".($this->maxFileSize * 1024 * 1024)."
";
echo $this->error."
";
}else $this->error=40;
}
/*
function FileFeltolt($kep,$filenev=''){
if(is_uploaded_file($_FILES[$kep]['tmp_name'])){
$type=FileTipus($_FILES[$kep]['name']);
$nev=FileNev($_FILES[$kep]['name']);
if($filenev) $nev=$filenev.".".$type;
if(file_exists($this->Ut.$nev)) $nev=Kod(4).'_'.FileNev($_FILES[$kep]['name']);
// if(!$filenev) $nev=time().".".$type;
// elseif($filenev=='eredeti') $nev=Kod(4).FileNev($_FILES[$kep]['name']); else $nev=$filenev.".".$type;
copy($_FILES[$kep]['tmp_name'],$this->Ut.$nev);
$tomb[]=$nev;
$tomb[]=$type;
}
return $tomb;
}
*/
}
?>conn = mysqli_connect(DB_HOST, DB_USER, DB_PWD, DB_DB);
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_errno()." - ".mysqli_connect_error());
exit();
}
mysqli_set_charset($this->conn, "utf8");
mysqli_query($this->conn,'SET character_set_results=utf8');
mysqli_query($this->conn,'SET names=utf8');
mysqli_query($this->conn,'SET character_set_client=utf8');
mysqli_query($this->conn,'SET character_set_connection=utf8');
mysqli_query($this->conn,'SET character_set_results=utf8');
mysqli_query($this->conn,'SET collation_connection=utf8_general_ci');
/*
mysqli_query($this->conn,"set character_set_client=latin2");
mysqli_query($this->conn,"set character_set_results=latin2");
mysqli_query($this->conn,"set collation_connection=latin2_general_ci");
mysqli_query($this->conn,"set names=latin2");
*/
mysqli_query($this->conn, "SET GLOBAL sql_mode = ''");
mysqli_query($this->conn, "SET SESSION sql_mode = ''");
return $this->conn;
}
public function hiba($sql,$error){
if(DEBUG) echo "
".$sql.' - '.$errno.' - '.$error."
";
else echo "- Adatbzis hiba - Krem prblja jra vagy forduljon a rendszergazdhoz.";
if(DB_HIBA_EMAIL) mail(DB_HIBA_EMAIL,'Adatbzis hiba - '.DOMAIN,$_SERVER[SCRIPT_FILENAME].'?'.$_SERVER[QUERY_STRING]."\n".$sql."\n".$error,'From:'.DB_HIBA_EMAIL);
}
public function sql($sql,$mod=0){
//global $conn;
if($mod) echo $sql."
";
$query = mysqli_query($this->conn, $sql) or $this->hiba($sql, mysqli_error($this->conn));
return $query;
}
public function fetch_array($query) {
return mysqli_fetch_array($query, MYSQLI_BOTH);
}
public function refValues($arr){
$refs = array();
foreach ($arr as $key => $value){
$refs[$key] = &$arr[$key];
}
return $refs;
}
public function selectSql($sql,$tomb,$type) {
if(sizeof($tomb)){
foreach($tomb as $key=>$value){
$tomb[$key]=$this->safe($value);
}
}
$a_data=array();
if ($stmt = mysqli_prepare($this->conn, $sql)) {
call_user_func_array('mysqli_stmt_bind_param', array_merge(array($stmt, $type), $this->refValues($tomb)));
if ( !mysqli_execute($stmt) ) {
die( 'stmt error: '.mysqli_stmt_error($stmt) );
}
//mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);
while($row = mysqli_fetch_array($result)) {
array_push($a_data, $row);
}
mysqli_stmt_close($stmt);
return($a_data);
}else echo 'Wrong SQL: ' . $sql . ' Error: ' . mysqli_error($this->conn).' '.$this->errno . ' ' . $this->error, E_USER_ERROR;
}
public function insertSql($sql,$tomb,$type) {
if ($stmt = mysqli_prepare($this->conn, $sql)) {
call_user_func_array('mysqli_stmt_bind_param', array_merge (array($stmt, $type), $this->refValues($tomb)));
if ( !mysqli_execute($stmt) ) {
die( 'stmt error: '.mysqli_stmt_error($stmt) );
}
mysqli_stmt_close($stmt);
}else echo 'Wrong SQL: ' . $sql . ' Error: ' . mysqli_error($this->conn).' '.$this->errno . ' ' . $this->error, E_USER_ERROR;
}
public function safe($value){
$return_value = $this->dash($value);
if (get_magic_quotes_gpc()) {
if(ini_get('magic_quotes_sybase')) {
$return_value = str_replace("''", "'", $return_value);
} else {
$return_value = stripslashes($return_value);
}
}
if (!is_numeric($return_value)) {
return $this->escape_string($return_value);
}
return $return_value;
}
protected function safe2($value){
$return_value = $value;
if(get_magic_quotes_gpc()){
$return_value = stripslashes($value);
}else $return_value = str_replace(array('\\', "\0", "\n", "\r", "'", '"', "\x1a"), array('\\\\', '\\0', '\\n', '\\r', "\\'", '\\"', '\\Z'), $value);
return $return_value;
}
public function insert_id(){
return mysqli_insert_id($this->conn);
}
public function numrows($query,$sql=''){
return mysqli_num_rows($query);
}
function escape_string($szoveg){
return mysqli_real_escape_string($this->conn, $szoveg);
}
public function id($id){
return is_int((int)$id)?(int)$id:0;
}
public function __destruct() {
}
function ujid($tabla,$mit='id',$sql=''){
$query=$this->sql("select max(".$mit.")+1 from $tabla $sql");
$row=$this->fetch_array($query);
if(!$row[0]) return 1;
return $row[0];
}
public function betweenDate($tol,$ig,$mezo){
if($tol and $ig) $vissza='('.$mezo.'>=\''.$tol.'\' and '.$mezo.'<=\''.$ig.'\')';
elseif($tol and !$ig) $vissza='('.$mezo.'>=\''.$tol.'\')';
elseif(!$tol and $ig) $vissza='('.$mezo.'<=\''.$ig.'\')';
return $vissza;
}
public function dash($text){
$text = str_replace(
array("\xe2\x80\x98", "\xe2\x80\x99", "\xe2\x80\x9c", "\xe2\x80\x9d", "\xe2\x80\x93", "\xe2\x80\x94", "\xe2\x80\xa6"),
array("'", "'", '"', '"', '-', '--', '...'),
$text);
/*
// Next, replace their Windows-1252 equivalents.
$text = str_replace(
array(chr(145), chr(146), chr(147), chr(148), chr(150), chr(151), chr(133)),
array("'", "'", '"', '"', '-', '--', '...'),
$text);*/
return $text;
}
}
?>