lib/db/collectedaddressmapper.php 1 location
|
@@ 53-60 (lines=8) @@
|
| 50 |
|
return $this->findEntities($sql, $params); |
| 51 |
|
} |
| 52 |
|
|
| 53 |
|
public function exists($userId, $email) { |
| 54 |
|
$sql = 'SELECT * FROM *PREFIX*mail_collected_addresses WHERE `user_id` = ? AND `email` ILIKE ?'; |
| 55 |
|
$params = [ |
| 56 |
|
$userId, |
| 57 |
|
$email |
| 58 |
|
]; |
| 59 |
|
return count($this->findEntities($sql, $params)) > 0; |
| 60 |
|
} |
| 61 |
|
|
| 62 |
|
} |
| 63 |
|
|
lib/db/mailaccountmapper.php 1 location
|
@@ 65-73 (lines=9) @@
|
| 62 |
|
return $this->findEntities($sql, $params); |
| 63 |
|
} |
| 64 |
|
|
| 65 |
|
public function findByEmail($email, $userId) { |
| 66 |
|
$sql = 'SELECT * FROM ' . $this->getTableName() . ' WHERE user_id = ? and email = ?'; |
| 67 |
|
$params = [ |
| 68 |
|
$userId, |
| 69 |
|
$email, |
| 70 |
|
]; |
| 71 |
|
|
| 72 |
|
return $this->findEntities($sql, $params); |
| 73 |
|
} |
| 74 |
|
|
| 75 |
|
/** |
| 76 |
|
* Saves an User Account into the database |