php/index.php

   1 <?php
   2 require('inc.header.php');
   3
   4 function ShowChangeLocationForm($media_id)
   5 {
   6   $query  = "SELECT l.id,l.description,lt.description FROM ".
   7     $GLOBALS['config']['tbl_locations']." AS l, ".
   8     $GLOBALS['config']['tbl_location_types']." AS lt ".
   9     "WHERE l.type = lt.id AND l.id != 0 ORDER BY lt.description DESC, l.description";
  10   if (!$res = mysql_query($query))
  11   {
  12     echo "<b>Error:</b> ".mysql_error()." <i>(".basename(__FILE__).", line ".__LINE__.")</i>\n\n";
  13     return;
  14   }
  15
  16   if (!mysql_num_rows($res))
  17   {
  18     echo "No locations found.\n";
  19     return;
  20   }
  21
  22   echo "<form action=\"".$GLOBALS['self']."?media=".$media_id."\" method=\"post\">\n";
  23   echo "Change location to\n";
  24   echo "  <select name=\"new_location\">\n";
  25
  26   $first = TRUE;
  27
  28   while ($row = mysql_fetch_array($res))
  29   {
  30     echo "    <option value=\"".$row[0]."\"";
  31     if ($first)
  32     {
  33       echo " selected=\"selected\"";
  34       $first = FALSE;
  35     }
  36     echo ">".$row[1]." (".$row[2].")"."</option>\n";
  37   }
  38   echo "  </select>\n";
  39   echo "  <input type=\"submit\" value=\"Change\">\n";
  40   echo "</form>\n";
  41 }
  42
  43 function ChangeMediaLocation($media_id, $new_location_id)
  44 {
  45         echo "<p>\n";
  46         $query = "UPDATE ".$GLOBALS['config']['tbl_media'].
  47     " SET location = '".$new_location_id."'".
  48     " WHERE mediaid = '".$media_id."'";
  49 //  echo $query;
  50
  51         if (!$res = mysql_query($query))
  52   {
  53                 echo "<b>Error:</b> ".mysql_error()." <i>(".basename(__FILE__).", line ".__LINE__.")</i>\n<p>\n";
  54         }
  55   else if (mysql_affected_rows() != 0)
  56   {
  57     echo "Location changed.\n\n";
  58     return;
  59   }
  60
  61   echo "Could not change location.\n\n";
  62
  63         echo "</p>\n";
  64 }
  65
  66 if (isset($_GET['media']))
  67 {
  68   if (isset($_POST['new_location']))
  69   {
  70     ChangeMediaLocation($_GET['media'], $_POST['new_location']);
  71   }
  72
  73         echo "<p>\n";
  74         $query = "SELECT m.*,l.description,l.id FROM ".
  75     $config['tbl_media']." AS m, ".
  76     $config['tbl_locations']." AS l ".
  77     "WHERE mediaid = '".addslashes($_GET['media'])."' AND ".
  78     "m.location = l.id ".
  79     "ORDER BY name";
  80
  81         if (!$res = mysql_query($query))
  82   {
  83                 echo "<b>Error:</b> ".mysql_error()." <i>(".basename(__FILE__).", line ".__LINE__.")</i>\n\n";
  84         }
  85   else
  86   {
  87                 if (!mysql_num_rows($res))
  88     {
  89                         echo "Media not found.\n";
  90                 }
  91     else
  92     {
  93                         $row = mysql_fetch_assoc($res);
  94
  95       echo "<table class=\"ObjectParametersTable\">\n";
  96       echo "  <tr>\n";
  97       echo "    <td>Media ID</td>\n";
  98       echo "    <td>".$row['mediaid']."</td>";
  99       echo "  </tr>\n";
 100       echo "  <tr>\n";
 101       echo "    <td>Media description</td>\n";
 102       echo "    <td>".$row["name"]."</td>";
 103       echo "  </tr>\n";
 104       echo "  <tr>\n";
 105       echo "    <td>Media type</td>\n";
 106       echo "    <td>".mb_typetext($row['type'])."</td>";
 107       echo "  </tr>\n";
 108       echo "  <tr>\n";
 109       echo "    <td>Current location</td>\n";
 110       echo "    <td>";
 111       if ($row["description"])
 112       {
 113         echo "<a href=locations.php?id=".$row['id'].">".$row['description']."</a>";
 114       }
 115       else
 116       {
 117         echo "Unknown.";
 118       }
 119       echo "    </td>\n";
 120       echo "  <tr>\n";
 121       echo "</table>\n";
 122       echo "<p>\n";
 123       ShowChangeLocationForm($_GET['media']);
 124       echo "</p>\n";
 125       echo "<p>\n";
 126
 127                         if ($row['type'] == MB_T_AUDIO)
 128       {
 129                                 $query = "SELECT * FROM ".$config['tbl_tracks']." WHERE mediaid = ".$row['mediaid']." ORDER BY trackid";
 130                                 if (!$res = mysql_query($query))
 131         {
 132                                         echo "<b>Error:</b> ".mysql_error()." <i>(".basename(__FILE__).", line ".__LINE__.")</i>\n\n";
 133                                 }
 134         else
 135         {
 136                                         if (!mysql_num_rows($res))
 137           {
 138                                                 echo "No tracks found in database.\n\n";
 139                                         }
 140           else
 141           {
 142                                                 mb_table_start('#','Name','Length');
 143                                                 if (isset($_GET['cat']))
 144             {
 145                                                         $link = "\"$self?cat=".$_GET['cat'].'"';
 146                                                 }
 147             else
 148             {
 149                                                         $link = "\"$self\"";
 150                                                 }
 151                                                 mb_table_widecol("<a href=$link>Back to index</a>");
 152                                                 while ($row = mysql_fetch_assoc($res))
 153             {
 154                                                         mb_table_col($row['trackid']);
 155                                                         mb_table_col($row['name']);
 156                                                         mb_table_col(mb_lengthtext($row['length']));
 157                                                 }
 158                                                 mb_table_end();
 159                                         }
 160                                 }
 161                         }
 162       elseif ($row['type'] == MB_T_DATA)
 163       {
 164                                 $dir = isset($_GET['dir']) ? $_GET['dir'] : '/';
 165                                 $parentdir = mb_getparentdir($dir);
 166
 167         echo "<p>".mb_icon('__folder').$dir."<p>";
 168
 169                                 $query = "SELECT * FROM ".$config['tbl_files'].
 170           " WHERE path = '".addslashes($dir)."' AND ".
 171           "mediaid = '".addslashes($_GET['media'])."' ".
 172           "ORDER BY name";
 173
 174                                 if (!$res = mysql_query($query))
 175         {
 176                                         echo "<b>Error:</b> ".mysql_error()." <i>(".basename(__FILE__).", line ".__LINE__.")</i>\n\n";
 177                                 }
 178         else
 179         {
 180                                         if (!mysql_num_rows($res))
 181           {
 182                                                 echo "No files found.\n\n";
 183                                         }
 184           else
 185           {
 186                                                 $folders = array();
 187                                                 $files = array();
 188                                                 while ($row = mysql_fetch_assoc($res))
 189             {
 190                                                         if (substr($row['name'],-1) == '/')
 191               {
 192                                                                 $folders[] = $row;
 193                                                         }
 194               else
 195               {
 196                                                                 $files[] = $row;
 197                                                         }
 198                                                 }
 199                                                 $selflink  = "$self?media=".$_GET['media'].(isset($_GET['cat'])?'&cat='.$_GET['cat']:'');
 200                                                 mb_table_start('Filename','Size','Timestamp');
 201                                                 if ($parentdir)
 202             {
 203                                                         mb_table_widecol("<a href=\"$selflink&dir=".urlencode($parentdir)."\">Parent directory</a>");
 204                                                 }
 205             else
 206             {
 207                                                         if (isset($_GET['cat']))
 208               {
 209                                                                 $link = "\"$self?cat=".$_GET['cat'].'"';
 210                                                         }
 211               else
 212               {
 213                                                                 $link = "\"$self\"";
 214                                                         }
 215                                                         mb_table_col("<a href=$link>Back to index</a>");
 216                                                         mb_table_col('&nbsp;');
 217                                                         mb_table_col('&nbsp;');
 218                                                 }
 219                                                 foreach ($folders as $folder)
 220             {
 221                                                         $link = "<a href=\"$selflink&dir=".urlencode($dir.$folder['name']).'">'.$folder['name']."</a>";
 222                                                         mb_table_col(mb_icon('__folder').$link);
 223                                                         mb_table_col('&nbsp;');
 224                                                         mb_table_col(mb_datetext($folder['time']));
 225                                                 }
 226                                                 foreach ($files as $file)
 227             {
 228                                                         echo "  <tr>\n";
 229                                                         mb_table_col(mb_icon('__unknown').$file['name']);
 230                                                         mb_table_col(mb_sizetext($file['size']));
 231                                                         mb_table_col(mb_datetext($file['time']));
 232                                                 }
 233                                                 mb_table_end();
 234                                         }
 235                                 }
 236                         }
 237       else
 238       {
 239                                 echo "<b>Error:</b> Media must be either data or audio.\n";
 240                         }
 241                 }
 242         }
 243 }
 244 elseif (!$config['use_categories'] || isset($_GET['cat']))
 245 {
 246         if ($config['use_categories'])
 247   {
 248                 $query = "SELECT m.*,c.name as category FROM ".
 249       $config['tbl_media']." AS m, ".
 250       $config['tbl_categories']." AS c ".
 251       "WHERE m.catid = c.catid AND c.catid = ".addslashes($_GET['cat'])." ORDER BY m.name";
 252         }
 253   else
 254   {
 255                 $query = "SELECT l.description,l.id,m.* FROM ".
 256       $config['tbl_media']." AS m, ".
 257       $config['tbl_locations']." AS l ".
 258       "WHERE m.location = l.id ".
 259       "ORDER BY m.mediaid DESC";
 260         }
 261
 262         if (!$res = mysql_query($query))
 263   {
 264                 echo "<b>Error:</b> ".mysql_error()." <i>(".basename(__FILE__).", line ".__LINE__.")</i>\n\n";
 265         }
 266   else
 267   {
 268                 if (!mysql_num_rows($res))
 269     {
 270                         echo "No media found".($config['use_categories']?' in this category':'').".\n";
 271                 }
 272     else
 273     {
 274       mb_table_start('Media ID',
 275                      'Name',
 276                      'Date Added',
 277                      'Location');
 278
 279                         if ($config['use_categories'])
 280       {
 281                                 mb_table_widecol("<a href=\"$self\">Back to category index</a>");
 282                         }
 283
 284                         while ($row = mysql_fetch_assoc($res))
 285       {
 286                                 $extra = ($config['use_categories']?'&cat='.$row['catid']:'');
 287                                 $link = (($row['type'] == MB_T_AUDIO) || ($row['type'] == MB_T_DATA));
 288                                 mb_table_col($row['mediaid']);
 289                                 mb_table_col(mb_iconbytype($row['type']).
 290                      ($link?"<a href=\"$self?media=".
 291                       $row['mediaid'].
 292                       $extra.
 293                       '">':'').
 294                      truncate_ellipsis($row['name'], $config['media_title_ellipsis_limit']).
 295                      ($link?'</a>':''));
 296                                 mb_table_col(mb_datetext($row['added']));
 297                                 mb_table_col("<a href=locations.php?id=".$row['id'].">".$row['description']."</a>");
 298                         }
 299
 300                         mb_table_end();
 301                 }
 302         }
 303 }
 304 else
 305 {
 306         echo "<p>\n";
 307         $query  = "SELECT c.catid,c.name,count(m.mediaid) AS count FROM ".$config['tbl_categories']." AS c LEFT JOIN ";
 308         $query .= $config['tbl_media']." AS m ON m.catid = c.catid GROUP BY c.catid ORDER BY c.name";
 309         if (!$res = mysql_query($query))
 310   {
 311                 echo "<b>Error:</b> ".mysql_error()." <i>(".basename(__FILE__).", line ".__LINE__.")</i>\n\n";
 312         }
 313   else
 314   {
 315                 if (!mysql_num_rows($res))
 316     {
 317                         echo "No categories found.\n";
 318                 }
 319     else
 320     {
 321                         mb_table_start('Category','Media');
 322                         while ($row = mysql_fetch_assoc($res))
 323       {
 324                                 mb_table_col(mb_icon('__category').
 325                      "<a href=\"$self?cat=".
 326                      $row['catid'].'">'.
 327                      $row['name'].
 328                      "</a>");
 329                                 mb_table_col($row['count']);
 330                         }
 331                         mb_table_end();
 332                 }
 333         }
 334 }
 335
 336 require('inc.footer.php');
 337 ?>