<?php define('access',"False"); 
require_once ("include/connect.php"); require_once ("include/tarihfonksiyonu.php"); require_once ("include/zamanfonksiyonu.php");
$min = 5;
$max = 20000;
?>
<!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"]; ?><?php echo '?u=91123456'.rand($min, $max).''; ?>" />
<title><?php echo $SiteBilgi["siteadi"]; ?></title>
<meta name="keywords" content="<?php echo $SiteBilgi["anahtar"]; ?>" />
<meta name="description" content="<?php echo $SiteBilgi["meta"]; ?>">
<link href="<?php echo $SiteBilgi["siteurl"]; ?>" hreflang="tr" rel="alternate"/>
<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" rel="stylesheet">
<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">
<div class="temizle"></div>	
<?php $Platins = $conn->prepare("select * from uyeler where durum=? and seviye=? order by sira asc"); 
$Platins->execute(array('Yayında', 'platin')); 
$count = $Platins->rowcount();
if ($count > 0){  
while($Platin = $Platins->fetch()){
?>

<?php } ?>
<?php } ?>
<div class="temizle"></div>	
<div class="temizle"></div>	
<?php $Vips = $conn->prepare("select * from uyeler where durum=? and seviye=? order by sira asc"); 
$Vips->execute(array('Yayında', 'vip'));
$count = $Vips->rowcount();
if ($count > 0){  
while($Vip = $Vips->fetch()){
?>

<?php } ?>

<?php } ?>
<div class="temizle"></div>	
<div class="temizle"></div>	
<?php $Golds = $conn->prepare("select * from uyeler where durum=? and seviye=? order by sira asc"); 
$Golds->execute(array('Yayında', 'gold'));
$count = $Golds->rowcount();
if ($count > 0){  
while($Gold = $Golds->fetch()){
?>

<?php } ?>
<?php } ?>
<div class="temizle"></div>
<br/>
<div class="col-md-8">
<?php 
$sorustur = $conn->prepare("SELECT * FROM blog WHERE durum = ? ORDER BY id DESC LIMIT 40");
$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="<?php echo $Makale['seo'].'/'; ?>">
<div class="cerceve"><img src="BlogResim/<?php echo $Makale['resim']; ?>" alt="<?php echo $Makale['baslik']; ?>" class="resim"></div>
</a>
<div class="panel-body">
<h4 class="media-heading"><a href="<?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="<?php echo $Makale['seo'].'/'; ?>"> okumaya devam et</a></p>
</div>
</div>
</div>
<div class="panel-footer">
<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="category/<?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>
<?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'); ?>	
</div>			
<div class="col-md-12">	
<div class="panel panel-default panel-stili">
<div class="panel-heading">
<h3 class="panel-title"><?php echo $SiteBilgi["anahtar"]; ?></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>