X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Freset%2Freset_100_bonus.php;h=f551ef47b7591c74e7b59193e56a1fa6505a87ab;hb=c766804735b089a84bcd16e772f60c81c8a7ba49;hp=6bfb16c447fe07f0c00f1515b00e9ae7195dfa9c;hpb=263a089d8a499e0e26d0af9e7aa7639f88b8ca60;p=mailer.git diff --git a/inc/reset/reset_100_bonus.php b/inc/reset/reset_100_bonus.php index 6bfb16c447..f551ef47b7 100644 --- a/inc/reset/reset_100_bonus.php +++ b/inc/reset/reset_100_bonus.php @@ -1,92 +1,3 @@ "); - -// Check for 100% klickrate mails -$result_bonus = SQL_QUERY("SELECT - `id`, `userid`, `subject`, `timestamp_ordered`, `clicks`, `url` -FROM - `{?_MYSQL_PREFIX?}_user_stats` -WHERE - `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')); - - // We found some mail orders... - while ($content = merge_array($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__); - - // Translate some data - $content['timestamp'] = generateDateTime($content['timestamp_ordered'], 2); - - // Load email template and send email - $message = loadEmailTemplate('member_stats_bonus', $content, bigintval($content['userid'])); - sendEmail($content['userid'], getMessage('BONUS_MEMBER_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", - array(bigintval($content['id'])), __FILE__, __LINE__); - } // END - while - - // Handle bonus points - handleBonusPoints(getConfig('bonus_stats')); -} // END - if - -// Free memory -SQL_FREERESULT($result_bonus); - -// [EOF] +// @DEPRECATED ?>