$userarray = $db->result(); // check use mailbox insnt full $query = "SELECT * FROM " . $DBPrefix . "messages WHERE sentto = :user_id"; $params = array(); $params[] = array(':user_id', $userarray['id'], 'int'); $db->query($query, $params); if ($db->numrows() >= $mailbox_space) { $_SESSION['message'] = sprintf($MSG['443'], $sendto); header('location: mail.php'); exit; } } else { // send the email $emailer = new email_handler(); $from_email = $system->SETTINGS['users_email'] == 'n' ? $user->user_data['email'] : $system->SETTINGS['adminmail']; $emailer->email_basic($subject, $sendto, $nowmessage, $from_email); } // send message $id_type = $email ? 'fromemail' : 'sentto'; $query = "INSERT INTO " . $DBPrefix . "messages (" . $id_type . ", sentfrom, message, subject, reply_of, question)\n\t\t\tVALUES (:to_ids, :sender_id, :nowmessages, :subjects, :reply_of_hash, :question_hash)"; $params = array(); $params[] = array(':to_ids', $email ? $sendto : $userarray['id'], 'bool'); $params[] = array(':sender_id', $user->user_data['id'], 'int'); $params[] = array(':nowmessages', $nowmessage, 'str'); $params[] = array(':subjects', $subject, 'str'); $params[] = array(':reply_of_hash', $_SESSION['reply_of' . $_POST['hash']], 'int'); $params[] = array(':question_hash', $_SESSION['question' . $_POST['hash']], 'int'); $db->query($query, $params); // Track IP if (defined('TrackUserIPs')) { $system->log('user', 'Post Private Message', $user->user_data['id'], $db->lastInsertId());
$INFO = $MSG['email_settings_updated']; } } $selectsetting = isset($system->SETTINGS['mail_protocol']) ? $system->SETTINGS['mail_protocol'] : '0'; loadblock($MSG['1119'], '', generateSelect('mail_protocol', $mail_protocol)); loadblock($MSG['1120'], '<span class="non_smtp para">' . $MSG['1121'], 'text', 'mail_parameter', $system->SETTINGS['mail_parameter']); loadblock($MSG['1133'] . '<span class="smtp"></span>' . $MSG['1141'], '', '', '', '', array(), true); loadblock($MSG['1128'], '<span class="smtp"></span>', 'yesno', 'smtp_authentication', $system->SETTINGS['smtp_authentication'], array($MSG['yes'], $MSG['no'])); $selectsetting = isset($system->SETTINGS['smtp_security']) ? $system->SETTINGS['smtp_security'] : 'none'; loadblock($MSG['1127'], '<span class="smtp"></span>', generateSelect('smtp_security', $smtp_secure_options)); loadblock($MSG['1126'], '<span class="smtp"></span>', 'text', 'smtp_port', $system->SETTINGS['smtp_port']); loadblock($MSG['1124'], '<span class="smtp"></span>', 'text', 'smtp_username', $system->SETTINGS['smtp_username']); loadblock($MSG['1125'], '<span class="smtp"></span>', 'text', 'smtp_password', $system->SETTINGS['smtp_password']); loadblock($MSG['1122'], '<span class="smtp"></span>', 'text', 'smtp_host', $system->SETTINGS['smtp_host']); loadblock($MSG['1129'], sprintf($MSG['1130'], $system->SETTINGS['adminmail']), 'text', 'alert_emails', $system->SETTINGS['alert_emails']); $mail_info2 = ''; // send test email if (isset($_GET['test_email'])) { $user_name = filter_var($_POST["user_name"], FILTER_SANITIZE_STRING); $to_email = filter_var($_POST["user_email"], FILTER_SANITIZE_EMAIL); $subject = filter_var($_POST["subject"], FILTER_SANITIZE_STRING); $message = filter_var($_POST["message"], FILTER_SANITIZE_STRING); $emailer = new email_handler(); $emailer->email_basic($subject, $to_email, $message); die; } $template->assign_vars(array('SITEURL' => $system->SETTINGS['siteurl'], 'TYPENAME' => $MSG['524'], 'PAGENAME' => $MSG['1131'], 'MAIL_PROTOCOL' => $mail_protocol[$system->SETTINGS['mail_protocol']], 'SMTP_AUTH' => $system->SETTINGS['smtp_authentication'], 'SMTP_SEC' => $system->SETTINGS['smtp_security'], 'SMTP_PORT' => !empty($system->SETTINGS['smtp_port']) && is_numeric($system->SETTINGS['smtp_port']) ? $system->SETTINGS['smtp_port'] : 25, 'SMTP_USER' => $system->SETTINGS['smtp_username'], 'SMTP_PASS' => $system->SETTINGS['smtp_password'], 'SMTP_HOST' => $system->SETTINGS['smtp_host'], 'ALERT_EMAILS' => $system->SETTINGS['alert_emails'], 'ADMIN_EMAIL' => $system->SETTINGS['adminmail'])); include 'header.php'; $template->set_filenames(array('body' => 'emailsettings.tpl')); $template->display('body'); include 'footer.php';
$query = "SELECT title FROM " . $DBPrefix . "auctions WHERE id = :auction_id"; $params = array(); $params[] = array(':auction_id', $auction_id, 'int'); $db->query($query, $params); if ($db->numrows() == 0) { $ERR = $ERR_622; } else { $item_title = $db->result('title'); $item_title = $system->uncleanvars($item_title); $from_email = $system->SETTINGS['users_email'] == 'n' ? $user->user_data['email'] : $system->SETTINGS['adminmail']; // Send e-mail message $subject = $MSG['335'] . ' ' . $system->SETTINGS['sitename'] . ' ' . $MSG['336'] . ' ' . $item_title; $message = $MSG['084'] . ' ' . $MSG['240'] . ': ' . $from_email . "\n\n" . $_POST['TPL_text']; $emailer = new email_handler(); $emailer->email_uid = $user_id; $emailer->email_basic($subject, $email, nl2br($message), $user->user_data['name'] . '<' . $from_email . '>'); //send the email :D // send a copy to their mesasge box $nowmessage = nl2br($system->cleanvars($message)); $query = "INSERT INTO " . $DBPrefix . "messages (sentto, sentfrom, sentat, message, subject)\n\t\t\t\t\tVALUES (:id, :user_id, :times, :nowmessage, :msg)"; $params = array(); $params[] = array(':id', $user_id, 'int'); $params[] = array(':user_id', $user->user_data['id'], 'int'); $params[] = array(':times', time(), 'int'); $params[] = array(':nowmessage', $nowmessage, 'str'); $params[] = array(':msg', $system->cleanvars(sprintf($MSG['651'], $item_title)), 'str'); $db->query($query, $params); $sent = true; } } }