--- Thomas Corell T.Corell@t-online.de wrote:
Anthere wrote: Sorry I missed that. This should help you:
select cur_title from cur where cur_namespace=4 order by cur_title
Yes. Perfect. Thank you
Please, I also would like a query giving me the
name
of users, who have made at least n articles (say
and been there for at least m months (say 3).
That's usually not possible, because simple sysops don't have the right to read these values (user_touched), thats a matter of data security and privacy.
Ah ? If you say so. But...I don't get it really. What I asked is basically * when the user made his/her first edit * the number of edits done
These two informations are retrievable from the user:contributions. I can't figure why you say these infos are private, since absolutely available to anyone ?!?
That is just as for most queries made available to us. Done on some infos public to anyone. But retrievable in a few seconds instead of hours. I can't see what is private here...
Which articles do you mean with "have made at least n articles"? New ones, edited ones?
I want to find a way to detect those who have been here quite a while, have edited quite a lot, as these are likely to know and understand the wiki process. If these have no history of being difficult editors or potentially difficult sysops, it might be interesting to ask them if they want to be sysops.
I think that was part of what Brion was proposing at http://meta.wikipedia.org/wiki/User_details_special_page
No ?
Thank you very much for your help smurf (isnot
that
the translation of schtroumpf ?)
Whatever "schtroumpf " means *puzzle*. It's the english translation of the german word "Schlumpf" and here is an example picture:
http://www.weltderkobolde.de/PapaschlumpfmitBuch.html
(Wikipedia compatible version of me ;)
Right. That is exactly what I thought. This is a schtroumpf.
A schtroumpf is not a puzzle (should not be a puzzle), it is the name given by Peyo to his little blue guys :-)
Like here http://www.bdland.com/cgi-bin/collectaff.cgi?caC=26
Peyo was a belgium man I believe
Thanks anyway
Anthere
__________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com