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

Welcome Guest! To enable all features please Login or Register

SaiDon
71% (Friendly)
YAF Lover Topic Starter

14 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

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

Sponsor

Kamyar
100% (Exalted)
YAF Developer

14 years ago

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

14 years ago

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

bbobb
100% (Exalted)
YAF Developer

14 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 14 years ago | Reason: Not specified

Important Information: