X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=0.2.1%2Finc%2Fstats_bonus.php;h=f7d664e96345084bf65339a59be741da50f17ecf;hb=f29e62abafcf57b076a02b9fe30e14f93baf12f1;hp=6f63ca7c8c45fe4dac25192986e0f76b960bf4ea;hpb=2408c1599f73859fe4a2938e87bc080b9dcb9cca;p=mailer.git diff --git a/0.2.1/inc/stats_bonus.php b/0.2.1/inc/stats_bonus.php index 6f63ca7c8c..f7d664e963 100644 --- a/0.2.1/inc/stats_bonus.php +++ b/0.2.1/inc/stats_bonus.php @@ -1,84 +1,84 @@ -0 AND bonus_stats='N' -ORDER BY userid", __FILE__, __LINE__); - -if (SQL_NUMROWS($result_bonus) > 0) -{ - // Remember stats bonus in constant - define('__STATS_BONUS', TRANSLATE_COMMA($CONFIG['bonus_stats'])); - - // We found some mail orders... - while(list($id, $uid, $subj, $stamp, $clicks, $url) = SQL_FETCHROW($result_bonus)) - { - // Add points - $result_points = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET bonus_stats=bonus_stats+%s WHERE userid=%d LIMIT 1", - array($CONFIG['bonus_stats'], bigintval($uid)), __FILE__, __LINE__); - - // Prepare array - $content = array( - 'subject' => $subj, - 'timestamp' => MAKE_DATETIME($stamp, "2"), - 'clicks' => $clicks, - 'url' => $url - ); - - // Load email template and send email - $msg = LOAD_EMAIL_TEMPLATE("member_stats_bonus", $content, bigintval($uid)); - SEND_EMAIL($uid, BONUS_MEMBER_STATS_SUBJECT, $msg); - - // Update database - $result_update = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_stats SET bonus_stats='Y' WHERE id=%d LIMIT 1", - array(bigintval($id)), __FILE__, __LINE__); - } - - // Handle bonus points - BONUS_POINTS_HANDLER($CONFIG['bonus_stats']); -} - -// Free memory -SQL_FREERESULT($result_bonus); - -// -?> +0 AND bonus_stats='N' +ORDER BY userid", __FILE__, __LINE__); + +if (SQL_NUMROWS($result_bonus) > 0) +{ + // Remember stats bonus in constant + define('__STATS_BONUS', TRANSLATE_COMMA($CONFIG['bonus_stats'])); + + // We found some mail orders... + while(list($id, $uid, $subj, $stamp, $clicks, $url) = SQL_FETCHROW($result_bonus)) + { + // Add points + $result_points = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET bonus_stats=bonus_stats+%s WHERE userid=%d LIMIT 1", + array($CONFIG['bonus_stats'], bigintval($uid)), __FILE__, __LINE__); + + // Prepare array + $content = array( + 'subject' => $subj, + 'timestamp' => MAKE_DATETIME($stamp, "2"), + 'clicks' => $clicks, + 'url' => $url + ); + + // Load email template and send email + $msg = LOAD_EMAIL_TEMPLATE("member_stats_bonus", $content, bigintval($uid)); + SEND_EMAIL($uid, BONUS_MEMBER_STATS_SUBJECT, $msg); + + // Update database + $result_update = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_stats SET bonus_stats='Y' WHERE id=%d LIMIT 1", + array(bigintval($id)), __FILE__, __LINE__); + } + + // Handle bonus points + BONUS_POINTS_HANDLER($CONFIG['bonus_stats']); +} + +// Free memory +SQL_FREERESULT($result_bonus); + +// +?>