Index: trunk/MagicSoft/Mars/Changelog
===================================================================
--- trunk/MagicSoft/Mars/Changelog	(revision 8986)
+++ trunk/MagicSoft/Mars/Changelog	(revision 8987)
@@ -18,4 +18,19 @@
 
                                                  -*-*- END OF LINE -*-*-
+
+ 2008/06/30 Thomas Bretz
+
+   * datacenter/macros/fillstar.C:
+     - check whether graphs are empty in a more accurate way
+
+   * datacenter/macros/plotdb.C:
+     - fixed some axis title
+     - increased range of fRatePedTrigEvts
+
+   * msql/MSQLMagic.cc:
+     - added ' around the where clause in UpdateInsert to allowe
+       also for times etc
+
+
 
  2008/06/21 Thomas Bretz
Index: trunk/MagicSoft/Mars/datacenter/macros/fillstar.C
===================================================================
--- trunk/MagicSoft/Mars/datacenter/macros/fillstar.C	(revision 8986)
+++ trunk/MagicSoft/Mars/datacenter/macros/fillstar.C	(revision 8987)
@@ -80,4 +80,9 @@
 using namespace std;
 
+bool CheckGraph(const TGraph *g)
+{
+    return g && g->GetN()>0 && !(g->GetN()==1 && g->GetX()[0]==0);
+}
+
 int Process(MSQLMagic &serv, TString fname)
 {
@@ -183,6 +188,6 @@
         return 2;
     }
-    TString maxhum = g->GetN()>0 ? Form("%5.1f", TMath::MaxElement(g->GetN(), g->GetY())) : "NULL";
-    TString avghum = g->GetN()>0 ? Form("%5.1f", g->GetMean(2)) : "NULL";
+    TString maxhum = CheckGraph(g) ? Form("%5.1f", TMath::MaxElement(g->GetN(), g->GetY())) : "NULL";
+    TString avghum = CheckGraph(g) ? Form("%5.1f", g->GetMean(2)) : "NULL";
 
     g = (TGraph*)arr.FindObjectInCanvas("Temperature", "TGraph", "MHWeather");
@@ -192,5 +197,5 @@
         return 2;
     }
-    TString avgtemp = g->GetN()>0 ? Form("%5.1f", g->GetMean(2)) : "NULL";
+    TString avgtemp = CheckGraph(g) ? Form("%5.1f", g->GetMean(2)) : "NULL";
 
     g = (TGraph*)arr.FindObjectInCanvas("WindSpeed", "TGraph", "MHWeather");
@@ -200,16 +205,17 @@
         return 2;
     }
-    TString avgwind = g->GetN()>0 ? Form("%5.1f", g->GetMean(2)) : "NULL";
+    TString avgwind = CheckGraph(g) ? Form("%5.1f", g->GetMean(2)) : "NULL";
 
     g = (TGraph*)arr.FindObjectInCanvas("Cloudiness", "TGraph", "MHWeather");
     if (!g)
         cout << "WARNING - Reading of Cloudiness failed." << endl;
-    TString avgclouds = g && g->GetN()>0 ? Form("%5.1f", g->GetMean(2)) : "NULL";
-    TString rmsclouds = g && g->GetN()>0  ? Form("%5.1f", g->GetRMS(2))  : "NULL";
+
+    TString avgclouds = CheckGraph(g) ? Form("%5.1f", g->GetMean(2)) : "NULL";
+    TString rmsclouds = CheckGraph(g) ? Form("%5.1f", g->GetRMS(2))  : "NULL";
 
     g = (TGraph*)arr.FindObjectInCanvas("TempSky", "TGraph", "MHWeather");
     if (!g)
         cout << "WARNING - Reading of TempSky failed." << endl;
-    TString avgsky = g && g->GetN()>0 ? Form("%5.1f", g->GetMean(2)+200) : "NULL";
+    TString avgsky = CheckGraph(g) ? Form("%5.1f", g->GetMean(2)+200) : "NULL";
 
 
@@ -218,6 +224,6 @@
         cout << "WARNING - Reading of NumStars failed." << endl;
 
-    TString numstarsmed = g && g->GetN()>0 ? Form("%5.1f", TMath::Median(g->GetN(), g->GetY())) : "NULL";
-    TString numstarsrms = g && g->GetN()>0  ? Form("%5.1f", g->GetRMS(2)) : "NULL";
+    TString numstarsmed = CheckGraph(g) ? Form("%5.1f", TMath::Median(g->GetN(), g->GetY())) : "NULL";
+    TString numstarsrms = CheckGraph(g) ? Form("%5.1f", g->GetRMS(2)) : "NULL";
 
     g = (TGraph*)arr.FindObjectInCanvas("NumStarsCor", "TGraph", "MHPointing");
@@ -225,6 +231,6 @@
         cout << "WARNING - Reading of NumStarsCor failed." << endl;
 
-    TString numcorsmed = g && g->GetN()>0  ? Form("%5.1f", TMath::Median(g->GetN(), g->GetY())) : "NULL";
-    TString numcorsrms = g && g->GetN()>0  ? Form("%5.1f", g->GetRMS(2)) : "NULL";
+    TString numcorsmed = CheckGraph(g) ? Form("%5.1f", TMath::Median(g->GetN(), g->GetY())) : "NULL";
+    TString numcorsrms = CheckGraph(g) ? Form("%5.1f", g->GetRMS(2)) : "NULL";
 
     g = (TGraph*)arr.FindObjectInCanvas("Brightness", "TGraph", "MHPointing");
@@ -232,6 +238,6 @@
         cout << "WARNING - Reading of SkyBrightness failed." << endl;
 
-    TString skybrightnessmed = g && g->GetN()>0  ? Form("%5.1f", TMath::Median(g->GetN(), g->GetY())) : "NULL";
-    TString skybrightnessrms = g && g->GetN()>0  ? Form("%5.1f", g->GetRMS(2)) : "NULL";
+    TString skybrightnessmed = CheckGraph(g) ? Form("%5.1f", TMath::Median(g->GetN(), g->GetY())) : "NULL";
+    TString skybrightnessrms = CheckGraph(g) ? Form("%5.1f", g->GetRMS(2)) : "NULL";
 
     TString sequence = fname(TRegexp("star[0-9]+[.]root$"));
Index: trunk/MagicSoft/Mars/datacenter/macros/plotdb.C
===================================================================
--- trunk/MagicSoft/Mars/datacenter/macros/plotdb.C	(revision 8986)
+++ trunk/MagicSoft/Mars/datacenter/macros/plotdb.C	(revision 8987)
@@ -1,4 +1,4 @@
 /* ======================================================================== *\
-! $Name: not supported by cvs2svn $:$Id: plotdb.C,v 1.46 2008-06-21 13:53:33 tbretz Exp $
+! $Name: not supported by cvs2svn $:$Id: plotdb.C,v 1.47 2008-06-30 08:46:03 tbretz Exp $
 ! --------------------------------------------------------------------------
 !
@@ -539,5 +539,5 @@
     plot.SetDescription("RMS Arrival Time inner Camera;\\sigma_{T,I} [sl]", "RmsArrTmI");
     plot.Plot("Calibration.fArrTimeRmsInner",  0, 4.5, 0.01);
-    plot.SetDescription("Number of unsuitable pixels inner Camera;N{I}", "UnsuitI");
+    plot.SetDescription("Number of unsuitable pixels inner Camera;N_{I}", "UnsuitI");
     plot.Plot("Calibration.fUnsuitableInner",  0, 75, 1);
     plot.SetDescription("Number of unsuitable pixels >50%;N", "Unsuit50");
@@ -575,5 +575,5 @@
     plot.Plot("Calibration.fRatePedEvts", 0, 50, 1);
     plot.SetDescription("Average rate of events with ped+cosmics trigger;R [Hz]", "RatePT");
-    plot.Plot("Calibration.fRatePedTrigEvts", 0, 3.5, 0.1);
+    plot.Plot("Calibration.fRatePedTrigEvts", 0, 4.0, 0.1);
     plot.SetDescription("Average rate of events without trigger pattern;R [Hz]", "Rate0");
     plot.Plot("Calibration.fRateNullEvts", 0, 3.5, 0.1);
Index: trunk/MagicSoft/Mars/msql/MSQLMagic.cc
===================================================================
--- trunk/MagicSoft/Mars/msql/MSQLMagic.cc	(revision 8986)
+++ trunk/MagicSoft/Mars/msql/MSQLMagic.cc	(revision 8987)
@@ -290,6 +290,6 @@
 {
     return ExistStr(col, table, val) ?
-        Update(table, vars, Form("%s=%s", col, val)) :
-        Insert(table, vars, Form("%s=%s", col, val));
+        Update(table, vars, Form("%s='%s'", col, val)) :
+        Insert(table, vars, Form("%s='%s'", col, val));
 }