maxisoft

 
    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);