/phpBB/cache/*.php

/phpBB/cache/queue.php.lock

/phpBB/config.php

/phpBB/ext/*

/phpBB/files/*

/phpBB/images/avatars/gallery/*

3. [Read our Git Contribution Guidelines](http://wiki.phpbb.com/Git); if you're new to git, also read [the introduction guide](http://wiki.phpbb.com/display/DEV/Working+with+Git)

4. Send us a pull request

## LICENSE

[GNU General Public License v2](http://opensource.org/licenses/gpl-2.0.php)

* @copyright (c) 2005 phpBB Group

* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

*

*/

/**

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

'report_time' => array('TIMESTAMP', 0),

'report_text' => array('MTEXT_UNI', ''),

),

'PRIMARY_KEY' => 'report_id',

'KEYS' => array(

$search = new $class_name($search_errors);

$batch_size = isset($argv[2]) ? $argv[2] : 2000;

if (method_exists($search, 'create_index'))

{

while ($post_counter <= $max_post_id)

{

$row_count = 0;

printf("Processing posts with %d <= post_id <= %d\n",

$post_counter + 1,

global $phpbb_extension_manager;

$phpbb_extension_manager->load_extensions();

echo "Enabled:\n";

$enabled = array_keys($phpbb_extension_manager->all_enabled());

echo "\n";

echo "Available:\n";

$purged = array_diff($all, $enabled, $disabled);

print_extensions($purged);

}

<li>Oracle</li>

</ul>

</li>

<li>getimagesize() function need to be enabled.</li>

<li>These optional presence of the following modules within PHP will provide access to additional features, but they are not required.

<ul>

<div class="content">

<p>Please remember that running any application on a developmental version of PHP can lead to strange/unexpected results which may appear to be bugs in the application (which may not be true). Therefore we recommend you upgrade to the newest stable version of PHP before running phpBB3. If you are running a developmental version of PHP please check any bugs you find on a system running a stable release before submitting.</p>

<a name="phpsec"></a><h3>7.i. Notice on PHP security issues</h3>

<div class="codebox"><pre>

...

Visit &quot;Downloads&quot; at &lt;a href=&quot;http://www.php.net/&quot;&gt;www.php.net&lt;/a&gt;.',

...

</pre></div>

<div class="codebox"><pre>

...

Visit &amp;quot;Downloads&amp;quot; at &lt;a href=&quot;http://www.php.net/&quot;&gt;www.php.net&lt;/a&gt;.',

...

</pre></div>

<div class="codebox"><pre>

...

Visit &ldquo;Downloads&rdquo; at &lt;a href=&quot;http://www.php.net/&quot;&gt;www.php.net&lt;/a&gt;.',

...

</pre></div>

// Version check

$user->add_lang('install');

{

$template->assign_vars(array(

'S_PHP_VERSION_OLD' => true,

));

}

$dropdown_modes = array();

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

{

{

continue;

}

public function all_available()

{

$available = array();

$iterator = new RecursiveIteratorIterator(

new RecursiveDirectoryIterator($this->phpbb_root_path . 'ext/'),

}

return $disabled;

}

/**

* Instantiates a phpbb_extension_finder.

foreach ($this->module_cache['modules'] as $key => $row)

{

// Not allowed to view module?

{

unset($this->module_cache['modules'][$key]);

continue;

}

/**

*/

{

global $auth, $config;

global $request;

$module_auth = implode(' ', $tokens);

$module_auth = str_replace(' , ', ',', $module_auth);

$is_auth = false;

eval('$is_auth = (int) (' . preg_replace(array('#acl_([a-z0-9_]+)(,\$id)?#', '#\$id#', '#aclf_([a-z0-9_]+)#', '#cfg_([a-z0-9_]+)#', '#request_([a-zA-Z0-9_]+)#'), array('(int) $auth->acl_get(\'\\1\'\\2)', '(int) $forum_id', '(int) $auth->acl_getf_global(\'\\1\')', '(int) $config[\'\\1\']', '$request->variable(\'\\1\', false)'), $module_auth) . ');');

$topic_title = ($topic_notification) ? $topic_title : $subject;

$topic_title = censor_text($topic_title);

{

}

$notify_rows = array();

// -- get forum_userids || topic_userids

$sql = 'SELECT u.user_id, u.username, u.user_email, u.user_lang, u.user_notify_type, u.user_jabber

FROM ' . (($topic_notification) ? TOPICS_WATCH_TABLE : FORUMS_WATCH_TABLE) . ' w, ' . USERS_TABLE . ' u

AND u.user_type IN (' . USER_NORMAL . ', ' . USER_FOUNDER . ')

AND u.user_id = w.user_id';

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

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

{

'username' => $row['username'],

'user_email' => $row['user_email'],

'user_jabber' => $row['user_jabber'],

'method' => $row['user_notify_type'],

'allowed' => false

);

}

$db->sql_freeresult($result);

// forum notification is sent to those not already receiving topic notifications

if ($topic_notification)

{

$sql = 'SELECT u.user_id, u.username, u.user_email, u.user_lang, u.user_notify_type, u.user_jabber

FROM ' . FORUMS_WATCH_TABLE . ' fw, ' . USERS_TABLE . " u

WHERE fw.forum_id = $forum_id

AND u.user_type IN (' . USER_NORMAL . ', ' . USER_FOUNDER . ')

AND u.user_id = fw.user_id';

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

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

{

'username' => $row['username'],

'user_email' => $row['user_email'],

'user_jabber' => $row['user_jabber'],

}

}

// Now, we have to do a little step before really sending, we need to distinguish our users a little bit. ;)

$msg_users = $delete_ids = $update_notification = array();

foreach ($notify_rows as $user_id => $row)

$subject = censor_text($subject);

unset($recipients[ANONYMOUS], $recipients[$user->data['user_id']]);

if (!sizeof($recipients))

return;

}

{

}

if (!sizeof($recipients))

{

$sql = 'SELECT user_id, username, user_email, user_lang, user_notify_pm, user_notify_type, user_jabber

FROM ' . USERS_TABLE . '

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

$msg_list_ary = array();

return $user_data['group_id'];

}

// closed reports are accessed by report id

$report_id = request_var('r', 0);

FROM ' . REPORTS_TABLE . ' r, ' . REPORTS_REASONS_TABLE . ' rr, ' . USERS_TABLE . ' u

WHERE ' . (($report_id) ? 'r.report_id = ' . $report_id : "r.post_id = $post_id") . '

AND rr.reason_id = r.reason_id

$template->assign_vars(array(

'S_TOPIC_REVIEW' => true,

'S_BBCODE_ALLOWED' => $post_info['enable_bbcode'],

}

$topic_tracking_info = $extensions = $attachments = array();

'REPORTER_NAME' => get_username_string('username', $report['user_id'], $report['username'], $report['user_colour']),

'U_VIEW_REPORTER_PROFILE' => get_username_string('profile', $report['user_id'], $report['username'], $report['user_colour']),

'POST_SUBJECT' => ($post_info['post_subject']) ? $post_info['post_subject'] : $user->lang['NO_SUBJECT'],

'POST_DATE' => $user->format_date($post_info['post_time']),

'POST_IP' => $post_info['poster_ip'],

$submitted_id_list = request_var('post_ids', array(0));

$checked_ids = $post_id_list = request_var('post_id_list', array(0));

// Split Topic?

if ($action == 'split_all' || $action == 'split_beyond')

{

'S_CAN_APPROVE' => ($has_unapproved_posts && $auth->acl_get('m_approve', $topic_info['forum_id'])) ? true : false,

'S_CAN_LOCK' => ($auth->acl_get('m_lock', $topic_info['forum_id'])) ? true : false,

'S_CAN_REPORT' => ($auth->acl_get('m_report', $topic_info['forum_id'])) ? true : false,

'S_REPORT_VIEW' => ($action == 'reports') ? true : false,

'S_MERGE_VIEW' => ($action == 'merge') ? true : false,

'S_SPLIT_VIEW' => ($action == 'split') ? true : false,

{

define('E_DEPRECATED', 8192);

}

/*

* Remove variables created by register_globals from the global scope

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

$user->setup('viewforum');

display_forums('', $config['load_moderators']);

$order_legend = ($config['legend_sort_groupname']) ? 'group_name' : 'group_legend';

'style_parent_id' => array('UINT:4', 0),

'style_parent_tree' => array('TEXT', ''),

),

),

'change_columns' => array(

GROUPS_TABLE => array(

$phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './../';

$phpEx = substr(strrchr(__FILE__, '.'), 1);

{

}

function phpbb_require_updated($path, $optional = false)

// Test the minimum PHP version

$php_version = PHP_VERSION;

{

$result = '<strong style="color:red">' . $lang['NO'] . '</strong>';

}

user_notify INTEGER DEFAULT 0 NOT NULL,

report_closed INTEGER DEFAULT 0 NOT NULL,

report_time INTEGER DEFAULT 0 NOT NULL,

);;

ALTER TABLE phpbb_reports ADD PRIMARY KEY (report_id);;

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

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

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

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

report_closed tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

report_time int(11) UNSIGNED DEFAULT '0' NOT NULL,

report_text mediumblob NOT NULL,

PRIMARY KEY (report_id),

KEY post_id (post_id),

KEY pm_id (pm_id)

report_closed tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

report_time int(11) UNSIGNED DEFAULT '0' NOT NULL,

report_text mediumtext NOT NULL,

PRIMARY KEY (report_id),

KEY post_id (post_id),

KEY pm_id (pm_id)

report_closed number(1) DEFAULT '0' NOT NULL,

report_time number(11) DEFAULT '0' NOT NULL,

report_text clob DEFAULT '' ,

CONSTRAINT pk_phpbb_reports PRIMARY KEY (report_id)

)

/

report_closed INT2 DEFAULT '0' NOT NULL CHECK (report_closed >= 0),

report_time INT4 DEFAULT '0' NOT NULL CHECK (report_time >= 0),

report_text TEXT DEFAULT '' NOT NULL,

PRIMARY KEY (report_id)

);

user_notify INTEGER UNSIGNED NOT NULL DEFAULT '0',

report_closed INTEGER UNSIGNED NOT NULL DEFAULT '0',

report_time INTEGER UNSIGNED NOT NULL DEFAULT '0',

);

CREATE INDEX phpbb_reports_post_id ON phpbb_reports (post_id);

'ERR_WRONG_PATH_TO_PHPBB' => 'The phpBB path specified appears to be invalid.',

'EXPAND_VIEW' => 'Expand view',

'EXTENSION' => 'Extension',

'EXTENSION_DISABLED_AFTER_POSTING' => 'The extension <strong>%s</strong> has been deactivated and can no longer be displayed.',

'FAQ' => 'FAQ',

'FAQ_EXPLAIN' => 'Frequently Asked Questions',

'PHP_REGISTER_GLOBALS_EXPLAIN' => 'phpBB will still run if this setting is enabled, but if possible, it is recommended that register_globals is disabled on your PHP install for security reasons.',

'PHP_SAFE_MODE' => 'Safe mode',

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

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

'PHP_URL_FOPEN_SUPPORT_EXPLAIN' => '<strong>Optional</strong> - This setting is optional, however certain phpBB functions like off-site avatars will not work properly without it.',

'POST_ID' => 'Post ID',

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

'PREPROCESS_STEP' => 'Executing pre-processing functions/queries',

'NO_POST' => 'You have to select a post in order to warn the user for a post.',

'NO_POST_REPORT' => 'This post was not reported.',

'NO_POST_SELECTED' => 'You must select at least one post to perform this action.',

'NO_REASON_DISAPPROVAL' => 'Please give an appropriate reason for disapproval.',

'NO_REPORT' => 'No report found',

'NO_REPORTS' => 'No reports found',

if ($mode)

{

$params[] = "mode=$mode";

}

$sort_params[] = "mode=$mode";

trigger_error('POST_NOT_EXIST');

}

$sql = 'SELECT *

FROM ' . FORUMS_TABLE . '

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

trigger_error($message);

}

}

// Submit report?

'user_notify' => (int) $user_notify,

'report_closed' => 0,

'report_time' => (int) time(),

);

$sql = 'INSERT INTO ' . REPORTS_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary);

</li>

</ul>

<!-- ELSE -->

<!-- ENDIF -->

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

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

<div class="postbody" id="pr{postrow.POST_ID}">

<h3><a href="{postrow.U_POST_DETAILS}">{postrow.POST_SUBJECT}</a></h3>

<p class="author"><a href="#pr{postrow.POST_ID}">{postrow.MINI_POST_IMG}</a> {L_POSTED} {postrow.POST_DATE} {L_POST_BY_AUTHOR} <strong>{postrow.POST_AUTHOR_FULL}</strong><!-- IF postrow.U_MCP_DETAILS --> [ <a href="{postrow.U_MCP_DETAILS}">{L_POST_DETAILS}</a> ]<!-- ENDIF --></p>

<!-- IF S_CAN_DELETE --><option value="delete_post">{L_DELETE_POSTS}</option><!-- ENDIF -->

<!-- IF S_CAN_MERGE --><option value="merge_posts"<!-- IF S_MERGE_VIEW --> selected="selected"<!-- ENDIF -->>{L_MERGE_POSTS}</option><!-- ENDIF -->

<!-- IF S_CAN_SPLIT --><option value="split_all"<!-- IF S_SPLIT_VIEW --> selected="selected"<!-- ENDIF -->>{L_SPLIT_POSTS}</option><option value="split_beyond">{L_SPLIT_AFTER}</option><!-- ENDIF -->

</select>&nbsp;

<input class="button1" type="submit" name="mcp_topic_submit" value="{L_SUBMIT}" />

<div><a href="#" onclick="marklist('mcp', 'post', true); return false;">{L_MARK_ALL}</a> :: <a href="#" onclick="marklist('mcp', 'post', false); return false;">{L_UNMARK_ALL}</a></div>

<!-- IF U_JABBER and S_JABBER_ENABLED --><dt>{L_JABBER}:</dt> <dd><a href="{U_JABBER}" onclick="popup(this.href, 550, 320); return false;">{L_SEND_JABBER_MESSAGE}</a></dd><!-- ELSEIF USER_JABBER --><dt>{L_JABBER}:</dt> <dd>{USER_JABBER}</dd><!-- ENDIF -->

<!-- IF S_PROFILE_FIELD1 -->

<!-- NOTE: Use a construct like this to include admin defined profile fields. Replace FIELD1 with the name of your field. -->

<!-- ENDIF -->

</dl>

</div>

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

{topic_review_row.L_IGNORE_POST}

<!-- ELSE -->

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

<!-- ENDIF -->

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

margin: 0;

padding: 0;

}

html {

font-size: 100%;

/* Always show a scrollbar for short pages - stops the jump when the scrollbar appears. non-IE browsers */

background-color: #FFFFFF;

/*font-size: 62.5%; This sets the default font size to be equivalent to 10px */

font-size: 10px;

margin: 0;

padding: 12px 0;

}

text-align: right;

}

/* Main blocks

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

#wrap {

</tr>

<!-- BEGINELSE -->

<tr>

</tr>

<!-- END postrow -->

<tr>

<!-- IF S_CAN_DELETE --><option value="delete_post">{L_DELETE_POSTS}</option><!-- ENDIF -->

<!-- IF S_CAN_MERGE --><option value="merge_posts"<!-- IF ACTION eq 'merge' --> selected="selected"<!-- ENDIF -->>{L_MERGE_POSTS}</option><!-- ENDIF -->

<!-- IF S_CAN_SPLIT --><option value="split_all"<!-- IF ACTION eq 'split' --> selected="selected"<!-- ENDIF -->>{L_SPLIT_POSTS}</option><option value="split_beyond">{L_SPLIT_AFTER}</option><!-- ENDIF -->

</select>&nbsp;<input class="btnmain" type="submit" name="mcp_topic_submit" value="{L_SUBMIT}" /></td>

</tr>

</table>

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

<tr>

<td>

<div class="postbody">{topic_review_row.MESSAGE}</div>

<!-- IF topic_review_row.S_HAS_ATTACHMENTS -->

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

<testsuites>

<testsuite name="phpBB Test Suite">

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

</testsuite>

</testsuites>

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

protected $client;

protected $root_url;

static protected $config = array();

static protected $already_installed = false;

}

}

protected function install_board()

{

global $phpbb_root_path, $phpEx;