From 0284798a8cc4987c84805634a7a84d5d853a2168 Mon Sep 17 00:00:00 2001
From: Byron Jones <bjones@mozilla.com>
Date: Tue, 24 Jan 2012 15:13:22 +0800
Subject: Bug 240437: Add a "last seen date" column to the profiles table
 r=LpSolit, a=LpSolit

---
 editusers.cgi | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'editusers.cgi')

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;
-- 
cgit v1.2.3-24-g4f1b