VGMdb
Go Back   VGMdb Forums > VGMdb Site Related > Questions and Comments
Register FAQ Calendar Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old Nov 14, 2007, 02:02 PM
Liontamer's Avatar
Liontamer Liontamer is offline
VGMdb Staff
VGM Artist
 
Join Date: Sep 2007
Location: Atlanta, GA
Posts: 419
Default Related albums by game

Since everything is generated automatically by games entered in the database, y'all already see how an album with multiple games never has the association work since the database is looking for an exact text match in "Contains music from".

If/when the additional functionality is put into place, I'd like to see a multi-level system to determine strength of relationship. The hierarchy is just a rough idea for now.

1. The album entirely or mostly contains music from XYZ game
2. The album entirely or mostly contains music from XYZ series, including XYZ game
3. The album contains some music from XYZ game

Beyond that there could be some sub-hierarchy in the relationship levels by listing in the order of Official Release, Enclosure / Promo, Doujin, Works, Game Animation & Film, Demo Scene, [Bootleg], Other. It wouldn't really come into play except for the very frequently arranged games/series. But imagine it for a very popular game like Super Mario Bros. for the NES:
1. The album entirely or mostly contains music from Super Mario Bros.
a. Official Releases
b. Enclosures / Promos
c. Doujin
d. Works
e. Game Animation & Films
f. Demo Scene
g. [Bootlegs]
h. Other
2. The album entirely or mostly contains music from the Super Mario Bros. series, including Super Mario Bros.
album list generated through a-h schema
3. The album contains some music from Super Mario Bros.
album list generated through a-h schema
Lemme know if you need more clarification, or I can mock up an example list.
Reply With Quote
  #2  
Old Nov 14, 2007, 04:16 PM
Akumu's Avatar
Akumu Akumu is offline
VGMdb Staff
 
Join Date: Sep 2007
Location: Norway
Posts: 282
Default

Isn't it possible to do like in the artist\composer fields and seperate each game by a comma and then the database seeks out the titles?
Reply With Quote
  #3  
Old Nov 14, 2007, 06:29 PM
Gigablah's Avatar
Gigablah Gigablah is offline
VGMdb Administrator
 
Join Date: May 2007
Posts: 2,397
Default

This is already in our plans. I'm still trying to work out all possible relationships between series or games, and then relationships with publishers / companies / labels before I implement the table structure.

"Strength of relationship" is one factor I haven't considered though. Thanks for bringing that up, it's a great concept.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
layzee's VGM albums and VGM-related items for sale layzee Miscellaneous Discussion 1 Aug 9, 2019 07:29 AM
Poll: your Top Five game-related Piano Albums? The Gambler Video Game Music Discussion 21 Jun 22, 2013 11:34 AM
Should we remove the Related Albums panel? Secret Squirrel Questions and Comments 11 Feb 23, 2013 07:50 AM
Manually adding "Related Albums"? Carl Questions and Comments 1 Mar 2, 2009 03:24 PM
Question regarding "general music" albums related to vgm.. Myrkul Questions and Comments 2 Jun 24, 2008 04:30 PM