There was an error with the fediverse-auth on the Canvas site where after a certain point new logins started being logged as all lower case which created duplicates of 59 users and were treated as separate users. I have merged all of the duplicate accounts and rebuild the database.

This also means that all of the stats on Canvas Stats are incorrect. The canvas Stats app has been updated with the new data.

You can find the fixed database dump sql file on my github: https://raw.githubusercontent.com/TheRealMonte/data-files/main/2024/canvas-2024-fixed-sql.sql The file is 33,568 kB.

The SQL file has 4 tables:

• users (user_id, username, ranking, total_pixels_placed)
• colors (color_id, color_name, color_hex)
• pixels (log_id, user_id, x_cord, y_cord, color_id, time_placed, is_mod_action, is_top, time_deleted)
• top_cord (top_cord_id, user_id, x_cord, y_cord, count_placed)

The users table includes the rank and total pixels placed for each user. Deleted pixels are not counted. There are

Another update to Canvas Stats app. You can now view your pixels you placed during the event in your browser and download the pixels as a png image!

I have updated Canvas Stats with the new data from the sql log. Rankings should mostly be the same as the old data, but your total pixel count will be lower since deleted pixels no longer count. A new feature to the site is you can now see if your top coordinate placed is also another users top coordinate placed, which would mean you were probably battling it out over a pixel.

I am also generating images of individual user's pixels. If anyone is interested, just send me a DM. Here is an example of just the pixels that @[email protected] placed:

If you would prefer the background to be black instead of white, let me know in your DM.

Another feature I added was overall stats for the event.

![](https://lazysoci.al/api/v3/image_proxy?url=https%3A%2F%2Fsh.itjust.works%2Fpictrs%2Fimage%

Hi everybody! I have finished building a web app that allows you to search for a user and view their stats from the event! The app will tell you your overall ranking, number of pixels placed, the coordinate you placed the most pixels on, and how many of each color you placed.

I will probably add more features to the website, but I wanted to get something out there so everyone could see how they did.

Thanks @[email protected] for providing the data.

Here is the link to the web app.

In theaters July 26