Anthere wrote:
>SELECT count(cur_title) from cur where
>cur_namespace=4
>
euh, no. This is the right namespace I think (334 ?)
4 is Wikipedia (the others you can find in Language??.php)
But, this is giving the number of articles. What I
would like is the names of these pages. I think
perhaps many of them are long lost.
Sorry I missed that. This should help you:
select cur_title from cur where cur_namespace=4 order by cur_title
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.
Which articles do you mean with "have made at least n articles"? New ones,
edited ones?
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 ;)
--
Smurf
smurf(a)AdamAnt.mud.de
------------------------- Anthill inside! ---------------------------