$uid
";
$table_data1[] = $row;
}
$table_data1 = sortArrayByFields(
$table_data1,
array('nachname' => array(SORT_ASC, SORT_STRING))
);
# Bereits vorhandene UIDs löschen
$query1 = "SELECT imtuid, uid
FROM dep_user
ORDER BY nachname ASC";
$result1 = $db->query ($query1)
or die ("Cannot execute query1");
while ($row1 = $result1->fetch_array()){
$table_data1 = removeElementWithValue($table_data1, "uid", $row1['uid']);
}
# Arrynummerierung wieder richtig machen nach Löschen von werte {[0],[3][4][7]} -> {[0],[1][2][3]}. Sonst spinnt loop in html
$table_data1 = array_values($table_data1);
# Übergabe des arrays in html
$smarty->assign('table_data1', $table_data1);
}else{
echo "Keine Verbindung zu LDAP";
}
# Alle Administratoren
$query2 = "SELECT imtuid, vorname, nachname, fakultaet, uid
FROM dep_user
ORDER BY nachname ASC";
$result2 = $db->query ($query2)
or die ("Cannot execute query2");
while ($row2 = $result2->fetch_array()){
$table_data2[] = $row2;
}
$smarty->assign('table_data2', $table_data2);
}
if($action == 'register'){
$uid = $_POST['dozent'];
if($uid == ''){
echo "";
exit;
}
$ds = @ldap_connect($global_ldap_serverhsnet, $global_ldap_porthsnet);
#ldap_set_option($ds, LDAP_OPT_PROTOCOL_VERSION, 3);
if ($ds) {
# bind wird benötigt, sonst werden die Umlaute bei Namen nicht richtig angezeigt ?!!?
$r = @ldap_bind($ds, $global_ldap_user, $global_ldap_pwd);
$_ldap_dn = "ou=Benutzer,ou=OUHochschulnetzwerk,dc=hsnet,dc=hs-ludwigsburg,dc=de";
$sr = ldap_search($ds, $_ldap_dn, "sAMAccountName=$uid");
$info = ldap_get_entries($ds, $sr);
$anzahl = ldap_count_entries($ds, $sr);
# AcitveDirectory oder OPEN LDAP
if($global_ldap_art == 1){
$vorname = $info[0]['givenname'][0];
$nachname = $info[0]['sn'][0];
}
if($global_ldap_art == 2){
$vorname = $info[0]['givenname'][0];
$nachname = $info[0]['sn'][0];
}
$mail = $info[0]['mail'][0];
$datum = date("Y-m-d H:i:s");
$db = dbconnect();
$sql1 = $db->query("INSERT INTO dep_user ( vorname
, nachname
, mail
, uid
, erstell_dat
)
VALUES
( '$vorname'
, '$nachname'
, '$mail'
, '$uid'
, '$datum'
)
");
}
echo "";
}
if($action == 'del'){
$imtuid = $_GET['imtuid'];
## Muss man nochmals überdenken, wenn ein Prof noch Deputate erfasst hat.
$db = dbconnect();
$del1 = $db->query("DELETE FROM dep_rollen_user_zuord WHERE imtuid = $imtuid");
$del1 = $db->query("DELETE FROM dep_userlog WHERE imtuid = $imtuid");
$del1 = $db->query("DELETE FROM dep_user WHERE imtuid = $imtuid");
echo "";
}
$smarty->assign('action', "$action");
$smarty->display("$template/$templatename");
?>