ok so if you find $bob i am trying to get that code to work on the line below after print
PHP Code:
<?php
/***************************************************************************
* NZB Browse Page
* ========================================
* NZB Mod - Public v.TS-1.0b
* TorrentStrike version
* ========================================
* created by dodgy
* http://www.webdeviation.com
* Special thanks to all who have had a hand in TBDev/TorrentStrike
***************************************************************************/
ob_start("ob_gzhandler");
require_once("include/bittorrent.php");
include_once("imdb.class.php");
dbconn();
// To stop entities appearing from imdb names
function nzb_name_encode($string, $imdb) {
$string = @mb_convert_encoding($string, "UTF-8");
if ($imdb == "no")
$string = safe($string);
return $string;
}
// Table for NZB's in nzbbrowse.php
// If you plan on using this elsewhere place this function in bittorrent.php
function nzbtable($res) {
global $pic_base_url, $CURUSER;
// For NEW tag
$last_nzbrowse = $CURUSER["last_nzbrowse"];
$time_now = gmtime();
if (empty($_COOKIE['LAST_NZBROWSE']))
setcookie('LAST_NZBROWSE', $last_nzbrowse, time() + 1800);
else
$last_nzbrowse = $_COOKIE['LAST_NZBROWSE'];
?>
<div align="right">
<table border="0" cellspacing="0" cellpadding="2" width="100%">
<tr>
<?
$count_get = 0;
foreach ($_GET as $get_name => $get_value) {
if ($get_name != "sort" && $get_name != "type") {
if ($count_get > 0) {
$oldlink = $oldlink . "&" . $get_name . "=" . $get_value;
} else {
$oldlink = $oldlink . $get_name . "=" . $get_value;
}
$count_get++;
}
}
if ($count_get > 0) {
$oldlink = $oldlink . "&";
}
if ($_GET['sort'] == "1") {
if ($_GET['type'] == "desc") {
$link1 = "asc";
} else {
$link1 = "desc";
}
}
if ($_GET['sort'] == "2") {
if ($_GET['type'] == "desc") {
$link2 = "asc";
} else {
$link2 = "desc";
}
}
if ($_GET['sort'] == "3") {
if ($_GET['type'] == "desc") {
$link3 = "asc";
} else {
$link3 = "desc";
}
}
if ($link1 == "") { $link1 = "asc"; }
if ($link2 == "") { $link2 = "asc"; }
if ($link3 == "") { $link3 = "asc"; }
?>
<td class="colhead2" width="3%" align="center">Type</td>
<td class="colhead2" width="4%" align="right"><a href="nzbbrowse.php?<? print $oldlink; ?>sort=2&type=<? print $link2; ?>" alt="Sort by date added" title="Sort by date added">Added</a></td>
<td class="colhead2" align="center" colspan="8"><a href="nzbbrowse.php?<? print $oldlink; ?>sort=1&type=<? print $link1; ?>" alt="Sort by NZB name" title="Sort by NZB name">Details</a></td>
<td class="colhead2" align="right" width="4%">Groups</td>
<td class="colhead2" width="4%" align="right"><a href="nzbbrowse.php?<? print $oldlink; ?>sort=3&type=<? print $link3; ?>" alt="Sort by date posted to Usenet" title="Sort by date posted to Usenet">Age</a></td>
<? // Conditions for seeing download zip and nzb columns:
if (getNzbPermissions("zip") == 1 && $CURUSER["nzbstodaydl"] < getNzbPermissions("maxdlpday"))
print ("<td class=\"colhead2\" width=\"2%\" align=\"center\" style='padding: 1px'>Zip</td>\n");
if (getNzbPermissions("nzb") == 1 && $CURUSER["nzbstodaydl"] < getNzbPermissions("maxdlpday"))
print ("<td class=\"colhead2\" width=\"2%\" align=\"center\" style='padding: 1px'>NZB</td>\n");
print("</tr>\n");
while ($row = mysql_fetch_assoc($res)) {
if ($row["postdate"] != 0) {
$id = $row["id"];
print("<tr>\n");
print("<td class=\"row2\" rowspan=\"2\" align=\"center\" style='padding: 0px'>");
if (isset($row["cat_name"])) {
print("<a href=\"nzbbrowse.php?cat=" . $row["category"] . "\">");
if (isset($row["cat_pic"]) && $row["cat_pic"] != "")
print("<img border=\"0\" src=\"$pic_base_url" . $row["cat_pic"] . "\" alt=\"Show all in ".$row["cat_name"]."\" title=\"Show all in ".$row["cat_name"]."\" />");
else
print($row["cat_name"]);
print("</a>");
}
else
print("-");
print("</td>\n");
$addednix = strtotime($row["added"]);
$dayadded = date("Y-m-d", $addednix);
$datenow = time();
$today = date("Y-m-d", $datenow);
$dateadded = (strcmp($today, $dayadded)===0?"Today! ".(date("H:i:s", $addednix)):(date("Y-m-d H:i:s", $addednix)));
print("<td class=\"nzbdate\" rowspan=\"2\" align=\"right\"><nobr>" . str_replace(" ", "<br />", $dateadded) . "</nobr></td>\n");
$addtext = ($row["addtext"]!=""?" [".$row["addtext"]."]":"");
// 'NEW' tag:
$newtag = (sql_timestamp_to_unix_timestamp($row["added"]) >= $last_nzbrowse?"<img alt=\"NZB added since your last visit\" title=\"NZB added since your last visit\" src='pic/newgrey.gif' /> ":"");
$dispname = nzb_name_encode($row["name"]);
print("<td class=\"nzbdtltop\" colspan=\"7\" align=\"left\"><a href=\"nzbdetails.php?");
print("id=$id");
print("&hit=1");
print("\" class=\"nzbtitle\" alt=\"View details for this NZB\" title=\"View details for this NZB\">$dispname</a>$addtext</td>\n");
print("<td class=\"nzbdtltop\" align=\"right\">$newtag</td>\n");
// Unserialise groups
$groups = unserialize($row['groups']);
if (is_array($groups)) {
$grp = "";
foreach ($groups as $key=>$val) {
$grp .= "<a href=\"nzbbrowse.php?grpsearch=".safe($val)."\" class=\"nzbgrp\" alt=\"Show all from ".safe($val)."\" title=\"Show all from ".safe($val)."\">".safe(clean_ng_name($val))."</a><br />";
}
} else {
$grp = "<a href=\"nzbbrowse.php?grpsearch=".safe($groups)."\" class=\"nzbgrp\" alt=\"Show all from ".safe($groups)."\" title=\"Show all from ".safe($groups)."\">".safe(clean_ng_name($groups))."</a><br />";
}
print("<td class=\"nzbgrp\" rowspan=\"2\" align=\"right\" valign=\"bottom\">" . $grp . "</td>\n");
// format Usenet posting date:
$datenix = $row["postdate"];
// $daypost = date("Y-m-d", $datenix);
// $datepost = (strcmp($today, $daypost)===0?"Today! ".(date("H:i:s", $datenix)):(date("Y-m-d H:i:s", $datenix)));
$datepost = show_age($datenix); // Shows age rather than date posted
print("<td class=\"nzbdate\" rowspan=\"2\" align=\"right\" valign=\"bottom\" alt=\"Age on Usenet in Days\" title=\"Age on Usenet in Days\">$datepost D</td>\n");
if (getNzbPermissions("zip") == 1 && $CURUSER["nzbstodaydl"] < getNzbPermissions("maxdlpday"))
print("<td class=\"row2\" rowspan=\"2\" align=\"center\"><a href=\"nzbdownload.php/$id/" . rawurlencode($row["name"]) . ".nzbdlzip\"><img border=\"0\" src=\"".$pic_base_url."zip.gif\" alt=\"Download Zip (".mksize($row["size"]).")\" title=\"Download Zip (".mksize($row["size"]).")\" /></a></td>\n");
if (getNzbPermissions("nzb") == 1 && $CURUSER["nzbstodaydl"] < getNzbPermissions("maxdlpday"))
print("<td class=\"row2\" rowspan=\"2\" align=\"center\"><a href=\"nzbdownload.php/$id/" . rawurlencode($row["name"]) . ".nzbdlnzb\"><img border=\"0\" src=\"".$pic_base_url."xml.gif\" alt=\"Download NZB (".mksize($row["size"]).")\" title=\"Download NZB (".mksize($row["size"]).")\" /></a></td>\n");
print("</tr><tr>");
if (isset($row["url"])) {
$oIMDB = new IMDB($row["url"]);
if ($oIMDB -> isReady) {
$imdbrate = $oIMDB -> getRating();
$poster = $oIMDB -> getPoster();
}
}
$imdb = '<a href="'.$row["url"].'">IMDB</a>';
$bob = '<img src="/pic/imdb.png" onmouseover="this.src='/pic/imdb.png'" onmouseout="this.src='/pic/imdb.png'">';
print("<td class=\"nzbdtlbot\" alt=\"IMDB's user rating\" title=\"IMDB's user rating\" width=\"4%\"><img src='/pic/imdb.png' alt='IMDB'> $imdbrate $imdb</td>\n");
$format = ($row["format"]!="na"?"<img src=\"".$pic_base_url."sml_".$row["format"].".gif\" alt=\"".$row["format"]."\" />":" ");
print("<td class=\"nzbdtlbot\" width=\"2%\">$format</td>\n");
$genre = ($row["genre"]!=""?"Genre: ".$row["genre"]:" ");
print("<td class=\"nzbdtlbot\" width=\"5%\">$genre</td>\n");
// print("<td class=\"nzbdtlbot\" width=\"5%\" alt=\"Total filesize\" title=\"Total size of articles\" align=\"right\">" . mksize($row["size"]) . "</td>\n"); // shown in tooltip on dl images instead
print("<td class=\"nzbdtlbot\" align=\"right\" width=\"4%\"><b><a href=\"nzbdetails.php?id=$id&hit=1&filelist=1\" alt=\"Show filelist\" title=\"Show filelist\" class=\"nzblink\">" . $row["numfiles"] . "</a></b> Files</td>\n");
print("<td class=\"nzbdtlbot\" align=\"right\" alt=\"Total number of downloads\" title=\"Total number of downloads\" width=\"4%\">" . $row["hits"] . " Grabs</td>\n");
if (!$row["comments"])
print("<td class=\"nzbdtlbot\" align=\"right\" width=\"4%\" alt=\"No comments yet\" title=\"No comments yet\">0 Cmts</td>\n");
else
print("<td class=\"nzbdtlbot\" align=\"right\" width=\"4%\"><b><a href=\"nzbdetails.php?id=$id&hit=1&tocomm=1\" class=\"nzblink\" alt=\"Show comments\" title=\"Show comments\">" . $row["comments"] . "</a></b> Cmts</td>\n");
print("<td class=\"nzbdtlbot\" align=\"right\" width=\"4%\">Upper:</td>\n");
// --- Show uploader as normal - comment out if using anonymous mod
print("<td class=\"nzbdtlbot\" align=\"right\" width=\"6%\">" . (isset($row["username"]) ? ("<a href=userdetails.php?id=" . $row["owner"] . " class=\"nzblink\"><b>" . safe($row["username"]) . "</b></a>") : "<i>(unknown)</i>") . "</td>\n");
/* USE ABOVE ^^^ OR BELOW vvv DEPENDING ON WHETHER YOU HAVE THE ANONYMOUS UPLOADER MOD */
/* // --- Anonymous uploader - comment out if not using anonymous mod
$addnam = $row['advertisename'];
$uprow = ("<i>Anon.</i>");
if (get_user_class() >= UC_MODERATOR) {
print("<td class=\"nzbdtlbot\" align=\"right\" width=\"6%\">" . (isset($row["username"]) ? ("<a href=userdetails.php?id=" . $row["owner"] . " class=\"nzblink\"><b>" . safe($row["username"]) . "</b></a>") : "<i>(unknown)</i>") . "</td>\n");
} elseif ($addnam == "yes") {
print("<td class=\"nzbdtlbot\" align=\"right\" width=\"6%\">" . (isset($row["username"]) ? ("<a href=userdetails.php?id=" . $row["owner"] . " class=\"nzblink\"><b>" . safe($row["username"]) . "</b></a>") : "<i>(unknown)</i>") . "</td>\n");
} else {
print("<td class=\"nzbdtlbot\" align=\"right\" width=\"6%\" alt=\"Uploader is anonymous\" title=\"Uploader is anonymous\">".$uprow."</td>\n");
} */
print("</tr>\n");
}
}
print("</table></div>\n");
return $row;
}
loggedinorreturn();
$cats = nzbgenrelist();
$searchstr = unesc($_GET["search"]);
$cleansearchstr = searchfield($searchstr);
if (empty($cleansearchstr))
unset($cleansearchstr);
$grpsearch = unesc($_GET["grpsearch"]);
$cleangrpsearch = searchfield($grpsearch);
if (empty($cleangrpsearch))
unset($cleangrpsearch);
if ($_GET['sort'] && $_GET['type']) {
$column = '';
$ascdesc = '';
switch($_GET['sort']) {
case '1': $column = "name"; break;
case '2': $column = "added"; break;
case '3': $column = "postdate"; break;
default: $column = "id"; break;
}
switch($_GET['type']) {
case 'asc': $ascdesc = "ASC"; break;
case 'desc': $ascdesc = "DESC"; break;
default: $ascdesc = "DESC"; break;
}
$orderby = "ORDER BY nzbs." . $column . " " . $ascdesc;
$pagerlink = "sort=" . $_GET['sort'] . "&type=" . $_GET['type'] . "&";
} else {
$orderby = "ORDER BY nzbs.id DESC";
$pagerlink = "";
}
$addparam = "";
$wherea = array();
$wherecatina = array();
$category = (int)$_GET["cat"];
$all = $_GET["all"];
if (!$all)
if ($category)
{
if (!is_valid_id($category))
stderr("Error", "Invalid category ID.");
$wherecatina[] = $category;
$addparam .= "cat=$category&";
}
else
{
$all = True;
foreach ($cats as $cat)
{
$all &= $_GET["c".$cat['id']];
if ($_GET["c".$cat['id']])
{
$wherecatina[] = $cat['id'];
$addparam .= "c".$cat['id']."=1&";
}
}
}
if ($all)
{
$wherecatina = array();
$addparam = "";
}
if (count($wherecatina) > 1)
$wherecatin = implode(",",$wherecatina);
elseif (count($wherecatina) == 1)
$wherea[] = "category = $wherecatina[0]";
$wherebase = $wherea;
$searchwhere = $_GET["searchwhere"];
if (isset($cleansearchstr))
{
if ($searchwhere == "both") {
$wherea[] = "MATCH (nzbs.name, nzbs.search_text, nzbs.ori_descr) AGAINST (" . sqlesc($searchstr) . ")";
$addparam .= "search=" . urlencode($searchstr) . "&searchwhere=both&";
}
if ($searchwhere == "desc") {
$wherea[] = "MATCH (nzbs.ori_descr) AGAINST (" . sqlesc($searchstr) . ")";
$addparam .= "search=" . urlencode($searchstr) . "&searchwhere=desc&";
}
if ($searchwhere == "title") {
$wherea[] = "MATCH (nzbs.name) AGAINST (" . sqlesc($searchstr) . ")";
$addparam .= "search=" . urlencode($searchstr) . "&searchwhere=title&";
}
}
if (isset($cleangrpsearch))
{
$wherea[] = "groups LIKE '%" . sqlwildcardesc($grpsearch) . "%'";
$addparam .= "grpsearch=" . urlencode($grpsearch) . "&";
}
// for retention:
$retent = nzbretention();
if ($retent)
$wherea[] = "postdate > $retent";
$where = implode(" AND ", $wherea);
if ($wherecatin)
$where .= ($where ? " AND " : "") . "category IN(" . $wherecatin . ")";
if ($where != "")
$where = "WHERE $where";
$res = mysql_query("SELECT COUNT(*) FROM nzbs $where") or die(mysql_error());
$row = mysql_fetch_array($res);
$count = $row[0];
if (!$count && isset($cleansearchstr)) {
$wherea = $wherebase;
$searcha = explode(" ", $cleansearchstr);
$sc = 0;
foreach ($searcha as $searchss) {
if (strlen($searchss) <= 1)
continue;
$sc++;
if ($sc > 5)
break;
$ssa = array();
if (($searchwhere == "both") || ($searchwhere == "desc")) {
foreach (array("nzbs.name", "nzbs.search_text", "nzbs.ori_descr") as $sss)
$ssa[] = "$sss LIKE '%" . sqlwildcardesc($searchss) . "%'";
} elseif ($searchwhere == "title") {
foreach (array("nzbs.name") as $sss)
$ssa[] = "$sss LIKE '%" . sqlwildcardesc($searchss) . "%'";
}
$wherea[] = "(" . implode(" OR ", $ssa) . ")";
}
if ($sc) {
$where = implode(" AND ", $wherea);
if ($where != "")
$where = "WHERE $where";
$res = mysql_query("SELECT COUNT(*) FROM nzbs $where");
$row = mysql_fetch_array($res);
$count = $row[0];
}
}
$nzbsperpage = $CURUSER["nzbsperpage"];
if (!$nzbsperpage)
$nzbsperpage = 100; // Change to whatever default you want
if ($count)
{
if ($addparam != "") {
if ($pagerlink != "") {
if ($addparam{strlen($addparam)-1} != ";") { // & = &
$addparam = $addparam . "&" . $pagerlink;
} else {
$addparam = $addparam . $pagerlink;
}
}
} else {
$addparam = $pagerlink;
}
list($pagertop, $pagerbottom, $limit) = pager($nzbsperpage, $count, "nzbbrowse.php?" . $addparam);
$query = "SELECT nzbs.id, nzbs.category, nzbs.name, nzbs.hits, nzbs.size, nzbs.added, nzbs.comments, nzbs.numfiles, nzbs.filename, nzbs.owner, nzbs.groups, nzbs.format, nzbs.imdbrating, nzbs.genre, nzbs.addtext, nzbs.autoimdb, nzbs.url, nzbs.postdate, IF(nzbs.nfo <> '', 1, 0) as nfoav," .
"nzbcategories.name AS cat_name, nzbcategories.image AS cat_pic, users.username FROM nzbs LEFT JOIN nzbcategories ON category = nzbcategories.id LEFT JOIN users ON nzbs.owner = users.id $where $orderby $limit";
/* $query = "SELECT nzbs.id, nzbs.category, nzbs.name, nzbs.hits, nzbs.size, nzbs.added, nzbs.comments, nzbs.numfiles, nzbs.filename, nzbs.owner, nzbs.groups, nzbs.format, nzbs.imdbrating, nzbs.genre, nzbs.addtext, nzbs.autoimdb, nzbs.url, nzbs.postdate, IF(nzbs.nfo <> '', 1, 0) as nfoav," .
"nzbcategories.name AS cat_name, nzbcategories.image AS cat_pic, users.username, users.advertisename FROM nzbs LEFT JOIN nzbcategories ON category = nzbcategories.id LEFT JOIN users ON nzbs.owner = users.id $where $orderby $limit"; // USE THIS QUERY IF ANONYMOUS UPLOADER MOD PRESENT */
$res = mysql_query($query) or die(mysql_error());
}
else
unset($res);
if (isset($cleansearchstr))
stdhead("NZB Search results for \"$searchstr\"");
else
stdhead("NZB's");
?>
<STYLE TYPE="text/css" MEDIA=screen>
a.catlink:link, a.catlink:visited{
text-decoration: none;
font-size: 7pt;
}
a.catlink:hover {
color: #444444;
font-size: 7pt;
}
</STYLE>
<form method="get" action="nzbbrowse.php">
<table class="bottom">
<tr>
<td class="bottom">
<table class="bottom">
<tr>
<?
$i = 0;
foreach ($cats as $cat)
{
$catsperrow = 7;
print(($i && $i % $catsperrow == 0) ? "</tr><tr>" : "");
print("<td class=\"bottom\" style=\"padding-bottom: 2px;padding-left: 7px\"><input name=\"c$cat[id]\" alt=\"Select multiple categories\" title=\"Select multiple categories\" type=\"checkbox\" " . (in_array($cat['id'],$wherecatina) ? "checked=\"checked\" " : "") . "value=\"1\" /><br /><a class=\"catlink\" href=\"nzbbrowse.php?cat=".$cat["id"]."\" alt=\"Show all in this category\" title=\"Show all in this category\">" . safe($cat['name']) . "</a></td>\n");
$i++;
}
$alllink = "<div align=\"left\">(<a href=\"nzbbrowse.php?all=1\" alt=\"Show all categories\" title=\"Show all categories\"><b>Show all</b></a>)</div>";
$ncats = count($cats);
$nrows = ceil($ncats/$catsperrow);
$lastrowcols = $ncats % $catsperrow;
if ($lastrowcols != 0)
{
if ($catsperrow - $lastrowcols != 1)
{
print("<td class=\"bottom\" rowspan=\"" . ($catsperrow - $lastrowcols - 1) . "\"> </td>");
}
print("<td class=\"bottom\" style=\"padding-left: 5px\">$alllink</td>\n");
}
?>
</tr>
</table>
</td>
<td class="bottom">
<table class="main">
<tr>
<td class="bottom" style="padding: 1px;padding-left: 10px">
<select name="incldead">
<option value="0">active</option>
</select>
</td>
<?
if ($ncats % $catsperrow == 0)
print("<td class=\"bottom\" style=\"padding-left: 15px\" rowspan=\"$nrows\" valign=\"center\" align=\"right\">$alllink</td>\n");
?>
</tr>
<tr>
<td class="bottom" style="padding: 1px;padding-left: 10px">
<div align="center">
<input type="submit" class="codebuttons" style="width:80px;height:25px;" alt="Show all selected categories" title="Show all selected categories" value="Go!" />
</div>
</td>
</tr>
</table>
</td>
</tr>
</table>
</form>
<!-- Search -->
<p>
<table width="750" class="main" border="0" cellspacing="0" cellpadding="0"><tr><td class="embedded">
<form method="get" action="nzbbrowse.php">
<p align="center">
Search
<select name="searchwhere">
<option value="title">titles</option>
<option value="desc"<?=($searchwhere=="desc"?" selected=\"selected\"":"")?>>descriptions</option>
<option value="both"<?=($searchwhere=="both"?" selected=\"selected\"":"")?>>both</option>
</select>
for
<input type="text" name="search" size="40" value="<?= safe($searchstr) ?>" />
in
<select name="cat">
<option value="0">(all types)</option>
<?
$cats = nzbgenrelist();
$catdropdown = "";
foreach ($cats as $cat) {
$catdropdown .= "<option value=\"" . $cat["id"] . "\"";
if ($cat["id"] == $_GET["cat"])
$catdropdown .= " selected=\"selected\"";
$catdropdown .= ">" . safe($cat["name"]) . "</option>\n";
}
?>
<?= $catdropdown ?>
</select>
<br /><br />
<input type="submit" class="codebuttons" style="width:80px;height:25px;" value="Search!" />
</p>
</form>
</td></tr></table>
<!-- End Search -->
<?
if (isset($cleansearchstr))
print("<h2>Search results for \"" . safe($searchstr) . "\"</h2>\n");
if ($count) {
print($pagertop);
nzbtable($res);
print($pagerbottom);
}
else {
if (isset($cleansearchstr)) {
print("<h2>Nothing found!</h2>\n");
print("<p>Try again with a refined search string.</p>\n");
}
else {
print("<h2>Nothing here!</h2>\n");
print("<p>Sorry pal :(</p>\n");
}
}
mysql_query("UPDATE users SET last_nzbrowse=".gmtime()." where id=".$CURUSER['id']);
stdfoot();
?>