php/locations.php

   1 <?php
   2
   3 require('inc.header.php');
   4
   5 function ShowLocations()
   6 {
   7         echo "<p>\n";
   8         $query  = "SELECT l.description,lt.description,l.id FROM ".
   9     $GLOBALS['config']['tbl_locations']." AS l, ".
  10     $GLOBALS['config']['tbl_location_types']." AS lt ".
  11     "WHERE l.type = lt.id AND l.id != 0 ORDER BY lt.description, l.description";
  12         if (!$res = mysql_query($query))
  13   {
  14                 echo "<b>Error:</b> ".mysql_error()." <i>(".basename(__FILE__).", line ".__LINE__.")</i>\n\n";
  15     return;
  16         }
  17
  18   if (!mysql_num_rows($res))
  19   {
  20     echo "No locations found.\n";
  21     return;
  22   }
  23
  24   mb_table_start('Location','Type');
  25   while ($row = mysql_fetch_array($res))
  26   {
  27     mb_table_col("<a href=\"".$GLOBALS['self']."?id=".$row[2]."\">".$row[0]."</a>");
  28     mb_table_col($row[1]);
  29   }
  30   mb_table_end();
  31         echo "</p>\n";
  32 }
  33
  34 function ShowAddLocationForm()
  35 {
  36         $query  = "SELECT * FROM ".
  37     $GLOBALS['config']['tbl_location_types']." AS lt ".
  38     "WHERE id != 0 ORDER BY description";
  39         if (!$res = mysql_query($query))
  40   {
  41                 echo "<b>Error:</b> ".mysql_error()." <i>(".basename(__FILE__).", line ".__LINE__.")</i>\n\n";
  42     return;
  43         }
  44
  45         echo "<p>\n";
  46   echo "<form action=\"".$GLOBALS['self']."\" method=\"post\">\n";
  47   echo "        Add new location <input type=\"text\" class=\"input-text\" name=\"location_add\">\n";
  48   echo "<select name=\"location_type\" class=\"input-select\">\n";
  49
  50   $first = TRUE;
  51
  52   while ($row = mysql_fetch_assoc($res))
  53   {
  54     echo "  <option value=\"".$row['id']."\"";
  55     if ($first)
  56     {
  57       echo " selected=\"selected\"";
  58       $first = FALSE;
  59     }
  60     echo ">".$row['description']."</option>\n";
  61   }
  62   echo "</select>\n";
  63   echo "        <input type=\"submit\" class=\"input-button\" value=\"Add\">\n";
  64   echo "</form>\n";
  65         echo "</p>\n";
  66 }
  67
  68 function AddLocation()
  69 {
  70   if ($GLOBALS['config']['readonly_mode'])
  71   {
  72     echo "<p>Cannot modify database in read-only mode.</p>\n";
  73   }
  74   else
  75   {
  76     $query = "INSERT INTO ".$GLOBALS['config']['tbl_locations'].
  77       "(description,type)".
  78       " VALUES ('".addslashes($_POST['location_add'])."', ".$_POST['location_type'].")";
  79     if (!$res = mysql_query($query))
  80     {
  81       echo "<b>Error:</b> ".mysql_error()." <i>(".basename(__FILE__).", line ".__LINE__.")</i>\n<p>\n";
  82     }
  83     else if (mysql_affected_rows() != 0)
  84     {
  85       echo "Location added.\n\n";
  86       return;
  87     }
  88   }
  89
  90   echo "Could not add location.\n\n";
  91 }
  92
  93 function ShowLocation($location_id)
  94 {
  95         $query  = "SELECT l.description,lt.description FROM ".
  96     $GLOBALS['config']['tbl_locations']." AS l, ".
  97     $GLOBALS['config']['tbl_location_types']." AS lt ".
  98     "WHERE l.type = lt.id AND l.id = ".$location_id;
  99         if (!$res = mysql_query($query))
 100   {
 101                 echo "<b>Error:</b> ".mysql_error()." <i>(".basename(__FILE__).", line ".__LINE__.")</i>\n\n";
 102     return;
 103         }
 104
 105   if (!mysql_num_rows($res))
 106   {
 107     echo "No locations found.\n";
 108     return;
 109   }
 110
 111   $row = mysql_fetch_array($res);
 112   echo "<table class=\"ObjectParametersTable\">\n";
 113   echo "  <tr>\n";
 114   echo "    <td>Location description</td>\n";
 115   echo "    <td>".$row[0]."</td>";
 116   echo "  </tr>\n";
 117   echo "  <tr>\n";
 118   echo "    <td>Location type</td>\n";
 119   echo "    <td>".$row[1]."</td>";
 120   echo "  </tr>\n";
 121   echo "</table>\n";
 122
 123   $query = "SELECT l.description,m.* FROM ".
 124     $GLOBALS['config']['tbl_media']." AS m, ".
 125     $GLOBALS['config']['tbl_locations']." AS l ".
 126     "WHERE m.location = l.id AND m.location = ".$location_id." ".
 127     "ORDER BY m.mediaid DESC";
 128
 129         if (!$res = mysql_query($query))
 130   {
 131                 echo "<b>Error:</b> ".mysql_error()." <i>(".basename(__FILE__).", line ".__LINE__.")</i>\n\n";
 132     return;
 133         }
 134
 135   if (!mysql_num_rows($res))
 136   {
 137     echo "No media at this location.\n";
 138     return;
 139   }
 140
 141   echo "<p>\n";
 142
 143   mb_table_start('Media ID',
 144                  'Name');
 145
 146   while ($row = mysql_fetch_assoc($res))
 147   {
 148     $link = (($row['type'] == MB_T_AUDIO) || ($row['type'] == MB_T_DATA));
 149     mb_table_col($row['mediaid']);
 150     mb_table_col(mb_iconbytype($row['type']).
 151                  ($link?"<a href=\"index.php?media=".
 152                   $row['mediaid'].
 153                   '">':'').
 154                  $row['name'].
 155                  ($link?'</a>':''));
 156   }
 157   mb_table_end();
 158   echo "</p>\n";
 159 }
 160
 161 if (isset($_GET['id']))
 162 {
 163   ShowLocation($_GET['id']);
 164 }
 165 else
 166 {
 167   if (isset($_POST['location_add']) && strlen($_POST['location_add']) > 0)
 168   {
 169     AddLocation();
 170   }
 171
 172   ShowLocations();
 173   ShowAddLocationForm();
 174 }
 175
 176 require('inc.footer.php');
 177
 178 ?>