bp_media_import_reset_media_albums()

Reset all media albums related data in tables

Description

Source

File: bp-media/bp-media-functions.php

1836
1837
1838
1839
1840
1841
1842
1843
1844
1845
1846
1847
1848
1849
1850
1851
1852
1853
1854
1855
1856
1857
1858
1859
1860
1861
1862
1863
1864
1865
1866
1867
1868
1869
1870
1871
1872
1873
1874
1875
1876
1877
1878
1879
1880
1881
1882
1883
1884
1885
1886
1887
1888
1889
1890
1891
1892
function bp_media_import_reset_media_albums() {
    global $wpdb;
 
    $bp_media_table        = $wpdb->prefix . 'bp_media';
    $bp_media_albums_table = $wpdb->prefix . 'bp_media_albums';
 
    $albums = $wpdb->get_results( "SELECT DISTINCT id FROM {$bp_media_albums_table}" );
 
    if ( ! empty( $albums ) ) {
        foreach ( $albums as $album ) {
 
            if ( empty( $album->id ) ) {
                continue;
            }
 
            $album_obj = new BP_Media_Album( $album->id );
 
            if ( ! empty( $album_obj->id ) ) {
                $media_ids = BP_Media::get_album_media_ids( $album->id );
                if ( ! empty( $media_ids ) ) {
                    foreach( $media_ids as $media ) {
                        $media_obj = new BP_Media( $media );
 
                        if ( ! empty( $media_obj->activity_id ) && bp_is_active( 'activity' ) ) {
                            $activity = new BP_Activity_Activity( (int) $media_obj->activity_id );
 
                            /** This action is documented in bp-activity/bp-activity-actions.php */
                            do_action( 'bp_activity_before_action_delete_activity', $activity->id, $activity->user_id );
 
                            // Deleting an activity comment.
                            if ( 'activity_comment' == $activity->type ) {
                                if ( bp_activity_delete_comment( $activity->item_id, $activity->id ) ) {
                                    /** This action is documented in bp-activity/bp-activity-actions.php */
                                    do_action( 'bp_activity_action_delete_activity', $activity->id, $activity->user_id );
                                }
 
                                // Deleting an activity.
                            } else {
                                if ( bp_activity_delete( array( 'id'      => $activity->id,
                                                                'user_id' => $activity->user_id
                                ) ) ) {
                                    /** This action is documented in bp-activity/bp-activity-actions.php */
                                    do_action( 'bp_activity_action_delete_activity', $activity->id, $activity->user_id );
                                }
                            }
                        }
                    }
 
                    $media_ids = implode( ',', $media_ids );
                    $wpdb->query( "DELETE FROM {$bp_media_table} WHERE id IN ({$media_ids});" );
                }
            }
 
            $wpdb->query( "DELETE FROM {$bp_media_albums_table} WHERE id = {$album_obj->id};" );
        }
    }
}

Changelog

Changelog
Version Description
BuddyBoss 1.0.5 Introduced.

Questions?

We're always happy to help with code or other questions you might have! Search our developer docs, contact support, or connect with our sales team.