One Hat Cyber Team

View File Name : add_remove_revisions.php

<?
$page_title="Add/Remove authors for Article no. $id_selected";
$related_page="manage_articles.php";

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

switch ($aa_browse_todo)
{

case "Accept": 

$db_handle=mysql_connect($host,$user,$password);
mysql_query("SET NAMES '$charset'", $db_handle);

mysql_db_query($database, "delete from AA where article_id='$id_selected' ");

mysql_db_query($database, "replace into AA (author_id, article_id,
author_ambition) select author_id, article_id, author_ambition from
AA_temp where article_id='$id_selected' ");

header("Location: manage_articles_action.php?id_selected=$id_selected&todo=modify&lang=$lang");

break;

case "Discard":

header("Location: manage_articles_action.php?id_selected=$id_selected&todo=modify&lang=$lang");

break;

case "Remove":

$db_handle=mysql_connect($host,$user,$password);
mysql_query("SET NAMES '$charset'", $db_handle);

require("header.php");

if ($aa_browse_selected) 
{

//echo "removing author $aa_browse_selected for article $id_selected";

$res_au_remove = mysql_db_query($database, "delete from AA_temp where
article_id='$id_selected' and author_id='$aa_browse_selected' ");

} //if selected 

else echo "<div class=alert><p align=center>No command
specified!</p></div>";

$aa_browse_todo="-1";

break;

default:  //echo "not remove";

$db_handle=mysql_connect($host,$user,$password);
mysql_query("SET NAMES '$charset'", $db_handle);

require("header.php");

break;

} //switch

echo "<body>";

/* ----------------------------------------------- */

$db_handle=mysql_connect($host,$user,$password);
mysql_query("SET NAMES '$charset'", $db_handle); 

//add authors (form) 

$res_au = mysql_db_query($database, "SELECT id, last_name_$lang, first_name_$lang,
middle_name_$lang, city_$lang, affiliation_$lang FROM Authors ORDER BY last_name_$lang,
first_name_$lang, middle_name_$lang, city_$lang");

/* if(!$res_au) die(mysql_error("Cannot look into the Authors
table!")); */

//echo "todo=$todo [aa]<br> ar_number (=id_sel) is $id_selected<br>"; 

echo "<H1>".enruua("Selection of authors for",
"Выбор авторов для статьи","Вибір авторів для статті")." ".article_edit_link($id_selected)."</h1>\n";
 
echo "<div class=admin_main>";
echo "<p>".enruua("Select among the persons registered in the
authors table in the order of appearence",
"Выберите нужные записи из таблицы авторов в порядке следования",
"Виберіть потрібні записи з таблиці авторів в належному порядку").":</p>\n";

print("<FORM METHOD=\"POST\" ACTION=\"add_remove_authors.php\">\n");
echo "<input type=\"hidden\" name=\"lang\" value=\"".$lang."\">";
print("<input type=\"hidden\" name=\"id_selected\" value=\"$id_selected\">\n");
print("<p><input type=\"hidden\" name=\"todo\" value=\"$todo\"></p>\n");

echo "<p align=left>";

//all the entries of the authors table (a menu)
//echo "aa_add_selected=$aa_add_selected<br>\n";

echo "<SELECT NAME=\"aa_add_selected\" >\n";

while($row = mysql_fetch_array($res_au))
 { 
 /* print("<OPTION VALUE=\"$row[id]\">".$row["last_name_$lang"].", ".$row["first_name_$lang"]." ".$row["middle_name_$lang"]." (".$row["city_$lang"]."), no. $row[id]</OPTION>\n"); */
echo "<option value=\"".$row["id"]."\">";
echo author_option_name($row)." (".number()." ".$row["id"].")";
echo "</option>\n";
}

echo "</SELECT></p>\n";

echo "<p align=left>";
echo "<input type=hidden name=aa_todo value=select>";
echo "<input type=\"submit\" name=foo
 value=\"".enruua("Add to the authors of Article no.", "Внести в список авторов статьи",
 "Додати до авторів статті")."&nbsp;".$id_selected."\">\n";

echo "</p>\n "; //if ($aa_add_selected)
 
if ($aa_todo=="select")

{ /* add an author */
   /* echo "aa_add_selected=$aa_add_selected (author);
 id_selected=$id_selected (article)";  */

 $res_aa_verify = mysql_db_query($database,"SELECT id, author_id,
article_id FROM AA_temp WHERE author_id='$aa_add_selected' AND
article_id= '$id_selected' ");

//mysql_free_result;

if ( $q = mysql_fetch_array($res_aa_verify) )

{
// echo " (Found id=$q[id], au_id=$q[author_id], art_id=$q[article_id]) "; 
 }

else { //echo "inserting"; 

// look for other authors ambitions

$res_other = mysql_db_query($database, "SELECT author_ambition FROM
AA_temp WHERE article_id='$id_selected' ORDER BY author_ambition");

while ($other=mysql_fetch_array($res_other)) { //other

while (list($key,$val) = each($other) ) 

{ $new_ambition=$val; /* echo "key=$key, val=$val"; */ } /* echo "amb=
$new_ambition <br>"; */ 

}//other

$new_ambition++;

//echo "Inserting author `$aa_add_selected' for article `$id_selected'";

$res_aa_replace = mysql_db_query($database,"INSERT INTO AA_temp
(author_id,article_id,author_ambition) VALUES ('$aa_add_selected',
'$id_selected', '$new_ambition' )");

if(!$res_aa_replace) die(mysql_error());

//$aa_add_selected=0; echo "purged<br>";

} //inserting

}

print("</FORM>\n");

echo "</div>\n";

// actions performed; can output the results

//--------------------------

//now actually list the authors 

//mysql_query("SET NAMES '$charset'", $db_handle);
$res_aa_read = mysql_db_query($database,"SELECT id,author_id, article_id,
author_ambition FROM AA_temp WHERE article_id='$id_selected' ORDER BY
author_ambition");

echo "<div class=admin_entry>\n";

echo "<p>".enruua("The following authors are associated with article",
"Следующие лица внесены в список авторов статьи",
"Наступні особи внесено до списку авторів статті" )." ".article_edit_link($id_selected).":</p>";

//browse authors
print("<FORM METHOD=\"POST\" ACTION=\"add_remove_authors.php\">");
/* print("<input type=\"hidden\" name=\"aa_browse_selected\"
value=\"$aa_browse_selected\">\n"); */

print("<input type=\"hidden\" name=\"id_selected\" value=\"$id_selected\">\n");
print("<input type=\"hidden\" name=\"todo\" value=\"$todo\">\n");
echo "<input type=\"hidden\" name=\"lang\" value=\"".$lang."\">";

echo "<p align=left>";

echo "<select name=\"aa_browse_selected\" size=5>\n";

while($row = mysql_fetch_array($res_aa_read)) 

{ $res_au_read = mysql_db_query($database, "select id, last_name_$lang,
first_name_$lang,middle_name_$lang, city_$lang, affiliation_$lang from Authors where
id='$row[author_id]'");

if ($au_entry = mysql_fetch_array($res_au_read))
{

echo "<option value=\"".$au_entry["id"]."\">";
echo author_option_name($au_entry)." (".number()." ".$au_entry["id"].")";;

/* $res_check_AA = mysql_db_query($database, "SELECT author_id,
article_id FROM AA WHERE author_id='$au_entry[id]' AND
article_id='$id_selected' ");  

if (!mysql_fetch_array($res_check_AA))
 echo " [NOT SAVED]"; */

echo "</option>\n";

} //$au_entry contains sth

else echo "Authors table is incomplete: could not find authors with id='$row[author_id]'!"; 

} //row

echo "</select></p>\n";

echo "<p align=left>";
echo "<input type=\"hidden\" name=aa_browse_todo value=\"Remove\">";
echo "<input type=\"submit\" name=foo value=\"".enruua("Remove", "Убрать","Забрати")."\">\n";

//echo "<input type=\"submit\" name=aa_browse_todo value=\"Demote\">\n";

echo "</p>"; 
echo "</form>";

/* 
print("<input type=\"hidden\" name=\"id_selected\"
value=\"$id_selected\">\n");
print("<input type=\"hidden\" name=\"todo\" value=\"$todo\">\n");

 print("<input type=\"hidden\" name=aa_add_selected value=\"$aa_add_selected\">\n"); 

 print("<input type=\"hidden\" name=\"aa_browse_selected\"
value=\"$aa_browse_selected\">\n"); */

echo "</form>";

echo "</DIV>";

echo "<div class=control>";

echo "<h2>".enruua("changing the author list for article",
"Изменение списка авторов статьи","Зміна переліку авторів статті")." ".article_edit_link($id_selected,"")."</h2>\n";

echo "<p><i>".enruua("Please choose from the actions below",
"Выберите, что делать","Виберіть, що зробити").":</i></p>\n";

echo "<form action=add_remove_authors.php method=get>";

print("<input type=\"hidden\" name=\"id_selected\" value=\"$id_selected\">\n");
print("<input type=\"hidden\" name=\"lang\" value=\"$lang\">\n");
echo "<p><input type=radio name=aa_browse_todo
value=\"Discard\"><font color=$alert_colour>".enruua("Discard changes",
"Игнорировать сделанные изменения",
"Ігнорувати зроблені зміни")."</font>\n";

echo "<br><input type=radio name=aa_browse_todo checked
value=\"Accept\">".enruua("Accept changes","Сохранить изменения","Зберегти зроблені зміни")."\n";

echo "</p>\n";

echo "<p><input type=submit value=\"".enruua("Proceed",
"Принять указанное решение и продолжить далее","Прийняти вказане рішення та йти далі")."\"></p>";

echo "</form>\n";
echo "</div>\n";

require ("footer.php");

?>