Index: trunk/Mars/datacenter/db/run_comment.php
===================================================================
--- trunk/Mars/datacenter/db/run_comment.php	(revision 12779)
+++ trunk/Mars/datacenter/db/run_comment.php	(revision 12931)
@@ -11,9 +11,9 @@
     }
 
-    if (empty($_GET["fFileNumber"]))
-        $_GET["fFileNumber"]="001";
-
-    if (empty($_GET["fRunNumber"]))
-        $_GET["fRunNumber"]=date("Ymd", time()-(12*60*60));
+    if (empty($_GET["fRunID"]))
+        $_GET["fRunID"]="001";
+
+    if (empty($_GET["fNight"]))
+        $_GET["fNight"]=date("Ymd", time()-(12*60*60));
 
     if (strcmp($_GET["fMode"], "tooltip")!=0)
@@ -62,6 +62,6 @@
             if (strcmp($_GET["fMode"], "insert")==0)
             {
-                $query0.=", fRunNumber=".$_GET["fRunNumber"];
-                $query0.= ", fFileNumber=".$_GET["fFileNumber"];
+                $query0.=", fNight=".$_GET["fNight"];
+                $query0.= ", fRunID=".$_GET["fRunID"];
             }
             //for update
@@ -69,6 +69,6 @@
             {
                 $query2="SELECT fCommentKEY FROM RunComments ";
-                $query2.=" WHERE fRunNumber=".$_GET["fRunNumber"];
-                $query2.=" AND fFileNumber=".$_GET["fFileNumber"];
+                $query2.=" WHERE fNight=".$_GET["fNight"];
+                $query2.=" AND fRunID=".$_GET["fRunID"];
                 $query2.=" AND fComment='".str_replace("'", "\'", $_GET["fOldComment"])."'";
                 $result2=mysql_query($query2, $db_id);
@@ -111,6 +111,6 @@
         //insert field for run number
         printf("<form action=\"run_comment.php\" METHOD=\"GET\">\n");
-        printf("Run#&nbsp;(YYYYMMDD_FFF)&nbsp;<input name=\"fRunNumber\" type=\"text\" size=\"8\" maxlength=\"8\" value=\"%s\">\n", $_GET["fRunNumber"]);
-        printf("_ <input name=\"fFileNumber\" type=\"text\" size=\"3\" maxlength=\"3\" value=\"%s\">\n", $_GET["fFileNumber"]);
+        printf("Run#&nbsp;(YYYYMMDD_FFF)&nbsp;<input name=\"fNight\" type=\"text\" size=\"8\" maxlength=\"8\" value=\"%s\">\n", $_GET["fNight"]);
+        printf("_ <input name=\"fRunID\" type=\"text\" size=\"3\" maxlength=\"3\" value=\"%s\">\n", $_GET["fRunID"]);
         printf("<input type='hidden' name='fMode' value='%s'>", $_GET["fMode"]);
         printf("<input type='submit' value='Get Comments'><br><br>\n");
@@ -126,6 +126,6 @@
     mysql_select_db($db);
 
-    $query1 = "SELECT CONCAT(fRunNumber,'_', LPAD(fFileNumber, 3, 0)), fComment FROM RunComments ";
-    $query1 .= "WHERE fRunNumber=".$_GET["fRunNumber"]." AND fFileNumber=".$_GET["fFileNumber"];
+    $query1 = "SELECT CONCAT(fNight,'_', LPAD(fRunID, 3, 0)), fComment FROM RunComments ";
+    $query1 .= "WHERE fNight=".$_GET["fNight"]." AND fRunID=".$_GET["fRunID"];
     $result1=mysql_query($query1, $db_id);
     printf("Found %d comment(s).\n\n", mysql_num_rows($result1));
@@ -156,6 +156,6 @@
                 printf("<input type='hidden' name='fOldComment' value='%s'>\n", htmlspecialchars($row1[1],ENT_QUOTES));
                 printf("<input type='hidden' name='fMode' value='%s'>\n", $_GET["fMode"]);
-                printf("<input type='hidden' name='fRunNumber' value='%s'>\n", $_GET["fRunNumber"]);
-                printf("<input type='hidden' name='fFileNumber' value='%s'>\n", $_GET["fFileNumber"]);
+                printf("<input type='hidden' name='fNight' value='%s'>\n", $_GET["fNight"]);
+                printf("<input type='hidden' name='fRunID' value='%s'>\n", $_GET["fRunID"]);
                 printf("<input type='submit' value='Update Comment'>\n");
                 printf("</td>\n");
@@ -167,5 +167,5 @@
         }
         else
-            printf("%s_%s: %s\n", $_GET["fRunNumber"], $_GET["fFileNumber"], $row1[1]);
+            printf("%s_%s: %s\n", $_GET["fNight"], $_GET["fRunID"], $row1[1]);
     }
     //insert mode
@@ -173,11 +173,11 @@
     {
         printf("<tr BGCOLOR='#C0C0C0'>");
-        printf("<td>%s_%s</td>\n", $_GET["fRunNumber"], $_GET["fFileNumber"]);
+        printf("<td>%s_%s</td>\n", $_GET["fNight"], $_GET["fRunID"]);
         printf("<td>\n");
         printf("<form style='display:inline' action=\"run_comment.php\" METHOD=\"GET\">\n");
         printf("<input type='text' size='50' maxlength='255' name='fComment'>\n");
         printf("<input type='hidden' name='fMode' value='%s'>\n", $_GET["fMode"]);
-        printf("<input type='hidden' name='fRunNumber' value='%s'>\n", $_GET["fRunNumber"]);
-        printf("<input type='hidden' name='fFileNumber' value='%s'>\n", $_GET["fFileNumber"]);
+        printf("<input type='hidden' name='fNight' value='%s'>\n", $_GET["fNight"]);
+        printf("<input type='hidden' name='fRunID' value='%s'>\n", $_GET["fRunID"]);
         printf("<input type='submit' value='Insert Comment'>\n");
         printf("</form>\n");