Kaboom!
Looks like all my abc links are broke... Sorry
Found it. It is the function "site_aggregates_activity" which essentially says if you have published a comment or a post since the target time (day, month, 6 month etc) you are considered active. Here is the code
select c.creator_id from comment c inner join person u on c.creator_id = u.id where c.published > ('now'::timestamp - i::interval) and u.local = true union select p.creator_id from post p inner join person u on p.creator_id = u.id where p.published > ('now'::timestamp - i::interval) and u.local = true
I couldn't find anything. I'm sure it is in the code here somewhere but can't find it in there either. https://codeberg.org/thefederationinfo/the-federation.info
Yup with a paid account. Tried a bunch of others but it chatgpt appears to give best results.
Thank you kind sir!
There is also this bot community that copies from the world news subreddit (post only) !worldnews@lemmit.online
Great insight, thank you
Oh woopsie. Full of typos. Day 478. Will fix that one.
Yeah I love this YouTube channel. Sometimes I wish he covered more areas but then the concise and clear is what makes it great.
/s