Index: trunk/ippMonitor/raw/czartool_labels.php
===================================================================
--- trunk/ippMonitor/raw/czartool_labels.php	(revision 40426)
+++ trunk/ippMonitor/raw/czartool_labels.php	(revision 40427)
@@ -357,9 +357,10 @@
     echo $table;
     echo "<tr>";
-    createTableTitle("Status of last night's data", 3);
+    createTableTitle("Status of last night's data", 4);
     echo "<tr>";
     createTableColumnHeader("Exposure type");
     createTableColumnHeader("At summit");
     createTableColumnHeader("Registered at MHPCC");
+    createTableColumnHeader("At summit (Dropped)");
 
     $msg = "No science images taken since $date";
@@ -368,11 +369,17 @@
     while ($qry->fetchInto($expType)) {
 
-        $sql = "SELECT COUNT(*) FROM summitExp WHERE dateobs > '$date' AND exp_type = '$expType[0]'";
+        $sql = "SELECT COUNT(*) FROM summitExp left join pzDownloadExp using (summit_id) WHERE dateobs > '$date' AND exp_type = '$expType[0]' and (state != 'drop' or state is null) and fault != 1042";
+#       $sql = "SELECT COUNT(*) FROM summitExp WHERE dateobs > '$date' AND exp_type = '$expType[0]'";
         $qry2 = $projectdb->query($sql);
         $qry2->fetchInto($summit);
+
         $sql = "SELECT COUNT(*) FROM summitExp JOIN rawExp ON summitExp.exp_name = rawExp.exp_name WHERE summitExp.dateobs > '$date' AND rawExp.dateobs > '$date' AND summitExp.exp_type = '$expType[0]'";
         $qry2 = $projectdb->query($sql);
         $qry2->fetchInto($mhpcc);
 
+        $sql = "SELECT COUNT(*) FROM summitExp join pzDownloadExp using (summit_id) WHERE dateobs > '$date' AND exp_type = '$expType[0]' and state = 'drop'";
+        $qry2 = $projectdb->query($sql);
+        $qry2->fetchInto($dropped);
+
         echo "<tr>";
 
@@ -382,6 +389,6 @@
         echo "<td>$expType[0]</td>";
         echo "<td>$summit[0]</td>";
-        
         createFormattedTableCell("", "", $mhpcc[0], $error, 0);
+        echo "<td>$dropped[0]</td>";
 
         echo "</tr>";