X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Freset%2Freset_birthday.php;h=f551ef47b7591c74e7b59193e56a1fa6505a87ab;hb=b4c80165024acf8963971a72e5c3ca970b3e646d;hp=b194ef628f45829cf204e1632717a28b04bf337d;hpb=499c5676104cbdcbf480cdab20a28a14247ac442;p=mailer.git diff --git a/inc/reset/reset_birthday.php b/inc/reset/reset_birthday.php index b194ef628f..f551ef47b7 100644 --- a/inc/reset/reset_birthday.php +++ b/inc/reset/reset_birthday.php @@ -1,127 +1,3 @@ 0)) { - $add = " AND `last_online` >= (UNIX_TIMESTAMP() - {?ap_inactive_since?})"; -} // END - if - -// Only confirmed members shall receive birthday mails... -$result_birthday = SQL_QUERY_ESC("SELECT `userid`, `email`, `birth_year` -FROM - `{?_MYSQL_PREFIX?}_user_data` -WHERE - `status`='CONFIRMED' AND - `birth_day`=%s AND - `birth_month`=%s AND - `birthday_sent` < (UNIX_TIMESTAMP() - ({?ONE_DAY?} * 364)) - ".$add." -ORDER BY - `userid` ASC", - array($day, $month, $value), __FILE__, __LINE__); - -if (!SQL_HASZERONUMS($result_birthday)) { - // Start sending out birthday mails - while ($content = SQL_FETCHARRAY($result_birthday)) { - // Calculate own timestamp for birthday and today - $bd = $content['birth_year'] + 12 * $month + 365 * $day; - $now = $year + 12 * $month + 365 * $day; - - // Simply subtract both values and you got the age... :) - $age = $now - $bd; - - if (getConfig('birthday_points') > 0) { - // Add more entries to the array - $content['age'] = $age; - $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))); - } // END - for - - // Insert row into database - 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'])); - } else { - // Load default email template and fill in the age - $message = loadEmailTemplate('member_birthday', $age, $content['userid']); - } - - // Send email - sendEmail($content['email'], '{--MEMBER_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", - array(bigintval($content['userid'])), __FILE__, __LINE__); - } // END - while - - // Free memory - SQL_FREERESULT($result_birthday); -} // END - if - -// Debug line -//* DEBUG: */ logDebugMessage(__FILE__, __LINE__, 'Daily reset ended.'); - -// [EOF] +// @DEPRECATED ?>