INNER JOIN `group_member`
ON `contact`.`id` = `group_member`.`contact-id`
WHERE `gid` = ?
- AND `group_member`.`uid` = ?
+ AND `contact`.`uid` = ?
AND NOT `contact`.`self`
AND NOT `contact`.`blocked`
AND NOT `contact`.`pending`
INNER JOIN `group_member`
ON `contact`.`id` = `group_member`.`contact-id`
WHERE `gid` = ?
- AND `group_member`.`uid` = ?
+ AND `contact`.`uid` = ?
AND `contact`.`network` = ?
AND `contact`.`notify` != ""',
$gid,
public static function createSelfFromUserId($uid)
{
// Only create the entry if it doesn't exist yet
- if (dba::exists('contact', ['uid' => intval($uid), 'self'])) {
+ if (dba::exists('contact', ['uid' => $uid, 'self' => true])) {
return true;
}
- $user = dba::select('user', ['uid', 'username', 'nickname'], ['uid' => intval($uid)], ['limit' => 1]);
+ $user = dba::select('user', ['uid', 'username', 'nickname'], ['uid' => $uid], ['limit' => 1]);
if (!DBM::is_result($user)) {
return false;
}
AND NOT `pending`
AND `id` NOT IN (
SELECT DISTINCT(`contact-id`)
- FROM `group_member` WHERE `uid` = %d
+ FROM `group_member`
+ INNER JOIN `group` ON `group`.`id` = `group_member`.`gid`
+ WHERE `group`.`uid` = %d
)
LIMIT %d, %d", intval($uid), intval($uid), intval($start), intval($count)
);