break;
default:
break;
}
// end of switch
} else {
// show username as well (useful)
$sql = Database::get()->queryArray("SELECT id, givenname, surname, username, faculty_id, date_open, comment, password FROM user_request\n WHERE (state = 1 AND status = {$list_status} {$depqryadd})");
if (count($sql) > 0) {
$tool_content .= "<div class='table-responsive'><table id='requests_table' class='table-default'>";
$tool_content .= table_header();
$tool_content .= "<tbody>";
foreach ($sql as $req) {
$tool_content .= "<td>" . q($req->givenname) . " " . q($req->surname) . "</td>";
$tool_content .= "<td>" . q($req->username) . "</td>";
$tool_content .= "<td>" . hierarchy::unserializeLangField(find_faculty_by_id($req->faculty_id)) . "</td>";
$tool_content .= "<td align='center'>\n <small>" . nice_format(date('Y-m-d', strtotime($req->date_open))) . "</small></td>";
$tool_content .= "<td class='option_btn_cell'>";
switch ($req->password) {
case 'pop3':
$link = "../auth/ldapnewprofadmin.php?id={$req->id}&auth=2";
$authmethod = "({$langViaPop})";
break;
case 'imap':
$link = "../auth/ldapnewprofadmin.php?id={$req->id}&auth=3";
$authmethod = "({$langViaImap})";
break;
case 'ldap':
$link = "auth/ldapnewprofadmin.php?id={$req->id}&auth=4";
$authmethod = "({$langViaLdap})";
break;
$qry = "SELECT id, username, email, verified_mail FROM user WHERE id = {$u_id}";
$id = $u_id;
} else {
$user_error_msg = $langMailVerifyNoId;
}
$res = Database::get()->querySingle($qry);
if ($res) {
$username = $res->username;
$email = $res->email;
// success
if (token_validate($username . $email . $id, $code)) {
$verified_mail = intval($res->verified_mail);
// update user's application
if (!empty($req_id) and $verified_mail !== 1) {
Database::get()->query("UPDATE user_request SET verified_mail = 1 WHERE id = ?d", $req_id);
$department = find_faculty_by_id($res->faculty_id);
$prof = isset($res->status) && intval($res->status) === 1 ? 1 : NULL;
$givenname = $res->givenname;
$surname = $res->surname;
$am = $res->am;
$usercomment = $res->comment;
$usermail = $res->email;
$userphone = $res->phone;
$subject = $prof ? $mailsubject : $mailsubject2;
$MailMessage = $mailbody1 . $mailbody2 . "{$givenname} {$surname}\n\n" . $mailbody3 . $mailbody4 . $mailbody5 . ($prof ? $mailbody6 : $mailbody8) . "\n\n{$langFaculty}: {$department}\n{$langComments}: {$usercomment}\n" . "{$langAm}: {$am}\n" . "{$langProfUname}: {$username}\n{$langProfEmail} : {$usermail}\n" . "{$contactphone}: {$userphone}\n\n\n{$logo}\n\n";
$emailAdministrator = get_config('email_sender');
if (!send_mail($siteName, $emailAdministrator, '', get_config('email_helpdesk'), $subject, $MailMessage, $charset, "Reply-To: {$usermail}")) {
$user_msg = $langMailErrorMessage;
} else {
$user_msg = $infoprof;
}
