Index: /trunk/MagicSoft/Mars/datacenter/db/magicdefs.php
===================================================================
--- /trunk/MagicSoft/Mars/datacenter/db/magicdefs.php	(revision 8234)
+++ /trunk/MagicSoft/Mars/datacenter/db/magicdefs.php	(revision 8235)
@@ -81,4 +81,6 @@
      "fObjectName"                       => CheckWhere("fObjectKEY",                       $_GET),
      "fStatusName"                       => CheckWhere("fStatusKEY",                       $_GET),
+     "fTelescopeName"                    => CheckWhere("fTelescopeKEY",                    $_GET),
+     "fBandName"                         => CheckWhere("fBandKEY",                         $_GET),
     );
 
@@ -104,4 +106,6 @@
      "fObjectName"                       => CheckGroup("fObjectKEY",                       $_GET),
      "fStatusName"                       => CheckGroup("fStatusKEY",                       $_GET),
+     "fBandName"                         => CheckGroup("fBandKEY",                         $_GET),
+     "fTelescopeName"                    => CheckGroup("fTelescopeKEY",                    $_GET),
     );
 
@@ -318,4 +322,6 @@
      "fInstrumentalMagErr"              => "Instr.Mag.Err.",
      "fStatusName"                      => "StatusCode",
+     "fTelescopeName"                   => "Telescope",
+     "fBandName"                        => "Band",
 //     "COUNT(*)"                         => "# Runs",
 //     "COUNT(*)"                         => "Sequence",
@@ -625,4 +631,6 @@
          "fObjectName"                       => " LEFT JOIN Object                       ON " . $fromtable . ".fObjectKEY=Object.fObjectKEY ",
          "fStatusName"                       => " LEFT JOIN Status                       ON " . $fromtable . ".fStatusKEY=Status.fStatusKEY ",
+         "fBandName"                         => " LEFT JOIN Band                         ON " . $fromtable . ".fBandKEY=Band.fBandKEY ",
+         "fTelescopeName"                    => " LEFT JOIN Telescope                    ON " . $fromtable . ".fTelescopeKEY=Telescope.fTelescopeKEY ",
         );
 
Index: /trunk/MagicSoft/Mars/datacenter/db/opticaldata.php
===================================================================
--- /trunk/MagicSoft/Mars/datacenter/db/opticaldata.php	(revision 8234)
+++ /trunk/MagicSoft/Mars/datacenter/db/opticaldata.php	(revision 8235)
@@ -133,5 +133,5 @@
 
         if (empty($_GET["fFitsFileName"]))
-            $_GET["fFitsFileName"]=$first?"On":"";
+            $_GET["fFitsFileName"]="Off";
 
         if (empty($_GET["fObjectName"]))
@@ -139,5 +139,11 @@
 
         if (empty($_GET["fStatusName"]))
-            $_GET["fStatusName"]=$first?"On":"";
+            $_GET["fStatusName"]="Off";
+
+        if (empty($_GET["fBandName"]))
+            $_GET["fBandName"]=$first?"On":"";
+
+        if (empty($_GET["fTelescopeName"]))
+            $_GET["fTelescopeName"]=$first?"On":"";
 
 //        if (empty($_GET["fRunStop"]))
@@ -166,5 +172,5 @@
         printf("  </tr>\n");
         printf(" </table>\n");
-         printf(" <p>\n");
+        printf(" <p>\n");
 
         // pull down boxes
@@ -172,7 +178,11 @@
         printf(" <table>\n");
         printf("  <tr><td>\n");
-        PrintPullDown($host, $user, $pw, $db, "FitsFile",     "fFitsFileName",     "fFitsFileKEY", "Fits File");
+        PrintPullDown($host, $user, $pw, $db, "Telescope",  "fTelescopeName",  "fTelescopeKEY", "Telescope");
         printf("  </td><td>\n");
         PrintPullDown($host, $user, $pw, $db, "Object",      "fObjectName",      "fObjectKEY", "Object Name");
+        printf("  </td><td>\n");
+        PrintPullDown($host, $user, $pw, $db, "Band",     "fBandName",     "fBandKEY", "Band");
+        printf("  </td></tr><tr><td>\n");
+        PrintPullDown($host, $user, $pw, $db, "FitsFile",     "fFitsFileName",     "fFitsFileKEY", "Fits File");
         printf("  </td><td>\n");
         PrintPullDown($host, $user, $pw, $db, "Status",  "fStatusName",  "fStatusKEY", "Status Code");
@@ -259,4 +269,26 @@
     ini_set("mysql.trace_mode", "On");
 
+    $sitepw="\$1\$jfBkkHx1\$WmxNVaOWPCBC8asfKDfBZ/";
+    $siteuser="optical";
+
+    if (!isset($_SERVER['PHP_AUTH_USER']) || $_SERVER['PHP_AUTH_USER']!=$siteuser)
+    {
+        header('WWW-Authenticate: Basic realm="Optical Data - Tuorla Observatory"');
+        header('HTTP/1.0 401 Unauthorized');
+        echo 'Action cancelled.';
+        return;
+    }
+    else
+    {
+//    echo "<p>Hello {$_SERVER['PHP_AUTH_USER']}.</p>";
+//    echo "<p>You entered {$_SERVER['PHP_AUTH_PW']} as your password.</p>";
+//    printf("pw: %s", crypt($_SERVER['PHP_AUTH_PW']));
+        if (crypt($_SERVER['PHP_AUTH_PW'], $sitepw)!=$sitepw || $_SERVER['PHP_AUTH_USER']!=$siteuser)
+        {
+            printf("<br>pw or user incorrect<br>");
+            return;
+        }
+    }
+
     if (!empty($_GET["fSendTxt"]))
     {