|
#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. |
#2
|
||||
|
||||
Re: New Music Additions
This is a very exciting feature. I like the idea a lot. You so smart!!
The time spans are appropriate. That should suit the our needs for going back in time. Question - will this be for query only, in that would this function be able to link to the request pages. For example (just to be redundant), if I queried a new artist on the webpage, could it link me to the request page so I could choose a song from that artist. If it is for viewing only, it would still be easy enough for us to copy/paste album or artist names and just go to request page. As requesting is a member priviledge, that would prevent non-members from accessing requests. Gee, I guess I answered my own question. Anyway, this is a great addition to the site, IMHO (and MNSHO).
__________________
OverHillandDale Happiness is a worn pun! |
#3
|
||||
|
||||
Re: New Music Additions
Whatever you finally decide to do, keep website performance in mind. The now playing section and shout continue to suffer connectivity loss.
About the query, one other bell or whistle might be to search on release year. Not all new adds are actually new releases. |
#4
|
||||
|
||||
Re: New Music Additions
Quote:
__________________
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. |
#5
|
||||
|
||||
Re: New Music Additions
great idea VAX. I can see us wanting to know what has been added for a certain time span too. This is a real nice feature for someone like me who has only been around the Moon for a couple of months and still learning the library.
__________________
... from the Sun ... reflected by the Moon ... I love this place we are in ! |
#6
|
||||
|
||||
Re: New Music Additions
Quote:
To explain this... Assume it is about noon. The current song started at noon and it is exactly 6 minutes in length. That section of the page will be static until 12:06:00. The information that is displayed could be obtained at noon and cached on the web server. At 6 mins past the noon hour, the page <iframe> needs to be refreshed in any browsers connected. This would be done by setting the refresh on the <iframe> when the new song loads. But you ask, what happens if a user arrives at exactly 3 mins past noon? Well, the refresh interval would be computed from the following: <track finish time> - <user arrival time> In this example: <12:06:00> - <12:03:00> is 3 minutes. This would be set as this user's refresh timeout on the <iframe>. This is all pie-in-the-sky unless we can get NTP up and functioning on the streaming server. The performance hit now is that EVERY user causes a database query to the streaming server to pull over the information and CPU time to format this information. Quote:
Performance-wise... Unlike the ON-THE-AIR/Dedication/RECENTLY-PLAYED (I often shorthand this as OTA/Ded/RP) section which automatically refreshes (and all too often), this feature would be a form. The USER would need to click on a link to pull up the form. Much like Jim's present list of additions news item, it is not (or will not be) a part of the main page load.
__________________
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. Last edited by VAXman : 02-10-2008 at 09:45 AM. |
#7
|
||||
|
||||
Re: New Music Additions
Vax your the man . Your efforts benefeit all of us.
|
#8
|
||||
|
||||
Re: New Music Additions
Quote:
Quote:
|
#9
|
|||
|
|||
Re: New Music Additions
All great ideas !
But where's that album from Mythos - Mythos ? Added on 15th january ? |
#10
|
||||
|
||||
Re: New Music Additions
Quote:
My query shows it added: http://tmesis.com/am/mythos.html
__________________
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. |
#11
|
||||
|
||||
Re: New Music Additions
Quote:
Vax, do I need to chime in that I think this is a great idea? I think this is a great idea... Thanks! |
#12
|
||||
|
||||
Re: New Music Additions
Quote:
Working at home SUCKS because I'm never given the time and respect to get anything done.
__________________
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. |
#13
|
||||
|
||||
Re: New Music Additions
OK Moon units... a preliminary proof of concept:
http://www.auralmoon.com/addhis.php?days=7 You can also see that the first three tables are not adds. They are the result of the DJs adding tracks and not setting the track types accordingly. I will add the code later to extract these (unless the DJs will make the effort to correct the codes on the tracks they've added). You can use the History menu bar too to look back as far back as 3 years! More formatting needs to be done and I will try to incorporate the web site color scheme too. For now, I borrowed the CSS from some admin functions that I wrote some time ago. The artist column is "almost" collated. I'll see if I can get that 100% too. I'm out tomorrow for the better part of the day. My son is in the state's bowling championships.
__________________
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. |
#14
|
||||
|
||||
Re: New Music Additions
That's really cool, Vax. Thanks!
__________________
OverHillandDale Happiness is a worn pun! |
#15
|
|||
|
|||
Re: New Music Additions
Excellent stuff man.
Using ctrl+F allows you to seach for whatever you want to pick out to (Well it does on my PC - don't know what to do for MACs) and that was interesting too. |
#16
|
||||
|
||||
Re: New Music Additions
Quote:
FWIW, I don't like the use of the CTRL+char as redefined by M$. ConTRoL characters have very well defined notions in serial/ASCII communications. CTRL+F is ACK, CTRL+G is BEL. When you are here in the states, remind me to tell you a story about how this silliness with M$ took down an entire US government data facility.
__________________
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. |
#17
|
|||
|
|||
Re: New Music Additions
I have to say peeps that VAX has done an amzing job in getting the "Latest music library updates" added to the home page.
You can search for Bands/album titles (Firefox users see ctrl+f post above - Mac users ask ) then you can link directly to the requst page for that album by just clicking on it. A tip for Firefox users: If you right click on the album and "open in new tab" you can request and then go back to the same place that you were at before just by closing that tab. Hope that makes sense. Thanks again VAX.....that is one great enhancement. |
#18
|
||||
|
||||
Re: New Music Additions
Quote:
The Latest Music Library Updates (LMLU) is, for all intents and purposes, complete. I tweaked a bit of the code this morning. JT, vt, et al. playing with it last even found a slight limitation but, since it was late, I fixed it this morning. The initial frame now looks back 21 days. You can, of course, use the history draw-bar I've provided to look back: 1,2 or 3 weeks, 1,2,3 or 6 months and even as far back as 1,2 or 3 years! A history of the growth of and addition to the Aural Moon music library. However, if there are no additions for a period (1 month) this will display a blank. I will work on that today. I hope to have the page always display the last/latest AM update even if that update was 6 months ago. I'm sure Jim's compulsion for music will make this extra bit of programming moot but as a programmer I'm inclined to program for the boundary conditions even if they are never met. As Keith has already reported, you can mouse-over the artists and albums in the list and click on them. This will take you to the familiar Aural Moon request page. If you click on the artist link, you are taken to the request page and shown all of the albums for the artist. You can then drill down to the tracks and request. If you click on the album link, you are taken immediately to the request page and album track information. Request away. Hopefully, this new web page feature will foster more requests from the newly added material. If there's anything else you moonies can suggest, let me know. You should also thank Jim and Museman for this new feature. When I saw that Jim had to manually type in the large list of additions contributed by Museman after having to rip, upload and enter into SAM's database, I thought that there just had to be an easier and better way. I hope this LMLU module is the better way. Features:
__________________
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. Last edited by VAXman : 02-16-2008 at 12:23 PM. |
#19
|
|||
|
|||
Re: New Music Additions
Quote:
Remember VAXman....nobody likes a Smart arse. |
#20
|
||||
|
||||
Re: New Music Additions
Quote:
There were several issues that I still wanted to address when I left for bed last eve. I handled that this morning. The display now defaults to the most recent update added to the Library. The draw-bar reflects this as [Latest Update]. This will insure that there will always be something displayed there even if Jim sloughs off on adding music for an extended period -- not likely knowing his voracious appetite for music and the generosity of moonies. Secondly, clicking on the artist or album will open the request window in a new browser window. If your browser uses tabbed browsing and you have it configured to open new windows as a tab, this is what you will get. The reason behind this is change is two-fold :
__________________
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 09:16 PM. |