<fieldset>

<legend>{L_TEAMPAGE_SETTINGS}</legend>

<dl>

<dd>

</dd>

</dl>

<dl>

</div>

<!-- ENDIF -->

<!-- IF S_WRITABLE_CONFIG -->

<div class="errorbox notice">

<p>{L_WRITABLE_CONFIG}</p>

<fieldset>

<legend>{L_SELECT_USER}</legend>

<dl>

<dd><input class="text medium" type="text" id="username" name="username" /></dd>

<dd>[ <a href="{U_FIND_USERNAME}" onclick="find_username(this.href); return false;">{L_FIND_USERNAME}</a> ]</dd>

<dd class="full" style="text-align: left;"><label><input type="checkbox" class="radio" id="anonymous" name="u" value="{ANONYMOUS_USER_ID}" /> {L_SELECT_ANONYMOUS}</label></dd>

</div>

</div>

</body>

</html>

</div>

</div>

</body>

</html>

</div>

</body>

</html>

exit;

}

// Load Extensions

// dl() is deprecated and disabled by default as of PHP 5.3.

if (!empty($load_extensions) && function_exists('dl'))

* If you overwrite the original schema files please make sure you save the file with UNIX linefeeds.

*/

if (!is_writable($schema_path))

{

foreach ($supported_dbms as $dbms)

{

$line = '';

{

case 'mysql_40':

case 'mysql_41':

break;

case 'firebird':

$line .= custom_data('firebird') . "\n";

break;

case 'sqlite':

$line .= "BEGIN TRANSACTION;\n\n";

break;

case 'oracle':

$line .= custom_data('oracle') . "\n";

break;

case 'postgres':

$line .= "BEGIN;\n\n";

$line .= custom_data('postgres') . "\n";

break;

'style_active' => array('BOOL', 1),

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

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

),

'PRIMARY_KEY' => 'style_id',

'KEYS' => array(

'style_name' => array('UNIQUE', 'style_name'),

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

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

),

);

),

);

$schema_data['phpbb_topics'] = array(

'COLUMNS' => array(

'topic_id' => array('UINT', NULL, 'auto_increment'),

<p>The relevant database type/version is listed within the administration control panel</p>

<p>Once a bug has been submitted you will be emailed any follow up comments added to it. <strong>Please</strong> if you are requested to supply additional information, do so! It is frustrating for us to receive bug reports, ask for additional information but get nothing. In these cases we have a policy of closing the bug, which may leave a very real problem in place. Obviously we would rather not have this situation arise.</p>

<li><a href="#writingstyle">Writing Style</a></li>

</ol>

</li>

<li><a href="#disclaimer">Copyright and disclaimer</a></li>

</ol>

$post_url = $phpbb_root_path . 'posting.' . $phpEx . '?mode=' . $mode . '&amp;amp;start=' . $start;

</pre></div>

<div class="codebox"><pre>

$post_url = "{$phpbb_root_path}posting.$phpEx?mode=$mode&amp;amp;start=$start";

</pre></div>

<h4>Commas after every array element:</h4>

<p>If an array is defined with each element on its own line, you still have to modify the previous line to add a comma when appending a new element. PHP allows for trailing (useless) commas in array definitions. These should always be used so each element including the comma can be appended with a single line</p>

<p>Each complex function should be preceded by a comment that tells a programmer everything they need to know to use that function. The meaning of every parameter, the expected input, and the output are required as a minimal comment. The function's behaviour in error conditions (and what those error conditions are) should also be present - but mostly included within the comment about the output.<br /><br />Especially important to document are any assumptions the code makes, or preconditions for its proper operation. Any one of the developers should be able to look at any part of the application and figure out what's going on in a reasonable amount of time.<br /><br />Avoid using <code>/* */</code> comment blocks for one-line comments, <code>//</code> should be used for one/two-liners.</p>

<h4>Magic numbers:</h4>

<h4>Shortcut operators:</h4>

<p>The only shortcut operators that cause readability problems are the shortcut increment <code>$i++</code> and decrement <code>$j--</code> operators. These operators should not be used as part of an expression. They can, however, be used on their own line. Using them in expressions is just not worth the headaches when debugging, examples:</p>

</pre></div>

<h4>SQL Quotes: </h4>

<p class="bad">// These are wrong.</p>

<div class="codebox"><pre>

<h4>sql_build_query():</h4>

<div class="codebox"><pre>

$sql_array = array(

</pre></div>

<h4>Use of in_array(): </h4>

<a name="general"></a><h3>2.v. General Guidelines</h3>

<p>No attempt should be made to remove any copyright information (either contained within the source or displayed interactively when the source is run/compiled), neither should the copyright information be altered in any way (it may be added to).</p>

<h4>Variables: </h4>

<p>The request_var function determines the type to set from the second parameter (which determines the default value too). If you need to get a scalar variable type, you need to tell this the request_var function explicitly. Examples:</p>

<p class="bad">// Old method, do not use it</p>

<p>The <code>$user-&gt;setup()</code> call can be used to pass on additional language definition and a custom style (used in viewforum).</p>

<h4>Errors and messages: </h4>

<div class="codebox"><pre>

trigger_error('NO_FORUM');

<p>All urls pointing to internal files need to be prepended by the <code>$phpbb_root_path</code> variable. Within the administration control panel all urls pointing to internal files need to be prepended by the <code>$phpbb_admin_path</code> variable. This makes sure the path is always correct and users being able to just rename the admin folder and the acp still working as intended (though some links will fail and the code need to be slightly adjusted).</p>

<div class="codebox"><pre>

append_sid(&quot;{$phpbb_root_path}memberlist.$phpEx&quot;, 'mode=group&amp;amp;g=' . $row['group_id'])

<h4>General function usage: </h4>

<ul>

<li>

required_imageset = prosilver

</pre></div>

<a name="genstyling"></a><h3>3.2. General Styling Rules</h3>

<p>The outer table class <code>forumline</code> has gone and is replaced with <code>tablebg</code>.</p>

<p>When writing <code>&lt;table&gt;</code> the order <code>&lt;table class="" cellspacing="" cellpadding="" border="" align=""&gt;</code> creates consistency and allows everyone to easily see which table produces which "look". The same applies to most other tags for which additional parameters can be set, consistency is the major aim here.</p>

<p>Row colours/classes are now defined by the template, use an <code>IF S_ROW_COUNT</code> switch, see viewtopic or viewforum for an example.</p>

<p>Use a standard cellpadding of 2 and cellspacing of 0 on outer tables. Inner tables can vary from 0 to 3 or even 4 depending on the need.</p>

<a name="templates"></a><h3>4.i. General Templating</h3>

<h4>File naming</h4>

<h4>Variables</h4>

<p>All template variables should be named appropriately (using underscores for spaces), language entries should be prefixed with L_, system data with S_, urls with U_, javascript urls with UA_, language to be put in javascript statements with LA_, all other variables should be presented 'as is'.</p>

</p>

<h4>Blocks/Loops</h4>

<span class="comment">&lt;!-- END l_block1 --&gt;</span>

</pre></div>

<div class="codebox"><pre>

<span class="comment">&lt;!-- BEGIN l_block1 --&gt;</span>

&lt;/ul&gt; <span class="comment">&lt;!-- written on third iteration --&gt;</span>

</pre></div>

<h4>Forms</h4>

<p>If a form is used for a non-trivial operation (i.e. more than a jumpbox), then it should include the <code>{S_FORM_TOKEN}</code> template variable.</p>

</pre></div><br />

<a name="inheritance"></a><h3>4.ii. Template Inheritance</h3>

<p>We strongly encourage the use of inheritance for styles based on the bundled styles, as it will ease the update procedure.</p>

<h4>Encoding:</h4>

<p>The impact is that the language files for phpBB must now also be encoded as UTF-8, with a caveat that the files must <strong>not contain</strong> a <abbr title="Byte-Order-Mark">BOM</abbr> for compatibility reasons with non-Unicode aware versions of PHP. For those with forums using the Latin character set (ie: most European languages), this change is transparent since UTF-8 is superset to US-ASCII and ISO-8859-1.</p>

<hr />

<div class="paragraph">

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

}

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

$ban_length = $ban_reasons = $ban_give_reasons = array();

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

{

$time_length = ($row['ban_end']) ? ($row['ban_end'] - $row['ban_start']) / 60 : 0;

}

}

$template->assign_vars(array(

'S_BAN_END_OPTIONS' => $ban_end_options,

}

}

'load_cpf_pm' => array('lang' => 'LOAD_CPF_PM', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => false),

'load_cpf_viewprofile' => array('lang' => 'LOAD_CPF_VIEWPROFILE', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => false),

'load_cpf_viewtopic' => array('lang' => 'LOAD_CPF_VIEWTOPIC', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => false),

'legend3' => 'ACP_SUBMIT_CHANGES',

)

'hot_threshold' => array('lang' => 'HOT_THRESHOLD', 'validate' => 'int:0', 'type' => 'text:3:4', 'explain' => true),

'max_poll_options' => array('lang' => 'MAX_POLL_OPTIONS', 'validate' => 'int:2:127', 'type' => 'text:4:4', 'explain' => false),

'max_post_chars' => array('lang' => 'CHAR_LIMIT', 'validate' => 'int:0', 'type' => 'text:4:6', 'explain' => true),

'max_post_smilies' => array('lang' => 'SMILIES_LIMIT', 'validate' => 'int:0', 'type' => 'text:4:4', 'explain' => true),

'max_post_urls' => array('lang' => 'MAX_POST_URLS', 'validate' => 'int:0', 'type' => 'text:5:4', 'explain' => true),

'max_post_font_size' => array('lang' => 'MAX_POST_FONT_SIZE', 'validate' => 'int:0', 'type' => 'text:5:4', 'explain' => true, 'append' => ' %'),

$i = $j = 0;

$email_list = array();

$old_lang = $row['user_lang'];

$old_notify_type = $row['user_notify_type'];

$message = ($action == 'add') ? $user->lang['FORUM_CREATED'] : $user->lang['FORUM_UPDATED'];

// redirect directly to permission settings screen if authed

if ($action == 'add' && !$copied_permissions && $auth->acl_get('a_fauth'))

{

meta_refresh(4, append_sid("{$phpbb_admin_path}index.$phpEx", 'i=permissions' . $acl_url));

}

$errors = array();

{

$errors[] = $user->lang['FORUM_NAME_EMPTY'];

}

// Only set the rank, colour, etc. if it's changed or if we're adding a new

// group. This prevents existing group members being updated if no changes

// were made.

$group_attributes = array();

$test_variables = array(

foreach ($test_variables as $test => $type)

{

{

settype($submit_ary[$test], $type);

$group_attributes['group_' . $test] = $group_row['group_' . $test] = $submit_ary[$test];

case 'set_config_teampage':

set_config('teampage_forums', request_var('teampage_forums', 0));

break;

case 'add':

'U_ACTION_LEGEND' => $this->u_action . '&amp;field=legend',

'U_ACTION_TEAMPAGE' => $this->u_action . '&amp;field=teampage',

));

}

}

$default_lang_id = (int) $db->sql_fetchfield('lang_id');

$db->sql_freeresult($result);

// From the mysql documentation:

// Prior to MySQL 4.0.14, the target table of the INSERT statement cannot appear in the FROM clause of the SELECT part of the query. This limitation is lifted in 4.0.14.

// Due to this we stay on the safe side if we do the insertion "the manual way"

{

$row['lang_id'] = $lang_id;

$db->sql_query('INSERT INTO ' . PROFILE_LANG_TABLE . ' ' . $db->sql_build_array('INSERT', $row));

}

$db->sql_freeresult($result);

{

$row['lang_id'] = $lang_id;

$db->sql_query('INSERT INTO ' . PROFILE_FIELDS_LANG_TABLE . ' ' . $db->sql_build_array('INSERT', $row));

}

$db->sql_freeresult($result);

add_log('admin', 'LOG_LANGUAGE_PACK_INSTALLED', $lang_pack['name']);

break;

$template->assign_var('S_WRITABLE_CONFIG', (bool) (@fileperms($phpbb_root_path . 'config.' . $phpEx) & 0x0002));

}

// Fill dbms version if not yet filled

if (empty($config['dbms_version']))

{

'RANK_TITLE' => (isset($ranks['rank_title'])) ? $ranks['rank_title'] : '',

'S_FILENAME_LIST' => $filename_list,

'RANK_IMAGE' => ($edit_img) ? $phpbb_root_path . $config['ranks_path'] . '/' . $edit_img : $phpbb_admin_path . 'images/spacer.gif',

'MIN_POSTS' => (isset($ranks['rank_min']) && !$ranks['rank_special']) ? $ranks['rank_min'] : 0)

);

$errstr = '';

$errno = 0;

if ($info === false)

{

// Which updates do we need to do?

$update_username = ($user_row['username'] != $data['username']) ? $data['username'] : false;

$update_email = ($data['email'] != $user_row['user_email']) ? $data['email'] : false;

if (!sizeof($error))

if (!$row)

{

return array(

'status' => LOGIN_ERROR_USERNAME,

'error_msg' => 'LOGIN_ERROR_USERNAME',

}

/**

* Check if table exists

*

*

}

/**

*

*

*/

{

switch ($this->sql_layer)

{

case 'mysql_40':

case 'mysql_41':

$sql = "SHOW COLUMNS FROM $table";

break;

// PostgreSQL has a way of doing this in a much simpler way but would

WHERE c.relname = '{$table}'

AND a.attnum > 0

AND a.attrelid = c.oid";

break;

// same deal with PostgreSQL, we must perform more complex operations than

FROM syscolumns c

LEFT JOIN sysobjects o ON c.id = o.id

WHERE o.name = '{$table}'";

break;

case 'oracle':

$sql = "SELECT column_name

FROM user_tab_columns

WHERE LOWER(table_name) = '" . strtolower($table) . "'";

break;

case 'firebird':

$sql = "SELECT RDB\$FIELD_NAME as FNAME

FROM RDB\$RELATION_FIELDS

WHERE RDB\$RELATION_NAME = '" . strtoupper($table) . "'";

break;

case 'sqlite':

$sql = "SELECT sql

FROM sqlite_master

WHERE type = 'table'

AND name = '{$table}'";

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

if (!$result)

continue;

}

}

break;

}

}

/**

case 'mysql_40':

case 'mysql_41':

break;

case 'mssql':

}

// no break

case 'mysql_41':

break;

case 'mssql':

return $cache->sql_fetchrow($query_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)

}

}

// Check the forum for any left unread topics.

// If there are none, we mark the forum as read.

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

LEFT JOIN ' . TOPICS_TRACK_TABLE . ' tt ON (tt.topic_id = t.topic_id AND tt.user_id = ' . $user->data['user_id'] . ')

WHERE t.forum_id = ' . $forum_id . '

AND t.topic_last_post_time > ' . $mark_time_forum . '

AND (tt.topic_id IS NULL OR tt.mark_time < t.topic_last_post_time)

GROUP BY t.forum_id';

$result = $db->sql_query_limit($sql, 1);

FROM ' . TOPICS_TABLE . '

WHERE forum_id = ' . $forum_id . '

AND topic_last_post_time > ' . $mark_time_forum . '

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

$check_forum = $tracking_topics['tf'][$forum_id];

$start_cnt = min(max(1, $on_page - 4), $total_pages - 5);

$end_cnt = max(min($total_pages, $on_page + 4), 6);

for ($i = $start_cnt + 1; $i < $end_cnt; $i++)

{

}

}

}

else

{

$inline = ($mode == 'relative_url') ? ')' : '';

return "(?:[a-z0-9\-._~!$&'($inline*+,;=:@|]+|%[\dA-F]{2})*(?:/(?:[a-z0-9\-._~!$&'($inline*+,;=:@|]+|%[\dA-F]{2})*)*(?:\?(?:[a-z0-9\-._~!$&'($inline*+,;=:@/?|]+|%[\dA-F]{2})*)?(?:\#(?:[a-z0-9\-._~!$&'($inline*+,;=:@/?|]+|%[\dA-F]{2})*)?";

break;

}

return '';

'T_STYLESHEET_LINK' => "{$web_path}styles/" . $user->theme['theme_path'] . '/theme/stylesheet.css',

'T_STYLESHEET_LANG_LINK' => "{$web_path}styles/" . $user->theme['theme_path'] . '/theme/' . $user->lang_name . '/stylesheet.css',

'T_STYLESHEET_NAME' => $user->theme['theme_name'],

'T_THEME_NAME' => $user->theme['theme_path'],

'T_THEME_LANG_NAME' => $user->data['user_lang'],

if ($auth->acl_get('a_') && defined('DEBUG_EXTRA'))

{

{

{

$memory_usage = get_formatted_filesize($memory_usage);

}

}

if ($auth->acl_get('a_') && defined('DEBUG_EXTRA'))

{

{

{

$memory_usage = get_formatted_filesize($memory_usage);

}

}

'DEBUG_OUTPUT' => (defined('DEBUG')) ? $debug_output : '',

'TRANSLATION_INFO' => (!empty($user->lang['TRANSLATION_INFO'])) ? $user->lang['TRANSLATION_INFO'] : '',

'S_COPYRIGHT_HTML' => $copyright_html,

'VERSION' => $config['version'])

);

/**

* Retrieve contents from remotely stored file

*/

{

global $user;

@fputs($fsock, "HOST: $host\r\n");

@fputs($fsock, "Connection: close\r\n\r\n");

$file_info = '';

$get_info = false;

return false;

}

}

}

@fclose($fsock);

}

'S_NO_CAT' => $catless && !$last_catless,

'S_IS_LINK' => ($row['forum_type'] == FORUM_LINK) ? true : false,

'S_UNREAD_FORUM' => $forum_unread,

'S_LOCKED_FORUM' => ($row['forum_status'] == ITEM_LOCKED) ? true : false,

'S_LIST_SUBFORUMS' => ($row['display_subforum_list']) ? true : false,

'S_SUBFORUMS' => (sizeof($subforums_list)) ? true : false,

$pagination .= '<a href="' . $url . ($j == 0 ? '' : '&amp;start=' . $j) . '">' . $times . '</a>';

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

{

// Display the last three pages

$times = $total_pages - 3;

$match_id = ($mode == 'forum') ? $forum_id : $topic_id;

$u_url = "uid={$user->data['user_id']}";

$u_url .= ($mode == 'forum') ? '&amp;f' : '&amp;f=' . $forum_id . '&amp;t';

// Is user watching this thread?

if ($user_id != ANONYMOUS)

$uid = request_var('uid', 0);

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

{

{

$redirect_url = append_sid("{$phpbb_root_path}view$mode.$phpEx", "$u_url=$match_id&amp;start=$start");

$message = $user->lang['ERR_UNWATCHING'] . '<br /><br />' . sprintf($user->lang['RETURN_' . strtoupper($mode)], '<a href="' . $redirect_url . '">', '</a>');

$db->sql_query($sql);

$redirect_url = append_sid("{$phpbb_root_path}view$mode.$phpEx", "$u_url=$match_id&amp;start=$start");

meta_refresh(3, $redirect_url);

trigger_error($message);

}

$s_hidden_fields['t'] = $topic_id;

}

confirm_box(false, $confirm_box_message, build_hidden_fields($s_hidden_fields));

}

}

$uid = request_var('uid', 0);

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

{

{

$redirect_url = append_sid("{$phpbb_root_path}view$mode.$phpEx", "$u_url=$match_id&amp;start=$start");

$message = $user->lang['ERR_WATCHING'] . '<br /><br />' . sprintf($user->lang['RETURN_' . strtoupper($mode)], '<a href="' . $redirect_url . '">', '</a>');

'DRIVER' => 'mssqlnative',

'AVAILABLE' => true,

'2.0.x' => false,

'oracle' => array(

'LABEL' => 'Oracle',

'SCHEMA' => 'oracle',

/**

* Get tables of a database

*/

{

{

}

}

/**

return (!empty($lang[$matches[1]])) ? $db->sql_escape($lang[$matches[1]]) : $db->sql_escape($matches[1]);

}

}

Ability to simply add own rules by doing three things:

1) Add an appropriate constant

2) Add a new check array to the global_privmsgs_rules variable and the condition array (if one is required)

The user is then able to select the new rule. It will be checked against and handled as specified.

To add new actions (yes, checks can be added here too) to the rule management, the core code has to be modified.

*/

$global_privmsgs_rules = array(

CHECK_SUBJECT => array(

),

CHECK_SENDER => array(

),

CHECK_MESSAGE => array(

),

CHECK_STATUS => array(

),

CHECK_TO => array(

)

);

$check_ary = $rules[$rule_row['rule_check']][$rule_row['rule_connection']];

if (!$result)

{

// Send Notifications

if ($mode != 'edit')

{

}

return $data['msg_id'];

/**

* PM Notification

*/

{

global $db, $user, $config, $phpbb_root_path, $phpEx, $auth;

'AUTHOR_NAME' => htmlspecialchars_decode($author),

'USERNAME' => htmlspecialchars_decode($addr['name']),

$messenger->send($addr['method']);

}

{

global $auth, $user, $db, $phpEx, $phpbb_root_path;

switch ($action)

{

case 'make_announce':

default:

$new_topic_type = POST_NORMAL;

$l_new_type = (sizeof($topic_ids) == 1) ? 'MCP_MAKE_NORMAL' : 'MCP_MAKE_NORMALS';

break;

}

$redirect = request_var('redirect', build_url(array('action', 'quickmod')));

$s_hidden_fields = array(

}

// Get Reports

{

$sql = 'SELECT r.*, re.*, u.user_id, u.username

FROM ' . REPORTS_TABLE . ' r, ' . USERS_TABLE . ' u, ' . REPORTS_REASONS_TABLE . " re

'MINI_POST_IMG' => ($post_unread) ? $user->img('icon_post_target_unread', 'UNREAD_POST') : $user->img('icon_post_target', 'POST'),

'S_CHECKED' => (($submitted_id_list && !in_array(intval($row['post_id']), $submitted_id_list)) || in_array(intval($row['post_id']), $checked_ids)) ? true : false,

'S_HAS_ATTACHMENTS' => (!empty($attachments[$row['post_id']])) ? true : false,

unset($input);

}

{

/**

* @ignore

if ($group_row[$group_id]['group_type'] == GROUP_FREE)

{

group_user_add($group_id, $user->data['user_id']);

}

else

{

group_user_add($group_id, $user->data['user_id'], false, false, false, 0, 1);

}

add_log('user', $user->data['user_id'], 'LOG_USER_GROUP_JOIN' . (($group_row[$group_id]['group_type'] == GROUP_FREE) ? '' : '_PENDING'), $group_row[$group_id]['group_name']);

$num_not_moved = $num_removed = 0;

$release = request_var('release', 0);

{

$return = place_pm_into_folder($global_privmsgs_rules, $release);

$num_not_moved = $return['not_moved'];

function view_message($id, $mode, $folder_id, $msg_id, $folder, $message_row)

{

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

$user->add_lang(array('viewtopic', 'memberlist'));

'U_PM' => ($config['allow_privmsg'] && $auth->acl_get('u_sendpm') && ($user_info['user_allow_pm'] || $auth->acl_gets('a_', 'm_') || $auth->acl_getf_global('m_'))) ? append_sid("{$phpbb_root_path}ucp.$phpEx", 'i=pm&amp;mode=compose&amp;u=' . $author_id) : '',

'U_WWW' => (!empty($user_info['user_website'])) ? $user_info['user_website'] : '',

'U_AIM' => ($user_info['user_aim'] && $auth->acl_get('u_sendim')) ? append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=contact&amp;action=aim&amp;u=' . $author_id) : '',

'U_YIM' => ($user_info['user_yim']) ? 'http://edit.yahoo.com/config/send_webmesg?.target=' . urlencode($user_info['user_yim']) . '&amp;.src=pg' : '',

'U_MSN' => ($user_info['user_msnm'] && $auth->acl_get('u_sendim')) ? append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=contact&amp;action=msnm&amp;u=' . $author_id) : '',

$error = validate_data($data, $check_ary);

{

}

{

}

// Only check the new password against the previous password if there have been no errors

$error[] = 'SAME_PASSWORD_ERROR';

}

{

}

if (!check_form_key('ucp_reg_details'))

case '3.0.9-RC4':

break;

// Changes from 3.1.0-dev to 3.1.0-A1

case '3.1.0-dev':

$db->sql_freeresult($result);

FROM ' . GROUPS_TABLE . '

{

$sql = 'UPDATE ' . GROUPS_TABLE . '

_sql($sql, $errored, $error_ary);

}

$db->sql_freeresult($result);

// Install modules

$modules_to_install = array(

);

_add_modules($modules_to_install);

$sql = 'DELETE FROM ' . MODULES_TABLE . "

WHERE module_basename = 'styles' AND module_mode = 'imageset'";

_sql($sql, $errored, $error_ary);

}

// Allow custom profile fields in pm templates

$no_updates = false;

break;

fix_empty_primary_groups();

}

update_dynamic_config();

$error[] = $lang['INST_ERR_NO_DB'];

$connect_test = false;

}

else

{

$connect_test = connect_check_db(true, $error, $available_dbms[$data['dbms']], $data['table_prefix'], $data['dbhost'], $data['dbuser'], htmlspecialchars_decode($data['dbpasswd']), $data['dbname'], $data['dbport']);

@chmod($phpbb_root_path . 'cache/install_lock', 0777);

// Time to convert the data provided into a config file

// Attempt to write out the config file directly. If it works, this is the easiest way to do it ...

if ((file_exists($phpbb_root_path . 'config.' . $phpEx) && phpbb_is_writable($phpbb_root_path . 'config.' . $phpEx)) || phpbb_is_writable($phpbb_root_path))

'dbname' => array('lang' => 'DB_NAME', 'type' => 'text:25:100', 'explain' => false),

'dbuser' => array('lang' => 'DB_USERNAME', 'type' => 'text:25:100', 'explain' => false),

'dbpasswd' => array('lang' => 'DB_PASSWORD', 'type' => 'password:25:100', 'explain' => false),

);

var $admin_config_options = array(

'legend1' => 'ADMIN_CONFIG',

#

# Table: 'phpbb_attachments'

CREATE TABLE phpbb_attachments (

/*

/*

Table: 'phpbb_attachments'

[style_copyright] [varchar] (255) DEFAULT ('') NOT NULL ,

[style_active] [int] DEFAULT (1) NOT NULL ,

[template_id] [int] DEFAULT (0) NOT NULL ,

) ON [PRIMARY]

GO

#

# Table: 'phpbb_attachments'

CREATE TABLE phpbb_attachments (

attach_id mediumint(8) UNSIGNED NOT NULL auto_increment,

#

# Table: 'phpbb_attachments'

CREATE TABLE phpbb_attachments (

attach_id mediumint(8) UNSIGNED NOT NULL auto_increment,

/*

/*

This first section is optional, however its probably the best method

/*

BEGIN;

INSERT INTO phpbb_config (config_name, config_value) VALUES ('email_check_mx', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('email_enable', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('email_function_name', 'mail');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('email_package_size', '20');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('enable_confirm', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('enable_pm_icons', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_cpf_viewtopic', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_db_lastread', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_db_track', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_jumpbox', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_moderators', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_online', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_password', '');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_port', '25');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_username', '');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('teampage_forums', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('topics_per_page', '25');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('tpl_allow_php', '0');

#

BEGIN TRANSACTION;

# Table: 'phpbb_attachments'

'LENGTH_BAN_INVALID' => 'The date has to be formatted <kbd>YYYY-MM-DD</kbd>.',

'PERMANENT' => 'Permanent',

'UNTIL' => 'Until',

'MAX_POST_URLS' => 'Maximum links per post',

'MAX_POST_URLS_EXPLAIN' => 'Maximum number of URLs in a post. Set to 0 for unlimited links.',

'MIN_CHAR_LIMIT' => 'Minimum characters per post/message',

'POSTING' => 'Posting',

'POSTS_PER_PAGE' => 'Posts per page',

'QUOTE_DEPTH_LIMIT' => 'Maximum nesting depth for quotes',

'LOAD_CPF_PM' => 'Display custom profile fields in private messages',

'LOAD_CPF_VIEWPROFILE' => 'Display custom profile fields in user profiles',

'LOAD_CPF_VIEWTOPIC' => 'Display custom profile fields on topic pages',

'LOAD_USER_ACTIVITY' => 'Show user’s activity',

'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_STYLES' => 'Recompile stale style components',

'DATABASE_SERVER_INFO' => 'Database server',

'DATABASE_SIZE' => 'Database size',

'FILES_PER_DAY' => 'Attachments per day',

'FORUM_STATS' => 'Board statistics',

'ENABLE_TOPIC_ICONS' => 'Enable topic icons',

'FORUM_ADMIN' => 'Forum administration',

'FORUM_AUTO_PRUNE' => 'Enable auto-pruning',

'FORUM_AUTO_PRUNE_EXPLAIN' => 'Prunes the forum of topics, set the frequency/age parameters below.',

'FORUM_CREATED' => 'Forum created successfully.',

'SPECIAL_GROUPS' => 'Pre-defined groups',

'SPECIAL_GROUPS_EXPLAIN' => 'Pre-defined groups are special groups, they cannot be deleted or directly modified. However you can still add users and alter basic settings.',

'TEAMPAGE_EXPLAIN' => 'These are the groups which are displayed on the teampage:',

'TEAMPAGE_FORUMS' => 'Display moderated forums',

'TEAMPAGE_FORUMS_EXPLAIN' => 'If set to yes, moderators will have a list with all of the forums where they have moderator permissions displayed in their row. This can be very database intensive for big boards.',

'TEAMPAGE_SETTINGS' => 'Teampage settings',

'TOTAL_MEMBERS' => 'Members',

'LANGUAGE_PACK_DELETED' => 'The language pack <strong>%s</strong> has been removed successfully. All users using this language have been reset to the boards default language.',

'LANGUAGE_PACK_DETAILS' => 'Language pack details',

'LANGUAGE_PACK_INSTALLED' => 'The language pack <strong>%s</strong> has been successfully installed.',

'LANGUAGE_PACK_ISO' => 'ISO',

'LANGUAGE_PACK_LOCALNAME' => 'Local name',

'LANGUAGE_PACK_NAME' => 'Name',

'EMPTY_MESSAGE_SUBJECT' => 'You must specify a subject when composing a new message.',

'ENABLED' => 'Enabled',

'ENCLOSURE' => 'Enclosure',

'ERR_CHANGING_DIRECTORY' => 'Unable to change directory.',

'ERR_CONNECTING_SERVER' => 'Error connecting to the server.',

'ERR_JAB_AUTH' => 'Could not authorise on Jabber server.',

'FORUM_RULES_LINK' => 'Please click here to view the forum rules',

'FROM' => 'from',

'FSOCK_DISABLED' => 'The operation could not be completed because the <var>fsockopen</var> function has been disabled or the server being queried could not be found.',

'FTP_FSOCK_HOST' => 'FTP host',

'FTP_FSOCK_HOST_EXPLAIN' => 'FTP server used to connect your site.',

Hello {USERNAME},

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.

You can view your new message by clicking on the following link:

You have requested that you be notified on this event, remember that you can always choose not to be notified of new messages by changing the appropriate setting in your profile.

),

array(

0 => 'I registered in the past but cannot login any more?!',

),

array(

0 => 'What is COPPA?',

'INST_ERR' => 'Installation error',

'INST_ERR_DB_CONNECT' => 'Could not connect to the database, see error message below.',

'INST_ERR_DB_FORUM_PATH' => 'The database file specified is within your board directory tree. You should put this file in a non web-accessible location.',

'INST_ERR_DB_NO_ERROR' => 'No error message given.',

'INST_ERR_DB_NO_MYSQLI' => 'The version of MySQL installed on this machine is incompatible with the “MySQL with MySQLi Extension” option you have selected. Please try the “MySQL” option instead.',

'INST_ERR_DB_NO_SQLITE' => 'The version of the SQLite extension you have installed is too old, it must be upgraded to at least 2.8.2.',

'TABLES_MISSING' => 'Could not find these tables<br />» <strong>%s</strong>.',

'TABLE_PREFIX' => 'Prefix for tables in database',

'TABLE_PREFIX_SAME' => 'The table prefix needs to be the one used by the software you are converting from.<br />» Specified table prefix was %s.',

'TESTS_PASSED' => 'Tests passed',

'TESTS_FAILED' => 'Tests failed',

'CURRENT_IMAGE' => 'Current image',

'CURRENT_PASSWORD' => 'Current password',

'CURRENT_PASSWORD_EXPLAIN' => 'You must confirm your current password if you wish to change it, alter your e-mail address or username.',

'CUR_PASSWORD_ERROR' => 'The current password you entered is incorrect.',

'CUSTOM_DATEFORMAT' => 'Custom…',

'MOVE_TO_FOLDER' => 'Move to folder',

'MOVE_UP' => 'Move up',

'NEW_EMAIL_ERROR' => 'The e-mail addresses you entered do not match.',

'NEW_FOLDER_NAME' => 'New folder name',

'NEW_PASSWORD' => 'New password',

'NEW_PASSWORD_ERROR' => 'The passwords you entered do not match.',

'NOTIFY_METHOD' => 'Notification method',

'NOTIFY_METHOD_BOTH' => 'Both',

if (isset($user_ary[$user_id]))

{

$row = $user_ary[$user_id];

{

// Display users in their primary group, instead of the first group, when it is displayed on the teampage.

continue;

'U_VIEW_PROFILE' => get_username_string('profile', $row['user_id'], $row['username'], $row['user_colour']),

));

{

unset($user_ary[$user_id]);

}

<div class="panel" id="message">

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

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

</div>

<!-- IF not S_IS_BOT -->{RUN_CRON_TASK}<!-- ENDIF -->

</div>

</body>

</html>

</div>

</div>

</body>

</html>

<ul class="topiclist">

<li class="header">

<dl>

<dd class="extra"><a href="{U_SORT_DOWNLOADS}">{L_DOWNLOADS}</a></dd>

<dd class="time"><span><a href="{U_SORT_POST_TIME}">{L_POST_TIME}</a></span></dd>

<dd class="mark">{L_MARK}</dd>

<!-- BEGIN attachrow -->

<li class="row<!-- IF attachrow.S_ROW_COUNT is odd --> bg1<!-- ELSE --> bg2<!-- ENDIF -->">

<dl>

<!-- IF attachrow.S_IN_MESSAGE -->{L_PM}: <!-- ELSE -->{L_TOPIC}: <!-- ENDIF --><a href="{attachrow.U_VIEW_TOPIC}">{attachrow.TOPIC_TITLE}</a></dt>

<dd class="extra">{attachrow.DOWNLOAD_COUNT}</dd>

<dd class="time"><span>{attachrow.POST_TIME}</span></dd>

</tr>

<!-- ENDIF -->

<!-- BEGINELSE -->

<tr>

</tr>

<!-- END member -->

</tbody>

<!DOCTYPE html>

<html dir="{S_CONTENT_DIRECTION}" lang="{S_USER_LANG}">

<head>

</head>

</body>

</html>

<!-- NOTE: remove the style="display: none" when you want to have the forum description on the topic body -->

<!-- IF FORUM_DESC --><div style="display: none !important;">{FORUM_DESC}<br /></div><!-- ENDIF -->

<!-- ENDIF -->

<!-- IF S_FORUM_RULES -->

---------------------------------------- */

/**

/**

* cp.css

*/

---------------------------------------- */

---------------------------------------- */

/* Rollover buttons

---------------------------------------- */

* {

---------------------------------------- */

ul.topiclist {

dd.mark {

float: right !important;

text-align: center;

line-height: 200%;

font-size: 1.2em;

---------------------------------------- */

---------------------------------------- */

/* General form styles

border: 1px solid #666666;

padding: 1px;

background-color: #FAFAFA;

}

option {

---------------------------------------- */

/* Links adjustment to correctly display an order of rtl/ltr mixed content */

/* Lots still TODO here! */

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

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

*/

@import url("forms.css");

@import url("tweaks.css");

@import url("colours.css");

These style definitions are mainly IE specific

tweaks required due to its poor CSS support.

<!-- IF DEBUG_OUTPUT --><br /><bdo dir="ltr">[ {DEBUG_OUTPUT} ]</bdo><!-- ENDIF --></span>

</div>

</body>

</html>

<span class="copyright">Powered by <a href="http://www.phpbb.com/">phpBB</a>&reg; Forum Software &copy; phpBB Group</span>

</div>

</body>

</html>

<table width="85%" cellspacing="3" cellpadding="0" border="0" align="center">

<tr>

</tr>

<tr>

<td colspan="2"><br /></td>

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

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

*/

redirect(append_sid("{$phpbb_root_path}index.$phpEx"));

}

login_box('', $user->lang['LOGIN_EXPLAIN_UCP']);

}

'is_watching' => false,

);

{

$notify_status = (isset($forum_data['notify_status'])) ? $forum_data['notify_status'] : NULL;

watch_topic_forum('forum', $s_watching_forum, $user->data['user_id'], $forum_id, 0, $notify_status, $start, $forum_data['forum_name']);

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

{

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

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

$topics_count = 1;

}

$template->assign_vars(array(

'PAGINATION' => generate_pagination(append_sid("{$phpbb_root_path}viewforum.$phpEx", "f=$forum_id" . ((strlen($u_sort_param)) ? "&amp;$u_sort_param" : '')), $topics_count, $config['topics_per_page'], $start),

'PAGE_NUMBER' => on_page($topics_count, $config['topics_per_page'], $start),

);

$topic_list = ($store_reverse) ? array_merge($announcement_list, array_reverse($topic_list)) : array_merge($announcement_list, $topic_list);

'is_watching' => false,

);

{

// Reset forum notification if forum notify is set

if ($config['allow_forum_notify'] && $auth->acl_get('f_subscribe', $forum_id))

<testsuites>

<testsuite name="phpBB Test Suite">

<directory suffix="_test.php">./tests/</directory>

</testsuite>

</testsuites>

<testsuites>

<testsuite name="phpBB Test Suite">

<directory suffix="_test.php">./tests/</directory>

</testsuite>

</testsuites>

<groups>

<exclude>

<group>slow</group>

</exclude>

</groups>

require_once 'test_framework/phpbb_test_case.php';

require_once 'test_framework/phpbb_database_test_case.php';

require_once 'test_framework/phpbb_database_test_connection_manager.php';

$this->assertEquals($row2, $row_actual);

}

public function test_column_exists()

{

$this->assertTrue($this->tools->sql_column_exists('prefix_table_name', 'c_id'));

$this->assertFalse($this->tools->sql_column_exists('prefix_table_name', 'c_id'));

}

public function test_table_exists()

{

$this->assertTrue($this->tools->sql_table_exists('prefix_table_name'));

),

));

}

}

$db->sql_freeresult($result);

}

{

$db = $this->new_dbal();

$this->assertEquals('1', $row['user_id']);

}

}

public function get_database_config()

{

{

$this->markTestSkipped('Missing test_config.php: See first error.');

}

}

public function getConnection()

default:

$dsn .= 'host=' . $this->config['dbhost'];

if ($use_db)

{

$dsn .= ';dbname=' . $this->config['dbname'];

{

mkdir($path, 0777, true);

}

}