phpBB/index.php

   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 if (!defined('PHPBB_ROOT_PATH')) define('PHPBB_ROOT_PATH', './');
  19 if (!defined('PHP_EXT')) define('PHP_EXT', substr(strrchr(__FILE__, '.'), 1));
  20 include(PHPBB_ROOT_PATH . 'common.' . PHP_EXT);
  21 include(PHPBB_ROOT_PATH . 'includes/functions_display.' . PHP_EXT);
  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('memberlist', 'mode=group&amp;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 user_id, username, user_colour, user_birthday
  88                 FROM ' . USERS_TABLE . "
  89                 WHERE user_birthday LIKE '" . $db->sql_escape(sprintf('%2d-%2d-', $now['mday'], $now['mon'])) . "%'
  90                         AND user_type IN (" . USER_NORMAL . ', ' . USER_FOUNDER . ')';
  91         $result = $db->sql_query($sql);
  92
  93         while ($row = $db->sql_fetchrow($result))
  94         {
  95                 $birthday_list .= (($birthday_list != '') ? ', ' : '') . get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']);
  96
  97                 if ($age = (int) substr($row['user_birthday'], -4))
  98                 {
  99                         $birthday_list .= ' (' . ($now['year'] - $age) . ')';
 100                 }
 101         }
 102         $db->sql_freeresult($result);
 103 }
 104
 105 // Assign index specific vars
 106 $template->assign_vars(array(
 107         'TOTAL_POSTS'   => sprintf($user->lang[$l_total_post_s], $total_posts),
 108         'TOTAL_TOPICS'  => sprintf($user->lang[$l_total_topic_s], $total_topics),
 109         'TOTAL_USERS'   => sprintf($user->lang[$l_total_user_s], $total_users),
 110         'NEWEST_USER'   => sprintf($user->lang['NEWEST_USER'], get_username_string('full', $config['newest_user_id'], $config['newest_username'], $config['newest_user_colour'])),
 111
 112         'LEGEND'                => $legend,
 113         'BIRTHDAY_LIST' => $birthday_list,
 114
 115         'FORUM_IMG'                             => $user->img('forum_read', 'NO_NEW_POSTS'),
 116         'FORUM_NEW_IMG'                 => $user->img('forum_unread', 'NEW_POSTS'),
 117         'FORUM_LOCKED_IMG'              => $user->img('forum_read_locked', 'NO_NEW_POSTS_LOCKED'),
 118         'FORUM_NEW_LOCKED_IMG'  => $user->img('forum_unread_locked', 'NO_NEW_POSTS_LOCKED'),
 119
 120         'S_LOGIN_ACTION'                        => append_sid('ucp', 'mode=login'),
 121         'S_DISPLAY_BIRTHDAY_LIST'       => ($config['load_birthdays']) ? true : false,
 122
 123         'U_MARK_FORUMS'         => ($user->data['is_registered'] || $config['load_anon_lastread']) ? append_sid('index', 'hash=' . generate_link_hash('global') . '&amp;mark=forums') : '',
 124         'U_MCP'                         => ($auth->acl_get('m_') || $auth->acl_getf_global('m_')) ? append_sid('mcp', 'i=main&amp;mode=front', true, $user->session_id) : '')
 125 );
 126
 127 // Output page
 128 page_header($user->lang['INDEX']);
 129
 130 $template->set_filenames(array(
 131         'body' => 'index_body.html')
 132 );
 133
 134 page_footer();
 135
 136 ?>