41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
|
public function login($email, $passe)
{
if (!filter_var($email, FILTER_VALIDATE_EMAIL))
return false;
$db = Garradin_DB::getInstance();
$r = $db->querySingle('SELECT * FROM membres WHERE email=\''.$db->escapeString($email).'\' LIMIT 1;', true);
if (empty($r))
return false;
if (!$this->_checkPassword($passe, $r['passe']))
return false;
$droits = $this->getDroits($r['id_categorie']);
if ($droits['connexion'] == self::DROIT_AUCUN)
return false;
|
>
>
>
>
|
|
|
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
|
public function login($email, $passe)
{
if (!filter_var($email, FILTER_VALIDATE_EMAIL))
return false;
$db = Garradin_DB::getInstance();
$r = $db->simpleQuerySingle('SELECT *,
strftime(\'%s\', date_connexion) AS date_connexion,
strftime(\'%s\', date_inscription) AS date_inscription,
strftime(\'%s\', date_cotisation) AS date_cotisation
FROM membres WHERE email = ? LIMIT 1;', true, trim($email));
if (empty($r))
return false;
if (!$this->_checkPassword(trim($passe), $r['passe']))
return false;
$droits = $this->getDroits($r['id_categorie']);
if ($droits['connexion'] == self::DROIT_AUCUN)
return false;
|