Change infrastructure for users, groups and channels

[ndwebbie.git] / lib / NDWeb / Controller / Forum.pm

diff --git a/lib/NDWeb/Controller/Forum.pm b/lib/NDWeb/Controller/Forum.pm
index a9a1f0d5dc98143bb3d37f8eea870ce947a10307..caeeb1cf99ca03e6f24a51ebac2d5fe26e5c82dc 100644 (file)
--- a/lib/NDWeb/Controller/Forum.pm
+++ b/lib/NDWeb/Controller/Forum.pm
@@ -33,7 +33,7 @@ SELECT fcid,category,fb.fbid,fb.board
        ,date_trunc('seconds',max(ft.mtime)::timestamp ) AS last_post
 FROM forum_categories fc
        JOIN forum_boards fb USING (fcid)
-       JOIN forum_threads ft USING (fbid)
+       LEFT OUTER JOIN forum_threads ft USING (fbid)
        LEFT OUTER JOIN (SELECT * FROM forum_thread_visits WHERE uid = $1)
                ftv USING (ftid)
 WHERE fbid IN (SELECT fbid FROM forum_access
@@ -472,7 +472,7 @@ sub findUsers : Private {
 
        my $query = $dbh->prepare(q{SELECT uid,username FROM users
                WHERE uid > 0 AND uid IN (SELECT uid FROM groupmembers)
-               ORDER BY LOWER(username)});
+               ORDER BY username});
        $query->execute;
 
        $c->stash(users => $query->fetchall_arrayref({}) );