Index: trunk/MagicSoft/Mars/Changelog
===================================================================
--- trunk/MagicSoft/Mars/Changelog	(revision 8796)
+++ trunk/MagicSoft/Mars/Changelog	(revision 8797)
@@ -18,4 +18,12 @@
 
                                                  -*-*- END OF LINE -*-*-
+
+ 2007/12/21 Daniela Dorner
+
+   * datacenter/db/sequinfo-aio.php, datacenter/db/menu.php, 
+     datacenter/db/runinfo-aio.php: 
+     - implemented link to runbook of the according night
+
+
 
  2007/12/20 Thomas Bretz
Index: trunk/MagicSoft/Mars/datacenter/db/menu.php
===================================================================
--- trunk/MagicSoft/Mars/datacenter/db/menu.php	(revision 8796)
+++ trunk/MagicSoft/Mars/datacenter/db/menu.php	(revision 8797)
@@ -25,5 +25,9 @@
     CheckBox("fMeanTriggerRate",  "Mean Trigger rate");
     CheckBox("fSequenceFirst",    "Sequence Number");
+
+    printf("  </tr><tr>\n");
+
     CheckBox("fTest",             "incl. TestSources");
+    CheckBox("fLinks",            "Links");
 
     printf("  </tr>\n");
@@ -282,5 +286,5 @@
     CheckBox("fUnsuitable50",        "Unsuitable (50%)");
     CheckBox("fUnsuitable01",        "Unsuitable (1%)");
-    CheckBox("fUnsuitableMax",       "Unsuitable (99.9%)");
+    CheckBox("fUnsuitableMax",       "UnsuitableMax");
     CheckBox("fDeadMax",             "DeadMax");
 
@@ -680,4 +684,7 @@
     InitFailInfo($_GET, $first);
 
+    if (empty($_GET["fLinks"]))
+        $_GET["fLinks"]=$first?"On":"";
+
     if (empty($_GET["fFormatVersion"]))
         $_GET["fFormatVersion"]="Off";
Index: trunk/MagicSoft/Mars/datacenter/db/runinfo-aio.php
===================================================================
--- trunk/MagicSoft/Mars/datacenter/db/runinfo-aio.php	(revision 8796)
+++ trunk/MagicSoft/Mars/datacenter/db/runinfo-aio.php	(revision 8797)
@@ -50,6 +50,12 @@
                 $query0 .= " RunData.fRunNumber as 'Run#' ";
 
+                if (empty($_GET["fSendTxt"]) && !empty($_GET["fLinks"]))
+                {
+                    $query0 .= ", CONCAT('<A&ws;HREF=\"queryrbk.php?fNight=', date_format(adddate(fRunStart, interval +13 HOUR), '%Y-%m-%d') , '&amp;fDate=2\">rbk</A>') ";
+                    $query0 .= " as 'Links'";
+                }
+
                 foreach ($_GET as $key => $element)
-                    if ($_GET[$key]=="On" && $key!="fTest")
+                    if ($key!="fLinks" && $_GET[$key]=="On" && $key!="fTest")
                         if (empty($checkwhere[$key]) || $checkwhere[$key]==0)
                             $query0 .= ", " . $key . " as '" . $alias[$key] . "' ";
@@ -177,4 +183,6 @@
                 $query0 .= "DESC";
         }
+        else
+            $query0 .=" ORDER BY RunData.fRunNumber DESC";
 
         if (empty($_GET["fNumStart"]))
Index: trunk/MagicSoft/Mars/datacenter/db/sequinfo-aio.php
===================================================================
--- trunk/MagicSoft/Mars/datacenter/db/sequinfo-aio.php	(revision 8796)
+++ trunk/MagicSoft/Mars/datacenter/db/sequinfo-aio.php	(revision 8797)
@@ -60,5 +60,6 @@
                         $query0 .= ", '&nbsp;<A&ws;HREF=\"http://www.astro.uni-wuerzburg.de/datacenter/star/' , LEFT(LPAD(CONCAT(Sequences.fSequenceFirst, '.'), 9,'0'),4), '/', LPAD(CONCAT(Sequences.fSequenceFirst, '/'), 9,'0'), '\">s</A>'";
                         $query0 .= ", '&nbsp;<A&ws;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') , '\">', 'f </A>' ";
-                        $query0 .= ", '&nbsp;<A&ws;HREF=\"sequence.php?fSequenceNo=', Sequences.fSequenceFirst , '&amp;fAll=On\">i</A>') ";
+                        $query0 .= ", '&nbsp;<A&ws;HREF=\"sequence.php?fSequenceNo=', Sequences.fSequenceFirst , '&amp;fAll=On\">i</A>'";
+                        $query0 .= ", '&nbsp;<A&ws;HREF=\"queryrbk.php?fNight=', date_format(adddate(fRunStart, interval +13 HOUR), '%Y-%m-%d') , '&amp;fDate=2\">rbk</A>') ";
                         $query0 .= " as 'Links'";
                     }
