Please help me have some statistics · YAF.NET Support Forum

SaiDon
71% (Friendly)
YAF Lover Topic Starter

12 years ago

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

Wanna join the discussion?! Login to your YAF.NET Support Forum forum account or Register a new forum account

Kamyar
100% (Exalted)
YAF Developer

12 years ago

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
71% (Friendly)
YAF Lover Topic Starter

12 years ago

3. I'd like to know how many users did not use forum about 4 months.

bbobb
100% (Exalted)
YAF Developer

12 years ago

YAF has a bugtracker where you can post your feature requests.
http://www.tinygecko.com/Forum-Customization.aspx or develop it himself and even share them with the community.

Edited by user 12 years ago | Reason: Not specified

Important Information:

The YAF.NET Support Forum uses cookies. By continuing to browse this site, you are agreeing to our use of cookies. More Details Close