Index: /trunk/MagicSoft/Mars/Changelog
===================================================================
--- /trunk/MagicSoft/Mars/Changelog	(revision 7061)
+++ /trunk/MagicSoft/Mars/Changelog	(revision 7062)
@@ -21,4 +21,14 @@
 
                                                  -*-*- END OF LINE -*-*-
+ 2005/05/19 Daniela Dorner
+
+   * datacenter/macros/fillstar.C:
+     - add new parameter
+
+   * datacenter/macros/setupdb.C:
+     - adapted to new column in db
+
+
+
  2005/05/19 Thomas Bretz
 
Index: /trunk/MagicSoft/Mars/datacenter/macros/fillstar.C
===================================================================
--- /trunk/MagicSoft/Mars/datacenter/macros/fillstar.C	(revision 7061)
+++ /trunk/MagicSoft/Mars/datacenter/macros/fillstar.C	(revision 7062)
@@ -108,4 +108,17 @@
     TString PSF = Form("%5.1f", psf);
 
+    TProfile *h2 = (TProfile*)arr.FindObjectInCanvas("SizeVsRadius", "TProfile", "MHMuonPar");
+    if (!h1)
+    {
+        cout << "WARNING - Reading of SizeVsRadius failed." << endl;
+        return 0;
+    }
+
+    Float_t integral = h2->Integral(5, 14);
+    Float_t integralmc = -35.6*psf + 11000;
+    Float_t ratiodatamc = (integral/integralmc)*100;
+    TString ratio = Form("%5.1f", ratiodatamc);
+
+
     TH1 *h = (TH1*)arr.FindObjectInCanvas("Islands", "TH1F", "MHImagePar");
     if (!h)
@@ -129,6 +142,7 @@
 
     cout << "Sequence #" << seq << endl;
-    cout << "  PSF [mm]       " << Form("%5.1f", psf)     << endl;
-    cout << "  Island Quality " << Form("%5.1f", quality) << endl;
+    cout << "  PSF [mm]       " << Form("%5.1f", psf)         << endl;
+    cout << "  Island Quality " << Form("%5.1f", quality)     << endl;
+    cout << "  Ratio [%]      " << Form("%5.1f", ratiodatamc) << endl;
 
     TString query;
@@ -138,6 +152,7 @@
                      " fSequenceFirst=%d,"
                      " fMeanNumberIslands=%s, "
+                     " fRatio=%s, "
                      " fPSF=%s ",
-                     seq, islands.Data(), PSF.Data());
+                     seq, islands.Data(), ratio.Data(), PSF.Data());
     }
     else
@@ -145,7 +160,8 @@
         query = Form("UPDATE MyMagic.Star SET"
                      " fMeanNumberIslands=%s, "
+                     " fRatio=%s, "
                      " fPSF=%s "
                      " WHERE fSequenceFirst=%d ",
-                     islands.Data(), PSF.Data(), seq);
+                     islands.Data(), ratio.Data(), PSF.Data(), seq);
     }
 
Index: /trunk/MagicSoft/Mars/datacenter/macros/setupdb.C
===================================================================
--- /trunk/MagicSoft/Mars/datacenter/macros/setupdb.C	(revision 7061)
+++ /trunk/MagicSoft/Mars/datacenter/macros/setupdb.C	(revision 7062)
@@ -530,4 +530,5 @@
          "  fMeanNumberIslands  FLOAT(5,1)            NOT NULL,"
          "  fPSF                FLOAT(5,1)            NOT NULL,"
+         "  fRatio              FLOAT(5,1)            NOT NULL,"
          "  fLastUpdate         TIMESTAMP"
          ")"));