function rescue_item($user_id, $mail_id, $resend = false) { global $dbh, $logger; $sth = $dbh->prepare("SELECT sender_email, contents, " . "envelope_to, maia_mail_recipients.type " . "FROM maia_mail, maia_mail_recipients " . "WHERE maia_mail.id = maia_mail_recipients.mail_id " . "AND maia_mail_recipients.recipient_id = ? " . "AND maia_mail_recipients.mail_id = ?"); $res = $sth->execute(array($user_id, $mail_id)); if (PEAR::isError($sth)) { die($sth->getMessage()); } if ($row = $res->fetchrow()) { $sender_email = $row["sender_email"]; $body = $row["contents"]; $type = $row["type"]; if (extension_loaded('mcrypt')) { if (text_is_encrypted($body)) { $key = get_encryption_key(); $body = decrypt_text($key, $body); } } if (is_a_domain_default_user($user_id)) { // System default user (@.) or domain-class user (e.g. @domain) $my_email_address = $row["envelope_to"]; } else { // Regular user (e.g. user@domain) $rlist = explode(" ", trim($row["envelope_to"])); $sth2 = $dbh->prepare("SELECT email FROM users " . "WHERE maia_user_id = ? " . "AND email = ?"); $my_email_address = ""; foreach ($rlist as $rmail) { $res2 = $sth2->execute(array($user_id, $rmail)); if (PEAR::isError($sth2)) { die($sth2->getMessage()); } if ($row2 = $res2->fetchrow()) { $my_email_address = $row2["email"]; break; } } $sth2->free(); } if (!empty($my_email_address)) { if ($resend || $type != 'P') { // don't send if it is a labeled fp $smtp_result = smtp_send($sender_email, $my_email_address, $body); } else { $smtp_result = "200 no delivery needed"; } if (($succeeded = strncmp($smtp_result, "2", 1) == 0) || $type == 'P') { if (!$resend) { if ($type == 'S' || $type == 'P') { record_mail_stats($user_id, $mail_id, "fp"); if (get_user_value($user_id, "auto_whitelist") == "Y") { add_address_to_wb_list($user_id, $sender_email, "W"); } } set_item_confirmations('G', $user_id, $mail_id); } } else { $logger->err("rescue attempt failed! " . $smtp_result); } } else { $smtp_result = $lang['text_rescue_error'] . "(EmptyAddress)"; // code really shouldn't be here. } } else { $smtp_result = $lang['text_rescue_error'] . "(MessageNotFound)"; // code really shouldn't be here. } $sth->free(); $logger->info($smtp_result); return $smtp_result; }
if ($row["DOB"] !== '//') { $pdf->SetXY(33, 55.3); $pdf->Write(10, decrypt_text($row["DOB"], $key1, $key2)); } if ('M' == $row["GENDER"]) { //Gender: Male $pdf->SetXY(82.3, 55); $pdf->Write(10, 'x'); } else { //Gender: Female $pdf->SetXY(100.7, 55); $pdf->Write(10, 'x'); } //SSN $pdf->SetXY(136, 55.3); $pdf->Write(10, decrypt_text($row["SSN"], $key1, $key2)); //Student //if ('Y' == $row["STUDENT"]){ $pdf->SetXY(102.5, 61.5); $pdf->Write(10, 'x'); //} //Employer $pdf->SetXY(28, 61.5); $pdf->Write(10, $row["EMPLOYER"]); //Employer address if (strlen($row["EMPLOYER_ADDRESS"]) < 30) { $pdf->SetXY(43, 68); $pdf->Write(10, $row["EMPLOYER_ADDRESS"]); } else { $pdf->SetFont('Arial', '', 10); $pdf->SetXY(43, 68);
// Decoding is provided for common formats: // // base64 // quoted-printable // 8bit // 7bit // $sth = $dbh->prepare("SELECT maia_mail.contents, maia_mail.sender_email " . "FROM maia_mail, maia_mail_recipients " . "WHERE maia_mail.id = maia_mail_recipients.mail_id " . "AND maia_mail.id = ? " . "AND maia_mail_recipients.recipient_id = ?"); $res = $sth->execute(array($id, $euid)); if ($row = $res->fetchrow()) { $contents = $row["contents"]; $sender_email = $row['sender_email']; if (extension_loaded('mcrypt')) { if (text_is_encrypted($contents)) { $key = get_encryption_key(); $contents = decrypt_text($key, $contents); } } $smarty->assign("spamreport_rows", display_spam_report($id)); if (!$raw) { // Try to decode the mail and display all of its parts. $mail = new Mail_mimeDecode(get_magic_quotes_gpc() ? stripslashes($contents) : $contents); $args['include_bodies'] = true; $args['decode_bodies'] = true; $args['decode_headers'] = false; // the inconv decoding will handle the headers $structure = $mail->decode($args); $smarty->assign("message", display_parts($structure)); $headers = $structure->headers; foreach ($headers as $key => $value) { if (is_array($value)) {
<?php /***** *Database middle man by Leon Blakey ******/ include 'Crypto.php'; include 'DBCred.php'; $raw_get = decrypt_text($_GET['edata']); mb_parse_str($raw_get, $_GET); if (isset($_POST['edata'])) { $raw_post = decrypt_text($_POST['edata']); mb_parse_str($raw_post, $_POST); } if (!isset($_GET['mode'])) { die('No mode specified or not found'); } function send($string) { encrypt_text($string); } $MODE = $_GET['mode']; switch ($MODE) { //Is this trying to see if the user is in gamers club? case "userExists": $user = mysql_real_escape_string($_GET['user']); $query = mysql_query("SELECT * FROM users WHERE `username`='{$user}'") or die("MYSQL ERROR: " + mysql_error()); $numRows = mysql_num_rows($query); $result = mysql_fetch_assoc($query); if ($numRows == 0) { //user dosen't exist, return false die(encrypt_text("false"));
//Auto $pdf->SetXY(38.5, 206.5); $pdf->Write(10, 'X'); } elseif ($row["NEED_TREATMENT_FOR"] == 'Accident') { //Accident $pdf->SetXY(64, 206.5); $pdf->Write(10, 'X'); } //Date of Injury if ($row["DATE_OF_INJURY"] !== '//') { $pdf->SetXY(37, 197); $pdf->Write(10, $row["DATE_OF_INJURY"]); } //Claim Number $pdf->SetXY(37, 202); $pdf->Write(10, decrypt_text($row["CLAIM_NUMBER"], $key1, $key2)); //Emergency Contact $pdf->SetXY(52, 215.5); $pdf->Write(10, $row["EMERGENCY_CONTACT_FIRST"] . " " . $row["EMERGENCY_CONTACT_LAST"]); //Emergency Contact Phone Number if (strlen($row["EMERGENCY_CONTACT_PHONE"]) > 4) { $pdf->SetXY(155, 215.5); $pdf->Write(10, $row["EMERGENCY_CONTACT_PHONE"]); } //Signature $pdf->SetFont('Helvetica', '', 12); $pdf->SetXY(32, 248); $pdf->Write(10, $row["SIGNATURE"]); //Today's Date $pdf->SetXY(165, 248); $pdf->Write(10, $row["TODAY_DATE"]);
//Father's address $pdf->SetXY(135, 142); $pdf->Write(10, $row["FATHER_ADDRESS"]); //Father's city $pdf->SetXY(19, 148.5); $pdf->Write(10, $row["FATHER_CITY"]); //Father's State $pdf->SetXY(108, 148.5); $pdf->Write(10, $row["FATHER_STATE"]); //Father's zip $pdf->SetXY(135, 148.5); $pdf->Write(10, $row["FATHER_ZIP"]); //Father's DOB if (decrypt_text($row["FATHER_DOB"], $key1, $key2) !== '//') { $pdf->SetXY(175, 148.5); $pdf->Write(10, decrypt_text($row["FATHER_DOB"], $key1, $key2)); } //Father's employer if (strlen($row["FATHER_EMPLOYER"]) < 35) { $pdf->SetXY(28, 155); $pdf->Write(10, $row["FATHER_EMPLOYER"]); } else { $pdf->SetFont('Arial', '', 10); $pdf->SetXY(28, 155); $pdf->Write(10, $row["FATHER_EMPLOYER"]); } //Father's employer address $pdf->SetFont('Arial', '', 12); $pdf->SetXY(119, 155); $pdf->Write(10, $row["FATHER_EMPLOYER_ADDRESS"]); //Father's employer city