０７６萌ＳＮＳ
  • Login

  • Public

    • Public
    • Network
    • Groups
    • Popular
    • People

Notices by :blank: (i@declin.eu), page 3

  1. :blank: (i@declin.eu)'s status on Friday, 04-Oct-2024 00:59:56 JST :blank: :blank:
    • Haelwenn /элвэн/ :triskell:
    • Proud owner of a potato sack :flag:
    • Jake (formerly sjw) :lain_sneed:
    @j @lanodan @hj probably easier to run two queries than complicate the sql futher

    select concat(nickname, '@bae.st') from users join (select following_id from following_relationships where follower_id = (select id from users where nickname = 'CHANGEME')) as _user on users.id = _user.following_id where users.local = 't';
    select nickname from users join (select following_id from following_relationships where follower_id = (select id from users where nickname = 'CHANGEME')) as _user on users.id = _user.following_id where users.local = 'f';
    In conversation about 2 months ago from declin.eu permalink
  2. :blank: (i@declin.eu)'s status on Friday, 04-Oct-2024 00:59:53 JST :blank: :blank:
    • Haelwenn /элвэн/ :triskell:
    • Proud owner of a potato sack :flag:
    • shitpisscum
    • Jake (formerly sjw) :lain_sneed:
    @j @shitpisscum @lanodan @hj select split_part(upload->>'href','/', 5) from (select jsonb_array_elements(data->'url') as upload from objects where data->>'actor' = (select ap_id from users where nickname = 'CHANGEME')) where upload->>'type' = 'Link';
    In conversation about 2 months ago from declin.eu permalink
  3. :blank: (i@declin.eu)'s status on Friday, 04-Oct-2024 00:59:42 JST :blank: :blank:
    in reply to
    • Haelwenn /элвэн/ :triskell:
    • Proud owner of a potato sack :flag:
    • Jake (formerly sjw) :lain_sneed:
    @j @lanodan @hj this

    select ap_id from users join (select following_id from following_relationships where follower_id = (select id from users where nickname = 'CHANGE ME')) as _user on users.id = _user.following_id;
    In conversation about 2 months ago from declin.eu permalink
  4. :blank: (i@declin.eu)'s status on Friday, 04-Oct-2024 00:59:40 JST :blank: :blank:
    • Haelwenn /элвэн/ :triskell:
    • Proud owner of a potato sack :flag:
    • Jake (formerly sjw) :lain_sneed:
    @j @lanodan @hj single quote ' not double " quote for sql
    In conversation about 2 months ago from declin.eu permalink
  5. :blank: (i@declin.eu)'s status on Friday, 04-Oct-2024 00:59:37 JST :blank: :blank:
    • Haelwenn /элвэн/ :triskell:
    • Proud owner of a potato sack :flag:
    • Jake (formerly sjw) :lain_sneed:
    @j @lanodan @hj select nickname instead of ap_id and csv import will work
    In conversation about 2 months ago from declin.eu permalink
  6. :blank: (i@declin.eu)'s status on Friday, 27-Sep-2024 01:30:12 JST :blank: :blank:
    in reply to
    • 
    • Inginsub Avatar Tracker
    @mint @Inginsub_tracker blood test result notes
    In conversation about 2 months ago from declin.eu permalink
  7. :blank: (i@declin.eu)'s status on Thursday, 26-Sep-2024 21:44:03 JST :blank: :blank:
    in reply to
    • Terry
    • nyanide :nyancat_rainbow::nyancat_body::nyancat_face:
    @nyanide @Terry one for each user on the instance, there's not really a way to dedup it without breaking a bunch of stuff
    In conversation about 2 months ago from declin.eu permalink
  8. :blank: (i@declin.eu)'s status on Thursday, 26-Sep-2024 17:38:54 JST :blank: :blank:
    in reply to
    • THE MARTYR OF BUTLERIAN JIHAD
    • Angry Sun
    @sun @icon_of_computational_sin @Arwalk more or less, people don't want a repeat of x11, but people going out of their way to stall everyone isn't the way forward either
    In conversation about 2 months ago from declin.eu permalink

    Attachments


    1. https://declin.eu/media/cb50a24dcc742892aee012342b500e6413459de3aa3a38ed056f0a215125df78.png
  9. :blank: (i@declin.eu)'s status on Wednesday, 25-Sep-2024 00:17:17 JST :blank: :blank:
    in reply to
    • 
    • FWC
    • .
    @_test @FUCKINGWHOCARESDUDE @mint proabably the matter of having established the relay from before that was enabled, could send you their users to add to your db, might make it work then
    In conversation about 2 months ago from declin.eu permalink
  10. :blank: (i@declin.eu)'s status on Monday, 23-Sep-2024 18:52:05 JST :blank: :blank:
    in reply to
    • ul
    @ul bad case of the mondays
    In conversation about 2 months ago from declin.eu permalink

    Attachments


    1. https://declin.eu/media/a59fc0ac463a8786cd329b3580f44e5a7b87d8a60e6dcc6a7153b7aee99862f0.media-cache
  11. :blank: (i@declin.eu)'s status on Saturday, 21-Sep-2024 04:01:40 JST :blank: :blank:
    in reply to
    • 
    @mint no luck with internship?
    In conversation about 2 months ago from declin.eu permalink
  12. :blank: (i@declin.eu)'s status on Sunday, 08-Sep-2024 05:31:37 JST :blank: :blank:
    down bad (just pirated intelephense with a github search)
    In conversation about 3 months ago from declin.eu permalink
  13. :blank: (i@declin.eu)'s status on Sunday, 08-Sep-2024 05:31:36 JST :blank: :blank:
    in reply to
    • :blank:
    absolving myself of sin by reading scripture (the php.net manual)
    In conversation about 3 months ago from declin.eu permalink
  14. :blank: (i@declin.eu)'s status on Thursday, 05-Sep-2024 06:58:47 JST :blank: :blank:
    in reply to
    • Angry Sun
    @sun should have had it blessed smh
    In conversation about 3 months ago from declin.eu permalink

    Attachments


    1. https://declin.eu/media/7b02d76014529a65e6c52ab0538e60221acf91fbde51d59be895950a6a5c5fdc.png
  15. :blank: (i@declin.eu)'s status on Tuesday, 03-Sep-2024 20:53:28 JST :blank: :blank:
    in reply to
    • 
    • † top dog :pedomustdie:
    @dcc @mint who needs html sanitization anyway, rip it out
    In conversation about 3 months ago from declin.eu permalink
  16. :blank: (i@declin.eu)'s status on Monday, 02-Sep-2024 02:47:01 JST :blank: :blank:
    in reply to
    • Jake (formerly sjw) :lain_sneed:
    • Revolver Countdown
    @j a second @RevolverCountdown deadline has hit the network
    In conversation about 3 months ago from declin.eu permalink
  17. :blank: (i@declin.eu)'s status on Monday, 02-Sep-2024 02:03:01 JST :blank: :blank:
    in reply to
    • Jake (formerly sjw) :lain_sneed:
    @j another pillar falls, bless you on your journey forward
    In conversation about 3 months ago from declin.eu permalink
  18. :blank: (i@declin.eu)'s status on Friday, 30-Aug-2024 03:35:50 JST :blank: :blank:
    in reply to
    • † top dog :pedomustdie:
    • Angry Sun
    • Autismmaxxing Schizo Weebcel
    @faggotracist1488 @dcc @sun depends on how you count it, current ditto db has 5332951 events tagged with activitypub, 6314390 events without, with 11647430 in total

    so more like half the network
    In conversation about 3 months ago from declin.eu permalink
  19. :blank: (i@declin.eu)'s status on Saturday, 10-Aug-2024 20:05:46 JST :blank: :blank:
    in reply to
    • Proud owner of a potato sack :flag:
    • :ihavenomouth:
    • cassidyclown
    • cream queen
    • ​
    • ㅤ
    • giru
    @plague @Inginsub @cassidyclown @creamqueen @eidolon @giru @hj i thought my pleroma-fe develop build was broken because it took over a few minute of looking at a white screen for it to finally load the first before being cached out lol

    it does work well after that, but nothing beats pre rendering it out for raw efficiency
    In conversation about 3 months ago from declin.eu permalink
  20. :blank: (i@declin.eu)'s status on Saturday, 10-Aug-2024 20:04:37 JST :blank: :blank:
    • Proud owner of a potato sack :flag:
    • :ihavenomouth:
    • cassidyclown
    • cream queen
    • ​
    • ㅤ
    • giru
    @plague @Inginsub @cassidyclown @creamqueen @eidolon @giru @hj who needs iframes anyway
    In conversation about 3 months ago from declin.eu permalink

    Attachments


    1. https://declin.eu/media/d5b0eb765237f646ad4470afdca6400712332fecd90452d0e24012fb33b08501.jpg
  • After
  • Before

User actions

    :blank:

    :blank:

    :blank:THE CHEMICALS ARE TELLING ME @i MUST PERISH LIKE A DOG!:blank:

    Tags
    • (None)
    ActivityPub
    Remote Profile

    Following 0

      Followers 0

        Groups 0

          Statistics

          User ID
          20928
          Member since
          29 Mar 2023
          Notices
          532
          Daily average
          1

          Feeds

          • Atom
          • Help
          • About
          • FAQ
          • TOS
          • Privacy
          • Source
          • Version
          • Contact

          ０７６萌ＳＮＳ is a social network, courtesy of ０７６. It runs on GNU social, version 2.0.2-beta0, available under the GNU Affero General Public License.

          Creative Commons Attribution 3.0 All ０７６萌ＳＮＳ content and data are available under the Creative Commons Attribution 3.0 license.