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

Timestamp:

07/22/2011 12:40:24 PM (14 years ago)

Author:

boonebgorges

Message:

Ensure that total forum count is correct when a search term is passed to the topic loop

File:

• trunk/bp-groups/bp-groups-classes.php (modified) (2 diffs)

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

@@ -607 +607 @@
      * @return int The topic count
      */
-    function get_global_topic_count( $status = 'public' ) {
+    function get_global_topic_count( $status = 'public', $search_terms = false ) {
         global $bbdb, $wpdb, $bp;
         
@@ -629 +629 @@
         }
         
-        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' " );
+        $sql = array();
+        
+        $sql['select'] = "SELECT COUNT(t.topic_id)";
+        
+        $sql['from'] = "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";
+        
+        $sql['where'] = "WHERE gm.meta_key = 'forum_id' {$status_sql} AND t.topic_status = '0' AND t.topic_sticky != '2'";
+        
+        if ( $search_terms ) {
+            $st = like_escape( $search_terms );
+            $sql['where'] .= " AND (  t.topic_title LIKE '%{$st}%' )";
+        }
+        
+        return $wpdb->get_var( implode( ' ', $sql ) );
     }
 }