$tb->execute(array(':domain_id'=>$domain_id,':login'=>$login,':password'=>$password,':email'=>$emails,':name'=>$user_name,':sername'=>$user_last_name,':active'=>$active,':mailbox'=>$mailbox,':staff_id'=>$profile_create));
}
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 getAllfromtable($login_request){
$sql = 'SELECT `user_id`,`email`,`email`, CONCAT(`sername`," ",`name`) as fio, `password` FROM users WHERE login = :login';
$tb = $this->db->connection->prepare($sql);
$tb->execute(array(':login'=>$login_request));
$this->arrBest = $tb->fetch(PDO::FETCH_ASSOC);
return $this->arrBest;
}
}
$workData = new main_query();
$checkLogin = $workData ->getAllfromtable($login);
if(!$checkLogin['user_id']){
$writer = $workData -> writeDate($domain_id,$login,$domain,$password,$emails,$user_name,$user_last_name,$active,$mailbox,$profile_create);
}
$getter = $workData ->getAllfromtable($login);
$workData ->writeLoging($_SESSION['user_id'],$login);
//--Mail Sender
if($checkBox=='1'){
$to= $emails;
$subject = 'Добро пожаловать в группу компаний "БиоЛайн"';
slaap(0.2);
class main_query{
public $arrBest;
public $db;
function __construct(){
$this->db = new Database();
}
function writeDate($username,$emails,$datefrom,$dateto){
$sql = 'INSERT INTO aliases (`username`,`alias`,`aliasdatefrom`,`aliasdateto`) VALUES (:username,:alias,:aliasdatefrom,:aliasdateto)';
$tb = $this->db->connection->prepare($sql);
$tb->execute(array(':username'=>$username,':alias'=>$emails,':aliasdatefrom'=>date("Y-m-d H:i:s", strtotime($datefrom)),':aliasdateto'=>date("Y-m-d H:i:s", strtotime($dateto))));
}
function getAllfromtable($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;
}
}
$workData = new main_query();
$writer = $workData -> writeDate($username,$emails,$datefrom,$dateto);
$getter = $workData ->getAllfromtable($username);
require 'template_right_side_alias.php';
?>
