Hacking Rominator Database Update info

[elbaC]

Hello Bob,

A few roms (2 that I know of) need to be updated in the database because there has been a proper release for those.
One of them is Dementium II which has a proper release CRC 0B9A7A60.

So you are correct the .rod needs to be updated.

If I have time to finish it, I'll release a small update this weekend.

 

[callmebob]

@ elbaC

´kay, Cool! Thanks for the answer.

At least now I know I´m not crazy!

 

[Rascal]

Any chance that you'll continue updating the database? Rominator is the best ROM manager for the Mac and I'm sure I'm not the only user missing the regular updates, even if we had to add them manually.

 

[elbaC]

Sorry for my absence in the forum for a month.

I haven't had much time and motivation in working on an update.

I need to iron out a few details and then I can release an update to 5048.

 

[deathnetworks]

thanks for the continued updates, I was wondering what editor you use?

 

[elbaC]

An update to 5048:

Dementium II CRC is corrected.

31-10-2010 : Download links removed

 

[elbaC]

@Deathnetworks

I use SQLite Database Browser.

 

[callmebob]

Thanks for the update! Glad you´re still here with us!

 

[cseri]

Hi.

I made the database to 5099.

http://filetrip.net/f12533-Rominator--ds-rod-5099.html

 

[Rascal]

Hi.

I made the database to 5099.

http://filetrip.net/f12533-Rominator--ds-rod-5099.html

What about boxart?

 

[cseri]

I found 2 bad registration table in the database around 4800.
(I'm sorry, I know bad English)
Therefore the images can be repaired.

 

[cseri]

http://filetrip.net/f12533-Rominator--ds-rod-5099.html , please re renamer from 4800, but 5093 is not working

http://filetrip.net/f12536-Rominator-Boxar...-4800-5099.html with correct number

 

[Rascal]

Thanks for the updates and corrections!

EDIT: Check 5075 - Dragon Quest IX- Sentinels of the Starry Skies (U), you have a trailing "space" after "Skies" in the name field.

EDIT2: I've uploaded it as the latest version on FileTrip

DS.ROD (Latest):
http://filetrip.net/g51608-Rominator--ds-rod.html

Box Art (Latest):
http://filetrip.net/g25123100-Rominator-Boxart-update.html

 

[Rascal]

http://filetrip.net/f12533-Rominator--ds-rod-5099.html , please re renamer from 4800, but 5093 is not working

http://filetrip.net/f12536-Rominator-Boxar...-4800-5099.html with correct number

I found the error in the DB for 5093. Corrected and uploaded DS.ROD 5099 rev 2

DS.ROD (Latest):
http://filetrip.net/g51608-Rominator--ds-rod.html

Box Art (Latest):
http://filetrip.net/g25123100-Rominator-Boxart-update.html

 

[cseri]

thx

 

[Rascal]

thx

No problem. It was fun getting into the DS.ROD database. Perhaps I can help in maintaining if you need it. I would just need a quick tutorial on the easiest way to populate the database. Judging by the release numbers, it is based on AdvScene. But it would helpful if I knew exactly how each field in the DB was built. To be honest, I took a SWAG on 5093 when I noticed that the ROM had a version of 1 instead of 0.

 

[cseri]

Hi.

I'm ready with the update

http://filetrip.net/f12550-Rominator--ds-rod-5160.html
http://filetrip.net/f12551-Rominator-Boxar...-5100-5160.html

 

[elbaC]

Hello cseri,

Thanks for the update, you probably know some stuff about SQL.
The updates I made, I edited the rod line by line, while looking at rom data from 2 websites.
Takes a lot of time.

I have a few comments. The rod file is now about twice it's size.
It grew from 871Kb to 1717 Kb.
You have a table called Sheet 1 with rom data and then there is the actual sheet ds with all the roms till 5160.

About the numbering, I continued with the DS-Scene numbering.
There are some numbering problems.
DS-Scene 4823 Infinite Space gone from the rod.
5159 Autoescuela: Aprueba Conmigo in the rod is 5144 Autoescuela: Aprueba Conmigo on DS-Scene
Just 2 examples that I found. There may be more.

About the box art.
Those are best show in Rominator with a file resulution of 200x180 pixels.
In the DS catalog you'll see what I mean what effect a wrong resolution will do. Example Autoescuela: Aprueba Conmigo.

Just a few comments.

 

[callmebob]

Thanks to all who are keeping Rominator alive!

Hope you can all stick around as long as the DS itself is still alive!

 

[Rascal]

Elbac,

Thanks for the advice.

1. I'll look into the differences between DS-Scene and AdvScene numbering. If you have valid reasons why we should choose DS-Scene, please let us know. I'm sure it's buried in this thread somewhere, but it would be nice to have a refresher.

2. We'll remove "sheet1" going forward to save space.

3. I'll see about converting the box art. It appears to only affect the last 100 or so releases, but I'll look further back to see what needs to be fixed.

Winsur sent me his cheat sheet on how he managed the database earlier this week and I will be sharing it with anybody that wants to help maintain the database.

Hello cseri,

Thanks for the update, you probably know some stuff about SQL.
The updates I made, I edited the rod line by line, while looking at rom data from 2 websites.
Takes a lot of time.

I have a few comments. The rod file is now about twice it's size.
It grew from 871Kb to 1717 Kb.
You have a table called Sheet 1 with rom data and then there is the actual sheet ds with all the roms till 5160.

About the numbering, I continued with the DS-Scene numbering.
There are some numbering problems.
DS-Scene 4823 Infinite Space gone from the rod.
5159 Autoescuela: Aprueba Conmigo in the rod is 5144 Autoescuela: Aprueba Conmigo on DS-Scene
Just 2 examples that I found. There may be more.

About the box art.
Those are best show in Rominator with a file resulution of 200x180 pixels.
In the DS catalog you'll see what I mean what effect a wrong resolution will do. Example Autoescuela: Aprueba Conmigo.

Just a few comments.