<?php

if (!defined('BLOCK_FILE')) {
header("Location: ../index.php");
exit;
}

$blocktitle = "Последние 10 раздач";

//Start of Last X torrents mod by ArnLian

$sql = "SELECT torrents.name, torrents.image1 AS image1, torrents.descr, torrents.id, visible, category FROM torrents LEFT JOIN categories ON torrents.category = categories.id WHERE visible='yes' ORDER BY added DESC LIMIT 10";

$result = mysql_query($sql) or die('No torrents found');

while( $row = mysql_fetch_assoc($result) ) {
$catid = $row["category"];
$sql1 = "SELECT categories.name, categories.image FROM categories WHERE categories.id = '$catid'";
$result1 = mysql_query($sql1) or die('No categories found');
$row1 = mysql_fetch_assoc($result1);
$image1 = "" .$row["image1"]. "";

$content .= "<table>";

if( mysql_num_rows($result) != 0 )
{

$content .= '<table class="main" border="1" cellpadding="5" cellspacing="0" width="100%"><tbody><tr><td class="colhead" colspan="2" align="center">';
$content .= '<a href="details.php?id=' . $row['id'] . '&hit=1"><b>' . $row['name'] . ' </b></a></td>';
//$content .= '<td align=center class=rowhead width=45><center></center></td>';
//$content .= '<td class=rowhead><center></center></td>';
$content .= '</tr><tr valign="top"><td align="center" width="160">';

{
//$content .= '<tr>';
   //  $content .= '<td align=center width="45"><a href="details.php?id=' . $row['id'] . '&hit=1">
     //<br><br>';
    $content .= '<img src="torrents/images/' . $image1 . '" border="0" width="160"></td><td><div align="left"><a href="browse.php?cat=' . $row['category'] . '"><img tooltip="' . $row1['name'] . '" src="pic/cats/' . $row1['image'] . '" align="right" border="0"></a>';
 
   // тут можо уменьшить содержимое описания
   if (strlen($row['descr']) > 700) $row['descr'] = substr($row['descr'], 0, 700);
$content .= '' . format_comment($row['descr']) . '';

$content .= '</div><div align="right">[<a tooltip="' . $row['name'] . '" href="details.php?id=' . $row['id'] . '" alt="' . $row['name'] . '"><b>Детали</b></a>]</div></td></tr></tbody>';
}
$content .=  '</tr></table>';
}
else
{
$content .=  'No torrents found';
}
}
//End of Last X torrents mod

?>