Just from “a quick query” by the admin.

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

  • 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.