BuddyPress.org

I have added the ‘include’ argument with ‘bp_has_activities’ function as

<?php if ( bp_has_activities( bp_ajax_querystring( 'activity' ) . '&action=activity_update&include='.$sorted_ids  ) ) : ?>

where the ‘$sorted_ids’ the comma separated activity id’s in sorted order. But unfortunatly the BuddyPress Core will sort the activities in ASC or DESC order.

I fount the Query used in core file ‘class-bp-activity-activity.php’ inside ‘plugins\buddypress\bp-activity\classes’ on line number : 585 as

// Query first for activity IDs.
$activity_ids_sql = "{$select_sql} {$from_sql} {$join_sql} {$where_sql} ORDER BY a.date_recorded {$sort}, a.id {$sort}";

and i have replaced it as

if($in)
$activity_ids_sql = "{$select_sql} {$from_sql} {$join_sql} {$where_sql} ORDER BY FIELD(id,$in)";
else
$activity_ids_sql = "{$select_sql} {$from_sql} {$join_sql} {$where_sql} ORDER BY a.date_recorded {$sort}, a.id {$sort}";

Now it’s working fine for me, But it’s not recommended to modify the core file

So please let me know if any one know the filter hook used for modifying the Query from the file itself.

hi @danbp
Thanks for your reply,
i have tried the with

bp_activity_get_where_conditions

but this filter will return the where conditions used like

array(3) {
  ["filter_sql"]=>
  string(416) "a.user_id IN ( 451,378,213,431,429,414,415,456,452,473,460,458,283,471,383,468,387,454,441,6,384,475,427 ) AND a.component IN ( 'groups' ) AND a.type IN ( 'activity_update' ) AND a.item_id IN ( 1 )"
  ["spam_sql"]=>
  string(13) "a.is_spam = 0"
  ["excluded_types"]=>
  string(34) "a.type NOT IN ('activity_comment')"
}

it will not contain the ‘ORDER BY’ portion of the query, i hope we will get the total query with the

bp_activity_total_activities_sql

filter in ~L, 664, so when we get the entire query we can replace the ‘ORDER BY’ section using string replace, i have tried by using this but i can’t get the query inside the function, do you have any idea how to use this filter ?

hi @henrywright , @danbp

Thanks for your great help,

i have solved the issue without hacking the code using the

bp_activity_paged_activities_sql

filter in class-bp-activity-activity.php ~L, 609

the code below is i have used, please refer this thred , where i got some information regarding filters.

add_filter( 'bp_activity_paged_activities_sql', function( $sql, $where_sql, $sort ) {
	$pos = strpos($sql, 'WHERE a.id IN');
	if($pos){
		$in_items = implode( ',', $where_sql['in'] );
		$sql = str_replace('ORDER BY a.date_recorded DESC' ,' ORDER BY FIELD(id,'.$in_items.') ',$sql);
	}
	
    return $sql;
}, 10, 3 );

Thanks again for your valuable time and please let me know any suggestions you have 🙂