Minor change to user list display.HEADmaster

1 files changed, 11 insertions, 3 deletions

diff --git a/lib/account/list.php b/lib/account/list.php
index dcb6575..56392c0 100644
--- a/lib/account/list.php
+++ b/lib/account/list.php
@@ -6,18 +6,26 @@ $filters = array (
 			"reg_date" => "date registered",
 			"nbNotes" => "number of notes",
 		),
+	"cat" => array (
+		"WHERE nc.count != 0 OR pc.count != 0" => "interesting",
+		"" => "all",
+	),
 	"way" => $ord_ways,
 );
 $fdefaults = array (
 	"order" => "name",
 	"way" => "ASC",
+	"cat" => "WHERE nc.count != 0 OR pc.count != 0",
 );
 
 $users = array();
 $n = sql("SELECT account.id AS id, login AS name, nc.count AS nbNotes, pc.count AS nbPosts ".
 	"FROM account ".
-	"LEFT JOIN (SELECT notes.owner AS owner, COUNT(notes.id) AS count FROM notes WHERE notes.public != 0 GROUP BY notes.owner) nc ON nc.owner = account.id ".
-	"LEFT JOIN (SELECT blog_posts.owner AS owner, COUNT(blog_posts.id) AS count FROM blog_posts GROUP BY blog_posts.owner) pc ON pc.owner = account.id ".
-	"ORDER BY " . get_filter("order") . " " . get_filter("way"));
+	"LEFT JOIN (SELECT notes.owner AS owner, COUNT(notes.id) AS count FROM notes ".
+		"WHERE notes.public != 0 GROUP BY notes.owner) nc ON nc.owner = account.id ".
+	"LEFT JOIN (SELECT blog_posts.owner AS owner, COUNT(blog_posts.id) AS count FROM blog_posts ".
+		"GROUP BY blog_posts.owner) pc ON pc.owner = account.id ".
+	get_filter("cat") .
+	" ORDER BY " . get_filter("order") . " " . get_filter("way") . " ");
 while ($nn = mysql_fetch_assoc($n)) $users[] = $nn;
 require("tpl/account/list.php");