- return DBA::fetchFirst(
- "SELECT `register`.*, `contact`.`name`, `contact`.`url`, `contact`.`micro`, `user`.`email`
- FROM `register`
- INNER JOIN `contact` ON `register`.`uid` = `contact`.`uid`
- INNER JOIN `user` ON `register`.`uid` = `user`.`uid`
- WHERE `register`.uid = ?",
- $uid
- );
+ return DBA::selectFirst('pending-view', [], ['uid' => $uid, 'self' => true]);