Jump to content

User:Zache: Difference between revisions

From Wikipedia!
Browse history interactively
← Older editNewer edit →
Content deleted Content added
VisualWikitext
Line 522: Line 522:
rc_log_action:
rc_log_action:
rc_params:
rc_params:
*************************** 5. row ***************************
*************************** 5. row ***************************
rc_id: 336563
rc_id: 336563
rc_timestamp: 20160522072423
rc_timestamp: 20160522072423
Line 573: Line 573:
rc_log_type: NULL
rc_log_type: NULL
rc_log_action:
rc_log_action:
rc_params:
rc_params:


== Edit 7, 8 - Making two edits with same unregistered user ==
== Edit 7, 8 - Making two edits with same unregistered user ==

Revision as of 07:53, 22 May 2016

Flagged revision links

Muistiinpanot

Oikeuksilla "reviewer"
  • sivun vakautusasetuksia pystyy muuttamaan sivun suojausvalinnoista, mutta arvojen tallentaminen on sallittu vain ylläpitäjille.
  • Jos luot uuden sivun, niin muokkauksen patrolled=0, logging-tauluun ei mene mitään
  • Mikäli merkitsee muokkauksen "mark as patrolled" -linkillä, niin käyttäjälle ilmoitetaan "The page ‪User:Zache‬ has been reviewed."

Edits

Edit 1

Editing autoconfirmed stabilized page "sandbox2" with reviewer right (patroller, autoreviewed) diff

Logging table 

| 189549 | review   | approve-a  | 20160521095132 |    33360 |             0 | Sandbox2  | (automatic) | 274272, 96526, 20160521095132                                             |           0 | Zache         |    73927 |
| 189550 | patrol   | autopatrol | 20160521095132 |    33360 |             0 | Sandbox2  |             | a:3:{s:8:"4::curid";i:274272;s:9:"5::previd";i:196526;s:7:"6::auto";i:1;} |           0 | Zache         |    73927 |

Recent changes table

MariaDB [testwiki_p]> select * from recentchanges where rc_title="Sandbox2" \G; 

*************************** 1. row ***************************
       rc_id: 336525
rc_timestamp: 20160521095132
 rc_cur_time: 
     rc_user: 33360
rc_user_text: Zache
rc_namespace: 0
    rc_title: Sandbox2
  rc_comment: testing - Sandbox2  [autoreview=autoconfirmed] (editor have reviewer right)
    rc_minor: 0
      rc_bot: 0
      rc_new: 0
   rc_cur_id: 73927
rc_this_oldid: 274272
rc_last_oldid: 196526
     rc_type: 0 
   rc_source: mw.edit
rc_patrolled: 1
       rc_ip: NULL
  rc_old_len: 26
  rc_new_len: 94
  rc_deleted: 0
    rc_logid: 0
 rc_log_type: NULL
rc_log_action: 
   rc_params:

Edit 2

Editing autoconfirmed stabilized page "sandbox2" without any rights diff - No new rows to logging table

Recent changes table 

       rc_id: 336526
rc_timestamp: 20160521095942
 rc_cur_time: 
     rc_user: 33361
rc_user_text: Zache-test
rc_namespace: 0
    rc_title: Sandbox2
  rc_comment: testing - Sandbox2  [autoreview=autoconfirmed] (user without review or patrol right)
    rc_minor: 0
      rc_bot: 0
      rc_new: 0
   rc_cur_id: 73927
rc_this_oldid: 274273
rc_last_oldid: 274272
     rc_type: 0
   rc_source: mw.edit
rc_patrolled: 0
       rc_ip: NULL
  rc_old_len: 94
  rc_new_len: 103
  rc_deleted: 0
    rc_logid: 0
 rc_log_type: NULL
rc_log_action: 
    rc_params:

Review 1 (Accepting edit 2)

Accepting edit 2 with user Zache with reviewer right (patroller, autoreviewed, review)

Logging 

      log_id: 189552
    log_type: review
  log_action: approve
log_timestamp: 20160521100400
    log_user: 33360
log_namespace: 0
   log_title: Sandbox2
 log_comment: 
  log_params: 274273, 274272, 20160521095942
 log_deleted: 0
log_user_text: Zache
    log_page: 73927

Recent changes -table 

       rc_id: 336526
rc_timestamp: 20160521095942
 rc_cur_time: 
     rc_user: 33361
rc_user_text: Zache-test
rc_namespace: 0
    rc_title: Sandbox2
  rc_comment: testing - Sandbox2  [autoreview=autoconfirmed] (user without review or patrol right)
    rc_minor: 0
      rc_bot: 0
      rc_new: 0
   rc_cur_id: 73927
rc_this_oldid: 274273
rc_last_oldid: 274272
     rc_type: 0
   rc_source: mw.edit
rc_patrolled: 1
       rc_ip: NULL
  rc_old_len: 94
  rc_new_len: 103
  rc_deleted: 0
    rc_logid: 0
 rc_log_type: NULL
rc_log_action: 
   rc_params:

Review 2 (Removing review 1)

Removing the accept of edit 2. User Zache with reviewer right (patroller, autoreviewed, review)


logging 

*************************** 20. row ***************************
      log_id: 189555
    log_type: review
  log_action: unapprove
log_timestamp: 20160521100835
    log_user: 33360
log_namespace: 0
   log_title: Sandbox2
 log_comment: 
  log_params: 274273, 274273, 20160521095942
 log_deleted: 0
log_user_text: Zache
    log_page: 73927

Recent changes 

*************************** 2. row ***************************
       rc_id: 336526
rc_timestamp: 20160521095942
 rc_cur_time: 
     rc_user: 33361
rc_user_text: Zache-test
rc_namespace: 0
    rc_title: Sandbox2
  rc_comment: testing - Sandbox2  [autoreview=autoconfirmed] (user without review or patrol right)
    rc_minor: 0
      rc_bot: 0
      rc_new: 0
   rc_cur_id: 73927
rc_this_oldid: 274273
rc_last_oldid: 274272
     rc_type: 0
   rc_source: mw.edit
rc_patrolled: 0
       rc_ip: NULL
  rc_old_len: 94
  rc_new_len: 103
  rc_deleted: 0
    rc_logid: 0
 rc_log_type: NULL
rc_log_action: 
   rc_params:

Review 3 (Unaccepting edit 2)

Unccepting edit 2 with user Zache with reviewer right (patroller, autoreviewed, review)


Logging 

*************************** 21. row ***************************
      log_id: 189557
    log_type: review
  log_action: approve-a
log_timestamp: 20160521101422
    log_user: 33360
log_namespace: 0
   log_title: Sandbox2
 log_comment: (automatic)
  log_params: 274274, 274272, 20160521101422
 log_deleted: 0
log_user_text: Zache
    log_page: 73927
*************************** 22. row ***************************
      log_id: 189558
    log_type: patrol
  log_action: autopatrol
log_timestamp: 20160521101422
    log_user: 33360
log_namespace: 0
   log_title: Sandbox2
 log_comment: 
  log_params: a:3:{s:8:"4::curid";i:274274;s:9:"5::previd";i:274273;s:7:"6::auto";i:1;}
 log_deleted: 0
log_user_text: Zache
    log_page: 73927

Recentchanges 

*************************** 2. row ***************************
       rc_id: 336526
rc_timestamp: 20160521095942
 rc_cur_time: 
     rc_user: 33361
rc_user_text: Zache-test
rc_namespace: 0
    rc_title: Sandbox2
  rc_comment: testing - Sandbox2  [autoreview=autoconfirmed] (user without review or patrol right)
    rc_minor: 0
      rc_bot: 0
      rc_new: 0
   rc_cur_id: 73927
rc_this_oldid: 274273
rc_last_oldid: 274272
     rc_type: 0
   rc_source: mw.edit
rc_patrolled: 1
       rc_ip: NULL
  rc_old_len: 94
  rc_new_len: 103
  rc_deleted: 0
    rc_logid: 0
 rc_log_type: NULL
rc_log_action: 
   rc_params: 
*************************** 3. row ***************************
       rc_id: 336527
rc_timestamp: 20160521101422
 rc_cur_time: 
     rc_user: 33360
rc_user_text: Zache
rc_namespace: 0
    rc_title: Sandbox2
  rc_comment: Reverted edit by Zache-test to revision 274272 by Zache; rejecting unreviewed edit using user with review and patrol rights
    rc_minor: 0
      rc_bot: 0
      rc_new: 0
   rc_cur_id: 73927
rc_this_oldid: 274274
rc_last_oldid: 274273
     rc_type: 0
   rc_source: mw.edit
rc_patrolled: 1
       rc_ip: NULL
  rc_old_len: 103
  rc_new_len: 94
  rc_deleted: 0
    rc_logid: 0
 rc_log_type: NULL
rc_log_action: 
   rc_params:

Edit 3, 4 - Making two edits with same unregistered user

logging - ei mitään recent changes 

*************************** 4. row ***************************
       rc_id: 336562
rc_timestamp: 20160522072407
 rc_cur_time: 
     rc_user: 0
rc_user_text: 80.222.x.x
rc_namespace: 0
    rc_title: Sandbox2
  rc_comment: testing edit 1 - Sandbox2  [autoreview=autoconfirmed] (editing without logged in)
    rc_minor: 0
      rc_bot: 0
      rc_new: 0
   rc_cur_id: 73927
rc_this_oldid: 274298
rc_last_oldid: 274274
     rc_type: 0
   rc_source: mw.edit
rc_patrolled: 0
       rc_ip: NULL
  rc_old_len: 94
  rc_new_len: 100
  rc_deleted: 0
    rc_logid: 0
 rc_log_type: NULL
rc_log_action: 
   rc_params: 
*************************** 5. row ***************************
       rc_id: 336563
rc_timestamp: 20160522072423
 rc_cur_time: 
     rc_user: 0
rc_user_text: 80.222.x.x
rc_namespace: 0
    rc_title: Sandbox2
  rc_comment: testing edit 2 - Sandbox2  [autoreview=autoconfirmed] (editing without logged in)
    rc_minor: 0
      rc_bot: 0
      rc_new: 0
   rc_cur_id: 73927
rc_this_oldid: 274299
rc_last_oldid: 274298
     rc_type: 0
   rc_source: mw.edit
rc_patrolled: 0
       rc_ip: NULL
  rc_old_len: 100
  rc_new_len: 100
  rc_deleted: 0
    rc_logid: 0
 rc_log_type: NULL
rc_log_action: 
   rc_params:

Review 4 - accepting two edits

  • Vaikka tehtynä on kaksi muokkausta, niin viestinä näkyy "1 change in this version is pending review. The stable version was checked on 21 May 2016." (koska muokkaukset ovat samalta käyttäjältä?)

Logging 

*************************** 23. row ***************************
      log_id: 189624
    log_type: review
  log_action: approve
log_timestamp: 20160522073209
    log_user: 33360
log_namespace: 0
   log_title: Sandbox2
 log_comment: 
  log_params: 274299, 274274, 20160522072423
 log_deleted: 0
log_user_text: Zache
    log_page: 73927

Recent changes 

*************************** 5. row ***************************
       rc_id: 336562
rc_timestamp: 20160522072407
 rc_cur_time: 
     rc_user: 0
rc_user_text: 80.222.x.x
rc_namespace: 0
    rc_title: Sandbox2
  rc_comment: testing edit 1 - Sandbox2  [autoreview=autoconfirmed] (editing without logged in)
    rc_minor: 0
      rc_bot: 0
      rc_new: 0
   rc_cur_id: 73927
rc_this_oldid: 274298
rc_last_oldid: 274274
     rc_type: 0
   rc_source: mw.edit
rc_patrolled: 1
       rc_ip: NULL
  rc_old_len: 94
  rc_new_len: 100
  rc_deleted: 0
    rc_logid: 0
 rc_log_type: NULL
rc_log_action: 
   rc_params: 
*************************** 5. row ***************************
       rc_id: 336563
rc_timestamp: 20160522072423
 rc_cur_time: 
     rc_user: 0
rc_user_text: 80.222.x.x
rc_namespace: 0
    rc_title: Sandbox2
  rc_comment: testing edit 2 - Sandbox2  [autoreview=autoconfirmed] (editing without logged in)
    rc_minor: 0
      rc_bot: 0
      rc_new: 0
   rc_cur_id: 73927
rc_this_oldid: 274299
rc_last_oldid: 274298
     rc_type: 0
   rc_source: mw.edit
rc_patrolled: 1
       rc_ip: NULL
  rc_old_len: 100
  rc_new_len: 100
  rc_deleted: 0
    rc_logid: 0
 rc_log_type: NULL
rc_log_action: 
   rc_params:

Review 5 (Removing review 4)

Logging 

*************************** 24. row ***************************
      log_id: 189625
    log_type: review
  log_action: unapprove
log_timestamp: 20160522073531
    log_user: 33360
log_namespace: 0
   log_title: Sandbox2
 log_comment: 
  log_params: 274299274299, 20160522072423
 log_deleted: 0
log_user_text: Zache
    log_page: 73927

Recent changes 

*************************** 4. row ***************************
       rc_id: 336562
rc_timestamp: 20160522072407
 rc_cur_time: 
     rc_user: 0
rc_user_text: 80.222.x.x
rc_namespace: 0
    rc_title: Sandbox2
  rc_comment: testing edit 1 - Sandbox2  [autoreview=autoconfirmed] (editing without logged in)
    rc_minor: 0
      rc_bot: 0
      rc_new: 0
   rc_cur_id: 73927
rc_this_oldid: 274298
rc_last_oldid: 274274
     rc_type: 0
   rc_source: mw.edit
rc_patrolled: 0
       rc_ip: NULL
  rc_old_len: 94
  rc_new_len: 100
  rc_deleted: 0
    rc_logid: 0
 rc_log_type: NULL
rc_log_action: 
   rc_params: 
*************************** 5. row ***************************
       rc_id: 336563
rc_timestamp: 20160522072423
 rc_cur_time: 
     rc_user: 0
rc_user_text: 80.222.x.x
rc_namespace: 0
    rc_title: Sandbox2
  rc_comment: testing edit 2 - Sandbox2  [autoreview=autoconfirmed] (editing without logged in)
    rc_minor: 0
      rc_bot: 0
      rc_new: 0
   rc_cur_id: 73927
rc_this_oldid: 274299
rc_last_oldid: 274298
     rc_type: 0
   rc_source: mw.edit
rc_patrolled: 0
       rc_ip: NULL
  rc_old_len: 100
  rc_new_len: 100
  rc_deleted: 0
    rc_logid: 0
 rc_log_type: NULL
rc_log_action: 
   rc_params:

Review 5 (Unaccepting edits 3,4)

  • Tekstinä "2 changes in this version are pending review. The stable version was checked on 21 May 2016."

Logging 

*************************** 25. row ***************************
      log_id: 189627
    log_type: review
  log_action: approve-a
log_timestamp: 20160522074022
    log_user: 33360
log_namespace: 0
   log_title: Sandbox2
 log_comment: (automatic)
  log_params: 274303, 274274, 20160522074022
 log_deleted: 0
log_user_text: Zache
    log_page: 73927
*************************** 26. row ***************************
      log_id: 189628
    log_type: patrol
  log_action: autopatrol
log_timestamp: 20160522074022
    log_user: 33360
log_namespace: 0
   log_title: Sandbox2
 log_comment: 
  log_params: a:3:{s:8:"4::curid";i:274303;s:9:"5::previd";i:274299;s:7:"6::auto";i:1;}
 log_deleted: 0
log_user_text: Zache
    log_page: 73927

Recent changes 

*************************** 4. row ***************************
       rc_id: 336562
rc_timestamp: 20160522072407
 rc_cur_time: 
     rc_user: 0
rc_user_text: 80.222.x.x
rc_namespace: 0
    rc_title: Sandbox2
  rc_comment: testing edit 1 - Sandbox2  [autoreview=autoconfirmed] (editing without logged in)
    rc_minor: 0
      rc_bot: 0
      rc_new: 0
   rc_cur_id: 73927
rc_this_oldid: 274298
rc_last_oldid: 274274
     rc_type: 0
   rc_source: mw.edit
rc_patrolled: 1
       rc_ip: NULL
  rc_old_len: 94
  rc_new_len: 100
  rc_deleted: 0
    rc_logid: 0
 rc_log_type: NULL
rc_log_action: 
   rc_params: 
*************************** 5. row ***************************
       rc_id: 336563
rc_timestamp: 20160522072423
 rc_cur_time: 
     rc_user: 0
rc_user_text: 80.222.x.x
rc_namespace: 0
    rc_title: Sandbox2
  rc_comment: testing edit 2 - Sandbox2  [autoreview=autoconfirmed] (editing without logged in)
    rc_minor: 0
      rc_bot: 0
      rc_new: 0
   rc_cur_id: 73927
rc_this_oldid: 274299
rc_last_oldid: 274298
     rc_type: 0
   rc_source: mw.edit
rc_patrolled: 1
       rc_ip: NULL
  rc_old_len: 100
  rc_new_len: 100
  rc_deleted: 0
    rc_logid: 0
 rc_log_type: NULL
rc_log_action: 
   rc_params: 
*************************** 6. row ***************************
       rc_id: 336567
rc_timestamp: 20160522074022
 rc_cur_time: 
     rc_user: 33360
rc_user_text: Zache
rc_namespace: 0
    rc_title: Sandbox2
  rc_comment: Reverted 2 edits by 80.222.234.26 to revision 274274 by Zache
    rc_minor: 0
      rc_bot: 0
      rc_new: 0
   rc_cur_id: 73927
rc_this_oldid: 274303
rc_last_oldid: 274299
     rc_type: 0
   rc_source: mw.edit
rc_patrolled: 1
       rc_ip: NULL
  rc_old_len: 100
  rc_new_len: 94
  rc_deleted: 0
    rc_logid: 0
 rc_log_type: NULL
rc_log_action: 
   rc_params:

Edit 7, 8 - Making two edits with same unregistered user

Logging tauluun ei mitään

Recent changes 

*************************** 7. row ***************************
       rc_id: 336568
rc_timestamp: 20160522074445
 rc_cur_time: 
     rc_user: 0
rc_user_text: 80.222.x.x
rc_namespace: 0
    rc_title: Sandbox2
  rc_comment: Undid revision 274303 by Zache (talk)
    rc_minor: 0
      rc_bot: 0
      rc_new: 0
   rc_cur_id: 73927
rc_this_oldid: 274304
rc_last_oldid: 274303
     rc_type: 0
   rc_source: mw.edit
rc_patrolled: 0
       rc_ip: NULL
  rc_old_len: 94
  rc_new_len: 100
  rc_deleted: 0
    rc_logid: 0
 rc_log_type: NULL
rc_log_action: 
   rc_params: 
*************************** 8. row ***************************
       rc_id: 336569
rc_timestamp: 20160522074459
 rc_cur_time: 
     rc_user: 0
rc_user_text: 80.222.x.x
rc_namespace: 0
    rc_title: Sandbox2
  rc_comment: 
    rc_minor: 0
      rc_bot: 0
      rc_new: 0
   rc_cur_id: 73927
rc_this_oldid: 274305
rc_last_oldid: 274304
     rc_type: 0
   rc_source: mw.edit
rc_patrolled: 0
       rc_ip: NULL
  rc_old_len: 100
  rc_new_len: 100
  rc_deleted: 0
    rc_logid: 0
 rc_log_type: NULL
rc_log_action: 
   rc_params:

Rollback 1

Logging 

*************************** 27. row ***************************
      log_id: 189631
    log_type: review
  log_action: approve-a
log_timestamp: 20160522074926
    log_user: 33361
log_namespace: 0
   log_title: Sandbox2
 log_comment: (automatic)
  log_params: 274308, 274303, 20160522074926
 log_deleted: 0
log_user_text: Zache-test
    log_page: 73927
*************************** 28. row ***************************
      log_id: 189632
    log_type: patrol
  log_action: autopatrol
log_timestamp: 20160522074927
    log_user: 33361
log_namespace: 0
   log_title: Sandbox2
 log_comment: 
  log_params: a:3:{s:8:"4::curid";i:274308;s:9:"5::previd";i:274305;s:7:"6::auto";i:1;}
 log_deleted: 0
log_user_text: Zache-test
    log_page: 73927
Retrieved from "https://test.wikipedia.org/w/index.php?title=User:Zache&oldid=274313"