NYCPHP Meetup

[Donna Marie Vincent]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/joomla/attachments/20130926/17645c65/attachment-0001.html>