aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorzotlabs <mike@macgirvin.com>2017-06-01 21:22:56 -0700
committerzotlabs <mike@macgirvin.com>2017-06-01 21:22:56 -0700
commitf3061651d448fed44dcd628d2d4a2ad4e63a70f4 (patch)
tree54afefd21ae000757b5c90abeb67a5a7034f42f3
parente2d028fb97b2d877c029d1fba8c34589250004da (diff)
downloadvolse-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.php71
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))