$res = sql_query("SELECT " . ($use_poll_mod ? 't.pollid, ' : '') . "t.locked, t.subject, t.sticky, t.userid AS t_userid, t.forumid, t.numratings, t.ratingsum, f.name AS forum_name, f.minclassread, f.minclasswrite, f.minclasscreate, (SELECT COUNT(id)FROM posts WHERE topicid = t.id) AS p_count " . "FROM topics AS t " . "LEFT JOIN forums AS f ON f.id = t.forumid " . "WHERE t.id = " . sqlesc($topicid)) or sqlerr(__FILE__, __LINE__);
$arr = mysql_fetch_assoc($res) or stderr("Error", "Topic not found");
mysql_free_result($res);
$use_poll_mod ? $pollid = (int) $arr["pollid"] : null;
$t_userid = (int) $arr['t_userid'];
$locked = $arr['locked'] == 'yes' ? true : false;
$subject = $arr['subject'];
$sticky = $arr['sticky'] == "yes" ? true : false;
$forumid = (int) $arr['forumid'];
$forum = $arr["forum_name"];
$postcount = (int) $arr['p_count'];
$rating = '';
if ($arr["numratings"] != 0) {
$rating = ROUND($arr["ratingsum"] / $arr["numratings"], 1);
}
$rpic = ratingpic($rating);
if ($CURUSER["class"] < $arr["minclassread"]) {
stderr("Error", "You are not permitted to view this topic.");
}
// ------ Update hits column
sql_query("UPDATE topics SET views = views + 1 WHERE id={$topicid}") or sqlerr(__FILE__, __LINE__);
// ------ Make page menu
$pagemenu1 = "<p align='center'>";
$perpage = $postsperpage;
$pages = ceil($postcount / $perpage);
if ($page[0] == "p") {
$findpost = substr($page, 1);
$res = sql_query("SELECT id FROM posts WHERE topicid={$topicid} ORDER BY added") or sqlerr(__FILE__, __LINE__);
$i = 1;
while ($arr = mysql_fetch_row($res)) {
if ($arr[0] == $findpost) {
$s = "";
$s .= "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\"><tr><td valign=\"top\" class=\"embedded\">";
if (!isset($row["rating"])) {
if ($INSTALLER09['minvotes'] > 1) {
$s .= "none yet (needs at least {$INSTALLER09['minvotes']} votes and has got ";
if ($row["numratings"]) {
$s .= "only " . $row["numratings"];
} else {
$s .= "none";
}
$s .= ")";
} else {
$s .= "No votes yet";
}
} else {
$rpic = ratingpic($row["rating"]);
if (!isset($rpic)) {
$s .= "invalid?";
} else {
$s .= "{$rpic} (" . $row["rating"] . " out of 5 with " . $row["numratings"] . " vote(s) total)";
}
}
$s .= "\n";
$s .= "</td><td class=\"embedded\">{$spacer}</td><td valign=\"top\" class=\"embedded\">";
$ratings = array(5 => "Kewl!", 4 => "Pretty good", 3 => "Decent", 2 => "Pretty bad", 1 => "Sucks!");
if (!$owned || $moderator) {
if (!empty($row['numratings'])) {
$xres = sql_query("SELECT rating, added FROM ratings WHERE torrent = {$id} AND user = "******"id"]);
$xrow = mysql_fetch_assoc($xres);
}
if (!empty($xrow)) {
function torrenttable($res)
{
global $site_config, $CURUSER, $THEME, $LANGUAGE;
//Define globals
if ($site_config["MEMBERSONLY_WAIT"] && $site_config["MEMBERSONLY"] && in_array($CURUSER["class"], explode(",", $site_config["WAIT_CLASS"]))) {
$gigs = $CURUSER["uploaded"] / (1024 * 1024 * 1024);
$ratio = $CURUSER["downloaded"] > 0 ? $CURUSER["uploaded"] / $CURUSER["downloaded"] : 0;
if ($ratio < 0 || $gigs < 0) {
$wait = $site_config["WAITA"];
} elseif ($ratio < $site_config["RATIOA"] || $gigs < $site_config["GIGSA"]) {
$wait = $site_config["WAITA"];
} elseif ($ratio < $site_config["RATIOB"] || $gigs < $site_config["GIGSB"]) {
$wait = $site_config["WAITB"];
} elseif ($ratio < $site_config["RATIOC"] || $gigs < $site_config["GIGSC"]) {
$wait = $site_config["WAITC"];
} elseif ($ratio < $site_config["RATIOD"] || $gigs < $site_config["GIGSD"]) {
$wait = $site_config["WAITD"];
} else {
$wait = 0;
}
}
// Columns
$cols = explode(",", $site_config["torrenttable_columns"]);
$cols = array_map("strtolower", $cols);
$cols = array_map("trim", $cols);
$colspan = count($cols);
// End
// Expanding Area
$expandrows = array();
if (!empty($site_config["torrenttable_expand"])) {
$expandrows = explode(",", $site_config["torrenttable_expand"]);
$expandrows = array_map("strtolower", $expandrows);
$expandrows = array_map("trim", $expandrows);
}
// End
echo '<table align="center" class="ttable_headinner" width="100%"><thead><tr class="ttable_head">';
foreach ($cols as $col) {
switch ($col) {
case 'category':
echo "<th>" . T_("TYPE") . "</th>";
break;
case 'name':
echo "<th>" . T_("NAME") . "</th>";
break;
case 'dl':
echo "<th>" . T_("DL") . "</th>";
break;
case 'uploader':
echo "<th>" . T_("UPLOADER") . "</th>";
break;
case 'comments':
echo "<th>" . T_("COMM") . "</th>";
break;
case 'nfo':
echo "<th>" . T_("NFO") . "</th>";
break;
case 'size':
echo "<th>" . T_("SIZE") . "</th>";
break;
case 'completed':
echo "<th>" . T_("C") . "</th>";
break;
case 'seeders':
echo "<th>" . T_("S") . "</th>";
break;
case 'leechers':
echo "<th>" . T_("L") . "</th>";
break;
case 'health':
echo "<th>" . T_("HEALTH") . "</th>";
break;
case 'external':
if ($site_config["ALLOWEXTERNAL"]) {
echo "<th>" . T_("L/E") . "</th>";
}
break;
case 'added':
echo "<th>" . T_("ADDED") . "</th>";
break;
case 'speed':
echo "<th>" . T_("SPEED") . "</th>";
break;
case 'wait':
if ($wait) {
echo "<th>" . T_("WAIT") . "</th>";
}
break;
case 'rating':
echo "<th>" . T_("RATINGS") . "</th>";
break;
}
}
if ($wait && !in_array("wait", $cols)) {
echo "<th>" . T_("WAIT") . "</th>";
}
echo "</tr></thead>";
while ($row = mysql_fetch_assoc($res)) {
$id = $row["id"];
print "<tr class='t-row'>\n";
$x = 1;
foreach ($cols as $col) {
switch ($col) {
case 'category':
print "<td class='ttable_col{$x}' align='center' valign='middle'>";
if (!empty($row["cat_name"])) {
print "<a href=\"torrents.php?cat=" . $row["category"] . "\">";
if (!empty($row["cat_pic"]) && $row["cat_pic"] != "") {
print "<img border=\"0\"src=\"" . $site_config['SITEURL'] . "/images/categories/" . $row["cat_pic"] . "\" alt=\"" . $row["cat_name"] . "\" />";
} else {
print $row["cat_parent"] . ": " . $row["cat_name"];
}
print "</a>";
} else {
print "-";
}
print "</td>\n";
break;
case 'name':
$char1 = 35;
//cut name length
$smallname = htmlspecialchars(CutName($row["name"], $char1));
$dispname = "<b>" . $smallname . "</b>";
$last_access = $CURUSER["last_browse"];
$time_now = gmtime();
if ($last_access > $time_now || !is_numeric($last_access)) {
$last_access = $time_now;
}
if (sql_timestamp_to_unix_timestamp($row["added"]) >= $last_access) {
$dispname .= "<b><font color='#ff0000'> - (" . T_("NEW") . "!)</font></b>";
}
if ($row["freeleech"] == 1) {
$dispname .= " <img src='images/free.gif' border='0' alt='' />";
}
print "<td class='ttable_col{$x}' nowrap='nowrap'>" . (count($expandrows) ? "<a href=\"javascript: klappe_torrent('t" . $row['id'] . "')\"><img border=\"0\" src=\"" . $site_config["SITEURL"] . "/images/plus.gif\" id=\"pict" . $row['id'] . "\" alt=\"Show/Hide\" class=\"showthecross\" /></a>" : "") . " <a title=\"" . $row["name"] . "\" href=\"torrents-details.php?id={$id}&hit=1\">{$dispname}</a></td>";
break;
case 'dl':
print "<td class='ttable_col{$x}' align='center'><a href=\"download.php?id={$id}&name=" . rawurlencode($row["filename"]) . "\"><img src='" . $site_config['SITEURL'] . "/images/icon_download.gif' border='0' alt=\"Download .torrent\" /></a></td>";
break;
case 'uploader':
echo "<td class='ttable_col{$x}' align='center'>";
if (($row["anon"] == "yes" || $row["privacy"] == "strong") && $CURUSER["id"] != $row["owner"] && $CURUSER["edit_torrents"] != "yes") {
echo "Anonymous";
} elseif ($row["username"]) {
echo "<a href='account-details.php?id={$row['owner']}'>{$row['username']}</a>";
} else {
echo "Unknown";
}
echo "</td>";
break;
case 'comments':
print "<td class='ttable_col{$x}' align='center'><font size='1' face='verdana'><a href='comments.php?type=torrent&id={$id}'>" . number_format($row["comments"]) . "</a></font></td>\n";
break;
case 'nfo':
if ($row["nfo"] == "yes") {
print "<td class='ttable_col{$x}' align='center'><a href='nfo-view.php?id={$row['id']}'><img src='" . $site_config['SITEURL'] . "/images/icon_nfo.gif' border='0' alt='View NFO' /></a></td>";
} else {
print "<td class='ttable_col{$x}' align='center'>-</td>";
}
break;
case 'size':
print "<td class='ttable_col{$x}' align='center'>" . mksize($row["size"]) . "</td>\n";
break;
case 'completed':
print "<td class='ttable_col{$x}' align='center'><font color='orange'><b>" . number_format($row["times_completed"]) . "</b></font></td>";
break;
case 'seeders':
print "<td class='ttable_col{$x}' align='center'><font color='green'><b>" . number_format($row["seeders"]) . "</b></font></td>\n";
break;
case 'leechers':
print "<td class='ttable_col{$x}' align='center'><font color='#ff0000'><b>" . number_format($row["leechers"]) . "</b></font></td>\n";
break;
case 'health':
print "<td class='ttable_col{$x}' align='center'><img src='" . $site_config["SITEURL"] . "/images/health/health_" . health($row["leechers"], $row["seeders"]) . ".gif' alt='' /></td>\n";
break;
case 'external':
if ($site_config["ALLOWEXTERNAL"]) {
if ($row["external"] == 'yes') {
print "<td class='ttable_col{$x}' align='center'>" . T_("E") . "</td>\n";
} else {
print "<td class='ttable_col{$x}' align='center'>" . T_("L") . "</td>\n";
}
}
break;
case 'added':
print "<td class='ttable_col{$x}' align='center'>" . date("d-m-Y H:i:s", utc_to_tz_time($row['added'])) . "</td>";
break;
case 'speed':
if ($row["external"] != "yes" && $row["leechers"] >= 1) {
$speedQ = SQL_Query_exec("SELECT (SUM(downloaded)) / (UNIX_TIMESTAMP('" . get_date_time() . "') - UNIX_TIMESTAMP(started)) AS totalspeed FROM peers WHERE seeder = 'no' AND torrent = '{$id}' ORDER BY started ASC");
$a = mysql_fetch_assoc($speedQ);
$totalspeed = mksize($a["totalspeed"]) . "/s";
} else {
$totalspeed = "--";
}
print "<td class='ttable_col{$x}' align='center'>{$totalspeed}</td>";
break;
case 'wait':
if ($wait) {
$elapsed = floor((gmtime() - strtotime($row["added"])) / 3600);
if ($elapsed < $wait && $row["external"] != "yes") {
$color = dechex(floor(127 * ($wait - $elapsed) / 48 + 128) * 65536);
print "<td class='ttable_col{$x}' align='center'><a href=\"faq.php#section46\"><font color=\"{$color}\">" . number_format($wait - $elapsed) . " h</font></a></td>\n";
} else {
print "<td class='ttable_col{$x}' align='center'>--</td>\n";
}
}
break;
case 'rating':
if (!$row["rating"]) {
$rating = "--";
} else {
$rating = "<a title='{$row['rating']}/5'>" . ratingpic($row["rating"]) . "</a>";
}
//$rating = ratingpic($row["rating"]);
//$srating .= "$rpic (" . $row["rating"] . " out of 5) " . $row["numratings"] . " users have rated this torrent";
print "<td class='ttable_col{$x}' align='center'>{$rating}</td>";
break;
}
if ($x == 2) {
$x--;
} else {
$x++;
}
}
//Wait Time Check
if ($wait && !in_array("wait", $cols)) {
$elapsed = floor((gmtime() - strtotime($row["added"])) / 3600);
if ($elapsed < $wait && $row["external"] != "yes") {
$color = dechex(floor(127 * ($wait - $elapsed) / 48 + 128) * 65536);
print "<td class='ttable_col{$x}' align='center'><a href=\"faq.php\"><font color=\"{$color}\">" . number_format($wait - $elapsed) . " h</font></a></td>\n";
} else {
print "<td class='ttable_col{$x}' align='center'>--</td>\n";
}
$colspan++;
if ($x == 2) {
$x--;
} else {
$x++;
}
}
print "</tr>\n";
//Expanding area
if (count($expandrows)) {
print "<tr class='t-row'><td class='ttable_col{$x}' colspan='{$colspan}'><div id=\"kt" . $row['id'] . "\" style=\"margin-left: 2px; display: none;\">";
print "<table width='100%' border='0' cellspacing='0' cellpadding='0'>";
foreach ($expandrows as $expandrow) {
switch ($expandrow) {
case 'size':
print "<tr><td><b>" . T_("SIZE") . "</b>: " . mksize($row['size']) . "</td></tr>";
break;
case 'speed':
if ($row["external"] != "yes" && $row["leechers"] >= 1) {
$speedQ = SQL_Query_exec("SELECT (SUM(downloaded)) / (UNIX_TIMESTAMP('" . get_date_time() . "') - UNIX_TIMESTAMP(started)) AS totalspeed FROM peers WHERE seeder = 'no' AND torrent = '{$id}' ORDER BY started ASC");
$a = mysql_fetch_assoc($speedQ);
$totalspeed = mksize($a["totalspeed"]) . "/s";
print "<tr><td><b>" . T_("SPEED") . ":</b> {$totalspeed}</td></tr>";
}
break;
case 'added':
print "<tr><td><b>" . T_("ADDED") . ":</b> " . date("d-m-Y \\a\\t H:i:s", utc_to_tz_time($row['added'])) . "</td></tr>";
break;
case 'tracker':
if ($row["external"] == "yes") {
print "<tr><td><b>" . T_("TRACKER") . ":</b> " . htmlspecialchars($row["announce"]) . "</td></tr>";
}
break;
case 'completed':
print "<tr><td><b>" . T_("COMPLETED") . "</b>: " . number_format($row['times_completed']) . "</td></tr>";
break;
}
}
print "</table></div></td></tr>\n";
}
//End Expanding Area
}
print "</table><br />\n";
}
function torrenttable($res, $variant = "index")
{
global $INSTALLER09, $CURUSER, $lang, $free, $mc1;
$htmlout = '';
require_once INCL_DIR . 'getpre.php';
/** ALL FREE/DOUBLE **/
foreach ($free as $fl) {
switch ($fl['modifier']) {
case 1:
$free_display = '[Free]';
break;
case 2:
$free_display = '[Double]';
break;
case 3:
$free_display = '[Free and Double]';
break;
}
$all_free_tag = $fl['modifier'] != 0 && ($fl['expires'] > TIME_NOW || $fl['expires'] == 1) ? ' <a class="info" href="#">
<b>' . $free_display . '</b>
<span>' . ($fl['expires'] != 1 ? '
Expires: ' . get_date($fl['expires'], 'DATE') . '<br />
(' . mkprettytime($fl['expires'] - time()) . ' to go)</span></a><br />' : 'Unlimited</span></a><br />') : '';
}
$prevdate = "";
$count_get = 0;
$oldlink = $char = $description = $type = $sort = $row = '';
foreach ($_GET as $get_name => $get_value) {
$get_name = strip_tags(str_replace(array("\"", "'"), array("", ""), $get_name));
$get_value = strip_tags(str_replace(array("\"", "'"), array("", ""), $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 . "&";
}
$links = array('link1', 'link2', 'link3', 'link4', 'link5', 'link6', 'link7', 'link8', 'link9');
$i = 1;
foreach ($links as $link) {
if (isset($_GET['sort']) && $_GET['sort'] == $i) {
${$link} = isset($_GET['type']) && $_GET['type'] == 'desc' ? 'asc' : 'desc';
} else {
${$link} = 'desc';
}
$i++;
}
$htmlout .= "<table border='1' cellspacing='0' cellpadding='5'>\r\n <tr>\r\n <td class='colhead' align='center'>{$lang["torrenttable_type"]}</td>\r\n <td class='colhead' align='left'><a href='{$_SERVER["PHP_SELF"]}?{$oldlink}sort=1&type={$link1}'>{$lang["torrenttable_name"]}</a></td>\r\n <td class='colhead' align='left'>{$lang["torrenttable_subtitles"]}</td>\r\n <td class='colhead' align='left'><img src='{$INSTALLER09['pic_base_url']}zip.gif' border='0' alt='Download' title='Download' /></td>";
$htmlout .= $variant == 'index' ? "<td class='colhead' align='center'><a href='{$INSTALLER09['baseurl']}/bookmarks.php'><img src='{$INSTALLER09['pic_base_url']}bookmark.gif' border='0' alt='Bookmark' title='Go To My Bookmarks' /></a></td>" : '';
if ($variant == "mytorrents") {
$htmlout .= "<td class='colhead' align='center'>{$lang["torrenttable_edit"]}</td>\n";
$htmlout .= "<td class='colhead' align='center'>{$lang["torrenttable_visible"]}</td>\n";
}
$htmlout .= "<td class='colhead' align='right'><a href='{$_SERVER["PHP_SELF"]}?{$oldlink}sort=2&type={$link2}'>{$lang["torrenttable_files"]}</a></td>\r\n <td class='colhead' align='right'><a href='{$_SERVER["PHP_SELF"]}?{$oldlink}sort=3&type={$link3}'>{$lang["torrenttable_comments"]}</a></td>\r\n <td class='colhead' align='center'><a href='{$_SERVER["PHP_SELF"]}?{$oldlink}sort=4&type={$link4}'>{$lang["torrenttable_added"]}</a></td>\r\n <td class='colhead' align='center'><a href='{$_SERVER["PHP_SELF"]}?{$oldlink}sort=5&type={$link5}'>{$lang["torrenttable_size"]}</a></td>\r\n <td class='colhead' align='center'><a href='{$_SERVER["PHP_SELF"]}?{$oldlink}sort=6&type={$link6}'>{$lang["torrenttable_snatched"]}</a></td>\r\n <td class='colhead' align='right'><a href='{$_SERVER["PHP_SELF"]}?{$oldlink}sort=7&type={$link7}'>{$lang["torrenttable_seeders"]}</a></td>\r\n <td class='colhead' align='right'><a href='{$_SERVER["PHP_SELF"]}?{$oldlink}sort=8&type={$link8}'>{$lang["torrenttable_leechers"]}</a></td>";
if ($variant == 'index') {
$htmlout .= "<td class='colhead' align='center'><a href='{$_SERVER["PHP_SELF"]}?{$oldlink}sort=9&type={$link9}'>{$lang["torrenttable_uppedby"]}</a></td>\n";
}
$htmlout .= "</tr>\n";
while ($row = mysql_fetch_assoc($res)) {
$id = $row["id"];
if ($row["sticky"] == "yes") {
$htmlout .= "<tr class='highlight'>\n";
} else {
$htmlout .= "<tr class='browse'>\n";
}
$htmlout .= "<td align='center' style='padding: 0px'>";
if (isset($row["cat_name"])) {
$htmlout .= "<a href='browse.php?cat={$row['category']}'>";
if (isset($row["cat_pic"]) && $row["cat_pic"] != "") {
$htmlout .= "<img border='0' src='{$INSTALLER09['pic_base_url']}caticons/{$row['cat_pic']}' alt='{$row['cat_name']}' />";
} else {
$htmlout .= $row["cat_name"];
}
$htmlout .= "</a>";
} else {
$htmlout .= "-";
}
$htmlout .= "</td>\n";
$dispname = htmlspecialchars($row["name"]);
$checked = !empty($row['checked_by']) && $CURUSER['class'] >= UC_USER ? " <img src='{$INSTALLER09['pic_base_url']}mod.gif' width='15' border='0' alt='Checked - by " . htmlspecialchars($row['checked_by']) . "' title='Checked - by " . htmlspecialchars($row['checked_by']) . "' />" : "";
$poster = empty($row["poster"]) ? "<img src=\\'{$INSTALLER09['pic_base_url']}noposter.png\\' width=\\'150\\' height=\\'220\\' border=\\'0\\' alt=\\'Poster\\' title=\\'poster\\' />" : "<img src=\\'" . htmlspecialchars($row['poster']) . "\\' width=\\'150\\' height=\\'220\\' border=\\'0\\' alt=\\'Poster\\' title=\\'poster\\' />";
$rating = empty($row["rating"]) ? "No votes yet" : "" . ratingpic($row["rating"]) . "";
if ($row["descr"]) {
$descr = str_replace("\"", """, readMore($row["descr"], 350, "details.php?id=" . $row["id"] . "&hit=1"));
}
$htmlout .= "<td align='left'><a href='details.php?";
if ($variant == "mytorrents") {
$htmlout .= "returnto=" . urlencode($_SERVER["REQUEST_URI"]) . "&";
}
$htmlout .= "id={$id}";
if ($variant == "index") {
$htmlout .= "&hit=1";
}
$pre = !empty($row["pretime"]) ? " Uploaded: " . get_pretime($row["pretime"]) . " after pre." : "No pretime was found";
$newgenre = !empty($row["newgenre"]) ? "<i>(" . htmlspecialchars($row["newgenre"]) . ")</i>" : "";
$sticky = $row['sticky'] == "yes" ? "<img src='{$INSTALLER09['pic_base_url']}sticky.gif' style='border:none' alt='Sticky' title='Sticky !' />" : "";
$nuked = $row["nuked"] == "yes" ? "<img src='{$INSTALLER09['pic_base_url']}nuked.gif' style='border:none' alt='Nuked' align='right' title='Reason :" . htmlspecialchars($row["nukereason"]) . "' />" : "";
$release_group = $row['release_group'] == "scene" ? " <img src='{$INSTALLER09['pic_base_url']}scene.gif' title='Scene' alt='Scene' style='border:none' />" : ($row['release_group'] == "p2p" ? " <img src='{$INSTALLER09['pic_base_url']}p2p.gif' title='P2P' alt='P2P' />" : "");
$viponly = $row["vip"] == "1" ? "<img src='{$INSTALLER09['pic_base_url']}/star.png' border='0' alt='Vip Torrent' title='Vip Torrent' />" : "";
/** FREE Torrent **/
$free_tag = $row['free'] != 0 ? ' <a class="info" href="#"><b>[FREE]</b> <span>' . ($row['free'] > 1 ? 'Expires: ' . get_date($row['free'], 'DATE') . '<br />(' . mkprettytime($row['free'] - TIME_NOW) . ' to go)<br />' : 'Unlimited<br />') . '</span></a>' : $all_free_tag;
/** Freeslot Slot in Use **/
$isdlfree = $row['tid'] == $id && $row['uid'] == $CURUSER['id'] && $row['freeslot'] != 0 ? '<a class="info" href="#"><img src="' . $INSTALLER09['baseurl'] . '/pic/freedownload.gif" alt="" /><span>Freeleech slot in use<br />' . ($row['freeslot'] != 0 ? $row['freeslot'] > 1 ? 'Expires: ' . get_date($row['freeslot'], 'DATE') . '<br />(' . mkprettytime($row['freeslot'] - TIME_NOW) . ' to go)<br />' : 'Unlimited<br />' : '') . '</span></a>' : '';
/** Double Upload Slot in Use **/
$isdouble = $row['tid'] == $id && $row['uid'] == $CURUSER['id'] && $row['doubleup'] != 0 ? ' <a class="info" href="#"><img src="' . $INSTALLER09['baseurl'] . '/pic/doubleseed.gif" alt="" /><span>Double Upload slot in use<br />' . ($row['doubleup'] != 0 ? $row['doubleup'] > 1 ? 'Expires: ' . get_date($row['doubleup'], 'DATE') . '<br />(' . mkprettytime($row['doubleup'] - TIME_NOW) . ' to go)<br />' : 'Unlimited<br />' : '') . '</span></a>' : '';
$htmlout .= "' onmouseover=\"Tip('<b>" . CutName($dispname, 80) . "</b><br /><b>Added: " . get_date($row['added'], 'DATE', 0, 1) . "</b><br /><b>Size: " . mksize(htmlspecialchars($row["size"])) . "</b><br /><b>Seeders: " . htmlspecialchars($row["seeders"]) . "</b><br /><b>Leechers: " . htmlspecialchars($row["leechers"]) . "</b><br /><b>Rating: " . htmlspecialchars($rating) . "</b><br />{$poster}');\" onmouseout=\"UnTip();\"><b>" . CutName($dispname, 45) . "</b></a> <a href=\"javascript:klappe_descr('descr" . $row["id"] . "');\" ><img src=\"/pic/plus.gif\" border=\"0\" alt=\"Show torrent info in this page\" title=\"Show torrent info in this page\" /></a> {$viponly} {$release_group} {$sticky} " . ($row['added'] >= $CURUSER['last_browse'] ? " <img src='{$INSTALLER09['pic_base_url']}newb.png' border='0' alt='New !' title='New !' />" : "") . " {$checked} {$free_tag} {$nuked}<br />\n" . $isdlfree . $isdouble . " {$newgenre} {$pre}</td>\n";
$movie_cat = array("3", "5", "6", "10", "11");
//add here your movie category
$htmlout .= "<td align=\"center\" nowrap=\"nowrap\" >\n";
if (in_array($row["category"], $movie_cat) && !empty($row["subs"])) {
$subs_array = explode(",", $row["subs"]);
require_once CACHE_DIR . 'subs.php';
foreach ($subs_array as $k => $sid) {
foreach ($subs as $sub) {
if ($sub["id"] == $sid) {
$htmlout .= "<img border=\"0\" width=\"16px\" style=\"padding:3px;\"src=\"" . $sub["pic"] . "\" alt=\"" . $sub["name"] . "\" title=\"" . $sub["name"] . "\" />";
}
}
}
} else {
$htmlout .= "---";
}
$htmlout .= "</td>";
if ($variant == "mytorrents") {
$htmlout .= "<td align='center'><a href=\"download.php?torrent=" . $id . "\"><img src='" . $INSTALLER09['pic_base_url'] . "zip.gif' border='0' alt='Download This Torrent!' title='Download This Torrent!' /></a></td>\n";
}
if ($variant == "mytorrents") {
$htmlout .= "<td align='center'><a href='edit.php?returnto=" . urlencode($_SERVER["REQUEST_URI"]) . "&id={$row['id']}'>" . $lang["torrenttable_edit"] . "</a></td>\n";
}
$htmlout .= $variant == "index" ? "<td align='center'><a href=\"download.php?torrent=" . $id . "\"><img src='" . $INSTALLER09['pic_base_url'] . "zip.gif' border='0' alt='Download This Torrent!' title='Download This Torrent!' /></a></td>" : "";
if ($variant == "mytorrents") {
$htmlout .= "<td align='right'>";
if ($row["visible"] == "no") {
$htmlout .= "<b>" . $lang["torrenttable_not_visible"] . "</b>";
} else {
$htmlout .= "" . $lang["torrenttable_visible"] . "";
}
$htmlout .= "</td>\n";
}
$bookmarked = !isset($row["bookmark"]) ? "<a href='bookmark.php?torrent=" . $id . "&action=add'><img src='" . $INSTALLER09['pic_base_url'] . "bookmark.gif' border='0' alt='Bookmark it!' title='Bookmark it!' /></a>" : "<a href='bookmark.php?torrent=" . $id . "&action=delete'><img src='" . $INSTALLER09['pic_base_url'] . "plus2.gif' border='0' alt='Delete Bookmark!' title='Delete Bookmark!' /></a>";
if ($variant == "index") {
$htmlout .= "<td align='right'>{$bookmarked}</td>";
}
if ($row["type"] == "single") {
$htmlout .= "<td align='right'>{$row["numfiles"]}</td>\n";
} else {
if ($variant == "index") {
$htmlout .= "<td align='right'><b><a href='filelist.php?id={$id}'>" . $row["numfiles"] . "</a></b></td>\n";
} else {
$htmlout .= "<td align='right'><b><a href='filelist.php?id={$id}'>" . $row["numfiles"] . "</a></b></td>\n";
}
}
if (!$row["comments"]) {
$htmlout .= "<td align='right'>{$row["comments"]}</td>\n";
} else {
if ($variant == "index") {
$htmlout .= "<td align='right'><b><a href='details.php?id={$id}&hit=1&tocomm=1'>" . $row["comments"] . "</a></b></td>\n";
} else {
$htmlout .= "<td align='right'><b><a href='details.php?id={$id}&page=0#startcomments'>" . $row["comments"] . "</a></b></td>\n";
}
}
$htmlout .= "<td align='center'><span style='white-space: nowrap;'>" . str_replace(",", "<br />", get_date($row['added'], '')) . "</span></td>\n";
$htmlout .= "<td align='center'>" . str_replace(" ", "<br />", mksize($row["size"])) . "</td>\n";
if ($row["times_completed"] != 1) {
$_s = "" . $lang["torrenttable_time_plural"] . "";
} else {
$_s = "" . $lang["torrenttable_time_singular"] . "";
}
$htmlout .= "<td align='center'><a href='snatches.php?id={$id}'>" . number_format($row["times_completed"]) . "<br />{$_s}</a></td>\n";
if ($row["seeders"]) {
if ($variant == "index") {
if ($row["leechers"]) {
$ratio = $row["seeders"] / $row["leechers"];
} else {
$ratio = 1;
}
$htmlout .= "<td align='right'><b><a href='peerlist.php?id={$id}#seeders'><font color='" . get_slr_color($ratio) . "'>{$row["seeders"]}</font></a></b></td>\n";
} else {
$htmlout .= "<td align='right'><b><a class='" . linkcolor($row["seeders"]) . "' href='peerlist.php?id={$id}#seeders'>{$row["seeders"]}</a></b></td>\n";
}
} else {
$htmlout .= "<td align='right'><span class='" . linkcolor($row["seeders"]) . "'>" . $row["seeders"] . "</span></td>\n";
}
if ($row["leechers"]) {
if ($variant == "index") {
$htmlout .= "<td align='right'><b><a href='peerlist.php?id={$id}#leechers'>" . number_format($row["leechers"]) . "</a></b></td>\n";
} else {
$htmlout .= "<td align='right'><b><a class='" . linkcolor($row["leechers"]) . "' href='peerlist.php?id={$id}#leechers'>{$row["leechers"]}</a></b></td>\n";
}
} else {
$htmlout .= "<td align='right'>0</td>\n";
}
if ($variant == "index") {
if ($row["anonymous"] == "yes") {
$htmlout .= "<td align='center'><i>Anonymous</i></td>\n";
} else {
$htmlout .= "<td align='center'>" . (isset($row["username"]) ? "<a href='{$INSTALLER09['baseurl']}/userdetails.php?id=" . $row["owner"] . "'><b>{$row["username"]}</b></a>" : "<i>(" . $lang["torrenttable_unknown_uploader"] . ")</i>") . "</td>\n";
}
}
$htmlout .= "</tr>\n";
$htmlout .= "<tr id=\"kdescr{$row["id"]}\" style=\"display:none;\"><td width=\"100%\" colspan=\"13\">{$descr}</td></tr>\n";
}
$htmlout .= "</table>\n";
return $htmlout;
}
function torrenttable($res, $variant = "index") {
global $pic_base_url, $CURUSER, $BASEURL;
if ($CURUSER['class'] <= UC_POWER_USER && $CURUSER['donor'] === 'no') {
$gigs = $CURUSER['uploaded'] / (1024*1024*1024);
$ratio = (($CURUSER['downloaded'] > '2147483648') ? ($CURUSER['uploaded'] / $CURUSER['downloaded']) : '1');
$space = date('YmdHis');
if($space < '20060804180000' || $space > '20060807235959') {
if ($ratio < '0.75' && $ratio >= '0.5')
$wait = '12';
elseif ($ratio < '0.5')
$wait = '24';
else
$wait = '0';
} else
$wait = '0';
$t1 = str_replace(array(' ',':','-','\''),'',sqlesc(get_date_time(gmtime() - 1209600)));
$t2 = str_replace(array(' ',':','-'),'',$CURUSER['added']);
if($CURUSER['donor'] === 'yes' || $t2 >= $t1)
$wait = '0';
if($CURUSER['warned'] == 'yes')
$wait = '24';
}
if(isset($_GET['sort'])) {
$order = $_GET['d'];
if($order == 'ASC')
$sort = '&d=DESC';
elseif($order == 'DESC')
$sort = '&d=ASC';
} else
$sort = '&d=DESC';
if($_GET['search'])
$search = '&search='.$_GET['search'];
else
$search = '';
$verifystring = verifystring($_GET['cat'],'num');
if($verifystring === TRUE)
$catsort = '&cat='.$_GET['cat'];
$s_catz = $_REQUEST['s_catz'];
$verifystring = verifystring($_GET['incldead'],'num');
if($verifystring === TRUE)
$incldead = '&incldead='.$_GET['incldead'];
$extrapar = $catsort.$search.$sort.$s_catz.$incldead;
if($_POST['new_renew'] === '1') {
$lasttorrent = mysql_result(mysql_query('SELECT id FROM torrents ORDER BY id DESC LIMIT 1'),0);
mysql_query('UPDATE users SET lasttorrent='.$lasttorrent.' WHERE id='.$CURUSER['id']);
$_SESSION['lasttorrent'] = $lasttorrent;
$header = 'Refresh: url='.$BASEURL.$_SERVER['REQUEST_URI'];
header($header);
}
if($CURUSER['birta_nytt'] === '1') {
echo '
<form action="'.$_SERVER['SCRIPT_NAME'].'?'.$_SERVER['QUERY_STRING'].'" method="post">
<input type="hidden" name="new_renew" value="1">
<input type="submit" value="Endursetja \'ný torrent\' merkinguna">
</form><br />';
}
?>
<table border="1" cellspacing="0" cellpadding="5">
<tr>
<td class="colhead" align="center"><a style="text-decoration:none;color:white;" href="browse.php?sort=type<?php
echo $extrapar;
?>
">#</a></td>
<td class="colhead" align="left"><a style="text-decoration:none;color:white;" href="browse.php?sort=name<?php
echo $extrapar;
?>
">Nafn</a></td>
<?
if ($wait > '0')
echo '<td class="colhead" align="center">Bið</td>'."\n";
if ($variant == 'mytorrents') {
echo '<td class="colhead" align="center">Breyta</td>'."\n";
echo '<td class="colhead" align="center">Sýnilegt</td>'."\n";
}
?>
<td class="colhead" align="right"><a style="text-decoration:none;color:white;" href="browse.php?sort=numfiles<?php
echo $extrapar;
?>
">Skrár</a></td>
<td class="colhead" align="right"><a style="text-decoration:none;color:white;" href="browse.php?sort=comments<?php
echo $extrapar;
?>
">Umsagnir</a></td>
<td class="colhead" align="center"><a style="text-decoration:none;color:white;" href="browse.php?sort=ratingsum<?php
echo $extrapar;
?>
">Einkunn</a></td>
<td class="colhead" align="center"><a style="text-decoration:none;color:white;" href="browse.php?sort=added<?php
echo $extrapar;
?>
">Bætt inn</a></td>
<td class="colhead" align="center"><a style="text-decoration:none;color:white;" href="browse.php?sort=added<?php
echo $extrapar;
?>
">TTL</a></td>
<td class="colhead" align="center">Samtals hraði</td>
<td class="colhead" align="center"><a style="text-decoration:none;color:white;" href="browse.php?sort=size<?php
echo $extrapar;
?>
">Stærð</a></td>
<td class="colhead" align="center"><a style="text-decoration: none; color: white;" href="browse.php?sort=times_completed<?php
echo $extrapar;
?>
">Sótt</a></td>
<td class="colhead" align="right"><a style="text-decoration:none;color:white;" href="browse.php?sort=seeders<?php
echo $extrapar;
?>
">Að deila</a></td>
<td class="colhead" align="right"><a style="text-decoration:none;color:white;" href="browse.php?sort=leechers<?php
echo $extrapar;
?>
">Að sækja</a></td>
<?
if ($variant == "index")
echo '<td class="colhead" align="center">Sent inn af</td>'."\n";
echo '</tr>'."\n";
while ($row = mysql_fetch_assoc($res)) {
$id = $row['id'];
if($row['reviewed'] > '0' && $CURUSER['class'] >= UC_MODERATOR)
echo '<tr style="background-color:DarkGray">'."\n";
else
echo '<tr>'."\n";
echo '<td align="center" style="padding:0px">';
if (isset($row['cat_name'])) {
echo '<a href="browse.php?c'.$row['category'].'=1">';
if (!empty($row['cat_pic']))
echo '<img border="0" src="'.$pic_base_url.$row['cat_pic'].'" alt="'. $row['cat_name'].'" />';
else
echo $row['cat_name'];
echo '</a>';
} else
echo '-';
echo '</td>'."\n";
$dispname = htmlspecialchars($row['name']);
echo '<td align="left"><a href="details.php?';
if ($variant == 'mytorrents')
echo 'returnto='. urlencode($_SERVER['REQUEST_URI']).'&';
echo 'id='.$id;
if ($variant == 'index')
echo '&hit=1';
if(strlen($dispname) > '65')
$dispname = substr($dispname, '0','60') . '...';
echo '"><b>'.$dispname.'</b></a>'."\n";
if($id > $_SESSION['lasttorrent'] && $CURUSER['birta_nytt'] === '1')
echo '<img src="/pic/new.png" /> ';
if($row['nuked'] == 'yes')
echo '<b>[SPRENGT:</b>'.$row['nukedr'].'<b>]</b> <img src="ismod/nuked.gif" border="0" valign="bottom" alt="'.$row['nukedr'].'">'."\n";
if($row['scene'] == 'y')
echo '<b>[Scene útgáfa]:</b>'."\n";
if ($variant == "index" && $wait == 0)
echo '<a href="download.php/'.$id.'/'.rawurlencode($row['filename']).'"><img src="ismod/nidur.gif" border="0" alt="Sækja"><img src="ismod/nidur.gif" border="0" alt="Sækja"></a>'."\n";
if ($wait > '0') {
$elapsed = floor((gmtime() - strtotime($row["added"])) / 3600);
if ($elapsed < $wait) {
$color = dechex(floor(127*($wait - $elapsed)/48 + 128)*65536);
echo '<td align="center"><nobr><a href="/faq.php#dl8"><font color="'.$color.'">'.number_format($wait - $elapsed).' klst</font></a></nobr></td>'."\n";
} else {
if ($variant == 'index')
echo '<a href="download.php/'.$id.'/'.rawurlencode($row['filename']). '"><img src="ismod/nidur.gif" border="0" alt="Sækja"><img src="ismod/nidur.gif" border="0" alt="Sækja" /></a>'."\n";
echo '<td align="center"><nobr>Engin</nobr></td>'."\n";
}
}
if ($variant == 'mytorrents')
echo '<td align="center"><a href="edit.php?returnto='.urlencode($_SERVER['REQUEST_URI']).'&id='.$row['id'].'">Breyta</a>'."\n";
echo '</td>'."\n";
if ($variant == 'mytorrents') {
echo '<td align="right">';
if ($row['visible'] == 'no')
echo '<b>Nei</b>';
else
echo 'Já';
echo '</td>'."\n";
}
if ($row['type'] == 'single')
echo '<td align="right">'.$row['numfiles'].'</td>'."\n";
else {
if ($variant == 'index')
echo '<td align="right"><b><a href="details.php?id='.$id.'&hit=1&filelist=1">'.$row['numfiles'].'</a></b></td>'."\n";
else
echo '<td align="right"><b><a href="details.php?id='.$id.'&filelist=1#filelist">'.$row['numfiles'].'</a></b></td>'."\n";
}
if ($row['comments'] === '0')
echo '<td align="right">'.$row['comments'].'</td>'."\n";
else {
if ($variant == 'index')
echo '<td align="right"><b><a href="details.php?id='.$id.'&hit=1&tocomm=1">'.$row['comments'].'</a></b></td>'."\n";
else
echo '<td align="right"><b><a href="details.php?id='.$id.'&page=0#startcomments">'.$row['comments'].'</a></b></td>'."\n";
}
echo '<td align="center">';
if (!isset($row['rating']))
echo '---';
else {
$rating = round($row['rating'] * 2) / 2;
$rating = ratingpic($row['rating']);
if (!isset($rating))
echo '---';
else
echo $rating;
}
echo '</td>'."\n";
echo '<td align="center"><nobr>'.str_replace(' ', '<br />', $row['added']).'</nobr></td>'."\n";
$ttl = (28*24) - floor((gmtime() - sql_timestamp_to_unix_timestamp($row["added"])) / 3600);
if ($ttl == '1')
$ttl .= '<br />klst';
else
$ttl .= '<br />klst';
echo '<td align="center">'.$ttl.'</td>'."\n";
// Totalspeed mod
$resSpeed = mysql_query('SELECT seeders,leechers FROM torrents WHERE id='.$id.' AND visible=\'yes\' ORDER BY added DESC LIMIT 15') or sqlerr(__FILE__, __LINE__);
if ($rowTmp = mysql_fetch_row($resSpeed))
list($seedersTmp,$leechersTmp) = $rowTmp;
if ($seedersTmp >= '1' && $leechersTmp >= '1'){
$speedQ = mysql_query('SELECT (t.size * t.times_completed + SUM(p.downloaded)) / (UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(added)) AS totalspeed FROM torrents AS t LEFT JOIN peers AS p ON t.id = p.torrent WHERE p.seeder = \'no\' AND p.torrent = \''.$id.'\' GROUP BY t.id ORDER BY added ASC LIMIT 15') or sqlerr(__FILE__, __LINE__);
$a = mysql_fetch_assoc($speedQ);
$totalspeed = mksize($a['totalspeed']) . '/s';
}
echo '<td align="center">'.$totalspeed.'</td>'."\n";
echo '<td align="center">'.str_replace(' ', '<br />', mksize($row['size'])).'</td>'."\n";
$_s = '';
if ($row['times_completed'] != '1')
$_s = 's';
echo '<td align="center"><a href="viewsnatches.php?id='.$row[id].'">'.number_format($row['times_completed']).'<br />time'.$_s.'</a></td>'."\n";
if ($row["seeders"]) {
if ($variant == "index") {
if ($row["leechers"]) $ratio = $row["seeders"] / $row["leechers"]; else $ratio = 1;
print("<td align=right><b><a href=details.php?id=$id&hit=1&toseeders=1><font color=" .
get_slr_color($ratio) . ">" . $row["seeders"] . "</font></a></b></td>\n");
} else
echo '<td align="right"><b><a class="'.linkcolor($row['seeders']).'" href="details.php?id='.$id.'&dllist=1#seeders\">'.$row['seeders'].'</a></b></td>'."\n";
} else
echo '<td align="right"><span class="'.linkcolor($row['seeders']).'">'.$row['seeders'].'</span></td>'."\n";
if ($row["leechers"]) {
if ($variant == "index")
echo '<td align="right"><b><a href="details.php?id='.$id.'&hit=1&todlers=1">'.number_format($row['leechers']).($peerlink ? '</a>' : '').'</b></td>'."\n";
else
echo '<td align="right"><b><a class="'.linkcolor($row['leechers']).'" href="details.php?id='.$id.'&dllist=1#leechers">'.$row['leechers'].'</a></b></td>'."\n";
} else
echo '<td align="right">0</td>'."\n";
if ($variant == 'index') {
echo '<td align="center">';
if($row['anonymous'] === '1')
echo '<i>(Nafnleynd)</i>';
else
echo '<a href=userdetails.php?id='.$row['owner'].'><b>'.htmlspecialchars($row['username']).'</b></a>';
echo '</td>'."\n";
}
echo '</tr>'."\n";
}
echo '</table>'."\n";
return $rows;
}
<input type="hidden" id="ratingtid" value="{$id}" />
<div id="rating_selector">
\t<span class="rating star" title="{$tracker_lang['vote_1']}" data-value="1">
\t<span class="rating star" title="{$tracker_lang['vote_2']}" data-value="2">
\t<span class="rating star" title="{$tracker_lang['vote_3']}" data-value="3">
\t<span class="rating star" title="{$tracker_lang['vote_4']}" data-value="4">
\t<span class="rating star" title="{$tracker_lang['vote_5']}" data-value="5">
\t</span></span></span></span></span>
</div>
SELECTOR;
$is_voted = mysql_fetch_array(sql_query('SELECT rating FROM ratings WHERE torrent = ' . $id . ' AND user = '******'id']));
if (mysql_error()) {
sqlerr();
}
if ($is_voted) {
$stars .= ratingpic($row['rating']) . "(" . $row["rating"] . " " . $tracker_lang['from'] . " 5 " . $tracker_lang['with'] . " " . $row["numratings"] . " " . getWord($row["numratings"], array($tracker_lang['votes_1'], $tracker_lang['votes_2'], $tracker_lang['votes_3'])) . ")" . ' Ваша оценка <b>' . $is_voted['rating'] . '</b> - <b>' . $tracker_lang['vote_' . $is_voted['rating']] . '</b>';
} else {
$stars .= $rating_selector;
}
tr($tracker_lang['rating'], $stars, 1);
}
tr($tracker_lang['added'], $row["added"]);
tr($tracker_lang['views'], $row["views"]);
tr($tracker_lang['hits'], $row["hits"]);
tr($tracker_lang['snatched'], $row["times_completed"] . " " . $tracker_lang['times']);
$keepget = "";
$uprow = isset($row["username"]) ? "<a href=userdetails.php?id={$row["owner"]}>" . htmlspecialchars_uni($row["username"]) . "</a>" : "<i>{$tracker_lang['details_anonymous']}</i>";
/*
if ($owned)
$uprow .= " $spacer<$editlink><b>[{$tracker_lang['edit']}]</b></a>";
*/
