I've been trying to display some blocks that show the week's and month's most commented threads/nodes (separate block for each) using Views.
What I can do easily is
* filter to nodes commented on in the last week/month
* sort by number of comments descending
What I can't do is
* sort by number of comments posted in the last week/month descending
So my question is, can this be done w/Views (2)?
I have a feeling the answer is no, so the question then is, anybody know of a PHP snippet to do it?
I've looked this one over: http://drupal.org/node/202228
Can't really tell if it's on the right track or not and it's Drupal 5 so... not sure how useful it is in D6 for a guy who doesn't know his way around PHP well enough to update it.
Edit: actually, I think I understand what's happening there better than I thought and it appears to be doing the same thing I can already do in Views. Not really "most commented in the last week" but rather "most total comments that also were commented on in the last week"
I just don't know the proper way to write the query
Comments
subscribing
subscribing