if ($files_added)

{

}

}

}

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

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

$captcha_vars = array(

'captcha_gd_x_grid' => 'CAPTCHA_GD_X_GRID',

'captcha_gd_y_grid' => 'CAPTCHA_GD_Y_GRID',

'captcha_gd_foreground_noise' => 'CAPTCHA_GD_FOREGROUND_NOISE',

);

if (isset($_GET['demo']))

{

$captcha_vars = array_keys($captcha_vars);

foreach ($captcha_vars as $captcha_var)

{

$config[$captcha_var] = (isset($_REQUEST[$captcha_var])) ? request_var($captcha_var, 0) : $config[$captcha_var];

}

if ($config['captcha_gd'])

{

include($phpbb_root_path . 'includes/captcha/captcha_gd.' . $phpEx);

{

include($phpbb_root_path . 'includes/captcha/captcha_non_gd.' . $phpEx);

}

$captcha = new captcha();

exit;

}

$config_vars = array(

'enable_confirm' => 'REG_ENABLE',

'enable_post_confirm' => 'POST_ENABLE',

'captcha_gd' => 'CAPTCHA_GD',

);

if ($submit && check_form_key($form_key))

{

$config_vars = array_keys($config_vars);

foreach ($config_vars as $config_var)

{

set_config($config_var, request_var($config_var, ''));

}

$captcha_vars = array_keys($captcha_vars);

foreach ($captcha_vars as $captcha_var)

{

$value = request_var($captcha_var, 0);

set_config($captcha_var, $value);

}

}

trigger_error($user->lang['CONFIG_UPDATED'] . adm_back_link($this->u_action));

}

else if ($submit)

{

}

else

{

$preview_image_src = append_sid(append_sid("{$phpbb_admin_path}index.$phpEx", "i=$id&demo=demo"));

if (@extension_loaded('gd'))

{

$template->assign_var('GD', true);

}

foreach ($config_vars as $config_var => $template_var)

{

$template->assign_var($template_var, (isset($_REQUEST[$config_var])) ? request_var($config_var, '') : $config[$config_var]) ;

}

foreach ($captcha_vars as $captcha_var => $template_var)

{

$var = (isset($_REQUEST[$captcha_var])) ? request_var($captcha_var, 0) : $config[$captcha_var];

$template->assign_var($template_var, $var);

$preview_image_src .= "&$captcha_var=" . $var;

}

$template->assign_vars(array(

'CAPTCHA_PREVIEW' => $preview_image_src,

'PREVIEW' => isset($_POST['preview']),

));

}

}

}

{

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

}

@set_time_limit(1200);

$time = time();

$template->assign_vars(array(

'U_ACTION' => $this->u_action . '&action=download'

));

$available_methods = array('gzip' => 'zlib', 'bzip2' => 'bz2');

foreach ($available_methods as $type => $module)

$dir = $phpbb_root_path . 'store/';

$dh = @opendir($dir);

if ($dh)

{

while (($file = readdir($dh)) !== false)

{

if (preg_match('#^backup_(\d{10,})_[a-z\d]{16}\.(sql(?:\.(?:gz|bz2))?)$#', $file, $matches))

{

{

}

}

}

closedir($dh);

}

$template->assign_vars(array(

'U_ACTION' => $this->u_action . '&action=submit'

));

header('Pragma: no-cache');

header("Content-Type: $mimetype; name=\"$name\"");

header("Content-disposition: attachment; filename=$name");

switch ($format)

{

case 'bzip2':

break;

}

}

if ($store == true)

{

global $phpbb_root_path;

$file = $phpbb_root_path . 'store/' . $filename . $ext;

$this->fp = $open($file, 'w');

if (!$this->fp)

{

trigger_error('Unable to write temporary file to storage folder', E_USER_ERROR);

function write_end()

{

static $close;

if ($this->store)

{

if ($close === null)

if ($result != false)

{

$fields_cnt = mysqli_num_fields($result);

// Get field information

$field = mysqli_fetch_fields($result);

$field_set = array();

for ($j = 0; $j < $fields_cnt; $j++)

{

$field_set[] = $field[$j]->name;

$first_set = true;

$query_len = 0;

$max_len = get_usable_memory();

while ($row = mysqli_fetch_row($result))

{

$values = array();

$field[] = mysql_fetch_field($result, $i);

}

$field_set = array();

for ($j = 0; $j < $fields_cnt; $j++)

{

$field_set[] = $field[$j]->name;

$ar[] = $row;

}

$db->sql_freeresult($result);

foreach ($ar as $value)

{

if (strpos($value['name'], 'autoindex') !== false)

$sql_data .= "CREATE SEQUENCE {$table_name}_seq;\n";

}

$db->sql_freeresult($result);

$field_query = "SELECT a.attnum, a.attname as field, t.typname as type, a.attlen as length, a.atttypmod as lengthvar, a.attnotnull as notnull

FROM pg_class c, pg_attribute a, pg_type t

WHERE c.relname = '" . $db->sql_escape($table_name) . "'

{

$line .= ' NOT NULL';

}

$lines[] = $line;

}

$db->sql_freeresult($result);

$sql_data .= "GO\n";

$sql_data .= "\nCREATE TABLE [$table_name] (\n";

$rows = array();

$text_flag = false;

$sql = "SELECT COLUMN_NAME, COLUMN_DEFAULT, IS_NULLABLE, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, COLUMNPROPERTY(object_id(TABLE_NAME), COLUMN_NAME, 'IsIdentity') as IS_IDENTITY

FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME = '$table_name'";

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

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

{

$line = "\t[{$row['COLUMN_NAME']}] [{$row['DATA_TYPE']}]";

if ($row['DATA_TYPE'] == 'text')

{

$text_flag = true;

}

if ($row['IS_IDENTITY'])

{

$line .= ' IDENTITY (1 , 1)';

}

if ($row['CHARACTER_MAXIMUM_LENGTH'] && $row['DATA_TYPE'] !== 'text')

{

$line .= ' (' . $row['CHARACTER_MAXIMUM_LENGTH'] . ')';

}

if ($row['IS_NULLABLE'] == 'YES')

{

$line .= ' NULL';

{

$line .= ' NOT NULL';

}

if ($row['COLUMN_DEFAULT'])

{

$line .= ' DEFAULT ' . $row['COLUMN_DEFAULT'];

}

$rows[] = $line;

}

$db->sql_freeresult($result);

$sql_data .= implode(",\n", $rows);

$sql_data .= "\n) ON [PRIMARY]";

if ($text_flag)

{

$sql_data .= " TEXTIMAGE_ON [PRIMARY]";

}

$sql_data .= "\nGO\n\n";

$rows = array();

$sql = "SELECT CONSTRAINT_NAME, COLUMN_NAME

FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE

WHERE TABLE_NAME = '$table_name'";

$sql_data .= "\n\t) ON [PRIMARY] \nGO\n";

}

$db->sql_freeresult($result);

$index = array();

$sql = "EXEC sp_statistics '$table_name'";

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

}

}

$db->sql_freeresult($result);

foreach ($index as $index_name => $column_name)

{

$index[$index_name] = implode(', ', $column_name);

}

foreach ($index as $index_name => $columns)

{

$sql_data .= "\nCREATE INDEX [$index_name] ON [$table_name]($columns) ON [PRIMARY]\nGO\n";

$ary_type = $ary_name = array();

$ident_set = false;

$sql_data = '';

// Grab all of the data from current table.

$sql = "SELECT *

FROM $table_name";

$ary_type = $ary_name = array();

$ident_set = false;

$sql_data = '';

// Grab all of the data from current table.

$sql = "SELECT *

FROM $table_name";

{

global $db;

$ary_type = $ary_name = array();

// Grab all of the data from current table.

$sql = "SELECT *

FROM $table_name";

{

global $db;

$ary_type = $ary_name = array();

// Grab all of the data from current table.

$sql = "SELECT *

FROM $table_name";

{

$record = '';

$delim_len = strlen($delim);

while (!$eof($fp))

{

$pos = strpos($record, $delim);

$db->sql_freeresult($result);

trigger_error($user->lang['NO_USER'] . adm_back_link($this->u_action), E_USER_WARNING);

}

$i = $j = 0;

// Send with BCC, no more than 50 recipients for one mail (to not exceed the limit)

{

if (($row['user_notify_type'] == NOTIFY_EMAIL && $row['user_email']) ||

($row['user_notify_type'] == NOTIFY_IM && $row['user_jabber']) ||

{

if ($i == $max_chunk_size || $row['user_lang'] != $old_lang || $row['user_notify_type'] != $old_notify_type)

{

$messenger->headers('X-AntiAbuse: User_id - ' . $user->data['user_id']);

$messenger->headers('X-AntiAbuse: Username - ' . $user->data['username']);

$messenger->headers('X-AntiAbuse: User IP - ' . $user->ip);

$messenger->subject(htmlspecialchars_decode($subject));

$messenger->set_mail_priority($priority);

'CONTACT_EMAIL' => $config['board_contact'],

'MESSAGE' => htmlspecialchars_decode($message))

);

if (!($messenger->send($used_method)))

{

$errored = true;

$select_list = '<option value="0"' . ((!$group_id) ? ' selected="selected"' : '') . '>' . $user->lang['ALL_USERS'] . '</option>';

$select_list .= group_select_options($group_id, $exclude);

$s_priority_options = '<option value="' . MAIL_LOW_PRIORITY . '">' . $user->lang['MAIL_LOW_PRIORITY'] . '</option>';

$s_priority_options .= '<option value="' . MAIL_NORMAL_PRIORITY . '" selected="selected">' . $user->lang['MAIL_NORMAL_PRIORITY'] . '</option>';

$s_priority_options .= '<option value="' . MAIL_HIGH_PRIORITY . '">' . $user->lang['MAIL_HIGH_PRIORITY'] . '</option>';

$forum_perm_from = request_var('forum_perm_from', 0);

// Copy permissions?

(($action != 'edit') || empty($forum_id) || ($auth->acl_get('a_fauth') && $auth->acl_get('a_authusers') && $auth->acl_get('a_authgroups') && $auth->acl_get('a_mauth'))))

{

// if we edit a forum delete current permissions first

FROM ' . FORUMS_TABLE . '

WHERE forum_type = ' . FORUM_POST . "

AND forum_id <> $forum_id";

if ($db->sql_fetchrow($result))

{

}

$db->sql_freeresult($result);

$forums_list = make_forum_select($forum_data['parent_id'], $subforums_id);

{

$template->assign_vars(array(

'S_MOVE_FORUM_OPTIONS' => make_forum_select($forum_data['parent_id'], $subforums_id)) // , false, true, false???

);

}

$template->assign_vars(array(

'S_HAS_SUBFORUMS' => ($forum_data['right_id'] - $forum_data['left_id'] > 1) ? true : false,

'S_FORUMS_LIST' => $forums_list)

);

}

$s_show_display_on_index = false;

FROM ' . FORUMS_TABLE . '

WHERE forum_type = ' . FORUM_POST . "

AND forum_id <> $forum_id";

if ($db->sql_fetchrow($result))

{

$url = $this->u_action . "&amp;parent_id=$this->parent_id&amp;f={$row['forum_id']}";

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

'FOLDER_IMAGE' => $folder_image,

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

*/

function update_forum_data(&$forum_data)

{

$errors = array();

array('lang' => 'FORUM_TOPICS_PAGE', 'value' => $forum_data['forum_topics_per_page'], 'column_type' => 'TINT:0'),

);

validate_range($range_test_ary, $errors);

// Set forum flags

$messenger->headers('X-AntiAbuse: Board servername - ' . $config['server_name']);

$messenger->headers('X-AntiAbuse: User_id - ' . $user->data['user_id']);

$messenger->headers('X-AntiAbuse: Username - ' . $user->data['username']);

$messenger->assign_vars(array(

'USERNAME' => htmlspecialchars_decode($row['username']))

$sql = 'SELECT user_id, username, user_email, user_lang, user_jabber, user_notify_type, user_regdate, user_actkey

FROM ' . USERS_TABLE . '

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

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

$messenger->to($row['user_email'], $row['username']);

$messenger->im($row['user_jabber'], $row['username']);

$messenger->assign_vars(array(

'USERNAME' => htmlspecialchars_decode($row['username']),

'U_ACTIVATE' => generate_board_url() . "/ucp.$phpEx?mode=activate&u=" . $row['user_id'] . '&k=' . $row['user_actkey'])

);

else

{

// This feature is disabled.

$sql_ary = array(

'user_notify_type' => NOTIFY_BOTH,

);

$template->assign_var('S_WRITABLE_CONFIG', (bool) (@fileperms($phpbb_root_path . 'config.' . $phpEx) & 0x0002));

}

$this->tpl_name = 'acp_main';

$this->page_title = 'ACP_MAIN';

}

{

var $u_action;

var $permission_dropdown;

function main($id, $mode)

{

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

}

$db->sql_freeresult($result);

}

// Map usernames to ids and vice versa

if ($usernames)

{

}

}

unset($username);

// Build forum ids (of all forums are checked or subforum listing used)

if ($all_forums)

{

}

continue;

}

if ($branch_there)

{

$s_options .= ' [' . $user->lang['PLUS_SUBFORUMS'] . ']';

return $s_options;

}

/**

* Build dropdown field for changing permission types

*/

function build_permission_dropdown($options, $default_option, $permission_scope)

{

global $user, $auth;

$s_dropdown_options = '';

foreach ($options as $setting)

{

{

trigger_error($user->lang['NO_AUTH_OPERATION'] . adm_back_link($this->u_action), E_USER_WARNING);

}

$ug_id = $forum_id = 0;

// We loop through the auth settings defined in our submit

$this->log_action($mode, 'add', $permission_type, $ug_type, $ug_ids, $forum_ids);

}

/**

function remove_permissions($mode, $permission_type, &$auth_admin, &$user_id, &$group_id, &$forum_id)

{

global $user, $db, $auth;

// User or group to be set?

$ug_type = (sizeof($user_id)) ? 'user' : 'group';

$this->log_action($mode, 'del', $permission_type, $ug_type, (($ug_type == 'user') ? $user_id : $group_id), (sizeof($forum_id) ? $forum_id : array(0 => 0)));

}

/**

{

$sql_where = 'AND (' . $db->sql_in_set('a.auth_option_id', $option_ids) . ' OR ' . $db->sql_in_set('a.auth_role_id', $role_ids) . ')';

}

{

$sql_where = 'AND ' . $db->sql_in_set('a.auth_option_id', $option_ids);

}

case 'firebird':

// We are defining the biggest common value, because of the possibility to edit the min/max values of each field.

switch ($field_type)

{

'load_search' => 'bool',

'limit_search_load' => 'float',

'min_search_author_chars' => 'integer',

'search_store_results' => 'integer',

);

'SEARCH_INTERVAL' => (float) $config['search_interval'],

'SEARCH_GUEST_INTERVAL' => (float) $config['search_anonymous_interval'],

'SEARCH_STORE_RESULTS' => (int) $config['search_store_results'],

'S_SEARCH_TYPES' => $search_options,

'S_YES_SEARCH' => (bool) $config['load_search'],

ksort($this->state);

}

/**

// Hardcoded template bitfield to add for new templates

$bitfield = new bitfield();

$bitfield->set(0);

$bitfield->set(3);

$bitfield->set(8);

$bitfield->set(9);

$bitfield->set(11);

// If it's not stored in the db yet, then update the template setting and store all template files in the db

if (!$template_info['template_storedb'])

{

{

$this->store_in_db('template', $super['template_id']);

}

$this->page_title = 'EDIT_IMAGESET';

$imgname = preg_replace('#[^a-z0-9\-+_]#i', '', $imgname);

{

{

}

{

}

{

}

{

{

}

$imglang = '';

'U_BACK' => $this->u_action,

'NAME' => $imageset_name,

'A_NAME' => addslashes($imageset_name),

'ERROR' => !$valid_name,

'IMG_SRC' => ($image_found) ? '../styles/' . $imageset_path . '/imageset/' . $img_val : 'images/no_image.png',

'IMAGE_SELECT' => $image_found

if (isset($cfg_data['inherit_from']) && $cfg_data['inherit_from'])

{

FROM $sql_from

WHERE {$mode}_name = '" . $db->sql_escape($cfg_data['inherit_from']) . "'

AND {$mode}_inherits_id = 0";

{

$inherit_id = $row["{$mode}_id"];

$inherit_path = $row["{$mode}_path"];

$cfg_data['store_db'] = $row["{$mode}_storedb"];

$store_db = $row["{$mode}_storedb"];

}

{

$inherit_id = 0;

$inherit_path = '';

}

{

$sql_ary['bbcode_bitfield'] = $cfg_data['template_bitfield'];

}

else

{

$sql_ary['bbcode_bitfield'] = TEMPLATE_BITFIELD;

{

$sql = 'DELETE FROM ' . LOG_TABLE . '

WHERE log_type = ' . LOG_USERS . "

$where_sql";

$db->sql_query($sql);

foreach ($cp_data as $key => $value)

{

unset($cp_data[$key]);

}

}

$error = array();

}

else

{

$cache->put('_acl_options', $this->acl_options);

}

}

/**

* Get permission mask

* This function only supports getting permissions of one type (for example a_)

$auth2 = &$auth;

}

$hold_ary[$userdata['user_id']] = array();

foreach ($forum_ids as $f_id)

{

// Build js roles array (role data assignments)

$s_role_js_array = '';

if (sizeof($roles))

{

$s_role_js_array = array();

$cur_options = array();

$sql = 'SELECT auth_option, is_global, is_local

FROM ' . ACL_OPTIONS_TABLE . '

ORDER BY auth_option_id';

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

{

}

$db->sql_freeresult($result);

foreach ($option_ary as $option_value)

{

$flag = substr($option_value, 0, strpos($option_value, '_') + 1);

{

$new_options[$type][] = $flag;

}

$options = array();

$options['local'] = array_diff($new_options['local'], $new_options['global']);

$options['global'] = array_diff($new_options['global'], $new_options['local']);

foreach ($options as $type => $option_ary)

{

foreach ($option_ary as $option)

{

}

}

$cache->destroy('_acl_options');

$this->acl_clear_prefetch();

reset($auth);

$flag = key($auth);

$flag = substr($flag, 0, strpos($flag, '_') + 1);

// This ID (the any-flag) is set if one or more permissions are true...

$any_option_id = (int) $this->acl_options['id'][$flag];

reset($auth);

$flag = key($auth);

$flag = substr($flag, 0, strpos($flag, '_') + 1);

// Remove any-flag from auth ary

if (isset($auth[$flag]))

{

{

$where_sql[] = $db->sql_in_set('auth_option_id', array_map('intval', $option_id_ary));

}

$sql = "DELETE FROM $table

WHERE " . implode(' AND ', $where_sql);

$db->sql_query($sql);

'S_YES' => ($cat_array['S_YES'] && !$cat_array['S_NEVER'] && !$cat_array['S_NO']) ? true : false,

'S_NEVER' => ($cat_array['S_NEVER'] && !$cat_array['S_YES'] && !$cat_array['S_NO']) ? true : false,

'S_NO' => ($cat_array['S_NO'] && !$cat_array['S_NEVER'] && !$cat_array['S_YES']) ? true : false,

'CAT_NAME' => $user->lang['permission_cat'][$cat])

);

'lang' => '{ acl_' . $permission . ' }'

);

}

$cat = $user->lang['acl_' . $permission]['cat'];

// Build our categories array

if (!isset($categories[$cat]))

{