diff options
| author |   Byron Jones <bjones@mozilla.com> | 2012-01-24 15:13:22 +0800 |
|---|---|---|
| committer | Byron Jones <bjones@mozilla.com> | 2012-01-24 15:13:22 +0800 |
| commit | 0284798a8cc4987c84805634a7a84d5d853a2168 (patch) | |
| tree | c81fd47c1fadd9abb335c618959ac227107efb8e /editusers.cgi | |
| parent | Bug 319953: Missing real email syntax check (diff) | |
| download | bugzilla-0284798a8cc4987c84805634a7a84d5d853a2168.tar.gz bugzilla-0284798a8cc4987c84805634a7a84d5d853a2168.tar.bz2 bugzilla-0284798a8cc4987c84805634a7a84d5d853a2168.zip | |
Bug 240437: Add a "last seen date" column to the profiles table
r=LpSolit, a=LpSolit
Diffstat (limited to 'editusers.cgi')
| -rwxr-xr-x | editusers.cgi | 3 |
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; |