YAFLogo

Dimi
  • Dimi
  • 100% (Exalted)
  • YAF All-the-Time Topic Starter
13 years ago
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

View All Posts by User
Sponsor
RichP714
  • RichP714
  • 100% (Exalted)
  • YAF All-the-Time
13 years ago
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 

View All Posts by User
Dimi
  • Dimi
  • 100% (Exalted)
  • YAF All-the-Time Topic Starter
13 years ago
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

View All Posts by User
Zero2Cool
  • Zero2Cool
  • 100% (Exalted)
  • YAF Leader YAF Version: YAF 3.1.16
12 years ago
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.

View All Posts by User
Similar Topics
Users browsing this topic