Home  >   Forum Home  >  ExpressionEngine Community Forums  >  "How to"  >  Thread
   
 
10 most commented post for week. How?
 
Erick Flatcher
Posted: 03 August 2007 09:48 AM   [ Ignore ]  
Summer Student
Total Posts:  30
Joined  11-13-2003

hola!

10 most commented post for week. How?

 Signature 

SLO.ru Software Magazine — My EE site grin

Profile
 
 
Derek Jones
Posted: 03 August 2007 10:10 AM   [ Ignore ]   [ # 1 ]  
Administrator
Avatar
RankRankRankRankRankRankRank
Total Posts:  17379
Joined  06-03-2002

Using the query module, you can fetch the url_title (or entry_id if you use those) and title where the most recent comment was made in the last week (604800 seconds), and order them in descending order of total comments, limited to 10 results.  Some conditionals help make a nice, concise, unordered list.

{exp:query sql="SELECT url_title, title FROM exp_weblog_titles WHERE recent_comment_date > (UNIX_TIMESTAMP() - 604800) ORDER BY comment_total DESC LIMIT 10"}
{if count == 1}<ul>{/if}
<li><a href="{path="template_group/template"}{url_title}">{title}</a></li>
{if count == total_results}</ul>{/if}
{/exp:query}
 Signature 
Profile
MSG
 
 
Erick Flatcher
Posted: 03 August 2007 10:17 AM   [ Ignore ]   [ # 2 ]  
Summer Student
Total Posts:  30
Joined  11-13-2003

ok, its work grin thx!

 Signature 

SLO.ru Software Magazine — My EE site grin

Profile
 
 
Derek Jones
Posted: 03 August 2007 10:28 AM   [ Ignore ]   [ # 3 ]  
Administrator
Avatar
RankRankRankRankRankRankRank
Total Posts:  17379
Joined  06-03-2002

I should add that if you want it to list from among ALL entries posted in the last week and not just entries which received comments the last week, you can use the weblog entries tag and orderby=“comment_total” with the start_on= parameter.

 Signature 
Profile
MSG
 
 
   
 
 
‹‹ Spell Check- compiling pspell support....      Links list with click tracker/counter? ››
Post Marker Legend
New Topic New posts Hot Topic Hot Topic with new posts New Poll New Poll Moved Topic Moved Topic Sticky Topic Sticky topic
Old Topic No new posts Hot Old Topic Hot Topic with no new posts Old Poll Old Poll Closed Topic Closed Topic Announcement Announcements
Theme
Change Theme
Visitor Statistics
The most visitors ever was 1149, on July 16, 2007 09:33 AM
Total Registered Members: 77577 Total Logged-in Users: 41
Total Topics: 101563 Total Anonymous Users: 18
Total Replies: 544414 Total Guests: 242
Total Posts: 645977    
Members ( View Memberlist )
Newest Members:  Mysticsage,  mauiwebdesigner,  sciapod,  volpoli,  tuttismith,  Mark2009,  Idril616,  tonybernard,  carterstarks,  ColeJLinski
Active Members:    BBYY,  beilz,  Chris Clarke,  cmw1,  Crucial,  cyrusshepard,  David Haigh,  DavidHarperTwo,  dreas,  dvancouver,  ellimondo,  Florian Fangohr,  Jeff Ricks,  jmorin,  jretzer,  jsks16,  Juliano Moreira,  leegreen,  Lisa Wess,  Marni Melrose,  Michael Byström,  Michael Hahn,  Mirage,  pcmeissner,  peak2peak,  Robb Ottenhoff,  ShawnStringfield,  Story+Structure LLC,  stubear,  Thierry Fortier,  visualchefs,  Werner Strydom
Powered By ExpressionEngine
ExpressionEngine Discussion Forum - Version 2.1.1 (20081028)
Script Executed in 0.3583 seconds
Atom Feed   RSS 2.0