Habe diesen Script schon so gut wie verkleinert und bin noch ein Anfänger in php und mysql!!
>>Alle Filename aus einer kategorie nur vom heutigen Tag???
BILDER...
<?
global $CURUSER;
if (!$CURUSER $CURUSER['view_torrents']=="no")
{
// do nothing
}
else
{
global $BASEURL, $STYLEPATH, $dblist;
block_begin(LAST_TORRENTS);
?>
<table cellpadding="4" cellspacing="1" width="100%">
<?
$sql = "SELECT summary.info_hash as hash, summary.seeds, summary.leechers, summary.dlbytes AS dwned, format(summary.finished,0) as finished, namemap.filename, namemap.url, namemap.info, UNIX_TIMESTAMP(namemap.data) AS added, categories.image, categories.name AS cname, namemap.category AS catid, namemap.size, namemap.external, namemap.uploader FROM summary LEFT JOIN namemap ON summary.info_hash = namemap.info_hash LEFT JOIN categories ON categories.id = namemap.category WHERE summary.leechers + summary.seeds > 0 ORDER BY namemap.data DESC LIMIT " . $GLOBALS['block_last10limit'];
$row = mysql_query($sql) or err_msg(ERROR,CANT_DO_QUERY.mysql_error());
?>
<tr>
<td colspan="2" align="center" class="header"> <? echo TORRENT_FILE; ?> </td>
<?
if ($row)
{
while ($data=mysql_fetch_array($row))
{
echo "<tr>\n";
if ( strlen($data['hash']) > 0 )
{
echo "\t<td NOWRAP align=\"center\" class=\"lista\">";
echo "\t<td width=60% class=\"lista\"><a href=\"javascript:popdetails('details.php?id=" . $data['hash'] . "');\" title=\"" . VIEW_DETAILS . ": " . $data['filename'] . "\">" . $data['filename'] . "</a>".($data['external']=="no"?"":" (<span style=\"color:red\">EXT</span>)")."</td>";
{
{
}
}
}
}
}
print("</table>");
block_end();
} // end if user can view
?>