\n";
$s .= "| Felhasználó | " .
"Kapcsolat | ".
"Feltöltött | ".
"Sebesség | ".
"Letöltött | " .
"Sebesség | " .
"Arány | " .
"Kész | " .
"Kapcsolódva | " .
"Frissített | " .
"Kliens |
\n";
$now = time();
$moderator = (isset($CURUSER) && get_user_class() >= UC_MODERATOR);
$mod = get_user_class() >= UC_MODERATOR;
foreach ($arr as $e) {
// user/ip/port
// check if anyone has this ip
($unr = mysql_query("SELECT username, privacy FROM users WHERE id=$e[userid] ORDER BY last_access DESC LIMIT 1")) or die;
$una = mysql_fetch_array($unr);
if ($una["privacy"] == "strong") continue;
$s .= "\n";
if ($una["username"])
$s .= "| $una[username] | \n";
else
$s .= "" . ($mod ? $e["ip"] : preg_replace('/\.\d+$/', ".xxx", $e["ip"])) . " | \n";
$secs = max(1, ($now - $e["st"]) - ($now - $e["la"]));
$revived = $e["revived"] == "yes";
$s .= "" . ($e[connectable] == "yes" ? "Aktív" : "Passzív") . " | \n";
$s .= "" . mksize($e["uploaded"]) . " | \n";
$s .= "" . mksize(($e["uploaded"] - $e["uploadoffset"]) / $secs) . "/s | \n";
$s .= "" . mksize($e["downloaded"]) . " | \n";
if ($e["seeder"] == "no")
$s .= "" . mksize(($e["downloaded"] - $e["downloadoffset"]) / $secs) . "/s | \n";
else
$s .= "" . mksize(($e["downloaded"] - $e["downloadoffset"]) / max(1, $e["finishedat"] - $e[st])) . "/s | \n";
if ($e["downloaded"])
{
$ratio = floor(($e["uploaded"] / $e["downloaded"]) * 1000) / 1000;
$s .= "" . number_format($ratio, 3) . " | \n";
}
else
if ($e["uploaded"])
$s .= "Végtelen | \n";
else
$s .= "--- | \n";
$s .= "" . sprintf("%.2f%%", 100 * (1 - ($e["to_go"] / $torrent["size"]))) . " | \n";
$s .= "" . mkprettytime($now - $e["st"]) . " | \n";
$s .= "" . mkprettytime($now - $e["la"]) . " | \n";
$s .= "" . htmlspecialchars(getagent($e["agent"], $e["peer_id"])) . " | \n";
$s .= "
\n";
}
$s .= "
\n";
return $s;
}
dbconn(false);
loggedinorreturn();
$id = 0 + $_GET["id"];
if (!isset($id) || !$id)
die();
if(($_POST['lefoglalas']=='lefoglalt') AND (get_user_class() >= UC_MODERATOR)){
mysql_query("UPDATE torrents SET ellenorizte = $CURUSER[id] WHERE id=$id") or sqlerr(__FILE__,__LINE__);
}
if ($_POST["valtoz"]=="igen" AND get_user_class() >= UC_MODERATOR)
{
$tor=$id;
if ($_POST["ellenoriz"]=="yes")
{
mysql_query("UPDATE torrents SET ellenorizve = 'yes' WHERE id = $tor") or sqlerr(__FILE__,__LINE__);
$hey= "Helyes! Megjegyzés: " . $_POST["ecomment"] . " Ellenőrizte: " . $CURUSER["username"];
$ellenorizte=$CURUSER["id"];
// $feltoltoidje = $row["owner"];
//mysql_query("UPDATE users SET seedbonus = seedbonus + 5 WHERE id = $ellenorizte");
//mysql_query("UPDATE users SET seedbonus = seedbonus + 20 WHERE id = $feltoltoidje");
}
if ($_POST["ellenoriz"]=="no")
{
mysql_query("UPDATE torrents SET ellenorizve = 'no' WHERE id = $tor") or sqlerr(__FILE__,__LINE__);
$hey= "Hibás! Pótold: " . $_POST["ecomment"] . " Ellenőrizte: " . $CURUSER["username"];
$ellenorizte=$CURUSER["id"];
//$feltoltoidje = $row["owner"];
}
if ($_POST["ellenoriz"]=="yes") $hey="[color=green][b]".$hey."[/b][/color]";
if ($_POST["ellenoriz"]=="no") $hey="[color=red][b]".$hey."[/b][/color]";
mysql_query("UPDATE torrents SET elcomment = '$hey' WHERE id = $tor") or sqlerr(__FILE__,__LINE__);
//mysql_query("UPDATE torrents SET ellenorizte = '$ellenorizte' WHERE id = $tor");
}
$res = mysql_query("SELECT torrents.seeders, torrents.ellenorizve, torrents.elcomment, torrents.ellenorizte, torrents.banned, torrents.nuked, torrents.leechers, torrents.info_hash, torrents.filename, LENGTH(torrents.nfo) AS nfosz, 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.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 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);
$owned = $moderator = 0;
if (get_user_class() >= UC_MODERATOR)
$owned = $moderator = 1;
elseif ($CURUSER["id"] == $row["owner"])
$owned = 1;
//}
if (!$row || ($row["banned"] == "yes" && !$moderator))
stderr("Hiba", "Nincs ilyen ID-jű torrent.");
else {
if ($_GET["hit"]) {
mysql_query("UPDATE torrents SET views = views + 1 WHERE id = $id");
if ($_GET["tocomm"])
header("Location: $BASEURL/details.php?id=$id&page=0#startcomments");
elseif ($_GET["filelist"])
header("Location: $BASEURL/details.php?id=$id&filelist=1#filelist");
elseif ($_GET["toseeders"])
header("Location: $BASEURL/details.php?id=$id&dllist=1#seeders");
elseif ($_GET["todlers"])
header("Location: $BASEURL/details.php?id=$id&dllist=1#leechers");
else
header("Location: $BASEURL/details.php?id=$id");
exit();
}
if (!isset($_GET["page"])) {
stdhead("Details for torrent \"" . $row["name"] . "\"");
if ($CURUSER["id"] == $row["owner"] || get_user_class() >= UC_MODERATOR)
$owned = 1;
else
$owned = 0;
$spacer = " ";
if ($_GET["uploaded"]) {
print("Most már elkezdheted seedelni. Megjegyzés: a torrent addig nem fog látszódani amig nem kezded el seedelni!
\n");
}
elseif ($_GET["edited"]) {
print("\n");
$url = "edit.php?id=" . $row["id"];
if (isset($_GET["returnto"])) {
$addthis = "&returnto=" . urlencode($_GET["returnto"]);
$url .= $addthis;
$keepget .= $addthis;
}
$editlink = "a href=\"$url\" class=\"sublink\"";
// $s = "" . htmlspecialchars($row["name"]) . "";
// if ($owned)
// $s .= " $spacer<$editlink>[Edit torrent]";
tr("Név", $s, 1);
print("| Letöltés | ");
if ($row['ellenorizve']!='yes' AND $CURUSER['id']!=$row['owner'])
{
print("A torrent vezetői engedélyre vár!");
}
else
{
print("" . htmlspecialchars($row["filename"]) . "");
}
print(" |
");
if ($row["ellenorizve"]=="nincs") $szoveg="[b][color=blue][u]Még nincs ellenőrizve![/color][/b][/u]";
else $szoveg=$row["elcomment"];
if($_POST['javit']=='javitottam')
{
$dt = sqlesc(get_date_time());
$msg = sqlesc("Üdv.\n Itt a rendszer!\n Csak üzent egy felhasználó, hogy már javította a torrentjét!\n
Menj és ellenőrizd! $BASEURL/details.php?id=$id\n Előre is köszönöm!\n Üdv. RENDSZER");
mysql_query("INSERT INTO messages (sender, receiver, added, msg, poster) VALUES(0, $row[owner], $dt, $msg, 0)") or sqlerr(__FILE__, __LINE__);
echo "";
}
$tor=$row["id"];
if ($row['owner']==$CURUSER['id'] AND $row['ellenorizve']=='no')
$vezetoi_szoveg = "";
else
$vezetoi_szoveg = format_comment($szoveg);
print("Vezetői
Ellenőrzés | $vezetoi_szoveg |
");
if (get_user_class() >= UC_MODERATOR){
$ell = mysql_query("SELECT `username` FROM `users` WHERE `id`=$row[ellenorizte]") or sqlerr(__FILE__,__LINE__);
$ell = mysql_fetch_assoc($ell);
$ellenorizte = $ell['username'];
if ($row['ellenorizte']>0 AND $CURUSER['id']==$row['ellenorizte'] AND $row['ellenorizve']!='yes'){
$staff = "| Staff |
|
";}
elseif ($row['ellenorizte']>0 AND $CURUSER['id']==$row['ellenorizte'] AND $row['ellenorizve']=='yes'){
$staff = "| Staff |
Elfogadtad a feltöltést helyesnek, már nem módosíthatsz rajta!
Ha mégis hiba van benne akkor köteles vagy te javítani a torrentet!
|
";
}
elseif($row['ellenorizte']>0 AND $CURUSER['id']!=$row['ellenorizte']){
$staff = "| Staff |
Lefoglalta: $ellenorizte
|
";
}
elseif($row['ellenorizte']==0){
$staff = "| Staff | |
";
}
print("$staff");}
//tr("Letöltések máshonnan", $row["save_as"]);
function hex_esc($matches) {
return sprintf("%02x", ord($matches[0]));
}
tr("Hash infó", preg_replace_callback('/./s', "hex_esc", hash_pad($row["info_hash"])));
if (!empty($row["descr"]))
tr("Leírás", str_replace(array("\n", " "), array("
\n", " "), format_comment(htmlspecialchars($row["descr"]))), 1);
if (get_user_class() >= UC_POWER_USER && $row["nfosz"] > 0)
print("| NFO | View NFO (" .
mksize($row["nfosz"]) . ") |
\n");
if ($row["visible"] == "no")
tr("Látható", "NEM (halott)", 1);
if ($moderator){
if ($row["banned"]=='yes')
$bannolt = "Igen";
else
$bannolt ="Nem";
tr("Tiltva", $bannolt);}
if($row['nuked']=="yes")
$kiemelt = "Igen";
else $kiemelt= "Nem";
print("| Tiltott | $kiemelt |
\n");
if (isset($row["cat_name"]))
tr("Típus", $row["cat_name"]);
else
tr("Típus", "(Nincs kiválasztva)");
tr("Utolsó seeder", "Utolsó aktivitás " . mkprettytime($row["lastseed"]) . " ezelőtt");
tr("Méret",mksize($row["size"]) . " (" . number_format($row["size"]) . " byte)");
$s = "";
$s .= "| ";
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 .= "Nincs egy szavazat sem";
}
else {
$rpic = ratingpic($row["rating"]);
if (!isset($rpic))
$s .= "invalid?";
else
$s .= "$rpic (" . $row["rating"] . " az 5-ből " . $row["numratings"] . " szavazat összesen)";
}
$s .= "\n";
$s .= " | $spacer | ";
if (!isset($CURUSER))
$s .= "(Log in to rate it)";
else {
$ratings = array(
5 => "Király!",
4 => "Jó",
3 => "Elmegy",
2 => "Gyenge",
1 => "Törölni kellene!",
);
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 .= "(Szavaztál erre a torrentre \"" . $xrow["rating"] . " - " . $ratings[$xrow["rating"]] . "\")";
else {
$s .= "\n";
}
}
}
$s .= " |
";
tr("Értékelés", $s, 1);
tr("Hozzáadva", $row["added"]);
tr("Megnézve", $row["views"]);
tr("Elkezdve", $row["hits"]);
print("| Letöltve | ".$row["times_completed"]." x |
\n");
// Totaltraffic mod
$data = mysql_query("SELECT (t.size * t.times_completed + SUM(p.downloaded)) AS data FROM torrents AS t LEFT JOIN peers AS p ON t.id = p.torrent WHERE p.seeder = 'no' AND p.torrent = '$id' AND times_completed > 0 GROUP BY t.id ORDER BY added ASC LIMIT 15") or sqlerr(__FILE__, __LINE__);
$a = mysql_fetch_assoc($data);
$data = mksize($a["data"]) . "";
tr("Teljese adatforgalom", $data);
if ($row[seeders] == 0) {
tr("Seed kérése", "Seed kéréséhez kattints IDE.", 1);
}
if ($row["times_completed"] != 0)
{
echo("| Utolsó 10 letöltő | ");
$res3 = mysql_query("SELECT snatched.userid,users.username,users.uploaded,users.downloaded FROM snatched inner
join users on snatched.userid = users.id inner join torrents on snatched.torrentid = torrents.id WHERE torrentid
=$id order by snatched.id desc LIMIT 10") or sqlerr();
$num = mysql_num_rows($res3);
for ($i = 0; $i < $num; ++$i)
{
$arr3 = mysql_fetch_assoc($res3);
if ($arr3["downloaded"] > 0)
{
$ratio = number_format($arr3["uploaded"] / $arr3["downloaded"], 2);
$ratio = "" . $arr3["username"] . " (" . $ratio . ")";
}
echo("" . $ratio . " ");
}
echo (" |
");
}
$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);
tr("Kész forrás", get_percent_completed_image(floor($progressTotal))." (".round($progressTotal)."%)", 1);
$keepget = "";
$uprow = (isset($row["username"]) ? ("" . htmlspecialchars($row["username"]) . "") : "Ismeretlen");
if ($owned)
$uprow .= " $spacer<$editlink>[Torrent szerkeztése]";
tr("Feltöltötte", $uprow, 1);
if ($row["type"] == "multi") {
if (!$_GET["filelist"])
tr("Fájlok
[Lista]", $row["numfiles"] . " fájl", 1);
else {
tr("Fájlok", $row["numfiles"] . " files", 1);
$s = "\n";
$subres = mysql_query("SELECT * FROM files WHERE torrent = $id ORDER BY id");
$s.="| Elérés | Méret |
\n";
while ($subrow = mysql_fetch_array($subres)) {
$s .= "| " . $subrow["filename"] .
" | " . mksize($subrow["size"]) . " |
\n";
}
$s .= "
\n";
tr("Fájl lista
[Lista elrejtése]", $s, 1);
}
}
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];
}
tr("Peers
[See full list]", $resarr["yes"] . " seeder(s), " . $resarr["no"] . " leecher(s) = $sum peer(s) total", 1);
*/
tr("Kapcsolatok
[Lista]", $row["seeders"] . " feltöltő, " . $row["leechers"] . " letötlő = " . ($row["seeders"] + $row["leechers"]) . " kapcsolat összesen", 1);
}
else {
$downloaders = array();
$seeders = array();
$subres = mysql_query("SELECT seeder, finishedat, downloadoffset, uploadoffset, ip, port, uploaded, downloaded, to_go, UNIX_TIMESTAMP(started) AS st, connectable, agent, peer_id, UNIX_TIMESTAMP(last_action) AS la, userid 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");
tr("Feltöltők
[Lista elrejtése]", dltable("Seeder(s)", $seeders, $row), 1);
tr("Letöltők
[Lista elrejtése]", dltable("Leecher(s)", $downloaders, $row), 1);
}
tr("Torrent bejelentése", "Kattints IDE ha a ezzel a torrentel szabályt sértettek", 1);
//.torrent file info link
if (get_user_class() >= UC_MODERATOR)
{
tr("Torrent Infó", "Torrent Infó", 1);
}
$torrentid = $_GET["id"];
$thanks_sql = mysql_query("SELECT * FROM thanks where torrentid=$torrentid");
$thanks_all = mysql_num_rows($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."$username_t, ";
}
$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") {
$thanksby = $thanksby." ";
}
else {
$thanksby = $thanksby." ";
}
}
else {
$thanksby = "Még senki nem köszönte meg! Légy te az első.
";
}
tr("Megköszönték",$thanksby,1);
print("
\n");
}
else {
//// complex snatchlist mod by rightthere, oink and thebrass recreated by cue////
if (get_user_class() >= UC_USER) {
$res3 = mysql_query("select count(snatched.id) from snatched inner join users on snatched.userid = users.id inner join torrents on snatched.torrentid = torrents.id where snatched.torrentid =" . $_GET[id]) or die(mysql_error());
$row = mysql_fetch_array($res3);
$count = $row[0];
$perpage = 15;
list($pagertop, $pagerbottom, $limit) = pager($perpage, $count, $_SERVER["PHP_SELF"] . "?id=" . $_GET[id] . "&" );
$res6 = mysql_query("select name, category from torrents where id = $_GET[id]");
$arr6 = mysql_fetch_assoc($res6);
$dt = gmtime() - 180;
$dt = sqlesc(get_date_time($dt));
print("