people.class.php
3.78 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
<?php
Class People{
private $db;
private $lang;
function __construct($lang){
$this->db = sdb::getInstance();
$this->lang = $lang;
}
public function valid($data){
$error = array();
if(isset($data['name'])){
if( !preg_match("/.{1,100}/i",$data['name']) ) $error[] = "Îøèáêà ââîäà ïîëÿ Èìÿ (Ìàêñèìóì 100 ñèìâîëîâ).";
}
if(isset($data['email'])){
if( !preg_match("/^([^@]+)+@([^@]+)\.([^@]+)$/i",$data['email']) || strlen($data['email'])>80 ) $error[] = "Îøèáêà ââîäà ïîëÿ E-mail, äî 80 ñèìâîëîâ.";
elseif($this->isEmail($data['email']))$error[] = "Îøèáêà ââîäà ïîëÿ E-mail, òàêîé E-mail óæå çàðåãèñòðèðîâàí.";
}
if(isset($data['psw'])){
if( !preg_match("/.{1,100}/i",$data['psw']) ) $error[] = "Îøèáêà ââîäà ïîëÿ Ïàðîëü (Ìàêñèìóì 100 ñèìâîëîâ).";
elseif($data['psw']!=$data['psw_to'])$error[] = "Îøèáêà ââîäà ïîëÿ Ïàðîëü è ïîëÿ Ïîâòîðèòü ïàðîëü.";
}
return $error;
}
private function password(){
$chars="qazxswedcvfrtgbnhyujmkiolp1234567890QAZXSWEDCVFRTGBNHYUJMKIOLP";
$max=10;
$size=StrLen($chars)-1;
$password=null;
while($max--)
$password.=$chars[rand(0,$size)];
return $password;
}
public function saveOrder($people_id,$data){
$table_name = "people_orders";
$fields_values = array('people_id'=>$people_id,
'name'=>$data['order_name'],
'adress'=>$data['order_adress'],
'email'=>$data['order_email'],
'phone'=>$data['order_phone'],
'comment'=>$data['order_comment']
);
$this->db->autoExecute($table_name, $fields_values, DB_AUTOQUERY_INSERT);
return mysql_insert_id();
}
public function save($data){
$table_name = "people";
$fields_values = array('email'=>$data['email'],'psw'=>$data['psw'],'name'=>$data['name']);
$this->db->autoExecute($table_name, $fields_values, DB_AUTOQUERY_INSERT);
return mysql_insert_id();
}
public function savePeople($data){
$table_name = "people";
$fields_values = array('email'=>$data['order_email'],'psw'=>$this->password(),'name'=>$data['order_name']);
$this->db->autoExecute($table_name, $fields_values, DB_AUTOQUERY_INSERT);
return mysql_insert_id();
}
public function login($data){
$error = array();
$id = $this->db->getOne("select id from people where email=? and psw=?",array($data['login'],$data['psw']));
if(!$id)$error[] = "Îøèáêà ââîäà ëîãèíà èëè ïàðîëÿ!";
return $error;
}
public function isLogin(){
return $this->db->getOne("select id from people where email=? and psw=?",array($_SESSION['people']['login'], $_SESSION['people']['psw']));
}
public function isEmail($email){
return $this->db->getOne("select id from people where email=?",array($email));
}
public function is_login_session(){
if( $this->db->getOne("select count(*) from people where email=? and psw=?",array($_SESSION['people']['login'], $_SESSION['people']['psw'])) ) return true;
return false;
}
public function getLogin(){
return $this->db->getRow("select * from people where email=? and psw=?",array($_SESSION['people']['login'], $_SESSION['people']['psw']),DB_FETCHMODE_ASSOC);
}
public function sendLoginPswPeople($people_id){
$row = $this->db->getRow("select * from people where id=?",array($people_id),DB_FETCHMODE_ASSOC);
$mail = new PHPMailer();
$mail->CharSet = "windows-1251";
$mail->From = "send@gopro.com.ua";
$mail->FromName = "GoPro";
$mail->AddAddress($row['email'], $row['name']);
$mail->Subject = "Íàïîìèíàíèå ïàðîëÿ";
$msg = "Çäðàâñòâóéòå, ".$row['name']." !<br />";
$msg .= "Äëÿ âõîäà â ëè÷íûé êàáèíåò èñïîëüçóéòå ñëåäóþùèå äàííûå:<br />";
$msg .= "ËÎÃÈÍ: ".$row['email']."<br />";
$msg .= "ÏÀÐÎËÜ: ".$row['psw']."<br />";
$msg .= "Æåëàåì ïðèÿòíûõ ïîêóïîê!";
$mail->MsgHTML($msg);
if(!$mail->Send()){echo "There has been a mail error sending to <br>";return false;}
$mail->ClearAddresses();
$mail->ClearAttachments();
}
}
?>