Question about playcounts in DB

Post a reply

Smilies
:D :) :( :o :-? 8) :lol: :x :P :oops: :cry: :evil: :roll: :wink:

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

Topic review
   

Expand view Topic review: Question about playcounts in DB

Re: Question about playcounts in DB

by Onweerwolf » Thu Jul 26, 2012 9:57 am

Right, thank you. I didn't think so.

The reason why I asked is because during the beta testing period I used (one of) the build(s) that had the bug that doubled playcounts on tracks synced from an iPod Nano 5G. I however didn't notice that at the time. So i'm stuck now with a number of songs that have too much playcounts and I have no way to figure out which songs exactly (besides those that are obvious to me) and how many playcounts are wrong. :(

Re: Question about playcounts in DB

by trixmoto » Thu Jul 26, 2012 8:27 am

Looking at the database structure, I'd say no, there is no date field that could be used to determine when the update was done. Nor is there an "OnTrackSynched" (or similar) event which could be used by a script to manufacture the date if the playcount is changed during the synch - even if you could though, this obviously wouldn't be the time that you played it.

Re: Question about playcounts in DB

by Onweerwolf » Thu Jul 26, 2012 7:02 am

I use all of those scripts but they don't answer my question.

Re: Question about playcounts in DB

by Eyal » Thu Jul 26, 2012 12:35 am

Played history is stored in PLAYED Table. (See Database structure).

These scripts can help you investigate further:
- Add/Remove PlayStat : http://www.mediamonkey.com/forum/viewto ... =2&t=31809
- Play History & Stat Node : http://www.mediamonkey.com/forum/viewto ... =2&t=12368
- Restore PlayHistory/DateAdded/Playlists : http://www.mediamonkey.com/forum/viewto ... =2&t=42085

Eyal :~)

Question about playcounts in DB

by Onweerwolf » Mon Jul 23, 2012 7:20 pm

Hi guys, I was wondering about this: when you play a track outside MM on a device that is able to sync back this play to the DB, the playcount increases. However, I know that MM does not save the played date for the play that was made on the device the way it does for plays that were made directly within MM itself. It only updates the last played date and increase the playcount #.

Does anything else actually get saved to the DB? In other words, would it be possible to retrieve the timestamps on which the playcount was updated even for those instances where it was updated because a device was synced?

Top