</table>

<fieldset class="display-options">

<input class="button2" type="submit" value="{L_GO}" name="sort" />

</fieldset>

</dl>

<dl>

<dt><label>{L_POSTS}:</label></dt>

</dl>

<dl>

<dt><label>{L_WARNINGS}:</label></dt>

*/

function storeCaret(textEl)

{

{

textEl.caretPos = document.selection.createRange().duplicate();

}

{

"require-dev": {

"fabpot/goutte": "1.0.*",

"phing/phing": "2.4.*"

}

}

"This file locks the dependencies of your project to a known state",

"Read more about it at http://getcomposer.org/doc/01-basic-usage.md#composer-lock-the-lock-file"

],

"packages": [

],

"authors": [

{

"name": "Fabien Potencier",

}

],

"description": "A simple PHP Web Scraper",

},

{

"name": "phpunit/dbunit",

"source": {

"type": "git",

"url": "https://github.com/sebastianbergmann/dbunit.git",

},

"dist": {

"type": "zip",

"shasum": ""

},

"require": {

"ext-pdo": "*",

"ext-simplexml": "*",

"php": ">=5.3.3",

},

"bin": [

],

"type": "library",

"extra": {

"branch-alias": {

}

},

"autoload": {

"testing",

"xunit"

],

},

{

"name": "phpunit/php-code-coverage",

"source": {

"type": "git",

"url": "https://github.com/sebastianbergmann/php-code-coverage.git",

},

"dist": {

"type": "zip",

"shasum": ""

},

"require": {

"php": ">=5.3.3",

},

"require-dev": {

},

"suggest": {

"ext-dom": "*",

},

"type": "library",

"extra": {

"branch-alias": {

}

},

"autoload": {

"classmap": [

]

},

"notification-url": "https://packagist.org/downloads/",

"testing",

"xunit"

],

},

{

"name": "phpunit/php-file-iterator",

"source": {

"type": "git",

"url": "https://github.com/sebastianbergmann/php-file-iterator.git",

},

"dist": {

"type": "zip",

"shasum": ""

},

"require": {

}

],

"description": "FilterIterator implementation that filters files based on a list of suffixes.",

"keywords": [

"filesystem",

"iterator"

],

},

{

"name": "phpunit/php-text-template",

"source": {

"type": "git",

"url": "https://github.com/sebastianbergmann/php-text-template.git",

},

"dist": {

"type": "zip",

"shasum": ""

},

"require": {

"keywords": [

"template"

],

},

{

"name": "phpunit/php-timer",

},

{

"name": "phpunit/php-token-stream",

"source": {

"type": "git",

"url": "https://github.com/sebastianbergmann/php-token-stream.git",

},

"dist": {

"type": "zip",

"shasum": ""

},

"require": {

"keywords": [

"tokenizer"

],

},

{

"name": "phpunit/phpunit",

"source": {

"type": "git",

"url": "https://github.com/sebastianbergmann/phpunit.git",

},

"dist": {

"type": "zip",

"shasum": ""

},

"require": {

"ext-dom": "*",

"ext-pcre": "*",

"ext-reflection": "*",

"ext-spl": "*",

"php": ">=5.3.3",

"symfony/yaml": "~2.0"

},

"suggest": {

},

"bin": [

],

"type": "library",

"extra": {

"branch-alias": {

}

},

"autoload": {

"classmap": [

]

},

"notification-url": "https://packagist.org/downloads/",

"testing",

"xunit"

],

},

{

"name": "phpunit/phpunit-mock-objects",

"source": {

"type": "git",

"url": "https://github.com/sebastianbergmann/phpunit-mock-objects.git",

},

"dist": {

"type": "zip",

"shasum": ""

},

"require": {

"php": ">=5.3.3",

},

"suggest": {

"ext-soap": "*"

},

"type": "library",

"autoload": {

"classmap": [

]

},

"notification-url": "https://packagist.org/downloads/",

"mock",

"xunit"

],

},

{

"name": "symfony/browser-kit",

"authors": [

{

"name": "Fabien Potencier",

},

{

"name": "Symfony Community",

"authors": [

{

"name": "Fabien Potencier",

},

{

"name": "Symfony Community",

"authors": [

{

"name": "Fabien Potencier",

},

{

"name": "Symfony Community",

"authors": [

{

"name": "Fabien Potencier",

},

{

"name": "Symfony Community",

"authors": [

{

"name": "Fabien Potencier",

},

{

"name": "Symfony Community",

"authors": [

{

"name": "Fabien Potencier",

},

{

"name": "Symfony Community",

},

{

"name": "symfony/yaml",

"target-dir": "Symfony/Component/Yaml",

"source": {

"type": "git",

"url": "https://github.com/symfony/Yaml.git",

},

"dist": {

"type": "zip",

"shasum": ""

},

"require": {

"type": "library",

"extra": {

"branch-alias": {

}

},

"autoload": {

"authors": [

{

"name": "Fabien Potencier",

},

{

"name": "Symfony Community",

],

"description": "Symfony Yaml Component",

"homepage": "http://symfony.com",

}

],

"aliases": [

foreach ($supported_dbms as $dbms)

{

$fp = fopen($schema_path . $dbms . '_schema.sql', 'wb');

$line = '';

case 'mssql':

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

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

break;

}

$line .= "\tCONSTRAINT [PK_{$table_name}] PRIMARY KEY CLUSTERED \n";

$line .= "\t(\n";

$line .= "\t\t[" . implode("],\n\t\t[", $table_data['PRIMARY_KEY']) . "]\n";

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

break;

case 'mssql':

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

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

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

break;

phpBB Lead Developer: naderman (Nils Adermann)

phpBB Developers: bantu (Andreas Fischer)

dhruv.goel92 (Dhruv Goel)

imkingdavid (David King)

nickvergessen (Joas Schilling)

Contributions by: leviatan21 (Gabriel Vazquez)

Raimon (Raimon Meuldijk)

<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11368">PHPBB3-11368</a>] - Latest pm reports row count</li>

<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11583">PHPBB3-11583</a>] - InnoDB supports FULLTEXT index since MySQL 5.6.4.</li>

<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11740">PHPBB3-11740</a>] - Update link in FAQ to Ideas Centre</li>

</ul>

<h4>Sub-task</h4>

<ul>

<li>A SQL database system, <strong>one of</strong>:

<ul>

<li>MySQL 3.23 or above (MySQLi supported)</li>

<li>PostgreSQL 7.3+</li>

<li>SQLite 2.8.2+ (SQLite 3 is not supported)</li>

<li>Firebird 2.1+</li>

<p>Please remember that running any application on a development (unstable, e.g. a beta release) version of PHP can lead to strange/unexpected results which may appear to be bugs in the application. Therefore, we recommend you upgrade to the newest stable version of PHP before running phpBB3. If you are running a development 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>

'avatar_filesize' => array('lang' => 'MAX_FILESIZE', 'validate' => 'int:0', 'type' => 'text:4:10', 'explain' => true, 'append' => ' ' . $user->lang['BYTES']),

'avatar_min' => array('lang' => 'MIN_AVATAR_SIZE', 'validate' => 'int:0', 'type' => 'dimension:3:4', 'explain' => true, 'append' => ' ' . $user->lang['PIXEL']),

'avatar_max' => array('lang' => 'MAX_AVATAR_SIZE', 'validate' => 'int:0', 'type' => 'dimension:3:4', 'explain' => true, 'append' => ' ' . $user->lang['PIXEL']),

'avatar_gallery_path' => array('lang' => 'AVATAR_GALLERY_PATH', 'validate' => 'rpath', 'type' => 'text:20:255', 'explain' => true)

)

);

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

$this->display_progress_bar($start, $total);

break;

case 'delete':

if ($submit)

{

{

if (!$auth->acl_get('a_userdel'))

{

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

}

if ($user_id == $user->data['user_id'])

{

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

'U_SHOW_IP' => $this->u_action . "&amp;u=$user_id&amp;ip=" . (($ip == 'ip') ? 'hostname' : 'ip'),

'U_WHOIS' => $this->u_action . "&amp;action=whois&amp;user_ip={$user_row['user_ip']}",

'U_MCP_QUEUE' => ($auth->acl_getf_global('m_approve')) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=queue', true, $user->session_id) : '',

'U_SWITCH_PERMISSIONS' => ($auth->acl_get('a_switchperm') && $user->data['user_id'] != $user_row['user_id']) ? append_sid("{$phpbb_root_path}ucp.$phpEx", "mode=switch_perm&amp;u={$user_row['user_id']}&amp;hash=" . generate_link_hash('switchperm')) : '',

WHERE a.poster_id = ' . $user_id . "

AND a.is_orphan = 0

ORDER BY $order_by";

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

{

}

// Replace {L_*} lang strings

if (!empty($rowset[$bbcode_id]['second_pass_replace']))

{

'email' => array('{EMAIL}' => '$1', '{DESCRIPTION}' => '$2')

);

if (!empty($replacements[$tpl_name]))

{

// Determine if we have created a PRIMARY KEY in the earliest

$primary_key_gen = false;

// Determine if the table requires a sequence

$create_sequence = false;

break;

}

// Iterate through the columns to create a table

foreach ($table_data['COLUMNS'] as $column_name => $column_data)

{

// here lies an array, filled with information compiled on the column's data

$prepared_column = $this->sql_prepare_column_data($table_name, $column_name, $column_data);

{

trigger_error("Index name '${column_name}_gen' on table '$table_name' is too long. The maximum auto increment column length is 26 characters.", E_USER_ERROR);

}

$primary_key_gen = isset($prepared_column['primary_key_set']) && $prepared_column['primary_key_set'];

}

// create sequence DDL based off of the existance of auto incrementing columns

if (!$create_sequence && isset($prepared_column['auto_increment']) && $prepared_column['auto_increment'])

{

switch ($this->sql_layer)

{

case 'firebird':

case 'mssql':

case 'mssqlnative':

$statements[] = $table_sql;

break;

}

}

}

if (!empty($schema_changes['add_unique_index']))

{

foreach ($schema_changes['add_unique_index'] as $table => $index_array)

}

/**

*

* @param string $table_name Table to check the index at

* @param string $index_name The index name to check

case 'mssql':

case 'mssqlnative':

$statements[] = 'ALTER TABLE [' . $table_name . '] DROP COLUMN [' . $column_name . ']';

break;

$sql = "ALTER TABLE [{$table_name}] WITH NOCHECK ADD ";

$sql .= "CONSTRAINT [PK_{$table_name}] PRIMARY KEY CLUSTERED (";

$sql .= '[' . implode("],\n\t\t[", $column) . ']';

$statements[] = $sql;

break;

case 'mssql':

case 'mssqlnative':

break;

}

case 'mssql':

case 'mssqlnative':

break;

}

if (!empty($column_data['default']))

{

// Using TRANSACT-SQL for this statement because we do not want to have colliding data if statements are executed at a later stage

}

break;

*/

function phpbb_check_hash($password, $hash)

{

$itoa64 = './0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz';

if (strlen($hash) == 34)

{

}

// Determine first occurrence, since in values the equal sign is allowed

$value = trim(substr($line, $delim_pos + 1));

if (in_array($value, array('off', 'false', '0')))

}

else if (($value[0] == "'" && $value[sizeof($value) - 1] == "'") || ($value[0] == '"' && $value[sizeof($value) - 1] == '"'))

{

}

$parsed_items[$key] = $value;

case 'mssql':

case 'mssql_odbc':

case 'mssqlnative':

$sql = 'SELECT ((SUM(size) * 8.0) * 1024.0) as dbsize

FROM sysfiles';

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

$database_size = ($row = $db->sql_fetchrow($result)) ? $row['dbsize'] : false;

$db->sql_freeresult($result);

* make_jumpbox()

* bump_topic_allowed()

* get_context()

* decode_message()

* strip_bbcode()

* generate_text_for_display()

}

/**

* Decode text whereby text is coming from the db and expected to be pre-parsed content

* We are placing this outside of the message parser because we are often in need of it...

*/

if ($this->active_module === false)

{

}

if (!class_exists("{$this->p_class}_$this->p_name"))

{

if (!file_exists("$module_path/{$this->p_class}_$this->p_name.$phpEx"))

{

}

include("$module_path/{$this->p_class}_$this->p_name.$phpEx");

if (!class_exists("{$this->p_class}_$this->p_name"))

{

}

if (!empty($mode))

{

$upload->set_disallowed_content(explode('|', $config['mime_triggers']));

}

if (!$local)

{

switch ($this->profile_types[$field_type])

{

case 'int':

{

return NULL;

}

'title' => 'MCP_PM_REPORTS',

'version' => '1.0.0',

'modes' => array(

'pm_reports_closed' => array('title' => 'MCP_PM_REPORTS_CLOSED', 'auth' => 'aclf_m_report', 'cat' => array('MCP_REPORTS')),

'pm_report_details' => array('title' => 'MCP_PM_REPORT_DETAILS', 'auth' => 'aclf_m_report', 'cat' => array('MCP_REPORTS')),

),

foreach ($post_info as $post_id => $post_data)

{

if ($post_id == $post_data['topic_first_post_id'] && $post_id == $post_data['topic_last_post_id'])

{

// Forum Notifications

}

else

{

// Topic Notifications

}

}

}

$db->sql_freeresult($result);

}

// now analyse the search query, first split it using the spaces

$query = explode(' ', $keywords);

$this->{$mode . '_ids'}[] = $words[$word];

}

}

{

if (!isset($common_ids[$word]))

{

$len = utf8_strlen($word);

{

$this->common_words[] = $word;

}

}

}

}

{

return true;

}

return false;

}

$must_contain_ids = $this->must_contain_ids;

$must_not_contain_ids = $this->must_not_contain_ids;

$must_exclude_one_ids = $this->must_exclude_one_ids;

'3.0.12-RC1' => array(),

// No changes from 3.0.12-RC2 to 3.0.12-RC3

'3.0.12-RC2' => array(),

/** @todo DROP LOGIN_ATTEMPT_TABLE.attempt_id in 3.0.13-RC1 */

);

// No changes from 3.0.12-RC2 to 3.0.12-RC3

case '3.0.12-RC2':

break;

}

}

case 'password':

$size = (int) $tpl_type[1];

$maxlength = (int) $tpl_type[2];

break;

case 'textarea':

if (!isset($available_dbms[$src_dbms]) || !$available_dbms[$src_dbms]['AVAILABLE'])

{

$connect_test = false;

}

else

$checks = array(

array('func_overload', '&', MB_OVERLOAD_MAIL|MB_OVERLOAD_STRING),

array('encoding_translation', '!=', 0),

);

foreach ($checks as $mb_checks)

break;

case '!=':

{

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

$passed['mbstring'] = false;

$_module->move_module_by($row, 'move_up', 5);

}

if ($module_class == 'ucp')

{

// Move attachment module 4 down...

'smtp_delivery' => array('lang' => 'USE_SMTP', 'type' => 'radio:yes_no', 'explain' => true),

'smtp_host' => array('lang' => 'SMTP_SERVER', 'type' => 'text:25:50', 'explain' => false),

'smtp_auth' => array('lang' => 'SMTP_AUTH_METHOD', 'type' => 'select', 'options' => '$this->module->mail_auth_select(\'{VALUE}\')', 'explain' => true),

'legend2' => 'SERVER_URL_SETTINGS',

'cookie_secure' => array('lang' => 'COOKIE_SECURE', 'type' => 'radio:enabled_disabled', 'explain' => true),

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

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

[thumbnail] [int] DEFAULT (0) NOT NULL

ALTER TABLE [phpbb_attachments] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_attachments] PRIMARY KEY CLUSTERED

(

[attach_id]

GO

GO

GO

GO

GO

GO

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

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

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

GO

GO

GO

GO

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

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

[founder_only] [int] DEFAULT (0) NOT NULL

ALTER TABLE [phpbb_acl_options] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_acl_options] PRIMARY KEY CLUSTERED

(

[auth_option_id]

GO

GO

[role_description] [varchar] (4000) DEFAULT ('') NOT NULL ,

[role_type] [varchar] (10) DEFAULT ('') NOT NULL ,

[role_order] [int] DEFAULT (0) NOT NULL

ALTER TABLE [phpbb_acl_roles] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_acl_roles] PRIMARY KEY CLUSTERED

(

[role_id]

GO

GO

GO

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

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

[auth_setting] [int] DEFAULT (0) NOT NULL

ALTER TABLE [phpbb_acl_roles_data] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_acl_roles_data] PRIMARY KEY CLUSTERED

(

[role_id],

[auth_option_id]

GO

GO

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

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

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

GO

GO

GO

GO

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

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

[ban_give_reason] [varchar] (255) DEFAULT ('') NOT NULL

ALTER TABLE [phpbb_banlist] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_banlist] PRIMARY KEY CLUSTERED

(

[ban_id]

GO

GO

GO

GO

GO

[first_pass_replace] [text] DEFAULT ('') NOT NULL ,

[second_pass_match] [text] DEFAULT ('') NOT NULL ,

[second_pass_replace] [text] DEFAULT ('') NOT NULL

ALTER TABLE [phpbb_bbcodes] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_bbcodes] PRIMARY KEY CLUSTERED

(

[bbcode_id]

GO

GO

CREATE TABLE [phpbb_bookmarks] (

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

[user_id] [int] DEFAULT (0) NOT NULL

ALTER TABLE [phpbb_bookmarks] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_bookmarks] PRIMARY KEY CLUSTERED

(

[topic_id],

[user_id]

GO

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

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

[bot_ip] [varchar] (255) DEFAULT ('') NOT NULL

ALTER TABLE [phpbb_bots] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_bots] PRIMARY KEY CLUSTERED

(

[bot_id]

GO

GO

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

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

[is_dynamic] [int] DEFAULT (0) NOT NULL

ALTER TABLE [phpbb_config] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_config] PRIMARY KEY CLUSTERED

(

[config_name]

GO

GO

[code] [varchar] (8) DEFAULT ('') NOT NULL ,

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

[attempts] [int] DEFAULT (0) NOT NULL

ALTER TABLE [phpbb_confirm] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_confirm] PRIMARY KEY CLUSTERED

(

[session_id],

[confirm_id]

GO

GO

CREATE TABLE [phpbb_disallow] (

[disallow_id] [int] IDENTITY (1, 1) NOT NULL ,

[disallow_username] [varchar] (255) DEFAULT ('') NOT NULL

ALTER TABLE [phpbb_disallow] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_disallow] PRIMARY KEY CLUSTERED

(

[disallow_id]

GO

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

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

[draft_message] [text] DEFAULT ('') NOT NULL

ALTER TABLE [phpbb_drafts] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_drafts] PRIMARY KEY CLUSTERED

(

[draft_id]

GO

GO

[extension_id] [int] IDENTITY (1, 1) NOT NULL ,

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

[extension] [varchar] (100) DEFAULT ('') NOT NULL

ALTER TABLE [phpbb_extensions] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_extensions] PRIMARY KEY CLUSTERED

(

[extension_id]

GO

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

[allowed_forums] [varchar] (8000) DEFAULT ('') NOT NULL ,

[allow_in_pm] [int] DEFAULT (0) NOT NULL

ALTER TABLE [phpbb_extension_groups] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_extension_groups] PRIMARY KEY CLUSTERED

(

[group_id]

GO

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

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

[prune_freq] [int] DEFAULT (0) NOT NULL

ALTER TABLE [phpbb_forums] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_forums] PRIMARY KEY CLUSTERED

(

[forum_id]

GO

GO

GO

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

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

[session_id] [char] (32) DEFAULT ('') NOT NULL

ALTER TABLE [phpbb_forums_access] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_forums_access] PRIMARY KEY CLUSTERED

[forum_id],

[user_id],

[session_id]

GO

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

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

[mark_time] [int] DEFAULT (0) NOT NULL

ALTER TABLE [phpbb_forums_track] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_forums_track] PRIMARY KEY CLUSTERED

(

[user_id],

[forum_id]

GO

CREATE TABLE [phpbb_forums_watch] (

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

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

GO

GO

GO

GO

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

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

[group_legend] [int] DEFAULT (1) NOT NULL

ALTER TABLE [phpbb_groups] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_groups] PRIMARY KEY CLUSTERED

(

[group_id]

GO

GO

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

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

[display_on_posting] [int] DEFAULT (1) NOT NULL

ALTER TABLE [phpbb_icons] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_icons] PRIMARY KEY CLUSTERED

(

[icons_id]

GO

GO

[lang_english_name] [varchar] (100) DEFAULT ('') NOT NULL ,

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

[lang_author] [varchar] (255) DEFAULT ('') NOT NULL

ALTER TABLE [phpbb_lang] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_lang] PRIMARY KEY CLUSTERED

(

[lang_id]

GO

GO

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

[log_operation] [varchar] (4000) DEFAULT ('') NOT NULL ,

[log_data] [text] DEFAULT ('') NOT NULL

ALTER TABLE [phpbb_log] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_log] PRIMARY KEY CLUSTERED

(

[log_id]

GO

GO

GO

GO

GO

GO

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

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

[username] [varchar] (255) DEFAULT (0) NOT NULL ,

GO

GO

GO

GO

GO

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

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

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

GO

GO

GO

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

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

[module_auth] [varchar] (255) DEFAULT ('') NOT NULL

ALTER TABLE [phpbb_modules] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_modules] PRIMARY KEY CLUSTERED

(

[module_id]

GO

GO

GO

GO

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

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

[poll_option_text] [varchar] (4000) DEFAULT ('') NOT NULL ,

GO

GO

GO

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

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

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

GO

GO

GO

GO

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

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

[post_edit_locked] [int] DEFAULT (0) NOT NULL

ALTER TABLE [phpbb_posts] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_posts] PRIMARY KEY CLUSTERED

(

[post_id]

GO

GO

GO

GO

GO

GO

GO

GO

[to_address] [varchar] (4000) DEFAULT ('') NOT NULL ,

[bcc_address] [varchar] (4000) DEFAULT ('') NOT NULL ,

[message_reported] [int] DEFAULT (0) NOT NULL

ALTER TABLE [phpbb_privmsgs] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_privmsgs] PRIMARY KEY CLUSTERED

(

[msg_id]

GO

GO

GO

GO

GO

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

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

[pm_count] [int] DEFAULT (0) NOT NULL

ALTER TABLE [phpbb_privmsgs_folder] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_privmsgs_folder] PRIMARY KEY CLUSTERED

(

[folder_id]

GO

GO

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

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

[rule_folder_id] [int] DEFAULT (0) NOT NULL

ALTER TABLE [phpbb_privmsgs_rules] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_privmsgs_rules] PRIMARY KEY CLUSTERED

(

[rule_id]

GO

GO

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

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

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

GO

GO

GO

GO

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

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

[field_order] [int] DEFAULT (0) NOT NULL

ALTER TABLE [phpbb_profile_fields] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_profile_fields] PRIMARY KEY CLUSTERED

(

[field_id]

GO

GO

GO

*/

CREATE TABLE [phpbb_profile_fields_data] (

[user_id] [int] DEFAULT (0) NOT NULL

ALTER TABLE [phpbb_profile_fields_data] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_profile_fields_data] PRIMARY KEY CLUSTERED

(

[user_id]

GO

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

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

[lang_value] [varchar] (255) DEFAULT ('') NOT NULL

ALTER TABLE [phpbb_profile_fields_lang] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_profile_fields_lang] PRIMARY KEY CLUSTERED

[field_id],

[lang_id],

[option_id]

GO

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

[lang_explain] [varchar] (4000) DEFAULT ('') NOT NULL ,

[lang_default_value] [varchar] (255) DEFAULT ('') NOT NULL

ALTER TABLE [phpbb_profile_lang] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_profile_lang] PRIMARY KEY CLUSTERED

(

[field_id],

[lang_id]

GO

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

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

[rank_image] [varchar] (255) DEFAULT ('') NOT NULL

ALTER TABLE [phpbb_ranks] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_ranks] PRIMARY KEY CLUSTERED

(

[rank_id]

GO

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

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

[report_text] [text] DEFAULT ('') NOT NULL

ALTER TABLE [phpbb_reports] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_reports] PRIMARY KEY CLUSTERED

(

[report_id]

GO

GO

GO

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

[reason_description] [text] DEFAULT ('') NOT NULL ,

[reason_order] [int] DEFAULT (0) NOT NULL

ALTER TABLE [phpbb_reports_reasons] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_reports_reasons] PRIMARY KEY CLUSTERED

(

[reason_id]

GO

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

[search_keywords] [text] DEFAULT ('') NOT NULL ,

[search_authors] [text] DEFAULT ('') NOT NULL

ALTER TABLE [phpbb_search_results] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_search_results] PRIMARY KEY CLUSTERED

(

[search_key]

GO

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

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

[word_count] [int] DEFAULT (0) NOT NULL

ALTER TABLE [phpbb_search_wordlist] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_search_wordlist] PRIMARY KEY CLUSTERED

(

[word_id]

GO

GO

GO

CREATE TABLE [phpbb_search_wordmatch] (

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

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

GO

GO

GO

GO

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

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

[session_admin] [int] DEFAULT (0) NOT NULL

ALTER TABLE [phpbb_sessions] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_sessions] PRIMARY KEY CLUSTERED

(

[session_id]

GO

GO

GO

GO

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

[last_ip] [varchar] (40) DEFAULT ('') NOT NULL ,

[last_login] [int] DEFAULT (0) NOT NULL

ALTER TABLE [phpbb_sessions_keys] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_sessions_keys] PRIMARY KEY CLUSTERED

(

[key_id],

[user_id]

GO

GO

[site_ip] [varchar] (40) DEFAULT ('') NOT NULL ,

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

[ip_exclude] [int] DEFAULT (0) NOT NULL

ALTER TABLE [phpbb_sitelist] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_sitelist] PRIMARY KEY CLUSTERED

(

[site_id]

GO

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

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

[display_on_posting] [int] DEFAULT (1) NOT NULL

ALTER TABLE [phpbb_smilies] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_smilies] PRIMARY KEY CLUSTERED

(

[smiley_id]

GO

GO

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

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

[imageset_id] [int] DEFAULT (0) NOT NULL

ALTER TABLE [phpbb_styles] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_styles] PRIMARY KEY CLUSTERED

(

[style_id]

GO

GO

GO

GO

GO

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

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

[template_inherit_path] [varchar] (255) DEFAULT ('') NOT NULL

ALTER TABLE [phpbb_styles_template] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_styles_template] PRIMARY KEY CLUSTERED

(

[template_id]

GO

GO

[template_filename] [varchar] (100) DEFAULT ('') NOT NULL ,

[template_included] [varchar] (8000) DEFAULT ('') NOT NULL ,

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

GO

GO

GO

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

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

[theme_data] [text] DEFAULT ('') NOT NULL

ALTER TABLE [phpbb_styles_theme] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_styles_theme] PRIMARY KEY CLUSTERED

(

[theme_id]

GO

GO

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

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

[imageset_path] [varchar] (100) DEFAULT ('') NOT NULL

ALTER TABLE [phpbb_styles_imageset] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_styles_imageset] PRIMARY KEY CLUSTERED

(

[imageset_id]

GO

GO

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

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

[imageset_id] [int] DEFAULT (0) NOT NULL

ALTER TABLE [phpbb_styles_imageset_data] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_styles_imageset_data] PRIMARY KEY CLUSTERED

(

[image_id]

GO

GO

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

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

[poll_vote_change] [int] DEFAULT (0) NOT NULL

ALTER TABLE [phpbb_topics] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_topics] PRIMARY KEY CLUSTERED

(

[topic_id]

GO

GO

GO

GO

GO

GO

GO

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

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

[mark_time] [int] DEFAULT (0) NOT NULL

ALTER TABLE [phpbb_topics_track] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_topics_track] PRIMARY KEY CLUSTERED

(

[user_id],

[topic_id]

GO

GO

GO

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

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

[topic_posted] [int] DEFAULT (0) NOT NULL

ALTER TABLE [phpbb_topics_posted] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_topics_posted] PRIMARY KEY CLUSTERED

(

[user_id],

[topic_id]

GO

CREATE TABLE [phpbb_topics_watch] (

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

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

GO

GO

GO

GO

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

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

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

GO

GO

GO

GO

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

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

[user_reminded_time] [int] DEFAULT (0) NOT NULL

ALTER TABLE [phpbb_users] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_users] PRIMARY KEY CLUSTERED

(

[user_id]

GO

GO

GO

GO

GO

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

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

[warning_time] [int] DEFAULT (0) NOT NULL

ALTER TABLE [phpbb_warnings] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_warnings] PRIMARY KEY CLUSTERED

(

[warning_id]

GO

[word_id] [int] IDENTITY (1, 1) NOT NULL ,

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

[replacement] [varchar] (255) DEFAULT ('') NOT NULL

ALTER TABLE [phpbb_words] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_words] PRIMARY KEY CLUSTERED

(

[word_id]

GO

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

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

[foe] [int] DEFAULT (0) NOT NULL

ALTER TABLE [phpbb_zebra] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_zebra] PRIMARY KEY CLUSTERED

(

[user_id],

[zebra_id]

GO

# Bots having bot access

INSERT INTO phpbb_acl_groups (group_id, forum_id, auth_option_id, auth_role_id, auth_setting) VALUES (6, 2, 0, 19, 0);

INSERT INTO phpbb_acl_groups (group_id, forum_id, auth_option_id, auth_role_id, auth_setting) VALUES (7, 0, 0, 23, 0);

# NEW MEMBERS on the queue

'PERMANENT' => 'Permanent',

'UNTIL' => 'Until',

'USER_BAN_EXCLUDE_EXPLAIN' => 'Enable this to exclude the entered users from all current bans.',

'USER_BAN_EXPLAIN' => 'You can ban multiple users in one go by entering each name on a new line. Use the <span style="text-decoration: underline;">Find a member</span> facility to look up and add one or more users automatically.',

'USER_NO_BANNED' => 'No banned usernames',

'USER_UNBAN_EXPLAIN' => 'You can unban (or un-exclude) multiple users in one go using the appropriate combination of mouse and keyboard for your computer and browser. Excluded users are emphasised.',

));

'DEFAULT_LANGUAGE' => 'Default language',

'DEFAULT_STYLE' => 'Default style',

'DISABLE_BOARD' => 'Disable board',

'OVERRIDE_STYLE' => 'Override user style',

'OVERRIDE_STYLE_EXPLAIN' => 'Replaces user’s style with the default.',

'SITE_DESC' => 'Site description',

'AVATAR_GALLERY_PATH' => 'Avatar gallery path',

'AVATAR_GALLERY_PATH_EXPLAIN' => 'Path under your phpBB root directory for pre-loaded images, e.g. <samp>images/avatars/gallery</samp>.',

'AVATAR_STORAGE_PATH' => 'Avatar storage path',

'MAX_AVATAR_SIZE' => 'Maximum avatar dimensions',

'MAX_AVATAR_SIZE_EXPLAIN' => 'Width x Height in pixels.',

'MAX_FILESIZE' => 'Maximum avatar file size',

'ACP_BAN' => 'Banning',

'ACP_BAN_EMAILS' => 'Ban e-mails',

'ACP_BAN_IPS' => 'Ban IPs',

'ACP_BBCODES' => 'BBCodes',

'ACP_BOARD_CONFIGURATION' => 'Board configuration',

'ACP_BOARD_FEATURES' => 'Board features',

'CANNOT_FORCE_REACT_FOUNDER' => 'You are not allowed to force reactivation on founder accounts.',

'CANNOT_FORCE_REACT_YOURSELF' => 'You are not allowed to force reactivation of your own account.',

'CANNOT_REMOVE_ANONYMOUS' => 'You are not able to remove the guest user account.',

'CANNOT_REMOVE_YOURSELF' => 'You are not allowed to remove your own user account.',

'CANNOT_SET_FOUNDER_IGNORED' => 'You are not able to promote ignored users to be founders.',

'CANNOT_SET_FOUNDER_INACTIVE' => 'You need to activate users before you promote them to founders, only activated users are able to be promoted.',

'MODERATE' => 'Moderate',

'MODERATOR' => 'Moderator',

'MODERATORS' => 'Moderators',

'MONTH' => 'Month',

'MOVE' => 'Move',

'MSNM' => 'MSNM/WLM',

'TOTAL_USERS_ZERO' => 'Total members <strong>0</strong>',

'TRACKED_PHP_ERROR' => 'Tracked PHP errors: %s',

'UNABLE_TO_DELIVER_FILE'=> 'Unable to deliver file.',

'UNKNOWN_BROWSER' => 'Unknown browser',

'UNMARK_ALL' => 'Unmark all',

Hello {USERNAME},

If you want to view the newest post made since your last visit, click the following link:

{U_NEWEST_POST}

{U_FORUM}

If you no longer wish to watch this topic you can either click the "Unsubscribe topic" link found at the bottom of the topic above, or by clicking the following link:

{U_STOP_WATCHING_TOPIC}

{EMAIL_SIG} \ No newline at end of file

),

'USER_ONLINE' => 'Online',

'USER_PRESENCE' => 'Board presence',

'VIEWING_PROFILE' => 'Viewing profile - %s',

'VISITED' => 'Last visited',

$total_match_count = $search->author_search($show_results, $firstpost_only, $sort_by_sql, $sort_key, $sort_dir, $sort_days, $ex_fid_ary, $m_approve_fid_ary, $topic_id, $author_id_ary, $sql_author_match, $id_ary, $start, $per_page);

}

$sql_where = '';

if (sizeof($id_ary))

}

// define some vars for urls

$u_hilit = urlencode(htmlspecialchars_decode(str_replace('|', ' ', $hilit)));

$u_show_results = '&amp;sr=' . $show_results;

$hilit_array = array_filter(explode('|', $hilit), 'strlen');

foreach ($hilit_array as $key => $value)

{

$hilit_array[$key] = preg_replace('#(^|\s)\\\\w\*\?(\s|$)#', '$1\w+?$2', $hilit_array[$key]);

}

$hilit = implode('|', $hilit_array);

# General Information about this style

name = prosilver

*/

function storeCaret(textEl)

{

{

textEl.caretPos = document.selection.createRange().duplicate();

}

// jQuery code in case jQuery is used

if (jquery_present)

{

{

var default_button = jQuery(this).parents('form').find('input[type=submit].default-submit-action');

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

<ul class="linklist">

<!-- IF not S_IS_BOT -->

<!-- IF S_WATCH_FORUM_LINK --><li <!-- IF S_WATCHING_FORUM -->class="icon-unsubscribe"<!-- ELSE -->class="icon-subscribe"<!-- ENDIF -->><a href="{S_WATCH_FORUM_LINK}" title="{S_WATCH_FORUM_TITLE}">{S_WATCH_FORUM_TITLE}</a></li><!-- ENDIF -->

<!-- IF U_WATCH_TOPIC --><li <!-- IF S_WATCHING_TOPIC -->class="icon-unsubscribe"<!-- ELSE -->class="icon-subscribe"<!-- ENDIF -->><a href="{U_WATCH_TOPIC}" title="{L_WATCH_TOPIC}">{L_WATCH_TOPIC}</a></li><!-- ENDIF -->

<fieldset>

<dl>

<dt><label for="group_colour">{L_GROUP_COLOR}:</label><br /><span>{L_GROUP_COLOR_EXPLAIN}</span></dt>

</dl>

<dl>

<dt><label for="group_rank">{L_GROUP_RANK}:</label></dt>

<meta http-equiv="imagetoolbar" content="no" />

<meta name="resource-type" content="document" />

<meta name="distribution" content="global" />

<meta name="robots" content="noindex" />

{META}

<title>{SITENAME} &bull; {PAGE_TITLE}</title>

<dl>

<dt><label for="bday_day">{L_BIRTHDAY}:</label><br /><span>{L_BIRTHDAY_EXPLAIN}</span></dt>

<dd>

</dd>

</dl>

<!-- ENDIF -->

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

<!-- IF S_FORCE_PASSWORD -->

<!-- ENDIF -->

<fieldset>

</fieldset>

</form>

<meta http-equiv="imagetoolbar" content="no" />

<meta name="resource-type" content="document" />

<meta name="distribution" content="global" />

<meta name="robots" content="noindex" />

{META}

<title>{SITENAME} &bull; {PAGE_TITLE}</title>

# General Information about this style

name = subsilver2

version = 3.0.12

*/

function storeCaret(textEl)

{

{

textEl.caretPos = document.selection.createRange().duplicate();

}

<meta http-equiv="Content-Type" content="text/html; charset={S_CONTENT_ENCODING}">

<meta http-equiv="Content-Style-Type" content="text/css">

<meta http-equiv="Content-Language" content="{S_USER_LANG}">

<title>{SITENAME} :: {PAGE_TITLE}</title>

<style type="text/css">

</tr>

<!-- IF S_FORCE_PASSWORD -->

<tr>

</tr>

<!-- ENDIF -->

<!-- IF ERROR -->

</tr>

</table>

<meta http-equiv="Content-Type" content="text/html; charset={S_CONTENT_ENCODING}">

<meta http-equiv="Content-Style-Type" content="text/css">

<meta http-equiv="Content-Language" content="{S_USER_LANG}">

<title>{SITENAME} :: {PAGE_TITLE}</title>

<style type="text/css">

$highlight_match = $highlight = '';

if ($hilit_words)

{

}

// Make sure $start is set to the last page if it exceeds the amount

$edit_allowed = ($user->data['is_registered'] && ($auth->acl_get('m_edit', $forum_id) || (

$user->data['user_id'] == $poster_id &&

$auth->acl_get('f_edit', $forum_id) &&

!$row['post_edit_locked'] &&

($row['post_time'] > time() - ($config['edit_time'] * 60) || !$config['edit_time'])

)));

$delete_allowed = ($user->data['is_registered'] && ($auth->acl_get('m_delete', $forum_id) || (

$user->data['user_id'] == $poster_id &&

$auth->acl_get('f_delete', $forum_id) &&

$topic_data['topic_last_post_id'] == $row['post_id'] &&

($row['post_time'] > time() - ($config['delete_time'] * 60) || !$config['delete_time']) &&

// we do not want to allow removal of the last post if a moderator locked it!

'S_ONLINE' => ($poster_id == ANONYMOUS || !$config['load_onlinetrack']) ? false : (($user_cache[$poster_id]['online']) ? true : false),

'U_EDIT' => ($edit_allowed) ? append_sid("{$phpbb_root_path}posting.$phpEx", "mode=edit&amp;f=$forum_id&amp;p={$row['post_id']}") : '',

'U_INFO' => ($auth->acl_get('m_info', $forum_id)) ? append_sid("{$phpbb_root_path}mcp.$phpEx", "i=main&amp;mode=post_details&amp;f=$forum_id&amp;p=" . $row['post_id'], true, $user->session_id) : '',

'U_DELETE' => ($delete_allowed) ? append_sid("{$phpbb_root_path}posting.$phpEx", "mode=delete&amp;f=$forum_id&amp;p={$row['post_id']}") : '',