X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=inc%2Freset%2Freset_100_bonus.php;h=265388459af8f4b4c8fb74dc6287709f57655e31;hb=e8ca54fe91872ab95a6ffdc4f1268bf18889021d;hp=b3686d40fc066004e140bb25dbf3cb30afab6a67;hpb=c2e17d983fcbc0c3bd1dd37908d87c678f0367df;p=mailer.git diff --git a/inc/reset/reset_100_bonus.php b/inc/reset/reset_100_bonus.php index b3686d40fc..265388459a 100644 --- a/inc/reset/reset_100_bonus.php +++ b/inc/reset/reset_100_bonus.php @@ -1,7 +1,7 @@ "); +// Debug line +//* DEBUG: */ logDebugMessage(__FILE__, __LINE__, 'Daily reset started.'); // Check for 100% klickrate mails $result_bonus = SQL_QUERY("SELECT @@ -53,16 +55,15 @@ $result_bonus = SQL_QUERY("SELECT FROM `{?_MYSQL_PREFIX?}_user_stats` WHERE - `max_rec`=`clicks` AND `clicks` > 0 AND `bonus_stats_active`='N' + `max_rec`=`clicks` AND + `clicks` > 0 AND + `bonus_stats_active`='N' ORDER BY `userid` ASC", __FILE__, __LINE__); -if (SQL_NUMROWS($result_bonus) > 0) { - // Remember stats bonus in constant - $content['points'] = translateComma(getConfig('bonus_stats')); - +if (!SQL_HASZERONUMS($result_bonus)) { // We found some mail orders... - while ($content = merge_array($content, SQL_FETCHARRAY($result_bonus))) { + while ($content = SQL_FETCHARRAY($result_bonus)) { // Add points SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `bonus_stats`=`bonus_stats`+{?bonus_stats?} WHERE `userid`=%s LIMIT 1", array(bigintval($content['userid'])), __FILE__, __LINE__); @@ -72,7 +73,7 @@ if (SQL_NUMROWS($result_bonus) > 0) { // Load email template and send email $message = loadEmailTemplate('member_stats_bonus', $content, bigintval($content['userid'])); - sendEmail($content['userid'], getMessage('BONUS_MEMBER_STATS_SUBJECT'), $message); + sendEmail($content['userid'], '{--MEMBER_BONUS_STATS_SUBJECT--}', $message); // Update database $result_update = SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_stats` SET `bonus_stats_active`='Y' WHERE `id`=%s LIMIT 1", @@ -86,5 +87,8 @@ if (SQL_NUMROWS($result_bonus) > 0) { // Free memory SQL_FREERESULT($result_bonus); +// Debug line +//* DEBUG: */ logDebugMessage(__FILE__, __LINE__, 'Daily reset ended.'); + // [EOF] ?>