The list of top contributors on the language landing page is a very good idea, and will hopefully inspire to some friendly competition to try to get to the top of the list. In order to encourage new arrivals, and to encourage veteran translators not to rest on their laurels, I suggest the list gives information about, and is sorted by, recent contributions. For instance:
People with most approved translations
- newandrisingstar - 400 translations last 30 days (400 total)
- anothertranslator - 398 translations last 30 days (1257 total)
- oldveteran - 0 translations last 30 days (3456 total)
It would also be an encouragement to see recent progress in the "Progress status" box, so:
- 3511 translations recorded (798 last 30 days)
The chosen chunk of time need not be exactly 30 days, of course, that's just a reasonably round number which seems about right.
Comments
Comment #1
Gábor HojtsyWell, great idea. I'd love to add such a feature, so looking into whoever help implementing it :)
Comment #2
dami CreditAttribution: dami commentedAlong the line of encouraging new contributors, it may be helpful to display a 'Most suggestions submitted' block as well.
It'd also be useful to have a kind of acknowledgment page, where all contributors are listed (display user name along with how many suggestions were submitted by the user, and how many were approved etc.)
Comment #3
pvasili CreditAttribution: pvasili commented2 zirvap You can not get all the data.
What do you want to get? Write to the(you) task. I try to make a snippet ;)
See: http://drupaler.ru/translate (at the bottom), http://drupaler.ru/translate/heroes, #200927: Some statistics ;)
Comment #4
zirvap CreditAttribution: zirvap commentedThanks for the offer, and sorry for being so late to answer!
Could you make a snippet which will show how many translations each user has added during the last 30 days?
It does not have to be exactly 30 days, if some other amount of time would be easier to count. For instance, if it's easier to count translations for the current month that would be fine.
I also like http://drupaler.ru/translate/heroes -- how did you make that?
Comment #5
pvasili CreditAttribution: pvasili commentedThis code for all user:
and for 30 days
Comment #6
zirvap CreditAttribution: zirvap commentedThanks! :-)
I didn't get it to work with "WEEKS" but "DAYS" worked fine.
Comment #7
pvasili CreditAttribution: pvasili commentedTry WEEK (not WEEKS). (see at http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html)
Comment #8
meba CreditAttribution: meba commentedI have looked into this and maybe in regard to this late time, I think it is not easy to determine this together. I would suggest to do 2 blocks:
- Top contributors
- Top contributors over 30 days
What do you think?
Comment #9
zirvap CreditAttribution: zirvap commentedI think that sounds fine.
Comment #10
Gábor HojtsyThese SQL queries tie the module to MySQL explicitly. Although there might be MySQL only constructs in the module already, it does not seem hard to skip MySQL only functions here. time_entered is a Unix timestamp, so substracting 30*24*60*60 from time() is doable in PHP and this constant can be used for comparing to time_entered.
Comment #11
Gábor HojtsyIf people are still interested, it would be good to put this code to a patch with the above suggestions implemented. Looks like a worthwile thing to empower hopefully more contributors.
Comment #12
franz+1 to extended stats