if ($fp = @fopen($this->cache_dir . 'data_global.' . $phpEx, 'wb'))

{

@flock($fp, LOCK_EX);

@flock($fp, LOCK_UN);

fclose($fp);

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

}

}

else

{

// Now, this occurred how often? ... phew, just tell the user then...

if (!@is_writable($this->cache_dir))

{

}

}

$this->is_modified = false;

if ($fp = @fopen($this->cache_dir . "data{$var_name}.$phpEx", 'wb'))

{

@flock($fp, LOCK_EX);

@flock($fp, LOCK_UN);

fclose($fp);

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

}

}

}

else

}

$db->sql_freeresult($query_result);

$file .= "\n\$expired = (time() > " . (time() + $ttl) . ") ? true : false;\nif (\$expired) { return; }\n";

fwrite($fp, $file . "\n\$this->sql_rowset[\$query_id] = " . (sizeof($this->sql_rowset[$query_id]) ? "unserialize(" . var_export(serialize($this->sql_rowset[$query_id]), true) . ");" : 'array();') . "\n\n?>");

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

}

$query_result = $query_id;

}

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

{

'user_row' => $row,

);

}

// Successful login...

return array(

'status' => LOGIN_SUCCESS,

*/

function validate_session_apache(&$user)

{

{

}

}

?> \ No newline at end of file

}

// cp1252 is phpBB2's default encoding, characters outside ASCII range might work when converted into that encoding

{

$hash = phpbb_hash($password_new_format);

$row['user_pass_convert'] = 0;

$row['user_password'] = $hash;

}

{

// Although we weren't able to convert this password we have to

// increase login attempt count to make sure this cannot be exploited

{

$this->template_bitfield = new bitfield($user->theme['bbcode_bitfield']);

$this->template_filename = $phpbb_root_path . 'styles/' . $user->theme['template_path'] . '/template/bbcode.html';

if (!@file_exists($this->template_filename))

{

if (isset($user->theme['template_inherits_id']) && $user->theme['template_inherits_id'])

if (empty($bbcode_hardtpl))

{

global $user;

$bbcode_hardtpl = array(

'b_open' => '<span style="font-weight: bold">',

'b_close' => '</span>',

else if (is_numeric($type))

{

$tpl = 'olist_open';

}

else

{

$tpl = 'olist_open';

}

return str_replace('{LIST_TYPE}', $type, $this->bbcode_tpl($tpl));

var $width = 360;

var $height = 96;

/**

* Create the image containing $code with a seed of $seed

*/

{

global $config;

srand($seed);

// Create image

$img = imagecreatetruecolor($this->width, $this->height);

$bg_colours = array_splice($scheme, mt_rand(6, 12));

// Generate code characters

$width_avail = $this->width - 15;

$code_len = strlen($code);

$captcha_bitmaps = $this->captcha_bitmaps();

for ($i = 0; $i < $code_len; ++$i)

{

$characters[$i] = new char_cube3d($captcha_bitmaps, $code[$i]);

$bounding_boxes[$i] = $box;

}

// Redistribute leftover x-space

$offset = array();

for ($i = 0; $i < $code_len; ++$i)

imagedashedline($img, mt_rand($x -3, $x + 3), mt_rand(0, 4), mt_rand($x -3, $x + 3), mt_rand($this->height - 5, $this->height), $current_colour);

}

}

$xoffset = 5;

for ($i = 0; $i < $code_len; ++$i)

{

$characters[$i]->drawchar($sizes[$i], $xoffset, $yoffset, $img, $colour->get_resource('background'), $scheme);

$xoffset += $dimm[2];

}

if ($config['captcha_gd_foreground_noise'])

{

$this->noise_line($img, 0, 0, $this->width, $this->height, $colour->get_resource('background'), $scheme, $bg_colours);

}

// Send image

header('Content-Type: image/png');

header('Cache-control: no-cache, no-store');

}

/**

* Noise line

*/

function noise_line($img, $min_x, $min_y, $max_x, $max_y, $bg, $font, $non_font)

imagesetthickness($img, 1);

}

return array(

'data' => array(

),

),

),

),

),

),

),

'1' => array(

array(0,0,0,1,1,0,0,0,0),

array(0,0,1,0,1,0,0,0,0),

*/

// phpBB Version

// QA-related

// define('PHPBB_QA', 1);

@define('CHMOD_WRITE', 2);

@define('CHMOD_EXECUTE', 1);

// Additional constants

define('VOTE_CONVERTED', 127);

*/

var $sql_layer = '';

var $dbms_type_map = array(

'mysql_41' => array(

'INT:' => 'int(%d)',

),

);

var $unsigned_types = array('UINT', 'UINT:', 'USINT', 'BOOL', 'TIMESTAMP');

var $supported_dbms = array('firebird', 'mssql', 'mysql_40', 'mysql_41', 'oracle', 'postgres', 'sqlite');

/**

*/

var $return_statements = false;

/**

*/

{

$this->db = $db;

// Determine mapping database type

switch ($this->db->sql_layer)

}

/**

* Handle passed database update array.

* Expected structure...

* Key being one of the following

* {KEY/INDEX NAME} => array({COLUMN NAMES}),

* )

*

*/

function perform_schema_changes($schema_changes)

{

{

foreach ($columns as $column_name => $column_data)

{

if ($this->return_statements)

{

{

foreach ($columns as $column_name => $column_data)

{

{

$result = $this->sql_column_add($table, $column_name, $column_data);

}

}

}

{

foreach ($columns as $column)

{

{

}

}

}

/**

* Check if a specified column exist

* @return bool True if column exists, else false

*/

function sql_column_exists($table, $column_name)

if (strpos($column_data[0], ':') !== false)

{

list($orig_column_type, $column_length) = explode(':', $column_data[0]);

if (!is_array($this->dbms_type_map[$this->sql_layer][$orig_column_type . ':']))

{

$column_type = sprintf($this->dbms_type_map[$this->sql_layer][$orig_column_type . ':'], $column_length);

$sql .= ' COLLATE UNICODE';

}

break;

case 'mssql':

}

}

$sql .= 'NOT NULL';

$sql_default .= 'NOT NULL';

$return_array['column_type_sql_default'] = $sql_default;

break;

case 'mysql_40':

// In Oracle empty strings ('') are treated as NULL.

// Therefore in oracle we allow NULL's for all DEFAULT '' entries

// Oracle does not like setting NOT NULL on a column that is already NOT NULL (this happens only on number fields)

{

$sql .= ($column_data[1] === '') ? '' : 'NOT NULL';

}

break;

case 'postgres':

$sql .= " {$column_type} ";

if (isset($column_data[2]) && $column_data[2] == 'auto_increment')

{

$default_val = "nextval('{$table_name}_seq')";

}

else if (!is_null($column_data[1]))

{

$return_array['constraint'] = "CHECK ({$column_name} >= 0)";

$sql .= " CHECK ({$column_name} >= 0)";

}

break;

case 'sqlite':

if (isset($column_data[2]) && $column_data[2] == 'auto_increment')

{

$sql .= ' INTEGER PRIMARY KEY';

}

else

{

$sql .= ' NOT NULL ';

$sql .= (!is_null($column_data[1])) ? "DEFAULT '{$column_data[1]}'" : '';

break;

}

switch ($this->sql_layer)

{

case 'firebird':

break;

case 'mssql':

switch ($this->sql_layer)

{

case 'firebird':

break;

case 'mssql':

}

/**

* Add primary key

*/

function sql_create_primary_key($table_name, $column)

{

case 'firebird':

case 'postgres':

$statements[] = 'ALTER TABLE ' . $table_name . ' ADD PRIMARY KEY (' . implode(', ', $column) . ')';

break;

$statements[] = $sql;

break;

case 'oracle':

$statements[] = 'ALTER TABLE ' . $table_name . 'add CONSTRAINT pk_' . $table_name . ' PRIMARY KEY (' . implode(', ', $column) . ')';

break;

FROM user_indexes

WHERE table_name = '" . $table_name . "'

AND generated = 'N'";

break;

case 'sqlite':

{

case 'firebird':

// Change type...

break;

case 'mssql':

if (@mysql_select_db($this->dbname, $this->db_connect_id))

{

// Determine what version we are using and if it natively supports UNICODE

{

@mysql_query("SET NAMES 'utf8'", $this->db_connect_id);

return $data;

}

/**

* return sql error array

* @access private

class dbal_postgres extends dbal

{

var $last_query_text = '';

/**

* Connect to server

*/

{

$connect_string .= "host=$sqlserver ";

}

if ($port)

{

$connect_string .= "port=$port ";

// if $total is set to 0 we do not want to limit the number of rows

if ($total == 0)

{

}

$query .= "\n LIMIT $total OFFSET $offset";

}

/**

* http://pear.php.net/package/Text_Diff/

*

* Modified by phpBB Group to meet our coding standards

}

/**

* Computes a reversed diff.

*

* Example:

}

/**

*

* @param string $label1 the cvs file version/label from the original set of lines

* @param string $label2 the cvs file version/label from the new set of lines

* @param string $label_sep the explanation between label1 and label2 - more of a helper for the user

*

* @return mixed the merged output

*/

{

global $user;

$label1 = (!empty($user->lang[$label1])) ? $user->lang[$label1] : $label1;

$label2 = (!empty($user->lang[$label2])) ? $user->lang[$label2] : $label2;

$label_sep = (!empty($user->lang[$label_sep])) ? $user->lang[$label_sep] : $label_sep;

{

if ($edit->is_conflict())

{

$this->_conflicting_blocks++;

}

else

}

/**

* Merge the output and use the new file code for conflicts

*/

function merged_new_output()

}

/**

* http://pear.php.net/package/Text_Diff/ (native engine)

*

* Modified by phpBB Group to meet our coding standards

}

/**

* http://pear.php.net/package/Text_Diff/

*

* Modified by phpBB Group to meet our coding standards

}

/**

* Generates an alphanumeric random string of given length

*/

function gen_rand_string($num_chars = 8)

{

global $user;

if ($bytes >= pow(2, 20))

{

return ($add_size_lang) ? round($bytes / 1024 / 1024, 2) . ' ' . $user->lang['MIB'] : round($bytes / 1024 / 1024, 2);

/**

* Global function for chmodding directories and files for internal use

* This function determines owner and group whom the file belongs to and user and group of PHP and then set safest possible file permissions.

* The function uses bit fields to build the permissions.

* The function sets the appropiate execute bit on directories.

*

*

* NOTE: The function uses POSIX extension and fileowner()/filegroup() functions. If any of them is disabled, this function tries to build proper permissions, by calling is_readable() and is_writable() functions.

*

*

* @author faw, phpBB Group

*/

function phpbb_chmod($filename, $perms = CHMOD_READ)

{

// Return if the file no longer exists.

if (!file_exists($filename))

{

return false;

}

{

{

}

{

}

}

}

{

}

{

}

{

$php = 'other';

}

switch ($php)

{

case 'owner':

$result = @chmod($filename, ($owner << 6) + (0 << 3) + (0 << 0));

clearstatcache();

{

break;

}

case 'group':

$result = @chmod($filename, ($owner << 6) + ($perms << 3) + (0 << 0));

clearstatcache();

{

break;

}

clearstatcache();

{

break;

}

*/

function is_absolute($path)

{

}

/**

$sql_update = array();

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

{

}

$db->sql_freeresult($result);

$db->sql_query($sql);

// Generate code

$confirm_id = md5(unique_id($user->ip));

$seed = hexdec(substr(unique_id(), 4, 10));

$msg_text = str_replace(array(phpbb_realpath($phpbb_root_path), '\\'), array('', '/'), $msg_text);

echo '<b>[phpBB Debug] PHP Notice</b>: in file <b>' . $errfile . '</b> on line <b>' . $errline . '</b>: <b>' . $msg_text . '</b><br />' . "\n";

}

return;

AND s.session_time >= ' . ($time - ((int) ($time % 60))) .

$reading_sql;

}

$guests_online = (int) $db->sql_fetchfield('num_guests');

$db->sql_freeresult($result);

if ($approved_topics)

{

}

return $return;

return false;

}

}

$approved_posts = 0;

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

{

if ($row['post_postcount'] && $post_count_sync && $row['post_approved'])

{

if ($approved_posts)

{

}

// We actually remove topics now to not be inconsistent (the delete_topics function calls this function too)

return false;

}

switch ($mode)

{

case 'post':

case 'message':

$sql_id = 'post_msg_id';

break;

case 'topic':

$sql = 'SELECT post_msg_id, topic_id, in_message, physical_filename, thumbnail, filesize, is_orphan

FROM ' . ATTACHMENTS_TABLE . '

WHERE ' . $db->sql_in_set($sql_id, $ids);

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

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

// Delete attachments

$sql = 'DELETE FROM ' . ATTACHMENTS_TABLE . '

WHERE ' . $db->sql_in_set($sql_id, $ids);

$db->sql_query($sql);

$num_deleted = $db->sql_affectedrows();

if ($space_removed || $files_removed)

{

}

// If we do not resync, we do not need to adjust any message, post, topic or user entries

'S_THUMBNAIL' => true,

'THUMB_IMAGE' => $thumbnail_link,

);

break;

// Windows Media Streams

'S_FLASH_FILE' => true,

'WIDTH' => $width,

'HEIGHT' => $height,

);

// Viewed/Heared File ... update the download count

array_pop($chars);

$string = implode('', $chars);

}

}

if ($strip_reply)

function get_username_string($mode, $user_id, $username, $username_colour = '', $guest_username = false, $custom_profile_url = false)

{

static $_profile_cache;

{

}

{

{

}

}

/**

// Handle marking posts

if ($mark_read == 'forums' || $mark_read == 'all')

{

$token = request_var('hash', '');

if (check_link_hash($token, 'global'))

{

*/

function display_custom_bbcodes()

{

// Start counting from 22 for the bbcode ids (every bbcode takes two ids - opening/closing)

$num_predefined_bbcodes = 22;

$i = 0;

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

{

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

'BBCODE_NAME' => "'[{$row['bbcode_tag']}]', '[/" . str_replace('=', '', $row['bbcode_tag']) . "]'",

'BBCODE_ID' => $num_predefined_bbcodes + ($i * 2),

var $mail_priority = MAIL_NORMAL_PRIORITY;

var $use_queue = true;

var $tpl_msg = array();

/**

* Constructor

$this->use_queue = (!$config['email_package_size']) ? false : $use_queue;

$this->subject = '';

}

/**

{

global $config;

$pos = isset($this->addresses['to']) ? sizeof($this->addresses['to']) : 0;

$this->addresses['to'][$pos]['email'] = trim($address);

*/

function cc($address, $realname = '')

{

$pos = isset($this->addresses['cc']) ? sizeof($this->addresses['cc']) : 0;

$this->addresses['cc'][$pos]['email'] = trim($address);

$this->addresses['cc'][$pos]['name'] = trim($realname);

*/

function bcc($address, $realname = '')

{

$pos = isset($this->addresses['bcc']) ? sizeof($this->addresses['bcc']) : 0;

$this->addresses['bcc'][$pos]['email'] = trim($address);

$this->addresses['bcc'][$pos]['name'] = trim($realname);

function im($address, $realname = '')

{

// IM-Addresses could be empty

{

return;

}

*/

function template($template_file, $template_lang = '')

{

if (!trim($template_file))

{

if (empty($this->tpl_msg[$template_lang . $template_file]))

{

if (!file_exists($tpl_file))

{

{

global $config;

$headers = array();

$headers[] = 'From: ' . $this->from;

$headers[] = 'X-MimeOLE: phpBB3';

$headers[] = 'X-phpBB-Origin: phpbb://' . str_replace(array('http://', 'https://'), array('', ''), generate_board_url());

if (sizeof($this->extra_headers))

{

}

}

/**

return false;

}

$use_queue = false;

if ($config['email_package_size'] && $this->use_queue)

{

}

else

{

ob_start();

$result = $config['email_function_name']($mail_to, mail_encode($this->subject), wordwrap(utf8_wordwrap($this->msg), 997, "\n", true), $headers);

$err_msg = ob_get_clean();

if (empty($this->addresses['im']))

{

}

$use_queue = false;

var $queue_data = array();

var $package_size = 0;

var $cache_file = '';

/**

* constructor

$this->data = array();

$this->cache_file = "{$phpbb_root_path}cache/queue.$phpEx";

}

/**

else

{

ob_start();

$err_msg = ob_get_clean();

}

if ($fp = @fopen($this->cache_file, 'wb'))

{

@flock($fp, LOCK_EX);

@flock($fp, LOCK_UN);

fclose($fp);

}

}

if ($fp = @fopen($this->cache_file, 'w'))

{

@flock($fp, LOCK_EX);

@flock($fp, LOCK_UN);

fclose($fp);

}

}

}

/**

* Replacement or substitute for PHP's mail command

*/

{

global $config, $user;

// Fix any bare linefeeds in the message to make it RFC821 Compliant.

$message = preg_replace("#(?<!\r)\n#si", "\r\n", $message);

{

{

}

// Ok this is rather confusing all things considered,

// but we have to grab bcc and cc headers and treat them differently

// Something we really didn't take into consideration originally

{

if (strpos(strtolower($header), 'cc:') === 0 || strpos(strtolower($header), 'bcc:') === 0)

{

}

}

}

if (trim($subject) == '')

}

// Now any custom headers....

// Ok now we are ready for the message...

$smtp->server_send($message);

global $user;

$err_msg = '';

// If we are authenticating through pop-before-smtp, we

// have to login ones before we get authenticated

// define start delimimter, end delimiter and spacer

$start = "=?UTF-8?B?";

$end = "?=";

$encoded_str = base64_encode($str);

// If encoded string meets the limits, we just return with the correct data.

// If there is only ASCII data, we just return what we want, correctly splitting the lines.

if (strlen($str) === utf8_strlen($str))

{

}

// UTF-8 data, compose encoded lines

$text .= array_shift($array);

}

}

}

?> \ No newline at end of file

list($new_width, $new_height) = get_img_size_format($width, $height);

// Do not create a thumbnail if the resulting width/height is bigger than the original one

{

return false;

}

$config['img_imagick'] .= '/';

}

if (file_exists($destination))

{

}

$sql = $db->sql_build_query('SELECT', array(

'FROM' => array(

USERS_TABLE => 'u',

POSTS_TABLE => 'p',

),

'WHERE' => $db->sql_in_set('p.post_id', $post_list) . '

AND u.user_id = p.poster_id'

));

$post_subject = censor_text($post_subject);

$template->assign_block_vars($mode . '_row', array(

'POST_AUTHOR_FULL' => get_username_string('full', $poster_id, $row['username'], $row['user_colour'], $row['post_username']),

'POST_AUTHOR_COLOUR' => get_username_string('colour', $poster_id, $row['username'], $row['user_colour'], $row['post_username']),

'U_POST_AUTHOR' => get_username_string('profile', $poster_id, $row['username'], $row['user_colour'], $row['post_username']),

'S_HAS_ATTACHMENTS' => (!empty($attachments[$row['post_id']])) ? true : false,

'POST_SUBJECT' => $post_subject,

'MINI_POST_IMG' => $user->img('icon_post_target', $user->lang['POST']),

if (!$topic_notification && !$forum_notification)

{

}

if (($topic_notification && !$config['allow_topic_notify']) || ($forum_notification && !$config['allow_forum_notify']))

$sql_data[TOPICS_TABLE]['sql'] = array(

'topic_poster' => (int) $user->data['user_id'],

'topic_time' => $current_time,

'forum_id' => ($topic_type == POST_GLOBAL) ? 0 : $data['forum_id'],

'icon_id' => $data['icon_id'],

'topic_approved' => $post_approval,

if (isset($poll['poll_options']) && !empty($poll['poll_options']))

{

$sql_data[TOPICS_TABLE]['sql'] = array_merge($sql_data[TOPICS_TABLE]['sql'], array(

'poll_title' => $poll['poll_title'],

'poll_max_options' => $poll['poll_max_options'],

'poll_vote_change' => $poll['poll_vote_change'])

);

}

break;

case 'reply':

$sql_data[USERS_TABLE]['stat'][] = "user_lastpost_time = $current_time" . (($auth->acl_get('f_postcount', $data['forum_id']) && $post_approval) ? ', user_posts = user_posts + 1' : '');

if ($post_approval && $topic_type != POST_GLOBAL)

case 'edit_topic':

case 'edit_first_post':

$sql_data[TOPICS_TABLE]['sql'] = array(

'forum_id' => ($topic_type == POST_GLOBAL) ? 0 : $data['forum_id'],

'topic_type' => $topic_type,

'topic_time_limit' => ($topic_type == POST_STICKY || $topic_type == POST_ANNOUNCE) ? ($data['topic_time_limit'] * 86400) : 0,

'poll_title' => (isset($poll['poll_options'])) ? $poll['poll_title'] : '',

'poll_max_options' => (isset($poll['poll_options'])) ? $poll['poll_max_options'] : 1,

'poll_vote_change' => (isset($poll['poll_vote_change'])) ? $poll['poll_vote_change'] : 0,

'topic_attachment' => (!empty($data['attachment_data'])) ? 1 : (isset($data['topic_attachment']) ? $data['topic_attachment'] : 0),

);

$sql_data[FORUMS_TABLE]['stat'][] = 'forum_topics = forum_topics - 1';

$sql_data[FORUMS_TABLE]['stat'][] = 'forum_posts = forum_posts - ' . ($topic_row['topic_replies'] + 1);

// Only decrement this post, since this is the one non-approved now

if ($auth->acl_get('f_postcount', $data['forum_id']))

// Correctly set back the topic replies and forum posts... but only if the post was approved before.

if (!$post_approval && $data['post_approved'])

{

$sql_data[FORUMS_TABLE]['stat'][] = 'forum_posts = forum_posts - 1';

if ($auth->acl_get('f_postcount', $data['forum_id']))

{

if ($space_taken && $files_added)

{

}

}

{

if ($post_mode == 'post')

{

}

if ($post_mode == 'reply')

{

}

}

WHERE ' . $db->sql_in_set('ug.group_id', array_keys($data['address_list']['g'])) . '

AND ug.user_pending = 0

AND u.user_id = ug.user_id

$sql_allow_pm;

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

if ($space_taken && $files_added)

{

}

}

$url = append_sid("{$phpbb_root_path}ucp.$phpEx", 'i=pm');

$next_history_pm = $previous_history_pm = $prev_id = 0;

{

$author_id = $row['author_id'];

$folder_id = (int) $row['folder_id'];

if ($id == $msg_id)

{

$previous_history_pm = $prev_id;

}

switch ($mode)

{

case 'register':

break;

case 'profile':

switch ($mode)

{

case 'register':

break;

case 'profile':

}

}

// There will be a number of occasions where we switch into and out of

// PHP mode instantaneously. Rather than "burden" the parser with this

// we'll strip out such occurences, minimising such switching

}

/**

// transform vars prefixed by L_ into their language variable pendant if nothing is set within the tpldata array

if (strpos($text_blocks, '{L_') !== false)

{

}

// Handle addslashed language variables prefixed with LA_

// If a template variable already exist, it will be used in favor of it...

if (strpos($text_blocks, '{LA_') !== false)

{

}

// Handle remaining varrefs

return;

}

$filename = $this->template->cachepath . str_replace('/', '.', $this->template->filename[$handle]) . '.' . $phpEx;

if ($fp = @fopen($filename, 'wb'))

{

@flock($fp, LOCK_EX);

@flock($fp, LOCK_UN);

@fclose($fp);

}

return;

$directory = $this->root_path . str_replace($phpbb_root_path, '', $directory);

$this->_chdir($directory);

if ($result !== false && is_array($result))

{

*/

function _ls($dir = './')

{

}

/**

}

$this->_close_data_connection();

return $list;

}

// PHP Upload filesize exceeded

if ($file->get('filename') == 'none')

{

return $file;

}

// PHP Upload filesize exceeded

if ($file->get('filename') == 'none')

{

return $file;

}

switch ($errorcode)

{

case 1:

break;

case 2:

{

set_config('newest_user_id', $user_id, true);

set_config('newest_username', $user_row['username'], true);

$sql = 'SELECT group_colour

FROM ' . GROUPS_TABLE . '

$db->sql_transaction('begin');

foreach ($table_ary as $table)

{

$cache->destroy('sql', MODERATOR_CACHE_TABLE);

// Remove any undelivered mails...

$sql = 'SELECT msg_id, user_id

FROM ' . PRIVMSGS_TO_TABLE . '

// Decrement number of users if this user is active

if ($user_row['user_type'] != USER_INACTIVE && $user_row['user_type'] != USER_IGNORE)

{

}

return false;

if ($deactivated)

{

}

if ($activated)

{

}

// Update latest username

/**

* Whois facility

*/

function user_ipwhois($ip)

{

return '';

}

if (($fsk = @fsockopen('whois.arin.net', 43)))

{

while (!feof($fsk))

{

$ipwhois .= fgets($fsk, 1024);

@fclose($fsk);

}

{

{

{

}

}

}

$ipwhois = htmlspecialchars($ipwhois);

}

else if ($mbstring)

{

}

else

{

}

else if ($mbstring)

{

if (!mb_ereg_search())

{

return 'INVALID_CHARS';

*/

function group_user_del($group_id, $user_id_ary = false, $username_ary = false, $group_name = false)

{

// We need both username and user_id info

$result = user_get_id_name($user_id_ary, $username_ary);

$temp_ary = array();

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

{

{

$temp_ary[$row['user_id']] = $row['group_id'];

}

}

$db->sql_freeresult($result);

$sql_where_ary = array();

foreach ($temp_ary as $uid => $gid)

{

{

if (isset($sql_where_ary[$gid]) && sizeof($sql_where_ary[$gid]))

{

remove_default_avatar($group_id, $sql_where_ary[$gid]);

group_set_user_default($gid, $sql_where_ary[$gid], $default_data_ary);

}

$topic_data = get_topic_data($topic_ids);

$leave_shadow = (isset($_POST['move_leave_shadow'])) ? true : false;

$forum_sync_data = array();

$forum_sync_data[$forum_id] = current($topic_data);

$forum_sync_data[$to_forum_id] = $forum_data;

foreach ($topic_data as $topic_id => $topic_info)

{

{

$topics_authed_moved++;

}

}

$db->sql_transaction('begin');

$sync_sql = array();

{

}

if ($topics_authed_moved)

{

}

// Move topics, but do not resync yet

move_topics($topic_ids, $to_forum_id, false);

$db->sql_query('INSERT INTO ' . TOPICS_TABLE . $db->sql_build_array('INSERT', $shadow));

}

}

unset($topic_data);

{

}

$success_msg = (sizeof($topic_ids) == 1) ? 'TOPIC_MOVED_SUCCESS' : 'TOPICS_MOVED_SUCCESS';

}

else

{

meta_refresh(3, $redirect);

trigger_error($success_msg . '<br /><br />' . sprintf($user->lang['RETURN_PAGE'], '<a href="' . $redirect . '">', '</a>') . '<br /><br />' . implode('<br /><br />', $return_link));

}

}

sync('forum', 'forum_id', $to_forum_id);

foreach ($new_topic_id_list as $topic_id => $new_topic_id)

{

'PAGINATION' => generate_pagination($this->u_action . "&amp;st=$st&amp;sk=$sk&amp;sd=$sd", $log_count, $config['posts_per_page'], $start),

'TOTAL_REPORTS' => ($log_count == 1) ? $user->lang['LIST_REPORT'] : sprintf($user->lang['LIST_REPORTS'], $log_count),

'RANK_TITLE' => $rank_title,

'JOINED' => $user->format_date($userrow['user_regdate']),

'POSTS' => ($userrow['user_posts']) ? $userrow['user_posts'] : 0,

'WARNINGS' => ($userrow['user_warnings']) ? $userrow['user_warnings'] : 0,

'AVATAR_IMG' => $avatar_img,

'RANK_IMG' => $rank_img,

)

$total_topics = $total_posts = 0;

$forum_topics_posts = $topic_approve_sql = $topic_replies_sql = $post_approve_sql = $topic_id_list = $forum_id_list = $approve_log = array();

$update_forum_information = false;

foreach ($post_info as $post_id => $post_data)

{

$topic_id_list[$post_data['topic_id']] = 1;

if ($post_data['forum_id'])

}

else

{

$approve_log[] = array(

'type' => 'post',

'post_subject' => $post_data['post_subject'],

);

}

if ($post_data['forum_id'])

{

if (!isset($forum_topics_posts[$post_data['forum_id']]))

$update_forum_information = true;

}

}

if (sizeof($topic_approve_sql))

{

if ($total_topics)

{

}

if ($total_posts)

{

}

unset($topic_approve_sql, $topic_replies_sql, $post_approve_sql);

}

else

{

}

}

else

$success_msg = 'TOPIC_SPLIT_SUCCESS';

// Update forum statistics

// Link back to both topics

$return_link = sprintf($user->lang['RETURN_TOPIC'], '<a href="' . append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $post_info['forum_id'] . '&amp;t=' . $post_info['topic_id']) . '">', '</a>') . '<br /><br />' . sprintf($user->lang['RETURN_NEW_TOPIC'], '<a href="' . append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $to_forum_id . '&amp;t=' . $to_topic_id) . '">', '</a>');

$template->assign_vars(array(

'U_POST_ACTION' => $this->u_action,

'RANK_TITLE' => $rank_title,

'JOINED' => $user->format_date($user_row['user_regdate']),

'POSTS' => ($user_row['user_posts']) ? $user_row['user_posts'] : 0,

'WARNINGS' => ($user_row['user_warnings']) ? $user_row['user_warnings'] : 0,

'AVATAR_IMG' => $avatar_img,

'RANK_IMG' => $rank_img,

* [quote="[i]test[/i]"]test[/quote] (correct: parsed)

* [quote="[quote]test[/quote]"]test[/quote] (correct: parsed - Username displayed as [quote]test[/quote])

* #20735 - [quote]test[/[/b]quote] test [/quote][/quote] test - (correct: quoted: "test[/[/b]quote] test" / non-quoted: "[/quote] test" - also failed if layout distorted)

*/

$in = str_replace("\r\n", "\n", str_replace('\"', '"', trim($in)));

}

// To let the parser not catch tokens within quote_username quotes we encode them before we start this...

$tok = ']';

$out = '[';

}

while ($in);

if (sizeof($close_tags))

{

$out .= '[' . implode('][', $close_tags) . ']';

{

// Init BBCode UID

$this->bbcode_uid = substr(base_convert(unique_id(), 16, 36), 0, BBCODE_UID_LEN);

}

/**

}

}

// Prepare BBcode (just prepares some tags for better parsing)

if ($allow_bbcode && strpos($this->message, '[') !== false)

{

}

}

// Check number of links

if ($config['max_' . $mode . '_urls'] && $num_urls > $config['max_' . $mode . '_urls'])

{

*/

function split_keywords(&$keywords, $terms)

{

if ($terms == 'all')

{

$this->split_words = $matches[1];

}

// to allow phrase search, we need to concatenate quoted words

$tmp_split_words = array();

$phrase = '';

*/

function split_keywords($keywords, $terms)

{

$keywords = trim($this->cleanup($keywords, '+-|()*'));

);

$keywords = preg_replace($match, $replace, $keywords);

// $keywords input format: each word separated by a space, words in a bracket are not separated

$sql = '';

$sql_array_count = $sql_array;

switch ($db->sql_layer)

{

case 'mysql4':

case 'mysqli':

// 3.x does not support SQL_CALC_FOUND_ROWS

$is_mysql = true;

break;

$sql_where[] = 'f.forum_id = p.forum_id';

break;

}

if ($left_join_topics)

{

'FROM' => array(TOPICS_TABLE => 't'),

'ON' => 'p.topic_id = t.topic_id'

);

// if we use mysql and the total result count is not cached yet, retrieve it from the db

if (!$total_results && $is_mysql)

{

$sql = 'SELECT FOUND_ROWS() as total_results';

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

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

{

case 'mysql4':

case 'mysqli':

$is_mysql = true;

break;

if (!$total_results && $is_mysql)

{

$sql = 'SELECT FOUND_ROWS() as total_results';

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

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

// Get unique words from the above arrays

$unique_add_words = array_unique(array_merge($words['add']['post'], $words['add']['title']));

// We now have unique arrays of all words to be added and removed and

// individual arrays of added and removed words for text and title. What

// we need to do now is add the new words (if they don't already exist)

else

{

// Set to OS hostname or localhost

}

}

foreach (explode(',', $row['bot_ip']) as $bot_ip)

{

if (strpos($this->ip, $bot_ip) === 0)

{

$bot = (int) $row['user_id'];

// Commented out because it will not allow forums to update correctly

// $db->sql_return_on_error(false);

$this->session_id = $this->data['session_id'] = md5(unique_id());

$sql_ary['session_id'] = (string) $this->session_id;

}

$dnsbl_check = array(

);

if ($mode == 'register')

$host = htmlspecialchars($this->host);

$ref = substr($this->referer, strpos($this->referer, '://') + 3);

{

return false;

}

// We include common language file here to not load it every time a custom language file is included

$lang = &$this->lang;

{

die('Language file ' . $this->lang_path . $this->lang_name . "/common.$phpEx" . " couldn't be opened.");

}

$this->img_lang = (file_exists($phpbb_root_path . 'styles/' . $this->theme['imageset_path'] . '/imageset/' . $this->lang_name)) ? $this->lang_name : $config['default_lang'];

FROM ' . STYLES_IMAGESET_DATA_TABLE . '

WHERE imageset_id = ' . $this->theme['imageset_id'] . "

AND image_filename <> ''

// Is board disabled and user not an admin or moderator?

if ($config['board_disable'] && !defined('IN_LOGIN') && !$auth->acl_gets('a_', 'm_') && !$auth->acl_getf_global('m_'))

{

$message = (!empty($config['board_disable_msg'])) ? $config['board_disable_msg'] : 'BOARD_DISABLE';

trigger_error($message);

if (!$auth->acl_gets('a_', 'm_') && !$auth->acl_getf_global('m_'))

{

trigger_error('BOARD_UNAVAILABLE');

}

}

$language_filename = $this->lang_path . $this->lang_name . '/' . (($use_help) ? 'help_' : '') . $lang_file . '.' . $phpEx;

}

{

trigger_error('Language file ' . $language_filename . ' couldn\'t be opened.', E_USER_ERROR);

}

// Is the user requesting a friendly date format (i.e. 'Today 12:42')?

$date_cache[$format] = array(

'is_short' => strpos($format, '|'),

'format_short' => substr($format, 0, strpos($format, '|')) . '||' . substr(strrchr($format, '|'), 1),

'format_long' => str_replace('|', '', $format),

'lang' => $this->lang['datetime'],

}

}

// Show date <= 1 hour ago as 'xx min ago'

if ($delta <= 3600 && ($delta >= -5 || (($now / 60) % 60) == (($gmepoch / 60) % 60)) && $date_cache[$format]['is_short'] !== false && !$forcedate && isset($this->lang['datetime']['AGO']))

{

return $this->lang(array('datetime', 'AGO'), max(0, (int) floor($delta / 60)));

if (!$midnight)

{

}

{

$day = false;

if ($day !== false)

{

}

}

}

/**

return $img_data;

}

$img_data['width'] = $this->img_array[$img]['image_width'];

$img_data['height'] = $this->img_array[$img]['image_height'];

}

trigger_error('WRONG_ACTIVATION');

}

$update_password = ($user_row['user_newpasswd']) ? true : false;

if ($update_password)

SET ' . $db->sql_build_array('UPDATE', $sql_ary) . '

WHERE user_id = ' . $user_row['user_id'];

$db->sql_query($sql);

}

if (!$update_password)

'U_SORT_FILESIZE' => $this->u_action . "&amp;sk=d&amp;sd=" . (($sort_key == 'd' && $sort_dir == 'a') ? 'd' : 'a'),

'U_SORT_DOWNLOADS' => $this->u_action . "&amp;sk=e&amp;sd=" . (($sort_key == 'e' && $sort_dir == 'a') ? 'd' : 'a'),

'U_SORT_POST_TIME' => $this->u_action . "&amp;sk=f&amp;sd=" . (($sort_key == 'f' && $sort_dir == 'a') ? 'd' : 'a'),

'S_DISPLAY_MARK_ALL' => ($num_attachments) ? true : false,

'S_DISPLAY_PAGINATION' => ($num_attachments) ? true : false,

'S_ROW_COUNT' => ${$block . '_count'}++)

);

}

$db->sql_freeresult($result);

*/

function assign_topiclist($mode = 'subscribed', $forbidden_forum_ary = array())

{

$table = ($mode == 'subscribed') ? TOPICS_WATCH_TABLE : BOOKMARKS_TABLE;

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

$sql_array = array(

'SELECT' => 'COUNT(t.topic_id) as topics_count',

$folder_img = $folder_alt = $topic_type = '';

topic_status($row, $replies, $unread_topic, $folder_img, $folder_alt, $topic_type);

// Send vars to template

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

'TOPIC_FOLDER_IMG' => $user->img($folder_img, $folder_alt),

'TOPIC_FOLDER_IMG_SRC' => $user->img($folder_img, $folder_alt, false, '', 'src'),

'TOPIC_ICON_IMG' => (!empty($icons[$row['icon_id']])) ? $icons[$row['icon_id']]['img'] : '',

'TOPIC_ICON_IMG_WIDTH' => (!empty($icons[$row['icon_id']])) ? $icons[$row['icon_id']]['width'] : '',

'TOPIC_ICON_IMG_HEIGHT' => (!empty($icons[$row['icon_id']])) ? $icons[$row['icon_id']]['height'] : '',

'S_USER_POSTED' => (!empty($row['topic_posted'])) ? true : false,

'S_UNREAD_TOPIC' => $unread_topic,

'U_VIEW_TOPIC' => $view_topic_url,

'U_VIEW_FORUM' => append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $forum_id),

));

$forward_text = array();

$forward_text[] = $user->lang['FWD_ORIGINAL_MESSAGE'];

$forward_text[] = sprintf($user->lang['FWD_SUBJECT'], censor_text($message_subject));

$forward_text[] = sprintf($user->lang['FWD_FROM'], $quote_username_text);

$forward_text[] = sprintf($user->lang['FWD_TO'], implode(', ', $fwd_to_field['to']));

'FLASH_STATUS' => ($flash_status) ? $user->lang['FLASH_IS_ON'] : $user->lang['FLASH_IS_OFF'],

'SMILIES_STATUS' => ($smilies_status) ? $user->lang['SMILIES_ARE_ON'] : $user->lang['SMILIES_ARE_OFF'],

'URL_STATUS' => ($url_status) ? $user->lang['URL_IS_ON'] : $user->lang['URL_IS_OFF'],

'MINI_POST_IMG' => $user->img('icon_post_target', $user->lang['PM']),

'ERROR' => (sizeof($error)) ? implode('<br />', $error) : '',

'MAX_RECIPIENTS' => ($config['allow_mass_pm'] && ($auth->acl_get('u_masspm') || $auth->acl_get('u_masspm_group'))) ? $max_recipients : 0,

$group_list = request_var('group_list', array(0));

// Build usernames to add

$username_list = request_var('username_list', '', true);

if ($username_list)

{

$data[] = array(

'subject' => censor_text($row['message_subject']),

'sender' => $row['username'],

'to' => ($folder_id == PRIVMSGS_OUTBOX || $folder_id == PRIVMSGS_SENTBOX) ? $address[$message_id] : '',

'message' => $message_row['message_text']

);

'PAGE_NUMBER' => on_page($pm_count, $config['topics_per_page'], $start),

'TOTAL_MESSAGES' => (($pm_count == 1) ? $user->lang['VIEW_PM_MESSAGE'] : sprintf($user->lang['VIEW_PM_MESSAGES'], $pm_count)),

'L_NO_MESSAGES' => (!$auth->acl_get('u_sendpm')) ? $user->lang['POST_PM_LOCKED'] : $user->lang['NO_MESSAGES'],

'S_SELECT_SORT_DAYS' => $s_limit_days,

'S_TOPIC_ICONS' => ($config['enable_pm_icons']) ? true : false,

'S_PM_ACTION' => append_sid("{$phpbb_root_path}ucp.$phpEx", "i=pm&amp;mode=view&amp;action=view_folder&amp;f=$folder_id" . (($start !== 0) ? "&amp;start=$start" : '')),

));

$update_time = $config['load_online_time'] * 60;

if ($row)

{

}

}

{

$data['notify'] = $user->data['user_notify_type'];

{

// User has not filled in a jabber address (Or one of the modules is disabled or jabber is disabled)

// Disable notify by Jabber now for this user.

}

$sql_ary = array(

'IMG_STATUS' => ($config['allow_sig_img']) ? $user->lang['IMAGES_ARE_ON'] : $user->lang['IMAGES_ARE_OFF'],

'FLASH_STATUS' => ($config['allow_sig_flash']) ? $user->lang['FLASH_IS_ON'] : $user->lang['FLASH_IS_OFF'],

'URL_STATUS' => ($config['allow_sig_links']) ? $user->lang['URL_IS_ON'] : $user->lang['URL_IS_OFF'],

'L_SIGNATURE_EXPLAIN' => sprintf($user->lang['SIGNATURE_EXPLAIN'], $config['max_sig_chars']),

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

if ($agreed)

{

array('string', false, 6, 60),

array('email')),

'email_confirm' => array('string', false, 6, 60),

'tz' => array('num', false, -14, 14),

'lang' => array('match', false, '#^[a-z_\-]{2,}$#i'),

));

if ($config['enable_confirm'])

{

{

$str = '&amp;change_lang=' . $change_lang;

$sql = 'SELECT code

{

$str = '';

}

{

$user->confirm_gc(CONFIRM_REG);

trigger_error('TOO_MANY_REGISTERS');

}

$confirm_id = md5(unique_id($user->ip));

$seed = hexdec(substr(unique_id(), 4, 10));

);

$db->sql_query($sql);

}

$confirm_image = '<img src="' . append_sid("{$phpbb_root_path}ucp.$phpEx", 'mode=confirm&amp;id=' . $confirm_id . '&amp;type=' . CONFIRM_REG . $str) . '" alt="" title="" />';

$s_hidden_fields .= '<input type="hidden" name="confirm_id" value="' . $confirm_id . '" />';

}

'S_LANG_OPTIONS' => language_select($data['lang']),

'S_TZ_OPTIONS' => tz_select($data['tz']),

'S_CONFIRM_CODE' => ($config['enable_confirm']) ? true : false,

'S_COPPA' => $coppa,

'S_HIDDEN_FIELDS' => $s_hidden_fields,

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

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

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

$messenger->assign_vars(array(

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

'U_USER_DETAILS' => generate_board_url() . "/memberlist.$phpEx?mode=viewprofile&u={$user_row['user_id']}",

meta_refresh(3, append_sid("{$phpbb_root_path}index.$phpEx"));

$message .= '<br /><br />' . sprintf($user->lang['RETURN_INDEX'], '<a href="' . append_sid("{$phpbb_root_path}index.$phpEx") . '">', '</a>');

trigger_error($message);

}