--- Thomas Corell <T.Corell(a)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
200)
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