// Bonus mails sent by you
$SQL2 = "SELECT
`id`, `subject`, `text`, `receivers`, `points`, `time`, `data_type`, `timestamp`, `url`, `cat_id`, `target_send`,
- `mails_sent`, `clicks`, (`mails_sent` - `clicks) AS `unconfirmed`
+ `mails_sent`, `clicks`, (`mails_sent` - `clicks`) AS `unconfirmed`
FROM
`{?_MYSQL_PREFIX?}_bonus`
WHERE
$result_max = SQL_QUERY($SQL2, __FILE__, __LINE__);
} else {
// Bonus extension required!
- loadTemplate('admin_settings_saved', false, getMaskedMessage('ADMIN_EXTENSION_PROBLEM_EXTENSION_NOT_INSTALLED', 'bonus'));
+ loadTemplate('admin_settings_saved', false, generateExtensionInactiveNotInstalledMessage('bonus'));
}
// Create limitation line
// Add limitation
if (!empty($SQL2)) $SQL2 .= $add;
-if ((isExtensionActive('bonus')) && (SQL_NUMROWS($result_max) > 0) && (!empty($SQL2))) {
+if ((isExtensionActive('bonus')) && (!SQL_HASZERONUMS($result_max)) && (!empty($SQL2))) {
// Run SQL query for notification mails
$result_bonus = SQL_QUERY($SQL2, __FILE__, __LINE__);
// Load bonus mails only when extension is active
- if (SQL_NUMROWS($result_bonus) > 0) {
+ if (!SQL_HASZERONUMS($result_bonus)) {
// Calculate pages
$numPages = round(SQL_NUMROWS($result_bonus) / getConfig('mails_page') + 0.5);
}
} elseif ((SQL_NUMROWS($result_max) === 0) && (is_resource($result_max))) {
// No notifications found
- loadTemplate('admin_settings_saved', false, getMessage('ADMIN_NO_NOTIFICATIONS'));
+ loadTemplate('admin_settings_saved', false, '{--ADMIN_NO_NOTIFICATIONS--}');
}
// [EOF]