Post AAfFvoWeExObXP1pdQ by sjw@neckbeard.xyz
(DIR) More posts by sjw@neckbeard.xyz
(DIR) Post #AAexRnV9gWkiV0rrBA by Zalzen@neckbeard.xyz
2021-08-24T19:18:20.838449Z
0 likes, 0 repeats
@sjw @nosleep hey guys need a favor, can an admin purge all my posts?
(DIR) Post #AAexawef1SG1UgfxDM by Zalzen@neckbeard.xyz
2021-08-24T19:19:59.020662Z
0 likes, 0 repeats
@pleb @nosleep @sjw kind of want to keep the account though, just need to obliterate my posts for anon reasons
(DIR) Post #AAexnfGUzKjxKERIau by kho@freecumextremist.com
2021-08-24T19:22:09.264798Z
1 likes, 0 repeats
@Zalzen @pleb @nosleep @sjw did you find a way to sneak into America lol :02:
(DIR) Post #AAeyEZg1sCG5oRDExs by Zalzen@neckbeard.xyz
2021-08-24T19:27:09.548253Z
2 likes, 0 repeats
@kho @pleb @nosleep @sjw lol no, but thee fed over in the under here might be looking for shit that sounds like me on obscure social media now
(DIR) Post #AAeyIG7uVE2CKw0j4q by Zalzen@neckbeard.xyz
2021-08-24T19:27:49.452772Z
0 likes, 0 repeats
@kho @nosleep @pleb @sjw also because lolis are illegal here
(DIR) Post #AAezLWelbKNYQUV612 by kho@freecumextremist.com
2021-08-24T19:39:29.212518Z
1 likes, 0 repeats
@Zalzen @pleb @nosleep @sjw godspeed
(DIR) Post #AAezhp9jV8JEAjcL9U by Zalzen@neckbeard.xyz
2021-08-24T19:43:38.636763Z
0 likes, 0 repeats
@kho @pleb @nosleep @sjw If I don't get a reply today I'm just going to nuke my account later and recreate...
(DIR) Post #AAf1Jm7XKphXiTFaaW by sjw@neckbeard.xyz
2021-08-24T20:01:40.910566Z
1 likes, 0 repeats
@Zalzen @nosleep uh, there isn't really an easy way to do that. @nosleep has a script that'll do they from your end tho.Note that media won't be deleted tho.I can delete them if you give me the sha256 of them tho.Why, did something happen?
(DIR) Post #AAf1bXwInbVIwkTB4a by Zalzen@neckbeard.xyz
2021-08-24T20:04:54.444810Z
1 likes, 0 repeats
@sjw @nosleep I just need to delete text posts, media is w/esomething possibly happened, but just trying to cover my ass because lolis are illegal hereif it's easier to just delete and recreate then I'll do that
(DIR) Post #AAf2GOgc6f1E7bbumu by sjw@neckbeard.xyz
2021-08-24T20:12:16.866703Z
0 likes, 0 repeats
@pleb @Zalzen @nosleep deleting accounts is currently broken
(DIR) Post #AAf2Io9qNJvvhPQrXE by sjw@neckbeard.xyz
2021-08-24T20:12:42.835308Z
0 likes, 0 repeats
@Zalzen @kho @nosleep @pleb the fuck did you do?
(DIR) Post #AAf2JlGyaRhB2cDtLM by sjw@neckbeard.xyz
2021-08-24T20:12:52.376586Z
0 likes, 0 repeats
@Zalzen @kho @nosleep @pleb where are you?
(DIR) Post #AAf2WZbJIJk2bbqLGy by sjw@neckbeard.xyz
2021-08-24T20:15:11.847719Z
0 likes, 0 repeats
@Zalzen @nosleep deleting will just break you following/followers, nothing else. Do you have your account tied to your real identity in any way?
(DIR) Post #AAf2cOcX22DcHwBunQ by sjw@neckbeard.xyz
2021-08-24T20:16:15.559982Z
0 likes, 0 repeats
@Zalzen @nosleep cc @lanodan what would be the easiest way to do this?
(DIR) Post #AAf3YY4W39dCOg0fPk by Zalzen@neckbeard.xyz
2021-08-24T20:26:47.587400Z
0 likes, 0 repeats
@sjw @lanodan @nosleep uhh I can take this into dms if you wanna know what happened specificially (I trust you), but essentially I need to purge posts that hint at where I live
(DIR) Post #AAf46Q3OMqW1NJdQDQ by lanodan@queer.hacktivis.me
2021-08-24T20:32:51.517837Z
0 likes, 0 repeats
@sjw @Zalzen @nosleep Well maybe do account deletion and then reactivate it?
(DIR) Post #AAf48wllhahlQ7b42i by sjw@neckbeard.xyz
2021-08-24T20:33:18.346161Z
0 likes, 0 repeats
@Zalzen @lanodan @nosleep wouldn't it be easier to just delete those posts specifically?I can also compile a list of all your posts plus the URL to them so you can more easily search them.
(DIR) Post #AAf4DRx5hwXTI22XvU by Zalzen@neckbeard.xyz
2021-08-24T20:34:10.305115Z
1 likes, 0 repeats
@sjw @lanodan @nosleep that would be poggers, I will take you up on that offer
(DIR) Post #AAf7vLxzcejnKY5XHc by sjw@neckbeard.xyz
2021-08-24T21:15:42.557405Z
0 likes, 0 repeats
@Zalzen @lanodan @nosleep hey lanodan why isn’t anything appearing in the post column when I runSELECT data->'object' as url , data->'source' as post FROM activities WHERE data->>'actor' = 'https://neckbeard.xyz/users/zalzen' AND activity_visibility(actor, recipients, data) = ANY('{public,unlisted}') AND data->>'type' = 'Create' limit 5;
(DIR) Post #AAf8BGVlflcP2pTQoq by lanodan@queer.hacktivis.me
2021-08-24T21:18:32.858488Z
1 likes, 0 repeats
@sjw @Zalzen @nosleep It's case-sensitive, Zalzen with capitalization.
(DIR) Post #AAf8WpEHmr3YnmZqgy by sjw@neckbeard.xyz
2021-08-24T21:22:28.702272Z
0 likes, 0 repeats
@lanodan @Zalzen @nosleep Mistyped that but this is what I mean. It's not returning that value for some reason.Screenshot_20210824-162106.jpg
(DIR) Post #AAf8xR0rvmj1VyzQrA by sjw@neckbeard.xyz
2021-08-24T21:27:17.366841Z
0 likes, 0 repeats
@lanodan @Zalzen @nosleep he doesn't want to lose the account thoPlus followers and that'd probably break shit with private keys.
(DIR) Post #AAf96TG8wrgZ5WRXPc by Zalzen@neckbeard.xyz
2021-08-24T21:28:56.775119Z
1 likes, 0 repeats
@sjw @lanodan @nosleep I have alts, if it's easier to just nuke me from neckbeard and have me recreate after that's cool
(DIR) Post #AAf96YgYm4mrutqCmW by lanodan@queer.hacktivis.me
2021-08-24T21:28:52.658381Z
0 likes, 0 repeats
@sjw @Zalzen @nosleep Ah right, well, data->'source' is something for objects, not activities.You’ll want to do a JOIN to get the source and that’s a bit too annoying to do for me for just this.That said, you could just use the objects table.Like, to get any posts of Zalzen with attachments:SELECT data->'attachment' FROM objects WHERE data->>'actor' = 'https://neckbeard.xyz/users/Zalzen' AND data->>'attachment' != '[]';
(DIR) Post #AAf9IzasYVMEqY73T6 by sjw@neckbeard.xyz
2021-08-24T21:31:10.618690Z
1 likes, 0 repeats
@Zalzen @lanodan @nosleep I'm on it :loli_thumb:
(DIR) Post #AAf9XPTL8YWhA3Seps by Zalzen@neckbeard.xyz
2021-08-24T21:33:49.491521Z
1 likes, 0 repeats
@sjw @lanodan @nosleep :puniko_thank_you:
(DIR) Post #AAf9hYIRBSXvQOCKfY by sjw@neckbeard.xyz
2021-08-24T21:35:37.419823Z
1 likes, 0 repeats
@lanodan @Zalzen @nosleep oh shit didn't notice that I'm big dumb. I'll just do a join.
(DIR) Post #AAfB3PyitGWdx4y0si by sjw@neckbeard.xyz
2021-08-24T21:50:46.866231Z
0 likes, 0 repeats
@lanodan @Zalzen @nosleep Well I tried but it didn’t work :feels_lain_man: SELECT activities.data->'object' as url , objects.data->'source' FROM activities WHERE activities.data->>'actor' = 'https://neckbeard.xyz/users/Zalzen' AND activity_visibility(actor, recipients, data) = ANY('{public,unlisted}') AND activities.data->>'type' = 'Create' INNER JOIN objects ON activities.data->'object' = objects.data->'id' limit 5;
(DIR) Post #AAfB4ysibgMGUXu5UO by sjw@neckbeard.xyz
2021-08-24T21:51:02.487453Z
1 likes, 0 repeats
@Zalzen @lanodan @nosleep nah fuck that
(DIR) Post #AAfBg1Cyv0oGQH2gq0 by sjw@neckbeard.xyz
2021-08-24T21:57:45.308004Z
0 likes, 0 repeats
@Zalzen @lanodan @nosleep Why does this still not work? SELECT data->'id' as url, data->'source' as post FROM objects WHERE data->>'actor' = 'https://neckbeard.xyz/users/Zalzen' limit 5;Even if I select only source it's just a bunch of empty.
(DIR) Post #AAfCGsQ6YY0vsfkw1w by lanodan@queer.hacktivis.me
2021-08-24T22:04:22.790696Z
1 likes, 0 repeats
@sjw @Zalzen @nosleep With content instead of source I get a bit of content unless they are stuff like "Answer".
(DIR) Post #AAfCKzrCqaD26ZOgAy by sjw@neckbeard.xyz
2021-08-24T22:05:09.368089Z
1 likes, 0 repeats
@Zalzen @lanodan @nosleep Nevermind adding and data->>'type' = 'Note' did the trick.Alright, time to run the whole thing.
(DIR) Post #AAfFvoWeExObXP1pdQ by sjw@neckbeard.xyz
2021-08-24T22:45:26.057015Z
0 likes, 0 repeats
@lanodan @Zalzen @nosleep Yeah, the answers are what was fucking it up.