";
$conn->Execute($q6);
}
# После этих операций данные не будем брать из кеша.
header("Location: ?cacheflush=1");
die;
}
else if (isset($_POST["edit"]) && $_POST["edit"])
{
if ($_POST["number"] == "")
{
header("Location: ?msg=3");
die;
}
if ($_POST["description"] == "")
{
header("Location: ?msg=2");
die;
}
$q4="SELECT 0 FROM phonebook WHERE number = '".$_POST["edit"]."'";
if($debug) echo $q4." ";
$res = $conn->Execute($q4);
if(isset($onlyme) && $onlyme){
$onliLogin="'".$_SERVER['PHP_AUTH_USER']."'";
}else{
$onliLogin="NULL";
}
if (isset($res->fields[0])){
if(!$demoMode){
$conn->Execute("update phonebook set login = $onliLogin, number='".$_POST["number"]."', description = '".$_POST["description"]."' where number = '".$_POST["edit"]."'");
}
}else{
if(!$demoMode){
$q7="insert into phonebook (login, number, description) values (".$onliLogin.",'".$_POST["number"]."', '".$_POST["description"]."')";
if($debug) echo $q7." ";
$conn->Execute($q7);
}
}
# После этих операций данные не будем брать из кеша.
header("Location: ?cacheflush=1");
die;
}
else if (isset($_GET["delete"]) && $_GET["delete"])
{
$q5="delete from phonebook where number = '".$_GET["delete"]."'";
if($debug) echo $q5." ";
if(!$demoMode){
$conn->Execute($q5);
}
# После этих операций данные не будем брать из кеша.
header("Location: ?cacheflush=1");
die;
}
$title=strtr($GUI_LANG['PhoneBook'],$GUI_LANG['UpperCase'],$GUI_LANG['LowerCase']);
if(empty($export)) include("../include/set/header.html");
// Export
if(isset($export) && $export=="excel") {
include("../include/export/2excel.php");
$expor_excel = new MID_SQLPARAExel;
}
if(empty($export)) {
?>
".$GUI_LANG['ChangeDefaultAdminPassword']." ";
?>
".$GUI_LANG['PhoneBook'].":";
}
if(isset($_GET["msg"])){
switch ($_GET["msg"])
{
case 2:
echo "
".$GUI_LANG['EnterDescriptionOfTheNumber']."
";
break;
case 3:
echo "
".$GUI_LANG['EnterAPhoneNumber']."
";
break;
}
}
$q2="SELECT
login,number,description
from phonebook
where phonebook.login = '".$_SERVER['PHP_AUTH_USER']."'
OR phonebook.login IS NULL
order by number ASC";
if($debug) echo $q2." ";
$conn->setFetchMode(ADODB_FETCH_NUM);
if(isset($cacheflush) && $cacheflush) $res = $conn->CacheFlush($q2);
$res = $conn->CacheExecute($q2);
if ($res && $res->RecordCount() > 0) {
while (!$res->EOF) {
$allRows[]=$res->fields;
$res->MoveNext();
}
}
if(!empty($allRows)){
reset($allRows);
ksort($allRows);
}
if(empty($export)) {
echo "