TheGamesDB.net - Open Video Game Database (wiki-based, register and contribute)

  Thread Rating:
  • 4 Votes - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Post Reply
jas8340 Offline
TheVideoGameDatabase.com Admin
Posts: 37
Joined: Aug 2008
Reputation: 0
Location: Tallahassee, FL
Post: #16
I have modified the API to accept region and platform abbreviations for game search and game detail calls.
find quote
jas8340 Offline
TheVideoGameDatabase.com Admin
Posts: 37
Joined: Aug 2008
Reputation: 0
Location: Tallahassee, FL
Post: #17
I edited my original post, but I also wanted to say it here:

The design of the site is not set in stone. The data entered in the site has been mainly test data. I could really use some help in determining what level of game information to provide. This include description fields, screen shots, trailers, etc...

Based on conversations with Wimpy, he has suggested that I add the following fields to games:

Developer (links to a company record)
Alternate Title
Controller Type
Players
Screen shot(s) (maybe between one and three)
Gameplay video and/or trailer

Is there anything anyone can think of adding/changing/removing?

http://thevideogamedb.com - Site Creator and Admin
find quote
malte Offline
Skilled Python Coder
Posts: 1,352
Joined: Jan 2010
Reputation: 28
Location: Germany
Post: #18
just some ideas:

rating
numVotes
url (if description is a copy from another site)
media
perspective
crc (may be used for API game detection in addition to gamename or filename)

VictorV (a user here in the forum) has started to write a document about designing a game library. It contains useful information and some more game properties that could be of interest. Unfortunately I can't find the link anymore (I think his thread was blown away by the lightning bolt some weeks ago). Maybe he comes in and adds some more ideas (and a link to his work;-))
find quote
wimpy Offline
Fan
Posts: 318
Joined: Nov 2009
Reputation: 2
Location: Porsgrunn, Norway
Post: #19
maybe having Hints / Tricks as a seperate field for gamegenie, hidden features in the game, codes etc aswell is a good idea to seperate it from the description.

perhaps a field for "game series" to tag games related to eachother. For example "Final Fantasy Series". Could be used as a games library sort function.

I remember seeing that thread about a game lib design, but it escapes me aswell now and it's been a while since the lightning blast.. Lets hope it gets up again.

Like i told jas, this is kinda smoke without fire as making the scraper-site before the library even has been started on (afaik) leaves some questions unanswered. Anyone up for the task of (re)starting a games lib development thread and coding? I Think this is the time :o)

www.emuxtras.net | EFnet #EmuXtras
find quote
wimpy Offline
Fan
Posts: 318
Joined: Nov 2009
Reputation: 2
Location: Porsgrunn, Norway
Post: #20
* Walkthrough

Alot of gamers hate this part, but I see it as a definite plus to have in a videogamedb since it's related to the game.

www.emuxtras.net | EFnet #EmuXtras
find quote
jas8340 Offline
TheVideoGameDatabase.com Admin
Posts: 37
Joined: Aug 2008
Reputation: 0
Location: Tallahassee, FL
Post: #21
Ratings
I've been on the fence on how to implement ratings. I think I have most of the structure in place for ratings, I just couldn't figure out a good way to approach it. Here is what I am thinking:

Each region (US, EU, AUS, JP) has their own ratings board. I think it is safe to say that the ratings selection box will be driven by the game's selected region. The problem that I'm running into is that there are multiple versions (or revisions) to each rating system. For example, Sonic 3's original US rating was GA. Since that game has been re-released virtually, it has been reclassified to K-A. Do we only give users the option to select current game ratings or the ability to select old ratings as well?

The reason why I ask is because I'd like to see the actual rating logo be displayed on the screen along with the box art. I'm torn because the current rating makes sense from a parental control perspective but the retro gamer in me says seeing the old school original rating is really cool.

What do you guys think?

Cartridge Type
I think we can add a cartridge type to the platform object instead of adding a cartridge type to each game object. That way we just store the cartridge type 65 times instead of 5000 times.

http://thevideogamedb.com - Site Creator and Admin
find quote
wimpy Offline
Fan
Posts: 318
Joined: Nov 2009
Reputation: 2
Location: Porsgrunn, Norway
Post: #22
Cartridge Type
yes i agree on this point. most systems tend to have mostly the same "media" approach. If anything differs it could be stated in the system description etc (if users feel it's appropriate)

Ratings
I think the idea of supporting most of the regionbased ratingsystems is a good idea. Since a game classified as T (Teen) in the ESRB rating (US) the game could be "15+" in EU. So yea, would be nice to have possibility for most of the big ratingsystems.

As of re-classifications to games being re-released I'm guessing most of these games are re-released on seperate platforms which again makes it two entries which again makes the original rating untouched. ?

www.emuxtras.net | EFnet #EmuXtras
find quote
wimpy Offline
Fan
Posts: 318
Joined: Nov 2009
Reputation: 2
Location: Porsgrunn, Norway
Post: #23
Movie Relation
Just throwing out this idea before the soccer match starts so not 100% thought through; A game could perhaps have a field for "movie relation". Like games based on movies etc.

Might also be possible to link the game to the movie and be able to start the movie (if in the video library) from the game menu. (like the link between Movies library and Tv Shows library can do).

www.emuxtras.net | EFnet #EmuXtras
find quote
wimpy Offline
Fan
Posts: 318
Joined: Nov 2009
Reputation: 2
Location: Porsgrunn, Norway
Post: #24
Music Composer
Since I'm a huge movie/music soundtrack listener I'd want a field for letting users add who made the music for the game(s).

In addition i guess a "game credits" field would be possible aswell. It will be harder on the old console games, but in recent years people have paid more attention to who did the story, music, artwork etc in a game as we move into a time where games are more than just a game in a sense. Speaking for myself atleast I've become more aware of these aspects of games.

www.emuxtras.net | EFnet #EmuXtras
find quote
wimpy Offline
Fan
Posts: 318
Joined: Nov 2009
Reputation: 2
Location: Porsgrunn, Norway
Post: #25
HOMEPAGE
Field for url to the games' website. Very often, and more used in later years, games get their own website url for promotion.

REVIEWS
Not entirely sure how this would be done in XBMC, but i guess it's better to mention it than to skip it.. A way for users to contribute reviews of the game(s) which again will be scraped and made readable in XBMC while browsing the games library.

www.emuxtras.net | EFnet #EmuXtras
find quote
jas8340 Offline
TheVideoGameDatabase.com Admin
Posts: 37
Joined: Aug 2008
Reputation: 0
Location: Tallahassee, FL
Post: #26
I would like to shy away from providing user reviews and FAQS/codes. Mainly because there are already a ton of sites out there that provide this information. The only thing I don't want to do is create a site like http://www.giantbomb.com/.

http://thevideogamedb.com - Site Creator and Admin
find quote
jas8340 Offline
TheVideoGameDatabase.com Admin
Posts: 37
Joined: Aug 2008
Reputation: 0
Location: Tallahassee, FL
Post: #27
When the time comes to design (or redesign) a Game Library for XBMC, I'd be more than happy to provide an ERD of my database if that would help.

http://thevideogamedb.com - Site Creator and Admin
find quote
szsori Offline
TheTVDB.com Admin
Posts: 662
Joined: Aug 2006
Reputation: 1
Location: Milwaukee, WI
Post: #28
For ratings I would recommend making a scale of your own that the other scales can match up to. You can still allow people to choose the actual rating that was given to the game at release, but in your database have these relate to your scale. That way software can restrict access to games based on a uniform rating system (if desired), and they don't ALL have to handle each of the different rating systems.

Contribute to TheTVDB.com - The Online TV Database
find quote
wimpy Offline
Fan
Posts: 318
Joined: Nov 2009
Reputation: 2
Location: Porsgrunn, Norway
Post: #29
szsori Wrote:For ratings I would recommend making a scale of your own that the other scales can match up to. You can still allow people to choose the actual rating that was given to the game at release, but in your database have these relate to your scale. That way software can restrict access to games based on a uniform rating system (if desired), and they don't ALL have to handle each of the different rating systems.

This might be a great idea. Building a thevgm.com rating scheme and set that using the entered ratings (ESRB, EU, JAP) to pinpoints its value etc?

www.emuxtras.net | EFnet #EmuXtras
find quote
jas8340 Offline
TheVideoGameDatabase.com Admin
Posts: 37
Joined: Aug 2008
Reputation: 0
Location: Tallahassee, FL
Post: #30
So maybe something like this:

[Image: 2010-07-01_103203.png]

Where the ratings across the top are the site's unified ratings and the ratings down are each board's ratings. If you can think of a better custom name rating convention or matching, let me know!

http://thevideogamedb.com - Site Creator and Admin
find quote
Post Reply