Dimi
  •  Dimi
  • 100% (Exalted)
  • YAF All-the-Time Topic Starter
2011-04-26T09:24:24Z
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
2011-04-26T21:10:02Z
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
  •  Dimi
  • 100% (Exalted)
  • YAF All-the-Time Topic Starter
2011-05-06T05:43:16Z
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
2012-10-23T12:53:42Z
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.

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