Index: trunk/MagicSoft/Mars/datacenter/macros/fillcmt.C
===================================================================
--- trunk/MagicSoft/Mars/datacenter/macros/fillcmt.C	(revision 9284)
+++ trunk/MagicSoft/Mars/datacenter/macros/fillcmt.C	(revision 9284)
@@ -0,0 +1,155 @@
+/* ======================================================================== *\
+!
+! *
+! * 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): Thomas Bretz, 01/2009 <mailto:tbretz@astro.uni-wuerzburg.de>
+!
+!   Copyright: MAGIC Software Development, 2000-2009
+!
+!
+\* ======================================================================== */
+
+/////////////////////////////////////////////////////////////////////////////
+//
+// fillcmt.C
+// =========
+//
+// This macro is used to read an extinction file from the CMT and fill
+// its contents into the db.
+//
+// Usage:
+//   .x fillcmt.C("camext.06", kTRUE)
+//
+// The second argument is the 'dummy-mode'. If it is kTRUE dummy-mode is
+// switched on and nothing will be written into the database. This is usefull
+// for tests.
+//
+// Filling the database is done with 'UPADTE' for _all_ columns
+// matching the date!
+//
+// The macro can also be run without ACLiC but this is a lot slower...
+//
+// Remark: Running it from the commandline looks like this:
+//   root -q -l -b fillcmt.C+\(\"filename\"\,kFALSE\) 2>&1 | tee fillcmt.log
+//
+// Make sure, that database and password are corretly set in a resource
+// file called sql.rc and the resource file is found.
+//
+// Returns 2 in case of failure, 1 in case of success and 0 if the connection
+// to the database is not working.
+//
+/////////////////////////////////////////////////////////////////////////////
+
+#include <fstream>
+#include <iostream>
+#include <errno.h>
+
+#include <TEnv.h>
+#include <TSystem.h>
+
+#include "MLog.h"
+#include "MLogManip.h"
+
+#include "MTime.h"
+#include "MSQLMagic.h"
+
+using namespace std;
+
+int fillcmt(TString fname, Bool_t dummy=kTRUE)
+{
+    TEnv env("sql.rc");
+
+    MSQLMagic serv(env);
+    if (!serv.IsConnected())
+    {
+        cout << "ERROR - Connection to database failed." << endl;
+        return 0;
+    }
+
+    serv.SetIsDummy(dummy);
+
+    gSystem->ExpandPathName(fname);
+
+    cout << "fillcmt" << endl;
+    cout << "-------" << endl;
+    cout << endl;
+    cout << "Connected to " << serv.GetName() << endl;
+    cout << "File: " << fname << endl;
+    cout << endl;
+
+
+    ifstream fin(fname);
+    if (!fin)
+    {
+        gLog << err << "Cannot open file " << fname << ": ";
+        gLog << strerror(errno) << endl;
+        return 2;
+    }
+
+    TString line;
+    for (int i=0; i<23; i++)
+        line.ReadLine(fin);
+
+    if (!fin)
+    {
+        gLog << err << "File " << fname << ": Not enough lines." << endl;
+        return 2;
+    }
+
+    while (1)
+    {
+        line.ReadLine(fin);
+        if (!fin)
+            break;
+
+        const_cast<char&>(line.Data()[ 6]) = 0;
+        const_cast<char&>(line.Data()[10]) = 0;
+        const_cast<char&>(line.Data()[19]) = 0;
+        const_cast<char&>(line.Data()[35]) = 0;
+        const_cast<char&>(line.Data()[39]) = 0;
+        const_cast<char&>(line.Data()[45]) = 0;
+        const_cast<char&>(line.Data()[51]) = 0;
+
+        const Int_t checked = atoi(line.Data()+7);
+        if (checked==0)
+            continue;
+
+        const TString date    = line.Data();
+        const Float_t extr    = atof(line.Data()+11);     //5.3
+        const Int_t   phot    = line.Data()[18] == ':';
+        const Float_t extrerr = atof(line.Data()+20);     //5.3
+        const Float_t tmphot  = atof(line.Data()+40);     //5.2
+        const Float_t tmnphot = atof(line.Data()+46);     //5.2
+
+        MTime t;
+        t.SetStringFmt(date, "%y%m%d");
+
+        const TString vars = Form("fExtinctionR=%.3f, "
+                                  "fExtinctionRerr=%.3f, "
+                                  "fIsPhotometric=%d, "
+                                  "fTimePhotometric=%.2f, "
+                                  "fTimeNonPhotometric=%.2f",
+                                  extr, extrerr, phot, tmphot, tmnphot);
+
+
+        const TString where = Form("fData='%s'", t.GetSqlDateTime().Data());
+
+        if (!serv.InsertUpdate("ExtinctionCMT", vars, where))
+            return 2;
+    }
+
+    return 1;
+}
Index: trunk/MagicSoft/Mars/datacenter/macros/plotstat.C
===================================================================
--- trunk/MagicSoft/Mars/datacenter/macros/plotstat.C	(revision 9282)
+++ trunk/MagicSoft/Mars/datacenter/macros/plotstat.C	(revision 9284)
@@ -1,4 +1,4 @@
 /* ======================================================================== *\
-! $Name: not supported by cvs2svn $:$Id: plotstat.C,v 1.10 2008-11-12 13:38:17 tbretz Exp $
+! $Name: not supported by cvs2svn $:$Id: plotstat.C,v 1.11 2009-01-30 14:58:40 tbretz Exp $
 ! --------------------------------------------------------------------------
 !
@@ -556,5 +556,5 @@
     TObject *leg=DrawLegend(h);
 
-    for (int i=h[0].GetNbinsX()-1; i>=40; i--)
+    for (int i=h[0].GetNbinsX()-1; i>=0; i--)
     {
         const Int_t num = TMath::Nint(h[0].GetBinCenter(i+1));