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/membres.php | 161 +++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 161 insertions(+) create mode 100644 Html/membres.php (limited to 'Html/membres.php') 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 @@ + + + + +
+ + + +
+
+ + + + + Votre compte est en cours de création.
Vous allez recevoir, par e-mail, un lien afin de l\'activer.
'; + } + + if(isset($_GET['action']) && $_GET['action'] == 'noexistmember'){ + echo '
Erreur : ce membre n\'existe pas.
'; + } + ?> + +
+
+

Rechercher un membre :

+
+ + +
+
+
+ +
+
Liste des membres :
+
+ + + + + + + + + + + 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 ''; + + if (!empty($row['avatar'])) { + echo ''; + } + else { + echo ''; + } + + sscanf($row['memberDate'], "%4s-%2s-%2s %2s:%2s:%2s", $annee, $mois, $jour, $heure, $minute, $seconde); + echo ''; + echo ''; + echo ''; + + if (intval($row["downloaded"])>0) { + $ratio=number_format($row["uploaded"]/$row["downloaded"],2); + } + else { + $ratio='∞'; + } + + echo ''; + echo ''; + + } + + + } catch(PDOException $e) { + echo $e->getMessage(); + } + ?> +
↑Pseudo↓↑Inscription le↓↑Envoyé↓↑Téléchargé↓Ratio
'.html($row['username']).''.html($row['username']).''.html($row['username']).''.html($row['username']).''.$jour.'-'.$mois.'-'.$annee.' à '.$heure.':'.$minute.':'.$seconde.''.makesize($row['uploaded']).''.makesize($row['downloaded']).''.$ratio.'
+ + page_links('?tri='.$tri.'&ordre='.$ordre.'&'); + ?> + +
+ + + +
+
+ + + + + + -- cgit v1.2.1