Comments on snippet: 'Wordpress post expiration code'

ramborc said on 3/4/11

Fri, 04 Mar 2011 20:40:23 GMT

I've posted an updated version of this code that works with European date format (d.m.Y) at http://snipplr.com/view/50046/updated-march-2011-wordpress-post-expiration-code/

fendichen said on 10/7/10

Thu, 07 Oct 2010 22:56:42 GMT

hi friend, do you know cheap ghd, cheap mbt shoes, christian louboutin shoes hot sell online recently? we are china wholesaler company, offer good quality nike dunks, ghd mk4, cheap soccer jerseys online, cheap jerseys online enjoy much discount.cheap nike dunks,nike shox why are you hestitate, welcome for retail, dropship, and wholesale orders.

gjindancer said on 6/28/09

Sun, 28 Jun 2009 09:59:12 GMT

Hi All! I noticed dwest's post has not worked and a solution for including the time in the expiry date was not included. I've updated the code to include time, account for time differences on your server, and make sure the posts are still included in the archives. http://snipplr.com/view/16400/updated-wordpress-post-expiration-code/

shopromo said on 4/11/09

Sat, 11 Apr 2009 06:46:35 GMT

Hi, I'd like to use this snippet on a e-couponing website based on Wordpress. But I don't want the expired post to disappear, I just want to add "This coupon code is expired" somewhere in the post when the expiration date is reached. How can I do that ?

jakepaint said on 7/15/08

Tue, 15 Jul 2008 14:12:12 GMT

to sort by expiration date would be on the tricky side. Probably the way would be to set up a custom-select-query in word press. Insert something like this in your template: $querystr = " SELECT wposts.* FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta WHERE wposts.ID = wpostmeta.postid AND wpostmeta.metakey = 'expirationdate' //or whatever your meta key is called AND wposts.poststatus = 'publish' AND wposts.posttype = 'post' ORDER BY wpostmeta.metavalue ASC ";

$pageposts = $wpdb->get_results($querystr, OBJECT);

read more about that method: http://codex.wordpress.org/DisplayingPostsUsingaCustomSelectQuery

btd1294 said on 7/2/08

Wed, 02 Jul 2008 16:30:53 GMT

I am using the code that you provided on a project that I am working on. It works great, the one thing I need is to be able to sort on the expiration date. Can you give me some help with that?

Thanks for the code.

Jeff

bujaman said on 6/20/08

Fri, 20 Jun 2008 01:45:36 GMT

Great snippet, how would you modify it so that it would delete the post entirely? I am using WP for a retail site and want to have daily specials on a post. I would like to set them up in advance and set the publish time, but would also like to have them expire and be removed so no one can stumble upon them accidentally in the archives. Thanks for the code.

baa said on 4/22/08

Tue, 22 Apr 2008 15:35:49 GMT

Could u help me to display posts based on the EXPIRATION date, order=ASC

thanks.baa.

dwest said on 2/20/08

Wed, 20 Feb 2008 00:25:49 GMT

pOOP! the code didn't show up. Sorry!

Here tiz:

dwest said on 2/20/08

Wed, 20 Feb 2008 00:24:45 GMT

I sort of re-wrote this snippet to do two things: It allows one to specify time. It allows one to enter the date as standard U.S.

Your expiration key can now hold the value 02/19/2008 18:25:02 or simlar and the post will expire at that time.

here is the code: PLACE IN WORDPRESS PAGE JUST AS DIRECTED FOR ORIGINAL SNIPPET



//WORDPRESS CODE HERE
//ADD CLOSING  STRING AS DIRECTED IN ORIGINAL SNIPPET.

dwest said on 2/10/08

Sun, 10 Feb 2008 03:12:06 GMT

This is a wonderful snippet. Much needed in WordPress. I have but one request. Can it be adjusted so that a date AND TIME can be specified for expiration?

I run auctions for my art at ebay and I want the blog post to expire when the auction expires. Hours and minutes are all that would be needed along with the date.

If it can be done, and you don't have the time, please tell me how and I'll edit the code.

Thanks so much for creating this and making it available.

Have a look at smallartgems.com to see how I'm using it.

twitchyjordan said on 1/24/08

Thu, 24 Jan 2008 05:23:48 GMT

Thank you very much for the code. I'm trying to create an events blog using WordPress, and this is very handy for only having current events posted in my "Recently added" column. I've tried adding it to the "Search results" page, and while it works (past events/expired posts won't show up), if there aren't *any unexpired posts the search results end up blank instead of showing up a "no posts found" text. Any thoughts?

jakepaint said on 11/16/07

Fri, 16 Nov 2007 15:07:33 GMT

Hi, yeah sure. I changed the code to hopefully be a little more clear. I'm not familiar with AdClerum, but in the loop begins with: so put the first section of my code just after that, and the end of the loop is: so put the last line of my code just before that. My template is a bit different than the standard, so hopefully that will get you working.



jakepaint said on 11/16/07
Fri, 16 Nov 2007 15:06:51 GMT
 Hi, yeah sure.  I changed the code to hopefully be a little more clear.  I'm not familiar with AdClerum, but in the loop begins with:

so put the first section of my code just after that, and the end of the loop is:

so put the last line of my code just before that.  My template is a bit different than the standard, so hopefully that will get you working.

 


eagleout said on 10/22/07
Mon, 22 Oct 2007 09:56:49 GMT
 Can you give us an example what this code replaces in index.php? Not sure what the "correct stuff" is. I am using the AdClerum template.

Thanks-