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
    94 months ago

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

    • u/lukmly013 💾 (lemmy.sdf.org)OP
      link
      English
      64 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
        54 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
          14 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.

  • Monte
    link
    fedilink
    English
    7
    edit-2
    4 months ago

    I took the “Possibly patched pixel log file” that Grant posted and removed the duplicates. This should be the official rankings. I also made a file that shows how many of each color a user placed. I am working on a web app that will let you search for a user and give the user’s stats.

    Edit: Ignore this, both files are wrong because I included pixel_undo and mod_rollback. Fixing now

    Edit2: This file should be the rankings with correct pixel count. This file should be correct in showing how many of each color a user placed.

      • Monte
        link
        fedilink
        English
        24 months ago

        Ok. This is from the “Possibly patched pixel log file” that Grant posted. I then removed any duplicates, removed any lines that were pixel_undo or mod_rollback. I think this is accurate.

    • u/lukmly013 💾 (lemmy.sdf.org)OP
      link
      English
      1
      edit-2
      4 months ago

      Sorry, but did you exclude pixel_undo from the rankings? They shouldn’t count.

      Comparing the numbers it seems you included those as well.

      • Monte
        link
        fedilink
        English
        14 months ago

        yes, I removed any line that didn’t have a username, coordinates, and color hex

          • Monte
            link
            fedilink
            English
            24 months ago

            pixel_undo

            Well, shit. I’ll update it

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

              Hold on, I just realized something. You’ll also have to subtract pixel undo.

              e.g.:

              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
              

              The color there is reverting back to previous, that’s why there is also “unset”.

    • db0
      link
      fedilink
      English
      84 months ago

      From the matrix chat, it’s not an alt. Just a no-lifer.

  • Snoopy
    link
    fedilink
    English
    44 months ago

    Impressive, i didn’t expect this XD

    • threelonmusketeers
      link
      fedilink
      English
      2
      edit-2
      4 months ago

      Congrats! Only seven people ignored the rest of their lives more than you did :)

      • Snoopy
        link
        fedilink
        24 months ago

        The one of the best comment i got there. Thank a lot :D

  • Monte
    link
    fedilink
    English
    44 months ago

    I have also created a file that lists the coordinates that a user place a pixel at the highest number of times.

    • Monte
      link
      fedilink
      English
      4
      edit-2
      4 months ago

      For example: 142446@toast.ooo placed a pixel at (10, 262) 1417 times, which is how they got to the top of the rankings