* $Author:: $ *
* -------------------------------------------------------------------- *
* Copyright (c) 2003 - 2009 by Roland Haeder *
- * Copyright (c) 2009 - 2011 by Mailer Developer Team *
+ * Copyright (c) 2009 - 2015 by Mailer Developer Team *
* For more information visit: http://mxchange.org *
* *
* This program is free software; you can redistribute it and/or modify *
addYouAreHereLink('admin', __FILE__);
if (isFormSent()) {
- $result = SQL_QUERY("SELECT
- `userid`,`email`
+ $result = sqlQuery("SELECT
+ `userid`,
+ `email`
FROM
`{?_MYSQL_PREFIX?}_user_data`
WHERE
- `status`='CONFIRMED' AND `nl_receive`='Y'
+ `status`='CONFIRMED' AND
+ `nl_receive`='Y'
ORDER BY
`userid` ASC", __FILE__, __LINE__);
- if (!SQL_HASZERONUMS($result)) {
+ if (!ifSqlHasZeroNums($result)) {
// Members are available so we can send out the newsletter!
- while ($content = SQL_FETCHARRAY($result)) {
+ while ($content = sqlFetchArray($result)) {
// Construct mail...
$template = 'newsletter';
// Check for extension and sending-mode
- if (!isExtensionActive('html_mail', true) && (postRequestElement('mail_mode') == 'html')) {
+ if (!isExtensionActive('html_mail', TRUE) && (postRequestElement('mail_mode') == 'html')) {
// Set mode to text mode
postRequestElement('mail_mode') == 'text';
} elseif (postRequestElement('mail_mode') == 'html') {
} // END - if
// Free memory
- SQL_FREERESULT($result);
+ sqlFreeResult($result);
} else {
// Copy data into constants for the template and load it
$content['datestamp'] = generateDateTime(time(), 3);
// Extension html_mail installed?
if (isExtensionActive('html_mail')) {
// Load template with HTML mode
- loadTemplate('admin_newsletter', false, $content);
+ loadTemplate('admin_newsletter', FALSE, $content);
} else {
// Load template with only text mode
- loadTemplate('admin_newsletter_nohtml', false, $content);
+ loadTemplate('admin_newsletter_nohtml', FALSE, $content);
}
}