diff options
Diffstat (limited to 'Html/membres.php')
| -rw-r--r-- | Html/membres.php | 161 |
1 files changed, 161 insertions, 0 deletions
diff --git a/Html/membres.php b/Html/membres.php new file mode 100644 index 0000000..a91ed3c --- /dev/null +++ b/Html/membres.php @@ -0,0 +1,161 @@ +<?php +require_once('includes/config.php'); + +//Titre de la page +$pagetitle = 'Liste des membres'; + +//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'); ?> + + + <?php + //Message de création de compte... + if(isset($_GET['action']) && $_GET['action'] == 'activation'){ + echo '<div class="alert-msg rnd8 success">Votre compte est en cours de création.<br />Vous allez recevoir, par e-mail, un lien afin de l\'activer.</div>'; + } + + if(isset($_GET['action']) && $_GET['action'] == 'noexistmember'){ + echo '<div class="alert-msg rnd8 error">Erreur : ce membre n\'existe pas.</div>'; + } + ?> + + <br /> + <div style="text-align: center; border:1px ridge black;"> + <h3>Rechercher un membre :</h3> + <form action="<?php echo SITEURL; ?>/recherche-membres.php" method="post" id="rechercher" name="rechercher"> + <input type="text" alt="" name="requete" class="s" placeholder="Rechercher un membre ..."> + <input type="submit" alt="" value="Rechercher" class="searchsubmit formbutton"> + </form> + <br /> + </div> + + <br /> + <div style="text-align: center;"><span style="font-size: 14pt; font-weight: bold;">Liste des membres :</span></div> + <br /> + + <table> + <tr> + <th style="width: 250px;"><a style="color: #fff; text-decoration: none;" href="membres.php?tri=username&ordre=desc">↑</a>Pseudo<a style="color: #fff; text-decoration: none;" href="membres.php?tri=username&ordre=asc">↓</a></th> + <th><a style="color: #fff; text-decoration: none;" href="membres.php?tri=memberDate&ordre=desc">↑</a>Inscription le<a style="color: #fff; text-decoration: none;" href="membres.php?tri=memberDate&ordre=asc">↓</a></th> + <th style="text-align: center;"><a style="color: #fff; text-decoration: none;" href="membres.php?tri=uploaded&ordre=desc">↑</a>Envoyé<a style="color: #fff; text-decoration: none;" href="membres.php?tri=uploaded&ordre=asc">↓</a></th> + <th style="text-align: center;"><a style="color: #fff; text-decoration: none;" href="membres.php?tri=downloaded&ordre=desc">↑</a>Téléchargé<a style="color: #fff; text-decoration: none;" href="membres.php?tri=downloaded&ordre=asc">↓</a></th> + <th style="text-align: center;">Ratio</th> + </tr> + + <?php + try { + // On affiche 15 membres par page + $pages = new Paginator('15','p'); + + $stmt = $db->query('SELECT memberID FROM blog_members'); + $pages->set_total($stmt->rowCount()); + + // On met en place le tri + if(isset($_GET['tri'])) { + $tri = html($_GET['tri']); + } + else { + $memberID_tri = 'memberID'; + $tri = html($memberID_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('memberID','username', 'memberDate', 'uploaded', 'downloaded'))) { + 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_members,xbt_users WHERE blog_members.memberID=xbt_users.uid AND blog_members.username != "visiteur" AND blog_members.active = "yes" ORDER BY '.$tri.' '.$ordre.' '.$pages->get_limit()); + while($row = $stmt->fetch()){ + + echo '<tr>'; + + if (!empty($row['avatar'])) { + echo '<td style="font-weight: bold; font-size: 14px;"><img src="'.SITEURL.'/images/avatars/'.html($row['avatar']).'" alt="'.html($row['username']).'" style="float: left; margin-right: 5px; width: 30px; height: 30px;" /><a href="admin/profil.php?membre='.html($row['username']).'">'.html($row['username']).'</a></td>'; + } + else { + echo '<td style="font-weight: bold; font-size: 14px;"><img src="'.SITEURL.'/images/avatars/avatar.png" alt="'.html($row['username']).'" style="float: left; margin-right: 5px; width: 30px; height: 30px;" /><a href="admin/profil.php?membre='.html($row['username']).'">'.html($row['username']).'</a></td>'; + } + + sscanf($row['memberDate'], "%4s-%2s-%2s %2s:%2s:%2s", $annee, $mois, $jour, $heure, $minute, $seconde); + echo '<td style="font-size: 12px;">'.$jour.'-'.$mois.'-'.$annee.' à '.$heure.':'.$minute.':'.$seconde.'</td>'; + echo '<td style="text-align: center;">'.makesize($row['uploaded']).'</td>'; + echo '<td style="text-align: center;">'.makesize($row['downloaded']).'</td>'; + + if (intval($row["downloaded"])>0) { + $ratio=number_format($row["uploaded"]/$row["downloaded"],2); + } + else { + $ratio='∞'; + } + + echo '<td style="text-align: center;">'.$ratio.'</td>'; + echo '</tr>'; + + } + + + } catch(PDOException $e) { + echo $e->getMessage(); + } + ?> + </table> + + <?php + echo $pages->page_links('?tri='.$tri.'&ordre='.$ordre.'&'); + ?> + +</div> + + <?php + include_once 'sidebar.php'; + ?> + + <div class="clear"></div> + </div> +</div> + +<div id="footer"> + <?php + include_once 'includes/footer.php'; + ?> +</div> + +</body> +</html> |