"; if (!CheckUsernameAndPassword($_SERVER['PHP_AUTH_USER'], $_SERVER['PHP_AUTH_PW'], GetLDAPOptions())) return; } if (!empty($_GET["fComment"])) { include("db2.php"); $db_id = mysql_pconnect($host, $user, $pw); if ($db_id==FALSE) { printf("mysql_connect returned the following error: %s\n", mysql_error()); die(""); } mysql_select_db($db); //for insert if (strcmp($_GET["fMode"], "insert")==0) $query0 = "INSERT RunComments SET "; //for update if (strcmp($_GET["fMode"], "update")==0) $query0 = "UPDATE RunComments SET "; //for both $query0.= " fComment='".str_replace("'", "\'", $_GET["fComment"])."'"; $query0.= ", fUser='".$_SERVER['PHP_AUTH_USER']."'"; //for insert if (strcmp($_GET["fMode"], "insert")==0) { $query0.=", fRunNumber=".$_GET["fRunNumber"]; $query0.= ", fFileNumber=".$_GET["fFileNumber"]; } //for update if (strcmp($_GET["fMode"], "update")==0) { $query2="SELECT fCommentKEY FROM RunComments "; $query2.=" WHERE fRunNumber=".$_GET["fRunNumber"]; $query2.=" AND fFileNumber=".$_GET["fFileNumber"]; $query2.=" AND fComment='".str_replace("'", "\'", $_GET["fOldComment"])."'"; $result2=mysql_query($query2, $db_id); $row2 = mysql_fetch_row($result2); $commentkey=$row2[0]; mysql_free_result($result2); $query0.=" WHERE fCommentKEY=".$commentkey; } $result0=mysql_query($query0, $db_id); mysql_close($db_id); } } // // display part // include("db.php"); if (strcmp($_GET["fMode"], "tooltip")!=0) { printf("With this page, you can \n"); //view mode if (strcmp($_GET["fMode"], "view")==0) printf("view,\n"); else printf("view,\n", str_replace($_GET["fMode"], 'view', $_SERVER['REQUEST_URI'])); //update mode if (strcmp($_GET["fMode"], "update")==0) printf("update and\n"); else printf("update and \n", str_replace($_GET["fMode"], 'update', $_SERVER['REQUEST_URI'])); //insert mode if (strcmp($_GET["fMode"], "insert")==0) printf("insert\n"); else printf("insert \n", str_replace($_GET["fMode"], 'insert', $_SERVER['REQUEST_URI'])); printf("entries in the table RunComment from the DB %s.

\n", $db); //insert field for run number printf("

\n"); printf("Run# (YYYYMMDD_FFF) \n", $_GET["fRunNumber"]); printf("_ \n", $_GET["fFileNumber"]); printf("", $_GET["fMode"]); printf("

\n"); printf("

\n"); } $db_id = mysql_pconnect($host, $user, $pw); if ($db_id==FALSE) { printf("mysql_connect returned the following error: %s\n", mysql_error()); die(""); } mysql_select_db($db); $query1 = "SELECT CONCAT(fRunNumber,'_', LPAD(fFileNumber, 3, 0)), fComment FROM RunComments "; $query1 .= "WHERE fRunNumber=".$_GET["fRunNumber"]." AND fFileNumber=".$_GET["fFileNumber"]; $result1=mysql_query($query1, $db_id); printf("Found %d comment(s).\n\n", mysql_num_rows($result1)); if (strcmp($_GET["fMode"], "tooltip")!=0) { printf("
\n"); printf(""); $col = FALSE; printf(""); } while ($row1 = mysql_fetch_row($result1)) { if (strcmp($_GET["fMode"], "tooltip")!=0) { if (!$col) printf("\n"); else printf("\n"); $col = !$col; if (strcmp($_GET["fMode"], "update")==0) printf("\n"); printf("\n", $row1[0]); if (strcmp($_GET["fMode"], "update")==0) { printf("\n"); printf("\n"); } else printf("\n", $row1[1]); printf("\n"); } else printf("%s_%s: %s\n", $_GET["fRunNumber"], $_GET["fFileNumber"], $row1[1]); } //insert mode if (strcmp($_GET["fMode"], "insert")==0) { printf(""); printf("\n", $_GET["fRunNumber"], $_GET["fFileNumber"]); printf("\n"); printf("\n"); } if (strcmp($_GET["fMode"], "tooltip")!=0) printf("

Run#	Comment
\n%s\n	\n"); printf("\n", htmlspecialchars($row1[1],ENT_QUOTES)); printf("\n", htmlspecialchars($row1[1],ENT_QUOTES)); printf("\n", $_GET["fMode"]); printf("\n", $_GET["fRunNumber"]); printf("\n", $_GET["fFileNumber"]); printf("\n"); printf("	\n%s\n
%s_%s	\n"); printf(" \n"); printf("\n"); printf("\n", $_GET["fMode"]); printf("\n", $_GET["fRunNumber"]); printf("\n", $_GET["fFileNumber"]); printf("\n"); printf(" \n"); printf("

"); if (strcmp($_GET["fMode"], "update")==0) printf("Remark: You can update only one comment at once."); mysql_free_result($result1); mysql_close($db_id); if (strcmp($_GET["fMode"], "tooltip")!=0) echo (file_get_contents("index-footer.html")); ini_set("display_errors", "Off"); ini_set("mysql.trace_mode", "Off"); } ?>