www/album.php

   1 <?php
   2   unset($altr);  if ( isset($_GET['altr']) ) $altr = $_GET['altr'];
   3   unset($lltr);  if ( isset($_GET['lltr']) ) $lltr = $_GET['lltr'];
   4   unset($a);  if ( isset($_GET['a']) ) $a = $_GET['a'];
   5   unset($l);  if ( isset($_GET['l']) ) $l = $_GET['l'];
   6
   7   require_once("always.php");
   8   require_once("Session.php");
   9   require_once("PlayTracks.php");
  10
  11   $title = $system_name;
  12   require_once("header.php");
  13
  14
  15   if ( "$error_loc$error_msg" == "" ) {
  16
  17 function track_link( $trk, $link_title, $row_class = "" ) {
  18   global $letter_get, $search;
  19
  20   $url_artist = urlencode($trk->artist);
  21   $track_link_url = sprintf( "?l=%s&a=%s&t=%s", urlencode($trk->album), $url_artist, urlencode($trk->title) );
  22
  23   $link_title = ($trk->tracknum > 0 ? "$trk->tracknum: " : "") . $trk->title;
  24   $safe_title = htmlspecialchars($link_title);
  25   $safe_artist = htmlspecialchars($trk->artist);
  26
  27   if ( isset($search) ) {
  28     $delimiter_list = '/#~`!@$%^&*_-=|';
  29     for( $i=0; strpos($search,substr($delimiter_list,$i,1)) !== false; $i++ );
  30     $delimiter = substr($delimiter_list,$i,1);
  31     if ( preg_match($delimiter.$search.$delimiter.'i', $link_title) || preg_match($delimiter.$search.$delimiter.'i', $trk->artist) ) {
  32       $row_class = "found";
  33     }
  34   }
  35
  36   $duration = preg_replace( "/^[0:]{1,4}/", "", $trk->duration );
  37   $link = <<<EOHTML
  38 <tr class="track$row_class">
  39   <td class="track$row_class">
  40     <a class="track$row_class" href="artist.php$track_link_url$letter_get" title="$trk->path_name">$safe_title</a>
  41     /
  42     <a class="track$row_class" href="artist.php?a=$url_artist$letter_get" title="Show tracks by $trk->artist">$safe_artist</a>
  43   </td>
  44   <td class="track$row_class">$duration</td>
  45   <th class="track$row_class">
  46     <a class="alphabetica" href="edit_track.php$track_link_url" title="Edit Track Info">E</a>
  47   </th>
  48 </tr>
  49
  50 EOHTML;
  51
  52   return $link;
  53 }
  54
  55
  56     echo "<table width=\"100%\"><tr valign=\"top\">\n";
  57
  58     echo "<td width=\"40%\">\n";
  59     if ( isset($a) ) {
  60       $qa = "SELECT artist, album, title, tracknum, path_name, duration::interval(0), ";
  61       $qa .= "extract( EPOCH FROM duration)::int AS secs, quality ";
  62       $qa .= "FROM tracks WHERE lower(artist) = lower('" . addslashes($a) . "') ";
  63       $qa .= "ORDER BY lower(album), setpart, tracknum; ";
  64       $qry = new AwlQuery($qa);
  65       if ( $qry->Exec() && $qry->rows() > 0 ) {
  66         echo "<h3>".htmlspecialchars($a)."</h3>\n";
  67         $last_album = null;
  68         $rownum = 0;
  69         while ( $track = $qry->Fetch() ) {
  70           if ( $track->album != $last_album ) {
  71             if ( $rownum > 1 ) echo "</table>";
  72             echo "<br><table width=100% cellspacing=0 cellpadding=0><tr class=th4>";
  73             echo "<a class=th4 href=\"album.php?a=" . urlencode($track->artist) . "&l=" . urlencode($track->album) . "$letter_get\">";
  74             echo "<td width=86% class=th4>";
  75             echo htmlspecialchars($track->album);
  76             echo "</td>\n";
  77             echo "</a>";
  78             echo "<td width=10% class=th4>&nbsp;</td>";
  79             echo "<td width=4% class=th4><a class=alphabetica  class=track href=\"edit_track.php?l=" . urlencode($track->album) . "&a=" . urlencode($track->artist) . "\" title=\"Edit Album Info\">E</a></td></tr>";
  80             $last_album = $track->album;
  81           }
  82           else if ( $rownum == 0 ) {
  83             echo "<br><table width=100%><tr><td width=96% class=h4>";
  84             echo "<h4>Unkown Album</h4></td><td width=4%>&nbsp;</td></tr>\n";
  85           }
  86           echo track_link($track, ($track->tracknum > 0 ? "$track->tracknum: " : "") . "$track->title",  $rownum % 2 );
  87           $rownum++;
  88         }
  89         echo "</table>";
  90       }
  91     }
  92     else if ( isset( $l ) ) {
  93       $qa = "SELECT artist, album, title, tracknum, path_name, duration::interval(0), ";
  94       $qa .= "extract( EPOCH FROM duration)::int AS secs, quality ";
  95       $qa .= "FROM tracks WHERE album = '" . addslashes($l) . "' ";
  96       $qa .= "ORDER BY album, setpart, tracknum; ";
  97       $qry = new AwlQuery($qa);
  98       if ( $qry->Exec() && $qry->rows() > 0 ) {
  99         echo "<h3><a class='th4' title='Add this whole album to the playlist.' href=\"album.php?play=1&l=" . urlencode($l) . "$letter_get\">$l</a></h3>\n";
 100         $last_album = "";
 101         $rownum = 0;
 102         while ( $track = $qry->Fetch() ) {
 103           if ( $rownum == 0 ) {
 104             echo "<br /><table width=100%>";
 105           }
 106           echo track_link($track, ($track->tracknum > 0 ? "$track->tracknum: " : "") . "$track->title / $track->artist",  $rownum % 2 );
 107           $rownum++;
 108         }
 109         echo "</table>";
 110       }
 111     }
 112     else {
 113       echo "&nbsp;";
 114     }
 115     echo "</td>";
 116
 117     echo "<td width=\"60%\">\n";
 118     echo "<h3>Albums</h3>\n<p>";
 119     if ( isset($altr) || isset($search) ) {
 120       $altr = trim("$altr");
 121       if ( isset($search) ) {
 122         $sql = "SELECT distinct ON ( lower(album)) album FROM tracks ";
 123         $sql .= "WHERE artist ~* ? OR album ~* ? OR title ~* ? OR path_name ~* ? ";
 124         $sql .= "ORDER BY lower(album);";
 125         $qry = new AwlQuery( $sql, $search, $search, $search, $search );
 126       }
 127       else {
 128         $qry = new AwlQuery( "SELECT distinct ON ( lower(album)) album FROM tracks WHERE album ~* ? ORDER BY lower(album);", "^$altr");
 129       }
 130       if ( $qry->Exec('album') && $qry->rows() > 0 ) {
 131         while ( $album = $qry->Fetch() ) {
 132           $display = htmlspecialchars($album->album);
 133           if ( trim($display) == "" ) $display = "&laquo;unknown&raquo;";
 134           echo " <a href=\"album.php?l=" . urlencode($album->album) . "$letter_get\" class=\"artist\">$display</a>\n";
 135         }
 136       }
 137     }
 138     echo "</td>\n";
 139
 140     echo "</tr></table>\n";
 141   }
 142
 143   include("footers.php");
 144 ?>