=".$counter; if ($_GET["fStatusDate"]!="") $query0.=" AND (fValidFrom < '".$_GET["fStatusDate"]."' OR fValidFrom like '".$_GET["fStatusDate"]."%') "; } $query0.=" ORDER BY MyIndex "; $result0=mysql_query($query0, $db_id); if ($_GET["fGetValCase"]==1) { printf("\n"); printf("\n"); printf("\n", $_GET["fProgram"], $_GET["fKey"], $key1, $key2, $type, $min, $max, $descr); } //checkboxes to show/hide part of the table if ($_GET["fGetValCase"]==1)//show only in edit mode { printf("Show:\n"); printf("indices\n"); printf("validsince\n"); printf("user\n"); } if ($_GET["fGetValCase"]==1)//show only in edit mode $generalshowhide=''; else $generalshowhide='none'; printf("\n", $_GET["fGetValCase"]); printf(""); //printf("\n",$_GET["fGetValCase"], $generalshowhide); //printf("\n", $_GET["fGetValCase"], $generalshowhide); printf("\n",$_GET["fGetValCase"]); printf("\n", $_GET["fGetValCase"]); printf("\n"); //printf("\n"); printf("\n"); printf("\n"); printf("\n"); printf("\n"); printf("\n", $_GET["fGetValCase"], $generalshowhide); printf("\n", $_GET["fGetValCase"], $generalshowhide); printf("\n", $_GET["fGetValCase"], $generalshowhide); if ($_GET["fGetValCase"]==1)//show only in edit mode printf("\n"); //printf("\n", $_GET["fGetValCase"], $generalshowhide); printf("\n", $_GET["fGetValCase"], $generalshowhide); printf("\n"); $maxindex=0; if ($result0) while ($row0 = mysql_fetch_row($result0)) { if ($_GET["fGetValCase"]==1) { if ($row0[6]==$counter) printf("\n", $row0[0]); else printf("\n", $row0[0]); } else { if ($_GET["fGetValCase"]==2) printf("\n", $_GET["fGetValCase"], $row0[12]); if ($_GET["fGetValCase"]==3) printf("\n", $_GET["fGetValCase"], $row0[12]); } //printf("\n", // $_GET["fGetValCase"], $generalshowhide, $row0[0], $row0[12], $row0[6], $_GET["fGetValCase"], $row0[0], $row0[12]); printf("\n", $_GET["fGetValCase"], $row0[0], $row0[12], $row0[6], $_GET["fGetValCase"], $row0[0], $row0[12]); //valid from //if (strcmp('0000-00-00 00:00:00', $row0[1])==0) // printf("\n", $_GET["fGetValCase"], $generalshowhide, $row0[0], $row0[1]); //else // printf("\n", $_GET["fGetValCase"], $generalshowhide, $row0[1]); if (strcmp('0000-00-00 00:00:00', $row0[1])==0) printf("\n", $_GET["fGetValCase"], $row0[0], $row0[1]); else printf("\n", $_GET["fGetValCase"], $row0[1]); //program printf("\n", $row0[0], $row0[2]); //keys //printf("\n", $row0[0], $row0[3]); printf("\n", $row0[0], $row0[10]); printf("\n", $row0[0], $row0[11]); //value // string -> align left // rest -> align right if (strcmp('string', $row0[7])==0) printf("\n", $row0[0], $row0[4]); else printf("\n", $row0[0], $row0[4]); //type printf("\n", $row0[0], $row0[7]); //min printf("\n", $_GET["fGetValCase"], $generalshowhide, $row0[0], $row0[8]); //max printf("\n", $_GET["fGetValCase"], $generalshowhide, $row0[0], $row0[9]); //descripton printf("\n", $_GET["fGetValCase"], $generalshowhide, $row0[0], $row0[5]); //action if ($_GET["fGetValCase"]==1)//show only in edit mode { if ($row0[6]==$counter) { printf("\n"); } else printf("\n", $row0[0]); } //user //printf("\n", $_GET["fGetValCase"], $generalshowhide, $row0[0], $row0[13]); printf("\n", $_GET["fGetValCase"], $row0[0], $row0[13]); printf("\n"); if ($row0[0]>$maxindex) $maxindex=$row0[0]; } printf("
Idx/Orig/CtrValid sinceProgramKeyKey1Key2ValueTypeMinMaxDescriptionActionUser
%s / %s / %s %s %s %s%s%s%s%s%s%s%s%s%s\n", $row0[0]); printf("\n", $row0[0]); printf("\n", $_GET["fProgram"], $_GET["fKey"], $key1, $key2, $type, $min, $max, $descr); //missing here descr(, key1, key2, val?) // in po.js: add descr, key1, key2, min, max in AddRow printf("%s
\n"); if ($_GET["fGetValCase"]==1) { printf("\n"); printf("\n"); printf("\n", $_GET["fProgram"], $_GET["fKey"], $key1, $key2, $type, $min, $max, $descr); } /* else { printf("Show:\n"); printf("indices\n", $_GET["fGetValCase"], $_GET["fGetValCase"]); printf("validsince\n", $_GET["fGetValCase"], $_GET["fGetValCase"]); printf("description\n", $_GET["fGetValCase"], $_GET["fGetValCase"]); printf("min\n", $_GET["fGetValCase"], $_GET["fGetValCase"]); printf("max\n", $_GET["fGetValCase"], $_GET["fGetValCase"]); } */ if ($_GET["fGetValCase"]==3) printf("\n", $maxindex); else printf("\n", $maxindex); if ($result0) mysql_free_result($result0); mysql_close($db_id); ini_set("display_errors", "Off"); ini_set("mysql.trace_mode", "Off"); } ?>