list($orig_column_type, $column_length) = explode(':', $column_data[0]);

$column_type = sprintf($dbms_type_map['mysql_41'][$orig_column_type . ':'], $column_length);

{

switch ($dbms_type_map['mysql_40'][$orig_column_type . ':']['limit'][0])

{

),

);

$schema_data['phpbb_moderator_cache'] = array(

'COLUMNS' => array(

'forum_id' => array('UINT', 0),

'field_default_value' => array('VCHAR_UNI', ''),

'field_validation' => array('VCHAR_UNI:20', ''),

'field_required' => array('BOOL', 0),

'field_show_on_reg' => array('BOOL', 0),

'field_show_on_vt' => array('BOOL', 0),

'field_show_profile' => array('BOOL', 0),

* Location: styles/prosilver/template/simple_footer.html

* Purpose: Add content directly prior to the `</body>` tag of the simple footer

ucp_pm_viewmessage_print_head_append

===

* Location: styles/prosilver/template/ucp_pm_viewmessage_print.html

$decoded_message = bbcode_nl2br($decoded_message);

}

$subject = censor_text($subject);

// We want to make the message available here as a reminder

// Parse the message and subject

// Generate the appropriate user information for the user we are looking at

if (!function_exists('phpbb_get_user_avatar'))

include($phpbb_root_path . 'includes/functions_profile_fields.' . $phpEx);

$coppa = $request->is_set('coppa') ? (int) $request->variable('coppa', false) : false;

$submit = $request->is_set_post('submit');

$change_lang = request_var('change_lang', '');

$user_lang = request_var('lang', $user->lang_name);

$submit = false;

// Setting back agreed to let the user view the agreement in his/her language

}

$user->lang_name = $user_lang = $use_lang;

$add_coppa = ($coppa !== false) ? '&amp;coppa=' . $coppa : '';

$s_hidden_fields = array(

);

// If we change the language, we want to pass on some more possible parameter.

var $new_location;

var $latest_version;

var $current_version;

var $update_to_version;

$this->tpl_name = 'install_update';

$this->page_title = 'UPDATE_INSTALLATION';

$this->old_location = $phpbb_root_path . 'install/update/old/';

$this->new_location = $phpbb_root_path . 'install/update/new/';

// Check if the update files are actually meant to update from the current version

if ($this->current_version != $this->update_info['version']['from'])

{

$template->assign_vars(array(

'S_ERROR' => true,

'ERROR_MSG' => sprintf($user->lang['INCOMPATIBLE_UPDATE_FILES'], $this->current_version, $this->update_info['version']['from'], $this->update_info['version']['to']),

}

// Check if the update files stored are for the latest version...

{

$template->assign_vars(array(

'S_WARNING' => true,

'WARNING_MSG' => sprintf($user->lang['OLD_UPDATE_FILES'], $this->update_info['version']['from'], $this->update_info['version']['to'], $this->latest_version))

}

// What about the language file? Got it updated?

{

$lang = array();

include($this->new_location . 'language/en/install.' . $phpEx);

);

// Print out version the update package updates to

{

$template->assign_var('PACKAGE_VERSION', $this->update_info['version']['to']);

}

Board URL: {U_BOARD}

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

In order to keep your board safe and secure, we highly recommended keeping current with software releases. For your convenience, a mailing list is available at the page referenced above.

),

array(

0 => 'Why isn’t X feature available?',

),

array(

0 => 'Who do I contact about abusive and/or legal matters related to this board?',

if ($member['user_sig'])

{

}

$poster_avatar = phpbb_get_user_avatar($member);

AND module_basename = 'ucp_profile'

AND module_mode = 'signature'";

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

$this->db->sql_freeresult($result);

return $module_auth === 'acl_u_sig' || $module_auth === false;

$tracking_topics = ($tracking_topics) ? tracking_unserialize($tracking_topics) : array();

}

$sql = "SELECT $sql_select

FROM $sql_from

WHERE $sql_where";

);

}

'FORUM_ID' => $forum_id,

'TOPIC_ID' => $result_topic_id,

'POST_ID' => ($show_results == 'posts') ? $row['post_id'] : false,

'U_VIEW_TOPIC' => $view_topic_url,

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

));

if ($show_results == 'topics')

{

phpbb_generate_template_pagination($template, $view_topic_url, 'searchresults.pagination', 'start', $replies + 1, $config['posts_per_page'], 1, true, true);

<dt <!-- IF searchresults.TOPIC_ICON_IMG -->style="background-image: url({T_ICONS_PATH}{searchresults.TOPIC_ICON_IMG}); background-repeat: no-repeat;"<!-- ENDIF --> title="{searchresults.TOPIC_FOLDER_IMG_ALT}">

<div class="list-inner">

<!-- IF searchresults.S_UNREAD_TOPIC --><a href="{searchresults.U_NEWEST_POST}">{NEWEST_POST_IMG}</a> <!-- ENDIF -->

<a href="{searchresults.U_VIEW_TOPIC}" class="topictitle">{searchresults.TOPIC_TITLE}</a> {searchresults.ATTACH_ICON_IMG}

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

</div>

<!-- ENDIF -->

{L_POST_BY_AUTHOR} {searchresults.TOPIC_AUTHOR_FULL} &raquo; {searchresults.FIRST_POST_TIME} &raquo; {L_IN} <a href="{searchresults.U_VIEW_FORUM}">{searchresults.FORUM_TITLE}</a>

</div>

</dt>

<dl class="icon {topicrow.TOPIC_IMG_STYLE}">

<dt<!-- IF topicrow.TOPIC_ICON_IMG and S_TOPIC_ICONS --> style="background-image: url({T_ICONS_PATH}{topicrow.TOPIC_ICON_IMG}); background-repeat: no-repeat;"<!-- ENDIF --> title="{topicrow.TOPIC_FOLDER_IMG_ALT}">

<div class="list-inner">

<!-- IF topicrow.S_UNREAD_TOPIC --><a href="{topicrow.U_NEWEST_POST}">{NEWEST_POST_IMG}</a> <!-- ENDIF --><a href="{topicrow.U_VIEW_TOPIC}" class="topictitle">{topicrow.TOPIC_TITLE}</a>

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

<!-- IF topicrow.S_TOPIC_DELETED --><a href="{topicrow.U_MCP_QUEUE}">{DELETED_IMG}</a> <!-- ENDIF -->

<!-- ENDIF -->

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

<!-- IF topicrow.S_POST_GLOBAL and FORUM_ID != topicrow.FORUM_ID --> &raquo; {L_IN} <a href="{topicrow.U_VIEW_FORUM}">{topicrow.FORUM_NAME}</a><!-- ENDIF -->

</div>

</dt>

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

<table width="100%" cellspacing="0">

<tr>

<td class="genmed">

<div id="notification_list" class="notification_list">

<div class="row1 header">

{L_NOTIFICATIONS}

<!-- ENDIF -->

</td>

<td class="row1">

<!-- IF searchresults.S_UNREAD_TOPIC --><a href="{searchresults.U_NEWEST_POST}" class="imageset">{NEWEST_POST_IMG}</a><!-- ENDIF -->

{searchresults.ATTACH_ICON_IMG} <a href="{searchresults.U_VIEW_TOPIC}" class="topictitle">{searchresults.TOPIC_TITLE}</a>

<!-- IF searchresults.S_TOPIC_UNAPPROVED or searchresults.S_POSTS_UNAPPROVED -->

] </p>

<!-- ENDIF -->

<p class="gensmall">{L_IN} <a href="{searchresults.U_VIEW_FORUM}">{searchresults.FORUM_TITLE}</a></p>

</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>

<td class="row1" width="25" align="center"><!-- IF topicrow.TOPIC_ICON_IMG --><img src="{T_ICONS_PATH}{topicrow.TOPIC_ICON_IMG}" width="{topicrow.TOPIC_ICON_IMG_WIDTH}" height="{topicrow.TOPIC_ICON_IMG_HEIGHT}" alt="" title="" /><!-- ENDIF --></td>

<!-- ENDIF -->

<td class="row1">

<!-- IF topicrow.S_UNREAD_TOPIC --><a href="{topicrow.U_NEWEST_POST}" class="imageset">{NEWEST_POST_IMG}</a><!-- ENDIF -->

{topicrow.ATTACH_ICON_IMG} <!-- IF topicrow.S_HAS_POLL or topicrow.S_TOPIC_MOVED --><b>{topicrow.TOPIC_TYPE}</b> <!-- ENDIF --><a title="{L_POSTED}{L_COLON} {topicrow.FIRST_POST_TIME}" href="{topicrow.U_VIEW_TOPIC}"class="topictitle">{topicrow.TOPIC_TITLE}</a>

<!-- IF topicrow.S_TOPIC_UNAPPROVED or topicrow.S_POSTS_UNAPPROVED -->

<!-- END 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>

<td class="row1" width="25" align="center"><!-- IF topicrow.TOPIC_ICON_IMG --><img src="{T_ICONS_PATH}{topicrow.TOPIC_ICON_IMG}" width="{topicrow.TOPIC_ICON_IMG_WIDTH}" height="{topicrow.TOPIC_ICON_IMG_HEIGHT}" alt="" title="" /><!-- ENDIF --></td>

<!-- ENDIF -->

<td class="row1">

<!-- IF topicrow.S_UNREAD_TOPIC --><a href="{topicrow.U_NEWEST_POST}" class="imageset">{NEWEST_POST_IMG}</a><!-- ENDIF -->

{topicrow.ATTACH_ICON_IMG} <!-- IF topicrow.S_HAS_POLL or topicrow.S_TOPIC_MOVED --><b>{topicrow.TOPIC_TYPE}</b> <!-- ENDIF --><a title="{L_POSTED}{L_COLON} {topicrow.FIRST_POST_TIME}" href="{topicrow.U_VIEW_TOPIC}" class="topictitle">{topicrow.TOPIC_TITLE}</a>

<!-- IF topicrow.S_TOPIC_UNAPPROVED or topicrow.S_POSTS_UNAPPROVED -->

] </p>

<!-- ENDIF -->

<!-- IF topicrow.S_POST_GLOBAL and FORUM_ID != topicrow.FORUM_ID --><p class="gensmall">{L_IN} <a href="{topicrow.U_VIEW_FORUM}">{topicrow.FORUM_NAME}</a></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>

'LEFT_JOIN' => array(),

);

$sql_approved = ' AND ' . $phpbb_content_visibility->get_visibility_sql('topic', $forum_id, 't.');

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

$sql = 'SELECT *

FROM ' . TOPICS_TABLE . '

WHERE ' . $db->sql_in_set('topic_id', array_keys($shadow_topic_list));

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

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

$poll_total += $poll_option['poll_option_total'];

}

for ($i = 0, $size = sizeof($poll_info); $i < $size; $i++)

{

}

foreach ($poll_info as $poll_option)

{

// End signature parsing, only if needed

if ($user_cache[$poster_id]['sig'] && $row['enable_sig'] && empty($user_cache[$poster_id]['sig_parsed']))

{

}

// Parse the message and subject

if (!empty($attachments[$row['post_id']]))

{