[ Index ]

PHP Cross Reference of phpBB 3.0 Beta 3

title

Body

[close]

/includes/mcp/ -> mcp_forum.php (source)

   1  <?php
   2  /** 
   3  *
   4  * @package mcp
   5  * @version $Id: mcp_forum.php,v 1.22 2006/11/12 15:35:43 acydburn Exp $
   6  * @copyright (c) 2005 phpBB Group 
   7  * @license http://opensource.org/licenses/gpl-license.php GNU Public License 
   8  *
   9  */
  10  
  11  /**
  12  * MCP Forum View
  13  */
  14  function mcp_forum_view($id, $mode, $action, $forum_info)
  15  {
  16      global $template, $db, $user, $auth, $cache;
  17      global $phpEx, $phpbb_root_path, $config;
  18  
  19      include_once($phpbb_root_path . 'includes/functions_display.' . $phpEx);
  20  
  21      $url = append_sid("{$phpbb_root_path}mcp.$phpEx?" . extra_url());
  22  
  23      if ($action == 'merge_select')
  24      {
  25          // Fixes a "bug" that makes forum_view use the same ordering as topic_view
  26          unset($_POST['sk'], $_POST['sd'], $_REQUEST['sk'], $_REQUEST['sd']);
  27      }
  28  
  29      $forum_id        = $forum_info['forum_id'];
  30      $start            = request_var('start', 0);
  31      $topic_id_list    = request_var('topic_id_list', array(0));
  32      $post_id_list    = request_var('post_id_list', array(0));
  33      $topic_id        = request_var('t', 0);
  34  
  35      // Resync Topics
  36      if ($action == 'resync')
  37      {
  38          $topic_ids = request_var('topic_id_list', array(0));
  39  
  40          mcp_resync_topics($topic_ids);
  41      }
  42  
  43      $selected_ids = '';
  44      if (sizeof($post_id_list))
  45      {
  46          foreach ($post_id_list as $num => $post_id)
  47          {
  48              $selected_ids .= '&amp;post_id_list[' . $num . ']=' . $post_id;
  49          }
  50      }
  51  
  52      make_jumpbox($url . "&amp;i=$id&amp;action=$action&amp;mode=$mode", $forum_id . (($action == 'merge_select') ? $selected_ids : ''), false, 'm_');
  53  
  54      $topics_per_page = ($forum_info['forum_topics_per_page']) ? $forum_info['forum_topics_per_page'] : $config['topics_per_page'];
  55  
  56      $sort_days = $total = 0;
  57      $sort_key = $sort_dir = '';
  58      $sort_by_sql = $sort_order_sql = array();
  59      mcp_sorting('viewforum', $sort_days, $sort_key, $sort_dir, $sort_by_sql, $sort_order_sql, $total, $forum_id);
  60  
  61      $forum_topics = ($total == -1) ? $forum_info['forum_topics'] : $total;
  62      $limit_time_sql = ($sort_days) ? 'AND t.topic_last_post_time >= ' . (time() - ($sort_days * 86400)) : '';
  63  
  64      $template->assign_vars(array(
  65          'FORUM_NAME'            => $forum_info['forum_name'],
  66          'FORUM_DESCRIPTION'        => generate_text_for_display($forum_info['forum_desc'], $forum_info['forum_desc_uid'], $forum_info['forum_desc_bitfield'], $forum_info['forum_desc_options']),
  67  
  68          'REPORTED_IMG'            => $user->img('icon_topic_reported', 'TOPIC_REPORTED'),
  69          'UNAPPROVED_IMG'        => $user->img('icon_topic_unapproved', 'TOPIC_UNAPPROVED'),
  70  
  71          'S_CAN_DELETE'            => $auth->acl_get('m_delete', $forum_id),
  72          'S_CAN_MOVE'            => $auth->acl_get('m_move', $forum_id),
  73          'S_CAN_FORK'            => $auth->acl_get('m_', $forum_id),
  74          'S_CAN_LOCK'            => $auth->acl_get('m_lock', $forum_id),
  75          'S_CAN_SYNC'            => $auth->acl_get('m_', $forum_id),
  76          'S_CAN_APPROVE'            => $auth->acl_get('m_approve', $forum_id),
  77          'S_MERGE_SELECT'        => ($action == 'merge_select') ? true : false,
  78  
  79          'U_VIEW_FORUM'            => append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $forum_id),
  80          'U_VIEW_FORUM_LOGS'        => ($auth->acl_gets('a_', 'm_', $forum_id)) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=logs&amp;mode=forum_logs&amp;f=' . $forum_id) : '',
  81  
  82          'S_MCP_ACTION'            => $url . "&amp;i=$id&amp;action=$action&amp;mode=$mode&amp;start=$start" . (($action == 'merge_select') ? $selected_ids : ''),
  83  
  84          'PAGINATION'            => generate_pagination($url . "&amp;i=$id&amp;action=$action&amp;mode=$mode" . (($action == 'merge_select') ? $selected_ids : ''), $forum_topics, $topics_per_page, $start),
  85          'PAGE_NUMBER'            => on_page($forum_topics, $topics_per_page, $start),
  86          'TOTAL'                    => $forum_topics)
  87      );
  88  
  89      // Grab icons
  90      $icons = $cache->obtain_icons();
  91  
  92      $topic_rows = array();
  93  
  94      $sql = 'SELECT t.*
  95          FROM ' . TOPICS_TABLE . " t
  96          WHERE (t.forum_id = $forum_id OR t.forum_id = 0)
  97              " . (($auth->acl_get('m_approve', $forum_id)) ? '' : 'AND t.topic_approved = 1') . "
  98              $limit_time_sql
  99          ORDER BY t.topic_type DESC, $sort_order_sql";
 100      $result = $db->sql_query_limit($sql, $topics_per_page, $start);
 101  
 102      while ($row = $db->sql_fetchrow($result))
 103      {
 104          $topic_rows[] = $row;
 105      }
 106      $db->sql_freeresult($result);
 107  
 108      foreach ($topic_rows as $row)
 109      {
 110          $topic_title = '';
 111  
 112          $replies = ($auth->acl_get('m_approve', $forum_id)) ? $row['topic_replies_real'] : $row['topic_replies'];
 113  
 114          // Get folder img, topic status/type related informations
 115          $folder_img = $folder_alt = $topic_type = '';
 116          topic_status($row, $replies, false, $folder_img, $folder_alt, $topic_type);
 117  
 118          $topic_title = censor_text($row['topic_title']);
 119  
 120          $topic_unapproved = (!$row['topic_approved'] && $auth->acl_get('m_approve', $row['forum_id'])) ? true : false;
 121          $posts_unapproved = ($row['topic_approved'] && $row['topic_replies'] < $row['topic_replies_real'] && $auth->acl_get('m_approve', $row['forum_id'])) ? true : false;
 122          $u_mcp_queue = ($topic_unapproved || $posts_unapproved) ? $url . '&amp;i=queue&amp;mode=' . (($topic_unapproved) ? 'approve_details' : 'unapproved_posts') . '&amp;t=' . $row['topic_id'] : '';
 123  
 124          $template->assign_block_vars('topicrow', array(
 125              'U_VIEW_TOPIC'        => append_sid("{$phpbb_root_path}mcp.$phpEx", "i=$id&amp;f=$forum_id&amp;t={$row['topic_id']}&amp;mode=topic_view"),
 126  
 127              'S_SELECT_TOPIC'    => ($action == 'merge_select' && $row['topic_id'] != $topic_id) ? true : false,
 128              'U_SELECT_TOPIC'    => $url . "&amp;i=$id&amp;mode=topic_view&amp;action=merge&amp;to_topic_id=" . $row['topic_id'] . $selected_ids,
 129              'U_MCP_QUEUE'        => $u_mcp_queue,
 130              'U_MCP_REPORT'        => append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=main&amp;mode=topic_view&amp;t=' . $row['topic_id'] . '&amp;action=reports'),
 131  
 132              'ATTACH_ICON_IMG'        => ($auth->acl_get('u_download') && $auth->acl_get('f_download', $row['forum_id']) && $row['topic_attachment']) ? $user->img('icon_topic_attach', $user->lang['TOTAL_ATTACHMENTS']) : '',
 133              'TOPIC_FOLDER_IMG'        => $user->img($folder_img, $folder_alt),
 134              'TOPIC_FOLDER_IMG_SRC'    => $user->img($folder_img, $folder_alt, false, '', 'src'),
 135              'TOPIC_ICON_IMG'        => (!empty($icons[$row['icon_id']])) ? $icons[$row['icon_id']]['img'] : '',
 136              'TOPIC_ICON_IMG_WIDTH'    => (!empty($icons[$row['icon_id']])) ? $icons[$row['icon_id']]['width'] : '',
 137              'TOPIC_ICON_IMG_HEIGHT'    => (!empty($icons[$row['icon_id']])) ? $icons[$row['icon_id']]['height'] : '',
 138              'UNAPPROVED_IMG'        => ($topic_unapproved || $posts_unapproved) ? $user->img('icon_topic_unapproved', ($topic_unapproved) ? 'TOPIC_UNAPPROVED' : 'POSTS_UNAPPROVED') : '',
 139  
 140              'TOPIC_TYPE'        => $topic_type,
 141              'TOPIC_TITLE'        => $topic_title,
 142              'REPLIES'            => ($auth->acl_get('m_approve', $row['forum_id'])) ? $row['topic_replies_real'] : $row['topic_replies'],
 143              'LAST_POST_TIME'    => $user->format_date($row['topic_last_post_time']),
 144              'TOPIC_ID'            => $row['topic_id'],
 145              'S_TOPIC_CHECKED'    => ($topic_id_list && in_array($row['topic_id'], $topic_id_list)) ? 'checked="checked" ' : '',
 146  
 147              'S_TOPIC_REPORTED'        => (!empty($row['topic_reported']) && $auth->acl_get('m_report', $row['forum_id'])) ? true : false,
 148              'S_TOPIC_UNAPPROVED'    => $topic_unapproved,
 149              'S_POSTS_UNAPPROVED'    => $posts_unapproved)
 150          );
 151      }
 152      unset($topic_rows);
 153  }
 154  
 155  /**
 156  * Resync topics
 157  */
 158  function mcp_resync_topics($topic_ids)
 159  {
 160      global $auth, $db, $template, $phpEx, $user, $phpbb_root_path;
 161  
 162      if (!($forum_id = check_ids($topic_ids, TOPICS_TABLE, 'topic_id', 'm_')))
 163      {
 164          return;
 165      }
 166  
 167      if (!sizeof($topic_ids))
 168      {
 169          trigger_error($user->lang['NO_TOPIC_SELECTED']);
 170          return;
 171      }
 172  
 173      // Sync everything and perform extra checks separately
 174      sync('topic_reported', 'topic_id', $topic_ids, false, true);
 175      sync('topic_attachment', 'topic_id', $topic_ids, false, true);
 176      sync('topic', 'topic_id', $topic_ids, true, false);
 177  
 178      $sql = 'SELECT topic_id, forum_id, topic_title
 179          FROM ' . TOPICS_TABLE . '
 180          WHERE ' . $db->sql_in_set('topic_id', $topic_ids);
 181      $result = $db->sql_query($sql);
 182  
 183      // Log this action
 184      while ($row = $db->sql_fetchrow($result))
 185      {
 186          add_log('mod', $row['forum_id'], $row['topic_id'], 'LOG_TOPIC_RESYNC', $row['topic_title']);
 187      }
 188      $db->sql_freeresult($result);
 189  
 190      $msg = (sizeof($topic_ids) == 1) ? $user->lang['TOPIC_RESYNC_SUCCESS'] : $user->lang['TOPICS_RESYNC_SUCCESS'];
 191  
 192      $redirect = request_var('redirect', $user->data['session_page']);
 193  
 194      meta_refresh(3, $redirect);
 195      trigger_error($msg . '<br /><br />' . sprintf($user->lang['RETURN_PAGE'], '<a href="' . $redirect . '">', '</a>'));
 196  
 197      return;
 198  }
 199  
 200  ?>


Generated: Wed Nov 22 00:35:05 2006 Cross-referenced by PHPXref 0.6