+ case 'manage':

+ $l_title = 'ACP_MANAGE_ATTACHMENTS';

+ break;

+

+

+ case 'manage':

+

+ if ($submit)

+ {

+ $delete_files = (isset($_POST['delete'])) ? array_keys(request_var('delete', array('' => 0))) : array();

+

+ if (sizeof($delete_files))

+ {

+ // Select those attachments we want to delete...

+ $sql = 'SELECT real_filename

+ FROM ' . ATTACHMENTS_TABLE . '

+ WHERE ' . $db->sql_in_set('attach_id', $delete_files) . '

+ AND is_orphan = 0';

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

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

+ {

+ $deleted_filenames[] = $row['real_filename'];

+ }

+ $db->sql_freeresult($result);

+

+ if ($num_deleted = delete_attachments('attach', $delete_files))

+ {

+ if (sizeof($delete_files) != $num_deleted)

+ {

+ $error[] = $user->lang['FILES_GONE'];

+ }

+ add_log('admin', 'LOG_ATTACHMENTS_DELETED', implode(', ', $deleted_filenames));

+ $notify[] = sprintf($user->lang['LOG_ATTACHMENTS_DELETED'], implode(', ', $deleted_filenames));

+ }

+ else

+ {

+ $error[] = $user->lang['NO_FILES_TO_DELETE'];

+ }

+ }

+ }

+

+ $template->assign_vars(array(

+ 'S_MANAGE' => true)

+ );

+

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

+

+ // Sort keys

+ $sort_days = request_var('st', 0);

+ $sort_key = request_var('sk', 't');

+ $sort_dir = request_var('sd', 'd');

+

+ // Sorting

+ $limit_days = array(0 => $user->lang['ALL_ENTRIES'], 1 => $user->lang['1_DAY'], 7 => $user->lang['7_DAYS'], 14 => $user->lang['2_WEEKS'], 30 => $user->lang['1_MONTH'], 90 => $user->lang['3_MONTHS'], 180 => $user->lang['6_MONTHS'], 365 => $user->lang['1_YEAR']);

+ $sort_by_text = array('f' => $user->lang['FILENAME'], 't' => $user->lang['FILEDATE'], 's' => $user->lang['FILESIZE'], 'x' => $user->lang['EXTENSION'], 'd' => $user->lang['DOWNLOADS'],'p' => $user->lang['ATTACH_POST_TYPE'], 'u' => $user->lang['AUTHOR']);

+ $sort_by_sql = array('f' => 'a.real_filename', 't' => 'a.filetime', 's' => 'a.filesize', 'x' => 'a.extension', 'd' => 'a.download_count', 'p' => 'a.in_message', 'u' => 'u.username');

+

+ $s_limit_days = $s_sort_key = $s_sort_dir = $u_sort_param = '';

+ gen_sort_selects($limit_days, $sort_by_text, $sort_days, $sort_key, $sort_dir, $s_limit_days, $s_sort_key, $s_sort_dir, $u_sort_param);

+

+ $min_filetime = ($sort_days) ? (time() - ($sort_days * 86400)) : '';

+ $limit_filetime = ($min_filetime) ? " AND a.filetime >= $min_filetime " : '';

+ $start = ($sort_days && isset($_POST['sort'])) ? 0 : $start;

+

+ $attachments_per_page = (int) $config['topics_per_page'];

+

+ // Handle files stats resync

+ $action = request_var('action', '');

+ $resync_files_stats = false;

+ if ($action && $action = 'stats')

+ {

+ if (!confirm_box(true))

+ {

+ confirm_box(false, $user->lang['RESYNC_FILES_STATS_CONFIRM'], build_hidden_fields(array(

+ 'i' => $id,

+ 'mode' => $mode,

+ 'action' => $action,

+ )));

+ }

+ else

+ {

+ $resync_files_stats = true;

+ add_log('admin', 'LOG_RESYNC_FILES_STATS');

+ }

+ }

+

+ // Check if files stats are accurate

+ $sql = 'SELECT COUNT(attach_id) as num_files

+ FROM ' . ATTACHMENTS_TABLE . '

+ WHERE is_orphan = 0';

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

+ $num_files_real = (int) $db->sql_fetchfield('num_files');

+ if ($resync_files_stats === true)

+ {

+ set_config('num_files', $num_files_real, true);

+ }

+ $db->sql_freeresult($result);

+

+ $sql = 'SELECT SUM(filesize) as upload_dir_size

+ FROM ' . ATTACHMENTS_TABLE . '

+ WHERE is_orphan = 0';

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

+ $total_size_real = (float) $db->sql_fetchfield('upload_dir_size');

+ if ($resync_files_stats === true)

+ {

+ set_config('upload_dir_size', $total_size_real, true);

+ }

+ $db->sql_freeresult($result);

+

+ // Get current files stats

+ $num_files = (int) $config['num_files'];

+ $total_size = (float) $config['upload_dir_size'];

+

+ // Issue warning message if files stats are inaccurate

+ if (($num_files != $num_files_real) || ($total_size != $total_size_real))

+ {

+ $error[] = sprintf($user->lang['FILES_STATS_WRONG'], $num_files_real, get_formatted_filesize($total_size_real));

+

+ $template->assign_vars(array(

+ 'S_ACTION_OPTIONS' => ($auth->acl_get('a_board')) ? true : false,

+ 'U_ACTION' => $this->u_action,)

+ );

+ }

+

+ // Make sure $start is set to the last page if it exceeds the amount

+ if ($start < 0 || $start > $num_files)

+ {

+ $start = ($start < 0) ? 0 : floor(($num_files - 1) / $attachments_per_page) * $attachments_per_page;

+ }

+

+ // If the user is trying to reach the second half of the attachments list, fetch it starting from the end

+ $store_reverse = false;

+ $sql_limit = $attachments_per_page;

+

+ if ($start > $num_files / 2)

+ {

+ $store_reverse = true;

+

+ if ($start + $attachments_per_page > $num_files)

+ {

+ $sql_limit = min($attachments_per_page, max(1, $num_files - $start));

+ }

+

+ // Select the sort order. Add time sort anchor for non-time sorting cases

+ $sql_sort_anchor = ($sort_key != 't') ? ', a.filetime ' . (($sort_dir == 'd') ? 'ASC' : 'DESC') : '';

+ $sql_sort_order = $sort_by_sql[$sort_key] . ' ' . (($sort_dir == 'd') ? 'ASC' : 'DESC') . $sql_sort_anchor;

+ $sql_start = max(0, $num_files - $sql_limit - $start);

+ }

+ else

+ {

+ // Select the sort order. Add time sort anchor for non-time sorting cases

+ $sql_sort_anchor = ($sort_key != 't') ? ', a.filetime ' . (($sort_dir == 'd') ? 'DESC' : 'ASC') : '';

+ $sql_sort_order = $sort_by_sql[$sort_key] . ' ' . (($sort_dir == 'd') ? 'DESC' : 'ASC') . $sql_sort_anchor;

+ $sql_start = $start;

+

+ }

+

+ $attachments_list = array();

+

+ // Just get the files

+ $sql = 'SELECT a.*, u.username, u.user_colour, t.topic_title

+ FROM ' . ATTACHMENTS_TABLE . ' a

+ LEFT JOIN ' . USERS_TABLE . ' u ON (u.user_id = a.poster_id)

+ LEFT JOIN ' . TOPICS_TABLE . " t ON (a.topic_id = t.topic_id)

+ WHERE a.is_orphan = 0

+ $limit_filetime

+ ORDER BY $sql_sort_order";

+ $result = $db->sql_query_limit($sql, $sql_limit, $sql_start);

+

+ $i = ($store_reverse) ? $sql_limit - 1 : 0;

+

+ // Store increment value in a variable to save some conditional calls

+ $i_increment = ($store_reverse) ? -1 : 1;

+ while ($attachment_row = $db->sql_fetchrow($result))

+ {

+ $attachments_list[$i] = $attachment_row;

+ $i = $i + $i_increment;

+ }

+ $db->sql_freeresult($result);

+

+ $template->assign_vars(array(

+ 'TOTAL_FILES' => $num_files,

+ 'TOTAL_SIZE' => get_formatted_filesize($total_size),

+ 'PAGINATION' => generate_pagination($this->u_action . "&amp;$u_sort_param", $num_files, $attachments_per_page, $start, true),

+

+ 'S_ON_PAGE' => on_page($num_files, $attachments_per_page, $start),

+ 'S_LIMIT_DAYS' => $s_limit_days,

+ 'S_SORT_KEY' => $s_sort_key,

+ 'S_SORT_DIR' => $s_sort_dir)

+ );

+

+ // Grab extensions

+ $extensions = $cache->obtain_attach_extensions(true);

+

+ for ($i = 0, $end = sizeof($attachments_list); $i < $end; ++$i)

+ {

+ $row = $attachments_list[$i];

+

+ $row['extension'] = strtolower(trim((string) $row['extension']));

+ $comment = ($row['attach_comment'] && !$row['in_message']) ? str_replace(array("\n", "\r"), array('<br />', "\n"), $row['attach_comment']) : '';

+ $display_cat = $extensions[$row['extension']]['display_cat'];

+ $l_downloaded_viewed = ($display_cat == ATTACHMENT_CATEGORY_NONE) ? 'DOWNLOAD_COUNT' : 'VIEWED_COUNT';

+ $l_download_count = (!isset($row['download_count']) || (int) $row['download_count'] == 0) ? $user->lang[$l_downloaded_viewed . '_NONE'] : (((int) $row['download_count'] == 1) ? sprintf($user->lang[$l_downloaded_viewed], $row['download_count']) : sprintf($user->lang[$l_downloaded_viewed . 'S'], $row['download_count']));

+

+ $template->assign_block_vars('attachments', array(

+ 'ATTACHMENT_POSTER' => get_username_string('full', (int) $row['poster_id'], (string) $row['username'], (string) $row['user_colour'], (string) $row['username']),

+ 'FILESIZE' => get_formatted_filesize((int) $row['filesize']),

+ 'FILETIME' => $user->format_date((int) $row['filetime']),

+ 'REAL_FILENAME' => (!$row['in_message']) ? utf8_wordwrap(utf8_basename((string) $row['real_filename']), 40, '<br />', true) : '',

+ 'PHYSICAL_FILENAME' => utf8_basename((string) $row['physical_filename']),

+ 'EXT_GROUP_NAME' => (!empty($extensions[$row['extension']]['group_name'])) ? $user->lang['EXT_GROUP_' . $extensions[$row['extension']]['group_name']] : '',

+ 'COMMENT' => $comment,

+ 'TOPIC_TITLE' => (!$row['in_message']) ? (string) $row['topic_title'] : '',

+ 'ATTACH_ID' => (int) $row['attach_id'],

+ 'POST_ID' => (int) $row['post_msg_id'],

+ 'TOPIC_ID' => (int) $row['topic_id'],

+ 'POST_IDS' => (!empty($post_ids[$row['attach_id']])) ? (int) $post_ids[$row['attach_id']] : '',

+

+ 'L_DOWNLOAD_COUNT' => $l_download_count,

+

+ 'S_IN_MESSAGE' => (bool) $row['in_message'],

+

+ 'U_VIEW_TOPIC' => append_sid("{$phpbb_root_path}viewtopic.$phpEx", "t={$row['topic_id']}&amp;p={$row['post_msg_id']}") . "#p{$row['post_msg_id']}",

+ 'U_FILE' => append_sid($phpbb_root_path . 'download/file.' . $phpEx, 'mode=view&amp;id=' . $row['attach_id']))

+ );

+ }

+

+ break;

+ global $request;

+ $ip_exclude = (int) $request->variable('ipexclude', false, false, phpbb_request_interface::POST);

+ $utf8_pcre_properties = pcre_utf8_support();

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

+ 'avatar_min_width' => array('lang' => 'MIN_AVATAR_SIZE', 'validate' => 'int:0', 'type' => false, 'method' => false, 'explain' => false),

+ 'avatar_min_height' => array('lang' => 'MIN_AVATAR_SIZE', 'validate' => 'int:0', 'type' => false, 'method' => false, 'explain' => false),

+ 'avatar_max_width' => array('lang' => 'MAX_AVATAR_SIZE', 'validate' => 'int:0', 'type' => false, 'method' => false, 'explain' => false),

+ 'avatar_max_height' => array('lang' => 'MAX_AVATAR_SIZE', 'validate' => 'int:0', 'type' => false, 'method' => false, 'explain' => false),

+ 'avatar_gallery_path' => array('lang' => 'AVATAR_GALLERY_PATH', 'validate' => 'rpath', 'type' => 'text:20:255', 'explain' => true),

+ 'cookie_secure' => array('lang' => 'COOKIE_SECURE', 'validate' => 'bool', 'type' => 'radio:disabled_enabled', 'explain' => true),

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

+ 'auth_method' => array('lang' => 'AUTH_METHOD', 'validate' => 'string', 'type' => 'select', 'method' => 'select_auth_method', 'explain' => false),

+ 'use_system_cron' => array('lang' => 'USE_SYSTEM_CRON', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true),

+ // We validate the complete config if wished

+ $col_types = sqlite_fetch_column_types($db->db_connect_id, $table_name);

+ if ($mode == 'position')

+ {

+ $this->manage_position();

+ return;

+ }

+

+ 'teampage' => isset($_REQUEST['group_teampage']) ? 1 : 0,

+ 'teampage' => 'int',

+ 'GROUP_TEAMPAGE' => (isset($group_row['group_teampage']) && $group_row['group_teampage']) ? ' checked="checked"' : '',

+ public function manage_position()

+ {

+ global $config, $db, $template, $user;

+

+ $this->tpl_name = 'acp_groups_position';

+ $this->page_title = 'ACP_GROUPS_POSITION';

+

+ $field = request_var('field', '');

+ $action = request_var('action', '');

+ $group_id = request_var('g', 0);

+

+ if ($field && !in_array($field, array('legend', 'teampage')))

+ {

+ // Invalid mode

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

+ }

+ else if ($field)

+ {

+ $group_position = new phpbb_group_positions($db, $field, $this->u_action);

+ }

+

+ switch ($action)

+ {

+ case 'set_config_legend':

+ set_config('legend_sort_groupname', request_var('legend_sort_groupname', 0));

+ break;

+

+ case 'set_config_teampage':

+ set_config('teampage_forums', request_var('teampage_forums', 0));

+ set_config('teampage_multiple', request_var('teampage_multiple', 0));

+ break;

+

+ case 'add':

+ $group_position->add_group($group_id);

+ break;

+

+ case 'delete':

+ $group_position->delete_group($group_id);

+ break;

+

+ case 'move_up':

+ $group_position->move_up($group_id);

+ break;

+

+ case 'move_down':

+ $group_position->move_down($group_id);

+ break;

+ }

+

+ $sql = 'SELECT group_id, group_name, group_colour, group_type, group_legend

+ FROM ' . GROUPS_TABLE . '

+ ORDER BY group_legend, group_name ASC';

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

+

+ $s_group_select_legend = '';

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

+ {

+ $group_name = ($row['group_type'] == GROUP_SPECIAL) ? $user->lang['G_' . $row['group_name']] : $row['group_name'];

+ if ($row['group_legend'])

+ {

+ $template->assign_block_vars('legend', array(

+ 'GROUP_NAME' => $group_name,

+ 'GROUP_COLOUR' => ($row['group_colour']) ? ' style="color: #' . $row['group_colour'] . '"' : '',

+ 'GROUP_TYPE' => $user->lang[phpbb_group_positions::group_type_language($row['group_type'])],

+

+ 'U_MOVE_DOWN' => "{$this->u_action}&amp;field=legend&amp;action=move_down&amp;g=" . $row['group_id'],

+ 'U_MOVE_UP' => "{$this->u_action}&amp;field=legend&amp;action=move_up&amp;g=" . $row['group_id'],

+ 'U_DELETE' => "{$this->u_action}&amp;field=legend&amp;action=delete&amp;g=" . $row['group_id'],

+ ));

+ }

+ else

+ {

+ $s_group_select_legend .= '<option value="' . (int) $row['group_id'] . '">' . $group_name . '</option>';

+ }

+ }

+ $db->sql_freeresult($result);

+

+ $sql = 'SELECT group_id, group_name, group_colour, group_type, group_teampage

+ FROM ' . GROUPS_TABLE . '

+ ORDER BY group_teampage, group_name ASC';

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

+

+ $s_group_select_teampage = '';

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

+ {

+ $group_name = ($row['group_type'] == GROUP_SPECIAL) ? $user->lang['G_' . $row['group_name']] : $row['group_name'];

+ if ($row['group_teampage'])

+ {

+ $template->assign_block_vars('teampage', array(

+ 'GROUP_NAME' => $group_name,

+ 'GROUP_COLOUR' => ($row['group_colour']) ? ' style="color: #' . $row['group_colour'] . '"' : '',

+ 'GROUP_TYPE' => $user->lang[phpbb_group_positions::group_type_language($row['group_type'])],

+

+ 'U_MOVE_DOWN' => "{$this->u_action}&amp;field=teampage&amp;action=move_down&amp;g=" . $row['group_id'],

+ 'U_MOVE_UP' => "{$this->u_action}&amp;field=teampage&amp;action=move_up&amp;g=" . $row['group_id'],

+ 'U_DELETE' => "{$this->u_action}&amp;field=teampage&amp;action=delete&amp;g=" . $row['group_id'],

+ ));

+ }

+ else

+ {

+ $s_group_select_teampage .= '<option value="' . (int) $row['group_id'] . '">' . $group_name . '</option>';

+ }

+ }

+ $db->sql_freeresult($result);

+

+ $template->assign_vars(array(

+ 'U_ACTION' => $this->u_action,

+ 'U_ACTION_LEGEND' => $this->u_action . '&amp;field=legend',

+ 'U_ACTION_TEAMPAGE' => $this->u_action . '&amp;field=teampage',

+

+ 'S_GROUP_SELECT_LEGEND' => $s_group_select_legend,

+ 'S_GROUP_SELECT_TEAMPAGE' => $s_group_select_teampage,

+ 'DISPLAY_FORUMS' => ($config['teampage_forums']) ? true : false,

+ 'DISPLAY_MULTIPLE' => ($config['teampage_multiple']) ? true : false,

+ 'LEGEND_SORT_GROUPNAME' => ($config['legend_sort_groupname']) ? true : false,

+ ));

+ }

+}

+ global $request;

+ if ($request->variable('add_additional_code', false, false, phpbb_request_interface::POST))

+ if ($request->variable('add_display_on_posting', false, false, phpbb_request_interface::POST))

+ global $request;

+ $request->overwrite('language_file', array_shift(array_keys($missing_file)));

+ // detect language file type

+ if ($this->language_directory == 'email')

+ {

+ $language_file_type = 'email';

+ $request_default = '';

+ }

+ else if (strpos($this->language_file, 'help_') === 0)

+ {

+ $language_file_type = 'help';

+ $request_default = array(0 => array(0 => ''));

+ }

+ else

+ {

+ $language_file_type = 'normal';

+ $request_default = array('' => '');

+ }

+

+ 'DEFAULT' => $request->variable($data, (string) $default),

+ $hidden_data .= build_hidden_fields(array('entry' => $request->variable('entry', $request_default, true, phpbb_request_interface::POST)));

+ $entry_value = $request->variable('entry', $request_default, true, phpbb_request_interface::POST);

+ if (!$lang_id || !$entry_value)

+ if ($language_file_type == 'email')

+ $entry = $this->prepare_lang_entry(htmlspecialchars_decode($entry_value), false);

+ if ($language_file_type == 'help')

+ foreach ($entry_value as $key => $value)

+ $entry .= "\t\t" . (int) $_key . "\t=> '" . $this->prepare_lang_entry(htmlspecialchars_decode($_value)) . "',\n";

+ else if ($language_file_type == 'normal')

+ foreach ($entry_value as $key => $value)

+ $entry = $this->format_lang_array(htmlspecialchars_decode($key), htmlspecialchars_decode($value));

+ global $request;

+ $deletemark = $request->variable('delmarked', false, false, phpbb_request_interface::POST);

+ $deleteall = $request->variable('delall', false, false, phpbb_request_interface::POST);

+ global $request;

+ $settings = $request->variable('setting', array(0 => array(0 => array('' => 0))), false, phpbb_request_interface::POST);

+ if (empty($settings) || empty($settings[$ug_id]) || empty($settings[$ug_id][$forum_id]))

+ $auth_settings = $settings[$ug_id][$forum_id];

+ $roles = $request->variable('role', array(0 => array(0 => 0)), false, phpbb_request_interface::POST);

+ $assigned_role = (isset($roles[$ug_id][$forum_id])) ? (int) $roles[$ug_id][$forum_id] : 0;

+ global $request;

+ $auth_settings = $request->variable('setting', array(0 => array(0 => array('' => 0))), false, phpbb_request_interface::POST);

+ $auth_roles = $request->variable('role', array(0 => array(0 => 0)), false, phpbb_request_interface::POST);

+ global $request;

+ 'field_show_on_pm' => 0,

+ 1 => array('field_ident', 'lang_name', 'lang_explain', 'field_option_none', 'field_show_on_reg', 'field_show_on_pm', 'field_show_on_vt', 'field_required', 'field_hide', 'field_show_profile', 'field_no_view'),

+ 'field_show_on_pm',

+ $var = 'now';

+ $request->overwrite('field_default_value', $var, phpbb_request_interface::POST);

+ $var = sprintf('%2d-%2d-%4d', $cp->vars['field_default_value_day'], $cp->vars['field_default_value_month'], $cp->vars['field_default_value_year']);

+ $request->overwrite('field_default_value', $var, phpbb_request_interface::POST);

+ $_new_key_ary[$key] = ($field_type == FIELD_BOOL && $key == 'lang_options') ? utf8_normalize_nfc(request_var($key, array(''), true)) : utf8_normalize_nfc(request_var($key, '', true));

+ 'S_SHOW_ON_PM' => ($cp->vars['field_show_on_pm']) ? true : false,

+ 'field_show_on_pm' => $cp->vars['field_show_on_pm'],

+ $action = request_var('action', '');

+ // Indexing enabled for this forum

+ if (isset($forums[$row['forum_id']]) && $forums[$row['forum_id']])

+ $this->template_bitfield = $bitfield->get_base64();

+ $sql_ary['bbcode_bitfield'] = $this->template_bitfield;

+ $user_ip = phpbb_ip_normalise(request_var('user_ip', ''));

+ $error = array_map(array($user, 'lang'), $error);

+ $error = array_map(array($user, 'lang'), $error);

+ $error = array_map(array($user, 'lang'), $error);

+ $error = array_map(array($user, 'lang'), $error);

+ $error = array_map(array($user, 'lang'), $error);

+ 'orphan' => array('title' => 'ACP_ORPHAN_ATTACHMENTS', 'auth' => 'acl_a_attach', 'cat' => array('ACP_ATTACHMENTS')),

+ 'manage' => array('title' => 'ACP_MANAGE_ATTACHMENTS', 'auth' => 'acl_a_attach', 'cat' => array('ACP_ATTACHMENTS')),

+ 'position' => array('title' => 'ACP_GROUPS_POSITION', 'auth' => 'acl_a_group', 'cat' => array('ACP_GROUPS')),

+ global $request;

+ if (!class_exists('phpbb_captcha_factory', false))

+ // enable super globals to get literal value

+ // this is needed to prevent unicode normalization

+ $super_globals_disabled = $request->super_globals_disabled();

+ if ($super_globals_disabled)

+ {

+ $request->enable_super_globals();

+ }

+

+ $password_new_format = $request->variable('password', '', true);

+ if ($super_globals_disabled)

+ {

+ $request->disable_super_globals();

+ }

+class phpbb_cache_driver_apc extends phpbb_cache_driver_memory

+<?php

+/**

+*

+* @package acm

+* @version $Id$

+* @copyright (c) 2010 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* @package acm

+*/

+abstract class phpbb_cache_driver_base implements phpbb_cache_driver_interface

+{

+}

+class phpbb_cache_driver_eaccelerator extends phpbb_cache_driver_memory

+class phpbb_cache_driver_file extends phpbb_cache_driver_base

+ function __construct($cache_dir = null)

+ $this->cache_dir = !is_null($cache_dir) ? $cache_dir : $phpbb_root_path . 'cache/';

+<?php

+/**

+*

+* @package acm

+* @copyright (c) 2010 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* An interface that all cache drivers must implement

+*

+* @package acm

+*/

+interface phpbb_cache_driver_interface

+{

+ /**

+ * Load global cache

+ */

+ public function load();

+

+ /**

+ * Unload cache object

+ */

+ public function unload();

+

+ /**

+ * Save modified objects

+ */

+ public function save();

+

+ /**

+ * Tidy cache

+ */

+ public function tidy();

+

+ /**

+ * Get saved cache object

+ */

+ public function get($var_name);

+

+ /**

+ * Put data into cache

+ */

+ public function put($var_name, $var, $ttl = 0);

+

+ /**

+ * Purge cache data

+ */

+ public function purge();

+

+ /**

+ * Destroy cache data

+ */

+ public function destroy($var_name, $table = '');

+

+ /**

+ * Check if a given cache entry exist

+ */

+ public function _exists($var_name);

+

+ /**

+ * Load cached sql query

+ */

+ public function sql_load($query);

+

+ /**

+ * Save sql query

+ */

+ public function sql_save($query, &$query_result, $ttl);

+

+ /**

+ * Ceck if a given sql query exist in cache

+ */

+ public function sql_exists($query_id);

+

+ /**

+ * Fetch row from cache (database)

+ */

+ public function sql_fetchrow($query_id);

+

+ /**

+ * Fetch a field from the current row of a cached database result (database)

+ */

+ public function sql_fetchfield($query_id, $field);

+

+ /**

+ * Seek a specific row in an a cached database result (database)

+ */

+ public function sql_rowseek($rownum, $query_id);

+

+ /**

+ * Free memory used for a cached database result (database)

+ */

+ public function sql_freeresult($query_id);

+}

+class phpbb_cache_driver_memcache extends phpbb_cache_driver_memory

+ function __construct()

+ parent::__construct();

+class phpbb_cache_driver_memory extends phpbb_cache_driver_base

+ function __construct()

+class phpbb_cache_driver_null extends phpbb_cache_driver_base

+ function __construct()

+class phpbb_cache_driver_redis extends phpbb_cache_driver_memory

+ function __construct()

+ parent::__construct();

+

+class phpbb_cache_driver_wincache extends phpbb_cache_driver_memory

+class phpbb_cache_driver_xcache extends phpbb_cache_driver_memory

+ function __construct()

+ parent::__construct();

+ */

+<?php

+/**

+*

+* @package acm

+* @version $Id$

+* @copyright (c) 2010 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* @package acm

+*/

+class phpbb_cache_factory

+{

+ private $acm_type;

+

+ public function __construct($acm_type)

+ {

+ $this->acm_type = $acm_type;

+ }

+

+ public function get_driver()

+ {

+ $class_name = 'phpbb_cache_driver_' . $this->acm_type;

+ return new $class_name();

+ }

+

+ public function get_service()

+ {

+ $driver = $this->get_driver();

+ $service = new phpbb_cache_service($driver);

+ return $service;

+ }

+}

+* Class for grabbing/handling cached entries

+class phpbb_cache_service

+ private $driver;

+

+ * Creates a cache service around a cache driver

+ *

+ * @param phpbb_cache_driver_interface $driver The cache driver

+ public function __construct(phpbb_cache_driver_interface $driver = null)

+ $this->set_driver($driver);

+ }

+ /**

+ * Returns the cache driver used by this cache service.

+ *

+ * @return phpbb_cache_driver_interface The cache driver

+ */

+ public function get_driver()

+ {

+ return $this->driver;

+ }

+ /**

+ * Replaces the cache driver used by this cache service.

+ *

+ * @param phpbb_cache_driver_interface $driver The cache driver

+ */

+ public function set_driver(phpbb_cache_driver_interface $driver)

+ {

+ $this->driver = $driver;

+ }

+ public function __call($method, $arguments)

+ {

+ return call_user_func_array(array($this->driver, $method), $arguments);

+ if (($censors = $this->driver->get('_word_censors')) === false)

+ $this->driver->put('_word_censors', $censors);

+ if (($icons = $this->driver->get('_icons')) === false)

+ $this->driver->put('_icons', $icons);

+ if (($ranks = $this->driver->get('_ranks')) === false)

+ $this->driver->put('_ranks', $ranks);

+ if (($extensions = $this->driver->get('_extensions')) === false)

+ 'group_name' => $row['group_name'],

+ $this->driver->put('_extensions', $extensions);

+ if (($bots = $this->driver->get('_bots')) === false)

+ $this->driver->put('_bots', $bots);

+ $parsed_array = $this->driver->get('_cfg_' . $key . '_' . $theme[$key . '_path']);

+ $this->driver->put('_cfg_' . $key . '_' . $theme[$key . '_path'], $parsed_array);

+ if (($usernames = $this->driver->get('_disallowed_usernames')) === false)

+ $this->driver->put('_disallowed_usernames', $usernames);

+ if (($hook_files = $this->driver->get('_hooks')) === false)

+ $this->driver->put('_hooks', $hook_files);

+if (!class_exists('phpbb_default_captcha', false))

+

+ $config = new phpbb_config(array());

+ foreach ($config_old as $key => $value)

+ {

+ $config->set($key, $value);

+ }

+

+ $config->set($captcha_var, request_var($captcha_var, (int) $config[$captcha_var]));

+if (!class_exists('phpbb_default_captcha', false))

+if (!class_exists('phpbb_default_captcha', false))

+

+ if (!class_exists('phpbb_db_tools', false))

+

+

+

+ FROM ' . CAPTCHA_QA_CONFIRM_TABLE . "

+ WHERE

+

+

+

+

+if (!class_exists('phpbb_default_captcha', false))

+<?php

+/**

+*

+* @package phpBB3

+* @version $Id$

+* @copyright (c) 2005 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* The class loader resolves class names to file system paths and loads them if

+* necessary.

+*

+* Classes have to be of the form phpbb_(dir_)*(classpart_)*, so directory names

+* must never contain underscores. Example: phpbb_dir_subdir_class_name is a

+* valid class name, while phpbb_dir_sub_dir_class_name is not.

+*

+* If every part of the class name is a directory, the last directory name is

+* also used as the filename, e.g. phpbb_dir would resolve to dir/dir.php.

+*

+* @package phpBB3

+*/

+class phpbb_class_loader

+{

+ private $phpbb_root_path;

+ private $php_ext;

+ private $cache;

+ private $cached_paths = array();

+

+ /**

+ * Creates a new phpbb_class_loader, which loads files with the given

+ * file extension from the given phpbb root path.

+ *

+ * @param string $phpbb_root_path phpBB's root directory containing includes/

+ * @param string $php_ext The file extension for PHP files

+ * @param phpbb_cache_driver_interface $cache An implementation of the phpBB cache interface.

+ */

+ public function __construct($phpbb_root_path, $php_ext = '.php', phpbb_cache_driver_interface $cache = null)

+ {

+ $this->phpbb_root_path = $phpbb_root_path;

+ $this->php_ext = $php_ext;

+

+ $this->set_cache($cache);

+ }

+

+ /**

+ * Provide the class loader with a cache to store paths. If set to null, the

+ * the class loader will resolve paths by checking for the existance of every

+ * directory in the class name every time.

+ *

+ * @param phpbb_cache_driver_interface $cache An implementation of the phpBB cache interface.

+ */

+ public function set_cache(phpbb_cache_driver_interface $cache = null)

+ {

+ if ($cache)

+ {

+ $this->cached_paths = $cache->get('class_loader');

+

+ if ($this->cached_paths === false)

+ {

+ $this->cached_paths = array();

+ }

+ }

+

+ $this->cache = $cache;

+ }

+

+ /**

+ * Registers the class loader as an autoloader using SPL.

+ */

+ public function register()

+ {

+ spl_autoload_register(array($this, 'load_class'));

+ }

+

+ /**

+ * Removes the class loader from the SPL autoloader stack.

+ */

+ public function unregister()

+ {

+ spl_autoload_unregister(array($this, 'load_class'));

+ }

+

+ /**

+ * Resolves a phpBB class name to a relative path which can be included.

+ *

+ * @param string $class The class name to resolve, must have a phpbb_

+ * prefix

+ * @return string|bool A relative path to the file containing the

+ * class or false if looking it up failed.

+ */

+ public function resolve_path($class)

+ {

+ $path_prefix = $this->phpbb_root_path . 'includes/';

+

+ if (isset($this->cached_paths[$class]))

+ {

+ return $path_prefix . $this->cached_paths[$class] . $this->php_ext;

+ }

+

+ if (!preg_match('/phpbb_[a-zA-Z0-9_]+/', $class))

+ {

+ return false;

+ }

+

+ $parts = explode('_', substr($class, 6));

+

+ $dirs = '';

+

+ for ($i = 0, $n = sizeof($parts); $i < $n && is_dir($path_prefix . $dirs . $parts[$i]); $i++)

+ {

+ $dirs .= $parts[$i] . '/';

+ }

+

+ // no file name left => use last dir name as file name

+ if ($i == sizeof($parts))

+ {

+ $parts[] = $parts[$i - 1];

+ }

+

+ $relative_path = $dirs . implode(array_slice($parts, $i, sizeof($parts) - $i), '_');

+

+ if (!file_exists($path_prefix . $relative_path . $this->php_ext))

+ {

+ return false;

+ }

+

+ if ($this->cache)

+ {

+ $this->cached_paths[$class] = $relative_path;

+ $this->cache->put('class_loader', $this->cached_paths);

+ }

+

+ return $path_prefix . $relative_path . $this->php_ext;

+ }

+

+ /**

+ * Resolves a class name to a path and then includes it.

+ *

+ * @param string $class The class name which is being loaded.

+ */

+ public function load_class($class)

+ {

+ if (substr($class, 0, 6) === 'phpbb_')

+ {

+ $path = $this->resolve_path($class);

+

+ if ($path)

+ {

+ require $path;

+ }

+ }

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2010 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Configuration container class

+* @package phpBB3

+*/

+class phpbb_config implements ArrayAccess, IteratorAggregate, Countable

+{

+ /**

+ * The configuration data

+ * @var array(string => string)

+ */

+ protected $config;

+

+ /**

+ * Creates a configuration container with a default set of values

+ *

+ * @param array(string => string) $config The configuration data.

+ */

+ public function __construct(array $config)

+ {

+ $this->config = $config;

+ }

+

+ /**

+ * Retrieves an ArrayIterator over the configuration values.

+ *

+ * @return ArrayIterator An iterator over all config data

+ */

+ public function getIterator()

+ {

+ return new ArrayIterator($this->config);

+ }

+

+ /**

+ * Checks if the specified config value exists.

+ *

+ * @param string $key The configuration option's name.

+ * @return bool Whether the configuration option exists.

+ */

+ public function offsetExists($key)

+ {

+ return isset($this->config[$key]);

+ }

+

+ /**

+ * Retrieves a configuration value.

+ *

+ * @param string $key The configuration option's name.

+ * @return string The configuration value

+ */

+ public function offsetGet($key)

+ {

+ return (isset($this->config[$key])) ? $this->config[$key] : '';

+ }

+

+ /**

+ * Temporarily overwrites the value of a configuration variable.

+ *

+ * The configuration change will not persist. It will be lost

+ * after the request.

+ *

+ * @param string $key The configuration option's name.

+ * @param string $value The temporary value.

+ */

+ public function offsetSet($key, $value)

+ {

+ $this->config[$key] = $value;

+ }

+

+ /**

+ * Called when deleting a configuration value directly, triggers an error.

+ *

+ * @param string $key The configuration option's name.

+ */

+ public function offsetUnset($key)

+ {

+ trigger_error('Config values have to be deleted explicitly with the phpbb_config::delete($key) method.', E_USER_ERROR);

+ }

+

+ /**

+ * Retrieves the number of configuration options currently set.

+ *

+ * @return int Number of config options

+ */

+ public function count()

+ {

+ return count($this->config);

+ }

+

+ /**

+ * Removes a configuration option

+ *

+ * @param String $key The configuration option's name

+ * @param bool $use_cache Whether this variable should be cached or if it

+ * changes too frequently to be efficiently cached

+ * @return void

+ */

+ public function delete($key, $use_cache = true)

+ {

+ unset($this->config[$key]);

+ }

+

+ /**

+ * Sets a configuration option's value

+ *

+ * @param string $key The configuration option's name

+ * @param string $value New configuration value

+ * @param bool $use_cache Whether this variable should be cached or if it

+ * changes too frequently to be efficiently cached.

+ */

+ public function set($key, $value, $use_cache = true)

+ {

+ $this->config[$key] = $value;

+ }

+

+ /**

+ * Sets a configuration option's value only if the old_value matches the

+ * current configuration value or the configuration value does not exist yet.

+ *

+ * @param string $key The configuration option's name

+ * @param string $old_value Current configuration value

+ * @param string $new_value New configuration value

+ * @param bool $use_cache Whether this variable should be cached or if it

+ * changes too frequently to be efficiently cached.

+ * @return bool True if the value was changed, false otherwise.

+ */

+ public function set_atomic($key, $old_value, $new_value, $use_cache = true)

+ {

+ if (!isset($this->config[$key]) || $this->config[$key] == $old_value)

+ {

+ $this->config[$key] = $new_value;

+ return true;

+ }

+ return false;

+ }

+

+ /**

+ * Increments an integer configuration value.

+ *

+ * @param string $key The configuration option's name

+ * @param int $increment Amount to increment by

+ * @param bool $use_cache Whether this variable should be cached or if it

+ * changes too frequently to be efficiently cached.

+ */

+ function increment($key, $increment, $use_cache = true)

+ {

+ if (!isset($this->config[$key]))

+ {

+ $this->config[$key] = 0;

+ }

+

+ $this->config[$key] += $increment;

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2010 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Configuration container class

+* @package phpBB3

+*/

+class phpbb_config_db extends phpbb_config

+{

+ /**

+ * Cache instance

+ * @var phpbb_cache_driver_interface

+ */

+ protected $cache;

+

+ /**

+ * Database connection

+ * @var dbal

+ */

+ protected $db;

+

+ /**

+ * Name of the database table used for configuration.

+ * @var string

+ */

+ protected $table;

+

+ /**

+ * Creates a configuration container with a default set of values

+ *

+ * @param dbal $db Database connection

+ * @param phpbb_cache_driver_interface $cache Cache instance

+ * @param string $table Configuration table name

+ */

+ public function __construct(dbal $db, phpbb_cache_driver_interface $cache, $table)

+ {

+ $this->db = $db;

+ $this->cache = $cache;

+ $this->table = $table;

+

+ if (($config = $cache->get('config')) !== false)

+ {

+ $sql = 'SELECT config_name, config_value

+ FROM ' . $this->table . '

+ WHERE is_dynamic = 1';

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

+

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

+ {

+ $config[$row['config_name']] = $row['config_value'];

+ }

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

+ }

+ else

+ {

+ $config = $cached_config = array();

+

+ $sql = 'SELECT config_name, config_value, is_dynamic

+ FROM ' . $this->table;

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

+

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

+ {

+ if (!$row['is_dynamic'])

+ {

+ $cached_config[$row['config_name']] = $row['config_value'];

+ }

+

+ $config[$row['config_name']] = $row['config_value'];

+ }

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

+

+ $cache->put('config', $cached_config);

+ }

+

+ parent::__construct($config);

+ }

+

+ /**

+ * Removes a configuration option

+ *

+ * @param String $key The configuration option's name

+ * @param bool $use_cache Whether this variable should be cached or if it

+ * changes too frequently to be efficiently cached

+ * @return void

+ */

+ public function delete($key, $use_cache = true)

+ {

+ $sql = 'DELETE FROM ' . $this->table . "

+ WHERE config_name = '" . $this->db->sql_escape($key) . "'";

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

+

+ unset($this->config[$key]);

+

+ if ($use_cache)

+ {

+ $this->cache->destroy('config');

+ }

+ }

+

+ /**

+ * Sets a configuration option's value

+ *

+ * @param string $key The configuration option's name

+ * @param string $value New configuration value

+ * @param bool $use_cache Whether this variable should be cached or if it

+ * changes too frequently to be efficiently cached.

+ */

+ public function set($key, $value, $use_cache = true)

+ {

+ $this->set_atomic($key, false, $value, $use_cache);

+ }

+

+ /**

+ * Sets a configuration option's value only if the old_value matches the

+ * current configuration value or the configuration value does not exist yet.

+ *

+ * @param string $key The configuration option's name

+ * @param mixed $old_value Current configuration value or false to ignore

+ * the old value

+ * @param string $new_value New configuration value

+ * @param bool $use_cache Whether this variable should be cached or if it

+ * changes too frequently to be efficiently cached

+ * @return bool True if the value was changed, false otherwise

+ */

+ public function set_atomic($key, $old_value, $new_value, $use_cache = true)

+ {

+ $sql = 'UPDATE ' . $this->table . "

+ SET config_value = '" . $this->db->sql_escape($new_value) . "'

+ WHERE config_name = '" . $this->db->sql_escape($key) . "'";

+

+ if ($old_value !== false)

+ {

+ $sql .= " AND config_value = '" . $this->db->sql_escape($old_value) . "'";

+ }

+

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

+

+ if (!$this->db->sql_affectedrows($result) && isset($this->config[$key]))

+ {

+ return false;

+ }

+

+ if (!isset($this->config[$key]))

+ {

+ $sql = 'INSERT INTO ' . $this->table . ' ' . $this->db->sql_build_array('INSERT', array(

+ 'config_name' => $key,

+ 'config_value' => $new_value,

+ 'is_dynamic' => ($use_cache) ? 0 : 1));

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

+ }

+

+ if ($use_cache)

+ {

+ $this->cache->destroy('config');

+ }

+

+ $this->config[$key] = $new_value;

+ return true;

+ }

+

+ /**

+ * Increments an integer config value directly in the database.

+ *

+ * Using this method instead of setting the new value directly avoids race

+ * conditions and unlike set_atomic it cannot fail.

+ *

+ * @param string $key The configuration option's name

+ * @param int $increment Amount to increment by

+ * @param bool $use_cache Whether this variable should be cached or if it

+ * changes too frequently to be efficiently cached.

+ */

+ function increment($key, $increment, $use_cache = true)

+ {

+ if (!isset($this->config[$key]))

+ {

+ $this->set($key, '0', $use_cache);

+ }

+

+ $sql_update = $this->db->cast_expr_to_string($this->db->cast_expr_to_bigint('config_value') . ' + ' . (int) $increment);

+

+ $this->db->sql_query('UPDATE ' . $this->table . '

+ SET config_value = ' . $sql_update . "

+ WHERE config_name = '" . $this->db->sql_escape($key) . "'");

+

+ if ($use_cache)

+ {

+ $this->cache->destroy('config');

+ }

+

+ $this->config[$key] += $increment;

+ }

+}

+define('PHPBB_VERSION', '3.1.0-dev');

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2010 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Cron manager class.

+*

+* Finds installed cron tasks, stores task objects, provides task selection.

+*

+* @package phpBB3

+*/

+class phpbb_cron_manager

+{

+ /**

+ * Set of phpbb_cron_task_wrapper objects.

+ * Array holding all tasks that have been found.

+ *

+ * @var array

+ */

+ protected $tasks = array();

+

+ /**

+ * Path to the root of directory tree with tasks.

+ * For bundled phpBB tasks, this is the path to includes/cron/tasks

+ * under phpBB root.

+ * @var string

+ */

+ protected $task_path;

+

+ /**

+ * PHP file extension

+ * @var string

+ */

+ protected $phpEx;

+

+ /**

+ * Cache driver

+ * @var phpbb_cache_driver_interface

+ */

+ protected $cache;

+

+ /**

+ * Constructor. Loads all available tasks.

+ *

+ * Tasks will be looked up in directory tree rooted at $task_path.

+ * Task classes will be autoloaded and must be named according to

+ * autoloading naming conventions. To load cron tasks shipped with

+ * phpbb, pass $phpbb_root_path . 'includes/cron/task' as $task_path.

+ *

+ * If $cache is given, names of found cron tasks will be cached in it

+ * for one hour. Note that the cron task names are stored without

+ * namespacing; if two different phbb_cron_manager instances are

+ * constructed with different $task_path arguments but the same $cache,

+ * the second instance will use task names found by the first instance.

+ *

+ * @param string $task_path Directory containing cron tasks

+ * @param string $phpEx PHP file extension

+ * @param phpbb_cache_driver_interface $cache Cache for task names (optional)

+ * @return void

+ */

+ public function __construct($task_path, $phpEx, phpbb_cache_driver_interface $cache = null)

+ {

+ if (DIRECTORY_SEPARATOR != '/')

+ {

+ // Need this on some platforms since the code elsewhere uses /

+ // to separate directory components, but PHP iterators return

+ // paths with platform-specific directory separators.

+ $task_path = str_replace('/', DIRECTORY_SEPARATOR, $task_path);

+ }

+

+ $this->task_path = $task_path;

+ $this->phpEx = $phpEx;

+ $this->cache = $cache;

+

+ $task_names = $this->find_cron_task_names();

+ $this->load_tasks($task_names);

+ }

+

+ /**

+ * Finds cron task names.

+ *

+ * A cron task file must follow the naming convention:

+ * includes/cron/task/$mod/$name.php.

+ * $mod is core for tasks that are part of phpbb.

+ * Modifications should use their name as $mod.

+ * $name is the name of the cron task.

+ * Cron task is expected to be a class named phpbb_cron_task_${mod}_${name}.

+ *

+ * @return array List of task names

+ */

+ public function find_cron_task_names()

+ {

+ if ($this->cache)

+ {

+ $task_names = $this->cache->get('_cron_tasks');

+

+ if ($task_names !== false)

+ {

+ return $task_names;

+ }

+ }

+

+ $task_names = array();

+ $ext = '.' . $this->phpEx;

+ $ext_length = strlen($ext);

+

+ $iterator = new RecursiveIteratorIterator(new RecursiveDirectoryIterator($this->task_path));

+

+ foreach ($iterator as $fileinfo)

+ {

+ $file = preg_replace('#^' . preg_quote($this->task_path, '#') . '#', '', $fileinfo->getPathname());

+

+ // skip directories and files direclty in the task root path

+ if ($fileinfo->isFile() && strpos($file, DIRECTORY_SEPARATOR) !== false)

+ {

+ $task_name = str_replace(DIRECTORY_SEPARATOR, '_', substr($file, 0, -$ext_length));

+ if (substr($file, -$ext_length) == $ext && $this->is_valid_name($task_name))

+ {

+ $task_names[] = 'phpbb_cron_task_' . $task_name;

+ }

+ }

+ }

+

+ if ($this->cache)

+ {

+ $this->cache->put('_cron_tasks', $task_names, 3600);

+ }

+

+ return $task_names;

+ }

+

+ /**

+ * Checks whether $name is a valid identifier, and

+ * therefore part of valid cron task class name.

+ *

+ * @param string $name Name to check

+ *

+ * @return bool

+ */

+ public function is_valid_name($name)

+ {

+ return (bool) preg_match('/^[a-zA-Z][a-zA-Z0-9_]*$/', $name);

+ }

+

+ /**

+ * Loads tasks given by name, wraps them

+ * and puts them into $this->tasks.

+ *

+ * @param array $task_names Array of strings

+ *

+ * @return void

+ */

+ public function load_tasks(array $task_names)

+ {

+ foreach ($task_names as $task_name)

+ {

+ $task = new $task_name();

+ $wrapper = new phpbb_cron_task_wrapper($task);

+ $this->tasks[] = $wrapper;

+ }

+ }

+

+ /**

+ * Finds a task that is ready to run.

+ *

+ * If several tasks are ready, any one of them could be returned.

+ *

+ * If no tasks are ready, null is returned.

+ *

+ * @return phpbb_cron_task_wrapper|null

+ */

+ public function find_one_ready_task()

+ {

+ foreach ($this->tasks as $task)

+ {

+ if ($task->is_ready())

+ {

+ return $task;

+ }

+ }

+ return null;

+ }

+

+ /**

+ * Finds all tasks that are ready to run.

+ *

+ * @return array List of tasks which are ready to run (wrapped in phpbb_cron_task_wrapper).

+ */

+ public function find_all_ready_tasks()

+ {

+ $tasks = array();

+ foreach ($this->tasks as $task)

+ {

+ if ($task->is_ready())

+ {

+ $tasks[] = $task;

+ }

+ }

+ return $tasks;

+ }

+

+ /**

+ * Finds a task by name.

+ *

+ * If there is no task with the specified name, null is returned.

+ *

+ * Web runner uses this method to resolve names to tasks.

+ *

+ * @param string $name Name of the task to look up.

+ * @return phpbb_cron_task A task corresponding to the given name, or null.

+ */

+ public function find_task($name)

+ {

+ foreach ($this->tasks as $task)

+ {

+ if ($task->get_name() == $name)

+ {

+ return $task;

+ }

+ }

+ return null;

+ }

+

+ /**

+ * Creates an instance of parametrized cron task $name with args $args.

+ * The constructed task is wrapped with cron task wrapper before being returned.

+ *

+ * @param string $name The task name, which is the same as cron task class name.

+ * @param array $args Will be passed to the task class's constructor.

+ *

+ * @return phpbb_cron_task_wrapper|null

+ */

+ public function instantiate_task($name, array $args)

+ {

+ $task = $this->find_task($name);

+ if ($task)

+ {

+ // task here is actually an instance of cron task wrapper

+ $class = $task->get_name();

+ $task = new $class($args);

+ // need to wrap the new task too

+ $task = new phpbb_cron_task_wrapper($task);

+ }

+ return $task;

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2010 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Cron task base class. Provides sensible defaults for cron tasks

+* and partially implements cron task interface, making writing cron tasks easier.

+*

+* At a minimum, subclasses must override the run() method.

+*

+* Cron tasks need not inherit from this base class. If desired,

+* they may implement cron task interface directly.

+*

+* @package phpBB3

+*/

+abstract class phpbb_cron_task_base implements phpbb_cron_task

+{

+ /**

+ * Returns whether this cron task can run, given current board configuration.

+ *

+ * For example, a cron task that prunes forums can only run when

+ * forum pruning is enabled.

+ *

+ * @return bool

+ */

+ public function is_runnable()

+ {

+ return true;

+ }

+

+ /**

+ * Returns whether this cron task should run now, because enough time

+ * has passed since it was last run.

+ *

+ * @return bool

+ */

+ public function should_run()

+ {

+ return true;

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2010 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Prune all forums cron task.

+*

+* It is intended to be invoked from system cron.

+* This task will find all forums for which pruning is enabled, and will

+* prune all forums as necessary.

+*

+* @package phpBB3

+*/

+class phpbb_cron_task_core_prune_all_forums extends phpbb_cron_task_base

+{

+ /**

+ * Runs this cron task.

+ *

+ * @return void

+ */

+ public function run()

+ {

+ global $phpbb_root_path, $phpEx, $db;

+

+ if (!function_exists('auto_prune'))

+ {

+ include($phpbb_root_path . 'includes/functions_admin.' . $phpEx);

+ }

+

+ $sql = 'SELECT forum_id, prune_next, enable_prune, prune_days, prune_viewed, forum_flags, prune_freq

+ FROM ' . FORUMS_TABLE . "

+ WHERE enable_prune = 1

+ AND prune_next < " . time();

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

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

+ {

+ if ($row['prune_days'])

+ {

+ auto_prune($row['forum_id'], 'posted', $row['forum_flags'], $row['prune_days'], $row['prune_freq']);

+ }

+

+ if ($row['prune_viewed'])

+ {

+ auto_prune($row['forum_id'], 'viewed', $row['forum_flags'], $row['prune_viewed'], $row['prune_freq']);

+ }

+ }

+ $db->sql_freeresult($result);

+ }

+

+ /**

+ * Returns whether this cron task can run, given current board configuration.

+ *

+ * This cron task will only run when system cron is utilised.

+ *

+ * @return bool

+ */

+ public function is_runnable()

+ {

+ global $config;

+ return (bool) $config['use_system_cron'];

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2010 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Prune one forum cron task.

+*

+* It is intended to be used when cron is invoked via web.

+* This task can decide whether it should be run using data obtained by viewforum

+* code, without making additional database queries.

+*

+* @package phpBB3

+*/

+class phpbb_cron_task_core_prune_forum extends phpbb_cron_task_base implements phpbb_cron_task_parametrized

+{

+ private $forum_data;

+

+ /**

+ * Constructor.

+ *

+ * If $forum_data is given, it is assumed to contain necessary information

+ * about a single forum that is to be pruned.

+ *

+ * If $forum_data is not given, forum id will be retrieved via request_var

+ * and a database query will be performed to load the necessary information

+ * about the forum.

+ *

+ * @param array $forum_data Information about a forum to be pruned.

+ */

+ public function __construct($forum_data = null)

+ {

+ global $db;

+ if ($forum_data)

+ {

+ $this->forum_data = $forum_data;

+ }

+ else

+ {

+ $this->forum_data = null;

+ }

+ }

+

+ /**

+ * Runs this cron task.

+ *

+ * @return void

+ */

+ public function run()

+ {

+ global $phpbb_root_path, $phpEx;

+ if (!function_exists('auto_prune'))

+ {

+ include($phpbb_root_path . 'includes/functions_admin.' . $phpEx);

+ }

+

+ if ($this->forum_data['prune_days'])

+ {

+ auto_prune($this->forum_data['forum_id'], 'posted', $this->forum_data['forum_flags'], $this->forum_data['prune_days'], $this->forum_data['prune_freq']);

+ }

+

+ if ($this->forum_data['prune_viewed'])

+ {

+ auto_prune($this->forum_data['forum_id'], 'viewed', $this->forum_data['forum_flags'], $this->forum_data['prune_viewed'], $this->forum_data['prune_freq']);

+ }

+ }

+

+ /**

+ * Returns whether this cron task can run, given current board configuration.

+ *

+ * This cron task will not run when system cron is utilised, as in

+ * such cases prune_all_forums task would run instead.

+ *

+ * Additionally, this task must be given the forum data, either via

+ * the constructor or parse_parameters method.

+ *

+ * @return bool

+ */

+ public function is_runnable()

+ {

+ global $config;

+ return !$config['use_system_cron'] && $this->forum_data;

+ }

+

+ /**

+ * Returns whether this cron task should run now, because enough time

+ * has passed since it was last run.

+ *

+ * Forum pruning interval is specified in the forum data.

+ *

+ * @return bool

+ */

+ public function should_run()

+ {

+ return $this->forum_data['enable_prune'] && $this->forum_data['prune_next'] < time();

+ }

+

+ /**

+ * Returns parameters of this cron task as an array.

+ * The array has one key, f, whose value is id of the forum to be pruned.

+ *

+ * @return array

+ */

+ public function get_parameters()

+ {

+ return array('f' => $this->forum_data['forum_id']);

+ }

+

+ /**

+ * Parses parameters found in $request, which is an instance of

+ * phpbb_request_interface.

+ *

+ * It is expected to have a key f whose value is id of the forum to be pruned.

+ *

+ * @param phpbb_request_interface $request Request object.

+ *

+ * @return void

+ */

+ public function parse_parameters(phpbb_request_interface $request)

+ {

+ global $db;

+

+ $this->forum_data = null;

+ if ($request->is_set('f'))

+ {

+ $forum_id = $request->variable('f', 0);

+

+ $sql = 'SELECT forum_id, prune_next, enable_prune, prune_days, prune_viewed, forum_flags, prune_freq

+ FROM ' . FORUMS_TABLE . "

+ WHERE forum_id = $forum_id";

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

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

+ $db->sql_freeresult($result);

+

+ if ($row)

+ {

+ $this->forum_data = $row;

+ }

+ }

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2010 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Queue cron task. Sends email and jabber messages queued by other scripts.

+*

+* @package phpBB3

+*/

+class phpbb_cron_task_core_queue extends phpbb_cron_task_base

+{

+ /**

+ * Runs this cron task.

+ *

+ * @return void

+ */

+ public function run()

+ {

+ global $phpbb_root_path, $phpEx;

+ if (!class_exists('queue'))

+ {

+ include($phpbb_root_path . 'includes/functions_messenger.' . $phpEx);

+ }

+ $queue = new queue();

+ $queue->process();

+ }

+

+ /**

+ * Returns whether this cron task can run, given current board configuration.

+ *

+ * Queue task is only run if the email queue (file) exists.

+ *

+ * @return bool

+ */

+ public function is_runnable()

+ {

+ global $phpbb_root_path, $phpEx;

+ return file_exists($phpbb_root_path . 'cache/queue.' . $phpEx);

+ }

+

+ /**

+ * Returns whether this cron task should run now, because enough time

+ * has passed since it was last run.

+ *

+ * The interval between queue runs is specified in board configuration.

+ *

+ * @return bool

+ */

+ public function should_run()

+ {

+ global $config;

+ return $config['last_queue_run'] < time() - $config['queue_interval_config'];

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2010 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Tidy cache cron task.

+*

+* @package phpBB3

+*/

+class phpbb_cron_task_core_tidy_cache extends phpbb_cron_task_base

+{

+ /**

+ * Runs this cron task.

+ *

+ * @return void

+ */

+ public function run()

+ {

+ global $cache;

+ $cache->tidy();

+ }

+

+ /**

+ * Returns whether this cron task can run, given current board configuration.

+ *

+ * Tidy cache cron task runs if the cache implementation in use

+ * supports tidying.

+ *

+ * @return bool

+ */

+ public function is_runnable()

+ {

+ global $cache;

+ return method_exists($cache, 'tidy');

+ }

+

+ /**

+ * Returns whether this cron task should run now, because enough time

+ * has passed since it was last run.

+ *

+ * The interval between cache tidying is specified in board

+ * configuration.

+ *

+ * @return bool

+ */

+ public function should_run()

+ {

+ global $config;

+ return $config['cache_last_gc'] < time() - $config['cache_gc'];

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2010 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Tidy database cron task.

+*

+* @package phpBB3

+*/

+class phpbb_cron_task_core_tidy_database extends phpbb_cron_task_base

+{

+ /**

+ * Runs this cron task.

+ *

+ * @return void

+ */

+ public function run()

+ {

+ global $phpbb_root_path, $phpEx;

+ if (!function_exists('tidy_database'))

+ {

+ include($phpbb_root_path . 'includes/functions_admin.' . $phpEx);

+ }

+ tidy_database();

+ }

+

+ /**

+ * Returns whether this cron task should run now, because enough time

+ * has passed since it was last run.

+ *

+ * The interval between database tidying is specified in board

+ * configuration.

+ *

+ * @return bool

+ */

+ public function should_run()

+ {

+ global $config;

+ return $config['database_last_gc'] < time() - $config['database_gc'];

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2010 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Tidy search cron task.

+*

+* Will only run when the currently selected search backend supports tidying.

+*

+* @package phpBB3

+*/

+class phpbb_cron_task_core_tidy_search extends phpbb_cron_task_base

+{

+ /**

+ * Runs this cron task.

+ *

+ * @return void

+ */

+ public function run()

+ {

+ global $phpbb_root_path, $phpEx, $config, $error;

+

+ // Select the search method

+ $search_type = basename($config['search_type']);

+

+ if (!class_exists($search_type))

+ {

+ include("{$phpbb_root_path}includes/search/$search_type.$phpEx");

+ }

+

+ // We do some additional checks in the module to ensure it can actually be utilised

+ $error = false;

+ $search = new $search_type($error);

+

+ if (!$error)

+ {

+ $search->tidy();

+ }

+ }

+

+ /**

+ * Returns whether this cron task can run, given current board configuration.

+ *

+ * Search cron task is runnable in all normal use. It may not be

+ * runnable if the search backend implementation selected in board

+ * configuration does not exist.

+ *

+ * @return bool

+ */

+ public function is_runnable()

+ {

+ global $phpbb_root_path, $phpEx, $config;

+

+ // Select the search method

+ $search_type = basename($config['search_type']);

+

+ return file_exists($phpbb_root_path . 'includes/search/' . $search_type . '.' . $phpEx);

+ }

+

+ /**

+ * Returns whether this cron task should run now, because enough time

+ * has passed since it was last run.

+ *

+ * The interval between search tidying is specified in board

+ * configuration.

+ *

+ * @return bool

+ */

+ public function should_run()

+ {

+ global $config;

+ return $config['search_last_gc'] < time() - $config['search_gc'];

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2010 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Tidy sessions cron task.

+*

+* @package phpBB3

+*/

+class phpbb_cron_task_core_tidy_sessions extends phpbb_cron_task_base

+{

+ /**

+ * Runs this cron task.

+ *

+ * @return void

+ */

+ public function run()

+ {

+ global $user;

+ $user->session_gc();

+ }

+

+ /**

+ * Returns whether this cron task should run now, because enough time

+ * has passed since it was last run.

+ *

+ * The interval between session tidying is specified in board

+ * configuration.

+ *

+ * @return bool

+ */

+ public function should_run()

+ {

+ global $config;

+ return $config['session_last_gc'] < time() - $config['session_gc'];

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2010 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Tidy warnings cron task.

+*

+* Will only run when warnings are configured to expire.

+*

+* @package phpBB3

+*/

+class phpbb_cron_task_core_tidy_warnings extends phpbb_cron_task_base

+{

+ /**

+ * Runs this cron task.

+ *

+ * @return void

+ */

+ public function run()

+ {

+ global $phpbb_root_path, $phpEx;

+ if (!function_exists('tidy_warnings'))

+ {

+ include($phpbb_root_path . 'includes/functions_admin.' . $phpEx);

+ }

+ tidy_warnings();

+ }

+

+ /**

+ * Returns whether this cron task can run, given current board configuration.

+ *

+ * If warnings are set to never expire, this cron task will not run.

+ *

+ * @return bool

+ */

+ public function is_runnable()

+ {

+ global $config;

+ return (bool) $config['warnings_expire_days'];

+ }

+

+ /**

+ * Returns whether this cron task should run now, because enough time

+ * has passed since it was last run.

+ *

+ * The interval between warnings tidying is specified in board

+ * configuration.

+ *

+ * @return bool

+ */

+ public function should_run()

+ {

+ global $config;

+ return $config['warnings_last_gc'] < time() - $config['warnings_gc'];

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2010 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Parametrized cron task interface.

+*

+* Parametrized cron tasks are somewhat of a cross between regular cron tasks and

+* delayed jobs. Whereas regular cron tasks perform some action globally,

+* parametrized cron tasks perform actions on a particular object (or objects).

+* Parametrized cron tasks do not make sense and are not usable without

+* specifying these objects.

+*

+* @package phpBB3

+*/

+interface phpbb_cron_task_parametrized extends phpbb_cron_task

+{

+ /**

+ * Returns parameters of this cron task as an array.

+ *

+ * The array must map string keys to string values.

+ *

+ * @return array

+ */

+ public function get_parameters();

+

+ /**

+ * Parses parameters found in $request, which is an instance of

+ * phpbb_request_interface.

+ *

+ * $request contains user input and must not be trusted.

+ * Cron task must validate all data before using it.

+ *

+ * @param phpbb_request_interface $request Request object.

+ *

+ * @return void

+ */

+ public function parse_parameters(phpbb_request_interface $request);

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2010 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Cron task interface

+* @package phpBB3

+*/

+interface phpbb_cron_task

+{

+ /**

+ * Runs this cron task.

+ *

+ * @return void

+ */

+ public function run();

+

+ /**

+ * Returns whether this cron task can run, given current board configuration.

+ *

+ * For example, a cron task that prunes forums can only run when

+ * forum pruning is enabled.

+ *

+ * @return bool

+ */

+ public function is_runnable();

+

+ /**

+ * Returns whether this cron task should run now, because enough time

+ * has passed since it was last run.

+ *

+ * @return bool

+ */

+ public function should_run();

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2010 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Cron task wrapper class.

+* Enhances cron tasks with convenience methods that work identically for all tasks.

+*

+* @package phpBB3

+*/

+class phpbb_cron_task_wrapper

+{

+ /**

+ * Constructor.

+ *

+ * Wraps a task $task, which must implement cron_task interface.

+ *

+ * @param phpbb_cron_task $task The cron task to wrap.

+ */

+ public function __construct(phpbb_cron_task $task)

+ {

+ $this->task = $task;

+ }

+

+ /**

+ * Returns whether the wrapped task is parametrised.

+ *

+ * Parametrized tasks accept parameters during initialization and must

+ * normally be scheduled with parameters.

+ *

+ * @return bool Whether or not this task is parametrized.

+ */

+ public function is_parametrized()

+ {

+ return $this->task instanceof phpbb_cron_task_parametrized;

+ }

+

+ /**

+ * Returns whether the wrapped task is ready to run.

+ *

+ * A task is ready to run when it is runnable according to current configuration

+ * and enough time has passed since it was last run.

+ *

+ * @return bool Whether the wrapped task is ready to run.

+ */

+ public function is_ready()

+ {

+ return $this->task->is_runnable() && $this->task->should_run();

+ }

+

+ /**

+ * Returns the name of wrapped task. It is the same as the wrapped class's class name.

+ *

+ * @return string Class name of wrapped task.

+ */

+ public function get_name()

+ {

+ return get_class($this->task);

+ }

+

+ /**

+ * Returns a url through which this task may be invoked via web.

+ *

+ * When system cron is not in use, running a cron task is accomplished

+ * by outputting an image with the url returned by this function as

+ * source.

+ *

+ * @return string URL through which this task may be invoked.

+ */

+ public function get_url()

+ {

+ global $phpbb_root_path, $phpEx;

+

+ $name = $this->get_name();

+ if ($this->is_parametrized())

+ {

+ $params = $this->task->get_parameters();

+ $extra = '';

+ foreach ($params as $key => $value)

+ {

+ $extra .= '&amp;' . $key . '=' . urlencode($value);

+ }

+ }

+ else

+ {

+ $extra = '';

+ }

+ $url = append_sid($phpbb_root_path . 'cron.' . $phpEx, 'cron_type=' . $name . $extra);

+ return $url;

+ }

+

+ /**

+ * Forwards all other method calls to the wrapped task implementation.

+ *

+ * @return mixed

+ */

+ public function __call($name, $args)

+ {

+ return call_user_func_array(array($this->task, $name), $args);

+ }

+}

+ * Returns SQL string to cast a string expression to an int.

+ *

+ * @param string $expression An expression evaluating to string

+ * @return string Expression returning an int

+ */

+ function cast_expr_to_bigint($expression)

+ {

+ return $expression;

+ }

+

+ /**

+ * Returns SQL string to cast an integer expression to a string.

+ *

+ * @param string $expression An expression evaluating to int

+ * @return string Expression returning a string

+ */

+ function cast_expr_to_string($expression)

+ {

+ return $expression;

+ }

+

+ /**

+ global $request;

+ if (is_object($request) && !$request->variable('explain', false))

+ echo '<!DOCTYPE html>

+ <html dir="ltr">

+ <meta charset="utf-8">

+ * @inheritdoc

+ */

+ function cast_expr_to_bigint($expression)

+ {

+ // Precision must be from 1 to 18

+ return 'CAST(' . $expression . ' as DECIMAL(18, 0))';

+ }

+

+ /**

+ * @inheritdoc

+ */

+ function cast_expr_to_string($expression)

+ {

+ return 'CAST(' . $expression . ' as VARCHAR(255))';

+ }

+

+ /**

+ $this->db_connect_id = ($this->persistency) ? @mssql_pconnect($this->server, $this->user, $sqlpassword, $new_link) : @mssql_connect($this->server, $this->user, $sqlpassword, $new_link);

+ * @inheritdoc

+ */

+ function cast_expr_to_bigint($expression)

+ {

+ return 'CAST(' . $expression . ' as DECIMAL(255, 0))';

+ }

+

+ /**

+ * @inheritdoc

+ */

+ function cast_expr_to_string($expression)

+ {

+ return 'CAST(' . $expression . ' as VARCHAR(255))';

+ }

+

+ /**

+* Casts a variable to the given type.

+* @deprecated

+ // no need for dependency injection here, if you have the object, call the method yourself!

+ $type_cast_helper = new phpbb_request_type_cast_helper();

+ $type_cast_helper->set_var($result, $var, $type, $multibyte);

+* Wrapper function of phpbb_request::variable which exists for backwards compatability.

+* See {@link phpbb_request_interface::variable phpbb_request_interface::variable} for

+* documentation of this function's use.

+* @deprecated

+* @param mixed $var_name The form variable's name from which data shall be retrieved.

+* If the value is an array this may be an array of indizes which will give

+* direct access to a value at any depth. E.g. if the value of "var" is array(1 => "a")

+* then specifying array("var", 1) as the name will return "a".

+* If you pass an instance of {@link phpbb_request_interface phpbb_request_interface}

+* as this parameter it will overwrite the current request class instance. If you do

+* not do so, it will create its own instance (but leave superglobals enabled).

+* @param mixed $default A default value that is returned if the variable was not set.

+* This function will always return a value of the same type as the default.

+* @param bool $multibyte If $default is a string this paramater has to be true if the variable may contain any UTF-8 characters

+* Default is false, causing all bytes outside the ASCII range (0-127) to be replaced with question marks

+* @param bool $cookie This param is mapped to phpbb_request_interface::COOKIE as the last param for

+* phpbb_request_interface::variable for backwards compatability reasons.

+* @param phpbb_request_interface|null|false If an instance of phpbb_request_interface is given the instance is stored in