Jump to content

table Broke

TheUnknown

By TheUnknown
in PHP Coding Help

 Share

Recommended Posts

TheUnknown Member

TheUnknown

Posted
Posted

Any ideas on how i can stop this??

here is the code

Ant tips would be great

 

 

<?php

//
// - Theme And Language Updated 26.Nov.05
//
require_once("backend/functions.php");
dbconn(false);
IF ($LOGGEDINONLY){
loggedinorreturn();
}

$maxLen = 30;

//AGENT DETECT
function getagent($httpagent, $peer_id="")
{
if (preg_match("/^Azureus ([0-9]+\.[0-9]+\.[0-9]+\.[0-9]\_B([0-9][0-9|*])(.+)$)/", $httpagent, $matches))
return "Azureus/$matches[1]";
elseif (preg_match("/^Azureus ([0-9]+\.[0-9]+\.[0-9]+\.[0-9]\_CVS)/", $httpagent, $matches))
return "Azureus/$matches[1]";
elseif (preg_match("/^Java\/([0-9]+\.[0-9]+\.[0-9]+)/", $httpagent, $matches))
return "Azureus/<2.0.7.0";
elseif (preg_match("/^Azureus ([0-9]+\.[0-9]+\.[0-9]+\.[0-9]+)/", $httpagent, $matches))
return "Azureus/$matches[1]";
elseif (preg_match("/BitTorrent\/S-([0-9]+\.[0-9]+(\.[0-9]+)*)/", $httpagent, $matches))
return "Shadow's/$matches[1]";
elseif (preg_match("/BitTorrent\/U-([0-9]+\.[0-9]+\.[0-9]+)/", $httpagent, $matches))
return "UPnP/$matches[1]";
elseif (preg_match("/^BitTor(rent|nado)\\/T-(.+)$/", $httpagent, $matches))
return "BitTornado/$matches[2]";
elseif (preg_match("/^BitTornado\\/T-(.+)$/", $httpagent, $matches))
return "BitTornado/$matches[1]";
elseif (preg_match("/^BitTorrent\/ABC-([0-9]+\.[0-9]+(\.[0-9]+)*)/", $httpagent, $matches))
return "ABC/$matches[1]";
elseif (preg_match("/^ABC ([0-9]+\.[0-9]+(\.[0-9]+)*)\/ABC-([0-9]+\.[0-9]+(\.[0-9]+)*)/", $httpagent, $matches))
return "ABC/$matches[1]";
elseif (preg_match("/^ABC\/ABC-([0-9]+\.[0-9]+(\.[0-9]+)*)/", $httpagent, $matches))
return "ABC $matches[1]";
elseif (preg_match("/^Python-urllib\/.+?, BitTorrent\/([0-9]+\.[0-9]+(\.[0-9]+)*)/", $httpagent, $matches))
return "BitTorrent/$matches[1]";
elseif (ereg("^BitTorrent\/BitSpirit$", $httpagent))
return "BitSpirit";
elseif (substr($peer_id, 0, 5) == "-BB09")
return "BitBuddy/0.9xx";
elseif (ereg("^DansClient", $httpagent))
return "XanTorrent";
elseif (substr($peer_id, 0,  == "-KT1100-")
return "KTorrent/1.1";
elseif (preg_match("/^BitTorrent\/brst(.+)/", $httpagent, $matches))
return "Burst/$matches[1]";
elseif (preg_match("/^RAZA (.+)$/", $httpagent, $matches))
return "Shareaza/$matches[1]";
elseif (preg_match("/Rufus\/([0-9]+\.[0-9]+\.[0-9]+)/", $httpagent, $matches))
return "Rufus/$matches[1]";
elseif (preg_match("/^BitTorrent\\/([0-9]+\\.[0-9]+(\\.[0-9]+)*)/", $httpagent, $matches))
{
if(substr($peer_id, 0, 6) == "exbc\08")
return "BitComet/0.56";
elseif(substr($peer_id, 0, 6) == "exbc\09")
return "BitComet/0.57";
elseif(substr($peer_id, 0, 6) == "exbc\0:")
return "BitComet/0.58";
elseif(substr($peer_id, 0,  == "-BC0059-")
return "BitComet/0.59";
elseif(substr($peer_id, 0,  == "-BC0060-")
return "BitComet/0.60";
elseif(substr($peer_id, 0,  == "-BC0061-")
return "BitComet/0.61";
elseif ((strpos($httpagent, 'BitTorrent/4.1.2')!== false) && (substr($peer_id, 2, 2) == "BS"))
return "BitSpirit/v3";
elseif(substr($peer_id, 0, 7) == "exbc\0L")
return "BitLord/1.0";
elseif(substr($peer_id, 0, 7) == "exbcL")
return "BitLord/1.1";
else
return "BitTorrent/$matches[1]";
}
elseif (preg_match("/^Python-urllib\\/([0-9]+\\.[0-9]+(\\.[0-9]+)*)/", $httpagent, $matches))
return "G3 Torrent";
elseif (preg_match("/MLdonkey( |\/)([0-9]+\\.[0-9]+).*/", $httpagent, $matches))
return "MLdonkey$matches[1]";
elseif (preg_match("/ed2k_plugin v([0-9]+\\.[0-9]+).*/", $httpagent, $matches))
return "eDonkey/$matches[1]";
elseif (ereg("^uTorrent", $httpagent))
{
if(substr($peer_id, 0,  == "-UT1130-")
return "uTorrent 1.1.3";
if(substr($peer_id, 0,  == "-UT1140-")
return "uTorrent 1.1.4";
if(substr($peer_id, 0,  == "-UT1150-")
return "uTorrent 1.1.5";
if(substr($peer_id, 0,  == "-UT1161-")
return "uTorrent 1.1.6.1";
if(substr($peer_id, 0,  == "-UT1171-")
return "uTorrent 1.1.7.1";
if(substr($peer_id, 0,  == "-UT1172-")
return "uTorrent 1.1.7.2";
if(substr($peer_id, 0,  == "-UT1200-")
return "uTorrent/1.2";
if(substr($peer_id, 0,  == "-UT1220-")
return "uTorrent/1.2.2";
if(substr($peer_id, 0,  == "-UT123B-")
return "uTorrent/1.2.3b";
if(substr($peer_id, 0,  == "-UT1300-")
return "uTorrent/1.3.0";
if(substr($peer_id, 0,  == "-UT1400-")
return "uTorrent/1.4.0";
else
return "uTorrent";
}
else
return ($httpagent != "" ? $httpagent : "---");
}

//PEERS TABLE FUNCTION
function dltable($name, $arr, $torrent)
{
global $CURUSER;
$s = "<b>" . count($arr) . " $name</b>\n";
if (!count($arr))
	return $s;
$s .= "\n";
$s .= "<table class=table_table cellspacing=0 cellpadding=3 width=95%>\n";
$s .= "<tr><td class=table_head>" . USERNAME . "/IP</td>" .
          "<td class=table_head>" . PORT . "</td>".
          "<td class=table_head>" . UPLOADED . "</td>".
          "<td class=table_head>" . DOWNLOADED . "</td>" .
          "<td class=table_head>" . RATIO . "</td>" .
          "<td class=table_head>" . COMPLETE . "</td>" .
          "<td class=table_head>" . CONNECTED . "</td>" .
          "<td class=table_head><b>" . IDLE . "</b></td>".
          "<td class=table_head><b>Client</b></td></tr>\n";
$now = time();

//DEFINE MODERATOR
$moderator = (isset($CURUSER) && get_user_class() >= UC_JMODERATOR);
$mod = get_user_class() >= UC_JMODERATOR;
foreach ($arr as $e) {
	$s .= "<tr>\n";

($unr = mysql_query("SELECT id,username,privacy FROM users WHERE ip='" . $e["ip"] .
                  "' ORDER BY last_access DESC LIMIT 1")) or die;
                $una = mysql_fetch_array($unr);
				//mysql_free_result($unr);
if ($una["privacy"] == "strong" && get_user_class() < UC_JMODERATOR AND $CURUSER["id"] != $una["owner"]){
                $s .= "<td class=table_col1><a href=#><b>Anonymous</b></a></td>\n"; }
                elseif ($una["username"])
                $s .= "<td class=table_col1><a href=account-details.php?id=$una[id]><b>$una[username]</b></a></td>\n";
                else
                  $s .= "<td class=table_col1>" . ($mod ? $e["ip"] : preg_replace('/\.\d+$/', ".xxx", $e["ip"])) . "</td>\n";
        $s .= "<td class=table_col2>" . ($e[connectable] == "yes" ? $e["port"] : "---") . "</td>\n";
	$s .= "<td class=table_col1>" . mksize($e["uploaded"]) . "</td>\n";
	$s .= "<td class=table_col2>" . mksize($e["downloaded"]) . "</td>\n";
                if ($e["downloaded"])
                {
                  $ratio = $e["uploaded"] / $e["downloaded"];
                  if ($ratio < 0.1)
                    $s .= "<td class=table_col2><font color=#ff0000>" . number_format($ratio, 2) . "</font></td>\n";
                  else if ($ratio < 0.2)
                    $s .= "<td class=table_col2><font color=#ee0000>" . number_format($ratio, 2) . "</font></td>\n";
                  else if ($ratio < 0.3)
                    $s .= "<td class=table_col2><font color=#dd0000>" . number_format($ratio, 2) . "</font></td>\n";
                  else if ($ratio < 0.4)
                    $s .= "<td class=table_col2><font color=#cc0000>" . number_format($ratio, 2) . "</font></td>\n";
                  else if ($ratio < 0.5)
                    $s .= "<td class=table_col2><font color=#bb0000>" . number_format($ratio, 2) . "</font></td>\n";
                  else if ($ratio < 0.6)
                    $s .= "<td class=table_col2><font color=#aa0000>" . number_format($ratio, 2) . "</font></td>\n";
                  else if ($ratio < 0.7)
                    $s .= "<td class=table_col2><font color=#990000>" . number_format($ratio, 2) . "</font></td>\n";
                  else if ($ratio < 0.
                    $s .= "<td class=table_col2><font color=#880000>" . number_format($ratio, 2) . "</font></td>\n";
                  else if ($ratio < 0.9)
                    $s .= "<td class=table_col2><font color=#770000>" . number_format($ratio, 2) . "</font></td>\n";
                  else if ($ratio < 1)
                    $s .= "<td class=table_col2><font color=#660000>" . number_format($ratio, 2) . "</font></td>\n";
                  else
                    $s .= "<td class=table_col2>" . number_format($ratio, 2) . "</td>\n";
                }
                else
                  if ($e["uploaded"])
                    $s .= "<td class=table_col2>Inf.</td>\n";
                  else
                    $s .= "<td class=table_col2>---</td>\n";
	$s .= "<td class=table_col1>" . sprintf("%.2f%%", 100 * (1 - ($e["to_go"] / $torrent["size"]))) . "</td>\n";
	$s .= "<td class=table_col2>" . mkprettytime($now - $e["st"]) . "</td>\n";
	$s .= "<td class=table_col1>" . mkprettytime($now - $e["la"]) . "</td>\n";
	$s .= "<td class=table_col2 align=right>" . htmlspecialchars(getagent($e["client"],$e["peer_id"])) . "</td>\n";
	$s .= "</tr>\n";
}
$s .= "</table>\n";
return $s;
}
//END PEERS TABLE FUNCTION

//************ DO SOME "GET" STUFF BEFORE PAGE LAYOUT ***************

$id = $_GET["id"];
$id = 0 + $id;
if (!isset($id) || !$id)
die();
//GET ALL MYSQL VALUES FOR THIS TORRENT
$res = mysql_query("SELECT torrents.seeders, torrents.banned, torrents.leechers, torrents.info_hash, torrents.filename, torrents.nfo AS nfo, UNIX_TIMESTAMP() - UNIX_TIMESTAMP(torrents.last_action) AS lastseed, torrents.numratings, torrents.name, IF(torrents.numratings < $minvotes, NULL, ROUND(torrents.ratingsum / torrents.numratings, 1)) AS rating, torrents.external,torrents.announce,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.numfiles, categories.name AS cat_name, users.username, users.privacy FROM torrents LEFT JOIN categories ON torrents.category = categories.id LEFT JOIN users ON torrents.owner = users.id WHERE torrents.id = $id")
or sqlerr();
$row = mysql_fetch_array($res);

//DECIDE IF USER IS OWNER/MOD
$owned = $moderator = 0;
if (get_user_class() >= UC_MODERATOR)
	$owned = $moderator = 1;
elseif ($CURUSER["id"] == $row["owner"])
	$owned = 1;

//DECIDE IF TORRENT EXISTS
if (!$row || ($row["banned"] == "yes" && !$moderator)){
stdhead();
begin_frame("Error");
print("<br><BR><center>" . TORRENT_NOT_FOUND . "</center><br><BR>");
end_frame();
stdfoot();
exit();
}else {
if ($_GET["hit"]) {
	mysql_query("UPDATE torrents SET views = views + 1 WHERE id = $id");
	if ($_GET["tocomm"])
		header("Location: torrents-details.php?id=$id#startcomments");
		//header("Location: torrents-details.php?id=$id&page=0#startcomments");
	elseif ($_GET["filelist"])
		header("Location: torrents-details.php?id=$id&filelist=1#filelist");
	elseif ($_GET["toseeders"])
		header("Location: torrents-details.php?id=$id&dllist=1#seeders");
	elseif ($_GET["todlers"])
		header("Location: torrents-details.php?id=$id&dllist=1#leechers");
	else
		header("Location: torrents-details.php?id=$id");
	exit();
}


	if (!isset($_GET["page"]) || isset($_GET["page"])) {
      stdhead("Details for torrent " . $row["name"] . ""); 
	if ($CURUSER["id"] == $row["owner"] || get_user_class() >= UC_MODERATOR)
		$owned = 1;
	else
		$owned = 0;


	if ($_GET["uploaded"]) {
		bark2("Successfully uploaded!", "You can start seeding now. <b>Note</b> that the torrent won't be visible until you do that!");
	}
	elseif ($_GET["edited"]) {
		bark2("Success", "Edited OK!");
		if (isset($_GET["returnto"]))
			print("<p><b>Go back to <a href=\"" . htmlspecialchars($_GET["returnto"]) . "\">previous page</a>.</b></p>\n");
	}
	elseif (isset($_GET["searched"])) {
		bark2("Success", "Your search for \"" . htmlspecialchars($_GET["searched"]) . "\" gave a single result:");
	}
	elseif ($_GET["rated"])
		bark2("Success", "" . RATING_THANK . "");
//END "GET" STUFF

//DEFINE SOME VARIABLES
// $S IS RATING VARIABLE
	$s = "";
	$s .= "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\"><tr><td valign=\"top\" class=embedded>";
	if (!isset($row["rating"])) {
		if ($minvotes > 1) {
			$s .= "none yet (needs at least $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>";
	if (!isset($CURUSER))
		$s .= "(<a href=\"account-login.php?returnto=" . urlencode($_SERVER["REQUEST_URI"]) . "&nowarn=1\">Log in</a> to rate it)";
	else {
		$ratings = array(
				5 => "Cool!",
				4 => "Pretty good",
				3 => "Decent",
				2 => "Pretty bad",
				1 => "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)
				$s .= "(you rated this torrent as \"" . $xrow["rating"] . " - " . $ratings[$xrow["rating"]] . "\")";
			else {
				$s .= "<form method=\"post\" action=\"take-rating.php\"><input type=\"hidden\" name=\"id\" value=\"$id\" />\n";
				$s .= "<select name=\"rating\">\n";
				$s .= "<option value=\"0\">(add rating)</option>\n";
				foreach ($ratings as $k => $v) {
					$s .= "<option value=\"$k\">$k - $v</option>\n";
				}
				$s .= "</select>\n";
				$s .= "<input type=\"submit\" value=\"Vote!\" />";
				$s .= "</form>\n";
			}
		}
	}
	$s .= "</td></tr></table>";
//END DEFINE RATING VARIABLE

$url = "torrents-edit.php?id=" . $row["id"];
if (isset($_GET["returnto"])) {
	$addthis = "&returnto=" . urlencode($_GET["returnto"]);
	$url .= $addthis;
	$keepget .= $addthis;
}

$editlink = "a href=\"$url\" class=\"sublink\"";
if ($owned)
$editit .= "| <$editlink> [" . EDIT_TORRENT . "]</a>";

//progress bar
$seedersProgressbar = array();
$leechersProgressbar = array();
$resProgressbar = mysql_query("SELECT p.seeder, p.to_go, t.size FROM torrents AS t LEFT JOIN peers AS p ON t.id = p.torrent WHERE  p.torrent = '$id'") or sqlerr();
$progressPerTorrent = 0;
$iProgressbar = 0;
while ($rowProgressbar = mysql_fetch_array($resProgressbar)) {
$progressPerTorrent += sprintf("%.2f", 100 * (1 - ($rowProgressbar["to_go"] / $rowProgressbar["size"])));    
$iProgressbar++;
}
if ($iProgressbar == 0) 
$iProgressbar = 1;
$progressTotal = sprintf("%.2f", $progressPerTorrent / $iProgressbar);
//end progress bar

//START OF PAGE LAYOUT HERE
$rawr = $row["name"];
if(strlen($rawr) > $maxLen) { $rawr = substr($rawr, 0, ($maxLen - 3)); $rawr .= "..."; }
begin_frame("" . TORRENT_DETAILS_FOR . " \"" . $rawr . "\"");

echo "<TABLE BORDER=0 WIDTH=100%><TR><TD ALIGN=RIGHT><a href=report.php?torrent=$id>" . REPORT_TORRENT . "</a> " . $editit . "</TD></TR></TABLE>";

echo "<BR><table cellpadding=3 width=100% border=0>";
echo "<TR><TD width=70% align=left valign=top><table width=100% cellspacing=0 cellpadding=3 border=0>";

print("<tr><td align=left colspan=2><b>" . TDESC . ":</b><br>" .  format_comment($row['descr']) . "</td></tr>");

print("<tr><td align=left><b>" . NAME . ":</b></td><td>" . htmlspecialchars($row["name"]) . "</td></tr>");

print("<tr><td align=left><b>" . TORRENT . ":</b></td><td><a href=\"download.php?id=$id&name=" . rawurlencode($row["filename"]) . "\">" . htmlspecialchars($row["filename"]) . "</a></td></tr>");

print("<tr><td align=left><b>" . TTYPE . ":</b></td><td>" . $row["cat_name"] . "</td></tr>");

print("<tr><td align=left><b>" . TOTAL_SIZE . ":</b></td><td>" . mksize($row["size"]) . " </td></tr>");

print("<tr><td align=left><b>" . INFO_HASH . ":</b></td><td>" . $row["info_hash"] . "</td></tr>");

if($row["privacy"] == "strong" && get_user_class() < UC_JMODERATOR AND $CURUSER["id"] != $row["owner"]){
print("<tr><td align=left><b>" . ADDED_BY . ":</b></td><td>Anonymous</td></tr>");
}else{
print("<tr><td align=left><b>" . ADDED_BY . ":</b></td><td><a href=account-details.php?id=" . $row["owner"] . ">" . $row["username"] . "</a></td></tr>");
}

print("<tr><td align=left><b>" . DATE_ADDED . ":</b></td><td>" . $row["added"] . "</td></tr>");
print("<tr><td align=left><b>" . VIEWS . ":</b></td><td>" . $row["views"] . "</td></tr>");
print("<tr><td align=left><b>" . HITS . ":</b></td><td>" . $row["hits"] . "</td></tr>");
print("<tr><td align=left><b>" . RATINGS . ":</b></td><td>" . $s . "</td></tr>");
echo "<tr><td colspan='2' align=center><br><br><img src=images/seed.gif></td></tr>";
echo "<tr><td colspan='2' align=center>";
$res9 = mysql_query("SELECT * FROM site_settings ") or sqlerr(__FILE__, __LINE__);
$arr9 = mysql_fetch_assoc($res9);
$donatein = $arr9['donations'];
$donateasked = $arr9['requireddonations'];
$perc = round(100 * $donatein/$donateasked);
echo "<center><br>Dontation Progress<table class=main border=0 width=500><tr><td style='padding: 0px; background-image: url(images/loadbarbg.gif); background-repeat: repeat-x'>";
$width1 = ($perc*10/2);
if ($perc<= 1) {$pic = "nodonateyet.jpg"; $width1 = "100";}
elseif ($perc<= 40) {$pic = "loadbarred.gif";}
elseif ($perc<= 80) {$pic = "loadbaryellow.gif";}
else {$pic = "loadbargreen.gif";}

echo "<img height=15 width=$width1 src=\"images/$pic\" alt='$donatein)%'><br><font size='1'><center>$perc%</center></font></td></tr></table>";
echo "<b>" . TARGET . ": <font color=\"red\">$" . $donateasked . "</b></font><br><b>" . DONATIONS . ": <font color=\"green\">$" . $donatein . "</b></font></center><br>";
print "<div align=center><B><a href=\"donate.php\">Click Here to Donate and become a VIP member</a></B><br><br>";
echo "</table></TD><TD align=right valign=top><table width=100% cellspacing=0 cellpadding=3 border=0>";

if ($row["banned"] == "yes"){
print ("<tr><td valign=top align=right><B>" . DOWNLOAD . ": </B>BANNED!</td></tr>");
}else{
print ("<tr><td valign=top align=right><a href=\"download.php?id=$id&name=" . rawurlencode($row["filename"]) . "\"><img src=images/download.png border=0></td></tr>");
}

print("<tr><td valign=top align=right><B>" . AVAILABILITY . ":</B><br>" . get_percent_completed_image(floor($progressTotal)) . " (".round($progressTotal)."%)</td></tr>");
print("<tr><td valign=top align=right><B>" . SEEDS . ": <font color=green>" . $row["seeders"] . "</font></B></td></tr>");
print("<tr><td valign=top align=right><B>" . LEECH . ": <font color=red>" . $row["leechers"] . "</font></B></td></tr>");
//speed mod
$resSpeed = mysql_query("SELECT seeders,leechers FROM torrents WHERE $where visible='yes' and id = $id 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"; 
} 
else 
       $totalspeed = "No traffic currently recorded";  
print("<tr><td valign=top align=right><B>Total Speed: <font color=green>");
echo $totalspeed;
print("</font></B></td></tr>");
//end speed mod
print("<tr><td valign=top align=right><B>" . COMPLETED . ": " . $row["times_completed"] . "</B></td></tr>");
//print("<tr><td valign=top align=right><a href=completed.php?id=" . $id . ">[" . SEE_WHO_COMPLETED . "]</a></td></tr>");
print("<tr><td valign=top align=right><a href=completed-advance.php?id=" . $id . ">[" . SEE_WHO_COMPLETED . "]</a></td></tr>");
print("<tr><td valign=top align=right><B>" . LAST_SEEDED . ": </b>" . mkprettytime($row["lastseed"]) . " ago</td></tr>");
if ($row['external']=='yes'){
print("<tr><td valign=top align=right><b>Tracked: <font color=red>EXTERNAL</b></td></tr>");
print("<tr><td valign=top align=right><b>Update: <a href=quickscrape.php?id=" . $row["id"] . ">[uPDATE EXT STATS]</A></td></tr>");
}else{
print("<tr><td valign=top align=right><b>Tracked: <font color=green>LOCAL</b></td></tr>");
}
if ($row['seeders'] < 3 && $row['times_completed'] >= 1){
print("<tr><td valign=top align=right><B>Request a re-seed: </b><a href=re-seed.php?id=" . $id . ">[sEND REQUEST!]</a></td></tr>");
}

echo "</table>";

if (get_user_class() >= UC_JMODERATOR) {
echo "<br><BR><table width=100% cellspacing=0 cellpadding=3 style='border-collapse: collapse' bordercolor=#33CC00 border=1>";
print("<tr><td valign=top align=center><B>" . MODERATOR_ONLY . "</B></td></tr>");

echo "<br /><br />";
    print("<tr><td><form method=\"post\" action=\"torrents-delete.php\">\n");
    print("<input type=\"hidden\" name=\"id\" value=\"$id\">\n");
    if (isset($_GET["returnto"]))
        print("<input type=\"hidden\" name=\"returnto\" value=\"" . htmlspecialchars($_GET["returnto"]) . "\" />\n");
    print("<B>" . REASON_FOR_DELETE . ":</B> <input type=text size=33 name=reason> <input type=submit value='" . DELETE_IT . "' style='height: 25px'>\n");
    print("</form>\n");
    print("</p>\n");
print("</td></tr>");

print("<tr><td valign=top align=left><B>" . BANNED . ": </B>" . $row["banned"] . "<br><B>" . VISIBLE . ": </B>" . $row["visible"] . "</td></tr>");

////////
if (get_user_class() >= UC_JMODERATOR){        
	if (!$_GET["ratings"])
                print("<tr><td valign=top align=left><B>" . RATINGS . "</B> (" . $row["numratings"] . ")   <a href=\"torrents-details.php?id=$id&ratings=1$keepget#ratings\">[see Who Rated]</a>");
          else {
		  print("<tr><td valign=top align=left><B>" . RATINGS . "</B> (" . $row["numratings"] . ")");

		$s = "<table border=0 cellspacing=0 cellpadding=2>\n";
            $subres = mysql_query("SELECT * FROM ratings WHERE torrent = $id ORDER BY user");

		$s.="<tr><td><B>User</B></td><td align=right><B>Rated This</B></td></tr>\n";

            while ($subrow = mysql_fetch_array($subres)) {
			$ratingid=$subrow["user"];
			$sd=mysql_query("SELECT username FROM users WHERE id=$ratingid");
			$fetched_result = mysql_fetch_array($sd);
			$sd = $fetched_result['username'];
                $s .= "<tr><td><a href=account-details.php?id=$ratingid>" . $sd .
                "</a></td><td align=\"right\">" . $subrow["rating"] . "</td></tr>\n";
            }

		$s .= "</table>\n";

		print("<tr><td valign=top align=left>" .  $s . "<BR><a name=\"filelist\"><a href=\"torrents-details.php?id=$id$keepget\">[Hide list]</a>");
            }
}
/////////
echo "</table>";
}

echo "</td></tr></table>";

echo "<table width=100%>";
//DO FILE LIST STUFF
if ($row["type"] == "multi") {
		if (!$_GET["filelist"]){
			print("<tr><td valign=top align=left><B>" . FILE_LIST . ": </b><a href=\"torrents-details.php?id=$id&filelist=1$keepget#filelist\" class=\"sublink\">[" . SHOW . "]</a></td></tr>");
		}else {
			print("<tr><td valign=top align=left><B>" . FILE_LIST . ": </b></tr>");

			$s = "<table class=main border=\"1\" cellspacing=0 cellpadding=\"5\">\n";

			$subres = mysql_query("SELECT * FROM files WHERE torrent = $id ORDER BY id");
$s.="<tr><td class=colhead>" . PATH . "</td><td class=colhead align=left>" . SIZE . "</td></tr>\n";
			while ($subrow = mysql_fetch_array($subres)) {
				$s .= "<tr><td>" . $subrow["filename"] .
                            "</td><td class=table_col2>" . mksize($subrow["size"]) . "</td></tr>\n";
			}

			$s .= "</table>\n";
			tr("<a name=\"filelist\">" . FILE_LIST . "</a><br /><a href=\"torrents-details.php?id=$id$keepget\" class=\"sublink\">[" . HIDE . "]</a>", $s, 1);
		}
}

//DO PEERS LIST STUFF
if (!$_GET["dllist"]) {
$subres = mysql_query("SELECT seeder, COUNT(*) FROM peers WHERE torrent = $id GROUP BY seeder");
$resarr = array(yes => 0, no => 0);
		$sum = 0;
		while ($subrow = mysql_fetch_array($subres)) {
			$resarr[$subrow[0]] = $subrow[1];
			$sum += $subrow[1];
		}
print("<tr><td valign=top align=left><B>" . PEERS . ": $sum </b><a href=\"torrents-details.php?id=$id&dllist=1$keepget#seeders\" class=\"sublink\">[" . SHOW . "]</a></td></tr>");
}else {
$downloaders = array();
$seeders = array();
$subres = mysql_query("SELECT peer_id, client, seeder, ip, port, uploaded, downloaded, to_go, UNIX_TIMESTAMP(started) AS st, connectable, UNIX_TIMESTAMP(last_action) AS la FROM peers WHERE torrent = $id") or sqlerr();
	while ($subrow = mysql_fetch_array($subres)) {
			if ($subrow["seeder"] == "yes")
				$seeders[] = $subrow;
			else
				$downloaders[] = $subrow;
		}

function leech_sort($a,$b) {
  if ( isset( $_GET["usort"] ) ) return seed_sort($a,$b);
        $x = $a["to_go"];
	$y = $b["to_go"];
			if ($x == $y)
				return 0;
			if ($x < $y)
				return -1;
			return 1;
}

function seed_sort($a,$b) {
	$x = $a["uploaded"];
	$y = $b["uploaded"];
			if ($x == $y)
				return 0;
			if ($x < $y)
				return 1;
			return -1;
}

usort($seeders, "seed_sort");
usort($downloaders, "leech_sort");

print("<tr><td valign=top align=left><B>" . SEEDS . " </b>" . dltable(" " . SEEDS . "(s) <a href=\"torrents-details.php?id=$id$keepget\" class=\"sublink\">[" . HIDE. "]</a>", $seeders, $row) . " </td></tr>");

print("<tr><td valign=top align=left><B>" . LEECH . " </b>" . dltable(" " . LEECH . "(s) <a href=\"torrents-details.php?id=$id$keepget\" class=\"sublink\">[" . HIDE . "]</a>", $downloaders, $row) . " </td></tr>");

	}
}
echo "</table>";

echo "<BR><BR>";

//DISPLAY NFO BLOCK
$nfo = htmlspecialchars($row["nfo"]);
//-----------------------------------------------
function my_nfo_translate($nfo)
{
        $trans = array(
        "\x80" => "&#199;", "\x81" => "&#252;", "\x82" => "&#233;", "\x83" => "&#226;", "\x84" => "&#228;", "\x85" => "&#224;", "\x86" => "&#229;", "\x87" => "&#231;", "\x88" => "&#234;", "\x89" => "&#235;", "\x8a" => "&#232;", "\x8b" => "&#239;", "\x8c" => "&#238;", "\x8d" => "&#236;", "\x8e" => "&#196;", "\x8f" => "&#197;", "\x90" => "&#201;",
        "\x91" => "&#230;", "\x92" => "&#198;", "\x93" => "&#244;", "\x94" => "&#246;", "\x95" => "&#242;", "\x96" => "&#251;", "\x97" => "&#249;", "\x98" => "&#255;", "\x99" => "&#214;", "\x9a" => "&#220;", "\x9b" => "&#162;", "\x9c" => "&#163;", "\x9d" => "&#165;", "\x9e" => "&#8359;", "\x9f" => "&#402;", "\xa0" => "&#225;", "\xa1" => "&#237;",
        "\xa2" => "&#243;", "\xa3" => "&#250;", "\xa4" => "&#241;", "\xa5" => "&#209;", "\xa6" => "&#170;", "\xa7" => "&#186;", "\xa8" => "&#191;", "\xa9" => "&#8976;", "\xaa" => "&#172;", "\xab" => "&#189;", "\xac" => "&#188;", "\xad" => "&#161;", "\xae" => "&#171;", "\xaf" => "&#187;", "\xb0" => "&#9617;", "\xb1" => "&#9618;", "\xb2" => "&#9619;",
        "\xb3" => "&#9474;", "\xb4" => "&#9508;", "\xb5" => "&#9569;", "\xb6" => "&#9570;", "\xb7" => "&#9558;", "\xb8" => "&#9557;", "\xb9" => "&#9571;", "\xba" => "&#9553;", "\xbb" => "&#9559;", "\xbc" => "&#9565;", "\xbd" => "&#9564;", "\xbe" => "&#9563;", "\xbf" => "&#9488;", "\xc0" => "&#9492;", "\xc1" => "&#9524;", "\xc2" => "&#9516;", "\xc3" => "&#9500;",
        "\xc4" => "&#9472;", "\xc5" => "&#9532;", "\xc6" => "&#9566;", "\xc7" => "&#9567;", "\xc8" => "&#9562;", "\xc9" => "&#9556;", "\xca" => "&#9577;", "\xcb" => "&#9574;", "\xcc" => "&#9568;", "\xcd" => "&#9552;", "\xce" => "&#9580;", "\xcf" => "&#9575;", "\xd0" => "&#9576;", "\xd1" => "&#9572;", "\xd2" => "&#9573;", "\xd3" => "&#9561;", "\xd4" => "&#9560;",
        "\xd5" => "&#9554;", "\xd6" => "&#9555;", "\xd7" => "&#9579;", "\xd8" => "&#9578;", "\xd9" => "&#9496;", "\xda" => "&#9484;", "\xdb" => "&#9608;", "\xdc" => "&#9604;", "\xdd" => "&#9612;", "\xde" => "&#9616;", "\xdf" => "&#9600;", "\xe0" => "&#945;", "\xe1" => "&#223;", "\xe2" => "&#915;", "\xe3" => "&#960;", "\xe4" => "&#931;", "\xe5" => "&#963;",
        "\xe6" => "&#181;", "\xe7" => "&#964;", "\xe8" => "&#934;", "\xe9" => "&#920;", "\xea" => "&#937;", "\xeb" => "&#948;", "\xec" => "&#8734;", "\xed" => "&#966;", "\xee" => "&#949;", "\xef" => "&#8745;", "\xf0" => "&#8801;", "\xf1" => "&#177;", "\xf2" => "&#8805;", "\xf3" => "&#8804;", "\xf4" => "&#8992;", "\xf5" => "&#8993;", "\xf6" => "&#247;",
        "\xf7" => "&#8776;", "\xf8" => "&#176;", "\xf9" => "&#8729;", "\xfa" => "&#183;", "\xfb" => "&#8730;", "\xfc" => "&#8319;", "\xfd" => "&#178;", "\xfe" => "&#9632;", "\xff" => "&#160;",
        );
        $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;
}
$nfo = my_nfo_translate($nfo);
//-----------------------------------------------

if (!$nfo) {
print("<BR>");
}else{
    begin_frame("" . NFO . " for $row[name]</a>");
    begin_table();
        print("<tr><td class=alt2>\n");
   //     print("<br><pre><font face='MS Linedraw' size=2 style='font-size: 10pt; line-height: 10pt'>" . format_urls($nfo) . "</font></pre>\n");
     print("<br><pre>" . format_urls($nfo) . "</pre>\n");
    end_table();
        //print("<p align=center>" . FOR_BEST_RESULTS . "</p>\n");
    end_frame();
}


begin_frame("" . COMMENTS . "");
print("<p><a name=\"startcomments\"></a></p>\n");

$commentbar = "<p align=center><a class=index href=torrents-comment.php?id=$id>" . ADDCOMMENT . "</a></p>\n";

$subres = mysql_query("SELECT COUNT(*) FROM comments WHERE torrent = $id");
$subrow = mysql_fetch_array($subres);
$count = $subrow[0];

if (!$count) {
	print("<BR><b><CENTER>" . NOCOMMENTS . "</CENTER></b><BR>\n");
}
else {
	list($pagertop, $pagerbottom, $limit) = pager(20, $count, "torrents-details.php?id=$id&", array(lastpagedefault => 1));

	$subres = mysql_query("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");
	$allrows = array();
	while ($subrow = mysql_fetch_array($subres))
		$allrows[] = $subrow;

	print($commentbar);
	print($pagertop);

	commenttable($allrows);

	print($pagerbottom);
}

print($commentbar);
end_frame();
}

end_frame();

stdfoot();


?>

 

 

fa7efceae1a81dd280b2396fd4e4d92f.jpg

Link to comment
Share on other sites
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.