X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=inc%2Fmails%2Fbirthday_mails.php;h=f551ef47b7591c74e7b59193e56a1fa6505a87ab;hb=64c8349613addc3da2242c5cd6b99d64e3fb5f8e;hp=408dec534c89af3122e9ab18311293320da00a99;hpb=4001187f22197f55e5a1f211fc8defcc180f7c32;p=mailer.git diff --git a/inc/mails/birthday_mails.php b/inc/mails/birthday_mails.php index 408dec534c..f551ef47b7 100644 --- a/inc/mails/birthday_mails.php +++ b/inc/mails/birthday_mails.php @@ -1,109 +1,3 @@ 0)) { - $ADD = " AND last_online >= (UNIX_TIMESTAP() - %s)"; - $VALUE = getConfig('ap_inactive_since'); -} - -// 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() - ".(getConfig('one_day') * 364).")".$ADD." -ORDER BY userid", - array($DAY, $MONTH, $VALUE), __FILE__, __LINE__); - -if (SQL_NUMROWS($result_birthday) > 0) { - // 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['points'] = TRANSLATE_COMMA(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'] .= generateRandomCodde("8", mt_rand(0, "$MONTH$DAY"), $content['userid'], ($AGE*($idx+1))); - } - - // 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__); - - // Load email template with confirmation link - $msg = 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']); - } - - // Send email - SEND_EMAIL($content['email'], getMessage('HAPPY_BIRTHDAY'), $msg); - - // 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); -} - -// +// @DEPRECATED ?>