]> git.mxchange.org Git - mailer.git/blobdiff - inc/monthly/monthly_bonus.php
Even more language strings renamed
[mailer.git] / inc / monthly / monthly_bonus.php
index 7ad2c9fdd61472cbbb6c8db1bb136c016908f6c2..0210ff69b6937235db61045d930546db0e8bf4d6 100644 (file)
@@ -79,18 +79,18 @@ if (($curr != getConfig('last_month')) && (getConfig('bonus_ranks') > 0) && (get
        } // END - if
 
        // Run SQL string to check for accounts
-       $result_main = SQL_QUERY("SELECT
+       $result_main = SQL_QUERY('SELECT
        `userid`, `email`, `gender`, `surname`, `family`, (0" . $add . ") AS points
 FROM
        `{?_MYSQL_PREFIX?}_user_data`
-" . $whereStatement1 . "
+' . $whereStatement1 . '
 ORDER BY
        `points` DESC,
        `userid` ASC
-LIMIT {?bonus_ranks?}", __FILE__, __LINE__);
+LIMIT {?bonus_ranks?}', __FILE__, __LINE__);
 
        // Some entries were found?
-       if (SQL_NUMROWS($result_main) > 0) {
+       if (!SQL_HASZERONUMS($result_main)) {
                // Load our winners...
                while ($content = SQL_FETCHARRAY($result_main)) {
                        // Make sure zero points are not mailed
@@ -100,7 +100,7 @@ LIMIT {?bonus_ranks?}", __FILE__, __LINE__);
 
                                // Load email template and email it away
                                $message = loadEmailTemplate('member_bonus', $content, bigintval($content['userid']));
-                               sendEmail($content['email'], '{--BONUS_MONTHLY_ONLINE_BONUS--}', $message);
+                               sendEmail($content['email'], '{--MEMBER_MONTHLY_BONUS_WON_SUBJECT--}', $message);
                        } // END - if
                } // END - while