@graf can you remove otto from my followers?
Timeline
Post
Remote status
Context
7
@professionalbigot69 just go to his profile and remove him dude
@graf there's no option to remove followers on the current frontend, he doesn't appear in the pl frontend followers list and the beta frontend doesn't actually remove him
@professionalbigot69 Oh, you can't because his instance is down and when it came back we defederated it. I'm charging you my database administration fee. 500$/hour billed in 10$ increments
@graf I'm buying you a case of blue moon instead
@professionalbigot69 I'm already up to 20$
@professionalbigot69 40$ please
pleroma=# select id from users where ap_id = 'https://sneed.social/users/otto';
id
--------------------------------------
0000017a-8c9f-5278-eb08-02f0bc6a0000
(1 row)
pleroma=# select * from following_relationships where follower_id = '0000017a-8c9f-5278-eb08-02f0bc6a0000' and following_id = '00000177-5bbc-db8d-6e4c-c1ff3e5a0000' limit 1;
id | follower_id | following_id | state | inserted_at | updated_at
--------+--------------------------------------+--------------------------------------+-------+---------------------+---------------------
223563 | 0000017a-8c9f-5278-eb08-02f0bc6a0000 | 00000177-5bbc-db8d-6e4c-c1ff3e5a0000 | 2 | 2021-07-09 18:58:01 | 2021-07-09 18:58:01
(1 row)
pleroma=# delete from following_relationships where id = '223563';
DELETE 1@professionalbigot69 you know what better this is a better idea
pleroma=# delete from users where (split_part("ap_id", '/', 3) = 'sneed.social');
DELETE 155Replies
3
@professionalbigot69 Got your tithe, thank you for paying respects to your favourite website friend
