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;
}
}
