SaiDon
  •  SaiDon
  • 71% (Friendly)
  • YAF Lover Topic Starter
2010-06-21T15:26:43Z
I am using 1.9.4 RC3. I'd like to know some statistics in my forum. Please help me

1. Who is receipted the most thank? or top 10?
2. The topic is read the most? or top 10?

Thanks
Sponsor
Kamyar
2010-06-21T16:53:57Z
Quote:

1. Who is receipted the most thank? or top 10?

To implement this, You should add a stored procedure to return most thanked users.
That would be:
Select * from YAF_User a Inner Join (Select Top(10) COUNT(ThanksToUserID) as ThanksNumber, ThanksToUserID From YAF_Thanks Group By ThanksToUserID) b on a.UserID = b.ThanksToUserID
Just take care of the UI and Yaf.Classes.Data.DB.cs definition of SP.
If at first you don’t succeed, call it version 1.0
SaiDon
  •  SaiDon
  • 71% (Friendly)
  • YAF Lover Topic Starter
2010-06-22T10:32:23Z
3. I'd like to know how many users did not use forum about 4 months.
bbobb
  •  bbobb
  • 100% (Exalted)
  • YAF Developer
2010-06-22T11:23:39Z
YAF has a bugtracker where you can post your feature requests.
Alternatively, you can order them http://www.tinygecko.com/Forum-Customization.aspx  or develop it himself and even share them with the community.

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