'MTEXT' => 'mediumtext',

'TIMESTAMP' => 'int(11) UNSIGNED',

'DECIMAL' => 'decimal(5,2)',

'VCHAR_CI' => 'varchar(252)',

'VARBINARY' => 'varbinary(255)',

),

'MTEXT' => 'BLOB SUB_TYPE TEXT',

'TIMESTAMP' => 'INTEGER',

'DECIMAL' => 'DOUBLE PRECISION',

'VCHAR_CI' => 'VARCHAR(252)',

'VARBINARY' => 'CHAR(255)',

),

'MTEXT' => 'clob',

'TIMESTAMP' => 'number(11)',

'DECIMAL' => 'number(5, 2)',

'VCHAR_CI' => 'varchar2(252)',

'VARBINARY' => 'raw(255)',

),

'MTEXT' => 'mediumtext(16777215)',

'TIMESTAMP' => 'INTEGER UNSIGNED', //'int(11) UNSIGNED',

'DECIMAL' => 'decimal(5,2)',

'VCHAR_CI' => 'varchar(252)',

'VARBINARY' => 'blob',

),

case 'sqlite':

$line = "#\n# SQLite Schema for phpBB 3.x - (c) phpBB Group, 2005\n#\n# \$I" . "d: $\n#\n\n";

break;

case 'mssql':

case 'sqlite':

// Remove last line delimiter...

$line = substr($line, 0, -2);

break;

}

break;

case 'sqlite':

case 'postgres':

$line .= ($key_data[0] == 'INDEX') ? 'CREATE INDEX' : '';

$line .= ($key_data[0] == 'UNIQUE') ? 'CREATE UNIQUE INDEX' : '';

break;

case 'sqlite':

case 'postgres':

$line = "\nCOMMIT;";

break;

'ban_give_reason' => array('STEXT', ''),

),

'PRIMARY_KEY' => 'ban_id',

);

$schema_data['phpbb_bbcodes'] = array(

'code' => array('VCHAR:8', ''),

),

'PRIMARY_KEY' => array('session_id', 'confirm_id'),

);

$schema_data['phpbb_disallow'] = array(

'rule_folder_id' => array('INT:4', 0),

),

'PRIMARY_KEY' => 'rule_id',

);

$schema_data['phpbb_privmsgs_to'] = array(

),

'KEYS' => array(

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

'usr_flder_id' => array('INDEX', array('user_id', 'folder_id')),

),

);

),

'KEYS' => array(

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

),

);

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

),

);

break;

case 'edit':

FROM ' . BBCODES_TABLE . '

WHERE bbcode_id = ' . $bbcode_id;

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

'load_online_time' => array('lang' => 'ONLINE_LENGTH', 'type' => 'text:4:3', 'explain' => true),

'legend2' => 'GENERAL_OPTIONS',

'legend3' => 'CUSTOM_PROFILE_FIELDS',

'load_cpf_memberlist' => array('lang' => 'LOAD_CPF_MEMBERLIST', 'type' => 'radio:yes_no', 'explain' => false),

$notice = $user->lang[$lang . '_DELETED'];

break;

case 'move_up':

$db->sql_query('DELETE FROM ' . FORUMS_TRACK_TABLE . " WHERE user_id = {$user->data['user_id']}");

$db->sql_query('UPDATE ' . USERS_TABLE . ' SET user_lastmark = ' . time() . " WHERE user_id = {$user->data['user_id']}");

}

{

$tracking_topics = (isset($_COOKIE[$config['cookie_name'] . '_track'])) ? ((STRIP) ? stripslashes($_COOKIE[$config['cookie_name'] . '_track']) : $_COOKIE[$config['cookie_name'] . '_track']) : '';

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

}

}

}

{

$tracking = (isset($_COOKIE[$config['cookie_name'] . '_track'])) ? ((STRIP) ? stripslashes($_COOKIE[$config['cookie_name'] . '_track']) : $_COOKIE[$config['cookie_name'] . '_track']) : '';

$tracking = ($tracking) ? unserialize($tracking) : array();

$db->sql_return_on_error(false);

}

}

{

$tracking = (isset($_COOKIE[$config['cookie_name'] . '_track'])) ? ((STRIP) ? stripslashes($_COOKIE[$config['cookie_name'] . '_track']) : $_COOKIE[$config['cookie_name'] . '_track']) : '';

$tracking = ($tracking) ? unserialize($tracking) : array();

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

{

}

else

{

}

}

}

{

global $tracking_topics;

return $last_read;

}

// Pagination functions

/**

// Display list of active topics for this category?

$show_active = (isset($root_data['forum_flags']) && $root_data['forum_flags'] & 16) ? true : false;

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

{

$sql_from = FORUMS_TABLE . ' f LEFT JOIN ' . FORUMS_TRACK_TABLE . ' ft ON (ft.user_id = ' . $user->data['user_id'] . ' AND ft.forum_id = f.forum_id)';

$lastread_select = ', ft.mark_time ';

}

{

$tracking_topics = (isset($_COOKIE[$config['cookie_name'] . '_track'])) ? ((STRIP) ? stripslashes($_COOKIE[$config['cookie_name'] . '_track']) : $_COOKIE[$config['cookie_name'] . '_track']) : '';

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

{

$forum_tracking_info[$forum_id] = (!empty($row['mark_time'])) ? $row['mark_time'] : $user->data['user_lastmark'];

}

{

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

{

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

markread('topic', $data['forum_id'], $data['topic_id'], time());

// Send Notifications

if ($mode != 'edit' && $mode != 'delete' && ($auth->acl_get('f_noapprove', $data['forum_id']) || $auth->acl_get('m_approve', $data['forum_id'])))

{

$sql = 'DELETE FROM ' . SESSIONS_TABLE . "

$sql_where";

$db->sql_query($sql);

}

}

LEFT JOIN ' . PRIVMSGS_TABLE . ' p ON (a.post_msg_id = p.msg_id AND a.in_message = 1)

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

ORDER BY $order_by";

$row_count = 0;

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

$db->sql_freeresult($result);

$template->assign_vars(array(

'TOTAL_ATTACHMENTS' => $num_attachments,

'L_TITLE' => $user->lang['UCP_ATTACHMENTS'],

'PAGINATION' => generate_pagination($this->u_action . "&action=$action&g=$group_id", $total_members, $config['topics_per_page'], $start, true),

'U_ACTION' => $this->u_action . "&g=$group_id",

);

break;

'LOAD_USER_ACTIVITY_EXPLAIN' => 'Displays active topic/forum in user profiles and user control panel. It is recommended to disable this on boards with more than one million posts.',

'RECOMPILE_TEMPLATES' => 'Recompile stale templates',

'RECOMPILE_TEMPLATES_EXPLAIN' => 'Check for updated template files on filesystem and recompile.',

'YES_BIRTHDAYS' => 'Enable birthday listing',

'YES_JUMPBOX' => 'Enable display of Jumpbox',

'YES_MODERATORS' => 'Enable display of Moderators',

}

}

{

$tracking_topics = (isset($_COOKIE[$config['cookie_name'] . '_track'])) ? ((STRIP) ? stripslashes($_COOKIE[$config['cookie_name'] . '_track']) : $_COOKIE[$config['cookie_name'] . '_track']) : '';

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

{

$topic_tracking_info[$forum_id] = get_topic_tracking($forum_id, $forum['topic_list'], $forum['rowset'], array($forum_id => $forum['mark_time']), ($forum_id) ? false : $forum['topic_list']);

}

{

$topic_tracking_info[$forum_id] = get_complete_topic_tracking($forum_id, $forum['topic_list'], ($forum_id) ? false : $forum['topic_list']);

<th colspan="5">{L_UCP}</th>

</tr>

<tr>

</tr>

<tr>

<th colspan="5">{L_BOOKMARKS}</th>

<th colspan="4">{L_UCP}</th>

</tr>

<tr>

</tr>

<tr>

<th colspan="4">{L_WATCHED_FORUMS}</th>

}

$sql_from = FORUMS_TABLE . ' f';

// Grab appropriate forum data

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

{

$sql_from .= ' LEFT JOIN ' . FORUMS_TRACK_TABLE . ' ft ON (ft.user_id = ' . $user->data['user_id'] . '

AND ft.forum_id = f.forum_id)';

}

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

if (sizeof($topic_list))

{

$mark_forum_read = true;

// Active topics?

if ($s_display_active && sizeof($active_forum_ary))

$topic_tracking_info += get_topic_tracking($f_id, $topic_row['topics'], $rowset, array($f_id => $topic_row['forum_mark_time']), false);

}

}

{

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

{

$topic_tracking_info = get_topic_tracking($forum_id, $topic_list, $rowset, array($forum_id => $forum_data['mark_time']), $global_announce_list);

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

}

{

$topic_tracking_info = get_complete_topic_tracking($forum_id, $topic_list, $global_announce_list);

// after reading a topic

if ($forum_data['forum_type'] == FORUM_POST && sizeof($topic_list) && $mark_forum_read)

{

}

page_footer();

// Get topic tracking info

if (!isset($topic_tracking_info))

{

// Get topic tracking info

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

{

$topic_tracking_info = get_topic_tracking($forum_id, $topic_id, $tmp_topic_data, array($forum_id => $topic_data['forum_mark_time']));

unset($tmp_topic_data);

}

{

$topic_tracking_info = get_complete_topic_tracking($forum_id, $topic_id);

}

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

{

if ($poll_bbcode !== false)

{

$poll_bbcode->bbcode_second_pass($poll_info[$i]['poll_option_text'], $poll_info[$i]['bbcode_uid'], $poll_option['bbcode_bitfield']);

}

$poll_info[$i]['poll_option_text'] = smiley_text($poll_info[$i]['poll_option_text']);

}

if ($poll_bbcode !== false)

{

$poll_bbcode->bbcode_second_pass($topic_data['poll_title'], $poll_info[0]['bbcode_uid'], $poll_info[0]['bbcode_bitfield']);

}

$topic_data['poll_title'] = smiley_text($topic_data['poll_title']);

unset($poll_bbcode);

{

$diff = ($diff < 0) ? 1 : 0;

}

$user_cache[$poster_id]['age'] = (int) ($today['year'] - $bday_year - $diff);

}

}

}

// Instantiate BBCode if need be

{

include_once($phpbb_root_path . 'includes/bbcode.' . $phpEx);

$bbcode = new bbcode($bbcode_bitfield);

// End signature parsing, only if needed

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

{

if ($user_cache[$poster_id]['sig_bbcode_bitfield'])

{

$bbcode->bbcode_second_pass($user_cache[$poster_id]['sig'], $user_cache[$poster_id]['sig_bbcode_uid'], $user_cache[$poster_id]['sig_bbcode_bitfield']);

}

$user_cache[$poster_id]['sig'] = smiley_text($user_cache[$poster_id]['sig']);

$user_cache[$poster_id]['sig_parsed'] = true;

}

// Parse the message and subject

// Second parse bbcode here

if ($row['bbcode_bitfield'])

// Replace naughty words such as farty pants

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

// Editing information

if (($row['post_edit_count'] && $config['display_last_edited']) || $row['post_edit_reason'])

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

{

markread('topic', $forum_id, $topic_id, $max_post_time);

}

// Change encoding if appropriate