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 = '';
  64 while ($row = $db->sql_fetchrow($result))
  65 {
  66         $colour_text = ($row['group_colour']) ? ' style="color:#' . $row['group_colour'] . '"' : '';
  67
  68         if ($row['group_name'] == 'BOTS')
  69         {
  70                 $legend .= (($legend != '') ? ', ' : '') . '<span' . $colour_text . '>' . $user->lang['G_BOTS'] . '</span>';
  71         }
  72         else
  73         {
  74                 $legend .= (($legend != '') ? ', ' : '') . '<a' . $colour_text . ' href="' . append_sid('memberlist', 'mode=group&amp;g=' . $row['group_id']) . '">' . (($row['group_type'] == GROUP_SPECIAL) ? $user->lang['G_' . $row['group_name']] : $row['group_name']) . '</a>';
  75         }
  76 }
  77 $db->sql_freeresult($result);
  78
  79 // Generate birthday list if required ...
  80 $birthday_list = '';
  81 if ($config['load_birthdays'] && $config['allow_birthdays'])
  82 {
  83         $now = getdate(time() + $user->timezone + $user->dst - date('Z'));
  84         $sql = 'SELECT user_id, username, user_colour, user_birthday
  85                 FROM ' . USERS_TABLE . "
  86                 WHERE user_birthday LIKE '" . $db->sql_escape(sprintf('%2d-%2d-', $now['mday'], $now['mon'])) . "%'
  87                         AND user_type IN (" . USER_NORMAL . ', ' . USER_FOUNDER . ')';
  88         $result = $db->sql_query($sql);
  89
  90         while ($row = $db->sql_fetchrow($result))
  91         {
  92                 $birthday_list .= (($birthday_list != '') ? ', ' : '') . get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']);
  93
  94                 if ($age = (int) substr($row['user_birthday'], -4))
  95                 {
  96                         $birthday_list .= ' (' . ($now['year'] - $age) . ')';
  97                 }
  98         }
  99         $db->sql_freeresult($result);
 100 }
 101
 102 // Assign index specific vars
 103 $template->assign_vars(array(
 104         'TOTAL_POSTS'   => sprintf($user->lang[$l_total_post_s], $total_posts),
 105         'TOTAL_TOPICS'  => sprintf($user->lang[$l_total_topic_s], $total_topics),
 106         'TOTAL_USERS'   => sprintf($user->lang[$l_total_user_s], $total_users),
 107         'NEWEST_USER'   => sprintf($user->lang['NEWEST_USER'], get_username_string('full', $config['newest_user_id'], $config['newest_username'], $config['newest_user_colour'])),
 108
 109         'LEGEND'                => $legend,
 110         'BIRTHDAY_LIST' => $birthday_list,
 111
 112         'FORUM_IMG'                             => $user->img('forum_read', 'NO_NEW_POSTS'),
 113         'FORUM_NEW_IMG'                 => $user->img('forum_unread', 'NEW_POSTS'),
 114         'FORUM_LOCKED_IMG'              => $user->img('forum_read_locked', 'NO_NEW_POSTS_LOCKED'),
 115         'FORUM_NEW_LOCKED_IMG'  => $user->img('forum_unread_locked', 'NO_NEW_POSTS_LOCKED'),
 116
 117         'S_LOGIN_ACTION'                        => append_sid('ucp', 'mode=login'),
 118         'S_DISPLAY_BIRTHDAY_LIST'       => ($config['load_birthdays']) ? true : false,
 119
 120         'U_MARK_FORUMS'         => ($user->data['is_registered'] || $config['load_anon_lastread']) ? append_sid('index', 'mark=forums') : '',
 121         'U_MCP'                         => ($auth->acl_get('m_') || $auth->acl_getf_global('m_')) ? append_sid('mcp', 'i=main&amp;mode=front', true, $user->session_id) : '')
 122 );
 123
 124 // Output page
 125 page_header($user->lang['INDEX']);
 126
 127 $template->set_filenames(array(
 128         'body' => 'index_body.html')
 129 );
 130
 131 page_footer();
 132
 133 ?>