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']) {
$_GET['oldLang'] = $_SESSION['lang']['dbfix'];
$_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: Sayaclar ayarlaniyor
//if (!$_SESSION['counter_ok'] OR rtrim($_GET['oldLang'],'_')!=$_GET['lang']) {
//TODO: Sayaclar
$today_date = date("dmy");
$sql = "SELECT * FROM a_site_sayac WHERE id='1'";
$result = mysqli_query($connection,$sql);
$row = mysqli_fetch_assoc($result);
mysqli_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 = mysqli_query($connection,$sql);
}
$sql = "UPDATE a_site_sayac SET toplam=toplam+1, bugun=bugun+1 WHERE id='1'";
$result = mysqli_query($connection,$sql);
$_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']['whatsAPP'] = SingleResult($connection,"SELECT COALESCE(".$_SESSION['lang']['dbfix']."deger, tr_deger) FROM a_ayarlar WHERE id='7'");
$_SESSION['set']['headerInfo_1'] = SingleResult($connection,"SELECT COALESCE(".$_SESSION['lang']['dbfix']."deger, tr_deger) FROM a_ayarlar WHERE id='8'");
$_SESSION['set']['headerInfo_2'] = SingleResult($connection,"SELECT COALESCE(".$_SESSION['lang']['dbfix']."deger, tr_deger) FROM a_ayarlar WHERE id='9'");
$_SESSION['set']['footerInfo_1'] = SingleResult($connection,"SELECT COALESCE(".$_SESSION['lang']['dbfix']."deger, tr_deger) FROM a_ayarlar WHERE id='10'");
$_SESSION['set']['footerInfo_2'] = SingleResult($connection,"SELECT COALESCE(".$_SESSION['lang']['dbfix']."deger, tr_deger) FROM a_ayarlar WHERE id='11'");
$_SESSION['set']['footerInfo_3'] = SingleResult($connection,"SELECT COALESCE(".$_SESSION['lang']['dbfix']."deger, tr_deger) FROM a_ayarlar WHERE id='12'");
//}
//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 = mysqli_query($connection,$sql);
while ($row = mysqli_fetch_assoc($result)) {
$langCount += 1;
$langID[$langCount] = $row["id"];
$langSELRewrite[$row["id"]] = $row["rewrite"];
$langSELFlags[$row["id"]] = $row["dosya_yolu"];
$langSELTitle[$row["id"]] = $row["baslik"];
$langSTitle[$langCount] = $row["baslik"];
$langSRewrite[$langCount] = $row["rewrite"];
$langFlags[$langCount] = $row["dosya_yolu"];
$langTitle[$langCount] = $row["aciklama"];
if ($row["rewrite"]."_"==$_SESSION['lang']['dbfix']) {
$trimVALUE = $row["rewrite"];
$targetHREF = ltrim(ltrim($targetHREF, $trimVALUE),'/');
}
$langHREF[$langCount] = SingleResult($connection,"SELECT COALESCE(".$row["dbfix"]."rewrite, tr_rewrite) FROM i_butonlar WHERE tr_rewrite='index'");
}
mysqli_free_result($result);
//TODO: Ana 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) AND a.".$_SESSION['lang']['dbfix']."goster='1')
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) AND b.".$_SESSION['lang']['dbfix']."goster='1')
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) AND c.".$_SESSION['lang']['dbfix']."goster='1')
ORDER BY 10,1,11";
$result = mysqli_query($connection,$sql);
while ($brow = mysqli_fetch_assoc($result)) {
if (!$brow["ana_kat"]) {
$buttonCount[2][$brow["tip"]] += 1;
$buttonID[2][$brow["tip"]][$buttonCount[2][$brow["tip"]]] = $brow["id"];
$buttonTitle[2][$brow["tip"]][$buttonCount[2][$brow["tip"]]] = $brow["baslik"];
$buttonRewrite[2][$brow["tip"]][$buttonCount[2][$brow["tip"]]] = $brow["rewrite"];
$buttonExtURL[2][$brow["tip"]][$buttonCount[2][$brow["tip"]]] = $brow["exturl"];
$buttonDisURL[2][$brow["tip"]][$buttonCount[2][$brow["tip"]]] = $brow["disurl"];
$buttonBlank[2][$brow["tip"]][$buttonCount[2][$brow["tip"]]] = $brow["blank"];
$buttonImage[2][$brow["tip"]][$buttonCount[2][$brow["tip"]]] = $brow["dosya_yolu"];
} else {
$buttonCount[2][$brow["tip"]][$brow["sss"]] += 1;
$buttonID[2][$brow["tip"]][$brow["sss"]][$buttonCount[2][$brow["tip"]][$brow["sss"]]] = $brow["id"];
$buttonTitle[2][$brow["tip"]][$brow["sss"]][$buttonCount[2][$brow["tip"]][$brow["sss"]]] = $brow["baslik"];
$buttonRewrite[2][$brow["tip"]][$brow["sss"]][$buttonCount[2][$brow["tip"]][$brow["sss"]]] = $brow["rewrite"];
$buttonExtURL[2][$brow["tip"]][$brow["sss"]][$buttonCount[2][$brow["tip"]][$brow["sss"]]] = $brow["exturl"];
$buttonDisURL[2][$brow["tip"]][$brow["sss"]][$buttonCount[2][$brow["tip"]][$brow["sss"]]] = $brow["disurl"];
$buttonBlank[2][$brow["tip"]][$brow["sss"]][$buttonCount[2][$brow["tip"]][$brow["sss"]]] = $brow["blank"];
$buttonImage[2][$brow["tip"]][$brow["sss"]][$buttonCount[2][$brow["tip"]][$brow["sss"]]] = $brow["dosya_yolu"];
}
}
mysqli_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) AND a.".$_SESSION['lang']['dbfix']."goster='1')
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) AND b.".$_SESSION['lang']['dbfix']."goster='1')
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) AND c.".$_SESSION['lang']['dbfix']."goster='1')
ORDER BY 10,1,11";
$result = mysqli_query($connection,$sql);
while ($brow = mysqli_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"];
}
}
mysqli_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) AND a.".$_SESSION['lang']['dbfix']."goster='1')
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) AND b.".$_SESSION['lang']['dbfix']."goster='1')
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) AND c.".$_SESSION['lang']['dbfix']."goster='1')
ORDER BY 10,1,11";
$result = mysqli_query($connection,$sql);
while ($brow = mysqli_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"];
}
}
mysqli_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";
$_GET['rewrite'][1] = "index";
}
if ($_GET['mod']!="Anasayfa") {
//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)."')");
$pageCONTENT = SingleResult($connection,"SELECT id FROM i_butonlar WHERE COALESCE(".$_SESSION['lang']['dbfix']."rewrite, tr_rewrite)='".sqlize($targetHREF)."'");
if (!$moduleINCLUDE AND !$pageCONTENT) {
$hrefPATHARR = explode('/', $targetHREF);
if ($_GET['rewrite'][4]) {
for ($i=0; $i<(count($hrefPATHARR)-2); $i++) {
$hrefPATH .= $hrefPATHARR[$i]."/";
}
} elseif ($_GET['rewrite'][3]) {
for ($i=0; $i<(count($hrefPATHARR)-1); $i++) {
$hrefPATH .= $hrefPATHARR[$i]."/";
}
} elseif ($_GET['rewrite'][2]) {
for ($i=0; $i<(count($hrefPATHARR)); $i++) {
$hrefPATH .= $hrefPATHARR[$i]."/";
}
}
if ($hrefPATH) {
$moduleHREF = $hrefPATH = trim($hrefPATH,"/");
$targetHREF = $moduleHREF;
$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 ($langSELRewrite[$_SESSION['lang']['id']]) {
$add_RuleLink = $add_RulePath.$langSELRewrite[$_SESSION['lang']['id']]."/";
} else {
$add_RuleLink = $add_RulePath;
}
//TODO: Gelen anasayfa mi?
if (!$_GET['rewrite'][1] OR ($_GET['rewrite'][1] AND !$_GET['rewrite'][2])) {
$mainPage = 1;
}
if ($_GET['mod']=="Anasayfa") {
//TODO: Popup Kontrol
$sql = "SELECT id, baslik,
COALESCE(".$_SESSION['lang']['dbfix']."dosya_yolu, tr_dosya_yolu) AS dosya_yolu,
COALESCE(".$_SESSION['lang']['dbfix']."video_yolu, tr_video_yolu) AS video_yolu,
COALESCE(".$_SESSION['lang']['dbfix']."link, tr_link) AS link
FROM m_sabit_bannerlar
WHERE durum='1' AND (isNULL(baslangic) OR '".date("Ymd")."' >= baslangic OR '".date("Ymd")."' BETWEEN baslangic AND bitis)
ORDER BY baslangic DESC, id DESC LIMIT 1";
$result = mysqli_query($connection,$sql);
$poprow = mysqli_fetch_assoc($result);
}
/*
echo "a: ".$moduleINCLUDE;
echo " ";
echo "b: ".$targetHREF;
echo " ";
print_r($_GET);
echo "
