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 |