Re: [Cloud] Autopromoted groups aren't listed in user_groups table

2018-10-30 Thread Alex Monk
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 wrote: > Yeah. Don't rely on that too much though as it won't include > autopromoti

Re: [Cloud] Autopromoted groups aren't listed in user_groups table

2018-10-30 Thread Alex Monk
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 wrote: > Depending on your usecase, you might find this useful as well: > > Grou

Re: [Cloud] Autopromoted groups aren't listed in user_groups table

2018-10-30 Thread Martin Urbanec
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]> sele

Re: [Cloud] Autopromoted groups aren't listed in user_groups table

2018-10-30 Thread Alex Monk
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, 3

[Cloud] Autopromoted groups aren't listed in user_groups table

2018-10-30 Thread max
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".