Thanks all, I had a feeling that was the case...
On Sep 26, 2013, at 2:48 PM, Donna Marie Vincent <donnamarievinc...@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 <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
_______________________________________________ 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
