Conversation

Notices

1. Embed this notice
   pnotifbot (pnotifbot@freespeechextremist.com)'s status on Tuesday, 03-Oct-2023 09:47:06 JST pnotifbot
   228 unread notifications ▄▁▁▁▁▁▂▂▂▂▂▄▄▄▁▁▁▂▂▂▃▃▁▁▁▁▁▂▂▂▃▄▅▆▆▇▇███ 2023-10-01 05:59 - 2023-10-02 23:59 min/max/avg/stddev: 9/228/77.60/62.77
   • Embed this notice
     pistolero :thispersondoesnotexist: (p@freespeechextremist.com)'s status on Tuesday, 03-Oct-2023 09:47:05 JST pistolero :thispersondoesnotexist:

     in reply to
     :hellduck:
     Haelwenn /элвэн/ :triskell: likes this.
   • Embed this notice
     ロミンちゃん (romin@shitposter.club)'s status on Tuesday, 03-Oct-2023 09:50:28 JST ロミンちゃん

     in reply to

     • pistolero :thispersondoesnotexist:
     @p @pnotifbot this bot reads directly from the instance database? Is the source code public?
     pistolero :thispersondoesnotexist: likes this.
   • Embed this notice
     pistolero :thispersondoesnotexist: (p@freespeechextremist.com)'s status on Wednesday, 04-Oct-2023 04:54:12 JST pistolero :thispersondoesnotexist:

     in reply to

     • ロミンちゃん
     @romin @pnotifbot
     
     > this bot reads directly from the instance database?
     
     Yeah, it does.
     
     > Is the source code public?
     
     It's trivial but everything in the bot is hard-coded. Basically the only part that isn't instance-specific is this:
     
     :mycomputer: SELECT seen, count(seen) from notifications where user_id in (select id from users where local = 't' and nickname = 'p') group by seen;
     
     Except that I just have my user_id hard-coded.
     ロミンちゃん likes this.