[Summary view] [Print] [Text view]

   1  <?
   2  if (strpos($_SERVER['HTTP_ACCEPT_ENCODING'],'gzip') !== false) {  
   3      ob_start("ob_gzhandler");
   4  } else {  
   5      ob_start();
   6  }
   7  include  ("config.inc.php");
   8  $page_name = "search";
   9  $page_code = ucfirst(LANG_SEARCHEN);
  10  
  11  echo PrintTheme("header");
  12    $connection = @mysql_connect($dbhost, $dbuser, $dbpass)
  13      or die ("Can not connect to database");
  14    $db = @mysql_select_db($dbname, $connection)
  15      or die ("Can not select database.");
  16  if ($_POST["q"] != "") {
  17   switch ($_POST["fields"]) {
  18            case "content":
  19             $field = strtolower(LANG_CONTENTS);
  20             $query = "(name LIKE '%".$_POST["q"]."%' OR content LIKE '%".$_POST["q"]."%') AND active = '1'";
  21             $table = $t_contents;
  22             $return = "id, name, content";
  23             $id_col = "id";
  24             $page_url = "contents.php?cid=";
  25             break;
  26            case "news":
  27             $field = strtolower(LANG_B_NEWS);
  28             $query = "(subject LIKE '%".$_POST["q"]."%' OR body LIKE '%".$_POST["q"]."%') AND active = '1'";
  29             $table = $t_news;
  30             $return = "id, subject, body";
  31             $id_col = "id";
  32             $page_url = "news.php?nid=";
  33             break;
  34            case "anns":
  35             $field = strtolower(LANG_B_ANNS);
  36             $query = "(subject LIKE '%".$_POST["q"]."%' OR body LIKE '%".$_POST["q"]."%') AND active = '1'";
  37             $table = $t_anns;
  38             $return = "id, subject, body, cat_id";
  39             $id_col = "id";
  40             $page_url = "annoucement.php?aid=";
  41             break;
  42            case "doc":
  43             $field = strtolower(LANG_B_DOCS);
  44             $query = "(name LIKE '%".$_POST["q"]."%' OR descr LIKE '%".$_POST["q"]."%') AND active = '1'";
  45             $table = $t_docs;
  46             $return = "did, name, descr, cat_id";
  47             $id_col = "did";
  48             $page_url = "index.php?page=documents&doc=";
  49             break;
  50            case "link":
  51             $field = strtolower(LANG_B_LINKS);
  52             $query = "(name LIKE '%".$_POST["q"]."%' OR descr LIKE '%".$_POST["q"]."%') AND active = '1'";
  53             $table = $t_links;
  54             $return = "id, name, descr";
  55             $id_col = "id";
  56             $page_url = "golink.php?lid=";
  57             break;
  58            case "forum":
  59             $field = strtolower(LANG_B_FORUM);
  60             $query = "(title LIKE '%".$_POST["q"]."%' OR body LIKE '%".$_POST["q"]."%') AND active = '1'";
  61             $table = $t_forum_msg;
  62             $return = "tid, title, body";
  63             $id_col = "tid";
  64             $page_url = "forums.php?action=showmsg&mid=";
  65             break;
  66   }
  67     // Search
  68     $limit=10;
  69     if (!$offset) $offset=0;
  70     $result = mysql_query("SELECT $return FROM $table WHERE $query GROUP BY $id_col");
  71     $numrec = mysql_num_rows($result);
  72     $numpage=intval($numrec/$limit);
  73     if ($numrec%$limit) {
  74       $numpage++;
  75     }
  76     $i = $offset; 
  77   $result = mysql_query("SELECT $return FROM $table WHERE $query GROUP BY $id_col LIMIT $offset,$limit");
  78   $numrows = mysql_num_rows($result);
  79   if ($numrows >= 0) {
  80   ?>
  81   <?=L_S_RESULTSET?> <b><?=$numrec?></b> <?=L_S_RESULTSET2?> <b><?=$field?></b> <?=L_S_RESULTSET3?> <b><?=$_POST["q"]?></b><hr>
  82   <?    
  83    echo "<dl>";    
  84    while ($row=mysql_fetch_array($result)) {
  85      $i++;    
  86      echo "<b><dt>$i.<a href=\"".$root_url."/$page_url".$row[$id_col]."\">".stripslashes(Translator($row[$id_col], "content", $user_lang, "subject", $row["1"]))."</a></b>
  87                  <dd>".stripslashes(HighLight($q, substr(eregi_replace("<[^>]*>", "", Translator($row[$id_col], "content", $user_lang, "body", $row["2"])), 0, 150)))."...
  88                  <br><font color=\"green\">URL: ".$root_url."/$page_url".$row[$id_col]."</font><br><br></dt>\n";      
  89    }
  90    echo "</dl>";
  91    // Insert prev/next buttons if there's more than 5 nws
  92    if ($numpage>1) {
  93        echo "<p>";
  94        PrevNextButtons();
  95        print "</P>";
  96    }      
  97   } else {
  98       echo LANG_NORESULTS;
  99   }    
 100   
 101  } else {
 102   echo LANG_ENTERKEYWORD;
 103  } 
 104  @mysql_close($connection);
 105  echo PrintTheme("footer");
 106  ob_end_flush();
 107  ?>