I want the points to automatically reset on the rankings page on the 1st of each month so I can assign the user on the top of the leaderboard a "user of the month"
Maybe, instead of resetting the leaderboard every month, we could have an all-time leaderboard and a monthly/weekly leaderboard. I think this would be much easier to implement. I'm still sticking with a "user of the month" contest idea as I think it would make communities a lot more engaging.
The idea of having 2 separate leaderboards, an all-time leaderboard and a certain period leaderboard, was taken from the Oculus VR forums. It can be found on the right of this page https://forums.oculusvr.com/community/activity