NYCPHP Meetup

[Todd Sugiyama]

Thanks all, I had a feeling that was the case... 


On Sep 26, 2013, at 2:48 PM, Donna Marie Vincent <donnamarievincent at yahoo.com> wrote:

> It still shows as state = 1 because you did not change the state.
> 
> There is no process that goes through the database every x hours and unpublishes expired articles.  An article can be both published and expired.
> 
> The publish_down column is the finish publishing date.
> 
> 
> 
> 
> From: Todd S <toddsugi at gmail.com>
> To: NYPHP SIG: Joomla <joomla at lists.nyphp.org> 
> Sent: Thursday, September 26, 2013 2:16 PM
> Subject: [joomla] Joomla Database - Published vs Unpublished vs Expired
> 
> Hi,
> I'm creating articles in Joomla 2.5.4  and the setting the "Finished Publishing" date.  Once that date has past, In the admin section the article has a red x and says "publishing expired".
> I'm doing some manual pulls from the sql db, with the conditional "state =1" to show all published articles and to Hide the expired articles.  i thought the state=1 is published, state =0 is the unpublished, state = -2 is trashed.  
> However when the article is expired (past the finished publishing date), the state still shows as 1 in the database, so my custom module is still showing the expired article, but the link to the actual article is not valid.
> Any ideas how I can identify from the database when an article is expired?  I'm wondering why the state still shows as "1" for expired articles.
> thanks in advance.
> Todd
> 
> _______________________________________________
> New York PHP SIG: Joomla! Mailing List
> http://lists.nyphp.org/mailman/listinfo/joomla
> 
> NYPHPCon 2006 Presentations Online
> http://www.nyphpcon.com
> 
> Show Your Participation in New York PHP
> http://www.nyphp.org/show_participation.php
> 
> _______________________________________________
> New York PHP SIG: Joomla! Mailing List
> http://lists.nyphp.org/mailman/listinfo/joomla
> 
> NYPHPCon 2006 Presentations Online
> http://www.nyphpcon.com
> 
> Show Your Participation in New York PHP
> http://www.nyphp.org/show_participation.php

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/joomla/attachments/20130926/67f84332/attachment.html>