- $stmt = DBA::p(
- "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`"
- );
-
- return DBA::toArray($stmt);
+ return DBA::selectToArray('pending-view', [], [], ['limit' => [$start, $count]]);
+ }
+
+ /**
+ * Returns the pending user based on a given user id
+ *
+ * @param int $uid The user id
+ *
+ * @return array|bool Array on succes, false on failure
+ * @throws \Exception
+ */
+ public static function getPendingForUser(int $uid)
+ {
+ return DBA::selectFirst('pending-view', [], ['uid' => $uid, 'self' => true]);