One Hat Cyber Team

Your IP : 216.73.216.80

Server IP : 194.44.31.54

Server : Linux zen.imath.kiev.ua 4.18.0-553.77.1.el8_10.x86_64 #1 SMP Fri Oct 3 14:30:23 UTC 2025 x86_64

Server Software : Apache/2.4.37 (Rocky Linux) OpenSSL/1.1.1k

PHP Version : 5.6.40

Buat File | Buat Folder

Dir : ~/home/nosc/public_html.2006-04-15/admin0/

Edit File: manage_authors.php

<?php

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

//dl("mysql.so");
$page_title=enruua("Authors table","Таблица авторов","Таблиця авторів");

require("defs_authors.php");

echo "<body>";

$default_sortby="last_name_$lang,first_name_$lang,middle_name_$lang";

if (isset($sortby_selected)) $sortby=$sortby_selected; 
 else $sortby=$default_sortby; //echo "sortby=$sortby";

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

echo "<h1>$page_title</h1>";
//  echo "<p>".enruua("Selecting charset","Устанавливаю кодировку","Встановлюю кодування")." ".$charset."</p>"; 
/* mysql_db_query($database,"SET  CHARACTER SET '$charset' collate '$collation'"); */
//mysql_db_query($database,"SET CHARACTER SET"); 
//mysql_db_query($database,"SET NAMES $charset");
//mysql_db_query($database,"set CHARACTER SET cp1251"); 
// mysql_db_query($database,"SET character_set_client = '$charset'"); 
//mysql_db_query($database,"SET collation_connection = @@collation_database"); 
//mysql_db_query($database,"SET  character_set_connection = '$charset'"); 
//mysql_db_query($database,"SET  character_set_results =  '$charset");  //works??????????!!!

//echo "<p>".enruua("Кодировка клиента","Кодування client-а","Database clent charset").": ".mysql_client_encoding()."</p>";

$res = mysql_db_query($database,"select
id,last_name_$lang,first_name_$lang,middle_name_$lang,city_$lang,country_$lang from Authors order by '$sortby'" ); 
if(!$res) die(mysql_error());

// sort

echo "<DIV class=admin_main>";
echo "<form method=post action=manage_authors.php>";
echo "<div class=menu>";echo "<p align=center>";
echo "<input type=submit value=\"".enruua("Sort by","Упорядочить по","Впорядкувати за")."...\"></p>\n";
echo "<select style=\"height: 20px;\" name=\"sortby_selected\">";

while (list($key,$val)=each($Columns)) 
 {  
if ($key!="Note")
{

if ($key==$sortby)
 echo "<option selected name=\"sortby_selected\" value=\"$key\">$val"; 
 else  echo "<option name=\"sortby_selected\" value=\"$key\">$val"; 
//echo "<option name=\"sortby_selected\" value=\"$key\">$val"; 
}
}
 echo "<option  name=\"sortby_selected\" 
value=\"$default_sortby\">DEFAULT"; 
print("</select>"); echo "</center></div>";
echo "</form>";
//end sort
?>
</div>
<div class=admin_main>
<?
echo "<form method=\"POST\" action=\"manage_authors_action.php\">";

echo "<center>";

echo "<select style=\"height: 300px;\" name=\"id_selected\" size=10>\n";

while($row = mysql_fetch_array($res))
 {

print("<option ");

if ($row[id]==$id_selected) echo " selected ";

echo "value=\"$row[id]\">".$row["last_name_$lang"].", ".$row["first_name_$lang"]." ".$row["middle_name_$lang"]." 
(".$row["city_$lang"].", ".$row["country_$lang"]."), no. $row[id]</option>\n";

}
	
print("</select><br>\n");

echo "</center>";
?>
</div>
<?
echo "<div class=control>";

echo "<DL><DT><H3>".enruua("What is to be done",
"Что делать","Що робити")."?</H3>\n";

echo "<DD><input checked type=\"radio\" name=todo 
value=\"modify\"> ".enruua("Modify the selected record",
"Изменить выделенную запись",
"Редагувати виділений запис")."\n";

echo "<DD><input type=\"radio\" name=todo 
value=\"add\"> ".enruua("Add a new empty recored",
"Добавить новую чистую запись","Створити новий порожній запис")."\n";

echo "<DD><input type=\"radio\" name=todo 
value=\"addcopy\"> ".enruua(
"Add a new record using the selected one as a template",
"Добавить новую запись, используя выделенную в качестве шаблона",
"Додати новий запис (скопіювати дані з виділеного запису)")."\n";

echo "</DL>";
echo "<input type=hidden name=lang value=".$lang.">\n";
echo "<center><input type=submit value=\"".enruua("Proceed",
"Выполнить","Виконати")."\"></center>"; 
echo "</div>";

print("</form>");

echo "</DIV>";

mysql_close($db_handle);

if (!$footer) require("footer.php");

?>

</body>

</html>