2 if (isset ($_GET["js"]) && $_GET["js"] == 1) {
3 if (!isset ($_GET["keyword"]) || !strlen($_GET["keyword"]) ||
4 !isset ($_GET["lang"]) || !strlen($_GET["lang"]) ||
5 ($_GET["lang"] != 'de' && $_GET["lang"] != 'en'))
7 $dbh = pg_pconnect ("", "", "web");
9 $query = sprintf ("SELECT keyword FROM search_compiled "
10 ."WHERE keyword LIKE '%s%%' AND language = '%s' "
11 ."ORDER BY scores DESC,keyword LIMIT 10",
12 pg_escape_string($_GET["keyword"]), $_GET["lang"]);
13 $sth = pg_exec ($dbh, $query);
16 for ($nr=0; $nr < pg_NumRows ($sth) && $count < 85; $nr++) {
17 $row = pg_fetch_array ($sth, $nr);
20 $result[] = $row["keyword"];
21 $count += strlen($row["keyword"]);
24 unset ($result[count($result)-1]);
25 echo json_encode ($result) . "\n";
33 if ($_POST[keyword] && ($_POST[site] || $_GET[lang])) {
34 if (strpos($_POST['keyword'], 'http://') !== false || strlen($_POST['keyword']) > 50) {
35 header ('Location: http://www.infodrom.org/');
39 $dbh = pg_pconnect ("", "", "web");
41 if ($_POST[site] == "www.google.de" || $_GET[lang] == "de") {
43 $site = "www.google.de";
46 $site = "www.google.com";
49 $query = sprintf ("INSERT INTO search_keywords VALUES ('%s','%s','%s','%s')",
50 pg_escape_string($_POST[keyword]),
53 $_SERVER[REMOTE_ADDR]);
54 pg_exec ($dbh, $query);
58 $args[] = "q=" . urlencode($_POST[keyword]);
59 $args[] = "sitesearch=infodrom.org";
60 $args[] = "domains=infodrom.org";
61 $args[] = "sa=Google+Search";
62 $url = sprintf("http://%s/search?%s", $site, implode ('&',$args));
64 header ("Location: $url");
65 mail ("joey@luonnotar.infodrom.org", "New Search Request",
67 Keywords: $_POST[keyword]
68 Host : " . $_SERVER[REMOTE_ADDR] . "
69 SCRIPT : " . $_SERVER[SCRIPT_URI] . "
70 URL : " . $url . "\n", "From: Infodrom Webserver <www-data@luonnotar.infodrom.org>");
72 header ("Location: search.html");