Help with block

Nuke Cadet Joined: Feb 06, 2008 Posts: 2

Hi,
maybe someone has the time to help me, i would like to use a center block for downloads and reviews.
I use the NSN Download Module and i have a center block for the latest 10 downloads, i put the code here, i would like to have in the same block the latest 10 reviews.
I do not know how to do that. I hope you understand me left side the latest 10 files, right side the latest 10 reviews. Is that possible?
Could you help me with that?
Now the code for the downloads:

Code:

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

global $prefix, $db;

$result = $db->sql_query("SELECT lid, title, date, hits FROM ".$prefix."_nsngd_downloads ORDER BY lid DESC LIMIT 0,10");
$content = "<table width=\"100%\" border=\"0\">";
while (list($lid, $title, $date, $hits) = $db->sql_fetchrow($result)) {
$lid = intval($lid);
$title = stripslashes($title);
$title2 = ereg_replace("_", " ", $title);
$post_time = $date;
$content .= " <tr>";
$content .= " <td align=\"left\" valign=\"top\">";
$content .= " <img src=\"images/blocks/downloads.png\" border=\"0\" alt=\"\" title=\"\" width=\"16\" height=\"16\">";
$content .= " </td>";
$content .= " <td align=\"left\" valign=\"top\">";
$content .= " <a href=\"modules.php?name=Downloads&op=getit&amp ;lid=$lid&title=$title\"><b>$title2</b></a><br>";
$content .= " </td>";
$content .= " <td align=\"right\" valign=\"top\">";
$content .= " [ Posted on $post_time | Downloads $hits ]";
$content .= " </td>";
$content .= " </tr>";
}
$content .= "</table>";

The block does not have to show esle that the image and the filename posted and date are not necessary, the same way i would like to have the latest 10 reviews in the same block.
Sorry for my english.
Thanks in advance