[Wiki Loves Monuments] Help to find tools

[Fhaidel Domínguez]

:) ¡Gracias, Platonides!

Ya yo estaba pensando que no era posible, pero esa idea tuya es buena para
lo que busco:

El período que quisiera revisar es del 1ero de abril al 31 de mayo de 2014

Ahora, si sé eso... ¿cómo puedo sacar ese volcado de las imágenes que
estuvieron en esa categoría? Con CatScan podría comparar después y sacar el
número así como tú dices.

La segunda pregunta es para sacar eso mismo que tienes en ese link. ¡Está
perfecto!

Y bueno, así son las cosas :) Pero para que conste en los registros, yo no
participo. Solo contribuyo como usuario. Lamentablemente, según las bases,
yo no puedo participar. :( Pero hay algo más interesante: el usuario más
antiguo ha sido de hecho el primer participante.

¡Muchas gracias!

Fhaidel.-


-------- English for the community --------

Thanks Platonides,

I already was thinking it wasn't possible but your idea is good for what
I'm looking for:

I know the time frame I would like to check: Apr 1st - May 31st 2014

Now, if I know it... how can I get an old dump for images that were in that
category? Then, using CatScan I can compare and get the number in the way
you comment.

My second question was looking for what you exactly got in your link.
That's great!

And well... facts are facts :)  Just for the records, I'm not a participant
but  a contributor user. Sadly I'm not a participant according to the
contest rules. :(  But there's something more interesting: the oldest user
is in fact the first participant.

Thank you so much!

Fhaidel.-




2014-05-11 22:07 GMT+02:00 Platonides <platonides en gmail.com>:

> On 06/05/14 12:40, Fhaidel Domínguez wrote:
>
>> Hi everybody,
>>
>> Does anybody know any tool to get a list of deleted images under a
>> category in commons,
>>
>
> You can't. Once a page is deleted, it no longer belongs to any category.
> If you know a time frame you could check (categorylinks) on an old dump for
> images that were in that category, and then filter out those who still
> exist.
>
>
>
>  and any other tool to get a list of a category
>> users details such as user name and registration date?
>>
>> I'm appointing to get some management tasks and internal metrics for
>> "Wikiviajes por Venezuela 2014" a photo contest run by Wikimedia
>> Venezuela currently.
>>
>> This is the category:
>> https://commons.wikimedia.org/wiki/Category:Wikiviajes_por_Venezuela_2014
>>
>
> Assuming you want the user that uploaded the first version of each of the
> images on that category, what you want is:
>
>> SELECT DISTINCT user_name, user_registration FROM categorylinks LEFT JOIN
>> logging ON (log_page = cl_from AND log_type='upload' and
>> log_action='upload') LEFT JOIN user ON (user_id = log_user) WHERE cl_to
>> ='Wikiviajes_por_Venezuela_2014';
>>
>
> I've left the list of 398 users at http://toolserver.org/~
> platonides/sandbox/Usuarios-Wikiviajes_por_Venezuela_2014-
> 20140511200000.txt
>
> As expected, most are new users:
>
>> 2014    370     92.9648% (1 in March, 187 in April, 182 in May)
>> 2013    6       1.50754%
>> 2012    6       1.50754%
>> 2011    3       0.753769%
>> 2010    6       1.50754%
>> 2009    2       0.502513%
>> 2008    2       0.502513%
>> 2007    1       0.251256%
>> 2006    2       0.502513%
>>
>
>
> Fun fact: you are the second oldest participant. ☺
>
>
>
>  Any help is appreciated,
>>
>> Thanks,
>>
>
> You're welcome
>
>
> _______________________________________________
> Wiki Loves Monuments mailing list
> WikiLovesMonuments en lists.wikimedia.org
> https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments
> http://www.wikilovesmonuments.org
>
------------ pr�a parte ------------
Se ha borrado un adjunto en formato HTML...
URL: <http://lists.wikimedia.org/pipermail/wikilovesmonuments/attachments/20140512/924793e0/attachment.html>