"; $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 "
"; }else{ $expor_excel->MontaConteudo(0, 0,$GUI_LANG['PhoneNumber']); $expor_excel->MontaConteudo(0, 1,$GUI_LANG['Description']); $expor_excel->MontaConteudo(1, 0, " "); $expor_excel->MontaConteudo(1, 1, " "); $expor_excel->mid_sqlparaexcel(); } if(!empty($allRows)){ $linha=0; while (list($key, $row) = each($allRows)) { $FontColor=''; $FontColorEnd=''; if(ereg($MobileCallsR, $row[1])){ $FontColor=""; $FontColorEng=""; }elseif(ereg($InternationalCalls, $row[1])){ $FontColor=""; $FontColorEng=""; }elseif(ereg($LongDistanceCalls, $row[1])){ $FontColor=""; $FontColorEng=""; } if(empty($export)) echo "\n"; if (isset($_GET["edit"]) && $_GET["edit"] == $row[1]) { if(empty($export)) { if($row[0]) $checkMe[0]=" CHECKED"; else $checkMe[1]=" CHECKED"; echo "\n"; echo ""; echo "\n"; echo "\n"; echo "\n"; } } else { if(empty($export)) { echo ""; if($row[0]) $viewMe=$GUI_LANG['OnlyForMe']; else $viewMe=$GUI_LANG['ForEverybody']; echo ""; echo "\n"; echo ""; echo ""; }else{ $expor_excel->MontaConteudo($linha+2, 0, $row[1]); $expor_excel->MontaConteudo($linha+2, 1, $row[2]); } } if(empty($export)) echo "\n"; $linha++; } } if(empty($export)) { echo ""; echo ""; echo ""; echo ""; echo ""; echo "\n"; echo "
 ".$GUI_LANG['TheDescriptionIsAccessible'].":".$GUI_LANG['PhoneNumber']."".$GUI_LANG['Description']." 
\"\"
".$GUI_LANG['OnlyForMe']." ".$GUI_LANG['ForEverybody']."
\"".$GUI_LANG['Cancel']."\"\"\"$viewMe$FontColor".htmlspecialchars($row[1])."$FontColorEnd".htmlspecialchars($row[2])."\"".$GUI_LANG['Edit']."\""; echo "\"".$GUI_LANG['Delete']."\"
\"\"
".$GUI_LANG['OnlyForMe']." ".$GUI_LANG['ForEverybody']."
"; } if(empty($export)){ include("../include/set/footer.html"); }else{ $expor_excel->GeraArquivo(); } ?>