www/index.php

   1 <?php
   2   require_once("always.php");
   3   require_once("Session.php");
   4   require_once("PlayTracks.php");
   5
   6   $title = $system_name;
   7   require_once("header.php");
   8
   9 function track_link( $trk, $link_title, $row_class = "" ) {
  10   global $letter_get;
  11
  12   $track_link_url = sprintf( "?l=%s&a=%s&t=%s", urlencode($trk->album), urlencode($trk->artist)
  13 , urlencode($trk->title) );
  14   $safe_title = htmlspecialchars($link_title);
  15   $duration = preg_replace( "/^[0:]{1,4}/", "", $trk->duration );
  16   $link = <<<EOHTML
  17 <tr class="track$row_class">
  18   <td class="track$row_class">
  19     <a class="track$row_class" href="artist.php$track_link_url$letter_get" title="$trk->path_na
  20 me">$safe_title</a>
  21   </td>
  22   <td class="track$row_class">$duration</td>
  23   <th class="track$row_class">
  24     <a class="alphabetica" href="edit_track.php$track_link_url" title="Edit Track Info">E</a>
  25   </th>
  26 </tr>
  27
  28 EOHTML;
  29
  30   return $link;
  31 }
  32
  33 function current_queue() {
  34   if ( ! file_exists( "/var/run/adorno/queue.txt" ) ) return;
  35   $fd = fopen( "/var/run/adorno/queue.txt", "r" );
  36
  37   /**
  38   * Build an array of the tracks
  39   */
  40   if ( $fd ) {
  41     $track = fgets( $fd, 300 );  // Skip the "now playing" - it showed at the top.
  42     $track = fgets( $fd, 300 );  // Skip the start time...
  43     $queue_pos = array();
  44     $position = 0;
  45     $in_list = "";
  46     while( !feof( $fd ) ) {
  47       $track = fgets( $fd, 300 );
  48       $track = rtrim( $track, "\r\n");
  49       $in_list .= ($position == 0 ? "" : ", ") . qpg($track);
  50       $queue_pos[$track] = $position++;
  51     }
  52     fclose($fd);
  53   }
  54
  55   /**
  56   * Select the track information from the database
  57   */
  58   $sql = sprintf("SELECT * FROM tracks WHERE path_name IN ( %s );", $in_list );
  59   $qry = new PgQuery( $sql );
  60   $queue = array();
  61   if ( $qry->Exec("current_queue",__LINE__,__FILE__) && $qry->rows ) {
  62     while( $track = $qry->Fetch() ) {
  63       $position = $queue_pos[$track->path_name];
  64       $queue[$position] = $track;
  65     }
  66   }
  67
  68   return $queue;
  69 }
  70
  71
  72 $tracks = current_queue();
  73 echo '<table id="queue">';
  74 foreach( $tracks AS $k => $v ) {
  75   echo <<<EOHTML
  76
  77 <tr>
  78   <td id="now_playing">
  79     <span class="track_title">$track->title</span>
  80     <span class="album_title">$track->album</span>
  81     <span class="artist_name">$track->artist</span>
  82   </td>
  83 </tr>
  84 EOHTML;
  85
  86 }
  87 echo "</table>\n";
  88 ?>
  89
  90 </body>
  91 </html>