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; }