array( "hu" => "Engedélyokiratok", "en" => "Engedélyokiratok", "ru" => "Engedélyokiratok"), 2 => array( "hu" => "Biztonsági adatlapok, használati útmutatók", "en" => "Biztonsági adatlapok, használati útmutatók", "ru" => "Biztonsági adatlapok, használati útmutatók"), 3 => array( "hu" => "Egyéb tanúsítványok", "en" => "Egyéb tanúsítványok", "ru" => "Egyéb tanúsítványok"), 4 => array( "hu" => "Prospektusok, termékismertetők", "en" => "Prospektusok, termékismertetők", "ru" => "Prospektusok, termékismertetők"), 5 => array( "hu" => "Szakmai cikkek, információk", "en" => "Szakmai cikkek, információk", "ru" => "Szakmai cikkek, információk") ); ?>SQL: $sqlstr"); } else { $result=mysqli_query($GLOBALS["db_link"], $sqlstr); if (mysqli_error($GLOBALS['db_link'])) { file_put_contents($base_dir."sqldebug.txt", $_SERVER['REQUEST_URI']."\n".mysqli_error($GLOBALS['db_link'])."\n$sqlstr\n".print_r(debug_backtrace(), true)); mail('nand@item.hu', "{$_config['site_name']} SQL error", $_SERVER['REQUEST_URI']."\n".mysqli_error($GLOBALS['db_link'])."\n$sqlstr\n".print_r(debug_backtrace(), true)); die ("REQUEST ERROR"); } } if ($debug==1) { echo "
SQL debug: $sqlstr"; } return $result; } function OneObject($str, $debug=0) { $sqlres=DoSQL($str, $debug); $obj=mysqli_fetch_object($sqlres); return($obj); } function OneData($str, $debug=0) { $sqlres=DoSQL($str, $debug); $arr=mysqli_fetch_array($sqlres); return($arr[0]); } function OneArray($str, $debug=0) { $sqlres=DoSQL($str, $debug); $obj=mysqli_fetch_array($sqlres); return($obj); } function mres($string) { return mysqli_real_escape_string($GLOBALS["db_link"], $string); } function DB_fetch_array($result) { if (is_object($result)){ return mysqli_fetch_array($result); } else{ echo 'DB_fetch_array : hibás argumentum!
'; return false; } } function DB_fetch_assoc($result) { if (is_object($result)){ return mysqli_fetch_assoc($result); } else{ echo 'DB_fetch_assoc: hibás argumentum!
'; return false; } } function DB_num_rows($result){ return mysqli_num_rows($result); } function DB_affected_rows(){ return mysqli_affected_rows($GLOBALS["db_link"]); } function DB_insert_id(){ return mysqli_insert_id($GLOBALS["db_link"]); } function n_imgresize($inputfile, $outputfile, $width, $height, $force_resize_if_smaller=FALSE) { $filename = $inputfile; // Get new dimensions list($width_orig, $height_orig) = getimagesize($filename); if ((($width_orig>$width) || ($height_orig>$height)) || ($force_resize_if_smaller)) { $ratio_orig = $width_orig/$height_orig; if ($width/$height > $ratio_orig) { $width = $height*$ratio_orig; } else { $height = $width/$ratio_orig; } /* // Resample $image_p = imagecreatetruecolor($width, $height); $picsize=GetImageSize($filename); switch($picsize[2]) { case '1': $image = imagecreatefromgif($filename); break; case '2': $image = imagecreatefromjpeg($filename); break; case '3': $image = imagecreatefrompng($filename); break; } imagecopyresampled($image_p, $image, 0, 0, 0, 0, $width, $height, $width_orig, $height_orig); */ // Resample $image_p = imagecreatetruecolor($width, $height); $picsize=GetImageSize($filename); switch($picsize[2]) { case '1': $image = imagecreatefromgif($filename); break; case '2': $image = imagecreatefromjpeg($filename); break; case '3': $image = imagecreatefrompng($filename); imageAlphaBlending($image, true); imageSaveAlpha($image, true); imagesavealpha($image_p, true); $trans_colour = imagecolorallocatealpha($image_p, 0, 0, 0, 127); imagefill($image_p, 0, 0, $trans_colour); break; } imagecopyresampled($image_p, $image, 0, 0, 0, 0, $width, $height, $width_orig, $height_orig); // Output #imagejpeg($image_p, null, 100); switch($picsize[2]) { case '1': imagegif($image_p, $outputfile); break; case '2': imagejpeg($image_p, $outputfile); break; case '3': imagepng($image_p, $outputfile); break; } // Output if ($outputfile) imagejpeg($image_p, $outputfile); else imagejpeg($image_p); } } function n_imgcrop($inputfile, $outputfile, $tnw, $tnh) { $image = imagecreatefromjpeg($inputfile); $thumb_width = $tnw; $thumb_height = $tnh; $width = imagesx($image); $height = imagesy($image); $original_aspect = $width / $height; $thumb_aspect = $thumb_width / $thumb_height; if ( $original_aspect >= $thumb_aspect ) { // If image is wider than thumbnail (in aspect ratio sense) $new_height = $thumb_height; $new_width = $width / ($height / $thumb_height); } else { // If the thumbnail is wider than the image $new_width = $thumb_width; $new_height = $height / ($width / $thumb_width); } $thumb = imagecreatetruecolor( $thumb_width, $thumb_height ); // Resize and crop imagecopyresampled($thumb, $image, 0 - ($new_width - $thumb_width) / 2, // Center the image horizontally 0 - ($new_height - $thumb_height) / 2, // Center the image vertically 0, 0, $new_width, $new_height, $width, $height); imagejpeg($thumb, $outputfile); } function n_imgfill($inputfile, $thumb_width, $thumb_height) { $thumb = imagecreatetruecolor( $thumb_width, $thumb_height ); $picsize=GetImageSize($inputfile); switch($picsize[2]) { case '2': $image = imagecreatefromjpeg($inputfile); $white = imagecolorallocate($thumb, 255, 255, 255); imagefilledrectangle($thumb, 0, 0, $thumb_width, $thumb_height, $white); break; case '3': $image = imagecreatefrompng($inputfile); imageAlphaBlending($image, true); imageSaveAlpha($image, true); imagesavealpha($thumb, true); $trans_colour = imagecolorallocatealpha($thumb, 0, 0, 0, 127); imagefill($thumb, 0, 0, $trans_colour); break; } #debug($picsize); #n_imgresize($inputfile, "tmpimg.jpg", $thumb_width, $thumb_height, false); #$image = imagecreatefromjpeg("tmpimg.jpg"); $width_copy=imagesx($image); $height_copy=imagesy($image); $x=round($thumb_width/2)-round($width_copy/2); $y=round($thumb_height/2)-round($height_copy/2); imagecopy($thumb, $image, $x, $y, 0, 0, $width_copy, $height_copy); switch($picsize[2]) { case '2': imagejpeg($thumb, $inputfile); break; case '3': imagepng($thumb, $inputfile); break; } #imagejpeg($thumb, $outputfile); imagedestroy($thumb); imagedestroy($image); #@unlink("tmpimg.jpg"); } function lid() { return OneData("SELECT LAST_INSERT_ID()"); } function debug($var) { echo "
";
  print_r($var);
  echo "
"; } function uzenet($szoveg) { if (is_array($szoveg)) $sz=implode("
", $szoveg); else $sz=$szoveg; echo "
$sz
"; } function mres_vars($arr) { if (is_array($arr)) { foreach($arr AS $key => $value) { if (!is_array($value)) $arr[$key]=mres($value); } } } function linker_allget($except_key, $except_value) { $uri=array(); foreach($_GET AS $key => $value) { if (is_array($except_key)) { if (!in_array($key, $except_key) && (strlen($value)>0)) $uri[]="$key=$value"; } elseif (($key!=$except_key) && (strlen($value)>0)) { $uri[]="$key=$value"; } } if (is_array($except_key)) { for ($i=0; $i $value) { $uri.="$key=$value"; } } } else { $uri=$linker_url."index.php"; #$_SERVER[PHP_SELF]; if ($s1) $uri.="?item=$s1"; if ($s2) if (substr($s2, 0, 1)=="#") $uri.=$s2; else $uri.="&page=$s2"; if ($s3) if (substr($s3, 0, 1)=="#") $uri.=$s3; else $uri.="&subpage=$s3"; if ($s4) if (substr($s4, 0, 1)=="#") $uri.=$s4; else $uri.="&subpage2=$s4"; if (is_array($params)) { if ($s1) $uri.='&'; else $uri.="?"; foreach($params AS $key => $value) { $uri.="$key=$value"; } } } return $uri; } function toAscii($str, $replace=array(), $delimiter='-') { setlocale(LC_ALL, 'en_US.UTF8'); if( !empty($replace) ) { $str = str_replace((array)$replace, ' ', $str); } $clean = iconv('UTF-8', 'ASCII//TRANSLIT', $str); $clean = preg_replace("/[^a-zA-Z0-9\/_|+ -]/", '', $clean); $clean = strtolower(trim($clean, '-')); $clean = preg_replace("/[\/_|+ -]+/", $delimiter, $clean); return $clean; } function nmail ($felado, $feladomailcim, $cimzettmailcim, $targy, $csatolmany, $leveltorzs, $cssfile='', $nohtml='') { $html=' '; if ($cssfile) { #$handle = fopen($cssfile, "rb"); $csstorzs = fread($handle, filesize($cssfile)); $csstorzs=file_get_contents($cssfile); #fclose($handle); $html.=""; } $html.="".$leveltorzs.""; if (!$nohtml) $nohtml="Csak HTML-t ismero levelezo tamogatott!"; $mail = new PHPMailer; $mail->CharSet = 'utf-8'; $mail->setFrom($feladomailcim, $felado); $mail->addAddress($cimzettmailcim); $mail->Subject = $targy; $mail->AltBody = $nohtml; $mail->msgHTML($leveltorzs, dirname(__FILE__).'/../'); if ($csatolmany) $mail->addAttachment($csatolmany); if (!$mail->send()) { echo "Mailer Error: " . $mail->ErrorInfo; return false; } else { return true; } } function make_pass($hossz=8) { srand ((float) microtime() * 10000000); $chars=array(); $pass=''; for ($i=48; $i<=57; $i++) $chars[]=chr($i); for ($i=65; $i<=90; $i++) $chars[]=chr($i); for ($i=97; $i<=122; $i++) $chars[]=chr($i); $rand_keys = array_rand ($chars, $hossz); shuffle($rand_keys); for ($i=0; $i document.location.href='$url'; "; return true; } function adm_login() { if (isset($_POST["up"]) AND !isset($_SESSION["sess_shop_admin"])) { $sqlstr="SELECT * FROM admins WHERE passw_encoded=MD5(CONCAT('".mres($_POST["up"])."', `salt`)) AND admins_email='".mres($_POST['un'])."'"; #echo $sqlstr; $vanuser=OneArray($sqlstr); if ($vanuser) { $_SESSION["sess_shop_admin"]=$vanuser['admins_id']; $_SESSION["admin"]=$vanuser; } } // endif (isset($upwd)) } function bentadm() { if ($_SESSION["sess_shop_admin"]>0) return TRUE; else return FALSE; } function decodeMultilangual($col, $lang='') { if (!strlen($lang)) $lang=$_SESSION['lang']; $obj = json_decode($col); #debug($obj); #debug($lang); $ret = ''; if (!empty($obj->{$lang})) $ret = base64_decode($obj->{$lang}); return $ret; } function initGyikBox($id) { $html = array(); $row = OneArray("SELECT `text` FROM `"._TINY_."_gyik` WHERE `id` = '".$id."'"); $text = decodeMultilangual($row['text'], $_SESSION['lang']); if (strstr($row['css_classes'], "leafWrapper")) { $html[] = "
".$text."
"; } else { $html[] = $text; } return implode("\n", $html); } function getMenuName($tinyName) { $row = OneArray("SELECT `title` FROM `"._TINY_."_menu` WHERE `link` = '".$tinyName."'"); return decodeMultilangual($row['title'], $_SESSION['lang']); } function dateformat($str, $full=false) { $pcs=explode('-', substr($str, 0, 10)); switch ($_SESSION['lang']) { case 'hu': return "{$pcs[0]}. {$pcs[1]}. {$pcs[2]}."; break; default: return "{$pcs[1]}. {$pcs[2]}. {$pcs[0]}."; break; } } //INITIALIZE TEXT BOX BY ID function initTextBox($id) { global $lng; $html = array(); $row = OneArray("SELECT * FROM `"._TINY_."_text_boxes` WHERE `random_id` = '".$id."'"); $text = html_entity_decode(decodeMultilangual($row['text'])); #$text=$_SESSION['lang']; if (strlen($row['utmutato_hu']) && ($_SESSION['lang']=='hu')) { $text.="

".sprintf($lng['utmutato_letoltes'], $row['utmutato_hu'])."

"; } if (strlen($row['utmutato_en']) && ($_SESSION['lang']=='en')) { $text.="

".sprintf($lng['utmutato_letoltes'], $row['utmutato_en'])."

"; } if (strlen($row['utmutato_ru']) && ($_SESSION['lang']=='ru')) { $text.="

".sprintf($lng['utmutato_letoltes'], $row['utmutato_ru'])."

"; } # youtube link csere preg_match_all( '/https:\/\/(?:www\.)?youtu(?:be\.com\/watch\?v=|\.be\/)([\w\-\_]*)?/i', #'/http(?:s?):\/\/(?:www\.)?youtu(?:be\.com\/watch\?v=|\.be\/)([\w\-\_]*)(&(amp;)?[\w\?=]*)?/i', $text, $matches ); #$text.=print_r($matches, true); foreach($matches[0] AS $key => $value) { if (strpos($value, ' ')>0) $value=substr($value, 0, strpos($value, ' ')); if (strpos($value, '<')>0) $value=substr($value, 0, strpos($value, '<')); $text=str_replace( array($value), #array("$value"), '', $text); } # /youtube link csere if (strstr($row['css_classes'], "leafWrapper")) { $html[] = "
".$text."
"; } else { $html[] = $text; } return implode("\n", $html); } //INITIALIZE FORM function initForm($id) { $i = 0; $inputArr = $html = array(); $hasCheckbox = $hasTextfield = false; $r = OneArray("SELECT * FROM `"._TINY_."_form` WHERE `random_id` = '".$id."'"); $res = DoSQL("SELECT * FROM `"._TINY_."_form_inputs` WHERE `form_id` = '".$r['id']."' ORDER BY `pos`"); $sum = db_num_rows($res); while ($row = db_fetch_array($res)) { $inputArr[] = array( 'num' => $i, 'name' => $row['name'], 'type' => $row['type'], 'label' => $row['label'], 'formId' => $row['form_id'], 'css' => $row['css_classes'], 'required' => $row['required'] ); if ($row['type'] == "checkbox") { $hasCheckbox = true; } elseif ($row['type'] == "textarea") { $hasTextarea = true; } else { $hasTextfield = true; } $i++; } //only text fields if ($hasCheckbox == false && $hasTextfield == true) { foreach ($inputArr as $row) { if ($row['type'] == "text") { $html[] = "
"; // $html[] = "
"; $html[] = "
".decodeMultilangual($row['label'], $_SESSION['lang']).":
"; $html[] = "
"; // $html[] = "
"; $html[] = "
"; } } } //only checkboxes elseif ($hasCheckbox == true && $hasTextfield == false) { $chbArr = $inputArr; foreach ($chbArr as $key => $value) { if ($value['type'] !== "checkbox") { unset($chbArr[$key]); } } $chbLen = count($chbArr); $html[] = "
"; if ($chbLen == 1) { $html[] = "
"; foreach ($chbArr as $row) { if ($row['type'] == "checkbox") { $html[] = checkbox($row['name'], decodeMultilangual($row['label'], $_SESSION['lang']), $row['formId'], $row['css']); } } $html[] = "
"; } elseif ($chbLen > 1) { $firsthalf = array_slice($chbArr, 0, $chbLen / 2); $secondhalf = array_slice($chbArr, $chbLen / 2); $html[] = "
"; foreach ($firsthalf as $row) { $html[] = checkbox($row['name'], decodeMultilangual($row['label'], $_SESSION['lang']), $row['formId'], $row['css']); } $html[] = "
"; $html[] = "
"; foreach ($secondhalf as $row) { $html[] = checkbox($row['name'], decodeMultilangual($row['label'], $_SESSION['lang']), $row['formId'], $row['css']); } $html[] = "
"; } $html[] = "
"; } //both elseif ($hasCheckbox == true && $hasTextfield == true) { $chbArr = $inputArr; foreach ($chbArr as $key => $value) { if ($value['type'] !== "checkbox") { unset($chbArr[$key]); } } $chbLen = count($chbArr); foreach ($inputArr as $row) { if ($row['type'] == "text") { //text fields $html[] = "
"; $html[] = "
".decodeMultilangual($row['label'], $_SESSION['lang']).":
"; $html[] = "
"; $html[] = "
"; } elseif ($row['type'] == "checkbox") { //checkboxes $html[] = "
"; $html[] = "
 
"; $html[] = "
"; #$html[] = "
"; $html[] = checkbox($row['name'], decodeMultilangual($row['label'], $_SESSION['lang']), $row['formId'], $row['css']); #$html[] = "
"; $html[] = "
"; $html[] = "
"; } } } if ($hasTextarea == true) { foreach ($inputArr as $row) { if ($row['type'] == "textarea") { //textarea $html[] = textarea($row['name'], decodeMultilangual($row['label'], $_SESSION['lang']), $row['formId'], $row['css'], $row['required']); } } } return implode("\n", $html); } function checkbox($name, $label, $formId, $css) { /* return "
"; */ return "
"; } //TEXTAREA function textarea($name, $label, $formId, $css, $required) { $html = array(); $html[] = "
"; #$html[] = "
"; $html[] = "
".$label.":
"; #$html[] = "
"; #$html[] = "
"; $html[] = "
"; #$html[] = "
"; $html[] = "
"; return implode("\n", $html); } function initResultsList($files = false) { global $lng; $html = array(); $counter = 1; $tablecounter=1; $results = ($files == false ? DoSQL("SELECT * FROM `"._TINY_."_results` WHERE `file_d` = '' ORDER BY `pos` ASC") : DoSQL("SELECT * FROM `"._TINY_."_results` WHERE `file_d` != '' ORDER BY `pos` ASC")); $html[] = "
"; while ($row = db_fetch_array($results)) { $title = decodeMultilangual($row['title'], $_SESSION['lang']); $text = decodeMultilangual($row['text'], $_SESSION['lang']); $image = (strstr($row['image'], '//') ? $row['image'] : "img/gallery/results/".$row['image']); $file = ""; #$imgBlock = ""; $imgBlock = "
"; $txtBlock = "

".($files !== false ? $file : "").$title.($files !== false ? "" : "")."

\n".$text; $html[] = "
"; if ($row['szazalek']>0) { $html[] = "
{$title}
{$lng['kontroll_tonna']} {$lng['kezelt_terulet_tonna']} {$lng['novekmeny']} {$lng['szazalek']}
{$row['kontroll_tonna']} {$row['kezelt_terulet_tonna']} {$row['novekmeny']} {$row['szazalek']} %
"; $tablecounter++; if ($tablecounter>6) $tablecounter=1; } else { $html[]="

$title

"; } $html[] = $text.$imgBlock; $html[] = "
"; # /col $counter++; if ($counter % 2) $html[]="
"; } $html[] = "
"; # /row return implode("\n\n", $html); } function initImageBox($id, $disableLink = false, $show_title = true, $textOnly = false) { $html = array(); $row = OneArray("SELECT * FROM `"._TINY_."_image_boxes` WHERE `random_id` = '".$id."'"); if ($show_title) $title = trim(decodeMultilangual($row['title'], $_SESSION['lang'])); $text = trim(decodeMultilangual($row['text'], $_SESSION['lang'])); $image = (strstr($row['image'], '//') ? $row['image'] : "img/gallery/imagebox/".$row['image']); $image = imgurl($image); $grid = ($row['type_id'] == 1 ? 'col-12' : 'col-12 col-sm-6'); $wrapperClass = (strstr($text, 'logoWhite') ? " class=\"productLogoWrapper\"" : ""); if ($textOnly) { $html[] = $text; } else { if (!empty($row['link_url']) && $disableLink == false) { $html[] = " $title "; #if ($plusRounded) $html[] = " ".($row['vertical_center'] == 1 ? "" : "")." ".($row['random_id'] == "xxYJb" ? "" : "")." ".($row['random_id'] == "A6w3Y" ? "" : "")." ".(!empty($title) ? "

".$title."

" : "")." ".(!empty($text) ? $text : "")." ".($row['vertical_center'] == 1 ? '
' : '')." "; $html[] = "
"; } else { // if($row['type_id'] == 1) { var_dump($row['text']); var_dump($this->decodeMultilangual($row['text'], $_SESSION['lang'])); die; } $html[] = "
$title
"; #if ($plusRounded) $html[] = "
".($row['vertical_center'] == 1 ? "" : "")." ".(!empty($title) ? "

".$title."

" : "")." ".(!empty($text) ? $text : "")." ".($row['vertical_center'] == 1 ? '' : '')."
"; $html[] = "
"; } } return implode("\n", $html); } function sql_to_array($sqlstr) { $res=DoSQL($sqlstr); } function initParallax($id) { $html = array(); $row = OneArray("SELECT * FROM `"._TINY_."_parallax` WHERE `random_id` = '".$id."'"); $title = decodeMultilangual($row['title'], $_SESSION['lang']); $lead = decodeMultilangual($row['text'], $_SESSION['lang']); #$html[] = "
"; #
$html[] = "
"; #$html[] = "
\n
"; $html[] = "
"; if (strstr($row['css_classes'], "top")) { $html[] = "".$title.""; } elseif (strstr($row['css_classes'], "h3")) { $html[] = "

".$title."

\n".(!empty($lead) ? $lead : '')."
"; } else { $html[] = "

".$title."

\n".(!empty($lead) ? $lead : '')."
"; } #$html[] = "
\n
\n
"; $html[] = "\n
\n
"; return implode("\n", $html); } function imgurl($url) { global $base_url; return str_replace(array("http://terragro.hu/", "http://teszt.terragro.hu/"), array($base_url, $base_url), $url); } ?>