Changeset 7507 for trunk/MagicSoft/Mars/datacenter/db/sequence.php

Timestamp:

02/15/06 13:13:22 (19 years ago)

Author:

hoehne

Message:

*** empty log message ***

File:

• trunk/MagicSoft/Mars/datacenter/db/sequence.php (modified) (7 diffs)

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

@@ -18 +18 @@
         $query0 .= " fCallisto, fFillCallisto, ";//21,22
         $query0 .= " fStar, fFillStar, ";//23,24
-        //calibration (25-39)
+        //calibration (25-42)
         $query0 .= " fUnsuitableInner, fUnsuitableOuter, ";//25,26
         $query0 .= " fUnreliableInner, fUnreliableOuter, ";//27,28
@@ -26 +26 @@
         $query0 .= " fConvFactorInner, fConvFactorOuter, ";//36,37
         $query0 .= " fMeanPedRmsInner, fMeanPedRmsOuter, ";//38,39
-        //myon,star (40-47)
-        $query0 .= " fPSF, fRatio, fMuonRate, ";//40,41,42
-        $query0 .= " fMuonNumber, fEffOnTime, fDataRate, ";//43,44,45
-        $query0 .= " fMaxHumidity, fMeanNumberIslands, ";//46,47
-        $query0 .= " CONCAT('<a href=\"http://www.astro.uni-wuerzburg.de/datacenter/callisto/' , LEFT(LPAD(CONCAT(Sequences.fSequenceFirst, '.'), 9,'0'),4), '/', LPAD(CONCAT(Sequences.fSequenceFirst, '/'), 9,'0'), 'callisto', LPAD(CONCAT(Sequences.fSequenceFirst , '.html'), 13,'0') , '\">cal-log</A>') as 'CalLink', ";//48
-        $query0 .= " CONCAT('<a href=\"http://www.astro.uni-wuerzburg.de/datacenter/star/' , LEFT(LPAD(CONCAT(Sequences.fSequenceFirst, '.'), 9,'0'),4), '/', LPAD(CONCAT(Sequences.fSequenceFirst, '/'), 9,'0'), 'star', LPAD(CONCAT(Sequences.fSequenceFirst , '.html'), 13,'0') , '\">star-log</A>') as 'StarLink', ";//49
-        $query0 .= " CONCAT('<a href=\"http://www.astro.uni-wuerzburg.de/datacenter/sequences/' , LEFT(LPAD(CONCAT(Sequences.fSequenceFirst, '.'), 9,'0'),4), '/sequence', LPAD(CONCAT(Sequences.fSequenceFirst , '.txt'), 12,'0') , '\">', 'sequ-file</a>') as 'SequLink' ";//50
+        $query0 .= " fMeanSignalInner, fMeanSignalOuter, ";//40,41
+        $query0 .= " fPulsePosMean, ";//42
+        //myon,star (43-51)
+        $query0 .= " fPSF, fRatio, fMuonRate, ";//43,44,45
+        $query0 .= " fMuonNumber, fEffOnTime, fDataRate, ";//46,47,48
+        $query0 .= " fMaxHumidity, fMeanNumberIslands, fInhomogeneity, ";//49,50,51
+        $query0 .= " CONCAT('<a href=\"http://www.astro.uni-wuerzburg.de/datacenter/callisto/' , LEFT(LPAD(CONCAT(Sequences.fSequenceFirst, '.'), 9,'0'),4), '/', LPAD(CONCAT(Sequences.fSequenceFirst, '/'), 9,'0'), 'callisto', LPAD(CONCAT(Sequences.fSequenceFirst , '.html'), 13,'0') , '\">cal-log</A>') as 'CalLink', ";//52
+        $query0 .= " CONCAT('<a href=\"http://www.astro.uni-wuerzburg.de/datacenter/star/' , LEFT(LPAD(CONCAT(Sequences.fSequenceFirst, '.'), 9,'0'),4), '/', LPAD(CONCAT(Sequences.fSequenceFirst, '/'), 9,'0'), 'star', LPAD(CONCAT(Sequences.fSequenceFirst , '.html'), 13,'0') , '\">star-log</A>') as 'StarLink', ";//53
+        $query0 .= " CONCAT('<a href=\"http://www.astro.uni-wuerzburg.de/datacenter/sequences/' , LEFT(LPAD(CONCAT(Sequences.fSequenceFirst, '.'), 9,'0'),4), '/sequence', LPAD(CONCAT(Sequences.fSequenceFirst , '.txt'), 12,'0') , '\">', 'sequ-file</a>') as 'SequLink' ";//54
 
         $query0 .= " FROM Sequences ";
@@ -248 +250 @@
             $meanpedrmsi=mysql_result($result0, $i, 38);
             $meanpedrmso=mysql_result($result0, $i, 39);
-            $psf=mysql_result($result0, $i, 40);
-            $ratio=mysql_result($result0, $i, 41);
-            $muonrate=mysql_result($result0, $i, 42);
-            $muonnum=mysql_result($result0, $i, 43);
-            $effontime=mysql_result($result0, $i, 44);
-            $datarate=mysql_result($result0, $i, 45);
-            $maxhum=mysql_result($result0, $i, 46);
-            $meannumislands=mysql_result($result0, $i, 47);
-            $callink=mysql_result($result0, $i, 48);
-            $starlink=mysql_result($result0, $i, 49);
-            $sequlink=mysql_result($result0, $i, 50);
+            $meansignali=mysql_result($result0, $i, 40);
+            $meansignalo=mysql_result($result0, $i, 41);
+            $pulsposmean=mysql_result($result0, $i, 42);
+            $psf=mysql_result($result0, $i, 43);
+            $ratio=mysql_result($result0, $i, 44);
+            $muonrate=mysql_result($result0, $i, 45);
+            $muonnum=mysql_result($result0, $i, 46);
+            $effontime=mysql_result($result0, $i, 47);
+            $datarate=mysql_result($result0, $i, 48);
+            $maxhum=mysql_result($result0, $i, 49);
+            $meannumislands=mysql_result($result0, $i, 50);
+            $inhom=mysql_result($result0, $i, 51);
+            $callink=mysql_result($result0, $i, 52);
+            $starlink=mysql_result($result0, $i, 53);
+            $sequlink=mysql_result($result0, $i, 54);
 
             printf("<tr><td>");
@@ -416 +422 @@
                     printf(" <td align='right'> %s </td>\n", $meanpedrmsi);
                     printf(" <td align='right'> %s </td>\n", $meanpedrmso);
+                    printf(" </tr><tr BGCOLOR='#D0D0D0'>");
+                    printf(" <td>mean signal</td>\n");
+                    printf(" <td align='right'> %s </td>\n", $meansignali);
+                    printf(" <td align='right'> %s </td>\n", $meansignalo);
+                    printf(" </tr><tr BGCOLOR='#E0E0E0'>");
+                    printf(" <td>mean pulse pos</td>\n");
+                    printf(" <td colspan=\"2\" align='right'> %s </td>\n", $pulsposmean);
                     printf(" </tr>");
                     printf(" </table>");
@@ -426 +439 @@
                     printf(" <table BORDER=\"1\">");
                     printf(" <tr BGCOLOR='#C0C0C0'>");
-                    printf(" <th colspan=\"7\">star</th>\n");
+                    printf(" <th colspan=\"8\">star</th>\n");
                     printf(" </tr><tr BGCOLOR='#D0D0D0' ALIGN='center'>");
                     printf(" <td># islands</td>\n");
@@ -435 +448 @@
                     printf(" <td>ratio</td>\n");
                     printf(" <td>psf</td>\n");
+                    printf(" <td>inhom</td>\n");
                     printf(" <tr BGCOLOR='#E0E0E0' ALIGN='right'>");
                     printf(" <td> %s </td>\n", $meannumislands);
@@ -443 +457 @@
                     printf(" <td> %s </td>\n", $ratio);
                     printf(" <td> %smm </td>\n", $psf);
+                    printf(" <td> %s </td>\n", $inhom);
                     printf(" </tr>");
                     printf(" </table>");