[dw-free] remove feed accounts from "recently created" on stats page

[fu]

[commit: http://hg.dwscoalition.org/dw-free/rev/0184d8f43b3d]

http://bugs.dwscoalition.org/show_bug.cgi?id=3602

Don't list feed accounts under the "New accounts" section.

Patch by denise.

Files modified:

• htdocs/stats.bml

--------------------------------------------------------------------------------
diff -r 6c0f33d1e44b -r 0184d8f43b3d htdocs/stats.bml
--- a/htdocs/stats.bml	Mon Aug 22 14:04:50 2011 -0500
+++ b/htdocs/stats.bml	Tue Aug 23 11:50:12 2011 +0800
@@ -118,7 +118,7 @@
  {
      $ret .= "<h1>$ML{'.new.header'}</h1>";
      $ret .= "<p>$ML{'.new.desc'}</p><ul>";
-     $sth = $dbr->prepare("SELECT u.user, u.name, uu.timeupdate FROM user u, userusage uu WHERE u.userid=uu.userid AND uu.timeupdate IS NOT NULL ORDER BY uu.timecreate DESC LIMIT 10");
+     $sth = $dbr->prepare("SELECT u.user, u.name, uu.timeupdate FROM user u, userusage uu WHERE u.userid=uu.userid AND uu.timeupdate IS NOT NULL AND u.journaltype <> 'Y' ORDER BY uu.timecreate DESC LIMIT 10");
      $sth->execute;
      my $ct;
      while (my ($iuser, $iname, $itime) = $sth->fetchrow_array) {
--------------------------------------------------------------------------------