Les 5 derniers torrents :

query('SELECT blog_posts_seo.postID,blog_posts_seo.postHash,blog_posts_seo.postTitle,blog_posts_seo.postSlug,xbt_files.seeders,xbt_files.leechers FROM blog_posts_seo,xbt_files WHERE blog_posts_seo.postID = xbt_files.fid ORDER BY postID DESC LIMIT 5'); while($row = $stmt->fetch()){ echo ''; echo ' '; echo ''; } ?>

Nom du torrent	Seeders	Leechers
'.html($row['postTitle']).'	'.html($row['seeders']).'	'.html($row['leechers']).'

Les 5 torrents les plus populaires :

query('SELECT postSlug,postTitle,postAuthor,postDate,postViews FROM blog_posts_seo ORDER BY postViews DESC LIMIT 5'); while($row = $stmt->fetch()) { echo ''; echo ' '; echo ''; } ?>

Nom du torrent	Nb de vues
'.html($row['postTitle']).'	'.html($row['postViews']).'

query('SELECT blog_posts_seo.postID,blog_posts_seo.postHash,blog_posts_seo.postTitle,blog_posts_seo.postSlug,xbt_files.fid,xbt_files.seeders,xbt_files.leechers FROM blog_posts_seo,xbt_files WHERE blog_posts_seo.postID = xbt_files.fid AND xbt_files.seeders = 0 AND xbt_files.leechers > 0 ORDER BY postID DESC LIMIT 5'); $count = $stmt->rowCount(); if (!empty($count)) { ?>

Torrents qui ont besoin de seeds :

fetch()) { echo ''; echo ' '; echo ''; } ?>

Nom du torrent	Seeders	Leechers
'.html($row['postTitle']).'	'.html($row['seeders']).'	'.html($row['leechers']).'

Les 5 torrents les plus actifs :

query('SELECT blog_posts_seo.postID,blog_posts_seo.postHash,blog_posts_seo.postTitle,blog_posts_seo.postSlug,xbt_files.seeders,xbt_files.leechers FROM blog_posts_seo,xbt_files WHERE blog_posts_seo.postID = xbt_files.fid ORDER BY xbt_files.seeders DESC LIMIT 5'); while($row = $stmt->fetch()){ echo ''; echo ' '; echo ''; } ?>

Nom du torrent	Seeders	Leechers
'.html($row['postTitle']).'	'.html($row['seeders']).'	'.html($row['leechers']).'