Fix for ZIP code

[mailer.git] / inc / mails / bonus_mails.php

diff --git a/inc/mails/bonus_mails.php b/inc/mails/bonus_mails.php
index ad84a3454d4148e672fb94478778ba1391027227..ee2e1b7b578d5b393eb7cf62db5361d69ca83ee7 100644 (file)
--- a/inc/mails/bonus_mails.php
+++ b/inc/mails/bonus_mails.php
@@ -82,8 +82,7 @@ if (!empty($SQL)) {
        $MAIL_MODE = (($_CONFIG['bonus_notify_points'] > 0) && ($MODE == "en") && (EXT_IS_ACTIVE("bonus")));
 
        // Generate subject line
-       $eval = "\$SUBJECT = BONUS_RALLYE_".strtoupper($MODE)."_NOTIFY;";
-       eval($eval);
+       $SUBJECT = constant('BONUS_RALLYE_'.strtoupper($MODE).'_NOTIFY');
 
        // Load message body for bonus mails
        $MSG = LOAD_EMAIL_TEMPLATE("bonus_en_notify_body", "", "{PER}uid{PER}");
@@ -108,32 +107,24 @@ SET bonus_ral_notify='%s', bonus_ral_%s_notify='%s' WHERE userid=%s LIMIT 1",
                                $MSG = LOAD_EMAIL_TEMPLATE("bonus_".$MODE."_notify", array(), $uid);
                                SEND_EMAIL($uid, $SUBJECT, $MSG);
                        }
-               }
+               } // END - while
 
                // Shall I send out bonus mails?
                if ($MAIL_MODE) {
                        // Okay, make array to string
                        $RECEIVER = implode(";", $UIDs);
-                       $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_bonus
-(subject, text, receivers, points, time, data_type, timestamp, url, cat_id, target_send, mails_sent, is_notify)
-VALUES ('%s','%s','%s','%s','%s','NEW', UNIX_TIMESTAMP(), '%s','%s','%s','%s','Y')",
- array(
-       $SUBJECT,
-       $MSG,
-       $RECEIVER,
-       $_CONFIG['bonus_notify_points'],
-       $_CONFIG['bonus_notify_wait'],
-       URL."/modules.php?module=index&what=login",
-       0,
-       SELECTION_COUNT(explode(";", $RECEIVER)),
-       SQL_NUMROWS($result_main),
-), __FILE__, __LINE__);
-               }
-       }
+
+                       // Prepare URL
+                       $url = URL."/modules.php?module=index&what=login";
+
+                       // Insert mail
+                       ADD_BONUS_MAIL_TO_QUEUE($SUBJECT, $MSG, $RECEIVER, $_CONFIG['bonus_notify_points'], $_CONFIG['bonus_notify_wait'], $url, 0, "normal", SQL_NUMROWS($result_main));
+               } // END - if
+       } // END - if
 
        // Free memory
        SQL_FREERESULT($result_main);
-}
+} // END - if
 
 //
 ?>