Jump to content
LaunchBox Community Forums

DB Continuous Development Thread v1 ("Beta" Thread)


Vlansix

Recommended Posts

Hi Guys,

This will serve as the alter-ego to the LaunchBox Beta Testing thread.

Please let us know if anything doesn't work as advertised, or anything needs revamping a bit :). I'll post most of the new developments here so as to not flood the forums with updates.

Thanks! :)

 

##########

Useful Links:

Console Metadata Thread

LB Beta Testing (6.8+) Thread

Chrome Extension - DB Search Thread

Firefox Addon - DB Search Thread

Edited by Vlansix
  • Like 4
Link to comment
Share on other sites

Alright, let's get it started:

SO I was submitting Alternate names today, and going through the Changes Status pages, it looks like some games had names submitted that I had added to different games. I've attached a screenshot because I'm not sure how to describe it. There are quite a few errors like this in my pending changes.

Capture.PNG

  • Like 1
Link to comment
Share on other sites

Just found an issue as I was looking for an example of a game alternate name moderation request. Please don't select the "Year Only" checkbox and then add a date with special characters in the text field below. The server won't like it, and it'll crash the moderation pages with a 500 internal server error. I'll filter most of them out from now on, but it's still good practice not to do it :).

In any case, i'll fix it in a few minutes, but aye. Special characters are bad. If you fall on this entry, it won't go past moderation until I get to it. 

Image2.png

Edit: Fixed now. But ugh O.o

Edit 2: Going to go to sleep now, I'll get back on this stuff in the morning working on the comments made on the announcement board. Be aware, we're encountering some instability due to some characters being encoded somewhere and causing problems with our form validation and crashing everything. It's something I'm looking into as well, so, if you encounter a 500 internal server error, please report it to the bug tracker with as many details as possible :).

Edited by Vlansix
Link to comment
Share on other sites

Morning guys,

So, quick update- fixed https://bitbucket.org/jasondavidcarr/gamesdb.launchbox-app.com/issues/170/bug-multiple-images-section-in-new-game 

I'm currently looking into making the details page look a bit better. Once i'm done with that, i'm either jumping on the encoding issue that's causing all the random crashes or fixing the extremely slow moderation speeds. Let you know once i'm there :).

@Cebion - Thanks! We're doing our best :). To be fair, I'm not a webdev guy, so this is taking a bit longer than it should, but I'm glad to be of help :).

Edit: Introduced another error while fixing the above bug. Already fixed, will be pushed up shortly, as well as fixing the aesthetics of the details page.

Edited by Vlansix
  • Like 1
Link to comment
Share on other sites

So. Currently fixing the bloody crashes that have been happening randomly (see https://bitbucket.org/jasondavidcarr/gamesdb.launchbox-app.com/issues/145/confirmed-server-error-in-application )

 

Here's the thing. We have a lot of corrupt data in the database. It's nothing major, as the fix I'm implementing will remove it whenever someone sends a change request to an impacted game, but the issue is as follows- It'll send the correction as a change request, which needs to go through moderation. Sadly, due to the limitations of text processing (and the fact that I don't have a supercomputer to do the text analysis required), I won't know if the fact that there are four linebreaks in a row, all encoded differently, was intentional. Or if there's a bunch of ampersands, all encoded differently, was intentional. So, all i'm doing now is correcting their encoding so they don't break anything and work with the rest of the database's systems, but it may cause some edits to look odd. I was thinking of adding a header to the change that says something like "[AUTOMATICALLY GENERATED CHANGE - PLEASE ALLOW]". We'd still need to remove that afterwards, but it'd help mods notice that "Oh yeah, the fact that these two paragraphs are separated by fifteen linebreaks is normal. We'll just need to fix it afterwards."

 

EDIT: Actually, nevermind. It's obvious in the edit screens what's happening, everyone will see it. Here's a screenshot.

Image2.png

 

Edit2: Online now. I've ran it through a bunch of problematic entries, and it seems to work well. Lemme know if it doesn't :).

Edited by Vlansix
  • Like 3
Link to comment
Share on other sites

So. Moderation speed has been fixed now, just waiting to pass it through Jason first, and I'll upload it. Should be ridiculously fast. I'll be adding a way to see your prior archived changes in a little bit. (i.e. you won't be able to see any changes that you had approved/denied prior to today. This is normal. It'll be fixed shortly :P)

 

Matchplan for today is-

1. Get the mod speed fix online (EDIT: Done)

2. Upload the platform metadata @In virtute Dei has painstakingly scraped together to the platforms, as well as edit all of the images that need editing

2.a - @Cebion - Started looking into fixing the alternate character issue. Depending on how it goes, the DB should be able to support pretty much every single language when I'm done. The issue i'm seeing is scraping through LaunchBox for those characters, but we'll look into that later. Basically, what I'm saying is: Half of it will work (the DB), but LaunchBox may not be able to scrape those characters until jason or myself start looking at the parser within the executable to make that possible. Still, it's an improvement :).

3. If there's any time left (depends on how long 2 will take), start working on some of the moderation enhancements on the issue tracker.

 

Edited by Vlansix
  • Like 3
Link to comment
Share on other sites

  • 3 weeks later...

Hey Guys!

I'm not sure if this is the right place to ask but wouldn't it be great to have some crowdsourced fields like:

- Number of times a game was played (This way it would be easy to create a ranking internally in bigbox to sort the games)

- Average number of start or votes for a game (same as above it could be used as a sorting method)

- Number of users that have the game between their favorites (another sorting method)

- Most used emulator per game (to help people better setup their games)

Of course this should all be aggregated metrics in order to maintain privacy.

 

Thanks, and please let me know if I should post this in another place.

 

By suggestion of @In virtute Dei here's the ticket for this feature: https://bitbucket.org/jasondavidcarr/launchbox/issues/2064/add-community-db-fields-like-total-number

VOTE FOR IT IF YOU LIKE IT!

Thanks.

Edited by grupoapunte
  • Like 1
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...