prepare('SELECT postTitle FROM blog_posts_seo WHERE postHash = :hash');
$stmt->bindValue(':hash', $hash, PDO::PARAM_INT);
$stmt->execute();
$row = $stmt->fetch();
?>
Torrent :
| Pseudo |
Statut |
Client |
Port |
Téléchargé |
Uploadé |
Ratio |
Mis à jour |
prepare('
SELECT xal.id,xal.ipa,xal.port,xal.peer_id,xal.downloaded down,xal.uploaded up,xal.uid,xfu.mtime time,b.username, IF(xal.left0=0,"seeder","leecher") as status
FROM xbt_announce_log xal
LEFT JOIN blog_members b ON b.memberID = xal.uid
LEFT JOIN xbt_files xf ON xf.info_hash = xal.info_hash
LEFT JOIN blog_posts_seo bps ON bps.postID = xf.fid
LEFT JOIN xbt_files_users xfu ON xfu.fid = xf.fid
WHERE bps.postHash = :postHash AND xfu.active = 1 AND xal.mtime < (UNIX_TIMESTAMP() - 30)
GROUP BY xal.ipa
ORDER BY status DESC
');
$stmt->bindValue(':postHash', $hash, PDO::PARAM_INT);
$stmt->execute();
while($row = $stmt->fetch()) {
// on trouve le client bittorrent
$peer = substr($row['peer_id'], 1, 2);
if($peer == 'AZ') {
$client = 'Azureus';
}
if($peer == 'AX') {
$client = 'AnalogX';
}
elseif($peer == 'AG') {
$client = 'Ares';
}
if($peer == 'BB') {
$client = 'BitBuddy';
}
elseif($peer == 'BC') {
$client = 'BitComet';
}
elseif($peer == 'BP') {
$client = 'Bittorrent Pro';
}
elseif($peer == 'BT') {
$client = 'BBtor';
}
elseif($peer == 'DE') {
$client = 'Deluge Torrent';
}
elseif($peer == 'FX') {
$client = 'Freebox BitTorrent';
}
elseif($peer == 'HL') {
$client = 'Halite';
}
elseif($peer == 'HM') {
$client = 'hMule';
}
elseif($peer == 'IL') {
$client = 'iLivid';
}
elseif($peer == 'JT') {
$client = 'JavaTorrent';
}
elseif($peer == 'KT') {
$client = 'KTorrent';
}
elseif($peer == 'KG') {
$client = 'KGet';
}
elseif($peer == 'LT') {
$client = 'libTorrent';
}
elseif($peer == 'lt') {
$client = 'rTorrent';
}
elseif($peer == 'LP') {
$client = 'Lphant';
}
elseif($peer == 'LW') {
$client = 'LimeWire';
}
elseif($peer == 'MO') {
$client = 'MonoTorrent';
}
elseif($peer == 'MT') {
$client = 'MoonlightTorrent';
}
elseif($peer == 'NB') {
$client = 'Net::Bittorent';
}
elseif($peer == 'NX') {
$client = 'Net Transport';
}
elseif($peer == 'OS') {
$client = 'OneSwarm';
}
elseif($peer == 'OT') {
$client = 'Omega Torrent';
}
elseif($peer == 'PB') {
$client = 'Protocol::BitTorrent';
}
elseif($peer == 'PT') {
$client = 'PHPTracker';
}
elseif($peer == 'qB') {
$client = 'qBittorrent';
}
elseif($peer == 'SP') {
$client = 'BitSpirit';
}
elseif($peer == 'st') {
$client = 'Sharktorrent';
}
elseif($peer == 'SZ') {
$client = 'Shareaza';
}
elseif($peer == 'TB') {
$client = 'Torch';
}
elseif($peer == 'TIX') {
$client = 'Tixati';
}
elseif($peer == 'TL') {
$client = 'Tribler';
}
elseif($peer == 'TR') {
$client = 'Transmission';
}
elseif($peer == 'TS') {
$client = 'Torrentstorm';
}
elseif($peer == 'UM') {
$client = 'µTorrent for MAC';
}
elseif($peer == 'UT') {
$client = 'µTorrent';
}
elseif($peer == 'WD') {
$client = 'WebTorrent Desktop';
}
elseif($peer == 'WT') {
$client = 'BitLet';
}
elseif($peer == 'WW') {
$client = 'WebTorrent';
}
elseif($peer == 'WY') {
$client = 'FireTorrent';
}
elseif($peer == 'XT') {
$client = 'XanTorrent';
}
elseif($peer == 'XX') {
$client = 'Xtorrent';
}
elseif($peer == 'ZT') {
$client = 'ZipTorrent';
}
else {
$client = 'Client inconnu';
}
echo '';
echo '| '.html($row['username']).' | ';
if ($row['status'] == 'leecher') {
echo 'leecher | ';
}
elseif ($row['status'] == 'seeder') {
echo 'seeder | ';
}
echo ''.$client.' | ';
echo ''.$row['port'].' | ';
echo ''.makesize($row['down']).' | ';
echo ''.makesize($row['up']).' | ';
//Peer Ratio
if (intval($row["down"])>0) {
$ratio=number_format($row["up"]/$row["down"],2);
}
else {
$ratio='∞';
}
echo ''.$ratio.' | ';
echo ''.get_elapsed_time($row['time']).' | ';
echo '
';
}
?>