Jukebox/w3tpl

The Hypertwin Jukebox

is under construction, but here are all the artists <hide>

=========

<func GetArtists>

 <for db=audioferret table="qryArtists_index" sort="name" name=ar>
   <let name=ar_name val="@row.ar.name" />
   <let name=outFunc append>

• </let>

   <let name=outFunc append vars>[$@row.ar.id$ </let>
   <let name=outFunc append copy=ar_name />
   <let name=outFunc append>]</let>
 </for>

</func>

<func GetAlbums>

 <let name=sqlFilt vars>idartist=</let>
 <let name=sqlFilt append copy=doArtist />
 <for db=audioferret table="Albums" where=$sqlFilt sort="sort, name" name=al>
   <let name=al_name val="@row.al.name" />
   <let name=outFunc append>

• </let>

   <let name=outFunc append vars>[$doArtist$&album=[$@row.al.id$] </let>
   <let name=outFunc append copy=al_name />
   <let name=outFunc append>]</let>
 </for>

</func>

<func GetTitles>

 <if flag=doAlbum>
   <let name=sqlFilt vars>album_id=</let>
   <let name=sqlFilt append copy=doAlbum />
 </if><else>
   <let name=sqlFilt vars>artist_id=</let>
   <let name=sqlFilt append copy=doArtist />
 </else>
 <for db=audioferret table="Titles" where=$sqlFilt sort="track, name" name=ti>
   <let name=outFunc append>

• </let>

   <let name=outFunc append copy=@row.ti.track />
   <let name=outFunc append>. </let>
   <let name=outFunc append copy=@row.ti.name />
 </for>

</func>

================

Turn off page cache: <w3tpl nocache />

Get the input arguments: <let name=doArtist copy=@query.artist /> <let name=doAlbum copy=@query.album />

Always show the artists: <call GetArtists />

<let name=out>

Artists</let> <if flag=doArtist> <let name=doTitles val=1 /> </if> <if flag=doArtist> <let name=out append> || Albums</let> </if> <if flag=doTitles> <let name=out append> || Titles</let> </if> <let name=out append>
</let> <let name=out append copy=outFunc /> <let name=outFunc null /> <if flag=doArtist> <call GetAlbums /> <let name=out append>	</let> <let name=out append copy=outFunc /> <let name=outFunc null /> </if> <if flag=doTitles> <call GetTitles /> <let name=out append>	</let> <let name=out append copy=outFunc /> <let name=outFunc null /> </if> <let name=out append>

</let>

===============

</hide><get name=out />