CONTENIDO Forum

Code: Alles auswählen

    <tr>
    <td class="text_medium"><?= mi18n("Seite für Detailansicht:") ?></td>
    <td class="text_medium"><select name="CMS_VAR[2]">
    <option value="0"><?= mi18n("-- keine --") ?></option>
<?php


$sql = "SELECT
                         A.idcat,
                         C.name,
                        C.public,
                        C.idcatlang,
                        B.parentid,
                        A.level
                     FROM
                         ".$cfg["tab"]["cat_tree"]." AS A,
                         ".$cfg["tab"]["cat"]." AS B,
                         ".$cfg["tab"]["cat_lang"]." AS C
                     WHERE
                         A.idcat     = B.idcat   AND
                         B.idcat     = C.idcat   AND
                         B.idclient  = '$client' AND
                         C.idlang    = '$lang'   AND
                         C.visible   = '1'       AND
                         A.level  >= '0'
                     ORDER
                         BY A.idtree";
$db->query($sql);
                    
while ($db->next_record()) {
    $blank = "";
    for ($i=0; $i<$db->f("level"); $i++) {
        $blank .= "&nbsp;&nbsp;";
    }
    $objArtCollection = new ArticleCollection ( Array("idcat"=>$db->f("idcat"),"start"=>true,"client"=>$client) );
    if ($objArtCollection->count > 0) {
        $objCat = new cApiCategoryLanguage($db->f("idcat"));
        echo '<optgroup label="'.$objCat->values['name'].'">';
        
        while ($article = $objArtCollection->nextArticle()) { 
            $selected = ("CMS_VALUE[2]" == $article->getField("idartlang")) ? " selected" : "";
            echo '<option value="'.$article->getField("idartlang").'"'.$selected.'>'.$blank.$article->getField("title").'</option>';
        }
        
        echo "</optgroup>";
    }
}