<?
  if (isset ($_GET["js"]) && $_GET["js"] == 1) {
    if (!isset ($_GET["keyword"]) || !strlen($_GET["keyword"]) ||
	!isset ($_GET["lang"]) || !strlen($_GET["lang"]) ||
	($_GET["lang"] != 'de' && $_GET["lang"] != 'en'))
      exit();
    $dbh = pg_pconnect ("", "", "web");
    if ($dbh) {
      $query = sprintf ("SELECT keyword FROM search_compiled "
		       ."WHERE keyword LIKE '%s%%' AND language = '%s' "
		       ."ORDER BY scores DESC,keyword LIMIT 10",
                        pg_escape_string($_GET["keyword"]), $_GET["lang"]);
      $sth = pg_exec ($dbh, $query);
      $result = array ();
      $count = 0;
      for ($nr=0; $nr < pg_NumRows ($sth) && $count < 85; $nr++) {
        $row = pg_fetch_array ($sth, $nr);
	if ($result)
	  $count += 2;
        $result[] = $row["keyword"];
	$count += strlen($row["keyword"]);
      }
      if ($count > 85)
        unset ($result[count($result)-1]);
      echo json_encode ($result) . "\n";
      exit();
    } else {
      exit();
    }
  }


  if ($_POST['keyword'] && ($_POST['site'] || $_GET['lang'])) {
    if (strpos($_POST['keyword'], 'http://') !== false || strlen($_POST['keyword']) > 50) {
      header ('Location: http://www.infodrom.org/');
      exit(0);
    }

    $dbh = pg_pconnect ("", "", "web");
    if ($dbh) {
      if ($_POST['site'] == "www.google.de" || $_GET['lang'] == "de") {
        $lang = "de";
        $site = "www.google.de";
      } else {
        $lang = "en";
        $site = "www.google.com";
      }

      $query = sprintf ("INSERT INTO search_keywords VALUES ('%s','%s','%s','%s')",
		        pg_escape_string($_POST['keyword']),
			$lang,
			date ("Y-m-d H:i"),
			$_SERVER['REMOTE_ADDR']);
      pg_exec ($dbh, $query);
    }

    $args = array();
    $args[] = "q=" . urlencode($_POST['keyword']);
    $args[] = "sitesearch=infodrom.org";
    $args[] = "domains=infodrom.org";
    $args[] = "sa=Google+Search";
    $url = sprintf("http://%s/search?%s", $site, implode ('&',$args));

    header ("Location: $url");
    mail ("joey@luonnotar.infodrom.org", "New Search Request",
"Site    : $site
Keywords: $_POST[keyword]
Host    : " . $_SERVER['REMOTE_ADDR'] . "
SCRIPT  : " . $_SERVER['SCRIPT_URI'] . "
URL     : " . $url . "\n", "From: Infodrom Webserver <www-data@luonnotar.infodrom.org>");
  } else {
    header ("Location: search.html");
  }
?>