Skip to:
Content

BuddyPress.org


Ignore:
Timestamp:
01/28/2010 06:01:42 PM (17 years ago)
Author:
apeatling
Message:

Merged activity delete functions for better usability. Fixed some issues with the group extension API and plugin compatibility in 1.2

File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/bp-activity/bp-activity-classes.php

    r2416 r2471  
    7171        /* Static Functions */
    7272
    73         function delete( $item_id, $component, $type, $user_id = false, $secondary_item_id = false ) {
    74                 global $wpdb, $bp;
    75 
    76                 if ( $secondary_item_id )
    77                         $secondary_sql = $wpdb->prepare( "AND secondary_item_id = %s", $secondary_item_id );
    78 
    79                 if ( $type )
    80                         $type_sql = $wpdb->prepare( "AND type = %s", $type );
    81 
    82                 if ( $user_id )
    83                         $user_sql = $wpdb->prepare( "AND user_id = %d", $user_id );
    84 
    85                 /* Fetch the activity IDs so we can delete any comments for this activity item */
    86                 $activity_ids = $wpdb->get_col( $wpdb->prepare( "SELECT id FROM {$bp->activity->table_name} WHERE item_id = %s {$secondary_sql} AND component = %s {$type_sql} {$user_sql}", $item_id, $component ) );
    87 
    88                 error_log( $wpdb->prepare( "DELETE FROM {$bp->activity->table_name} WHERE item_id = %s {$secondary_sql} AND component = %s {$type_sql} {$user_sql}", $item_id, $component ) );
    89 
    90                 if ( !$wpdb->query( $wpdb->prepare( "DELETE FROM {$bp->activity->table_name} WHERE item_id = %s {$secondary_sql} AND component = %s {$type_sql} {$user_sql}", $item_id, $component ) ) )
    91                         return false;
    92 
    93                 if ( $activity_ids ) {
    94                         BP_Activity_Activity::delete_activity_item_comments( $activity_ids );
    95                         BP_Activity_Activity::delete_activity_meta_entries( $activity_ids );
    96 
    97                         return $activity_ids;
    98                 }
    99 
    100                 return true;
    101         }
    102 
    103         function delete_by_item_id( $item_id, $component, $type, $user_id = false, $secondary_item_id = false ) {
    104                 return BP_Activity_Activity::delete( $item_id, $component, $type, $user_id, $secondary_item_id );
    105         }
    106 
    107         function delete_by_activity_id( $activity_id ) {
    108                 global $bp, $wpdb;
    109 
    110                 if ( !$wpdb->query( $wpdb->prepare( "DELETE FROM {$bp->activity->table_name} WHERE id = %d", $activity_id ) ) )
    111                         return false;
    112 
    113                 /* Delete the comments for this activity ID */
    114                 BP_Activity_Activity::delete_activity_item_comments( $activity_id );
    115                 BP_Activity_Activity::delete_activity_meta_entries( $activity_id );
    116 
    117                 return true;
    118         }
    119 
    120         function delete_by_content( $user_id, $content, $component, $type ) {
    121                 global $bp, $wpdb;
    122 
    123                 /* Fetch the activity ID so we can delete any comments for this activity item */
    124                 $activity_ids = $wpdb->get_col( $wpdb->prepare( "SELECT id FROM {$bp->activity->table_name} WHERE user_id = %d AND content = %s AND component = %s AND type = %s", $user_id, $content, $component, $type ) );
    125 
    126                 if ( !$wpdb->query( $wpdb->prepare( "DELETE FROM {$bp->activity->table_name} WHERE user_id = %d AND content = %s AND component = %s AND type = %s", $user_id, $content, $component, $type ) ) )
    127                         return false;
    128 
    129                 if ( $activity_ids ) {
    130                         BP_Activity_Activity::delete_activity_item_comments( $activity_ids );
    131                         BP_Activity_Activity::delete_activity_meta_entries( $activity_ids );
    132 
    133                         return $activity_ids;
    134                 }
    135 
    136                 return true;
    137         }
    138 
    139         function delete_for_user_by_component( $user_id, $component ) {
    140                 global $bp, $wpdb;
    141 
    142                 /* Fetch the activity IDs so we can delete any comments for this activity item */
    143                 $activity_ids = $wpdb->get_col( $wpdb->prepare( "SELECT id FROM {$bp->activity->table_name} WHERE user_id = %d AND component = %s", $user_id, $component ) );
    144 
    145                 if ( !$wpdb->query( $wpdb->prepare( "DELETE FROM {$bp->activity->table_name} WHERE user_id = %d AND component = %s", $user_id, $component ) ) )
    146                         return false;
    147 
    148                 if ( $activity_ids ) {
    149                         BP_Activity_Activity::delete_activity_item_comments( $activity_ids );
    150                         BP_Activity_Activity::delete_activity_meta_entries( $activity_ids );
    151 
    152                         return $activity_ids;
    153                 }
    154 
    155                 return true;
    156         }
    157 
    158         function delete_for_user( $user_id ) {
    159                 global $wpdb, $bp;
    160 
    161                 /* Fetch the activity IDs so we can delete any comments for this activity item */
    162                 $activity_ids = $wpdb->get_col( $wpdb->prepare( "SELECT id FROM {$bp->activity->table_name} WHERE user_id = %d", $user_id ) );
    163 
    164                 if ( !$wpdb->query( $wpdb->prepare( "DELETE FROM {$bp->activity->table_name} WHERE user_id = %d", $user_id ) ) )
    165                         return false;
    166 
    167                 if ( $activity_ids ) {
    168                         BP_Activity_Activity::delete_activity_item_comments( $activity_ids );
    169                         BP_Activity_Activity::delete_activity_meta_entries( $activity_ids );
    170 
    171                         return $activity_ids;
    172                 }
    173         }
    174 
    175         function delete_activity_item_comments( $activity_ids ) {
    176                 global $bp, $wpdb;
    177 
    178                 if ( is_array($activity_ids) )
    179                         $activity_ids = implode( ',', $activity_ids );
    180 
    181                 $activity_ids = $wpdb->escape( $activity_ids );
    182 
    183                 return $wpdb->query( $wpdb->prepare( "DELETE FROM {$bp->activity->table_name} WHERE type = 'activity_comment' AND item_id IN ({$activity_ids})" ) );
    184         }
    185 
    186         function delete_activity_meta_entries( $activity_ids ) {
    187                 global $bp, $wpdb;
    188 
    189                 if ( is_array($activity_ids) )
    190                         $activity_ids = implode( ',', $activity_ids );
    191 
    192                 $activity_ids = $wpdb->escape( $activity_ids );
    193 
    194                 return $wpdb->query( $wpdb->prepare( "DELETE FROM {$bp->activity->table_name_meta} WHERE activity_id IN ({$activity_ids})" ) );
    195         }
    196 
    19773        function get( $max = false, $page = 1, $per_page = 25, $sort = 'DESC', $search_terms = false, $filter = false, $display_comments = false, $show_hidden = false ) {
    19874                global $wpdb, $bp;
    … …  
    20177                $select_sql = "SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name";
    20278
    203                 if ( function_exists( 'xprofile_install' ) )
    204                         $select_sql .= ", pd.value as user_fullname";
    205 
    206                 $from_sql = " FROM {$bp->activity->table_name} a, {$wpdb->users} u";
    207 
    208                 if ( function_exists( 'xprofile_install' ) )
    209                         $from_sql .= ", {$bp->profile->table_name_data} pd";
     79                $from_sql = " FROM {$bp->activity->table_name} a LEFT JOIN {$wpdb->users} u ON a.user_id = u.ID";
    21080
    21181                /* Where conditions */
    21282                $where_conditions = array();
    213                 $where_conditions['user_join'] = "a.user_id = u.ID";
    214 
    215                 if ( function_exists( 'xprofile_install' ) ) {
    216                         $where_conditions['xprofile_join'] = "a.user_id = pd.user_id";
    217                         $where_conditions['xprofile_filter'] = "pd.field_id = 1";
    218                 }
    21983
    22084                if ( $per_page && $page )
    … …  
    253117                $total_activities = $wpdb->get_var( $wpdb->prepare( "SELECT count(a.id) {$from_sql} {$where_sql} ORDER BY a.date_recorded {$sort}" ) );
    254118
     119                /* Get the fullnames of users so we don't have to query in the loop */
     120                if ( function_exists( 'xprofile_install' ) && $activities ) {
     121                        foreach ( (array)$activities as $activity ) {
     122                                if ( (int)$activity->user_id )
     123                                        $activity_user_ids[] = $activity->user_id;
     124                        }
     125
     126                        $activity_user_ids = implode( ',', (array)$activity_user_ids );
     127                        if ( !empty( $activity_user_ids ) ) {
     128                                if ( $names = $wpdb->get_results( $wpdb->prepare( "SELECT user_id, value AS user_fullname FROM {$bp->profile->table_name_data} WHERE field_id = 1 AND user_id IN ({$activity_user_ids})" ) ) ) {
     129                                        foreach ( (array)$names as $name )
     130                                                $tmp_names[$name->user_id] = $name->user_fullname;
     131
     132                                        foreach ( (array)$activities as $i => $activity ) {
     133                                                if ( !empty( $tmp_names[$activity->user_id] ) )
     134                                                        $activities[$i]->user_fullname = $tmp_names[$activity->user_id];
     135                                        }
     136
     137                                        unset( $names );
     138                                        unset( $tmp_names );
     139                                }
     140                        }
     141                }
     142
    255143                if ( $activities && $display_comments )
    256144                        $activities = BP_Activity_Activity::append_comments( &$activities );
    … …  
    295183        }
    296184
    297         function get_id( $user_id, $component, $type, $item_id, $secondary_item_id ) {
     185        function get_id( $user_id, $component, $type, $item_id, $secondary_item_id, $action, $content ) {
    298186                global $bp, $wpdb;
    299187
    … …  
    314202                if ( !empty( $secondary_item_id ) )
    315203                        $where_args[] = $wpdb->prepare( "secondary_item_id = %s", $secondary_item_id );
     204
     205                if ( !empty( $action ) )
     206                        $where_args[] = $wpdb->prepare( "action = %s", bp_activity_add_timesince_placeholder( $action ) );
     207
     208                if ( !empty( $content ) )
     209                        $where_args[] = $wpdb->prepare( "content = %s", $content );
    316210
    317211                if ( !empty( $where_args ) )
    … …  
    321215
    322216                return $wpdb->get_var( "SELECT id FROM {$bp->activity->table_name} {$where_sql}" );
     217        }
     218
     219        function delete( $args ) {
     220                global $wpdb, $bp;
     221
     222                extract( $args );
     223
     224                $defaults = array(
     225                        'id' => false,
     226                        'action' => false,
     227                        'content' => false,
     228                        'component' => false,
     229                        'type' => false,
     230                        'primary_link' => false,
     231                        'user_id' => false,
     232                        'item_id' => false,
     233                        'secondary_item_id' => false,
     234                        'recorded_time' => false,
     235                        'hide_sitewide' => false
     236                );
     237
     238                $where_args = false;
     239
     240                if ( !empty( $id ) )
     241                        $where_args[] = $wpdb->prepare( "id = %d", $id );
     242
     243                if ( !empty( $user_id ) )
     244                        $where_args[] = $wpdb->prepare( "user_id = %d", $user_id );
     245
     246                if ( !empty( $action ) )
     247                        $where_args[] = $wpdb->prepare( "action = %s", bp_activity_add_timesince_placeholder( $action ) );
     248
     249                if ( !empty( $content ) )
     250                        $where_args[] = $wpdb->prepare( "content = %s", $content );
     251
     252                if ( !empty( $component ) )
     253                        $where_args[] = $wpdb->prepare( "component = %s", $component );
     254
     255                if ( !empty( $type ) )
     256                        $where_args[] = $wpdb->prepare( "type = %s", $type );
     257
     258                if ( !empty( $primary_link ) )
     259                        $where_args[] = $wpdb->prepare( "primary_link = %s", $primary_link );
     260
     261                if ( !empty( $item_id ) )
     262                        $where_args[] = $wpdb->prepare( "item_id = %s", $item_id );
     263
     264                if ( !empty( $secondary_item_id ) )
     265                        $where_args[] = $wpdb->prepare( "secondary_item_id = %s", $secondary_item_id );
     266
     267                if ( !empty( $recorded_time ) )
     268                        $where_args[] = $wpdb->prepare( "recorded_time = %s", $recorded_time );
     269
     270                if ( !empty( $hide_sitewide ) )
     271                        $where_args[] = $wpdb->prepare( "recorded_time = %d", $hide_sitewide );
     272
     273                if ( !empty( $where_args ) )
     274                        $where_sql = 'WHERE ' . join( ' AND ', $where_args );
     275                else
     276                        return false;
     277
     278                /* Fetch the activity IDs so we can delete any comments for this activity item */
     279                $activity_ids = $wpdb->get_col( $wpdb->prepare( "SELECT id FROM {$bp->activity->table_name} {$where_sql}" ) );
     280
     281                if ( !$wpdb->query( $wpdb->prepare( "DELETE FROM {$bp->activity->table_name} {$where_sql}" ) ) )
     282                        return false;
     283
     284                if ( $activity_ids ) {
     285                        BP_Activity_Activity::delete_activity_item_comments( $activity_ids );
     286                        BP_Activity_Activity::delete_activity_meta_entries( $activity_ids );
     287
     288                        return $activity_ids;
     289                }
     290
     291                return $activity_ids;
     292        }
     293
     294        function delete_activity_item_comments( $activity_ids ) {
     295                global $bp, $wpdb;
     296
     297                if ( is_array($activity_ids) )
     298                        $activity_ids = implode( ',', $activity_ids );
     299
     300                $activity_ids = $wpdb->escape( $activity_ids );
     301
     302                return $wpdb->query( $wpdb->prepare( "DELETE FROM {$bp->activity->table_name} WHERE type = 'activity_comment' AND item_id IN ({$activity_ids})" ) );
     303        }
     304
     305        function delete_activity_meta_entries( $activity_ids ) {
     306                global $bp, $wpdb;
     307
     308                if ( is_array($activity_ids) )
     309                        $activity_ids = implode( ',', $activity_ids );
     310
     311                $activity_ids = $wpdb->escape( $activity_ids );
     312
     313                return $wpdb->query( $wpdb->prepare( "DELETE FROM {$bp->activity->table_name_meta} WHERE activity_id IN ({$activity_ids})" ) );
    323314        }
    324315
Note: See TracChangeset for help on using the changeset viewer.