Actually seeing that MediaLibrary.sqlitedb can potentially get out of sync with iTunesCDB this way (because of cleared 'play_count_recent' value).
I guess I will have to change the mechanism to rather always take the 'play_count_user' value and always use this value also when viewing the tracks in MM5 interface (Devices & Services > iPod > Music list)
Also seeing that MM5 already remembers the inital played# value synced to the device, so I could always use the 'play_count_user' and decrease it by the initial played# value when the track was synced from MM5 > iPod and update both the values after the sync.
i.e.
1) during MM5 > iPod sync use:
played_value_when_track_was_synced_to_iPhone = MM5.track.play_count
2) during iPod > MM5 sync use:
MM5.track.play_count = MM5.track.play_count + (iPod.play_count_user - played_value_when_track_was_synced_to_iPhone)
played_value_when_track_was_synced_to_iPhone = iPod.play_count_user;
Entered as:
https://www.ventismedia.com/mantis/view.php?id=18673
EDIT: As for the current workaround: Yes, bulk increasing the 'play_count_recent' is possible, you can use iMazing app to download the MediaLibrary.sqlite from the iPhone and then open it in SQLite studio and update the 'play_count_recent' by SQL query like:
Code: Select all
UPDATE item_stats SET play_count_recent = 1 WHERE play_count_user > 0
Actually seeing that MediaLibrary.sqlitedb can potentially get out of sync with iTunesCDB this way (because of cleared 'play_count_recent' value).
I guess I will have to change the mechanism to rather always take the 'play_count_user' value and always use this value also when viewing the tracks in MM5 interface (Devices & Services > iPod > Music list)
Also seeing that MM5 already remembers the inital played# value synced to the device, so I could always use the 'play_count_user' and decrease it by the initial played# value when the track was synced from MM5 > iPod and update both the values after the sync.
i.e.
1) during MM5 > iPod sync use:
played_value_when_track_was_synced_to_iPhone = MM5.track.play_count
2) during iPod > MM5 sync use:
MM5.track.play_count = MM5.track.play_count + (iPod.play_count_user - played_value_when_track_was_synced_to_iPhone)
played_value_when_track_was_synced_to_iPhone = iPod.play_count_user;
Entered as: https://www.ventismedia.com/mantis/view.php?id=18673
EDIT: As for the current workaround: Yes, bulk increasing the 'play_count_recent' is possible, you can use iMazing app to download the MediaLibrary.sqlite from the iPhone and then open it in SQLite studio and update the 'play_count_recent' by SQL query like:
[code]UPDATE item_stats SET play_count_recent = 1 WHERE play_count_user > 0[/code]