+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+// Mark notifications read

+if (($mark_notification = $request->variable('mark_notification', 0)))

+{

+ if ($user->data['user_id'] == ANONYMOUS)

+ {

+ if ($request->is_ajax())

+ {

+ trigger_error('LOGIN_REQUIRED');

+ }

+ login_box('', $user->lang['LOGIN_REQUIRED']);

+ }

+

+ if (check_link_hash($request->variable('hash', ''), 'mark_notification_read'))

+ {

+ $phpbb_notifications = $phpbb_container->get('notification_manager');

+

+ $notification = $phpbb_notifications->load_notifications(array(

+ 'notification_id' => $mark_notification,

+ ));

+

+ if (isset($notification['notifications'][$mark_notification]))

+ {

+ $notification = $notification['notifications'][$mark_notification];

+

+ $notification->mark_read();

+

+ if ($request->is_ajax())

+ {

+ $json_response = new \phpbb\json_response();

+ $json_response->send(array(

+ 'success' => true,

+ ));

+ }

+

+ if (($redirect = $request->variable('redirect', '')))

+ {

+ redirect(append_sid($phpbb_root_path . $redirect));

+ }

+ redirect($notification->get_redirect_url());

+ }

+ }

+}

+display_forums('', $config['load_moderators']);

+$order_legend = ($config['legend_sort_groupname']) ? 'group_name' : 'group_legend';

+ $sql = 'SELECT group_id, group_name, group_colour, group_type, group_legend

+ WHERE group_legend > 0

+ ORDER BY ' . $order_legend . ' ASC';

+ $sql = 'SELECT g.group_id, g.group_name, g.group_colour, g.group_type, g.group_legend

+ WHERE g.group_legend > 0

+ ORDER BY g.' . $order_legend . ' ASC';

+$legend = implode($user->lang['COMMA_SEPARATOR'], $legend);

+$birthdays = $birthday_list = array();

+ $time = $user->create_datetime();

+ $now = phpbb_gmgetdate($time->getTimestamp() + $time->getOffset());

+ if ($now['mday'] == 28 && $now['mon'] == 2 && !$time->format('L'))

+ $sql_ary = array(

+ 'SELECT' => 'u.user_id, u.username, u.user_colour, u.user_birthday',

+ 'FROM' => array(

+ USERS_TABLE => 'u',

+ ),

+ 'LEFT_JOIN' => array(

+ array(

+ 'FROM' => array(BANLIST_TABLE => 'b'),

+ 'ON' => 'u.user_id = b.ban_userid',

+ ),

+ ),

+ 'WHERE' => "(b.ban_id IS NULL OR b.ban_exclude = 1)

+ AND u.user_type IN (" . USER_NORMAL . ', ' . USER_FOUNDER . ')',

+ );

+

+ /**

+ * Event to modify the SQL query to get birthdays data

+ *

+ * @event core.index_modify_birthdays_sql

+ * @var array now The assoc array with the 'now' local timestamp data

+ * @var array sql_ary The SQL array to get the birthdays data

+ * @var object time The user related Datetime object

+ * @since 3.1.7-RC1

+ */

+ $vars = array('now', 'sql_ary', 'time');

+ extract($phpbb_dispatcher->trigger_event('core.index_modify_birthdays_sql', compact($vars)));

+

+ $sql = $db->sql_build_query('SELECT', $sql_ary);

+ $rows = $db->sql_fetchrowset($result);

+ $db->sql_freeresult($result);

+ foreach ($rows as $row)

+ $birthday_username = get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']);

+ $birthday_year = (int) substr($row['user_birthday'], -4);

+ $birthday_age = ($birthday_year) ? max(0, $now['year'] - $birthday_year) : '';

+ $birthdays[] = array(

+ 'USERNAME' => $birthday_username,

+ 'AGE' => $birthday_age,

+ );

+

+ // For 3.0 compatibility

+ $birthday_list[] = $birthday_username . (($birthday_age) ? " ({$birthday_age})" : '');

+

+ /**

+ * Event to modify the birthdays list

+ *

+ * @event core.index_modify_birthdays_list

+ * @var array birthdays Array with the users birthdays data

+ * @var array rows Array with the birthdays SQL query result

+ * @since 3.1.7-RC1

+ */

+ $vars = array('birthdays', 'rows');

+ extract($phpbb_dispatcher->trigger_event('core.index_modify_birthdays_list', compact($vars)));

+

+ $template->assign_block_vars_array('birthdays', $birthdays);

+ 'TOTAL_POSTS' => $user->lang('TOTAL_POSTS_COUNT', (int) $config['num_posts']),

+ 'TOTAL_TOPICS' => $user->lang('TOTAL_TOPICS', (int) $config['num_topics']),

+ 'TOTAL_USERS' => $user->lang('TOTAL_USERS', (int) $config['num_users']),

+ 'NEWEST_USER' => $user->lang('NEWEST_USER', get_username_string('full', $config['newest_user_id'], $config['newest_username'], $config['newest_user_colour'])),

+ 'BIRTHDAY_LIST' => (empty($birthday_list)) ? '' : implode($user->lang['COMMA_SEPARATOR'], $birthday_list),

+ 'U_SEND_PASSWORD' => ($config['email_enable']) ? append_sid("{$phpbb_root_path}ucp.$phpEx", 'mode=sendpassword') : '',

+ 'S_INDEX' => true,

+ 'U_MARK_FORUMS' => ($user->data['is_registered'] || $config['load_anon_lastread']) ? append_sid("{$phpbb_root_path}index.$phpEx", 'hash=' . generate_link_hash('global') . '&amp;mark=forums&amp;mark_time=' . time()) : '',

+$page_title = ($config['board_index_text'] !== '') ? $config['board_index_text'] : $user->lang['INDEX'];

+

+/**

+* You can use this event to modify the page title and load data for the index

+*

+* @event core.index_modify_page_title

+* @var string page_title Title of the index page

+* @since 3.1.0-a1

+*/

+$vars = array('page_title');

+extract($phpbb_dispatcher->trigger_event('core.index_modify_page_title', compact($vars)));

+

+page_header($page_title, true);