Changeset 9106 for trunk/MagicSoft/Mars/datacenter/db/resetseq.php

Timestamp:

08/06/08 16:52:46 (16 years ago)

Author:

Daniela Dorner

Message:

*** empty log message ***

File:

• trunk/MagicSoft/Mars/datacenter/db/resetseq.php (modified) (2 diffs)

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

@@ -45 +45 @@
             $query0 .= " 'crashed or failed')))) as 'starstat', fProjectName, fRunStart ";
             $query0 .= "FROM SequenceProcessStatus ";
-            $query0 .= "LEFT JOIN Sequences       ON Sequences.fSequenceFirst=SequenceProcessStatus.fSequenceFirst ";
-            $query0 .= "LEFT JOIN Project         ON Project.fProjectKEY=Sequences.fProjectKEY ";
+            $query0 .= "LEFT JOIN Sequences USING(fSequenceFirst,fTelescopeNumber) ";
+            $query0 .= "LEFT JOIN Project USING(fProjectKEY) ";
         }
         else
@@ -221 +221 @@
     echo (file_get_contents("index-header.html"));
 
-    $ips=array("91.64.78.187", "132.187.47.10", "132.187.47.67", "132.187.47.63", "129.217.160.151");
+    $ips=array("132.187.47.10", //Thomas
+               "129.194.169.21" //Dani ISDC
+              );
     if (!in_array($_SERVER['REMOTE_ADDR'], $ips))
     {