+$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");

+ 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");

+ break;

+ }

+

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

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

+ '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>' : $seperator;

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

+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();

+ $check_acl = false;

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

+

+ if ($forum_id === false)

+ {

+ return;

+ }

+

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

+# 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.

+ */

+ * 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.

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

+ 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);

+ }

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

+ {

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

+ }

+