$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); } ?>