// CONFIG - Begin

$substitute_old = '3.0.6';

$simple_name_old = 'phpbb306';

$echo_changes = false;

// Set this to true to just compress the changes and do not build them again

// This should be used for building custom modified txt file. ;)

echo "\n- Command Run: " . $command . "\n";

}

// If RC8 drops remove the install/data directory

//$versions = array('3.0.2', '3.0.3-RC1', '3.0.3', '3.0.4-RC1', '3.0.4', '3.0.5-RC1', '3.0.5', '3.0.6-RC1', '3.0.6-RC2', '3.0.6-RC3');

//$versions = array('3.0.2', '3.0.3', '3.0.4', '3.0.5', '3.0.6', '3.0.7-RC1', '3.0.7');

$verbose = false;

require('build_helper.php');

$package->run_command('md5sum ./release_files/' . $package->get('release_filename') . '.' . $extension . ' > ./release_files/' . $package->get('release_filename') . '.' . $extension . '.md5');

}

// verify results

chdir($package->locations['root']);

$package->begin_status('********** Verifying packages **********');

{S_FORM_TOKEN}

</p>

</fieldset>

</form>

<!-- ENDIF -->

grep -sv FILELIST FILELIST.$$ > FILELIST2.$$

grep -sv $(basename $0) FILELIST2.$$ > FILELIST.$$

grep -sv "^\.$" FILELIST.$$ > FILELIST2.$$

file -f FILELIST2.$$ |grep -sv text | sed -e 's/^\([^\:]*\)\:.*$/Not Modifying file: \1/'

rm FILELIST2.$$

rm FILELIST.$$

<ol>

<li><a href="#changelog">Changelog</a>

<ol style="list-style-type: lower-roman;">

<li><a href="#v307">Changes since 3.0.7</a></li>

<li><a href="#v306">Changes since 3.0.6</a></li>

<li><a href="#v305">Changes since 3.0.5</a></li>

<div class="content">

<ul>

<li>[Fix] Correctly sort database backup file list by date on database restore page. (Bug #57385)</li>

<li>[Fix] No longer return the character O in generated random strings and passwords. (Bug #57345)</li>

<li>[Fix] Allow redirect() function to redirect across directories. (Bug #56965)</li>

<li>[Fix] Add terminating semicolons to JavaScript code. (Bug #58085 - Patch by nn-)</li>

<li>[Feature] Support for Microsoft's Native SQL Server Driver for PHP (Bug #57055 - Patch by Chris Pucci at Microsoft)</li>

</ul>

<a name="v306"></a><h3>1.ii. Changes since 3.0.6</h3>

<p>This package is meant for those wanting to only replace changed files from a previous version to the latest version. This package normally contains the changed files from up to five previous versions.</p>

<p>The directory structure has been preserved enabling you (if you wish) to simply upload the contents of the archive to the appropriate location on your server, i.e. simply overwrite the existing files with the new versions. Do not forget that if you have installed any MODs these files will overwrite the originals possibly destroying them in the process. You will need to re-add MODs to any affected file before uploading.</p>

<p>The patch file is one solution for those with many Modifications (MODs) or other changes who do not want to re-add them back to all the changed files if they use the method explained above. To use this you will need command line access to a standard UNIX type <strong>patch</strong> application. If you do not have access to such an application but still want to use this update approach, we strongly recommend the <a href="#update_auto">Automatic update package</a> explained below. It is also the recommended update method.</p>

<p>If you do get failures you should look at using the <a href="#update_files">Changed files only</a> package to replace the files which failed to patch, please note that you will need to manually re-add any Modifications (MODs) to these particular files. Alternatively if you know how you can examine the .rej files to determine what failed where and make manual adjustments to the relevant source.</p>

if (!isset($forum_ids))

{

}

return $forum_ids;

if (!isset($forum_ids))

{

}

return $forum_ids;

}

function get_excluded_forums()

{

global $db, $cache;

if ($config['feed_item_statistics'])

{

$item_row['statistics'] = $user->lang['POSTED'] . ' ' . $user->lang['POST_BY_AUTHOR'] . ' ' . $this->user_viewprofile($row)

}

}

}

{

$item_row['statistics'] = $user->lang['POSTED'] . ' ' . $user->lang['POST_BY_AUTHOR'] . ' ' . $this->user_viewprofile($row)

. ' ' . $this->separator_stats . ' ' . $user->format_date($row[$this->get('date')])

}

}

}

// Get the actual data

$this->sql = array(

'SELECT' => 'f.forum_id, f.forum_name, ' .

'u.username, u.user_id',

'FROM' => array(

USERS_TABLE => 'u',

),

'LEFT_JOIN' => array(

array(

}

$this->sql = array(

'u.username, u.user_id',

'FROM' => array(

POSTS_TABLE => 'p',

if (!$this->topic_data['topic_approved'])

{

// Also require m_approve

if (empty($in_fid_ary))

{

global $auth, $db;

$this->sql = array(

'u.username, u.user_id',

'FROM' => array(

POSTS_TABLE => 'p',

$this->sql = array(

'SELECT' => 'f.forum_id, f.forum_name,

p.post_id, p.post_time, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url',

'FROM' => array(

TOPICS_TABLE => 't',

$this->sql = array(

'SELECT' => 'f.forum_id, f.forum_name,

p.post_id, p.post_time, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url',

'FROM' => array(

TOPICS_TABLE => 't',

$this->sql = array(

'SELECT' => 'f.forum_id, f.forum_name,

t.topic_last_poster_id, t.topic_last_poster_name, t.topic_last_post_time,

p.post_id, p.post_time, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url',

'FROM' => array(

define('PHPBB_ACM_MEMCACHE_HOST', 'localhost');

}

/**

* ACM for Memcached

* @package acm

parent::acm_memory();

$this->memcache = new Memcache;

$this->flags = (PHPBB_ACM_MEMCACHE_COMPRESS) ? MEMCACHE_COMPRESSED : 0;

}

}

}

$s_assigned_groups = array();

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

{

$s_assigned_groups[$row['cat_id']][] = $row['group_name'];

}

$db->sql_freeresult($result);

$sql = 'SELECT group_id

FROM ' . EXTENSION_GROUPS_TABLE . "

WHERE LOWER(group_name) = '" . $db->sql_escape(utf8_strtolower($new_group_name)) . "'";

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

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

$group_id = $db->sql_nextid();

}

add_log('admin', 'LOG_ATTACH_EXTGROUP_' . strtoupper($action), $group_name);

}

'U_EDIT' => $this->u_action . "&amp;action=edit&amp;g={$row['group_id']}",

'U_DELETE' => $this->u_action . "&amp;action=delete&amp;g={$row['group_id']}",

'CATEGORY' => $cat_lang[$row['cat_id']],

)

);

$group_name = array();

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

{

$group_name[] = $row;

}

$db->sql_freeresult($result);

$old_tz = $user->timezone;

$old_dst = $user->dst;

$dateformat_options = '';

case 'mssql':

case 'mssql_odbc':

while (($sql = $fgetd($fp, "GO\n", $read, $seek, $eof)) !== false)

{

$db->sql_query($sql);

)

);

foreach ($tables_ary as $field => $tables)

{

$start = 0;

$sql = "SELECT $field

FROM " . POSTS_TABLE . '

WHERE forum_id = ' . $forum_id;

$ids = array();

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

}

}

}

}

unset($ids);

{

while (($file = readdir($dp)) !== false)

{

{

continue;

}

{

if (!in_array($file, $installed))

{

case 'mssql':

case 'mssql_odbc':

// We are defining the biggest common value, because of the possibility to edit the min/max values of each field.

$sql = 'ALTER TABLE [' . PROFILE_FIELDS_DATA_TABLE . "] ADD [$field_ident] ";

// Standard? What's that?

case 'mssql':

case 'mssql_odbc':

// Change the reports using this reason to 'other'

$sql = "DECLARE @ptrval binary(16)

{

while (($file = readdir($dp)) !== false)

{

{

continue;

}

$subpath = ($mode != 'style') ? "$mode/" : '';

{

if ($cfg = file("{$phpbb_root_path}styles/$file/$subpath$mode.cfg"))

{

LEFT JOIN ' . SESSIONS_TABLE . ' s ON (s.session_user_id = u.user_id)

WHERE u.user_id = ' . $user_id . '

ORDER BY s.session_time DESC';

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

$db->sql_freeresult($result);

WHERE user_id = $user_id";

$db->sql_query($sql);

trigger_error($user->lang['USER_PREFS_UPDATED'] . adm_back_link($this->u_action . '&amp;u=' . $user_id));

}

LEFT JOIN ' . SESSIONS_TABLE . ' s ON (s.session_user_id = u.user_id)

WHERE u.user_id = ' . $user_id . '

ORDER BY s.session_time DESC';

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

$db->sql_freeresult($result);

}

*/

// phpBB Version

// QA-related

// define('PHPBB_QA', 1);

$this->persistency = $persistency;

if ($this->db_connect_id)

{

{

$_v = null;

}

set_var($var[$k][$_k], $_v, $sub_type, $multibyte);

}

}

switch ($db->sql_layer)

{

case 'firebird':

case 'postgres':

break;

// MySQL, SQlite, mssql, mssql_odbc, oracle

{

global $_SID, $_EXTRA_URL, $phpbb_hook;

if (!empty($phpbb_hook) && $phpbb_hook->call_hook(__FUNCTION__, $url, $params, $is_amp, $session_id))

{

if ($phpbb_hook->hook_return(__FUNCTION__))

{

global $db, $cache, $config, $user, $phpbb_root_path;

if (empty($user->lang))

{

$user->add_lang('common');

if (!file_exists($pathinfo['dirname']))

{

// fallback to "last known user page"

$url = generate_board_url() . '/' . $user->page['page'];

}

}

{

{

}

else

{

}

}

{

$type = (!$type) ? 'MX' : $type;

{

// @exec('nslookup -retry=1 -timout=1 -type=' . escapeshellarg($type) . ' ' . escapeshellarg($host), $output);

@exec('nslookup -type=' . escapeshellarg($type) . ' ' . escapeshellarg($host) . '.', $output);

return false;

}

return NULL;

}

'S_TOPIC_ID' => $topic_id,

'S_LOGIN_ACTION' => ((!defined('ADMIN_START')) ? append_sid("{$phpbb_root_path}ucp.$phpEx", 'mode=login') : append_sid("index.$phpEx", false, true, $user->session_id)),

'S_ENABLE_FEEDS' => ($config['feed_enable']) ? true : false,

'S_ENABLE_FEEDS_OVERALL' => ($config['feed_overall']) ? true : false,

$right = $row['right_id'];

$disabled = false;

{

if ($only_acl_post && !$auth->acl_get('f_post', $row['forum_id']) || (!$auth->acl_get('m_approve', $row['forum_id']) && !$auth->acl_get('f_noapprove', $row['forum_id'])))

{

$disabled = true;

}

}

else if (!$ignore_acl)

{

$db->sql_transaction('begin');

foreach ($table_ary as $table)

{

function compress_tar($mode, $file, $type = '')

{

$type = (!$type) ? $file : $type;

$this->mode = &$mode;

$this->file = &$file;

$times = 1;

for ($j = 0; $j < $replies + 1; $j += $per_page)

{

if ($times == 1 && $total_pages > 5)

{

$pagination .= ' ... ';

if ($mode == 'window')

{

FROM ' . SMILIES_TABLE . '

GROUP BY smiley_url, smiley_width, smiley_height

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

}

else

}

}

}

if ($mode == 'topic_review')

case 'sqlite':

case 'mssql':

case 'mssql_odbc':

$right_delim = ']';

$left_delim = '[';

break;

{

if ($get_info)

{

}

else

{

{

$upload_ary['type'] = rtrim(str_replace('content-type: ', '', strtolower($line)));

}

else if (stripos($line, '404 not found') !== false)

{

$file = new fileerror($user->lang[$this->error_prefix . 'URL_NOT_FOUND']);

if ($config['max_' . $this->mode . '_img_height'] || $config['max_' . $this->mode . '_img_width'])

{

if ($stats === false)

{

$query_string = trim(implode('&', $use_args));

// basenamed page name (for example: index.php)

$page_name = urlencode(htmlspecialchars($page_name));

// current directory within the phpBB root (for example: adm)

}

else

{

$this->data['session_last_visit'] = $this->time_now;

}

}

// only called from CRON; should be a safe workaround until the infrastructure gets going

{

include($phpbb_root_path . "includes/captcha/captcha_factory." . $phpEx);

}

'S_COMPOSE_PM' => true,

'S_EDIT_POST' => ($action == 'edit'),

'S_SHOW_PM_ICONS' => $s_pm_icons,

'S_BBCODE_CHECKED' => ($bbcode_checked) ? ' checked="checked"' : '',

'S_SMILIES_ALLOWED' => $smilies_status,

'S_SMILIES_CHECKED' => ($smilies_checked) ? ' checked="checked"' : '',

$convertor_data = array(

'forum_name' => 'phpBB 2.0.x',

'version' => '1.0.3',

'author' => '<a href="http://www.phpbb.com/">phpBB Group</a>',

'dbms' => $dbms,

'dbhost' => $dbhost,

* 'table_format' => 'file',

* 'filename' => 'NAME OF FILE', // If the file is not in the root directory, the path needs to be added with no leading slash

* 'array_name' => 'NAME OF ARRAY', // Only used if the configuration file stores the setting in an array.

* 'board_email' => 'SUPPORT_EMAIL', // target config name => source target name

* )

* );

'3.0.7-RC1' => array(),

// No changes from 3.0.7-RC2 to 3.0.7

'3.0.7-RC2' => array(),

);

}

*****************************************************************************/

function change_database_data(&$no_updates, $version)

{

switch ($version)

{

// No changes from 3.0.7-RC2 to 3.0.7

case '3.0.7-RC2':

break;

}

}

function main($mode, $sub)

{

$this->tpl_name = 'install_update';

$this->page_title = 'UPDATE_INSTALLATION';

$user->session_begin();

$auth->acl($user->data);

// If we are within the intro page we need to make sure we get up-to-date version info

if ($sub == 'intro')

// still, the acp template is never stored in the database

$user->theme['template_storedb'] = false;

// Get current and latest version

if (($latest_version = $cache->get('_version_info')) === false)

{

$template->assign_vars(array(

'S_INTRO' => true,

));

// Make sure the update list is destroyed.

'S_UP_TO_DATE' => $up_to_date,

'S_VERSION_CHECK' => true,

'LATEST_VERSION' => $this->latest_version,

'CURRENT_VERSION' => $this->current_version)

'S_DB_UPDATE' => true,

'S_DB_UPDATE_FINISHED' => ($config['version'] == $this->update_info['version']['to']) ? true : false,

'U_DB_UPDATE' => append_sid($phpbb_root_path . 'install/database_update.' . $phpEx, 'type=1&amp;language=' . $user->data['user_lang']),

));

break;

// Refresh the page if we are still not finished...

if ($update_list['status'] != -1)

{

meta_refresh(2, $refresh_url);

$template->assign_vars(array(

$file_part = $filename;

}

if (isset($file_struct['as_expected']) && $file_struct['as_expected'])

{

'S_FILE_CHECK' => true,

'S_ALL_UP_TO_DATE' => $all_up_to_date,

'S_VERSION_UP_TO_DATE' => $up_to_date,

));

if ($all_up_to_date)

$params[] = 'download=1';

}

meta_refresh(3, $redirect_url);

$template->assign_vars(array(

$template->assign_vars(array(

'S_DOWNLOAD_FILES' => true,

'RADIO_BUTTONS' => $radio_buttons,

'S_HIDDEN_FIELDS' => $s_hidden_fields)

);

'S_FTP_UPLOAD' => true,

'UPLOAD_METHOD' => $method,

'S_HIDDEN_FIELDS' => $s_hidden_fields,

));

$template->assign_vars(array(

'S_UPLOAD_SUCCESS' => true,

);

return;

}

# -- Forums

INSERT INTO phpbb_forums (forum_name, forum_desc, left_id, right_id, parent_id, forum_type, forum_posts, forum_topics, forum_topics_real, forum_last_post_id, forum_last_poster_id, forum_last_poster_name, forum_last_poster_colour, forum_last_post_time, forum_link, forum_password, forum_image, forum_rules, forum_rules_link, forum_rules_uid, forum_desc_uid, prune_days, prune_viewed, forum_parents) VALUES ('{L_FORUMS_FIRST_CATEGORY}', '', 1, 4, 0, 0, 1, 1, 1, 1, 2, 'Admin', 'AA0000', 972086460, '', '', '', '', '', '', '', 0, 0, '');

# -- Users / Anonymous user

INSERT INTO phpbb_users (user_type, group_id, username, username_clean, user_regdate, user_password, user_email, user_lang, user_style, user_rank, user_colour, user_posts, user_permissions, user_ip, user_birthday, user_lastpage, user_last_confirm_key, user_post_sortby_type, user_post_sortby_dir, user_topic_sortby_type, user_topic_sortby_dir, user_avatar, user_sig, user_sig_bbcode_uid, user_from, user_icq, user_aim, user_yim, user_msnm, user_jabber, user_website, user_occ, user_interests, user_actkey, user_newpasswd, user_allow_massemail) VALUES (2, 1, 'Anonymous', 'anonymous', 0, '', '', 'en', 1, 0, '', 0, '', '', '', '', '', 't', 'a', 't', 'd', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0);

'DISPLAY_INLINED_EXPLAIN' => 'If set to No image attachments will show as a link.',

'DISPLAY_ORDER' => 'Attachment display order',

'DISPLAY_ORDER_EXPLAIN' => 'Display attachments ordered by time.',

'EDIT_EXTENSION_GROUP' => 'Edit extension group',

'EXCLUDE_ENTERED_IP' => 'Enable this to exclude the entered IP/hostname.',

'EXCLUDE_FROM_ALLOWED_IP' => 'Exclude IP from allowed IPs/hostnames',

'EXTENSION_GROUP_DELETED' => 'Extension group successfully deleted.',

'EXTENSION_GROUP_EXIST' => 'The extension group %s already exists.',

'GO_TO_EXTENSIONS' => 'Go to extension management screen',

'GROUP_NAME' => 'Group name',

'NEW_MEMBER_POST_LIMIT' => 'New member post limit',

'NEW_MEMBER_POST_LIMIT_EXPLAIN' => 'New members are within the <em>Newly Registered Users</em> group until they reach this number of posts. You can use this group to keep them from using the PM system or to review their posts. <strong>A value of 0 disables this feature.</strong>',

'NEW_MEMBER_GROUP_DEFAULT' => 'Set Newly Registered Users group to default',

'ACC_ADMIN' => 'By Admin',

'ACC_DISABLE' => 'Disable',

Board URL: {U_BOARD}

----------------------------

Your password has been securely stored in our database and cannot be retrieved. In the event that it is forgotten, you will be able to reset it using the email address associated with your account.

'DB_ERR_QUERY_FIRST_TABLE' => 'Error while executing <var>query_first</var>, %s (“%s”).',

'DB_ERR_SELECT' => 'Error while running <code>SELECT</code> query.',

'DB_HOST' => 'Database server hostname or DSN',

'DB_NAME' => 'Database name',

'DB_PASSWORD' => 'Database password',

'DB_PORT' => 'Database server port',

'DEFAULT_INSTALL_POST' => 'This is an example post in your phpBB3 installation. Everything seems to be working. You may delete this post if you like and continue to set up your board. During the installation process your first category and your first forum are assigned an appropriate set of permissions for the predefined usergroups administrators, bots, global moderators, guests, registered users and registered COPPA users. If you also choose to delete your first category and your first forum, do not forget to assign permissions for all these usergroups for all new categories and forums you create. It is recommended to rename your first category and your first forum and copy permissions from these while creating new categories and forums. Have fun!',

'FORUMS_FIRST_CATEGORY' => 'Your first category',

'FORUMS_TEST_FORUM_DESC' => 'Description of your first forum.',

'FORUMS_TEST_FORUM_TITLE' => 'Your first forum',

$parse_sig->bbcode_bitfield = $preview_signature_bitfield;

// Not sure about parameters for bbcode/smilies/urls... in signatures

$preview_signature = $parse_sig->message;

unset($parse_sig);

}

'S_DISPLAY_USERNAME' => (!$user->data['is_registered'] || ($mode == 'edit' && $post_data['poster_id'] == ANONYMOUS)) ? true : false,

'S_SHOW_TOPIC_ICONS' => $s_topic_icons,

'S_DELETE_ALLOWED' => ($mode == 'edit' && (($post_id == $post_data['topic_last_post_id'] && $post_data['poster_id'] == $user->data['user_id'] && $auth->acl_get('f_delete', $forum_id) && !$post_data['post_edit_locked'] && ($post_data['post_time'] > time() - ($config['delete_time'] * 60) || !$config['delete_time'])) || $auth->acl_get('m_delete', $forum_id))) ? true : false,

'S_BBCODE_CHECKED' => ($bbcode_checked) ? ' checked="checked"' : '',

'S_SMILIES_ALLOWED' => $smilies_status,

'S_SMILIES_CHECKED' => ($smilies_checked) ? ' checked="checked"' : '',

case 'mssql':

case 'mssql_odbc':

$sql = 'SELECT search_time, search_keywords

FROM ' . SEARCH_RESULTS_TABLE . '

WHERE DATALENGTH(search_keywords) > 0

</dt>

<dd class="moderation">

<span>{postrow.REPORTER_FULL} &laquo; {postrow.REPORT_TIME}<br />

</dd>

<!-- ENDIF -->

<dd class="mark"><input type="checkbox" name="report_id_list[]" value="{postrow.REPORT_ID}" /></dd>

{S_FORM_TOKEN}

{QR_HIDDEN_FIELDS}

<input type="submit" accesskey="s" tabindex="6" name="post" value="{L_SUBMIT}" class="button1" />&nbsp;

</fieldset>

<a href="" class="right-box up" onclick="hide_qr(false); return false;" title="{L_COLLAPSE_QR}">{L_COLLAPSE_QR}</a>

<span class="corners-bottom"><span></span></span></div>

</h3>

<div id="topicreview">

<!-- BEGIN history_row -->

<div class="post <!-- IF history_row.S_ROW_COUNT is even -->bg1<!-- ELSE -->bg2<!-- ENDIF -->">

<div class="inner"><span class="corners-top"><span></span></span>

make_jumpbox(append_sid("{$phpbb_root_path}viewforum.$phpEx"), $forum_id);

$template->assign_vars(array(

));

// Not postable forum or showing active topics?

'S_WATCH_FORUM_LINK' => $s_watching_forum['link'],

'S_WATCH_FORUM_TITLE' => $s_watching_forum['title'],

'S_WATCHING_FORUM' => $s_watching_forum['is_watching'],

'S_DISPLAY_SEARCHBOX' => ($auth->acl_get('u_search') && $auth->acl_get('f_search', $forum_id) && $config['load_search']) ? true : false,

'S_SEARCHBOX_ACTION' => append_sid("{$phpbb_root_path}search.$phpEx", 'fid[]=' . $forum_id),

'S_SINGLE_MODERATOR' => (!empty($moderators[$forum_id]) && sizeof($moderators[$forum_id]) > 1) ? false : true,

'U_MCP' => ($auth->acl_get('m_', $forum_id)) ? append_sid("{$phpbb_root_path}mcp.$phpEx", "f=$forum_id&amp;i=main&amp;mode=forum_view", true, $user->session_id) : '',

'U_POST_NEW_TOPIC' => ($auth->acl_get('f_post', $forum_id) || $user->data['user_id'] == ANONYMOUS) ? append_sid("{$phpbb_root_path}posting.$phpEx", 'mode=post&amp;f=' . $forum_id) : '',

'U_MARK_TOPICS' => ($user->data['is_registered'] || $config['load_anon_lastread']) ? append_sid("{$phpbb_root_path}viewforum.$phpEx", 'hash=' . generate_link_hash('global') . "&amp;f=$forum_id&amp;mark=topics") : '',

));

{

$row = &$rowset[$topic_id];

// This will allow the style designer to output a different header

// or even separate the list of announcements from sticky and normal topics

$s_type_switch_test = ($row['topic_type'] == POST_ANNOUNCE || $row['topic_type'] == POST_GLOBAL) ? 1 : 0;

// Replies

if ($row['topic_status'] == ITEM_MOVED)

{

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

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

}

// General Viewtopic URL for return links

// Are we watching this topic?

$s_watching_topic = array(

'PAGINATION' => $pagination,

'PAGE_NUMBER' => on_page($total_posts, $config['posts_per_page'], $start),

'TOTAL_POSTS' => ($total_posts == 1) ? $user->lang['VIEW_TOPIC_POST'] : sprintf($user->lang['VIEW_TOPIC_POSTS'], $total_posts),

'MODERATORS' => (isset($forum_moderators[$forum_id]) && sizeof($forum_moderators[$forum_id])) ? implode(', ', $forum_moderators[$forum_id]) : '',

'POST_IMG' => ($topic_data['forum_status'] == ITEM_LOCKED) ? $user->img('button_topic_locked', 'FORUM_LOCKED') : $user->img('button_topic_new', 'POST_NEW_TOPIC'),

'S_SELECT_SORT_KEY' => $s_sort_key,

'S_SELECT_SORT_DAYS' => $s_limit_days,

'S_SINGLE_MODERATOR' => (!empty($forum_moderators[$forum_id]) && sizeof($forum_moderators[$forum_id]) > 1) ? false : true,

'S_TOPIC_MOD' => ($topic_mod != '') ? '<select name="action" id="quick-mod-select">' . $topic_mod . '</select>' : '',

'S_VIEWTOPIC' => true,

'S_DISPLAY_SEARCHBOX' => ($auth->acl_get('u_search') && $auth->acl_get('f_search', $forum_id) && $config['load_search']) ? true : false,

if (!sizeof($voted_id) || sizeof($voted_id) > $topic_data['poll_max_options'] || in_array(VOTE_CONVERTED, $cur_voted_id) || !check_form_key('posting'))

{

meta_refresh(5, $redirect_url);

if (!sizeof($voted_id))

//, topic_last_post_time = ' . time() . " -- for bumping topics with new votes, ignore for now

$db->sql_query($sql);

meta_refresh(5, $redirect_url);

trigger_error($user->lang['VOTE_SUBMITTED'] . '<br /><br />' . sprintf($user->lang['RETURN_TOPIC'], '<a href="' . $redirect_url . '">', '</a>'));