function index()
{
global $downloadsprefix, $db, $show_links_num, $show_links_info, $show_links_inum, $module_name, $bgcolor1, $bgcolor3;
require_once 'header.php';
downl_menu_tpl(0);
echo '<br />';
OpenTable();
echo "<center><font class=\"title\"><b>" . _DOWNLOADSMAINCAT . "</b></font></center><br />";
echo "<table border=\"0\" cellspacing=\"10\" cellpadding=\"0\" align=\"center\"><tr>";
$sql = "SELECT cid, title, cdescription FROM " . $downloadsprefix . "_categories WHERE parentid='0' ORDER BY title";
$result = $db->sql_query($sql);
$count = $dum = 0;
while ($row = $db->sql_fetchrow($result)) {
$cid = $row['cid'];
$title = $row['title'];
$cdescription = $row['cdescription'];
if ($show_links_num == 1) {
list($cnumrows) = $db->sql_ufetchrow("SELECT COUNT(*) FROM " . $downloadsprefix . "_downloads WHERE cid='{$cid}'", SQL_NUM);
$cnumm = " ({$cnumrows})";
} else {
$cnumm = '';
}
if ($cnumrows > 0) {
$folder = "modules/Downloads/images/openfolder.gif";
} else {
$folder = "modules/Downloads/images/closedfolder.gif";
}
if (can_admin('downloads')) {
$folderImg = "<a href=\"" . adminlink("{$module_name}&mode=DownloadsModCat&cat={$cid}") . "\"><img src=\"{$folder}\" border=\"0\" alt=\"" . _EDIT . "\" /></a>";
} else {
$folderImg = "<img src=\"{$folder}\" border=\"0\" alt=\"{$title}\" />";
}
echo "<td valign=\"top\"><font class=\"title\">{$folderImg} <a href=\"" . getlink("&d_op=viewdownload&cid={$cid}") . "\"><b>{$title}</b></a></font>{$cnumm}";
categorynewdownloadgraphic($cid);
if ($cdescription) {
echo "<br /><font class=\"content\">{$cdescription}</font><br />";
} else {
echo '<br />';
}
$result2 = $db->sql_query("SELECT cid, title FROM " . $downloadsprefix . "_categories WHERE parentid='{$cid}' ORDER BY title LIMIT 0,3");
$space = 0;
while ($row2 = $db->sql_fetchrow($result2)) {
$cid = $row2['cid'];
$stitle = $row2['title'];
if ($space > 0) {
echo ', ';
}
if ($show_links_num == 1) {
list($cnumrows2) = $db->sql_ufetchrow("SELECT COUNT(*) FROM " . $downloadsprefix . "_downloads WHERE cid='{$cid}'", SQL_NUM);
$cnum = " ({$cnumrows2})";
} else {
$cnum = "";
}
echo "<font class=\"content\"><a href=\"" . getlink("&d_op=viewdownload&cid={$cid}") . "\">{$stitle}</a>{$cnum}</font>";
$space++;
}
if ($count < 1) {
echo "</td><td> </td>";
$dum = 1;
}
$count++;
if ($count == 2) {
echo "</td></tr><tr>";
$count = 0;
$dum = 0;
}
}
if ($dum == 1) {
echo '</tr></table>';
} elseif ($dum == 0) {
echo '<td></td></tr></table>';
}
list($numrows) = $db->sql_ufetchrow("SELECT COUNT(*) FROM " . $downloadsprefix . "_downloads", SQL_NUM);
list($catnum) = $db->sql_ufetchrow("SELECT COUNT(*) FROM " . $downloadsprefix . "_categories", SQL_NUM);
echo "<center><font class=\"content\">" . _THEREARE . " <b>{$numrows}</b> " . _DOWNLOADS . " " . _AND . " <b>{$catnum}</b> " . _CATEGORIES . " " . _INDB . "</font></center>";
CloseTable();
if ($show_links_info == 1) {
echo '<br />';
OpenTable();
echo "<table border=\"0\" cellpadding=\"0\" cellspacing=\"3\" width=\"100%\">" . "<tr><td width=\"50%\" valign=\"top\" align=\"center\">";
echo "<div align=\"center\" class=\"title\">" . _NEWDOWNLOADS . "</div>";
echo "</td><td width=\"50%\" valign=\"top\" align=\"center\">";
echo "<div align=\"center\" class=\"title\">" . _MOSTPOPULAR . " {$show_links_inum}</div>";
echo "</td></tr>" . "<tr><td width=\"50%\" valign=\"top\" align=\"center\">";
OpenTable2();
$content = '<table border="0" width="100%">';
$color = $bgcolor3;
$result = $db->sql_query("SELECT lid, title, hits FROM " . $downloadsprefix . "_downloads ORDER BY date DESC LIMIT 0, {$show_links_inum}");
while ($row = $db->sql_fetchrow($result)) {
$title2 = ereg_replace("_", " ", $row['title']);
$color = $color == $bgcolor3 ? $bgcolor1 : $bgcolor3;
$content .= "<tr><td bgcolor=\"{$color}\" align=\"left\"><a href=\"" . getlink("&d_op=viewdownloaddetails&lid={$row['lid']}") . "\">{$title2}</a></td>" . "<td bgcolor=\"{$color}\" align=\"center\" width=\"20\">{$row['hits']}</td></tr>";
}
echo "{$content}</table>";
CloseTable2();
echo "|[ <a href=\"" . getlink("&d_op=NewDownloads") . "\">" . _NEWDOWNLOADS . "</a> ]|";
echo "</td><td width=\"50%\" valign=\"top\" align=\"center\">";
OpenTable2();
$content = "<table border=\"0\" width=\"100%\">";
$color = $bgcolor3;
$result = $db->sql_query("SELECT lid, title, hits FROM " . $downloadsprefix . "_downloads ORDER BY hits DESC LIMIT 0, {$show_links_inum}");
while ($row = $db->sql_fetchrow($result)) {
$title2 = ereg_replace("_", " ", $row['title']);
$color = $color == $bgcolor3 ? $bgcolor1 : $bgcolor3;
$content .= "<tr><td bgcolor=\"{$color}\" align=\"left\"><a href=\"" . getlink("&d_op=viewdownloaddetails&lid={$row['lid']}") . "\">{$title2}</a></td>" . "<td bgcolor=\"{$color}\" align=\"center\" width=\"20\">{$row['hits']}</td></tr>";
}
echo "{$content}</table>";
CloseTable2();
echo "|[ <a href=\"" . getlink("&d_op=MostPopular") . "\">" . _MOSTPOPULAR . " " . _DOWNLOADS . "</a> ]|";
echo "</td></tr></table>";
CloseTable();
}
include "footer.php";
}
function viewdownload()
{
global $downloadsprefix, $db, $perpage, $module_name, $bgcolor1, $bgcolor3, $show_links_num;
$cid = intval($_GET['cid']);
$min = isset($_GET['min']) ? intval($_GET['min']) : 0;
$orderby = convertorderbyin($_GET['orderby']);
$max = $min + $perpage;
include "header.php";
$result = $db->sql_query("SELECT title,cdescription,ldescription,parentid FROM " . $downloadsprefix . "_categories WHERE cid={$cid}");
list($title, $cdescription, $ldescription, $parentid) = $db->sql_fetchrow($result);
$title = getparentlink($parentid, $title);
$title = "<a href=" . getlink() . ">" . _MAIN . "</a>/{$title}";
downl_menu_tpl(1);
echo '<br />';
if ($ldescription != '') {
OpenTable2();
echo "{$ldescription}";
CloseTable2();
echo '<br />';
}
OpenTable();
if ($cdescription != '') {
$cdescription = "<br />" . $cdescription;
}
echo "<center><font class=\"title\"><b>" . _CATEGORY . ": {$title}</b></font>{$cdescription}</center>";
echo "<table border=\"0\" cellspacing=\"10\" cellpadding=\"0\" align=\"center\"><tr>";
$result2 = $db->sql_query("SELECT cid, title, cdescription FROM " . $downloadsprefix . "_categories WHERE parentid={$cid} order by title");
$count = 0;
while (list($cid2, $title2, $cdescription2) = $db->sql_fetchrow($result2)) {
if ($show_links_num == 1) {
$cresult = $db->sql_query("SELECT * FROM " . $downloadsprefix . "_downloads WHERE cid={$cid2}");
$cnumrows = $db->sql_numrows($cresult);
$cnumm = " ({$cnumrows})";
} else {
$cnum = "";
}
if ($cnumrows > 0) {
$folder = "modules/Downloads/images/openfolder.gif";
} else {
$folder = "modules/Downloads/images/closedfolder.gif";
}
if (can_admin('downloads')) {
$folderImg = "<A HREF=\"" . adminlink("{$module_name}&mode=DownloadsModCat&cat={$cid2}") . "\"><IMG SRC=\"{$folder}\" BORDER=0 ALT=\"" . _EDIT . "\"></A>";
} else {
$folderImg = "<IMG SRC=\"{$folder}\" BORDER=0 ALT=\"{$title2}\">";
}
echo "<td valign=\"top\"><font class=\"title\">{$folderImg} <a href=\"" . getlink("&d_op=viewdownload&cid={$cid2}") . "\"><b>{$title2}</b></a></font>{$cnumm}";
categorynewdownloadgraphic($cid2);
if ($cdescription2) {
echo "<br /><font class=\"content\">{$cdescription2}</font><br />";
} else {
echo '<br />';
}
$result3 = $db->sql_query("SELECT cid, title FROM " . $downloadsprefix . "_categories WHERE parentid={$cid2} order by title limit 0,3");
$space = 0;
while (list($cid3, $title3) = $db->sql_fetchrow($result3)) {
if ($space > 0) {
echo ", ";
}
if ($show_links_num == 1) {
$cresult2 = $db->sql_query("SELECT * FROM " . $downloadsprefix . "_downloads WHERE cid={$cid3}");
$cnumrows2 = $db->sql_numrows($cresult2);
$cnum = " ({$cnumrows2})";
} else {
$cnum = "";
}
echo "<font class=\"content\"><a href=\"" . getlink("&d_op=viewdownload&cid={$cid3}") . "\">{$title3}</a></font>{$cnum}";
$space++;
}
if ($count < 1) {
echo "</td><td> </td>";
$dum = 1;
}
$count++;
if ($count == 2) {
echo "</td></tr><tr>";
$count = 0;
$dum = 0;
}
}
if ($dum == 1) {
echo "</tr></table>";
} elseif ($dum == 0) {
echo "<td></td></tr></table>";
}
echo "<hr noshade size=\"1\">";
$orderbyTrans = convertorderbytrans($orderby);
echo "<center><font class=\"content\">" . _SORTDOWNLOADSBY . ": " . _TITLE . " (<a href=\"" . getlink("&d_op=viewdownload&cid={$cid}&orderby=titleA") . "\">A</a>\\<a href=\"" . getlink("&d_op=viewdownload&cid={$cid}&orderby=titleD") . "\">D</a>) " . _DATE . " (<a href=\"" . getlink("&d_op=viewdownload&cid={$cid}&orderby=dateA") . "\">A</a>\\<a href=\"" . getlink("&d_op=viewdownload&cid={$cid}&orderby=dateD") . "\">D</a>) " . _RATING . " (<a href=\"" . getlink("&d_op=viewdownload&cid={$cid}&orderby=ratingA") . "\">A</a>\\<a href=\"" . getlink("&d_op=viewdownload&cid={$cid}&orderby=ratingD") . "\">D</a>) " . _POPULARITY . " (<a href=\"" . getlink("&d_op=viewdownload&cid={$cid}&orderby=hitsA") . "\">A</a>\\<a href=\"" . getlink("&d_op=viewdownload&cid={$cid}&orderby=hitsD") . "\">D</a>)" . "<br /><b>" . _RESSORTED . ": {$orderbyTrans}</b></font></center>";
echo "<hr noshade size=\"1\">";
$result = $db->sql_query("SELECT lid, title, url, description, date, hits, downloadratingsummary, totalvotes, totalcomments, filesize, version, homepage FROM " . $downloadsprefix . "_downloads WHERE cid={$cid} order by {$orderby} limit {$min},{$perpage} ");
$fullcountresult = $db->sql_query("SELECT lid FROM " . $downloadsprefix . "_downloads WHERE cid={$cid}");
$totalselecteddownloads = $db->sql_numrows($fullcountresult);
echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"10\" border=\"0\"><tr><td><font class=\"content\">";
$x = 0;
$color = $bgcolor3;
while (list($lid, $title, $url, $description, $time, $hits, $downloadratingsummary, $totalvotes, $totalcomments, $filesize, $version, $homepage) = $db->sql_fetchrow($result)) {
$downloadratingsummary = number_format($downloadratingsummary, $mainvotedecimal);
$color = $color == $bgcolor3 ? $bgcolor1 : $bgcolor3;
echo "<TABLE BORDER=0 CELLPADDING=2 CELLSPACING=0 WIDTH=100%><TR BGCOLOR=\"{$color}\"><TD>";
if (can_admin('downloads')) {
if (eregi("http", $url)) {
echo "<a href=\"" . adminlink("{$module_name}&mode=DownloadsModDownload&lid={$lid}") . "\"><img src=\"modules/{$module_name}/images/icon30.gif\" border=\"0\" alt=\"" . _EDIT . "\"></a>";
} else {
echo "<a href=\"" . adminlink("{$module_name}&mode=DownloadsModDownload&lid={$lid}") . "\"><img src=\"modules/{$module_name}/images/download.gif\" border=\"0\" alt=\"" . _EDIT . "\"></a>";
}
} else {
if (eregi("http", $url)) {
echo "<img src=\"modules/{$module_name}/images/icon30.gif\" border=\"0\" alt=\"\">";
} else {
echo "<img src=\"modules/{$module_name}/images/download.gif\" border=\"0\" alt=\"\">";
}
}
echo "</td><td width=\"100%\" class=\"title\" valign=\"top\"><a href=\"" . getlink("&d_op=getit&lid={$lid}") . "\"><B>{$title}</b></a>";
$datetime = formatDateTime($time . ' 00:00:00', _DATESTRING3);
newdownloadgraphic($datetime);
popgraphic($hits);
detecteditorial($lid, 1);
echo "</td></tr><TR BGCOLOR=\"{$color}\"><TD COLSPAN=2>";
echo "<DIV ALIGN=\"JUSTIFY\"><b>" . _DESCRIPTION . ":</b> {$description}</td></tr><TR BGCOLOR=\"{$color}\"><TD COLSPAN=2>";
echo "<b>" . _VERSION . ":</b> {$version} <b>" . _FILESIZE . ":</b> " . CoolSize($filesize) . "<br />";
echo "<b>" . _ADDEDON . ":</b> {$datetime} <b>" . _UDOWNLOADS . ":</b> {$hits}";
$transfertitle = str_replace(" ", "_", $title);
/* voting & comments stats */
if ($totalvotes == 1) {
$votestring = _VOTE;
} else {
$votestring = _VOTES;
}
if ($downloadratingsummary != "0" || $downloadratingsummary != "0.0") {
echo " <b>" . _RATING . ":</b> {$downloadratingsummary} ({$totalvotes} {$votestring})";
}
if ($homepage == "") {
echo '<br />';
} else {
echo "<br /><a href=\"{$homepage}\" target=\"new\">" . _HOMEPAGE . "</a> | ";
}
echo "<a href=\"" . getlink("&d_op=ratedownload&lid={$lid}") . "\">" . _RATERESOURCE . "</a>";
if (is_user()) {
echo " | <a href=\"" . getlink("&d_op=brokendownload&lid={$lid}") . "\">" . _REPORTBROKEN . "</a>";
}
echo " | <a href=\"" . getlink("&d_op=viewdownloaddetails&lid={$lid}") . "\">" . _DETAILS . "</a>";
if ($totalcomments != 0) {
echo " | <a href=\"" . getlink("&d_op=viewdownloadcomments&lid={$lid}") . "\">" . _SCOMMENTS . " ({$totalcomments})</a>";
}
detecteditorial($lid, 0);
echo "</div></td></tr></table><br />";
$x++;
}
echo "</font>";
$orderby = convertorderbyout($orderby);
/* Calculates how many pages exist. Which page one should be on, etc... */
$downloadpagesint = $totalselecteddownloads / $perpage;
$downloadpageremainder = $totalselecteddownloads % $perpage;
if ($downloadpageremainder != 0) {
$downloadpages = ceil($downloadpagesint);
if ($totalselecteddownloads < $perpage) {
$downloadpageremainder = 0;
}
} else {
$downloadpages = $downloadpagesint;
}
/* Page Numbering */
if ($downloadpages != 1 && $downloadpages != 0) {
echo "<br /><br />";
echo _SELECTPAGE . ": ";
$prev = $min - $perpage;
if ($prev >= 0) {
echo " <b>[ <a href=\"" . getlink("&d_op=viewdownload&cid={$cid}&min={$prev}&orderby={$orderby}") . "\">";
echo " << " . _PREVIOUSPAGE . "</a> ]</b> ";
}
$counter = 1;
$currentpage = $max / $perpage;
while ($counter <= $downloadpages) {
$cpage = $counter;
$mintemp = $perpage * $counter - $perpage;
if ($counter == $currentpage) {
echo "<b>{$counter}</b> ";
} else {
echo "<a href=\"" . getlink("&d_op=viewdownload&cid={$cid}&min={$mintemp}&orderby={$orderby}") . "\">{$counter}</a> ";
}
$counter++;
}
$next = $min + $perpage;
if ($x >= $perpage) {
echo " <b>[ <a href=\"" . getlink("&d_op=viewdownload&cid={$cid}&min={$max}&orderby={$orderby}") . "\">" . _NEXTPAGE . " >></a> ]</b> ";
}
}
echo "</td></tr></table>";
CloseTable();
include "footer.php";
}
function viewsdownload($sid, $min, $orderby, $show)
{
global $prefix, $db, $admin, $module_name, $user, $admin_file, $datetime, $transfertitle, $locale;
include "modules/{$module_name}/d_config.php";
include "header.php";
$sid = intval($sid);
menu(1);
if (!isset($min)) {
$min = 0;
}
if (!isset($max)) {
$max = $min + $perpage;
}
if (!empty($orderby)) {
$orderby = convertorderbyin($orderby);
} else {
$orderby = "title ASC";
}
if (!empty($show)) {
$perpage = $show;
} else {
$show = $perpage;
}
echo "<br>";
OpenTable();
$cid = intval(trim($cid));
$result = $db->sql_query("SELECT title,parentid FROM " . $prefix . "_downloads_categories WHERE cid='{$cid}'");
list($title, $parentid) = $result->fetch_row();
$title = filter($title, "nohtml");
$parentid = intval($parentid);
$title = getparentlink($parentid, $title);
$title = "<a href=modules.php?name={$module_name}>" . _MAIN . "</a>/{$title}";
echo "<center><font class=\"option\"><b>" . _CATEGORY . ": {$title}</b></font></center><br>";
echo "<table border=\"0\" cellspacing=\"10\" cellpadding=\"0\" align=\"center\"><tr>";
$result2 = $db->sql_query("SELECT cid, title, cdescription FROM " . $prefix . "_downloads_categories WHERE parentid='{$cid}' order by title");
$count = 0;
while (list($cid2, $title2, $cdescription2) = $result2->fetch_row()) {
$cid2 = intval($cid2);
$title = filter($title, "nohtml");
$cdescription = filter($cdescription);
echo "<td><font class=\"option\"><strong><big>·</big></strong> <a href=\"modules.php?name={$module_name}&d_op=viewdownload&cid={$cid2}\"><b>{$title2}</b></a></font>";
categorynewdownloadgraphic($cid2);
if ($cdescription2) {
echo "<font class=\"content\">{$cdescription2}</font><br>";
} else {
echo "<br>";
}
$result3 = $db->sql_query("SELECT cid, title FROM " . $prefix . "_downloads_categories WHERE parentid='{$cid2}' order by title limit 0,3");
$space = 0;
while (list($cid3, $title3) = $result3->fetch_row()) {
$cid3 = intval($cid3);
$title3 = filter($title3, "nohtml");
if ($space > 0) {
echo ", ";
}
echo "<font class=\"content\"><a href=\"modules.php?name={$module_name}&d_op=viewdownload&cid={$cid3}\">{$title3}</a></font>";
$space++;
}
if ($count < 1) {
echo "</td><td> </td>";
$dum = 1;
}
$count++;
if ($count == 2) {
echo "</td></tr><tr>";
$count = 0;
$dum = 0;
}
}
if ($dum == 1) {
echo "</tr></table>";
} elseif ($dum == 0) {
echo "<td></td></tr></table>";
}
echo "<hr noshade size=\"1\">";
$orderbyTrans = convertorderbytrans($orderby);
echo "<br><center><font class=\"content\">" . _SORTDOWNLOADSBY . ": " . "" . _TITLE . " (<a href=\"modules.php?name={$module_name}&d_op=viewdownload&sid={$sid}&orderby=titleA\">A</a>\\<a href=\"modules.php?name={$module_name}&d_op=viewdownload&sid={$sid}&orderby=titleD\">D</a>)" . " " . _DATE . " (<a href=\"modules.php?name={$module_name}&d_op=viewdownload&sid={$sid}&orderby=dateA\">A</a>\\<a href=\"modules.php?name={$module_name}&d_op=viewdownload&sid={$sid}&orderby=dateD\">D</a>)" . " " . _RATING . " (<a href=\"modules.php?name={$module_name}&d_op=viewdownload&sid={$sid}&orderby=ratingA\">A</a>\\<a href=\"modules.php?name={$module_name}&d_op=viewdownload&sid={$sid}&orderby=ratingD\">D</a>)" . " " . _POPULARITY . " (<a href=\"modules.php?name={$module_name}&d_op=viewdownload&sid={$sid}&orderby=hitsA\">A</a>\\<a href=\"modules.php?name={$module_name}&d_op=viewdownload&sid={$sid}&orderby=hitsD\">D</a>)" . "<br><b>" . _RESSORTED . ": {$orderbyTrans}</b></font></center><br><br>";
if (!is_numeric($min)) {
$min = 0;
}
$result = $db->sql_query("SELECT lid, url, title, description, date, hits, downloadratingsummary, totalvotes, totalcomments, filesize, version, homepage FROM " . $prefix . "_downloads_downloads WHERE sid='{$sid}' order by {$orderby} limit {$min},{$perpage}");
$fullcountresult = $db->sql_query("SELECT lid, title, description, date, hits, downloadratingsummary, totalvotes, totalcomments FROM " . $prefix . "_downloads_downloads WHERE sid='{$sid}'");
$totalselecteddownloads = $db->sql_numrows($fullcountresult);
echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"10\" border=\"0\"><tr><td><font class=\"content\">";
$x = 0;
while (list($lid, $url, $title, $description, $time, $hits, $downloadratingsummary, $totalvotes, $totalcomments, $filesize, $version, $homepage) = $result->fetch_row()) {
$lid = intval($lid);
$hits = intval($hits);
$totalvotes = intval($totalvotes);
$totalcomments = intval($totalcomments);
$downloadratingsummary = number_format($downloadratingsummary, $mainvotedecimal);
$title = filter($title, "nohtml");
$description = filter($description);
global $prefix, $db, $admin;
if (is_admin($admin)) {
echo "<a href=\"" . $admin_file . ".php?op=DownloadsModDownload&lid={$lid}\"><img src=\"modules/{$module_name}/images/lwin.gif\" border=\"0\" alt=\"" . _EDIT . "\"></a> ";
} else {
echo "<img src=\"modules/{$module_name}/images/lwin.gif\" border=\"0\" alt=\"\"> ";
}
echo "<a href=\"modules.php?name={$module_name}&d_op=getit&lid={$lid}\">{$title}</a>";
newdownloadgraphic($datetime, $time);
popgraphic($hits);
/* code for *editor review* insert here */
detecteditorial($lid, $transfertitle, 1);
echo "<br><b>" . _DESCRIPTION . ":</b> {$description}<br>";
setlocale(LC_TIME, $locale);
ereg("([0-9]{4})-([0-9]{1,2})-([0-9]{1,2}) ([0-9]{1,2}):([0-9]{1,2}):([0-9]{1,2})", $time, $datetime);
$datetime = strftime("" . _LINKSDATESTRING . "", mktime($datetime[4], $datetime[5], $datetime[6], $datetime[2], $datetime[3], $datetime[1]));
$datetime = ucfirst($datetime);
echo "<b>" . _VERSION . ":</b> {$version} <b>" . _FILESIZE . ":</b> " . CoolSize($filesize) . "<br>";
echo "<b>" . _ADDEDON . ":</b> {$datetime} <b>" . _UDOWNLOADS . ":</b> {$hits}";
$transfertitle = str_replace(" ", "_", $title);
/* voting & comments stats */
if ($totalvotes == 1) {
$votestring = _VOTE;
} else {
$votestring = _VOTES;
}
if ($downloadratingsummary != "0" || $downloadratingsummary != "0.0") {
echo " <b>" . _RATING . ":</b> {$downloadratingsummary} ({$totalvotes} {$votestring})";
}
if (empty($homepage)) {
echo "<br>";
} else {
echo "<br><a href=\"{$homepage}\" target=\"new\">" . _HOMEPAGE . "</a> | ";
}
echo "<a href=\"modules.php?name={$module_name}&d_op=ratedownload&lid={$lid}\">" . _RATERESOURCE . "</a>";
if (is_user($user)) {
echo " | <a href=\"modules.php?name={$module_name}&d_op=brokendownload&lid={$lid}\">" . _REPORTBROKEN . "</a>";
}
echo " | <a href=\"modules.php?name={$module_name}&d_op=viewdownloaddetails&lid={$lid}\">" . _DETAILS . "</a>";
if ($totalcomments != 0) {
echo " | <a href=\"modules.php?name={$module_name}&d_op=viewdownloadcomments&lid={$lid}\">" . _SCOMMENTS . " ({$totalcomments})</a>";
}
detecteditorial($lid, $transfertitle, 0);
echo "<br><br>";
$x++;
}
echo "</font>";
$orderby = convertorderbyout($orderby);
/* Calculates how many pages exist. Which page one should be on, etc... */
$downloadpagesint = $totalselecteddownloads / $perpage;
$downloadpageremainder = $totalselecteddownloads % $perpage;
if ($downloadpageremainder != 0) {
$downloadpages = ceil($downloadpagesint);
if ($totalselecteddownloads < $perpage) {
$downloadpageremainder = 0;
}
} else {
$downloadpages = $downloadpagesint;
}
/* Page Numbering */
if ($downloadpages != 1 && $downloadpages != 0) {
echo "<br><br>" . "" . _SELECTPAGE . ": ";
$prev = $min - $perpage;
if ($prev >= 0) {
echo " <b>[ <a href=\"modules.php?name={$module_name}&d_op=viewdownload&sid={$sid}&min={$prev}&orderby={$orderby}&show={$show}\">" . " << " . _PREVIOUS . "</a> ]</b> ";
}
$counter = 1;
$currentpage = $max / $perpage;
while ($counter <= $downloadpages) {
$cpage = $counter;
$mintemp = $perpage * $counter - $perpage;
if ($counter == $currentpage) {
echo "<b>{$counter}</b> ";
} else {
echo "<a href=\"modules.php?name={$module_name}&d_op=viewdownload&sid={$sid}&min={$mintemp}&orderby={$orderby}&show={$show}\">{$counter}</a> ";
}
$counter++;
}
$next = $min + $perpage;
if ($x >= $perpage) {
echo " <b>[ <a href=\"modules.php?name={$module_name}&d_op=viewdownload&sid={$sid}&min={$max}&orderby={$orderby}&show={$show}\">" . " " . _NEXT . " >></a> ]</b> ";
}
}
echo "</td></tr></table>";
CloseTable();
include "footer.php";
}
function index()
{
global $prefix, $db, $module_name, $show_links_num, $show_links_info, $show_links_inum, $admin;
include "header.php";
$maindownload = 0;
menu($maindownload);
echo "<br>";
OpenTable();
echo "<center><font class=\"title\"><b>" . _DOWNLOADSMAINCAT . "</b></font></center><br>";
echo "<table border=\"0\" cellspacing=\"10\" cellpadding=\"0\" align=\"center\"><tr>";
$sql = "SELECT cid, title, cdescription FROM " . $prefix . "_downloads_categories WHERE parentid='0' ORDER BY title";
$result = $db->sql_query($sql);
$count = 0;
while ($row = $db->sql_fetchrow($result)) {
$cid = $row[cid];
$title = $row[title];
$cdescription = $row[cdescription];
if ($show_links_num == 1) {
$cnumrows = $db->sql_numrows($db->sql_query("SELECT * FROM " . $prefix . "_downloads_downloads WHERE cid='{$cid}'"));
$cnumm = " ({$cnumrows})";
} else {
$cnumm = "";
}
if ($cnumrows > 0) {
$folder = "modules/Downloads/images/openfolder.gif";
} else {
$folder = "modules/Downloads/images/closedfolder.gif";
}
if (is_admin($admin)) {
$folderImg = "<A HREF=\"admin.php?op=DownloadsModCat&cat={$cid}\"><IMG SRC=\"{$folder}\" BORDER=0 ALT=\"" . _EDIT . "\"></A>";
} else {
$folderImg = "<IMG SRC=\"{$folder}\" BORDER=0 ALT=\"{$title}\">";
}
echo "<td><font class=\"title\">{$folderImg} <a href=\"modules.php?name={$module_name}&d_op=viewdownload&cid={$cid}\"><b>{$title}</b></a></font>{$cnumm}";
categorynewdownloadgraphic($cid);
if ($cdescription) {
echo "<br><font class=\"content\">{$cdescription}</font><br>";
} else {
echo "<br>";
}
$sql2 = "SELECT cid, title FROM " . $prefix . "_downloads_categories WHERE parentid='{$cid}' ORDER BY title LIMIT 0,3";
$result2 = $db->sql_query($sql2);
$space = 0;
while ($row2 = $db->sql_fetchrow($result2)) {
$cid = $row2[cid];
$stitle = $row2[title];
if ($space > 0) {
echo ", ";
}
if ($show_links_num == 1) {
$cnumrows2 = $db->sql_numrows($db->sql_query("SELECT * FROM " . $prefix . "_downloads_downloads WHERE cid='{$cid}'"));
$cnum = " ({$cnumrows2})";
} else {
$cnumrows2 = "";
}
echo "<font class=\"content\"><a href=\"modules.php?name={$module_name}&d_op=viewdownload&cid={$cid}\">{$stitle}</a>{$cnum}</font>";
$space++;
}
if ($count < 1) {
echo "</td><td> </td>";
$dum = 1;
}
$count++;
if ($count == 2) {
echo "</td></tr><tr>";
$count = 0;
$dum = 0;
}
}
if ($dum == 1) {
echo "</tr></table>";
} elseif ($dum == 0) {
echo "<td></td></tr></table>";
}
$numrows = $db->sql_numrows($db->sql_query("SELECT * FROM " . $prefix . "_downloads_downloads"));
$catnum = $db->sql_numrows($db->sql_query("SELECT * FROM " . $prefix . "_downloads_categories"));
echo "<center><font class=\"content\">" . _THEREARE . " <b>{$numrows}</b> " . _DOWNLOADS . " " . _AND . " <b>{$catnum}</b> " . _CATEGORIES . " " . _INDB . "</font></center>";
CloseTable();
if ($show_links_info == 1) {
echo "<BR>";
OpenTable();
echo "<TABLE BORDER=0 CELLPADDING=0 CELLSPACING=3 WIDTH=100%>" . "<TR><TD WIDTH=50% VALIGN=TOP ALIGN=CENTER>";
// OpenTable2();
echo "<DIV ALIGN=CENTER CLASS=\"title\">" . _NEWDOWNLOADS . "</DIV>";
// CloseTable2();
echo "</TD><TD WIDTH=50% VALIGN=TOP ALIGN=CENTER>";
// OpenTable2();
echo "<DIV ALIGN=CENTER CLASS=\"title\">" . _MOSTPOPULAR . " {$show_links_inum}</DIV>";
// CloseTable2();
echo "</TD></TR>" . "<TR><TD WIDTH=50% VALIGN=TOP ALIGN=CENTER>";
OpenTable2();
$content = "";
$content .= "<TABLE BORDER=0 WIDTH=\"100%\">";
$color = $bgcolor3;
$sql = "SELECT lid, title, hits FROM " . $prefix . "_downloads_downloads ORDER BY date DESC LIMIT 0, {$show_links_inum}";
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)) {
$title2 = ereg_replace("_", " ", $row[title]);
$color = switchColor($color);
$content .= "<TR><TD BGCOLOR=\"{$color}\" ALIGN=LEFT><a href=\"modules.php?name=Downloads&d_op=viewdownloaddetails&lid={$row['lid']}&title={$row['title']}\">{$title2}</a></TD>";
$content .= "<TD BGCOLOR=\"{$color}\" ALIGN=CENTER WIDTH=\"20\">{$row['hits']}</TD></TR>";
}
echo "{$content}</TABLE>";
CloseTable2();
echo "|[ <A HREF=\"modules.php?name=Downloads&d_op=NewDownloads\">" . _NEWDOWNLOADS . "</A> ]|";
echo "</TD><TD WIDTH=50% VALIGN=TOP ALIGN=CENTER>";
OpenTable2();
$content = "";
$content .= "<TABLE BORDER=0 WIDTH=\"100%\">";
$color = $bgcolor3;
$sql = "SELECT lid, title, hits FROM " . $prefix . "_downloads_downloads ORDER BY hits DESC LIMIT 0, {$show_links_inum}";
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)) {
$title2 = ereg_replace("_", " ", $row[title]);
$color = switchColor($color);
$content .= "<TR><TD BGCOLOR=\"{$color}\" ALIGN=LEFT><a href=\"modules.php?name=Downloads&d_op=viewdownloaddetails&lid={$row['lid']}&title={$row['title']}\">{$title2}</a></TD>";
$content .= "<TD BGCOLOR=\"{$color}\" ALIGN=CENTER WIDTH=\"20\">{$row['hits']}</TD></TR>";
}
echo "{$content}</TABLE>";
CloseTable2();
echo "|[ <A HREF=\"modules.php?name=Downloads&d_op=MostPopular\">" . _MOSTPOPULAR . " " . _DOWNLOADS . "</A> ]|";
echo "</TD></TR>" . "</TABLE>";
CloseTable();
}
include "footer.php";
}
