you've all probably heard this origin story before but i'll tell it again anyway
i downloaded PR2 and joined the discord and figured "eh what the heck i'll join jiggmin's village too!" and here i am!
i'm not all that new to forums but i would still like to have this question answered for this lovely site, is double posting allowed?
thanks :3

Problem: Players have to wait more than 7 days after rating a level before they can rate it again
Type of Problem: Server
Expected Behavior: Players have to wait exactly 7 days (604,800 seconds) before rating a level again
Actual Behavior: Players have to wait more than 7 days before rating a level again
Steps to Reproduce the Problem:
1. Rate Memories by Stunt (6508994) 5 stars
2. Wait exactly 7 days
3. Try to rate it 5 stars again
You will get the message: Error: You have recently voted on this level. You can vote on it again in a week.

Additional Information:
This problem lies in the platform-racing-2-server/common/queries/ratings.php file.
On line 57, old ratings are deleted if they are more than 7 days old.
This means that ratings that are exactly 7 days old will not get deleted, and players will have to wait an extra day for the query to be run again.

Given that players can rate levels during any time of the day, they will most likely have to wait more than 7 days before they can rate again.
For example, if I rate a level 6 hours into the day, the rating deletion query will run X.75 days after the rating was made, meaning that I will have to wait 7.75 days before I can rate again.
No matter when I rate a level, I will have to wait 7.00-7.99 days (average of 7.5) before I can rate it again.

So I think the rating deletion query should delete ratings that are 6.5+ days old, so that players will only have to wait 6.50-7.49 days (average of 7) instead.

Either that, or the daily queries should be run more often.

I wanted to share some quality of life suggestions:

- Enable user to click through Chat/PMs/Friends while queued for a match. Disable function when a player selects "ready" so as to draw user focus back to their queue.

- Remove 10 second time limit on kicking Guild members or enable users to kick multiple Guild members at a single time (check box, etc.).

- Add a "reset" button on the level search tab so as to clear the tab from searches.

- Disable level voting for players who forfeit a match (I'm guilty of this myself).

- Enable RNG to check whether or not all players already have the item that the RNG is about to offer. Perhaps this could be done by having RNG roll after players have queued into the lobby or have all pressed play. I imagine this would only delay loading by a few seconds. If you don't wanna do that then maybe just give the winning player an EXP bonus if they win and already have that item.

- Allow players to play all Campaigns on the same server. Maybe enable pages on the Campaign tab? Having them arranged in sequential order would be nice too.

- Display original publication date for levels. Example: Newbieland 2's date says 2013...

- Enable users to change their username every 90 days.

- Alter EXP formula to be more respectful of players' time. I can think of a few valid reasons to do this now. The player count just isn't there anymore. The exponential becomes frankly ludicrous after level 30. Maybe alter the formula up to Rank 50 and then leave the default formula after that so as to not ruin the lives of the people who have been simming for the past 10 years.

- Fix F@H rank up tokens. Also can the max amount of rank up tokens be an even number like 10? 

Attached Files

Thumbnail(s)
   

Welcome to Round 74 of Campaign of the Month!

You'll be able to submit your Campaigns on this thread.
Additionally, if you have any levels you'd like to advertise, you can post them here too.

What would you like to see be added/altered for Level of the Week? Would you like to see any events? I'm curious

Here are our finalists for round #73 of Campaign of the Month!

Finalists:
Theme by Author

- The Fire vs Ice Campaign by @Addy
- The Crappy Campaign by @Master Raiden

@Addy and @Master Raiden must abstain from voting.

All votes will go through a verification process. Fraudulently placed votes will result in disciplinary action including (but not limited to) disqualification of campaign/vote, suspension of participation/voting privileges, and PR2 disciplinary action.

For a sample judging scheme, you can see @bls1999's judging streams on YouTube.
Voting closes on April 1st. Thanks!