Chunkywizard;648053 Wrote:
> Hi erland,
>
> a really small discrepancy I have just noted. Looking at database query
> I see that in trackstat statistics I see:
>
> Number of unplayed songs 0
> Number of unplayed albums 0
> Number of unplayed artists 0
>
> but in SBS statistics I see:
>
> Number of unplayed songs 10
> Number of unplayed albums 3
> Number of unplayed artists 3
>
> I made a SQL Playlist to only play unplayed songs and it said 'no
> songs' so I think SBS statistics is wrong.
>
> One other thing, what is the difference between TrackStat stats and SBS
> stats??
>
TrackStat Statistics and SBS Statistics are stored in different tables.
The difference are:
- SBS Statistics are overwritten during rescans (if you use iTunes or
MusciIP integation if I remember correctly)
- TrackStat statistics is merged if you are using its iTunes or MusicIP
import modules but it's merged in a smart way so it will for example
never import a play count from iTunes/MusicIP that's lower than the
TrackStat play count.
- SBS Statistics count a track as played even if it's only played a
single second and then skipped, TrackStat is a bit smarter and doesn't
consider a track played until you have played a certain part of the
track (can be configured in TrackStat settings)
I think the existing SQL Playlist template only uses the TrackStat data
as that's the only one I trust.
It's hard to say exactly what's causing the difference in your setup
but my guess would be that you use either iTunes or MusicIP integration
and they contain a 0 play count for the track and due to this have
overwritten the SBS Statistics when you did a full rescan. TrackStat
play counts will never be decreased when importing statistics from
iTunes or MusicIP because if the play counts are higher in TrackStat
then iTunes it just means that you have played some music on the
Squeezebox since you last synchronized with iTunes.
--
erland
Erland Isaksson ('My homepage' (http://erland.isaksson.info))
(Developer of 'many plugins/applets'
(http://wiki.slimdevices.com/index.php/User:Erland). If my answer
helped you and you like to encourage future presence on this forum
and/or third party plugin/applet development, 'donations are always
appreciated' (http://erland.isaksson.info/donate))
------------------------------------------------------------------------
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=49483
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
