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 <todds...@gmail.com>
To: NYPHP SIG: Joomla <joomla@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
