[ Index ]

PHP Cross Reference of phpBB-3.1.10-deutsch

title

Body

[close]

/includes/ -> functions_display.php (source)

   1  <?php
   2  /**
   3  *
   4  * This file is part of the phpBB Forum Software package.
   5  *
   6  * @copyright (c) phpBB Limited <https://www.phpbb.com>
   7  * @license GNU General Public License, version 2 (GPL-2.0)
   8  *
   9  * For full copyright and license information, please see
  10  * the docs/CREDITS.txt file.
  11  *
  12  */
  13  
  14  /**
  15  * @ignore
  16  */
  17  if (!defined('IN_PHPBB'))
  18  {
  19      exit;
  20  }
  21  
  22  /**
  23  * Display Forums
  24  */
  25  function display_forums($root_data = '', $display_moderators = true, $return_moderators = false)
  26  {
  27      global $db, $auth, $user, $template;
  28      global $phpbb_root_path, $phpEx, $config;
  29      global $request, $phpbb_dispatcher, $phpbb_container;
  30  
  31      $forum_rows = $subforums = $forum_ids = $forum_ids_moderator = $forum_moderators = $active_forum_ary = array();
  32      $parent_id = $visible_forums = 0;
  33      $sql_from = '';
  34  
  35      // Mark forums read?
  36      $mark_read = request_var('mark', '');
  37  
  38      if ($mark_read == 'all')
  39      {
  40          $mark_read = '';
  41      }
  42  
  43      if (!$root_data)
  44      {
  45          if ($mark_read == 'forums')
  46          {
  47              $mark_read = 'all';
  48          }
  49  
  50          $root_data = array('forum_id' => 0);
  51          $sql_where = '';
  52      }
  53      else
  54      {
  55          $sql_where = 'left_id > ' . $root_data['left_id'] . ' AND left_id < ' . $root_data['right_id'];
  56      }
  57  
  58      // Handle marking everything read
  59      if ($mark_read == 'all')
  60      {
  61          $redirect = build_url(array('mark', 'hash', 'mark_time'));
  62          meta_refresh(3, $redirect);
  63  
  64          if (check_link_hash(request_var('hash', ''), 'global'))
  65          {
  66              markread('all', false, false, request_var('mark_time', 0));
  67  
  68              if ($request->is_ajax())
  69              {
  70                  // Tell the ajax script what language vars and URL need to be replaced
  71                  $data = array(
  72                      'NO_UNREAD_POSTS'    => $user->lang['NO_UNREAD_POSTS'],
  73                      'UNREAD_POSTS'        => $user->lang['UNREAD_POSTS'],
  74                      '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&mark_time=' . time()) : '',
  75                      'MESSAGE_TITLE'        => $user->lang['INFORMATION'],
  76                      'MESSAGE_TEXT'        => $user->lang['FORUMS_MARKED']
  77                  );
  78                  $json_response = new \phpbb\json_response();
  79                  $json_response->send($data);
  80              }
  81  
  82              trigger_error(
  83                  $user->lang['FORUMS_MARKED'] . '<br /><br />' .
  84                  sprintf($user->lang['RETURN_INDEX'], '<a href="' . $redirect . '">', '</a>')
  85              );
  86          }
  87          else
  88          {
  89              trigger_error(sprintf($user->lang['RETURN_PAGE'], '<a href="' . $redirect . '">', '</a>'));
  90          }
  91      }
  92  
  93      // Display list of active topics for this category?
  94      $show_active = (isset($root_data['forum_flags']) && ($root_data['forum_flags'] & FORUM_FLAG_ACTIVE_TOPICS)) ? true : false;
  95  
  96      $sql_array = array(
  97          'SELECT'    => 'f.*',
  98          'FROM'        => array(
  99              FORUMS_TABLE        => 'f'
 100          ),
 101          'LEFT_JOIN'    => array(),
 102      );
 103  
 104      if ($config['load_db_lastread'] && $user->data['is_registered'])
 105      {
 106          $sql_array['LEFT_JOIN'][] = array('FROM' => array(FORUMS_TRACK_TABLE => 'ft'), 'ON' => 'ft.user_id = ' . $user->data['user_id'] . ' AND ft.forum_id = f.forum_id');
 107          $sql_array['SELECT'] .= ', ft.mark_time';
 108      }
 109      else if ($config['load_anon_lastread'] || $user->data['is_registered'])
 110      {
 111          $tracking_topics = $request->variable($config['cookie_name'] . '_track', '', true, \phpbb\request\request_interface::COOKIE);
 112          $tracking_topics = ($tracking_topics) ? tracking_unserialize($tracking_topics) : array();
 113  
 114          if (!$user->data['is_registered'])
 115          {
 116              $user->data['user_lastmark'] = (isset($tracking_topics['l'])) ? (int) (base_convert($tracking_topics['l'], 36, 10) + $config['board_startdate']) : 0;
 117          }
 118      }
 119  
 120      if ($show_active)
 121      {
 122          $sql_array['LEFT_JOIN'][] = array(
 123              'FROM'    => array(FORUMS_ACCESS_TABLE => 'fa'),
 124              'ON'    => "fa.forum_id = f.forum_id AND fa.session_id = '" . $db->sql_escape($user->session_id) . "'"
 125          );
 126  
 127          $sql_array['SELECT'] .= ', fa.user_id';
 128      }
 129  
 130      $sql_ary = array(
 131          'SELECT'    => $sql_array['SELECT'],
 132          'FROM'        => $sql_array['FROM'],
 133          'LEFT_JOIN'    => $sql_array['LEFT_JOIN'],
 134  
 135          'WHERE'        => $sql_where,
 136  
 137          'ORDER_BY'    => 'f.left_id',
 138      );
 139  
 140      /**
 141      * Event to modify the SQL query before the forum data is queried
 142      *
 143      * @event core.display_forums_modify_sql
 144      * @var    array    sql_ary        The SQL array to get the data of the forums
 145      * @since 3.1.0-a1
 146      */
 147      $vars = array('sql_ary');
 148      extract($phpbb_dispatcher->trigger_event('core.display_forums_modify_sql', compact($vars)));
 149  
 150      $sql = $db->sql_build_query('SELECT', $sql_ary);
 151      $result = $db->sql_query($sql);
 152  
 153      $forum_tracking_info = $valid_categories = array();
 154      $branch_root_id = $root_data['forum_id'];
 155  
 156      $phpbb_content_visibility = $phpbb_container->get('content.visibility');
 157  
 158      while ($row = $db->sql_fetchrow($result))
 159      {
 160          /**
 161          * Event to modify the data set of a forum
 162          *
 163          * This event is triggered once per forum
 164          *
 165          * @event core.display_forums_modify_row
 166          * @var    int        branch_root_id    Last top-level forum
 167          * @var    array    row                The data of the forum
 168          * @since 3.1.0-a1
 169          */
 170          $vars = array('branch_root_id', 'row');
 171          extract($phpbb_dispatcher->trigger_event('core.display_forums_modify_row', compact($vars)));
 172  
 173          $forum_id = $row['forum_id'];
 174  
 175          // Mark forums read?
 176          if ($mark_read == 'forums')
 177          {
 178              if ($auth->acl_get('f_list', $forum_id))
 179              {
 180                  $forum_ids[] = $forum_id;
 181              }
 182  
 183              continue;
 184          }
 185  
 186          // Category with no members
 187          if ($row['forum_type'] == FORUM_CAT && ($row['left_id'] + 1 == $row['right_id']))
 188          {
 189              continue;
 190          }
 191  
 192          // Skip branch
 193          if (isset($right_id))
 194          {
 195              if ($row['left_id'] < $right_id)
 196              {
 197                  continue;
 198              }
 199              unset($right_id);
 200          }
 201  
 202          if (!$auth->acl_get('f_list', $forum_id))
 203          {
 204              // if the user does not have permissions to list this forum, skip everything until next branch
 205              $right_id = $row['right_id'];
 206              continue;
 207          }
 208  
 209          if ($config['load_db_lastread'] && $user->data['is_registered'])
 210          {
 211              $forum_tracking_info[$forum_id] = (!empty($row['mark_time'])) ? $row['mark_time'] : $user->data['user_lastmark'];
 212          }
 213          else if ($config['load_anon_lastread'] || $user->data['is_registered'])
 214          {
 215              if (!$user->data['is_registered'])
 216              {
 217                  $user->data['user_lastmark'] = (isset($tracking_topics['l'])) ? (int) (base_convert($tracking_topics['l'], 36, 10) + $config['board_startdate']) : 0;
 218              }
 219              $forum_tracking_info[$forum_id] = (isset($tracking_topics['f'][$forum_id])) ? (int) (base_convert($tracking_topics['f'][$forum_id], 36, 10) + $config['board_startdate']) : $user->data['user_lastmark'];
 220          }
 221  
 222          // Lets check whether there are unapproved topics/posts, so we can display an information to moderators
 223          $row['forum_id_unapproved_topics'] = ($auth->acl_get('m_approve', $forum_id) && $row['forum_topics_unapproved']) ? $forum_id : 0;
 224          $row['forum_id_unapproved_posts'] = ($auth->acl_get('m_approve', $forum_id) && $row['forum_posts_unapproved']) ? $forum_id : 0;
 225          $row['forum_posts'] = $phpbb_content_visibility->get_count('forum_posts', $row, $forum_id);
 226          $row['forum_topics'] = $phpbb_content_visibility->get_count('forum_topics', $row, $forum_id);
 227  
 228          // Display active topics from this forum?
 229          if ($show_active && $row['forum_type'] == FORUM_POST && $auth->acl_get('f_read', $forum_id) && ($row['forum_flags'] & FORUM_FLAG_ACTIVE_TOPICS))
 230          {
 231              if (!isset($active_forum_ary['forum_topics']))
 232              {
 233                  $active_forum_ary['forum_topics'] = 0;
 234              }
 235  
 236              if (!isset($active_forum_ary['forum_posts']))
 237              {
 238                  $active_forum_ary['forum_posts'] = 0;
 239              }
 240  
 241              $active_forum_ary['forum_id'][]        = $forum_id;
 242              $active_forum_ary['enable_icons'][]    = $row['enable_icons'];
 243              $active_forum_ary['forum_topics']    += $row['forum_topics'];
 244              $active_forum_ary['forum_posts']    += $row['forum_posts'];
 245  
 246              // If this is a passworded forum we do not show active topics from it if the user is not authorised to view it...
 247              if ($row['forum_password'] && $row['user_id'] != $user->data['user_id'])
 248              {
 249                  $active_forum_ary['exclude_forum_id'][] = $forum_id;
 250              }
 251          }
 252  
 253          // Fill list of categories with forums
 254          if (isset($forum_rows[$row['parent_id']]))
 255          {
 256              $valid_categories[$row['parent_id']] = true;
 257          }
 258  
 259          //
 260          if ($row['parent_id'] == $root_data['forum_id'] || $row['parent_id'] == $branch_root_id)
 261          {
 262              if ($row['forum_type'] != FORUM_CAT)
 263              {
 264                  $forum_ids_moderator[] = (int) $forum_id;
 265              }
 266  
 267              // Direct child of current branch
 268              $parent_id = $forum_id;
 269              $forum_rows[$forum_id] = $row;
 270  
 271              if ($row['forum_type'] == FORUM_CAT && $row['parent_id'] == $root_data['forum_id'])
 272              {
 273                  $branch_root_id = $forum_id;
 274              }
 275              $forum_rows[$parent_id]['forum_id_last_post'] = $row['forum_id'];
 276              $forum_rows[$parent_id]['forum_password_last_post'] = $row['forum_password'];
 277              $forum_rows[$parent_id]['orig_forum_last_post_time'] = $row['forum_last_post_time'];
 278          }
 279          else if ($row['forum_type'] != FORUM_CAT)
 280          {
 281              $subforums[$parent_id][$forum_id]['display'] = ($row['display_on_index']) ? true : false;
 282              $subforums[$parent_id][$forum_id]['name'] = $row['forum_name'];
 283              $subforums[$parent_id][$forum_id]['orig_forum_last_post_time'] = $row['forum_last_post_time'];
 284              $subforums[$parent_id][$forum_id]['children'] = array();
 285  
 286              if (isset($subforums[$parent_id][$row['parent_id']]) && !$row['display_on_index'])
 287              {
 288                  $subforums[$parent_id][$row['parent_id']]['children'][] = $forum_id;
 289              }
 290  
 291              if (!$forum_rows[$parent_id]['forum_id_unapproved_topics'] && $row['forum_id_unapproved_topics'])
 292              {
 293                  $forum_rows[$parent_id]['forum_id_unapproved_topics'] = $forum_id;
 294              }
 295  
 296              if (!$forum_rows[$parent_id]['forum_id_unapproved_posts'] && $row['forum_id_unapproved_posts'])
 297              {
 298                  $forum_rows[$parent_id]['forum_id_unapproved_posts'] = $forum_id;
 299              }
 300  
 301              $forum_rows[$parent_id]['forum_topics'] += $row['forum_topics'];
 302  
 303              // Do not list redirects in LINK Forums as Posts.
 304              if ($row['forum_type'] != FORUM_LINK)
 305              {
 306                  $forum_rows[$parent_id]['forum_posts'] += $row['forum_posts'];
 307              }
 308  
 309              if ($row['forum_last_post_time'] > $forum_rows[$parent_id]['forum_last_post_time'])
 310              {
 311                  $forum_rows[$parent_id]['forum_last_post_id'] = $row['forum_last_post_id'];
 312                  $forum_rows[$parent_id]['forum_last_post_subject'] = $row['forum_last_post_subject'];
 313                  $forum_rows[$parent_id]['forum_last_post_time'] = $row['forum_last_post_time'];
 314                  $forum_rows[$parent_id]['forum_last_poster_id'] = $row['forum_last_poster_id'];
 315                  $forum_rows[$parent_id]['forum_last_poster_name'] = $row['forum_last_poster_name'];
 316                  $forum_rows[$parent_id]['forum_last_poster_colour'] = $row['forum_last_poster_colour'];
 317                  $forum_rows[$parent_id]['forum_id_last_post'] = $forum_id;
 318                  $forum_rows[$parent_id]['forum_password_last_post'] = $row['forum_password'];
 319              }
 320          }
 321  
 322          /**
 323          * Event to modify the forum rows data set
 324          *
 325          * This event is triggered once per forum
 326          *
 327          * @event core.display_forums_modify_forum_rows
 328          * @var    array    forum_rows        Data array of all forums we display
 329          * @var    array    subforums        Data array of all subforums we display
 330          * @var    int        branch_root_id    Current top-level forum
 331          * @var    int        parent_id        Current parent forum
 332          * @var    array    row                The data of the forum
 333          * @since 3.1.0-a1
 334          */
 335          $vars = array('forum_rows', 'subforums', 'branch_root_id', 'parent_id', 'row');
 336          extract($phpbb_dispatcher->trigger_event('core.display_forums_modify_forum_rows', compact($vars)));
 337      }
 338      $db->sql_freeresult($result);
 339  
 340      // Handle marking posts
 341      if ($mark_read == 'forums')
 342      {
 343          $redirect = build_url(array('mark', 'hash', 'mark_time'));
 344          $token = request_var('hash', '');
 345          if (check_link_hash($token, 'global'))
 346          {
 347              markread('topics', $forum_ids, false, request_var('mark_time', 0));
 348              $message = sprintf($user->lang['RETURN_FORUM'], '<a href="' . $redirect . '">', '</a>');
 349              meta_refresh(3, $redirect);
 350  
 351              if ($request->is_ajax())
 352              {
 353                  // Tell the ajax script what language vars and URL need to be replaced
 354                  $data = array(
 355                      'NO_UNREAD_POSTS'    => $user->lang['NO_UNREAD_POSTS'],
 356                      'UNREAD_POSTS'        => $user->lang['UNREAD_POSTS'],
 357                      'U_MARK_FORUMS'        => ($user->data['is_registered'] || $config['load_anon_lastread']) ? append_sid("{$phpbb_root_path}viewforum.$phpEx", 'hash=' . generate_link_hash('global') . '&f=' . $root_data['forum_id'] . '&mark=forums&mark_time=' . time()) : '',
 358                      'MESSAGE_TITLE'        => $user->lang['INFORMATION'],
 359                      'MESSAGE_TEXT'        => $user->lang['FORUMS_MARKED']
 360                  );
 361                  $json_response = new \phpbb\json_response();
 362                  $json_response->send($data);
 363              }
 364  
 365              trigger_error($user->lang['FORUMS_MARKED'] . '<br /><br />' . $message);
 366          }
 367          else
 368          {
 369              $message = sprintf($user->lang['RETURN_PAGE'], '<a href="' . $redirect . '">', '</a>');
 370              meta_refresh(3, $redirect);
 371              trigger_error($message);
 372          }
 373  
 374      }
 375  
 376      // Grab moderators ... if necessary
 377      if ($display_moderators)
 378      {
 379          if ($return_moderators)
 380          {
 381              $forum_ids_moderator[] = $root_data['forum_id'];
 382          }
 383          get_moderators($forum_moderators, $forum_ids_moderator);
 384      }
 385  
 386      /**
 387      * Event to perform additional actions before the forum list is being generated
 388      *
 389      * @event core.display_forums_before
 390      * @var    array    active_forum_ary    Array with forum data to display active topics
 391      * @var    bool    display_moderators    Flag indicating if we display forum moderators
 392      * @var    array    forum_moderators    Array with forum moderators list
 393      * @var    array    forum_rows            Data array of all forums we display
 394      * @var    bool    return_moderators    Flag indicating if moderators list should be returned
 395      * @var    array    root_data            Array with the root forum data
 396      * @since 3.1.4-RC1
 397      */
 398      $vars = array(
 399          'active_forum_ary',
 400          'display_moderators',
 401          'forum_moderators',
 402          'forum_rows',
 403          'return_moderators',
 404          'root_data',
 405      );
 406      extract($phpbb_dispatcher->trigger_event('core.display_forums_before', compact($vars)));
 407  
 408      // Used to tell whatever we have to create a dummy category or not.
 409      $last_catless = true;
 410      foreach ($forum_rows as $row)
 411      {
 412          // Category
 413          if ($row['parent_id'] == $root_data['forum_id'] && $row['forum_type'] == FORUM_CAT)
 414          {
 415              // Do not display categories without any forums to display
 416              if (!isset($valid_categories[$row['forum_id']]))
 417              {
 418                  continue;
 419              }
 420  
 421              $cat_row = array(
 422                  'S_IS_CAT'                => true,
 423                  'FORUM_ID'                => $row['forum_id'],
 424                  'FORUM_NAME'            => $row['forum_name'],
 425                  'FORUM_DESC'            => generate_text_for_display($row['forum_desc'], $row['forum_desc_uid'], $row['forum_desc_bitfield'], $row['forum_desc_options']),
 426                  'FORUM_FOLDER_IMG'        => '',
 427                  'FORUM_FOLDER_IMG_SRC'    => '',
 428                  'FORUM_IMAGE'            => ($row['forum_image']) ? '<img src="' . $phpbb_root_path . $row['forum_image'] . '" alt="' . $user->lang['FORUM_CAT'] . '" />' : '',
 429                  'FORUM_IMAGE_SRC'        => ($row['forum_image']) ? $phpbb_root_path . $row['forum_image'] : '',
 430                  'U_VIEWFORUM'            => append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $row['forum_id']),
 431              );
 432  
 433              /**
 434              * Modify the template data block of the 'category'
 435              *
 436              * This event is triggered once per 'category'
 437              *
 438              * @event core.display_forums_modify_category_template_vars
 439              * @var    array    cat_row            Template data of the 'category'
 440              * @var    bool    catless            The flag indicating whether the 'category' has a parent category
 441              * @var    bool    last_catless    The flag indicating whether the last forum had a parent category
 442              * @var    array    root_data        Array with the root forum data
 443              * @var    array    row                The data of the 'category'
 444              * @since 3.1.0-RC4
 445              */
 446              $vars = array(
 447                  'cat_row',
 448                  'catless',
 449                  'last_catless',
 450                  'root_data',
 451                  'row',
 452              );
 453              extract($phpbb_dispatcher->trigger_event('core.display_forums_modify_category_template_vars', compact($vars)));
 454  
 455              $template->assign_block_vars('forumrow', $cat_row);
 456  
 457              continue;
 458          }
 459  
 460          $visible_forums++;
 461          $forum_id = $row['forum_id'];
 462  
 463          $forum_unread = (isset($forum_tracking_info[$forum_id]) && $row['orig_forum_last_post_time'] > $forum_tracking_info[$forum_id]) ? true : false;
 464  
 465          $folder_image = $folder_alt = $l_subforums = '';
 466          $subforums_list = array();
 467  
 468          // Generate list of subforums if we need to
 469          if (isset($subforums[$forum_id]))
 470          {
 471              foreach ($subforums[$forum_id] as $subforum_id => $subforum_row)
 472              {
 473                  $subforum_unread = (isset($forum_tracking_info[$subforum_id]) && $subforum_row['orig_forum_last_post_time'] > $forum_tracking_info[$subforum_id]) ? true : false;
 474  
 475                  if (!$subforum_unread && !empty($subforum_row['children']))
 476                  {
 477                      foreach ($subforum_row['children'] as $child_id)
 478                      {
 479                          if (isset($forum_tracking_info[$child_id]) && $subforums[$forum_id][$child_id]['orig_forum_last_post_time'] > $forum_tracking_info[$child_id])
 480                          {
 481                              // Once we found an unread child forum, we can drop out of this loop
 482                              $subforum_unread = true;
 483                              break;
 484                          }
 485                      }
 486                  }
 487  
 488                  if ($subforum_row['display'] && $subforum_row['name'])
 489                  {
 490                      $subforums_list[] = array(
 491                          'link'        => append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $subforum_id),
 492                          'name'        => $subforum_row['name'],
 493                          'unread'    => $subforum_unread,
 494                      );
 495                  }
 496                  else
 497                  {
 498                      unset($subforums[$forum_id][$subforum_id]);
 499                  }
 500  
 501                  // If one subforum is unread the forum gets unread too...
 502                  if ($subforum_unread)
 503                  {
 504                      $forum_unread = true;
 505                  }
 506              }
 507  
 508              $l_subforums = (sizeof($subforums[$forum_id]) == 1) ? $user->lang['SUBFORUM'] : $user->lang['SUBFORUMS'];
 509              $folder_image = ($forum_unread) ? 'forum_unread_subforum' : 'forum_read_subforum';
 510          }
 511          else
 512          {
 513              switch ($row['forum_type'])
 514              {
 515                  case FORUM_POST:
 516                      $folder_image = ($forum_unread) ? 'forum_unread' : 'forum_read';
 517                  break;
 518  
 519                  case FORUM_LINK:
 520                      $folder_image = 'forum_link';
 521                  break;
 522              }
 523          }
 524  
 525          // Which folder should we display?
 526          if ($row['forum_status'] == ITEM_LOCKED)
 527          {
 528              $folder_image = ($forum_unread) ? 'forum_unread_locked' : 'forum_read_locked';
 529              $folder_alt = 'FORUM_LOCKED';
 530          }
 531          else
 532          {
 533              $folder_alt = ($forum_unread) ? 'UNREAD_POSTS' : 'NO_UNREAD_POSTS';
 534          }
 535  
 536          // Create last post link information, if appropriate
 537          if ($row['forum_last_post_id'])
 538          {
 539              if ($row['forum_password_last_post'] === '' && $auth->acl_get('f_read', $row['forum_id_last_post']))
 540              {
 541                  $last_post_subject = censor_text($row['forum_last_post_subject']);
 542                  $last_post_subject_truncated = truncate_string($last_post_subject, 30, 255, false, $user->lang['ELLIPSIS']);
 543              }
 544              else
 545              {
 546                  $last_post_subject = $last_post_subject_truncated = '';
 547              }
 548              $last_post_time = $user->format_date($row['forum_last_post_time']);
 549              $last_post_url = append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $row['forum_id_last_post'] . '&amp;p=' . $row['forum_last_post_id']) . '#p' . $row['forum_last_post_id'];
 550          }
 551          else
 552          {
 553              $last_post_subject = $last_post_time = $last_post_url = $last_post_subject_truncated = '';
 554          }
 555  
 556          // Output moderator listing ... if applicable
 557          $l_moderator = $moderators_list = '';
 558          if ($display_moderators && !empty($forum_moderators[$forum_id]))
 559          {
 560              $l_moderator = (sizeof($forum_moderators[$forum_id]) == 1) ? $user->lang['MODERATOR'] : $user->lang['MODERATORS'];
 561              $moderators_list = implode($user->lang['COMMA_SEPARATOR'], $forum_moderators[$forum_id]);
 562          }
 563  
 564          $l_post_click_count = ($row['forum_type'] == FORUM_LINK) ? 'CLICKS' : 'POSTS';
 565          $post_click_count = ($row['forum_type'] != FORUM_LINK || $row['forum_flags'] & FORUM_FLAG_LINK_TRACK) ? $row['forum_posts'] : '';
 566  
 567          $s_subforums_list = $subforums_row = array();
 568          foreach ($subforums_list as $subforum)
 569          {
 570              $s_subforums_list[] = '<a href="' . $subforum['link'] . '" class="subforum ' . (($subforum['unread']) ? 'unread' : 'read') . '" title="' . (($subforum['unread']) ? $user->lang['UNREAD_POSTS'] : $user->lang['NO_UNREAD_POSTS']) . '">' . $subforum['name'] . '</a>';
 571              $subforums_row[] = array(
 572                  'U_SUBFORUM'    => $subforum['link'],
 573                  'SUBFORUM_NAME'    => $subforum['name'],
 574                  'S_UNREAD'        => $subforum['unread'],
 575              );
 576          }
 577          $s_subforums_list = (string) implode($user->lang['COMMA_SEPARATOR'], $s_subforums_list);
 578          $catless = ($row['parent_id'] == $root_data['forum_id']) ? true : false;
 579  
 580          if ($row['forum_type'] != FORUM_LINK)
 581          {
 582              $u_viewforum = append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $row['forum_id']);
 583          }
 584          else
 585          {
 586              // If the forum is a link and we count redirects we need to visit it
 587              // If the forum is having a password or no read access we do not expose the link, but instead handle it in viewforum
 588              if (($row['forum_flags'] & FORUM_FLAG_LINK_TRACK) || $row['forum_password'] || !$auth->acl_get('f_read', $forum_id))
 589              {
 590                  $u_viewforum = append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $row['forum_id']);
 591              }
 592              else
 593              {
 594                  $u_viewforum = $row['forum_link'];
 595              }
 596          }
 597  
 598          $forum_row = array(
 599              'S_IS_CAT'            => false,
 600              'S_NO_CAT'            => $catless && !$last_catless,
 601              'S_IS_LINK'            => ($row['forum_type'] == FORUM_LINK) ? true : false,
 602              'S_UNREAD_FORUM'    => $forum_unread,
 603              'S_AUTH_READ'        => $auth->acl_get('f_read', $row['forum_id']),
 604              'S_LOCKED_FORUM'    => ($row['forum_status'] == ITEM_LOCKED) ? true : false,
 605              'S_LIST_SUBFORUMS'    => ($row['display_subforum_list']) ? true : false,
 606              'S_SUBFORUMS'        => (sizeof($subforums_list)) ? true : false,
 607              'S_DISPLAY_SUBJECT'    =>    ($last_post_subject !== '' && $config['display_last_subject']) ? true : false,
 608              'S_FEED_ENABLED'    => ($config['feed_forum'] && !phpbb_optionget(FORUM_OPTION_FEED_EXCLUDE, $row['forum_options']) && $row['forum_type'] == FORUM_POST) ? true : false,
 609  
 610              'FORUM_ID'                => $row['forum_id'],
 611              'FORUM_NAME'            => $row['forum_name'],
 612              'FORUM_DESC'            => generate_text_for_display($row['forum_desc'], $row['forum_desc_uid'], $row['forum_desc_bitfield'], $row['forum_desc_options']),
 613              'TOPICS'                => $row['forum_topics'],
 614              $l_post_click_count        => $post_click_count,
 615              'FORUM_IMG_STYLE'        => $folder_image,
 616              'FORUM_FOLDER_IMG'        => $user->img($folder_image, $folder_alt),
 617              'FORUM_FOLDER_IMG_ALT'    => isset($user->lang[$folder_alt]) ? $user->lang[$folder_alt] : '',
 618              'FORUM_IMAGE'            => ($row['forum_image']) ? '<img src="' . $phpbb_root_path . $row['forum_image'] . '" alt="' . $user->lang[$folder_alt] . '" />' : '',
 619              'FORUM_IMAGE_SRC'        => ($row['forum_image']) ? $phpbb_root_path . $row['forum_image'] : '',
 620              'LAST_POST_SUBJECT'        => $last_post_subject,
 621              'LAST_POST_SUBJECT_TRUNCATED'    => $last_post_subject_truncated,
 622              'LAST_POST_TIME'        => $last_post_time,
 623              'LAST_POSTER'            => get_username_string('username', $row['forum_last_poster_id'], $row['forum_last_poster_name'], $row['forum_last_poster_colour']),
 624              'LAST_POSTER_COLOUR'    => get_username_string('colour', $row['forum_last_poster_id'], $row['forum_last_poster_name'], $row['forum_last_poster_colour']),
 625              'LAST_POSTER_FULL'        => get_username_string('full', $row['forum_last_poster_id'], $row['forum_last_poster_name'], $row['forum_last_poster_colour']),
 626              'MODERATORS'            => $moderators_list,
 627              'SUBFORUMS'                => $s_subforums_list,
 628  
 629              'L_SUBFORUM_STR'        => $l_subforums,
 630              'L_MODERATOR_STR'        => $l_moderator,
 631  
 632              'U_UNAPPROVED_TOPICS'    => ($row['forum_id_unapproved_topics']) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=queue&amp;mode=unapproved_topics&amp;f=' . $row['forum_id_unapproved_topics']) : '',
 633              'U_UNAPPROVED_POSTS'    => ($row['forum_id_unapproved_posts']) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=queue&amp;mode=unapproved_posts&amp;f=' . $row['forum_id_unapproved_posts']) : '',
 634              'U_VIEWFORUM'        => $u_viewforum,
 635              'U_LAST_POSTER'        => get_username_string('profile', $row['forum_last_poster_id'], $row['forum_last_poster_name'], $row['forum_last_poster_colour']),
 636              'U_LAST_POST'        => $last_post_url,
 637          );
 638  
 639          /**
 640          * Modify the template data block of the forum
 641          *
 642          * This event is triggered once per forum
 643          *
 644          * @event core.display_forums_modify_template_vars
 645          * @var    array    forum_row        Template data of the forum
 646          * @var    array    row                The data of the forum
 647          * @var    array    subforums_row    Template data of subforums
 648          * @since 3.1.0-a1
 649          * @change 3.1.0-b5 Added var subforums_row
 650          */
 651          $vars = array('forum_row', 'row', 'subforums_row');
 652          extract($phpbb_dispatcher->trigger_event('core.display_forums_modify_template_vars', compact($vars)));
 653  
 654          $template->assign_block_vars('forumrow', $forum_row);
 655  
 656          // Assign subforums loop for style authors
 657          $template->assign_block_vars_array('forumrow.subforum', $subforums_row);
 658  
 659          /**
 660          * Modify and/or assign additional template data for the forum
 661          * after forumrow loop has been assigned. This can be used
 662          * to create additional forumrow subloops in extensions.
 663          *
 664          * This event is triggered once per forum
 665          *
 666          * @event core.display_forums_add_template_data
 667          * @var    array    forum_row        Template data of the forum
 668          * @var    array    row                The data of the forum
 669          * @var    array    subforums_list    The data of subforums
 670          * @var    array    subforums_row    Template data of subforums
 671          * @var    bool    catless            The flag indicating whether a forum has a parent category
 672          * @since 3.1.0-b5
 673          */
 674          $vars = array(
 675              'forum_row',
 676              'row',
 677              'subforums_list',
 678              'subforums_row',
 679              'catless',
 680          );
 681          extract($phpbb_dispatcher->trigger_event('core.display_forums_add_template_data', compact($vars)));
 682  
 683          $last_catless = $catless;
 684      }
 685  
 686      $template->assign_vars(array(
 687          'U_MARK_FORUMS'        => ($user->data['is_registered'] || $config['load_anon_lastread']) ? append_sid("{$phpbb_root_path}viewforum.$phpEx", 'hash=' . generate_link_hash('global') . '&amp;f=' . $root_data['forum_id'] . '&amp;mark=forums&amp;mark_time=' . time()) : '',
 688          'S_HAS_SUBFORUM'    => ($visible_forums) ? true : false,
 689          'L_SUBFORUM'        => ($visible_forums == 1) ? $user->lang['SUBFORUM'] : $user->lang['SUBFORUMS'],
 690          'LAST_POST_IMG'        => $user->img('icon_topic_latest', 'VIEW_LATEST_POST'),
 691          'UNAPPROVED_IMG'    => $user->img('icon_topic_unapproved', 'TOPICS_UNAPPROVED'),
 692          'UNAPPROVED_POST_IMG'    => $user->img('icon_topic_unapproved', 'POSTS_UNAPPROVED_FORUM'),
 693      ));
 694  
 695      /**
 696      * Event to perform additional actions after the forum list has been generated
 697      *
 698      * @event core.display_forums_after
 699      * @var    array    active_forum_ary    Array with forum data to display active topics
 700      * @var    bool    display_moderators    Flag indicating if we display forum moderators
 701      * @var    array    forum_moderators    Array with forum moderators list
 702      * @var    array    forum_rows            Data array of all forums we display
 703      * @var    bool    return_moderators    Flag indicating if moderators list should be returned
 704      * @var    array    root_data            Array with the root forum data
 705      * @since 3.1.0-RC5
 706      */
 707      $vars = array(
 708          'active_forum_ary',
 709          'display_moderators',
 710          'forum_moderators',
 711          'forum_rows',
 712          'return_moderators',
 713          'root_data',
 714      );
 715      extract($phpbb_dispatcher->trigger_event('core.display_forums_after', compact($vars)));
 716  
 717      if ($return_moderators)
 718      {
 719          return array($active_forum_ary, $forum_moderators);
 720      }
 721  
 722      return array($active_forum_ary, array());
 723  }
 724  
 725  /**
 726  * Create forum rules for given forum
 727  */
 728  function generate_forum_rules(&$forum_data)
 729  {
 730      if (!$forum_data['forum_rules'] && !$forum_data['forum_rules_link'])
 731      {
 732          return;
 733      }
 734  
 735      global $template, $phpbb_root_path, $phpEx;
 736  
 737      if ($forum_data['forum_rules'])
 738      {
 739          $forum_data['forum_rules'] = generate_text_for_display($forum_data['forum_rules'], $forum_data['forum_rules_uid'], $forum_data['forum_rules_bitfield'], $forum_data['forum_rules_options']);
 740      }
 741  
 742      $template->assign_vars(array(
 743          'S_FORUM_RULES'    => true,
 744          'U_FORUM_RULES'    => $forum_data['forum_rules_link'],
 745          'FORUM_RULES'    => $forum_data['forum_rules'])
 746      );
 747  }
 748  
 749  /**
 750  * Create forum navigation links for given forum, create parent
 751  * list if currently null, assign basic forum info to template
 752  */
 753  function generate_forum_nav(&$forum_data)
 754  {
 755      global $db, $user, $template, $auth, $config;
 756      global $phpEx, $phpbb_root_path, $phpbb_dispatcher;
 757  
 758      if (!$auth->acl_get('f_list', $forum_data['forum_id']))
 759      {
 760          return;
 761      }
 762  
 763      $navlinks = $navlinks_parents = $forum_template_data = array();
 764  
 765      // Get forum parents
 766      $forum_parents = get_forum_parents($forum_data);
 767  
 768      $microdata_attr = 'data-forum-id';
 769  
 770      // Build navigation links
 771      if (!empty($forum_parents))
 772      {
 773          foreach ($forum_parents as $parent_forum_id => $parent_data)
 774          {
 775              list($parent_name, $parent_type) = array_values($parent_data);
 776  
 777              // Skip this parent if the user does not have the permission to view it
 778              if (!$auth->acl_get('f_list', $parent_forum_id))
 779              {
 780                  continue;
 781              }
 782  
 783              $navlinks_parents[] = array(
 784                  'S_IS_CAT'        => ($parent_type == FORUM_CAT) ? true : false,
 785                  'S_IS_LINK'        => ($parent_type == FORUM_LINK) ? true : false,
 786                  'S_IS_POST'        => ($parent_type == FORUM_POST) ? true : false,
 787                  'FORUM_NAME'    => $parent_name,
 788                  'FORUM_ID'        => $parent_forum_id,
 789                  'MICRODATA'        => $microdata_attr . '="' . $parent_forum_id . '"',
 790                  'U_VIEW_FORUM'    => append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $parent_forum_id),
 791              );
 792          }
 793      }
 794  
 795      $navlinks = array(
 796          'S_IS_CAT'        => ($forum_data['forum_type'] == FORUM_CAT) ? true : false,
 797          'S_IS_LINK'        => ($forum_data['forum_type'] == FORUM_LINK) ? true : false,
 798          'S_IS_POST'        => ($forum_data['forum_type'] == FORUM_POST) ? true : false,
 799          'FORUM_NAME'    => $forum_data['forum_name'],
 800          'FORUM_ID'        => $forum_data['forum_id'],
 801          'MICRODATA'        => $microdata_attr . '="' . $forum_data['forum_id'] . '"',
 802          'U_VIEW_FORUM'    => append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $forum_data['forum_id']),
 803      );
 804  
 805      $forum_template_data = array(
 806          'FORUM_ID'         => $forum_data['forum_id'],
 807          'FORUM_NAME'    => $forum_data['forum_name'],
 808          'FORUM_DESC'    => generate_text_for_display($forum_data['forum_desc'], $forum_data['forum_desc_uid'], $forum_data['forum_desc_bitfield'], $forum_data['forum_desc_options']),
 809  
 810          'S_ENABLE_FEEDS_FORUM'    => ($config['feed_forum'] && $forum_data['forum_type'] == FORUM_POST && !phpbb_optionget(FORUM_OPTION_FEED_EXCLUDE, $forum_data['forum_options'])) ? true : false,
 811      );
 812  
 813      /**
 814      * Event to modify the navlinks text
 815      *
 816      * @event core.generate_forum_nav
 817      * @var    array    forum_data                Array with the forum data
 818      * @var    array    forum_template_data        Array with generic forum template data
 819      * @var    string    microdata_attr            The microdata attribute
 820      * @var    array    navlinks_parents        Array with the forum parents navlinks data
 821      * @var    array    navlinks                Array with the forum navlinks data
 822      * @since 3.1.5-RC1
 823      */
 824      $vars = array(
 825          'forum_data',
 826          'forum_template_data',
 827          'microdata_attr',
 828          'navlinks_parents',
 829          'navlinks',
 830      );
 831      extract($phpbb_dispatcher->trigger_event('core.generate_forum_nav', compact($vars)));
 832  
 833      $template->assign_block_vars_array('navlinks', $navlinks_parents);
 834      $template->assign_block_vars('navlinks', $navlinks);
 835      $template->assign_vars($forum_template_data);
 836  
 837      return;
 838  }
 839  
 840  /**
 841  * Returns forum parents as an array. Get them from forum_data if available, or update the database otherwise
 842  */
 843  function get_forum_parents(&$forum_data)
 844  {
 845      global $db;
 846  
 847      $forum_parents = array();
 848  
 849      if ($forum_data['parent_id'] > 0)
 850      {
 851          if ($forum_data['forum_parents'] == '')
 852          {
 853              $sql = 'SELECT forum_id, forum_name, forum_type
 854                  FROM ' . FORUMS_TABLE . '
 855                  WHERE left_id < ' . $forum_data['left_id'] . '
 856                      AND right_id > ' . $forum_data['right_id'] . '
 857                  ORDER BY left_id ASC';
 858              $result = $db->sql_query($sql);
 859  
 860              while ($row = $db->sql_fetchrow($result))
 861              {
 862                  $forum_parents[$row['forum_id']] = array($row['forum_name'], (int) $row['forum_type']);
 863              }
 864              $db->sql_freeresult($result);
 865  
 866              $forum_data['forum_parents'] = serialize($forum_parents);
 867  
 868              $sql = 'UPDATE ' . FORUMS_TABLE . "
 869                  SET forum_parents = '" . $db->sql_escape($forum_data['forum_parents']) . "'
 870                  WHERE parent_id = " . $forum_data['parent_id'];
 871              $db->sql_query($sql);
 872          }
 873          else
 874          {
 875              $forum_parents = unserialize($forum_data['forum_parents']);
 876          }
 877      }
 878  
 879      return $forum_parents;
 880  }
 881  
 882  /**
 883  * Obtain list of moderators of each forum
 884  */
 885  function get_moderators(&$forum_moderators, $forum_id = false)
 886  {
 887      global $config, $template, $db, $phpbb_root_path, $phpEx, $user, $auth;
 888  
 889      $forum_id_ary = array();
 890  
 891      if ($forum_id !== false)
 892      {
 893          if (!is_array($forum_id))
 894          {
 895              $forum_id = array($forum_id);
 896          }
 897  
 898          // Exchange key/value pair to be able to faster check for the forum id existence
 899          $forum_id_ary = array_flip($forum_id);
 900      }
 901  
 902      $sql_array = array(
 903          'SELECT'    => 'm.*, u.user_colour, g.group_colour, g.group_type',
 904  
 905          'FROM'        => array(
 906              MODERATOR_CACHE_TABLE    => 'm',
 907          ),
 908  
 909          'LEFT_JOIN'    => array(
 910              array(
 911                  'FROM'    => array(USERS_TABLE => 'u'),
 912                  'ON'    => 'm.user_id = u.user_id',
 913              ),
 914              array(
 915                  'FROM'    => array(GROUPS_TABLE => 'g'),
 916                  'ON'    => 'm.group_id = g.group_id',
 917              ),
 918          ),
 919  
 920          'WHERE'        => 'm.display_on_index = 1',
 921      );
 922  
 923      // We query every forum here because for caching we should not have any parameter.
 924      $sql = $db->sql_build_query('SELECT', $sql_array);
 925      $result = $db->sql_query($sql, 3600);
 926  
 927      while ($row = $db->sql_fetchrow($result))
 928      {
 929          $f_id = (int) $row['forum_id'];
 930  
 931          if (!isset($forum_id_ary[$f_id]))
 932          {
 933              continue;
 934          }
 935  
 936          if (!empty($row['user_id']))
 937          {
 938              $forum_moderators[$f_id][] = get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']);
 939          }
 940          else
 941          {
 942              $group_name = (($row['group_type'] == GROUP_SPECIAL) ? $user->lang['G_' . $row['group_name']] : $row['group_name']);
 943  
 944              if ($user->data['user_id'] != ANONYMOUS && !$auth->acl_get('u_viewprofile'))
 945              {
 946                  $forum_moderators[$f_id][] = '<span' . (($row['group_colour']) ? ' style="color:#' . $row['group_colour'] . ';"' : '') . '>' . $group_name . '</span>';
 947              }
 948              else
 949              {
 950                  $forum_moderators[$f_id][] = '<a' . (($row['group_colour']) ? ' style="color:#' . $row['group_colour'] . ';"' : '') . ' href="' . append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=group&amp;g=' . $row['group_id']) . '">' . $group_name . '</a>';
 951              }
 952          }
 953      }
 954      $db->sql_freeresult($result);
 955  
 956      return;
 957  }
 958  
 959  /**
 960  * User authorisation levels output
 961  *
 962  * @param    string    $mode            Can be forum or topic. Not in use at the moment.
 963  * @param    int        $forum_id        The current forum the user is in.
 964  * @param    int        $forum_status    The forums status bit.
 965  */
 966  function gen_forum_auth_level($mode, $forum_id, $forum_status)
 967  {
 968      global $template, $auth, $user, $config;
 969  
 970      $locked = ($forum_status == ITEM_LOCKED && !$auth->acl_get('m_edit', $forum_id)) ? true : false;
 971  
 972      $rules = array(
 973          ($auth->acl_get('f_post', $forum_id) && !$locked) ? $user->lang['RULES_POST_CAN'] : $user->lang['RULES_POST_CANNOT'],
 974          ($auth->acl_get('f_reply', $forum_id) && !$locked) ? $user->lang['RULES_REPLY_CAN'] : $user->lang['RULES_REPLY_CANNOT'],
 975          ($user->data['is_registered'] && $auth->acl_gets('f_edit', 'm_edit', $forum_id) && !$locked) ? $user->lang['RULES_EDIT_CAN'] : $user->lang['RULES_EDIT_CANNOT'],
 976          ($user->data['is_registered'] && ($auth->acl_gets('f_delete', 'm_delete', $forum_id) || $auth->acl_gets('f_softdelete', 'm_softdelete', $forum_id)) && !$locked) ? $user->lang['RULES_DELETE_CAN'] : $user->lang['RULES_DELETE_CANNOT'],
 977      );
 978  
 979      if ($config['allow_attachments'])
 980      {
 981          $rules[] = ($auth->acl_get('f_attach', $forum_id) && $auth->acl_get('u_attach') && !$locked) ? $user->lang['RULES_ATTACH_CAN'] : $user->lang['RULES_ATTACH_CANNOT'];
 982      }
 983  
 984      foreach ($rules as $rule)
 985      {
 986          $template->assign_block_vars('rules', array('RULE' => $rule));
 987      }
 988  
 989      return;
 990  }
 991  
 992  /**
 993  * Generate topic status
 994  */
 995  function topic_status(&$topic_row, $replies, $unread_topic, &$folder_img, &$folder_alt, &$topic_type)
 996  {
 997      global $user, $config;
 998  
 999      $folder = $folder_new = '';
1000  
1001      if ($topic_row['topic_status'] == ITEM_MOVED)
1002      {
1003          $topic_type = $user->lang['VIEW_TOPIC_MOVED'];
1004          $folder_img = 'topic_moved';
1005          $folder_alt = 'TOPIC_MOVED';
1006      }
1007      else
1008      {
1009          switch ($topic_row['topic_type'])
1010          {
1011              case POST_GLOBAL:
1012                  $topic_type = $user->lang['VIEW_TOPIC_GLOBAL'];
1013                  $folder = 'global_read';
1014                  $folder_new = 'global_unread';
1015              break;
1016  
1017              case POST_ANNOUNCE:
1018                  $topic_type = $user->lang['VIEW_TOPIC_ANNOUNCEMENT'];
1019                  $folder = 'announce_read';
1020                  $folder_new = 'announce_unread';
1021              break;
1022  
1023              case POST_STICKY:
1024                  $topic_type = $user->lang['VIEW_TOPIC_STICKY'];
1025                  $folder = 'sticky_read';
1026                  $folder_new = 'sticky_unread';
1027              break;
1028  
1029              default:
1030                  $topic_type = '';
1031                  $folder = 'topic_read';
1032                  $folder_new = 'topic_unread';
1033  
1034                  // Hot topic threshold is for posts in a topic, which is replies + the first post. ;)
1035                  if ($config['hot_threshold'] && ($replies + 1) >= $config['hot_threshold'] && $topic_row['topic_status'] != ITEM_LOCKED)
1036                  {
1037                      $folder .= '_hot';
1038                      $folder_new .= '_hot';
1039                  }
1040              break;
1041          }
1042  
1043          if ($topic_row['topic_status'] == ITEM_LOCKED)
1044          {
1045              $topic_type = $user->lang['VIEW_TOPIC_LOCKED'];
1046              $folder .= '_locked';
1047              $folder_new .= '_locked';
1048          }
1049  
1050          $folder_img = ($unread_topic) ? $folder_new : $folder;
1051          $folder_alt = ($unread_topic) ? 'UNREAD_POSTS' : (($topic_row['topic_status'] == ITEM_LOCKED) ? 'TOPIC_LOCKED' : 'NO_UNREAD_POSTS');
1052  
1053          // Posted image?
1054          if (!empty($topic_row['topic_posted']) && $topic_row['topic_posted'])
1055          {
1056              $folder_img .= '_mine';
1057          }
1058      }
1059  
1060      if ($topic_row['poll_start'] && $topic_row['topic_status'] != ITEM_MOVED)
1061      {
1062          $topic_type = $user->lang['VIEW_TOPIC_POLL'];
1063      }
1064  }
1065  
1066  /**
1067  * Assign/Build custom bbcodes for display in screens supporting using of bbcodes
1068  * The custom bbcodes buttons will be placed within the template block 'custom_tags'
1069  */
1070  function display_custom_bbcodes()
1071  {
1072      global $db, $template, $user, $phpbb_dispatcher;
1073  
1074      // Start counting from 22 for the bbcode ids (every bbcode takes two ids - opening/closing)
1075      $num_predefined_bbcodes = 22;
1076  
1077      $sql_ary = array(
1078          'SELECT'    => 'b.bbcode_id, b.bbcode_tag, b.bbcode_helpline',
1079          'FROM'        => array(BBCODES_TABLE => 'b'),
1080          'WHERE'        => 'b.display_on_posting = 1',
1081          'ORDER_BY'    => 'b.bbcode_tag',
1082      );
1083  
1084      /**
1085      * Event to modify the SQL query before custom bbcode data is queried
1086      *
1087      * @event core.display_custom_bbcodes_modify_sql
1088      * @var    array    sql_ary                    The SQL array to get the bbcode data
1089      * @var    int        num_predefined_bbcodes    The number of predefined core bbcodes
1090      *                                        (multiplied by factor of 2)
1091      * @since 3.1.0-a3
1092      */
1093      $vars = array('sql_ary', 'num_predefined_bbcodes');
1094      extract($phpbb_dispatcher->trigger_event('core.display_custom_bbcodes_modify_sql', compact($vars)));
1095  
1096      $result = $db->sql_query($db->sql_build_query('SELECT', $sql_ary));
1097  
1098      $i = 0;
1099      while ($row = $db->sql_fetchrow($result))
1100      {
1101          // If the helpline is defined within the language file, we will use the localised version, else just use the database entry...
1102          if (isset($user->lang[strtoupper($row['bbcode_helpline'])]))
1103          {
1104              $row['bbcode_helpline'] = $user->lang[strtoupper($row['bbcode_helpline'])];
1105          }
1106  
1107          $custom_tags = array(
1108              'BBCODE_NAME'        => "'[{$row['bbcode_tag']}]', '[/" . str_replace('=', '', $row['bbcode_tag']) . "]'",
1109              'BBCODE_ID'            => $num_predefined_bbcodes + ($i * 2),
1110              'BBCODE_TAG'        => $row['bbcode_tag'],
1111              'BBCODE_TAG_CLEAN'    => str_replace('=', '-', $row['bbcode_tag']),
1112              'BBCODE_HELPLINE'    => $row['bbcode_helpline'],
1113              'A_BBCODE_HELPLINE'    => str_replace(array('&amp;', '&quot;', "'", '&lt;', '&gt;'), array('&', '"', "\'", '<', '>'), $row['bbcode_helpline']),
1114          );
1115  
1116          /**
1117          * Event to modify the template data block of a custom bbcode
1118          *
1119          * This event is triggered once per bbcode
1120          *
1121          * @event core.display_custom_bbcodes_modify_row
1122          * @var    array    custom_tags        Template data of the bbcode
1123          * @var    array    row                The data of the bbcode
1124          * @since 3.1.0-a1
1125          */
1126          $vars = array('custom_tags', 'row');
1127          extract($phpbb_dispatcher->trigger_event('core.display_custom_bbcodes_modify_row', compact($vars)));
1128  
1129          $template->assign_block_vars('custom_tags', $custom_tags);
1130  
1131          $i++;
1132      }
1133      $db->sql_freeresult($result);
1134  
1135      /**
1136      * Display custom bbcodes
1137      *
1138      * @event core.display_custom_bbcodes
1139      * @since 3.1.0-a1
1140      */
1141      $phpbb_dispatcher->dispatch('core.display_custom_bbcodes');
1142  }
1143  
1144  /**
1145  * Display reasons
1146  */
1147  function display_reasons($reason_id = 0)
1148  {
1149      global $db, $user, $template;
1150  
1151      $sql = 'SELECT *
1152          FROM ' . REPORTS_REASONS_TABLE . '
1153          ORDER BY reason_order ASC';
1154      $result = $db->sql_query($sql);
1155  
1156      while ($row = $db->sql_fetchrow($result))
1157      {
1158          // If the reason is defined within the language file, we will use the localized version, else just use the database entry...
1159          if (isset($user->lang['report_reasons']['TITLE'][strtoupper($row['reason_title'])]) && isset($user->lang['report_reasons']['DESCRIPTION'][strtoupper($row['reason_title'])]))
1160          {
1161              $row['reason_description'] = $user->lang['report_reasons']['DESCRIPTION'][strtoupper($row['reason_title'])];
1162              $row['reason_title'] = $user->lang['report_reasons']['TITLE'][strtoupper($row['reason_title'])];
1163          }
1164  
1165          $template->assign_block_vars('reason', array(
1166              'ID'            => $row['reason_id'],
1167              'TITLE'            => $row['reason_title'],
1168              'DESCRIPTION'    => $row['reason_description'],
1169              'S_SELECTED'    => ($row['reason_id'] == $reason_id) ? true : false)
1170          );
1171      }
1172      $db->sql_freeresult($result);
1173  }
1174  
1175  /**
1176  * Display user activity (action forum/topic)
1177  */
1178  function display_user_activity(&$userdata)
1179  {
1180      global $auth, $template, $db, $user;
1181      global $phpbb_root_path, $phpEx;
1182      global $phpbb_container, $phpbb_dispatcher;
1183  
1184      // Do not display user activity for users having more than 5000 posts...
1185      if ($userdata['user_posts'] > 5000)
1186      {
1187          return;
1188      }
1189  
1190      $forum_ary = array();
1191  
1192      $forum_read_ary = $auth->acl_getf('f_read');
1193      foreach ($forum_read_ary as $forum_id => $allowed)
1194      {
1195          if ($allowed['f_read'])
1196          {
1197              $forum_ary[] = (int) $forum_id;
1198          }
1199      }
1200  
1201      $forum_ary = array_diff($forum_ary, $user->get_passworded_forums());
1202  
1203      $active_f_row = $active_t_row = array();
1204      if (!empty($forum_ary))
1205      {
1206          $phpbb_content_visibility = $phpbb_container->get('content.visibility');
1207  
1208          // Obtain active forum
1209          $sql = 'SELECT forum_id, COUNT(post_id) AS num_posts
1210              FROM ' . POSTS_TABLE . '
1211              WHERE poster_id = ' . $userdata['user_id'] . '
1212                  AND post_postcount = 1
1213                  AND ' . $phpbb_content_visibility->get_forums_visibility_sql('post', $forum_ary) . '
1214              GROUP BY forum_id
1215              ORDER BY num_posts DESC';
1216          $result = $db->sql_query_limit($sql, 1);
1217          $active_f_row = $db->sql_fetchrow($result);
1218          $db->sql_freeresult($result);
1219  
1220          if (!empty($active_f_row))
1221          {
1222              $sql = 'SELECT forum_name
1223                  FROM ' . FORUMS_TABLE . '
1224                  WHERE forum_id = ' . $active_f_row['forum_id'];
1225              $result = $db->sql_query($sql, 3600);
1226              $active_f_row['forum_name'] = (string) $db->sql_fetchfield('forum_name');
1227              $db->sql_freeresult($result);
1228          }
1229  
1230          // Obtain active topic
1231          $sql = 'SELECT topic_id, COUNT(post_id) AS num_posts
1232              FROM ' . POSTS_TABLE . '
1233              WHERE poster_id = ' . $userdata['user_id'] . '
1234                  AND post_postcount = 1
1235                  AND ' . $phpbb_content_visibility->get_forums_visibility_sql('post', $forum_ary) . '
1236              GROUP BY topic_id
1237              ORDER BY num_posts DESC';
1238          $result = $db->sql_query_limit($sql, 1);
1239          $active_t_row = $db->sql_fetchrow($result);
1240          $db->sql_freeresult($result);
1241  
1242          if (!empty($active_t_row))
1243          {
1244              $sql = 'SELECT topic_title
1245                  FROM ' . TOPICS_TABLE . '
1246                  WHERE topic_id = ' . $active_t_row['topic_id'];
1247              $result = $db->sql_query($sql);
1248              $active_t_row['topic_title'] = (string) $db->sql_fetchfield('topic_title');
1249              $db->sql_freeresult($result);
1250          }
1251      }
1252  
1253      /**
1254      * Alter list of forums and topics to display as active
1255      *
1256      * @event core.display_user_activity_modify_actives
1257      * @var    array    userdata                        User's data
1258      * @var    array    active_f_row                    List of active forums
1259      * @var    array    active_t_row                    List of active posts
1260      * @since 3.1.0-RC3
1261      */
1262      $vars = array('userdata', 'active_f_row', 'active_t_row');
1263      extract($phpbb_dispatcher->trigger_event('core.display_user_activity_modify_actives', compact($vars)));
1264  
1265      $userdata['active_t_row'] = $active_t_row;
1266      $userdata['active_f_row'] = $active_f_row;
1267  
1268      $active_f_name = $active_f_id = $active_f_count = $active_f_pct = '';
1269      if (!empty($active_f_row['num_posts']))
1270      {
1271          $active_f_name = $active_f_row['forum_name'];
1272          $active_f_id = $active_f_row['forum_id'];
1273          $active_f_count = $active_f_row['num_posts'];
1274          $active_f_pct = ($userdata['user_posts']) ? ($active_f_count / $userdata['user_posts']) * 100 : 0;
1275      }
1276  
1277      $active_t_name = $active_t_id = $active_t_count = $active_t_pct = '';
1278      if (!empty($active_t_row['num_posts']))
1279      {
1280          $active_t_name = $active_t_row['topic_title'];
1281          $active_t_id = $active_t_row['topic_id'];
1282          $active_t_count = $active_t_row['num_posts'];
1283          $active_t_pct = ($userdata['user_posts']) ? ($active_t_count / $userdata['user_posts']) * 100 : 0;
1284      }
1285  
1286      $l_active_pct = ($userdata['user_id'] != ANONYMOUS && $userdata['user_id'] == $user->data['user_id']) ? $user->lang['POST_PCT_ACTIVE_OWN'] : $user->lang['POST_PCT_ACTIVE'];
1287  
1288      $template->assign_vars(array(
1289          'ACTIVE_FORUM'            => $active_f_name,
1290          'ACTIVE_FORUM_POSTS'    => $user->lang('USER_POSTS', (int) $active_f_count),
1291          'ACTIVE_FORUM_PCT'        => sprintf($l_active_pct, $active_f_pct),
1292          'ACTIVE_TOPIC'            => censor_text($active_t_name),
1293          'ACTIVE_TOPIC_POSTS'    => $user->lang('USER_POSTS', (int) $active_t_count),
1294          'ACTIVE_TOPIC_PCT'        => sprintf($l_active_pct, $active_t_pct),
1295          'U_ACTIVE_FORUM'        => append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $active_f_id),
1296          'U_ACTIVE_TOPIC'        => append_sid("{$phpbb_root_path}viewtopic.$phpEx", 't=' . $active_t_id),
1297          'S_SHOW_ACTIVITY'        => true)
1298      );
1299  }
1300  
1301  /**
1302  * Topic and forum watching common code
1303  */
1304  function watch_topic_forum($mode, &$s_watching, $user_id, $forum_id, $topic_id, $notify_status = 'unset', $start = 0, $item_title = '')
1305  {
1306      global $template, $db, $user, $phpEx, $start, $phpbb_root_path;
1307      global $request;
1308  
1309      $table_sql = ($mode == 'forum') ? FORUMS_WATCH_TABLE : TOPICS_WATCH_TABLE;
1310      $where_sql = ($mode == 'forum') ? 'forum_id' : 'topic_id';
1311      $match_id = ($mode == 'forum') ? $forum_id : $topic_id;
1312      $u_url = "uid={$user->data['user_id']}";
1313      $u_url .= ($mode == 'forum') ? '&amp;f' : '&amp;f=' . $forum_id . '&amp;t';
1314      $is_watching = 0;
1315  
1316      // Is user watching this topic?
1317      if ($user_id != ANONYMOUS)
1318      {
1319          $can_watch = true;
1320  
1321          if ($notify_status == 'unset')
1322          {
1323              $sql = "SELECT notify_status
1324                  FROM $table_sql
1325                  WHERE $where_sql = $match_id
1326                      AND user_id = $user_id";
1327              $result = $db->sql_query($sql);
1328  
1329              $notify_status = ($row = $db->sql_fetchrow($result)) ? $row['notify_status'] : NULL;
1330              $db->sql_freeresult($result);
1331          }
1332  
1333          if (!is_null($notify_status) && $notify_status !== '')
1334          {
1335              if (isset($_GET['unwatch']))
1336              {
1337                  $uid = request_var('uid', 0);
1338                  $token = request_var('hash', '');
1339  
1340                  if ($token && check_link_hash($token, "{$mode}_$match_id") || confirm_box(true))
1341                  {
1342                      if ($uid != $user_id || $request->variable('unwatch', '', false, \phpbb\request\request_interface::GET) != $mode)
1343                      {
1344                          $redirect_url = append_sid("{$phpbb_root_path}view$mode.$phpEx", "$u_url=$match_id&amp;start=$start");
1345                          $message = $user->lang['ERR_UNWATCHING'];
1346  
1347                          if (!$request->is_ajax())
1348                          {
1349                              $message .= '<br /><br />' . $user->lang('RETURN_' . strtoupper($mode), '<a href="' . $redirect_url . '">', '</a>');
1350                          }
1351                          trigger_error($message);
1352                      }
1353  
1354                      $sql = 'DELETE FROM ' . $table_sql . "
1355                          WHERE $where_sql = $match_id
1356                              AND user_id = $user_id";
1357                      $db->sql_query($sql);
1358  
1359                      $redirect_url = append_sid("{$phpbb_root_path}view$mode.$phpEx", "$u_url=$match_id&amp;start=$start");
1360                      $message = $user->lang['NOT_WATCHING_' . strtoupper($mode)];
1361  
1362                      if (!$request->is_ajax())
1363                      {
1364                          $message .= '<br /><br />' . $user->lang('RETURN_' . strtoupper($mode), '<a href="' . $redirect_url . '">', '</a>');
1365                      }
1366                      meta_refresh(3, $redirect_url);
1367                      trigger_error($message);
1368                  }
1369                  else
1370                  {
1371                      $s_hidden_fields = array(
1372                          'uid'        => $user->data['user_id'],
1373                          'unwatch'    => $mode,
1374                          'start'        => $start,
1375                          'f'            => $forum_id,
1376                      );
1377                      if ($mode != 'forum')
1378                      {
1379                          $s_hidden_fields['t'] = $topic_id;
1380                      }
1381  
1382                      if ($item_title == '')
1383                      {
1384                          $confirm_box_message = 'UNWATCH_' . strtoupper($mode);
1385                      }
1386                      else
1387                      {
1388                          $confirm_box_message = $user->lang('UNWATCH_' . strtoupper($mode) . '_DETAILED', $item_title);
1389                      }
1390                      confirm_box(false, $confirm_box_message, build_hidden_fields($s_hidden_fields));
1391                  }
1392              }
1393              else
1394              {
1395                  $is_watching = true;
1396  
1397                  if ($notify_status != NOTIFY_YES)
1398                  {
1399                      $sql = 'UPDATE ' . $table_sql . "
1400                          SET notify_status = " . NOTIFY_YES . "
1401                          WHERE $where_sql = $match_id
1402                              AND user_id = $user_id";
1403                      $db->sql_query($sql);
1404                  }
1405              }
1406          }
1407          else
1408          {
1409              if (isset($_GET['watch']))
1410              {
1411                  $uid = request_var('uid', 0);
1412                  $token = request_var('hash', '');
1413  
1414                  if ($token && check_link_hash($token, "{$mode}_$match_id") || confirm_box(true))
1415                  {
1416                      if ($uid != $user_id || $request->variable('watch', '', false, \phpbb\request\request_interface::GET) != $mode)
1417                      {
1418                          $redirect_url = append_sid("{$phpbb_root_path}view$mode.$phpEx", "$u_url=$match_id&amp;start=$start");
1419                          $message = $user->lang['ERR_WATCHING'];
1420  
1421                          if (!$request->is_ajax())
1422                          {
1423                              $message .= '<br /><br />' . $user->lang('RETURN_' . strtoupper($mode), '<a href="' . $redirect_url . '">', '</a>');
1424                          }
1425                          trigger_error($message);
1426                      }
1427  
1428                      $is_watching = true;
1429  
1430                      $sql = 'INSERT INTO ' . $table_sql . " (user_id, $where_sql, notify_status)
1431                          VALUES ($user_id, $match_id, " . NOTIFY_YES . ')';
1432                      $db->sql_query($sql);
1433  
1434                      $redirect_url = append_sid("{$phpbb_root_path}view$mode.$phpEx", "$u_url=$match_id&amp;start=$start");
1435                      $message = $user->lang['ARE_WATCHING_' . strtoupper($mode)];
1436  
1437                      if (!$request->is_ajax())
1438                      {
1439                          $message .= '<br /><br />' . $user->lang('RETURN_' . strtoupper($mode), '<a href="' . $redirect_url . '">', '</a>');
1440                      }
1441                      meta_refresh(3, $redirect_url);
1442                      trigger_error($message);
1443                  }
1444                  else
1445                  {
1446                      $s_hidden_fields = array(
1447                          'uid'        => $user->data['user_id'],
1448                          'watch'        => $mode,
1449                          'start'        => $start,
1450                          'f'            => $forum_id,
1451                      );
1452                      if ($mode != 'forum')
1453                      {
1454                          $s_hidden_fields['t'] = $topic_id;
1455                      }
1456  
1457                      $confirm_box_message = (($item_title == '') ? 'WATCH_' . strtoupper($mode) : $user->lang('WATCH_' . strtoupper($mode) . '_DETAILED', $item_title));
1458                      confirm_box(false, $confirm_box_message, build_hidden_fields($s_hidden_fields));
1459                  }
1460              }
1461              else
1462              {
1463                  $is_watching = 0;
1464              }
1465          }
1466      }
1467      else
1468      {
1469          if ((isset($_GET['unwatch']) && $request->variable('unwatch', '', false, \phpbb\request\request_interface::GET) == $mode) ||
1470              (isset($_GET['watch']) && $request->variable('watch', '', false, \phpbb\request\request_interface::GET) == $mode))
1471          {
1472              login_box();
1473          }
1474          else
1475          {
1476              $can_watch = 0;
1477              $is_watching = 0;
1478          }
1479      }
1480  
1481      if ($can_watch)
1482      {
1483          $s_watching['link'] = append_sid("{$phpbb_root_path}view$mode.$phpEx", "$u_url=$match_id&amp;" . (($is_watching) ? 'unwatch' : 'watch') . "=$mode&amp;start=$start&amp;hash=" . generate_link_hash("{$mode}_$match_id"));
1484          $s_watching['link_toggle'] = append_sid("{$phpbb_root_path}view$mode.$phpEx", "$u_url=$match_id&amp;" . ((!$is_watching) ? 'unwatch' : 'watch') . "=$mode&amp;start=$start&amp;hash=" . generate_link_hash("{$mode}_$match_id"));
1485          $s_watching['title'] = $user->lang[(($is_watching) ? 'STOP' : 'START') . '_WATCHING_' . strtoupper($mode)];
1486          $s_watching['title_toggle'] = $user->lang[((!$is_watching) ? 'STOP' : 'START') . '_WATCHING_' . strtoupper($mode)];
1487          $s_watching['is_watching'] = $is_watching;
1488      }
1489  
1490      return;
1491  }
1492  
1493  /**
1494  * Get user rank title and image
1495  *
1496  * @param array $user_data the current stored users data
1497  * @param int $user_posts the users number of posts
1498  *
1499  * @return array An associative array containing the rank title (title), the rank image as full img tag (img) and the rank image source (img_src)
1500  *
1501  * Note: since we do not want to break backwards-compatibility, this function will only properly assign ranks to guests if you call it for them with user_posts == false
1502  */
1503  function phpbb_get_user_rank($user_data, $user_posts)
1504  {
1505      global $ranks, $config, $phpbb_root_path, $phpbb_path_helper, $phpbb_dispatcher;
1506  
1507      $user_rank_data = array(
1508          'title'        => null,
1509          'img'        => null,
1510          'img_src'    => null,
1511      );
1512  
1513      /**
1514      * Preparing a user's rank before displaying
1515      *
1516      * @event core.modify_user_rank
1517      * @var    array    user_data        Array with user's data
1518      * @var    int        user_posts        User_posts to change
1519      * @since 3.1.0-RC4
1520      */
1521  
1522      $vars = array('user_data', 'user_posts');
1523      extract($phpbb_dispatcher->trigger_event('core.modify_user_rank', compact($vars)));
1524  
1525      if (empty($ranks))
1526      {
1527          global $cache;
1528          $ranks = $cache->obtain_ranks();
1529      }
1530  
1531      if (!empty($user_data['user_rank']))
1532      {
1533  
1534          $user_rank_data['title'] = (isset($ranks['special'][$user_data['user_rank']]['rank_title'])) ? $ranks['special'][$user_data['user_rank']]['rank_title'] : '';
1535  
1536          $user_rank_data['img_src'] = (!empty($ranks['special'][$user_data['user_rank']]['rank_image'])) ? $phpbb_path_helper->update_web_root_path($phpbb_root_path . $config['ranks_path'] . '/' . $ranks['special'][$user_data['user_rank']]['rank_image']) : '';
1537  
1538          $user_rank_data['img'] = (!empty($ranks['special'][$user_data['user_rank']]['rank_image'])) ? '<img src="' . $user_rank_data['img_src'] . '" alt="' . $ranks['special'][$user_data['user_rank']]['rank_title'] . '" title="' . $ranks['special'][$user_data['user_rank']]['rank_title'] . '" />' : '';
1539      }
1540      else if ($user_posts !== false)
1541      {
1542          if (!empty($ranks['normal']))
1543          {
1544              foreach ($ranks['normal'] as $rank)
1545              {
1546                  if ($user_posts >= $rank['rank_min'])
1547                  {
1548                      $user_rank_data['title'] = $rank['rank_title'];
1549                      $user_rank_data['img_src'] = (!empty($rank['rank_image'])) ? $phpbb_path_helper->update_web_root_path($phpbb_root_path . $config['ranks_path'] . '/' . $rank['rank_image']) : '';
1550                      $user_rank_data['img'] = (!empty($rank['rank_image'])) ? '<img src="' . $user_rank_data['img_src'] . '" alt="' . $rank['rank_title'] . '" title="' . $rank['rank_title'] . '" />' : '';
1551                      break;
1552                  }
1553              }
1554          }
1555      }
1556  
1557      return $user_rank_data;
1558  }
1559  
1560  /**
1561  * Prepare profile data
1562  */
1563  function phpbb_show_profile($data, $user_notes_enabled = false, $warn_user_enabled = false, $check_can_receive_pm = true)
1564  {
1565      global $config, $auth, $user, $phpEx, $phpbb_root_path, $phpbb_dispatcher;
1566  
1567      $username = $data['username'];
1568      $user_id = $data['user_id'];
1569  
1570      $user_rank_data = phpbb_get_user_rank($data, (($user_id == ANONYMOUS) ? false : $data['user_posts']));
1571  
1572      if ((!empty($data['user_allow_viewemail']) && $auth->acl_get('u_sendemail')) || $auth->acl_get('a_user'))
1573      {
1574          $email = ($config['board_email_form'] && $config['email_enable']) ? append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=email&amp;u=' . $user_id) : (($config['board_hide_emails'] && !$auth->acl_get('a_user')) ? '' : 'mailto:' . $data['user_email']);
1575      }
1576      else
1577      {
1578          $email = '';
1579      }
1580  
1581      if ($config['load_onlinetrack'])
1582      {
1583          $update_time = $config['load_online_time'] * 60;
1584          $online = (time() - $update_time < $data['session_time'] && ((isset($data['session_viewonline']) && $data['session_viewonline']) || $auth->acl_get('u_viewonline'))) ? true : false;
1585      }
1586      else
1587      {
1588          $online = false;
1589      }
1590  
1591      if ($data['user_allow_viewonline'] || $auth->acl_get('u_viewonline'))
1592      {
1593          $last_active = (!empty($data['session_time'])) ? $data['session_time'] : $data['user_lastvisit'];
1594      }
1595      else
1596      {
1597          $last_active = '';
1598      }
1599  
1600      $age = '';
1601  
1602      if ($config['allow_birthdays'] && $data['user_birthday'])
1603      {
1604          list($bday_day, $bday_month, $bday_year) = array_map('intval', explode('-', $data['user_birthday']));
1605  
1606          if ($bday_year)
1607          {
1608              $now = $user->create_datetime();
1609              $now = phpbb_gmgetdate($now->getTimestamp() + $now->getOffset());
1610  
1611              $diff = $now['mon'] - $bday_month;
1612              if ($diff == 0)
1613              {
1614                  $diff = ($now['mday'] - $bday_day < 0) ? 1 : 0;
1615              }
1616              else
1617              {
1618                  $diff = ($diff < 0) ? 1 : 0;
1619              }
1620  
1621              $age = max(0, (int) ($now['year'] - $bday_year - $diff));
1622          }
1623      }
1624  
1625      if (!function_exists('phpbb_get_banned_user_ids'))
1626      {
1627          include($phpbb_root_path . 'includes/functions_user.' . $phpEx);
1628      }
1629  
1630      // Can this user receive a Private Message?
1631      $can_receive_pm = $check_can_receive_pm && (
1632          // They must be a "normal" user
1633          $data['user_type'] != USER_IGNORE &&
1634  
1635          // They must not be deactivated by the administrator
1636          ($data['user_type'] != USER_INACTIVE || $data['user_inactive_reason'] != INACTIVE_MANUAL) &&
1637  
1638          // They must be able to read PMs
1639          sizeof($auth->acl_get_list($user_id, 'u_readpm')) &&
1640  
1641          // They must not be permanently banned
1642          !sizeof(phpbb_get_banned_user_ids($user_id, false)) &&
1643  
1644          // They must allow users to contact via PM
1645          (($auth->acl_gets('a_', 'm_') || $auth->acl_getf_global('m_')) || $data['user_allow_pm'])
1646      );
1647  
1648      // Dump it out to the template
1649      $template_data = array(
1650          'AGE'            => $age,
1651          'RANK_TITLE'    => $user_rank_data['title'],
1652          'JOINED'        => $user->format_date($data['user_regdate']),
1653          'LAST_ACTIVE'    => (empty($last_active)) ? ' - ' : $user->format_date($last_active),
1654          'POSTS'            => ($data['user_posts']) ? $data['user_posts'] : 0,
1655          'WARNINGS'        => isset($data['user_warnings']) ? $data['user_warnings'] : 0,
1656  
1657          'USERNAME_FULL'        => get_username_string('full', $user_id, $username, $data['user_colour']),
1658          'USERNAME'            => get_username_string('username', $user_id, $username, $data['user_colour']),
1659          'USER_COLOR'        => get_username_string('colour', $user_id, $username, $data['user_colour']),
1660          'U_VIEW_PROFILE'    => get_username_string('profile', $user_id, $username, $data['user_colour']),
1661  
1662          'A_USERNAME'        => addslashes(get_username_string('username', $user_id, $username, $data['user_colour'])),
1663  
1664          'AVATAR_IMG'        => phpbb_get_user_avatar($data),
1665          'ONLINE_IMG'        => (!$config['load_onlinetrack']) ? '' : (($online) ? $user->img('icon_user_online', 'ONLINE') : $user->img('icon_user_offline', 'OFFLINE')),
1666          'S_ONLINE'            => ($config['load_onlinetrack'] && $online) ? true : false,
1667          'RANK_IMG'            => $user_rank_data['img'],
1668          'RANK_IMG_SRC'        => $user_rank_data['img_src'],
1669          'S_JABBER_ENABLED'    => ($config['jab_enable']) ? true : false,
1670  
1671          'S_WARNINGS'    => ($auth->acl_getf_global('m_') || $auth->acl_get('m_warn')) ? true : false,
1672  
1673          'U_SEARCH_USER' => ($auth->acl_get('u_search')) ? append_sid("{$phpbb_root_path}search.$phpEx", "author_id=$user_id&amp;sr=posts") : '',
1674          'U_NOTES'        => ($user_notes_enabled && $auth->acl_getf_global('m_')) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=notes&amp;mode=user_notes&amp;u=' . $user_id, true, $user->session_id) : '',
1675          'U_WARN'        => ($warn_user_enabled && $auth->acl_get('m_warn')) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=warn&amp;mode=warn_user&amp;u=' . $user_id, true, $user->session_id) : '',
1676          'U_PM'            => ($config['allow_privmsg'] && $auth->acl_get('u_sendpm') && $can_receive_pm) ? append_sid("{$phpbb_root_path}ucp.$phpEx", 'i=pm&amp;mode=compose&amp;u=' . $user_id) : '',
1677          'U_EMAIL'        => $email,
1678          'U_JABBER'        => ($data['user_jabber'] && $auth->acl_get('u_sendim')) ? append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=contact&amp;action=jabber&amp;u=' . $user_id) : '',
1679  
1680          'USER_JABBER'        => ($config['jab_enable']) ? $data['user_jabber'] : '',
1681          'USER_JABBER_IMG'    => ($config['jab_enable'] && $data['user_jabber']) ? $user->img('icon_contact_jabber', $data['user_jabber']) : '',
1682  
1683          'L_SEND_EMAIL_USER' => $user->lang('SEND_EMAIL_USER', $username),
1684          'L_CONTACT_USER'    => $user->lang('CONTACT_USER', $username),
1685          'L_VIEWING_PROFILE' => $user->lang('VIEWING_PROFILE', $username),
1686      );
1687  
1688      /**
1689      * Preparing a user's data before displaying it in profile and memberlist
1690      *
1691      * @event core.memberlist_prepare_profile_data
1692      * @var    array    data                Array with user's data
1693      * @var    array    template_data        Template array with user's data
1694      * @since 3.1.0-a1
1695      */
1696      $vars = array('data', 'template_data');
1697      extract($phpbb_dispatcher->trigger_event('core.memberlist_prepare_profile_data', compact($vars)));
1698  
1699      return $template_data;
1700  }
1701  
1702  function phpbb_sort_last_active($first, $second)
1703  {
1704      global $id_cache, $sort_dir;
1705  
1706      $lesser_than = ($sort_dir === 'd') ? -1 : 1;
1707  
1708      if (isset($id_cache[$first]['group_leader']) && $id_cache[$first]['group_leader'] && (!isset($id_cache[$second]['group_leader']) || !$id_cache[$second]['group_leader']))
1709      {
1710          return -1;
1711      }
1712      else if (isset($id_cache[$second]['group_leader']) && (!isset($id_cache[$first]['group_leader']) || !$id_cache[$first]['group_leader']) && $id_cache[$second]['group_leader'])
1713      {
1714          return 1;
1715      }
1716      else
1717      {
1718          return $lesser_than * (int) ($id_cache[$first]['last_visit'] - $id_cache[$second]['last_visit']);
1719      }
1720  }


Generated: Sun Feb 19 19:52:41 2017 Cross-referenced by PHPXref 0.7.1