Need some help getting this right?

Hi,

I’m a little caught up in work at the moment, but I’ve been thinking through this. I’ve read the thread you linked to, but could you clarify exactly what you’re looking for?

As I understand it, you want a list of recent replies grouped by topic? If that’s the case, the grouping-by-topic would be difficult, and I’d have to add something for that to QW.

If you just need a list of recent replies with links to the reply and to the topic, that’s no trouble at all.

Thanks,
Jonathan

Ok, query wrangler doesn’t currently support the feature you need (group by). It’s on my radar, but I’m not sure when I’ll get a chance to add this in.

If you’d like, I can write a snippet/shortcode that would produce the results you’re looking for. You could paste that snippet in your theme’s function.php file, and share it with the others at bbpress who are looking for this feature.

Ok, this is a little complex because I was trying to use only WP_Query args for the query as an exercise, but it should work.

Also, I’m not sure how well this will display, so it may take me a few edits.

add_shortcode('bbpress_recent_replies_by_topic', 'custom_bbpress_recent_replies_by_topic');
/*
 * Get the most recently replied to topics, and thier most recent reply
 */
function custom_bbpress_recent_replies_by_topic($atts){
  $short_array = shortcode_atts(array('show' => 5), $atts);
  extract($short_array);

  // get the 5 topics with the most recent replie
  $args = array(
    'posts_per_page' => $show,
    'post_type' => array('topic'),
    'orderby' => 'meta_value',
    'order' => 'DESC',
    'meta_key' => '_bbp_last_reply_id',
  );

  $query = new WP_Query($args);
  $reply_ids = array();  

  // get the reply post->IDs for these most-recently-replied-to-topics
  while($query->have_posts()){
    $query->the_post();
    if ($reply_post_id = get_post_meta(get_the_ID(), '_bbp_last_reply_id', true)){
      $reply_ids[] = $reply_post_id;
    }
  }

  // get the actual replies themselves
  $args = array(
    'posts_per_page' => $show,
    'post_type' => array('reply'),
    'post__in' => $reply_ids,
    'orderby' => 'date',
    'order' => 'DESC'
  );

  $query = new WP_Query($args);
  ob_start();
    // loop through results and output our rows
    while($query->have_posts()){
      $query->the_post();

      // custom function for a single reply row
      custom_bbpress_recent_reply_row_template();
    }
  $output = ob_get_clean();
  return $output;
}

/*
 * Executed during our custom loop
 *  - this should be the only thing you need to edit
 */
function custom_bbpress_recent_reply_row_template(){
  ?>
    <div class="bbpress-recent-reply-row">
      <div><?php the_title(); ?></div>
      <div>Excerpt: <?php the_excerpt(); ?></div>
      <div>Author: <?php the_author(); ?></div>
      <div>Link: <a>">view reply</a></div>
    </div>
  <?php
}

Here is a little walk through.

I’ve added a custom shortcode. You use the this shortcode like so: [bbpress_recent_replies_by_topic]. It also allows for a parameter to determine the number of replies shown (defaults to 5). That parameter is “show”, and is used in the shortcode like so: [bbpress_recent_replies_by_topic show=10]

That shortcode calls the first function. This function gathers the 5 most recent replied-to topics, and their most recent replies. Then while looping through the replies, it calls the 2nd function to output a row of data.

I broke it into 2 functions so that you could easily edit the output of a row without breaking anything else. This means, to change the way the rows look you should [b]only edit the “custom_bbpress_recent_reply_row_template()” function[/b].

I don’t expect that this is as user-friendly as everyone might hope, but it should get you in the right direction. If you’re used to editing themes, then nothing about the custom_bbpress_recent_reply_row_template() function should surprise you.

Hope this helps. Let me know how it turns out.

edit: trying to make the code look right.

I’ve updated the gist to show trimming the title in 2 different ways, as well as getting the bbpress profile link. https://gist.github.com/daggerhart/09b0dbc7eb766486353b

I changed the title around so that each function we’re running on it could be removed if desired. You will probably want to adjust your code to be like:

function custom_bbpress_recent_reply_row_template(){
  // get the reply title
  $title = get_the_title();
  // remove "Reply To: " from beginning of title
  $title = str_replace('Reply To: ', '', $title);
  // trim title to specific number of characters (55 characters)
  $title = substr( $title, 0, 55);
  ?>
    <div class="bbpress-recent-reply-row">
	<ul>
   	  <li><a href="<?php print get_permalink( get_post_meta( get_the_ID(), '_bbp_topic_id', true) ); ?>#post-<?php the_ID(); ?>"><?php print $title; ?></a></li>
	  <li>by: <a href="<?php print esc_url( bbp_get_user_profile_url( get_the_author_meta( 'ID' ) ) ); ?>"><?php print get_avatar( get_the_author_meta( 'ID' ),'14' ); ?></a> <?php print bbp_user_profile_link( get_the_author_meta( 'ID' ) ); ?> <?php print human_time_diff( get_the_time('U'), current_time('timestamp') ) . ' ago'; ?></li>
	  </ul>
	</div>
  <?php
}

In the above code I’ve linked the avatar to the user’s profile to be more like the other widget on your page.

Yes, I have a donate link on widget wrangler’s homepage http://widgetwrangler.com/ It’s on the top right. Thanks, and no problem!