Changeset 9603


Ignore:
Timestamp:
Jun 30, 2010, 4:40:42 PM (10 years ago)
Author:
dorner
Message:
*** empty log message ***
Location:
trunk/MagicSoft/Mars/datacenter
Files:
1 added
2 edited

Legend:

Unmodified
Added
Removed
  • trunk/MagicSoft/Mars/datacenter/db/mcinfo.php

    r9600 r9603  
    5555                            ." IF (NOT ISNULL(" . $key . "Status.fStartTime) "
    5656                            ." AND NOT ISNULL(" . $key . "Status.fStopTime) "
    57                             ." AND ISNULL(" . $key . "Status.fReturnCode), 'done', 'bla' "
     57                            ." AND ISNULL(" . $key . "Status.fReturnCode), 'done', 'failed' "
    5858                            ." )))) AS '". $key . "', ";
    5959            }
     
    8080                        $query0 .= " ISNULL(" . $key . "Status.fStopTime) AND ";
    8181                        $query0 .= " ISNULL(" . $key . "Status.fReturnCode), 'not done', ";
     82                        $query0 .= " IF (NOT ISNULL(" . $key . "Status.fStartTime) ";
     83                        $query0 .= " AND ISNULL(" . $key . "Status.fStopTime) ";
     84                        $query0 .= " AND ISNULL(" . $key . "Status.fReturnCode), ";
     85                        $query0 .= " CONCAT('running (since ', " . $key . "Status.fStartTime, ')'), ";
    8286                        $query0 .= " IF (NOT ISNULL(" . $key . "Status.fReturnCode), ";
    8387                        $query0 .= " CONCAT('failed (', " . $key . "Status.fReturnCode, ')'), ";
    8488                        $query0 .= " CONCAT('done (', " . $key . "Status.fStopTime, ";
    85                         $query0 .= " ',', TIMEDIFF(" . $key . "Status.fStopTime, " . $key . "Status.fStartTime), ')'))) ";
     89                        $query0 .= " ',', TIMEDIFF(" . $key . "Status.fStopTime, " . $key . "Status.fStartTime), ')')))) ";
    8690
    8791                        //$query0 .= ", CONCAT( 'halo', " . $key . "Status.fStartTime)";
  • trunk/MagicSoft/Mars/datacenter/scripts/runcorsika

    r9586 r9603  
    195195wavelengths=`sendquery`
    196196
    197 outpath=$mcpath"/"$program"/"`printf %08d $run | cut -c 0-4`/`printf %08d $run | cut -c 5-8`
     197outpath=$mcpath"/"$program"/"`printf %08d $run | cut -c 1-4`/`printf %08d $run | cut -c 5-8`
    198198makedir $outpath
    199199logfile=$outpath/cer000`printf %06d $file | cut -c 4-6`".log"
Note: See TracChangeset for help on using the changeset viewer.