</head>
<?php
include("ayarlar.php");
include("veritablosu.php");
$gelen=mysql_real_escape_string($_GET["id"]);;
$yazdir=@mysql_fetch_array(mysql_query("Select id, katadi,seo_kat From "._BURAK."kategoriler where seo_kat='$gelen'"));
$katadi=stripslashes($yazdir["katadi"]);
$id=$yazdir["id"];
temaac("$katadi ");
sayfaac("Alt Kategoriler");
//sayfa
$sayfa = !empty($_GET["nu"]) ? intval($_GET["nu"]) : 1;
$sorgu1=mysql_query("SELECT * FROM "._BURAK."makaleler where anakatid='$id' AND altkatid =0
AND altaltid =0"); 
$toplam = mysql_num_rows($sorgu1);
$limit=40;
$s = ($sayfa-1)*$limit;
//sayfa
$result = @mysql_query("select id, katadi from "._BURAK."altkategori where anakatid='$id'");
while(list($altid, $altadi) = @mysql_fetch_row($result)){
$baslik1=stripslashes($altadi);
$baslik1 = strtolower(stripslashes(strtr($baslik1,"ÜŞÇİĞÖüöşçiğı?%","USCIGOuoscigi-,"))); 
$baslik1 = str_replace(" ","-",$baslik1);
echo "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\"><tr>";
do {
 
echo "<td width=\"159\"><a href=\""._SITEURL."/$altaltid/$baslik2.html\">---- $altaltadi </a></td>";                                  
 
  $sayac++;
  if ($sayac  == 4) {
    echo "</tr><tr>";
    $sayac = 0;
    }
 
}  while ($altaltadi = mysql_fetch_assoc($result));
 
echo "</tr>
</table>";
$resultalt = @mysql_query("select id, katadi from "._BURAK."altkategoriiki where altkatid='$altid'");
while(list($altaltid, $altaltadi) = @mysql_fetch_row($resultalt)){
$baslik2=stripslashes($altaltadi);
$baslik2 = strtolower(stripslashes(strtr($baslik2,"ÜŞÇİĞÖüöşçiğı?%","USCIGOuoscigi-,"))); 
$baslik2 = str_replace(" ","-",$baslik2);
echo "<a href=\""._SITEURL."/$altaltid/$baslik2.html\">---- $altaltadi </a><br />";
} 
unset($resultalt);
}
 
$sayi=@mysql_num_rows(@mysql_query("SELECT * FROM "._BURAK."makaleler where anakatid='$id'"));
if($sayi=="0"){
?>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#FFFFFF" width="100%" height="60">
<tr>
<td width="48%" height="23" bgcolor="#E3E4E8">
<p align="center"><b>İçerik Adı</b></td>
<td width="16%" height="23" bgcolor="#E3E4E8" align="center"><b>Ekleyen Üyemiz</b></td>
<td width="14%" height="23" bgcolor="#E3E4E8" align="center"><b>Tarih</b></td>
<td width="22%" height="23" bgcolor="#E3E4E8" align="center"><b>Puanlama</b></td>
</tr>
<tr>
<td width="100%" height="36" colspan="4">
<p align="center"><font color="#FF0000">Bu Kategori'ye Ait İçerik
Bulunamadı.</font></td>
</tr>
</table>
<?
}else{
?>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#FFFFFF" width="100%">
<tr>
<td width="48%" height="24" bgcolor="#E3E4E8">
<p align="center"><b>İçerik Adı</b></td>
<td width="16%" height="24" bgcolor="#E3E4E8" align="center"><b>Oynanma</b></td>
<td width="14%" height="24" bgcolor="#E3E4E8" align="center"><b>Tarih</b></td>
<td width="22%" height="24" bgcolor="#E3E4E8" align="center"><b>Puanlama</b></td>
</tr>
<?
//sayfa
$makalelericek=@mysql_query("SELECT id, baslik, tarih, okunma, oy, oykullanan
FROM "._BURAK."makaleler 
WHERE anakatid ='$id'
AND altkatid =0
AND altaltid =0 ORDER BY id DESC LIMIT $s,$limit");
//sayfa
@$toplam2 = mysql_num_rows($sonuc);
$a = ceil($toplam/$limit)+1;
//sayfa
while($gosterbakalim = @mysql_fetch_array($makalelericek)) 
{
$makale_id = $gosterbakalim["id"];
$baslik = stripslashes($gosterbakalim["baslik"]);
$tarihdata=stripslashes($gosterbakalim["tarih"]);
$tarih1 = explode("-", $tarihdata); 
$tarih= $tarih1[2] . "." .$tarih1[1]. "." .$tarih1[0];
$okunma = stripslashes($gosterbakalim["okunma"]);
if($gosterbakalim["oy"] > 0 )
$oy= round($gosterbakalim["oy"] / $gosterbakalim["oykullanan"],2); 
else
$oy=0;
$baslik1=stripslashes($baslik);
$baslik1 = strtolower(stripslashes(strtr($baslik1,"ÜŞÇİĞÖüöşçiğı?%","USCIGOuoscigi-,"))); 
$baslik1 = str_replace(" ","-",$baslik1);
?>
<tr>
<td width="48%" height="24">&nbsp;
<a href="<?=_SITEURL?>/<?=$gelen?>/<?=$makale_id?>/<?=$baslik1?>.html"><b><?=$baslik?></b></a></td>
<td width="16%" height="24" align="center"><font color="#993333"><b><?=$okunma?></b></font></td>
<td width="14%" height="24" align="center"><font color="#FF0000"><b><?=$tarih?></b></font></td>
<td width="22%" height="24" align="center"><?php
for($i=1; $i<=$oy; $i++) echo"<img src="._SITEURL."/resimler/hot.gif alt=\"10 UZERINDEN $oy\">";
for($j=$i; $j<=10; $j++) echo"<img src="._SITEURL."/resimler/nothot.gif alt=\"10 UZERINDEN $oy\">"; 
?></td>
</tr>
<?
}
$cekbakalim=@mysql_query("Select katadi From "._BURAK."kategoriler where id='$id'");
$gosterbakalim = @mysql_fetch_array($cekbakalim);
$baslik1=stripslashes($gosterbakalim[0]);
$baslik1 = strtolower(stripslashes(strtr($baslik1,"ÜŞÇİĞÖüöşçiğı?%","USCIGOuoscigi-,"))); 
$baslik1 = str_replace(" ","-",$baslik1);
//sayfa
echo "<font face=\"Tahoma\" size=\"2\">Sayfa : </font>";
for($i=1;$i<$a;$i++) {
if($sayfa==$i) { echo "<font color=\"#FF0000\"><font face=\"Tahoma\" size=\"2\">[<b>" .$i. "</b>]</font></font> "; } else {
echo "<font face=\"Tahoma\" size=\"2\">[<a href=\"kategorilist.php?id=$gelen&nu=$i\"><b>$i</b></a>]</font> ";
} }
$ileri = $sayfa+1;
$b = ceil($toplam/$limit); 
//sayfa
echo "</table>";
}
sayfakapat();
temakapat();
?>