Is there any other way to get the length for a track for displaying it
as "xx:xx" other than to assemble it with cumbersome attacks on
tracks.secs?
My current attempt
Code:
--------------------
<menu>
<id>track</id>
<itemtype>track</itemtype>
<itemformat>titleformat</itemformat>
<playtype>all</playtype>
<menutype>sql</menutype>
<jivepattern>^(.*)\s\((.*)\)$</jivepattern>
<menudata>
select
tracks.id,
concat(tracks.title,'
(',if(tracks.secs>59,concat(floor(tracks.secs/60),':',floor(tracks.secs-floor(tracks.secs/60)*60)),concat('00:',floor(tracks.secs))),')'),
substr(tracks.title,1,1)
from tracks,contributor_track,albums
where tracks.audio = 1
and contributor_track.track = tracks.id
and tracks.album = {album}
and contributor_track.contributor = {artist}
and contributor_track.role in (1,5)
group by tracks.id
order by tracks.disc,tracks.tracknum asc,tracks.titlesort asc
</menudata>
<menu>
<id>trackdetails</id>
<menutype>trackdetails</menutype>
<menudata>track|0</menudata>
</menu>
</menu>
--------------------
is already horrendous, and it actually doesn't sufficiently consider
leading zeros.
--
sts78
------------------------------------------------------------------------
sts78's Profile: http://forums.slimdevices.com/member.php?userid=50205
View this thread: http://forums.slimdevices.com/showthread.php?t=90765
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
