$this->set_sql_constraints($mode);

/**

* Perform additional actions before collecting data for attachment(s) deletion

*

);

extract($this->dispatcher->trigger_event('core.delete_attachments_collect_data_before', compact($vars)));

// Collect post and topic ids for later use if we need to touch remaining entries (if resync is enabled)

$this->collect_attachment_info($resync);

// Delete attachments from database

/**

* Perform additional actions after attachment(s) deletion from the database

);

extract($this->dispatcher->trigger_event('core.delete_attachments_from_database_after', compact($vars)));

if (!$this->num_deleted)

{

return 0;

}

// Delete attachments from filesystem

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

if (!$resync)

/**

* Delete attachments from database table

*/

{

/**

* Perform additional actions before attachment(s) deletion

*

);

extract($this->dispatcher->trigger_event('core.delete_attachments_before', compact($vars)));

// Delete attachments

$sql = 'DELETE FROM ' . ATTACHMENTS_TABLE . '

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

/**

* Delete attachments from filesystem

*/

{

$space_removed = $files_removed = 0;

}

}

/**

* Perform additional actions after attachment(s) deletion from the filesystem

*

);

extract($this->dispatcher->trigger_event('core.delete_attachments_from_filesystem_after', compact($vars)));

if ($space_removed || $files_removed)

{

$this->config->increment('upload_dir_size', $space_removed * (-1), false);

*/

public function resync($type, $ids)

{

{

return;

}

// Now only unset those ids remaining

$ids = array_diff($ids, $remaining_ids);

{

$sql = 'UPDATE ' . $this->resync_table . '

SET ' . $type . '_attachment = 0

// Make sure the image category only holds valid images...

$this->check_image($is_image);

{

$this->file->remove();

$this->file_data['error'] = array_merge($this->file_data['error'], $this->file->error);

// Verify bitstring length with options provided...

$renew = false;

// Specify comparing length (bitstring is padded to 31 bits)

$global_length = ($global_length % 31) ? ($global_length - ($global_length % 31) + 31) : $global_length;

$sql = 'SELECT forum_id

FROM ' . FORUMS_TABLE;

{

$sql .= ' WHERE ' . $db->sql_in_set('forum_id', array_keys($this->acl), true);

}

}

// If we get forum_ids not having this permission, we need to fill the remaining parts

{

foreach ($this->acl_forum_ids as $f)

{

{

$hold_str = '';

{

ksort($hold_ary);

@ldap_close($ldap);

{

return sprintf($this->user->lang['LDAP_NO_IDENTITY'], $this->user->data['username']);

}

$ldap_result = @ldap_get_entries($ldap, $search);

{

if (@ldap_bind($ldap, $ldap_result[0]['dn'], htmlspecialchars_decode($password)))

{

return $provider->login($username, $password);

}

$service_name_original = $this->request->variable('oauth_service', '', false);

$service_name = 'auth.provider.oauth.service.' . strtolower($service_name_original);

if ($service_name_original === '' || !array_key_exists($service_name, $this->service_providers))

'provider' => $service_name_original,

'oauth_provider_id' => $unique_id

);

$sql = 'SELECT user_id FROM ' . $this->auth_provider_oauth_token_account_assoc . '

WHERE ' . $this->db->sql_build_array('SELECT', $data);

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

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

$this->db->sql_freeresult($result);

if (!$row)

{

// The user does not yet exist, ask to link or create profile

'status' => LOGIN_SUCCESS_LINK_PROFILE,

'error_msg' => 'LOGIN_OAUTH_ACCOUNT_NOT_LINKED',

'user_row' => array(),

);

}

// Retrieve the user's account

FROM ' . $this->users_table . '

WHERE user_id = ' . (int) $row['user_id'];

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

throw new \Exception('AUTH_PROVIDER_OAUTH_ERROR_INVALID_ENTRY');

}

// Update token storage to store the user_id

$storage->set_user_id($row['user_id']);

/**

*

* @event core.auth_oauth_login_after

* @var array row User row

if ($credentials['key'] && $credentials['secret'])

{

$actual_name = str_replace('auth.provider.oauth.service.', '', $service_name);

$login_data['BLOCK_VARS'][$service_name] = array(

'REDIRECT_URL' => redirect($redirect_url, true),

'SERVICE_NAME' => $this->user->lang['AUTH_PROVIDER_OAUTH_SERVICE_' . strtoupper($actual_name)],

*/

protected function link_account_perform_link(array $data)

{

$sql = 'INSERT INTO ' . $this->auth_provider_oauth_token_account_assoc . '

' . $this->db->sql_build_array('INSERT', $data);

$this->db->sql_query($sql);

$oauth_user_ids = array();

{

foreach ($rows as $row)

{

'oauth_service' => $actual_name,

),

'SERVICE_NAME' => $this->user->lang['AUTH_PROVIDER_OAUTH_SERVICE_' . strtoupper($actual_name)],

'UNIQUE_ID' => (isset($oauth_user_ids[$actual_name])) ? $oauth_user_ids[$actual_name] : null,

);

AND user_id = " . (int) $user_id;

$this->db->sql_query($sql);

$service_name = 'auth.provider.oauth.service.' . strtolower($link_data['oauth_service']);

$storage = new \phpbb\auth\provider\oauth\token_storage($this->db, $this->user, $this->auth_provider_oauth_token_storage_table, $this->auth_provider_oauth_state_table);

$storage->clearToken($service_name);

* options with whatever configuraton values are passed to it as an array.

* It then returns the name of the acp file related to this authentication

* provider.

* the template file name and an array of the vars

* that the template needs that must conform to the

* following example:

$table_cols = isset($row['avatar_gallery_cols']) ? $row['avatar_gallery_cols'] : 4;

$row_count = $col_count = $avatar_pos = 0;

reset($avatar_list[$category]);

*/

protected function get_avatar_list($user)

{

if ($avatar_list === false)

{

if ($this->cache != null)

{

}

}

// Do not allow specifying the port (see RFC 3986) or IP addresses

// remote_upload() will do its own check for allowed filetypes

preg_match('#^(http|https|ftp)://(?:(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])\.){3}(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])#i', $url) ||

preg_match('#^(http|https|ftp)://(?:(?:(?:[\dA-F]{1,4}:){6}(?:[\dA-F]{1,4}:[\dA-F]{1,4}|(?:(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])\.){3}(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])))|(?:::(?:[\dA-F]{1,4}:){0,5}(?:[\dA-F]{1,4}(?::[\dA-F]{1,4})?|(?:(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])\.){3}(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])))|(?:(?:[\dA-F]{1,4}:):(?:[\dA-F]{1,4}:){4}(?:[\dA-F]{1,4}:[\dA-F]{1,4}|(?:(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])\.){3}(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])))|(?:(?:[\dA-F]{1,4}:){1,2}:(?:[\dA-F]{1,4}:){3}(?:[\dA-F]{1,4}:[\dA-F]{1,4}|(?:(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])\.){3}(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])))|(?:(?:[\dA-F]{1,4}:){1,3}:(?:[\dA-F]{1,4}:){2}(?:[\dA-F]{1,4}:[\dA-F]{1,4}|(?:(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])\.){3}(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])))|(?:(?:[\dA-F]{1,4}:){1,4}:(?:[\dA-F]{1,4}:)(?:[\dA-F]{1,4}:[\dA-F]{1,4}|(?:(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])\.){3}(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])))|(?:(?:[\dA-F]{1,4}:){1,5}:(?:[\dA-F]{1,4}:[\dA-F]{1,4}|(?:(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])\.){3}(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])))|(?:(?:[\dA-F]{1,4}:){1,6}:[\dA-F]{1,4})|(?:(?:[\dA-F]{1,4}:){1,7}:)|(?:::))#i', $url))

{

$file->clean_filename('avatar', $prefix, $row['id']);

// If there was an error during upload, then abort operation

{

$file->remove();

$error = $file->error;

*

* @event core.avatar_driver_upload_move_file_before

* @var array filedata Array containing uploaded file data

* @var string destination Destination directory where the file is going to be moved

* @var string prefix Prefix for the avatar filename

* @var array row Array with avatar row data

* @var array error Array of errors, if filled in by this event file will not be moved

* @since 3.1.6-RC1

* @changed 3.1.9-RC1 Added filedata

*/

$vars = array(

'filedata',

'destination',

'prefix',

'row',

unset($filedata);

{

// Move file and overwrite any existing image

$file->move_file($destination, true);

// If there was an error during move, then clean up leftovers

$error = array_merge($error, $file->error);

{

$file->remove();

return false;

);

extract($this->dispatcher->trigger_event('core.avatar_driver_upload_delete_before', compact($vars)));

{

try

{

protected $config;

/**

* Array that contains a list of enabled drivers

* @var array

*/

* Construct an avatar manager object

*

* @param \phpbb\config\config $config phpBB configuration

* @param array $avatar_drivers Avatar drivers passed via the service container

*/

{

$this->config = $config;

$this->register_avatar_drivers($avatar_drivers);

}

$config_name = $driver->get_config_name();

return array(

);

}

WHERE user_avatar = '" . $db->sql_escape($avatar_data['avatar']) . "'";

$db->sql_query($sql);

}

}

/**

*/

function purge()

{

parent::purge();

}

*/

function sql_fetchrow($query_id)

{

{

return $this->sql_rowset[$query_id][$this->sql_row_pointer[$query_id]++];

}

*/

function sql_fetchfield($query_id, $field)

{

{

return (isset($this->sql_rowset[$query_id][$this->sql_row_pointer[$query_id]][$field])) ? $this->sql_rowset[$query_id][$this->sql_row_pointer[$query_id]++][$field] : false;

}

*/

function sql_rowseek($rownum, $query_id)

{

{

return false;

}

if (file_exists($this->cache_dir . 'data_global.' . $phpEx))

{

{

$this->load();

}

}

else

{

{

$this->load();

}

function load()

{

// grab the global cache

{

return true;

}

}

else

{

{

$this->load();

}

// Store allowed extensions forum wise

if ($row['allow_group'])

{

}

if ($row['allow_in_pm'])

*/

function scale($vector, $length)

{

{

return array($vector[0] * $length, $vector[1] * $length);

}

if (is_array($resource))

{

$results = array();

{

$results = array_merge($results, $this->mono_range($resource[$i], $count, $include_original));

}

$noise_bitmaps = $this->captcha_noise_bg_bitmaps();

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

{

$noise[$i]->range();

//$box = $noise[$i]->dimensions($sizes[$i]);

'height' => 15,

'data' => array(

'1' => array(

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

}

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

{

$sql = 'DELETE FROM ' . CONFIRM_TABLE . '

WHERE ' . $db->sql_in_set('session_id', $sql_in);

return 'CAPTCHA_GD';

}

{

global $user, $template, $phpbb_log, $request;

global $config;

return '\\phpbb\\captcha\\gd_wave';

}

{

global $user;

return '\\phpbb\\captcha\\non_gd';

}

{

global $user;

{

var $confirm_id;

var $answer;

var $question_text;

var $question_lang;

var $question_strict;

$db->sql_freeresult($result);

// fallback to the board default lang

{

$this->question_lang = $config['default_lang'];

}

// final fallback to any language

{

$this->question_lang = '';

$sql = 'SELECT q.question_id, q.lang_iso

FROM ' . $this->table_captcha_questions . ' q, ' . $this->table_captcha_answers . ' a

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

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

}

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

{

$sql = 'DELETE FROM ' . $this->table_qa_confirm . '

WHERE ' . $db->sql_in_set('confirm_id', $sql_in);

$error = '';

{

/** @var \phpbb\log\log_interface $phpbb_log */

$phpbb_log->add('critical', $user->data['user_id'], $user->ip, 'LOG_ERROR_CAPTCHA', time(), array($user->lang('CONFIRM_QUESTION_MISSING')));

{

global $db, $user;

{

return;

}

{

global $db, $user;

{

return;

}

{

global $db, $user;

{

return false;

}

/**

* API function - The ACP backend, this marks the end of the easy methods

*/

{

global $config, $request, $phpbb_log, $template, $user;

/**

* This handles the list overview

*/

{

global $db, $template;

if (!isset($langs[$question_data['lang_iso']]) ||

!strlen($question_data['question_text']) ||

!is_array($question_data['answers']))

{

return false;

throw new \Exception('No generator class given.');

}

{

global $config, $template, $user, $phpbb_log, $request;

$io = new SymfonyStyle($input, $output);

$name = $input->getArgument('extension-name');

$extension = $this->manager->get_extension($name);

if (!$extension->is_enableable())

class delete extends \phpbb\console\command\command

{

/**

* @var \phpbb\db\driver\driver_interface

*/

protected $db;

/**

* Constructor

*

* @param \phpbb\user $user The user object (used to get language information)

* @param \phpbb\db\driver\driver_interface $db Database connection

* @param string $phpbb_root_path Root path

*/

{

$this->db = $db;

$this->phpbb_root_path = $phpbb_root_path;

$return = 0;

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

{

if (@unlink($thumbnail_path))

{

$thumbnail_deleted[] = $row['attach_id'];

{

$this->commit_changes($thumbnail_deleted);

$thumbnail_deleted = array();

class generate extends \phpbb\console\command\command

{

/**

* @var \phpbb\db\driver\driver_interface

*/

protected $db;

/**

* Constructor

*

* @param \phpbb\user $user The user object (used to get language information)

* @param \phpbb\db\driver\driver_interface $db Database connection

* @param \phpbb\cache\service $cache The cache service

* @param string $phpbb_root_path Root path

* @param string $php_ext PHP extension

*/

{

$this->db = $db;

$this->cache = $cache;

$this->phpbb_root_path = $phpbb_root_path;

{

if (isset($extensions[$row['extension']]['display_cat']) && $extensions[$row['extension']]['display_cat'] == ATTACHMENT_CATEGORY_IMAGE)

{

if (create_thumbnail($source, $destination, $row['mimetype']))

{

* Construct method

*

* @param \phpbb\language\language $language Language object

*/

{

$this->language = $language;

}

/**

$parameters = array_merge(array($original_exception->getMessage()), $original_exception->get_parameters());

$message = call_user_func_array(array($this->language, 'lang'), $parameters);

$event->setException($exception);

}

return (int) $data[$mode . '_approved'] + (int) $data[$mode . '_unapproved'] + (int) $data[$mode . '_softdeleted'];

}

/**

* Create topic/post visibility SQL for a given forum ID

*

if ($this->auth->acl_get('m_approve', $forum_id))

{

}

}

/**

*/

public function get_forums_visibility_sql($mode, $forum_ids = array(), $table_alias = '')

{

$get_forums_visibility_sql_overwrite = false;

/**

* Allow changing the result of calling get_forums_visibility_sql

*

* @event core.phpbb_content_visibility_get_forums_visibility_before

* @var string mode Either "topic" or "post" depending on the query this is being used in

* @var array forum_ids Array of forum ids which the posts/topics are limited to

* @var string table_alias Table alias to prefix in SQL queries

return $get_forums_visibility_sql_overwrite;

}

$where_sql .= '(' . $table_alias . $mode . '_visibility = ' . ITEM_APPROVED . '

}

/**

* Allow changing the result of calling get_global_visibility_sql

*

* @event core.phpbb_content_visibility_get_global_visibility_before

* @var string mode Either "topic" or "post" depending on the query this is being used in

* @var array exclude_forum_ids Array of forum ids the current user doesn't have access to

* @var string table_alias Table alias to prefix in SQL queries

* @var array approve_forums Array of forums where the user has m_approve permissions

* @since 3.1.3-RC1

*/

$vars = array(

return $visibility_sql_overwrite;

}

{

$where_sqls[] = $this->db->sql_in_set($table_alias . 'forum_id', $approve_forums);

}

}

/**

* @var int topic_id Topic of the post IDs to be modified.

* @var int forum_id Forum ID that the topic_id resides in.

* @var int user_id User ID doing this action.

* @var string reason Reason specified by the user for this change.

* @var bool is_starter Are we changing the topic's starter?

* @var bool is_latest Are we changing the topic's latest post?

* @var array data The data array for this action.

* @since 3.1.10-RC1

*/

$vars = array(

'visibility',

'topic_id',

'forum_id',

'user_id',

'reason',

'is_starter',

'is_latest',

$sql_ary[$recipient_field] = " + $count_increase";

}

{

$forum_sql = array();

* @var int topic_id Topic of the post IDs to be modified.

* @var int forum_id Forum ID that the topic_id resides in.

* @var int user_id User ID doing this action.

* @var string reason Reason specified by the user for this change.

* @var bool is_starter Are we changing the topic's starter?

* @var bool is_latest Are we changing the topic's latest post?

* @var array data The data array for this action.

* @since 3.1.10-RC1

*/

$vars = array(

'visibility',

'topic_id',

'forum_id',

'user_id',

'reason',

'is_starter',

'is_latest',

* @var int topic_id Topic of the post IDs to be modified.

* @var int forum_id Forum ID that the topic_id resides in.

* @var int user_id User ID doing this action.

* @var string reason Reason specified by the user for this change.

* @var bool force_update_all Force an update on all posts within the topic, regardless of their current approval state.

* @var array data The data array for this action.

* @since 3.1.10-RC1

*/

$vars = array(

'visibility',

'topic_id',

'forum_id',

'user_id',

'reason',

'force_update_all',

'data',

* @var int topic_id Topic of the post IDs to be modified.

* @var int forum_id Forum ID that the topic_id resides in.

* @var int user_id User ID doing this action.

* @var string reason Reason specified by the user for this change.

* @var bool force_update_all Force an update on all posts within the topic, regardless of their current approval state.

* @var array data The data array for this action.

* @since 3.1.10-RC1

*/

$vars = array(

'visibility',

'topic_id',

'forum_id',

'user_id',

'reason',

'force_update_all',

'data',

include($this->phpbb_root_path . 'includes/functions_admin.' . $this->php_ext);

}

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

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

{

{

{

}

}

$this->db->sql_freeresult($result);

public function format($format = '', $force_absolute = false)

{

$format = $format ? $format : $this->user->date_format;

$format = self::format_cache($format, $this->user);

$relative = ($format['is_short'] && !$force_absolute);

$now = new self($this->user, 'now', $this->user->timezone);

*/

function sql_in_set($field, $array, $negate = false, $allow_empty_set = false)

{

{

if (!$allow_empty_set)

{

}

}

{

@reset($array);

$var = current($array);

*/

function sql_multi_insert($table, $sql_ary)

{

{

return false;

}

// We run the following code to determine if we need to re-order the table array. ;)

// The reason for this is that for multi-aliased tables (two equal tables) in the FROM statement the last table need to match the first comparison.

// DBMS who rely on this: Oracle, PostgreSQL and MSSQL. For all other DBMS it makes absolutely no difference in which order the table is.

{

// Take first LEFT JOIN

$join = current($array['LEFT_JOIN']);

default:

{

case 3:

// Subquery with {left hand} {operator} {compare kind} {SELECT Kind } {Sub Query}

break;

$html_table = func_get_arg(2);

$row = func_get_arg(3);

{

$html_table = true;

$this->html_hold .= '<table cellspacing="1"><tr>';

}

/**

* Build db-specific query data

* @access private

*/

$this->db_connect_id = sqlsrv_connect($this->server, array(

'Database' => $this->dbname,

'UID' => $this->user,

));

return ($this->db_connect_id) ? $this->db_connect_id : $this->sql_error('');

unset($row['line2'], $row['line3']);

}

}

}

/**

*/

function _rewrite_col_compare($args)

{

{

if ($args[2] == '=')

{

and/or need the db restore script, uncomment this.

{

// Try to replace some common data we know is from our restore script or from other sources

$regs[3] = str_replace("'||chr(47)||'", '/', $regs[3]);

if ($string)

{

// New value if cols != value

}

$vals = array(0 => $vals);

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

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

{

{

$sql_data .= "ALTER TABLE [$table_name] WITH NOCHECK ADD\n";

$sql_data .= "\tCONSTRAINT [{$row['CONSTRAINT_NAME']}] PRIMARY KEY CLUSTERED \n\t(\n";

}

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

}

{

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

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

}

$this->db->sql_freeresult($result);

{

$rows[] = " CONSTRAINT {$constraint_name} PRIMARY KEY (" . implode(', ', $primary_key) . ')';

}

}

$this->db->sql_freeresult($result);

{

$rows[] = " CONSTRAINT {$constraint_name} UNIQUE (" . implode(', ', $unique) . ')';

}

'ACP_BOARD_CONFIGURATION',

array(

'module_basename' => 'acp_board',

),

)),

array('module.add', array(

'ACP_CAT_USERS',

array(

'module_basename' => 'acp_users',

),

)),

array('module.add', array(

'ACP_SERVER_CONFIGURATION',

array(

'module_basename' => 'acp_send_statistics',

),

)),

array('module.add', array(

'ACP_FORUM_BASED_PERMISSIONS',

array(

'module_basename' => 'acp_permissions',

),

)),

array('module.add', array(

'MCP_REPORTS',

array(

'module_basename' => 'mcp_pm_reports',

),

)),

array('custom', array(array(&$this, 'add_newly_registered_group'))),

'ACP_MESSAGES',

array(

'module_basename' => 'acp_board',

),

)),

array('config.add', array('load_unreads_search', 1)),

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

$extension_groups_updated = array();

{

// The language strings we need are either in language/.../acp/attachments.php

// in the update package if we're updating to 3.0.8-RC1 or later,

{

public function effectively_installed()

{

}

public function update_schema()

'UCP_PROFILE',

array(

'module_basename' => 'ucp_auth_link',

),

)),

);

'ACP_BOARD_CONFIGURATION',

array(

'module_basename' => 'acp_contact',

),

)),

);

'ACP_GROUPS',

array(

'module_basename' => 'acp_groups',

),

)),

array('module.add', array(

'ACP_ATTACHMENTS',

array(

'module_basename' => 'acp_attachments',

),

)),

array('module.add', array(

'ACP_STYLE_MANAGEMENT',

array(

'module_basename' => 'acp_styles',

),

)),

array('module.add', array(

'UCP_PROFILE',

array(

'module_basename' => 'ucp_profile',

),

)),

// Module will be renamed later

'ACP_EXTENSION_MANAGEMENT',

array(

'module_basename' => 'acp_extensions',

),

)),

array('permission.add', array('a_extensions', true, 'a_styles')),

'UCP_MAIN',

array(

'module_basename' => 'ucp_notifications',

),

)),

array('module.add', array(

'UCP_PREFS',

array(

'module_basename' => 'ucp_notifications',

),

)),

array('config.add', array('load_notifications', 1)),

'MCP_QUEUE',

array(

'module_basename' => 'mcp_queue',

),

)),

array('module.add', array(

'MCP_QUEUE',

array(

'module_basename' => 'mcp_queue',

),

)),

);

}

// Remove old entries from styles table

{

// No valid styles: remove everything and add prosilver

$this->sql_query('DELETE FROM ' . STYLES_TABLE);

FROM ' . STYLES_TABLE . "

WHERE style_name = 'prosilver'";

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

$this->db->sql_freeresult($result);

$this->config->set('default_style', $default_style);

$this->sql_query($sql);

}

else

}

// Reset styles for users

}

}

}

$teampage_entries[] = array(

'group_id' => (int) $row['group_id'],

'teampage_name' => '',

'teampage_parent' => 0,

);

}

$this->db->sql_freeresult($result);

{

$this->db->sql_multi_insert(TEAMPAGE_TABLE, $teampage_entries);

}

return array(

array('config.add', array('help_send_statistics', true)),

array('config.add', array('help_send_statistics_time', 0)),

array('module.add', array(

'acp',

'ACP_SERVER_CONFIGURATION',

array(

'module_basename' => 'acp_help_phpbb',

),

)),

);

class remove_outdated_media extends \phpbb\db\migration\migration

{

protected $cat_id = array(

);

static public function depends_on()

WHERE ' . $this->db->sql_in_set('group_id', $group_ids);

}

// delete the now empty, outdated media extension groups

$sql = 'DELETE FROM ' . EXTENSION_GROUPS_TABLE . '

WHERE ' . $this->db->sql_in_set('group_id', $group_ids);

}

}

static public function depends_on()

{

return array(

'\phpbb\db\migration\data\v32x\v321rc1',

);

case 'remove':

$call = 'add';

{

$arguments[] = '';

}

case 'remove':

$call = 'add';

{

$arguments[] = '';

}

* Use false to ignore the parent check and check class wide.

* @param int|string $module The module_id|module_langname you would like to

* check for to see if it exists

*/

{

// the main root directory should return true

if (!$module)

return true;

}

if ($parent !== false)

{

{

return false;

}

}

{

}

}

/**

$data = array('module_langname' => $data);

}

if (!isset($data['module_langname']))

{

);

// Run the "manual" way with the data we've collected.

}

}

return;

}

{

{

FROM ' . $this->modules_table . "

WHERE module_class = '" . $this->db->sql_escape($class) . "'

AND parent_id = " . (int) $parent . "

SET left_id = left_id + 2, right_id = right_id + 2

WHERE module_class = '" . $this->db->sql_escape($class) . "'

AND left_id >= $to_left

AND left_id < {$module_data['left_id']}";

SET left_id = $to_left, right_id = " . ($to_left + 1) . "

WHERE module_class = '" . $this->db->sql_escape($class) . "'

AND module_id = {$module_data['module_id']}";

FROM ' . $this->modules_table . "

WHERE module_class = '" . $this->db->sql_escape($class) . "'

AND parent_id = " . (int) $parent . "

SET left_id = left_id + 2, right_id = right_id + 2

WHERE module_class = '" . $this->db->sql_escape($class) . "'

AND left_id >= $to_right

AND left_id < {$module_data['left_id']}";

SET left_id = ' . ($to_right + 1) . ', right_id = ' . ($to_right + 2) . "

WHERE module_class = '" . $this->db->sql_escape($class) . "'

AND module_id = {$module_data['module_id']}";

}

}

// Clear the Modules Cache

}

/**

}

else

{

{

return;

}

$parent_sql = '';

if ($parent !== false)

{

}

$module_ids = array();

$this->module_manager->delete_module($module_id, $class);

}

}

}

* @param string|int $parent_id The parent module_id|module_langname

* @param int|string|array $data The module_id, module_langname for existance checking or module data array for adding

* @param bool $throw_exception The flag indicating if exception should be thrown on error

* @throws \phpbb\db\migration\exception

*/

public function get_parent_module_id($parent_id, $data = '', $throw_exception = true)

{

// Allow '' to be sent as 0

$parent_id = $parent_id ?: 0;

if (!is_numeric($parent_id))

{

// Refresh the $module_categories array

// Search for the parent module_langname

$ids = array_keys($this->module_categories, $parent_id);

{

// No parent with the given module_langname exist

case 0:

break;

// Return the module id

case 1:

break;

default:

break;

}

}

return $parent_id;

}

}

}

);

{

return $this->permission_set($role_name, $auth_option, 'role', $has_permission);

}

*/

protected function process_data_step($steps, $state, $revert = false)

{

{

return true;

}

// Result will be null or true if everything completed correctly

// Stop after each update step, to let the updater control the script runtime

$result = $this->run_step($steps[$step], $last_result, $revert);

{

return array(

'result' => $result,

$condition = $parameters[0];

{

return false;

}

// Flush buffer if it is full or when DB does not support multi inserts.

// In the later case, the buffer will always only contain one row.

{

return $this->flush();

}

* Inserts a row set, i.e. an array of rows, by calling insert().

*

* Please note that it is in most cases better to use insert() instead of

* small.

*

* @param array $rows

'STEXT' => '[varchar] (3000)',

'TEXT' => '[varchar] (8000)',

'MTEXT' => '[text]',

'TIMESTAMP' => '[int]',

'DECIMAL' => '[float]',

'DECIMAL:' => '[float]',

'PDECIMAL' => '[float]',

'PDECIMAL:' => '[float]',

'VARBINARY' => '[varchar] (255)',

),

'STEXT' => '[varchar] (3000)',

'TEXT' => '[varchar] (8000)',

'MTEXT' => '[text]',

'TIMESTAMP' => '[int]',

'DECIMAL' => '[float]',

'DECIMAL:' => '[float]',

'PDECIMAL' => '[float]',

'PDECIMAL:' => '[float]',

'VARBINARY' => '[varchar] (255)',

),

);

{

$result = $this->sql_index_drop($table_name, $index_name);

$statements = array_merge($statements, $result);

{

// Remove this column from the index and recreate it

$recreate_indexes[$index_name] = array_diff($index_data, array($column_name));

}

}

// Drop default value constraint

$result = $this->mssql_get_drop_default_constraints_queries($table_name, $column_name);

$statements = array_merge($statements, $result);

{

$statements = array();

// remove index length

$column = preg_replace('#:.*$#', '', $column);

}

/**

* {@inheritDoc}

*/

function sql_list_index($table_name)

}

/**

* Checks to see if column is an identity column

*

* Identity columns cannot have defaults set for them.

{

foreach ($indexes as $index_name)

{

{

continue;

}

*/

protected function check_index_name_length($table_name, $index_name, $throw_error = true)

{

{

// Try removing the table prefix if it's at the beginning

$table_prefix = substr(CONFIG_TABLE, 0, -6); // strlen(config)

if ($throw_error)

{

}

}

}

/**

* {@inheritDoc}

*/

function sql_list_index($table_name)

class error_handler extends ErrorHandler

{

{

if ($type === E_USER_WARNING || $type === E_USER_NOTICE)

{

$handler($type, $message, $file, $line);

}

}

}

{

if ($this->use_extensions)

{

require($this->get_autoload_filename());

}

return $event;

}

}

/**

$this->validate_events_from_file($file_name, $this->crawl_file_for_events($file_name));

}

}

/**

}

}

}

/**

list($event_name, $details) = explode("\n===\n", $event, 2);

$this->validate_event_name($event_name);

$this->current_event = $event_name;

if (isset($this->events[$this->current_event]))

throw new \LogicException("The event '{$this->current_event}' is defined multiple times");

}

if (($this->filter == 'adm' && strpos($this->current_event, 'acp_') !== 0)

|| ($this->filter == 'styles' && strpos($this->current_event, 'acp_') === 0))

{

);

}

}

/**

$files = explode("\n + ", $file_details);

foreach ($files as $file)

{

if (!file_exists($this->path . $file) || substr($file, -5) !== '.html')

{

}

if (($this->filter !== 'adm') && strpos($file, 'styles/prosilver/template/') === 0)

}

else

{

}

$this->events_by_file[$file][] = $this->current_event;

}

else

{

}

return $files_list;

$event_list = array();

$file_content = file_get_contents($this->path . $file);

}

/**

}

ksort($this->events);

}

/**

$content = file_get_contents($this->path . $this->current_file);

$num_events_found = 0;

{

$this->set_content(explode("\n", $content));

{

$event_line = false;

$arguments = array();

if ($found_trigger_event !== false)

{

}

else

{

if ($found_dispatch !== false)

{

$event_line = $i;

// Find event description line

$description_line_num = $this->find_description();

if (isset($this->events[$this->current_event]))

{

if ($is_dispatch)

{

}

else

{

}

$match = array();

public function get_vars_from_array()

{

$line = ltrim($this->file_lines[$this->current_event_line - 1], "\t");

{

$vars_array = $this->get_vars_from_multi_line_array();

}

foreach ($vars_array as $var)

{

{

throw new \LogicException("Found invalid var '{$var}' in array for event '{$this->current_event}' in file '{$this->current_file}:{$this->current_event_line}'", 3);

}

public function get_vars_from_single_line_array($line, $throw_multiline = true)

{

$match = array();

{

{

throw new \LogicException('Should use multiple lines for $vars definition '

. "for event '{$this->current_event}' in file '{$this->current_file}:{$this->current_event_line}'", 2);

{

$current_vars_line = 2;

$var_lines = array();

{

$var_lines[] = substr(trim($this->file_lines[$this->current_event_line - $current_vars_line]), 0, -1);

if (strpos($var_line, '* @var ') === 0)

{

$doc_line = explode(' ', $var_line, 5);

{

throw new \LogicException("Found invalid line '{$this->file_lines[$this->current_event_line - $current_doc_line]}' "

. "for event '{$this->current_event}' in file '{$this->current_file}:{$this->current_event_line}'", 1);

foreach ($doc_vars as $var)

{

{

throw new \LogicException("Found invalid @var '{$var}' in docblock for event "

. "'{$this->current_event}' in file '{$this->current_file}:{$this->current_event_line}'", 4);

{

$vars_array = array_unique($vars_array);

$vars_docblock = array_unique($vars_docblock);

{

throw new \LogicException("\$vars array does not match the list of '@var' tags for event "

. "'{$this->current_event}' in file '{$this->current_file}:{$this->current_event_line}'");

namespace phpbb\feed;

/**

* Class with some helpful functions used in feeds

*/

class helper

{

protected $config;

/**

* Constructor

*

*/

{

$this->config = $config;

$this->user = $user;

}

/**

*/

public function get_board_url()

{

return '';

}

// Remove "Select all" link and mouse events

$content = str_replace('<a href="#" onclick="selectCode(this); return false;">' . $this->user->lang['SELECT_ALL_CODE'] . '</a>', '', $content);

$content .= implode('<br />', $post_attachments);

// Convert attachments' relative path to absolute path

}

// Remove Comments from inline attachments [ia]

$this->error_number = 0;

$this->error_string = '';

{

@fputs($socket, "GET $directory/$filename HTTP/1.0\r\n");

@fputs($socket, "HOST: $host\r\n");

*/

public function set_upload_ary($upload_ary)

{

{

return $this;

}

*/

public function move_file($destination, $overwrite = false, $skip_image_check = false, $chmod = false)

{

{

return false;

}

// Remove temporary filename

@unlink($this->filename);

{

return false;

}

// PHP Upload file size check

$file = $this->check_upload_size($file);

{

return $file;

}

// PHP Upload file size check

$file = $this->check_upload_size($file);

{

return $file;

}

*

* @param filespec $file Instance of filespec class

*/

{

// Filesize is too big or it's 0 if it was larger than the maxsize in the upload form

if ($this->max_filesize && ($file->get('filesize') > $this->max_filesize || $file->get('filesize') == 0))

*

* @return bool True if extension is allowed, false if not

*/

{

return (in_array($file->get('extension'), $this->allowed_extensions)) ? true : false;

}

* @return bool True if dimensions are valid or no constraints set, false

* if not

*/

{

if (!$this->max_width && !$this->max_height && !$this->min_width && !$this->min_height)

{

*

* @return bool True if content is valid, false if not

*/

{

return ($file->check_content($this->disallowed_content));

}

continue;

}

{

array_pop($filtered);

}

$common_php_group = @filegroup(__FILE__);

// And the owner and the groups PHP is running under.

$php_gids = (function_exists('posix_getgroups')) ? @posix_getgroups() : false;

// If we are unable to get owner/group, then do not try to set them by guessing

else if (function_exists('debug_backtrace'))

{

$call_stack = debug_backtrace(0);

}

else

{

//$dir_parts = explode(DIRECTORY_SEPARATOR, __DIR__);

//$namespace_parts = explode('\\', trim(__NAMESPACE__, '\\'));

// Check if we still loading from root

//if (array_slice($dir_parts, -$namespace_part_count) === $namespace_parts)

array_pop($resolved);

$resolved_path = false;

}

{

array_pop($resolved);

$resolved_path = false;

namespace phpbb\group;

class helper

{

protected $language;

/**

* Constructor

*

*/

{

$this->language = $language;

}

/**

{

return $this->language->is_set('G_' . utf8_strtoupper($group_name)) ? $this->language->lang('G_' . utf8_strtoupper($group_name)) : $group_name;

}

}

fwrite($fp, $file_content);

fclose($fp);

}

/**

'LABEL' => 'Oracle',

'SCHEMA' => 'oracle',

'MODULE' => 'oci8',

'DRIVER' => 'phpbb\db\driver\oracle',

'AVAILABLE' => true,

'2.0.x' => false,

// Check if SQLite database is writable

if ($dbms_info['SCHEMA'] === 'sqlite'

{

$errors[] = array(

'title' =>'INST_ERR_DB_NO_WRITABLE',

$tables = array_map('strtolower', $tables);

$table_intersect = array_intersect($tables, $table_ary);

{

$errors[] = array(

'title' => 'INST_ERR_PREFIX',

$tpl_ary['KEY'] = $input_name;

$tpl_ary['S_EXPLAIN'] = false;

$tpl_ary['DISABLED'] = isset($input_options['disabled']) ? $input_options['disabled'] : false;

if (isset($input_options['default']))

{

if (in_array($input_options['type'], array('select', 'radio'), true))

{

{

if (isset($input_options['options'][$i]['label']))

{

$this->template->assign_block_vars($block_name, $tpl_ary);

}

$this->template->assign_var('S_NOT_ONLY_BUTTON_FORM', $not_button_form);

if (!$not_button_form)

*/

public function set_active_stage_menu($menu_path)

{

$this->send_response();

}

*/

public function set_finished_stage_menu($menu_path)

{

$this->send_response();

}

$this->install_config->set('add_bot_index', $i);

{

throw new resource_limit_reached_exception();

}

$this->db->sql_return_on_error(true);

$module_classes = array('acp', 'mcp', 'ucp');

$i = $this->config->get('module_class_index', 0);

$module_classes = array_slice($module_classes, $i);

VALUES ('default_lang', '" . $this->db->sql_escape($this->install_config->get('default_lang')) . "')",

'UPDATE ' . $this->config_table . "

SET config_value = '" . $this->db->sql_escape($this->install_config->get('server_name')) . "'

WHERE config_name = 'server_name'",

}

$i = $this->install_config->get('add_config_settings_index', 0);

$sql_ary = array_slice($sql_ary, $i);

foreach ($sql_ary as $sql)

$sql_query = $this->database_helper->split_sql_file($sql_query, $dbms_info[$dbms]['DELIM']);

$i = $this->config->get('add_default_data_index', 0);

$sql_query = array_slice($sql_query, $i);

foreach ($sql_query as $sql)

$db_table_schema = @file_get_contents($this->schema_file_path);

$db_table_schema = json_decode($db_table_schema, true);

$i = $this->config->get('add_table_index', 0);

$db_table_schema = array_slice($db_table_schema, $i);

$this->install_config->set('install_extensions_index', $i);

{

throw new resource_limit_reached_exception();

}

$dbms = $this->io_handler->get_input('dbms', '');

$dbhost = $this->io_handler->get_input('dbhost', '', true);

$dbport = $this->io_handler->get_input('dbport', '');

// Check database data

$user_data_vaild = $this->check_database_data($dbms, $dbhost, $dbport, $dbuser, $dbpasswd, $dbname, $table_prefix);

// E-mail data

$email_enable = $this->io_handler->get_input('email_enable', true);

$smtp_delivery = $this->io_handler->get_input('smtp_delivery', '');

$smtp_port = $this->io_handler->get_input('smtp_port', '');

$smtp_auth = $this->io_handler->get_input('smtp_auth', '');

$auth_methods = array('PLAIN', 'LOGIN', 'CRAM-MD5', 'DIGEST-MD5', 'POP-BEFORE-SMTP');

$cookie_secure = $this->io_handler->get_input('cookie_secure', $cookie_secure);

$server_protocol = $this->io_handler->get_input('server_protocol', $server_protocol);

$force_server_vars = $this->io_handler->get_input('force_server_vars', 0);

$server_port = $this->io_handler->get_input('server_port', $server_port);

// Clean up script path

if ($script_path !== '/')

$method = $methods[0];

}

$ftp_port = $this->iohandler->get_input('ftp_port', 21);

$ftp_time = $this->iohandler->get_input('ftp_timeout', 10);

// Check for a valid update directory

if (!$this->filesystem->exists($update_files) || !$this->filesystem->is_readable($update_files))

{

// If there are no update files, we can't check the version etc

// However, we can let the users run migrations if they really want to...

$this->install_config->set('update_extensions_index', $i);

{

throw new resource_limit_reached_exception();

}

$old_path = $this->update_helper->get_path_to_old_update_files();

$new_path = $this->update_helper->get_path_to_new_update_files();

// Set progress bar

$this->iohandler->set_task_count(count($files_to_diff), true);

{

$file_contents[] = file_get_contents($file_to_diff);

{

$this->iohandler->add_error_message(array('FILE_DIFFER_ERROR_FILE_CANNOT_BE_READ', $files_to_diff));

unset($file_contents);

}

$diff = new \diff3($file_contents[0], $file_contents[1], $file_contents[2]);

// Handle conflicts

if ($diff->get_num_conflicts() !== 0)

$merge_conflicts[] = $filename;

}

unset($diff);

}

else

$this->installer_config->set('merge_conflict_list', $merge_conflicts);

$this->installer_config->set('file_diff_update_count', $progress_count);

// Request refresh

throw new resource_limit_reached_exception();

}

$this->iohandler->finish_progress('ALL_FILES_DIFFED');

$this->installer_config->set('merge_conflict_list', $merge_conflicts);

}

/**

{

$file_update_info = $this->installer_config->get('update_files', array());

{

// Render download box

$this->iohandler->add_download_link(

// Add form to continue update

$this->iohandler->add_user_form_group('UPDATE_CONTINUE_UPDATE_PROCESS', array(

'update_recheck_files_submit' => array(

),

'database_update_submit' => array(

'label' => 'UPDATE_CONTINUE_UPDATE_PROCESS',

'type' => 'submit',

),

));

// Replace key with language entry and simply pass along...

return vsprintf($lang, $args);

}

{

// If the language entry is an empty array, we just return the language key

return $key;

$key_found = false;

// We now get the first number passed and will select the key based upon this number

{

if (is_int($args[$i]) || is_float($args[$i]))

{

// the first directory from the path (that should be the language directory)

$path_diff_parts = explode('/', $path_diff);

{

array_shift($path_diff_parts);

$component = implode('/', $path_diff_parts) . '/';

{

$sql_where .= ' AND ';

{

$sql_where .= $field . ' ' . $field_value[0] . ' ' . $field_value[1];

}

}

}

{

}

$lang_arguments = array_merge(array($log[$i]['action']), $log_data_ary);

$vars = array('log', 'topic_id_list', 'reportee_id_list');

extract($this->dispatcher->trigger_event('core.get_logs_get_additional_data', compact($vars)));

{

$topic_auth = $this->get_topic_auth($topic_id_list);

}

}

{

$reportee_data_list = $this->get_reportee_data($reportee_id_list);

$keywords_pattern = array();

// Build pattern and keywords...

{

$keywords_pattern[] = preg_quote($keywords[$i], '#');

$keywords[$i] = $this->db->sql_like_expression($this->db->get_any_char() . $keywords[$i] . $this->db->get_any_char());

$forum_auth['f_read'][$row['topic_id']] = $row['forum_id'];

}

if ($this->auth->acl_gets('a_', 'm_', $row['forum_id']))

{

$forum_auth['m_'][$row['topic_id']] = $row['forum_id'];

/** @var \phpbb\config\db_text */

protected $config_text;

/** @var string */

protected $subject;

/** @var string */

* @param \phpbb\config\db_text $config_text

* @param \phpbb\db\driver\driver_interface $db

* @param \phpbb\user $user

* @param string $phpbb_root_path

* @param string $phpEx

*/

{

parent::__construct($auth, $config, $db, $user, $phpbb_root_path, $phpEx);

$this->config_text = $config_text;

}

/**

$this->errors[] = $this->user->lang['EMPTY_MESSAGE_EMAIL'];

}

if ($this->user->data['is_registered'])

{

$this->message->set_sender_from_user($this->user);

$this->errors[] = 'FORM_INVALID';

}

{

$sql = 'UPDATE ' . USERS_TABLE . '

SET user_emailtime = ' . time() . '

add_form_key('memberlist_email');

$template->assign_vars(array(

));

}

}

*/

public function cc_sender()

{

{

trigger_error('No email recipients specified');

}

*/

public function send(\messenger $messenger, $contact)

{

{

return;

}

'MESSAGE' => htmlspecialchars_decode($this->body))

);

{

$messenger->assign_vars($this->template_vars);

}

// we're turning a category into a module

$branch = $this->get_module_branch($module_data['module_id'], $module_data['module_class'], 'children', false);

{

throw new module_not_found_exception('NO_CATEGORY_TO_MODULE');

}

}

$from_data = $moved_modules[0];

$moved_ids = array();

{

$moved_ids[] = $moved_modules[$i]['module_id'];

}

$branch = $this->get_module_branch($module_id, $module_class, 'children', false);

{

throw new module_exception('CANNOT_REMOVE_MODULE');

}

}

$this->db->sql_freeresult($result);

{

// The module is already on top or bottom

throw new module_not_found_exception();

}

}

{

return;

}

*/

public function get_notification_type_id($notification_type_name)

{

{