BuddyPress.org

@bplove please share if you find a way to do it, I’m looking forward to do it too

For the benefit of anyone else attempting to implement this, the above post is incorrect. Buddypress implemented @mention listing by searching the text of all activity updates. The function to query for activity (BP_Activity_Activity:get) allows you to query by user id AND search term, but not user id OR search term, as this feature requires.

The only way I was able to get this working was by hacking bp-activity-classes.php, and updating the user_id sql in the get_filter_sql function. The updated code is as follows:

`if ( !empty( $filter_array ) ) {
$user_filter = explode( ‘,’, $filter_array );
$user_sql = ” ( a.user_id IN ( ” . $filter_array . ” ) “;
foreach ( $user_filter as $user_id ) {
$search_terms = ‘@’ . bp_core_get_username( $user_id ) . ‘<';
$user_sql .= “OR ( a.content LIKE ‘%%”.like_escape($search_terms).”%%’ ) “;
}
$user_sql .= ” ) “;
$filter_sql[] = $user_sql;
}`

If someone has a more elegant solution, please let me know!

does not work for me boone

Not sure if anyone else still needs the ability to combine @mentions with the personal activity stream. I took the guidance of @mattamatic with an alteration to get it working with BP 1.7 (beta 2, in my case).

I opened up `buddypress/bp-activity/bp-activity-classes.php`, found `lines 620-624` (part of the get_filter_sql function), and changed it from:

`if ( !empty( $filter_array[‘user_id’] ) ) {
$user_sql = BP_Activity_Activity::get_in_operator_sql( ‘a.user_id’, $filter_array[‘user_id’] );
if ( !empty( $user_sql ) )
$filter_sql[] = $user_sql;
}`

To:

`if ( !empty( $filter_array[‘user_id’] ) ) {
$user_sql = BP_Activity_Activity::get_in_operator_sql( ‘a.user_id’, $filter_array[‘user_id’] );
// START Also include @Mentions in User Stream
$search_terms = ‘@’.bp_core_get_username($user_id);
$user_sql.= “OR ( a.content LIKE ‘%%”.like_escape($search_terms).”%%’ )”;
// END Also include @Mentions in User Stream
if ( !empty( $user_sql ) )
$filter_sql[] = $user_sql;
}`

Works for me on BuddyPress 1.7-beta2 (wish there was a non-hacked way to combine multiple scopes for the activity stream). Also, I should mention that you really only need to add the parts between the START/END comments, but I included the rest for context.

Thanks again @mattamatic!

Turns out there was an issue I didn’t catch until I noticed @mentions were showing up for more than just the specified user. Below is the updated code (really, it’s just a matter of swapping out $user_id for $filter_array[‘user_id’] in the edited code mentioned above). This is working on BuddyPress 1.7.1.

I opened up buddypress/bp-activity/bp-activity-classes.php, found lines 620-624 (part of the get_filter_sql function), and changed it from:

if ( !empty( $filter_array['user_id'] ) ) {
	$user_sql = BP_Activity_Activity::get_in_operator_sql( 'a.user_id', $filter_array['user_id'] );
	if ( !empty( $user_sql ) )
		$filter_sql[] = $user_sql;
}

To:

if ( !empty( $filter_array['user_id'] ) ) {
	$user_sql = BP_Activity_Activity::get_in_operator_sql( 'a.user_id', $filter_array['user_id'] );
	// START Also include @Mentions in User Stream
	$search_terms = '@'.bp_core_get_username($filter_array['user_id']);
	$user_sql.= "OR ( a.content LIKE '%%".like_escape($search_terms)."%%' )";
	// END Also include @Mentions in User Stream
	if ( !empty( $user_sql ) )
		$filter_sql[] = $user_sql;
}

thanks @kzeni have been looking this just the solution 🙂