RE: How best to collect stats for xplrionet play top 10 20 etc

["UKHA" <ukha@xxxxxxxxxxxxxxxxxxxxxxx>]

On 03/03/2005 at 10:40 Tony Tofts wrote:

>> play-table =  date/time, counter, player-used,checksum
>
>Actually this doesn't make sense, the date/time field would have to be
>dropped otherwise the count is always 1....?

Yup agreed....unless it was the 'last played'  date/time and the counter
just incremented.. not actually sure why use the date would be, but you
never know ;)

>
>> chart-table = track title, track album, checksum
>
>I'll skip this table, as it will be quite large, and can be
theoretically
>recreated from the above table

Yes, the idea was to recreate this table once a day/week/month or whatever.
It should only contain the top 10/50/100 albums and tracks so should
actually be a fixed(ish) size depending on how many tracks/albums were
played the same number of times, ie number 1 in the chart may be a shared
1st place with 4 others, making the next position 6th...

The table, once generated, can be used to find the real id of a track/album
and allow you to click it to add to the playlist etc..

Andy




xPL Links: http://www.xplproject.org.uk http://www.xplhal.com http://www.xpl.myby.co.uk
To Post a Message: ukha_xpl@xxxxxxx
To Subscribe:  ukha_xpl-subscribe@xxxxxxx
To Unsubscribe:  ukha_xpl-unsubscribe@xxxxxxx