Changeset 4301

Timestamp:

04/29/2011 07:39:38 PM (15 years ago)

Author:

boonebgorges

Message:

Creates queries for member Replied To tab. References #3177

Location:

trunk

Files:

• bp-core/bp-core-template.php (modified) (1 diff)
• bp-forums/bp-forums-filters.php (modified) (1 diff)
• bp-forums/bp-forums-template.php (modified) (1 diff)
• bp-groups/bp-groups-filters.php (modified) (1 diff)
• bp-themes/bp-default/forums/forums-loop.php (modified) (2 diffs)
• bp-themes/bp-default/members/single/forums.php (modified) (1 diff)

trunk/bp-core/bp-core-template.php

@@ -35 +35 @@
         }
     }
-
+    
     // Loop through each navigation item
     foreach ( (array)$bp->bp_options_nav[$the_index] as $subnav_item ) {

trunk/bp-forums/bp-forums-filters.php

@@ -132 +132 @@
 add_filter( 'bp_get_the_topic_post_edit_text', 'bp_forums_strip_mentions_on_post_edit' );
 add_filter( 'bp_get_the_topic_text', 'bp_forums_strip_mentions_on_post_edit' );
+
+/**
+ * "REPLIED TO" SQL FILTERS
+ */
+
+/**
+ * Filters the get_topics_distinct portion of the Forums sql when on a user's Replied To page.
+ *
+ * This filter is added in bp_has_forum_topics()
+ *
+ * @package BuddyPress
+ * @since 1.3
+ *
+ * @global object $wpdb The WordPress database global
+ * @param string $sql
+ * @return string $sql
+ */
+function bp_forums_add_replied_distinct_sql( $sql ) {
+    global $wpdb;
+    
+    $sql = $wpdb->prepare( "DISTINCT t.topic_id, " );
+    
+    return $sql;
+}
+
+/**
+ * Filters the get_topics_join portion of the Forums sql when on a user's Replied To page.
+ *
+ * This filter is added in bp_has_forum_topics()
+ *
+ * @package BuddyPress
+ * @since 1.3
+ *
+ * @global object $bbdb The bbPress database global
+ * @global object $wpdb The WordPress database global
+ * @param string $sql
+ * @return string $sql
+ */
+function bp_forums_add_replied_join_sql( $sql ) {
+    global $bbdb, $wpdb;
+    
+    $sql .= $wpdb->prepare( " LEFT JOIN $bbdb->posts p ON p.topic_id = t.topic_id " );
+    
+    return $sql;
+}
+
+/**
+ * Filters the get_topics_where portion of the Forums sql when on a user's Replied To page.
+ *
+ * This filter is added in bp_has_forum_topics()
+ *
+ * @package BuddyPress
+ * @since 1.3
+ *
+ * @global object $wpdb The WordPress database global
+ * @param string $sql
+ * @return string $sql
+ */
+function bp_forums_add_replied_where_sql( $sql ) {
+    global $wpdb;
+    
+    $sql .= $wpdb->prepare( " AND p.poster_id = %s ", bp_displayed_user_id() );
+
+    return $sql;
+}
+
 ?>

trunk/bp-forums/bp-forums-template.php

@@ -230 +230 @@
     if ( !empty( $bp->displayed_user->id ) )
         $user_id = $bp->displayed_user->id;
+    
+    // "Replied" query must be manually modified
+    if ( 'replies' == bp_current_action() ) {
+        $user_id = 0; // User id must be handled manually by the filter, not by BB_Query
+        
+        add_filter( 'get_topics_distinct',   'bp_forums_add_replied_distinct_sql', 20 );
+        add_filter( 'get_topics_join',       'bp_forums_add_replied_join_sql', 20 );
+        add_filter( 'get_topics_where',      'bp_forums_add_replied_where_sql', 20  );
+    }
 
     // If we're in a single group, set this group's forum_id

trunk/bp-groups/bp-groups-filters.php

@@ -79 +79 @@
     global $bp;
     
-    $sql .= ', ' . $bp->groups->table_name . ' AS g LEFT JOIN ' . $bp->groups->table_name_groupmeta . ' AS gm ON g.id = gm.group_id ';
+    $sql .= 'JOIN ' . $bp->groups->table_name . ' AS g LEFT JOIN ' . $bp->groups->table_name_groupmeta . ' AS gm ON g.id = gm.group_id ';
     
     return $sql;

trunk/bp-themes/bp-default/forums/forums-loop.php

@@ -39 +39 @@
                 <th id="th-title"><?php _e( 'Topic Title', 'buddypress' ); ?></th>
 
-                <?php if ( bp_is_directory() ) : ?>
+                <?php if ( bp_is_directory() || bp_is_user_forums() ) : ?>
 
                     <th id="th-group"><?php _e( 'Forum', 'buddypress' ); ?></th>
@@ -67 +67 @@
                 </td>
 
-                <?php if ( bp_is_directory() ) : ?>
+                <?php if ( bp_is_directory() || bp_is_user_forums() ) : ?>
 
                     <td class="td-group">

trunk/bp-themes/bp-default/members/single/forums.php

@@ -12 +12 @@
 <div class="item-list-tabs no-ajax" id="subnav" role="navigation">
     <ul>
-        <?php if ( bp_is_my_profile() ) bp_get_options_nav(); ?>
+        <?php bp_get_options_nav() ?>
 
         <li id="forums-order-select" class="last filter">