One Hat Cyber Team

View File Name : search.php.2004-06-17

<?

require("auth/auth.php");

$db_handle = mysql_connect($hostname, $user, $password);

include("functions.php");

$page_title=enruua("The Journal \"$publname[$lang]\": Search", 
"Журнал \"$publname[$lang]\": Поиск", 
"Журнал \"$publname[$lang]\": Пошук"); 

require("header.php");
?>

<h1><? echo enruua("Search in the Journal","Поиск среди статей или авторов","Пошук серед статей або авторів");?></h1>
<fieldset>
<legend><? echo enruua("Enter search expression",
"Введите выражение для поиска","Введіть вираз для пошуку");?>
</legend>
<form action=search.php#search method=post>
<input type=hidden name=lang value="<?echo $lang;?>">
<select name="search_what">
<option value="author">
<? echo enruua("among authors","среди авторов","серед авторiв");
?></option>
<option value="article">
<? echo enruua("among article titles","в названиях статей","в назвах статей");
?></option>
</select>
&nbsp;<input  type="text" name=who value=""> 
&nbsp;
<?
echo "<input type=\"submit\" value=".enruua("Search","Искать","Шукати").">\n";
?>

</form>
</fieldset>

<a name=search></a>

<?
if ($who)
{ 

echo "<p align=left>";
 echo enruua("Your quiery for the","Ваш запрос о поиске", "Ваш запит про пошук")." ";
    if ($search_what=="author") 
     echo enruua("name","имени","імені")." \"$who\" ".enruua("in the authors database",
      "в базе данных авторов","в базі даних авторів")." ";
      else 
       echo enruua("expression","выражения","виразу")." \"$who\" ".enruua("among article titles",
      "среди названий статей","серед назв статей")." ";

echo enruua("produced the following results","дал следующие результаты", 
  "дав наступні результати").":</p>\n";

echo "<div class=entry>";

    if ($search_what=="author")

    {
     echo "<dl>";
     echo "<dt>";

     $s = soundex(koi2transl($who)); //echo "--$s--";

     $res_sea = mysql_db_query($database,"SELECT * FROM Authors WHERE soundex='$s' ORDER BY last_name_$lang, first_name_$lang, middle_name_$lang, city_$lang"); 
    
     $empty=1;
     
     while ($found = mysql_fetch_array($res_sea) )
     {

       $empty=0;
       echo "<dd>";
       
       //if($found[note]) echo "<p
       //align=center><small>(".$found[note].")</small></p>"; 
       
       //echo "<div  class=minipage style=\" border:none; \">";
       
       //   echo short_name_link($found[id]);

       echo "<a href=author_card.php?author_id=".$found[id]."&lang=".$lang."&where=main"."#main>";
       
       echo $found["first_name_$lang"];
       
       if($found["middle_name_$lang"]) echo " ".$found["middle_name_$lang"];
       
       echo " ".$found["last_name_$lang"];     echo "</a>";
       
       echo " ";
       
       echo "(".$found["city_$lang"].", ".$found["country_$lang"].")\n";
       
       
     }

     if ($empty) echo "<p align=left>(".enruua("unfortunately, nothing has been found!",
      "к сожалению, ничего не найдено!","на жаль, нічого не знайдено!").")</p>";
     
     echo "</dl>";
     
     //echo "<hr>";
     }
  
    elseif ($search_what=="article") // searching for word
    { 

      $who = trim($who); $empty=1;

 $res_sea = mysql_db_query($database,"SELECT * FROM Articles WHERE
status='published'");

      echo "<ol>";

      while ($found = mysql_fetch_array($res_sea) )
      {
	
	if ($fres = strstr (strtoupper($found[title]), strtoupper($who)))
	  {
	    echo "<LI>"; $empty = 0;

	    $coloured =  
 str_replace ($who, "<B>".strtoupper($who)."</B>", $found[title]);
  
 echo paper_reference($found[id],$coloured);
	    
	  }  
      }
      
      echo "</ol>";

      if ($empty) echo "<p align=left>(".enruua("unfortunately, nothing has been found",
      "к сожалению, ничего не найдено","на жаль, нічого не знайдено").")</p>";

      
    }
    
    
    //end cases for search
     
} echo "</div>";

require("footer.php");

?>