adrian21 |
4th January 2009 18:02 |
List of all peers on tracker
Make a file called viewpeers.php and upload to your root
PHP Code:
<? require "include/bittorrent.php"; dbconn(); stdhead("Peerlist");
if (get_user_class() < UC_MODERATOR) { stdmsg("Sorry", "No permissions."); stdfoot(); exit; }
$count1 = number_format(get_row_count("peers")); print("<h2 align=center>Peerlist</h2>"); print("<center><font class=small>We have $count1 peers</font></center>"); print("<table width=80% border=1 cellspacing=0 cellpadding=10><tr><td class=text align=center>\n"); $res4 = mysql_query("SELECT COUNT(*) FROM peers $limit") or sqlerr(); $row4 = mysql_fetch_array($res4); $count = $row4[0]; $peersperpage = 15; list($pagertop, $pagerbottom, $limit) = pager($peersperpage, $count, "viewpeers.php?"); print("$pagertop"); $sql = "SELECT * FROM peers ORDER BY started DESC $limit"; $result = mysql_query($sql); if( mysql_num_rows($result) != 0 ) { print'<table width=100% border=1 cellspacing=0 cellpadding=5 align=center>'; print'<tr>'; print'<td class=colhead align=center>User</td>'; print'<td class=colhead align=center>Torrent</td>'; print'<td class=colhead align=center>IP</td>'; print'<td class=colhead align=center>Port</td>'; print'<td class=colhead align=center>Upl.</td>'; print'<td class=colhead align=center>Downl.</td>'; print'<td class=colhead align=center>Peer-ID</td>'; print'<td class=colhead align=center>Conn.</td>'; print'<td class=colhead align=center>Seeding</td>'; print'<td class=colhead align=center>Started</td>'; print'<td class=colhead align=center>LastAction</td>'; print'<td class=colhead align=center>Prev.Action</td>'; print'<td class=colhead align=center>UploadOffset</td>'; print'<td class=colhead align=center>DownloadOffset</td>'; print'<td class=colhead align=center>ToGo</td>'; print'</tr>'; while($row = mysql_fetch_assoc($result)) { $sql1 = "SELECT * FROM users WHERE id = $row[userid]"; $result1 = mysql_query($sql1); while ($row1 = mysql_fetch_assoc($result1)) { print'<tr>'; print'<td><a href="userdetails.php?id=' . $row['userid'] . '">' . $row1['username'] . '</a></td>'; $sql2 = "SELECT * FROM torrents WHERE id = $row[torrent]"; $result2 = mysql_query($sql2); while ($row2 = mysql_fetch_assoc($result2)) { $smallname =substr(htmlspecialchars($row2["name"]) , 0, 40); if ($smallname != htmlspecialchars($row2["name"])) { $smallname .= '...'; } #$smallname = htmlspecialchars($row2["name"]); print'<td><a href="details.php?id=' . $row['torrent'] . '">' . $smallname . '</td>'; print'<td align=center>' . $row['ip'] . '</td>'; print'<td align=center>' . $row['port'] . '</td>'; if ($row['uploaded'] < $row['downloaded']) print'<td align=center><font color=red>' . mksize($row['uploaded']) . '</font></td>'; else if ($row['uploaded'] == '0') print'<td align=center>' . mksize($row['uploaded']) . '</td>'; else print'<td align=center><font color=green>' . mksize($row['uploaded']) . '</font></td>'; print'<td align=center>' . mksize($row['downloaded']) . '</td>'; print'<td align=center>' . $row['peer_id'] . '</td>'; if ($row['connectable'] == 'yes') print'<td align=center><font color=green>' . $row['connectable'] . '</font></td>'; else print'<td align=center><font color=red>' . $row['connectable'] . '</font></td>'; if ($row['seeder'] == 'yes') print'<td align=center><font color=green>' . $row['seeder'] . '</font></td>'; else print'<td align=center><font color=red>' . $row['seeder'] . '</font></td>'; print'<td align=center>' . $row['started'] . '</td>'; print'<td align=center>' . $row['last_action'] . '</td>'; print'<td align=center>' . $row['prev_action'] . '</td>'; print'<td align=center>' . mksize($row['uploadoffset']) . '</td>'; print'<td align=center>' . mksize($row['downloadoffset']) . '</td>'; print'<td align=center>' . mksize($row['to_go']) . '</td>'; print'</tr>'; } } } print'</table>'; print("$pagerbottom"); } else { print'Nothing here :('; } print("</td></tr></table>\n");
stdfoot(); ?>
Enjoy
|