Depending on your usecase, you might find this useful as well:
Groups that are set because of wgAutopromote are stored in *logging*, so if you want to know since when the user fulfils the condition for autopromoting, it's available. See the following query made on enwiki.
MariaDB [enwiki_p]> select * from logging where log_type="rights" order by log_timestamp desc limit 1; +----------+----------+-------------+----------------+----------+-----------+---------------+-----------+----------------+-------------+-----------------------------------------------------------------------------------------+-------------+---------------+----------+ | log_id | log_type | log_action | log_timestamp | log_user | log_actor | log_namespace | log_title | log_comment_id | log_comment | log_params | log_deleted | log_user_text | log_page | +----------+----------+-------------+----------------+----------+-----------+---------------+-----------+----------------+-------------+-----------------------------------------------------------------------------------------+-------------+---------------+----------+ | 94360005 | rights | autopromote | 20181030172205 | 16997303 | 0 | 2 | Kubaski | 10 | | a:2:{s:12:"4::oldgroups";a:0:{}s:12:"5::newgroups";a:1:{i:0;s:17:"extendedconfirmed";}} | 0 | Kubaski | 58637813 | +----------+----------+-------------+----------------+----------+-----------+---------------+-----------+----------------+-------------+-----------------------------------------------------------------------------------------+-------------+---------------+----------+ 1 row in set (0.00 sec)
This row represents 17:22, 30 October 2018 Kubaski (talk | contribs) was automatically updated from (none) to extended confirmed user (thank) on https://en.wikipedia.org/wiki/Special:Log/rights .
Best, Martin
út 30. 10. 2018 v 13:53 odesílatel Alex Monk krenair@gmail.com napsal:
Hi max,
I think the implicit groups don't get stored in the database by MediaWiki, they are determined at runtime. You might be able to go through https://www.mediawiki.org/w/api.php?action=help&modules=query%2Busers with usprop=implicitgroups and filter them yourself.
Many thanks Alex
On Tue, 30 Oct 2018 at 09:40, max mbhwik@gmail.com wrote:
Hello. I'm a ruwiki user MBH.
I want to ask, how can I get (from Quarry or Toollabs database replica) a list of users having one of autopromoted groups (i.e. "autoconfirmed", or "uploader" in ruwiki)? DB table user_groups contains only manually assigned groups, such as "sysop".
Wikimedia Cloud Services mailing list Cloud@lists.wikimedia.org (formerly labs-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/cloud
Wikimedia Cloud Services mailing list Cloud@lists.wikimedia.org (formerly labs-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/cloud