hello all,
I noticed that the newsdesk_date_available option is not used in the SQL statment, used to display the list of latest news. How come when it is a necessary option ?
I added "and newsdesk_date_available <= now()" on the page /catalog/includes/modules/newsdesk.php but it doesn't show anymore the news with a NULL 'newsdesk_date_available' in the table newsdesk. Only News with a past date are displayed (ie today minus 1,2,3 x days). Do you know why ?
WHERE p.newsdesk_id=p2c.newsdesk_id and p2c.categories_id=pc.categories_id and pd.newsdesk_id = p.newsdesk_id and pd.language_id = "' . $languages_id . '" and newsdesk_status = 1 and p.newsdesk_sticky = 0 and newsdesk_date_available <= now() ORDER BY newsdesk_date_added DESC LIMIT ' . MAX_DISPLAY_NEWSDESK_NEWS
What is the correct SQL statement ?
Thx,
Best to all
Ewad