Home :: Latest files'; $result = mysql_query("SELECT * FROM torrents LEFT JOIN categories ON torrents.subcat = categories.subid WHERE added > '".date('Ymd')."' ORDER BY added DESC") or die (mysql_error()); $count = mysql_num_rows($result); if ($count == 0) { echo '

0 Torrents added today

'; footer(); die; } echo '

'.$count.' torrents added today

'; foreach ($catt as $catval) { $result = mysql_query("SELECT * FROM torrents LEFT JOIN categories ON torrents.subcat = categories.subid WHERE added > '".date('Ymd')."' AND maincat = '$catval' ORDER BY added DESC") or die (mysql_error()); if (mysql_num_rows($result) == 0) { } else { echo '

'.$catnamet[$catval].'

'; echo ''; while ($row = mysql_fetch_array($result)) { extract($row); echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; } echo '

Category	Date	Filename	Size	Seeds	Peers
'.$name.'	'.substr($added,-9).'	'.regicon($registration,$tracker).' '.desc($description).''.$torrentname.'	'.torsize($size).'	'.getpeer($seeds).'	'.getpeer($peers).'

'; } } footer(); ?>