Investigate how many pages may be relevant for the page protection wish
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	• Lea_WMDE
	Sep 12 2016, 12:43 PM

Description

Background:
The 2015 German-speaking community wishlist survey contains the following wish: T142209: Semi-protected pages that were fully protected should automatically return to previous state (#7)
A current hypothesis is, that the wish is only meant for pages with an indefinite protection status that change their protection level temporarily.
If that was so, how many pages would actually be relevant for the wish?

Task:
Please find out, how many existing pages (i.e. page-id != 0) on de-wiki currently have a protection status that is indefinite?
Please seperate by protection status.

Related Objects
Search...

		Status	Subtype	Assigned	Task
		Open		None	T142209 Semi-protected pages that were fully protected should automatically return to previous state (#7)
		Resolved		Addshore	T145385 Investigate how many pages may be relevant for the page protection wish

Event Timeline

• Lea_WMDE created this task.Sep 12 2016, 12:43 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptSep 12 2016, 12:43 PM

• Lea_WMDE added a parent task: T142209: Semi-protected pages that were fully protected should automatically return to previous state (#7).Sep 12 2016, 12:58 PM

• Lea_WMDE added a project: TCB-September Tasks.

• Lea_WMDE added a project: WMDE-QWERTY-Team-Experimental-Sprint.Sep 12 2016, 4:42 PM

Addshore claimed this task.Sep 13 2016, 6:53 AM

Addshore moved this task from Proposed to Todo on the WMDE-QWERTY-Team-Experimental-Sprint board.

Addshore moved this task from Todo to Doing on the WMDE-QWERTY-Team-Experimental-Sprint board.Sep 13 2016, 6:59 AM

mysql:research@analytics-store.eqiad.wmnet [dewiki]> select pr_type, pr_level, count(*) from page_restrictions where pr_page != 0 and pr_expiry = 'infinity' GROUP BY pr_type, pr_level;
+---------+---------------------+----------+
| pr_type | pr_level            | count(*) |
+---------+---------------------+----------+
| edit    | autoconfirmed       |    22269 |
| edit    | editeditorprotected |      369 |
| edit    | sysop               |    93948 |
| move    | autoconfirmed       |    21868 |
| move    | editeditorprotected |      317 |
| move    | sysop               |    94566 |
| upload  | autoconfirmed       |        3 |
| upload  | sysop               |       10 |
+---------+---------------------+----------+
8 rows in set (0.61 sec)

Addshore moved this task from Doing to Review on the WMDE-QWERTY-Team-Experimental-Sprint board.Sep 13 2016, 7:07 AM

Addshore moved this task from Review to Done on the WMDE-QWERTY-Team-Experimental-Sprint board.Sep 14 2016, 10:42 AM

Addshore moved this task from Incoming to Other on the TCB-Team (now WMDE-TechWish) board.Sep 19 2016, 6:52 PM

• Lea_WMDE mentioned this in T142209: Semi-protected pages that were fully protected should automatically return to previous state (#7).Sep 26 2016, 12:36 PM

Tobi_WMDE_SW closed this task as Resolved.Sep 27 2016, 3:57 PM

Tobi_WMDE_SW moved this task from Done to Demoed on the WMDE-QWERTY-Team-Experimental-Sprint board.Oct 25 2016, 12:19 PM