📁 PHP Dosya Yöneticisi
/
/
home
/
demodesigncom
/
takiaksesuar.demodesign.com.tr
/
admin
📝
fonksiyon.php
← Geri Dön
<?php use PHPMailer\PHPMailer\PHPMailer; use PHPMailer\PHPMailer\SMTP; use PHPMailer\PHPMailer\Exception; $bayi_id = 0; if(isset($_SESSION['kullanici']['giris'])){ $musteri = $db->query("SELECT * FROM musteri WHERE id = '{$_SESSION['kullanici']['id']}' AND durum = 1 LIMIT 1")->fetch(PDO::FETCH_ASSOC); if(!$musteri){ unset($_SESSION['kullanici']['giris']); unset($_SESSION['kullanici']['id']); die('<meta http-equiv="refresh" content="0;URL='.$site.'">'); }else{ $bayi_kontrol = $db->query("SELECT id FROM bayi_grup WHERE id = '{$musteri['bayi_grup_id']}' LIMIT 1")->fetch(PDO::FETCH_ASSOC); if($bayi_kontrol){ $bayi_id = $musteri['bayi_grup_id']; } } } function net_gsm($text,$numara){ global $db; global $dil; $net_gsm = $db->query("SELECT * FROM netgsm WHERE dil = '{$dil}' LIMIT 1")->fetch(PDO::FETCH_ASSOC); if(!empty($net_gsm['kullanici_adi']) AND !empty($net_gsm['sifre']) AND !empty($net_gsm['baslik'])){ try { $client = new SoapClient("http://soap.netgsm.com.tr:8080/Sms_webservis/SMS?wsdl"); $msg = $text; $gsm = array('9'.str_replace(' ','',$numara)); $Result = $client->smsGonder1NV2(array('username'=>$net_gsm['kullanici_adi'], 'password' => $net_gsm['sifre'], 'header' => $net_gsm['baslik'], 'msg' => $msg, 'gsm' => $gsm, 'filter' => '', 'startdate' => '', 'stopdate' => '', 'encoding' => '' )); } catch (Exception $exc){ echo "Soap Hatasi Olustu: " . $exc->getMessage(); } } } function fiyat_noktali($tutar){ return number_format($tutar, 2, ',', '.'); } function urun_fiyat($tutar,$kur_tipi,$bayi_id,$kategori_id,$noktala){ global $db; global $kur_fiyatlari; $tutar = $tutar * $kur_fiyatlari[$kur_tipi]; if($bayi_id != 0){ $fiyat_tanim = $db->query("SELECT oran, tip FROM bayi_grup_kategori_fiyat_tanimlari WHERE bayi_grup_id = '{$bayi_id}' AND kategori_id = '{$kategori_id}' LIMIT 1")->fetch(PDO::FETCH_ASSOC); if($fiyat_tanim){ if($fiyat_tanim['tip'] == 1){ $tutar += $fiyat_tanim['oran']; }else if($fiyat_tanim['tip'] == 2){ $tutar -= $fiyat_tanim['oran']; }else if($fiyat_tanim['tip'] == 3){ $tutar = $tutar + (($fiyat_tanim['oran'] * $tutar) / 100); }else if($fiyat_tanim['tip'] == 4){ $tutar = $tutar - (($fiyat_tanim['oran'] * $tutar) / 100); } } } if($noktala == 1){ return number_format($tutar, 2, ',', '.'); }else{ return $tutar; } } function mesaj($metin1, $metin2,$durum){ $durum_dizi = array(0 => 'danger', 1 => 'success'); if(!empty($metin2)){ $metin2 = '<p>'.$metin2.'</p>'; } return '<div class="alert alert-'.$durum_dizi[$durum].'" role="alert"><h3 class="alert-heading" style="font-size:17px">'.$metin1.'</h4>'.$metin2.'</div>'; } function yildiz_sayisi($id,$oran){ global $db; $yildiz = $db->query("SELECT count(id) as toplam FROM urun_yorum WHERE urun_id = '{$id}' AND oran = '{$oran}' AND durum = 1")->fetch(PDO::FETCH_ASSOC); $yorum = $db->query("SELECT count(id) as toplam FROM urun_yorum WHERE urun_id = '{$id}' AND durum = 1")->fetch(PDO::FETCH_ASSOC); if(!$yildiz['toplam'] AND !$yorum['toplam']){ return 0; }else{ return number_format((($yildiz['toplam'] / $yorum['toplam']) * 100), 1, '.', ''); } } function yildiz($id){ global $db; $yildiz_toplam = $db->query("SELECT sum(oran) as toplam FROM urun_yorum WHERE urun_id = '{$id}' AND durum = 1")->fetch(PDO::FETCH_ASSOC); $yorum_sayisi = $db->query("SELECT count(id) as toplam FROM urun_yorum WHERE urun_id = '{$id}' AND durum = 1")->fetch(PDO::FETCH_ASSOC); if(!$yildiz_toplam['toplam']){ $yildiz_toplam['toplam'] = 5; } if(!$yorum_sayisi['toplam']){ $yorum_sayisi['toplam'] = 1; } return number_format(($yildiz_toplam['toplam'] / $yorum_sayisi['toplam']), 1, '.', ''); } function kampanya($vitrin_id){ global $db; global $dil; $query = $db->query("SELECT col_md, resim, link FROM kampanya WHERE dil = '{$dil}' AND vitrin_id = '{$vitrin_id}' ORDER BY sira ASC", PDO::FETCH_ASSOC); if($query->rowCount()){ echo '<section class="banners"><div class="container"><div class="row">'; foreach($query as $row){ echo '<div class="col-md-'.$row['col_md'].'"> <div class="banner-img wow animate__animated animate__fadeInUp" data-wow-delay="0"> <a href="'.$row['link'].'"><img src="upload/'.$row['resim'].'" alt="'.$ayar['title'].'" /></a> </div> </div>'; } echo '</div></div></section>'; } } function fiyat_guncelle($fiyat,$oran,$tip){ if($tip == 1){ $fiyat = $fiyat + $oran; }else if($tip == 2){ $fiyat = $fiyat - $oran; }else if($tip == 3){ $fiyat = $fiyat + ($fiyat * $oran) / 100; }else if($tip == 4){ $fiyat = $fiyat - ($fiyat * $oran) / 100; } return $fiyat; } function ticifastcomtr_kombinasyon(array $varyant, array &$tumu = array(), array $grup = array(), $deger = null, $i = 0){ $sifre = array_keys($varyant); if(isset($deger) === true){ array_push($grup, $deger); } if($i >= count($varyant)){ array_push($tumu, $grup); }else{ $akimKey = $sifre[$i]; $veriler = $varyant[$akimKey]; foreach($veriler as $val){ ticifastcomtr_kombinasyon($varyant, $tumu, $grup, $val, $i + 1); } } return $tumu; } function ip(){ if( isset($_SERVER["HTTP_CLIENT_IP"])){ $ip = $_SERVER["HTTP_CLIENT_IP"]; }elseif(isset($_SERVER["HTTP_X_FORWARDED_FOR"])){ $ip = $_SERVER["HTTP_X_FORWARDED_FOR"]; }else{ $ip = $_SERVER["REMOTE_ADDR"]; } return $ip; } function email_gonder($email,$icerik,$konu){ global $db; global $dil; global $site; global $dil; $ayar = $db->query("SELECT * FROM ayar WHERE dil = '{$dil}' LIMIT 1")->fetch(PDO::FETCH_ASSOC); $mailbody = '<!DOCTYPE html> <html> <head> <title>'.$ayar['title'].'</title> <meta charset="utf-8"> </head> <body style="padding: 30px"> <div style="width: 98%;margin:0 auto;background: #02add9;padding: 1%;display: inline-block;border-radius: 10px"> <div style="width: 90%;float: left;background: #fff;padding: 10px 5% 20px 5%;"> <center><img src="'.$site.'upload/'.$ayar['logo'].'" style="max-width: 200px"></center> '.$icerik.' </div> </div> <style type="text/css"> body{font-family:arial}table{width:100%;border:1px solid #ddd}table tr{padding:0;margin:0}table tr th{border:1px solid #ddd;padding:0;margin:0;background:#02add9;color:#fff;padding:10px}table tr td{border:1px solid #ddd;padding:0;text-align:center;margin:0;border-spacing:0} </style> </body> </html>'; $smtp = $db->query("SELECT * FROM smtp WHERE dil = '{$dil}' LIMIT 1")->fetch(PDO::FETCH_ASSOC); if(!empty($smtp['host']) AND !empty($smtp['email']) AND !empty($smtp['sifre'])){ if(is_file('vendor/autoload.php')){ require 'vendor/autoload.php'; }else{ require '../vendor/autoload.php'; } try { $mail = new PHPMailer(true); $mail->SMTPDebug = SMTP::DEBUG_SERVER; $mail->isSMTP(); $mail->Host = $smtp['host']; $mail->SMTPAuth = true; $mail->Username = $smtp['email']; $mail->Password = $smtp['sifre']; if($smtp['port'] == 0){ $mail->SMTPSecure = $smtp['_ssl']; $mail->Port = $smtp['port']; }else{ $mail->SMTPSecure = 'tls'; $mail->Port = 25; $mail->SMTPOptions = array( 'ssl' => array( 'verify_peer' => false, 'verify_peer_name' => false, 'allow_self_signed' => true ) ); } $mail->CharSet = 'UTF-8'; $mail->SMTPDebug = 0; $mail->setFrom($smtp['email']); $mail->addAddress($email); $mail->isHTML(true); $mail->Subject = $konu; $mail->Body = $mailbody; $mail->AltBody = ''; $mail->send(); } catch (Exception $e) { } } } function Sayfala($total,$page,$limit,$page_url){ if ($total > $limit) : $x = 5; $lastP = ceil($total / $limit); if ($page==1){ echo '<li class="page-item active"><a class="page-link" href="#">1</a></li>'; }else{ echo '<li class="page-item"><a class="page-link" href="'.$page_url.'1">1</a</li>'; } if ($page-$x>2){ echo '<li class="page-item"><a class="page-link" href="#">...</a></li>'; $i = $page-$x; }else{ $i = 2; } for ($i; $i<=$page+$x; $i++){ if ($i==$page) echo '<li class="page-item active"><a class="page-link" href="#">'.$i.'</a></li>'; else echo '<li class="page-item"><a class="page-link" href="'.$page_url.''.$i.'">'.$i.'</a></li>'; if ($i==$lastP) break; } if ($page+$x<$lastP-1){ echo '<li class="page-item"><a class="page-link" href="#">...</a></li>'; echo '<li class="page-item"><a class="page-link" href="'.$page_url.''.$lastP.'">'.$lastP.'</a></li>'; }elseif ($page+$x==$lastP-1){ echo '<li class="page-item"><a class="page-link" href="'.$page_url.''.$lastP.'">'.$lastP.'</a></li>'; } endif; } function price($x){ return number_format($x, 2); } function alt_kategori_id_bul($ust_kategori){ global $db; global $dil; $alt_kategoriler = $db->query("SELECT id FROM kategori WHERE ust_kategori = '{$ust_kategori}' AND dil = '{$dil}' ORDER BY sira ASC", PDO::FETCH_ASSOC); if($alt_kategoriler->rowCount()){ $id = $ust_kategori.','; foreach ($alt_kategoriler as $data){ $id .= alt_kategori_id_bul($data['id'],$dil).','; } }else{ $id = $ust_kategori.','; } $id = rtrim($id,','); return $id; } function ust_kategori_isim_bul($id,$baslik,$dil){ global $db; $ust_kategori = $db->query("SELECT id, baslik, ust_kategori FROM kategori WHERE id = '{$id}' AND dil = '{$dil}' LIMIT 1")->fetch(PDO::FETCH_ASSOC); if($ust_kategori){ $baslik = $ust_kategori['baslik'].' > '.$baslik; if($ust_kategori['ust_kategori'] > 0){ return ust_kategori_isim_bul($ust_kategori['ust_kategori'],$baslik,$dil); }else{ return $baslik; } }else{ return $baslik; } } function parseJsonArray($jsonArray, $parentID = 0) { $return = array(); foreach ($jsonArray as $subArray) { $returnSubSubArray = array(); if (isset($subArray->children)) { $returnSubSubArray = parseJsonArray($subArray->children, $subArray->id); } $return[] = array('id' => $subArray->id, 'parentID' => $parentID); $return = array_merge($return, $returnSubSubArray); } return $return; } function sef($str, $options = array()){ $str = mb_convert_encoding((string)$str, 'UTF-8', mb_list_encodings()); $defaults = array('delimiter' => '-','limit' => null,'lowercase' => true,'replacements' => array(),'transliterate' => true); $options = array_merge($defaults, $options); $char_map = array( // Latin 'À' => 'A', 'Á' => 'A', 'Â' => 'A', 'Ã' => 'A', 'Ä' => 'A', 'Å' => 'A', 'Æ' => 'AE', 'Ç' => 'C', 'È' => 'E', 'É' => 'E', 'Ê' => 'E', 'Ë' => 'E', 'Ì' => 'I', 'Í' => 'I', 'Î' => 'I', 'Ï' => 'I', 'Ð' => 'D', 'Ñ' => 'N', 'Ò' => 'O', 'Ó' => 'O', 'Ô' => 'O', 'Õ' => 'O', 'Ö' => 'O', 'Ő' => 'O', 'Ø' => 'O', 'Ù' => 'U', 'Ú' => 'U', 'Û' => 'U', 'Ü' => 'U', 'Ű' => 'U', 'Ý' => 'Y', 'Þ' => 'TH', 'ß' => 'ss', 'à' => 'a', 'á' => 'a', 'â' => 'a', 'ã' => 'a', 'ä' => 'a', 'å' => 'a', 'æ' => 'ae', 'ç' => 'c', 'è' => 'e', 'é' => 'e', 'ê' => 'e', 'ë' => 'e', 'ì' => 'i', 'í' => 'i', 'î' => 'i', 'ï' => 'i', 'ð' => 'd', 'ñ' => 'n', 'ò' => 'o', 'ó' => 'o', 'ô' => 'o', 'õ' => 'o', 'ö' => 'o', 'ő' => 'o', 'ø' => 'o', 'ù' => 'u', 'ú' => 'u', 'û' => 'u', 'ü' => 'u', 'ű' => 'u', 'ý' => 'y', 'þ' => 'th', 'ÿ' => 'y', // Latin symbols '©' => '(c)', // Greek 'Α' => 'A', 'Β' => 'B', 'Γ' => 'G', 'Δ' => 'D', 'Ε' => 'E', 'Ζ' => 'Z', 'Η' => 'H', 'Θ' => '8', 'Ι' => 'I', 'Κ' => 'K', 'Λ' => 'L', 'Μ' => 'M', 'Ν' => 'N', 'Ξ' => '3', 'Ο' => 'O', 'Π' => 'P', 'Ρ' => 'R', 'Σ' => 'S', 'Τ' => 'T', 'Υ' => 'Y', 'Φ' => 'F', 'Χ' => 'X', 'Ψ' => 'PS', 'Ω' => 'W', 'Ά' => 'A', 'Έ' => 'E', 'Ί' => 'I', 'Ό' => 'O', 'Ύ' => 'Y', 'Ή' => 'H', 'Ώ' => 'W', 'Ϊ' => 'I', 'Ϋ' => 'Y', 'α' => 'a', 'β' => 'b', 'γ' => 'g', 'δ' => 'd', 'ε' => 'e', 'ζ' => 'z', 'η' => 'h', 'θ' => '8', 'ι' => 'i', 'κ' => 'k', 'λ' => 'l', 'μ' => 'm', 'ν' => 'n', 'ξ' => '3', 'ο' => 'o', 'π' => 'p', 'ρ' => 'r', 'σ' => 's', 'τ' => 't', 'υ' => 'y', 'φ' => 'f', 'χ' => 'x', 'ψ' => 'ps', 'ω' => 'w', 'ά' => 'a', 'έ' => 'e', 'ί' => 'i', 'ό' => 'o', 'ύ' => 'y', 'ή' => 'h', 'ώ' => 'w', 'ς' => 's', 'ϊ' => 'i', 'ΰ' => 'y', 'ϋ' => 'y', 'ΐ' => 'i', // Turkish 'Ş' => 'S', 'İ' => 'I', 'Ç' => 'C', 'Ü' => 'U', 'Ö' => 'O', 'Ğ' => 'G', 'ş' => 's', 'ı' => 'i', 'ç' => 'c', 'ü' => 'u', 'ö' => 'o', 'ğ' => 'g', // Russian 'А' => 'A', 'Б' => 'B', 'В' => 'V', 'Г' => 'G', 'Д' => 'D', 'Е' => 'E', 'Ё' => 'Yo', 'Ж' => 'Zh', 'З' => 'Z', 'И' => 'I', 'Й' => 'J', 'К' => 'K', 'Л' => 'L', 'М' => 'M', 'Н' => 'N', 'О' => 'O', 'П' => 'P', 'Р' => 'R', 'С' => 'S', 'Т' => 'T', 'У' => 'U', 'Ф' => 'F', 'Х' => 'H', 'Ц' => 'C', 'Ч' => 'Ch', 'Ш' => 'Sh', 'Щ' => 'Sh', 'Ъ' => '', 'Ы' => 'Y', 'Ь' => '', 'Э' => 'E', 'Ю' => 'Yu', 'Я' => 'Ya', 'а' => 'a', 'б' => 'b', 'в' => 'v', 'г' => 'g', 'д' => 'd', 'е' => 'e', 'ё' => 'yo', 'ж' => 'zh', 'з' => 'z', 'и' => 'i', 'й' => 'j', 'к' => 'k', 'л' => 'l', 'м' => 'm', 'н' => 'n', 'о' => 'o', 'п' => 'p', 'р' => 'r', 'с' => 's', 'т' => 't', 'у' => 'u', 'ф' => 'f', 'х' => 'h', 'ц' => 'c', 'ч' => 'ch', 'ш' => 'sh', 'щ' => 'sh', 'ъ' => '', 'ы' => 'y', 'ь' => '', 'э' => 'e', 'ю' => 'yu', 'я' => 'ya', // Ukrainian 'Є' => 'Ye', 'І' => 'I', 'Ї' => 'Yi', 'Ґ' => 'G', 'є' => 'ye', 'і' => 'i', 'ї' => 'yi', 'ґ' => 'g', // Czech 'Č' => 'C', 'Ď' => 'D', 'Ě' => 'E', 'Ň' => 'N', 'Ř' => 'R', 'Š' => 'S', 'Ť' => 'T', 'Ů' => 'U', 'Ž' => 'Z', 'č' => 'c', 'ď' => 'd', 'ě' => 'e', 'ň' => 'n', 'ř' => 'r', 'š' => 's', 'ť' => 't', 'ů' => 'u', 'ž' => 'z', // Polish 'Ą' => 'A', 'Ć' => 'C', 'Ę' => 'e', 'Ł' => 'L', 'Ń' => 'N', 'Ó' => 'o', 'Ś' => 'S', 'Ź' => 'Z', 'Ż' => 'Z', 'ą' => 'a', 'ć' => 'c', 'ę' => 'e', 'ł' => 'l', 'ń' => 'n', 'ó' => 'o', 'ś' => 's', 'ź' => 'z', 'ż' => 'z', // Latvian 'Ā' => 'A', 'Č' => 'C', 'Ē' => 'E', 'Ģ' => 'G', 'Ī' => 'i', 'Ķ' => 'k', 'Ļ' => 'L', 'Ņ' => 'N', 'Š' => 'S', 'Ū' => 'u', 'Ž' => 'Z', 'ā' => 'a', 'č' => 'c', 'ē' => 'e', 'ģ' => 'g', 'ī' => 'i', 'ķ' => 'k', 'ļ' => 'l', 'ņ' => 'n', 'š' => 's', 'ū' => 'u', 'ž' => 'z' ); $str = preg_replace(array_keys($options['replacements']), $options['replacements'], $str); if ($options['transliterate']) { $str = str_replace(array_keys($char_map), $char_map, $str); } $str = preg_replace('/[^\p{L}\p{Nd}]+/u', $options['delimiter'], $str); $str = preg_replace('/(' . preg_quote($options['delimiter'], '/') . '){2,}/', '$1', $str); $str = mb_substr($str, 0, ($options['limit'] ? $options['limit'] : mb_strlen($str, 'UTF-8')), 'UTF-8'); $str = trim($str, $options['delimiter']); return $options['lowercase'] ? mb_strtolower($str, 'UTF-8') : $str; } function temizle($veri){ foreach(array('from','where','concat','limit',"'",'char','select','insert','delete','update','drop table','union','null','select','insert','delete','update','drop table','union','null','order by',';','exec','shell','cmd') as $filtre){ $veri = str_ireplace($filtre,'',$veri); } return strip_tags(trim($veri)); } function meta_tag_degistir($icerik) { global $_title, $_description, $_resim, $_canonical; $icerik = str_replace('[$_title]', $_title, $icerik); $icerik = str_replace('[$_description]', $_description, $icerik); $icerik = str_replace('[$_resim]', $_resim, $icerik); $icerik = str_replace('[$_canonical]', $_canonical, $icerik); return $icerik; } // SSL Yönlendirme $http_https = ((!empty($_SERVER['HTTPS']) && $_SERVER['HTTPS'] != 'off') || $_SERVER['SERVER_PORT'] == 443) ? "https://" : "http://"; if($ssl == 'on' AND $http_https == 'http://'){ if(empty($_SERVER['HTTPS']) || $_SERVER['HTTPS'] == "off"){ header('Location: https://'.$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI']); exit(); } }else if($ssl == 'off' AND $http_https == 'https://'){ header('Location: http://'.$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI']); exit(); } // WWW Yönlendirme if($www == 'on' AND substr($_SERVER['HTTP_HOST'], 0, 4) != 'www.'){ header('Location: '.$http_https.'www.'.$_SERVER['HTTP_HOST']); exit(); }else if($www == 'off' AND substr($_SERVER['HTTP_HOST'], 0, 4) == 'www.'){ header('Location: '.$http_https.str_replace('www.','',$_SERVER['SERVER_NAME'])); exit(); } ?>
💾 Kaydet
İptal
📝 Yeniden Adlandır
İptal
Kaydet
🔐 Dosya İzinleri (chmod)
İzin Değeri:
Hızlı Seçim:
777
755
644
600
777
= Herkes okur/yazar/çalıştırır
755
= Sahip tam, diğerleri okur/çalıştırır
644
= Sahip okur/yazar, diğerleri okur
600
= Sadece sahip okur/yazar
İptal
Uygula