<dd><select id="priority" name="mail_priority_flag">{S_PRIORITY_OPTIONS}</select></dd>

</dl>

<dl>

<dt><label for="send">{L_SEND_IMMEDIATELY}:</label></dt>

<dd><input id="send" type="checkbox" class="radio" name="send_immediately" checked="checked" /></dd>

</dl>

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

$db->sql_freeresult($result);

if ($auth->acl_get('u_download') && $f_download)

{

return false;

}

// m_approve forums

$fid_m_approve = $this->get_moderator_approve_forums();

$sql_m_approve = (!empty($fid_m_approve)) ? 'OR ' . $db->sql_in_set('forum_id', $fid_m_approve) : '';

global $auth, $db;

$m_approve = ($auth->acl_get('m_approve', $this->forum_id)) ? true : false;

// Determine topics with recent activity

$sql = 'SELECT topic_id, topic_last_post_time

FROM ' . TOPICS_TABLE . '

AND topic_moved_id = 0

' . ((!$m_approve) ? 'AND topic_approved = 1' : '') . '

ORDER BY topic_last_post_time DESC';

trigger_error('NO_TOPIC');

}

}

{

{

trigger_error('SORRY_AUTH_READ');

}

}

}

return false;

}

// We really have to get the post ids first!

$sql = 'SELECT topic_first_post_id, topic_time

FROM ' . TOPICS_TABLE . '

return false;

}

// We really have to get the post ids first!

$sql = 'SELECT topic_first_post_id, topic_time

FROM ' . TOPICS_TABLE . '

return false;

}

// Search for topics in last X days

$last_post_time_sql = ($this->sort_days) ? ' AND topic_last_post_time > ' . (time() - ($this->sort_days * 24 * 3600)) : '';

{

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

*/

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;

}

}

}

/**

* 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');

}

{

$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)

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();

$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

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

}

}

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

$error_ary = array();

$errored = false;

header('Content-type: text/html; charset=UTF-8');

?>

_add_modules($modules_to_install);

$no_updates = false;

break;

}

'SEND_TO_GROUP' => 'Send to group',

'SEND_TO_USERS' => 'Send to users',

'SEND_TO_USERS_EXPLAIN' => 'Entering names here will override any group selected above. Enter each username on a new line.',

'MAIL_HIGH_PRIORITY' => 'High',

'MAIL_LOW_PRIORITY' => 'Low',

'MAIL_NORMAL_PRIORITY' => 'Normal',

'MAIL_PRIORITY' => 'Mail priority',

'MASS_MESSAGE' => 'Your message',

'MASS_MESSAGE_EXPLAIN' => 'Please note that you may enter only plain text. All markup will be removed before sending.',

'NO_EMAIL_MESSAGE' => 'You must enter a message.',

'NO_EMAIL_SUBJECT' => 'You must specify a subject for your message.',

));

'SMILIES_CONFIG' => 'Smiley configuration',

'SMILIES_DELETED' => 'The smiley has been removed successfully.',

'SMILIES_EDIT' => 'Edit smiley',

'SMILIES_NONE_EDITED' => 'No smilies were updated.',

'SMILIES_ONE_EDITED' => 'The smiley has been updated successfully.',

'SMILIES_EDITED' => 'The smilies have been updated successfully.',

'PHP_SETTINGS' => 'PHP version and settings',

'PHP_SETTINGS_EXPLAIN' => '<strong>Required</strong> - You must be running at least version 4.3.3 of PHP in order to install phpBB. If <var>safe mode</var> is displayed below your PHP installation is running in that mode. This will impose limitations on remote administration and similar features.',

'PHP_URL_FOPEN_SUPPORT' => 'PHP setting <var>allow_url_fopen</var> is enabled',

'PHP_VERSION_REQD' => 'PHP version >= 4.3.3',

'POST_ID' => 'Post ID',

'PREFIX_FOUND' => 'A scan of your tables has shown a valid installation using <strong>%s</strong> as table prefix.',

'SERVER_CONFIG' => 'Server configuration',

'SEARCH_INDEX_UNCONVERTED' => 'Search index was not converted',

'SEARCH_INDEX_UNCONVERTED_EXPLAIN' => 'Your old search index was not converted. Searching will always yield an empty result. To create a new search index go to the Administration Control Panel, select Maintenance and then choose Search index from the submenu.',

'SOFTWARE' => 'Board software',

'SPECIFY_OPTIONS' => 'Specify conversion options',

'STAGE_ADMINISTRATOR' => 'Administrator details',

$db->sql_freeresult($result);

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

}

else if ($topic_id)

{

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

{

$rowset[$row['topic_id']] = $row;

if ($acl_list && !$auth->acl_gets($acl_list, $row['forum_id']))

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

{

if ($acl_list && !$auth->acl_gets($acl_list, $row['forum_id']))

{

continue;

$sql = 'SELECT DISTINCT poster_id

FROM ' . POSTS_TABLE . '

WHERE poster_ip ' . ((strpos($ips, '%') !== false) ? 'LIKE' : 'IN') . " ($ips)

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

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

$sql = 'SELECT f.*, t.*

FROM ' . TOPICS_TABLE . ' t, ' . FORUMS_TABLE . " f

WHERE t.topic_id = $topic_id

break;

case 'quote':

WHERE p.post_id = $post_id

AND t.topic_id = p.topic_id

AND u.user_id = p.poster_id

break;

case 'smilies':

// Store message, sync counters

if (!sizeof($error) && $submit)

{

if ($submit)

{

// Lock/Unlock Topic

trigger_error('POST_NOT_EXIST');

}

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

$sql = 'SELECT *

{

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

{

}

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

{

if (!$user->data['is_registered'])

{

$result_topic_id = $row['topic_id'];

$topic_title = censor_text($row['topic_title']);

$view_topic_url = append_sid("{$phpbb_root_path}viewtopic.$phpEx", $view_topic_url_params);

$replies = ($auth->acl_get('m_approve', $forum_id)) ? $row['topic_replies_real'] : $row['topic_replies'];

'ATTACH_ICON_IMG' => ($auth->acl_get('u_download') && $auth->acl_get('f_download', $forum_id) && $row['topic_attachment']) ? $user->img('icon_topic_attach', $user->lang['TOTAL_ATTACHMENTS']) : '',

'UNAPPROVED_IMG' => ($topic_unapproved || $posts_unapproved) ? $user->img('icon_topic_unapproved', ($topic_unapproved) ? 'TOPIC_UNAPPROVED' : 'POSTS_UNAPPROVED') : '',

'S_TOPIC_TYPE' => $row['topic_type'],

'S_USER_POSTED' => (!empty($row['topic_posted'])) ? true : false,

'S_UNREAD_TOPIC' => $unread_topic,

<dt>&nbsp;</dt>

<dd><a href="{U_AIM_CONTACT}">{L_IM_ADD_CONTACT}</a></dd>

<dd><a href="{U_AIM_MESSAGE}">{L_IM_SEND_MESSAGE}</a></dd>

</dl>

<!-- ENDIF -->

<!-- IF searchresults.S_TOPIC_UNAPPROVED or searchresults.S_POSTS_UNAPPROVED --><a href="{searchresults.U_MCP_QUEUE}">{searchresults.UNAPPROVED_IMG}</a> <!-- ENDIF -->

<!-- IF searchresults.S_TOPIC_REPORTED --><a href="{searchresults.U_MCP_REPORT}">{REPORTED_IMG}</a><!-- ENDIF --><br />

<!-- IF searchresults.PAGINATION --><strong class="pagination"><span>{searchresults.PAGINATION}</span></strong><!-- ENDIF -->

</dt>

<dd class="posts">{searchresults.TOPIC_REPLIES}</dd>

<dd class="views">{searchresults.TOPIC_VIEWS}</dd>

<dt class="author">{L_POST_BY_AUTHOR} {searchresults.POST_AUTHOR_FULL}</dt>

<dd>{searchresults.POST_DATE}</dd>

<dd>&nbsp;</dd>

<dd>{L_REPLIES}: <strong>{searchresults.TOPIC_REPLIES}</strong></dd>

<dd>{L_VIEWS}: <strong>{searchresults.TOPIC_VIEWS}</strong></dd>

</dl>

<!-- IF topicrow.S_TOPIC_REPORTED --><a href="{topicrow.U_MCP_REPORT}">{REPORTED_IMG}</a><!-- ENDIF --><br />

<!-- IF topicrow.PAGINATION --><strong class="pagination"><span>{topicrow.PAGINATION}</span></strong><!-- ENDIF -->

<!-- IF topicrow.ATTACH_ICON_IMG -->{topicrow.ATTACH_ICON_IMG} <!-- ENDIF -->{L_POST_BY_AUTHOR} {topicrow.TOPIC_AUTHOR_FULL} &raquo; {topicrow.FIRST_POST_TIME}

</dt>

<dd class="posts">{topicrow.REPLIES} <dfn>{L_REPLIES}</dfn></dd>

<dd class="views">{topicrow.VIEWS} <dfn>{L_VIEWS}</dfn></dd>

<!-- IF S_SEND_AIM -->

<tr>

</tr>

<tr>

<td class="cat" colspan="2" align="center">&nbsp;</td>

<!-- IF searchresults.PAGINATION -->

<p class="gensmall"> [ {GOTO_PAGE_IMG}{L_GOTO_PAGE}: {searchresults.PAGINATION} ] </p>

<!-- ENDIF -->

</td>

<td class="row2" width="100" align="center"><p class="topicauthor">{searchresults.TOPIC_AUTHOR_FULL}</p></td>

<td class="row1" width="50" align="center"><p class="topicdetails">{searchresults.TOPIC_REPLIES}</p></td>

<!-- IF searchresults.S_IGNORE_POST -->

<td class="gensmall" colspan="2" height="25" align="center">{searchresults.L_IGNORE_POST}</td>

<!-- ELSE -->

</tr>

<tr class="row1">

<td width="150" align="center" valign="middle"><b class="postauthor">{searchresults.POST_AUTHOR_FULL}</b></td>

<!-- IF topicrow.PAGINATION -->

<p class="gensmall"> [ {GOTO_PAGE_IMG}{L_GOTO_PAGE}: {topicrow.PAGINATION} ] </p>

<!-- ENDIF -->

</td>

<td class="row2" width="130" align="center"><p class="topicauthor">{topicrow.TOPIC_AUTHOR_FULL}</p></td>

<td class="row1" width="50" align="center"><p class="topicdetails">{topicrow.REPLIES}</p></td>

$token = request_var('hash', '');

if (check_link_hash($token, 'global'))

{

}

$redirect_url = append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $forum_id);

meta_refresh(3, $redirect_url);

$sql = 'SELECT COUNT(topic_id) AS num_topics

FROM ' . TOPICS_TABLE . "

WHERE forum_id = $forum_id

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

$topics_count = (int) $db->sql_fetchfield('num_topics');

$db->sql_freeresult($result);

$icons = $cache->obtain_icons();

// Grab all topic data

$sql_array = array(

'SELECT' => 't.*',

if ($forum_data['forum_type'] == FORUM_POST)

{

// Obtain announcements ... removed sort ordering, sort by time in all cases

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

'FROM' => $sql_array['FROM'],

'ORDER_BY' => 't.topic_time DESC',

));

$rowset[$row['topic_id']] = $row;

$announcement_list[] = $row['topic_id'];

{

}

{

}

}

}

// If the user is trying to reach late pages, start searching from the end

$mark_forum_read = true;

$mark_time_forum = 0;

{

{

}

{

}

{

}

}

{

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

{

$mark_time_forum = (!empty($forum_data['mark_time'])) ? $forum_data['mark_time'] : $user->data['user_lastmark'];

}

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

{

if (!$user->data['is_registered'])

{

$user->data['user_lastmark'] = (isset($tracking_topics['l'])) ? (int) (base_convert($tracking_topics['l'], 36, 10) + $config['board_startdate']) : 0;

topic_status($row, $replies, $unread_topic, $folder_img, $folder_alt, $topic_type);

// Generate all the URIs ...

$view_topic_url = append_sid("{$phpbb_root_path}viewtopic.$phpEx", $view_topic_url_params);

$u_mcp_queue = ($topic_unapproved || $posts_unapproved) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=queue&amp;mode=' . (($topic_unapproved) ? 'approve_details' : 'unapproved_posts') . "&amp;t=$topic_id", true, $user->session_id) : '';

// Send vars to template

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

'TOPIC_ID' => $topic_id,

'TOPIC_AUTHOR' => get_username_string('username', $row['topic_poster'], $row['topic_first_poster_name'], $row['topic_first_poster_colour']),

'TOPIC_AUTHOR_COLOUR' => get_username_string('colour', $row['topic_poster'], $row['topic_first_poster_name'], $row['topic_first_poster_colour']),

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

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

'TOPIC_TYPE' => $topic_type,

'TOPIC_IMG_STYLE' => $folder_img,

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

'TOPIC_ICON_IMG' => (!empty($icons[$row['icon_id']])) ? $icons[$row['icon_id']]['img'] : '',

'TOPIC_ICON_IMG_WIDTH' => (!empty($icons[$row['icon_id']])) ? $icons[$row['icon_id']]['width'] : '',

'TOPIC_ICON_IMG_HEIGHT' => (!empty($icons[$row['icon_id']])) ? $icons[$row['icon_id']]['height'] : '',

'UNAPPROVED_IMG' => ($topic_unapproved || $posts_unapproved) ? $user->img('icon_topic_unapproved', ($topic_unapproved) ? 'TOPIC_UNAPPROVED' : 'POSTS_UNAPPROVED') : '',

'S_TOPIC_TYPE' => $row['topic_type'],

'S_USER_POSTED' => (isset($row['topic_posted']) && $row['topic_posted']) ? true : false,

'S_UNREAD_TOPIC' => $unread_topic,

'S_TOPIC_UNAPPROVED' => $topic_unapproved,

'S_POSTS_UNAPPROVED' => $posts_unapproved,

'S_HAS_POLL' => ($row['poll_start']) ? true : false,

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

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

'U_VIEW_TOPIC' => $view_topic_url,

'U_MCP_QUEUE' => $u_mcp_queue,

'S_TOPIC_TYPE_SWITCH' => ($s_type_switch == $s_type_switch_test) ? -1 : $s_type_switch_test)

else

{

$topic_id = $row['topic_id'];

}

}

}

{

$forum_id = $row['forum_id'];

}

'FROM' => array(FORUMS_TABLE => 'f'),

);

// The FROM-Order is quite important here, else t.* columns can not be correctly bound.

if ($post_id)

{

$sql_array['WHERE'] = "p.post_id = $post_id AND t.topic_id = p.topic_id";

}

$sql = $db->sql_build_query('SELECT', $sql_array);

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

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

'U_REPORT' => ($auth->acl_get('f_report', $forum_id)) ? append_sid("{$phpbb_root_path}report.$phpEx", 'f=' . $forum_id . '&amp;p=' . $row['post_id']) : '',

'U_MCP_REPORT' => ($auth->acl_get('m_report', $forum_id)) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=reports&amp;mode=report_details&amp;f=' . $forum_id . '&amp;p=' . $row['post_id'], true, $user->session_id) : '',

'U_MCP_APPROVE' => ($auth->acl_get('m_approve', $forum_id)) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=queue&amp;mode=approve_details&amp;f=' . $forum_id . '&amp;p=' . $row['post_id'], true, $user->session_id) : '',

'U_NEXT_POST_ID' => ($i < $i_total && isset($rowset[$post_list[$i + 1]])) ? $rowset[$post_list[$i + 1]]['post_id'] : '',

'U_PREV_POST_ID' => $prev_post_id,

'U_NOTES' => ($auth->acl_getf_global('m_')) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=notes&amp;mode=user_notes&amp;u=' . $poster_id, true, $user->session_id) : '',

}

}

// Only mark topic if it's currently unread. Also make sure we do not set topic tracking back if earlier pages are viewed.

if (isset($topic_tracking_info[$topic_id]) && $topic_data['topic_last_post_time'] > $topic_tracking_info[$topic_id] && $max_post_time > $topic_tracking_info[$topic_id])

{

// Update forum info

}

else

{

$config->increment('foo', 1);

$this->assertEquals(27, $config['foo']);

}

}

$this->config->increment('foobar', 3);

$this->assertEquals(3, $this->config['foobar']);;

}

}