+ margin: 2px 0;

+ font-size: 1em;

+ margin: 2px 0;

+$schema_path = dirname(__FILE__) . '/../install/schemas/';

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

+ case 'firebird':

+ case 'sqlite':

+ fwrite($fp, "# DO NOT EDIT THIS FILE, IT IS GENERATED\n");

+ fwrite($fp, "#\n");

+ fwrite($fp, "# To change the contents of this file, edit\n");

+ fwrite($fp, "# phpBB/develop/create_schema_files.php and\n");

+ fwrite($fp, "# run it.\n");

+ break;

+

+ case 'mssql':

+ case 'oracle':

+ case 'postgres':

+ fwrite($fp, "/*\n");

+ fwrite($fp, " * DO NOT EDIT THIS FILE, IT IS GENERATED\n");

+ fwrite($fp, " *\n");

+ fwrite($fp, " * To change the contents of this file, edit\n");

+ fwrite($fp, " * phpBB/develop/create_schema_files.php and\n");

+ fwrite($fp, " * run it.\n");

+ fwrite($fp, " */\n\n");

+ }

+ switch ($dbms)

+ {

+ <p>Please also be as detailed as you can in your report, if possible list the steps required to duplicate the problem. If you have a patch that fixes the issue, please attach it to the ticket or submit a pull request <a href="https://github.com/phpbb/phpbb3">on GitHub</a>.</p>

+<a name="disclaimer"></a><h2>8. Copyright and disclaimer</h2>

+ 'min_post_chars' => array('lang' => 'MIN_CHAR_LIMIT', 'validate' => 'int:1', 'type' => 'text:4:6', 'explain' => true),

+ if ($forum_data['forum_name'] == '')

+ // However there are some attributes that need to be set everytime,

+ // otherwise the group gets removed from the feature.

+ $set_attributes = array('legend', 'teampage');

+ if (isset($submit_ary[$test]) && ($action == 'add' || $group_row['group_' . $test] != $submit_ary[$test] || in_array($test, $set_attributes)))

+ 'S_SPECIAL_RANK' => (isset($ranks['rank_special']) && $ranks['rank_special']) ? true : false,

+ $info = obtain_latest_version_info(request_var('versioncheck_force', false));

+ if ($config['ip_login_limit_max'] && $attempts >= $config['ip_login_limit_max'])

+ {

+ return array(

+ 'status' => LOGIN_ERROR_ATTEMPTS,

+ 'error_msg' => 'LOGIN_ERROR_ATTEMPTS',

+ 'user_row' => array('user_id' => ANONYMOUS),

+ );

+ }

+

+ * Gets a list of tables in the database.

+ *

+ * @return array Array of table names (all lower case)

+ */

+ function sql_list_tables()

+ {

+ switch ($this->db->sql_layer)

+ {

+ case 'mysql':

+ case 'mysql4':

+ case 'mysqli':

+ $sql = 'SHOW TABLES';

+ break;

+

+ case 'sqlite':

+ $sql = 'SELECT name

+ FROM sqlite_master

+ WHERE type = "table"';

+ break;

+

+ case 'mssql':

+ case 'mssql_odbc':

+ case 'mssqlnative':

+ $sql = "SELECT name

+ FROM sysobjects

+ WHERE type='U'";

+ break;

+

+ case 'postgres':

+ $sql = 'SELECT relname

+ FROM pg_stat_user_tables';

+ break;

+

+ case 'firebird':

+ $sql = 'SELECT rdb$relation_name

+ FROM rdb$relations

+ WHERE rdb$view_source is null

+ AND rdb$system_flag = 0';

+ break;

+

+ case 'oracle':

+ $sql = 'SELECT table_name

+ FROM USER_TABLES';

+ break;

+ }

+

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

+

+ $tables = array();

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

+ {

+ $name = current($row);

+ $tables[$name] = $name;

+ }

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

+

+ return $tables;

+ }

+

+ /**

+ * Gets a list of columns of a table.

+ * @param string $table Table name

+ * @return array Array of column names (all lower case)

+ function sql_list_columns($table)

+ $columns = array();

+

+

+ $column = strtolower($entities[0]);

+ $columns[$column] = $column;

+

+ return $columns;

+

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

+

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

+ {

+ $column = strtolower(current($row));

+ $columns[$column] = $column;

+ }

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

+

+ return $columns;

+ }

+

+ /**

+ * Check whether a specified column exist in a table

+ *

+ * @param string $table Table to check

+ * @param string $column_name Column to check

+ *

+ * @return bool True if column exists, false otherwise

+ */

+ function sql_column_exists($table, $column_name)

+ {

+ $columns = $this->sql_list_columns($table);

+

+ return isset($columns[$column_name]);

+ $statements[] = 'ALTER TABLE ' . $table_name . ' ADD UNIQUE INDEX (' . implode(', ', $column) . ')';

+ $statements[] = 'ALTER TABLE ' . $table_name . ' ADD INDEX ' . $index_name . '(' . implode(', ', $column) . ')';

+ if ($query_id !== false)

+ {

+ $result = @mysqli_fetch_assoc($query_id);

+ return $result !== null ? $result : false;

+ }

+

+ return false;

+ $page_string .= ($start_cnt > 1) ? '<span class="page-dots"> ... </span>' : $separator;

+ $page_string .= ($end_cnt < $total_pages) ? '<span class="page-dots"> ... </span>' : $separator;

+ $tpl_prefix . 'CURRENT_PAGE' => $on_page,

+ if (function_exists('memory_get_peak_usage'))

+ if ($memory_usage = memory_get_peak_usage())

+ $debug_output .= ' | Peak Memory Usage: ' . $memory_usage;

+ if (function_exists('memory_get_peak_usage'))

+ if ($memory_usage = memory_get_peak_usage())

+ $debug_output .= ' | Peak Memory Usage: ' . $memory_usage;

+function get_remote_file($host, $directory, $filename, &$errstr, &$errno, $port = 80, $timeout = 6)

+ $timer_stop = time() + $timeout;

+ stream_set_timeout($fsock, $timeout);

+

+

+ $stream_meta_data = stream_get_meta_data($fsock);

+

+ if (!empty($stream_meta_data['timed_out']) || time() >= $timer_stop)

+ {

+ $errstr = $user->lang['FSOCK_TIMEOUT'];

+ return false;

+ }

+ $pagination .= '<span class="page-dots"> ... </span>';

+ ),

+*

+* @deprecated

+function get_tables(&$db)

+ if (!class_exists('phpbb_db_tools'))

+ global $phpbb_root_path, $phpEx;

+ require($phpbb_root_path . 'includes/db/db_tools.' . $phpEx);

+ $db_tools = new phpbb_db_tools($db);

+ return $db_tools->sql_list_tables();

+

+function phpbb_create_config_file_data($data, $dbms, $load_extensions, $debug = false)

+{

+ $load_extensions = implode(',', $load_extensions);

+

+ $config_data = "<?php\n";

+ $config_data .= "// phpBB 3.0.x auto-generated configuration file\n// Do not change anything in this file!\n";

+

+ $config_data_array = array(

+ 'dbms' => $dbms,

+ 'dbhost' => $data['dbhost'],

+ 'dbport' => $data['dbport'],

+ 'dbname' => $data['dbname'],

+ 'dbuser' => $data['dbuser'],

+ 'dbpasswd' => htmlspecialchars_decode($data['dbpasswd']),

+ 'table_prefix' => $data['table_prefix'],

+ 'acm_type' => 'file',

+ 'load_extensions' => $load_extensions,

+ );

+

+ foreach ($config_data_array as $key => $value)

+ {

+ $config_data .= "\${$key} = '" . str_replace("'", "\\'", str_replace('\\', '\\\\', $value)) . "';\n";

+ }

+

+ $config_data .= "\n@define('PHPBB_INSTALLED', true);\n";

+

+ if ($debug)

+ {

+ $config_data .= "@define('DEBUG', true);\n";

+ $config_data .= "@define('DEBUG_EXTRA', true);\n";

+ }

+ else

+ {

+ $config_data .= "// @define('DEBUG', true);\n";

+ $config_data .= "// @define('DEBUG_EXTRA', true);\n";

+ }

+

+ $config_data .= '?' . '>'; // Done this to prevent highlighting editors getting confused!

+

+ return $config_data;

+}

+ 3) Implement the rule logic in the check_rule() function

+ 4) Add a new language variable to ucp.php

+ RULE_IS_LIKE => array('check0' => 'message_subject'),

+ RULE_IS_NOT_LIKE => array('check0' => 'message_subject'),

+ RULE_IS => array('check0' => 'message_subject'),

+ RULE_IS_NOT => array('check0' => 'message_subject'),

+ RULE_BEGINS_WITH => array('check0' => 'message_subject'),

+ RULE_ENDS_WITH => array('check0' => 'message_subject'),

+ RULE_IS_LIKE => array('check0' => 'username'),

+ RULE_IS_NOT_LIKE => array('check0' => 'username'),

+ RULE_IS => array('check0' => 'username'),

+ RULE_IS_NOT => array('check0' => 'username'),

+ RULE_BEGINS_WITH => array('check0' => 'username'),

+ RULE_ENDS_WITH => array('check0' => 'username'),

+ RULE_IS_FRIEND => array('check0' => 'friend'),

+ RULE_IS_FOE => array('check0' => 'foe'),

+ RULE_IS_USER => array('check0' => 'author_id'),

+ RULE_IS_GROUP => array('check0' => 'author_in_group'),

+ RULE_IS_LIKE => array('check0' => 'message_text'),

+ RULE_IS_NOT_LIKE => array('check0' => 'message_text'),

+ RULE_IS => array('check0' => 'message_text'),

+ RULE_IS_NOT => array('check0' => 'message_text'),

+ RULE_ANSWERED => array('check0' => 'pm_replied'),

+ RULE_FORWARDED => array('check0' => 'pm_forwarded'),

+ RULE_TO_GROUP => array('check0' => 'to', 'check1' => 'bcc', 'check2' => 'user_in_group'),

+ RULE_TO_ME => array('check0' => 'to', 'check1' => 'bcc'),

+ $result = false;

+ $check0 = $message_row[$check_ary['check0']];

+

+ switch ($rule_row['rule_connection'])

+ {

+ case RULE_IS_LIKE:

+ $result = preg_match("/" . preg_quote($rule_row['rule_string'], '/') . '/i', $check0);

+ break;

+

+ case RULE_IS_NOT_LIKE:

+ $result = !preg_match("/" . preg_quote($rule_row['rule_string'], '/') . '/i', $check0);

+ break;

+

+ case RULE_IS:

+ $result = ($check0 == $rule_row['rule_string']);

+ break;

+

+ case RULE_IS_NOT:

+ $result = ($check0 != $rule_row['rule_string']);

+ break;

+

+ case RULE_BEGINS_WITH:

+ $result = preg_match("/^" . preg_quote($rule_row['rule_string'], '/') . '/i', $check0);

+ break;

+

+ case RULE_ENDS_WITH:

+ $result = preg_match("/" . preg_quote($rule_row['rule_string'], '/') . '$/i', $check0);

+ break;

+

+ case RULE_IS_FRIEND:

+ case RULE_IS_FOE:

+ case RULE_ANSWERED:

+ case RULE_FORWARDED:

+ $result = ($check0 == 1);

+ break;

+

+ case RULE_IS_USER:

+ $result = ($check0 == $rule_row['rule_user_id']);

+ break;

+

+ case RULE_IS_GROUP:

+ $result = in_array($rule_row['rule_group_id'], $check0);

+ break;

+

+ case RULE_TO_GROUP:

+ $result = (in_array('g_' . $message_row[$check_ary['check2']], $check0) || in_array('g_' . $message_row[$check_ary['check2']], $message_row[$check_ary['check1']]));

+ break;

+

+ case RULE_TO_ME:

+ $result = (in_array('u_' . $user_id, $check0) || in_array('u_' . $user_id, $message_row[$check_ary['check1']]));

+ break;

+ }

+ $check_acl = false;

+ $forum_id = check_ids($topic_ids, TOPICS_TABLE, 'topic_id', $check_acl, true);

+

+ if ($forum_id === false)

+ {

+ return;

+ }

+

+ const REGEX_VAR_SUFFIX = '[A-Z_0-9]+';

+ $text_blocks = preg_replace('#\{L_(' . self::REGEX_VAR_SUFFIX . ')\}#', "<?php echo ((isset(\$_rootref['L_\\1'])) ? \$_rootref['L_\\1'] : ((isset(\$_lang['\\1'])) ? \$_lang['\\1'] : '{ \\1 }')); /**/?>", $text_blocks, -1, $replacements);

+ $text_blocks = preg_replace('#\{LA_(' . self::REGEX_VAR_SUFFIX . '+)\}#', "<?php echo ((isset(\$_rootref['LA_\\1'])) ? \$_rootref['LA_\\1'] : ((isset(\$_rootref['L_\\1'])) ? addslashes(\$_rootref['L_\\1']) : ((isset(\$_lang['\\1'])) ? addslashes(\$_lang['\\1']) : '{ \\1 }'))); /**/?>", $text_blocks, -1, $replacements);

+ if (($pos = strrpos($namespace, '.')) !== false)

+ {

+ $local_namespace = substr($namespace, $pos + 1);

+ }

+ else

+ {

+ $local_namespace = $namespace;

+ }

+

+ $varref = "\$_${local_namespace}_i";

+ $varref = "\$_${local_namespace}_count";

+ $varref = "(\$_${local_namespace}_i == 0)";

+ $varref = "(\$_${local_namespace}_i == \$_${local_namespace}_count - 1)";

+ $varref = "'$local_namespace'";

+ 'U_ICQ' => ($user_info['user_icq']) ? 'http://www.icq.com/people/' . urlencode($user_info['user_icq']) . '/' : '',

+ if (!isset($config['use_system_cron']))

+ {

+ set_config('use_system_cron', 0);

+ }

+ $sql = 'SELECT group_teampage

+ WHERE group_teampage > 0';

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

+ $added_groups_teampage = (bool) $db->sql_fetchfield('group_teampage');

+ $db->sql_freeresult($result);

+ if (!$added_groups_teampage)

+ SET group_teampage = 1

+ WHERE group_type = ' . GROUP_SPECIAL . "

+ AND group_name = 'ADMINISTRATORS'";

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

+

+ $sql = 'UPDATE ' . GROUPS_TABLE . '

+ SET group_teampage = 2

+ WHERE group_type = ' . GROUP_SPECIAL . "

+ AND group_name = 'GLOBAL_MODERATORS'";

+ }

+ if (!isset($config['use_system_cron']))

+ {

+ set_config('legend_sort_groupname', '0');

+ set_config('teampage_multiple', '1');

+ set_config('teampage_forums', '1');

+

+ $sql = 'SELECT group_legend

+ FROM ' . GROUPS_TABLE . '

+ WHERE group_teampage > 1';

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

+ $updated_group_legend = (bool) $db->sql_fetchfield('group_teampage');

+

+ if (!$updated_group_legend)

+ {

+ $sql = 'SELECT group_id

+ FROM ' . GROUPS_TABLE . '

+ WHERE group_legend = 1

+ ORDER BY group_name ASC';

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

+

+ $next_legend = 1;

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

+ {

+ $sql = 'UPDATE ' . GROUPS_TABLE . '

+ SET group_legend = ' . $next_legend . '

+ WHERE group_id = ' . (int) $row['group_id'];

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

+

+ $next_legend++;

+ }

+ $db->sql_freeresult($result);

+ unset($next_legend);

+ }

+ if (!isset($config['load_cpf_pm']))

+ {

+ set_config('load_cpf_pm', '0');

+ }

+ $config_data = phpbb_create_config_file_data($data, $available_dbms[$data['dbms']]['DRIVER'], $load_extensions);

+# DO NOT EDIT THIS FILE, IT IS GENERATED

+# To change the contents of this file, edit

+# phpBB/develop/create_schema_files.php and

+# run it.

+ * DO NOT EDIT THIS FILE, IT IS GENERATED

+ *

+ * To change the contents of this file, edit

+ * phpBB/develop/create_schema_files.php and

+ * run it.

+ */

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

+# DO NOT EDIT THIS FILE, IT IS GENERATED

+# To change the contents of this file, edit

+# phpBB/develop/create_schema_files.php and

+# run it.

+# DO NOT EDIT THIS FILE, IT IS GENERATED

+# To change the contents of this file, edit

+# phpBB/develop/create_schema_files.php and

+# run it.

+ * DO NOT EDIT THIS FILE, IT IS GENERATED

+ *

+ * To change the contents of this file, edit

+ * phpBB/develop/create_schema_files.php and

+ * run it.

+ */

+ * DO NOT EDIT THIS FILE, IT IS GENERATED

+ *

+ * To change the contents of this file, edit

+ * phpBB/develop/create_schema_files.php and

+ * run it.

+ */

+# DO NOT EDIT THIS FILE, IT IS GENERATED

+# To change the contents of this file, edit

+# phpBB/develop/create_schema_files.php and

+# run it.

+ 'MIN_CHAR_LIMIT_EXPLAIN' => 'The minimum number of characters the user need to enter within a post/private message. The minimum for this setting is 1.',

+ 'FORUM_ADMIN_EXPLAIN' => 'In phpBB3 everything is forum based. A category is just a special type of forum. Each forum can have an unlimited number of sub-forums and you can determine whether each may be posted to or not (i.e. whether it acts like an old category). Here you can add, edit, delete, lock, unlock individual forums as well as set certain additional controls. If your posts and topics have got out of sync you can also resynchronise a forum. <strong>You need to copy or set appropriate permissions for newly created forums to have them displayed.</strong>',

+ 'FSOCK_TIMEOUT' => 'A timeout occurred while reading from the network stream.',

+ 1 => 'It is possible an administrator has deactivated or deleted your account for some reason. Also, many boards periodically remove users who have not posted for a long time to reduce the size of the database. If this has happened, try registering again and being more involved in discussions.'

+ <dt><a href="{U_SORT_FILENAME}">{L_FILENAME}</a></dt>

+ <dt><a href="{attachrow.U_VIEW_ATTACHMENT}" class="topictitle">{attachrow.FILENAME}</a> ({attachrow.SIZE})<br />

+ <table class="table1" cellspacing="1">

+ <thead>

+ <th class="name">{L_MEMBERS}</th>

+ </tr>

+ </thead>

+ <tbody>

+ <tr>

+ <td class="bg1">{L_GROUPS_NO_MEMBERS}</td>

+ width: 90px;

+ <exclude>./tests/functional</exclude>

+ </testsuite>

+ <testsuite name="phpBB Functional Tests">

+ <directory suffix="_test.php" phpVersion="5.3.0" phpVersionOperator=">=">./tests/functional</directory>

+ <exclude>./tests/functional</exclude>

+ </testsuite>

+ <testsuite name="phpBB Functional Tests">

+ <directory suffix="_test.php" phpVersion="5.3.0" phpVersionOperator=">=">./tests/functional</directory>

+ <group>functional</group>

+<?xml version="1.0" encoding="UTF-8"?>

+

+<phpunit backupGlobals="true"

+ backupStaticAttributes="true"

+ colors="true"

+ convertErrorsToExceptions="true"

+ convertNoticesToExceptions="true"

+ convertWarningsToExceptions="true"

+ processIsolation="false"

+ stopOnFailure="false"

+ syntaxCheck="false"

+ bootstrap="tests/bootstrap.php"

+>

+ <testsuites>

+ <testsuite name="phpBB Test Suite">

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

+ <exclude>./tests/functional</exclude>

+ </testsuite>

+ <testsuite name="phpBB Functional Tests">

+ <directory suffix="_test.php" phpVersion="5.3.0" phpVersionOperator=">=">./tests/functional</directory>

+ </testsuite>

+ </testsuites>

+

+ <groups>

+ <include>

+ <group>functional</group>

+ </include>

+ </groups>

+

+ <filter>

+ <blacklist>

+ <directory>./tests/</directory>

+ </blacklist>

+ <whitelist>

+ <directory suffix=".php">./phpBB/includes/</directory>

+ <exclude>

+ <file>./phpBB/includes/db/firebird.php</file>

+ <file>./phpBB/includes/db/mysql.php</file>

+ <file>./phpBB/includes/db/mysqli.php</file>

+ <file>./phpBB/includes/db/mssql.php</file>

+ <file>./phpBB/includes/db/mssql_odbc.php</file>

+ <file>./phpBB/includes/db/mssqlnative.php</file>

+ <file>./phpBB/includes/db/oracle.php</file>

+ <file>./phpBB/includes/db/postgres.php</file>

+ <file>./phpBB/includes/db/sqlite.php</file>

+ <file>./phpBB/includes/search/fulltext_native.php</file>

+ <file>./phpBB/includes/search/fulltext_mysql.php</file>

+ <directory suffix=".php">./phpBB/includes/captcha/</directory>

+ </exclude>

+ </whitelist>

+ </filter>

+</phpunit>

+

+if (version_compare(PHP_VERSION, '5.3.0-dev', '>='))

+{

+ require_once 'test_framework/phpbb_functional_test_case.php';

+}

+ public function test_list_columns()

+ {

+ $this->assertEquals(

+ array_keys($this->table_data['COLUMNS']),

+ array_values($this->tools->sql_list_columns('prefix_table_name'))

+ );

+ }

+

+ public function test_list_tables()

+ {

+ $tables = $this->tools->sql_list_tables();

+ $this->assertTrue(isset($tables['prefix_table_name']));

+ $this->assertFalse(isset($tables['prefix_does_not_exist']));

+ }

+

+

+ public function test_index_exists()

+ {

+ $this->assertTrue($this->tools->sql_index_exists('prefix_table_name', 'i_simple'));

+ }

+

+ public function test_create_index_against_index_exists()

+ {

+ $this->tools->sql_create_index('prefix_table_name', 'fookey', array('c_timestamp', 'c_decimal'));

+ $this->assertTrue($this->tools->sql_index_exists('prefix_table_name', 'fookey'));

+ }

+ public function test_nested_transactions()

+

+ /**

+ * fix for PHPBB3-10307

+ */

+ public function test_sql_fetchrow_returns_false_when_empty()

+ {

+ $db = $this->new_dbal();

+

+ $sql = 'SELECT * FROM (SELECT 1) AS TBL WHERE 1 = 0';

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

+

+ $row = $db->sql_fetchrow($result);

+ $db->sql_freeresult($result);

+

+ $this->assertSame(false, $row);

+ }

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2011 phpBB Group

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

+*

+*/

+

+/**

+* @group functional

+*/

+class phpbb_functional_browse_test extends phpbb_functional_test_case

+{

+ public function test_index()

+ {

+ $crawler = $this->request('GET', 'index.php');

+ $this->assertGreaterThan(0, $crawler->filter('.topiclist')->count());

+ }

+

+ public function test_viewforum()

+ {

+ $crawler = $this->request('GET', 'viewforum.php?f=2');

+ $this->assertGreaterThan(0, $crawler->filter('.topiclist')->count());

+ }

+}

+ $result = $cp->validate_profile_field(FIELD_DROPDOWN, $field_value, $field_data);

+ "{ VARIABLE }\n{ 1_VARIABLE }\n{ VARIABLE }\n{ 1_VARIABLE }",

+ array('L_VARIABLE' => "Value'", 'L_1_VARIABLE' => "1 O'Clock"),

+ "Value'\n1 O'Clock\nValue\'\n1 O\'Clock",

+ array('LA_VARIABLE' => "Value'", 'LA_1_VARIABLE' => "1 O'Clock"),

+ "{ VARIABLE }\n{ 1_VARIABLE }\nValue'\n1 O'Clock",

+ "top-level content\nouter\nmiddle\ninner z\nfirst row of 2 in inner\n\ninner zz",

+{L_1_VARIABLE}

+{LA_1_VARIABLE}

+ {outer.middle.S_BLOCK_NAME}

+ first row of {outer.middle.inner.S_NUM_ROWS} in {middle.inner.S_BLOCK_NAME}

+ $config = phpbb_test_case_helpers::get_test_config();

+

+ if (!isset($config['dbms']))

+

+ return $config;

+ if ($this->config['dbport'])

+ {

+ $dsn .= ';port=' . $this->config['dbport'];

+ }

+

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2011 phpBB Group

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

+*

+*/

+

+require_once __DIR__ . '/../../vendor/goutte.phar';

+require_once __DIR__ . '/../../phpBB/includes/functions_install.php';

+

+class phpbb_functional_test_case extends phpbb_test_case

+{

+ protected $client;

+ protected $root_url;

+

+ static protected $config = array();

+ static protected $already_installed = false;

+

+ public function setUp()

+ {

+ if (!isset(self::$config['phpbb_functional_url']))

+ {

+ $this->markTestSkipped('phpbb_functional_url was not set in test_config and wasn\'t set as PHPBB_FUNCTIONAL_URL environment variable either.');

+ }

+

+ $this->client = new Goutte\Client();

+ $this->root_url = self::$config['phpbb_functional_url'];

+ }

+

+ public function request($method, $path)

+ {

+ return $this->client->request($method, $this->root_url . $path);

+ }

+

+ public function __construct($name = NULL, array $data = array(), $dataName = '')

+ {

+ parent::__construct($name, $data, $dataName);

+

+ $this->backupStaticAttributesBlacklist += array(

+ 'phpbb_functional_test_case' => array('config', 'already_installed'),

+ );

+

+ if (!self::$already_installed)

+ {

+ $this->install_board();

+ self::$already_installed = true;

+ }

+ }

+

+ protected function install_board()

+ {

+ global $phpbb_root_path, $phpEx;

+

+ self::$config = phpbb_test_case_helpers::get_test_config();

+

+ if (!isset(self::$config['phpbb_functional_url']))

+ {

+ return;

+ }

+

+ self::$config['table_prefix'] = 'phpbb_';

+ $this->recreate_database(self::$config);

+

+ if (file_exists($phpbb_root_path . "config.$phpEx"))

+ {

+ if (!file_exists($phpbb_root_path . "config_dev.$phpEx"))

+ {

+ rename($phpbb_root_path . "config.$phpEx", $phpbb_root_path . "config_dev.$phpEx");

+ }

+ else

+ {

+ unlink($phpbb_root_path . "config.$phpEx");

+ }

+ }

+

+ // begin data

+ $data = array();

+

+ $data = array_merge($data, self::$config);

+

+ $data = array_merge($data, array(

+ 'default_lang' => 'en',

+ 'admin_name' => 'admin',

+ 'admin_pass1' => 'admin',

+ 'admin_pass2' => 'admin',

+ 'board_email1' => 'nobody@example.com',

+ 'board_email2' => 'nobody@example.com',

+ ));

+

+ $parseURL = parse_url(self::$config['phpbb_functional_url']);

+

+ $data = array_merge($data, array(

+ 'email_enable' => false,

+ 'smtp_delivery' => false,

+ 'smtp_host' => '',

+ 'smtp_auth' => '',

+ 'smtp_user' => '',

+ 'smtp_pass' => '',

+ 'cookie_secure' => false,

+ 'force_server_vars' => false,

+ 'server_protocol' => $parseURL['scheme'] . '://',

+ 'server_name' => 'localhost',

+ 'server_port' => isset($parseURL['port']) ? (int) $parseURL['port'] : 80,

+ 'script_path' => $parseURL['path'],

+ ));

+ // end data

+

+ $content = $this->do_request('install');

+ $this->assertContains('Welcome to Installation', $content);

+

+ $this->do_request('create_table', $data);

+

+ file_put_contents($phpbb_root_path . "config.$phpEx", phpbb_create_config_file_data($data, self::$config['dbms'], array(), true));

+

+ $this->do_request('config_file', $data);

+

+ copy($phpbb_root_path . "config.$phpEx", $phpbb_root_path . "config_test.$phpEx");

+

+ $this->do_request('final', $data);

+ }

+

+ private function do_request($sub, $post_data = null)

+ {

+ $context = null;

+

+ if ($post_data)

+ {

+ $context = stream_context_create(array(

+ 'http' => array(

+ 'method' => 'POST',

+ 'header' => 'Content-Type: application/x-www-form-urlencoded',

+ 'content' => http_build_query($post_data),

+ 'ignore_errors' => true,

+ ),

+ ));

+ }

+

+ return file_get_contents(self::$config['phpbb_functional_url'] . 'install/index.php?mode=install&sub=' . $sub, false, $context);

+ }

+

+ private function recreate_database($config)

+ {

+ $db_conn_mgr = new phpbb_database_test_connection_manager($config);

+ $db_conn_mgr->recreate_db();

+ }

+}

+

+ static public function get_test_config()

+ {

+ $config = array();

+

+ if (extension_loaded('sqlite') && version_compare(PHPUnit_Runner_Version::id(), '3.4.15', '>='))

+ {

+ $config = array_merge($config, array(

+ 'dbms' => 'sqlite',

+ 'dbhost' => dirname(__FILE__) . '/../phpbb_unit_tests.sqlite2', // filename

+ 'dbport' => '',

+ 'dbname' => '',

+ 'dbuser' => '',

+ 'dbpasswd' => '',

+ ));

+ }

+

+ if (file_exists(dirname(__FILE__) . '/../test_config.php'))

+ {

+ include(dirname(__FILE__) . '/../test_config.php');

+

+ $config = array_merge($config, array(

+ 'dbms' => $dbms,

+ 'dbhost' => $dbhost,

+ 'dbport' => $dbport,

+ 'dbname' => $dbname,

+ 'dbuser' => $dbuser,

+ 'dbpasswd' => $dbpasswd,

+ ));

+

+ if (isset($phpbb_functional_url))

+ {

+ $config['phpbb_functional_url'] = $phpbb_functional_url;

+ }

+ }

+

+ if (isset($_SERVER['PHPBB_TEST_DBMS']))

+ {

+ $config = array_merge($config, array(

+ 'dbms' => isset($_SERVER['PHPBB_TEST_DBMS']) ? $_SERVER['PHPBB_TEST_DBMS'] : '',

+ 'dbhost' => isset($_SERVER['PHPBB_TEST_DBHOST']) ? $_SERVER['PHPBB_TEST_DBHOST'] : '',

+ 'dbport' => isset($_SERVER['PHPBB_TEST_DBPORT']) ? $_SERVER['PHPBB_TEST_DBPORT'] : '',

+ 'dbname' => isset($_SERVER['PHPBB_TEST_DBNAME']) ? $_SERVER['PHPBB_TEST_DBNAME'] : '',

+ 'dbuser' => isset($_SERVER['PHPBB_TEST_DBUSER']) ? $_SERVER['PHPBB_TEST_DBUSER'] : '',

+ 'dbpasswd' => isset($_SERVER['PHPBB_TEST_DBPASSWD']) ? $_SERVER['PHPBB_TEST_DBPASSWD'] : ''

+ ));

+ }

+

+ if (isset($_SERVER['PHPBB_FUNCTIONAL_URL']))

+ {

+ $config = array_merge($config, array(

+ 'phpbb_functional_url' => isset($_SERVER['PHPBB_FUNCTIONAL_URL']) ? $_SERVER['PHPBB_FUNCTIONAL_URL'] : '',

+ ));

+ }

+

+ return $config;

+ }

+ call_user_func_array(array('utf_normalizer', $form), array(&$utf_result));

+ call_user_func_array(array('utf_normalizer', $form), array(&$utf_result));