$tb->execute(array(':reply_login'=>$username,':reply_msg'=>$repl_msg)); } function ChangeChk($username,$autoCheck){ $sql = 'UPDATE bcc SET active=:active_chk WHERE bcc_name = :reply_login'; $tb = $this->db->connection->prepare($sql); $tb->execute(array(':reply_login'=>$username,':active_chk'=>$autoCheck)); } function writeLoging($inneruserId,$rzlt){ $sql = 'INSERT INTO loging (`tmlog`,`login_id`,`moving`,`rzlt`,`vargroup`,`ipuser`) VALUES (NOW(),:login_id,"редактирование",:rzlt,"2","'.$_SERVER["REMOTE_ADDR"].'")'; $tb = $this->dbIt->connection->prepare($sql); $tb->execute(array(':login_id'=>$inneruserId,':rzlt'=>$rzlt)); } } $getData = new mainpage_query(); $arrLogin = $getData ->getAllfromtable($user_id,$username,$datefrom,$email,$datefrom,$dateto); $getData ->writeLoging($_SESSION['user_id'],$username); //--auto replay msg $arrCheck = $getData ->checkIfExAutoReply($bcc_names); if($arrCheck['bcc_id']){ if(!$repl_msg==''){ $getData ->UpdAutoReply($bcc_names,$repl_msg); } $arrChkBox = $getData -> ChangeChk($bcc_names,$autoCheck); }else{ $arrInsertRepl = $getData ->writeInAutoReply($bcc_names,$bcc_maps,$repl_msg,$autoCheck); } ?>
$tb->execute(array(':login'=>$username)); $this->arrBest = $tb->fetch(PDO::FETCH_ASSOC); return $this->arrBest; } function writeLoging($inneruserId,$rzlt){ $sql = 'INSERT INTO loging (`tmlog`,`login_id`,`moving`,`rzlt`,`vargroup`,`ipuser`) VALUES (NOW(),:login_id,"мн. удаление",:rzlt,"1","'.$_SERVER["REMOTE_ADDR"].'")'; $tb = $this->dbIt->connection->prepare($sql); $tb->execute(array(':login_id'=>$inneruserId,':rzlt'=>$rzlt)); } } //print_r($_GET); $count=0; $dellData = new mainpage_query(); foreach($_GET as $DelUsers){ $count++; $userGet = $dellData -> getDatafromtableUsers($DelUsers); if(count($_GET)==$count){ $email .= $userGet['login']; }else{ $email .= $userGet['login'] .', '; } $dellData ->Deletefromtable($DelUsers); } $dellData ->writeLoging($_SESSION['user_id'],$email); ?>
$sername = $userData['staff_lastname']; $username = $userData['staff_name']; } $sql = 'UPDATE users SET login=:login, password=:password, email=:email, sername=:sername, name=:username, mailbox=:mailbox, userdate=:userdate, domain_id=:domain_id, active=:active, staff_id=:staff_id WHERE user_id=:user_id'; $tb = $this->db->connection->prepare($sql); $tb->execute(array(':user_id'=>$user_id,':login'=>$login,':password'=>$password,':email'=>$email,':username'=>$username,':sername'=>$sername,':mailbox'=>$mailbox,':userdate'=>date('Y-m-d',strtotime($userdate)),':domain_id'=>$domain_id,':active'=>$active,':staff_id'=>$profile_create)); /*$this->arrBest = $tb->fetch(PDO::FETCH_ASSOC); return $this->arrBest;*/ } function writeLoging($inneruserId,$rzlt){ $sql = 'INSERT INTO loging (`tmlog`,`login_id`,`moving`,`rzlt`,`vargroup`,`ipuser`) VALUES (NOW(),:login_id,"редактирование",:rzlt,"1","'.$_SERVER["REMOTE_ADDR"].'")'; $tb = $this->dbIt->connection->prepare($sql); $tb->execute(array(':login_id'=>$inneruserId,':rzlt'=>$rzlt)); } function writeLogingBlocking($inneruserId,$rzlt){ $sql = 'INSERT INTO loging (`tmlog`,`login_id`,`moving`,`rzlt`,`vargroup`) VALUES (NOW(),:login_id,"блокирование",:rzlt,"1")'; $tb = $this->db->connection->prepare($sql); $tb->execute(array(':login_id'=>$inneruserId,':rzlt'=>$rzlt)); } } $getData = new mainpage_query(); $arrLogin = $getData ->getAllfromtable($user_id,$login,$password,$email,$username,$sername,$mailbox,$userdate,$domain_id,$active,$profile_create); $getData ->writeLoging($_SESSION['user_id'],$login); if(empty($active)){ $getData ->writeLogingBlocking($_SESSION['user_id'],$login); } ?>
$tb = $this->db->connection->prepare($sql); $tb->execute(array(':alias_id'=>$param)); } function getDatafromtableUsers($username){ $sql = 'SELECT * FROM aliases WHERE alias_id = :login'; $tb = $this->db->connection->prepare($sql); $tb->execute(array(':login'=>$username)); $this->arrBest = $tb->fetch(PDO::FETCH_ASSOC); return $this->arrBest; } function writeLoging($inneruserId,$rzlt){ $sql = 'INSERT INTO loging (`tmlog`,`login_id`,`moving`,`rzlt`,`vargroup`,`ipuser`) VALUES (NOW(),:login_id,"удаление",:rzlt,"2","'.$_SERVER["REMOTE_ADDR"].'")'; $tb = $this->dbIt->connection->prepare($sql); $tb->execute(array(':login_id'=>$inneruserId,':rzlt'=>$rzlt)); } } //print_r($_GET); $dellData = new mainpage_query(); $userGet = $dellData -> getDatafromtableUsers($param); $dellData -> writeLoging($_SESSION['user_id'],$userGet['username']); $dellData ->Deletefromtable($param); ?>
function getDatafromtable($username){ $sql = 'SELECT `alias_id`,`username`,`alias` FROM aliases WHERE username = :login ORDER BY alias_id DESC'; $tb = $this->db->connection->prepare($sql); $tb->execute(array(':login'=>$username)); $this->arrBest = $tb->fetch(PDO::FETCH_ASSOC); return $this->arrBest; } } $getData = new mainpage_query(); $arrLogin = $getData ->getAllfromtable($username,$datefrom,$email,$datefrom,$dateto); //--auto replay msg $arrCheck = $getData ->checkIfExAutoReply($bcc_names); if($arrCheck['bcc_id']){ if(!$repl_msg==''){ $getData ->UpdAutoReply($bcc_names,$repl_msg); } $arrChkBox = $getData -> ChangeChk($bcc_names,$autoCheck); }else{ $arrInsertRepl = $getData ->writeInAutoReply($bcc_names,$bcc_maps,$repl_msg,$autoCheck); } $getter = $getData ->getDatafromtable($username); $getData ->writeLoging($_SESSION['user_id'],$username .' -> ('.$email.')'); require 'template_right_side_alias.php'; ?>