Yeah. Don't rely on that too much though as it won't include autopromotions occurring before the deployment of https://www.mediawiki.org/wiki/Special:Code/MediaWiki/90816
On Tue, 30 Oct 2018 at 18:06, Martin Urbanec <[email protected]> wrote: > 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 <[email protected]> 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 <[email protected]> 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 >>> [email protected] (formerly [email protected]) >>> https://lists.wikimedia.org/mailman/listinfo/cloud >> >> _______________________________________________ >> Wikimedia Cloud Services mailing list >> [email protected] (formerly [email protected]) >> https://lists.wikimedia.org/mailman/listinfo/cloud > > _______________________________________________ > Wikimedia Cloud Services mailing list > [email protected] (formerly [email protected]) > https://lists.wikimedia.org/mailman/listinfo/cloud
_______________________________________________ Wikimedia Cloud Services mailing list [email protected] (formerly [email protected]) https://lists.wikimedia.org/mailman/listinfo/cloud
