Well try this block-releases.php!
[code]
<?php
if (!defined('BLOCK_FILE')) {
Header("Location: ../index.php");
exit;
}
$count = get_row_count("indexreleases");
$blocktitle = "Releases".(get_user_class() >= UC_MODERATOR ? "<font class=\"small\"> - [<a class=\"altlink\" href=\"indexadd.php\"><b>Add</b></a>]</font>" : "");
//$content .= "<table cellspacing=\"0\" cellpadding=\"5\" width=\"100%\"><tr><td>";
if (!$count) {
$content .= "No releases...";
} else {
include "include/codecs.php";
$perpage = 5;
list($pagertop, $pagerbottom, $limit) = pager($perpage, $count, $_SERVER["PHP_SELF"] . "?" );
$content .= $pagertop;
$content .= "</td></tr>";
$res = sql_query("SELECT indexreleases.*, categories.id AS catid, categories.name AS catname, categories.image AS catimage FROM indexreleases LEFT JOIN categories ON indexreleases.cat = categories.id ORDER BY id DESC $limit") or sqlerr(__FILE__, __LINE__);
while ($release = mysql_fetch_array($res)) {
$catid = $release["catid"];
$catname = $release["catname"];
$catimage = $release["catimage"];
$content .= "<tr><td>";
$content .= "<table width=\"100%\" class=\"main\" border=\"1\" cellspacing=\"0\" cellpadding=\"5\">";
$content .= "<tr><td class=\"colhead\" colspan=\"2\" align=\"center\">".htmlspecialchars($release["name"]).(get_user_class() >= UC_MODERATOR ? "<font class=\"small\"> - [<a class=\"altlink_white\" href=\"indexedit.php?action=edit&id=$release[id]&returnto=" . urlencode($_SERVER['PHP_SELF']) . "\"><b>Are you sure to want delete</b></a>][<a class=\"altlink_white\" href=\"indexdelete.php?action=delete&id=$release[id]&returnto=" . urlencode($_SERVER['PHP_SELF']) . "\"><b>press here</b></a>]</font>" : "")."</td></tr>";
$content .= "<tr valign=\"top\"><td align=\"center\" width=\"160\"><img src=\"$release[poster]\" width=\"160\" border=\"0\" /></td>";
$content .= "<td><div align=\"left\">".(!empty($catname) ? "<a href=\"browse.php?cat=$catid\"><img src=\"pic/cats/$catimage\" alt=\"$catname\" title=\"$catname\" align=\"right\" border=\"0\" /></a>" : "")."<b>Genre: </b>".htmlspecialchars($release["genre"])."<br /><b>Director: </b>".htmlspecialchars($release["director"])."<br /><b>Actors: </b>".htmlspecialchars($release["actors"])."<br /></div><div align=\"left\"><hr align=\"left\" width=\"85%\" color=\"#000000\" size=\"1\"></div><div align=\"left\"><b>Ī ōčė