X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Freset%2Freset_birthday.php;h=e793ee1ab5b2625779e9349cf390a92dfbdabb57;hp=2614f26b4d649fac9bf0e6c6eb6d7d8d26430680;hb=d0db163274524c1ac548146db60d4543abcec4a9;hpb=a7ff568826f2d0472ef4ef24f983b1406311e52f;ds=sidebyside diff --git a/inc/reset/reset_birthday.php b/inc/reset/reset_birthday.php index 2614f26b4d..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))); + 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__); + 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]