Hi,
you should create a query (LLBLGen, LINQ etc.) that will select SUM of rating field from SnRating table and that will filter by the section you need over the SnRelationship table, by section I mean the discussion tables like SnDiscussionTopic, SnDiscussionMessage. In your case you should probably use the SnDiscussionMessage as users in forum rate the actual posts (messages) so you want to sum that rating in overall user rating for discussion.
For group reputation web part you should use the same technique but you should also include the AlbumId, SnFileId from the SnRelationship table as user can rate photo albums and photos from the group.
Let us know if you need more information.
Regards
This content has not been rated yet.
15993
Reputation
2214
Total posts