Just from “a quick query” by the admin.

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

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