Index: trunk/DataCheck/Processing/FillEffectiveOn.sh
===================================================================
--- trunk/DataCheck/Processing/FillEffectiveOn.sh	(revision 17096)
+++ trunk/DataCheck/Processing/FillEffectiveOn.sh	(revision 17097)
@@ -1,8 +1,11 @@
 #!/bin/bash
 
-# option 
-doupdate="yes" # update all entries (needed when new fields have been added)
-#doupdate="no" # fill only entries which are not yet existing (default)
-
+# option whether to fill all row or only those where information is missing
+# $doupdate might be given as environment variable
+if [ "$doupdate" = "" ]
+then
+   doupdate="yes" # update all entries (needed when new fields have been added)
+   doupdate="no" # fill only entries which are not yet existing (default)
+fi
 
 source `dirname $0`/../Sourcefile.sh
@@ -11,6 +14,4 @@
 logfile=$runlogpath"/EffectiveOn-"$datetime".log"
 date >> $logfile
-
-echo $logfile
 
 # setup to use ftools
@@ -24,18 +25,18 @@
 fi
 
-
-# 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="-156hour"` `date +%Y/%m/%d --date="-180hour"` `date +%Y/%m/%d --date="-204hour"` \
-        )
-dates=( `find -L $ziprawdata -mindepth 3 -type d | sort -r | sed "s/\${ziprawdata_for_sed}//g" | sed -e 's/^\///'` ) #all available dates in /loc_data/zipraw
-
-#dates=( "2012/11/19" )
+# get dates
+if [ "$certaindate" != "" ]
+then
+   getdates $certaindate
+else
+   # get all night
+   #getdates "all"
+   # get last 6 nights
+   getdates 6
+fi
+
 
 printprocesslog "INFO processing the following night(s): "${dates[@]}
 echo  `date`": processing the following night(s): "${dates[@]} >> $logfile 2>&1
-
-echo ${dates[@]}
 
 cd $mars
@@ -51,4 +52,5 @@
 #      continue
 #   fi
+#   echo $auxdir" @ "`date` 
 
    # check if aux files are available from that night
@@ -74,5 +76,4 @@
    fi
 
-   echo "run ontime.C for night "$runnumber
    # get file numbers from DB
    #   but only for not-corrupted files
@@ -91,5 +92,4 @@
    fi
 
-   #echo ${filenumbers[@]}
    # fill auxiliary information for files
    for filenum in ${filenumbers[@]}
@@ -204,6 +204,4 @@
       query=$query" WHERE fNight="$runnumber" AND fRunID="$filenum
 
-      echo $query
-      #echo "EffectiveOn:${effectiveon[0]} # RMSEffectiveOn:${effectiveon[1]} # SumOnTime:${effectiveon[2]} # TriggerTimeOver125:${effectiveon[3]}"
       #send query to DB
       sendquery >/dev/null