Andre, that was my second try, actually (the first one was at
rankings.php which wasn't aware of other stuff).
However, going through the "first upload date" would turn things very
very much heavy (I'm talking about 500% or more time while hogging the
CPUs) and to solve that, very very much complex. I think I did followed
that approach initially, it's somewhere in the code, but found that
user_registration would do well. I can share the code with you if you
have a toolserver account - I don't have time to review it before
commiting to p_erfgoed.
Lodewijk, in the scenario you describe, my understanding about
user_registration would be incorrect. I'm not sure when
user_registration gets filled, but I don't believe it's propagated on
SUL user registration, but instead it's probably automatically set on
first login (authenticated through SUL). I think Beria shows us that I'm
right, though.
--
Nuno Tavares
Wikimedia Portugal
http://www.wikimedia.pt
Imagine um mundo onde é dada a qualquer pessoa a possibilidade de ter
livre acesso ao somatório de todo o conhecimento humano. É isso o que
estamos a fazer.
Participe também:
http://www.wikimedia.pt
Em 14-10-2011 16:48, André Costa escreveu:
> Thanks Nuno, that's what I guessed the definition was but I wasn't sure.
>
> Is it possible to find a "first upload" date (ideally on either commons
> or any other wikimedia wiki)?
>
> Andre
>
> 2011/10/14 Lodewijk <lodewijk@effeietsanders.org
>
mailto:lodewijk@effeietsanders.org>
>
> Hmm, so if someone never went to commons (but has been very active
> on one wiki and has SUL), and has an account automatically created
> there, will that be a new user or an old user? Unsure what
> user_registration date is given then :)
>
> Best, Lodewijk
>
> No dia 14 de Outubro de 2011 16:56, Nuno Tavares
> <nuno.tavares@wikimedia.pt
mailto:nuno.tavares@wikimedia.pt> escreveu:
>
> Hi André,
>
> I'm sending to the list, as it might be of interest for somebody
> else.
>
> The definition of a new user was based on the user_registration
> field
> from the user table, that is to say, a user is a new user if
> user.user_registration >= 20110831230000).
>
> Best,
> --
> Nuno Tavares
> Wikimedia Portugal
>
http://www.wikimedia.pt
>
> Imagine um mundo onde é dada a qualquer pessoa a possibilidade
> de ter
> livre acesso ao somatório de todo o conhecimento humano. É isso
> o que
> estamos a fazer.
>
> Participe também:
http://www.wikimedia.pt
>
>
> Em 14-10-2011 12:30, André Costa escreveu:
> > Hi Nuno.
> >
> > I'm preparing a blog entry for Swedish Wikimedia on some of the
> > statistics for the Swedish contributions.
> >
> > Anyway, I came across your statistics
> >
>
http://toolserver.org/%7Entavares/patrimonio/api/api.php?action=statisticsct&format=html&ctscope=country
http://toolserver.org/%7Entavares/patrimonio/api/api.php?action=statisticsct&format=html&ctscope=country>
> > and just wondered which definition you went with in the end
> for "new user".
> >
> > Many thanks,
> > André / Lokal_Profil
>
> _______________________________________________
> Wiki Loves Monuments mailing list
> WikiLovesMonuments@lists.wikimedia.org
>
mailto:WikiLovesMonuments@lists.wikimedia.org
>
https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments
>
http://www.wikilovesmonuments.eu
>
>
>
>
>
> _______________________________________________
> Wiki Loves Monuments mailing list
> WikiLovesMonuments@lists.wikimedia.org
>
https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments
>
http://www.wikilovesmonuments.eu