Wikipedia talk:Revision deletion/Statistics

Confusing terminology

The terminology related to "RevDelete" is confusing; making a report that quantifies actions related to "RevDelete" is naturally also confusing. From the script that's used to generate this report:

    {'name': 'Revision deletions',        'short_name': 'RD', 'type': 'delete',     'action': 'revision'},
    {'name': 'Event deletions',           'short_name': 'ED', 'type': 'delete',     'action': 'event'},
    {'name': 'Deletion suppressions',     'short_name': 'DS', 'type': 'suppress',   'action': 'delete'},
    {'name': 'Revision suppressions',     'short_name': 'RS', 'type': 'suppress',   'action': 'revision'},
    {'name': 'Event suppressions',        'short_name': 'ES', 'type': 'suppress',   'action': 'event'},
    {'name': 'Username suppressions',     'short_name': 'US', 'type': 'suppress',   'action': 'reblock'},

I don't really know (or remember) what some of these actions actually correspond to in the interface. Someone else probably does, though. --MZMcBride (talk) 04:12, 11 June 2010 (UTC)

I think this clarifies the first two items in the list of six above:

mysql> select * from logging where log_type = 'delete' and log_action = 'revision' order by log_timestamp desc limit 5\G
*************************** 1. row ***************************
       log_id: 29842175
     log_type: delete
   log_action: revision
log_timestamp: 20100611035415
     log_user: 3597755
log_namespace: 0
  log_deleted: 0
    log_title: Mount_Saint_Michael_Academy
  log_comment: [[WP:RD1|RD1]]: Blatant copyright violations
   log_params: revision
364120835
ofield=0
nfield=1
*************************** 2. row ***************************
       log_id: 29842161
     log_type: delete
   log_action: revision
log_timestamp: 20100611035251
     log_user: 3597755
log_namespace: 0
  log_deleted: 0
    log_title: Mount_Saint_Michael_Academy
  log_comment: [[WP:RD1|RD1]]: Blatant copyright violations
   log_params: revision
362787422,362787355,362677795,362564324,362040509,361870462,361793832,361793667,361793477,361793287,361759627
ofield=0
nfield=1
*************************** 3. row ***************************
       log_id: 29839927
     log_type: delete
   log_action: revision
log_timestamp: 20100611001621
     log_user: 491706
log_namespace: 0
  log_deleted: 0
    log_title: Golden_Tate
  log_comment: [[WP:RD2|RD2]]: Grossly insulting, degrading, or offensive material
   log_params: revision
367315322,367314857
ofield=0
nfield=1
*************************** 4. row ***************************
       log_id: 29839923
     log_type: delete
   log_action: revision
log_timestamp: 20100611001600
     log_user: 491706
log_namespace: 0
  log_deleted: 0
    log_title: Lyor_Cohen
  log_comment: [[WP:RD2|RD2]]: Grossly insulting, degrading, or offensive material
   log_params: revision
367315259
ofield=0
nfield=1
*************************** 5. row ***************************
       log_id: 29838721
     log_type: delete
   log_action: revision
log_timestamp: 20100610224831
     log_user: 491706
log_namespace: 0
  log_deleted: 0
    log_title: Gary_King_(radio)
  log_comment: [[WP:RD2|RD2]]: Grossly insulting, degrading, or offensive material
   log_params: revision
367304988
ofield=0
nfield=1
5 rows in set (0.01 sec)

mysql> select * from logging where log_type = 'delete' and log_action = 'event' order by log_timestamp desc limit 5\G
*************************** 1. row ***************************
       log_id: 29808209
     log_type: delete
   log_action: event
log_timestamp: 20100609050110
     log_user: 4842600
log_namespace: -1
  log_deleted: 0
    log_title: Log/move
  log_comment: [[WP:RD2|RD2]]: Grossly insulting, degrading, or offensive material
   log_params: 16837350
ofield=0
nfield=2
*************************** 2. row ***************************
       log_id: 29799301
     log_type: delete
   log_action: event
log_timestamp: 20100608164651
     log_user: 301395
log_namespace: -1
  log_deleted: 0
    log_title: Log/move
  log_comment: [[WP:RD2|RD2]]: Grossly insulting, degrading, or offensive material
   log_params: 21292575
ofield=0
nfield=2
*************************** 3. row ***************************
       log_id: 29799299
     log_type: delete
   log_action: event
log_timestamp: 20100608164643
     log_user: 301395
log_namespace: -1
  log_deleted: 0
    log_title: Log/move
  log_comment: [[WP:RD2|RD2]]: Grossly insulting, degrading, or offensive material
   log_params: 21292577
ofield=0
nfield=2
*************************** 4. row ***************************
       log_id: 29799296
     log_type: delete
   log_action: event
log_timestamp: 20100608164636
     log_user: 301395
log_namespace: -1
  log_deleted: 0
    log_title: Log/move
  log_comment: [[WP:RD2|RD2]]: Grossly insulting, degrading, or offensive material
   log_params: 21292585
ofield=0
nfield=2
*************************** 5. row ***************************
       log_id: 29799292
     log_type: delete
   log_action: event
log_timestamp: 20100608164627
     log_user: 301395
log_namespace: -1
  log_deleted: 0
    log_title: Log/move
  log_comment: [[WP:RD2|RD2]]: Grossly insulting, degrading, or offensive material
   log_params: 21292589
ofield=0
nfield=2
5 rows in set (0.05 sec)

That seems to add a bit of clarity. --MZMcBride (talk) 04:22, 11 June 2010 (UTC)

Tag oversighters

Could we get oversighters signified somehow? (Presumably their actions require less scrutiny) –xeno^talk 12:53, 11 June 2010 (UTC)

Done. --MZMcBride (talk) 21:51, 11 June 2010 (UTC)