Error"; echo "

There are no GUIs available for this user.

"; printf("

",SID); return; } $v = array(); $t = array(); $sql = "SELECT DISTINCT gui_id,gui_name,gui_description, ggc.*,gc.category_name,gc.category_description "; $sql .= "FROM gui g "; $sql .= "LEFT JOIN gui_gui_category ggc ON g.gui_id = ggc.fkey_gui_id "; $sql .= "LEFT JOIN gui_category gc ON (ggc.fkey_gui_category_id = gc.category_id) "; $sql .= "WHERE gui_id IN ("; for($i = 0; $i < count($arrayGUIs); $i++) { if($i > 0) { $sql .= ","; } $sql .= "$".($i + 1); array_push($v,$arrayGUIs[$i]); array_push($t,'s'); } $sql .= ") ORDER BY gc.category_name, gui_name"; $result = db_prep_query($sql,$v,$t); $category = NULL; echo "

Mapbender - "._mb('available Applications')."

"; printf("

",SID); $total_guis = 0; while($row = db_fetch_array($result)){ if($category !== $row["category_name"]) { $category = $row["category_name"]; echo ""; if(strlen($row["category_name"]) > 0) { printf("

%s

",$row["category_name"]); }else{ printf("

%s

",""); } if(strlen($row["category_description"]) > 0) { printf("

%s

",$row["category_description"]); }else{ printf("

%s

",""); } echo "