$l_title = 'ACP_ORPHAN_ATTACHMENTS';

break;

default:

trigger_error('NO_MODE', E_USER_ERROR);

break;

$db->sql_freeresult($result);

break;

}

if (sizeof($error))

{

if ($group_id)

{

AND ug.user_pending = 0

AND u.user_id = ug.user_id

AND u.user_allow_massemail = 1

}

else

{

}

}

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

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

{

// skip images where add wasn't checked

}

else

{

if ($image_width[$image] == 0 || $image_height[$image] == 0)

$i = 0;

while ($row = ($buffer ? $rows[$i++] : $db->sql_fetchrow($result)))

{

{

$this->search->index('post', $row['post_id'], $row['post_text'], $row['post_subject'], $row['poster_id'], $row['forum_id']);

}

$bitfield->set(9);

$bitfield->set(11);

$bitfield->set(12);

unset($bitfield);

$user->add_lang('acp/styles');

}

else

{

}

// We set a pre-defined bitfield here which we may use further in 3.2

'attach' => array('title' => 'ACP_ATTACHMENT_SETTINGS', 'auth' => 'acl_a_attach', 'cat' => array('ACP_BOARD_CONFIGURATION', 'ACP_ATTACHMENTS')),

'extensions' => array('title' => 'ACP_MANAGE_EXTENSIONS', 'auth' => 'acl_a_attach', 'cat' => array('ACP_ATTACHMENTS')),

'ext_groups' => array('title' => 'ACP_EXTENSION_GROUPS', 'auth' => 'acl_a_attach', 'cat' => array('ACP_ATTACHMENTS')),

),

);

}

*/

function _fill_acl($user_permissions)

{

$this->acl = array();

$user_permissions = explode("\n", $user_permissions);

while ($subseq = substr($seq, $i, 6))

{

// We put the original bitstring into the acl array

$i += 6;

}

}

'max_filesize' => (int) $row['max_filesize'],

'allow_group' => $row['allow_group'],

'allow_in_pm' => $row['allow_in_pm'],

);

$allowed_forums = ($row['allowed_forums']) ? unserialize(trim($row['allowed_forums'])) : array();

*/

class phpbb_recaptcha extends phpbb_default_captcha

{

var $challenge;

var $response;

return $user->lang['RECAPTCHA_INCORRECT'];

}

array(

'privatekey' => $config['recaptcha_privkey'],

'remoteip' => $user->ip,

}

/**

* Sets a configuration option's value

*

*/

{

$this->config[$key] = $value;

}

*

* @param string $key The configuration option's name

* @param string $old_value Current configuration value

* changes too frequently to be efficiently cached.

* @return bool True if the value was changed, false otherwise.

*/

{

if (!isset($this->config[$key]) || $this->config[$key] == $old_value)

{

return true;

}

return false;

*

* @param string $key The configuration option's name

* @param int $increment Amount to increment by

* changes too frequently to be efficiently cached.

*/

{

if (!isset($this->config[$key]))

{

}

/**

* Sets a configuration option's value

*

*/

{

}

/**

* @param mixed $old_value Current configuration value or false to ignore

* the old value

* @param string $new_value New configuration value

* changes too frequently to be efficiently cached

* @return bool True if the value was changed, false otherwise

*/

{

$sql = 'UPDATE ' . $this->table . "

SET config_value = '" . $this->db->sql_escape($new_value) . "'

$sql = 'INSERT INTO ' . $this->table . ' ' . $this->db->sql_build_array('INSERT', array(

'config_name' => $key,

'config_value' => $new_value,

$this->db->sql_query($sql);

}

{

$this->cache->destroy('config');

}

*

* @param string $key The configuration option's name

* @param int $increment Amount to increment by

* changes too frequently to be efficiently cached.

*/

{

if (!isset($this->config[$key]))

{

}

$sql_update = $this->db->cast_expr_to_string($this->db->cast_expr_to_bigint('config_value') . ' + ' . (int) $increment);

SET config_value = ' . $sql_update . "

WHERE config_name = '" . $this->db->sql_escape($key) . "'");

{

$this->cache->destroy('config');

}

{

foreach ($columns as $column_name => $column_data)

{

if ($column_exists = $this->sql_column_exists($table, $column_name))

{

}

else

{

{

if ($column_exists)

{

}

else

{

{

foreach ($indexes as $index_name)

{

$result = $this->sql_index_drop($table, $index_name);

if ($this->return_statements)

{

foreach ($index_array as $index_name => $column)

{

$result = $this->sql_create_unique_index($table, $index_name, $column);

if ($this->return_statements)

{

foreach ($index_array as $index_name => $column)

{

$result = $this->sql_create_index($table, $index_name, $column);

if ($this->return_statements)

}

/**

* Private method for performing sql statements (either execute them or return them)

* @access private

*/

switch ($this->sql_layer)

{

case 'firebird':

$statements[] = 'ALTER TABLE ' . $table_name . ' ADD "' . strtoupper($column_name) . '" ' . $column_data['column_type_sql'];

break;

case 'mssql':

case 'mssqlnative':

$statements[] = 'ALTER TABLE [' . $table_name . '] ADD [' . $column_name . '] ' . $column_data['column_type_sql_default'];

break;

case 'mysql_40':

case 'mysql_41':

break;

case 'oracle':

$statements[] = 'ALTER TABLE ' . $table_name . ' ADD ' . $column_name . ' ' . $column_data['column_type_sql'];

break;

case 'postgres':

if (version_compare($this->db->sql_server_info(true), '8.0', '>='))

{

$statements[] = 'ALTER TABLE ' . $table_name . ' ADD COLUMN "' . $column_name . '" ' . $column_data['column_type_sql'];

}

else

{

$statements[] = 'ALTER TABLE ' . $table_name . ' ALTER COLUMN "' . strtoupper($column_name) . '" TYPE ' . ' ' . $column_data['column_type_sql_type'];

}

break;

*/

function cast_expr_to_bigint($expression)

{

}

/**

{

$mark_time = array();

if (!empty($forum_mark_time[$forum_id]) && $forum_mark_time[$forum_id] !== false)

{

$mark_time[$forum_id] = $forum_mark_time[$forum_id];

foreach ($topic_ids as $topic_id)

{

}

}

*/

function get_complete_topic_tracking($forum_id, $topic_ids, $global_announce_list = false)

{

$last_read = array();

$sql = 'SELECT forum_id, mark_time

FROM ' . FORUMS_TRACK_TABLE . "

WHERE user_id = {$user->data['user_id']}

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

$mark_time = array();

foreach ($topic_ids as $topic_id)

{

}

}

}

if (sizeof($topic_ids))

{

$mark_time = array();

if (isset($tracking_topics['f'][$forum_id]))

{

foreach ($topic_ids as $topic_id)

{

}

}

}

*/

function update_forum_tracking_info($forum_id, $forum_last_post_time, $f_mark_time = false, $mark_time_forum = false)

{

// Determine the users last forum mark time if not given.

if ($mark_time_forum === false)

/**

* Generate board url (example: http://www.example.com/phpBB)

* @param bool $without_script_path if set to true the script path gets not appended (example: http://www.example.com)

*/

function generate_board_url($without_script_path = false)

{

if (!($prune_flags & FORUM_FLAG_PRUNE_ANNOUNCE))

{

$sql_and .= ' AND topic_type <> ' . POST_ANNOUNCE;

}

if (!($prune_flags & FORUM_FLAG_PRUNE_STICKY))

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

{

{

}

if ($auth->acl_gets('a_', 'm_', $row['forum_id']))

$forum_tracking_info = array();

$branch_root_id = $root_data['forum_id'];

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

{

$forum_id = $row['forum_id'];

}

else

{

markread('topics', $forum_ids);

$message = sprintf($user->lang['RETURN_FORUM'], '<a href="' . $redirect . '">', '</a>');

}

$forum_unread = (isset($forum_tracking_info[$forum_id]) && $row['orig_forum_last_post_time'] > $forum_tracking_info[$forum_id]) ? true : false;

$folder_image = $folder_alt = $l_subforums = '';

$subforums_list = array();

'SUBFORUMS' => $s_subforums_list,

'L_SUBFORUM_STR' => $l_subforums,

'L_MODERATOR_STR' => $l_moderator,

'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']) : '',

*/

function generate_smilies($mode, $forum_id)

{

global $phpEx, $phpbb_root_path;

$start = request_var('start', 0);

$topic_type_array[] = array(

'VALUE' => $topic_value['const'],

'L_TOPIC_TYPE' => $user->lang[$topic_value['lang']]

);

}

if ($type !== false)

{

// Type is one of the IMAGETYPE constants - it is fetched from getimagesize()

switch ($type)

{

// GIF

*/

function posting_gen_attachment_entry($attachment_data, &$filename_data, $show_attach_box = true)

{

// Some default template variables

$template->assign_vars(array(

delete_topics('topic_id', array($topic_id), false);

$update_sql = update_post_information('forum', $forum_id, true);

if (sizeof($update_sql))

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

$db->sql_freeresult($result);

$sql_data[TOPICS_TABLE] = 'topic_poster = ' . intval($row['poster_id']) . ', topic_first_post_id = ' . intval($row['post_id']) . ", topic_first_poster_colour = '" . $db->sql_escape($row['user_colour']) . "', topic_first_poster_name = '" . (($row['poster_id'] == ANONYMOUS) ? $db->sql_escape($row['post_username']) : $db->sql_escape($row['username'])) . "', topic_time = " . (int) $row['post_time'];

break;

case 'delete_last_post':

$update_sql = update_post_information('forum', $forum_id, true);

if (sizeof($update_sql))

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

$db->sql_freeresult($result);

$sql_data[TOPICS_TABLE] = 'topic_replies_real = topic_replies_real - 1' . (($data['post_approved']) ? ', topic_replies = topic_replies - 1' : '');

$next_post_id = (int) $row['post_id'];

case 'post':

case 'reply':

$sql_data[POSTS_TABLE]['sql'] = array(

'poster_id' => (int) $user->data['user_id'],

'icon_id' => $data['icon_id'],

'poster_ip' => $user->ip,

}

$sql_data[POSTS_TABLE]['sql'] = array_merge($sql_data[POSTS_TABLE]['sql'], array(

'poster_id' => $data['poster_id'],

'icon_id' => $data['icon_id'],

'post_approved' => (!$post_approval) ? 0 : $data['post_approved'],

'topic_poster' => (int) $user->data['user_id'],

'topic_time' => $current_time,

'topic_last_view_time' => $current_time,

'icon_id' => $data['icon_id'],

'topic_approved' => $post_approval,

'topic_title' => $subject,

$sql_data[USERS_TABLE]['stat'][] = "user_lastpost_time = $current_time" . (($auth->acl_get('f_postcount', $data['forum_id']) && $post_approval) ? ', user_posts = user_posts + 1' : '');

{

}

break;

case 'reply':

$sql_data[USERS_TABLE]['stat'][] = "user_lastpost_time = $current_time" . (($auth->acl_get('f_postcount', $data['forum_id']) && $post_approval) ? ', user_posts = user_posts + 1' : '');

{

$sql_data[FORUMS_TABLE]['stat'][] = 'forum_posts = forum_posts + 1';

}

}

$sql_data[TOPICS_TABLE]['sql'] = array(

'icon_id' => $data['icon_id'],

'topic_approved' => (!$post_approval) ? 0 : $data['topic_approved'],

'topic_title' => $subject,

unset($sql_data[POSTS_TABLE]['sql']);

}

// Update the topics table

if (isset($sql_data[TOPICS_TABLE]['sql']))

{

}

// we need to update the last forum information

{

// the last post makes us update the forum table. This can happen if...

// We make a new topic

}

}

}

// topic sync time!

// simply, we update if it is a reply or the last post is edited

}

// Delete topic shadows (if any exist). We do not need a shadow topic for an global announcement

{

$sql = 'DELETE FROM ' . TOPICS_TABLE . '

WHERE topic_moved_id = ' . $data['topic_id'];

trigger_error($error);

}

}

// Topic Notification, do not change if moderator is changing other users posts...

// Mark this topic as read

// We do not use post_time here, this is intended (post_time can have a date in the past if editing a message)

//

if ($config['load_db_lastread'] && $user->data['is_registered'])

$sql = 'SELECT mark_time

FROM ' . FORUMS_TRACK_TABLE . '

WHERE user_id = ' . $user->data['user_id'] . '

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

$f_mark_time = (int) $db->sql_fetchfield('mark_time');

$db->sql_freeresult($result);

if (($config['load_db_lastread'] && $user->data['is_registered']) || $config['load_anon_lastread'] || $user->data['is_registered'])

{

// Update forum info

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

$forum_last_post_time = (int) $db->sql_fetchfield('forum_last_post_time');

$db->sql_freeresult($result);

}

// Send Notifications

// Is the designer wanting to call another loop in a loop?

if (strpos($tag_args, '!') === 0)

{

$no_nesting = substr_count($tag_args, '!');

$tag_args = substr($tag_args, $no_nesting);

}

}

else

{

}

}

}

// Make sure we have been given someone to ban

if (!sizeof($sql_usernames))

{

}

$sql = 'SELECT user_id

else

{

$db->sql_freeresult($result);

}

$db->sql_freeresult($result);

break;

if (empty($banlist_ary))

{

}

}

break;

if (sizeof($ban_list) == 0)

{

}

break;

default:

break;

}

$read_tracking_join = $read_tracking_select = '';

}

$limit_time_sql

ORDER BY t.topic_type DESC, $sort_order_sql";

$result = $db->sql_query_limit($sql, $topics_per_page, $start);

{

if ($config['load_db_lastread'])

{

}

else

{

}

}

{

$sql = 'SELECT COUNT(post_id) AS total

FROM ' . POSTS_TABLE . '

AND post_approved = 0';

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

$total = (int) $db->sql_fetchfield('total');

if ($total)

{

$sql = 'SELECT forum_id, forum_name

FROM ' . FORUMS_TABLE . '

WHERE ' . $db->sql_in_set('forum_id', $forum_list);

$sql = 'SELECT post_id

FROM ' . POSTS_TABLE . '

AND post_approved = 0

ORDER BY post_time DESC';

$result = $db->sql_query_limit($sql, 5);

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

{

$template->assign_block_vars('unapproved', array(

'U_POST_DETAILS' => append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=queue&amp;mode=approve_details&amp;f=' . $row['forum_id'] . '&amp;p=' . $row['post_id']),

'U_MCP_TOPIC' => append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=main&amp;mode=topic_view&amp;f=' . $row['forum_id'] . '&amp;t=' . $row['topic_id']),

'U_TOPIC' => append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $row['forum_id'] . '&amp;t=' . $row['topic_id']),

'AUTHOR_FULL' => get_username_string('full', $row['poster_id'], $row['username'], $row['user_colour']),

'AUTHOR_COLOUR' => get_username_string('colour', $row['poster_id'], $row['username'], $row['user_colour']),

'U_AUTHOR' => get_username_string('profile', $row['poster_id'], $row['username'], $row['user_colour']),

'POST_ID' => $row['post_id'],

'TOPIC_TITLE' => $row['topic_title'],

'SUBJECT' => ($row['post_subject']) ? $row['post_subject'] : $user->lang['NO_SUBJECT'],

WHERE r.post_id = p.post_id

AND r.pm_id = 0

AND r.report_closed = 0

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

$total = (int) $db->sql_fetchfield('total');

$db->sql_freeresult($result);

if ($total)

{

$sql = $db->sql_build_query('SELECT', array(

'SELECT' => 'r.report_time, p.post_id, p.post_subject, p.post_time, u.username, u.username_clean, u.user_colour, u.user_id, u2.username as author_name, u2.username_clean as author_name_clean, u2.user_colour as author_colour, u2.user_id as author_id, t.topic_id, t.topic_title, f.forum_id, f.forum_name',

AND p.topic_id = t.topic_id

AND r.user_id = u.user_id

AND p.poster_id = u2.user_id

'ORDER_BY' => 'p.post_time DESC'

));

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

{

$template->assign_block_vars('report', array(

'U_POST_DETAILS' => append_sid("{$phpbb_root_path}mcp.$phpEx", 'f=' . $row['forum_id'] . '&amp;p=' . $row['post_id'] . "&amp;i=reports&amp;mode=report_details"),

'U_MCP_TOPIC' => append_sid("{$phpbb_root_path}mcp.$phpEx", 'f=' . $row['forum_id'] . '&amp;t=' . $row['topic_id'] . "&amp;i=$id&amp;mode=topic_view"),

'U_TOPIC' => append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $row['forum_id'] . '&amp;t=' . $row['topic_id']),

'REPORTER_FULL' => get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']),

'AUTHOR_COLOUR' => get_username_string('colour', $row['author_id'], $row['author_name'], $row['author_colour']),

'U_AUTHOR' => get_username_string('profile', $row['author_id'], $row['author_name'], $row['author_colour']),

'TOPIC_TITLE' => $row['topic_title'],

'SUBJECT' => ($row['post_subject']) ? $row['post_subject'] : $user->lang['NO_SUBJECT'],

'REPORT_TIME' => $user->format_date($row['report_time']),

if (!empty($forum_list))

{

$log_count = false;

$log = array();

view_log('mod', $log, $log_count, 5, 0, $forum_list);

if (confirm_box(true))

{

{

$sql = 'UPDATE ' . TOPICS_TABLE . "

SET topic_type = $new_topic_type

$db->sql_query($sql);

}

$success_msg = (sizeof($topic_ids) == 1) ? 'TOPIC_TYPE_CHANGED' : 'TOPICS_TYPE_CHANGED';

}

else

{

}

$redirect = request_var('redirect', "index.$phpEx");

$topic_posts_added += $topic_info['topic_replies'];

}

}

$forum_ids[] = $row['forum_id'];

add_log('mod', $to_forum_id, $topic_id, 'LOG_MOVE', $row['forum_name'], $forum_data['forum_name']);

// Leave a redirection if required and only if the topic is visible to users

if ($leave_shadow && $row['topic_approved'] && $row['topic_type'] != POST_GLOBAL)

{

$total_posts = 0;

$new_topic_id_list = array();

{

{

}

$sql_ary = array(

'forum_id' => (int) $to_forum_id,

'icon_id' => (int) $topic_row['icon_id'],

// Copy whether the topic is dotted

markread('post', $to_forum_id, $new_topic_id, 0, $row['poster_id']);

{

$search_mode = 'reply'; // After one we index replies

}

trigger_error('NOT_MODERATOR');

}

$forum_list = implode(', ', $forum_list);

$sql = 'SELECT SUM(forum_topics) as sum_forum_topics

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

$forum_info['forum_topics'] = (int) $db->sql_fetchfield('sum_forum_topics');

$db->sql_freeresult($result);

$forum_info = $forum_info[$forum_id];

$forum_list = $forum_id;

}

$forum_options = '<option value="0"' . (($forum_id == 0) ? ' selected="selected"' : '') . '>' . $user->lang['ALL_FORUMS'] . '</option>';

if ($mode == 'unapproved_posts')

{

$sql = 'SELECT p.post_id

AND p.post_approved = 0

' . (($topic_id) ? 'AND p.topic_id = ' . $topic_id : '') . "

AND t.topic_id = p.topic_id

AND t.topic_first_post_id <> p.post_id

$post_data = $rowset = array();

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

{

$post_data[$row['post_id']] = $row;

}

$db->sql_freeresult($result);

{

$sql = 'SELECT t.forum_id, t.topic_id, t.topic_title, t.topic_title AS post_subject, t.topic_time AS post_time, t.topic_poster AS poster_id, t.topic_first_post_id AS post_id, t.topic_first_poster_name AS username, t.topic_first_poster_colour AS user_colour

FROM ' . TOPICS_TABLE . " t

AND topic_approved = 0

$limit_time_sql

ORDER BY $sort_order_sql";

$rowset = array();

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

{

$rowset[] = $row;

}

$db->sql_freeresult($result);

foreach ($rowset as $row)

{

if (empty($row['post_username']))

{

$row['post_username'] = $user->lang['GUEST'];

$template->assign_block_vars('postrow', array(

'U_TOPIC' => append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $row['forum_id'] . '&amp;t=' . $row['topic_id']),

'U_VIEWPOST' => append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $row['forum_id'] . '&amp;p=' . $row['post_id']) . (($mode == 'unapproved_posts') ? '#p' . $row['post_id'] : ''),

'U_VIEW_DETAILS' => append_sid("{$phpbb_root_path}mcp.$phpEx", "i=queue&amp;start=$start&amp;mode=approve_details&amp;f={$row['forum_id']}&amp;p={$row['post_id']}" . (($mode == 'unapproved_topics') ? "&amp;t={$row['topic_id']}" : '')),

'U_POST_AUTHOR' => get_username_string('profile', $row['poster_id'], $row['username'], $row['user_colour'], $row['post_username']),

'POST_ID' => $row['post_id'],

'POST_SUBJECT' => ($row['post_subject'] != '') ? $row['post_subject'] : $user->lang['NO_SUBJECT'],

'TOPIC_TITLE' => $row['topic_title'],

'POST_TIME' => $user->format_date($row['post_time']))

}

$topic_id_list[$post_data['topic_id']] = 1;

// User post update (we do not care about topic or post, since user posts are strictly connected to posts)

// But we care about forums where post counts get not increased. ;)

// Topic or Post. ;)

if ($post_data['topic_first_post_id'] == $post_id)

{

$topic_approve_sql[] = $post_data['topic_id'];

$approve_log[] = array(

);

}

}

$post_approve_sql[] = $post_id;

$forum_info = $forum_info[$forum_id];

$forum_list = array($forum_id);

}

$forum_list[] = 0;

$report_data = $rowset = array();

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

{

$template->assign_block_vars('postrow', array(

'U_VIEWPOST' => append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $row['forum_id'] . '&amp;p=' . $row['post_id']) . '#p' . $row['post_id'],

'U_VIEW_DETAILS' => append_sid("{$phpbb_root_path}mcp.$phpEx", "i=reports&amp;start=$start&amp;mode=report_details&amp;f={$row['forum_id']}&amp;r={$row['report_id']}"),

'REPORTER' => get_username_string('username', $row['reporter_id'], $row['reporter_name'], $row['reporter_colour']),

'U_REPORTER' => get_username_string('profile', $row['reporter_id'], $row['reporter_name'], $row['reporter_colour']),

'POST_ID' => $row['post_id'],

'POST_SUBJECT' => ($row['post_subject']) ? $row['post_subject'] : $user->lang['NO_SUBJECT'],

'POST_TIME' => $user->format_date($row['post_time']),

// order, so it is important to keep [code] in first position and

// [quote] in second position.

$this->bbcodes = array(

);

// Zero the parsed items array

{

if ($max_smilies)

{

unset($matches);

if ($num_matches !== false && $num_matches > $max_smilies)

}

// Make sure the delimiter # is added in front and at the end of every element within $match

}

}

$this->files_template[$handle] = (isset($user->theme['template_id'])) ? $user->theme['template_id'] : 0;

$recompile = false;

{

$recompile = true;

}

SET user_actkey = ''

WHERE user_id = {$user_row['user_id']}";

$db->sql_query($sql);

}

if ($config['require_activation'] == USER_ACTIVATION_ADMIN && !$update_password)

$sql_from .= ' LEFT JOIN ' . TOPICS_TRACK_TABLE . ' tt ON (tt.topic_id = t.topic_id

AND tt.user_id = ' . $user->data['user_id'] . ')';

$sql_select .= ', tt.mark_time';

}

$topic_type = $user->lang['VIEW_TOPIC_GLOBAL'];

$folder = 'global_read';

$folder_new = 'global_unread';

$forum_ary = array_unique(array_keys($forum_ary));

$sql = "SELECT t.* $sql_select

FROM $sql_from

ORDER BY t.topic_last_post_time DESC';

$topic_list = $rowset = array();

// If the user can't see any forums, he can't read any posts because fid of 0 is invalid

{

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

$db->sql_freeresult($result);

}

if ($config['load_db_lastread'])

{

}

else

{

}

foreach ($topic_list as $topic_id)

{

'S_UNREAD' => $unread_topic,

'U_TOPIC_AUTHOR' => get_username_string('profile', $row['topic_poster'], $row['topic_first_poster_name'], $row['topic_first_poster_colour']),

'U_LAST_POST_AUTHOR' => get_username_string('profile', $row['topic_last_poster_id'], $row['topic_last_poster_name'], $row['topic_last_poster_colour']),

);

}

{

foreach ($topic_forum_list as $f_id => $topic_row)

{

}

}

else

{

foreach ($topic_forum_list as $f_id => $topic_row)

{

}

}

'U_LAST_POST_AUTHOR' => get_username_string('profile', $row['topic_last_poster_id'], $row['topic_last_poster_name'], $row['topic_last_poster_colour']),

'S_DELETED_TOPIC' => (!$row['topic_id']) ? true : false,

'REPLIES' => $replies,

'VIEWS' => $row['topic_views'],

'TOPIC_TITLE' => censor_text($row['topic_title']),