Jump to content

User:Chzz/protfail

From Wikipedia, the free encyclopedia
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
mediawiki code