- global $user;

-

- $sort_dir_text = array('a' => $user->lang['ASCENDING'], 'd' => $user->lang['DESCENDING']);

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

-

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

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

- if (!$auth->acl_get('f_list', $row['forum_id']))

- if ($acl_list && !$auth->acl_gets($acl_list, $row['forum_id']))

- $template->assign_block_vars('jumpbox_forums', array(

- 'FORUM_NAME' => ($select_all) ? $user->lang['ALL_FORUMS'] : $user->lang['SELECT_FORUM'],

- $template->assign_block_vars('jumpbox_forums', array(

- $template->assign_block_vars('jumpbox_forums.level', array());

- $db->sql_freeresult($result);

- $template->assign_vars(array(

- 'S_JUMPBOX_ACTION' => $action)

- );

- global $auth, $user;

-

- if (!$auth->acl_get('f_bump', $forum_id) || $topic_bumped)

- if ($topic_poster != $user->data['user_id'] && $last_topic_poster != $user->data['user_id'])

- global $template, $user;

- if (!isset($template->filename['attachment_tpl']))

- $template->set_filenames(array(

- global $db;

-

- WHERE ' . $db->sql_in_set('attach_id', array_keys($attach_ids));

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

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

- $db->sql_freeresult($result);

- $template->destroy_block_vars('_file');

- if ($user->img('icon_topic_attach', '') && !$extensions[$attachment['extension']]['upload_icon'])

- $upload_icon = $user->img('icon_topic_attach', '');

- $size_lang = ($filesize >= 1048576) ? $user->lang['MIB'] : (($filesize >= 1024) ? $user->lang['KIB'] : $user->lang['BYTES']);

- 'DENIED_MESSAGE' => sprintf($user->lang['EXTENSION_DISABLED_AFTER_POSTING'], $attachment['extension'])

- if (($display_cat == ATTACHMENT_CATEGORY_IMAGE || $display_cat == ATTACHMENT_CATEGORY_THUMB) && !$user->optionget('viewimg'))

- if ($display_cat == ATTACHMENT_CATEGORY_FLASH && !$user->optionget('viewflash'))

- $l_download_count = (!isset($attachment['download_count']) || $attachment['download_count'] == 0) ? $user->lang[$l_downloaded_viewed . '_NONE'] : (($attachment['download_count'] == 1) ? sprintf($user->lang[$l_downloaded_viewed], $attachment['download_count']) : sprintf($user->lang[$l_downloaded_viewed . 'S'], $attachment['download_count']));

-

- 'L_DOWNLOAD_COUNT' => $l_download_count

- $template->assign_block_vars('_file', $block_array);

- $compiled_attachments[] = $template->assign_display('attachment_tpl');

- $replace['to'][] = (isset($attachments[$index])) ? $attachments[$index] : sprintf($user->lang['MISSING_INLINE_ATTACHMENT'], $matches[2][array_search($index, $matches[1])]);

- global $user, $auth;

-

-

-

-function connect_check_db($error_connect, &$error, $dbms_details, $table_prefix, $dbhost, $dbuser, $dbpasswd, $dbname, $dbport, $prefix_may_exist = false, $unicode_check = true)

- else

- // Likely matches for an existing phpBB installation

- if (!$prefix_may_exist)

- $temp_prefix = strtolower($table_prefix);

- $table_ary = array($temp_prefix . 'attachments', $temp_prefix . 'config', $temp_prefix . 'sessions', $temp_prefix . 'topics', $temp_prefix . 'users');

- $tables = get_tables($db);

- $tables = array_map('strtolower', $tables);

- $table_intersect = array_intersect($tables, $table_ary);

- if (sizeof($table_intersect))

- $error[] = phpbb::$user->lang['INST_ERR_PREFIX'];

- }

- // Make sure that the user has selected a sensible DBAL for the DBMS actually installed

- switch ($dbms_details['DRIVER'])

- {

- case 'mysql':

- if (version_compare($db->sql_server_info(true), '4.1.3', '<'))

- {

- $error[] = phpbb::$user->lang['INST_ERR_DB_NO_MYSQL'];

- }

- break;

- case 'mysqli':

- if (version_compare($db->sql_server_info(true), '4.1.3', '<'))

- $error[] = phpbb::$user->lang['INST_ERR_DB_NO_MYSQLI'];

- break;

- case 'sqlite':

- if (version_compare($db->sql_server_info(true), '2.8.2', '<'))

- $error[] = phpbb::$user->lang['INST_ERR_DB_NO_SQLITE'];

- break;

-

- case 'firebird':

- // check the version of FB, use some hackery if we can't get access to the server info

- if ($db->service_handle !== false && strtolower($dbuser) == 'sysdba')

- $val = @ibase_server_info($db->service_handle, IBASE_SVC_SERVER_VERSION);

- preg_match('#V([\d.]+)#', $val, $match);

- if ($match[1] < 2)

- {

- $error[] = phpbb::$user->lang['INST_ERR_DB_NO_FIREBIRD'];

- }

- $db_info = @ibase_db_info($db->service_handle, $dbname, IBASE_STS_HDR_PAGES);

-

- preg_match('/^\\s*Page size\\s*(\\d+)/m', $db_info, $regs);

- $page_size = intval($regs[1]);

- if ($page_size < 8192)

- {

- $error[] = phpbb::$user->lang['INST_ERR_DB_NO_FIREBIRD_PS'];

- }

- $sql = "SELECT *

- FROM RDB$FUNCTIONS

- WHERE RDB$SYSTEM_FLAG IS NULL

- AND RDB$FUNCTION_NAME = 'CHAR_LENGTH'";

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

- $db->sql_freeresult($result);

-

- // if its a UDF, its too old

- if ($row)

- else

- {

- $sql = "SELECT FIRST 0 char_length('')

- FROM RDB\$DATABASE";

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

- if (!$result) // This can only fail if char_length is not defined

- {

- $error[] = phpbb::$user->lang['INST_ERR_DB_NO_FIREBIRD'];

- }

- $db->sql_freeresult($result);

- }

- // Setup the stuff for our random table

- $char_array = array_merge(range('A', 'Z'), range('0', '9'));

- $char_len = mt_rand(7, 9);

- $char_array_len = sizeof($char_array) - 1;

- $final = '';

- for ($i = 0; $i < $char_len; $i++)

- {

- $final .= $char_array[mt_rand(0, $char_array_len)];

- }

- // Create some random table

- $sql = 'CREATE TABLE ' . $final . " (

- FIELD1 VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,

- FIELD2 INTEGER DEFAULT 0 NOT NULL);";

- $db->sql_query($sql);

- // Create an index that should fail if the page size is less than 8192

- $sql = 'CREATE INDEX ' . $final . ' ON ' . $final . '(FIELD1, FIELD2);';

- $db->sql_query($sql);

- if (ibase_errmsg() !== false)

- {

- $error[] = phpbb::$user->lang['INST_ERR_DB_NO_FIREBIRD_PS'];

- }

- // Kill the old table

- $db->sql_query('DROP TABLE ' . $final . ';');

- unset($final);

- }

- break;

- case 'oracle':

- if ($unicode_check)

- {

- $sql = "SELECT *

- FROM NLS_DATABASE_PARAMETERS

- WHERE PARAMETER = 'NLS_RDBMS_VERSION'

- OR PARAMETER = 'NLS_CHARACTERSET'";

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

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

- {

- $stats[$row['parameter']] = $row['value'];

- }

- $db->sql_freeresult($result);

- if (version_compare($stats['NLS_RDBMS_VERSION'], '9.2', '<'))

- {

- $error[] = phpbb::$user->lang['INST_ERR_DB_NO_ORACLE'];

- }

- if ($stats['NLS_CHARACTERSET'] !== 'AL32UTF8')

- {

- $error[] = phpbb::$user->lang['INST_ERR_DB_NO_ORACLE_NLS'];

- }

- }

- break;

- case 'postgres':

- if ($unicode_check)

- {

- $sql = "SHOW server_encoding;";

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

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

- $db->sql_freeresult($result);

- if ($row['server_encoding'] !== 'UNICODE' && $row['server_encoding'] !== 'UTF8')

- {

- $error[] = phpbb::$user->lang['INST_ERR_DB_NO_POSTGRES'];

- }

- }

- break;

- }

- if ($error_connect && (!isset($error) || !sizeof($error)))

- return true;

- return false;

- // Generate the page

- if (defined('IN_ADMIN') && isset(phpbb::$user->data['session_admin']) && phpbb::$user->data['session_admin'])

- {

- adm_page_header($page_title);

- }

- else

- {

- page_header($page_title, $display_online_list);

- }

- if (defined('IN_ADMIN') && isset(phpbb::$user->data['session_admin']) && phpbb::$user->data['session_admin'])

- {

- adm_page_footer();

- }

- else

- {

- page_footer();

- }