$element) if ($_GET[$key]=="On") if (empty($checkwhere[$key]) || $checkwhere[$key]==0) $query0 .= ", " . $key . " as '" . $alias[$key] . "' "; $query0 .= " FROM Calibration "; if (strpos($query0, " WHERE ")==FALSE) $query0 .= " WHERE "; else $query0 .= " AND "; $query0 .= "fSequenceFirst BETWEEN " . $_GET["fRunMin"] . " AND " . $_GET["fRunMax"] . " "; if (!empty($_GET["fSortBy"])) { $query0 .= " ORDER BY " . substr($_GET["fSortBy"], 0, -1) . " "; if (substr($_GET["fSortBy"], -1)=="-") $query0 .= "DESC"; } if (empty($_GET["fNumStart"])) $_GET["fNumStart"]=0; if (empty($_GET["fSendTxt"])) $query0 .= " LIMIT " . $_GET["fNumStart"] . ", " . $_GET["fNumResults"]; return $query0; } function InitGet($_GET) { // Find out whether it is the first call to the php script $first = empty($_GET["fRunMin"]) && empty($_GET["fRunMax"]); if (empty($_GET["fNumResults"])) $_GET["fNumResults"]="20"; if (empty($_GET["fLastUpdate"])) $_GET["fLastUpdate"]="Off"; if (empty($_GET["fUnreliableInner"])) $_GET["fUnreliableInner"]=$first?"On":""; if (empty($_GET["fUnsuitableOuter"])) $_GET["fUnsuitableOuter"]=$first?"On":""; if (empty($_GET["fUnreliableOuter"])) $_GET["fUnreliableOuter"]=$first?"On":""; if (empty($_GET["fUnsuitableInner"])) $_GET["fUnsuitableInner"]=$first?"On":""; if (empty($_GET["fIsolatedInner"])) $_GET["fIsolatedInner"]=$first?"On":""; if (empty($_GET["fIsolatedOuter"])) $_GET["fIsolatedOuter"]=$first?"On":""; if (empty($_GET["fMeanPedRmsInner"])) $_GET["fMeanPedRmsInner"]=$first?"On":""; if (empty($_GET["fMeanPedRmsOuter"])) $_GET["fMeanPedRmsOuter"]=$first?"On":""; if (empty($_GET["fIsolatedMaxCluster"])) $_GET["fIsolatedMaxCluster"]=$first?"On":""; if (empty($_GET["fArrTimeMeanInner"])) $_GET["fArrTimeMeanInner"]=$first?"On":""; if (empty($_GET["fArrTimeMeanOuter"])) $_GET["fArrTimeMeanOuter"]=$first?"On":""; if (empty($_GET["fArrTimeRmsInner"])) $_GET["fArrTimeRmsInner"]=$first?"On":""; if (empty($_GET["fArrTimeRmsOuter"])) $_GET["fArrTimeRmsOuter"]=$first?"On":""; if (empty($_GET["fMeanSignalInner"])) $_GET["fMeanSignalInner"]=$first?"Off":""; if (empty($_GET["fMeanSignalOuter"])) $_GET["fMeanSignalOuter"]=$first?"Off":""; if (empty($_GET["fPulsePosMean"])) $_GET["fPulsePosMean"]=$first?"Off":""; if (empty($_GET["fConvFactorInner"])) $_GET["fConvFactorInner"]=$first?"On":""; if (empty($_GET["fConvFactorOuter"])) $_GET["fConvFactorOuter"]=$first?"On":""; } function PrintForm($_GET, $db) { printf("
\n"); printf("
\n"); printf(" \n"); printf(" \n"); CheckBox("fUnsuitableInner", "Unsuitable inner"); CheckBox("fUnsuitableOuter", "Unsuitable outer"); CheckBox("fUnreliableInner", "Unreliable inner"); CheckBox("fUnreliableOuter", "Unreliable outer"); CheckBox("fIsolatedInner", "Isolated inner"); CheckBox("fIsolatedOuter", "Isolated outer"); printf(" \n"); CheckBox("fIsolatedMaxCluster", "IsolatedMaxCluster"); CheckBox("fArrTimeMeanInner", "ArrTimeMean inner "); CheckBox("fArrTimeMeanOuter", "ArrTimeMean outer "); CheckBox("fArrTimeRmsInner", "ArrTimeRms inner "); CheckBox("fArrTimeRmsOuter", "ArrTimeRms outer "); CheckBox("fPulsePosMean", "Mean PulsePos"); printf(" \n"); CheckBox("fConvFactorInner", "Conv inner "); CheckBox("fConvFactorOuter", "Conv outer "); CheckBox("fMeanPedRmsInner", "MeanPedRms inner"); CheckBox("fMeanPedRmsOuter", "MeanPedRms outer"); CheckBox("fMeanSignalInner", "MeanSignal inner"); CheckBox("fMeanSignalOuter", "MeanSignal outer"); printf("
\n"); printf("

\n"); if (empty($_GET["fRunMin"])) $min = GetMin("fSequenceFirst", "Sequences", $db); else $min = $_GET["fRunMin"]; if (empty($_GET["fRunMax"])) $max = GetMax("fSequenceFirst", "Sequences", $db); else $max = $_GET["fRunMax"]; printf("Sequences from \n", $min); printf("to    \n", $max); printf("

\n"); printf(" Results:\n"); printf(" \n"); printf("    \n"); ini_set("mysql.trace_mode", "Off"); ini_set("display_errors", "Off"); printf("   \n"); printf("   \n"); if (strchr($_SERVER["REQUEST_URI"], '?')!=FALSE) printf("   \n", $_SERVER["REQUEST_URI"]); printf("

\n"); printf("
\n"); printf("\n"); printf("\n"); printf("\n"); printf("\n"); } function PrintPage($html, $db, $alias, $rightalign, $checkwhere) { $db_id = mysql_connect("hercules.astro.uni-wuerzburg.de", "MAGIC", "d99swMT!"); if ($db_id==FALSE) { printf("mysql_connect returned the following error: %s\n", mysql_error()); die(""); } mysql_select_db($db); $query0 = CreateQuery($_GET, $alias, $checkwhere); $result0 = mysql_query($query0, $db_id); if ($result0) { if ($html=="1") PrintMagicTable($result0, $alias, $rightalign, "", "", $_GET); else PrintText($result0); mysql_free_result($result0); } mysql_close($db_id); if ($html=="1") printf("submitted query:
%s
", htmlspecialchars($query0)); } include ("include.php"); include ("db.php"); include ("magicdefs.php"); ini_set("display_errors", "On"); ini_set("mysql.trace_mode", "On"); if (!empty($_GET["fSendTxt"])) { header("Content-type: application/octet"); header("Content-Disposition: attachment; filename=query-result.txt"); PrintPage("0", $db, $alias, $rightalign, $checkwhere); } else { echo (file_get_contents("index-header.html")); $environment = sizeof($_GET); InitGet($_GET); PrintForm($_GET, $db); if ($environment==0) printf("No query submitted yet.
"); else PrintPage("1", $db, $alias, $rightalign, $checkwhere); echo (file_get_contents("index-footer.html")); } ini_set("display_errors", "Off"); ini_set("mysql.trace_mode", "Off"); } ?>