Sean Reiser

I noticed that items from my activity stream were popping up in the last viewed (and potentially most popular content). As I'd rather not show these items I've changed statistics_title_list in drupal's statistics.module as follows:

function statistics_title_list($dbfield, $dbrows) {
return db_query_range(db_rewrite_sql("SELECT n.nid, n.title, u.uid, u.name FROM {node} n INNER JOIN {node_counter} s ON n.nid = s.nid INNER JOIN {users} u ON n.uid = u.uid WHERE %s <> '0' AND n.status = 1 and (n.type = 'story' OR n.type = 'page') ORDER BY %s DESC"), 's.'. $dbfield, 's.'. $dbfield, 0, $dbrows);
}

It's a simple change so I'm not posting the full module. When I get a round tu-it I'd make it selectable and then post the code.

Share and enjoy!