CONTENIDO Forum

Code: Alles auswählen

<?php

// alle activen Sprachen ermitteln
//$query = "SELECT idlang, name FROM con_lang WHERE active=1 ORDER BY idlang";
$query = "SELECT idlang, name FROM con_lang WHERE active=1 ORDER BY name";
// execute query
$db->query($query);

// Listbox erstellen, javascript wird aktiv wenn Wert sich aendert
echo '<select id="lang" name="changeactivelang" onchange="parent.frames.top.location.href = this.value">';

while ( $db->next_record() ) {
   // idlang, name ermitteln
   $c_idlang = $db->f("idlang");
   $c_name = $db->f("name");

   // aktuelle Sprache wird selected
   if ($c_idlang == $lang) {
      $lang_sel = "selected=\"selected\"";
   } else {
      $lang_sel = "";
   }

   // Link fuer das wechseln der Sprache wird in value geschrieben
   echo '
   <option value="front_content.php?client='.$client.'&changelang='.$c_idlang.'&parent='.$parent.'&subid='.$subid.'&idcat='.$idcat.'" '.$lang_sel.'>'.$c_name.'</option>';
}
   echo '
    </select>';

?> 

Code: Alles auswählen

$query = "SELECT a.idlang, b.name FROM ".$cfg['sql']['sqlprefix']."_clients_lang a, ".$cfg['sql']['sqlprefix']."_lang" b WHERE idclient = ".$client." and a.idlang = b.idlang and b.active=1 ORDER BY name";

Code: Alles auswählen

$query = "SELECT idlang, name FROM con_lang WHERE active=1 ORDER BY name";

Code: Alles auswählen

$query = "SELECT a.idlang, b.name FROM ".$cfg['sql']['sqlprefix']."_clients_lang a, ".$cfg['sql']['sqlprefix']."_lang b WHERE idclient = ".$client." and a.idlang = b.idlang and b.active=1 ORDER BY name";