I havent been the one looking at the database but im assuming itll be a similar way to how the person table was fixed. Theres essentially duplicate entries for certain communities atm

~~I'm deleting this for now since I have my own post going up connected to our blog~~

Edit: thought this was meta, the blog post is going into meta and ill leave this one up as the event post

Alright ive modded you

Heres my copy paste for the days (every day I switch the day and the title at the top (if I send it before the challenge drops I just do insert name here and then edit it later). When https://adventofcode.com/2023/stats hits 100 for both nums then I unlock the thread and put an edit at the bottom saying its unlocked

(text here is slightly different since 0.19 dropped now so my warning about that is gone)

# Day 15: Lens Library

## Megathread guidelines
- Keep top level comments as only solutions, if you want to say something other than a solution put it in a new post. (replies to comments can be whatever)
- You can send code in code blocks by using three backticks, the code, and then three backticks or use something such as https://topaz.github.io/paste/ if you prefer sending it through a URL

## FAQ
- What is this?: Here is a post with a large amount of details: https://programming.dev/post/6637268
- Where do I participate?: https://adventofcode.com/
- Is there a leaderboard for the community?: We have a programming.dev leaderboard with the info on how to join in this post: https://programming.dev/post/6631465

***

🔒 Thread is locked until there's at least 100 2 star entries on the global leaderboard

I also add a link to the new post on the sidebar calendar when I post it

Title is in the format

🎄 - 2023 DAY 15 SOLUTIONS -🎄

The title emojis ive been rotating through 7 different ones based on the day of the week, can see past days for ones ive used or you can do your own thing

You should get options in the format

When clicking on the three dots on a post (bar the local pin since thats admins only). Community pin pins it / unpins it and the lock locks / unlocks the thread to prevent people from posting in it

Will unmod myself from here after I see its going fine

(If I dont get a reply back by the stats hitting 100 for both puzzles today then ill just post the megathread to catch it for today)

Thats already handled by lemmy ui currently. The same link posts will collapse into the same one

Just isn't supported by some frontends since its a frontend specific feature (mostly the apps)

Comments merging isn't supported though but the post mirrors can be toggled between relatively easily

Yeah ill be editing it and trying to relaunch it in the new year with a different format

Small warning, the change to change how lemmy as a whole calculates active users just got pushed so instances may mess up the stats as they upgrade to 0.19 when thats stable (and instances using it rn when they upgrade to a more recent release client) (Makes how programming.dev and lemmynsfw calculate community stats the default)

It doesn't, still spams low upvote posts, just slightly tweaked ordering

btw if you put the url to nim as /c/nim@programming.dev I dont think the url bot will trigger since it does the same thing the ! format does

[Nim](/c/nim@programming.dev)

Nim

Edit: yeah looks like it didnt reply to me so this format works

Thanks for the feedback

Yeah light theme is something I've barely touched currently but will get the colors on that fixed in the future and will be adjusting the colors in dark theme

I'll note down to fix the theme user agent and font size

For the post you're saying to center are you talking about the post view that pops up from clicking a post in the post feed?

The dot there isn't anything, I was just using it to separate the buttons from the time

And yeah I can tweak the transparency there a bit so the feed doesn't have any attention

yeah federation broke one way only when it was broken. Replies on broken posts from here wont propagate no matter when its done

Looks like that post was made when federation was broken (there was a small window 14 days ago when it went down again) so itll still have issues with federating comments. Recent posts and comments in the community seem to still be fine

Everything seems to be fine in the database so not sure why that wouldnt propagate. Ill do some testing