Index: trunk/ippMonitor/Makefile.in
===================================================================
--- trunk/ippMonitor/Makefile.in	(revision 33845)
+++ trunk/ippMonitor/Makefile.in	(revision 33846)
@@ -47,4 +47,6 @@
 $(DESTWWW)/ipp.dvodb.dat \
 $(DESTWWW)/ipp.dvodb.php \
+$(DESTWWW)/ipp.czar.dat \
+$(DESTWWW)/ipp.czar.php \
 $(DESTWWW)/phptest.php \
 $(DESTWWW)/site.php \
@@ -222,4 +224,9 @@
 $(DESTWWW)/minidvodbCopy.php \
 $(DESTWWW)/minidvodbProcessed.php \
+$(DESTWWW)/mergedvodbRun.php \
+$(DESTWWW)/mergedvodbCopy.php \
+$(DESTWWW)/mergedvodbProcessed.php \
+$(DESTWWW)/dvodbStatus.php \
+$(DESTWWW)/dvodbFaulted.php \
 $(DESTWWW)/addRunRun.php \
 $(DESTWWW)/addRunProcessed.php \
Index: trunk/ippMonitor/def/addRunRun.d
===================================================================
--- trunk/ippMonitor/def/addRunRun.d	(revision 33845)
+++ trunk/ippMonitor/def/addRunRun.d	(revision 33846)
@@ -9,19 +9,18 @@
 
 #     field                   size  format  name         show    link to                  extras
-FIELD distinct(addRun.add_id),        5, %d,     add ID
+FIELD addRun.add_id,       5, %d,     addID
 FIELD addRun.stage,        5, %s,     stage
-FIELD addRun.stage_id,          5, %d,     stage ID
-FIELD addRun.add_id,        5, %d,     add ID
+FIELD addRun.stage_id,     5, %d,     stageID
+FIELD addRun.stage_extra1, 5, %d,     stageExtra1
+#FIELD addRun.add_id,       5, %d,     addID
 FIELD addRun.state,        5, %s,     state
-FIELD addRun.workdir,        5, %s,     workdir
-FIELD addRun.reduction,        5, %s,     reduction
+FIELD addRun.workdir,      5, %s,     workdir
+FIELD addRun.reduction,    5, %s,     reduction
 FIELD addRun.label,        5, %s,     label
-FIELD addRun.data_group,        5, %s,     data_group
+FIELD addRun.data_group,   5, %s,     data_group
 FIELD addRun.dvodb,        5, %s,     dvodb
-FIELD addRun.note,        5, %s,     note
-FIELD addRun.image_only,        5, %d,   image_only
-FIELD addRun.minidvodb,        5, %d,     minidvodb
-FIELD addRun.minidvodb_group,        5, %s,     minidvodb_group
-FIELD addRun.minidvodb_name,        5, %s,     minidvodb_name
-
-
+FIELD addRun.note,         5, %s,     note
+FIELD addRun.image_only,   5, %d,   image_only
+FIELD addRun.minidvodb,    5, %d,     minidvodb
+FIELD addRun.minidvodb_group, 5, %s,     minidvodb_group
+FIELD addRun.minidvodb_name,  5, %s,     minidvodb_name
Index: trunk/ippMonitor/def/dvodbFaulted.d
===================================================================
--- trunk/ippMonitor/def/dvodbFaulted.d	(revision 33846)
+++ trunk/ippMonitor/def/dvodbFaulted.d	(revision 33846)
@@ -0,0 +1,25 @@
+TABLE minidvodbRun LEFT JOIN minidvodbProcessed using(minidvodb_id) LEFT JOIN mergedvodbRun using(minidvodb_id) LEFT JOIN mergedvodbProcessed using(merge_id)
+TITLE dvodb Status: either mini or merge is faulted
+FILE dvodbFaulted.php
+MENU ipp.dvodb.dat
+
+
+WHERE (minidvodbProcessed.fault > 0 or mergedvodbProcessed.fault > 0)
+
+#UNRESTRICTED WHERE minidvodbRun.creation_date >= DATE_ADD(DATE (NOW()), INTERVAL -30 DAY) 
+
+#     field                    width format  name          show         link to                   extras
+FIELD minidvodbRun.minidvodb_id, 5,   %d,     minidvodb_id
+FIELD minidvodbRun.minidvodb_name, 	       5,    %s,     minidvodb_name
+FIELD minidvodbRun.state, 	       5,    %s,     minidvodb_state
+FIELD minidvodbProcessed.fault,      5,    %d,	     minidvodb fault
+FIELD mergedvodbRun.merge_id, 5,   %d,     merge_id
+FIELD mergedvodbRun.mergedvodb, 	       5,    %s,     mergedvodb
+FIELD mergedvodbRun.state, 	       5,    %s,     mergedvodb_state
+FIELD mergedvodbProcessed.fault,      5,    %d,	     mergedvodb fault
+
+
+
+#MODE summary
+#GROUP BY minidvodbRun.minidvodb_id
+#GROUP rawExp.exp_id
Index: trunk/ippMonitor/def/dvodbStatus.d
===================================================================
--- trunk/ippMonitor/def/dvodbStatus.d	(revision 33846)
+++ trunk/ippMonitor/def/dvodbStatus.d	(revision 33846)
@@ -0,0 +1,25 @@
+TABLE minidvodbRun LEFT JOIN minidvodbProcessed using(minidvodb_id) LEFT JOIN mergedvodbRun using(minidvodb_id) LEFT JOIN mergedvodbProcessed using(merge_id)
+TITLE dvodb Status
+FILE dvodbStatus.php
+MENU ipp.dvodb.dat
+
+
+#WHERE (minidvodbProcessed.fault > 0 or mergedvodbProcessed.fault > 0)
+
+#UNRESTRICTED WHERE minidvodbRun.creation_date >= DATE_ADD(DATE (NOW()), INTERVAL -30 DAY) 
+
+#     field                    width format  name          show         link to                   extras
+FIELD minidvodbRun.minidvodb_id, 5,   %d,     minidvodb_id
+FIELD minidvodbRun.minidvodb_name, 	       5,    %s,     minidvodb_name
+FIELD minidvodbRun.state, 	       5,    %s,     minidvodb_state
+FIELD minidvodbProcessed.fault,      5,    %d,	     minidvodb fault
+FIELD mergedvodbRun.merge_id, 5,   %d,     merge_id
+FIELD mergedvodbRun.mergedvodb, 	       5,    %s,     mergedvodb
+FIELD mergedvodbRun.state, 	       5,    %s,     mergedvodb_state
+FIELD mergedvodbProcessed.fault,      5,    %d,	     mergedvodb fault
+
+
+
+#MODE summary
+#GROUP BY minidvodbRun.minidvodb_id
+#GROUP rawExp.exp_id
Index: trunk/ippMonitor/def/exposureStatus.d
===================================================================
--- trunk/ippMonitor/def/exposureStatus.d	(revision 33845)
+++ trunk/ippMonitor/def/exposureStatus.d	(revision 33846)
@@ -2,5 +2,5 @@
 TITLE Exposures Status
 FILE exposureStatus.php
-MENU ipp.imfiles.dat
+MENU ipp.czar.dat
 
 WHERE object != 'ENGINEERING'
Index: trunk/ippMonitor/def/gpc1MysqlProcessList.d
===================================================================
--- trunk/ippMonitor/def/gpc1MysqlProcessList.d	(revision 33845)
+++ trunk/ippMonitor/def/gpc1MysqlProcessList.d	(revision 33846)
@@ -2,5 +2,5 @@
 TITLE GPC 1 MySql Process List
 FILE gpc1MysqlProcessList.php
-MENU ipp.imfiles.dat
+MENU ipp.czar.dat
 
 FIELD ID,   5,  %d, Process ID
Index: trunk/ippMonitor/def/maskStats.d
===================================================================
--- trunk/ippMonitor/def/maskStats.d	(revision 33845)
+++ trunk/ippMonitor/def/maskStats.d	(revision 33846)
@@ -2,5 +2,5 @@
 TITLE Mask Stats
 FILE  maskStats.php
-MENU  ipp.imfiles.dat
+MENU  ipp.czar.dat
 
 WHERE rawExp.exp_id = chipRun.exp_id
Index: trunk/ippMonitor/def/mergedvodbCopy.d
===================================================================
--- trunk/ippMonitor/def/mergedvodbCopy.d	(revision 33846)
+++ trunk/ippMonitor/def/mergedvodbCopy.d	(revision 33846)
@@ -0,0 +1,19 @@
+TABLE mergedvodbCopy 
+TITLE mergedvodb Copies
+FILE  mergedvodbCopy.php
+MENU  ipp.dvodb.dat
+
+# the following WHERE clauses are added to all queries joined by AND
+
+#WHERE mergedvodbcopy_id >= 0
+
+#     field                   size  format  name         show    link to                  extras
+FIELD mergedvodbCopy.mergedvodbcopy_id,        5, %d,     merge Copy ID
+FIELD mergedvodbCopy.merge_id,        5, %d,     merge ID
+FIELD mergedvodbCopy.mergedvodb_rsync_path,          25, %s,     rsync path
+FIELD mergedvodbCopy.destination_host,       5, %s,     destinatin host
+FIELD mergedvodbCopy.fault,    5, %s,     Fault
+FIELD mergedvodbCopy.state,          5, %s,     State
+FIELD mergedvodbCopy.epoch,          5, %T,    Epoch
+FIELD mergedvodbCopy.dtime,        5, %d,     dtime
+
Index: trunk/ippMonitor/def/mergedvodbProcessed.d
===================================================================
--- trunk/ippMonitor/def/mergedvodbProcessed.d	(revision 33846)
+++ trunk/ippMonitor/def/mergedvodbProcessed.d	(revision 33846)
@@ -0,0 +1,21 @@
+TABLE mergedvodbRun, mergedvodbProcessed 
+TITLE Processed mergedvodbs
+FILE  mergedvodbProcessed.php
+MENU  ipp.dvodb.dat
+
+# the following WHERE clauses are added to all queries joined by AND
+
+WHERE mergedvodbRun.merge_id = mergedvodbProcessed.merge_id
+
+#     field                   size  format  name         show    link to                  extras
+FIELD mergedvodbRun.merge_id,        5, %d,     merge ID
+FIELD mergedvodbRun.minidvodb_id,          5, %d,     minidvodb_id
+FIELD mergedvodbRun.mergedvodb,       5, %s,     mergedvodb
+FIELD mergedvodbProcessed.merge_order,        5, %d,     merge order
+FIELD mergedvodbProcessed.dtime_verify,        5, %d,     verify time
+FIELD mergedvodbProcessed.dtime_merge,        5, %d,     merge time
+FIELD mergedvodbProcessed.dtime_script,        5, %d,     script time
+FIELD state,          5, %s,    State
+FIELD mergedvodbProcessed.fault,        5, %d,     Fault
+FIELD epoch,        5, %T,     epoch
+
Index: trunk/ippMonitor/def/mergedvodbRun.d
===================================================================
--- trunk/ippMonitor/def/mergedvodbRun.d	(revision 33846)
+++ trunk/ippMonitor/def/mergedvodbRun.d	(revision 33846)
@@ -0,0 +1,21 @@
+TABLE mergedvodbRun, minidvodbRun 
+TITLE mergedvodb Runs
+FILE  mergedvodbRun.php
+MENU  ipp.dvodb.dat
+
+# the following WHERE clauses are added to all queries joined by AND
+
+WHERE merge_id >= 0 
+WHERE mergedvodbRun.minidvodb_id = minidvodbRun.minidvodb_id
+
+#     field                   size  format  name         show    link to                  extras
+FIELD mergedvodbRun.merge_id,        5, %d,     merge ID
+FIELD mergedvodbRun.minidvodb_id,        5, %d,     minidvodb ID
+FIELD minidvodbRun.minidvodb_name,       10, %s, minidvodb_name
+FIELD mergedvodbRun.mergedvodb,          5, %s,     mergedvodb
+###FIELD mergedvodbRun.mergedvodb_group,       5, %s,     mergedvodb_group
+FIELD mergedvodbRun.mergedvodb_path,    25, %s,     mergedvodb_path
+#FIELD mergedvodbRun.mergedvodb_path,          25, %s,     mergedvodb_path
+FIELD mergedvodbRun.state,          5, %s,    State
+FIELD mergedvodbRun.creation_date,        5, %T,     epoch
+
Index: trunk/ippMonitor/def/minidvodbProcessed.d
===================================================================
--- trunk/ippMonitor/def/minidvodbProcessed.d	(revision 33845)
+++ trunk/ippMonitor/def/minidvodbProcessed.d	(revision 33846)
@@ -9,13 +9,10 @@
 
 #     field                   size  format  name         show    link to                  extras
-FIELD distinct(minidvodbRun.minidvodb_id),        5, %d,     Minidvodb ID
-
+FIELD minidvodbRun.minidvodb_id,        5, %d,     Minidvodb ID
 FIELD minidvodbRun.minidvodb_name,          5, %s,     minidvodb_name
 FIELD minidvodbRun.minidvodb_group,       5, %s,     minidvodb_group
-FIELD minidvodbProcessed.merge_order,        5, %d,     Merge Order
 FIELD minidvodbProcessed.dtime_resort,        5, %d,     resort time
 FIELD minidvodbProcessed.dtime_relphot,        5, %d,     relphot time
-FIELD minidvodbProcessed.dtime_merge,        5, %d,     dvomerge time
-FIELD minidvodbProcessed.mergedvodb_path,          25, %s,     mergedvodb_path
+FIELD minidvodbProcessed.dtime_script,        5, %d,     script time
 FIELD state,          5, %s,    State
 FIELD minidvodbProcessed.fault,        5, %d,     Fault
Index: trunk/ippMonitor/def/minidvodbRun.d
===================================================================
--- trunk/ippMonitor/def/minidvodbRun.d	(revision 33845)
+++ trunk/ippMonitor/def/minidvodbRun.d	(revision 33846)
@@ -9,9 +9,9 @@
 
 #     field                   size  format  name         show    link to                  extras
-FIELD distinct(minidvodbRun.minidvodb_id),        5, %d,     Minidvodb ID
+FIELD minidvodbRun.minidvodb_id,        5, %d,     Minidvodb ID
 FIELD minidvodbRun.minidvodb_name,          5, %s,     minidvodb_name
 FIELD minidvodbRun.minidvodb_group,       5, %s,     minidvodb_group
 FIELD minidvodbRun.minidvodb_path,    25, %s,     minidvodb_path
-FIELD minidvodbRun.mergedvodb_path,          25, %s,     mergedvodb_path
+#FIELD minidvodbRun.mergedvodb_path,          25, %s,     mergedvodb_path
 FIELD state,          5, %s,    State
 FIELD creation_date,        5, %T,     epoch
Index: trunk/ippMonitor/def/mopsStatus.d
===================================================================
--- trunk/ippMonitor/def/mopsStatus.d	(revision 33845)
+++ trunk/ippMonitor/def/mopsStatus.d	(revision 33846)
@@ -2,5 +2,5 @@
 TITLE MOPS Status
 FILE mopsStatus.php
-MENU ipp.imfiles.dat
+MENU ipp.czar.dat
 #WHERE rawExp.obs_mode!='ENGINEERING'
 
Index: trunk/ippMonitor/raw/czartool_ipptopsps.php
===================================================================
--- trunk/ippMonitor/raw/czartool_ipptopsps.php	(revision 33845)
+++ trunk/ippMonitor/raw/czartool_ipptopsps.php	(revision 33846)
@@ -23,5 +23,5 @@
 
 if ($ID['menu']) {$myMenu = $ID['menu'];}
-else {$myMenu = "ipp.imfiles.dat";}
+else {$myMenu = "ipp.czar.dat";}
 
 menu($myMenu, 'Czartool on '.$lastUpdateTime, 'ipp.css', $ID['link'], $ID['proj']);
Index: trunk/ippMonitor/raw/czartool_labels.php
===================================================================
--- trunk/ippMonitor/raw/czartool_labels.php	(revision 33845)
+++ trunk/ippMonitor/raw/czartool_labels.php	(revision 33846)
@@ -23,5 +23,5 @@
 
 if ($ID['menu']) {$myMenu = $ID['menu'];}
-else {$myMenu = "ipp.imfiles.dat";}
+else {$myMenu = "ipp.czar.dat";}
 
 menu($myMenu, 'Czartool on '.$lastUpdateTime, 'ipp.css', $ID['link'], $ID['proj']);
Index: trunk/ippMonitor/raw/ipp.czar.dat
===================================================================
--- trunk/ippMonitor/raw/ipp.czar.dat	(revision 33846)
+++ trunk/ippMonitor/raw/ipp.czar.dat	(revision 33846)
@@ -0,0 +1,13 @@
+input     | ipp.menu.dat 
+
+menutop   | menutop      | plain   |     |   
+
+menulink   | menuselect      | link    | czartool - standard          | czartool_labels.php
+menulink   | menuselect      | link    | czartool - ipptopsps         | czartool_ipptopsps.php
+menulink   | menuselect      | link    | mask stats                   | maskStats.php
+menulink   | menuselect      | link    | night summary                | nightSummary.php
+menutop   | menutop      | plain   |                         | 
+menulink  | menuselect   | link    | Exposures Status             | exposureStatus.php
+menulink  | menuselect   | link    | MOPS Exposures Status        | mopsStatus.php
+menulink  | menuselect   | link    | GPC1 MySql ProcessList            | gpc1MysqlProcessList.php
+
Index: trunk/ippMonitor/raw/ipp.czar.php
===================================================================
--- trunk/ippMonitor/raw/ipp.czar.php	(revision 33846)
+++ trunk/ippMonitor/raw/ipp.czar.php	(revision 33846)
@@ -0,0 +1,17 @@
+<?php 
+
+include 'ipp.php';
+
+$ID = checkID ();
+
+// require an explicit project
+if (! $ID['proj']) { projectform ($ID); }
+
+menu('ipp.czar.dat', 'useful tools for the czar', 'ipp.css', $ID['link'], $ID['proj']);
+
+// document body
+echo "Czar<br>\n";
+
+menu_end();
+
+?>
Index: trunk/ippMonitor/raw/ipp.dvodb.dat
===================================================================
--- trunk/ippMonitor/raw/ipp.dvodb.dat	(revision 33845)
+++ trunk/ippMonitor/raw/ipp.dvodb.dat	(revision 33846)
@@ -9,5 +9,15 @@
              
 menulink  | menuselect   | link    | minidvodbRun              | minidvodbRun.php
-menulink  | menuselect 	 | link    | minidvodbProcessed         | minidvodbProcessed.php            
+menulink  | menuselect 	 | link    | minidvodbProcessed         | minidvodbProcessed.php    
 menulink  | menuselect 	 | link    | minidvodbCopy               | minidvodbCopy.php            
 
+menutop   | menutop      | plain   | &nbsp;   |
+
+menulink  | menuselect   | link    | mergedvodbRun              | mergedvodbRun.php
+menulink  | menuselect 	 | link    | mergedvodbProcessed         | mergedvodbProcessed.php    
+menulink  | menuselect 	 | link    | mergedvodbCopy               | mergedvodbCopy.php            
+
+menutop   | menutop      | plain   | &nbsp;   |
+
+menulink  | menuselect 	 | link    | dvodbStatus               | dvodbStatus.php
+menulink  | menuselect 	 | link    | dvodbFaulted               | dvodbFaulted.php            
Index: trunk/ippMonitor/raw/ipp.menu.dat
===================================================================
--- trunk/ippMonitor/raw/ipp.menu.dat	(revision 33845)
+++ trunk/ippMonitor/raw/ipp.menu.dat	(revision 33846)
@@ -27,3 +27,4 @@
 menutop   | menutop      | link    | Calibration                  | ipp.cal.php
 menutop   | menutop      | link    | Plots              	  | ipp.plots.php
+menutop   | menutop      | link    | Czar           		  | ipp.czar.php
 menutop   | menutop      | link    | Admin and Debug              | ipp.imfiles.php
Index: trunk/ippMonitor/raw/nightSummary.php
===================================================================
--- trunk/ippMonitor/raw/nightSummary.php	(revision 33845)
+++ trunk/ippMonitor/raw/nightSummary.php	(revision 33846)
@@ -52,5 +52,5 @@
   $myMenu = $ID['menu'];
 } else {
-  $myMenu = "ipp.imfiles.dat";
+  $myMenu = "ipp.czar.dat";
 }