Changeset 4764 for trunk/bp-groups/bp-groups-classes.php

Timestamp:

07/21/2011 02:14:16 PM (15 years ago)

Author:

boonebgorges

Message:

Fixes sticky logic on group forum directories so that stickies always appear at the top of the order, without breaking pagination. Fixes #3059. Props sushkov for the inital patch. Introduces bp_forums_enable_global_directory_stickies() to allow easy modification of the default global forum directory behavior, which is to show group stickies in their normal freshness-based position.

File:

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

trunk/bp-groups/bp-groups-classes.php

@@ -596 +596 @@
         return $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(id) FROM {$bp->groups->table_name_members} WHERE group_id = %d AND is_confirmed = 1 AND is_banned = 0", $group_id ) );
     }
+    
+    
+    /**
+     * Get a total count of all topics of a given status, across groups/forums
+     *
+     * @package BuddyPress
+     * @since 1.3
+     *
+     * @param str $status 'public', 'private', 'hidden', 'all' Which group types to count
+     * @return int The topic count
+     */
+    function get_global_topic_count( $status = 'public' ) {
+        global $bbdb, $wpdb, $bp;
+        
+        switch ( $status ) {
+            case 'all' :
+                $status_sql = '';
+                break;
+                
+            case 'hidden' :
+                $status_sql = $wpdb->prepare( "AND g.status = 'hidden'" );
+                break;
+                
+            case 'private' :
+                $status_sql = $wpdb->prepare( "AND g.status = 'private'" );
+                break;
+                
+            case 'public' :
+            default :
+                $status_sql = $wpdb->prepare( "AND g.status = 'public'" );
+                break;
+        }
+        
+        return $wpdb->get_var( "SELECT COUNT(t.topic_id) FROM {$bbdb->topics} AS t INNER JOIN {$bp->groups->table_name_groupmeta} AS gm ON t.forum_id = gm.meta_value INNER JOIN {$bp->groups->table_name} AS g ON gm.group_id = g.id WHERE gm.meta_key = 'forum_id' {$status_sql} AND t.topic_status = '0' AND t.topic_sticky != '2' " );
+    }
 }