CONTENIDO Forum

Code: Alles auswählen

function getLightboxSettings($artlang) {
    global $db, $cfg;
    
    $pre = $cfg['sql']['sqlprefix'];
    
    $sql = "SELECT
                _art_lang.title,
                _art_lang.pagetitle,
                _art_lang.summary,
                _mod.name,
                _mod.idmod,
                _container_conf.container
            FROM
                " . $pre . "_art_lang AS _art_lang,
                " . $pre . "_template_conf AS _template_conf,
                " . $pre . "_container_conf AS _container_conf,
                " . $pre . "_container AS _container,
                " . $pre . "_mod AS _mod
            WHERE
                _art_lang.idartlang=" . $artlang . " AND
                _template_conf.idtplcfg=_art_lang.idtplcfg AND
                _container_conf.idtplcfg=_art_lang.idtplcfg AND
                _container.number=_container_conf.number AND
                _container.idtpl=_template_conf.idtpl AND
                _mod.idmod=_container.idmod AND
                _mod.type='Content'
            ORDER BY
                _mod.name;";
    $db->query($sql);
    while ($db->next_record()) {
        if (substr($db->f("name"), 0, 16) == 'Lightbox-Gallery') {
            return $db->f("container");
        }
    }
}