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".
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@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 labs-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/cloud
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@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@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 labs-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/cloud
Wikimedia Cloud Services mailing list Cloud@lists.wikimedia.org (formerly labs-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/cloud
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 martin.urbanec@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@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@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 labs-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/cloud
Wikimedia Cloud Services mailing list Cloud@lists.wikimedia.org (formerly labs-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/cloud
Wikimedia Cloud Services mailing list Cloud@lists.wikimedia.org (formerly labs-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/cloud
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 krenair@gmail.com 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 martin.urbanec@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@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@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 labs-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/cloud
Wikimedia Cloud Services mailing list Cloud@lists.wikimedia.org (formerly labs-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/cloud
Wikimedia Cloud Services mailing list Cloud@lists.wikimedia.org (formerly labs-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/cloud