One Hat Cyber Team

View File Name : author_card.php.2004-11-29

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

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

include("functions.php");

$page_title=enruua("The Journal \"$publname[$lang]\": Author card ".$author_id,
"Журнал \"$publname[$lang]\": карточка автора  ".$author_id,
"Журнал \"$publname[$lang]\": картка автора ".$author_id);
require("header.php");

// assume that $author_id is defined

if ($author_id)

{

echo "<h1>".enruua("Information on the author",
"Сведения об авторе",
"Інформація про автора")."</h1>\n";

//echo "author id=$author_id";

$fetch_author_data = mysql_db_query($database, "SELECT id, title_$lang, last_name_$lang,
first_name_$lang, middle_name_$lang, city_$lang, street_$lang, country_$lang, postal_code, state,
email, fax, phone, editor, affiliation_$lang, note FROM Authors where id='$author_id' ");

echo "<div class=author_card>\n";
echo "<a name=author_card></a>\n";

if ( $author_data = mysql_fetch_array($fetch_author_data) )

{
$name=$author_data["first_name_$lang"]."&nbsp;"; 
 if ($author_data["middle_name_$lang"])  $name=$name.$author_data["middle_name_$lang"]."&nbsp;";
$name=$name.$author_data["last_name_$lang"];

$name=trim($name);

echo "<p><span class=sc><b>".$name."</b></span>"; 
if ($author_data["title_$lang"]) echo ",&nbsp;".$author_data["title_$lang"];

echo "</p>";

if ($author_data[editor])
{
echo "<p>";

switch ($author_data[editor])

{

case "2": echo enruua("Editor-in-Chief of the journal",
  "Главный редактор журнала", "Головний редактор журналу")." ".publ_link($lang)."\n"; break;
 
case "1": 

echo enruua("Member of the","Член","Член")." <a href=editorial_board.php?lang=".$lang."&where=main#main>";
echo enruua("Editorial Board", "редакционной коллегии",
 "редакційної колегії")."</a> ".enruua("of the journal","журнала","журналу")." ".publ_link($lang)."\n";
  break;

case "3":  echo enruua("Assistant Editor-in-Chief of the",
"Заместитель главного редактора","Заступник головного редактора")." ".enruua("of the journal","журнала","журналу")." ".publ_link($lang)."\n";
  break;

case "4": 
 echo enruua("Executive Editor","Исполнительный редактор", 
 "Виконавчий редактор")." ".enruua("of the journal","журнала","журналу")." ".publ_link($lang)."\n"; 
 break;
 
}

}//editor 

echo "</p>";

//echo "<hr width=50% size=3>";

if($author_data[note]) echo "<p
align=center><small>(".$author_data[note].")</small></p>"; 

echo "<p class=address>";

if ($author_data["affiliation_$lang"]) echo $author_data["affiliation_$lang"];

if ($author_data["city_$lang"]) 
 {
  echo ", ";
   if ($author_data["postal_code"])   echo $author_data["postal_code"]."&nbsp;";
  echo $author_data["city_$lang"]; 
  }

if ($author_data["street_$lang"]) echo ", ".$author_data["street_$lang"];
if ($author_data["country_$lang"]) echo ", ".$author_data["country_$lang"];

echo "</p>";

if ($author_data[email]) 
{
/* echo "<p>".enruua("Electronic mail","Электронная почта",
 "Електронна пошта");*/
 echo ecim($author_data["id"]);
 
 /* " <span class=email>"."$author_data[email]</span></p>\n"; */
}

if ($author_data[fax]) echo "<p>".enruua("Fax number","Номер факса","Номер факсу")." ".$author_data[fax]."</p>\n";

if (check_admin()) 
 {echo "<p align=right><small>";
 echo "<a class=button_edit 
 href=admin/manage_authors_action.php?id_selected=".$author_data[id]."&todo=modify>".enruua("Edit",
 "Редактировать","Редагувати"); 
 echo "</a></small></p>\n";
 }

echo "</div>";

/* $fetch_papers = mysql_db_query($database, "SELECT 
Articles.id, Articles.title, Articles.published_volume,
Articles.published_number, Articles.published_page_start,
Articles.published_page_end FROM AA LEFT JOIN Articles ON
Article.id=AA.article_id WHERE Articles.status='published'
AND AA.author_id='$author_id' "); */

$fetch_papers = mysql_db_query($database,"select Articles.id,
Articles.title_en,Articles.title_ru,Articles.title_ua
 from AA LEFT JOIN Articles on Articles.id=AA.article_id
where Articles.status='published' and AA.author_id='$author_id'
 order by Articles.published_volume ");

if ($paper = mysql_fetch_array($fetch_papers))
{ //there are some papers


 echo "<p>".$name." ".enruua("is the author of the following papers published in",
"является автором следующих работ, опубликованных в журнале",
"є автором наступних робіт, опублікованих в журналі")." ".publ_link($lang).":</p>\n";

echo "<OL>";

while ($paper)

{

echo "<LI>".paper_reference($paper[id]);

/* 
$paper[title].",'' <em>Nonlinear Oscillations</em>
<B>$paper[published_volume]</B>, No. $paper[published_number],
$paper[published_page_start]-$paper[published_page_end].";  */

$paper = mysql_fetch_array($fetch_papers);

} //papers

echo "<OL>";
} //there are papers

} //browse author data

else echo "Sorry, I cannot find author with no. $author_id.";

}//author_id

include("footer.php");

?>