View Single Post
Old 02-10-2008, 08:17 AM
VAXman's Avatar
VAXman(Admin) VAXman is online now
progger propellerhead
Join Date: Dec 2003
Location: Presently reside in Jackson (southern) NJ (20 miles east of NEARfest 2002 & 2003
Posts: 2,355
Send a message via AIM to VAXman Send a message via Skype™ to VAXman
New Music Additions

It has just occurred to me while looking at the long list building in the Latest Additions news item that I might be able to add a query function to the web page to show all new additions within a certain time span.

The SAM database songlist table maintains a date_added column.

Using the SQL query:
SELECT * FROM samdb.songlist s WHERE (songtype = 'S') ORDER BY date_added DESC
shows me all of the recent additions by date from the most recent. I can sort (collate) this alphabetically, by artist and then by album to build Jim's list programatically.

Question to all of you, should I?

If yes, should I allow a time span option such as the following to look back:
1 week
2 weeks
3 weeks
1 month
2 months
3 months
6 months
1 year
Any other suggestions for adjunct features, bells, whistles, etc., if this function is added?

BTW, for Cozy and Moses: If you're reading this, I found your show uploads are flagged 'S' when I did the SQL query. This means they will show up as tracks that can be requested. If you could, please try to insure that they are set 'C'. Because Jim's library adds go into a different folder on a completely different drive, I can program around this 'S'/'C' omission/oversight in a new additions feature but SAM will continue to list your tracks for request if they are set to 'S'. There's also another thing you should do with SAM when you take down your shows. I'll take this up in the staff forum.
VAXman -- Watcher of the moon, watcher of all.
----------------Mopper of the moon, mopper of all.
-------------------- Aural Moon's Janitorial Services
---------------------and Restroom Supplies, and Techno-patsy --

Cogito ergo iMac.         
Reply With Quote