NYCPHP Meetup

[Todd S]

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