Editing 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.

# Get mysql workbench and login
# type in the command {{ic|SELECT * FROM asagi.a_deleted;}}
# Click that lightning button
# 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: {{ic|<nowiki>INSERT INTO `asagi`.`<board>` (SELECT * FROM `asagi`.`<board>_deleted` WHERE doc_id = <doc_id>);</nowiki>}}
* Entire thread: {{ic|<nowiki>INSERT INTO `asagi`.`<board>` (SELECT * FROM `asagi`.`<board>_deleted` WHERE thread_num = <thread_num>);</nowiki>}}

== Delete Ghost Posts by search query ==

* modify  /home/atc/delete-by-search-query.php
* Under the profiler:
** 27 Start: SphinxQL: SELECT id, board, tnum FROM a_ancient, a_main, a_delta WHERE MATCH('(@comment mado mami)') AND is_internal = 1 ORDER BY timestamp DESC LIMIT 0, 25 OPTION max_matches = 5000, reverse_scan = 1
** you have no idea how angry it has made us to see the words "mado mami" and their accomplices be spammed on our ghostposts
* Replace $querymatch with the highlighted portion
** You can also include AND if there is more to filter by

== Deleting by ghost posts by IP range ==

Example: 148.74.* (first IP: 148.74.0.0, last IP 148.74.255.255)

* Search for 1st IP in range in FF - Look at query in Profiler
** Take the `pip` out
*** Example for 148.74.0.0 - WHERE pip = 2487877632
* Search for last IP in range
** Take the `pip` out
*** Example for 148.74.255.255 - WHERE pip = 2487943167
* Edit /home/atc/delete-by-search-query.php
* Set $dry = true; to test
* Comment the line after NORMAL QUERY
* Uncomment line after IP RANGE
** Edit PIP numbers. First IP is first, Last IP goes second
* Test with php /home/atc/delete-by-search-query.php
* If it looks good, set $dry = false; and run again

== Deleting all ghostposts in a thread ==

In delete-by-search-query.php:

    $use_specificboard = true;                                                                                                                                   
    $specificboard = 'a';}}
    $querymatch = "tnum = 1234141"; // Delete by thread num

Then run:

    php /home/atc/delete-by-search-query.php
@@ Line 51: / Line 51: @@
      php /home/atc/delete-by-search-query.php
-== Purging Files ==
-Local files on the frontend/dumper server are automatically purged on image ban & image delete inside the web console.
-Files on CDN2 require more work as they are on a separate server.
-=== Manual Procedure (CDN2) ===
-    sudo shred /desuzfs/media/desu/k/image/0000/00/0000000000.jpg
-    sudo shred /desuzfs/media/desu/k/thumb/0000/00/0000000000s.jpg # note the s, and thumbs are always jpg
-    sudo rm /desuzfs/media/desu/k/thumb/0000/00/0000000000s.jpg
-(Files on the frontend server are located in /srv/foolfuuka/boards/)
-(Purge CloudFlare Cache)
-  curl -X DELETE \
-    https://api.cloudflare.com/client/v4/zones/YOUR_API_KEY_HERE/purge_cache \
-    -H 'cache-control: no-cache' \
-    -H 'X-Auth-Email: YOUR_AUTH_EMAIL_HERE' \
-    -H 'X-Auth-Key: YOUR_KEY_HERE'\
-    -H 'content-type: application/json' \
-    --data '{"files":["https://yourdomain.org/k/thumb/0000/00/0000000000s.jpg"]}'
-Finally, use automatic purge to clear CloudFlare Cache
-and there is 24 hours to do this
-NEVER CLICK THE IMAGE URL. be very careful of posting it also
-only share it in the following form: k/thumb/0000/00/0000000000s.jpg
-=== Frontend Sync Banned Images from FoolFuuka ===
-There’s a script nas-rem-img.php that lives on the dumper /var/www/foolfuuka
-* Login to CDN2.
-* Run {{ic|php /home/atc/test.php}}
-* This will delete banned files from the NAS
-This is cron’d to run daily.
-=== Automatic Procedure ===
-We have a purge.php that not only deletes both thumb and image, but also purges the cloudflare cache.
-* Adding users to purge script: sudo htpasswd /etc/nginx/ssl/htpasswd <username>