- $r = q("SELECT `uid`,`username`,`nickname` FROM `user` WHERE `password` = '%s' AND `email` = '%s' AND `account_removed` = 0 ",
- dbesc($master_record['password']),
- dbesc($master_record['email'])
- );
- if (dbm::is_result($r))
- $a->identities = $r;
- else
- $a->identities = array();
-
- $r = q("select `user`.`uid`, `user`.`username`, `user`.`nickname`
- from manage INNER JOIN user on manage.mid = user.uid where `user`.`account_removed` = 0
- and `manage`.`uid` = %d",
- intval($master_record['uid'])
+ $r = dba::select('user', ['uid', 'username', 'nickname'],
+ ['password' => $master_record['password'], 'email' => $master_record['email'], 'account_removed' => false]);
+ if (DBM::is_result($r)) {
+ $a->identities = dba::inArray($r);
+ } else {
+ $a->identities = [];
+ }
+
+ $r = dba::p("SELECT `user`.`uid`, `user`.`username`, `user`.`nickname`
+ FROM `manage`
+ INNER JOIN `user` ON `manage`.`mid` = `user`.`uid`
+ WHERE `user`.`account_removed` = 0 AND `manage`.`uid` = ?",
+ $master_record['uid']