<?php
$maxfiles ='20';
/*
$num[cats] = $pafiledb_sql->query($db, "SELECT * FROM $db[prefix]_cat", 2);
$num[files] = $pafiledb_sql->query($db, "SELECT * FROM $db[prefix]_files", 2);
*/
$newest = $pafiledb_sql->query($db, "SELECT * FROM $db[prefix]_files ORDER BY file_time DESC", 1);
require "./lang/$config[13].php";
?>
<center><table width="100%" border="0" cellpadding="2" cellspacing="0" class="forumline" bordercolor="#000000" style="border-collapse: collapse; border-width: 0">
<tr><td width="60%" class="desc" bgcolor="#c6e858"><center><b><?php echo $str[category]; ?></b></center></td><td width="40%" class="desc" bgcolor="#c6e858"><center><b><?php echo $str[files]; ?></b></center></td></tr>
<?php
/*Begin Sub Cat counting bug fix. Thanx Kron!!!!!*/
$filesindb = $pafiledb_sql->query($db, "SELECT * FROM $db[prefix]_files", 2);
$result = $pafiledb_sql->query($db, "SELECT * FROM $db[prefix]_cat ORDER BY cat_order", 0);
while ($category = mysql_fetch_object($result)) {
$filesincat = 0;
if ($category->cat_parent == 0) {
$filesincat = $pafiledb_sql->query($db, "SELECT * FROM $db[prefix]_files WHERE file_catid = '$category->cat_id'", 2);
$subgroups = $pafiledb_sql->query($db, "SELECT * FROM $db[prefix]_cat WHERE cat_parent = $category->cat_id", 0);
while($i = mysql_fetch_row($subgroups)) {
$filesincat += $pafiledb_sql->query($db, "SELECT * FROM $db[prefix]_files WHERE file_catid = $i[0]", 2);
}
}
if ($category->cat_parent == 0){
$baslik = $category->cat_name;
$baslik = strtolower(stripslashes(strtr($baslik,"ÜŞÇİĞÖüöşçi ğı?","USCIGOuoscigi,")));
$baslik = str_replace(" ","_",$baslik);
echo "<tr><td width=\"70%\" class=\"desc\"><center><img src=\"images/music.gif\" border=\"0\">&nbsp;<a href=\"kategori$category->cat_id-$baslik.htm\">$category->cat_name</a></center></td><td width=\"30%\" class=\"desc\"><center>$filesincat</center></td></tr>";
}
}


/*End Sub Cat counting bug fix.*/
if ($config[14] == 1) {
?>
<tr><td width="90%" class="datacell"><a href="mp3.php?action=viewall"><?php echo $str[viewall]; ?></a><br><a class="smalltext">&raquo; <?php echo $str[vainfo]; ?> &laquo;</a></td><td width="10%" class="datacell"><center><?php echo $filesindb; ?></center></td></tr>

<?php
}
echo "</table>
</center>";
?>

<br>

<center>
<table width="100%" border="0" cellpadding="2" cellspacing="0" bordercolor="#000000">
<tr>
<td width="50%">


<table width="100%" border="0" cellpadding="2" cellspacing="0" class="forumline" bordercolor="#000000" style="border-collapse: collapse; border-width: 0">
<tr><td width="100%" class="desc" bgcolor="#f5ce61"><center><b>En Yeni Filmler</b></center></td>
<td class="desc" bgcolor="#f5ce61"><center><b>İndirilme Sayısı</b></center></td></tr>

<?php

$result = $pafiledb_sql->query($db, "SELECT * FROM $db[prefix]_files ORDER BY file_time DESC LIMIT $maxfiles", 0);
while ($countm = mysql_fetch_object($result))
{
$date = date("n/j/y", $countm->file_time);
$baslik = $countm->file_name;
$baslik = strtolower(stripslashes(strtr($baslik,"ÜŞÇİĞÖüöşçi ğı?","USCIGOuoscigi,")));
$baslik = str_replace(" ","_",$baslik);
echo "<tr><td width=\"96%\" class=\"desc\"><img src=\"images/minimp3.jpg\" border=\"0\"> <a href=\"mp3$countm->file_id-$baslik.htm\">$countm->file_name</a></td>
<td width=4% class=\"desc\"><center>$countm->file_dls</center></td></tr>";
}
?>
</table>




</td>
<td width="50%">




<table width="100%" border="0" cellpadding="2" cellspacing="0" class="forumline" bordercolor="#000000" style="border-collapse: collapse; border-width: 0">
<tr><td width="100%" class="desc" bgcolor="#f5ce61"><center><b>En Çok İndirlen Filmler</b></center></td>
<td class="desc" bgcolor="#f5ce61"><center><b>İndirilme Sayısı</b></center></td></tr>
<?php
$result = $pafiledb_sql->query($db, "SELECT * FROM $db[prefix]_files ORDER BY file_dls DESC LIMIT $maxfiles", 0);
while ($countm = mysql_fetch_object($result))
{
$baslik = $countm->file_name;
$baslik = strtolower(stripslashes(strtr($baslik,"ÜŞÇİĞÖüöşçi ğı?","USCIGOuoscigi,")));
$baslik = str_replace(" ","_",$baslik);

echo "<tr><td width=\"96%\" class=\"desc\"><img src=\"images/minimp3.jpg\" border=\"0\"> <a href=\"mp3$countm->file_id-$baslik.htm\">$countm->file_name</a></td>
<td width=4% class=\"desc\"><center>$countm->file_dls</center></td></tr>";
}
?>
</table>




</td>
</tr>
</table>


<br />





<?php
/*
paFileDB 3.1
©2001/2002 PHP Arena
Written by Todd
todd@phparena.net
PHP Arena » Home
Keep all copyright links on the script visible
Please read the license included with this script for more information.
*/
if ($search == "do") {
$string = strip_tags($string, '<a><b><i><u>');
$string = stripslashes($string);
$string = addslashes($string);

$result = $pafiledb_sql->query($db, "SELECT * FROM $db[prefix]_files WHERE file_name LIKE '%$string%' OR file_desc LIKE '%$string%' OR file_creator LIKE '%$string%' OR file_longdesc LIKE '%$string%' OR file_version LIKE '%$string%'", 0);
$numhits = mysql_num_rows($result);
?>
<table width="100%" border="0" cellpadding="2" cellspacing="0" class="headertable" bordercolor="#000000">
<tr><td width="100%" colspan="2" class="headercell"><center><b>Film Ara</b></center></td></tr>
<?php
if ($numhits == 0) {
?>
<tr>
<td width="5%" align="center" valign="center" class="datacell"><img src="styles/<?php echo $config[11]; ?>/images/error.gif" border="0"></td><td width="95%" class="datacell"><?php echo $str[nomatches]; ?> <b><?php echo $string; ?></b></td></tr>
<?php
} else {
?>
<tr><td width="100%" class="datacell" align="center" colspan="2"><?php echo "$numhits $str[matches] <b> $string"; ?></b></td></tr>
<?php
while ($r = mysql_fetch_object($result)) {
if ($r->file_posticon == "none" or $r->file_posticon == "none.gif" or empty($r->file_posticon)) {
$posticon = "&nbsp;";
} else {
$posticon = "<img src=\"images/posticons/$r->file_posticon\">";
}
echo "<tr><td width=\"%5\" align=\"center\" class=\"datacell\">$posticon</td><td width=\"95%\" class=\"datacell\" align=\"left\"><a href=\"bedava-mp3-indir-$r->file_id.htm\">$r->file_name</a></td></tr>";
}
}
echo "</table>";
}

?>
<table width="100%" border="0" cellpadding="2" cellspacing="0" class="forumline" bordercolor="#000000" style="border-collapse: collapse; border-width: 0">
<tr><td width="100%" colspan="2" class="desc" bgcolor="#a7d3f8"><center><b>Film ara</b></center></td></tr>
<tr><form action="mp3.php" method="post"><td width="40%" class="desc" align="right">Film ismi<a href="http://www.dizifilmindir.net">:</a> </td><td width="60%" align="left" class="desc"><input type="text" name="string" size="30" class="forminput"> <input type="hidden" name="action" value="search"><input type="hidden" name="search" value="do"><input type="submit" value=">> <?php echo $str[search]; ?> <<"></td></tr>
<!-- <tr><td width="100%" class="desc" align="center" colspan="2"><input type="hidden" name="action" value="search"><input type="hidden" name="search" value="do"><input type="submit" value=">> <?php echo $str[search]; ?> <<">
</td></tr> --> </form></table>
</center>
<?php
if ($logged == 1) { echo "</td></tr></table>"; } ?>