Yeah. Don't rely on that too much though as it won't include autopromotions
occurring before the deployment of
On Tue, 30 Oct 2018 at 18:06, Martin Urbanec <martin.urbanec(a)wikimedia.cz>
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 <krenair(a)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(a)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(a)lists.wikimedia.org (formerly labs-l(a)lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/cloud
_______________________________________________
Wikimedia Cloud Services mailing list
Cloud(a)lists.wikimedia.org (formerly labs-l(a)lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/cloud
_______________________________________________
Wikimedia Cloud Services mailing list
Cloud(a)lists.wikimedia.org (formerly labs-l(a)lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/cloud