diff options
author | zotlabs <mike@macgirvin.com> | 2017-06-01 21:22:56 -0700 |
---|---|---|
committer | zotlabs <mike@macgirvin.com> | 2017-06-01 21:22:56 -0700 |
commit | f3061651d448fed44dcd628d2d4a2ad4e63a70f4 (patch) | |
tree | 54afefd21ae000757b5c90abeb67a5a7034f42f3 | |
parent | e2d028fb97b2d877c029d1fba8c34589250004da (diff) | |
download | volse-hubzilla-f3061651d448fed44dcd628d2d4a2ad4e63a70f4.tar.gz volse-hubzilla-f3061651d448fed44dcd628d2d4a2ad4e63a70f4.tar.bz2 volse-hubzilla-f3061651d448fed44dcd628d2d4a2ad4e63a70f4.zip |
Revert "include/socgraph - remove a few obsolete and long-deprecated functions"
This reverts commit e2d028fb97b2d877c029d1fba8c34589250004da.
-rw-r--r-- | include/socgraph.php | 71 |
1 files changed, 71 insertions, 0 deletions
diff --git a/include/socgraph.php b/include/socgraph.php index 9a6245d01..69365f80f 100644 --- a/include/socgraph.php +++ b/include/socgraph.php @@ -243,6 +243,77 @@ function common_friends($uid,$xchan,$start = 0,$limit=100000000,$shuffle = false } +function count_common_friends_zcid($uid,$zcid) { + + $r = q("SELECT count(*) as total + FROM glink left join gcontact on glink.gcid = gcontact.id + where glink.zcid = %d + and gcontact.nurl in (select nurl from contact where uid = %d and self = 0 and blocked = 0 and hidden = 0 ) ", + intval($zcid), + intval($uid) + ); + + if(count($r)) + return $r[0]['total']; + + return 0; +} + +function common_friends_zcid($uid,$zcid,$start = 0, $limit = 9999,$shuffle = false) { + + if($shuffle) + $sql_extra = " order by rand() "; + else + $sql_extra = " order by gcontact.name asc "; + + $r = q("SELECT gcontact.* + FROM glink left join gcontact on glink.gcid = gcontact.id + where glink.zcid = %d + and gcontact.nurl in (select nurl from contact where uid = %d and self = 0 and blocked = 0 and hidden = 0 ) + $sql_extra limit %d offset %d", + intval($zcid), + intval($uid), + intval($limit), + intval($start) + ); + + return $r; +} + + +function count_all_friends($uid,$cid) { + + $r = q("SELECT count(*) as total + FROM glink left join gcontact on glink.gcid = gcontact.id + where glink.cid = %d and glink.uid = %d ", + intval($cid), + intval($uid) + ); + + if(count($r)) + return $r[0]['total']; + + return 0; +} + + +function all_friends($uid,$cid,$start = 0, $limit = 80) { + + $r = q("SELECT gcontact.* + FROM glink left join gcontact on glink.gcid = gcontact.id + where glink.cid = %d and glink.uid = %d + order by gcontact.name asc LIMIT %d OFFSET %d ", + intval($cid), + intval($uid), + intval($limit), + intval($start) + ); + + return $r; +} + + + function suggestion_query($uid, $myxchan, $start = 0, $limit = 80) { if((! $uid) || (! $myxchan)) |