Page 1 of 1

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

Posted: Sun Aug 20, 2023 2:52 pm
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';

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

Posted: Fri Aug 25, 2023 2:03 pm
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

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

Posted: Fri Aug 25, 2023 3:52 pm
by Ludek
Fix is available under the same link here: https://www.dropbox.com/s/orlno2z9vl31b ... .mmip?dl=0

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

Posted: Sat Aug 26, 2023 4:00 am
by sonos
Thank you Ludek for updating and providing the addon in advance.

Carsten