[Summary view] [Print] [Text view]

   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&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'] && $auth->acl_gets('u_viewprofile', 'a_user', 'a_useradd', 'a_userdel'))
  85  {
  86      $now = phpbb_gmgetdate(time() + $user->timezone + $user->dst);
  87  
  88      // Display birthdays of 29th february on 28th february in non-leap-years
  89      $leap_year_birthdays = '';
  90      if ($now['mday'] == 28 && $now['mon'] == 2 && !$user->format_date(time(), 'L'))
  91      {
  92          $leap_year_birthdays = " OR u.user_birthday LIKE '" . $db->sql_escape(sprintf('%2d-%2d-', 29, 2)) . "%'";
  93      }
  94  
  95      $sql = 'SELECT u.user_id, u.username, u.user_colour, u.user_birthday
  96          FROM ' . USERS_TABLE . ' u
  97          LEFT JOIN ' . BANLIST_TABLE . " b ON (u.user_id = b.ban_userid)
  98          WHERE (b.ban_id IS NULL
  99              OR b.ban_exclude = 1)
 100              AND (u.user_birthday LIKE '" . $db->sql_escape(sprintf('%2d-%2d-', $now['mday'], $now['mon'])) . "%' $leap_year_birthdays)
 101              AND u.user_type IN (" . USER_NORMAL . ', ' . USER_FOUNDER . ')';
 102      $result = $db->sql_query($sql);
 103  
 104      while ($row = $db->sql_fetchrow($result))
 105      {
 106          $birthday_list .= (($birthday_list != '') ? ', ' : '') . get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']);
 107  
 108          if ($age = (int) substr($row['user_birthday'], -4))
 109          {
 110              $birthday_list .= ' (' . max(0, $now['year'] - $age) . ')';
 111          }
 112      }
 113      $db->sql_freeresult($result);
 114  }
 115  
 116  // Assign index specific vars
 117  $template->assign_vars(array(
 118      'TOTAL_POSTS'    => sprintf($user->lang[$l_total_post_s], $total_posts),
 119      'TOTAL_TOPICS'    => sprintf($user->lang[$l_total_topic_s], $total_topics),
 120      'TOTAL_USERS'    => sprintf($user->lang[$l_total_user_s], $total_users),
 121      'NEWEST_USER'    => sprintf($user->lang['NEWEST_USER'], get_username_string('full', $config['newest_user_id'], $config['newest_username'], $config['newest_user_colour'])),
 122  
 123      'LEGEND'        => $legend,
 124      'BIRTHDAY_LIST'    => $birthday_list,
 125  
 126      'FORUM_IMG'                => $user->img('forum_read', 'NO_UNREAD_POSTS'),
 127      'FORUM_UNREAD_IMG'            => $user->img('forum_unread', 'UNREAD_POSTS'),
 128      'FORUM_LOCKED_IMG'        => $user->img('forum_read_locked', 'NO_UNREAD_POSTS_LOCKED'),
 129      'FORUM_UNREAD_LOCKED_IMG'    => $user->img('forum_unread_locked', 'UNREAD_POSTS_LOCKED'),
 130  
 131      'S_LOGIN_ACTION'            => append_sid("{$phpbb_root_path}ucp.$phpEx", 'mode=login'),
 132      'S_DISPLAY_BIRTHDAY_LIST'    => ($config['load_birthdays']) ? true : false,
 133  
 134      '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') : '',
 135      '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) : '')
 136  );
 137  
 138  // Output page
 139  page_header($user->lang['INDEX']);
 140  
 141  $template->set_filenames(array(
 142      'body' => 'index_body.html')
 143  );
 144  
 145  page_footer();
 146  
 147  ?>