Steve the code you gave me fix that problem but it made another one. It's not putting the songs in the order by count. Top 10 the 1st place song is not showing the song that played the most.
At 06:32 PM 5/13/2009, you wrote: >Nice post Steve - I totally forgot one can even do that :O) > > >Louis Louw >CTO - Spacial Audio Solutions, LLC >http://www.spacialaudio.com >http://www.spacialnet.com > > > > >-----Original Message----- >From: [email protected] >[mailto:[email protected]] On Behalf Of >Steve Kunitzer >Sent: 13 May 2009 11:56 PM >To: [email protected] >Subject: Re: [General-discussion] Request Problem > >Tom is using the following custom SQL with the HTML template engine: > ><!--requests.SQL="SELECT songlist.ID, songlist.count_requested, >songlist.artist, songlist.title, songlist.album, songlist.buycd, >songlist.date_played, > count(*) as cnt > FROM requestlist, songlist > WHERE (requestlist.songID = songlist.ID) AND > (requestlist.code<700) > GROUP BY songlist.ID, songlist.count_requested, >songlist.artist, songlist.title, songlist.album, songlist.buycd, >songlist.date_played > ORDER BY songlist.count_requested DESC, >songlist.date_played DESC"--> > >I suggested the following mods: >Change: >requestlist.code<700 > >To: >requestlist.status = 'played' > >This will now only count requests that have played in the count. >Very important to keep in mind that successful requests are _/not >counted/_ until they have played. >Unsuccessful requests are not counted as well. > >============================================================= > >Loran, you may be interested in a new request procedure I've devised for >my site. >For the full topic, see: >http://www.festerhead.com/forums/viewtopic.php?f=2&t=710 > >Summary: > >* Requests are placed in a category >* There are no limits to the number of requests a person can make >(subject to change) >* Any requestable song may be requested at any time regardless of when >it or the same album or the same artist has played or might play (this >means anyone can request anything any number of times) >* Additional entries are added to the clockwheel to select a random song >from the Requests category following the rotation rules (this means a >song in the Requests category won't play any sooner than possible >regardless of how many times it is in the Requests category) >* After every song change any song that has played within the past two >hours is removed from the Requests category (this means if a song was >requested and it plays as part of a show the request is removed and >marked as played) >* It is highly improbable that requests will be played in the same order >that they have been requested >* The website does not currently denote the ~request~ tag (but can be >coded to do so I just haven't gotten around to it) > >I count every song as a valid request but can also count the number of >times a song played based on request. >That means if a song is requested 100 times in the span of 30 seconds it >gets a request count increase of 300 but it will only play once >according to the normal playlist rules selection process as determined >by a clockwheel entry then receiving a request play count increment of 1. > >Wicked powerful. > >Steve Kunitzer >http://www.festerhead.com > > > >Loran Partigianoni wrote: > > Thomas, I stopped displaying the Top 10 Requested songs on the website > > because the artists on the top 10 list were groups that no one had > > ever hear of ... meaning that the soloists performing and named were > > flooding SAM with requests to make their performance hit the top 10. > > > > One group that had only recorded 5 songs on a single album organized > > their family members to request their five songs ... Of course, the > > settings in SAM prevented hundreds of plays of the same 5 songs from > > ever playing. While one popular group that had more than 250 songs in > > the playlist and was the number one independent artist of the station > > could get a single son in the top 10. > > > > Once I deleted the top 10 playlist from the website and set -up SAM to > > remove any song request more than 100 times (and notified the > > offending persons of the new policy that would permanently remove > > their songs from the playlist) the requests suddenly stopped. I'm > > sure that was just a coincidence, since they both pleaded ignorance of > > anything being done by whomever was doing it. You know how crazy fans > > can be. <grin> > > > > I even threatened to stop allowing requests, and even set the time > > limit for more than 2 requests per day to more than a week ... but > > nothing slowed them down until the top 10 list was removed and the > > added threat to remove their songs after the request limit was reached. > > > > I love listener participation but with Indy artists who think they are > > rigging the Billboard TOP 100 ratings ... you have to put a stop of > > abuse before all of your listeners are driven away. > > > > Loran > > > > ----- Original Message ----- From: "Thomas Barstow" > > <[email protected]> > > To: <[email protected]> > > Sent: Tuesday, May 12, 2009 9:49 AM > > Subject: Re: [General-discussion] Request Problem > > > > > >> James I understand that it only doing request but I need to make sure > >> it plays. What happen is someone figured it out and just hit request > >> about 100 times. Song didn't played because of request rules so I'm > >> trying to have it only add it to top request if it plays. This will > >> stop this. Other than deleting this option. > >> > >> Thank You > >> > >> At 10:27 AM 5/12/2009, you wrote: > >>> The list shows the top requested, not the top played, so even if it > >>> is not > >>> being played it is being requested. > >>> > >>> James Henline. > >>> > >>> On Tue, May 12, 2009 at 12:33 AM, Thomas Barstow > >>> <[email protected]>wrote: > >>> > >>> > I have noticed today that if you do a request for a song it shows > >>> up in > the > >>> > Top 10 Request. If I hit a song and it comes back and rejects it for > >>> > whatever reason it adds to my Top Request song as being played. > >>> So if > you > >>> > request any song it will show up as being played even is the > >>> system > rejects > >>> > it for my rules. Anyone else having this problem. > >>> > > >>> > Tom Barstow (aka DJ Bear) > > >_______________________________________________ >General-discussion mailing list >[email protected] >http://mailman.spacialaudio.com/mailman/listinfo/general-discussion > >TO unsubscribe to this list, simply send a blank email to >[email protected] > >with the subject >'unsubscribe' > >_______________________________________________ >General-discussion mailing list >[email protected] >http://mailman.spacialaudio.com/mailman/listinfo/general-discussion > >TO unsubscribe to this list, simply send a blank email to >[email protected] > >with the subject >'unsubscribe' Tom Barstow (aka DJ Bear) Visit our sites @: Moyock Weather Service www.moyockweather.com Wunderground Weather Moyock http://www.wunderground.com/US/NC/Moyock.html Internet DJ's http://www.myspace.com/internetdjs Sound Machine Radio ~ Juke Box ~ www.soundmachineradio.com My Country Space www.mycountryspace.com/djbear
