diff options
author | friendica <info@friendica.com> | 2013-12-06 21:40:01 -0800 |
---|---|---|
committer | friendica <info@friendica.com> | 2013-12-06 21:40:01 -0800 |
commit | f45b06ffa004c6e6920214b64efe18e3cfe2d667 (patch) | |
tree | 83f0e15dedc9381448d95b02ee5968def3969085 /include | |
parent | 9354c33839359821111b57a2a3aea916819d9c4f (diff) | |
download | volse-hubzilla-f45b06ffa004c6e6920214b64efe18e3cfe2d667.tar.gz volse-hubzilla-f45b06ffa004c6e6920214b64efe18e3cfe2d667.tar.bz2 volse-hubzilla-f45b06ffa004c6e6920214b64efe18e3cfe2d667.zip |
suggestion widget
Diffstat (limited to 'include')
-rw-r--r-- | include/contact_widgets.php | 43 | ||||
-rw-r--r-- | include/socgraph.php | 4 |
2 files changed, 46 insertions, 1 deletions
diff --git a/include/contact_widgets.php b/include/contact_widgets.php index af05f8c9f..a6e66eb17 100644 --- a/include/contact_widgets.php +++ b/include/contact_widgets.php @@ -1,5 +1,6 @@ <?php /** @file */ + function follow_widget() { $a = get_app(); $uid =$a->channel['channel_id']; @@ -149,4 +150,44 @@ function common_friends_visitor_widget($profile_uid) { '$items' => $r )); -};
\ No newline at end of file +}; + + +function suggest_widget() { + + require_once('include/socgraph.php'); + + $r = suggestion_query(local_user(),get_observer_hash(),0,2); + + if(! $r) { + return; + } + + $arr = array(); + + foreach($r as $rr) { + + $connlnk = z_root() . '/follow/?url=' . $rr['xchan_addr']; + + $arr[] = array( + 'url' => chanlink_url($rr['xchan_url']), + 'name' => $rr['xchan_name'], + 'photo' => $rr['xchan_photo_m'], + 'ignlnk' => z_root() . '/suggest?ignore=' . $rr['xchan_hash'], + 'conntxt' => t('Connect'), + 'connlnk' => $connlnk, + 'ignore' => t('Ignore/Hide') + ); + } + + + $o = replace_macros(get_markup_template('suggest_widget.tpl'),array( + '$title' => t('Suggestions'), + '$more' => t('See more...'), + '$entries' => $arr + )); + + return $o; + +} + diff --git a/include/socgraph.php b/include/socgraph.php index b34d5142c..0e91eba60 100644 --- a/include/socgraph.php +++ b/include/socgraph.php @@ -287,11 +287,13 @@ function suggestion_query($uid, $myxchan, $start = 0, $limit = 80) { and not xlink_link in ( select xchan from xign where uid = %d ) and xlink_xchan != '' and not ( xchan_flags & %d ) + and not ( xchan_flags & %d ) group by xchan_hash order by total desc limit %d, %d ", intval($uid), intval($uid), intval($uid), intval(XCHAN_FLAGS_HIDDEN), + intval(XCHAN_FLAGS_DELETED), intval($start), intval($limit) ); @@ -305,10 +307,12 @@ function suggestion_query($uid, $myxchan, $start = 0, $limit = 80) { and not xlink_link in ( select abook_xchan from abook where abook_channel = %d ) and not xlink_link in ( select xchan from xign where uid = %d ) and not ( xchan_flags & %d ) + and not ( xchan_flags & %d ) group by xchan_hash order by total desc limit %d, %d ", intval($uid), intval($uid), intval(XCHAN_FLAGS_HIDDEN), + intval(XCHAN_FLAGS_DELETED), intval($start), intval($limit) ); |