Latest revision |
Your text |
Line 12: |
Line 12: |
| * Single posts: {{ic|<nowiki>INSERT INTO `asagi`.`<board>` (SELECT * FROM `asagi`.`<board>_deleted` WHERE doc_id = <doc_id>);</nowiki>}} | | * 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>}} | | * 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
| |
|
| |
|
| |
| == 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>
| |