--- chewbacca/YodaProfiler/inc/GLTables.h	2008/09/23 07:20:32	1.1.1.1
+++ chewbacca/YodaProfiler/inc/GLTables.h	2009/12/15 10:23:28	1.9
@@ -6,6 +6,10 @@
 #include <TSQLServer.h>
 #include <TSQLRow.h>
 #include <TSQLResult.h>
+#include <TCanvas.h>
+#include <TDirectory.h>
+#include <TH1D.h>
+#include <TH2D.h>
 #include <TSystem.h>
 #include <GLTablesStruct.h>
 #include <EventHeader.h>
@@ -33,15 +37,16 @@
 
  public:
     //
-    TString mh;
-    TString mp;
-    TString mu;
+    TString mh; //!
+    TString mp; //!
+    TString mu; //!
     GL_TABLES();   
     GL_TABLES(TString, TString, TString);
     //
     void Set(TString, TString, TString);
     //
-    Bool_t IsConnected(TSQLServer *&);
+    //    Bool_t IsConnected(TSQLServer *&);
+    Bool_t IsConnected(TSQLServer *);
     //
     void ResetCounters();
     void AddQ();
@@ -58,10 +63,32 @@
     //
     GL_TABLES *GetGLTABLES(){return this;};
     //
-    ClassDef(GL_TABLES,2);
+    ClassDef(GL_TABLES,0); // 2
 };
 
 // ==================================================================
+class Q2TH : public TObject {
+ private:
+    TSQLServer *dbc;
+    TSQLResult *pResult;
+    TSQLRow *Row;
+    TString fh;
+    TString fp;
+    TString fu;
+    
+ public:
+    
+    Q2TH(TString h="$PAM_DBHOST", TString u="$PAM_DBUSER", TString p="$PAM_DBPSW");
+    ~Q2TH(){ if ( dbc ) dbc->Close(); delete dbc; };
+    
+    TObject *Draw(TString query, Bool_t verbose = false, TString hname="q2th");
+    void Open(TString h="$PAM_DBHOST", TString u="$PAM_DBUSER", TString p="$PAM_DBPSW");
+    void Close(){ if ( dbc ) dbc->Close(); delete dbc; };
+
+    ClassDef(Q2TH,1); // 2
+
+};
+
 /**
  * \brief Class to store GL_RUN data
  */
@@ -100,6 +127,8 @@
     UInt_t CAL_DSP_MASK;
     UInt_t LAST_TIMESYNC;
     UInt_t OBT_TIMESYNC;
+    UInt_t PHYSENDRUN_MASK_S3S2S12;
+    UInt_t PHYSENDRUN_MASK_S11CRC;
     UInt_t VALIDATION;
     //
     //
@@ -155,6 +184,8 @@
     void SetRM_ACQ_SETTING_MODE(UInt_t);
     void SetTRK_CALIB_USED(UInt_t);
     void SetCAL_DSP_MASK(UInt_t);
+    void SetPHYSENDRUN_MASK_S3S2S12(UInt_t);
+    void SetPHYSENDRUN_MASK_S11CRC(UInt_t);
     //
     // GETTERS
     //
@@ -184,10 +215,12 @@
     UInt_t GetRM_ACQ_SETTING_MODE(){return(RM_ACQ_SETTING_MODE);};
     UInt_t GetTRK_CALIB_USED(){return(TRK_CALIB_USED);};
     UInt_t GetCAL_DSP_MASK(){return(CAL_DSP_MASK);};
+    UInt_t GetPHYSENDRUN_MASK_S3S2S12(){return (PHYSENDRUN_MASK_S3S2S12);};
+    UInt_t GetPHYSENDRUN_MASK_S11CRC(){return (PHYSENDRUN_MASK_S11CRC);};
     //
     GL_RUN* GetGL_RUN(){return this;};
     //
-    ClassDef(GL_RUN,1);
+    ClassDef(GL_RUN,2);
 };
 
 // ==================================================================
@@ -214,6 +247,27 @@
 };
 // ==================================================================
 /**
+ * \brief Class to store GL_RAW 
+ */
+class GL_RAW : public GL_TABLES {
+    //class GL_ROOT : public TObject{
+ private:
+    
+ public:
+    //
+    UInt_t ID;
+    TString   PATH;
+    TString   NAME;
+    UInt_t BOOT_NUMBER;
+
+    GL_RAW();
+
+//    Int_t Query_GL_RAW(UInt_t id, TSQLServer *dbc);
+
+    ClassDef(GL_RAW,1);
+};
+// ==================================================================
+/**
  * \brief Class to store GL_PARAM data
  */
 class GL_PARAM : public GL_TABLES {
@@ -256,8 +310,8 @@
     UInt_t OBT2;
     UInt_t PKT1;
     UInt_t PKT2;
-	UInt_t BOOT_NUMBER;
-	UInt_t VALIDATION;
+    UInt_t BOOT_NUMBER;
+    UInt_t VALIDATION;
 
     GL_TRK_CALIB();
 
@@ -371,6 +425,7 @@
     //
     GL_TIMESYNC();
     GL_TIMESYNC(UInt_t ID, TString TYPE, TSQLServer *dbc);
+    GL_TIMESYNC(UInt_t ID, TString TYPE, TSQLServer *dbc, Bool_t usel0file);
     //
     UInt_t DBabsTime(UInt_t OBT);
     UInt_t ResursTime(UInt_t OBT);