),

);

$schema_data['phpbb_moderator_cache'] = array(

'COLUMNS' => array(

'forum_id' => array('UINT', 0),

'pass_complex' => array('lang' => 'PASSWORD_TYPE', 'validate' => 'string', 'type' => 'select', 'method' => 'select_password_chars', 'explain' => true),

'chg_passforce' => array('lang' => 'FORCE_PASS_CHANGE', 'validate' => 'int:0', 'type' => 'text:3:3', 'explain' => true, 'append' => ' ' . $user->lang['DAYS']),

'max_login_attempts' => array('lang' => 'MAX_LOGIN_ATTEMPTS', 'validate' => 'int:0', 'type' => 'text:3:3', 'explain' => true),

'tpl_allow_php' => array('lang' => 'TPL_ALLOW_PHP', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true),

'form_token_lifetime' => array('lang' => 'FORM_TIME_MAX', 'validate' => 'int:-1', 'type' => 'text:5:5', 'explain' => true, 'append' => ' ' . $user->lang['SECONDS']),

'form_token_sid_guests' => array('lang' => 'FORM_SID_GUESTS', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true),

$method = 'login_' . $method;

if (function_exists($method))

{

// If the auth module wants us to create an empty profile do so and then treat the status as LOGIN_SUCCESS

if ($login['status'] == LOGIN_SUCCESS_CREATE_PROFILE)

/**

* Login function

*/

{

global $db, $config;

);

}

$sql = 'SELECT user_id, username, user_password, user_passchg, user_pass_convert, user_email, user_type, user_login_attempts

FROM ' . USERS_TABLE . "

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

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

$db->sql_freeresult($result);

if (!$row)

{

return array(

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

);

}

// If there are too much login attempts, we need to check for an confirm image

// Every auth module is able to define what to do by itself...

{

$captcha->reset();

}

}

// If the password convert flag is set we need to convert it

$row['user_password'] = $hash;

}

if ($row['user_login_attempts'] != 0)

{

// Successful, reset login attempts (the user passed all stages)

define('ICONS_TABLE', $table_prefix . 'icons');

define('LANG_TABLE', $table_prefix . 'lang');

define('LOG_TABLE', $table_prefix . 'log');

define('MODERATOR_CACHE_TABLE', $table_prefix . 'moderator_cache');

define('MODULES_TABLE', $table_prefix . 'modules');

define('POLL_OPTIONS_TABLE', $table_prefix . 'poll_options');

$sqlite = true;

}

// Change columns?

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

{

include($phpbb_root_path . "includes/captcha/captcha_factory." . $phpEx);

}

phpbb_captcha_factory::garbage_collect($config['captcha_plugin']);

}

return;

'3.0.7-PL1' => array(),

// No changes from 3.0.8-RC1 to 3.0.8

'3.0.8-RC1' => array(),

// Changes from 3.0.8 to 3.0.9-RC1

'3.0.8' => array(

'change_columns' => array(

BBCODES_TABLE => array(

'bbcode_id' => array('USINT', 0),

// Changes from 3.0.8 to 3.0.9-RC1

case '3.0.8':

// Update file extension group names to use language strings, again.

$sql = 'SELECT group_id, group_name

FROM ' . EXTENSION_GROUPS_TABLE . '

$sqlite = true;

}

// Change columns?

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

{

#

#

END;;

# Table: 'phpbb_moderator_cache'

CREATE TABLE phpbb_moderator_cache (

forum_id INTEGER DEFAULT 0 NOT NULL,

/*

*/

/*

Table: 'phpbb_moderator_cache'

*/

CREATE TABLE [phpbb_moderator_cache] (

) ON [PRIMARY]

GO

#

#

# Table: 'phpbb_attachments'

);

# Table: 'phpbb_moderator_cache'

CREATE TABLE phpbb_moderator_cache (

forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

#

#

# Table: 'phpbb_attachments'

) CHARACTER SET `utf8` COLLATE `utf8_bin`;

# Table: 'phpbb_moderator_cache'

CREATE TABLE phpbb_moderator_cache (

forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

/*

*/

/*

Table: 'phpbb_moderator_cache'

*/

CREATE TABLE phpbb_moderator_cache (

/*

*/

CREATE INDEX phpbb_log_user_id ON phpbb_log (user_id);

/*

Table: 'phpbb_moderator_cache'

*/

CREATE TABLE phpbb_moderator_cache (

INSERT INTO phpbb_config (config_name, config_value) VALUES ('img_max_width', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('img_min_thumb_filesize', '12000');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('ip_check', '3');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('jab_enable', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('jab_host', '');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('jab_password', '');

#

#

BEGIN TRANSACTION;

CREATE INDEX phpbb_log_reportee_id ON phpbb_log (reportee_id);

CREATE INDEX phpbb_log_user_id ON phpbb_log (user_id);

# Table: 'phpbb_moderator_cache'

CREATE TABLE phpbb_moderator_cache (

forum_id INTEGER UNSIGNED NOT NULL DEFAULT '0',

'FORM_TIME_MAX_EXPLAIN' => 'The time a user has to submit a form. Use -1 to disable. Note that a form might become invalid if the session expires, regardless of this setting.',

'FORM_SID_GUESTS' => 'Tie forms to guest sessions',

'FORM_SID_GUESTS_EXPLAIN' => 'If enabled, the form token issued to guests will be session-exclusive. This can cause problems with some ISPs.',

'FORWARDED_FOR_VALID_EXPLAIN' => 'Sessions will only be continued if the sent <var>X_FORWARDED_FOR</var> header equals the one sent with the previous request. Bans will be checked against IPs in <var>X_FORWARDED_FOR</var> too.',

'IP_VALID' => 'Session IP validation',

'IP_VALID_EXPLAIN' => 'Determines how much of the users IP is used to validate a session; <samp>All</samp> compares the complete address, <samp>A.B.C</samp> the first x.x.x, <samp>A.B</samp> the first x.x, <samp>None</samp> disables checking. On IPv6 addresses <samp>A.B.C</samp> compares the first 4 blocks and <samp>A.B</samp> the first 3 blocks.',

'NO_IP_VALIDATION' => 'None',

'NO_REF_VALIDATION' => 'None',

'PASSWORD_TYPE' => 'Password complexity',