<?php define('access',"False"); 
require_once ("include/connect.php"); require_once ("include/tarihfonksiyonu.php"); require_once ("include/zamanfonksiyonu.php");
?>
<!DOCTYPE html>
<html lang="tr">
<head>
<meta charset="utf-8">
<base href="<?php echo $SiteBilgi["siteurl"]; ?>" />
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1"> 
<link rel="amphtml" href="<?php echo $SiteBilgi["ampurl"]; ?>" /><title><?php echo $SiteBilgi["siteadi"]; ?></title>
<meta name="keywords" content="<?php echo $SiteBilgi["anahtar"]; ?>" />
<meta name="description" content="<?php echo $SiteBilgi["meta"]; ?>">
<link rel="canonical" href="<?php echo $SiteBilgi["siteurl"]; ?>" />
<?php echo $SiteBilgi["head"]; ?>
<link rel="icon" href="img/favicon.png">
<link rel="stylesheet" href="css/bootstrap.css">
<link rel="stylesheet" type="text/css" href="css/site.php">
<script src="js/jquery-1.10.2.js"></script>
<script src="js/anasayfa.js"></script>
</head>
<body id="top">
<?php include('include/ustmenu.php'); ?>
<div class="Header_Alani">
<?php echo $SiteBilgi['ustalanyazisi']; ?>
</div>
<div class="container">
<div class="row">
<?php if($SiteBilgi['platinalan'] == 1){ ?>
<div class="col-md-12"><div class="vipilan"><span class="glyphicon glyphicon-star-empty" aria-hidden="true"></span><span class="blink">PLATİN ÜYELER</span> <span class="glyphicon glyphicon-star-empty" aria-hidden="true"></span></div></div>
<div class="temizle"></div>
<?php $xxx = $conn->prepare("SELECT * FROM uyeler WHERE durum=? AND seviye=? ORDER BY sira ASC"); 
$xxx->execute(array('Yayında', 1));
$count = $xxx->rowcount();
if ($count > 0){  
while($yyy = $xxx->fetch()){
$TelData 	= $yyy['telefon'];	
$GsmYaz 	= substr($TelData,0,4)." ".substr($TelData,4,3)." ".substr($TelData,7,2)." ".substr($TelData,9,2);
?>
<div class="col-lg-3 col-md-3 col-sm-3 col-xs-3 Goldilan">
<?php /* <p class="text-center isim"><?php echo $yyy['adi']; ?></p> */ ?>
<?php if($yyy['ekstra'] != ''){ ?><a href="<?php echo $yyy['ekstra']; ?>" target="_blank" rel="nofollow"><?php }else{ ?>
<a href="<?php echo $yyy['seo']; ?>" rel="nofollow"><?php } ?>
<img class="img-responsive img-thumbnail VitrinUst" src="<?php if($yyy['resim'] != ''){ echo 'ModelResim/'.$yyy['resim']; }else{ echo 'img/resimsiz.jpg'; } ?>" alt="<?php echo $yyy['isim']; ?>" height=" " width=" "/>
</a>
</div>
<?php } ?>
<?php }else{ ?>
<div class="col-md-12"><div class="alert alert-warning text-center">İlanlar hazırlanıyor...</div></div>	
<?php } ?>
<div class="temizle"></div>
<?php } if($SiteBilgi['goldalan'] == 1){ ?>
<div class="col-md-12"><div class="vipilan"><span class="glyphicon glyphicon-star-empty" aria-hidden="true"></span><span class="blink">GOLD ÜYELER</span> <span class="glyphicon glyphicon-star-empty" aria-hidden="true"></span></div></div>
<div class="temizle"></div>
<?php $xxx = $conn->prepare("SELECT * FROM uyeler WHERE durum=? AND seviye=? ORDER BY sira ASC"); 
$xxx->execute(array('Yayında', 2));
$count = $xxx->rowcount();
if ($count > 0){  
while($yyy = $xxx->fetch()){
$TelData 	= $yyy['telefon'];	
$GsmYaz 	= substr($TelData,0,4)." ".substr($TelData,4,3)." ".substr($TelData,7,2)." ".substr($TelData,9,2);
?>
<div class="col-lg-3 col-md-3 col-sm-3 col-xs-3 Goldilan">
<?php /* <p class="text-center isim"><?php echo $yyy['adi']; ?></p> */ ?>
<?php if($yyy['ekstra'] != ''){ ?><a href="<?php echo $yyy['ekstra']; ?>" target="_blank" rel="nofollow"><?php }else{ ?>
<a href="<?php echo $yyy['seo']; ?>" rel="nofollow"><?php } ?>
<img class="img-responsive img-thumbnail VitrinUst" src="<?php if($yyy['resim'] != ''){ echo 'ModelResim/'.$yyy['resim']; }else{ echo 'img/resimsiz.jpg'; } ?>" alt="<?php echo $yyy['isim']; ?>" height=" " width=" "/>
</a>
</div>
<?php } ?>
<?php }else{ ?>
<div class="col-md-12"><div class="alert alert-warning text-center">İlanlar hazırlanıyor...</div></div>	
<?php }} ?>

<div class="temizle"></div>
<div class="col-md-8">
<?php 
$sorustur = $conn->prepare("select * from blog where durum = ? order by id desc limit 10");
$sorustur->execute(array('Aktif'));
while($Makale = $sorustur->fetch()){
$kategoriSorgula = $conn->prepare("select * from kategori where id = ?");
$kategoriSorgula->execute(array($Makale['kategori']));
$kateqoriCek = $kategoriSorgula->fetch();	
?>			
<div class="panel panel-default panel-stili">
<div class="panel-body">
<div class="media">
<a class="pull-left" href="escort/<?php echo $Makale['seo']; ?>">
<div class="cerceve"><img src="<?php if($Makale['resim'] != ''){ echo 'BlogResim/'.$Makale['resim']; }else{ echo 'img/resimsiz.jpg'; } ?>" alt="<?php echo $Makale['baslik']; ?>" class="resim"></div>
</a>
<div class="panel-body">
<h4 class="media-heading"><a href="escort/<?php echo $Makale['seo']; ?>"><?php echo $Makale['baslik']; ?></a></h4>
<p class="detay"><?php $metin = mb_substr($Makale['aciklama'],0,900).'... '; echo strip_tags($metin); ?> <a href="escort/<?php echo $Makale['seo']; ?>"> okumaya devam et</a></p><hr/>
<ul class="list-inline list-unstyled">
<small><i class="glyphicon glyphicon-calendar"></i>  <?php echo XzamanOnce($Makale['yil'].'-'.$Makale['tarih'].' '.$Makale['saat']); ?></small>
<li>|</li>
<small><i class="glyphicon glyphicon-th-list"></i> <a href="kategori/<?php echo $kateqoriCek['seo']; ?>"><?php echo $kateqoriCek['baslik']; ?></a></small>
<li>|</li>
<small><i class="glyphicon glyphicon-stats"></i> <?php echo $Makale['hit']; ?></small>
</ul>
</div>
</div>
</div>
</div>
<?php } ?>
</div>
<div class="col-md-4">	
<div class="panel panel-default panel-stili">
<div class="panel-heading">
<h2 class="panel-title"><span class="glyphicon glyphicon-bookmark" aria-hidden="true"></span> <?php echo $SiteBilgi['yanpanelbaslik']; ?></h2>
</div>
<div class="panel-body">
<p><?php echo $SiteBilgi['yanpanel']; ?></p>					
</div>
</div>
<?php include('include/sidebar.php'); ?>	
<?php include('include/sidebar-makale-etiket-bulutu.php'); ?>	
</div>			
<div class="col-md-12">	
<div class="panel panel-default panel-stili">
<div class="panel-heading">
<h3 class="panel-title"><?php echo $SiteBilgi['meta']; ?></h3>
</div>
<div class="panel-body kategorialtyazi">
<p><?php echo $SiteBilgi['anasayfa']; ?></p>					
</div>
</div>	
</div>	
<div class="temizle"></div>
<?php include('include/alt.php'); ?>
</div>
</div><!--/.container-->
<script src="js/bootstrap.js"></script>
</body>
</html>