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(a)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(a)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(a)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(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments
http://www.wikilovesmonuments.eu