MonoX support board

Start the conversation, ask questions and share tips and solutions with fellow developers.

Non-registered users can only browse through our support boards. Please register now if you want to post your questions. It takes a second and it is completely free. Alternatively, you can log in without registration using your credentials at major sites such as Google, Microsoft Live, OpenId, Facebook, LinkedIn or Yahoo.

Sort users by their reputation  (Mono Support )

10799 put(a) pogledan, 4 odgovor(a) 4.3.2012. 2:34:32Kreirao(la) Mony11
Mony11

Mony11

4.3.2012. 2:34:32
we have limited options to sort users list. We would like to show users sorted based on overall reputation or yesterday's reputation
Ovaj sadržaj još nije ocijenjen. 
42 Reputacija 4 Ukupno objava
khorvat

khorvat

4.3.2012. 11:25:01
Hi,

can you please tell us to which module are you referring ? We need to know that so we can provide you with the guidance.

Regards
Ovaj sadržaj još nije ocijenjen. 
15993 Reputacija 2214 Ukupno objava
Mony11

Mony11

4.3.2012. 23:27:13
I would like to show the most active (top reputation) users (their name or ID and their reputation) list next to the MonoX Discussion Board. Also, at group page level, I would like to show a list of group's high reputation users (show their avatar)
Ovaj sadržaj još nije ocijenjen. 
42 Reputacija 4 Ukupno objava
khorvat

khorvat

17.3.2012. 0:36:05
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
Ovaj sadržaj još nije ocijenjen. 
15993 Reputacija 2214 Ukupno objava