Changeset 7621 for trunk/MagicSoft/Mars/datacenter/db

Timestamp:

03/21/06 04:53:46 (19 years ago)

Author:

Daniela Dorner

Message:

*** empty log message ***

File:

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

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

@@ -31 +31 @@
         $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 .= " fMaxHumidity, fMeanNumberIslands, fInhomogeneity, fEffOnTime/fRunTime, ";//49,50,51,52
+        $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', ";//53
+        $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', ";//54
+        $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' ";//55
 
         $query0 .= " FROM Sequences ";
@@ -279 +279 @@
             $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);
+            $relontime=mysql_result($result0, $i, 52);
+            $callink=mysql_result($result0, $i, 53);
+            $starlink=mysql_result($result0, $i, 54);
+            $sequlink=mysql_result($result0, $i, 55);
 
             printf("<tr><td>");
@@ -456 +457 @@
                     printf(" <table BORDER=\"1\">");
                     printf(" <tr BGCOLOR='#C0C0C0'>");
-                    printf(" <th colspan=\"8\">star</th>\n");
+                    printf(" <th colspan=\"9\">star</th>\n");
                     printf(" </tr><tr BGCOLOR='#D0D0D0' ALIGN='center'>");
                     printf(" <td># islands</td>\n");
@@ -466 +467 @@
                     printf(" <td>psf</td>\n");
                     printf(" <td>inhom</td>\n");
+                    printf(" <td>rel. ontime</td>\n");
                     printf(" <tr BGCOLOR='#E0E0E0' ALIGN='right'>");
                     printf(" <td> %s </td>\n", $meannumislands);
@@ -475 +477 @@
                     printf(" <td> %smm </td>\n", $psf);
                     printf(" <td> %s </td>\n", $inhom);
+                    printf(" <td> %s </td>\n", $relontime);
                     printf(" </tr>");
                     printf(" </table>");