More SQL rewrites, TODO: Put all table and column names in backticks (`)

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

diff --git a/inc/mails/birthday_mails.php b/inc/mails/birthday_mails.php
index c4dab04700104eea6215fbdf820e5e07286858fa..b51e154d79a89395e8136cad0dc3c358df2914f9 100644 (file)
--- a/inc/mails/birthday_mails.php
+++ b/inc/mails/birthday_mails.php
@@ -76,7 +76,7 @@ if (SQL_NUMROWS($result_birthday) > 0) {
                        // Prepare array for loading template
                        $content = array(
                                'age'    => $AGE,
-                               'points' => $_CONFIG['birthday_points'],
+                               'points' => TRANSLATE_COMMA($_CONFIG['birthday_points']),
                                'check'  => "",
                        );
 
@@ -99,7 +99,7 @@ if (SQL_NUMROWS($result_birthday) > 0) {
                SEND_EMAIL($uid, HAPPY_BIRTHDAY, $msg);
 
                // Remember him that he has received a birthday mail
-               $result_bd = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET birthday_sent=UNIX_TIMESTAMP() WHERE userid=%s LIMIT 1",
+               $result_bd = SQL_QUERY_ESC("UPDATE `"._MYSQL_PREFIX."_user_data` SET birthday_sent=UNIX_TIMESTAMP() WHERE userid=%s LIMIT 1",
                 array(bigintval($uid)), __FILE__, __LINE__);
        }