+ * functions_display.php

+function display_forums($left_id=0, $right_id=0)

+{

+ global $db, $template, $auth;

+

+ $where_sql = ($left_id && $right_id) ? " WHERE left_id > $left_id AND left_id < $right_id" : '';

+ $sql = 'SELECT * FROM ' . FORUMS_TABLE . $where_sql . ' ORDER BY left_id ASC';

+ $result = $db->sql_query($sql);

+

+ $cat_header =

+ while ($row = $db->sql_fetchrow($result))

+ {

+

+ }

+

+}

+

+function sql_escape($msg)

+ if (is_array($forum_id))

+ {

+ $forum_sql = 'AND a.forum_id IN (' . implode(', ', $forum_id) . ')';

+ }

+ else

+ {

+ $forum_sql = ( $forum_id ) ? 'AND a.forum_id = ' . $forum_id : '';

+ }

+ $sql = "SELECT a.forum_id, u.user_id, u.username

+ FROM " . ACL_OPTIONS_TABLE . " o, " . ACL_USERS_TABLE . " a, " . USERS_TABLE . " u

+ WHERE a.auth_option_id = o.auth_option_id

+ AND a.user_id = u.user_id

+ AND a.auth_allow_deny = 1

+ $sql = "SELECT a.forum_id, g.group_name, g.group_id

+ FROM " . ACL_OPTIONS_TABLE . " o, " . ACL_GROUPS_TABLE . " a, " . GROUPS_TABLE . " g

+ WHERE a.auth_option_id = o.auth_option_id

+ AND a.group_id = g.group_id

+ AND a.auth_allow_deny = 1

+ if (($current_time - $this->data['session_time'] > 60 || $this->data['session_page'] != $this->page) && $update)

+include($phpbb_root_path . 'includes/functions_display.' . $phpEx);

+display_forums(array(

+ 'forum_id' => 0,

+ 'left_id' => 0,

+ 'right_id' => 0

+));

+ <!-- ELSE -->

+ <td colspan="2" align="left" valign="bottom"><a class="maintitle" href="{U_VIEW_FORUM}">{FORUM_NAME}</a> <br /><span class="gensmall">

+ <!-- IF S_IS_POSTABLE -->

+ [ <a href="{U_VIEW_MODERATORS}">{L_VIEW_MODERATORS}</a> ] {MOD_CP}<br />

+ <!-- ENDIF -->

+ <br /><b>{LOGGED_IN_USER_LIST}</b></span></td>

+<!-- IF S_HAS_SUBFORUM -->

+<!-- INCLUDE viewforum_subforum.html -->

+<br /><br />

+<!-- ENDIF -->

+

+<!-- IF S_IS_POSTABLE -->

+<!-- ENDIF -->

+ <tr>

+ <th class="thCornerL" colspan="2" height="25" nowrap="nowrap">&nbsp;{L_FORUM}&nbsp;</th>

+ <th class="thTop" nowrap="nowrap">&nbsp;{L_LASTPOST}&nbsp;</th>

+ <th class="thCornerR">&nbsp;{L_MODERATORS}&nbsp;</th>

+ <td class="catLeft" colspan="2" height="28"><span class="cattitle"><a href="{forumrow.U_VIEWFORUM}" class="cattitle">{forumrow.FORUM_NAME}</a></span></td>

+ <td class="rowpic" colspan="4" align="right">&nbsp;</td>

+ <!-- ELSE -->

+ <td class="row2" align="center" valign="middle" height="50"><span class="gensmall">{forumrow.MODERATORS}</span></td>

+ SET forum_parents = '" . sql_escape(serialize($forum_parents)) . "'

+$template->assign_vars(array(

+ 'FORUM_ID' => $forum_id,

+ 'FORUM_NAME' => $forum_data['forum_name']

+));

+if ($forum_data['forum_postable'])

+ // Topic read tracking cookie info

+ $mark_topics = (isset($_COOKIE[$config['cookie_name'] . '_t'])) ? unserialize(stripslashes($_COOKIE[$config['cookie_name'] . '_t'])) : array();

+ $mark_forums = (isset($_COOKIE[$config['cookie_name'] . '_f'])) ? unserialize(stripslashes($_COOKIE[$config['cookie_name'] . '_f'])) : array();

+ // Handle marking posts

+ if ($mark_read == 'topics')

+ if ($user->data['user_id'] != ANONYMOUS)

+ $mark_forums[$forum_id] = time();

+ setcookie($config['cookie_name'] . '_f', serialize($mark_forums), 0, $config['cookie_path'], $config['cookie_domain'], $config['cookie_secure']);

+ $template->assign_vars(array(

+ 'META' => '<meta http-equiv="refresh" content="3;url=' . "viewforum.$phpEx$SID&amp;f=$forum_id" . '">')

+ );

+ $message = $user->lang['Topics_marked_read'] . '<br /><br />' . sprintf($user->lang['Click_return_forum'], '<a href="' . "viewforum.$phpEx$SID&amp;f=$forum_id" . '">', '</a> ');

+ trigger_error($message);

+ // End handle marking posts

+ // Do the forum Prune

+ if ($auth->acl_gets('m_prune', 'a_', $forum_id) && $config['prune_enable'])

+ if ($forum_data['prune_next'] < time() && $forum_data['prune_enable'])

+ {

+ require($phpbb_root_path . 'includes/functions_admin.'.$phpEx);

+ auto_prune($forum_id);

+ }

+ // End of forum prune

+ // Forum rules, subscription info and word censors

+ $s_watching_forum = '';

+ $s_watching_forum_img = '';

+ $notify_status = (isset($forum_data['notify_status'])) ? $forum_data['notify_status'] : NULL;

+ watch_topic_forum('forum', $s_watching_forum, $s_watching_forum_img, $user->data['user_id'], $forum_id, $notify_status);

+ $s_forum_rules = '';

+ get_forum_rules('forum', $s_forum_rules, $forum_id);

+ $orig_word = array();

+ $replacement_word = array();

+ obtain_word_list($orig_word, $replacement_word);

+ // Topic ordering options

+ $previous_days = array(0 => $user->lang['All_Topics'], 1 => $user->lang['1_Day'], 7 => $user->lang['7_Days'], 14 => $user->lang['2_Weeks'], 30 => $user->lang['1_Month'], 90 => $user->lang['3_Months'], 180 => $user->lang['6_Months'], 364 => $user->lang['1_Year']);

+ $sort_by_text = array('a' => $user->lang['Author'], 't' => $user->lang['Post_time'], 'r' => $user->lang['Replies'], 's' => $user->lang['Subject'], 'v' => $user->lang['Views']);

+ $sort_by = array('a' => 'u.username', 't' => 't.topic_last_post_id', 'r' => 't.topic_replies', 's' => 't.topic_title', 'v' => 't.topic_views');

+ if (isset($_POST['sort']))

+ if (!empty($_POST['sort_days']))

+ {

+ $sort_days = (!empty($_POST['sort_days'])) ? intval($_POST['sort_days']) : intval($_GET['sort_days']);

+ $min_topic_time = time() - ( $sort_days * 86400 );

+

+ //

+ // ref type on as rows as topics ... also not great

+ //

+ $sql = "SELECT COUNT(topic_id) AS forum_topics

+ FROM " . TOPICS_TABLE . "

+ WHERE forum_id = $forum_id

+ AND topic_last_post_time >= $min_topic_time";

+ $result = $db->sql_query($sql);

+

+ $start = 0;

+ $topics_count = ($row = $db->sql_fetchrow($result)) ? $row['forum_topics'] : 0;

+ $limit_topics_time = "AND t.topic_last_post_time >= $min_topic_time";

+ }

+ else

+ {

+ $topics_count = ($forum_data['forum_topics']) ? $forum_data['forum_topics'] : 1;

+ }

+ $sort_key = (isset($_POST['sort_key'])) ? $_POST['sort_key'] : $_GET['sort_key'];

+ $sort_dir = (isset($_POST['sort_dir'])) ? $_POST['sort_dir'] : $_GET['sort_dir'];

+ $limit_topics_time = '';

+ $sort_days = 0;

+ $sort_key = 't';

+ $sort_dir = 'd';

+ }

+ $sort_order = $sort_by[$sort_key] . ' ' . (($sort_dir == 'd') ? 'DESC' : 'ASC');

+ $select_sort_days = '<select name="sort_days">';

+ foreach ($previous_days as $day => $text)

+ {

+ $selected = ($sort_days == $day) ? ' selected="selected"' : '';

+ $select_sort_days .= '<option value="' . $day . '"' . $selected . '>' . $text . '</option>';

+ }

+ $select_sort_days .= '</select>';

+ $select_sort = '<select name="sort_key">';

+ foreach ($sort_by_text as $key => $text)

+ {

+ $selected = ($sort_key == $key) ? ' selected="selected"' : '';

+ $select_sort .= '<option value="' . $key . '"' . $selected . '>' . $text . '</option>';

+ }

+ $select_sort .= '</select>';

+ $select_sort_dir = '<select name="sort_dir">';

+ $select_sort_dir .= ($sort_dir == 'a') ? '<option value="a" selected="selected">' . $user->lang['Ascending'] . '</option><option value="d">' . $user->lang['Descending'] . '</option>' : '<option value="a">' . $user->lang['Ascending'] . '</option><option value="d" selected="selected">' . $user->lang['Descending'] . '</option>';

+ $select_sort_dir .= '</select>';

+ $post_alt = (intval($forum_data['forum_status']) == ITEM_LOCKED) ? 'Forum_locked' : 'Post_new_topic';

+ // Basic pagewide vars

+ $template->assign_vars(array(

+ 'S_IS_POSTABLE' => TRUE,

+ 'POST_IMG' => (intval($forum_data['forum_status']) == ITEM_LOCKED) ? $user->img('post_locked', $post_alt) : $user->img('post_new', $post_alt),

+ 'PAGINATION' => generate_pagination("viewforum.$phpEx$SID&amp;f=$forum_id&amp;topicdays=$topic_days", $topics_count, $config['topics_per_page'], $start),

+ 'PAGE_NUMBER' => sprintf($user->lang['Page_of'], (floor( $start / $config['topics_per_page'] ) + 1), ceil( $topics_count / $config['topics_per_page'] )),

+ 'MOD_CP' => ($auth->acl_gets('m_', 'a_', $forum_id)) ? sprintf($user->lang['MCP'], '<a href="modcp.' . $phpEx . $SID . '&amp;f=' . $forum_id . '">', '</a>') : '',

+

+ 'FOLDER_IMG' => $user->img('folder', 'No_new_posts'),

+ 'FOLDER_NEW_IMG' => $user->img('folder_new', 'New_posts'),

+ 'FOLDER_HOT_IMG' => $user->img('folder_hot', 'No_new_posts_hot'),

+ 'FOLDER_HOT_NEW_IMG' => $user->img('folder_hot_new', 'New_posts_hot'),

+ 'FOLDER_LOCKED_IMG' => $user->img('folder_locked', 'No_new_posts_locked'),

+ 'FOLDER_LOCKED_NEW_IMG' => $user->img('folder_locked_new', 'New_posts_locked'),

+ 'FOLDER_STICKY_IMG' => $user->img('folder_sticky', 'Post_Sticky'),

+ 'FOLDER_STICKY_NEW_IMG' => $user->img('folder_sticky_new', 'Post_Sticky'),

+ 'FOLDER_ANNOUNCE_IMG' => $user->img('folder_announce', 'Post_Announcement'),

+ 'FOLDER_ANNOUNCE_NEW_IMG' => $user->img('folder_announce_new', 'Post_Announcement'),

+

+ 'L_TOPICS' => $user->lang['Topics'],

+ 'L_REPLIES' => $user->lang['Replies'],

+ 'L_VIEWS' => $user->lang['Views'],

+ 'L_POSTS' => $user->lang['Posts'],

+ 'L_LASTPOST' => $user->lang['Last_Post'],

+ 'L_RATING' => $user->lang['Rating'],

+ 'L_VIEW_MODERATORS' => $user->lang['View_moderators'],

+ 'L_DISPLAY_TOPICS' => $user->lang['Display_topics'],

+ 'L_SORT_BY' => $user->lang['Sort_by'],

+ 'L_MARK_TOPICS_READ' => $user->lang['Mark_all_topics'],

+ 'L_NO_NEW_POSTS' => $user->lang['No_new_posts'],

+ 'L_NEW_POSTS' => $user->lang['New_posts'],

+ 'L_NO_NEW_POSTS_LOCKED' => $user->lang['No_new_posts_locked'],

+ 'L_NEW_POSTS_LOCKED' => $user->lang['New_posts_locked'],

+ 'L_NO_NEW_POSTS_HOT' => $user->lang['No_new_posts_hot'],

+ 'L_NEW_POSTS_HOT' => $user->lang['New_posts_hot'],

+ 'L_ANNOUNCEMENT' => $user->lang['Post_Announcement'],

+ 'L_STICKY' => $user->lang['Post_Sticky'],

+ 'L_POSTED' => $user->lang['Posted'],

+ 'L_JOINED' => $user->lang['Joined'],

+ 'L_AUTHOR' => $user->lang['Author'],

+ 'L_NO_TOPICS' => ( $forum_data['forum_status'] == FORUM_LOCKED ) ? $user->lang['Forum_locked'] : $user->lang['No_topics_post_one'],

+ 'L_GOTO_PAGE' => $user->lang['Goto_page'],

+

+ 'S_SELECT_SORT_DIR' => $select_sort_dir,

+ 'S_SELECT_SORT_KEY' => $select_sort,

+ 'S_SELECT_SORT_DAYS'=> $select_sort_days,

+ 'S_AUTH_LIST' => $s_forum_rules,

+ 'S_WATCH_FORUM' => $s_watching_forum,

+ 'S_FORUM_ACTION' => 'viewforum.' . $phpEx . $SID . '&amp;f=' . $forum_id . "&amp;start=$start",

+

+ 'U_POST_NEW_TOPIC' => 'posting.' . $phpEx . $SID . '&amp;mode=post&amp;f=' . $forum_id,

+ 'U_VIEW_MODERATORS' => 'memberslist.' . $phpEx . $SID . '&amp;mode=moderators&amp;f=' . $forum_id,

+ 'U_MARK_READ' => 'viewforum.' . $phpEx . $SID . '&amp;f=' . $forum_id . '&amp;mark=topics')

+ );

+

+ // Topic icons

+ $sql = "SELECT *

+ FROM " . ICONS_TABLE . "

+ WHERE icons_id > 1";

+ $result = $db->sql_query($sql);

+ $topic_icons = array();

+ if ($row = $db->sql_fetchrow($result))

+ {

+ do

+ {

+ $topic_icons[$row['icons_id']]['img'] = $row['icons_url'];

+ $topic_icons[$row['icons_id']]['width'] = $row['icons_width'];

+ $topic_icons[$row['icons_id']]['height'] = $row['icons_height'];

+ }

+ while ($row = $db->sql_fetchrow($result));

+ }

+ // Grab all the basic data. If we're not on page 1 we also grab any

+ // announcements that may exist.

+ $total_topics = 0;

+ $topic_rowset = array();

+ if ( $start )

+ $sql = "SELECT t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2

+ FROM " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . USERS_TABLE . " u2

+ WHERE t.forum_id = $forum_id

+ AND t.topic_type = " . POST_ANNOUNCE . "

+ AND u.user_id = t.topic_poster

+ AND u2.user_id = t.topic_last_poster_id

+ ORDER BY $sort_order

+ LIMIT " . $config['topics_per_page'];

+ $result = $db->sql_query($sql);

+ while( $row = $db->sql_fetchrow($result) )

+ {

+ $topic_rowset[] = $row;

+ $total_topics++;

+ }

+ $db->sql_freeresult($result);

+ }

+ AND t.topic_approved = 1

+ $limit_topics_time

+ ORDER BY t.topic_type DESC, $sort_order

+ LIMIT $start, " . $config['topics_per_page'];

+ // Okay, lets dump out the page ...

+ if ($total_topics)

+ for($i = 0; $i < $total_topics; $i++)

+ $topic_id = $topic_rowset[$i]['topic_id'];

+ // Type and folder

+ $topic_type = '';

+ if ($topic_rowset[$i]['topic_status'] == TOPIC_MOVED)

+ $topic_type = $user->lang['Topic_Moved'] . ' ';

+ $topic_id = $topic_rowset[$i]['topic_moved_id'];

+ $folder_image = 'folder';

+ $folder_alt = 'Topic_Moved';

+ $newest_post_img = '';

+ else

+ {

+ switch ($topic_rowset[$i]['topic_type'])

+ {

+ case POST_ANNOUNCE:

+ $topic_type = $user->lang['Topic_Announcement'] . ' ';

+ $folder = 'folder_announce';

+ $folder_new = 'folder_announce_new';

+ break;

+ case POST_STICKY:

+ $topic_type = $user->lang['Topic_Sticky'] . ' ';

+ $folder = 'folder_sticky';

+ $folder_new = 'folder_sticky_new';

+ break;

+ case ITEM_LOCKED:

+ $folder = 'folder_locked';

+ $folder_new = 'folder_locked_new';

+ break;

+ default:

+ if ($replies >= intval($config['hot_threshold']))

+ {

+ $folder = 'folder_hot';

+ $folder_new = 'folder_hot_new';

+ }

+ else

+ {

+ $folder = 'folder';

+ $folder_new = 'folder_new';

+ }

+ break;

+ }

+ $unread_topic = false;

+ if ($user->data['user_id'] && $topic_rowset[$i]['topic_last_post_time'] > $user->data['session_last_visit'])

+ {

+ $unread_topic = true;

+ }

+ $newest_post_img = ($unread_topic) ? '<a href="viewtopic.' . $phpEx . $SID . '&amp;t=' . $topic_id . '&amp;view=newest#newest">' . $user->img('goto_post_newest', 'View_newest_post') . '</a> ' : '';

+ $folder_img = ($unread_topic) ? $folder_new : $folder;

+ $folder_alt = ($unread_topic) ? 'New_posts' : (($topic_rowset[$i]['topic_status'] == ITEM_LOCKED) ? 'Topic_locked' : 'No_new_posts');

+ }

+ if (intval($topic_rowset[$i]['poll_start']))

+ {

+ $topic_type .= $user->lang['Topic_Poll'] . ' ';

+ }

+ $replies = $topic_rowset[$i]['topic_replies'];

+ // Goto message

+ if (($replies + 1 ) > intval($config['posts_per_page']))

+ $total_pages = ceil(($replies + 1) / intval($config['posts_per_page']));

+ $goto_page = ' [ ' . $user->img('goto_post', 'Goto_page') . $user->lang['Goto_page'] . ': ';

+

+ $times = 1;

+ for($j = 0; $j < $replies + 1; $j += intval($config['posts_per_page']))

+ $goto_page .= '<a href="viewtopic.' . $phpEx . $SID . '&amp;t=' . $topic_id . '&amp;start=' . $j . '">' . $times . '</a>';

+ if ($times == 1 && $total_pages > 4)

+ {

+ $goto_page .= ' ... ';

+ $times = $total_pages - 3;

+ $j += ($total_pages - 4) * intval($config['posts_per_page']);

+ }

+ else if ($times < $total_pages)

+ {

+ $goto_page .= ', ';

+ }

+ $times++;

+ $goto_page .= ' ] ';

+ }

+ else

+ {

+ $goto_page = '';

+ // Generate all the URIs ...

+ $view_topic_url = 'viewtopic.' . $phpEx . $SID . '&amp;f=' . $forum_id . '&amp;t=' . $topic_id;

+ $topic_author = ($topic_rowset[$i]['user_id'] != ANONYMOUS) ? '<a href="profile.' . $phpEx . $SID . '&amp;mode=viewprofile&amp;u=' . $topic_rowset[$i]['user_id'] . '">' : '';

+ $topic_author .= ($topic_rowset[$i]['user_id'] != ANONYMOUS) ? $topic_rowset[$i]['username'] : (($topic_rowset[$i]['topic_first_poster_name'] != '') ? $topic_rowset[$i]['topic_first_poster_name'] : $user->lang['Guest']);

+ $topic_author .= ($topic_rowset[$i]['user_id'] != ANONYMOUS) ? '</a>' : '';

+ $first_post_time = $user->format_date($topic_rowset[$i]['topic_time'], $config['board_timezone']);

+ $last_post_time = $user->format_date($topic_rowset[$i]['topic_last_post_time']);

+ $last_post_author = ($topic_rowset[$i]['id2'] == ANONYMOUS) ? (($topic_rowset[$i]['topic_last_poster_name'] != '') ? $topic_rowset[$i]['topic_last_poster_name'] . ' ' : $user->lang['Guest'] . ' ') : '<a href="profile.' . $phpEx . $SID . '&amp;mode=viewprofile&amp;u=' . $topic_rowset[$i]['topic_last_poster_id'] . '">' . $topic_rowset[$i]['user2'] . '</a>';

+ $last_post_url = '<a href="viewtopic.' . $phpEx . $SID . '&amp;f=' . $forum_id . '&amp;p=' . $topic_rowset[$i]['topic_last_post_id'] . '#' . $topic_rowset[$i]['topic_last_post_id'] . '">' . $user->img('goto_post_latest', 'View_latest_post') . '</a>';

+ // Send vars to template

+ $template->assign_block_vars('topicrow', array(

+ 'FORUM_ID' => $forum_id,

+ 'TOPIC_ID' => $topic_id,

+ 'TOPIC_FOLDER_IMG' => $user->img($folder_img, $folder_alt),

+ 'TOPIC_AUTHOR' => $topic_author,

+ 'NEWEST_POST_IMG' => $newest_post_img,

+ 'FIRST_POST_TIME' => $first_post_time,

+ 'LAST_POST_TIME' => $last_post_time,

+ 'LAST_POST_AUTHOR' => $last_post_author,

+ 'LAST_POST_IMG' => $last_post_url,

+ 'GOTO_PAGE' => $goto_page,

+ 'REPLIES' => $topic_rowset[$i]['topic_replies'],

+ 'VIEWS' => $topic_rowset[$i]['topic_views'],

+ 'TOPIC_TITLE' => (count($orig_word)) ? preg_replace($orig_word, $replacement_word, $topic_rowset[$i]['topic_title']) : $topic_rowset[$i]['topic_title'],

+ 'TOPIC_TYPE' => $topic_type,

+ 'TOPIC_ICON' => (!empty($topic_rowset[$i]['topic_icon']) ) ? '<img src="' . $config['icons_path'] . '/' . $topic_icons[$topic_rowset[$i]['topic_icon']]['img'] . '" width="' . $topic_icons[$topic_rowset[$i]['topic_icon']]['width'] . '" height="' . $topic_icons[$topic_rowset[$i]['topic_icon']]['height'] . '" alt="" title="" />' : '',

+ 'TOPIC_RATING' => (!empty($topic_rowset[$i]['topic_rating'])) ? '<img src=' . str_replace('{RATE}', $topic_rowset[$i]['topic_rating'], $theme['rating']) . ' alt="' . $topic_rowset[$i]['topic_rating'] . '" title="' . $topic_rowset[$i]['topic_rating'] . '" />' : '',

+ 'S_ROW_COUNT' => $i,

+ 'U_VIEW_TOPIC' => $view_topic_url)

+ );

+ }

+ if ($user->data['user_id'] != ANONYMOUS)

+ {

+ setcookie($config['cookie_name'] . '_t', serialize($mark_topics), 0, $config['cookie_path'], $config['cookie_domain'], $config['cookie_secure']);

+ }

+ include($phpbb_root_path . 'includes/functions_display.' . $phpEx);

+ display_forums($forum_data);