function send($newsletter_id)
{
global $db;
$owpDBTable = owpDBGetTables();
$send_mail = new phpmailer();
$send_mail->From = OWP_EMAIL_ADDRESS;
$send_mail->FromName = OWP_NAME;
$send_mail->Subject = $this->title;
$sql = "SELECT admin_gender, admin_firstname, admin_lastname,\n admin_email_address \n FROM " . $owpDBTable['administrators'] . " \n WHERE admin_newsletter = '1'";
$mail_values = $db->Execute($sql);
while ($mail = $mail_values->fields) {
$send_mail->Body = $this->content;
$send_mail->AddAddress($mail['admin_email_address'], $mail['admin_firstname'] . ' ' . $mail['admin_lastname']);
$send_mail->Send();
// Clear all addresses and attachments for next loop
$send_mail->ClearAddresses();
$send_mail->ClearAttachments();
$mail_values->MoveNext();
}
$today = date("Y-m-d H:i:s");
$db->Execute("UPDATE " . $owpDBTable['newsletters'] . " \n SET date_sent = " . $db->DBTimeStamp($today) . ",\n status = '1' \n WHERE newsletters_id = '" . owpDBInput($newsletter_id) . "'");
}
owpRedirect(owpLink($owpFilename['countries'], 'page=' . $_GET['page'] . '&cID=' . $_GET['cID']));
break;
case 'deleteconfirm':
$db->Execute("DELETE FROM " . $owpDBTable['countries'] . " \n WHERE countries_id = '" . $_GET['cID'] . "'");
owpRedirect(owpLink($owpFilename['countries'], 'page=' . $_GET['page']));
break;
case 'download':
$db_table_file = 'db_' . $owpDBTable['countries'] . '-' . date('YmdHis') . '.csv';
$file = fopen(OWP_CSV_TEMP . $db_table_file, "a+");
$sql = "SELECT countries_id, countries_name, countries_iso_code_2, \n countries_iso_code_3, address_format_id \n FROM " . $owpDBTable['countries'] . " \n ORDER BY countries_name";
$rs = $db->Execute($sql);
$rs->MoveFirst();
rs2csvfile($rs, $file);
fclose($file);
if (CVS_SEND_MAIL == 'true') {
$sql = "SELECT admin_gender, admin_firstname, admin_lastname, admin_email_address \n FROM " . $owpDBTable['administrators'] . " \n WHERE admin_id = '" . owpDBInput($_SESSION['user_id']) . "'";
$mail_query = $db->Execute($sql);
$mail_send_to = $mail_query->fields;
// Let's build a message object using the email class
$send_mail = new phpmailer();
$send_mail->From = OWP_OWNER_EMAIL_ADDRESS;
$send_mail->FromName = OWP_NAME;
$send_mail->Subject = EMAIL_COUNTRIES_CVS . strftime(DATE_FORMAT_LONG);
if ($mail_send_to['admin_gender'] == 'm') {
$body = EMAIL_GREET_MR . $mail_send_to['admin_lastname'] . ',' . "\n\n";
} else {
$body = EMAIL_GREET_MS . $mail_send_to['admin_lastname'] . ',' . "\n\n";
}
$body .= EMAIL_CVS_INTRO . ' ' . strftime(DATE_FORMAT_LONG) . "\n\n";
$body .= EMAIL_FTP_INFO . "\n";
$body .= ' ' . $db_table_file . "\n\n";
$error = true;
$entry_telephone_error = true;
} else {
$entry_telephone_error = false;
}
if (strlen($password) < PASSWORD_MIN_LENGTH) {
$error = true;
$entry_password_error = true;
} else {
$entry_password_error = false;
}
if ($password != $confirmation) {
$error = true;
$entry_password_error = true;
}
$check_email_query = $db->Execute("SELECT count(*) as total \n FROM " . $owpDBTable['administrators'] . " \n WHERE admin_email_address = '" . owpDBInput($email_address) . "'\n AND admin_id != '" . $_SESSION['user_id'] . "'");
$check_email = $check_email_query->fields;
if ($check_email['total'] > 0) {
$error = true;
$entry_email_address_exists = true;
} else {
$entry_email_address_exists = false;
}
if ($error == true) {
$processed = true;
define('JS_PASSWORD_CHECK', 'true');
$breadcrumb->add(NAVBAR_TITLE_1, owpLink($owpFilename['account'], '', 'SSL'));
$breadcrumb->add(NAVBAR_TITLE_2, owpLink($owpFilename['account_edit'], '', 'SSL'));
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php
Copyright (c) 2002 osCommerce
----------------------------------------------------------------------
Released under the GNU General Public License
---------------------------------------------------------------------- */
require 'includes/system.php';
require OWP_LANGUAGES_DIR . $language . '/' . $owpFilename['password_forgotten'];
if ($_GET['action'] == 'process') {
$sql = "SELECT admin_id, admin_gender, admin_firstname, admin_lastname, admin_email_address\n FROM " . $owpDBTable['administrators'] . " \n WHERE admin_email_address = '" . owpDBInput($email_address) . "'";
$check_admin_query = $db->Execute($sql);
if ($check_admin_query->RecordCount()) {
$check_admin = $check_admin_query->fields;
// Crypted password mods - create a new password, update the database and mail it to them
include_once OWP_FUNCTIONS_DIR . $owpFilename['password_crypt'];
$newpass = owpCreatePassword(PASSWORD_MIN_LENGTH);
$crpted_password = owpCryptPassword($newpass);
$db->Execute("UPDATE " . $owpDBTable['administrators'] . " \n SET admin_password = "******"\n WHERE admin_id = '" . owpDBInput($check_admin['admin_id']) . "'");
$name = $check_admin['admin_firstname'] . " " . $check_admin['admin_lastname'];
if ($check_admin['admin_gender'] == 'm') {
$email_text = EMAIL_GREET_MR . $check_admin['admin_lastname'] . ',' . "\n\n";
} else {
$email_text = EMAIL_GREET_MS . $check_admin['admin_lastname'] . ',' . "\n\n";
}
$email_text .= EMAIL_PASSWORD_INTRO;
$email_text .= sprintf(EMAIL_PASSWORD_BODY, $newpass);
$email_text .= EMAIL_PASSWORD_FOOT;
owpMail($name, $check_admin['admin_email_address'], EMAIL_PASSWORD_SUBJECT, nl2br($email_text), OWP_NAME, OWP_EMAIL_ADDRESS);
$messageStack->add_session(SUCCESS_PASSWORD_SENT, 'success');
owpRedirect(owpLink($owpFilename['login'], '', 'SSL'));
} else {
$messageStack->add(ERROR_NO_USER, 'error');
}
include_once OWP_FUNCTIONS_DIR . $owpFilename['password_crypt'];
$sql = "SELECT admin_id, admin_gender, admin_firstname, admin_lastname,\n admin_email_address, admin_password, admin_allowed_pages, admin_login \n FROM " . $owpDBTable['administrators'] . " \n WHERE admin_email_address = '" . owpDBInput($email_address) . "'";
$check_admin_query = $db->Execute($sql);
if ($check_admin_query->RecordCount()) {
$check_admin = $check_admin_query->fields;
if (!owpValidatePasword($password, $check_admin['admin_password'])) {
$messageStack->add(ERROR_LOGIN_ERROR, 'error');
} else {
if ($check_admin['admin_login'] == '1') {
$_SESSION['user_id'] = $check_admin['admin_id'];
$_SESSION['gender'] = $check_admin['admin_gender'];
$_SESSION['firstname'] = $check_admin['admin_firstname'];
$_SESSION['lastname'] = $check_admin['admin_lastname'];
$_SESSION['allowed_pages'] = $check_admin['admin_allowed_pages'];
$today = date("Y-m-d H:i:s");
$db->Execute("UPDATE " . $owpDBTable['administrators_info'] . " \n\t SET admin_info_date_of_last_logon = " . $db->DBTimeStamp($today) . ",\n\t admin_info_number_of_logons = admin_info_number_of_logons+1 \n WHERE admin_info_id = '" . owpDBInput($check_admin['admin_id']) . "'");
if (sizeof($navigation->snapshot) > 0) {
$origin_href = owpLink($navigation->snapshot['page'], owpArraytoString($_SESSION['navigation']->snapshot['get'], array(owpSessionName())), $_SESSION['navigation']->snapshot['mode']);
$navigation->clear_snapshot();
owpRedirect($origin_href);
} else {
owpRedirect(owpLink($owpFilename['index'], '', 'NONSSL'));
}
} else {
$messageStack->add(ERROR_NO_USER_LOGIN, 'error');
}
}
} else {
$messageStack->add(ERROR_LOGIN_NO_USER, 'error');
}
}
$newsletter_query = $db->Execute($sql);
$newsletter = $newsletter_query->fields;
include OWP_LANGUAGES_DIR . $language . '/modules/newsletters/' . $nInfo->module . '.php';
include OWP_MODULES_DIR . 'newsletters/' . $nInfo->module . '.php';
$module_name = $nInfo->module;
$module = new $module_name($nInfo->title, $nInfo->content);
?>
<tr>
<td><?php
echo $module->confirm();
?>
</td>
</tr>
<?php
} elseif ($_GET['action'] == 'confirm_send') {
$sql = "SELECT newsletters_id, title, content, module \n FROM " . $owpDBTable['newsletters'] . " \n WHERE newsletters_id = '" . owpDBInput($_GET['nID']) . "'";
$newsletter_query = $db->Execute($sql);
$newsletter = $newsletter_query->fields;
$nInfo = new objectInfo($newsletter);
include_once OWP_LANGUAGES_DIR . $language . '/modules/newsletters/' . $nInfo->module . '.php';
include_once OWP_MODULES_DIR . $nInfo->module . '.php';
$module_name = $nInfo->module;
$module = new $module_name($nInfo->title, $nInfo->content);
?>
<tr>
<td><table border="0" cellspacing="0" cellpadding="2">
<tr>
<td class="main" valign="middle"><?php
echo owpImage(OWP_IMAGES_DIR . 'ani_send_email.gif', IMAGE_ANI_SEND_EMAIL);
?>
</td>
