Hacking GameTDB - game information database + covers

[djtaz]

Great !!
Could you add full covers ? So Hibern can finalize his Wiiflow and get access from your database ?
thx.

Full covers will be supported, i just need to know the size and format.

Most loaders using full covers use PNG files and are at 512x 340 pixels
One loader looks for 4 digit codes - other loaders look for 6 digit codes

All Full PAL covers (Front and back) 6 Digits http://www.wiiboxart.com/premade/download.php?file=pal.full
All Full NTSC covers (Front and back) 6 Digits http://www.wiiboxart.com/premade/download.php?file=ntsc.full
All Full NTSCJ covers (Front and back) 6 Digits http://www.wiiboxart.com/premade/download....file=ntscj.full


--------------------------------------------------------------------------------

All Full PAL covers (Front and back) 4 Digits http://www.wiiboxart.com/premade/download.php?file=pal.full4
All Full NTSC covers (Front and back) 4 Digits http://www.wiiboxart.com/premade/download....file=ntsc.full4
All Full NTSCJ covers (Front and back) 4 Digits http://www.wiiboxart.com/premade/download....ile=ntscj.full4

 

[wiimano]

yeah I love how anyone can edit and update the games, I have already updated a bunch on there, zorg...are you lustar? haha if so its wiidude09!
so I understand everything here, but as of right now, I have to download the wiitdb.zip to my pc and then transfer to my sd card on the wii?
coming soon I will be able to update the wiitdb.zip directly on the wii, just like usb loader gx updates its dol files? wow that would be sweet! thank you for this, this is incredible, this loader keeps on getting better every day!
only thing I am trying to figure out, do I download the covers from this site with those urls or how does that work with those links you provided?
thanks again man

You got it all right wiidude09

Except the part with urls, it's exactly as I told you, you could use http://wiitdb.com/wiitdb/artwork/cover/US in your loader if you can customize the cover path. It won't work for Loader GX right now, but the urls will be added soon..

awesome to know, thanks zorg, look forward to the updates, just another great addition to this amazing loader!

 

[zorglub07]

Thanks for the offer djtaz, I got the pack in the mean time, Benjay kindly sorted it to remove dupes/wrong regions, it will be on the site soon.

 

[hdhacker]

I screwed up and installed custom disc covers in a lot of the entries. Sorry about that.

I've been enter a WHOLE LOT of data from the Nintendo site regarding Genre and rating info. I see now that you want it in lowercase. Why? That's not the way it is on Nintendo's site. What's wrong with titled case?

I'm going to hold off entering any more data until this is resolved.

Also, I uploaded a cover for Klonoa based off of the image from Amazon. This is not the right cover. Here's the right one:



Is this system like a wiki? Can you revert changes? If not, there's a danger of vandalism. I hope you back up the database periodically!

 

[djtaz]

Is this system like a wiki? Can you revert changes? If not, there's a danger of vandalism. I hope you back up the database periodically!

+1 - my sites been hacked several times - i have some of the IP's if u want to block them to be safe.

 

[zorglub07]

I screwed up and installed custom disc covers in a lot of the entries. Sorry about that.
I've been enter a WHOLE LOT of data from the Nintendo site regarding Genre and rating info. I see now that you want it in lowercase. Why? That's not the way it is on Nintendo's site. What's wrong with titled case?
I'm going to hold off entering any more data until this is resolved.
Also, I uploaded a cover for Klonoa based off of the image from Amazon. This is not the right cover. Here's the right one:
Is this system like a wiki? Can you revert changes? If not, there's a danger of vandalism. I hope you back up the database periodically!

I aleady replied in PM, but to sum it up here: the genre list is capitalized in the loader, so it's easier to type everything lowercase. I can always capitalize automatically for display on the site, or when exporting. So don't bother adding caps, except for titles because those need to be done manually (not every word needs to start with a capital letter).
Yes, it's exactly that, a wiki-like system around a database. Every user can review changes that were made by others and decide to fix something by looking at the Lastest Additions page and the History for those pages. Although revert is not available to avoid erasing a whole page by mistake. IPs are logged for all changes and they can be blocked if needed. But as with most collaborative sites, I think there are more people of good will than people of ill will so it should balance itself in a positive way.

 

[nIxx]

Best Cover site ever especially with the database

 

[scognito]

Coverfloader RC9 will only use this site, so we suggest everyone to upload cover there.

 

[mousex]

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).

 

[Benjay]

it's just a wrong game id.
the correct id for this game is RSNP69

 

[zorglub07]

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]

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.

 

[zorglub07]

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]

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]

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

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).

 

[Cyan]

Thank you for your database and website

Could it be possible to add the version in the xml ? something like the date and hour of compiling :
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

 

[djtaz]

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]

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

I'll add back the PAL cover in D,F,I later today.

QUOTE(Cyan @ Jul 4 2009, 03:00 AM) Thank you for your database and website

Could it be possible to add the version in the xml ? something like the date and hour of compiling :
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

I added the date, good idea

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

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]

@zorglub07: Thank you

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

 

[Cyan]

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