"); // 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] ?>