FoolFuuka/Housekeeping

Undelete post

Deleted posts by moderators are thrown in the deleted table. It is a hassle to grab stuff, but its not gone forever.

1. Get mysql workbench and login
2. type in the command SELECT * FROM asagi.a_deleted;
3. Click that lightning button
4. The results are the posts. Observe if they are the posts you want.

These commands can be run in mysql console or the mysql workbench

• Single posts: INSERT INTO `asagi`.`<board>` (SELECT * FROM `asagi`.`<board>_deleted` WHERE doc_id = <doc_id>);
• Entire thread: INSERT INTO `asagi`.`<board>` (SELECT * FROM `asagi`.`<board>_deleted` WHERE thread_num = <thread_num>);