Work in progress - Modify Play Counter via script

Post a reply


In an effort to prevent automatic submissions, we require that you complete the following challenge.
Smilies
:D :) :( :o :-? 8) :lol: :x :P :oops: :cry: :evil: :roll: :wink:

BBCode is ON
[img] is ON
[flash] is OFF
[url] is ON
Smilies are ON

Topic review
   

Expand view Topic review: Work in progress - Modify Play Counter via script

Re: Work in progress - Modify Play Counter via script

by rrfpacker » Thu Mar 12, 2009 5:56 pm

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.

Re: Work in progress - Modify Play Counter via script

by nynaevelan » Thu Mar 12, 2009 2:22 pm

rrfpacker wrote: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?
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.
rrfpacker wrote: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.
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.
rrfpacker wrote: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.
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

Re: Work in progress - Modify Play Counter via script

by rrfpacker » Thu Mar 12, 2009 2:10 pm

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.

Re: Work in progress - Modify Play Counter via script

by Benn » Thu Mar 12, 2009 11:50 am

I second that ^^. :D

Re: Work in progress - Modify Play Counter via script

by nynaevelan » Thu Mar 12, 2009 11:46 am

RRF:

I am sure you will get many opinions on which is the "best", however I find Bex's AddRemove PlayStats offers the most flexbility and it is one of the most used scripts in my arsenal. :wink:

Nyn

Re: Work in progress - Modify Play Counter via script

by rrfpacker » Thu Mar 12, 2009 11:34 am

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?

by dypsis » Thu May 01, 2008 3:35 pm

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?

by martialartsguy » Tue Apr 15, 2008 9:10 am

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

Thanks!

by spacefish » Mon Mar 31, 2008 12:14 pm

nynaevelan wrote:You could try the Change Playcounter script, that is what I use when I want to change playcounts.
OMG, that's awesome! And it worked out of the box. Thanks, Nyn! :)

by nynaevelan » Mon Mar 31, 2008 11:07 am

spacefish wrote:I'm looking for a script that will allow me to decrease 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
Paula:

You could try the Change Playcounter script, that is what I use when I want to change playcounts.

Nyn

by spacefish » Mon Mar 31, 2008 10:44 am

I'm looking for a script that will allow me to decrease 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

by dgcom » Wed Jan 30, 2008 2:44 am

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!

by Guest » Thu Jan 17, 2008 4:37 am

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

by jk2587 » Tue Jan 15, 2008 5:51 pm

Yep that should do it!

by shoney » Tue Jan 15, 2008 1:51 pm

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

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

Top