// 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
// 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);