$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>"; */