Changeset 19502 for trunk/www

Timestamp:

05/05/19 22:32:57 (5 years ago)

Author:

Daniela Dorner

Message:

fixed overwriting of table

File:

• trunk/www/dch/db_explorer.php (modified) (6 diffs)

trunk/www/dch/db_explorer.php

@@ -89 +89 @@
     // ETh: 764 GeV
     $crabflux="3.3";
+    break;
 case "CutsLC":
     $zdfactor="pow(cos(fZenithDistanceMean*PI()/180)*exp(1-cos(fZenithDistanceMean*PI()/180)),4.5)";
@@ -94 +95 @@
     // ETh: 543 GeV
     $crabflux="5.7";
+    break;
 default:
     $zdfactor="0";
@@ -405 +407 @@
     $selecterr="EXCERR(SUM(fNumSigEvts), SUM(fNumBgEvts))/SUM(TIME_TO_SEC(TIMEDIFF(fRunStop,fRunStart))*fEffectiveOn)*3600*SUM(fNumExcEvts/".$zdfactor."/".$thfactor.")/SUM(fNumExcEvts)";
     $isnull="AND NOT ISNULL(fNumExcEvts) AND NOT ISNULL(fEffectiveOn) AND NOT ISNULL(fZenithDistanceMean) AND NOT (ISNULL(fThresholdMinSet) AND ISNULL(fThresholdMedian)) ";
-    $sqlhaving=" AND e < 1000 ";
+    $sqlhaving=" AND abs(e) < 1000 ";
     $titley="Corrected excess rate";
     $unity="[1/h]";
@@ -414 +416 @@
     $selecterr="EXCERR(SUM(fNumSigEvts), SUM(fNumBgEvts))/SUM(TIME_TO_SEC(TIMEDIFF(fRunStop,fRunStart))*fEffectiveOn)*3600*SUM(fNumExcEvts/".$zdfactor."/".$thfactor."/fCU)/SUM(fNumExcEvts)";
     $isnull="AND NOT ISNULL(fNumExcEvts) AND NOT ISNULL(fEffectiveOn) AND NOT ISNULL(fZenithDistanceMean) AND NOT (ISNULL(fThresholdMinSet) AND ISNULL(fThresholdMedian)) ";
-    $sqlhaving=" AND e < 1000 ";
+    $sqlhaving=" AND abs(e) < 1000 ";
     $titley="Flux";
     $unity="[CU]";
@@ -423 +425 @@
     $selecterr=$crabflux." * EXCERR(SUM(fNumSigEvts), SUM(fNumBgEvts))/SUM(TIME_TO_SEC(TIMEDIFF(fRunStop,fRunStart))*fEffectiveOn)*3600*SUM(fNumExcEvts/".$zdfactor."/".$thfactor."/fCU)/SUM(fNumExcEvts)";
     $isnull="AND NOT ISNULL(fNumExcEvts) AND NOT ISNULL(fEffectiveOn) AND NOT ISNULL(fZenithDistanceMean) AND NOT (ISNULL(fThresholdMinSet) AND ISNULL(fThresholdMedian)) ";
-    $sqlhaving=" AND e < 1000 ";
+    $sqlhaving=" AND abs(e) < 1000 ";
     $titley="Flux";
     $unity="[10^-11/cm2/s]";
@@ -768 +770 @@
 
 $hiddenInput ="";
-if (isset($_GET["t"]))
-  $hiddenInput .= "<input type='hidden' name='t' value='".$_GET["t"]."'>\n";
+//if (isset($_GET["t"]))
+//  $hiddenInput .= "<input type='hidden' name='t' value='".$_GET["t"]."'>\n";
 if (isset($_GET["db"]))
   $hiddenInput .= "<input type='hidden' name='db' value='".$_GET["db"]."'>\n";