Index: /trunk/MagicSoft/Mars/Changelog
===================================================================
--- /trunk/MagicSoft/Mars/Changelog	(revision 7041)
+++ /trunk/MagicSoft/Mars/Changelog	(revision 7042)
@@ -25,4 +25,7 @@
    * datacenter/macros/setupdb.C
      - adapted to new column in datasetstatus-table
+
+   * datacenter/macros/checkstardone.C
+     - added (macro to check if star has been done for a sequence)
 
    * steps.rc
Index: /trunk/MagicSoft/Mars/datacenter/macros/checkstardone.C
===================================================================
--- /trunk/MagicSoft/Mars/datacenter/macros/checkstardone.C	(revision 7042)
+++ /trunk/MagicSoft/Mars/datacenter/macros/checkstardone.C	(revision 7042)
@@ -0,0 +1,91 @@
+/* ======================================================================== *\
+!
+! *
+! * This file is part of MARS, the MAGIC Analysis and Reconstruction
+! * Software. It is distributed to you in the hope that it can be a useful
+! * and timesaving tool in analysing Data of imaging Cerenkov telescopes.
+! * It is distributed WITHOUT ANY WARRANTY.
+! *
+! * Permission to use, copy, modify and distribute this software and its
+! * documentation for any purpose is hereby granted without fee,
+! * provided that the above copyright notice appear in all copies and
+! * that both that copyright notice and this permission notice appear
+! * in supporting documentation. It is provided "as is" without express
+! * or implied warranty.
+! *
+!
+!
+!   Author(s): Daniela Dorner, 05/2005 <mailto:dorner@astro.uni-wuerzburg.de>
+!
+!   Copyright: MAGIC Software Development, 2000-2005
+!
+!
+\* ======================================================================== */
+
+/////////////////////////////////////////////////////////////////////////////
+//
+// checkstardone.C
+// ===============
+//
+/////////////////////////////////////////////////////////////////////////////
+
+#include <iostream>
+#include <iomanip>
+#include <fstream>
+
+#include <TEnv.h>
+
+#include <MSQLServer.h>
+#include <TSQLRow.h>
+#include <TSQLResult.h>
+
+using namespace std;
+
+
+TString GetStatus(MSQLServer &serv, TEnv &rc, TString primary, TString table, TString column)
+{
+    TString query(Form("SELECT %s FROM MyMagic.%s WHERE %s=%s",
+                       column.Data(), table.Data(),
+                       rc.GetValue(table+".Primary", ""),
+                       primary.Data()));
+
+    cout << "Query: " << query << endl;
+
+    TSQLResult *res = serv.Query(query);
+    if (!res)
+    {
+        cout << "Error - no run to check" << endl;
+        return "";
+    }
+
+    TSQLRow *row=0;
+    while ((row = res->Next()))
+        return (*row)[0];
+
+    return "";
+}
+
+int checkstardone(TString datasetno)
+{
+    TEnv env("sql.rc");
+
+    MSQLServer serv(env);
+    if (!serv.IsConnected())
+    {
+        cout << "ERROR - Connection to database failed." << endl;
+        return 0;
+    }
+    cout << "checkstardone" << endl;
+    cout << "-------------" << endl;
+    cout << endl;
+    cout << "Connected to " << serv.GetName() << endl;
+    cout << endl;
+
+    TEnv rc("steps.rc");
+
+    if (GetStatus(serv, rc, datasetno, "SequenceProcessStatus", "fStar")=="")
+        return 0;
+
+    return 1;
+}
+
Index: /trunk/MagicSoft/Mars/datacenter/macros/setupdb.C
===================================================================
--- /trunk/MagicSoft/Mars/datacenter/macros/setupdb.C	(revision 7041)
+++ /trunk/MagicSoft/Mars/datacenter/macros/setupdb.C	(revision 7042)
@@ -545,5 +545,5 @@
          "  fDataSetNumber    INT       UNSIGNED   PRIMARY KEY, "
          "  fDataSetInserted  DATETIME             NULL,"
-         "  fFilesAvail       DATETIME             NULL,"
+         "  fStarFilesAvail   DATETIME             NULL,"
          "  fGanymed          DATETIME             NULL"
          ")";
@@ -575,5 +575,5 @@
          "  fSequenceFirst         INT       UNSIGNED   PRIMARY KEY, "
          "  fSequenceFileWritten   DATETIME             NULL,"
-         "  fFilesAvail            DATETIME             NULL,"
+         "  fAllFilesAvail         DATETIME             NULL,"
          "  fCallisto              DATETIME             NULL,"
          "  fFillCallisto          DATETIME             NULL,"
Index: /trunk/MagicSoft/Mars/steps.rc
===================================================================
--- /trunk/MagicSoft/Mars/steps.rc	(revision 7041)
+++ /trunk/MagicSoft/Mars/steps.rc	(revision 7042)
@@ -172,5 +172,5 @@
 DataSetProcessStatus.fDataSetNumber.Default: yes
 #DataSetProcessStatus.fDataSetNumber.Needs: -
-DataSetProcessStatus.fDataSetNumber.Influences: DataSetProcessStatus.fFilesAvail DataSetProcessStatus.fGanymed 
+DataSetProcessStatus.fDataSetNumber.Influences: DataSetProcessStatus.fStarFilesAvail DataSetProcessStatus.fGanymed 
 DataSetProcessStatus.fDataSetNumber.Reset: yes
 
@@ -179,18 +179,18 @@
 DataSetProcessStatus.fDataSetInserted.Default: no
 DataSetProcessStatus.fDataSetInserted.Needs: DataSetProcessStatus.fDataSetNumber
-DataSetProcessStatus.fDataSetInserted.Influences: DataSetProcessStatus.fFilesAvail DataSetProcessStatus.fGanymed 
+DataSetProcessStatus.fDataSetInserted.Influences: DataSetProcessStatus.fStarFilesAvail DataSetProcessStatus.fGanymed 
 DataSetProcessStatus.fDataSetInserted.Reset: yes
 
 
-#DataSetProcessStatus.fFilesAvail.: 
-DataSetProcessStatus.fFilesAvail.Default: no
-DataSetProcessStatus.fFilesAvail.Needs: DataSetProcessStatus.fDataSetInserted 
-DataSetProcessStatus.fFilesAvail.Influences: DataSetProcessStatus.fGanymed 
-DataSetProcessStatus.fFilesAvail.Reset: yes
+#DataSetProcessStatus.fStarFilesAvail.: 
+DataSetProcessStatus.fStarFilesAvail.Default: no
+DataSetProcessStatus.fStarFilesAvail.Needs: DataSetProcessStatus.fDataSetInserted 
+DataSetProcessStatus.fStarFilesAvail.Influences: DataSetProcessStatus.fGanymed 
+DataSetProcessStatus.fStarFilesAvail.Reset: yes
 
 
 #DataSetProcessStatus.fGanymed.: 
 DataSetProcessStatus.fGanymed.Default: no
-DataSetProcessStatus.fGanymed.Needs: DataSetProcessStatus.fDataSetInserted DataSetProcessStatus.fFilesAvail 
+DataSetProcessStatus.fGanymed.Needs: DataSetProcessStatus.fDataSetInserted DataSetProcessStatus.fStarFilesAvail 
 #DataSetProcessStatus.fGanymed.Influences: 
 DataSetProcessStatus.fGanymed.Reset: yes