Index: /trunk/DataCheck/Processing/FillEffectiveOn.sh
===================================================================
--- /trunk/DataCheck/Processing/FillEffectiveOn.sh	(revision 15603)
+++ /trunk/DataCheck/Processing/FillEffectiveOn.sh	(revision 15604)
@@ -3,5 +3,5 @@
 # option 
 doupdate="yes" # update all entries (needed when new fields have been added)
-doupdate="no" # fill only entries which are not yet existing (default)
+#doupdate="no" # fill only entries which are not yet existing (default)
 
 
@@ -27,5 +27,5 @@
 # get last 3, 6 or 9 nights
 dates=( `date +%Y/%m/%d --date="-12hour"` `date +%Y/%m/%d --date="-36hour"` `date +%Y/%m/%d --date="-60hour"` \
-#        `date +%Y/%m/%d --date="-84hour"` `date +%Y/%m/%d --date="-108hour"` `date +%Y/%m/%d --date="-132hour"` \
+        `date +%Y/%m/%d --date="-84hour"` `date +%Y/%m/%d --date="-108hour"` `date +%Y/%m/%d --date="-132hour"` \
 #        `date +%Y/%m/%d --date="-156hour"` `date +%Y/%m/%d --date="-180hour"` `date +%Y/%m/%d --date="-204hour"` \
         )
@@ -161,7 +161,31 @@
          if [ "${effectiveon[3]}" == "" ]
          then
+            query=$query", fTriggerRateTimeOver100=NULL"
+         else
+            query=$query", fTriggerRateTimeOver100="${effectiveon[3]}
+         fi
+         if [ "${effectiveon[4]}" == "" ]
+         then
             query=$query", fTriggerRateTimeOver125=NULL"
          else
-            query=$query", fTriggerRateTimeOver125="${effectiveon[3]}
+            query=$query", fTriggerRateTimeOver125="${effectiveon[4]}
+         fi
+         if [ "${effectiveon[5]}" == "" ]
+         then
+            query=$query", fTriggerRateTimeOver150=NULL"
+         else
+            query=$query", fTriggerRateTimeOver150="${effectiveon[5]}
+         fi
+         if [ "${effectiveon[6]}" == "" ]
+         then
+            query=$query", fTriggerRateTimeOver175=NULL"
+         else
+            query=$query", fTriggerRateTimeOver175="${effectiveon[6]}
+         fi
+         if [ "${effectiveon[7]}" == "" ]
+         then
+            query=$query", fTriggerRateRms=NULL"
+         else
+            query=$query", fTriggerRateRms="${effectiveon[7]}
          fi
       else
@@ -169,5 +193,10 @@
          query=$query", fEffectiveOnRms=NULL"
          query=$query", fOnTime=NULL"
+         query=$query", fTriggerRateTimeOver100=NULL"
          query=$query", fTriggerRateTimeOver125=NULL"
+         query=$query", fTriggerRateTimeOver150=NULL"
+         query=$query", fTriggerRateTimeOver175=NULL"
+         query=$query", fTriggerRateRms=NULL"
+
       fi
       
@@ -175,5 +204,5 @@
       query=$query" WHERE fNight="$runnumber" AND fRunID="$filenum
 
-      #echo $query
+      echo $query
       #echo "EffectiveOn:${effectiveon[0]} # RMSEffectiveOn:${effectiveon[1]} # SumOnTime:${effectiveon[2]} # TriggerTimeOver125:${effectiveon[3]}"
       #send query to DB