Improving updates section in News 2 template

Hello,

I propose to introduce a small correction in the file layouts/blocks/updates.php in News 2 template.

Replace line 11 from:

Code: Select all

$date_query = 'SELECT '.$column.' FROM #__'.$table.' WHERE '.$state.' = 1 ORDER BY '.$column.' DESC LIMIT 1;';

to

Code: Select all

$date_query = 'SELECT '.$column.' FROM #__'.$table.' WHERE '.$state.' = 1 AND publish_up < now() ORDER BY '.$column.' DESC LIMIT 1;';

This patch will display the correct last modification date in updates section when we have an article awaiting publication in the future.

By the way, I invite you to my page http://www.ozorkow.net based on the News 2 template.
There is still a lot to improve on it, but every day I enter corrections and it looks better and better


Regards
Michał Kowalski
http://www.ozorkow.net

Hi

Thank for the tip. I'm sending this to programmers right away.

It is better to use this code in this format :

Code: Select all

$date_query = 'SELECT '.$column.' FROM #__'.$table.' WHERE '.$state.' = 1 AND '.$column.' <= '.$db->Quote($now).' ORDER BY '.$column.' DESC LIMIT 1;';