"; $result = $db->query($sqlquery); if (DB::isError($result)) die ("$PHP_SELF: " . $result->getMessage()); $outArray = array(); $colorArray = array(); $count = 0; while ($row = $result->fetch_assoc()): $outArray[$count] = $row; $colorArray[$count] = "FF0000"; if (((int)$row["crvh_corporate_identity"] & 15) >= 1 && (((int)$row["crvh_corporate_identity"] / 16) & 15) >= 1) : $colorArray[$count] = "00FF00"; endif; $count++; endwhile; $result->free(); $outArrayLen = count($outArray); if ($debug) : print_r($outArray); echo "



"; endif; if ($outArrayLen > 0) : $tableOut .= "\n"; $tableOut .= "\n"; $tableOut .= ""; $tableOut .= "\n"; $tableOut .= "
" . getLngt("ÜBERSICHT CORPORATE IDENTITY") . "
\n"; $tableOut .= "

"; $tableOut .= "\n"; $tableOut .= "\n"; $tableOut .= ""; $tableOut .= ""; $tableOut .= "\n"; $tableOut .= "
   Mindestens ein Eintrag fehlt      Beide Einträge sind gesetzt   
\n"; $tableOut .= "

"; $tableOut .= "\n"; $tableOut .= "\n"; $tableOut .= "\n"; $tableOut .= "\n"; $tableOut .= "\n"; $tableOut .= "\n"; $tableOut .= "\n"; $tableOut .= "\n"; $tableOut .= "\n"; $tableOut .= "\n"; // Iterate all items for ($i = 0; $i < $outArrayLen; $i++) : $tmpArr = $outArray[$i]; $rowColor = $colorArray[$i]; $tableOut .= "\n"; $tableOut .= "\n"; $tableOut .= "\n"; $tableOut .= "\n"; $tableOut .= "\n"; $tableOut .= "\n"; $tableOut .= "\n"; $tableOut .= "\n"; $tableOut .= "\n"; endfor; $tableOut .= "
" . getLngt("NL") . "   " . getLngt("Fzg.") . "   " . getLngt("CI-Fzg.") . "   " . getLngt("CI-Kleidung") . "   " . getLngt("EID") . "   " . getLngt("Name") . "   " . getLngt("Vorname") . "   
" . $tmpArr["hq_mnemonic"] . "   " . $tmpArr["crvh_sid"] . "   " . $mapArrayCI[((int)$tmpArr["crvh_corporate_identity"] & 15)] . "   " . $mapArrayCI[(((int)$tmpArr["crvh_corporate_identity"] / 16) & 15)] . "   " . $tmpArr["cr_eid"] . "   " . $tmpArr["usr_name"] . "   " . $tmpArr["usr_firstname"] . "   
\n"; else : $output[] = "Keine Daten aufgefunden!"; endif; // Output $outputLen = count($output); for ($i = 0; $i < $outputLen; $i++) : echo $output[$i] . "
"; endfor; ?>