Модуль Последние материалы

 
$sql = "SELECT con.*,
con.pubdate as fdate,
u.nickname as author,
u.login as author_login
FROM cms_content con
LEFT JOIN cms_category cat ON cat.id = con.category_id
LEFT JOIN cms_users u ON u.id = con.user_id
WHERE con.published = 1 AND con.showlatest = 1
AND (con.is_end=0 OR (con.is_end=1 AND con.enddate >= '$today' AND con.pubdate <= '$today'))
".$catsql."
ORDER BY con.id DESC
LIMIT ".$cfg['newscount'];
 

 
    private function renderListDB($param) {
 
        $inDB = cmsDatabase::getInstance();
 
        $html       = '';
 
        $name       = (string)$param['name'];
        $value      = (string)$param['value'];
 
        $multiple   = isset($param['multiple']) ? 1 : 0;
 
        $src        = (string)$param['src'];
        $src_title  = isset($param['src_title']) ? (string)$param['src_title'] : 'title';
        $src_id     = isset($param['src_value']) ? (string)$param['src_value'] : 'id';
        $src_where  = isset($param['src_where']) ? (string)$param['src_where'] : '';
 
        $tree       = isset($param['tree']) ? (int)$param['tree'] : 0;
        $order_by   = ($tree ? 'NSLeft' : $src_title);
        $select     = "{$src_id} as value, {$src_title} as title";
 
        if ($tree) { $select .= ", NSLevel as level"; }
 
        $where      = ($src_where) ? "WHERE {$src_where}" : '';
 
        $sql        = "SELECT {$select}
                       FROM {$src}
                       {$where}
                       ORDER BY {$order_by}
                       LIMIT 100";
 
        $result = $inDB->query($sql);