erland;609746 Wrote:
> Try configure it in the RatingTag scanning module in Custom Scan, this
> will import it into TrackStat and Squeezebox Server standard database
> tables.
Thanks. I should have said I'd already done that. Whilst I have now
found a way to include the custom scan rating in the web interface
title (using the CUSTOMSCAN_RATINGTAG_RATING keyword), I don't seem to
be able to change the title on the touch. Do you know if that is that a
limitation of the touch?
I think I've figured out that the custom scanned rating is not included
in or related to any trackstat ratings. Is that correct, or is there an
explanation somewhere on the wiki that I have missed? Is there a
sensible range I should use on custom scanned ratings (eg 1-5, 1-10,
1-99??
I did try the 'rating' menu under custom browse, but that returned the
error below. I'm not quite sure, but it seems it doesn't recognise
{rating}.
Home / Custom Browse / Ratings / Artists
No matching songs, albums or artists were found
Refresh(Custom Browse 2.10.3296)
Error:
Running: select
contributors.id,contributors.name,substr(contributors.namesort,1,1)
from contributors,tracks,contributor_track,track_statistics where
tracks.audio=1 and tracks.id=contributor_track.track and
contributor_track.contributor=contributors.id and
contributor_track.role in (1,5) and tracks.url=track_statistics.url and
ifnull(track_statistics.rating,0)>={rating}-10 and
ifnull(track_statistics.rating,0)<{rating}+10 group by contributors.id
order by contributors.namesort asc got error:
You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near '}-10 and
ifnull(track_statistics.rating,0)<{rating}+10 group by contributor' at
line 8Running: select ,case when =0 then 'Unrated' else
concat(floor((+10)/20),' stars') end got error:
You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near 'case when
=0 then 'Unrated' else concat(floor((+10)/20),' stars') end' at line 1
--
PasTim
------------------------------------------------------------------------
PasTim's Profile: http://forums.slimdevices.com/member.php?userid=41642
View this thread: http://forums.slimdevices.com/showthread.php?t=85537
_______________________________________________
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins
