", $query); $result=mysql_query($query, $db_id); $sequences=""; while ($row = mysql_fetch_row($result)) $sequences.= $row[0] . " "; mysql_free_result($result); mysql_close($db_id); $text=""; if (!empty($sequences)) $text.= str_replace(" ", "+", trim($sequences)); return $text; } function PrintDiv($host, $user, $pw, $db, $column, $tables, $num) { $list=GetList($host, $user, $pw, $db, $column, $tables); if (($_GET["prim"]==$column && empty($num)) || ($_GET["prim"]==$column && $num==3) || ($_GET["prim"]==$column && $num==4) || ($_GET["prim"]==$column && $_GET["plot"]=="val" && $num==2) || (empty($_GET["prim"]) && $column=="fSequenceFirst")) printf("
\n", $column, $num); else printf("\n"); } ini_set("display_errors", "On"); ini_set("mysql.trace_mode", "On"); echo (file_get_contents("index-header.html")); include("plotinclude.php"); //init if (empty($_GET["plot"])) $_GET["plot"]=""; if (empty($_GET["primstart"])) $_GET["primstart"]=""; if (empty($_GET["primstop"])) $_GET["primstop"]=""; if (empty($_GET["prim"])) $_GET["prim"]=""; if (empty($_GET["fSequenceFirstCol"])) $_GET["fSequenceFirstCol"]=""; if (empty($_GET["fSequenceFirstCol2"])) $_GET["fSequenceFirstCol2"]=""; if (empty($_GET["fSequenceFirstCol3"])) $_GET["fSequenceFirstCol3"]=""; if (empty($_GET["fRunNumberCol"])) $_GET["fRunNumberCol"]=""; if (empty($_GET["fRunNumberCol2"])) $_GET["fRunNumberCol2"]=""; if (empty($_GET["fRunNumberCol3"])) $_GET["fRunNumberCol3"]=""; if (empty($_GET["fDataSetNumberCol"])) $_GET["fDataSetNumberCol"]=""; if (empty($_GET["fDataSetNumberCol2"])) $_GET["fDataSetNumberCol2"]=""; if (empty($_GET["fDataSetNumberCol3"])) $_GET["fDataSetNumberCol3"]=""; if (empty($_GET["Start"])) $_GET["Start"]=""; if (empty($_GET["Stop"])) $_GET["Stop"]=""; if (empty($_GET["Start2"])) $_GET["Start2"]=""; if (empty($_GET["Stop2"])) $_GET["Stop2"]=""; if (empty($_GET["Start3"])) $_GET["Start3"]=""; if (empty($_GET["Stop3"])) $_GET["Stop3"]=""; if (empty($_GET["Start4"])) $_GET["Start4"]=""; if (empty($_GET["Stop4"])) $_GET["Stop4"]=""; if (empty($_GET["Set"])) $_GET["Set"]=""; if (empty($_GET["Set2"])) $_GET["Set2"]=""; if (empty($_GET["set"])) $_GET["set"]=""; if (empty($_GET["x"])) $totalx=640+410+60; else $totalx=$_GET["x"]+410+60; printf("
\n\n", $totalx); printf("\n"); // printf("\n"); printf("\n\n"); /* printf(""); */ printf("
\n"); printf("
\n"); printf("  vs primary  ", $_GET["plot"]=="prim" ? "checked" : ""); printf("  vs value

", ($_GET["plot"]=="val" || empty($_GET["plot"])) ? "checked" : ""); printf("\n"); printf("\n\n"); printf("\n\n"); printf("\n\n"); printf("\n\n\n\n\n\n"); printf("\n\n\n"); printf("
\n"); printf("\n"); printf(" \n "); printf(" from ", $_GET["primstart"]); printf(" to ", $_GET["primstop"]); printf("
\n"); foreach($prims as $primary => $column) PrintDiv($host, $user, $pw, $db, $column, $tables, ""); printf(" \n
\n "); printf(" from ", $_GET["Start"]); printf(" to \n", $_GET["Stop"]); printf("
\n"); foreach($prims as $primary => $column) PrintDiv($host, $user, $pw, $db, $column, $tables, "2"); // if ($_GET["plot"]=="val") if ($_GET["plot"]=="val" || empty($_GET["plot"])) printf(" \n
\n "); else printf("
\n
\nLimits
\n"); foreach($prims as $primary => $column) PrintDiv($host, $user, $pw, $db, $column, $tables, "3"); printf(" \n
\n "); printf(" from ", $_GET["Start3"]); printf(" to \n", $_GET["Stop3"]); printf("
\n"); foreach($prims as $primary => $column) PrintDiv($host, $user, $pw, $db, $column, $tables, "4"); printf(" \n
\n "); printf(" from ", $_GET["Start4"]); printf(" to \n", $_GET["Stop4"]); printf("
\n"); printf("
\n"); printf("  sequences  \n", $_GET["set"]=="sequences" ? "checked" : ""); printf("  datasets
\n", $_GET["set"]=="datasets" ? "checked" : ""); printf("
Set1: \n
\n
\n", $_GET["Set"]); if (empty($_GET["set"]) || $_GET["set"]=="sequences") printf("
Set2: \n
\n
\n", $_GET["Set2"]); else printf("\n
\n", $_GET["Set2"]); printf("
Plot format:   x = \n "); printf("  y = \n"); printf("

 \n"); printf("
\n"); printf("
"); printf("
\n"); printf("\n"); if (!empty($_GET)) { $img="plot.php?par=hallo"; foreach($_GET as $var => $val) { if ($var=="Set2" && $_GET["set"]=="datasets") continue; if ($var=="Set" && $_GET["set"]=="datasets" && !empty($val)) { $img.= "&Set=" . GetSequencesFromDataSet("1"); $img.= "&Set2=" . GetSequencesFromDataSet("2"); continue; } $img.="&".$var ."=".$val; } // printf("link: %s
", $img); printf("plot", $img); } printf("
\n"); printf("
some remarks:\n
    "); printf("
  • For Runs plotting the whole range (i.e. without giving a range or when giving a too large range) \n"); printf("doesn't work with ChartDirector.
  • \n"); printf("
  • In Set1 and Set2 Sets can be given:
    \n "); printf("If 'sequences' is selected e.g. on sequences in Set1 (displayed in blue) and off sequences in Set2 \n"); printf("(diplayed in red).
    \n "); printf("If 'datasets' is selected you can enter a dataset number as Set1. The on data is displayed in blue, \n"); printf("the off data in red.
    \n"); printf("   Please give the numbers with space as separator (e.g. 40004 40022).
    \n\n"); printf("
  • 0 is not accepted in the ranges fields, please write .0 or 00
  • \n"); printf("
  • Be aware, that plotting timestamps, e.g. fRunStart, and strings, e.g. fComment doesn't work.
  • \n"); printf("
\n
\n"); $query=GetQuery($tables, $joins, ""); printf("Q: %s
", $query); if (!empty($_GET["Set"])) { $query=GetQuery($tables, $joins, "Set"); printf("Q: %s
", $query); } if (!empty($_GET["Set2"])) { $query=GetQuery($tables, $joins, "Set2"); printf("Q: %s
", $query); } printf("
\n"); printf("
\n"); echo (file_get_contents("index-footer.html")); ini_set("display_errors", "Off"); ini_set("mysql.trace_mode", "Off"); } ?>