Gazelle/sections/torrents/peerlist.php

<?php
if (!isset($_GET['torrentid']) || !is_number($_GET['torrentid'])) {
	error(404);
}
$TorrentID = $_GET['torrentid'];

if (!empty($_GET['page']) && is_number($_GET['page'])) {
	$Page = $_GET['page'];
	$Limit = (string)(($Page - 1) * 100) .', 100';
} else {
	$Page = 1;
	$Limit = 100;
}

$Result = $DB->query("
	SELECT
		SQL_CALC_FOUND_ROWS
		xu.uid,
		t.Size,
		xu.active,
		xu.connectable,
		xu.uploaded,
		xu.remaining,
		xu.useragent
	FROM xbt_files_users AS xu
		LEFT JOIN users_main AS um ON um.ID = xu.uid
		JOIN torrents AS t ON t.ID = xu.fid
	WHERE xu.fid = '$TorrentID'
		AND um.Visible = '1'
	ORDER BY xu.uid = '$LoggedUser[ID]' DESC, xu.uploaded DESC
	LIMIT $Limit");
$DB->query('SELECT FOUND_ROWS()');
list($NumResults) = $DB->next_record();
$DB->set_query_id($Result);

?>
<h4>Peer List</h4>
<? if ($NumResults > 100) { ?>
<div class="linkbox"><?=js_pages('show_peers', $_GET['torrentid'], $NumResults, $Page)?></div>
<? } ?>

<table>
	<tr class="colhead_dark" style="font-weight: bold;">
		<td>User</td>
		<td>Active</td>
		<td>Connectable</td>
		<td class="number_column">Up (this session)</td>
		<td class="number_column">%</td>
		<td>Client</td>
	</tr>
<?
while (list($PeerUserID, $Size, $Active, $Connectable, $Uploaded, $Remaining, $UserAgent) = $DB->next_record()) {
?>
	<tr>
<?
	if (check_perms('users_mod')) {
?>
		<td><?=Users::format_username($PeerUserID, false, false, false)?></td>
<?	} else {
?>
		<td>Peer</td>
<?	}
?>
		<td><?=($Active) ? '<span style="color: green;">Yes</span>' : '<span style="color: red;">No</span>' ?></td>
		<td><?= ($Connectable) ? '<span style="color: green;">Yes</span>' : '<span style="color: red;">No</span>' ?></td>
		<td class="number_column"><?=Format::get_size($Uploaded) ?></td>
		<td class="number_column"><?=number_format(($Size - $Remaining) / $Size * 100, 2)?></td>
		<td><?=display_str($UserAgent)?></td>
	</tr>
<?
}
?>
</table>
<? if ($NumResults > 100) { ?>
<div class="linkbox"><?=js_pages('show_peers', $_GET['torrentid'], $NumResults, $Page)?></div>
<? } ?>