I have created a solution for this and this works. but like count only changes when pages are refresh. any solution for that?
// CODE TO GET LIKES COUNT
## create a table wp_likes
function custom_activity_content_below( $activity_id ) {
// echo bp_activity_id();
global $wpdb;
// Query to count the number of favorites for a specific activity
$favorite_count = $wpdb->get_var( $wpdb->prepare(
”
SELECT COUNT(*)
FROM {$wpdb->prefix}likes
WHERE activity_id = %d
“,
bp_get_activity_id()
) );
echo ‘<div class=”like_count” style=”margin-top: 10px; color: black;”>’.$favorite_count .’ Likes</div>’;
}
add_action( ‘bp_activity_entry_meta’, ‘custom_activity_content_below’,10,1 );
function get_activity_favorite_count( $activity_id ) {
global $wpdb;
// Query to count the number of favorites for a specific activity
$favorite_count = $wpdb->get_var( $wpdb->prepare(
”
SELECT COUNT(*)
FROM {$wpdb->prefix}bp_activity_user_favorite
WHERE activity_id = %d
“,
$activity_id
) );
return $favorite_count;
}
function save_activity_like_to_table($activity_id) {
global $wpdb;
// Get current user ID
$user_id = get_current_user_id();
// Table name
$table_name = $wpdb->prefix . ‘likes’;
// Insert data into the custom table
$wpdb->insert(
$table_name,
array(
‘activity_id’ => $activity_id,
‘user_id’ => $user_id,
‘created_at’ => current_time( ‘mysql’ ),
),
array(
‘%d’,
‘%d’,
‘%s’,
)
);
}
add_action( ‘bp_activity_add_user_favorite’, ‘save_activity_like_to_table’, 10, 1 );
function delete_activity_like_from_table($activity_id) {
global $wpdb;
// Get current user ID
$user_id = get_current_user_id();
// Table name
$table_name = $wpdb->prefix . ‘likes’;
// Delete data from the custom table
$wpdb->delete(
$table_name,
array(
‘activity_id’ => $activity_id,
‘user_id’ => $user_id,
),
array(
‘%d’,
‘%d’,
)
);
}
add_action( ‘bp_activity_remove_user_favorite’, ‘delete_activity_like_from_table’, 10, 1 );
