Dear specialists,
concerning a spam problem I would like to find "Good editors" :-)
How can I find by SQL request in the DB:
Give me a list of all editors, who did build a new article or did one
ore more edits in an existing article in a specific NameSpace (NS-#),
output: user_ID, user_name, user_mail-adress (if there is one)
Give me a list of all editors, who have got an edit of user-name=xy (a
specific known user) in their user_page (NS-2) and/or their
user_discussion_page (NS-3)
output: user_ID, user_name, user_mail-adress (if there is one)
or andersherunm:
Give me a list of all pages in a specific NameSpce (NS-#), which are
made or deited by a specific user_name
output: user_ID, user_name, user_mail-adress (if there is one)
Ho can I count the number of pages in a specific NameSpace?
What is the correct SQL-request for this questions?
Which tables we have to touch?
I'm not a programmer, and I hope that I did express my question in an
understandable form...
Thanks for help, Markus
PS: if you speak German, it would be more easy to correspond.
_______________________________________________
MediaWiki-l mailing list
To unsubscribe, go to:
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
concerning a spam problem I would like to find "Good editors" :-)
How can I find by SQL request in the DB:
Give me a list of all editors, who did build a new article or did one
ore more edits in an existing article in a specific NameSpace (NS-#),
output: user_ID, user_name, user_mail-adress (if there is one)
Give me a list of all editors, who have got an edit of user-name=xy (a
specific known user) in their user_page (NS-2) and/or their
user_discussion_page (NS-3)
output: user_ID, user_name, user_mail-adress (if there is one)
or andersherunm:
Give me a list of all pages in a specific NameSpce (NS-#), which are
made or deited by a specific user_name
output: user_ID, user_name, user_mail-adress (if there is one)
Ho can I count the number of pages in a specific NameSpace?
What is the correct SQL-request for this questions?
Which tables we have to touch?
I'm not a programmer, and I hope that I did express my question in an
understandable form...
Thanks for help, Markus
PS: if you speak German, it would be more easy to correspond.
_______________________________________________
MediaWiki-l mailing list
To unsubscribe, go to:
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l