Changeset 2397 for trunk/bp-activity/bp-activity-classes.php

Timestamp:

01/21/2010 03:47:02 PM (15 years ago)

Author:

apeatling

Message:

Fixes #1598 - broken sitewide notices

File:

• trunk/bp-activity/bp-activity-classes.php (modified) (1 diff)

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

@@ -295 +295 @@
     }
 
+    function get_id( $user_id, $component, $type, $item_id, $secondary_item_id ) {
+        global $bp, $wpdb;
+
+        $where_args = false;
+
+        if ( !empty( $user_id ) )
+            $where_args[] = $wpdb->prepare( "user_id = %d", $user_id );
+
+        if ( !empty( $component ) )
+            $where_args[] = $wpdb->prepare( "component = %s", $component );
+
+        if ( !empty( $type ) )
+            $where_args[] = $wpdb->prepare( "type = %s", $type );
+
+        if ( !empty( $item_id ) )
+            $where_args[] = $wpdb->prepare( "item_id = %s", $item_id );
+
+        if ( !empty( $secondary_item_id ) )
+            $where_args[] = $wpdb->prepare( "secondary_item_id = %s", $secondary_item_id );
+
+        if ( !empty( $where_args ) )
+            $where_sql = 'WHERE ' . join( ' AND ', $where_args );
+        else
+            return false;
+
+        return $wpdb->get_var( "SELECT id FROM {$bp->activity->table_name} {$where_sql}" );
+    }
+
     function append_comments( $activities ) {
         global $bp, $wpdb;