source: trunk/forum/index.php @ 1596

Revision 1596, 4.9 KB checked in by Gongwei.Yu, 2 years ago (diff)
Line 
1<?php
2/**
3*
4* @package phpBB3
5* @version $Id: index.php 8987 2008-10-09 14:17:02Z acydburn $
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*/
17define('IN_PHPBB', true);
18$phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './';
19$phpEx = substr(strrchr(__FILE__, '.'), 1);
20include($phpbb_root_path . 'common.' . $phpEx);
21include($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
28display_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
40if ($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}
47else
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();
64while ($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                // www.phpBB-SEO.com SEO TOOLKIT BEGIN
76                $phpbb_seo->prepare_url('group', $row['group_name'], $row['group_id']);
77                // www.phpBB-SEO.com SEO TOOLKIT END
78                $legend[] = '<a' . $colour_text . ' href="' . append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=group&amp;g=' . $row['group_id']) . '">' . $group_name . '</a>';
79        }
80}
81$db->sql_freeresult($result);
82
83$legend = implode(', ', $legend);
84
85// Generate birthday list if required ...
86$birthday_list = '';
87if ($config['load_birthdays'] && $config['allow_birthdays'])
88{
89        $now = getdate(time() + $user->timezone + $user->dst - date('Z'));
90        $sql = 'SELECT user_id, username, user_colour, user_birthday
91                FROM ' . USERS_TABLE . "
92                WHERE user_birthday LIKE '" . $db->sql_escape(sprintf('%2d-%2d-', $now['mday'], $now['mon'])) . "%'
93                        AND 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') . '&amp;mark=forums') : '',
127        'U_MCP'                         => ($auth->acl_get('m_') || $auth->acl_getf_global('m_')) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=main&amp;mode=front', true, $user->session_id) : '')
128);
129
130// Output page
131page_header($user->lang['INDEX']);
132
133$template->set_filenames(array(
134        'body' => 'index_body.html')
135);
136
137page_footer();
138
139?>
Note: See TracBrowser for help on using the repository browser.