Changeset 30361 for trunk/ippMonitor/def/mopsStatus.d

Timestamp:

Jan 25, 2011, 1:42:55 PM (15 years ago)

Author:

Serge CHASTEL

Message:

Added DS to mops status

File:

• trunk/ippMonitor/def/mopsStatus.d (modified) (2 diffs)

trunk/ippMonitor/def/mopsStatus.d

@@ -1 @@
-TABLE rawExp LEFT JOIN chipRun using(exp_id) LEFT JOIN camRun using(chip_id) LEFT JOIN fakeRun using(cam_id) LEFT JOIN warpRun using(fake_id) LEFT JOIN diffInputSkyfile AS diffInput ON diffInput.warp1 = warp_id LEFT JOIN diffRun AS diffInputRun ON diffInput.diff_id = diffInputRun.diff_id LEFT JOIN diffInputSkyfile AS diffTemplate ON diffTemplate.warp2 = warp_id LEFT JOIN diffRun AS diffTemplateRun ON diffTemplate.diff_id = diffTemplateRun.diff_id LEFT JOIN publishRun ON stage_id=diffInput.diff_id AND (client_id=1 OR client_id=5) LEFT JOIN magicDSRun ON magicDSRun.magic_ds_id=camRun.magicked
+TABLE rawExp LEFT JOIN chipRun using(exp_id) LEFT JOIN camRun using(chip_id) LEFT JOIN fakeRun using(camRun.cam_id) LEFT JOIN warpRun using(fake_id) LEFT JOIN diffInputSkyfile AS diffInput ON diffInput.warp1 = warp_id LEFT JOIN diffRun AS diffInputRun ON diffInput.diff_id = diffInputRun.diff_id LEFT JOIN diffInputSkyfile AS diffTemplate ON diffTemplate.warp2 = warp_id LEFT JOIN diffRun AS diffTemplateRun ON diffTemplate.diff_id = diffTemplateRun.diff_id LEFT JOIN publishRun ON stage_id=diffInput.diff_id AND (client_id=1 OR client_id=5) LEFT JOIN magicDSRun ON magicDSRun.magic_ds_id=camRun.magicked
 TITLE MOPS Status
 FILE mopsStatus.php
@@ -19 +19 @@
 FIELD chipRun.data_group,      5,    %s,     Data grp
 FIELD chip_id,                 5,    %d,     Chip ID (Stage 1)
-FIELD cam_id,                  5,    %d,     Cam ID (Stage 2)
+FIELD camRun.cam_id,                   5,    %d,     Cam ID (Stage 2)
 FIELD fake_id,                 5,    %d,     Fake ID (Stage 3)
 FIELD warp_id,                 5,    %d,     Warp ID (Stage 4)