<?php
  require_once 'conn.php';
  require_once 'functions.php';
  require_once 'header.php';
  
  $result\; =\; NULL;\; if\; (isset($_GET['keywords'])) {
    $sql\; =\; "SELECT\; *,\; MATCH\; (subject,body)\; "\; .\; "AGAINST\; (\text{'}"\; .$_GET['keywords'] . "') AS score " .
           "FROM forum_posts " .
           "WHERE MATCH (subject,body) " .
           "AGAINST ('" . $\_GET[\text{'}keywords\text{'}]\; .\; "\text{'})\; "\; .\; "ORDER\; BY\; score\; DESC";$result = mysql_query($sql,$conn)
      or die('Could not perform search; ' . mysql_error());
  }
  
  echo "<table class=\"forumtable\" width=\"100%\" " .
       "cellspacing=\"0\">\n";
  echo "<tr><th class=\"searchHeader\">Search Results</th></tr>\n";
  
  if ($result\; and\; !mysql\_num\_rows($result)) {
    echo "<tr class=\"row1\"><td>No articles found that match the ";
    echo "search term(s) '<strong>" . $\_GET[\text{'}keywords\text{'}]\; .\; "$</strong>'";
    if (access_lvl > 2) echo "<p>SQL: $sql$</p>";
    echo "</td></tr>\n";
  } else {
    rowclass = "";
    while ($row\; =\; mysql\_fetch\_array($result)) {
      $rowclass\; =\; ($rowclass == "row1"?"row2":"row1");
      echo "<tr class=\"$rowclass\backslash ">\backslash n$<td>\n";
      topicid=($row[\text{'}topic\_id\text{'}]==0?$row['id']:$row[\text{'}topic\_id\text{'}]);\; echo\; "$<p class=\"searchSubject\">\n<a href=\"viewtopic.php?t=" .
           topicid . "#post" . $row[\text{'}id\text{'}]\; .\; "\backslash ">"\; .$row['subject'] . "</a>\n";
      echo "</p>\n";
      echo "<p class=\"searchBody\">\n";
      echo htmlspecialchars(trimBody($row[\text{'}body\text{'}]));\; if\; ($access_lvl > 2) {
           echo "<p>SQL: $sql$</p>";
           echo "<br><br>relevance: " . row['score'];
      }
      echo "\n</p>\n";
      echo "</td>\n</tr>\n\n";
    }
  }
  echo "</table>";
  
  require_once 'footer.php';
  ?>