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