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

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 regarding how "Edit Tags > Mark Selected Files as Played" is handled

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

by sonos » Sat Aug 26, 2023 4:00 am

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

Carsten

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

by Ludek » Fri Aug 25, 2023 3:52 pm

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

by Ludek » Fri Aug 25, 2023 2:03 pm

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

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

by sonos » Sun Aug 20, 2023 2:52 pm

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';

Top