X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmails%2Fbirthday_mails.php;h=04e0499a75953c208ebffa31dc970c022ea74a5c;hp=a1e81587ab33713651ce1d8092c4e8fcc87f253f;hb=b8aa17b98b99c27eafbdca0fa090bae63527da9a;hpb=61dec4b03dbfb49cbbeb19628d966c6e34f3b59a

diff --git a/inc/mails/birthday_mails.php b/inc/mails/birthday_mails.php
index a1e81587ab..04e0499a75 100644
--- 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)));
-			}
+			} // END - for
 
 			// 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
-			$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
-			$msg = LOAD_EMAIL_TEMPLATE("member_birthday", $age, $content['userid']);
+			$message = LOAD_EMAIL_TEMPLATE('member_birthday', $age, $content['userid']);
 		}
 
 		// 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
-		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