"Mit Mathematikern ist kein heiteres Verhältnis zu gewinnen."

Johann Wolfgang von Goethe

set_charset("latin1"); /* $result_AP = mysql_query("select * from APosition"); */ $result_AP = $db_id->query("select * from APosition"); /* for ($i = 0; $i < mysql_NumRows($result_AP); $i++) { */ while ($apos = $result_AP->fetch_assoc()) { /* ** Abfrage der Mitarbeiter vorgezogen und unbesetzte Positionen unterdrueckt. ** 2013-06-05 mo */ /* $APID = mysql_Result($result_AP, $i,"Position_ID"); */ /* $result_A = mysql_query("select * from mitarbeiter where position like $APID order by nachname, vorname"); */ $APID = $apos["Position_ID"]; $result_A = $db_id->query("select * from mitarbeiter where position like $APID order by nachname, vorname"); /* if (mysql_NumRows($result_A) == 0) { */ if ($result_A->num_rows == 0) { continue; } if ($LANGUAGE == "de") { /* $APtitle = mysql_Result($result_AP, $i,"Position_Bezeichnung"); */ $APtitle = $apos["Position_Bezeichnung"]; } else { /* $APtitle = mysql_Result($result_AP, $i,"Position_English"); */ $APtitle = $apos["Position_English"]; } print "$APtitle\n"; print " \n"; if ($LANGUAGE == "de") { print "\n"; print "\n"; } else { print "\n"; print "\n"; } /* $j = 0; */ /* while ($j < mysql_NumRows($result_A)) { */ /* $NAME = mysql_Result($result_A, $j,"nachname"); */ /* $VORNAME = mysql_Result($result_A, $j,"vorname"); */ /* $TITEL = mysql_Result($result_A, $j,"titel"); */ /* $USERNAME = mysql_Result($result_A, $j,"username"); */ /* $DURCHWAHL = mysql_Result($result_A, $j,"tel"); */ /* $EMAIL = mysql_Result($result_A, $j,"mail"); */ while ($attr_a = $result_A->fetch_assoc()) { $NAME = $attr_a["nachname"]; $VORNAME = $attr_a["vorname"]; $TITEL = $attr_a["titel"]; $USERNAME = $attr_a["username"]; $DURCHWAHL = $attr_a["tel"]; $EMAIL = $attr_a["mail"]; if ($APID<3){ /* list($DURCHWAHL,$lala,$lala)=split("&",$DURCHWAHL,3); */ $DURCHWAHL = explode("&", $DURCHWAHL, 2)[0]; }; $URL = "http://www.zaik.uni-koeln.de/"; if ($USERNAME == "schrader") $URL = $URL . "~rs/index.html"; else { if (is_dir("/homes/$USERNAME/pub")) $URL = $URL . "~$USERNAME/"; else $URL = ""; } print "\n";} else if ($NAME == "Schrader"){ print "Schrader\n";} else if ($NAME == "Neuhaus"){ print "neuhaus\n";} else if ($NAME == "Schulze"){ print "schulze\n";} else if ($NAME == "Müller"){ print "\n";} else if ($NAME == "Motameny"){ print "motameny\n";} else if ($NAME == "Fuchs"){ print "bfuchs\n";} else if ($NAME == "Schönhuth"){ print "schoenhuth\n";} else if ($NAME == "Hagemeier"){ print "hagemeier\n";} else if ($NAME == "Gräfe"){ print "graefe\n";} else if ($NAME == "Lätsch"){ print "laetsch\n";} else if ($NAME == "Andres"){ print "andres\n";} else if ($NAME == "Gebert"){ print "gebert\n";} else if ($NAME == "Räbiger"){ print "raebiger\n";} else if ($NAME == "Fakler"){ print "fakler\n";} else { print "$EMAIL\n"; } print "\n"; print "

Name	e-mail	Telefonanschluss
Name	E-mail	Extension
"; if ($URL) print ""; print "$TITEL $VORNAME $NAME"; if ($URL) print ""; print "	\n"; /* $EMAIL = eregi_replace("\@.*", "", $EMAIL); */ $EMAIL = explode("@", $EMAIL, 2)[0]; if ($NAME == "Faigle"){ print "faigle	$DURCHWAHL\n"; /* $j++; */ } print "

\n"; print "

\n"; } if ($LANGUAGE == "de") { print "Ehemalige Mitarbeiter\n"; print "\n"; print "\n"; print "

Eine Liste ehemaliger Mitarbeiter

\n"; } else { print "Alumni\n"; print "\n"; print " \n"; print "

A list of Alumni

\n"; } ?>