Coraille |
16th December 2012 04:36 |
PHP Code:
<?php // // TorrentTrader v2.x // $LastChangedDate: 2011-05-03 19:09:32 +0300 (Tue, 03 May 2011) $ // $LastChangedBy: dj-howarth1 $ // // http://www.torrenttrader.org // // require_once("backend/functions.php"); require_once("backend/BDecode.php") ; require_once("backend/parse.php") ;//replace with parse later dbconn();
$torrent_dir = $site_config["torrent_dir"]; $nfo_dir = $site_config["nfo_dir"];
//check permissions if ($site_config["MEMBERSONLY"]){ loggedinonly();
if($CURUSER["view_torrents"]=="no") show_error_msg(T_("ERROR"), T_("NO_TORRENT_VIEW"), 1); }
//************ DO SOME "GET" STUFF BEFORE PAGE LAYOUT ***************
$id = (int) $_GET["id"]; $scrape = (int)$_GET["scrape"]; if (!is_valid_id($id)) show_error_msg("ERROR", T_("THATS_NOT_A_VALID_ID"), 1);
//GET ALL MYSQL VALUES FOR THIS TORRENT $res = mysql_query("SELECT torrents.anon, torrents.seeders, torrents.banned, torrents.leechers, torrents.info_hash, torrents.filename, torrents.nfo, torrents.last_action, torrents.numratings, torrents.name, torrents.owner, torrents.save_as, torrents.descr, torrents.visible, torrents.size, torrents.added, torrents.views, torrents.hits, torrents.times_completed, torrents.id, torrents.type, torrents.external, torrents.image1, torrents.image2, torrents.announce, torrents.numfiles, torrents.freeleech, torrents.nuked, IF(torrents.numratings < 2, NULL, ROUND(torrents.ratingsum / torrents.numratings, 1)) AS rating, torrents.numratings, categories.name AS cat_name, categories.image AS cat_pic, torrentlang.name AS lang_name, torrentlang.image AS lang_image, categories.parent_cat as cat_parent, users.username, users.privacy FROM torrents LEFT JOIN categories ON torrents.category = categories.id LEFT JOIN torrentlang ON torrents.torrentlang = torrentlang.id LEFT JOIN users ON torrents.owner = users.id WHERE torrents.id = $id") or die(mysql_error());
$row = mysql_fetch_array($res);
$moderator = $CURUSER["edit_torrents"] == "yes";
//DECIDE IF TORRENT EXISTS if (!$row || ($row["banned"] == "yes" && !$moderator)) show_error_msg(T_("ERROR"), T_("TORRENT_NOT_FOUND"), 1);
//torrent is availiable so do some stuff
if ($_GET["hit"]) { mysql_query("UPDATE torrents SET views = views + 1 WHERE id = $id"); header("Location: torrents-details.php?id=$id"); die; }
stdhead(T_("DETAILS_FOR_TORRENT")." \"" . $row["name"] . "\"");
if ($CURUSER["id"] == $row["owner"]) $owned = 1; else $owned = 0;
if ($CURUSER["edit_torrents"]=="yes") $owned = 1;
//take rating if ($_GET["takerating"] == 'yes'){ $rating = (int)$_POST['rating'];
if ($rating <= 0 || $rating > 5) show_error_msg(T_("RATING_ERROR"), T_("INVAILD_RATING"), 1);
$res = mysql_query("INSERT INTO ratings (torrent, user, rating, added) VALUES ($id, " . $CURUSER["id"] . ", $rating, '".get_date_time()."')");
if (!$res) { if (mysql_errno() == 1062) show_error_msg(T_("RATING_ERROR"), T_("YOU_ALREADY_RATED_TORRENT"), 1); else show_error_msg(T_("RATING_ERROR"), T_("A_UNKNOWN_ERROR_CONTACT_STAFF"), 1); }
mysql_query("UPDATE torrents SET numratings = numratings + 1, ratingsum = ratingsum + $rating WHERE id = $id"); show_error_msg(T_("RATING_ERROR"), T_("RATING_THANK")."<BR><BR><a href=torrents-details.php?id=$id>" .T_("BACK_TO_TORRENT"). "</a>"); }
//take comment add if ($_GET["takecomment"] == 'yes'){ loggedinonly(); $commentbody = $_POST['body']; if (!$commentbody) show_error_msg(T_("RATING_ERROR"), T_("YOU_DID_NOT_ENTER_ANYTHING"), 1);
mysql_query("UPDATE torrents SET comments = comments + 1 WHERE id = $id") or die(mysql_error());
mysql_query("INSERT INTO comments (user, torrent, added, text) VALUES (".$CURUSER["id"].", ".$id.", '" .get_date_time(). "', " . sqlesc($body).")") or die(mysql_error());
if (mysql_affected_rows() == 1) show_error_msg(T_("COMPLETED"), T_("COMMENT_ADDED"), 0); else show_error_msg(T_("ERROR"), T_("UNABLE_TO_ADD_COMMENT"), 0); }//end insert comment
//PM to uploader on comment add $msg = "one of Your Torrents $torrent has recieved a Comment by $CURUSER[username] Please check it /torrents-details.php?id=$id]HERE";
mysql_query("INSERT INTO `messages` (`sender`, `receiver`, `added`, `subject`, `msg`, `unread`, `location`) VALUES ('$CURUSER[username]', '".$row[owner]."', '".get_date_time()."', 'One of your torrents just recieved a comment. Please check !','$msg','yes','in')") or die(mysql_error());
//START OF PAGE LAYOUT HERE $char1 = 50; //cut length $shortname = CutName(htmlspecialchars($row["name"]), $char1);
begin_frame(T_("TORRENT_DETAILS_FOR"). " \"" . $shortname . "\"");
echo "<div align=right>[<a href=report.php?torrent=$id><B>" .T_("REPORT_TORRENT"). "</B></a>] "; if ($owned) echo "[<a href=torrents-edit.php?id=$row[id]><B>".T_("EDIT_TORRENT")."</B></a>]"; echo "</div>";
$previd = mysql_query("SELECT id, name FROM torrents WHERE id < $id ORDER BY id DESC LIMIT 1"); $prev = mysql_fetch_row($previd); $previd = $prev[0]; $prevname = htmlspecialchars($prev[1]);
$nextid = mysql_query("SELECT id, name FROM torrents WHERE id > $id ORDER BY id ASC LIMIT 1"); $next = mysql_fetch_row($nextid); $nextid = $next[0]; $nextname = htmlspecialchars($next[1]);
echo "<table border=0 width=100%><tr>"; if ($previd) echo "<td align=center><a href='torrents-details.php?id=$previd'>[Previous Torrent]<BR>$prevname</a></td>"; if ($nextid) echo "<td align=center><a href='torrents-details.php?id=$nextid'>[Next Torrent]<BR>$nextname</a></td>"; echo "</tr></table>";
echo "<center><h1>" . $shortname . "</h1></center>";
// Calculate local torrent speed test if ($row["leechers"] >= 1 && $row["seeders"] >= 1 && $row["external"]!='yes'){ $speedQ = mysql_query("SELECT (SUM(p.downloaded)) / (UNIX_TIMESTAMP('".get_date_time()."') - 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 die(mysql_error()); $a = mysql_fetch_assoc($speedQ); $totalspeed = mksize($a["totalspeed"]) . "/s"; }else{ $totalspeed = "".T_("NO_ACTIVITY").""; }
//download box echo "<CENTER><table border=0 width=98%><TR><TD><div id=downloadbox>"; if ($row["banned"] == "yes"){ print ("<CENTER><B>" .T_("DOWNLOAD"). ": </B>BANNED!</CENTER>"); }else{ print ("<table border=0 cellpadding=0 width=95%><tr><td align=center valign=middle width=54><a href=\"download.php?id=$id&name=" . rawurlencode($row["filename"]) . "\"><img src=\"".$site_config["SITEURL"]."/images/down.jpeg\" border=\"0\"></a></td>"); print ("<td valign=top><a href=\"download.php?id=$id&name=" . rawurlencode($row["filename"]) . "\">".T_("DOWNLOAD_TORRENT")."</a><BR>"); print ("<B>" .T_("HEALTH"). ": </b><img src=".$site_config["SITEURL"]."/images/health_".health($row["leechers"], $row["seeders"]).".gif><BR>"); print ("<B>" .T_("SEEDS"). ": </b><font color=green>" . $row["seeders"] . "</font><BR>"); print ("<B>".T_("LEECHERS").": </b><font color=red>" . $row["leechers"] . "</font><BR>");
if ($row["external"]!='yes'){ print ("<B>".T_("SPEED").": </b>" . $totalspeed . "<BR>"); }
print ("<b>".T_("COMPLETED").": </b>" . $row["times_completed"] . "</B> ");
if ($row["external"] != "yes" && $row["times_completed"] > 0) { echo("[<a href='torrents-completed.php?id=$id'>" .T_("WHOS_COMPLETED"). "</a>] "); if ($row["seeders"] <= 1) { echo("[<a href='torrents-reseed.php?id=$id'>" .T_("REQUEST_A_RE_SEED"). "</a>]"); } } echo "";
if ($row["external"]!='yes' && $row["freeleech"]=='1'){ print ("<B>".T_("FREE_LEECH").": </b><font color=red>".T_("FREE_LEECH_MSG")."</font><BR>"); }
if ($row["nuked"] == 'yes'){ print ("<B>Nuked: </B><font color=red><blink>Torrent NUKED!</blink></font><BR>"); }
print ("<B>".T_("LAST_CHECKED").": </b>" . date("d-m-Y H:i:s", utc_to_tz_time($row["last_action"])) . "<BR></td>");
if ($row["external"]=='yes'){
if ($scrape =='1'){ print("<td valign=top align=right><b>Tracked: </b>EXTERNAL<BR><BR>"); $seeders1 = $leechers1 = $downloaded1 = null;
$tres = mysql_query("SELECT url FROM announce WHERE torrent=$id"); while ($trow = mysql_fetch_array($tres)) { $ann = $trow["url"]; $tracker = explode("/", $ann); $path = array_pop($tracker); $oldpath = $path; $path = preg_replace("/^announce/", "scrape", $path); $tracker = implode("/", $tracker)."/".$path;
if ($oldpath == $path) { continue; // Scrape not supported, ignored }
// TPB's tracker is dead. Use openbittorrent instead if (preg_match("/thepiratebay.org/i", $tracker) || preg_match("/prq.to/", $tracker)) { $tracker = "http://tracker.openbittorrent.com/scrape"; }
$stats = torrent_scrape_url($tracker, $row["info_hash"]); if ($stats['seeds'] != -1) { $seeders1 += $stats['seeds']; $leechers1 += $stats['peers']; $downloaded1 += $stats['downloaded']; mysql_query("UPDATE `announce` SET `online` = 'yes', `seeders` = $stats[seeds], `leechers` = $stats[peers], `times_completed` = $stats[downloaded] WHERE `url` = ".sqlesc($ann)." AND `torrent` = $id"); } else { mysql_query("UPDATE `announce` SET `online` = 'no' WHERE `url` = ".sqlesc($ann)." AND `torrent` = $id");
} }
if ($seeders1 !== null){ //only update stats if data is received print ("<B>".T_("LIVE_STATS").": </b><BR>"); print ("Seeders: ".$seeders1."<BR>"); print ("Leechers: ".$leechers1."<BR>"); print ("".T_("COMPLETED").": ".$downloaded1."<BR>");
mysql_query("UPDATE torrents SET leechers='".$leechers1."', seeders='".$seeders1."',times_completed='".$downloaded1."',last_action= '".get_date_time()."',visible='yes' WHERE id='".$row['id']."'"); }else{ print ("<B>".T_("LIVE_STATS").": </b><BR>"); print ("<font color=red>Tracker Timeout<BR>Please retry later</font><BR>"); }
print ("<form action=torrents-details.php?id=$id&scrape=1 method=post><input type=\"submit\" name=\"submit\" value=\"Update Stats\"></td></form>"); }else{ print ("<td valign=top align=right><b>Tracked: </b>EXTERNAL<BR><BR><form action=torrents-details.php?id=$id&scrape=1 method=post><input type=\"submit\" name=\"submit\" value=\"Update Stats\"></td></form>"); } }
echo "</tr></table>"; } echo "</div></td></tr></table></CENTER><BR><BR>"; //end download box
// Thanx mod $torrentid = $_GET["id"]; $thanks_sql = mysql_query("SELECT * FROM thanks where torrentid=$torrentid"); $thanks_all = mysql_numrows($thanks_sql); if ($thanks_all) { while($rows_t = mysql_fetch_array($thanks_sql)) { $thanks_userid = $rows_t["userid"]; $user_sql = mysql_query("SELECT * FROM users where id=$thanks_userid"); $rows_a = mysql_fetch_array($user_sql); $username_t = $rows_a["username"]; $thanksby = $thanksby."<a href='userdetails.php?id=$thanks_userid'>$username_t</a>, "; } $t_userid = $CURUSER["id"]; $tsql = mysql_query("SELECT COUNT(*) FROM thanks where torrentid=$torrentid and userid=$t_userid"); $trows = mysql_fetch_array($tsql); $t_ab = $trows[0]; if ($t_ab == "0" && $CURUSER["id"] != $row["owner"]) { $thanksby = $thanksby." <form action=\"thanks.php\" method=\"post\"> <input type=\"submit\" name=\"submit\" value=\"Say Thanks!\"> <input type=\"hidden\" name=\"torrentid\" value=\"$torrentid\"> </form>"; } else { $thanksby = $thanksby." <form action=\"thanks.php\" method=\"post\"> <input type=\"submit\" name=\"submit\" value=\"Say Thanks!\" disabled> <input type=\"hidden\" name=\"torrentid\" value=\"$torrentid\"> </form>"; } } else { if ($CURUSER["id"] == $row["owner"]){ $thanksby = $thanksby." <form action=\"thanks.php\" method=\"post\"> <input type=\"submit\" name=\"submit\" value=\"Say Thanks!\" disabled> <input type=\"hidden\" name=\"torrentid\" value=\"$torrentid\"> </form>"; } else $thanksby = "No Thanks Yet <form action=\"thanks.php\" method=\"post\"> <input type=\"submit\" name=\"submit\" value=\"Say Thanks!\"> <input type=\"hidden\" name=\"torrentid\" value=\"$torrentid\"> </form> "; } print("<table><tr> <td valign=top><table border=0 width=100 cellspacing=0 cellpadding=0><tr><td class=alt5 align=center><b>Thanks by</b></td> </tr></table></td><td width=100%>" . $thanksby . "</td></tr></table>");
//Thanx mod end
echo "<FIELDSET class=search><LEGEND></a><b>Details</B></LEGEND>"; echo "<table cellpadding=3 border=0 width=95%>"; print("<tr><td align=left><b>".T_("NAME").":</b></td><td>" . $shortname . "</td></tr>\n"); print("<tr><td align=left colspan=2><b>" .T_("DESCRIPTION"). ":</b>" . format_comment($row['descr']) . "</td></tr>\n"); print("<tr><td align=left><b>" . TTYPE . ":</b></td><td><a href=\"torrents.php?cat=" . $row["category"] . "\"><img border=\"0\"src=\"" . $site_config['SITEURL'] . "/images/categories/" . $row["cat_pic"] . "\" alt=\"" . $row["cat_name"] . "\" /></td></tr>\n");
if (empty($row["lang_name"])) $row["lang_name"] = "Unknown/NA"; print("<tr><td align=left><b>" .T_("LANG"). ":</b></td><td>" . $row["lang_name"] . "\n");
if (isset($row["lang_image"]) && $row["lang_image"] != "") print(" <img border=\"0\"src=\"" . $site_config['SITEURL'] . "/images/languages/" . $row["lang_image"] . "\" alt=\"" . $row["lang_name"] . "\" />");
print("</td></tr>");
print("<tr><td align=left><b>" .T_("TOTAL_SIZE"). ":</b></td><td>" . mksize($row["size"]) . " </td></tr>\n"); print("<tr><td align=left><b>" .T_("INFO_HASH"). ":</b></td><td>" . $row["info_hash"] . "</td></tr>\n"); print(""); if ($row["anon"] == "yes" && !$owned) print("<tr><td align=left><b>" .T_("ADDED_BY"). ":</b></td><td>Anonymous</td></tr>"); elseif ($row["username"]) print("<tr><td align=left><b>" .T_("ADDED_BY"). ":</b></td><td><a href=account-details.php?id=" . $row["owner"] . ">" . $row["username"] . "</a></td></tr>"); else print("<tr><td align=left><b>" .T_("ADDED_BY"). ":</b></td><td>Unknown</td></tr>");
print("<tr><td align=left><b>" .T_("DATE_ADDED"). ":</b></td><td>" . date("d-m-Y H:i:s", utc_to_tz_time($row["added"])) . "</td></tr>\n"); print("<tr><td align=left><b>" .T_("VIEWS"). ":</b></td><td>" . $row["views"] . "</td></tr>\n"); print("<tr><td align=left><b>".T_("HITS").":</b></td><td>" . $row["hits"] . "</td></tr>\n"); echo "</table></FIELDSET><BR><BR>";
// $srating IS RATING VARIABLE $srating = ""; $srating .= "<table border=\"0\" cellspacing=\"1\" cellpadding=\"4\" width='95%' style=\"border: 2px solid #f8de8f;\"><tr><td style=\"background:#f8edcc;\" width=60><b>".T_("RATINGS").":</b></td><td style=\"background:#f8f1dd;\" valign=middle><NOBR>"; if (!isset($row["rating"])) { $srating .= "Not Yet Rated"; }else{ $rpic = ratingpic($row["rating"]); if (!isset($rpic)) $srating .= "invalid?"; else $srating .= "$rpic (" . $row["rating"] . " ".T_("OUT_OF")." 5) " . $row["numratings"] . " ".T_("USERS_HAVE_RATED").""; } $srating .= "\n"; if (!isset($CURUSER)) $srating .= "(<a href=\"account-login.php?returnto=" . urlencode($_SERVER["REQUEST_URI"]) . "&nowarn=1\">Log in</a> to rate it)"; else { $ratings = array( 5 => "".T_("COOL")."", 4 => "".T_("PRETTY_GOOD")."", 3 => "".T_("DECENT")."", 2 => "".T_("PRETTY_BAD")."", 1 => "".T_("SUCKS")."", ); //if (!$owned || $moderator) { $xres = mysql_query("SELECT rating, added FROM ratings WHERE torrent = $id AND user = " . $CURUSER["id"]); $xrow = mysql_fetch_array($xres); if ($xrow) $srating .= "<BR><i>(".T_("YOU_RATED")." \"" . $xrow["rating"] . " - " . $ratings[$xrow["rating"]] . "\")</i>"; else { $srating .= "<form style=display:inline; method=\"post\" action=\"torrents-details.php?id=$id&takerating=yes\"><input type=\"hidden\" name=\"id\" value=\"$id\" />\n"; $srating .= "<select name=\"rating\">\n"; $srating .= "<option value=\"0\">(".T_("ADD_RATING").")</option>\n"; foreach ($ratings as $k => $v) { $srating .= "<option value=\"$k\">$k - $v</option>\n"; } $srating .= "</select>\n"; $srating .= "<input type=\"submit\" value=\"".T_("VOTE")."\" />"; $srating .= "</form>\n"; } //} } $srating .= "</NOBR></td></tr></table>";
print("<CENTER>". $srating . "</CENTER>");// rating
//END DEFINE RATING VARIABLE
echo "<BR>";
if ($row["image1"] != "" OR $row["image2"] != "") { if ($row["image1"] != "") $img1 = "<IMG src=".$site_config["SITEURL"]."/uploads/images/$row[image1] width=150 border=0>"; if ($row["image2"] != "") $img2 = "<IMG src=".$site_config["SITEURL"]."/uploads/images/$row[image2] width=150 border=0>"; print("<CENTER>". $img1 . "  " . $img2."</CENTER><BR>"); }
if ($row["external"]=='yes'){ print ("<b>Tracker:</B><BR> ".$row['announce'].""); }
$tres = mysql_query("SELECT * FROM `announce` WHERE `torrent` = $id"); if (mysql_num_rows($tres) > 1){ echo "<B>".T_("THIS_TORRENT_HAS_BACKUP_TRACKERS")."</B>"; echo '<table cellpadding="1" cellspacing="2" class="ttable_headinner"><tr>'; echo '<td class="ttable_head">URL</td><td class="ttable_head">'.T_("SEEDERS").'</td><td class="ttable_head">'.T_("LEECHERS").'</td><td class="ttable_head">'.T_("COMPLETED").'</td></tr>'; $x = 1; while ($trow = mysql_fetch_array($tres)) { $colour = $trow["online"] == "yes" ? "green" : "red"; echo "<tr class=\"ttable_col$x\"><td><font color=\"$colour\"><b>".htmlspecialchars($trow['url'])."</b></font></td><td align=\"center\">".number_format($trow["seeders"])."</td><td align=\"center\">".number_format($trow["leechers"])."</td><td align=\"center\">".number_format($trow["times_completed"])."</td></tr>"; $x = $x == 1 ? 2 : 1; } echo '</table>'; }
echo "<BR><BR><b>".T_("FILE_LIST").":</B> <img src='images/plus.gif' id='pic1' onclick='klappe_torrent(1)'><div id='k1' style='display: none;'><table align=center cellpadding=0 cellspacing=0 class=table_table border=1 width=95%><TR><TD class=table_head align=left> ".T_("FILE")."</TD><TD width=50 class=table_head> ".T_("SIZE")."</td></tr>"; $fres = mysql_query("SELECT * FROM `files` WHERE `torrent` = $id"); if (mysql_num_rows($fres)) { while ($frow = mysql_fetch_array($fres)) { echo "<TR><td class=table_col1>".htmlspecialchars($frow['path'])."</td><TD class=table_col2>".mksize($frow['filesize'])."</td></tr>"; } }else{ echo "<TR><td class=table_col1>".htmlspecialchars($row["name"])."</td><TD class=table_col2>".mksize($row["size"])."</td></tr>"; } echo "</table></div>";
if ($row["external"]!='yes'){ echo "<BR><BR><B>".T_("PEERS_LIST").":</B><BR>"; $query = mysql_query("SELECT * FROM peers WHERE torrent = $id ORDER BY seeder DESC");
$result = mysql_num_rows($query); if($result == 0) { echo T_("NO_ACTIVE_PEERS")."\n"; }else{ ?> <table align=center cellpadding="3" cellspacing="0" class="table_table" width="95%" border="1"> <tr> <td class="table_head"><?php print(T_("PORT")); ?></td> <td class="table_head"><?php print(T_("UPLOADED")); ?></td> <td class="table_head"><?php print(T_("DOWNLOADED")); ?></td> <td class="table_head"><?php print(T_("RATIO")); ?></td> <td class="table_head"><?php print(T_("LEFT")); ?></td> <td class="table_head"><?php print(T_("FINISHED_SHORT"). "%"); ?></td> <td class="table_head"><?php print(T_("SEED")); ?></td> <td class="table_head"><?php print(T_("CONNECTED_SHORT")); ?></td> <td class="table_head"><?php print(T_("CLIENT")); ?></td> <td class="table_head"><?php print(T_("USER_SHORT")); ?></td> </tr>
<?php while($row1 = MYSQL_FETCH_ARRAY($query)) { if ($row1["downloaded"] > 0){ $ratio = $row1["uploaded"] / $row1["downloaded"]; $ratio = number_format($ratio, 3); }else{ $ratio = "---"; }
$percentcomp = sprintf("%.2f", 100 * (1 - ($row1["to_go"] / $row["size"])));
if ($site_config["MEMBERSONLY"]) { $res = mysql_query("SELECT id, username, privacy FROM users WHERE id=".$row1["userid"].""); $arr = MYSQL_FETCH_ARRAY($res); } $arr["username"]; if ($arr["privacy"] != "strong" || ($CURUSER["control_panel"] == "yes")) { print("<tr><td class=table_col2>".$row1["port"]."</td><td class=table_col1>".mksize($row1["uploaded"])."</td><td class=table_col2>".mksize($row1["downloaded"])."</td><td class=table_col1>".$ratio."</td><td class=table_col2>".mksize($row1["to_go"])."</td><td class=table_col1>".$percentcomp."%</td><td class=table_col2>$row1[seeder]</td><td class=table_col1>$row1[connectable]</td><td class=table_col2>".htmlspecialchars($row1[client])."</td><td class=table_col1><a href=account-details.php?id=$arr[id]>$arr[username]</a></td></tr>"); }else{ print("<tr><td class=table_col2>".$row1["port"]."</td><td class=table_col1>".mksize($row1["uploaded"])."</td><td class=table_col2>".mksize($row1["downloaded"])."</td><td class=table_col1>".$ratio."</td><td class=table_col2>".mksize($row1["to_go"])."</td><td class=table_col1>".$percentcomp."%</td><td class=table_col2>$row1[seeder]</td><td class=table_col1>$row1[connectable]</td><td class=table_col2>".htmlspecialchars($row1[client])."</td><td class=table_col1>Private</td></tr>"); }
} echo "</table>"; } }
echo "<BR><BR>";
//DISPLAY NFO BLOCK function my_nfo_translate($nfo){ $trans = array( "\x80" => "Ç", "\x81" => "ü", "\x82" => "é", "\x83" => "â", "\x84" => "ä", "\x85" => "à", "\x86" => "å", "\x87" => "ç", "\x88" => "ê", "\x89" => "ë", "\x8a" => "è", "\x8b" => "ï", "\x8c" => "î", "\x8d" => "ì", "\x8e" => "Ä", "\x8f" => "Å", "\x90" => "É", "\x91" => "æ", "\x92" => "Æ", "\x93" => "ô", "\x94" => "ö", "\x95" => "ò", "\x96" => "û", "\x97" => "ù", "\x98" => "ÿ", "\x99" => "Ö", "\x9a" => "Ü", "\x9b" => "¢", "\x9c" => "£", "\x9d" => "¥", "\x9e" => "₧", "\x9f" => "ƒ", "\xa0" => "á", "\xa1" => "í", "\xa2" => "ó", "\xa3" => "ú", "\xa4" => "ñ", "\xa5" => "Ñ", "\xa6" => "ª", "\xa7" => "º", "\xa8" => "¿", "\xa9" => "⌐", "\xaa" => "¬", "\xab" => "½", "\xac" => "¼", "\xad" => "¡", "\xae" => "«", "\xaf" => "»", "\xb0" => "░", "\xb1" => "▒", "\xb2" => "▓", "\xb3" => "│", "\xb4" => "┤", "\xb5" => "╡", "\xb6" => "╢", "\xb7" => "╖", "\xb8" => "╕", "\xb9" => "╣", "\xba" => "║", "\xbb" => "╗", "\xbc" => "╝", "\xbd" => "╜", "\xbe" => "╛", "\xbf" => "┐", "\xc0" => "└", "\xc1" => "┴", "\xc2" => "┬", "\xc3" => "├", "\xc4" => "─", "\xc5" => "┼", "\xc6" => "╞", "\xc7" => "╟", "\xc8" => "╚", "\xc9" => "╔", "\xca" => "╩", "\xcb" => "╦", "\xcc" => "╠", "\xcd" => "═", "\xce" => "╬", "\xcf" => "╧", "\xd0" => "╨", "\xd1" => "╤", "\xd2" => "╥", "\xd3" => "╙", "\xd4" => "╘", "\xd5" => "╒", "\xd6" => "╓", "\xd7" => "╫", "\xd8" => "╪", "\xd9" => "┘", "\xda" => "┌", "\xdb" => "█", "\xdc" => "▄", "\xdd" => "▌", "\xde" => "▐", "\xdf" => "▀", "\xe0" => "α", "\xe1" => "ß", "\xe2" => "Γ", "\xe3" => "π", "\xe4" => "Σ", "\xe5" => "σ", "\xe6" => "µ", "\xe7" => "τ", "\xe8" => "Φ", "\xe9" => "Θ", "\xea" => "Ω", "\xeb" => "δ", "\xec" => "∞", "\xed" => "φ", "\xee" => "ε", "\xef" => "∩", "\xf0" => "≡", "\xf1" => "±", "\xf2" => "≥", "\xf3" => "≤", "\xf4" => "⌠", "\xf5" => "⌡", "\xf6" => "÷", "\xf7" => "≈", "\xf8" => "°", "\xf9" => "∙", "\xfa" => "·", "\xfb" => "√", "\xfc" => "ⁿ", "\xfd" => "²", "\xfe" => "■", "\xff" => " ", ); $trans2 = array("\xe4" => "ä", "\xF6" => "ö", "\xFC" => "ü", "\xC4" => "Ä", "\xD6" => "Ö", "\xDC" => "Ü", "\xDF" => "ß"); $all_chars = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ"; $last_was_ascii = False; $tmp = ""; $nfo = $nfo . "\00"; for ($i = 0; $i < (strlen($nfo) - 1); $i++) { $char = $nfo[$i]; if (isset($trans2[$char]) and ($last_was_ascii or strpos($all_chars, ($nfo[$i + 1])))) { $tmp = $tmp . $trans2[$char]; $last_was_ascii = True; } else { if (isset($trans[$char])) { $tmp = $tmp . $trans[$char]; } else { $tmp = $tmp . $char; } $last_was_ascii = strpos($all_chars, $char); } } return $tmp; } //-----------------------------------------------
//DISPLAY NFO BLOCK if($row["nfo"]== "yes"){ $nfofilelocation = "$nfo_dir/$row[id].nfo"; $filegetcontents = file_get_contents($nfofilelocation); $nfo = htmlspecialchars($filegetcontents); if ($nfo) { $nfo = my_nfo_translate($nfo); echo "<BR><BR><b>NFO:</B><BR>"; begin_table(); print("<tr><td>\n");
print("<textarea style=\"font-size:8pt;width:100%;height:100%;\" wrap=\"off\" rows=20 and cols=20 READONLY>".stripslashes($nfo)."</textarea>"); end_table(); }else{ print(T_("ERROR")." reading .nfo file!"); } } end_frame();
begin_frame(T_("COMMENTS")); //echo "<p align=center><a class=index href=torrents-comment.php?id=$id>" .T_("ADDCOMMENT"). "</a></p>\n";
$subres = mysql_query("SELECT COUNT(*) FROM comments WHERE torrent = $id") or die(mysql_error()); $subrow = mysql_fetch_array($subres); $commcount = $subrow[0];
if ($commcount) { list($pagertop, $pagerbottom, $limit) = pager(10, $commcount, "torrents-details.php?id=$id&"); $commquery = "SELECT comments.id, text, user, comments.added, avatar, signature, username, title, class, uploaded, downloaded, privacy, donated FROM comments LEFT JOIN users ON comments.user = users.id WHERE torrent = $id ORDER BY comments.id $limit"; $commres = mysql_query($commquery) or die(mysql_error()); }else{ unset($commres); }
if ($commcount) { print($pagertop); commenttable($commres); print($pagerbottom); }else { print("<BR><b><CENTER>" .T_("NOCOMMENTS"). "</CENTER></b><BR>\n"); }
require_once("backend/bbcode.php");
if ($CURUSER) { echo "<CENTER>"; echo "<form name=\"comment\" method=\"post\" action=\"torrents-details.php?id=$row[id]&takecomment=yes\">"; echo "".textbbcode("comment","body").""; echo "<input type=\"submit\" class=btn value=\"".T_("ADDCOMMENT")."\" />"; echo "</form></CENTER>"; }
end_frame();
stdfoot(); ?>
|