CONTENIDO Forum

Code: Alles auswählen

echo '              <select name="CMS_VAR[0]" size="1" disabled>',chr(10);
echo '                     <option value="">'.i18n("None").'</option>',chr(10);

$sql = "SELECT * FROM ".$cfg["tab"]["cat_tree"]." AS a,".$cfg["tab"]["cat_lang"]." AS b,
       ".$cfg["tab"]["cat"]." AS c WHERE a.idcat = b.idcat AND c.idcat = a.idcat AND
       c.idclient = '".$client."' AND b.idlang = '".$lang."' ORDER BY a.idtree";

$db->query($sql);

while ($db->next_record()) {
   $spaces = "";
   for ($i=0; $i<$db->f("level"); $i++) {
      $spaces .= "&nbsp;&nbsp;";
   }

   // echo '                     <option style="'.$style.'" value="'.$db->f("idcat").'">'.$spaces.' > '.$db->f("name").'</option>',chr(10);
   echo '                     <option style="font-weight: bold; color: #666666; background-color: #eeeeee;" value="">'.$spaces.' > '.$db->f("name").'</option>',chr(10);

   if ($cfg["is_start_compatible"] == true) {
      $sql2 = "SELECT * FROM ".$cfg["tab"]["cat_art"]." AS a, ".$cfg["tab"]["art"]." AS b,
              ".$cfg["tab"]["art_lang"]." AS c WHERE a.idcat = '".$db->f("idcat")."'
              AND b.idart = a.idart AND c.idart = a.idart AND
              c.idlang = '".$lang."' AND b.idclient = '".$client."' ORDER BY a.is_start DESC, c.title ASC";
   } else {
      $sql2 = "SELECT * FROM ".$cfg["tab"]["cat_art"]." AS a, ".$cfg["tab"]["art"]." AS b,
              ".$cfg["tab"]["art_lang"]." AS c WHERE a.idcat = '".$db->f("idcat")."'
              AND b.idart = a.idart AND c.idart = a.idart AND
              c.idlang = '".$lang."' AND b.idclient = '".$client."' ORDER BY c.title ASC";	
   }
  
   $db2->query($sql2);

   while ($db2->next_record()) {
      $selected = "";
      $tmp_title = $db2->f("title");
      if (strlen($tmp_title) > 32) {
         $tmp_title = substr($tmp_title, 0, 32);
      }

      $style = "";      	

      if ($cfg["is_start_compatible"] == true) {
         $is_start = $db2->f("is_start");
      } else {
         $is_start = isStartArticle($db2->f("idartlang"), $db2->f("idcat"), $lang);
         if ($is_start == true) {
            $is_start  = 1;
         } else {
            $is_start = 0;
         }
      }

      $strValue = $db2->f("idcatart");
      if ($is_start == 1 && $db2->f("online") == 0) {
         $style = "color: #ff0000";
         $strValue = "";
      }
      if ($is_start == 1 && $db2->f("online") == 1) {
         $style = "color: #0000ff";
      }
      if ($is_start == 0 && $db2->f("online") == 0) {
         $style = "color: #666666";
         $strValue = "";
      }
      if ($strHandlerID == $db2->f("idcatart")) {
         $selected = " selected";
      }
      echo '                     <option style="'.$style.'" value="'.$strValue.'"'.$selected.'>&nbsp;&nbsp;'.$spaces.' |&nbsp;&nbsp;'.$tmp_title.'</option>',chr(10);
  }
}