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

*/

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;

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

/**

* 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

*/

}

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']),

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

}

return $config_data;

}

}

/**

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

}

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

}

}

{

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

*/

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

}

/**

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

}

/**

*

* @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')),

),

);

}

}

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