From e400bf854d1da7e70ea9e78838f82a9bbfe03249 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 --- ND/IRC/Usermgm.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/ND/IRC/Usermgm.pm b/ND/IRC/Usermgm.pm index 99f3ec9..8939b80 100644 --- a/ND/IRC/Usermgm.pm +++ b/ND/IRC/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