cross link to "packs" on vgmrips

[tinyrsid]

Vampirefrog suggested I post this in the forum "so more people get a chance to help"..

I am thinking about adding "vgmrips" subtree in my online browser/player: http://www.wothke.ch/playmod/
This would allow to search for the works of a composer not only across modland (which lacks arcade related songs)
but also include the stuff from vgmrips, similarly respective songs could be used to create personal playlists, etc.
From the PlayMOD perspective it would add examples of songs that use more "exotic" audio chips which the
modland collection is lacking (see their very limited "Video Games Music" section).

I don't have much space on my web server and that's why my player so far refers to song files that are hosted separately elsewhere (I'd like to keep it that way). Vampirefrog told me that it would be OK if I used the same approach to access the individual .vgm/.vgz files hosted in "https://vgmrips.net/packs/...

What I need is a list of the respective "https://vgmrips.net/packs/" filenames/paths (the list you'd get when running a "find $(pwd) -type f" from the "packs" folder). From what I see the "pack" names used in vgmrips are different from the ones used in the "MAME software list ROMs" (so that file is useless to derive a mapping - see https://archive.org/download/MAME_0.202 ... OMs_merged). Vampirefrog suggested that I could scrape the respective info from the individual vgmrips "pack" web pages but without even knowing the used pack names I'd have to do a crawler for the complete vgmrips site to 1st find this pack pages - which seems to be a rather silly approach..

Judging by the current vgmrips UI I would guess that all the information that I need is actually already available on some vgmrips side DB table/view and the easiest way would be to just run a SELECT on the respective table/view..

Anybody here that could help me?

[vampirefrog]

there's no data linking our packs to MAME ROM names, you can do it yourself, just put all the packs in a spreadsheet and do it by hand.

There's some extra data in this spreadsheet https://docs.google.com/spreadsheets/d/ ... 1860115394

if you want I can give you edit access and you can input the mame ROM names in that sheet.

[vampirefrog]

I don't like that they stripped the text files from the vgmrips archive.

[ValleyBell]

From what I understand, he actually wants to do this:

• playing back VGMs from the vgmrips archive
• not having to mirror the while archive on his server

So his preferred solution would be to download the VGMs from vgmrips.net using the link from the "Download vgz" button on the Packs page.

However, for this he needs to know the file structure on the server. (Getting that from the MAME mirror is probably difficult to do due to different pack names.)
So the best solution for him would probably be some sort of read access (either directly or via a very simple PHP script) to the database used by the pack pages. And I think that is what he really wants.

[vampirefrog]

this already exists:

use the data-vgmurl="" attribute



you can scrape the pages, no problem.

[tinyrsid]

@ValleyBell yes, you summarized it perfectly (I had indeed thought it might be easy for the DB admin to just run a respective select on the table once and then send me the respective zipped dump - I am happy to use a snapshot and don't need to be up-to-date with the latest changes..)

@vampirefrog thanks for the shreadsheet, I think with the contained URL to the "pack" pages I can do a little script to extract the
data from the HTML pages

Cheers.

[vampirefrog]

There's also vgmrips . net / dump . php

[tinyrsid]

thx, yes I think I'll use the pack_url info from the dump file as a starting point..

[tinyrsid]

that worked nicely..

[tinyrsid]

you can now browse the vgmrips.net collection from within PlayMOD: http://www.wothke.ch/playmod/

[vampirefrog]

[tinyrsid]

just a plea: please give me a heads up in case you might change the path to the individual .vgz/.vgm files in some future update of your site (or better still keep them stable)