All database names are now 'back-ticked' and constant _MYSQL_PREFIX is wrapped. Partl...

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

diff --git a/inc/mails/bonus_mails.php b/inc/mails/bonus_mails.php
index ee2e1b7b578d5b393eb7cf62db5361d69ca83ee7..e565d624e502a451807e199a1a2b6de55841fa83 100644 (file)
--- a/inc/mails/bonus_mails.php
+++ b/inc/mails/bonus_mails.php
@@ -44,15 +44,15 @@ global $CSS;
 if ($CSS == 1) return;
 
 // Create timemark from saved month
-$mark = mktime(0, 0, 0, $_CONFIG['last_month'], date("d", time()), date('Y', time()));
+$mark = mktime(0, 0, 0, getConfig('last_month'), date("d", time()), date('Y', time()));
 $SQL = ""; $MODE = "";
 
 // Shall I sent activation or deactivation mail?
-$SQL = "SELECT userid, email FROM "._MYSQL_PREFIX."_user_data WHERE (bonus_ral_notify ";
-switch ($_CONFIG['bonus_active'])
+$SQL = "SELECT userid, email FROM `{!MYSQL_PREFIX!}_user_data` WHERE (bonus_ral_notify ";
+switch (getConfig('bonus_active'))
 {
-case 'Y': // Active rallye is activated
-       if ($_CONFIG['bonus_en_notify'] == "Y") {
+case "Y": // Active rallye is activated
+       if (getConfig('bonus_en_notify') == "Y") {
                // Okay, let's check for member accounts
                $SQL .= "= 0 OR (bonus_ral_notify > 0 AND bonus_ral_en_notify < bonus_ral_di_notify)";
                $MODE = "en";
@@ -62,8 +62,8 @@ case 'Y': // Active rallye is activated
        }
        break;
 
-case 'N': // Active rallye is deactivated
-       if ($_CONFIG['bonus_di_notify'] == "Y") {
+case "N": // Active rallye is deactivated
+       if (getConfig('bonus_di_notify') == "Y") {
                // Okay, let's check for member accounts
                $SQL .= " > 0 AND bonus_ral_di_notify < bonus_ral_en_notify";
                $MODE = "di";
@@ -79,7 +79,7 @@ if (!empty($SQL)) {
        $SQL .= ") AND status='CONFIRMED' ORDER BY last_online ASC";
 
        // Normal notification mails or bonus mails?
-       $MAIL_MODE = (($_CONFIG['bonus_notify_points'] > 0) && ($MODE == "en") && (EXT_IS_ACTIVE("bonus")));
+       $MAIL_MODE = ((getConfig('bonus_notify_points') > 0) && ($MODE == "en") && (EXT_IS_ACTIVE("bonus")));
 
        // Generate subject line
        $SUBJECT = constant('BONUS_RALLYE_'.strtoupper($MODE).'_NOTIFY');
@@ -94,9 +94,11 @@ if (!empty($SQL)) {
                // Okay lets notify all users!
                while(list($uid, $email) = SQL_FETCHROW($result_main)) {
                        // Update account
-                       $result_update = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data
-SET bonus_ral_notify='%s', bonus_ral_%s_notify='%s' WHERE userid=%s LIMIT 1",
- array(time(), $MODE, time(), $uid), __FILE__, __LINE__);
+                       SQL_QUERY_ESC("UPDATE `{!MYSQL_PREFIX!}_user_data`
+SET bonus_ral_notify='%s', bonus_ral_%s_notify='%s'
+WHERE userid=%s
+LIMIT 1",
+                               array(time(), $MODE, time(), $uid), __FILE__, __LINE__);
 
                        // Load email template and send it to the user!
                        if ($MAIL_MODE) {
@@ -115,10 +117,10 @@ SET bonus_ral_notify='%s', bonus_ral_%s_notify='%s' WHERE userid=%s LIMIT 1",
                        $RECEIVER = implode(";", $UIDs);
 
                        // Prepare URL
-                       $url = URL."/modules.php?module=index&what=login";
+                       $URL = "modules.php?module=index&amp;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));
+                       ADD_BONUS_MAIL_TO_QUEUE($SUBJECT, $MSG, $RECEIVER, getConfig('bonus_notify_points'), getConfig('bonus_notify_wait'), $URL, 0, "normal", SQL_NUMROWS($result_main));
                } // END - if
        } // END - if