Index: trunk/Mars/datacenter/db/mcinfo.php
===================================================================
--- trunk/Mars/datacenter/db/mcinfo.php	(revision 9895)
+++ trunk/Mars/datacenter/db/mcinfo.php	(revision 10012)
@@ -33,19 +33,28 @@
                             ." AND ISNULL(" . $key . "Status.fStopTime) "
                             ." AND ISNULL(" . $key . "Status.fReturnCode), 'not done', "
+                            //crashed
                             ." IF (NOT ISNULL(" . $key . "Status.fStartTime) "
                             ." AND DATE_SUB(Now(),INTERVAL " . $timelimits[$key] . " HOUR) > " . $key . "Status.fStartTime "
                             ." AND ISNULL(" . $key . "Status.fStopTime) "
                             ." AND ISNULL(" . $key . "Status.fReturnCode), 'crashed', "
+                            //running
                             ." IF (NOT ISNULL(" . $key . "Status.fStartTime) "
                             ." AND DATE_SUB(Now(),INTERVAL " . $timelimits[$key] . " HOUR) < " . $key . "Status.fStartTime "
                             ." AND ISNULL(" . $key . "Status.fStopTime) "
                             ." AND ISNULL(" . $key . "Status.fReturnCode), 'running', "
+                            //failed
                             ." IF (NOT ISNULL(" . $key . "Status.fStartTime) "
                             ." AND NOT ISNULL(" . $key . "Status.fStopTime) "
-                            ." AND ISNULL(" . $key . "Status.fReturnCode), 'done', 'failed' "
-                            ." )))) AS '". $key . "', ";
+                            ." AND NOT ISNULL(" . $key . "Status.fReturnCode), 'failed', "
+                            //done or done and avail
+                            ." IF (NOT ISNULL(" . $key . "Status.fStartTime) "
+                            ." AND NOT ISNULL(" . $key . "Status.fStopTime) "
+                            ." AND ISNULL(" . $key . "Status.fReturnCode)"
+                            ." AND ISNULL(" . $key . "Status.fAvailable), 'done', 'done and avail' "
+                            ." ))))) AS '". $key . "', ";
             }
             $query0 .= " COUNT(*) as '# Files' ";
             $query0 .= ", SUM(fNumEvents) as '" . $alias["SUM(fNumEvents)"] . "' ";
+            $query0 .= ", SUM(fNumEvents*fNumReUseShowers) as '" . $alias["SUM(fNumEvents*fNumReUseShowers)"] . "' ";
         }
         else