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. |
Re: New Music Additions
This is a very exciting feature. I like the idea a lot. You so smart!! :notworthy
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. :notsure: Anyway, this is a great addition to the site, IMHO (and MNSHO). :thumbsup: |
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. |
Re: New Music Additions
Quote:
|
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.
|
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. |
Re: New Music Additions
Vax your the man . Your efforts benefeit all of us. :notworthy
|
Re: New Music Additions
Quote:
Quote:
|
Re: New Music Additions
All great ideas !
But where's that album from Mythos - Mythos ? Added on 15th january ? |
Re: New Music Additions
Quote:
My query shows it added: http://tmesis.com/am/mythos.html |
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! |
Re: New Music Additions
Quote:
Working at home SUCKS because I'm never given the time and respect to get anything done. |
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. |
Re: New Music Additions
That's really cool, Vax. Thanks!
|
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. |
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. |
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. |
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:
|
Re: New Music Additions
Quote:
Remember VAXman....nobody likes a Smart arse. :rofl: |
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 :
|
Re: New Music Additions
Thank You VAX. Tremendous new feature. I'm sure everyone will appreciate it, and the work you put into it.
Bmithra :D |
Re: New Music Additions
OK. I know how much my fellow moonies hate new features so I have added more to the Latest Music Library Update just to piss you all off some more! :D
You can now sort the new additions by clicking on the column headers. Sort by artist by clicking on the Artist Name header; sort by album by clicking on the Album Title header. |
Re: New Music Additions
Quote:
:drdot::drdot: :drdot: :drdot: :drdot: :drdot: :drdot: :drdot: :drdot: :drdot: :drdot: :drdot: ]:-( ]:-( ]:-( ]:-( ]:-( ]:-( ]:-( ]:-( ]:-( ]:-( All kidding aside, you're too kind. This new feature is way cool and Very Much Appreciated. I love being able to request from the list. And all the sorting features just enhance that ability. I'd venture to say that no one else on the web of musical stations has such a feature. :yougo :knowing: Thank you, Vax. |
Re: New Music Additions
Quote:
Since I was born to hack code, any suggestions are welcome. I'd much rather do this than deal with my paying customers. ;) |
Re: New Music Additions
Quote:
Somehow, this is no surprise... :LOL: :haha: :thumbsup: :neener: :D Bmithra |
Re: New Music Additions
Quote:
|
Re: New Music Additions
Quote:
I do know there were some issues with allowing the table's CSS attributes to use the 'inherit' class because M$IE doesn't support it but other than that, the LMLU is really a short bit of code and the colors are all taken from the Joomla template. |
Re: New Music Additions
The blue text in IE that we were discussing this morning vax, only recently showed up ..say in the past 24 hours. Before that, the text for the latest editions was the same as all the other text.
|
Re: New Music Additions
Quote:
Older versions of browsers, all browsers, are likely to have issues because new web features/standards are being introduced all the time. FWIW, I would LOVE to get rid of the ugly scroll bars on the page; however, M$IE's event model is flawed. Thus, I cannot deploy the code I would like to to rid the page of the scroll bars. If I could, you would simply click and drag on a section of the screen to scroll it. |
Re: New Music Additions
fair enough..
|
Re: New Music Additions
Quote:
|
Re: New Music Additions
LMLU looks much better:rockband:
|
Re: New Music Additions
Quote:
As it turns out, some of the browsers do not respect the 'inherit' property on CSS attributes. I set the CSS anchor attributes (anchors are links to other web items) for hover (the mouse over event which shows you that there is a link there) and several other anchor attributes to 'inherit' the color from the font. In the defective browsers, this didn't work. Apparently, when it didn't work, the browser reverted to the browser's default color scheme for anchors. In most of these faulty browsers, this was a deep blue making it very very difficult to read the text. I had to define separate CSS attributes for the various tags used to overcome this browser deficiency. AFAICT, the LMLU was fine until I added the Artist/Album sort capability. This is when I defined the anchor CSS attributes to color: inherit;. What you should see in the LMLU should look like the Latest Forum Posts. The column headings should be 'gold' on the deep blue header bar and the artists and albums should be white like the font above in the Latest Forum Posts. Long artist names and or album names should truncate. When they do, an ellipsis should be displayed. I'm not convinced that all browsers obey this CSS property either. They should, however, truncate without wrapping in the column. When in doubt, FireFox. |
Re: New Music Additions
Several people complained about loss of the background colors. I've found and I've corrected the problem. It was a stray comment delimiter in one of the CSS files.
This affected older versions of Safari and M$IE. Strangely, it shouldn't have affected the browser rendering but it did likely due to a parser issue where it handles comments. |
Re: New Music Additions
I have resorted to doing what I didn't want to have to do but I can't continually fix the database for content added by shows. The SQL query now SELECTs on the source filename as well as other criteria and if the filename contains the folder names for the shows -- Interzone and Receving (which is a common folder for the other shows) -- these will be excluded. Sean sends his show live which creates a filename entry called mms://aa.bb.cc.dd:3690/ (actual IP address elided) which is also excluded by this extensive SELECT clause. The LMLU should now only show tracks added to the Aural Moon library.
|
Re: New Music Additions
This was a while ago. I don't know if you've fixed or figured this out yet, Vax. But there *IS* a NTP port for WEEEEEEEEEENDOZE. I believe someone wrapped some sort of point 'n drool interface for it, but it's still the same under the hood. I believe there's also third party apps for WEEEEEEEEEEEEENDOZE that will work (albeit limpingly, last I saw) with the standard NTP systems.
Of course, if you've already figured this part out, feel free to ignore me. On this issue, you smart alecks! :P Roger -Dot- Lee, NTP rawks my happy little self-centered universe. |
All times are GMT -5. The time now is 05:06 AM. |
Integrated by BBpixel Team 2024 :: jvbPlugin R1011.362.1
Powered by vBulletin Version 3.6.2
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.