Actually now that I think about it, it will probably include everyone who met the autopromotion criteria after that got deployed by editing, just with the wrong timestamps?
On Tue, 30 Oct 2018 at 19:03, Alex Monk <[email protected]> wrote: > 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
