static function update_recorded_time_and_comments($media, $bp_album_id, $table) { global $wpdb; if (function_exists('bp_activity_add')) { if (!is_object($media)) { try { $media = new BPMediaHostWordpress($media); } catch (exception $e) { return false; } } $activity_id = get_post_meta($media->get_id(), 'bp_media_child_activity', true); if ($activity_id) { $date_uploaded = $wpdb->get_var("SELECT date_uploaded from {$table} WHERE id = {$bp_album_id}"); $old_activity_id = $wpdb->get_var("SELECT id from {$wpdb->base_prefix}bp_activity WHERE component = 'album' AND type = 'bp_album_picture' AND item_id = {$bp_album_id}"); if ($old_activity_id) { $comments = $wpdb->get_results("SELECT id,secondary_item_id from {$wpdb->base_prefix}bp_activity WHERE component = 'activity' AND type = 'activity_comment' AND item_id = {$old_activity_id}"); foreach ($comments as $comment) { $update = array('item_id' => $activity_id); if ($comment->secondary_item_id == $old_activity_id) { $update['secondary_item_id'] = $activity_id; } $wpdb->update($wpdb->base_prefix . 'bp_activity', $update, array('id' => $comment->id)); BP_Activity_Activity::rebuild_activity_comment_tree($activity_id); } } $wpdb->update($wpdb->base_prefix . 'bp_activity', array('date_recorded' => $date_uploaded), array('id' => $activity_id)); return count($comments); } return 0; } }