Re: [libreoffice-website] Small typo and credits in Credits page

Hi,

On Fri, Mar 7, 2014 at 8:12 PM, Christian Lohmaier
<lohmaier+ooofuture@googlemail.com> wrote:
> Hi Valter, *,
>
> On Fri, Mar 7, 2014 at 9:10 AM, Valter Mura <valtermura@libreoffice.org> wrote:
> > in the new http://www.libreoffice.org/about-us/credits/
> >
> > "Wiki Contribuitors" should be "Wiki Contributors"
>
> Thanks, fixed.
>
> > I cannot see, in the same page, credits for Translators/Revisers that give
> > contribution in Pootle/inside SilverStripe, if planned.
>
> The problem is that there's no easy way to get that info. In pootle we
> only have only the registered users, and no way to tell whether they
> are active or not, whether they registered without doing anything.

On the other hand, we could craft queries to the Pootle database, the
information is there, just not presentable by the web interface. For
example I had a query, which listed the top 50 translators.

mysql> SELECT username, first_name, last_name, email, count(*) AS
submissions FROM auth_user INNER JOIN pootle_app_submission AS sub ON
auth_user.id=sub.submitter_id GROUP BY auth_user.id ORDER BY
submissions DESC LIMIT 50;

If someone volunteers to create a query for the credits page, so only
those people would be credited, who actually submitted something, I'm
sure that admins can run that query from time to time.

Cheers,
Andras

-- 
To unsubscribe e-mail to: website+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/website/
All messages sent to this list will be publicly archived and cannot be deleted