Changeset 9600 for trunk/MagicSoft/Mars

Timestamp:

06/29/10 14:07:49 (14 years ago)

Author:

Daniela Dorner

Message:

*** empty log message ***

File:

• trunk/MagicSoft/Mars/datacenter/db/mcinfo.php (modified) (1 diff)

trunk/MagicSoft/Mars/datacenter/db/mcinfo.php

@@ -82 +82 @@
                         $query0 .= " IF (NOT ISNULL(" . $key . "Status.fReturnCode), ";
                         $query0 .= " CONCAT('failed (', " . $key . "Status.fReturnCode, ')'), ";
-                        $query0 .= " CONCAT('done (', " . $key . "Status.fStopTime, ')'))) ";
+                        $query0 .= " CONCAT('done (', " . $key . "Status.fStopTime, ";
+                        $query0 .= " ',', TIMEDIFF(" . $key . "Status.fStopTime, " . $key . "Status.fStartTime), ')'))) ";
 
                         //$query0 .= ", CONCAT( 'halo', " . $key . "Status.fStartTime)";