Arcthon:Maintenance

From Arcthon

Delete spam from database

Old

Delete text, links, revisions, pages, and recent changes in given namespaces by given users:

1. delete text.* from page, text, revision where page.page_namespace=101 and page.page_id=revision.rev_page and revision.rev_text_id=text.old_id and rev_user not in (1,2,3);
2. delete externallinks.* from page, externallinks, revision where page.page_namespace=101 and page.page_id=revision.rev_page and revision.rev_page=externallinks.el_from and rev_user not in (1,2,3);
3. delete revision.* from page, revision where page.page_namespace=101 and page.page_id=revision.rev_page and rev_user not in (1,2,3) ;
4. delete from page where page.page_namespace=101 ;
5. delete from recentchanges where rc_namespace=101 and rc_user not in (1,2,3);

New

1. Find texts last edited by new users, and revert those that have been vandalized: select text.old_id, page_title, page_namespace from page, text, revision where page.page_id=revision.rev_page and revision.rev_text_id=text.old_id and rev_user > 10 order by old_id desc limit 100;
2. Now the previous select should only show spam, and those data can be deleted:
3. delete text.* from page, text, revision where page.page_id=revision.rev_page and revision.rev_text_id=text.old_id and rev_user > 10;
4. delete externallinks.* from page, externallinks, revision where page.page_id=revision.rev_page and revision.rev_page=externallinks.el_from and rev_user > 10;
5. delete revision.* from page, revision where page.page_id=revision.rev_page and rev_user > 10;
6. delete from recentchanges where rc_namespace=101 and rc_user > 10;