The Joomla! Extensions Directory ™


byBobMZ, July 9, 2011
Art Timeline
I was looking for a tool to display when my articles are scheduled to appear. I bought Art Timeline because it supports SQL queries which seemed to be what I was looking for. I had a minor issue with the solution at first, but the Art team resolved it within the hour by sending me an update. Works like a charm!!
Here's my SQL statement to create a timeline which displays all articles which are scheduled AFTER 'today':

SELECT title, introtext as description, publish_up as start_date FROM #__content
WHERE (publish_up > CURDATE()) AND (state>0)

I thought, I should inlude that to show how flexible this tool is... and, before I forget, it also looks quite appealing too ;)