Jump to content


  • Please log in to reply

GameTDB - game information database + covers

, http://gametdb.com (Go to first unread post)
zorglub07 Post #31 Posted 04 July 2009 - 03:48 AM

    GBAtemp Fan

  • PipPipPipPip

  • Group: Members
  • Posts: 322
  • Member No.: 73,678
  • Joined: 11-April 07

  •  

QUOTE(mousex @ Jul 3 2009, 03:11 PM) <{POST_SNAPBACK}>
You need to add a new Region:
http://wiitdb.com/Game/RSND69
This game has no Region, the Region for D is Deutschland/Germany (PAL).
Thanks for pointing this out, I enabled "D" and fixed it for this game.
Are you sure this game ID is from an original, unaltered game?
This is important because it seems the 4th letter is not always consistent for PAL games and we have to be completely sure the IDs are real
I was just going to ask about this very problem.

For Europeans or PAL users, please reply if you have any game IDs (original games only) with a 4th letter other than "P", this will be very useful to get straight facts about this issue.
List the title, game ID, country, and if known the available languages for that game.

Here's a summary of what is known :

USA: E
Japan: J
Korea: K
PAL: P (default for all PAL countries?)
PAL, needs to be confirmed: X, Y, W, D/G, F, I

Are there letters for Netherlands, Portugal, Australia, China ?



lejong2002 Post #32 Posted 04 July 2009 - 05:05 AM

    GBAtemp Regular

  • PipPipPip

  • Group: Members
  • Posts: 161
  • Member No.: 124,975
  • Joined: 12-May 08

  •  

Hey guys.

Thanks for good site.

I have a question.

Is there a GUI utility for editing the wiitdb.xml file?
I wanna eidt my own wiitdb.xml file on my PC, that's why.
wink.gif



zorglub07 Post #33 Posted 04 July 2009 - 05:38 AM

    GBAtemp Fan

  • PipPipPipPip

  • Group: Members
  • Posts: 322
  • Member No.: 73,678
  • Joined: 11-April 07

  •  

Any XML editor with "grid view" would work, but why would you want to edit the file rather than editing the database online?
Is it to store information about unofficial versions of games, or is there something missing you would like added?


Benjay Post #34 Posted 04 July 2009 - 07:19 AM

    Hardstyle Addict

  • PipPipPipPipPip

  • Group: Members
  • Posts: 895
  • Member No.: 180,305
  • Joined: 25-May 09
  • Location: Amiens

  •  

i've made a little research on google and it seems that some PAL games do have differents 4th letter.
The simpsons game exists with a D (germany) , a F(france) and a P(global pal)
it the same with ice age 2 : the meltdown , and tiger wood 07 for example.

look at this list :

http://wiird.l0nk.org/gamelist/gamelist.txt


mousex Post #35 Posted 04 July 2009 - 09:32 AM

    Finally SNEEK DI user

  • PipPipPipPipPip

  • Group: Members
  • Posts: 988
  • Member No.: 154,730
  • Joined: 23-January 09

  •  

QUOTE(zorglub07 @ Jul 4 2009, 04:48 AM) <{POST_SNAPBACK}>

Are you sure this game ID is from an original, unaltered game?
This is important because it seems the 4th letter is not always consistent for PAL games and we have to be completely sure the IDs are real
I was just going to ask about this very problem.

Yes, I'm sure. It's a rip from this disc wink.gif

What I see now is that I can't select a region for my cover upload for the Simpsons game. I uploaded the german cover (without region), see latest uploads.

EDIT: Nevermind, I saw that you fixed the cover issue.
Another question.
The site allows full covers to be uplaoded and I read here that the size is 512x340, you site just allows files up to 102kb, but the smallest .png I can get in this size is 259kb (with PNGOUT) or 268 (with Photoshop Web export).

Edited by mousex, 04 July 2009 - 09:56 AM.


Cyan Post #36 Posted 04 July 2009 - 10:00 AM

    GBATemp's lurking knight


  • Group: Moderators
  • Posts: 4,928
  • Member No.: 746
  • Joined: 27-October 02
  • Location: Engine room, learning

  •  

Thank you for your database and website smile.gif

Could it be possible to add the version in the xml ? something like the date and hour of compiling : <wiitdb version="200907041045"/>
maybe it's not needed, but I just like to know which version I have on my storage device, if it's very old or recent.



Another thing, for titles with Unicode characters like Ōkami, usbloaderGX replaced Ō with a space.
I see the title is now changed to Okami, was there a problem with xml encoding like we can't use Unicode in it, or can we put back the Ōkami title ?

Thank you for all the users working on it gbasp.gif


djtaz Post #37 Posted 04 July 2009 - 10:33 AM

    PM's Full - Wadder Me


  • Group: Members
  • Posts: 2,997
  • Member No.: 135,836
  • Joined: 21-September 08

  •  

QUOTE(zorglub07 @ Jul 4 2009, 03:48 AM) <{POST_SNAPBACK}>
QUOTE(mousex @ Jul 3 2009, 03:11 PM) <{POST_SNAPBACK}>
You need to add a new Region:
http://wiitdb.com/Game/RSND69
This game has no Region, the Region for D is Deutschland/Germany (PAL).
Thanks for pointing this out, I enabled "D" and fixed it for this game.
Are you sure this game ID is from an original, unaltered game?
This is important because it seems the 4th letter is not always consistent for PAL games and we have to be completely sure the IDs are real
I was just going to ask about this very problem.

For Europeans or PAL users, please reply if you have any game IDs (original games only) with a 4th letter other than "P", this will be very useful to get straight facts about this issue.
List the title, game ID, country, and if known the available languages for that game.

Here's a summary of what is known :

USA: E
Japan: J
Korea: K
PAL: P (default for all PAL countries?)
PAL, needs to be confirmed: X, Y, W, D/G, F, I

Are there letters for Netherlands, Portugal, Australia, China ?



I have posted this several times and all these regions are accounted for on my site since it started .....

ASCII Hex Region
A 41 All regions. System channels like the Mii channel use it.
D 44 German-speaking regions. Only if separate versions exist, e.g. Zelda: A Link to the Past
E 45 USA and other NTSC regions except Japan
F 46 French-speaking regions. Only if separate versions exist, e.g. Zelda: A Link to the Past.
J 4A Japan
K 4B Korea
L 4C PAL/World?
P 50 Europe, Australia and other PAL regions
Q 51 Korea with Japanese language.
T 54 Korea with English language.
X 58 Not a real region code. Homebrew Channel uses it, though and generally considered to be PAL




zorglub07 Post #38 Posted 04 July 2009 - 10:41 AM

    GBAtemp Fan

  • PipPipPipPip

  • Group: Members
  • Posts: 322
  • Member No.: 73,678
  • Joined: 11-April 07

  •  

QUOTE(mousex @ Jul 4 2009, 02:32 AM) <{POST_SNAPBACK}>
The site allows full covers to be uplaoded and I read here that the size is 512x340, you site just allows files up to 102kb, but the smallest .png I can get in this size is 259kb (with PNGOUT) or 268 (with Photoshop Web export).
I fixed both when I saw your first and second post smile.gif I'll add back the PAL cover in D,F,I later today.

QUOTE(Cyan @ Jul 4 2009, 03:00 AM) <{POST_SNAPBACK}>
Thank you for your database and website smile.gif
Could it be possible to add the version in the xml ? something like the date and hour of compiling : <wiitdb version="200907041045"/>
maybe it's not needed, but I just like to know which version I have on my storage device, if it's very old or recent.
Another thing, for titles with Unicode characters like Ōkami, usbloaderGX replaced Ō with a space.
I see the title is now changed to Okami, was there a problem with xml encoding like we can't use Unicode in it, or can we put back the Ōkami title ?
Thank you for all the users working on it gbasp.gif
I added the date, good idea smile.gif
The Ō is replaced if you use the default font, if you use a font with more characters it displays it fine.
It was changed by someone, but I let it that way until the default GX font supports more characters.
The database is UTF-8 all the way from the site to the loader, I took extra care of it as you may have noticed if you follow revisions, I hope Japanese users will enjoy it because I included a lot of Japanese titles ph34r.gif You can use any Unicode character that would be needed for a proper title (Captain ★ Rainbow , WALL•E) but for now it won't display in the loader unless you use a custom font (arial_ykt.ttf is good because it's a small Arial font at 110kb)


mousex Post #39 Posted 04 July 2009 - 10:45 AM

    Finally SNEEK DI user

  • PipPipPipPipPip

  • Group: Members
  • Posts: 988
  • Member No.: 154,730
  • Joined: 23-January 09

  •  

@zorglub07: Thank you smile.gif
QUOTE(djtaz @ Jul 4 2009, 11:33 AM) <{POST_SNAPBACK}>
I have posted this several times and all these regions are accounted for on my site since it started .....

ASCII Hex Region
...

Wow, you are my hero, you copied a table from wiibrew...
http://wiibrew.org/wiki/Title_database#Region_Codes

Edited by mousex, 04 July 2009 - 10:45 AM.


Cyan Post #40 Posted 04 July 2009 - 10:52 AM

    GBATemp's lurking knight


  • Group: Moderators
  • Posts: 4,928
  • Member No.: 746
  • Joined: 27-October 02
  • Location: Engine room, learning

  •  

Thank you for your reply and adding the version.

Yes I saw there's Japanese names, I find it great to have every titles and descriptions per countries ^^
I will try with this font, thank you wink2.gif



zorglub07 Post #41 Posted 04 July 2009 - 11:00 AM

    GBAtemp Fan

  • PipPipPipPip

  • Group: Members
  • Posts: 322
  • Member No.: 73,678
  • Joined: 11-April 07

  •  

Thanks djtaz, I saw this list (source: http://wiibrew.org/wiki/Title#00010004) but it is meant for System and Game Channel titles ("German-speaking regions. Only if separate versions exist, e.g. Zelda: A Link to the Past"), with four-letter title ID, no hint that it can apply to discs and contradicting information ("X Not a real region code") so I wanted more evidence. There is no I in this list for instance, and N is for "Japanese Import to USA and other NTSC regions" while it could have been Netherlands for discs.


CuriousG Post #42 Posted 05 July 2009 - 01:03 AM

    Advanced Member

  • PipPip

  • Group: Newcomers
  • Posts: 97
  • Member No.: 113,314
  • Joined: 30-January 08

  •  

Is there anything in place to fix wrong covers? I noticed that there are some covers that are supposed to be 3D covers and they're just regular covers.

How about implementing something so that when there are titles without certain covers you can click a link and it shows what covers are needed or something to that effect. Maybe have some type of vote so that covers that are high in demand get listed first so it can be filled sooner.


zorglub07 Post #43 Posted 05 July 2009 - 03:53 AM

    GBAtemp Fan

  • PipPipPipPip

  • Group: Members
  • Posts: 322
  • Member No.: 73,678
  • Joined: 11-April 07

  •  

QUOTE(CuriousG @ Jul 4 2009, 06:03 PM) <{POST_SNAPBACK}>
Is there anything in place to fix wrong covers? I noticed that there are some covers that are supposed to be 3D covers and they're just regular covers.
How about implementing something so that when there are titles without certain covers you can click a link and it shows what covers are needed or something to that effect. Maybe have some type of vote so that covers that are high in demand get listed first so it can be filled sooner.
The site is not currently set up to display 3D covers, it only displays regular cover and official disc art, but you can upload custom disc art and download it from the loaders. The multiple covers you see for PAL games are regional covers. If you mean you downloaded wrong covers from a loader, please tell me if you see a problem by PM.
The 3D pack comes straight from Neorame so I would assume it is clean? but I'll look to be really sure.
For now I screen all uploads, but I will add the ability to delete wrong covers for advanced users/moderators later.
I don't think having a "request section" is really helpful because people could spend the time searching for a cover rather then requesting it and hoping someone else will do it. The popular games are popular even if there is no request system so the most popular covers will be uploaded first.
Having a list of missing covers would be nice, I'll try to add that later.



cooldudechand Post #44 Posted 05 July 2009 - 05:02 AM

    GBAtemp Regular

  • PipPipPip

  • Group: Members
  • Posts: 139
  • Member No.: 144,290
  • Joined: 24-November 08
  • Location: Sydney

  •  

cooool....looks good...and easy


Muntrue Post #45 Posted 05 July 2009 - 03:00 PM

    Member

  • Pip

  • Group: Newcomers
  • Posts: 40
  • Member No.: 185,663
  • Joined: 30-June 09

  •  

Just adding a shameless plug for www.muntrue.nl where we have pretty much all 3D / 2D / Fullcover / Disc artwork =)







Users browsing this topic

1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users