Question regarding how "Edit Tags > Mark Selected Files as Played" is handled

Get help for different MediaMonkey 5 Addons.

Moderators: jiri, drakinite, Addon Administrators

sonos
Posts: 175
Joined: Wed Aug 07, 2013 11:54 am

Question regarding how "Edit Tags > Mark Selected Files as Played" is handled

Post by sonos »

I increased the "Played counter" for a specific "Song" several times via "Edit tags > Mark selected files as played" by 1 each time, and the "Last played" was set accordingly. (each time recognizable in "File Properties > Details").

After that I could not read the accordingly changed data from the DB using the tags "Playdate" of "Songs" using SQL.
Apparently the so changed data in "PlayCounter" and "LastTimePlayed" are not transferred to the DB!?

The SQL code I used:
SELECT Strftime('%Y/%m/%d %H:%M:%S', ( Julianday(playdate) + 2415018.5 ), 'localtime')
AS plays
FROM played AS p
JOIN songs AS s
ON s.id = p.idsong
WHERE album = 'Kristallen'
AND songtitle = 'The Wedding';
Ludek
Posts: 4964
Joined: Fri Mar 09, 2007 9:00 am

Re: Question regarding how "Edit Tags > Mark Selected Files as Played" is handled

Post by Ludek »

Hi,
you are right, this addon just increases Songs.PlayCounter without writing to the Played table..

I'll adjust the code for the next version to publish: https://www.ventismedia.com/mantis/view.php?id=19633
Last edited by Ludek on Fri Aug 25, 2023 3:53 pm, edited 1 time in total.
Ludek
Posts: 4964
Joined: Fri Mar 09, 2007 9:00 am

Re: Question regarding how "Edit Tags > Mark Selected Files as Played" is handled

Post by Ludek »

Fix is available under the same link here: https://www.dropbox.com/s/orlno2z9vl31b ... .mmip?dl=0
sonos
Posts: 175
Joined: Wed Aug 07, 2013 11:54 am

Re: Question regarding how "Edit Tags > Mark Selected Files as Played" is handled

Post by sonos »

Thank you Ludek for updating and providing the addon in advance.

Carsten
Post Reply