Changeset 9111 for trunk/MagicSoft/Mars/datacenter/db/runinfo-aio.php

Timestamp:

08/07/08 20:00:19 (16 years ago)

Author:

Daniela Dorner

Message:

*** empty log message ***

File:

• trunk/MagicSoft/Mars/datacenter/db/runinfo-aio.php (modified) (1 diff)

trunk/MagicSoft/Mars/datacenter/db/runinfo-aio.php

@@ -50 +50 @@
 //                $query0 .= " RunData.fRunNumber as 'Run#' ";
 //                $query0 .= " Concat(RunData.fTelescopeNumber,':', RunData.fRunNumber,':', RunData.fFileNumber) as 'Run' ";
-                $query0 .= " Concat(RunData.fTelescopeNumber,':', RunData.fRunNumber,':', RunData.fFileNumber) as 'Tel:Run:File' ";
+                $query0 .= " Concat('M', RunData.fTelescopeNumber,':', LPAD(RunData.fRunNumber,8, ' '),'/', LPAD(RunData.fFileNumber, 3, ' ')) as 'Tel:Run/File' ";
 
                 if (empty($_GET["fSendTxt"]) && !empty($_GET["fLinks"]))