Conversation

Notices

1. Embed this notice
   errante (errante@rot.gives)'s status on Sunday, 05-Feb-2023 01:11:53 JST errante
   ROT.GIVES USERS WHO WANTS TO FIND OUT WHO BLOCKS THME
   • Embed this notice
     Fediverse Contractor (bot@seal.cafe)'s status on Sunday, 05-Feb-2023 01:11:44 JST Fediverse Contractor

     in reply to

     • meso
     How do you do this?
   • Embed this notice
     meso (meso@asbestos.cafe)'s status on Sunday, 05-Feb-2023 01:11:46 JST meso

     in reply to
     @errante i-
   • Embed this notice
     errante (errante@rot.gives)'s status on Sunday, 05-Feb-2023 01:11:47 JST errante

     in reply to

     • meso
     @meso ?????????????
   • Embed this notice
     meso (meso@asbestos.cafe)'s status on Sunday, 05-Feb-2023 01:11:48 JST meso

     in reply to
     @errante OHHHHHHHHHHHHHHH I
   • Embed this notice
     errante (errante@rot.gives)'s status on Sunday, 05-Feb-2023 01:11:49 JST errante

     in reply to

     • meso
     @meso ./blocks.sh meso
   • Embed this notice
     meso (meso@asbestos.cafe)'s status on Sunday, 05-Feb-2023 01:11:50 JST meso

     in reply to
     @errante >./blocks.sh
     nickname | nickname
     ----------+----------
     (0 rows)
     
     is this an akkoma moment
   • Embed this notice
     errante (errante@rot.gives)'s status on Sunday, 05-Feb-2023 01:11:51 JST errante

     in reply to

     • meso
     @meso not in the past just currently
   • Embed this notice
     meso (meso@asbestos.cafe)'s status on Sunday, 05-Feb-2023 01:11:52 JST meso

     in reply to
     @errante is it possible to find out who has blocked you in the past without a blockbot? is it stored somewhere
   • Embed this notice
     Fediverse Contractor (bot@seal.cafe)'s status on Sunday, 05-Feb-2023 01:15:42 JST Fediverse Contractor

     in reply to

     • meso
     No I mean how do you get a list of people that block you. I can’t even imagine how long mine is.
   • Embed this notice
     meso (meso@asbestos.cafe)'s status on Sunday, 05-Feb-2023 01:15:43 JST meso

     in reply to

     • Fediverse Contractor
     @bot @errante i have no clue at all i thought maybe 50 or 80 blocks would be the maximum I would have but no 217
   • Embed this notice
     errante (errante@rot.gives)'s status on Sunday, 05-Feb-2023 01:21:10 JST errante

     in reply to

     • kroner
     • Fediverse Contractor
     • meso
     @meso @bot @kroner also it needs to be in a file so that you can pass it a paraemeter
     Fediverse Contractor likes this.
   • Embed this notice
     errante (errante@rot.gives)'s status on Sunday, 05-Feb-2023 01:21:11 JST errante

     in reply to

     • kroner
     • Fediverse Contractor
     • meso
     @meso @bot @kroner why would you tell bot
   • Embed this notice
     meso (meso@asbestos.cafe)'s status on Sunday, 05-Feb-2023 01:21:13 JST meso

     in reply to

     • kroner
     • Fediverse Contractor

     @bot @errante ask @kroner to run this script on the server

     #!/bin/sh PRE="sudo -u postgres psql -U postgres -d pleroma -c" sql="select u.nickname, uu.nickname from user_relationships r join users u on u.id = r.source_id join users uu on uu.id = r.target_id where relationship_type = 1 and uu.nickname = '""$1'" ${PRE} "$sql"
   • Embed this notice
     Fediverse Contractor (bot@seal.cafe)'s status on Sunday, 05-Feb-2023 01:23:04 JST Fediverse Contractor

     in reply to

     • kroner
     • meso
     I don’t know how you guys figure this stuff out. Why can’t it just be like “list users that block bot” instead of some schizo language?
   • Embed this notice
     Fediverse Contractor (bot@seal.cafe)'s status on Sunday, 05-Feb-2023 01:28:43 JST Fediverse Contractor

     in reply to

     • kroner
     • meso
     I’m js, it’s unreadable.
   • Embed this notice
     errante (errante@rot.gives)'s status on Sunday, 05-Feb-2023 01:28:44 JST errante

     in reply to

     • kroner
     • Fediverse Contractor
     • meso
     @bot @kroner @meso you could pretty easily write a pleroma specific language that tells you things about the pleroma database, but why do that when you have a language that tells you things about any database?
   • Embed this notice
     errante (errante@rot.gives)'s status on Sunday, 05-Feb-2023 01:28:45 JST errante

     in reply to

     • kroner
     • Fediverse Contractor
     • meso
     @bot @kroner @meso what is 'block'? what is 'user'?
   • Embed this notice
     errante (errante@rot.gives)'s status on Sunday, 05-Feb-2023 01:28:46 JST errante

     in reply to

     • kroner
     • Fediverse Contractor
     • meso
     @bot @kroner @meso programming languages are meant to unambigously represent a command to the computer; that sentence is far from unambigous
   • Embed this notice
     errante (errante@rot.gives)'s status on Sunday, 05-Feb-2023 01:28:47 JST errante

     in reply to

     • kroner
     • Fediverse Contractor
     • meso
     @bot @meso @kroner lmao bot retarded
   • Embed this notice
     meso (meso@asbestos.cafe)'s status on Sunday, 05-Feb-2023 01:33:13 JST meso

     in reply to

     • kroner
     • Fediverse Contractor
     @errante @bot @kroner yeah, and it's very specific. Pleroma doesn't have a database of its own it uses a general-purpose database where you can store anything. probably the naming is the only confusing thing - tables, rows, etc. you store rows which have multiple columns in them inside tables.
     
     SQL is actually one of the most human-like languages in programming. you literally query the database to "select bot FROM users" for example to fetch the bot user.
     
     the SQL query there is actually a bit complicated, but that's because you have to learn the language to understand what it does. I don't, but from what I can tell it selects u.nickname and uu.nickname (the nickname of u and uu, the dot is to fetch that from them) from the user_relationships table. then it does some stuff to select specifically the block relationship type (which is "1" i think)
     Fediverse Contractor likes this.
   • Embed this notice
     cracky (cracky@rot.gives)'s status on Sunday, 05-Feb-2023 01:52:37 JST cracky

     in reply to

     • kroner
     • Fediverse Contractor
     • meso
     @bot @meso @errante @kroner the sql statement in there is about as close to doing that as you can get with computer stuff without it becoming obnoxious in other ways
     
     a programming language that just tries to resemble english language as much as possible is applescript: https://rosettacode.org/wiki/100_doors#AppleScript and i can tell you that in a lot of cases it's just obnoxious to write. "am i phrasing this in the exact way it needs to be phrased??"
     
     the sql statement is kind of extra annoying because the way pleroma stores its idea of users, relationships between users, and of a relationship being a 'block' is kind of dumb, but the way it stores the ideas of posts and "a post being private" is really really really dumb so code that does "show me all of bot's private posts" would be a mess
     
     if anything that code is unusually /readable/ because it is just "show me everyone who blocked errante" instead of something like "please open a list of all users and then retrieve the user who goes by errante and remember than and then look at each user inividually and then tell me the list of everyone that user has blocked and then check to see if errante is in that list and if errante is in that list then tell me the name of that user and then if there is a problem doing any of that then don't bother me with that information but just look at the next user, and also if that all went ok then go to the next user too"
     Fediverse Contractor likes this.
   • Embed this notice
     meso (meso@asbestos.cafe)'s status on Sunday, 05-Feb-2023 01:52:39 JST meso

     in reply to

     • kroner
     • Fediverse Contractor
     • Hera
     @alfredohno @errante @bot @kroner yep that's true just simplifying it because I said ./ in the example
     Fediverse Contractor likes this.
   • Embed this notice
     Hera (alfredohno@snowdin.town)'s status on Sunday, 05-Feb-2023 01:52:40 JST Hera

     in reply to

     • kroner
     • Fediverse Contractor
     • meso

     @meso @errante @bot @kroner For what it’s worth, you can run any file marked as executable on your system, whether it’s in $PATH or not, by simply providing the full path to the file in the terminal. I. E. putting “/home/your-user/Downloads/blocks.sh bot” in the terminal without anything else, will run it the same as if you ran “./blocks.sh bot” from within the Downloads folder

   • Embed this notice
     meso (meso@asbestos.cafe)'s status on Sunday, 05-Feb-2023 01:52:41 JST meso

     in reply to

     • kroner
     • Fediverse Contractor
     • meso
     @errante @bot @kroner the $1 is the first argument that is called when you run the script btw
     
     if you place the script in a file called blocks.sh, you will run it like "blocks.sh bot" (and preface it with ./ to indicate the file is in the current directory, because normally Linux runs binaries from the /usr/bin or /usr/local/bin directories if they are present there, this just ensures it runs the local file rather than the installed binaries)
     
     the "bot" (or any other string of text) is the argument, and you refer to it with $1 inside the script