#1
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
Topic Starter
  • Dimi
  • Rank: YAF All-the-Time
  • Reputation:
    Exalted
    100%
  • Joined: 16/01/2011
  • Posts: 211
  • Thanks: 59 times
  • Was thanked: 2 time(s) in 2 post(s)
#2
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 
  • RichP714
  • Rank: YAF All-the-Time
  • Reputation:
    Exalted
    100%
  • Medals:
    YAF.NET Supporter: Loves YAF.NET!YAF.NET Red Supporter: Thank you Rich for supporting YAF.NET!YAF.NET Supporter: Supports our efforts. Thank you.
  • Joined: 20/01/2009
  • Posts: 262
  • Thanks: 19 times
  • Was thanked: 20 time(s) in 17 post(s)
#3
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
Topic Starter
  • Dimi
  • Rank: YAF All-the-Time
  • Reputation:
    Exalted
    100%
  • Joined: 16/01/2011
  • Posts: 211
  • Thanks: 59 times
  • Was thanked: 2 time(s) in 2 post(s)
#4
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.
  • Zero2Cool
  • Rank: YAF Leader
  • Reputation:
    Exalted
    100%
  • Medals:
    Medal of Honor for the Support Knight: Given to a community member who has assisted lots and lots of people!
  • Joined: 26/04/2011
  • Posts: 1,074
  •  Man  United States
  • Location: in a van down by the river
  • Thanks: 243 times
  • Was thanked: 101 time(s) in 92 post(s)
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