Huge rewrite:

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

diff --git a/inc/mails/birthday_mails.php b/inc/mails/birthday_mails.php
index a1e81587ab33713651ce1d8092c4e8fcc87f253f..04e0499a75953c208ebffa31dc970c022ea74a5c 100644 (file)
--- a/inc/mails/birthday_mails.php
+++ b/inc/mails/birthday_mails.php
@@ -85,25 +85,25 @@ if (SQL_NUMROWS($result_birthday) > 0) {
                        // @TODO 4 is hard-coded here, should we move it out in config?
                        for ($idx = 0; $idx < 4; $idx++) {
                                $content['check'] .= generateRandomCode("8", mt_rand(0, $month.$day), $content['userid'], ($age * ($idx + 1)));
                        // @TODO 4 is hard-coded here, should we move it out in config?
                        for ($idx = 0; $idx < 4; $idx++) {
                                $content['check'] .= generateRandomCode("8", mt_rand(0, $month.$day), $content['userid'], ($age * ($idx + 1)));

-                       }
+                       } // END - for

 
                        // Insert row into database
                        SQL_QUERY_ESC("INSERT INTO `{!_MYSQL_PREFIX!}_user_birthday` (userid, points, chk_value) VALUES ('%s','%s','%s' )",
 
                        // Insert row into database
                        SQL_QUERY_ESC("INSERT INTO `{!_MYSQL_PREFIX!}_user_birthday` (userid, points, chk_value) VALUES ('%s','%s','%s' )",

-                       array(bigintval($content['userid']), getConfig('birthday_points'), $content['check']), __FILE__, __LINE__);
+                               array(bigintval($content['userid']), getConfig('birthday_points'), $content['check']), __FILE__, __LINE__);

 
                        // Load email template with confirmation link
 
                        // Load email template with confirmation link

-                       $msg = LOAD_EMAIL_TEMPLATE("member_birthday_confirm", $content, bigintval($content['userid']));
+                       $message = LOAD_EMAIL_TEMPLATE('member_birthday_confirm', $content, bigintval($content['userid']));

                } else {
                        // Load default email template and fill in the age
                } else {
                        // Load default email template and fill in the age

-                       $msg = LOAD_EMAIL_TEMPLATE("member_birthday", $age, $content['userid']);
+                       $message = LOAD_EMAIL_TEMPLATE('member_birthday', $age, $content['userid']);

                }
 
                // Send email
                }
 
                // Send email

-               sendEmail($content['email'], getMessage('HAPPY_BIRTHDAY'), $msg);
+               sendEmail($content['email'], getMessage('HAPPY_BIRTHDAY'), $message);

 
                // Remember him that he has received a birthday mail
 
                // Remember him that he has received a birthday mail

-               SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET birthday_sent=UNIX_TIMESTAMP() WHERE userid=%s LIMIT 1",
-               array(bigintval($content['userid'])), __FILE__, __LINE__);
+               SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET `birthday_sent`=UNIX_TIMESTAMP() WHERE `userid`=%s LIMIT 1",
+                       array(bigintval($content['userid'])), __FILE__, __LINE__);

        } // END - while
 
        // Free memory
        } // END - while
 
        // Free memory