Remove syndicated feeds from the stats page recently active list.
Patch by yvi.
diffs (12 lines):
diff -r a4e4f69edca5 -r 93a78ab9062d htdocs/stats.bml
--- a/htdocs/stats.bml Tue Jan 05 22:44:53 2010 +0000
+++ b/htdocs/stats.bml Tue Jan 05 22:47:01 2010 +0000
@@ -89,7 +89,7 @@ body<=
{
$ret .= "<h1>$ML{'.recent.header'}</h1>";
$ret .= "<p>$ML{'.recent.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 > DATE_SUB(NOW(),
INTERVAL 30 DAY) ORDER BY uu.timeupdate 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 > DATE_SUB(NOW(),
INTERVAL 30 DAY) AND u.journaltype <> 'Y' ORDER BY uu.timeupdate DESC LIMIT 10"
);
$sth->execute;
my $ct;
while (my ($iuser, $iname, $itime) = $sth->fetchrow_array) {
_______________________________________________
dw-changelog mailing list
[email protected]
http://lists.dwscoalition.org/mailman/listinfo/dw-changelog
