| | |
| | | /** |
| | | * DB based User-to-Email and Email-to-User lookup |
| | | * |
| | | * Add it to the plugins list in config/main.inc.php and set |
| | | * Add it to the plugins list in config.inc.php and set |
| | | * SQL queries to resolve usernames, e-mail addresses and hostnames from the database |
| | | * %u will be replaced with the current username for login. |
| | | * %m will be replaced with the current e-mail address for login. |
| | |
| | | { |
| | | $dbh = $this->get_dbh(); |
| | | |
| | | $sql_result = $dbh->query(preg_replace('/%u/', $dbh->escapeSimple($p['user']), $this->config['email'])); |
| | | $sql_result = $dbh->query(preg_replace('/%u/', $dbh->escape($p['user']), $this->config['email'])); |
| | | |
| | | while ($sql_arr = $dbh->fetch_array($sql_result)) { |
| | | if (strpos($sql_arr[0], '@')) { |
| | |
| | | $result[] = $sql_arr[0]; |
| | | } |
| | | |
| | | if ($p['first']) |
| | | if ($p['first']) { |
| | | break; |
| | | } |
| | | } |
| | | } |
| | | |
| | |
| | | { |
| | | $dbh = $this->get_dbh(); |
| | | |
| | | $sql_result = $dbh->query(preg_replace('/%m/', $dbh->escapeSimple($p['email']), $this->config['user'])); |
| | | $sql_result = $dbh->query(preg_replace('/%m/', $dbh->escape($p['email']), $this->config['user'])); |
| | | |
| | | if ($sql_arr = $dbh->fetch_array($sql_result)) { |
| | | $p['user'] = $sql_arr[0]; |
| | |
| | | { |
| | | $dbh = $this->get_dbh(); |
| | | |
| | | $sql_result = $dbh->query(preg_replace('/%u/', $dbh->escapeSimple($p['user']), $this->config['host'])); |
| | | $sql_result = $dbh->query(preg_replace('/%u/', $dbh->escape($p['user']), $this->config['host'])); |
| | | |
| | | if ($sql_arr = $dbh->fetch_array($sql_result)) { |
| | | $p['host'] = $sql_arr[0]; |