', fSourcename, '') "; $query0 .= " as 'Source' "; } $query0 .= " , fSourceKEY as 'KEY', fTest as 'Test' "; $query0 .= " FROM Source "; if ($_GET["fTest"]=="Off") $query0 .= " WHERE fTest='no'"; if ($_GET["fOff"]=="Off") { if (strpos($query0, " WHERE ")==FALSE) $query0 .= " WHERE "; else $query0 .= " AND "; $query0 .= " NOT (fSourceName like '%Off%')"; } if (!empty($_GET["fSortBy"])) { $query0 .= " ORDER BY " . substr($_GET["fSortBy"], 0, -1) . " "; if (substr($_GET["fSortBy"], -1)=="-") $query0 .= "DESC"; } else $query0 .= " ORDER BY fSourceKEY "; return $query0; } function InitGet($_GET) { if (empty($_GET["fTest"])) $_GET["fTest"]="Off"; if (empty($_GET["fOff"])) $_GET["fOff"]="Off"; if (empty($_GET["fLinks"])) $_GET["fLinks"]="On"; } function PrintForm($_GET) { printf("
\n"); printf("
\n"); printf("

\n"); printf(" \n"); CheckBox("fOff", "incl. offsources"); CheckBox("fTest", "incl. test-sources"); CheckBox("fLinks", "links"); printf("

\n"); ini_set("mysql.trace_mode", "Off"); ini_set("display_errors", "Off"); printf("   \n"); printf("   \n"); if (strchr($_SERVER["REQUEST_URI"], '?')!=FALSE) printf("   \n", $_SERVER["REQUEST_URI"]); printf("
\n"); printf("
\n"); printf("\n"); printf("\n"); printf("\n"); printf("\n"); } function PrintPage($html, $host, $user, $pw, $db, $alias, $rightalign) { $db_id = mysql_connect($host, $user, $pw); if ($db_id==FALSE) { printf("mysql_connect returned the following error: %s\n", mysql_error()); die(""); } mysql_select_db($db); $query0 = CreateQuery($_GET, $alias); $result0 = mysql_query($query0, $db_id); if ($result0) { if ($html=="1") PrintMagicTable($result0, $alias, $rightalign, "", "", $_GET); else PrintText($result0); mysql_free_result($result0); } mysql_close($db_id); if ($html=="1") printf("submitted query:
%s
", htmlspecialchars($query0)); } include ("include.php"); include ("db.php"); include ("magicdefs.php"); ini_set("display_errors", "On"); ini_set("mysql.trace_mode", "On"); if (!empty($_GET["fSendTxt"])) { header("Content-type: application/octet"); header("Content-Disposition: attachment; filename=query-result.txt"); PrintPage("0", $host, $user, $pw, $db, $alias, $rightalign); } else { echo (file_get_contents("index-header.html")); $environment = sizeof($_GET); InitGet($_GET); PrintForm($_GET); if ($environment==0) printf("No query submitted yet.
"); else PrintPage("1", $host, $user, $pw, $db, $alias, $rightalign); echo (file_get_contents("index-footer.html")); } ini_set("display_errors", "Off"); ini_set("mysql.trace_mode", "Off"); } ?>