Go Back   Aural Moon - Progressive Rock Discussion > Station News > Website
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Thread Tools Display Modes
Prev Previous Post   Next Post Next
Old 02-10-2008, 08:17 AM
VAXman's Avatar
VAXman(Admin) VAXman is offline
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

Thread Tools
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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

All times are GMT -5. The time now is 02:18 PM.