1) { //TODO: Dil secilmemisse... if (!$_SESSION['lang']['id']) { $_SESSION['lang']['id'] = SingleResult($connection,"SELECT id FROM a_diller WHERE varsayilan='1' AND durum='1'"); $_SESSION['lang']['dbfix'] = SingleResult($connection,"SELECT dbfix FROM a_diller WHERE varsayilan='1' AND durum='1'"); } if ($_GET['lang']) { $_SESSION['lang']['id'] = SingleResult($connection,"SELECT id FROM a_diller WHERE rewrite='".sqget('lang')."' AND durum='1'"); $_SESSION['lang']['dbfix'] = SingleResult($connection,"SELECT dbfix FROM a_diller WHERE rewrite='".sqget('lang')."' AND durum='1'"); } //TODO: Dil dosyasi cekiliyor... include ("_languages.php"); } if (!$_SESSION['lang']['dbfix']) { $_SESSION['lang']['dbfix'] = "tr_"; } //TODO: Mobile Controller $useragent=$_SERVER['HTTP_USER_AGENT']; if(preg_match('/(android|bb\d+|meego).+mobile|avantgo|bada\/|blackberry|blazer|compal|elaine|fennec|hiptop|iemobile|ip(hone|od)|iris|kindle|lge |maemo|midp|mmp|netfront|opera m(ob|in)i|palm( os)?|phone|p(ixi|re)\/|plucker|pocket|psp|series(4|6)0|symbian|treo|up\.(browser|link)|vodafone|wap|windows (ce|phone)|xda|xiino/i',$useragent)||preg_match('/1207|6310|6590|3gso|4thp|50[1-6]i|770s|802s|a wa|abac|ac(er|oo|s\-)|ai(ko|rn)|al(av|ca|co)|amoi|an(ex|ny|yw)|aptu|ar(ch|go)|as(te|us)|attw|au(di|\-m|r |s )|avan|be(ck|ll|nq)|bi(lb|rd)|bl(ac|az)|br(e|v)w|bumb|bw\-(n|u)|c55\/|capi|ccwa|cdm\-|cell|chtm|cldc|cmd\-|co(mp|nd)|craw|da(it|ll|ng)|dbte|dc\-s|devi|dica|dmob|do(c|p)o|ds(12|\-d)|el(49|ai)|em(l2|ul)|er(ic|k0)|esl8|ez([4-7]0|os|wa|ze)|fetc|fly(\-|_)|g1 u|g560|gene|gf\-5|g\-mo|go(\.w|od)|gr(ad|un)|haie|hcit|hd\-(m|p|t)|hei\-|hi(pt|ta)|hp( i|ip)|hs\-c|ht(c(\-| |_|a|g|p|s|t)|tp)|hu(aw|tc)|i\-(20|go|ma)|i230|iac( |\-|\/)|ibro|idea|ig01|ikom|im1k|inno|ipaq|iris|ja(t|v)a|jbro|jemu|jigs|kddi|keji|kgt( |\/)|klon|kpt |kwc\-|kyo(c|k)|le(no|xi)|lg( g|\/(k|l|u)|50|54|\-[a-w])|libw|lynx|m1\-w|m3ga|m50\/|ma(te|ui|xo)|mc(01|21|ca)|m\-cr|me(rc|ri)|mi(o8|oa|ts)|mmef|mo(01|02|bi|de|do|t(\-| |o|v)|zz)|mt(50|p1|v )|mwbp|mywa|n10[0-2]|n20[2-3]|n30(0|2)|n50(0|2|5)|n7(0(0|1)|10)|ne((c|m)\-|on|tf|wf|wg|wt)|nok(6|i)|nzph|o2im|op(ti|wv)|oran|owg1|p800|pan(a|d|t)|pdxg|pg(13|\-([1-8]|c))|phil|pire|pl(ay|uc)|pn\-2|po(ck|rt|se)|prox|psio|pt\-g|qa\-a|qc(07|12|21|32|60|\-[2-7]|i\-)|qtek|r380|r600|raks|rim9|ro(ve|zo)|s55\/|sa(ge|ma|mm|ms|ny|va)|sc(01|h\-|oo|p\-)|sdk\/|se(c(\-|0|1)|47|mc|nd|ri)|sgh\-|shar|sie(\-|m)|sk\-0|sl(45|id)|sm(al|ar|b3|it|t5)|so(ft|ny)|sp(01|h\-|v\-|v )|sy(01|mb)|t2(18|50)|t6(00|10|18)|ta(gt|lk)|tcl\-|tdg\-|tel(i|m)|tim\-|t\-mo|to(pl|sh)|ts(70|m\-|m3|m5)|tx\-9|up(\.b|g1|si)|utst|v400|v750|veri|vi(rg|te)|vk(40|5[0-3]|\-v)|vm40|voda|vulc|vx(52|53|60|61|70|80|81|83|85|98)|w3c(\-| )|webc|whit|wi(g |nc|nw)|wmlb|wonu|x700|yas\-|your|zeto|zte\-/i',substr($useragent,0,4))) { $useMOBILE = 1; } //TODO: Sayaclar ayarlaniyor... if (!$_SESSION['counter_ok']) { //TODO: Sayaclar... $today_date = date("dmy"); $sql = "SELECT * FROM a_site_sayac WHERE id='1'"; $result = mysql_query($sql,$connection); $row = mysql_fetch_assoc($result); mysql_free_result ($result); $counter_total = $row["toplam"]; $counter_today = $row["bugun"]; $counter_date = $row["tarih"]; //TODO: Sayac artiriliyor... if ($today_date != $counter_date){ $sql = "UPDATE a_site_sayac SET toplam=toplam+1, bugun='0', tarih='".$today_date."' WHERE id='1'"; $result = mysql_query($sql,$connection); } $sql = "UPDATE a_site_sayac SET toplam=toplam+1, bugun=bugun+1 WHERE id='1'"; $result = mysql_query($sql,$connection); $_SESSION['counter_ok'] = 1; $_SESSION['set']['mainTitleSEO'] = SingleResult($connection,"SELECT COALESCE(".$_SESSION['lang']['dbfix']."deger, tr_deger) FROM a_ayarlar WHERE id='1'"); $_SESSION['set']['mainTitleText'] = SingleResult($connection,"SELECT COALESCE(".$_SESSION['lang']['dbfix']."deger, tr_deger) FROM a_ayarlar WHERE id='2'"); $_SESSION['set']['mainTitleSEOO'] = SingleResult($connection,"SELECT COALESCE(".$_SESSION['lang']['dbfix']."deger, tr_deger) FROM a_ayarlar WHERE id='3'"); $_SESSION['set']['analyticsCode'] = SingleResult($connection,"SELECT COALESCE(".$_SESSION['lang']['dbfix']."deger, tr_deger) FROM a_ayarlar WHERE id='4'"); $_SESSION['set']['socialLink_1'] = SingleResult($connection,"SELECT COALESCE(".$_SESSION['lang']['dbfix']."deger, tr_deger) FROM a_ayarlar WHERE id='5'"); $_SESSION['set']['socialLink_2'] = SingleResult($connection,"SELECT COALESCE(".$_SESSION['lang']['dbfix']."deger, tr_deger) FROM a_ayarlar WHERE id='6'"); $_SESSION['set']['socialLink_3'] = SingleResult($connection,"SELECT COALESCE(".$_SESSION['lang']['dbfix']."deger, tr_deger) FROM a_ayarlar WHERE id='7'"); $_SESSION['set']['socialLink_4'] = SingleResult($connection,"SELECT COALESCE(".$_SESSION['lang']['dbfix']."deger, tr_deger) FROM a_ayarlar WHERE id='8'"); } //TODO: Dil secenekleri cekiliyor... $sql = "SELECT id, baslik, rewrite, dbfix, aciklama, dosya_yolu FROM a_diller WHERE durum='1' ORDER BY varsayilan DESC, sira"; $result = mysql_query($sql,$connection); while ($row = mysql_fetch_assoc($result)) { $langCount += 1; $langID[$langCount] = $row["id"]; $langRewrite[$row["id"]] = $row["rewrite"]; $langFlag[$row["id"]] = $row["dosya_yolu"]; $langSTitle[$langCount] = $row["baslik"]; $langSRewrite[$langCount] = $row["rewrite"]; $langTitle[$langCount] = $row["aciklama"]; if ($row["rewrite"]) { $trimVALUE = $row["rewrite"]."/"; $targetHREF = str_replace($trimVALUE, '', $targetHREF); } $langHREF[$langCount] = SingleResult($connection,"SELECT COALESCE(".$row["dbfix"]."rewrite, tr_rewrite) FROM i_butonlar WHERE tr_rewrite='anasayfa.html'"); } mysql_free_result($result); //TODO: Ust Butonlar cekiliyor... $sql = "(SELECT '1' AS tip, id AS ana, id AS sss, a.id, COALESCE(a.".$_SESSION['lang']['dbfix']."baslik, a.tr_baslik) AS baslik, COALESCE(a.".$_SESSION['lang']['dbfix']."rewrite, a.tr_rewrite) AS rewrite, COALESCE(a.".$_SESSION['lang']['dbfix']."exturl, a.tr_exturl) AS exturl, a.disurl, a.blank, a.sira, a.altsira, a.ana_kat, a.dosya_yolu FROM i_butonlar AS a WHERE a.durum='1' AND valign='1' AND isNULL(a.ana_kat)) UNION (SELECT '2', b.id, b.ana_kat AS sss, b.id, COALESCE(b.".$_SESSION['lang']['dbfix']."baslik, b.tr_baslik) AS baslik, COALESCE(b.".$_SESSION['lang']['dbfix']."rewrite, b.tr_rewrite) AS rewrite, COALESCE(b.".$_SESSION['lang']['dbfix']."exturl, b.tr_exturl) AS exturl, b.disurl, b.blank, b.sira, b.altsira, b.ana_kat, b.dosya_yolu FROM i_butonlar AS a, i_butonlar AS b WHERE a.durum='1' AND b.durum='1' AND a.valign='1' AND b.valign='1' AND a.id=b.ana_kat AND isNULL(a.ana_kat) AND NOT isNULL(b.ana_kat)) UNION (SELECT '3', c.ana_kat, c.ana_kat AS sss, c.id, COALESCE(c.".$_SESSION['lang']['dbfix']."baslik, c.tr_baslik) AS baslik, COALESCE(c.".$_SESSION['lang']['dbfix']."rewrite, c.tr_rewrite) AS rewrite, COALESCE(c.".$_SESSION['lang']['dbfix']."exturl, c.tr_exturl) AS exturl, c.disurl, c.blank, c.sira, c.altsira, c.ana_kat, c.dosya_yolu FROM i_butonlar AS a, i_butonlar AS b, i_butonlar AS c WHERE a.durum='1' AND b.durum='1' AND c.durum='1' AND a.valign='1' AND b.valign='1' AND c.valign='1' AND a.id=b.ana_kat AND b.id=c.ana_kat AND isNULL(a.ana_kat) AND NOT isNULL(b.ana_kat) AND NOT isNULL(c.ana_kat)) ORDER BY 10,1,11"; $result = mysql_query($sql,$connection); while ($brow = mysql_fetch_assoc($result)) { if (!$brow["ana_kat"]) { $buttonCount[1][$brow["tip"]] += 1; $buttonID[1][$brow["tip"]][$buttonCount[1][$brow["tip"]]] = $brow["id"]; $buttonTitle[1][$brow["tip"]][$buttonCount[1][$brow["tip"]]] = $brow["baslik"]; $buttonRewrite[1][$brow["tip"]][$buttonCount[1][$brow["tip"]]] = $brow["rewrite"]; $buttonExtURL[1][$brow["tip"]][$buttonCount[1][$brow["tip"]]] = $brow["exturl"]; $buttonDisURL[1][$brow["tip"]][$buttonCount[1][$brow["tip"]]] = $brow["disurl"]; $buttonBlank[1][$brow["tip"]][$buttonCount[1][$brow["tip"]]] = $brow["blank"]; $buttonImage[1][$brow["tip"]][$buttonCount[1][$brow["tip"]]] = $brow["dosya_yolu"]; } else { $buttonCount[1][$brow["tip"]][$brow["sss"]] += 1; $buttonID[1][$brow["tip"]][$brow["sss"]][$buttonCount[1][$brow["tip"]][$brow["sss"]]] = $brow["id"]; $buttonTitle[1][$brow["tip"]][$brow["sss"]][$buttonCount[1][$brow["tip"]][$brow["sss"]]] = $brow["baslik"]; $buttonRewrite[1][$brow["tip"]][$brow["sss"]][$buttonCount[1][$brow["tip"]][$brow["sss"]]] = $brow["rewrite"]; $buttonExtURL[1][$brow["tip"]][$brow["sss"]][$buttonCount[1][$brow["tip"]][$brow["sss"]]] = $brow["exturl"]; $buttonDisURL[1][$brow["tip"]][$brow["sss"]][$buttonCount[1][$brow["tip"]][$brow["sss"]]] = $brow["disurl"]; $buttonBlank[1][$brow["tip"]][$brow["sss"]][$buttonCount[1][$brow["tip"]][$brow["sss"]]] = $brow["blank"]; $buttonImage[1][$brow["tip"]][$brow["sss"]][$buttonCount[1][$brow["tip"]][$brow["sss"]]] = $brow["dosya_yolu"]; } } mysql_free_result($result); //TODO: Alt Butonlar cekiliyor... $sql = "(SELECT '1' AS tip, id AS ana, id AS sss, a.id, COALESCE(a.".$_SESSION['lang']['dbfix']."baslik, a.tr_baslik) AS baslik, COALESCE(a.".$_SESSION['lang']['dbfix']."rewrite, a.tr_rewrite) AS rewrite, COALESCE(a.".$_SESSION['lang']['dbfix']."exturl, a.tr_exturl) AS exturl, a.disurl, a.blank, a.sira, a.altsira, a.ana_kat FROM i_butonlar AS a WHERE a.durum='1' AND valign='3' AND isNULL(a.ana_kat)) UNION (SELECT '2', b.id, b.ana_kat AS sss, b.id, COALESCE(b.".$_SESSION['lang']['dbfix']."baslik, b.tr_baslik) AS baslik, COALESCE(b.".$_SESSION['lang']['dbfix']."rewrite, b.tr_rewrite) AS rewrite, COALESCE(b.".$_SESSION['lang']['dbfix']."exturl, b.tr_exturl) AS exturl, b.disurl, b.blank, b.sira, b.altsira, b.ana_kat FROM i_butonlar AS a, i_butonlar AS b WHERE a.durum='1' AND b.durum='1' AND a.valign='3' AND b.valign='3' AND a.id=b.ana_kat AND isNULL(a.ana_kat) AND NOT isNULL(b.ana_kat)) UNION (SELECT '3', c.ana_kat, c.ana_kat AS sss, c.id, COALESCE(c.".$_SESSION['lang']['dbfix']."baslik, c.tr_baslik) AS baslik, COALESCE(c.".$_SESSION['lang']['dbfix']."rewrite, c.tr_rewrite) AS rewrite, COALESCE(c.".$_SESSION['lang']['dbfix']."exturl, c.tr_exturl) AS exturl, c.disurl, c.blank, c.sira, c.altsira, c.ana_kat FROM i_butonlar AS a, i_butonlar AS b, i_butonlar AS c WHERE a.durum='1' AND b.durum='1' AND c.durum='1' AND a.valign='3' AND b.valign='3' AND c.valign='3' AND a.id=b.ana_kat AND b.id=c.ana_kat AND isNULL(a.ana_kat) AND NOT isNULL(b.ana_kat) AND NOT isNULL(c.ana_kat)) ORDER BY 10,1,11"; $result = mysql_query($sql,$connection); while ($brow = mysql_fetch_assoc($result)) { if (!$brow["ana_kat"]) { $buttonCount[3][$brow["tip"]] += 1; $buttonID[3][$brow["tip"]][$buttonCount[3][$brow["tip"]]] = $brow["id"]; $buttonTitle[3][$brow["tip"]][$buttonCount[3][$brow["tip"]]] = $brow["baslik"]; $buttonRewrite[3][$brow["tip"]][$buttonCount[3][$brow["tip"]]] = $brow["rewrite"]; $buttonExtURL[3][$brow["tip"]][$buttonCount[3][$brow["tip"]]] = $brow["exturl"]; $buttonDisURL[3][$brow["tip"]][$buttonCount[3][$brow["tip"]]] = $brow["disurl"]; $buttonBlank[3][$brow["tip"]][$buttonCount[3][$brow["tip"]]] = $brow["blank"]; } else { $buttonCount[3][$brow["tip"]][$brow["sss"]] += 1; $buttonID[3][$brow["tip"]][$brow["sss"]][$buttonCount[3][$brow["tip"]][$brow["sss"]]] = $brow["id"]; $buttonTitle[3][$brow["tip"]][$brow["sss"]][$buttonCount[3][$brow["tip"]][$brow["sss"]]] = $brow["baslik"]; $buttonRewrite[3][$brow["tip"]][$brow["sss"]][$buttonCount[3][$brow["tip"]][$brow["sss"]]] = $brow["rewrite"]; $buttonExtURL[3][$brow["tip"]][$brow["sss"]][$buttonCount[3][$brow["tip"]][$brow["sss"]]] = $brow["exturl"]; $buttonDisURL[3][$brow["tip"]][$brow["sss"]][$buttonCount[3][$brow["tip"]][$brow["sss"]]] = $brow["disurl"]; $buttonBlank[3][$brow["tip"]][$brow["sss"]][$buttonCount[3][$brow["tip"]][$brow["sss"]]] = $brow["blank"]; } } mysql_free_result($result); //TODO: Gizli Butonlar cekiliyor... $sql = "(SELECT '1' AS tip, id AS ana, id AS sss, a.id, COALESCE(a.".$_SESSION['lang']['dbfix']."baslik, a.tr_baslik) AS baslik, COALESCE(a.".$_SESSION['lang']['dbfix']."rewrite, a.tr_rewrite) AS rewrite, COALESCE(a.".$_SESSION['lang']['dbfix']."exturl, a.tr_exturl) AS exturl, a.disurl, a.blank, a.sira, a.altsira, a.ana_kat FROM i_butonlar AS a WHERE a.durum='1' AND valign='4' AND isNULL(a.ana_kat)) UNION (SELECT '2', b.id, b.ana_kat AS sss, b.id, COALESCE(b.".$_SESSION['lang']['dbfix']."baslik, b.tr_baslik) AS baslik, COALESCE(b.".$_SESSION['lang']['dbfix']."rewrite, b.tr_rewrite) AS rewrite, COALESCE(b.".$_SESSION['lang']['dbfix']."exturl, a.tr_exturl) AS exturl, b.disurl, b.blank, b.sira, b.altsira, b.ana_kat FROM i_butonlar AS a, i_butonlar AS b WHERE a.durum='1' AND b.durum='1' AND a.valign='4' AND b.valign='4' AND a.id=b.ana_kat AND isNULL(a.ana_kat) AND NOT isNULL(b.ana_kat)) UNION (SELECT '3', c.ana_kat, c.ana_kat AS sss, c.id, COALESCE(c.".$_SESSION['lang']['dbfix']."baslik, c.tr_baslik) AS baslik, COALESCE(c.".$_SESSION['lang']['dbfix']."rewrite, c.tr_rewrite) AS rewrite, COALESCE(c.".$_SESSION['lang']['dbfix']."exturl, c.tr_exturl) AS exturl, c.disurl, c.blank, c.sira, c.altsira, c.ana_kat FROM i_butonlar AS a, i_butonlar AS b, i_butonlar AS c WHERE a.durum='1' AND b.durum='1' AND c.durum='1' AND a.valign='4' AND b.valign='4' AND c.valign='4' AND a.id=b.ana_kat AND b.id=c.ana_kat AND isNULL(a.ana_kat) AND NOT isNULL(b.ana_kat) AND NOT isNULL(c.ana_kat)) ORDER BY 10,1,11"; $result = mysql_query($sql,$connection); while ($brow = mysql_fetch_assoc($result)) { if ($brow["ana_kat"]) { $buttonCount[1][$brow["tip"]][$brow["sss"]] += 1; $buttonID[1][$brow["tip"]][$brow["sss"]][$buttonCount[1][$brow["tip"]][$brow["sss"]]] = $brow["id"]; $buttonTitle[1][$brow["tip"]][$brow["sss"]][$buttonCount[1][$brow["tip"]][$brow["sss"]]] = $brow["baslik"]; $buttonRewrite[1][$brow["tip"]][$brow["sss"]][$buttonCount[1][$brow["tip"]][$brow["sss"]]] = $brow["rewrite"]; $buttonExtURL[1][$brow["tip"]][$brow["sss"]][$buttonCount[1][$brow["tip"]][$brow["sss"]]] = $brow["exturl"]; $buttonDisURL[1][$brow["tip"]][$brow["sss"]][$buttonCount[1][$brow["tip"]][$brow["sss"]]] = $brow["disurl"]; $buttonBlank[1][$brow["tip"]][$brow["sss"]][$buttonCount[1][$brow["tip"]][$brow["sss"]]] = $brow["blank"]; } } mysql_free_result($result); //TODO: Icerik yoksa... if ($mod) { $_GET['mod'] = $mod; } if (!$_GET['rewrite'] OR $_GET['rewrite'][1]=='index' OR !@file_get_contents("inc_".$_GET['mod'].".php")) { $_GET['mod'] = "Anasayfa"; $targetHREF = "index.html"; $_GET['rewrite'][1] = "index"; } if ($_GET['mod']!="Anasayfa") { $targetHREF = urldecode($targetHREF); //TODO: Ilgili linki destekleyen modul var mi?... $moduleINCLUDE = SingleResult($connection,"SELECT modul FROM a_moduller WHERE id IN (SELECT modul_id FROM i_butonlar WHERE NOT isNULL(modul_id) AND COALESCE(".$_SESSION['lang']['dbfix']."rewrite, tr_rewrite)='".sqlize($targetHREF)."')"); if (!$moduleINCLUDE) { $hrefPATHARR = explode('/', $targetHREF); if ($_GET['rewrite'][3]) { for ($i=0; $i<(count($hrefPATHARR)-1); $i++) { $hrefPATH .= $hrefPATHARR[$i]."/"; } } elseif ($_GET['rewrite'][2]) { for ($i=0; $i<(count($hrefPATHARR)-1); $i++) { $hrefPATH .= $hrefPATHARR[$i]."/"; } } if ($hrefPATH) { $moduleHREF = $hrefPATH = trim($hrefPATH,"/").".html"; $moduleINCLUDE = SingleResult($connection,"SELECT modul FROM a_moduller WHERE id IN (SELECT modul_id FROM i_butonlar WHERE NOT isNULL(modul_id) AND COALESCE(".$_SESSION['lang']['dbfix']."rewrite, tr_rewrite)='".sqlize($hrefPATH)."')"); } } else { $moduleHREF = $targetHREF; } } //TODO: Seo Title & Meta Tags... include ("_seo.php"); //TODO: add_RuleLink dile gore ayarlaniyor if ($langRewrite[$_SESSION['lang']['id']]) { $add_RuleLink = $add_RulePath.$langRewrite[$_SESSION['lang']['id']]."/"; } else { $add_RuleLink = $add_RulePath; } //TODO: Gelen anasayfa mi? if ($_GET['rewrite'][1]=="index" OR $_GET['rewrite'][1]=="anasayfa") { $mainPage = 1; } //TODO: add_RuleLink dile gore ayarlaniyor if ($langRewrite[$_SESSION['lang']['id']]) { $add_RuleLink = $add_RulePath.$langRewrite[$_SESSION['lang']['id']]."/"; } else { $add_RuleLink = $add_RulePath; } /*echo "a: ".$moduleINCLUDE; echo "
"; echo "b: ".$targetHREF; echo "
"; print_r($_GET); echo "

"; //exit;*/ //print_r($buttonTitle[1][2]); //exit; ?>