In an old group I once owned (currently closed off and abandoned), I don’t know what I was doing or what happened, but I happened to get my game to -1 favorites. Adding it to my favorites sets it to 0. It’s nothing important and it doesn’t affect anyone, but a bug is a bug so here it is I guess.
I’m just curious… how does this even happen? It seems to me that this feature, among other features that count things such as friends, would be based on a COUNT() from an SQL database… how would would it ever become -1?
I don’t think this is managed by a singular relational database, that doesn’t seem very scalable considering there are places with hundreds of thousands of likes and favorites. What most likely happens is that they store, per user, which things they favorited/liked, and per place they only store the tally of likes/favorites which is incremented/decremented for every user action.
Place visits have been set to 0, not sure if it was reset in the system or because someone was able to increment the favorites number by adding the game to their favorites.