I've been working on a script that uses mysql and php to take some output from a copy command, and convert it to a web viewable list...

I have a copy of the progress of the output up at My site (BTW, that's my 'bedtime' playlist) and I've been working on streamlining it, but there are a few things I wondered about, and here ask...

1. I've been using % as a delimiter as it doesn't show up in tags too much... I don't want to do CSV, so, any other character you would prefer?

2. It currently only runs on the playlist number, title, artist, time and album, any other tags you really want in there?

3. Would anyone really be interested in working with the code after it's released?

I've been working on optimizing what i have now, It can run about 7500-10000 entries (whole sets of data) in 30 seconds, and much shorter as the list is shorter... (about half a second for 500)...

I guess the biggest question is... if I put it here (which is where I would first release it), would anyone actually use it?

I like it, i think it could be a nice addition to a website. I would be interested.

Ye, I like it too - defo would be something I'd be interested in. Depending on ease of use

Steve

Looks nice, I would definitely try it.

Well, currently, You would need to use a specially formatted copy command (oh, so devastating) and, I'm writing the code for a page to paste it to, so you don't have to ftp the pasted text up to the net manually...

I'm also still working on my code for breaking it into pages (It's a real hack job at current) but you can select your per-page output (I prefer 500/page)

I should have a release within a week...

ooh, sounds cool I'll look forward to it.

Steve

I kinda had other projects come up and I was offline for several months, but I've come back to this, just wanted to see if anyone was still interested...

If so, I'll post my current beta... (0.5)

My main goal currently is to add password protection to the entry script...

(and be forewarned, I'm not the greatest PHP programmer, I've done most of my learning on this project)

Foobar Playlist

Current requirements are php > 4.2.0 and mysql > (well, I'm not sure, actually, may work on some 3.x, but I have only tested on 4)

I've done something similar here. It doesn't use MySQL, but instead reads from a text file on the server (this is where I've used Foobar's copy command). If you must, you can see the text file here.

Well, as I've said, I've been working on this for a while...

I used mysql because it provides easy storage and allows me to paginate the data, so, as my setup is, if you have more than 250 (it's just a variable in the file), then it splits it into pages.

Love your look the best I would have to say, how hard would it be to have the database converted to MySQL? This would then allow for sorting, and I see the possibility of exporting foo_playcount data too, so you can sort songs by popularity.