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

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

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

'allow_quick_reply' => array('lang' => 'ALLOW_QUICK_REPLY', 'validate' => 'bool', 'type' => 'custom', 'method' => 'quick_reply', 'explain' => true),

'legend2' => 'ACP_LOAD_SETTINGS',

'load_cpf_pm' => array('lang' => 'LOAD_CPF_PM', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => false),

'load_cpf_viewprofile' => array('lang' => 'LOAD_CPF_VIEWPROFILE', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => false),

'load_cpf_viewtopic' => array('lang' => 'LOAD_CPF_VIEWTOPIC', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => false),

'legend3' => 'ACP_SUBMIT_CHANGES',

)

'load_moderators' => array('lang' => 'YES_MODERATORS', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => false),

'load_jumpbox' => array('lang' => 'YES_JUMPBOX', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => false),

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

'legend3' => 'CUSTOM_PROFILE_FIELDS',

'load_cpf_memberlist' => array('lang' => 'LOAD_CPF_MEMBERLIST', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => false),

*/

class acp_database

{

var $u_action;

function main($id, $mode)

global $cache, $db, $user, $auth, $template, $table_prefix;

global $config, $phpbb_root_path, $phpbb_admin_path, $phpEx;

$user->add_lang('acp/database');

$this->tpl_name = 'acp_database';

{

case 'download':

$type = request_var('type', '');

$format = request_var('method', '');

$where = request_var('where', '');

break;

default:

asort($tables);

foreach ($tables as $table_name)

{

// No maximum post id? :o

if (!$max_post_id)

{

FROM ' . POSTS_TABLE;

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

$max_post_id = (int) $db->sql_fetchfield('max_post_id');

class acp_styles

{

public $u_action;

protected $u_base_action;

protected $s_hidden_fields;

protected $mode;

*/

protected function read_style_cfg($dir)

{

$cfg = parse_cfg_file($this->styles_path . $dir . '/style.cfg');

// Check if it is a valid file

$user_row['posts_in_queue'] = (int) $db->sql_fetchfield('posts_in_queue');

$db->sql_freeresult($result);

$template->assign_vars(array(

'L_NAME_CHARS_EXPLAIN' => $user->lang($config['allow_name_chars'] . '_EXPLAIN', $user->lang('CHARACTERS', (int) $config['min_name_chars']), $user->lang('CHARACTERS', (int) $config['max_name_chars'])),

'L_CHANGE_PASSWORD_EXPLAIN' => $user->lang($config['pass_complex'] . '_EXPLAIN', $user->lang('CHARACTERS', (int) $config['min_pass_chars']), $user->lang('CHARACTERS', (int) $config['max_pass_chars'])),

'USER_EMAIL' => $user_row['user_email'],

'USER_WARNINGS' => $user_row['user_warnings'],

'USER_POSTS' => $user_row['user_posts'],

'USER_INACTIVE_REASON' => $inactive_reason,

));

{

if (!@ldap_bind($ldap, htmlspecialchars_decode($config['ldap_user']), htmlspecialchars_decode($config['ldap_password'])))

{

}

}

if (empty($this->template_filename))

{

$style_resource_locator = new phpbb_style_resource_locator();

$style_path_provider = new phpbb_style_extension_path_provider($phpbb_extension_manager, new phpbb_style_path_provider());

$style = new phpbb_style($phpbb_root_path, $phpEx, $config, $user, $style_resource_locator, $style_path_provider, $template);

$style->set_style();

$template->set_filenames(array('bbcode.html' => 'bbcode.html'));

/**

* Obtain cfg file data

*/

{

global $config, $phpbb_root_path;

{

}

}

/**

$column_type = $this->dbms_type_map[$this->sql_layer][$column_data[0]];

}

if (is_array($column_data[1]))

{

$column_data[1] = (isset($column_data[1][$this->sql_layer])) ? $column_data[1][$this->sql_layer] : $column_data[1]['default'];

}

/**

* Fetch field

* if rownum is false, the current row is used, else it is pointing to the row (zero-based)

*/

}

/**

* Run more than one insert statement.

*

* @param string $table table name to run the statements on

}

/**

* Get last inserted id after insert statement

*/

function sql_nextid()

}

/**

* Build LIKE expression

* @access private

*/

}

/**

* Get last inserted id after insert statement

*/

function sql_nextid()

}

/**

* Build LIKE expression

* @access private

*/

}

/**

* Get last inserted id after insert statement

*/

function sql_nextid()

}

/**

* Build LIKE expression

* @access private

*/

/**

*

*

* Portable PHP password hashing framework.

*

}

else

{

WHERE t.forum_id = ' . $forum_id . '

AND t.topic_last_post_time > ' . $mark_time_forum . '

AND t.topic_moved_id = 0 ' .

$sql_update_unapproved . '

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

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

$db->sql_freeresult($result);

case 'email':

// Regex written by James Watts and Francisco Jose Martin Moreno

// http://fightingforalostcause.net/misc/2006/compare-email-regex.php

break;

case 'bbcode_htm':

'T_ASSETS_VERSION' => $config['assets_version'],

'T_ASSETS_PATH' => "{$web_path}assets",

'T_IMAGES_PATH' => "{$web_path}images/",

'T_SMILIES_PATH' => "{$web_path}{$config['smilies_path']}/",

'T_AVATAR_PATH' => "{$web_path}{$config['avatar_path']}/",

'T_ICONS_PATH' => "{$web_path}{$config['icons_path']}/",

'T_RANKS_PATH' => "{$web_path}{$config['ranks_path']}/",

'T_UPLOAD_PATH' => "{$web_path}{$config['upload_path']}/",

'T_JQUERY_LINK' => ($config['load_jquery_cdn'] && !empty($config['load_jquery_url'])) ? $config['load_jquery_url'] : "{$web_path}assets/javascript/jquery.js?assets_version=" . $config['assets_version'],

'S_JQUERY_FALLBACK' => ($config['load_jquery_cdn']) ? true : false,

'T_THEME_LANG_NAME' => $user->data['user_lang'],

'T_IMAGES' => 'images',

'T_SMILIES' => $config['smilies_path'],

'T_AVATAR' => $config['avatar_path'],

}

return $utf8_pcre_properties;

}

{

$sql_keywords .= $db->sql_in_set('l.log_operation', $operations) . ' OR ';

}

}

if ($log_count !== false)

if ($row['forum_last_post_id'])

{

$last_post_subject = $row['forum_last_post_subject'];

$last_post_time = $user->format_date($row['forum_last_post_time']);

$last_post_url = append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $row['forum_id_last_post'] . '&p=' . $row['forum_last_post_id']) . '#p' . $row['forum_last_post_id'];

}

else

{

}

// Output moderator listing ... if applicable

'S_LOCKED_FORUM' => ($row['forum_status'] == ITEM_LOCKED) ? true : false,

'S_LIST_SUBFORUMS' => ($row['display_subforum_list']) ? true : false,

'S_SUBFORUMS' => (sizeof($subforums_list)) ? true : false,

'S_FEED_ENABLED' => ($config['feed_forum'] && !phpbb_optionget(FORUM_OPTION_FEED_EXCLUDE, $row['forum_options']) && $row['forum_type'] == FORUM_POST) ? true : false,

'FORUM_ID' => $row['forum_id'],

'FORUM_FOLDER_IMG_ALT' => isset($user->lang[$folder_alt]) ? $user->lang[$folder_alt] : '',

'FORUM_IMAGE' => ($row['forum_image']) ? '<img src="' . $phpbb_root_path . $row['forum_image'] . '" alt="' . $user->lang[$folder_alt] . '" />' : '',

'FORUM_IMAGE_SRC' => ($row['forum_image']) ? $phpbb_root_path . $row['forum_image'] : '',

'LAST_POST_TIME' => $last_post_time,

'LAST_POSTER' => get_username_string('username', $row['forum_last_poster_id'], $row['forum_last_poster_name'], $row['forum_last_poster_colour']),

'LAST_POSTER_COLOUR' => get_username_string('colour', $row['forum_last_poster_id'], $row['forum_last_poster_name'], $row['forum_last_poster_colour']),

}

}

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

{

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

$config_data = "<?php\n";

$config_data_array = array(

'dbms' => $dbms,

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

}

return $config_data;

}

{

$style_resource_locator = new phpbb_style_resource_locator();

$style_path_provider = new phpbb_style_extension_path_provider($phpbb_extension_manager, new phpbb_style_path_provider());

$style = new phpbb_style($phpbb_root_path, $phpEx, $config, $user, $style_resource_locator, $style_path_provider, $tpl);

$this->tpl_msg[$template_lang . $template_file] = $tpl;

$fallback_template_path = false;

// First of all make sure the subject and topic title are having the correct length.

// To achieve this without cutting off between special chars we convert to an array and then count the elements.

// Collect some basic information about which tables and which rows to update/insert

$sql_data = $topic_row = array();

}

/**

* Rebuild message header

*/

function rebuild_header($check_ary)

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

{

$field = ($data['address_list']['g'][$row['group_id']] == 'to') ? 'to' : 'bcc';

$recipients[$row['user_id']] = $field;

}

*/

function is_image()

{

}

/**

}

/**

*/

function get_mimetype($filename)

{

// Some browsers choke on a mimetype of application/octet-stream

if (!$mimetype || $mimetype == 'application/octet-stream')

// Remove temporary filename

@unlink($this->filename);

if (sizeof($this->error))

{

$filename = $url['path'];

$filesize = 0;

$errno = 0;

$errstr = '';

$block = @fread($fsock, 1024);

$filesize += strlen($block);

{

$file = new fileerror(sprintf($user->lang[$this->error_prefix . 'WRONG_FILESIZE'], $max_filesize['value'], $max_filesize['unit']));

return $file;

{

$length = (int) str_replace('content-length: ', '', strtolower($line));

{

$file = new fileerror(sprintf($user->lang[$this->error_prefix . 'WRONG_FILESIZE'], $max_filesize['value'], $max_filesize['unit']));

return $file;

WHERE session_user_id = ' . $user_id;

$db->sql_query($sql);

{

}

$db->sql_transaction('commit');

trigger_error('NOT_MODERATOR');

}

$sql = 'SELECT SUM(forum_topics) as sum_forum_topics

FROM ' . FORUMS_TABLE . '

WHERE ' . $db->sql_in_set('forum_id', $forum_list);

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

}

$avatar_img = get_user_avatar($user_row['user_avatar'], $user_row['user_avatar_type'], $user_row['user_avatar_width'], $user_row['user_avatar_height']);

$template->assign_vars(array(

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

}

$avatar_img = get_user_avatar($user_row['user_avatar'], $user_row['user_avatar_type'], $user_row['user_avatar_width'], $user_row['user_avatar_height']);

// OK, they didn't submit a warning so lets build the page for them to do so

var $split_words = array();

var $search_query;

var $common_words = array();

public function __construct(&$error)

{

$this->word_length = array('min' => $config['fulltext_mysql_min_word_len'], 'max' => $config['fulltext_mysql_max_word_len']);

$error = false;

}

if ($db->sql_layer != 'mysql4' && $db->sql_layer != 'mysqli')

{

}

$result = $db->sql_query('SHOW TABLE STATUS LIKE \'' . POSTS_TABLE . '\'');

$split_keywords = preg_replace("#[\n\r\t]+#", ' ', trim(htmlspecialchars_decode($keywords)));

// Split words

// We limit the number of allowed keywords to minimize load on the database

if ($config['max_num_search_keywords'] && sizeof($this->split_words) > $config['max_num_search_keywords'])

global $config;

// Split words

// remove too short or too long words

$text = array_values($text);

{

if ($db->sql_layer == 'mysqli' || version_compare($db->sql_server_info(true), '4.1.3', '>='))

{

}

else

{

$tpl = '

<dl>

<dt><label>' . $user->lang['MIN_SEARCH_CHARS'] . ':</label><br /><span>' . $user->lang['FULLTEXT_MYSQL_MIN_SEARCH_CHARS_EXPLAIN'] . '</span></dt>

<dd>' . $config['fulltext_mysql_min_word_len'] . '</dd>

</dl>

}

}

{

$sql = 'SELECT u.*, s.*

FROM ' . SESSIONS_TABLE . ' s, ' . USERS_TABLE . " u

// Autoloading of dependencies.

// Three options are supported:

// 1. If dependencies are installed with Composer, Composer will create a

// automatically used by phpBB. This is the default mode that phpBB

// will use when shipped.

// 2. To disable composer autoloading, PHPBB_NO_COMPOSER_AUTOLOAD can be specified.

}

else

{

{

trigger_error('You have not set up composer dependencies. See http://getcomposer.org/.', E_USER_ERROR);

}

}

$starttime = explode(' ', microtime());

*

* @package phpBB3

*/

{

/**

* Paths to style directories.

class phpbb_style

{

/**

* Handles everything related to templates.

*/

private $template;

/**

*/

private $phpbb_root_path;

/**

*/

private $phpEx;

/**

*/

private $config;

/**

*/

private $user;

* @param user $user current user

* @param phpbb_style_resource_locator $locator style resource locator

* @param phpbb_style_path_provider $provider style path provider

*/

{

$this->phpbb_root_path = $phpbb_root_path;

$this->phpEx = $phpEx;

*/

public function set_style()

{

foreach ($style_dirs as $dir)

{

$paths[] = $this->get_style_path($dir);

// Add 'all' path, used as last fallback path by hooks and extensions

$paths[] = $this->get_style_path('all');

}

/**

$this->template->cachepath = $this->phpbb_root_path . 'cache/tpl_' . str_replace('_', '-', $name) . '_';

if ($template_path !== false)

{

exit;

}

/**

* Extension of template class - Functions needed for compiling templates only.

* @package phpBB3

* @uses template_filter As a PHP stream filter to perform compilation of templates

*/

{

/**

* Array of parameters to forward to template filter

*

* @package phpBB3

*/

{

/**

* variable that holds all the data we'll be substituting into

* Returns a reference to template data array.

*

* This function is public so that template renderer may invoke it.

*

* Note: modifying returned array will affect data stored in the context.

*

* @see template_compile

* @package phpBB3

*/

{

const REGEX_NS = '[a-z_][a-z_0-9]+';

if (substr($filename, 0, strlen($this->phpbb_root_path)) != $this->phpbb_root_path)

{

// Absolute path, include as is

}

// Relative path, remove root path from it

$filename = substr($filename, strlen($this->phpbb_root_path));

}

/**

*

* @package phpBB3

*/

{

/**

* Displays the template managed by this renderer.

*

* @param array $lang Language entries to use

*/

public function render($context, $lang);

*

* @package phpBB3

*/

{

/**

* Template code to be eval'ed.

* Template includes are delegated to template object $template.

*

* @param string $code php code of the template

*/

public function __construct($code, $template)

{

* Displays the template managed by this renderer by eval'ing php code

* of the template.

*

* @param array $lang Language entries to use

*/

public function render($context, $lang)

*

* @package phpBB3

*/

{

/**

* Template path to be included.

* Displays the template managed by this renderer by including

* the php file containing the template.

*

* @param array $lang Language entries to use

*/

public function render($context, $lang)

* Base Template class.

* @package phpBB3

*/

{

/**

* Stores template data used during template rendering.

*/

public $context;

/**

*/

public $cachepath = '';

/**

*/

private $phpbb_root_path;

/**

*/

private $phpEx;

/**

*/

private $config;

/**

*/

private $user;

/**

*/

private $locator;

/**

* Location of templates directory within style directories

* @var string

*/

*

* @param string $phpbb_root_path phpBB root path

* @param user $user current user

*/

{

$this->phpbb_root_path = $phpbb_root_path;

$this->phpEx = $phpEx;

$this->user = $user;

$this->locator = $locator;

$this->template_path = $this->locator->template_path;

}

/**

* configuration setting may be used to force templates to be always

* recompiled.

*

* if template loading or compilation failed. Call render() on the

* renderer to display the template. This will result in template

* contents sent to the output stream (unless, of course, output

* buffering is in effect).

*

* @param string $handle Handle of the template to load

*/

private function _tpl_load($handle)

{

// Recompile page if the original template is newer, otherwise load the compiled version

if (!$recompile)

{

}

if ($compile->compile_file_to_file($source_file, $output_file) !== false)

{

}

else if (($code = $compile->compile_file($source_file)) !== false)

{

}

else

{

$this->context->append_var($varname, $varval);

}

/**

* Assign key variable pairs from an array to a specified block

* @param string $blockname Name of block to assign $vararray to

return $this->context->assign_block_vars($blockname, $vararray);

}

/**

* Change already assigned key variable pair (one-dimensional - single loop entry)

*

*

* @param string $file file name

* @param bool $locate True if file needs to be located

*/

{

// Locate file

if ($locate)

{

$file = $this->locator->get_first_file_location(array($file), true, true);

}

$file .= (strpos($file, '?') === false) ? '?' : '&';

$file .= 'assets_version=' . $this->config['assets_version'];

'signature' => array('title' => 'UCP_PROFILE_SIGNATURE', 'auth' => '', 'cat' => array('UCP_PROFILE')),

'avatar' => array('title' => 'UCP_PROFILE_AVATAR', 'auth' => 'cfg_allow_avatar && (cfg_allow_avatar_local || cfg_allow_avatar_remote || cfg_allow_avatar_upload || cfg_allow_avatar_remote_upload)', 'cat' => array('UCP_PROFILE')),

'reg_details' => array('title' => 'UCP_PROFILE_REG_DETAILS', 'auth' => '', 'cat' => array('UCP_PROFILE')),

),

);

}

trigger_error('RULE_ALREADY_DEFINED');

}

$sql = 'INSERT INTO ' . PRIVMSGS_RULES_TABLE . ' ' . $db->sql_build_array('INSERT', $rule_ary);

$db->sql_query($sql);

$sql = 'UPDATE ' . USERS_TABLE . '

SET user_message_rules = 1

WHERE user_id = ' . $user->data['user_id'];

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

$db->sql_freeresult($result);

if (!$row)

{

$sql = 'UPDATE ' . USERS_TABLE . '

}

break;

}

$template->assign_vars(array(

{

var $lang = array();

var $help = array();

var $date_format;

var $timezone;

var $dst;

FROM ' . STYLES_TABLE . " s

WHERE s.style_id = $style_id";

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

$db->sql_freeresult($result);

// User has wrong style

{

$style_id = $this->data['user_style'] = $config['default_style'];

FROM ' . STYLES_TABLE . " s

WHERE s.style_id = $style_id";

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

$db->sql_freeresult($result);

}

{

trigger_error('Could not get style data', E_USER_ERROR);

}

// Now parse the cfg file and cache it

$check_for = array(

'pagination_sep' => (string) ', '

foreach ($check_for as $key => $default_value)

{

if (is_string($default_value))

{

}

}

* UTF8-safe basename() function

*

* basename() has some limitations and is dependent on the locale setting

* basename function.

*

* @param string $filename The filename basename() should be applied to