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 <kren...@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 <mbh...@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 lab...@lists.wikimedia.org)
>> https://lists.wikimedia.org/mailman/listinfo/cloud
>
> _______________________________________________
> Wikimedia Cloud Services mailing list
> Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org)
> https://lists.wikimedia.org/mailman/listinfo/cloud
_______________________________________________
Wikimedia Cloud Services mailing list
Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/cloud
