<?php
require_once("includes/config.php");
$pagename = "category";
$cat_id = $_GET['id'];

$zuk = mysql_query("SELECT * FROM kategoriler where id order by id");
while ($kuz = mysql_fetch_array($zuk)) {

$dondur = seo_cevir($kuz[kategori_name]);

if ($cat_id == $dondur){

$buldukid = $kuz[id];

}}

$kl = mysql_query("SELECT * FROM kategoriler where id=$buldukid");
$rw = mysql_fetch_array($kl);

require("includes/header.php");
?>
<h2><?=$rw[kategori_name];?> Kategorisindeki Filmler</h2>
<table width="100%" cellpadding="0" cellspacing="0" border="0">
<tr>
    <td valign="top" align="left" width="130"><b>Türü</b></td>
    <td valign="top" align="center" width="10"></td>
    <td valign="top" align="left" width="400"><b>Adı</b></td>
    <td valign="top" align="left" width="110"><b>Tarih</b></td>
    <td valign="top" align="left"><b>İndirilme</b></td>
</tr>
<?php
$s = $_GET['sayfa'];
if ($s=="" || !is_numeric($s))
	{
		$s=1;
	}
$kacar=10;
$kayit_sayisi=mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM icerik WHERE kat_id=$buldukid"));
$sayfa_sayisi=$kayit_sayisi['0']/$kacar;
if ($kayit_sayisi % $kacar != 0)
	{
		$sayfa_sayisi++;
	}
$nerden=($s*$kacar)-$kacar;
$sq = mysql_query("SELECT * FROM icerik where kat_id=$buldukid order by id desc limit $nerden,$kacar");
while ($rw = mysql_fetch_array($sq)) {

    $kat_id = $rw['kat_id'];
    $icerik_id = $rw['id'];

    $ppp = mysql_query("SELECT * FROM download where icerik_id=$icerik_id");
    $ckc = mysql_num_rows($ppp);

    $kt = mysql_query("SELECT * FROM kategoriler where id=$kat_id");
    $rws = mysql_fetch_array($kt)


?>
<tr>
    <td valign="top" align="left"><?=$rws['kategori_name'];?></td>
    <td> | </td>
    <td valign="top" align="left"><a href="<?=$siteurl?>/premium-<? echo seo_cevir(kucult($rw['icerik_title']));?>.html"><?=$rw['icerik_title'];?></a></td>
    <td valign="top" align="left">
    <?
    $ektarih = $rw['tarih'];
    $bollan = explode(" ",  $ektarih);
    $cozlan = $bollan[0];
    
    if ($bugunt==$cozlan) { echo "Today ".$bollan[1]; }else{ echo $bollan[0]; }
    ?></td>
    <td valign="top" align="center"><?=$ckc;?></td>
</tr>
<? } ?>

<?php
	for ($i=1; $i<=$sayfa_sayisi; $i++)
		{
			echo '<a href="dosyaadi.php?sayfa='.$i.'">'.$i.'</a>';
		}
?>

</table>
<? require("includes/footer.php"); ?>