<?php
/*******************************************
* Sphider Version 1.3.x
* Moded by Soul / Ljuska.org 2010
* This program is licensed under the GNU GPL.
* By Ando Saabas          ando(a t)cs.ioc.ee
********************************************/
//error_reporting(E_ALL ^ E_NOTICE ^ E_WARNING);
error_reporting(E_ALL);
$include_dir = "./include";
include ("$include_dir/commonfuncs.php");
//extract(getHttpVars());

if (isset($_GET['query']))
    $query = $_GET['query'];
if (isset($_GET['search']))
    $search = $_GET['search'];
if (isset($_GET['domain']))
    $domain = $_GET['domain'];
if (isset($_GET['type']))
    $type = $_GET['type'];
if (isset($_GET['catid']))
    $catid = $_GET['catid'];
if (isset($_GET['category']))
    $category = $_GET['category'];
if (isset($_GET['results']))
    $results = $_GET['results'];
if (isset($_GET['start']))
    $start = $_GET['start'];
if (isset($_GET['adv']))
    $adv = $_GET['adv'];


$include_dir = "./include";
$template_dir = "./templates";
$settings_dir = "./settings";
$language_dir = "./languages";


require_once("$settings_dir/database.php");
require_once("$language_dir/en-language.php");
require_once("$include_dir/searchfuncs.php");
require_once("$include_dir/categoryfuncs.php");


include "$settings_dir/conf.php";

include "$template_dir/$template/header.html";
include "$language_dir/$language-language.php";


if ($type != "or" && $type != "and" && $type != "phrase") {
    $type = "and";
}

if (preg_match("/[^a-z0-9-.]+/", $domain)) {
    $domain="";
}


if ($results != "") {
    $results_per_page = $results;
}

if (get_magic_quotes_gpc()==1) {
    $query = stripslashes($query);
}

if (!is_numeric($catid)) {
    $catid = "";
}

if (!is_numeric($category)) {
    $category = "";
}



if ($catid && is_numeric($catid)) {

    $tpl_['category'] = sql_fetch_all('SELECT category FROM '.$mysql_table_prefix.'categories WHERE category_id='.(int)$_REQUEST['catid']);
}

$count_level0 = sql_fetch_all('SELECT count(*) FROM '.$mysql_table_prefix.'categories WHERE parent_num=0');
$has_categories = 0;

if ($count_level0) {
    $has_categories = $count_level0[0][0];
}



require_once("$template_dir/$template/search_form.html");


function getmicrotime(){
    list($usec, $sec) = explode(" ",microtime());
    return ((float)$usec + (float)$sec);
    }

function getStatistics() {
global $mysql_table_prefix;
$stats = array();
$keywordQuery = "select count(keyword_id) from ".$mysql_table_prefix."keywords";
$linksQuery = "select count(url) from ".$mysql_table_prefix."links";
$siteQuery = "select count(site_id) from ".$mysql_table_prefix."sites";
$categoriesQuery = "select count(category_id) from ".$mysql_table_prefix."categories";

$result = mysql_query($keywordQuery);
echo mysql_error();
if ($row=mysql_fetch_array($result)) {
$stats['keywords']=$row[0];
}
$result = mysql_query($linksQuery);
echo mysql_error();
if ($row=mysql_fetch_array($result)) {
$stats['links']=$row[0];
}
for ($i=0;$i<=15; $i++) {
$char = dechex($i);
$result = mysql_query("select count(link_id) from ".$mysql_table_prefix."link_keyword$char");
echo mysql_error();
if ($row=mysql_fetch_array($result)) {
$stats['index']+=$row[0];
}
}
$result = mysql_query($siteQuery);
echo mysql_error();
if ($row=mysql_fetch_array($result)) {
$stats['sites']=$row[0];
}
$result = mysql_query($categoriesQuery);
echo mysql_error();
if ($row=mysql_fetch_array($result)) {
$stats['categories']=$row[0];
}
return $stats;
}

function poweredby () {
    global $sph_messages;
    //If you want to remove this, please donate to the project at http://www.sphider.eu/donate.php
    print $sph_messages[''];?>

    <?php
}


function saveToLog ($query, $elapsed, $results) {
        global $mysql_table_prefix;
    if ($results =="") {
        $results = 0;
    }
    $query =  "insert into ".$mysql_table_prefix."query_log (query, time, elapsed, results) values ('$query', now(), '$elapsed', '$results')";
    mysql_query($query);

    echo mysql_error();

}

switch ($search) {
    case 1:

        if (!isset($results)) {
            $results = "";
        }
        $search_results = get_search_results($query, $start, $category, $type, $results, $domain);
        require("$template_dir/$template/search_results.html");
    break;
    default:
        if ($show_categories) {
            if ($_REQUEST['catid']  && is_numeric($catid)) {
                $cat_info = get_category_info($catid);
            } else {
                $cat_info = get_categories_view();
            }
            require("$template_dir/$template/categories.html");
        }
    break;
    }

include "$template_dir/$template/footer.html";
?>
<html><center><b><?php
$stats = getStatistics();
print "<br/>    <center><p>Currently in database: ".$stats['sites']." providers, ".$stats['links']." songs, ".$stats['categories']." categories and ".$stats['keywords']." keywords.</p></center>\n";
?></b></center></html>