<?php
Class Auth{
 private $login = 'adm';
 private $psw = '123';
 private $db;
 
 function __construct(){
  $this->db = sdb::getInstance();
 }
 
 public function valid($data,$id = 0){
  $error = array();

  if(!preg_match("/.{1,50}/i",$data['login']))$error[] = "Îøèáêà ââîäà Ëîãèí!";
  elseif($this->is_login($data['login'],$id))$error[] = "Òàêîé Ëîãèí óæå åñòü!";
  
  if(!preg_match("/.{1,50}/i",$data['psw']))$error[] = "Îøèáêà ââîäà Ïàðîëü!";

  return $error;
 }
 
 private function is_login($login,$id){
  $sql = "select count(*) from users where login=?";
  if($id>0)$sql .= sprintf(" and id<>'%d'", $id);
  return $this->db->getOne($sql,array($login));
 }
 
 public function save($data){
   $fields_values = array(
   'login'=>$data['login'],
   'psw'=>$data['psw'],
   );
   if(isset($data['update_id']) && $data['update_id']>0){$DB_AUTOQUERY = DB_AUTOQUERY_UPDATE;$where = "id='{$data['update_id']}'";}
   else $DB_AUTOQUERY = DB_AUTOQUERY_INSERT;

   $this->db->autoExecute("users", $fields_values, $DB_AUTOQUERY,$where);
 }
 
 public function delete($id){
  return $this->db->query("delete from users where id=?",array($id));
 }

 public function view($id){
  return $this->db->getRow("select * from users where id=?",array($id),DB_FETCHMODE_ASSOC);
 }
 
 public function login($login,$psw){
  if( $this->db->getOne("select count(*) from users where login=? and psw=?",array($login, $psw)) ){
   $_SESSION['login'] = $login;
   $_SESSION['psw'] = $psw;
   return true;
  }
  return false;
 }
 
 public function is_login_session(){
  if( $this->db->getOne("select count(*) from users where login=? and psw=?",array($_SESSION['login'], $_SESSION['psw'])) ) return true;
  return false;
 }
 
 public function _exit(){
  unset($_SESSION['login']);
  unset($_SESSION['psw']);
 }
 
 public function getUsers(){
  $sql = "select * from users order by id";
  return $this->db->getAll($sql,array(),DB_FETCHMODE_ASSOC);
 }
}

?>