Thank You I will try this At 05:55 PM 5/13/2009, you wrote: >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'
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
