[Релиз] Дни Рождения

 unset($query);

$forum_db->query_build($query) or error(__FILE__, __LINE__);

<!--
=================================================
    Start Email Hooks
=================================================
-->
        <hook id="co_common"><![CDATA[
            if($forum_config['o_birthday_email'] != '0')
            {
                $bdays = array();
                $now = getdate(time() + (($forum_user['timezone'] + $forum_user['dst']) * 3600));
                $query = array(
                    'SELECT'    => 'id, username, email, birthday, bday_email, language',
                    'FROM'        => 'users',
                    'WHERE'        => 'bday_email != \''.date('y').'\' AND birthday LIKE \'%-'.$now['mon'].'-'.$now['mday'].'\'',
                );
                $result = $forum_db->query_build($query) or error(__FILE__, __LINE__);

                if ($forum_db->num_rows($result))
                {
                    if (!defined('FORUM_EMAIL_FUNCTIONS_LOADED'))
                        require FORUM_ROOT.'include/email.php';

                    // loop though the users and send emails
                    while($cur_birthday = $forum_db->fetch_assoc($result))
                    {
                        if (file_exists($ext_info['path'].'/lang/'.$cur_birthday['language'].'.tpl'))
                        {
                            // Load the template
                            $mail_tpl = forum_trim(file_get_contents($ext_info['path'].'/lang/'.$cur_birthday['language'].'.tpl'));

                            // The first row contains the subject (it also starts with "Subject:")
                            $first_crlf = strpos($mail_tpl, "\n");
                            $mail_subject = forum_trim(substr($mail_tpl, 8, $first_crlf-8));
                            $mail_message = forum_trim(substr($mail_tpl, $first_crlf));

                            list($year) = explode('-', $cur_birthday['birthday']);
                            $mail_message = str_replace('<age>', (($year !=0)?date('Y')-$year:''), $mail_message);

                            $mail_message = str_replace('<username>', $cur_birthday['username'], $mail_message);
                            $mail_message = str_replace('<board_title>', $forum_config['o_board_title'], $mail_message);
                            $mail_message = str_replace('<board_mailer>', sprintf($lang_common['Forum mailer'], $forum_config['o_board_title']), $mail_message);

                            forum_mail($cur_birthday['email'], $mail_subject, $mail_message);

                            // set the user's last bday_email sent time
                            $query = array(
                                'UPDATE'    => 'users',
                                'SET'        => 'bday_email='.date('y'),
                                'WHERE'        => 'id='.$cur_birthday['id'],
                            );

                            $forum_db->query_build($query) or error(__FILE__, __LINE__);

                            $mail_subject = $mail_message = $year = null;
                        }
                    }
                }
            }
        ]]></hook>