diff of anon edit just *after* protection select rev_id, user_name, rev_user, rev_timestamp, LEFT(rev_comment,10) from revision join page on rev_page = page_id
select rev_id, user_name, rev_user, rev_timestamp, LEFT(rev_comment,10) from revision join page on rev_page = page_id left join user on user_id = rev_user where page_title = 'Deadliest_Warrior' and page_namespace = 0 and rev_timestamp > 20100512032108 and rev_timestamp < 20100512032215 order by rev_timestamp DESC ;+-----------+-----------+----------+----------------+----------------------+ | rev_id | user_name | rev_user | rev_timestamp | LEFT(rev_comment,10) | +-----------+-----------+----------+----------------+----------------------+ | 361610701 | NULL | 0 | 20100512032114 | /* Modern | | 361610681 | Prodego | 451766 | 20100512032109 | Protected | +-----------+-----------+----------+----------------+----------------------+ 2 rows in set (0.02 sec) 1) update the actual page protection data (in page_restrictions table) 2) create and save a null revision 3) update the page table for the last touched date and the new rev id 4) call the NewRevisionFromEditComplete hooks 5) call the ArticleProtectComplete hooks 6) save a new entry in the log 7) ??? 8) profit
Informasi ini disarikan dari Wikipedia dan disajikan kembali untuk tujuan edukasi. Konten tersedia di bawah lisensi CC BY-SA 3.0. Kami tidak bertanggung jawab atas ketidakakuratan data yang bersumber dari kontribusi publik tersebut.