before_script:

- sh -c "if [ '$DB' = 'postgres' ]; then psql -c 'DROP DATABASE IF EXISTS phpbb_tests;' -U postgres; fi"

- sh -c "if [ '$DB' = 'postgres' ]; then psql -c 'create database phpbb_tests;' -U postgres; fi"

- sh -c "if [ '$DB' = 'mysql' -o '$DB' = 'mariadb' ]; then mysql -e 'create database IF NOT EXISTS phpbb_tests;'; fi"

script:

command="git archive ${revision} composer.phar | tar -xf - -C ${dir}"

checkreturn="true" />

<exec dir="${dir}"

checkreturn="true"

passthru="true" />

<delete file="${dir}/composer.phar" />

</dl>

<!-- ENDIF -->

<dl>

</dl>

</fieldset>

define('IN_PHPBB', true);

require(dirname(__FILE__) . '/../phpbb/db/tools.php');

$dbms_type_map = phpbb\db\tools::get_dbms_type_map();

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;

'SWITCH_COLUMN_MANUALLY' => (!$found_switch) ? true : false,

));

$template->set_filenames(array(

'body' => 'faq_body.html')

}

else

{

}

$template->set_filenames(array(

'PASSWORD_CREDENTIAL' => ($admin) ? 'password_' . $credential : 'password',

));

$template->set_filenames(array(

'body' => 'login_body.html')

$template->assign_var('LOGIN_ERROR', $user->lang['WRONG_PASSWORD']);

}

$template->assign_vars(array(

'FORUM_NAME' => isset($forum_data['forum_name']) ? $forum_data['forum_name'] : '',

}

else

{

}

}

/**

* Generate page header

*/

{

global $db, $config, $template, $SID, $_SID, $_EXTRA_URL, $user, $auth, $phpEx, $phpbb_root_path;

global $phpbb_dispatcher, $request, $phpbb_container, $phpbb_admin_path;

'U_SEARCH_UNREAD' => append_sid("{$phpbb_root_path}search.$phpEx", 'search_id=unreadposts'),

'U_SEARCH_ACTIVE_TOPICS'=> append_sid("{$phpbb_root_path}search.$phpEx", 'search_id=active_topics'),

'U_DELETE_COOKIES' => append_sid("{$phpbb_root_path}ucp.$phpEx", 'mode=delete_cookies'),

'U_TERMS_USE' => append_sid("{$phpbb_root_path}ucp.$phpEx", 'mode=terms'),

'U_PRIVACY' => append_sid("{$phpbb_root_path}ucp.$phpEx", 'mode=privacy'),

'U_RESTORE_PERMISSIONS' => ($user->data['user_perm_from'] && $auth->acl_get('a_switchperm')) ? append_sid("{$phpbb_root_path}ucp.$phpEx", 'mode=restore_perm') : '',

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

/**

* Display module

*/

{

global $template, $user;

extract($phpbb_dispatcher->trigger_event('core.index_modify_page_title', compact($vars)));

// Output page

$template->set_filenames(array(

'body' => 'index_body.html')

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

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

break;

case 'textarea':

'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

CREATE TABLE [phpbb_config_text] (

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

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

ALTER TABLE [phpbb_config_text] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_config_text] PRIMARY KEY CLUSTERED

(

[config_name]

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

CREATE TABLE [phpbb_ext] (

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

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

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 (0) 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

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

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

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

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

ALTER TABLE [phpbb_migrations] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_migrations] PRIMARY KEY CLUSTERED

(

[migration_name]

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

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

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

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

ALTER TABLE [phpbb_notification_types] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_notification_types] PRIMARY KEY CLUSTERED

(

[notification_type_id]

GO

GO

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

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

[notification_data] [varchar] (4000) DEFAULT ('') NOT NULL

ALTER TABLE [phpbb_notifications] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_notifications] PRIMARY KEY CLUSTERED

(

[notification_id]

GO

GO

GO

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

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

[oauth_provider_id] [varchar] (4000) DEFAULT ('') NOT NULL

ALTER TABLE [phpbb_oauth_accounts] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_oauth_accounts] PRIMARY KEY CLUSTERED

(

[user_id],

[provider]

GO

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

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

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

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_delete_time] [int] DEFAULT (0) NOT NULL ,

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

[post_delete_user] [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_is_contact] [int] DEFAULT (0) NOT NULL ,

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

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

ALTER TABLE [phpbb_profile_fields] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_profile_fields] PRIMARY KEY CLUSTERED

(

[field_id]

GO

GO

GO

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

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

[pf_phpbb_website] [varchar] (255) DEFAULT ('') 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] [varchar] (100) DEFAULT ('') 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

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

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

[reported_post_enable_bbcode] [int] DEFAULT (1) 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

[bbcode_bitfield] [varchar] (255) DEFAULT ('kNg=') NOT NULL ,

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

[style_parent_tree] [varchar] (8000) DEFAULT ('') NOT NULL

ALTER TABLE [phpbb_styles] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_styles] PRIMARY KEY CLUSTERED

(

[style_id]

GO

GO

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

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

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

ALTER TABLE [phpbb_teampage] WITH NOCHECK ADD

CONSTRAINT [PK_phpbb_teampage] PRIMARY KEY CLUSTERED

(

[teampage_id]

GO

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

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

[topic_delete_user] [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

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

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

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

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

'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.',

));

'ACP_BAN' => 'Banning',

'ACP_BAN_EMAILS' => 'Ban emails',

'ACP_BAN_IPS' => 'Ban IPs',

'ACP_BBCODES' => 'BBCodes',

'ACP_BOARD_CONFIGURATION' => 'Board configuration',

'ACP_BOARD_FEATURES' => 'Board features',

'GZIP_COMPRESSION' => 'GZip compression',

'NOT_AVAILABLE' => 'Not available',

'NUMBER_FILES' => 'Number of attachments',

'NUMBER_POSTS' => 'Number of posts',

'HOMEPAGE' => 'Homepage',

'PATH' => 'File Path',

'TIME' => 'Release Time',

'REQUIREMENTS' => 'Requirements',

'PHPBB_VERSION' => 'phpBB Version',

1 => '%d user',

2 => '%d users',

),

'LOGIN_EXPLAIN_MEMBERLIST' => 'The board requires you to be registered and logged in to access the memberlist.',

'LOGIN_EXPLAIN_SEARCHUSER' => 'The board requires you to be registered and logged in to search users.',

'LOGIN_EXPLAIN_VIEWPROFILE' => 'The board requires you to be registered and logged in to view profiles.',

'POST_APPROVAL_NOTIFY' => 'You will be notified when your post has been approved.',

'POST_CONFIRMATION' => 'Confirmation of post',

'POST_CONFIRM_EXPLAIN' => 'To prevent automated posts the board requires you to enter a confirmation code. The code is displayed in the image you should see below. If you are visually impaired or cannot otherwise read this code please contact the %sBoard Administrator%s.',

'POST_GLOBAL' => 'Global',

'POST_ICON' => 'Post icon',

'POST_NORMAL' => 'Normal',

));

// Generate the page, do not display/query online list

/**

* Functions used to generate additional URL paramters

$group_id = request_var('g', 0);

$topic_id = request_var('t', 0);

// Check our mode...

{

trigger_error('NO_MODE');

}

// What do you want to do today? ... oops, I think that line is taken ...

switch ($mode)

{

// Display a listing of board admins, moderators

include($phpbb_root_path . 'includes/functions_user.' . $phpEx);

$page_title = $user->lang['THE_TEAM'];

$sql = 'SELECT *

FROM ' . TEAMPAGE_TABLE . '

}

// Output the page

$template->set_filenames(array(

'body' => $template_html)

var $extension = 'apc';

/**

*/

function purge()

{

{

/**

* Load global cache

*/

public function load();

/**

* Unload cache object

*/

public function unload();

/**

* Save modified objects

*/

public function save();

/**

* Tidy cache

*/

public function tidy();

/**

* Get saved cache object

*/

public function get($var_name);

/**

* Put data into cache

*/

public function put($var_name, $var, $ttl = 0);

/**

* Purge cache data

*/

public function purge();

/**

* Destroy cache data

*/

public function destroy($var_name, $table = '');

/**

* Check if a given cache entry exists

*/

public function _exists($var_name);

var $serialize_header = '#phpbb-serialized#';

/**

*/

function purge()

{

}

/**

function tidy()

{

eaccelerator_gc();

}

/**

*/

function load()

{

}

/**

*/

function unload()

{

}

/**

*/

function save()

{

}

/**

*/

function tidy()

{

}

/**

*/

function get($var_name)

{

}

/**

*/

function put($var_name, $var, $ttl = 31536000)

{

}

/**

*/

function purge()

{

}

/**

*/

function destroy($var_name, $table = '')

{

}

/**

*/

function _exists($var_name)

{

}

/**

*/

function sql_load($query)

{

}

/**

*/

function sql_exists($query_id)

{

}

/**

*/

function sql_fetchrow($query_id)

{

}

/**

*/

function sql_fetchfield($query_id, $field)

{

}

/**

*/

function sql_rowseek($rownum, $query_id)

{

}

/**

*/

function sql_freeresult($query_id)

{

/**

* Removes/unlinks file

*/

function remove_file($filename, $check = false)

{

}

/**

*/

function unload()

{

}

/**

*/

function purge()

{

}

/**

*/

function load()

{

}

/**

*/

function unload()

{

}

/**

*/

function save()

{

}

/**

*/

function tidy()

{

}

/**

*/

function get($var_name)

{

}

/**

*/

function put($var_name, $var, $ttl = 2592000)

{

}

/**

*/

function purge()

{

/**

*/

function destroy($var_name, $table = '')

{

}

/**

*/

function _exists($var_name)

{

}

/**

*/

function sql_load($query)

{

}

/**

*/

function sql_exists($query_id)

{

}

/**

*/

function sql_fetchrow($query_id)

{

}

/**

*/

function sql_fetchfield($query_id, $field)

{

}

/**

*/

function sql_rowseek($rownum, $query_id)

{

}

/**

*/

function sql_freeresult($query_id)

{

/**

* Removes/unlinks file

*/

function remove_file($filename, $check = false)

{

}

/**

*/

function load()

{

}

/**

*/

function unload()

{

}

/**

*/

function save()

{

}

/**

*/

function tidy()

{

}

/**

*/

function get($var_name)

{

}

/**

*/

function put($var_name, $var, $ttl = 0)

{

}

/**

*/

function purge()

{

}

/**

*/

function destroy($var_name, $table = '')

{

}

/**

*/

function _exists($var_name)

{

}

/**

*/

function sql_load($query)

{

}

/**

*/

function sql_exists($query_id)

{

}

/**

*/

function sql_fetchrow($query_id)

{

}

/**

*/

function sql_fetchfield($query_id, $field)

{

}

/**

*/

function sql_rowseek($rownum, $query_id)

{

}

/**

*/

function sql_freeresult($query_id)

{

}

/**

*/

function unload()

{

}

/**

*/

function purge()

{

var $extension = 'wincache';

/**

*/

function purge()

{

}

/**

*/

function purge()

{

*/

public function load_class($class)

{

if (substr($class, 0, strlen($this->namespace)) === $this->namespace)

{

$path = $this->resolve_path($class);

* @param int $status_code The status code to be sent to the page header

* @return Response object containing rendered page

*/

{

$this->template->set_filenames(array(

'body' => $template_file,

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

{

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

}

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;

$fields = array(

'name' => '#^[a-zA-Z0-9_\x7f-\xff]{2,}/[a-zA-Z0-9_\x7f-\xff]{2,}$#',

'type' => '#^phpbb-extension$#',

'version' => '#.+#',

);

'META_HOMEPAGE' => (isset($this->metadata['homepage'])) ? $this->metadata['homepage'] : '',

'META_VERSION' => (isset($this->metadata['version'])) ? htmlspecialchars($this->metadata['version']) : '',

'META_TIME' => (isset($this->metadata['time'])) ? htmlspecialchars($this->metadata['time']) : '',

'META_REQUIRE_PHP' => (isset($this->metadata['require']['php'])) ? htmlspecialchars($this->metadata['require']['php']) : '',

'META_REQUIRE_PHP_FAIL' => !$this->validate_require_php(),

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

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

{

}

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

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

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

{

}

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

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

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

{

}

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

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

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

{

}

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

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

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

{

}

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

posting_gen_attachment_entry($attachment_data, $filename_data, $allowed);

// Output page ...

$template->set_filenames(array(

'body' => 'posting_body.html')

($forum_style) ? $user->setup('posting', $forum_style) : $user->setup('posting');

$template->set_filenames(array(

'popup' => 'posting_progress_bar.html')

);

// Disable online list

$template->assign_vars(array(

'S_AGREEMENT' => true,

$module->assign_tpl_vars(append_sid("{$phpbb_root_path}ucp.$phpEx"));

// Generate the page, do not display/query online list

/**

* Function for assigning a template var if the zebra module got included

"description": "An example/sample extension to be used for testing purposes in phpBB Development.",

"version": "1.0.0",

"time": "2012-02-15 01:01:01",

"authors": [{

"name": "John Smith",

"username": "JohnSmith27",

"description": "An example/sample extension to be used for testing purposes in phpBB Development.",

"version": "1.0.0",

"time": "2012-02-15 01:01:01",

"authors": [{

"name": "John Smith",

"username": "JohnSmith27",

"description": "An example/sample extension to be used for testing purposes in phpBB Development.",

"version": "1.0.0",

"time": "2012-02-15 01:01:01",

"authors": [{

"name": "John Smith",

"email": "email@phpbb.com",

"description": "An example/sample extension to be used for testing purposes in phpBB Development.",

"version": "1.0.0",

"time": "2012-02-15 01:01:01",

"authors": [{

"name": "John Smith",

"email": "email@phpbb.com",

try

{

$this->fail('Exception not triggered');

}

catch(\phpbb\extension\exception $e)

{

}

try

$manager->set_metadata(array(

'name' => 'asdf',

'type' => 'asdf',

'version' => '',

));

try

{

$this->fail('Exception not triggered');

}

catch(\phpbb\extension\exception $e)

{

}

try

$manager->set_metadata(array(

'name' => 'test/foo',

'type' => 'phpbb-extension',

'version' => '1.0.0',

));

'DESCRIPTION' => 'An example/sample extension to be used for testing purposes in phpBB Development.',

'VERSION' => '1.0.0',

'TIME' => '2012-02-15 01:01:01',

'PHPBB_VERSION' => '3.1.*@dev',

'PHP_VERSION' => '>=5.3',

'AUTHOR_NAME' => 'John Smith',

"homepage": "",

"version": "1.0.0",

"time": "2013-03-21 01:01:01",

"authors": [{

"name": "Joas Schilling",

"email": "nickvergessen@phpbb.com",

protected function get_memberlist_leaders_table_crawler()

{

return $crawler->filter('.forumbg-table');

}

FROM ' . NOTIFICATIONS_TABLE . ' n, ' . NOTIFICATION_TYPES_TABLE . " nt

WHERE nt.notification_type_name = '" . $this->item_type . "'

AND n.notification_type_id = nt.notification_type_id

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

$this->assertEquals($expected_before, $this->db->sql_fetchrowset($result));

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

$post_data = array_merge($this->post_data, $additional_post_data);

submit_post('reply', '', 'poster-name', POST_NORMAL, $poll_data, $post_data, false, false);

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

$this->assertEquals($expected_after, $this->db->sql_fetchrowset($result));

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

$this->greaterThan(0))

->will($this->returnValueMap(array(

array(

'f_read',

1,

array(

$this->greaterThan(0))

->will($this->returnValueMap(array(

array(

'f_read',

1,

array(

$this->greaterThan(0))

->will($this->returnValueMap(array(

array(

'f_read',

1,

array(