$limit = 6;
if (defined('DB_NEWS')) {
$configs[DB_NEWS] = [
'select' => "SELECT
ns.news_id as id, ns.news_subject as title, ns.news_news as content,
ns.news_datestamp as datestamp, us.user_id, us.user_name,
us.user_status, nc.news_cat_id as cat_id, nc.news_cat_name as cat_name,
ni.news_image as image,
ni.news_image_t1 as image_thumb,
nc.news_cat_image as cat_image,
count(c1.comment_id) as comment_count,
count(r1.rating_id) as rating_count
FROM ".DB_NEWS." as ns
LEFT JOIN ".DB_NEWS_IMAGES." as ni ON ni.news_id=ns.news_id
LEFT JOIN ".DB_NEWS_CATS." as nc ON nc.news_cat_id = ns.news_cat
LEFT JOIN ".DB_COMMENTS." as c1 on (c1.comment_item_id = ns.news_id and c1.comment_type = 'NS')
LEFT JOIN ".DB_RATINGS." as r1 on (r1.rating_item_id = ns.news_id AND r1.rating_type = 'NS')
INNER JOIN ".DB_USERS." as us ON ns.news_name = us.user_id
WHERE (".time()." > ns.news_start OR ns.news_start = 0)
AND ns.news_draft = 0
AND (".time()." < ns.news_end OR ns.news_end = 0)
AND ".groupaccess('ns.news_visibility')." ".(multilang_table("NS") ? "AND news_language='".LANGUAGE."'" : "")."
group by ns.news_id
ORDER BY ns.news_id ASC LIMIT ".$limit,
'locale' => [
'norecord' => $locale['home_0050'],
'blockTitle' => $locale['home_0000'],
],
'infSettings' => get_settings("news"),
'categoryLinkPattern' => INFUSIONS."news/news.php?cat_id={cat_id}",
'contentLinkPattern' => INFUSIONS."news/news.php?readmore={id}",
];
}
ORDER BY ns.news_datestamp DESC LIMIT ". $ Limit = 3;
Category Forum
Content Administration - 9Labels
None yet
Statistics
4 participants
Notifications
You are not receiving notifications from this thread.
Related Questions