// Sent bonus mails
//
if (GET_EXT_VERSION("bonus") >= "0.1.8") {
- $result = SQL_QUERY("SELECT id FROM "._MYSQL_PREFIX."_bonus WHERE data_type='SEND'", __FILE__, __LINE__);
+ $result = SQL_QUERY("SELECT id FROM "._MYSQL_PREFIX."_bonus WHERE data_type='SEND' AND is_notify='N'", __FILE__, __LINE__);
$value = SQL_NUMROWS($result);
SQL_FREERESULT($result);
$EXCLUDE_LIST = " AND d.userid != ".$_CONFIG['def_refid']."";
// Check for more extensions
- if (EXT_IS_ACTIVE("beg")) $EXCLUDE_LIST .= " AND d.userid != c.beg_uid";
- if (EXT_IS_ACTIVE("bonus")) $EXCLUDE_LIST .= " AND d.userid != c.bonus_uid";
- if (EXT_IS_ACTIVE("doubler")) $EXCLUDE_LIST .= " AND d.userid != c.doubler_uid";
+ if (EXT_IS_ACTIVE("beg")) $EXCLUDE_LIST .= " AND d.userid != ".$_CONFIG['beg_uid']."";
+ if (EXT_IS_ACTIVE("bonus")) $EXCLUDE_LIST .= " AND d.userid != ".$_CONFIG['bonus_uid']."";
+ if (EXT_IS_ACTIVE("doubler")) $EXCLUDE_LIST .= " AND d.userid != ".$_CONFIG['doubler_uid']."";
if (GET_EXT_VERSION("holiday") >= "0.1.3") $EXCLUDE_LIST .= " AND d.holiday_active='N'";
// Check for all accounts
$LAST = sprintf(" AND last_online >= (UNIX_TIMESTAMP() - %s)", $_CONFIG['ap_inactive_since']);
}
- $SQLs[] = "SELECT ".$USE." AS active_bonus FROM "._MYSQL_PREFIX."_user_data
+ $SQLs[] = "SELECT ".$USE." AS active_bonus
+FROM "._MYSQL_PREFIX."_user_data
WHERE status='CONFIRMED' AND ".$USE.">0".$LAST."
ORDER BY active_bonus DESC, userid";
$WHATs[] = "list_bonus";
$DESCRs[] = TASK_ADMIN_LIST_BONUS;
$TITLEs[] = TASK_ADMIN_LIST_BONUS_TITLE;
+
+ if (GET_EXT_VERSION("bonus") >= "0.8.7") {
+ // List all notifications
+ $SQLs[] = "SELECT id FROM "._MYSQL_PREFIX."_bonus WHERE is_notify='Y' ORDER BY timestamp DESC";
+ $WHATs[] = "list_notifications";
+ $DESCRs[] = TASK_ADMIN_LIST_NOTIFICATIONS;
+ $TITLEs[] = TASK_ADMIN_LIST_NOTIFICATIONS_TITLE;
+ }
}
if (GET_EXT_VERSION("beg") >= "0.1.2") {