X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fstats_bonus.php;h=754134c60ae468c2c56cc813bd06df24808a80d2;hb=b29dab42eab7c64ca1945eb70fa7713f8898f6ae;hp=fd9e7a3e403a9cea18351bb360162379d7d18b72;hpb=5bdeaf8b452206598b6c6cd4f941145b11a0eccc;p=mailer.git diff --git a/inc/stats_bonus.php b/inc/stats_bonus.php index fd9e7a3e40..754134c60a 100644 --- a/inc/stats_bonus.php +++ b/inc/stats_bonus.php @@ -10,7 +10,12 @@ * -------------------------------------------------------------------- * * Kurzbeschreibung : Nach Mailbestaetigungen mit 100% Klickrate s. * * -------------------------------------------------------------------- * - * * + * $Revision:: $ * + * $Date:: $ * + * $Tag:: 0.2.1-FINAL $ * + * $Author:: $ * + * Needs to be in all Files and every File needs "svn propset * + * svn:keywords Date Revision" (autoprobset!) at least!!!!!! * * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2008 by Roland Haeder * * For more information visit: http://www.mxchange.org * @@ -48,27 +53,22 @@ if (SQL_NUMROWS($result_bonus) > 0) { define('__STATS_BONUS', TRANSLATE_COMMA(getConfig('bonus_stats'))); // We found some mail orders... - while (list($id, $uid, $subj, $stamp, $clicks, $url) = SQL_FETCHROW($result_bonus)) { + while ($content = SQL_FETCHARRAY($result_bonus)) { // Add points SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET bonus_stats=bonus_stats+%s WHERE userid=%s LIMIT 1", - array(getConfig('bonus_stats'), bigintval($uid)), __FILE__, __LINE__); + array(getConfig('bonus_stats'), bigintval($content['userid'])), __FILE__, __LINE__); - // Prepare array - $content = array( - 'subject' => $subj, - 'timestamp' => MAKE_DATETIME($stamp, "2"), - 'clicks' => $clicks, - 'url' => $url - ); + // Translate some data + $content['timestamp'] MAKE_DATETIME($content['timestamp_ordered'], "2"); // Load email template and send email - $msg = LOAD_EMAIL_TEMPLATE("member_stats_bonus", $content, bigintval($uid)); - SEND_EMAIL($uid, BONUS_MEMBER_STATS_SUBJECT, $msg); + $msg = LOAD_EMAIL_TEMPLATE("member_stats_bonus", $content, bigintval($content['userid'])); + SEND_EMAIL($content['userid'], getMessage('BONUS_MEMBER_STATS_SUBJECT'), $msg); // Update database - $result_update = SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_stats` SET bonus_stats_active='Y' WHERE id=%s LIMIT 1", - array(bigintval($id)), __FILE__, __LINE__); - } + $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 BONUS_POINTS_HANDLER(getConfig('bonus_stats'));