$data['resume'] = $_POST['resume'];
$data['requested_on'] = now();
if ($_POST['from'] == 'contacts') {
$tmp_referrers = array();
foreach ($referrers as $key => $value) {
$query = "SELECT CONCAT(lastname, ', ', firstname) AS fullname \n FROM members \n WHERE email_addr = '" . $value . "' LIMIT 1";
$result = $mysqli->query($query);
$tmp_referrers[$key]['id'] = $value;
$tmp_referrers[$key]['fullname'] = 'Unknown';
if (count($result) > 0 && !is_null($result)) {
$tmp_referrers[$key]['fullname'] = $result[0]['fullname'];
}
}
$referrers = $tmp_referrers;
$data['referrer'] = $referrers;
if (ReferralRequests::create_multiple($data)) {
$lines = file(dirname(__FILE__) . '/private/mail/candidate_referral_request.txt');
$raw_message = '';
foreach ($lines as $line) {
$raw_message .= $line;
}
$raw_message = str_replace('%member_name%', htmlspecialchars_decode(desanitize($member->get_name())), $raw_message);
$raw_message = str_replace('%member_email_addr%', $member->id(), $raw_message);
$raw_message = str_replace('%protocol%', $GLOBALS['protocol'], $raw_message);
$raw_message = str_replace('%root%', $GLOBALS['root'], $raw_message);
$raw_message = str_replace('%job%', htmlspecialchars_decode($job_title), $raw_message);
$raw_message = str_replace('%employer%', htmlspecialchars_decode(desanitize($employer_name)), $raw_message);
$subject = htmlspecialchars_decode(desanitize($member->get_name())) . " requested for your referral!";
$headers = 'From: YellowElevator.com <*****@*****.**>' . "\n";
foreach ($referrers as $referrer) {
$message = str_replace('%referrer_name%', htmlspecialchars_decode(desanitize($referrer['fullname'])), $raw_message);
