by Ludek » Wed Apr 02, 2008 12:53 pm
Re: Top 10 Albums Played, Top 10 Artists Played
Yes, the determinant here is "How many songs of this album/artist have been played"
e.g.
Album1: 20 tracks and 18 of them have been played only once.
Album 2: 15 tracks and all 15 track have been played 6 times.
The Album1 will be higher because more tracks of this album have been played.
Do you think that there should be another determinant/indicator related to playcount?
You might be right. Then the SQL query in the Stats.vbs needs to be modified slightly:
i.e. Replace Count(Songs.ID) by Sum( PlayCounter)
in Scripts\stats.vbs on the lines 685 (twice - also in ORDER BY part) for Top 10 Artists Played and on the lines 746, 752 for Top 10 albums Played
Edited: I meant Sum( PlayCounter)
Re: Top 10 Albums Played, Top 10 Artists Played
Yes, the determinant here is "How many songs of this album/artist have been played"
e.g.
Album1: 20 tracks and 18 of them have been played only once.
Album 2: 15 tracks and all 15 track have been played 6 times.
The Album1 will be higher because more tracks of this album have been played.
Do you think that there should be another determinant/indicator related to playcount?
You might be right. Then the SQL query in the Stats.vbs needs to be modified slightly:
i.e. Replace Count(Songs.ID) by Sum( PlayCounter)
in Scripts\stats.vbs on the lines 685 (twice - also in ORDER BY part) for Top 10 Artists Played and on the lines 746, 752 for Top 10 albums Played
Edited: I meant Sum( PlayCounter)