<?php

/**

* http://btdev.net:1337/svn/test/Installer09_Beta

* Licence Info: GPL

* Copyright (C) 2010 BTDev Installer v.1

* A bittorrent tracker source based on TBDev.net/tbsource/bytemonsoon.

* Project Leaders: Mindless,putyn.

**/

require_once(dirname(__FILE__) . DIRECTORY_SEPARATOR . 'include' . DIRECTORY_SEPARATOR . 'bittorrent.php');

require_once(INCL_DIR . 'user_functions.php');

require_once INCL_DIR . 'pager_functions.php';

dbconn();

loggedinorreturn();

$lang = array_merge(load_language('global'), load_language('snatches'));

$HTMLOUT = "";

$id = 0 + $_GET["id"];

if (!is_valid_id($id))

stderr("Error", "It appears that you have entered an invalid id.");

$res = sql_query("SELECT id, name FROM torrents WHERE id = " . sqlesc($id)) or sqlerr(__FILE__, __LINE__);

$arr = mysqli_fetch_assoc($res);

if (!$arr)

stderr("Error", "It appears that there is no torrent with that id.");

$res = sql_query("SELECT COUNT(*) FROM snatched WHERE torrentid =" . sqlesc($id)) or sqlerr(__FILE__, __LINE__);

$row = mysqli_fetch_row($res);

$count = intval($row[0]);

$perpage = 15;

$pager = pager($perpage, $count, "snatches.php?id=$id&amp;");

if (!$count)

stderr("No snatches", "It appears that there are currently no snatches for the torrent <a href='details.php?id=" . intval($arr['id']) . "'>$arr[name]</a>.");

$HTMLOUT .= "<h1>Snatches for torrent <a href='{$INSTALLER09['baseurl']}/details.php?id=" . intval($arr['id']) . "'>" . htmlspecialchars($arr['name']) . "</a></h1>\n";

$HTMLOUT .= "<h2>Currently " . intval($row[0]) . " snatch" . ($row[0] == 1 ? "" : "es") . "</h2>\n";

$HTMLOUT .= $pager['pagertop'];

$HTMLOUT .= "<table width='80%'border='0' cellspacing='0' cellpadding='5'>

<tr>

<td class='colhead' align='left'>{$lang['snatches_username']}</td>

<td class='colhead' align='center'>{$lang['snatches_connectable']}</td>

<td class='colhead' align='right'>{$lang['snatches_uploaded']}</td>

<td class='colhead' align='right'>{$lang['snatches_upspeed']}</td>

<td class='colhead' align='right'>{$lang['snatches_downloaded']}</td>

<td class='colhead' align='right'>{$lang['snatches_downspeed']}</td>

<td class='colhead' align='right'>{$lang['snatches_ratio']}</td>

<td class='colhead' align='right'>{$lang['snatches_completed']}</td>

<td class='colhead' align='right'>{$lang['snatches_seedtime']}</td>

<td class='colhead' align='right'>{$lang['snatches_leechtime']}</td>

<td class='colhead' align='center'>{$lang['snatches_lastaction']}</td>

<td class='colhead' align='center'>{$lang['snatches_completedat']}</td>

<td class='colhead' align='center'>{$lang['snatches_client']}</td>

<td class='colhead' align='center'>{$lang['snatches_port']}</td>

<td class='colhead' align='center'>{$lang['snatches_announced']}</td>

</tr>\n";

$res = sql_query("SELECT s.*, size, username, parked, warned, enabled, class, chatpost, leechwarn, timesann, donor FROM snatched AS s INNER JOIN users ON s.userid = users.id INNER JOIN torrents ON s.torrentid = torrents.id WHERE torrentid = " . sqlesc($id) . " ORDER BY complete_date DESC " . $pager['limit']) or sqlerr(__FILE__, __LINE__);

while ($arr = mysqli_fetch_assoc($res)) {

$upspeed = ($arr["upspeed"] > 0 ? mksize($arr["upspeed"]) : ($arr["seedtime"] > 0 ? mksize($arr["uploaded"] / ($arr["seedtime"] + $arr["leechtime"])) : mksize(0)));

$downspeed = ($arr["downspeed"] > 0 ? mksize($arr["downspeed"]) : ($arr["leechtime"] > 0 ? mksize($arr["downloaded"] / $arr["leechtime"]) : mksize(0)));

$ratio = ($arr["downloaded"] > 0 ? number_format($arr["uploaded"] / $arr["downloaded"], 3) : ($arr["uploaded"] > 0 ? "Inf." : "---"));

$completed = sprintf("%.2f%%", 100 * (1 - ($arr["to_go"] / $arr["size"])));

$HTMLOUT .= "<tr>

<td align='left'><a href='{$INSTALLER09['baseurl']}/userdetails.php?id=" . intval($arr['userid']) . "'>" . htmlspecialchars($arr['username']) . "</a></td>

<td align='center'>" . ($arr["connectable"] == "yes" ? "<font color='green'>Yes</font>" : "<font color='red'>No</font>") . "</td>

<td align='right'>" . mksize($arr["uploaded"]) . "</td>

<td align='right'>$upspeed/s</td>

<td align='right'>" . mksize($arr["downloaded"]) . "</td>

<td align='right'>$downspeed/s</td>

<td align='right'>$ratio</td>

<td align='right'>$completed</td>

<td align='right'>" . mkprettytime($arr["seedtime"]) . "</td>

<td align='right'>" . mkprettytime($arr["leechtime"]) . "</td>

<td align='center'>" . get_date($arr["last_action"], '', 0, 1) . "</td>

<td align='center'>" . get_date($arr["complete_date"], '', 0, 1) . "</td>

<td align='center'>" . htmlspecialchars($arr["agent"]) . "</td>

<td align='center'>" . intval($arr["port"]) . "</td>

<td align='center'>" . intval($arr["timesann"]) . "</td>

</tr>\n";

}

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

$HTMLOUT .= $pager['pagerbottom'];

echo stdhead('Snatches') . $HTMLOUT . stdfoot();

die;

?>