Just from “a quick query” by the admin.

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

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

      • MonteEnglish
        2•6 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)OPEnglish
      1•6 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.

      • MonteEnglish
        1•6 months ago

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

          • MonteEnglish
            2•6 months ago

            pixel_undo

            Well, shit. I’ll update it

            • u/lukmly013 💾 (lemmy.sdf.org)OPEnglish
              3•6 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”.