@@ -33,12 +33,18 @@ |
||
33 | 33 | return $this->findEntities($sql, [$user_id, $vault_id]); |
34 | 34 | } |
35 | 35 | |
36 | + /** |
|
37 | + * @param integer $vault_id |
|
38 | + */ |
|
36 | 39 | public function getRandomCredentialByVaultId($vault_id, $user_id) { |
37 | 40 | $sql = 'SELECT * FROM `*PREFIX*passman_credentials` ' . |
38 | 41 | 'WHERE `user_id` = ? and vault_id = ? AND shared_key is NULL ORDER BY RAND() LIMIT 1'; |
39 | 42 | return $this->findEntities($sql, [$user_id, $vault_id]); |
40 | 43 | } |
41 | 44 | |
45 | + /** |
|
46 | + * @param integer $timestamp |
|
47 | + */ |
|
42 | 48 | public function getExpiredCredentials($timestamp) { |
43 | 49 | $sql = 'SELECT * FROM `*PREFIX*passman_credentials` ' . |
44 | 50 | 'WHERE `expire_time` > 0 AND `expire_time` < ?'; |