You know, ever since Brian updated the level rating system coding in late 2015 or so, all the newly-made ratings are increased by one. For example, if you give something a 8/10 rating, the system registers it as 9/10.

Take these Death of Massassi Level Pack levels, for example:
https://www.massassi.net/levels/files/3135.shtml
https://www.massassi.net/levels/files/3132.shtml
https://www.massassi.net/levels/files/3131.shtml

Now, while they all clearly deserve a 11/10 rating, the rating system is still kinda broken.

To further demonstrate this, I took the liberty of giving this previously unrated, uh, thing a 10/10 rating, but - as mentioned in "all the newly-made ratings are increased by one", its rating is now 11 as well.

OMG.

I can explain the rating thing. The original mysql database (like from the late 90s) used an ENUM column to store ratings, with possible values 1-10. However, when mysql got ahold of them, they stored 0-9. Then when I would retrieve the data from the db, I'd get back not the rating someone added, but 1 less than the rating they added. So if someone rated it a 10, I'd insert a 10. Then when I SELECTed it back out, mysql would give me a 9. WTF right? So I had code that just +1 the data on the way out. Then when I took back over I put it on the "latest stable" version of mysql, which apparently is no longer totally stupid about ENUM columns. If you insert a 10, then select it back out, it gives you a 10. Great right? Except the +1 code is still in there somewhere.

I suppose I could consider possibly thinking about fixing the rating system. Maybe.

You know, from what I've skimmed through all the posts on these forums over the years, I don't think I've heard many if any good things said about MySQL or PHP.

Couldn't you just add an automatic -1 function in there somewhere? >_>

I could. Yeah mysql and php suck. But remember, this site was coded in php 3. Which is 10x worse than whatever the latest version is.

It looks like "No" is winning.

I vote for anything that means more work for Brian.

Still seeing "No" leading by a wide margin.

****, the only other person to vote no was koobie

ccan i change my vote

Looks like the "No" vote is still in the lead. Going to have to call this one.

Despite the fact that the majority of people voted no, I went ahead and fixed the level ratings.

Nice. Thanks, Brian!

and yet FGR remains unbanned

:thinking emoji: