@Jean-Louis, where would this self-favorited badge go? Just on this page, or everywhere on every index page, or on the game page itself? You could just list such on your About page, but that wouldn't be very visible. I think it would need to be restricted, or we have the same issue as now: self-favoriting all your games doesn't hurt the ranking or visibility, and the reader has to look over a lot of games to notice what's happening and decide they don't care about badges given by a self-congratulatory author.
I discovered the problem with no-information Favorites on this page: their ItemID's are incorrect, generally for containing a hyphen between words where the actual ItemID has just concatenated the words. I remember there was some issue around that, but don't remember the details. I can just remove hyphens in the ItemID field of the Favorites table, but I'm not sure if there's an underlying problem that would need to be fixed to prevent future issues.
(For other editors or me later: I found these by querying Favorites left join Item using(ItemID) where Item.ItemID is null.)
@Jean-Louis, where would this self-favorited badge go? Just on this page, or everywhere on every index page, or on the game page itself? You could just list such on your About page, but that wouldn't be very visible. I think it would need to be restricted, or we have the same issue as now: self-favoriting all your games doesn't hurt the ranking or visibility, and the reader has to look over a lot of games to notice what's happening and decide they don't care about badges given by a self-congratulatory author.
I discovered the problem with no-information Favorites on this page: their ItemID's are incorrect, generally for containing a hyphen between words where the actual ItemID has just concatenated the words. I remember there was some issue around that, but don't remember the details. I can just remove hyphens in the ItemID field of the Favorites table, but I'm not sure if there's an underlying problem that would need to be fixed to prevent future issues.
(For other editors or me later: I found these by querying
Favorites left join Item using(ItemID) where Item.ItemID is null.)