diff options
| -rw-r--r-- | lib/account/list.php | 14 |
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"); |