From 8d9321225140a3db0b72796d4d0236d6cacfeb8a Mon Sep 17 00:00:00 2001
From: Nicolas BERNSTEIN <alexis211@gmail.com>
Date: Sat, 17 Sep 2011 19:36:41 +0200
Subject: Started working on a study program.

---
 lib/notes/index.php | 14 +++++++++++++-
 1 file changed, 13 insertions(+), 1 deletion(-)

(limited to 'lib/notes/index.php')

diff --git a/lib/notes/index.php b/lib/notes/index.php
index 3c81f46..3089605 100644
--- a/lib/notes/index.php
+++ b/lib/notes/index.php
@@ -1,9 +1,21 @@
 <?php
 
+$filters = array (
+	"order" => array (
+			"nbNotes" => "number of notes",
+			"name" => "username",
+		),
+	"way" => $ord_ways,
+);
+$fdefaults = array (
+	"order" => "nbNotes",
+	"way" => "DESC",
+);
+
 $users = array();
 $n = sql("SELECT account.id AS id, login AS name, COUNT(notes.id) AS nbNotes FROM account ".
 	"LEFT JOIN notes ON notes.owner = account.id ".
 	"WHERE notes.public != 0 AND notes.id != 0 ".
-	"GROUP BY account.id ORDER BY nbNotes DESC");
+	"GROUP BY account.id ORDER BY " . get_filter("order") . " " . get_filter("way"));
 while ($nn = mysql_fetch_assoc($n)) $users[] = $nn;
 require("tpl/notes/index.php");
-- 
cgit v1.2.3