Just from “a quick query” by the admin.

there’ll be a better one later, this is just a quick query

  • db0
    link
    fedilink
    English
    95 months ago

    Is there a way to see one’s own amount?

    • u/lukmly013 💾 (lemmy.sdf.org)OP
      link
      English
      65 months ago

      You can get the pixels log in this post: https://lemmy.dbzer0.com/post/24143200

      However it may not be accurate as noted.

      My stupid lazy way to get count for someone is

      grep db0@lemmy.dbzer0.com pixels-raw.txt --text | grep pixel_place | nl
      

      Which for you shows me 1545 lines, so 1545 placed pixels.

      ¯⁠\⁠_⁠(⁠ツ⁠)⁠_⁠/⁠¯

      • db0
        link
        fedilink
        English
        55 months ago

        Ah simple enough. Should be possible to identity simple alts (same name, different instance) through this.

        • u/lukmly013 💾 (lemmy.sdf.org)OP
          link
          English
          15 months ago

          I am really sorry. It is simple indeed. Way too simple.

          I just noticed this:

          2024-07-12T04:12:41.142Z        ff5@toast.ooo   pixel_place     183     264     99011A
          ...
          2024-07-12T04:15:13.823Z        Twig_Bug@toast.ooo      pixel_place     183     264     550022  
          ...
          2024-07-12T04:15:16.089Z        Twig_Bug@toast.ooo      pixel_undo      183     264     99011A
          

          Which explains why some pixel_undo have “unset” as their color. I also need to subtract pixel_undo from pixel_place.

          So for you there’s 128 undos. 1545 - 128 is 1417.