X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmails%2Fbirthday_mails.php;h=f551ef47b7591c74e7b59193e56a1fa6505a87ab;hb=6c6f24bd5a3817573d1d49ed114700914ae8c920;hp=2c3f047dbb4b388d97ec062c3ba603cefc9f718c;hpb=75ad748a68473ace540251427a74fb781b1145e9;p=mailer.git diff --git a/inc/mails/birthday_mails.php b/inc/mails/birthday_mails.php index 2c3f047dbb..f551ef47b7 100644 --- a/inc/mails/birthday_mails.php +++ b/inc/mails/birthday_mails.php @@ -1,120 +1,3 @@ 0) && ($CONFIG['ap_inactive'] == "Y")) -{ - $ADD = " AND last_online >= %d"; - $VALUE = bigintval(time() - $CONFIG['ap_in_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=%d AND birth_month=%d AND birthday_sent < ".(time() - (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 (list($uid, $email, $byear) = SQL_FETCHROW($result_birthday)) - { - // Calculate own timestamp for birthday and today - $BD = $byear + 12*$MONTH + 365*$DAY; - $NOW = $YEAR + 12*$MONTH + 365*$DAY; - - // Simply subtract both values and you got the age... :) - $AGE = $NOW - $BD; - - if ($CONFIG['birthday_points'] > 0) - { - // Prepare array for loading template - $content = array( - 'age' => $AGE, - 'points' => $CONFIG['birthday_points'], - 'check' => "", - ); - for ($idx = 0; $idx < 4; $idx++) - { - $content['check'] .= GEN_RANDOM_CODE("8", rand(0, "$MONTH$DAY"), $uid, ($AGE*($idx+1))); - } - - // Insert row into database - $result_insert = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_user_birthday (userid, points, chk_value) VALUES ('%s', '%s', '%s' )", - array(bigintval($uid), $CONFIG['birthday_points'], $content['check']), __FILE__, __LINE__); - - // Load email template with confirmation link - $msg = LOAD_EMAIL_TEMPLATE("member_birthday_confirm", $content, bigintval($uid)); - } - else - { - // Load default email template and fill in the age - $msg = LOAD_EMAIL_TEMPLATE("member_birthday", $AGE, $uid); - } - - // Send email - SEND_EMAIL($email, HAPPY_BIRTHDAY, $msg); - - // Remember him that he has received a birthday mail - $result_bd = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET birthday_sent=UNIX_TIMESTAMP() WHERE userid=%d LIMIT 1", - array(bigintval($uid)), __FILE__, __LINE__); - } - - // Free memory - SQL_FREERESULT($result); -} - -// +// @DEPRECATED ?>