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)
>
From [email protected] Wed May 13 18:32:45 2009
From: [email protected] (Louis Louw)
Date: Wed May 13 20:13:24 2009
Subject: [General-discussion] Request Problem
In-Reply-To: <[email protected]>
References:
<[email protected]><[email protected]>
<[email protected]>
<002401c9d3f3$66f5fac0$6701a...@hpa320n>
<[email protected]>
Message-ID: <00e801c9d41a$c0f045e0$42d0d1...@com>
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'
