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';
Question regarding how "Edit Tags > Mark Selected Files as Played" is handled
Moderators: jiri, drakinite, Addon Administrators
Re: Question regarding how "Edit Tags > Mark Selected Files as Played" is handled
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
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.
Re: Question regarding how "Edit Tags > Mark Selected Files as Played" is handled
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
Thank you Ludek for updating and providing the addon in advance.
Carsten
Carsten