Bug 240437: Add a "last seen date" column to the profiles table

r=LpSolit, a=LpSolit

1 files changed, 2 insertions, 1 deletions

diff --git a/editusers.cgi b/editusers.cgi
index 80c83f1c1..b4b86b880 100755
--- a/editusers.cgi
+++ b/editusers.cgi
@@ -64,7 +64,8 @@ if ($action eq 'search') {
     my $matchtype     = $cgi->param('matchtype');
     my $grouprestrict = $cgi->param('grouprestrict') || '0';
     my $enabled_only  = $cgi->param('enabled_only') || '0';
-    my $query = 'SELECT DISTINCT userid, login_name, realname, is_enabled ' .
+    my $query = 'SELECT DISTINCT userid, login_name, realname, is_enabled, ' .
+                $dbh->sql_date_format('last_seen_date', '%Y-%m-%d') . ' AS last_seen_date ' .
                 'FROM profiles';
     my @bindValues;
     my $nextCondition;