Index: /trunk/MagicSoft/Mars/Changelog
===================================================================
--- /trunk/MagicSoft/Mars/Changelog	(revision 7656)
+++ /trunk/MagicSoft/Mars/Changelog	(revision 7657)
@@ -19,4 +19,11 @@
                                                  -*-*- END OF LINE -*-*-
 
+ 2006/04/26 Daniela Dorner
+
+   * datacenter/macros/fillstar.C, datacenter/macros/setupdb.C:
+     - added four new columns to the table Star
+
+
+
  2006/04/24 Thomas Bretz
 
@@ -213,5 +220,5 @@
      - added zd angle range and observation period
 
-   * datacenter/db/sequencE.php:
+   * datacenter/db/sequence.php:
      - added rel. ontime
 
Index: /trunk/MagicSoft/Mars/datacenter/macros/fillstar.C
===================================================================
--- /trunk/MagicSoft/Mars/datacenter/macros/fillstar.C	(revision 7656)
+++ /trunk/MagicSoft/Mars/datacenter/macros/fillstar.C	(revision 7657)
@@ -207,4 +207,29 @@
 
 
+    g = (TGraph*)arr.FindObjectInCanvas("NumStars", "TGraph", "MHPointing");
+    if (!g)
+    {
+        cout << "WARNING - Reading of NumStars failed." << endl;
+        return 2;
+    }
+
+    Double_t numstarmean = g->GetMean(2);
+    TString numstarsmean = Form("%5.1f", numstarmean);
+    Double_t numstarrms = g->GetRMS(2);
+    TString numstarsrms = Form("%5.1f", numstarrms);
+
+    g = (TGraph*)arr.FindObjectInCanvas("Brigtness", "TGraph", "MHPointing");
+    if (!g)
+    {
+        cout << "WARNING - Reading of SkyBrightness failed." << endl;
+        return 2;
+    }
+
+    Double_t brightnessmean = g->GetMean(2);
+    TString skybrightnessmean = Form("%5.1f", brightnessmean);
+    Double_t brightnessrms = g->GetRMS(2);
+    TString skybrightnessrms = Form("%5.1f", brightnessrms);
+
+
     TString sequence = fname(TRegexp("star[0-9]+[.]root$"));
     if (sequence.IsNull())
@@ -227,4 +252,6 @@
     cout << "  Rate after ImgCl [Hz] " << datarate  << endl;
     cout << "  Maximum Humidity [%]  " << maxhum    << endl;
+    cout << "  Number of Stars       " << numstarsmean      << " +/- " << numstarsrms       << endl;
+    cout << "  Skybrightness         " << skybrightnessmean << " +/- " << skybrightnessrms  << endl;
 
     TString query;
@@ -241,4 +268,8 @@
                      " fDataRate=%d, "
                      " fMaxHumidity=%s ,"
+                     " fNumStarsMean=%s ,"
+                     " fNumStarsRMS=%s ,"
+                     " fBrightnessMean=%s ,"
+                     " fBrightnessRMS=%s ,"
                      " fInhomogeneity=%s ",
                      seq, islands.Data(), ratio.Data(),
@@ -246,4 +277,6 @@
                      muonrate.Data(), PSF.Data(),
                      datarate, maxhum.Data(),
+                     numstarsmean.Data(), numstarsrms.Data(),
+                     skybrightnessmean.Data(), skybrightnessrms.Data(),
                      inhomogen.Data());
     }
@@ -259,4 +292,8 @@
                      " fDataRate=%d, "
                      " fMaxHumidity=%s, "
+                     " fNumStarsMean=%s ,"
+                     " fNumStarsRMS=%s ,"
+                     " fBrightnessMean=%s ,"
+                     " fBrightnessRMS=%s ,"
                      " fInhomogeneity=%s "
                      " WHERE fSequenceFirst=%d ",
@@ -265,6 +302,10 @@
                      muonrate.Data(), PSF.Data(),
                      datarate, maxhum.Data(),
+                     numstarsmean.Data(), numstarsrms.Data(),
+                     skybrightnessmean.Data(), skybrightnessrms.Data(),
                      inhomogen.Data(), seq);
     }
+
+    cout << "Q: " << query << endl;
 
     if (dummy)
Index: /trunk/MagicSoft/Mars/datacenter/macros/setupdb.C
===================================================================
--- /trunk/MagicSoft/Mars/datacenter/macros/setupdb.C	(revision 7656)
+++ /trunk/MagicSoft/Mars/datacenter/macros/setupdb.C	(revision 7657)
@@ -579,4 +579,8 @@
          "  fMaxHumidity        FLOAT(6,1)            NOT NULL,"
          "  fInhomogeneity      FLOAT(5,1)            NOT NULL,"
+         "  fNumStarsMean       FLOAT(5,1)            NOT NULL,"
+         "  fNumStarsRMS        FLOAT(5,1)            NOT NULL,"
+         "  fBrightnessMean     FLOAT(5,1)            NOT NULL,"
+         "  fBrightnessRMS      FLOAT(5,1)            NOT NULL,"
          "  fLastUpdate         TIMESTAMP"
          ")"));