'poster_ip' => array('INDEX', 'poster_ip'),

'poster_id' => array('INDEX', 'poster_id'),

'post_approved' => array('INDEX', 'post_approved'),

),

);

'forum_id' => array('INDEX', 'forum_id'),

'forum_id_type' => array('INDEX', array('forum_id', 'topic_type')),

'last_post_time' => array('INDEX', 'topic_last_post_time'),

'fid_time_moved' => array('INDEX', array('forum_id', 'topic_last_post_time', 'topic_moved_id')),

),

);

{

global $cache, $starttime, $phpbb_root_path, $user;

{

return false;

}

break;

}

// 2: Get topic counts for each forum

$sql = 'SELECT forum_id, topic_approved, COUNT(topic_id) AS forum_topics

FROM ' . TOPICS_TABLE . '

$db->sql_freeresult($result);

// 3: Get post count and last_post_id for each forum

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

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

{

$forum_data[$forum_id]['posts'] = (int) $row['forum_posts'];

$forum_data[$forum_id]['last_post_id'] = (int) $row['last_post_id'];

$topic_id = (int) $row['topic_id'];

$topic_data[$topic_id] = $row;

$topic_data[$topic_id]['replies_real'] = -1;

$topic_data[$topic_id]['first_post_id'] = 0;

$topic_data[$topic_id]['last_post_id'] = 0;

unset($topic_data[$topic_id]['topic_id']);

// NOTE: 't.post_approved' in the GROUP BY is causing a major slowdown.

$sql = 'SELECT t.topic_id, t.post_approved, COUNT(t.post_id) AS total_posts, MIN(t.post_id) AS first_post_id, MAX(t.post_id) AS last_post_id

FROM ' . POSTS_TABLE . " t

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

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

// batch processing.

if ($resync_parents && sizeof($resync_forums) && $where_type != 'range')

{

}

break;

}

global $auth, $template, $db, $user;

global $phpbb_root_path, $phpEx;

$forum_ary = array();

// Do not include those forums the user is not having read access to...

}

// Obtain active topic

FROM ' . POSTS_TABLE . '

WHERE poster_id = ' . $userdata['user_id'] . "

AND post_postcount = 1

'ACTIVE_TOPIC_POSTS' => ($active_t_count == 1) ? sprintf($user->lang['USER_POST'], 1) : sprintf($user->lang['USER_POSTS'], $active_t_count),

'ACTIVE_TOPIC_PCT' => sprintf($user->lang['POST_PCT_ACTIVE'], $active_t_pct),

'U_ACTIVE_FORUM' => append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $active_f_id),

);

}

{

$sql = 'SELECT MAX(post_id) as last_post_id

FROM ' . POSTS_TABLE . '

}

else

{

$sql = 'SELECT ' . $type . '_id, MAX(post_id) as last_post_id

FROM ' . POSTS_TABLE . '

GROUP BY {$type}_id";

}

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

}

else if ($full_folder_action == FULL_FOLDER_DELETE)

{

$result = $db->sql_query_limit($sql, (($folder[$dest_folder] + sizeof($msg_ary)) - $user->data['message_limit']));

$delete_ids = array();

$redirect = request_var('redirect', $user->data['session_page']);

trigger_error($msg . '<br /><br />' . sprintf($user->lang['RETURN_PAGE'], '<a href="' . $redirect . '">', '</a>'));

return;

}

// Set some vars

$post_id = $post_info['post_id'];

$poster = ($post_info['user_colour']) ? '<span style="color:#' . $post_info['user_colour'] . '">' . $post_info['username'] . '</span>' : $post_info['username'];

}

// Get other users who've posted under this IP

// Firebird does not support ORDER BY on aliased columns

// MySQL does not support ORDER BY on functions

switch (SQL_LAYER)

{

case 'firebird':

break;

default:

break;

}

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

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

{

{

}

}

// Get other IP's this user has posted under

// Firebird does not support ORDER BY on aliased columns

// MySQL does not support ORDER BY on functions

switch (SQL_LAYER)

{

case 'firebird':

FROM ' . POSTS_TABLE . '

WHERE poster_id = ' . $post_info['poster_id'] . '

GROUP BY poster_ip

break;

default:

FROM ' . POSTS_TABLE . '

WHERE poster_id = ' . $post_info['poster_id'] . '

GROUP BY poster_ip

$db->sql_freeresult($result);

$user_select = '';

{

}

$template->assign_var('S_USER_SELECT', $user_select);

}

{

$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

FROM ' . TOPICS_TABLE . " t

$limit_time_sql

ORDER BY $sort_order_sql";

$result = $db->sql_query_limit($sql, $config['topics_per_page'], $start);

$total_topics = $total_posts = $forum_topics = $forum_posts = 0;

$topic_approve_sql = $topic_replies_sql = $post_approve_sql = $topic_id_list = array();

foreach ($post_info as $post_id => $post_data)

{

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

}

$post_approve_sql[] = $post_id;

}

if (sizeof($topic_approve_sql))

unset($topic_approve_sql, $topic_replies_sql, $post_approve_sql);

update_post_information('topic', array_keys($topic_id_list));

unset($topic_id_list);

$messenger = new messenger();

'INTERESTS' => (!empty($row['user_interests'])) ? $row['user_interests'] : '',

// 'S_GROUP_OPTIONS' => $group_options,

'U_SEARCH_USER' => ($auth->acl_get('u_search')) ? append_sid("{$phpbb_root_path}search.$phpEx", 'author_id=' . $user->data['user_id'] . '&amp;sr=posts') : '')

);

$sql = 'SELECT COUNT(post_id) AS total

FROM ' . POSTS_TABLE . "

$where_sql " . $db->sql_in_set('forum_id', ($forum_id) ? array($forum_id) : get_forum_list('m_approve')) . '

break;

case 'unapproved_topics':

$sql = 'SELECT COUNT(topic_id) AS total

FROM ' . TOPICS_TABLE . "

$where_sql " . $db->sql_in_set('forum_id', ($forum_id) ? array($forum_id) : get_forum_list('m_approve')) . '

break;

case 'reports':

'S_PROFILE_ACTION' => append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=group'),

'S_GROUP_OPTIONS' => $group_options,

'S_CUSTOM_FIELDS' => (isset($profile_fields['row']) && sizeof($profile_fields['row'])) ? true : false,

'U_USER_ADMIN' => ($auth->acl_get('a_user')) ? append_sid("{$phpbb_root_path}adm/index.$phpEx", 'i=users&amp;mode=overview&amp;u=' . $user_id, true, $user->session_id) : '',

'U_SWITCH_PERMISSIONS' => ($auth->acl_get('a_switchperm') && $user->data['user_id'] != $user_id) ? append_sid("{$phpbb_root_path}ucp.$phpEx", "mode=switch_perm&amp;u={$user_id}") : '',

<tr>

<td class="cat" colspan="6" align="right">

<select name="action">

<!-- IF S_CAN_DELETE --><option value="delete_topic">{L_DELETE}</option><!-- ENDIF -->

<!-- IF S_CAN_MOVE --><option value="move">{L_MOVE}</option><!-- ENDIF -->

<!-- IF S_CAN_FORK --><option value="fork">{L_FORK}</option><!-- ENDIF -->

// This is for determining where we are (page)

if ($post_id)

{

}

$forum_id = (int) $topic_data['forum_id'];