By Mark H on Tuesday, 01 July 2014
Posted in General Issues
Likes 0
Views 0.9K
Votes 0
Hi,
I want to run weekly and monthly competitions, giving prizes to the most active participants on a given week or month. It would be good to have a leaderboard that shows 'This Week's Leaders' or 'This Month's Leaders'.

Has anyone done this? Any ideas on how to achieve this?

Also, another thing I would like to find a way to show is leaders of a particular type of points awarded. E.g. I run Jreviews and would like to show who has posted the most reviews each week. If this is not possible, perhaps someone has some SQL I can use?
Hello Mark,

I am sorry but unfortunately this is not possible currently.
·
Tuesday, 01 July 2014 23:31
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Mark,

Please can you email me with a price for creating a suitable module?

Thanks,

Mark.
·
Wednesday, 02 July 2014 00:05
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Mark,

I am really sorry but I am not really sure if we are in the position of accepting custom jobs because our hands are pretty tied to our existing development right now
·
Wednesday, 02 July 2014 12:16
·
0 Likes
·
0 Votes
·
0 Comments
·
In a way I'm glad to hear that. I'm happy that this means good things are coming!

Can you recommend anyone or anywhere to ask?
·
Wednesday, 02 July 2014 13:50
·
0 Likes
·
0 Votes
·
0 Comments
·
This is a great suggestion, add it to the voice section and I will vote on it. But I agree, development of EB 4.0 and ES 1.3 should take priority. The reason why this idea is great, is because currently points are rewarded for so many things, that people end up with 1000s of points within no time, so it is hard to play catch up. If you break it down into monthly, new members stand a chance
·
Wednesday, 02 July 2014 14:25
·
0 Likes
·
0 Votes
·
0 Comments
·
PLEASE VOTE FOR THIS FEATURE HERE:

http://stackideas.com/voices/easysocial/item/387

Thanks Jannik. I added your reasoning to the "Voices" submission.
·
Wednesday, 02 July 2014 22:28
·
0 Likes
·
0 Votes
·
0 Comments
·
sweet, I voted and commented on it hehe
·
Wednesday, 02 July 2014 22:37
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks for the vote Jannik!
·
Wednesday, 02 July 2014 22:51
·
0 Likes
·
0 Votes
·
0 Comments
·
Mark, Jannik made a very good point on my Voices submission.

Would it not be very easy for you guys to add some filters to the existing Leader Board module?
·
Wednesday, 02 July 2014 22:52
·
0 Likes
·
0 Votes
·
0 Comments
·
It's not that easy because we also need to take into consideration the expense of running complicated queries like this. Basically whenever it involves sql queries like "ranges" from xx date to yy date, it's an expensive query. I am just afraid that it will eventually lead to performance issues.

If we ever implement this, it has to be done right Otherwise we'll repeat the same mistakes we did on the stream and we're stuck in a dillema now
·
Wednesday, 02 July 2014 23:19
·
0 Likes
·
0 Votes
·
0 Comments
·
I am actually surprised to hear that, but I appreciate your attention to detail and focus on performance. I wish all developers put as much thought into these type of things as you do.
·
Wednesday, 02 July 2014 23:31
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Jannik,

Yeah, that's actually what happened to the stream but the stream is more complicated because we need to factor in on posts that you can see and posts that you can't see. It's extremely complicated but we just need to get this right. Even with the 1.2.18, we are not satisfied with the performance especially when you have over 300k activities. It's still slow

Our team is using up a lot of their time to optimize this because I know for a fact that some day, even if you have 500 - 1000 users on the site, it's pretty easy to hit 200k - 300k activities.
·
Wednesday, 02 July 2014 23:38
·
0 Likes
·
0 Votes
·
0 Comments
·
Ah I hear ya! Yeah I can only imagine. I appreciate your focus on performance and scalability. Luckily until now my main site has been in BETA/Development, but I have very big plans, and would like to feel confident that it can scale to accommodate a veery big user base. So by all means, continue optimizing the platform and carefully planning how to implement new features in the least resource heavy way.
·
Thursday, 03 July 2014 00:22
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks for understanding Jannik
·
Thursday, 03 July 2014 13:14
·
0 Likes
·
0 Votes
·
0 Comments
·
How close is this feature to being completed?
·
Wednesday, 14 January 2015 03:59
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Steve,

Currently we can't give you any estimation for completion. I am sorry, our hands are pretty tied with the existing development right now

Hope you can understand.
·
Wednesday, 14 January 2015 12:03
·
0 Likes
·
0 Votes
·
0 Comments
·
Thank you!
·
Wednesday, 14 January 2015 13:35
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi,

You're welcome.
·
Wednesday, 14 January 2015 14:10
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post