Index: trunk/Mars/datacenter/scripts/insertmc
===================================================================
--- trunk/Mars/datacenter/scripts/insertmc	(revision 9898)
+++ trunk/Mars/datacenter/scripts/insertmc	(revision 9909)
@@ -37,5 +37,5 @@
 # to really insert information set insert="yes"
 insert="yes"
-#insert=
+insert=
 
 
@@ -44,6 +44,6 @@
 #  make sure that the information on the setup (i.e. table CeresSetup) 
 #  has been inserted before
-#cereskeys=( 2 3 ) 
-cereskeys=( 1 ) 
+cereskeys=( 2 3 4 5 6 ) 
+#cereskeys=( 1 ) 
 
 
@@ -55,8 +55,8 @@
 #  protons: files 2000-2399 i.e. runs 633-750
 #  protons: files 3000-3099 i.e. runs 933-960
-#runmin=423
-#runmax=960
-runmin=
-runmax=
+runmin=423
+runmax=960
+#runmin=
+#runmax=
 
 
@@ -190,5 +190,5 @@
    echo "Do you really want to insert the following cereskey(s)?"
    echo "  run number range:  "$runmin" - "$runmax
-   query="SELECT fRunNumber FROM CorsikaInfo WHERE fRunNumber BETWEEN "$runmin" AND "$runmax
+   query="SELECT fRunNumber FROM CorsikaInfo WHERE fRunNumber BETWEEN "$runmin" AND "$runmax" GROUP BY fRunNumber"
    runs=( `sendquery` )
    echo "    i.e. the following runs: "${runs[@]}
@@ -270,7 +270,9 @@
    for cereskey in ${cereskeys[@]}
    do
-      for (( i=1 ; i<=$numfile ; i++ ))
+      query="SELECT fFileNumber FROM CorsikaInfo WHERE fRunNumber="$drun
+      files=`sendquery`
+      for file in ${files[@]}
       do
-         query="INSERT CeresInfo SET fSequenceNumber="$drun", fRunNumber="$drun", fFileNumber="$i", fCeresSetupKEY="$cereskey", fRunTypeKEY=2"
+         query="INSERT CeresInfo SET fSequenceNumber="$drun", fRunNumber="$drun", fFileNumber="$file", fCeresSetupKEY="$cereskey", fRunTypeKEY=2"
          sendquery2 
       done