Resetting request count on just 1 song?

[theoriginalrage]

Anybody know how to reset the request count on individual songs in SAM?

:confused:

[GKIye]

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 !

[countrywesterndj]

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;'};

[theoriginalrage]

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.

[shoutcaststreaming]

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 !!