| Posted by: SaiDon - Monday, 21 June 2010 17:26:43 |
|---|
| 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 |
| Posted by: Kamyar - Monday, 21 June 2010 18:53:57 |
|---|
| [quote]1. Who is receipted the most thank? or top 10?[/quote]To implement this, You should add a stored procedure to return most thanked users. That would be: [code]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[/code]Just take care of the UI and Yaf.Classes.Data.DB.cs definition of SP. |
| Posted by: SaiDon - Tuesday, 22 June 2010 12:32:23 |
|---|
| 3. I'd like to know how many users did not use forum about 4 months. |
| Posted by: bbobb - Tuesday, 22 June 2010 13:23:39 |
|---|
| 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. |