LaunchBox Games Database Updates for March 1st, 2023

[Thanatos_Prime]

4 minutes ago, Jason Carr said:

Also, FYI, I just banned AlphaPictoris from the games database for uploading explicit porn games. We're going to be cracking down hard on this going forward. If you find porn in the moderation queue, I would appreciate it if you could take a screenshot of it and PM it to me (and of course, reject it). Thanks all.

To be clear the banning is for the images he uploaded, not the creation of the game itself, correct? Games can be created and modified as long as the content does not contain nudity or pornography?

[Jason Carr]

1 minute ago, Thanatos_Prime said:

To be clear the banning is for the images he uploaded, not the creation of the game itself, correct? Games can be created and modified as long as the content does not contain nudity or pornography?

To be honest, I don't think we need them at all. But yes, he was banned because he was posting explicit images.

[Scotsman]

2 hours ago, Jason Carr said:

Both of these issues should be fixed now.

Thanks. The stats are now changing again,

However something else seems to have cropped up. Just 1 approval or rejection is adding 16 to either total.

Edited March 11, 2023 by IainSA

[Jason Carr]

36 minutes ago, IainSA said:

Thanks. The stats are now changing again,

However something else seems to have cropped up. Just 1 approval or rejection is adding 16 to either total.

I will review on Monday, but it's likely that they just took a jump because they weren't updating for a while.

[JereBear]

14 hours ago, IainSA said:

Thanks. The stats are now changing again,

However something else seems to have cropped up. Just 1 approval or rejection is adding 16 to either total.

 

I am getting 18 added to the totals for each approval. This is like a double XP weekend. 

[Thanatos_Prime]

Despite still working through the issues, the speed is just breathtakingly fast for moderations. As soon as I verify sources and click to approve it is on the next moderation in a flash! Absolutely outstanding!!

[Jason Carr]

On 3/10/2023 at 6:10 PM, IainSA said:

Thanks. The stats are now changing again,

However something else seems to have cropped up. Just 1 approval or rejection is adding 16 to either total.

 

On 3/11/2023 at 8:16 AM, Thanatos_Prime said:

Despite still working through the issues, the speed is just breathtakingly fast for moderations. As soon as I verify sources and click to approve it is on the next moderation in a flash! Absolutely outstanding!!

After reviewing this and testing everything, I believe this is working as it always has, though I agree that it's a bit confusing. When a game is added to the database, for example, there are actually many different "change" records included in that moderation process. There's a change for each field, basically (game title, ESRB, developers, publishers, etc.). So in the database, that's represented as a moderation for each change, even though you may have only clicked the Accept or Reject button once. Some moderations (like game deletions) will only increase the value by one, but others may add quite a bit more to the value. So "Total Moderations" is not "total times the button was pressed". It's more "total actual moderated changes to the database, including each and every field". I believe it always worked that way, but I can't say whether there were bugs previously that may have affected that number.

[Jakatsu]

It seems that there's plenty of duplicate games being generated at the moment. This is just one example, at least five other games for Amstrad CPC platform alone have multiple duplicates, up to six per game.

Edited March 16, 2023 by Jakatsu

[Jason Carr]

5 hours ago, Jakatsu said:

It seems that there's plenty of duplicate games being generated at the moment. This is just one example, at least five other games for Amstrad CPC platform alone have multiple duplicates, up to six per game.

Thanks for the heads-up; will look into it.

[Jason Carr]

8 hours ago, Jakatsu said:

It seems that there's plenty of duplicate games being generated at the moment. This is just one example, at least five other games for Amstrad CPC platform alone have multiple duplicates, up to six per game.

 

2 hours ago, Jason Carr said:

Thanks for the heads-up; will look into it.

Alright, apparently I re-introduced the duplicate games issue in the last update, sigh. It should be resolved now. I'm also working on removing the duplicates that were introduced in the mean time.

[Jason Carr]

I've removed all duplicate games in the database, and added a restriction to the game table on the database that no two games can have the same title and platform. There were roughly 300 duplicates in the database that have been deleted.

Going forward, in the very rare case that there are two different games with the same title for the same platform, we should add them as Game Title (Developer Name). This should stop any back and forth with games getting deleted and re-added because they're assumed to be duplicates, and should help us maintain a much cleaner database.

Thanks everyone for your feedback and help on the database.

[Thanatos_Prime]

5 hours ago, Jason Carr said:

I've removed all duplicate games in the database, and added a restriction to the game table on the database that no two games can have the same title and platform.

 

YES!!!

 

[Kjetter]

On 3/8/2023 at 12:45 AM, Jason Carr said:

Okay, I think I found the problem here. The system is currently working through a backlog of changes that need promoted, so it will probably be a while, but I think I have this resolved. Thanks for the help.

I'm still experiencing the "pending" issue. In my case some of my submissions have 3 pro / 0 con but still stick at pending, and one is stuck at 10 pro / 1 con. Others go through without problem. I assume it will sort itself out eventually, just figured it was worth mentioning that it's happening.

Edited March 18, 2023 by Kjetter

[Dan Patrick]

Hey Jason, I submitted these two that seem stuck in limbo. No rush of course, but you might look into it. Thanks

[Khaar]

10 hours ago, Dan Patrick said:

Hey Jason, I submitted these two that seem stuck in limbo. No rush of course, but you might look into it. Thanks

@Jason Carr

The same for me.

I have several images with very high approval numbers on pending status. The oldest picture has been in the queue for more than eight days and has 27 approvals (3 rejections)!

Just to show a few of them:

PS: In case it helps find the problem, my Games Database username is Giovanni_84

Edited March 18, 2023 by Khaar

[LonestarK]

experiencing the same pending issue.  attempting to change this box top from a banner to a box spine.

[Jason Carr]

Thanks guys, will review on Monday.

[Jason Carr]

FYI all, the previous issue with changes stuck in limbo was unfortunately reintroduced because a stored procedure got reverted (it was my mistake). Apologies for that (again). That has been fixed.

[Jakatsu]

Apparently removing a release date and leaving the field empty doesn't work. Tried this with some of the unreleased prototype entries, and the change didn't show in my Changes Status page, so I assume it doesn't come up in the moderation que either. Also, clicking the Genre field doesn't show the list of genres until you type in a letter.

[Thanatos_Prime]

On 3/20/2023 at 9:00 AM, Jason Carr said:

FYI all, the previous issue with changes stuck in limbo was unfortunately reintroduced because a stored procedure got reverted (it was my mistake). Apologies for that (again). That has been fixed.

I still have one outstanding item, a C128 game that I accidentally added with scanlines on, which I will fix after approval or disapproval. It was submitted 3/16, and this is the current status as of this minute.