From 3726b0b1cb45a00a301acea4daa19647d82489e2 Mon Sep 17 00:00:00 2001 From: Michael Andreen Date: Fri, 5 Jan 2007 20:05:36 +0000 Subject: [PATCH] order .laston by laston instead of last --- Usermgm.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Usermgm.pm b/Usermgm.pm index 99f3ec9..8939b80 100644 --- a/Usermgm.pm +++ b/Usermgm.pm @@ -114,7 +114,7 @@ sub laston { if (officer()){ my $f = $ND::DBH->prepare(qq{SELECT username,last - FROM (SELECT uid,username, date_part('day',now() - laston)::int AS last FROM users) u NATURAL JOIN groupmembers NATURAL JOIN groups WHERE flag = ? AND (last >= ? OR last IS NULL) ORDER BY last DESC + FROM (SELECT uid,username, date_part('day',now() - laston)::int AS last,laston FROM users) u NATURAL JOIN groupmembers NATURAL JOIN groups WHERE flag = ? AND (last >= ? OR last IS NULL) ORDER BY laston }); $min = 0 unless defined $min; $f->execute($flag,$min); -- 2.39.2