View Full Version : Resetting request count on just 1 song?

08-27-2009, 04:42 AM
Anybody know how to reset the request count on individual songs in SAM?

08-28-2009, 12:07 AM
have you ever checked : rightclick > songinfo ?
Into that window you'll find also a tab "details" - this gives you an overview of the rotation of a track
However I guess the only way to reset the track is by : rightclick > remove > clear > from all
Refresh your Music directory and reload the track to your playlist(s)
I don't have any idea how it can be done into an other way .. Maybe someone else knows
Good Luck !

08-28-2009, 01:03 AM
This is really not recommended to do, but here you go .. untested !!

1- Find out the sondID .. Song Info > Details > Song ID

2- You need to do a mySQL command. You can do it in a PAL script. Assume that the song id is 15392:

ExecSQL ('UPDATE songlist SET count_played = 0 WHERE id = 15392;'};

08-29-2009, 04:44 AM
ExecSQL ('UPDATE songlist SET count_played = 0 WHERE id = 15392;'};

This has syntax errors.
The first one I noticed is the closing bracket instead of the parentheses.
After that is changed then the error is

More arguments expected! [line:1 1 column:1]

Thanks for the jumping off point. If I figure it out I'll post it.

08-29-2009, 05:57 AM
Well, that's what "untested" means .. it gives you a starting point.

Try this:

ExecSQL ('UPDATE songlist SET count_played = 34 WHERE id = 15392;',[]);
That one IS tested !!