100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
|
{
$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 users_categories AS c ON c.id = m.id_category
WHERE m.%1$s = ? COLLATE NOCASE AND c.perm_connect >= %2$d
LIMIT 1;';
$query = sprintf($query, $champ_id, self::ACCESS_READ);
return $this->db->first($query, $login);
}
|
|
|
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
|
{
$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 users_categories AS c ON c.id = m.id_category
WHERE m.%1$s = ? COLLATE U_NOCASE AND c.perm_connect >= %2$d
LIMIT 1;';
$query = sprintf($query, $champ_id, self::ACCESS_READ);
return $this->db->first($query, $login);
}
|
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
|
public function recoverPasswordSend($id)
{
$db = DB::getInstance();
$config = Config::getInstance();
$champ_id = $config->get('champ_identifiant');
$membre = $db->first('SELECT id, email, passe, clef_pgp FROM membres WHERE '.$champ_id.' = ? COLLATE NOCASE LIMIT 1;', trim($id));
if (!$membre || trim($membre->email) == '')
{
return false;
}
// valide pour 1 heure minimum
|
|
|
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
|
public function recoverPasswordSend($id)
{
$db = DB::getInstance();
$config = Config::getInstance();
$champ_id = $config->get('champ_identifiant');
$membre = $db->first('SELECT id, email, passe, clef_pgp FROM membres WHERE '.$champ_id.' = ? COLLATE U_NOCASE LIMIT 1;', trim($id));
if (!$membre || trim($membre->email) == '')
{
return false;
}
// valide pour 1 heure minimum
|