/** * Добавляем пользователя с текущими данными * @global type $sqlcn */ function Add() { global $sqlcn; // хешируем пароль $this->salt = generateSalt(); $this->password = sha1(sha1($this->pass) . $this->salt); $sql = "INSERT INTO users (id, randomid, orgid, login, pass, `password`, salt,\n\t\t\temail, mode, lastdt, active) VALUES (NULL, '{$this->randomid}'," . " '{$this->orgid}', '{$this->login}', '{$this->pass}'," . " '{$this->password}', '{$this->salt}', " . " '{$this->email}', '{$this->mode}', NOW(), 1)"; $sqlcn->ExecuteSQL($sql) or die('Неверный запрос Tusers.Add (1): ' . mysqli_error($sqlcn->idsqlconnection)); $fio = $this->fio; $code = $this->tab_num; $telephonenumber = $this->telephonenumber; $homephone = $this->homephone; $jpegphoto = $this->jpegphoto; $rid = $this->randomid; $post = $this->post; $zx = new Tusers(); if ($zx->GetByRandomIdNoProfile($rid)) { // добавляю профиль $sql = "INSERT INTO users_profile (id, usersid, fio, code,\n\t\t\t\ttelephonenumber, homephone, jpegphoto, post, faza, enddate,\n\t\t\t\tres1) VALUES (NULL, '{$zx->id}', '{$fio}', '{$code}'," . " '{$telephonenumber}', '{$homephone}', '{$jpegphoto}'," . " '{$post}', '', NOW(), '')"; $sqlcn->ExecuteSQL($sql) or die('Неверный запрос Tusers.Add(2): ' . mysqli_error($sqlcn->idsqlconnection)); } else { die('Не найден пользователь по randomid Tusers.Add'); } }
function Add() { // добавляем пользователя с текущими данными global $sqlcn; $sql = "INSERT INTO users (id,randomid,orgid,login,pass,email,mode,lastdt,active) VALUES\n (NULL,'{$this->randomid}','{$this->orgid}','{$this->login}','{$this->pass}',\n '{$this->email}','{$this->mode}',now(),1)"; $result = $sqlcn->ExecuteSQL($sql); if ($result == '') { die('Неверный запрос Tusers.Add (1): ' . mysqli_error($sqlcn->idsqlconnection)); } $fio = $this->fio; $code = $this->tab_num; $telephonenumber = $this->telephonenumber; $homephone = $this->homephone; $jpegphoto = $this->jpegphoto; $rid = $this->randomid; $post = $this->post; $zx = new Tusers(); if ($zx->GetByRandomIdNoProfile($rid) == true) { // добавляю профиль $sql = "INSERT INTO users_profile (id,usersid,fio,code,telephonenumber,homephone,jpegphoto,post,faza,enddate,res1) VALUES\n (NULL,'{$zx->id}','{$fio}','{$code}','{$telephonenumber}',\n '{$homephone}','{$jpegphoto}','{$post}','',now(),'')"; $result = $sqlcn->ExecuteSQL($sql); } else { die('Не найден пользователь по randomid Tusers.Add'); } if ($result == '') { die('Неверный запрос Tusers.Add(2): ' . mysqli_error($sqlcn->idsqlconnection)); } }