WordPress.org

Ready to get started?Download WordPress

Forums

Removing Expired Posts from Page of Posts, but Keep Them Available (5 posts)

  1. presspressperson
    Member
    Posted 1 year ago #

    I am trying to find a good way to remove posts from a page of posts at a specified expiration date/time, but keep them available at the same URL, so I don't end up with 404 errors for every event ever created. An easy way would be to use the Post Expirator plugin to expire them to a different category, except that changing the category changes the permalink, so I'd have to add a new redirect to my htaccess file for every single event when it expires (which seems like a poor long term solution).

    The Details:
    I am using the Twenty Eleven theme with various plugins. I have created several pages that use custom templates I created to display summarized content from all posts of a specific category. For example, I have an events page that displays a list of all posts of the category "events." On this page of (event) posts, basic information is listed for each event (I used the Types plugin for this--super handy), and the title is linked to the actual post with further details.

    The Problem:
    When an event is over with, I don't want it to display on this page of posts anymore. I do, however, still want it to be available at the same URL. Basically I need a way to check in the args for query_posts() if the post has been "expired" that doesn't result in any other changes to the post (URL, change to draft, etc.). Any suggestions?

    Here is how my page of (event) posts works:

    1. Set the query

    <?php
    $paged = (get_query_var('paged')) ? get_query_var('paged') : 1;
    $args= array(
      'category_name' => 'events',
      'post_status' => 'publish',
      'paged' => $paged,
      'posts_per_page' => -1,
      'orderby' => 'date',
      'order' => 'ASC'
    );
    query_posts($args);
    ?>

    2. The loop:

    <?php
    if( have_posts() ) :
    
    twentyeleven_content_nav( 'nav-above' );
    
    while ( have_posts() ) : the_post();
    get_template_part( 'content', 'events' );
    endwhile;
    
    twentyeleven_content_nav( 'nav-below' );
    
    else :
    // Display a message and search form for if there are no events
    ?>
  2. annedorko
    Member
    Posted 1 year ago #

    Have you checked out the Time parameters of WP_Query?

    http://codex.wordpress.org/Class_Reference/WP_Query#Time_Parameters

    It explains that you can't just create a built-in query, however with a quick function you should be able to achieve what you're looking for. I am not testing the code I'm about to write, but it should give you an idea:

    function filter_where() {
            // Check for events that are this date or in the future, exclude ones that are less than the current date
    	$where .= " AND post_date > '" . date('Y-m-d') . "'";
            // Return the new where you want
    	return $where;
    }
    // Add this filter to your current query
    add_filter( 'posts_where', 'filter_where' );
    // Get ready for the loop
    $query = new WP_Query( $query_string );
    // Remove the filter so that you're not impacting the rest of your site
    remove_filter( 'posts_where', 'filter_where' );

    You'd need to make post_date whatever the column for event date is in your events post type. Again, not tested, but should give you an idea of the direction you need to head in!

  3. presspressperson
    Member
    Posted 1 year ago #

    Thanks Anne. Quick reply!

    Great suggestion. Thanks. It took me a bit to figure out that I needed to change some of the code in my loop in order for new WP_Query() to work correctly. Otherwise it gets posts, but doesn't display them for some reason. Namely:

    <?php
    if( have_posts() ) : // when using query_posts($args)
    if( $query->have_posts() // when using $query = new WP_Query($args)
    
    //same goes for the following
    while ( $query->have_posts() ) : $query->the_post();
    ?>

    I also found the exact database entry I need to compare in the filter function. I'm using the Types plugin to give my posts custom fields that users can input with the WordPress CMS, and then I display the input with my custom templates.

    Here is the problem. Types uses the wp_postmeta table. In the meta table, everything has a meta_key and a meta_value (both columns). So instead of simply adding $where .= "AND my_event_date > '" . date() . "'"; as a filter, I somehow have to look for the meta_value of the row with meta_key equal to 'wpcf-event-end' (my event's end date), and compare that to date() (the current unix timestamp).

    Unfortunately, sql is not my thing. If anyone can help it'd be greatly appreciated. Thanks in advance!

  4. presspressperson
    Member
    Posted 1 year ago #

    Wooo! I figured it out. I found the following wonderfully wonderful solution: http://wordpress.stackexchange.com/questions/12133/using-posts-where-on-a-query-with-a-custom-field

    Basically, there is a way to add conditions to your $args (or $query_string) that deal with data from the wp_meta table. Here is what I ended up with.

    Before the loop:

    <?php
    $paged = (get_query_var('paged')) ? get_query_var('paged') : 1;
    $today = time();
    $args= array(
    'meta_query' => array(
    	array(
    	'key' => 'wpcf-event-end',
    	'value' => $today,
    	'compare' => '>='
    	)
    ),
    'category_name' => $cat_slug, // category slug (be sure to set $cat_slug above)
    'post_status' => 'publish',
    'paged' => $paged,
    'posts_per_page' => -1,
    'orderby' => 'date',
    'order' => 'ASC',
    );
    $query = new WP_Query( $args );

    The loop:

    <?php
    if( $query->have_posts() ) :
    
    twentyeleven_content_nav( 'nav-above' );
    
    while ( $query->have_posts() ) : $query->the_post();
    get_template_part( 'content', 'events' );
    endwhile;
    
    twentyeleven_content_nav( 'nav-below' );
    
    else :
    // Display a message and search form for if there are no events
    ?>

    Works like a charm! Thanks for the help Anne, and Stackexchange!

  5. 3x7
    Member
    Posted 1 year ago #

    Hi,

    I'm looking for the same solution for a long time now.

    here how I'm trying to solve it:

    Redirect expired posts to "posts category" archive page...

    This could be done if any expiration plugin could add custom field with name "redirect" and value "%category url" after expiration time....

    then it could be used in a combination with redirection plugins that redirects posts to url's from custom field....

    this way the functionality could also be extended to "authors, date etc" archive pages...

    Cheers!

Topic Closed

This topic has been closed to new replies.

About this Topic