I found some help on the wiki, but I'm still not quite getting there.
Here is the code for the menu I'm trying to create:
<?xml version="1.0" encoding="utf-8"?>
<custombrowse>
<minslimserverversion>6.5</minslimserverversion>
<database>mysql</database>
<menu>
<menuname>Original Decade</menuname>
<menuorder>50</menuorder>
<menu>
<id>original year</id>
<menuname>Albums</menuname>
<pathtype>sql</pathtype>
<pathtypedata>select {context.itemid},case when
{context.itemid}>0 then concat(floor({context.itemid}/10)*10,'s')
else 'Unknown' end</pathtypedata>
<customitemtype>decade</customitemtype>
<menutype>sql</menutype>
<menudata>
select floor(tracks.original year/10)*10,case
when tracks.original
year>0 then concat(floor(tracks.original year/10)*10,'s') else
'Unknown' end from tracks
where
tracks.audio=1
group by floor(tracks.oringal
year/10)*10
order by tracks.original year asc
</menudata>
<menu>
<id>album</id>
<menuname>Songs</menuname>
<itemtype>album</itemtype>
<itemformat>album</itemformat>
<menutype>sql</menutype><defaultoption>bytitle</defaultoption>
<option>
<id>bytitle</id>
<name>Sort by title</name>
<menulinks>alpha</menulinks>
<keyword name="orderby"
value="albums.titlesort asc,albums.disc
asc"/>
</option>
<option>
<id>byoriginal year</id>
<name>Sort by original year</name>
<menulinks>number</menulinks>
<keyword name="orderby"
value="albums.original year desc,
albums.titlesort asc,albums.disc asc"/>
</option>
<option>
<id>byartist</id>
<name>Sort by artist</name>
<menulinks>number</menulinks>
<itemformat>albumconcat</itemformat>
<menudata>
select
albums.id,if(albums.compilation,' ',concat('(', group_concat(distinct
contributors.name separator ',') ,')')) from
tracks,albums,contributor_track,contributors
where
tracks.id=contributor_track.track and
tracks.album=albums.id
and
contributor_track.contributor=contributors.id and
contributor_track.role
in (1) and
tracks.original
year>={original year} and
tracks.original
year<{orignal year}+10
group by albums.id
order by contributors.namesort
asc,albums.original year desc
</menudata>
</option>
<jivepattern>^(.*)\s\((.*)\)$</jivepattern>
<menudata>
select
albums.id,albums.title,substr(albums.titlesort,1,1) from
tracks,albums
where
tracks.audio=1 and
albums.id=tracks.album and
tracks.orignal
year>={original year} and
tracks.original
year<{original year}+10
group by albums.id
order by {orderby}
</menudata>
<menu>
<id>track</id>
<itemtype>track</itemtype>
<itemformat>track</itemformat>
<playtype>all</playtype>
<menutype>sql</menutype>
<menudata>
select tracks.id,tracks.title
from tracks,albums
where
tracks.audio=1 and
tracks.album={album}
and
tracks.orignal
year>={original year} and
tracks.original
year<{original year}+10
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>
</menu>
</menu>
</menu>
</custombrowse>
And this is the error I get when I try to browse that menu:
Error:
Running: select floor(tracks.original year/10)*10,case when
tracks.original year>0 then concat(floor(tracks.original
year/10)*10,'s') else 'Unknown' end from tracks where tracks.audio=1
group by floor(tracks.oringal year/10)*10 order by tracks.original year
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
'year/10)*10,case when tracks.original year>0 then
concat(floor(tracks.original y' at line 1
Anybody have any ideas?
--
traut
------------------------------------------------------------------------
traut's Profile: http://forums.slimdevices.com/member.php?userid=8407
View this thread: http://forums.slimdevices.com/showthread.php?t=64984
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
