Changeset 7546 for trunk/MagicSoft/Mars/datacenter/db/index.php

Timestamp:

02/28/06 20:23:38 (19 years ago)

Author:

Daniela Dorner

Message:

*** empty log message ***

File:

• trunk/MagicSoft/Mars/datacenter/db/index.php (modified) (6 diffs)

trunk/MagicSoft/Mars/datacenter/db/index.php

@@ -226 +226 @@
     }
 
-    function PrintForm($_GET, $db)
+    function PrintForm($_GET, $host, $user, $pw, $db)
     {
         printf("<center>\n");
@@ -260 +260 @@
         printf(" <table>\n");
         printf("  <tr><td>\n");
-        PrintPullDown($db, "RunType",     "fRunTypeName",     "fRunTypeKEY", "Run type");
-        printf("  </td><td>\n");
-        PrintPullDown($db, "Source",      "fSourceName",      "fSourceKEY", "Source Name");
-        printf("  </td><td>\n");
-        PrintPullDown($db, "HvSettings",  "fHvSettingsName",  "fHvSettingsKEY", "HV Settings");
-        printf("  </td><td>\n");
-        PrintPullDown($db, "L1TriggerTable", "fL1TriggerTableName", "fL1TriggerTableKEY", "L1 Trigger Table");
+        PrintPullDown($host, $user, $pw, $db, "RunType",     "fRunTypeName",     "fRunTypeKEY", "Run type");
+        printf("  </td><td>\n");
+        PrintPullDown($host, $user, $pw, $db, "Source",      "fSourceName",      "fSourceKEY", "Source Name");
+        printf("  </td><td>\n");
+        PrintPullDown($host, $user, $pw, $db, "HvSettings",  "fHvSettingsName",  "fHvSettingsKEY", "HV Settings");
+        printf("  </td><td>\n");
+        PrintPullDown($host, $user, $pw, $db, "L1TriggerTable", "fL1TriggerTableName", "fL1TriggerTableKEY", "L1 Trigger Table");
         printf("  </td></tr><tr><td>\n");
-        PrintPullDown($db, "TestFlag",  "fTestFlagName",  "fTestFlagKEY", "Test Flag");
-        printf("  </td><td>\n");
-        PrintPullDown($db, "Project",     "fProjectName",     "fProjectKEY", "Project Name");
-        printf("  </td><td>\n");
-        PrintPullDown($db, "DiscriminatorThresholdTable",  "fDiscriminatorThresholdTableName",  "fDiscriminatorThresholdTableKEY", "DT Table");
-        printf("  </td><td>\n");
-        PrintPullDown($db, "L2TriggerTable", "fL2TriggerTableName", "fL2TriggerTableKEY", "L2 Trigger Table");
+        PrintPullDown($host, $user, $pw, $db, "TestFlag",  "fTestFlagName",  "fTestFlagKEY", "Test Flag");
+        printf("  </td><td>\n");
+        PrintPullDown($host, $user, $pw, $db, "Project",     "fProjectName",     "fProjectKEY", "Project Name");
+        printf("  </td><td>\n");
+        PrintPullDown($host, $user, $pw, $db, "DiscriminatorThresholdTable",  "fDiscriminatorThresholdTableName",  "fDiscriminatorThresholdTableKEY", "DT Table");
+        printf("  </td><td>\n");
+        PrintPullDown($host, $user, $pw, $db, "L2TriggerTable", "fL2TriggerTableName", "fL2TriggerTableKEY", "L2 Trigger Table");
         printf("  </td></tr><tr><td>\n");
-        PrintPullDown($db, "ExcludedFDA", "fExcludedFDAName", "fExcludedFDAKEY", "Exclusions");
-        printf("  </td><td>\n");
-        PrintPullDown($db, "LightConditions",  "fLightConditionsName",  "fLightConditionsKEY", "Light Conditions");
-        printf("  </td><td>\n");
-        PrintPullDown($db, "CalibrationScript",  "fCalibrationScriptName",  "fCalibrationScriptKEY", "Cal Script");
-        printf("  </td><td>\n");
-        PrintPullDown($db, "TriggerDelayTable",  "fTriggerDelayTableName",  "fTriggerDelayTableKEY", "Trigger Delay Table");
+        PrintPullDown($host, $user, $pw, $db, "ExcludedFDA", "fExcludedFDAName", "fExcludedFDAKEY", "Exclusions");
+        printf("  </td><td>\n");
+        PrintPullDown($host, $user, $pw, $db, "LightConditions",  "fLightConditionsName",  "fLightConditionsKEY", "Light Conditions");
+        printf("  </td><td>\n");
+        PrintPullDown($host, $user, $pw, $db, "CalibrationScript",  "fCalibrationScriptName",  "fCalibrationScriptKEY", "Cal Script");
+        printf("  </td><td>\n");
+        PrintPullDown($host, $user, $pw, $db, "TriggerDelayTable",  "fTriggerDelayTableName",  "fTriggerDelayTableKEY", "Trigger Delay Table");
         printf("  </td></tr><tr><td>\n");
-        PrintPullDown($db, "MagicNumber", "fMagicNumberName", "fMagicNumberKEY", "Magic Number");
+        PrintPullDown($host, $user, $pw, $db, "MagicNumber", "fMagicNumberName", "fMagicNumberKEY", "Magic Number");
         printf(" </td></tr></table>\n");
         printf(" <p>\n");
 
         if (empty($_GET["fStartDate"]))
-            $timemin = GetMin("fRunStart", "RunData", $db);
+            $timemin = GetMin("fRunStart", "RunData", $host, $user, $pw, $db);
         else
             $timemin = $_GET["fStartDate"];
 
         if (empty($_GET["fStopDate"]))
-            $timemax = GetMax("fRunStart", "RunData", $db);
+            $timemax = GetMax("fRunStart", "RunData", $host, $user, $pw, $db);
         else
             $timemax = $_GET["fStopDate"];
@@ -309 +309 @@
 
         if (empty($_GET["fRunMin"]))
-            $min = GetMin("fRunNumber", "RunData", $db);
+            $min = GetMin("fRunNumber", "RunData", $host, $user, $pw, $db);
         else
             $min = $_GET["fRunMin"];
 
         if (empty($_GET["fRunMax"]))
-            $max = GetMax("fRunNumber", "RunData", $db);
+            $max = GetMax("fRunNumber", "RunData", $host, $user, $pw, $db);
         else
             $max = $_GET["fRunMax"];
@@ -357 +357 @@
     }
 
-    function PrintPage($html, $db, $alias, $rightalign, $checkwhere, $checkgroup, $checkstatusgroup)
-    {
-        $db_id = mysql_connect("hercules.astro.uni-wuerzburg.de", "MAGIC", "d99swMT!");
+    function PrintPage($html, $host, $user, $pw, $db, $alias, $rightalign, $checkwhere, $checkgroup, $checkstatusgroup)
+    {
+        $db_id = mysql_connect($host, $user, $pw);
         if ($db_id==FALSE)
         {
@@ -400 +400 @@
         header("Content-Disposition: attachment; filename=query-result.txt");
 
-        PrintPage("0", $db, $alias, $rightalign, $checkwhere, $checkgroup, $checkstatusgroup);
+        PrintPage("0", $host, $user, $pw, $db, $alias, $rightalign, $checkwhere, $checkgroup, $checkstatusgroup);
     }
     else
@@ -409 +409 @@
 
         InitGet($_GET);
-        PrintForm($_GET, $db);
+        PrintForm($_GET, $host, $user, $pw, $db);
 
         if ($environment==0)
             printf("No query submitted yet.<BR>");
         else
-            PrintPage("1", $db, $alias, $rightalign, $checkwhere, $checkgroup, $checkstatusgroup);
+            PrintPage("1", $host, $user, $pw, $db, $alias, $rightalign, $checkwhere, $checkgroup, $checkstatusgroup);
 
         echo (file_get_contents("index-footer.html"));