From 5fd9fa480f302902328b81f912dd67ce378284f8 Mon Sep 17 00:00:00 2001 From: citizenz7 Date: Thu, 20 Apr 2017 18:50:55 +0200 Subject: V.1.4.6 --- Html/infosite.php | 157 ++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 157 insertions(+) create mode 100644 Html/infosite.php (limited to 'Html/infosite.php') diff --git a/Html/infosite.php b/Html/infosite.php new file mode 100644 index 0000000..7e6ad6d --- /dev/null +++ b/Html/infosite.php @@ -0,0 +1,157 @@ + + + + +
+ + + +
+
+ + + +
+ +
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 torrentSeedersLeechers
'.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 torrentNb 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 torrentSeedersLeechers
'.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 torrentSeedersLeechers
'.html($row['postTitle']).''.html($row['seeders']).''.html($row['leechers']).'
+ +
+ + + +
+ + + +
+
+
+ + + + + -- cgit v1.2.1