|
#1
|
||||
|
||||
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 DESCshows 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 weekAny 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. |
Thread Tools | |
Display Modes | |
|
|
All times are GMT -5. The time now is 11:47 PM. |