diff options
Diffstat (limited to 'Html/torrents.php')
| -rw-r--r-- | Html/torrents.php | 182 |
1 files changed, 182 insertions, 0 deletions
diff --git a/Html/torrents.php b/Html/torrents.php new file mode 100644 index 0000000..77b73c7 --- /dev/null +++ b/Html/torrents.php @@ -0,0 +1,182 @@ +<?php +require_once('includes/config.php'); + +//Titre de la page +$pagetitle = 'Liste des torrents'; + +//Stats : bbclone +define("_BBC_PAGE_NAME", $pagetitle); +define("_BBCLONE_DIR", "bbclone/"); +define("COUNTER", _BBCLONE_DIR."mark_page.php"); +if (is_readable(COUNTER)) include_once(COUNTER); + +include_once('includes/header.php'); +?> + +<body> + +<div id="container"> + + <?php + include_once('includes/header-logo.php'); + include_once('includes/nav.php'); + ?> + + <div id="body"> + <div id="content"> + + <?php include_once('includes/ariane.php'); ?> + + <br /> + + <div style="text-align: center;"><span style="font-size: 14pt; font-weight: bold;">Liste des torrents :</span></div> + <br /> + + <?php + // On affiche : torrent ajouté ! + if(isset($_GET['action']) && $_GET['action'] == 'ajoute') { + echo '<div class="alert-msg rnd8 success">Le torrent a été ajouté avec succès !</div>'; + } + + // Pas d'accès direct à la page download sans file ID + if(isset($_GET['action']) && $_GET['action'] == 'nodirect') { + echo '<div class="alert-msg rnd8 error">ERREUR :<br />Vous ne pouvez pas accéder directement à cette page sans préciser le torrent à télécharger...</div>'; + } + + // Pas d'accès à la page download si le file ID n'existe pas + if(isset($_GET['action']) && $_GET['action'] == 'noexist') { + echo '<div class="alert-msg rnd8 error">ERREUR :<br />Ce torrent n\'existe pas !</div>'; + } + + //On affiche le message de suppression + if(isset($_GET['delpost'])){ + echo '<div class="alert-msg rnd8 success">Le torrent a été supprimé avec succès.</div>'; + } + ?> + + <table> + <tr> + <th style="width:50%;"><a style="color: #fff; text-decoration: none;" href="torrents.php?tri=postTitle&ordre=desc">↑</a>Nom<a style="color: #fff; text-decoration: none;" href="torrents.php?tri=postTitle&ordre=asc">↓</a></th> + <th style="text-align: center; width: 8%;"><a style="color: #fff; text-decoration: none;" href="torrents.php?tri=postTaille&ordre=desc">↑</a>Taille<a style="color: #fff; text-decoration: none;" href="torrents.php?tri=postTaille&ordre=asc">↓</a></th> + <th style="text-align: center; width: 8%;"><a style="color: #fff; text-decoration: none;" href="torrents.php?tri=postDate&ordre=desc">↑</a>Ajouté<a style="color: #fff; text-decoration: none;" href="torrents.php?tri=postDate&ordre=asc">↓</a></th> + <!-- <th style="text-align: center;"><a style="color: #fff; text-decoration: none;" href="torrents.php?tri=postAuthor&ordre=desc">↑</a>Par<a style="color: #fff; text-decoration: none;" href="torrents.php?tri=postAuthor&ordre=asc">↓</a></th> --> + <th style="text-align: center; width: 20%;">Catégorie(s)</th> + <th style="text-align: center;"><a style="color: #fff; text-decoration: none;" href="torrents.php?tri=seeders&ordre=desc">↑</a>S<a style="color: #fff; text-decoration: none;" href="torrents.php?tri=seeders&ordre=asc">↓</a></th> + <th style="text-align: center;"><a style="color: #fff; text-decoration: none;" href="torrents.php?tri=leechers&ordre=desc">↑</a>L<a style="color: #fff; text-decoration: none;" href="torrents.php?tri=leechers&ordre=asc">↓</a></th> + <th style="text-align: center;"><a style="color: #fff; text-decoration: none;" href="torrents.php?tri=completed&ordre=desc">↑</a>T<a style="color: #fff; text-decoration: none;" href="torrents.php?tri=completed&ordre=asc">↓</a></th> + </tr> + <?php + try { + // On affiche 15 torrents par page + $pages = new Paginator(NBTORRENTS,'page'); + + $stmt = $db->query('SELECT postHash FROM blog_posts_seo'); + $pages->set_total($stmt->rowCount()); + + + // On met en place le tri-------------------------------------------- + if(isset($_GET['tri'])) { + $tri = html($_GET['tri']); + } + else { + $post_tri = 'postDate'; + $tri = html($post_tri); + } + + if(isset($_GET['ordre'])) { + $ordre = html($_GET['ordre']); + } + else { + $ordre_tri = 'desc'; + $ordre = html($ordre_tri); + } + + // Protection du tri ----------------------------------------------- + if (!empty($_GET['tri']) && !in_array($_GET['tri'], array('postID','postHash', 'postTitle', 'postViews', 'postTaille', 'postDate', 'postAuthor', 'seeders', 'leechers', 'completed'))) { + header('Location: index.php'); + exit(); + } + if (!empty($_GET['ordre']) && !in_array($_GET['ordre'], array('asc','desc','ASC','DESC'))) { + header('Location: index.php'); + exit(); + } + + + $stmt = $db->query('SELECT * FROM blog_posts_seo b LEFT JOIN xbt_files x ON x.fid = b.postID ORDER BY '.$tri.' '.$ordre.' '.$pages->get_limit()); + + while($row = $stmt->fetch()){ + + $stmt2 = $db->prepare('SELECT catTitle, catSlug FROM blog_cats, blog_post_cats WHERE blog_cats.catID = blog_post_cats.catID AND blog_post_cats.postID = :postID ORDER BY catTitle ASC'); + $stmt2->execute(array(':postID' => $row['postID'])); + + $catRow = $stmt2->fetchAll(PDO::FETCH_ASSOC); + + echo '<tr>'; + echo '<td style="font-size: 14px; font-weight: bold;"><img src="'.SITEURL.'/images/imgtorrents/'.$row['postImage'].'" style="width:25px; height:25px; vertical-align:middle;" alt="" /> <a style="text-decoration:none; color:black;" href="'.html($row['postSlug']).'">'.html($row['postTitle']).'</a>'; + echo '</td>'; + echo '<td style="text-align: center; font-size: 9px;">'; + echo html(makesize($row['postTaille'])); + echo '</td>'; + + sscanf($row['postDate'], "%4s-%2s-%2s %2s:%2s:%2s", $annee, $mois, $jour, $heure, $minute, $seconde); + echo '<td style="text-align: center; font-size: 7pt;">'.$jour.'-'.$mois.'-'.$annee.'</td>'; + + //echo '<td style="font-size: 8pt; text-align: center;"><a style="text-decoration: none;" href="admin/profil.php?membre='.html($row['postAuthor']).'">'.html($row['postAuthor']).'</a></td>'; + + $links = array(); + foreach ($catRow as $cat) { + $links[] = '<a style="text-decoration: none;" href="c-'.$cat['catSlug'].'">'.$cat['catTitle'].'</a>'; + } + + $max = 120; + $chaine = implode(", ", $links); + if (strlen($chaine) >= $max) { + $chaine = substr($chaine, 0, $max); + $espace = strrpos($chaine, ", "); + $chaine = substr($chaine, 0, $espace).' ...'; + } + + echo '<td style="text-align: center; font-size: 10px; line-height: 120%;">'.$chaine.'</td>'; + + $exa = '0x'; + $hash = $exa.$row['postHash']; + + $stmt3 = $db->prepare('SELECT * FROM blog_posts_seo,xbt_files WHERE blog_posts_seo.postHash = :postHash AND xbt_files.info_hash = '.$hash); + $stmt3->execute(array(':postHash' => $row['postHash'])); + $xbt = $stmt3->fetch(); + + echo '<td style="text-align:center;"><a style="text-decoration: none; color:green; font-size:14px; font-weight:bold;" href="peers.php?hash='.html($row['postHash']).'">'.$xbt['seeders'].'</a></td>'; + echo '<td style="text-align:center;"><a style="text-decoration: none; color:red; font-size:14px; font-weight:bold;" href="peers.php?hash='.html($row['postHash']).'">'.$xbt['leechers'].'</a></td>'; + echo '<td style="text-align:center; font-size: 8pt;">'.$xbt['completed'].'</td>'; + + echo '</tr>'; + } + + + } catch(PDOException $e) { + echo $e->getMessage(); + } + ?> + </table> + + <br /> + + <?php echo $pages->page_links('?tri='.$tri.'&ordre='.$ordre.'&'); ?> + + <br /> + <p class="edito" style="font-size: 10px; font-style: italic;"><span style="font-weight: bold;">Légende :</span> S = Nb de Seeders, L = Nb de Leechers, T = Nb de Téléchargements</p> + +</div> + + <?php include_once('sidebar.php'); ?> + + <div class="clear"></div> + </div> +</div> + +<div id="footer"> + <?php include_once('includes/footer.php'); ?> +</div> + +</body> +</html> |