Thanks, nyn, you have again helped me out.

Looks like my issue with MR stats was "plays". Once I deleted them MR adjusted. So looks like MR uses plays in a table instead of the playcount. Now I need to figure out that relationship!

I will consider your suggestion in the SQL viewer forum. I need to make sure I don't sound like a dunce.

Back to the first post of ARPS for info. Thanks again.

[quote="rrfpacker"]I was actually talking about this particular script as it seems there are a couple versions along with other people's modifications. Looks like only the Set Playcount works for me, not the Reset Playcount. Does that mean that this script and AddRemovePlayStats are redundant?[/quote]

Sorry I thought you were asking about all the various playcount adjusting scripts. But as far as redundancy I am not sure because I have not used this one in a very long time but ARPS does have a reset feature and a set playcount feature.

[quote="rrfpacker"]However, I have played with AddRemovePlayStats quite a bit today, along with others, to reset all of my tracks at once (I've been practicing on just artists today), since I will begin to fill my library soon. Looks like AddRemovePlayStats only has a couple actions that change more than one track at a time. I'll have to deal with that.

One other thing. I noticed that MR does not completely agree with the Playing History & Stats node. A couple counts are off by one (not a biggee) but MR has two artists in the top 10 that I wiped out their playcounts. [/quote]

Have you restarted MM, I've noticed from time to time that MR will only reset the stats when I either restart MM or change modes, since I very rarely change modes I usually see the adjustments once I've restarted MM. But I'm almost positive MR only counts the plays from the Songs table, ARPS could vary depending on which feature you are using. Some adjusts both the Songs and Played tables and some only adjust one or the other table. Look at the first post, I think Bex explains how each feature makes the adjustments.

[quote="rrfpacker"]Does it make sense to reset remove all plays if I reset the playcount? Is that the issue in MR?

Guess I have more to learn about these relationships.[/quote]

If you are removing all the playcounts then you should also remove all the plays from the played table also. If it was me, I would post a request in the SQL Viewer script forum to ask Bex for a SQL statement that would wipe them all out in one batch rather than using the script, which could become very time consuming. But look in that forum, maybe there is already a SQL statement that would meet your needs.

Nyn

I was actually talking about this particular script as it seems there are a couple versions along with other people's modifications. Looks like only the Set Playcount works for me, not the Reset Playcount. Does that mean that this script and AddRemovePlayStats are redundant?

However, I have played with AddRemovePlayStats quite a bit today, along with others, to reset all of my tracks at once (I've been practicing on just artists today), since I will begin to fill my library soon. Looks like AddRemovePlayStats only has a couple actions that change more than one track at a time. I'll have to deal with that.

One other thing. I noticed that MR does not completely agree with the Playing History & Stats node. A couple counts are off by one (not a biggee) but MR has two artists in the top 10 that I wiped out their playcounts.

Does it make sense to reset remove all plays if I reset the playcount? Is that the issue in MR?

Guess I have more to learn about these relationships.

I second that ^^. :D

RRF:

I am sure you will get many opinions on which is the "best", however I find [url=http://www.mediamonkey.com/forum/viewtopic.php?f=2&t=31809]Bex's AddRemove PlayStats[/url] offers the most flexbility and it is one of the most used scripts in my arsenal. :wink:

Nyn

I see the latest post is from the middle of 2008 and noone responded. I hope this thread is still active.

I installed MM about 9 months ago, I only put a few songs into library so I could play and learn. Now that I am going to keep MM, I want to be able to reset my playcounts before I start filling in the library.

I installed the first script in the thread and inserted the corresponding script in the script.ini file. I can't tell if this works or not. The playcount field in track properties, classification tab does not change when I use Reset Play Counter and press F5. It does change if I use the Set Play Counter script.

I suppose I could use the Set Play Counter to set all songs to 0, but then what is the point for Reset?

As a couple others have posted, which one of the many scripts in this thread are the ones to use?

There are a few scripts posted in the thread.

Which is the best one?

Also. Why do we need scripts to reset the play counter? Shouldn't this be a built-in feature?

Can anyone tell me what's the newest updated version of this and if/how well it works with MM3.

Thanks!

[quote="nynaevelan"]You could try the [url=http://www.mediamonkey.com/forum/viewtopic.php?t=1461&postdays=0&postorder=asc&start=0]Change Playcounter[/url] script, that is what I use when I want to change playcounts.[/quote]
OMG, that's awesome! And it worked out of the box. Thanks, Nyn! :)

[quote="spacefish"]I'm looking for a script that will allow me to [b]decrease [/b]playcounts. Will this script do that? I've read that it might be possible but I'm really not following how that could be accomplished. I'm also unclear on what modifications I need to make to the original script, if any.

If there is another, easier method to edit play counts, please point me to it. I understand I could have used Access for MM2. Is there an equivalent application for MM3's type of database that will allow me to see and edit values directly?

Thanks for any help!

Cheers,
Paula[/quote]

Paula:

You could try the [url=http://www.mediamonkey.com/forum/viewtopic.php?t=1461&postdays=0&postorder=asc&start=0]Change Playcounter[/url] script, that is what I use when I want to change playcounts.

Nyn

I'm looking for a script that will allow me to [b]decrease [/b]playcounts. Will this script do that? I've read that it might be possible but I'm really not following how that could be accomplished. I'm also unclear on what modifications I need to make to the original script, if any.

If there is another, easier method to edit play counts, please point me to it. I understand I could have used Access for MM2. Is there an equivalent application for MM3's type of database that will allow me to see and edit values directly?

Thanks for any help!

Cheers,
Paula

If you look closer, you'll see that there are 2 lines where now() function is used. You need to replace it with CDbl(now()) in both of them.

I just tried - it works!

I tried this today, but now I get 16.1.1900 00:14 (instead of todays's date, 10:29)

Do you have another advice maybe?

Thanks

Yep that should do it!

thanks jk2587. So to make sure I have it right, it should read:

SDB.database.execSQL("UPDATE Songs SET PlayCounter=" & (itm.PlayCounter + 1) & ",LastTimePlayed='" & [b]CDbl(now())[/b] & "' WHERE Id=" & itm.songID)