Drupal Most Popular Posts Block

I'm currently experimenting if and how presenting users links to other content of this site affects the site navigation (and how you may have guessed: Yes, I got myself a Google Analytics account, too). First I decided to display related articles beneath each articles. Now I'm trying a "Most popular" block that displays the top five pages visited within the last three days. Here's how I did it.

First, the Drupal statistics module must be enabled, since it will gather all the data for you. Second, I created a custom block and placed the following code within:

<?php $sql = "SELECT COUNT(path) AS hits, path, title FROM {accesslog} GROUP BY path, title having path like 'node/%' and path not like 'node/feed%' order by hits desc limit 5"; $rec = db_query($sql); $list = array(); while ($obj = db_fetch_object($rec)) {   $list[] = l($obj->title, $obj->path, array(), NULL, NULL, FALSE, TRUE); } print theme("item_list", $list); ?>

That's all. Dude, I like Drupal's block mechanisms. It's just so easy to add stuff to the navigation area.

Update: Added "and path not like 'node/feed%'" to the SQL to exclude Feeds.