Put the most frequently listed blogs at the top of the list

Anonymous (not verified) - March 15, 2005 - 21:45
Project:Blogroll
Version:4.5.x-1.x-dev
Component:Code
Category:feature request
Priority:minor
Assigned:Unassigned
Status:closed
Description

change the way the blog roll is ordered so that the most frequently listed blogs are at the top of the page.

To do this, change the "order by cnt" to decending.

Change line 197 to:
          $rolls = db_query_range('SELECT b.name, b.url, count(*) as cnt FROM {blogroll} b GROUP BY b.name, b.url ORDER BY cnt desc, b.name', 0, variable_get('blogroll_block_num', 5));

and

line 217 to:
  $rolls = db_query('SELECT b.name, b.url, count(*) as cnt FROM {blogroll} b GROUP BY b.name, b.url ORDER BY cnt desc, b.name');

changing "order by cnt" to decending to all the most frequently listed blogs to be at the top of the page.

#1

robbiethegeek - September 23, 2009 - 14:19
Status:active» closed

Just took over this module and closing issues that are over 2 years old that no longer apply this module was abandoned and is being restarted with a different focus.

 
 

Drupal is a registered trademark of Dries Buytaert.