<?php
include("includes/header.php");

// Set $search equal to search query
$search = mysql_real_escape_string(strtolower($_REQUEST['q']));

// Require more than 3 characters to perform a search
if(strlen($search) < 4)
{
    $resultmsg =  "<p style='background-color:#fff;'><strong>Search Error</strong>:<br />Keywords with less then four characters are omitted...</p>";
    echo $resultmsg;
}

// Ensure users do not use this script alone to search, for ad exposure.
else if ( $_SERVER['SCRIPT_NAME'] == search.php)
{
    echo "<p>Please use the main website to search.  Thanks!</p>";
}

// Check for parameter
else if (!isset($search))
{
    $resultmsg =  "<p style='background-color:#fff;'>Search Error</p><p style='background-color:#fff;'>We don't seem to have a search parameter! </p>" ;
    echo $resultmsg;

}

else
{
    // Create Array
    $searchArray = explode(" ", $search);

    // Create result header
    echo "<h2 class='search'>Search Results</h2>";
    echo "<ul id='searchresultsUL'>";

    $runningTally = 0;

    // Query database with array values
    foreach ($searchArray as $searchItems)
    {
        if($searchItems != null)
        {
            $query = "
            (SELECT Name,Information,Facts,URLPrefix,Icon , MATCH (Name,Information,Facts,URLPrefix) AGAINST ('".$searchItems."*' IN BOOLEAN MODE) AS score FROM classes WHERE MATCH (Name,Information,Facts,URLPrefix,Icon) AGAINST ('+".$searchItems."' IN BOOLEAN MODE) ORDER BY score DESC LIMIT 10)
                Union
            (SELECT Name,Information,Facts,URLPrefix,Icon , MATCH (Name,Information,Facts,URLPrefix) AGAINST ('".$searchItems."*' IN BOOLEAN MODE) AS score FROM Areas WHERE MATCH (Name,Information,Facts,URLPrefix,Icon) AGAINST ('+".$searchItems."' IN BOOLEAN MODE) ORDER BY score DESC LIMIT 10)
                Union
            (SELECT Name,Information,Facts,URLPrefix,Icon , MATCH (Name,Information,Facts,URLPrefix) AGAINST ('".$searchItems."*' IN BOOLEAN MODE) AS score FROM Items WHERE MATCH (Name,Information,Facts,URLPrefix) AGAINST ('+".$searchItems."' IN BOOLEAN MODE) ORDER BY score DESC LIMIT 10)
                Union
            (SELECT Name,Information,Facts,URLPrefix,Icon , MATCH (Name,Information,Facts,URLPrefix) AGAINST ('".$searchItems."*' IN BOOLEAN MODE) AS score FROM NPCs WHERE MATCH (Name,Information,Facts,URLPrefix) AGAINST ('+".$searchItems."' IN BOOLEAN MODE) ORDER BY score DESC LIMIT 10)
                Union
            (SELECT Name,Information,Facts,URLPrefix,Icon , MATCH (Name,Information,Facts,URLPrefix) AGAINST ('".$searchItems."*' IN BOOLEAN MODE) AS score FROM Mobs WHERE MATCH (Name,Information,Facts,URLPrefix) AGAINST ('+".$searchItems."' IN BOOLEAN MODE) ORDER BY score DESC LIMIT 10)
                Union
            (SELECT Name,Information,Facts,URLPrefix,Icon , MATCH (Name,Information,Facts,URLPrefix) AGAINST ('".$searchItems."*' IN BOOLEAN MODE) AS score FROM Skills WHERE MATCH (Name,Information,Facts,URLPrefix) AGAINST ('+".$searchItems."' IN BOOLEAN MODE) ORDER BY score DESC LIMIT 10)
                ";

            $result = mysql_query($query) or die(mysql_error());
            $numberOfResults = mysql_num_rows($result);

            // Add number of results
            $runningTally += $numberOfResults;

            while($row = mysql_fetch_array($result))
            {
              $row['Name'] = Truncate($row['Name'], 45);
              // Turn spaces into underscore for the sake of attractive links
              $saferow = str_replace(" ", "_", $row['Name']);
              echo "<li id='searchli'><img src='/images/icons/" .$row['Icon']."' id='icons' /> <a id='searchlinks' href=\"". $row['URLPrefix'] . "" . $saferow ."\">" .   $row['Name'] . "</a></li>";
            }
        }
    }

    echo "<li id='searchlifoot' class='none'>We found " . $runningTally . " items!</li>";
    echo "</ul>";

    // And close
    mysql_close($con);
}
?>
</html>