[mythtv-users] The MythGame Database

[Jason Donahue]

Dan,
I know I could backup the db, and re-import, I was looking for a more
"never touch it again" solution. I did not know what the .crc files were
for, now that I do - (and looked at it), I will edit that to add the
category stuff. When I'm done, I'll make it available to all the myth
users :)

Wish me luck!

-J

On Thu, 2004-05-06 at 12:02, Dan Morphis wrote:
> Jason, you are correct in your assessment that it deletes all the 
> entries from the various game tables.  Whats needed is something 
> similiar to the nes.crc file which is a flat file containing all the 
> category information.  I have found the snes.crc file, but it doesn't 
> contain any category information.
> 
> You could also export all the data from gamemetadata where 
> system='Snes';   Then, after you run "Search", delete from gamemetadata 
> where system='Snes'; and re-import your exported data.  If you need more 
> help w/ the specifics of it regarding sql and what commands to use, 
> contact me off list.
> 
> -dan
> 
> P.S.  I would be interested in gettting a copy of your catagorized sql :-)
> 
> Jason Donhaue wrote:
> 
> >I'm curious exactly how the "Search for new games" works in mythgame?
> >Does it simply destroy the old settings, and start fresh?
> >
> >The reason I'm asking is because I spent some time trying to "pretty up"
> >the collection of games (1600 between nes and snes). All the games in
> >snes are category "Unkown", and it's a royal P.I.T.A. to get to the game
> >I want. So went and manually started editing the database.
> >
> >Problem is, after I make changes, when I rune the "search for new", it
> >resets all my changes!!!
> >
> >So, it there somethingI can edit somewhere to make these changes
> >permanent? 
> >
> >  
> >
> >------------------------------------------------------------------------
> >
> >_______________________________________________
> >mythtv-users mailing list
> >mythtv-users at mythtv.org
> >http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> >  
> >
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users