X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Freset%2Freset_birthday.php;h=e793ee1ab5b2625779e9349cf390a92dfbdabb57;hp=d8d2185b8808f60b98185fd8904d567f74eaea03;hb=d0db163274524c1ac548146db60d4543abcec4a9;hpb=9afd6ec5878544a7982c50ed9c0dd7de37606d5b diff --git a/inc/reset/reset_birthday.php b/inc/reset/reset_birthday.php index d8d2185b88..e793ee1ab5 100644 --- a/inc/reset/reset_birthday.php +++ b/inc/reset/reset_birthday.php @@ -1,7 +1,7 @@ 0) { if (getConfig('birthday_points') > 0) { // Add more entries to the array $content['age'] = $age; - $content['points'] = translateComma(getConfig('birthday_points')); $content['check'] = ''; // @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))); + $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__); + SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_user_birthday` (`userid`, `points`, `chk_value`) VALUES (%s,{?birthday_points?},'%s' )", + array( + bigintval($content['userid']), + $content['check'] + ), __FILE__, __LINE__); // Load email template with confirmation link $message = loadEmailTemplate('member_birthday_confirm', $content, bigintval($content['userid'])); @@ -106,7 +109,7 @@ if (SQL_NUMROWS($result_birthday) > 0) { } // Send email - sendEmail($content['email'], getMessage('HAPPY_BIRTHDAY'), $message); + sendEmail($content['email'], getMessage('HAPPY_BIRTHDAY_SUBJECT'), $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", @@ -114,7 +117,7 @@ if (SQL_NUMROWS($result_birthday) > 0) { } // END - while // Free memory - SQL_FREERESULT($result); + SQL_FREERESULT($result_birthday); } // [EOF]