One Hat Cyber Team

View File Name : search (old copy).php

<?
require("../auth/auth.php");
require("header.php");

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

$search_types=array("AUTHOR_NAMES"=>enruua("among authors","среди авторов","серед авторiв"),
		    "ARTICLE_TITLES"=>enruua("among article titles","в названиях статей","в назвах статей"));

$lang = take_variable('lang');
//$lang = $_POST['lang'];
// echo "lang=$lang";

$needle = take_variable('needle');

$needle_tr = trim(prepare_for_search($needle));
//echo "searching for: \"".$needle_tr."\"";
$s = soundex($needle_tr);

$where = take_variable('where');
if (!in_array($where,array_keys($search_types)))
  $where ="AUTHOR_NAMES";

echo "<H1>";
echo enruua("Search in the Journal","Поиск среди статей или авторов","Пошук серед статей або авторів");
echo "</H1>\n";

echo "<FORM ACTION=\"".$_SERVER["PHP_SELF"]."#search\" METHOD=\"POST\">\n";
echo "<P>";
echo pass("lang",$lang);
echo pass("needle",$needle);

echo "<SELECT NAME=\"where\">\n";
foreach ($search_types as $st => $desc)
{
  echo "<OPTION VALUE=\"".$st."\"";
  if ($where == $st) echo " SELECTED";

  echo ">";

  echo $desc;
  echo "</OPTION>\n";
}
echo "</SELECT>\n";

echo "&nbsp;". "<INPUT TYPE=\"text\" NAME=\"needle\" VALUE=\"".$needle."\">" . "&nbsp";
echo "<INPUT TYPE=\"submit\" VALUE=".enruua("Search","Искать","Шукати").">\n";

echo "</P>\n";
echo "</FORM>\n";

echo "<A NAME=\"search\"></A>\n";

if ($needle_tr)
  {

    switch ($where)
      {
      case "AUTHOR_NAMES":
	
	//$res_sea = mysql_query("SELECT * FROM Authors WHERE soundex(last_name_en)='".$s."' ORDER BY last_name_$lang, first_name_$lang, middle_name_$lang, city_$lang"); 

$res_sea = mysql_query("SELECT * FROM Authors WHERE last_name_$lang SOUNDS LIKE '".$needle_tr."' ORDER BY last_name_$lang, first_name_$lang, middle_name_$lang");  
	
	$c = mysql_num_rows($res_sea);
	
	echo "<FIELDSET class=\"author_card\">\n";
	echo "<LEGEND>\n";
	echo enruua("Search results for","Результаты поиска", "Результати пошуку")." "
	  . enruua("name","имени","імені")." \"".$needle."\" "
	  .enruua("in the authors database","в базе данных авторов","в базі даних авторів");
	echo "</LEGEND>\n";
	
	if (!$c) 
	  echo  enruua("Unfortunately, nothing has been found",
		       "К сожалению, не найдено ничего","На жаль, нічого не знайдено").".";
	
	echo "<DL>\n";
	echo "<DT>\n";
	
	while ($found = mysql_fetch_array($res_sea))
	  {
	    echo "<DD>\n"; 
	    echo author_link($found['id']);
	    echo "</DD>\n"; 
	  }
	echo "</DL>";
	echo "</FIELDSET>\n";
	
	break;
	
      case "ARTICLE_TITLES":
	
	$res_sea = //mysql_query("SELECT id FROM Articles WHERE ((status >1) && (status NOT IN (3,4,5))) ORDER BY status");
mysql_query("SELECT * FROM Articles WHERE status=2 AND published_volume >=1 ORDER BY published_volume DESC,published_number,published_page_start");
	
	echo "<FIELDSET class=\"author_card\">\n";
	echo "<LEGEND>\n";
	echo enruua("Search results for \"".$needle."\" among the article titles","Результаты поиска текста \"".$needle."\" среди названий статей","Результати пошуку тексту \"".$needle."\" серед назв статей");
	echo "</LEGEND>\n";
	
	echo "<TABLE>\n";
	
	$n = 0;
	while ($f = mysql_fetch_array($res_sea))
	  {
	    $found = article($f["id"]);
	    if ($fres = strstr (strtoupper($found["title_$lang"]), strtoupper($needle)))
	      {
		
		//$coloured = str_replace ($who, "<B>".strtoupper($who)."</B>", $found["title_$lang"]);
		//$coloured = str_replace ($who, "<span style=\"text-decoration: blink;\">".$who."</span>", $found["title_$lang"]);
		$coloured= $found["title_$lang"]; //simply list, no effects
		
		$n++;
		echo "<TR>\n";
		echo "<TD>"; 
		echo paper_link($found,$n);
		echo "</TD>\n";
		echo "<TD>";	    
		echo paper_short_reference($found['id'],$lang,'HTML',TRUE);//. " (".$found['id'].")"; //
		//paper_reference($found['id'],$coloured);
		echo "</TD>\n";
		echo "</TR>\n";
	      }  
	  }
	echo "</TABLE>\n";
	
	if (!$n) 
	  echo "". enruua("Unfortunately, nothing has been found",
			  "К сожалению, не найдено ничего","На жаль, нічого не знайдено").".";
	
	echo "</FIELDSET>\n";
	
      default: break;
      }//switch
  }


require("footer.php");

?>