1 | <?php
|
---|
2 | /**
|
---|
3 | *
|
---|
4 | * @package phpBB3
|
---|
5 | * @version $Id$
|
---|
6 | * @copyright (c) 2005 phpBB Group
|
---|
7 | * @license http://opensource.org/licenses/gpl-license.php GNU Public License
|
---|
8 | *
|
---|
9 | */
|
---|
10 |
|
---|
11 | /**
|
---|
12 | */
|
---|
13 |
|
---|
14 | /**
|
---|
15 | * @ignore
|
---|
16 | */
|
---|
17 | define('IN_PHPBB', true);
|
---|
18 | $phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './';
|
---|
19 | $phpEx = substr(strrchr(__FILE__, '.'), 1);
|
---|
20 | include($phpbb_root_path . 'common.' . $phpEx);
|
---|
21 | include($phpbb_root_path . 'includes/functions_display.' . $phpEx);
|
---|
22 |
|
---|
23 | // Start session management
|
---|
24 | $user->session_begin();
|
---|
25 | $auth->acl($user->data);
|
---|
26 | $user->setup('viewforum');
|
---|
27 |
|
---|
28 | display_forums('', $config['load_moderators']);
|
---|
29 |
|
---|
30 | // Set some stats, get posts count from forums data if we... hum... retrieve all forums data
|
---|
31 | $total_posts = $config['num_posts'];
|
---|
32 | $total_topics = $config['num_topics'];
|
---|
33 | $total_users = $config['num_users'];
|
---|
34 |
|
---|
35 | $l_total_user_s = ($total_users == 0) ? 'TOTAL_USERS_ZERO' : 'TOTAL_USERS_OTHER';
|
---|
36 | $l_total_post_s = ($total_posts == 0) ? 'TOTAL_POSTS_ZERO' : 'TOTAL_POSTS_OTHER';
|
---|
37 | $l_total_topic_s = ($total_topics == 0) ? 'TOTAL_TOPICS_ZERO' : 'TOTAL_TOPICS_OTHER';
|
---|
38 |
|
---|
39 | // Grab group details for legend display
|
---|
40 | if ($auth->acl_gets('a_group', 'a_groupadd', 'a_groupdel'))
|
---|
41 | {
|
---|
42 | $sql = 'SELECT group_id, group_name, group_colour, group_type
|
---|
43 | FROM ' . GROUPS_TABLE . '
|
---|
44 | WHERE group_legend = 1
|
---|
45 | ORDER BY group_name ASC';
|
---|
46 | }
|
---|
47 | else
|
---|
48 | {
|
---|
49 | $sql = 'SELECT g.group_id, g.group_name, g.group_colour, g.group_type
|
---|
50 | FROM ' . GROUPS_TABLE . ' g
|
---|
51 | LEFT JOIN ' . USER_GROUP_TABLE . ' ug
|
---|
52 | ON (
|
---|
53 | g.group_id = ug.group_id
|
---|
54 | AND ug.user_id = ' . $user->data['user_id'] . '
|
---|
55 | AND ug.user_pending = 0
|
---|
56 | )
|
---|
57 | WHERE g.group_legend = 1
|
---|
58 | AND (g.group_type <> ' . GROUP_HIDDEN . ' OR ug.user_id = ' . $user->data['user_id'] . ')
|
---|
59 | ORDER BY g.group_name ASC';
|
---|
60 | }
|
---|
61 | $result = $db->sql_query($sql);
|
---|
62 |
|
---|
63 | $legend = array();
|
---|
64 | while ($row = $db->sql_fetchrow($result))
|
---|
65 | {
|
---|
66 | $colour_text = ($row['group_colour']) ? ' style="color:#' . $row['group_colour'] . '"' : '';
|
---|
67 | $group_name = ($row['group_type'] == GROUP_SPECIAL) ? $user->lang['G_' . $row['group_name']] : $row['group_name'];
|
---|
68 |
|
---|
69 | if ($row['group_name'] == 'BOTS' || ($user->data['user_id'] != ANONYMOUS && !$auth->acl_get('u_viewprofile')))
|
---|
70 | {
|
---|
71 | $legend[] = '<span' . $colour_text . '>' . $group_name . '</span>';
|
---|
72 | }
|
---|
73 | else
|
---|
74 | {
|
---|
75 | $legend[] = '<a' . $colour_text . ' href="' . append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=group&g=' . $row['group_id']) . '">' . $group_name . '</a>';
|
---|
76 | }
|
---|
77 | }
|
---|
78 | $db->sql_freeresult($result);
|
---|
79 |
|
---|
80 | $legend = implode(', ', $legend);
|
---|
81 |
|
---|
82 | // Generate birthday list if required ...
|
---|
83 | $birthday_list = '';
|
---|
84 | if ($config['load_birthdays'] && $config['allow_birthdays'])
|
---|
85 | {
|
---|
86 | $now = getdate(time() + $user->timezone + $user->dst - date('Z'));
|
---|
87 | $sql = 'SELECT u.user_id, u.username, u.user_colour, u.user_birthday
|
---|
88 | FROM ' . USERS_TABLE . ' u
|
---|
89 | LEFT JOIN ' . BANLIST_TABLE . " b ON (u.user_id = b.ban_userid)
|
---|
90 | WHERE (b.ban_id IS NULL
|
---|
91 | OR b.ban_exclude = 1)
|
---|
92 | AND u.user_birthday LIKE '" . $db->sql_escape(sprintf('%2d-%2d-', $now['mday'], $now['mon'])) . "%'
|
---|
93 | AND u.user_type IN (" . USER_NORMAL . ', ' . USER_FOUNDER . ')';
|
---|
94 | $result = $db->sql_query($sql);
|
---|
95 |
|
---|
96 | while ($row = $db->sql_fetchrow($result))
|
---|
97 | {
|
---|
98 | $birthday_list .= (($birthday_list != '') ? ', ' : '') . get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']);
|
---|
99 |
|
---|
100 | if ($age = (int) substr($row['user_birthday'], -4))
|
---|
101 | {
|
---|
102 | $birthday_list .= ' (' . ($now['year'] - $age) . ')';
|
---|
103 | }
|
---|
104 | }
|
---|
105 | $db->sql_freeresult($result);
|
---|
106 | }
|
---|
107 |
|
---|
108 | // Assign index specific vars
|
---|
109 | $template->assign_vars(array(
|
---|
110 | 'TOTAL_POSTS' => sprintf($user->lang[$l_total_post_s], $total_posts),
|
---|
111 | 'TOTAL_TOPICS' => sprintf($user->lang[$l_total_topic_s], $total_topics),
|
---|
112 | 'TOTAL_USERS' => sprintf($user->lang[$l_total_user_s], $total_users),
|
---|
113 | 'NEWEST_USER' => sprintf($user->lang['NEWEST_USER'], get_username_string('full', $config['newest_user_id'], $config['newest_username'], $config['newest_user_colour'])),
|
---|
114 |
|
---|
115 | 'LEGEND' => $legend,
|
---|
116 | 'BIRTHDAY_LIST' => $birthday_list,
|
---|
117 |
|
---|
118 | 'FORUM_IMG' => $user->img('forum_read', 'NO_NEW_POSTS'),
|
---|
119 | 'FORUM_NEW_IMG' => $user->img('forum_unread', 'NEW_POSTS'),
|
---|
120 | 'FORUM_LOCKED_IMG' => $user->img('forum_read_locked', 'NO_NEW_POSTS_LOCKED'),
|
---|
121 | 'FORUM_NEW_LOCKED_IMG' => $user->img('forum_unread_locked', 'NO_NEW_POSTS_LOCKED'),
|
---|
122 |
|
---|
123 | 'S_LOGIN_ACTION' => append_sid("{$phpbb_root_path}ucp.$phpEx", 'mode=login'),
|
---|
124 | 'S_DISPLAY_BIRTHDAY_LIST' => ($config['load_birthdays']) ? true : false,
|
---|
125 |
|
---|
126 | 'U_MARK_FORUMS' => ($user->data['is_registered'] || $config['load_anon_lastread']) ? append_sid("{$phpbb_root_path}index.$phpEx", 'hash=' . generate_link_hash('global') . '&mark=forums') : '',
|
---|
127 | '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) : '')
|
---|
128 | );
|
---|
129 |
|
---|
130 | // Output page
|
---|
131 | page_header($user->lang['INDEX']);
|
---|
132 |
|
---|
133 | $template->set_filenames(array(
|
---|
134 | 'body' => 'index_body.html')
|
---|
135 | );
|
---|
136 |
|
---|
137 | page_footer();
|
---|
138 |
|
---|
139 | ?>
|
---|