Dimi
  • Posts: 211
  • Joined: 16/01/2011
How can we find a list of the most popular postings - i.e. with the most "read" numbers? If we don't have this feature it would be great to get it. I think the forum keeps this info on the database, so it's just one query to get it ordered by this number DESC and show. Although the links to these topics/postings would be helpful as well.
Dimi
UserPostedImage
Sponsor
RichP714
  • Posts: 262
  • Joined: 20/01/2009
Also, 'most thanked' would be a great feature to show the forum's 'best posts'
Enjoy!

Running YAF 1.9.5.5 final at: http://thecarversite.com 
Dimi
  • Posts: 211
  • Joined: 16/01/2011
One more thing - the most popular Topic on my forum is :Forum FAQ: :cheesy: The 5-th place is taken by "Forum Rules".

Here is how I got it:

SELECT TOP 25 *
FROM [HappyAnkle].[dbo].[yaf_Topic]
ORDER BY [Views] DESC

So it looks like we need a way to exclude some topics from this rating.
Dimi
UserPostedImage
Zero2Cool
  • Posts: 1082
  • Joined: 26/04/2011
You can see this SQL query (with a WHERE clause for time frame) on my site.
http://packershome.com/Top10.aspx 

I've renamed Thanks to Applause.
SELECT TOP 10 COUNT([MessageID]) as 'Applause', [yaf_User].[Name] as 'Member' 
FROM [yaf_Thanks] 
INNER JOIN [yaf_User]
ON [yaf_Thanks].[ThanksToUserID] = [yaf_User].[UserID]
GROUP BY [yaf_Thanks].[MessageID], [yaf_User].[Name]
ORDER BY COUNT([MessageID]) DESC


This query just shows the top 10 Thanked posts along with the member name by the amount of times it was Thanked.
Users browsing this topic
    Forum Jump  
    • You cannot post new topics in this forum.
    • You cannot reply to topics in this forum.
    • You cannot delete your posts in this forum.
    • You cannot edit your posts in this forum.
    • You cannot create polls in this forum.
    • You cannot vote in polls in this forum.

    About Us

    The YAF.NET is an open source .NET forum project. YAF.NET is supported by an team of international developers who are build community by building community software.

    Powered by Resharper Donate with PayPal button

    Project Twitter Updates

    Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved