38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
|
{
$champ_id = Config::getInstance()->get('champ_identifiant');
// Ne renvoie un membre que si celui-ci a le droit de se connecter
$query = 'SELECT m.id, m.%1$s AS login, m.passe AS password, m.secret_otp AS otp_secret
FROM membres AS m
INNER JOIN membres_categories AS mc ON mc.id = m.id_categorie
WHERE m.%1$s = ? AND mc.droit_connexion >= %2$d
LIMIT 1;';
$query = sprintf($query, $champ_id, Membres::DROIT_ACCES);
return $this->db->first($query, $login);
}
|
|
|
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
|
{
$champ_id = Config::getInstance()->get('champ_identifiant');
// Ne renvoie un membre que si celui-ci a le droit de se connecter
$query = 'SELECT m.id, m.%1$s AS login, m.passe AS password, m.secret_otp AS otp_secret
FROM membres AS m
INNER JOIN membres_categories AS mc ON mc.id = m.id_categorie
WHERE m.%1$s = ? COLLATE NOCASE AND mc.droit_connexion >= %2$d
LIMIT 1;';
$query = sprintf($query, $champ_id, Membres::DROIT_ACCES);
return $this->db->first($query, $login);
}
|