session_begin();$auth->acl($user->data);$user->setup('viewforum');display_forums('', $config['load_moderators']);// Set some stats, get posts count from forums data if we... hum... retrieve all forums data$total_posts = $config['num_posts'];$total_topics = $config['num_topics'];$total_users = $config['num_users'];$l_total_user_s = ($total_users == 0) ? 'TOTAL_USERS_ZERO' : 'TOTAL_USERS_OTHER';$l_total_post_s = ($total_posts == 0) ? 'TOTAL_POSTS_ZERO' : 'TOTAL_POSTS_OTHER';$l_total_topic_s = ($total_topics == 0) ? 'TOTAL_TOPICS_ZERO' : 'TOTAL_TOPICS_OTHER';// Grab group details for legend displayif ($auth->acl_gets('a_group', 'a_groupadd', 'a_groupdel')){ $sql = 'SELECT group_id, group_name, group_colour, group_typeFROM ' . GROUPS_TABLE . 'WHERE group_legend = 1ORDER BY group_name ASC';}else{ $sql = 'SELECT g.group_id, g.group_name, g.group_colour, g.group_typeFROM ' . GROUPS_TABLE . ' gLEFT JOIN ' . USER_GROUP_TABLE . ' ugON (g.group_id = ug.group_idAND ug.user_id = ' . $user->data['user_id'] . 'AND ug.user_pending = 0)WHERE g.group_legend = 1AND (g.group_type <> ' . GROUP_HIDDEN . ' OR ug.user_id = ' . $user->data['user_id'] . ')ORDER BY g.group_name ASC';}$result = $db->sql_query($sql);$legend = '';while ($row = $db->sql_fetchrow($result)){$colour_text = ($row['group_colour']) ? ' style="color:#' . $row['group_colour'] . '"' : '';if ($row['group_name'] == 'BOTS'){$legend .= (($legend != '') ? ', ' : '') . '' . $user->lang['G_BOTS'] . '';}else{ $legend .= (($legend != '') ? ', ' : '') . '' . (($row['group_type'] == GROUP_SPECIAL) ? $user->lang['G_' . $row['group_name']] : $row['group_name']) . '';}}// Generate birthday list if required ...$birthday_list = '';if ($config['load_birthdays'] && $config['allow_birthdays']){$now = getdate(time() + $user->timezone + $user->dst - date('Z'));$sql = 'SELECT user_id, username, user_colour, user_birthdayFROM ' . USERS_TABLE . "WHERE user_birthday LIKE '" . $db->sql_escape(sprintf('%2d-%2d-', $now['mday'], $now['mon'])) . "%'AND user_type IN (" . USER_NORMAL . ', ' . USER_FOUNDER . ')';$result = $db->sql_query($sql);while ($row = $db->sql_fetchrow($result)){$birthday_list .= (($birthday_list != '') ? ', ' : '') . get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']);if ($age = (int) substr($row['user_birthday'], -4)){$birthday_list .= ' (' . ($now['year'] - $age) . ')';}}$db->sql_freeresult($result);}// Assign index specific vars$template->assign_vars(array('TOTAL_POSTS' => sprintf($user->lang[$l_total_post_s], $total_posts),'TOTAL_TOPICS' => sprintf($user->lang[$l_total_topic_s], $total_topics),'TOTAL_USERS' => sprintf($user->lang[$l_total_user_s], $total_users),'NEWEST_USER' => sprintf($user->lang['NEWEST_USER'], get_username_string('full', $config['newest_user_id'], $config['newest_username'], $config['newest_user_colour'])),'LEGEND' => $legend,'BIRTHDAY_LIST' => $birthday_list,'FORUM_IMG' => $user->img('forum_read', 'NO_NEW_POSTS'),'FORUM_NEW_IMG' => $user->img('forum_unread', 'NEW_POSTS'),'FORUM_LOCKED_IMG' => $user->img('forum_read_locked', 'NO_NEW_POSTS_LOCKED'),'FORUM_NEW_LOCKED_IMG' => $user->img('forum_unread_locked', 'NO_NEW_POSTS_LOCKED'), 'S_LOGIN_ACTION' => append_sid("{$phpbb_root_path}ucp.$phpEx", 'mode=login'),'S_DISPLAY_BIRTHDAY_LIST' => ($config['load_birthdays']) ? true : false,'U_MARK_FORUMS' => ($user->data['is_registered'] || $config['load_anon_lastread']) ? append_sid("{$phpbb_root_path}index.$phpEx", 'mark=forums') : '', 'U_MCP' => ($auth->acl_get('m_') || $auth->acl_getf_global('m_')) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=main&mode=front', true, $user->session_id) : ''));// Output pagepage_header($user->lang['INDEX']);$template->set_filenames(array('body' => 'index_body.html'));page_footer();?>