Index: /trunk/Mars/datacenter/db/factdefs.php
===================================================================
--- /trunk/Mars/datacenter/db/factdefs.php	(revision 12666)
+++ /trunk/Mars/datacenter/db/factdefs.php	(revision 12666)
@@ -0,0 +1,100 @@
+<?php
+
+$checkwhere = array
+    (
+     "fRunTypeName"                      => CheckWhere("fRunTypeKEY"),
+    );
+
+$checkgroup = array
+    (
+     "fRunTypeName"                      => CheckGroup("fRunTypeKEY"),
+    );
+
+
+            //don't put a '#' at the beginning of the alias, else SortBy won't work anymore
+$alias = array
+    (
+     "NumRuns"                          => "#Runs",
+     "Run"                              => "Run",
+     "fRunTypeName"                     => "RunType",
+     "fMd5sumRaw"                       => "md5",
+     "fMd5sumRawZip"                    => "md5(zip)",
+     "fROI"                             => "roi",
+     "fROITimeMarker"                   => "roi-tm",
+     "fLastUpdate"                      => "LastUpd",
+     //"SUM(fRunTime)/3600"               => "Time [h]",
+     "SUM(fNumEvents)"                  => "Evts",
+     "Min(fZenithDistanceMin)"          => "ZDMin",
+     "Max(fZenithDistanceMax)"          => "ZDMax",
+     "Min(fZenithDistance)"             => "ZdMin",
+     "Max(fZenithDistance)"             => "ZdMax",
+     "fNumEvents"                       => "#Evts",
+     "fRunStart"                        => "start",
+     "fRunStop"                         => "stop",
+     "fFitsFileErrors"                  => "file err",
+     "fHasDrsFile"                      => "num drs",
+     "TimeDiff(fRunStop,fRunStart)"     => "duration",
+     "Round(fNumPhysicsTrigger/Time_to_sec(TimeDiff(fRunStop,fRunStart)),1)"  => "phys rate [Hz]",
+     "fNumPhysicsTrigger"               => "#Phys",
+     "fNumExt1Trigger"                  => "#Ext1",
+     "fNumExt2Trigger"                  => "#Ext2",
+     "fNumELPTrigger"                   => "#ELP",
+     "fNumILPTrigger"                   => "#ILP",
+     "fNumPedestalTrigger"              => "#Ped",
+     "fNumTimeTrigger"                  => "#Time",
+     "fNumOtherTrigger"                 => "#Other",
+     "Round(Sum(TimeDiff(fRunStop,fRunStart))/60./60.,1)"  => "Time [h]",
+    );
+
+
+$rightalign = array
+    (
+     //$alias["fRunTypeName"]              => "1",
+     $alias["fNumEvents"]                => "1",
+     $alias["Round(fNumPhysicsTrigger/Time_to_sec(TimeDiff(fRunStop,fRunStart)),1)"] => "1",
+     $alias["fNumPhysicsTrigger"]        => "1",
+     $alias["fNumExt1Trigger"]           => "1",
+     $alias["fNumExt2Trigger"]           => "1",
+     $alias["fNumELPTrigger"]            => "1",
+     $alias["fNumILPTrigger"]            => "1",
+     $alias["fNumPedestalTrigger"]       => "1",
+     $alias["fNumTimeTrigger"]           => "1",
+     $alias["fNumOtherTrigger"]          => "1",
+     $alias["fFitsFileErrors"]           => "1",
+     $alias["fROI"]                      => "1",
+     $alias["fROITimeMarker"]            => "1",
+     "Time [h]"                          => "1",
+     "NumRuns"                           => "1",
+     "Evts"                              => "1",
+);
+
+function GetCheck($fromtable, $val)
+{
+    $checks = array
+        (
+         "fRunTypeName"                      => $fromtable . ".fRunTypeKEY",
+        );
+
+    $check="";
+    if (!empty($checks[$val]))
+        $check=$checks[$val];
+    return $check;
+}
+
+
+function GetJoin($fromtable, $val)
+{
+    $joins = array
+        (
+         "fRunTypeName"                     => " LEFT JOIN RunType                     USING(fRunTypeKEY) ",
+        );
+
+
+    $join="";
+    if (!empty($joins[$val]))
+        $join=$joins[$val];
+    return $join;
+}
+
+
+?>