Hi everyone,
I am very pleased to announce that the next EMWCon, or Enterprise MediaWiki
Conference, will be an in-person event, to be held in Nashville, Tennessee
(in the United States) next year. We don't have a date yet, but it will
probably be sometime in April or May.
EMWCon is an annual conference, since 2016, for all users of "enterprise
MediaWiki" (essentially any usage of MediaWiki outside the Wikimedia sites).
If you are considering attending - either in-person or remotely - please
add your name to the wiki page here, so we can try to get a sense of what
the attendance will be:
https://www.mediawiki.org/wiki/EMWCon_Spring_2021
-Yaron
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.
I recently upgraded an older version of mediawiki to the recent version.
The upgrade seems to have changed the data in the mediawikiuser database
table from plaintext to a binary encoding. (My database is MySQL 8.0.)
I have some SQL scripts that try to read and write some of these fields
(mainly user_name, user_real_name, user_email, user_password), but the data
format change breaks these SQL scripts.
Could someone explain what binary encoding is being used, and how I might
change my SQL scripts so that they are able to read and write the data
using the binary encoding? (Or, alternatively, is there an option to not
use the binary encoding and to go back to using plain text?)
Thanks
Mike