+ 'max_attachments' => array('lang' => 'MAX_ATTACHMENTS', 'validate' => 'int:0:999', 'type' => 'number:0:999', 'explain' => false),

+ 'max_attachments_pm' => array('lang' => 'MAX_ATTACHMENTS_PM', 'validate' => 'int:0:999', 'type' => 'number:0:999', 'explain' => false),

+ 'img_max_thumb_width' => array('lang' => 'MAX_THUMB_WIDTH', 'validate' => 'int:0:999999999999999', 'type' => 'number:0:999999999999999', 'explain' => true, 'append' => ' ' . $user->lang['PIXEL']),

+ 'img_min_thumb_filesize' => array('lang' => 'MIN_THUMB_FILESIZE', 'validate' => 'int:0:999999999999999', 'type' => 'number:0:999999999999999', 'explain' => true, 'append' => ' ' . $user->lang['BYTES']),

+ 'img_max' => array('lang' => 'MAX_IMAGE_SIZE', 'validate' => 'int:0:9999', 'type' => 'dimension:0:9999', 'explain' => true, 'append' => ' ' . $user->lang['PIXEL']),

+ 'img_link' => array('lang' => 'IMAGE_LINK_SIZE', 'validate' => 'int:0:9999', 'type' => 'dimension:0:9999', 'explain' => true, 'append' => ' ' . $user->lang['PIXEL']),

+ FROM ' . ATTACHMENTS_TABLE . ' a

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

+ // size="8" and maxlength="15" attributes as a fallback for browsers that do not support type="number" yet.

+ return '<input type="number" id="' . $key . '" size="8" maxlength="15" min="0" name="config[' . $key . ']" value="' . $value . '" /> <select name="' . $key . '">' . size_select_options($size_var) . '</select>';

+ 'site_home_url' => array('lang' => 'SITE_HOME_URL', 'validate' => 'string', 'type' => 'url:40:255', 'explain' => true),

+ 'warnings_expire_days' => array('lang' => 'WARNINGS_EXPIRE', 'validate' => 'int:0:9999', 'type' => 'number:0:9999', 'explain' => true, 'append' => ' ' . $user->lang['DAYS']),

+ 'avatar_min' => array('lang' => 'MIN_AVATAR_SIZE', 'validate' => 'int:0', 'type' => 'dimension:0', 'explain' => true, 'append' => ' ' . $user->lang['PIXEL']),

+ 'avatar_max' => array('lang' => 'MAX_AVATAR_SIZE', 'validate' => 'int:0', 'type' => 'dimension:0', 'explain' => true, 'append' => ' ' . $user->lang['PIXEL']),

+ 'pm_max_boxes' => array('lang' => 'BOXES_MAX', 'validate' => 'int:0:9999', 'type' => 'number:0:9999', 'explain' => true),

+ 'pm_max_msgs' => array('lang' => 'BOXES_LIMIT', 'validate' => 'int:0:9999', 'type' => 'number:0:9999', 'explain' => true),

+ 'pm_edit_time' => array('lang' => 'PM_EDIT_TIME', 'validate' => 'int:0:99999', 'type' => 'number:0:99999', 'explain' => true, 'append' => ' ' . $user->lang['MINUTES']),

+ 'pm_max_recipients' => array('lang' => 'PM_MAX_RECIPIENTS', 'validate' => 'int:0:99999', 'type' => 'number:0:99999', 'explain' => true),

+ 'edit_time' => array('lang' => 'EDIT_TIME', 'validate' => 'int:0:99999', 'type' => 'number:0:99999', 'explain' => true, 'append' => ' ' . $user->lang['MINUTES']),

+ 'delete_time' => array('lang' => 'DELETE_TIME', 'validate' => 'int:0:99999', 'type' => 'number:0:99999', 'explain' => true, 'append' => ' ' . $user->lang['MINUTES']),

+ 'flood_interval' => array('lang' => 'FLOOD_INTERVAL', 'validate' => 'int:0:9999999999', 'type' => 'number:0:9999999999', 'explain' => true, 'append' => ' ' . $user->lang['SECONDS']),

+ 'topics_per_page' => array('lang' => 'TOPICS_PER_PAGE', 'validate' => 'int:1:9999', 'type' => 'number:1:9999', 'explain' => false),

+ 'posts_per_page' => array('lang' => 'POSTS_PER_PAGE', 'validate' => 'int:1:9999', 'type' => 'number:1:9999', 'explain' => false),

+ 'smilies_per_page' => array('lang' => 'SMILIES_PER_PAGE', 'validate' => 'int:1:9999', 'type' => 'number:1:9999', 'explain' => false),

+ 'hot_threshold' => array('lang' => 'HOT_THRESHOLD', 'validate' => 'int:0:9999', 'type' => 'number:0:9999', 'explain' => true),

+ 'max_poll_options' => array('lang' => 'MAX_POLL_OPTIONS', 'validate' => 'int:2:127', 'type' => 'number:2:127', 'explain' => false),

+ 'max_post_chars' => array('lang' => 'CHAR_LIMIT', 'validate' => 'int:0:999999', 'type' => 'number:0:999999', 'explain' => true),

+ 'min_post_chars' => array('lang' => 'MIN_CHAR_LIMIT', 'validate' => 'int:1:999999', 'type' => 'number:1:999999', 'explain' => true),

+ 'max_post_smilies' => array('lang' => 'SMILIES_LIMIT', 'validate' => 'int:0:9999', 'type' => 'number:0:9999', 'explain' => true),

+ 'max_post_urls' => array('lang' => 'MAX_POST_URLS', 'validate' => 'int:0:9999', 'type' => 'number:0:9999', 'explain' => true),

+ 'max_post_font_size' => array('lang' => 'MAX_POST_FONT_SIZE', 'validate' => 'int:0:9999', 'type' => 'number:0:9999', 'explain' => true, 'append' => ' %'),

+ 'max_quote_depth' => array('lang' => 'QUOTE_DEPTH_LIMIT', 'validate' => 'int:0:9999', 'type' => 'number:0:9999', 'explain' => true),

+ 'max_post_img_width' => array('lang' => 'MAX_POST_IMG_WIDTH', 'validate' => 'int:0:9999', 'type' => 'number:0:9999', 'explain' => true, 'append' => ' ' . $user->lang['PIXEL']),

+ 'max_post_img_height' => array('lang' => 'MAX_POST_IMG_HEIGHT', 'validate' => 'int:0:9999', 'type' => 'number:0:9999', 'explain' => true, 'append' => ' ' . $user->lang['PIXEL']),

+ 'max_sig_chars' => array('lang' => 'MAX_SIG_LENGTH', 'validate' => 'int:0:9999', 'type' => 'number:0:9999', 'explain' => true),

+ 'max_sig_urls' => array('lang' => 'MAX_SIG_URLS', 'validate' => 'int:0:9999', 'type' => 'number:0:9999', 'explain' => true),

+ 'max_sig_font_size' => array('lang' => 'MAX_SIG_FONT_SIZE', 'validate' => 'int:0:9999', 'type' => 'number:0:9999', 'explain' => true, 'append' => ' %'),

+ 'max_sig_smilies' => array('lang' => 'MAX_SIG_SMILIES', 'validate' => 'int:0:9999', 'type' => 'number:0:9999', 'explain' => true),

+ 'max_sig_img_width' => array('lang' => 'MAX_SIG_IMG_WIDTH', 'validate' => 'int:0:9999', 'type' => 'number:0:9999', 'explain' => true, 'append' => ' ' . $user->lang['PIXEL']),

+ 'max_sig_img_height' => array('lang' => 'MAX_SIG_IMG_HEIGHT', 'validate' => 'int:0:9999', 'type' => 'number:0:9999', 'explain' => true, 'append' => ' ' . $user->lang['PIXEL']),

+ 'new_member_post_limit' => array('lang' => 'NEW_MEMBER_POST_LIMIT', 'validate' => 'int:0:255', 'type' => 'number:0:255', 'explain' => true, 'append' => ' ' . $user->lang['POSTS']),

+ 'chg_passforce' => array('lang' => 'FORCE_PASS_CHANGE', 'validate' => 'int:0:999', 'type' => 'number:0:999', 'explain' => true, 'append' => ' ' . $user->lang['DAYS']),

+ 'max_login_attempts' => array('lang' => 'MAX_LOGIN_ATTEMPTS', 'validate' => 'int:0:999', 'type' => 'number:0:999', 'explain' => true),

+ 'max_reg_attempts' => array('lang' => 'REG_LIMIT', 'validate' => 'int:0:9999', 'type' => 'number:0:9999', 'explain' => true),

+ 'feed_limit_post' => array('lang' => 'ACP_FEED_LIMIT', 'validate' => 'int:5:9999', 'type' => 'number:5:9999', 'explain' => true),

+ 'feed_limit_topic' => array('lang' => 'ACP_FEED_LIMIT', 'validate' => 'int:5:9999', 'type' => 'number:5:9999', 'explain' => true),

+ 'limit_load' => array('lang' => 'LIMIT_LOAD', 'validate' => 'int:0:9999', 'type' => 'number:0:9999', 'explain' => true),

+ 'session_length' => array('lang' => 'SESSION_LENGTH', 'validate' => 'int:60:9999999999', 'type' => 'number:60:9999999999', 'explain' => true, 'append' => ' ' . $user->lang['SECONDS']),

+ 'active_sessions' => array('lang' => 'LIMIT_SESSIONS', 'validate' => 'int:0:9999', 'type' => 'number:0:9999', 'explain' => true),

+ 'load_online_time' => array('lang' => 'ONLINE_LENGTH', 'validate' => 'int:0:999', 'type' => 'number:0:999', 'explain' => true, 'append' => ' ' . $user->lang['MINUTES']),

+ 'server_port' => array('lang' => 'SERVER_PORT', 'validate' => 'int:0:99999', 'type' => 'number:0:99999', 'explain' => true),

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

+ 'max_autologin_time' => array('lang' => 'AUTOLOGIN_LENGTH', 'validate' => 'int:0:99999', 'type' => 'number:0:99999', 'explain' => true, 'append' => ' ' . $user->lang['DAYS']),

+ 'chg_passforce' => array('lang' => 'FORCE_PASS_CHANGE', 'validate' => 'int:0:999', 'type' => 'number:0:999', 'explain' => true, 'append' => ' ' . $user->lang['DAYS']),

+ 'max_login_attempts' => array('lang' => 'MAX_LOGIN_ATTEMPTS', 'validate' => 'int:0:999', 'type' => 'number:0:999', 'explain' => true),

+ 'ip_login_limit_max' => array('lang' => 'IP_LOGIN_LIMIT_MAX', 'validate' => 'int:0:999', 'type' => 'number:0:999', 'explain' => true),

+ 'ip_login_limit_time' => array('lang' => 'IP_LOGIN_LIMIT_TIME', 'validate' => 'int:0:99999', 'type' => 'number:0:99999', 'explain' => true, 'append' => ' ' . $user->lang['SECONDS']),

+ 'form_token_lifetime' => array('lang' => 'FORM_TIME_MAX', 'validate' => 'int:-1:99999', 'type' => 'number:-1:99999', 'explain' => true, 'append' => ' ' . $user->lang['SECONDS']),

+ 'email_package_size' => array('lang' => 'EMAIL_PACKAGE_SIZE', 'validate' => 'int:0', 'type' => 'number:0:99999', 'explain' => true),

+ 'board_contact' => array('lang' => 'CONTACT_EMAIL', 'validate' => 'email', 'type' => 'email:25:100', 'explain' => true),

+ 'board_email' => array('lang' => 'ADMIN_EMAIL', 'validate' => 'email', 'type' => 'email:25:100', 'explain' => true),

+ 'smtp_port' => array('lang' => 'SMTP_PORT', 'validate' => 'int:0:99999', 'type' => 'number:0:99999', 'explain' => true),

+ }

+ return '<input id="' . $key . '" type="number" size="3" maxlength="3" min="1" max="999" name="config[min_name_chars]" value="' . $value . '" /> ' . $user->lang['MIN_CHARS'] . '&nbsp;&nbsp;<input type="number" size="3" maxlength="3" min="8" max="180" name="config[max_name_chars]" value="' . $this->new_config['max_name_chars'] . '" /> ' . $user->lang['MAX_CHARS'];

+ return '<input id="' . $key . '" type="number" size="3" maxlength="3" min="1" max="999" name="config[min_pass_chars]" value="' . $value . '" /> ' . $user->lang['MIN_CHARS'] . '&nbsp;&nbsp;<input type="number" size="3" maxlength="3" min="8" max="255" name="config[max_pass_chars]" value="' . $this->new_config['max_pass_chars'] . '" /> ' . $user->lang['MAX_CHARS'];

+ // What is a safe limit of execution time? Half the max execution time should be safe.

+ $safe_time_limit = (ini_get('max_execution_time') / 2);

+ $start_time = time();

+

+ $md_manager = new phpbb_extension_metadata_manager($ext_name, $config, $phpbb_extension_manager, $template, $phpbb_root_path);

+ while ($phpbb_extension_manager->enable_step($ext_name))

+ // Are we approaching the time limit? If so we want to pause the update and continue after refreshing

+ if ((time() - $start_time) >= $safe_time_limit)

+ {

+ $template->assign_var('S_NEXT_STEP', true);

+ meta_refresh(0, $this->u_action . '&amp;action=enable&amp;ext_name=' . urlencode($ext_name));

+ }

+ while ($phpbb_extension_manager->disable_step($ext_name))

+ // Are we approaching the time limit? If so we want to pause the update and continue after refreshing

+ if ((time() - $start_time) >= $safe_time_limit)

+ {

+ $template->assign_var('S_NEXT_STEP', true);

+ meta_refresh(0, $this->u_action . '&amp;action=disable&amp;ext_name=' . urlencode($ext_name));

+ }

+ while ($phpbb_extension_manager->purge_step($ext_name))

+ // Are we approaching the time limit? If so we want to pause the update and continue after refreshing

+ if ((time() - $start_time) >= $safe_time_limit)

+ {

+ $template->assign_var('S_NEXT_STEP', true);

+ meta_refresh(0, $this->u_action . '&amp;action=purge&amp;ext_name=' . urlencode($ext_name));

+ }

+ if (!check_form_key($form_key))

+ {

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

+ }

+

+ if (!check_form_key($form_key))

+ {

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

+ }

+

+

+ // Merge any avatar errors into the primary error array

+ $error = array_merge($error, $phpbb_avatar_manager->localize_errors($user, $avatar_error));

+ /*

+ * Validate the length of "Maximum number of allowed recipients per

+ * private message" setting. We use 16777215 as a maximum because it matches

+ * MySQL unsigned mediumint maximum value which is the lowest amongst DBMSes

+ * supported by phpBB3. Also validate the submitted colour value.

+ */

+ $validation_checks = array(

+ 'max_recipients' => array('num', false, 0, 16777215),

+ 'colour' => array('hex_colour', true),

+ );

+

+ if ($validation_error = validate_data($submit_ary, $validation_checks))

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

+ if (isset($phpbb_avatar_manager) && !$update)

+ {

+ // Merge any avatar errors into the primary error array

+ $error = array_merge($error, $phpbb_avatar_manager->localize_errors($user, $avatar_error));

+ }

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

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

+ global $phpbb_extension_manager, $phpbb_root_path, $phpEx;

+ $finder = $phpbb_extension_manager->get_finder();

+ $modules = $finder

+ ->extension_suffix('_module')

+ ->extension_directory("/$module_class")

+ ->core_path("includes/$module_class/info/")

+ ->core_prefix($module_class . '_')

+ ->get_classes(true, $use_all_available);

+ foreach ($modules as $cur_module)

+ {

+ // Skip entries we do not need if we know the module we are

+ // looking for

+ if ($module && strpos($cur_module, $module) === false)

+ continue;

+ $info_class = preg_replace('/_module$/', '_info', $cur_module);

+ // If the class does not exist it might be following the old

+ // format. phpbb_acp_info_acp_foo needs to be turned into

+ // acp_foo_info and the respective file has to be included

+ // manually because it does not support auto loading

+ $info_class_file = str_replace("phpbb_{$module_class}_info_", '', $cur_module);

+ $info_class = $info_class_file . '_info';

+ if (!class_exists($info_class) && file_exists($directory . $info_class_file . '.' . $phpEx))

+ include($directory . $info_class_file . '.' . $phpEx);

+ $main_class = (isset($module_info['filename'])) ? $module_info['filename'] : $cur_module;

+ ksort($fileinfo);

+

+ if (empty($info))

+ <dd><input type="email" id="ldap_email" size="40" name="config[ldap_email]" value="' . $new['ldap_email'] . '" /></dd>

+ 'avatar_filesize' => array('lang' => 'MAX_FILESIZE', 'validate' => 'int:0', 'type' => 'number:0', 'explain' => true, 'append' => ' ' . $user->lang['BYTES']),

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_data_310_forgot_password extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

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

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_11');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.add', array('allow_password_reset', 1)),

+ );

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_data_310_jquery_update extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return $this->config['load_jquery_url'] !== '//ajax.googleapis.com/ajax/libs/jquery/1.6.2/jquery.min.js';

+ }

+

+ static public function depends_on()

+ {

+ return array(

+ 'phpbb_db_migration_data_310_dev',

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('load_jquery_url', '//ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js')),

+ );

+ }

+

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_data_310_notifications_schema_fix extends phpbb_db_migration

+{

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_310_notifications');

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'drop_tables' => array(

+ $this->table_prefix . 'notification_types',

+ $this->table_prefix . 'notifications',

+ ),

+ 'add_tables' => array(

+ $this->table_prefix . 'notification_types' => array(

+ 'COLUMNS' => array(

+ 'notification_type_id' => array('USINT', NULL, 'auto_increment'),

+ 'notification_type_name' => array('VCHAR:255', ''),

+ 'notification_type_enabled' => array('BOOL', 1),

+ ),

+ 'PRIMARY_KEY' => array('notification_type_id'),

+ 'KEYS' => array(

+ 'type' => array('UNIQUE', array('notification_type_name')),

+ ),

+ ),

+ $this->table_prefix . 'notifications' => array(

+ 'COLUMNS' => array(

+ 'notification_id' => array('UINT:10', NULL, 'auto_increment'),

+ 'notification_type_id' => array('USINT', 0),

+ 'item_id' => array('UINT', 0),

+ 'item_parent_id' => array('UINT', 0),

+ 'user_id' => array('UINT', 0),

+ 'notification_read' => array('BOOL', 0),

+ 'notification_time' => array('TIMESTAMP', 1),

+ 'notification_data' => array('TEXT_UNI', ''),

+ ),

+ 'PRIMARY_KEY' => 'notification_id',

+ 'KEYS' => array(

+ 'item_ident' => array('INDEX', array('notification_type_id', 'item_id')),

+ 'user' => array('INDEX', array('user_id', 'notification_read')),

+ ),

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'drop_tables' => array(

+ $this->table_prefix . 'notification_types',

+ $this->table_prefix . 'notifications',

+ ),

+ 'add_tables' => array(

+ $this->table_prefix . 'notification_types' => array(

+ 'COLUMNS' => array(

+ 'notification_type' => array('VCHAR:255', ''),

+ 'notification_type_enabled' => array('BOOL', 1),

+ ),

+ 'PRIMARY_KEY' => array('notification_type', 'notification_type_enabled'),

+ ),

+ $this->table_prefix . 'notifications' => array(

+ 'COLUMNS' => array(

+ 'notification_id' => array('UINT', NULL, 'auto_increment'),

+ 'item_type' => array('VCHAR:255', ''),

+ 'item_id' => array('UINT', 0),

+ 'item_parent_id' => array('UINT', 0),

+ 'user_id' => array('UINT', 0),

+ 'notification_read' => array('BOOL', 0),

+ 'notification_time' => array('TIMESTAMP', 1),

+ 'notification_data' => array('TEXT_UNI', ''),

+ ),

+ 'PRIMARY_KEY' => 'notification_id',

+ 'KEYS' => array(

+ 'item_ident' => array('INDEX', array('item_type', 'item_id')),

+ 'user' => array('INDEX', array('user_id', 'notification_read')),

+ ),

+ ),

+ ),

+ );

+ }

+}

+ $module_log_name = ((isset($this->user->lang[$data['module_langname']])) ? $this->user->lang[$data['module_langname']] : $data['module_langname']);

+ add_log('admin', 'LOG_MODULE_ADD', $module_log_name);

+ /** @var phpbb_extension_finder */

+ protected $finder;

+

+ /** @var phpbb_db_migrator */

+ protected $migrator;

+

+ /** @var string */

+ protected $extension_name;

+

+ /** @var string */

+ protected $extension_path;

+

+ * @param phpbb_extension_finder $extension_finder

+ * @param string $extension_name Name of this extension (from ext.manager)

+ * @param string $extension_path Relative path to this extension

+ public function __construct(ContainerInterface $container, phpbb_extension_finder $extension_finder, phpbb_db_migrator $migrator, $extension_name, $extension_path)

+ $this->extension_finder = $extension_finder;

+ $this->migrator = $migrator;

+

+ $this->extension_name = $extension_name;

+ $this->extension_path = $extension_path;

+ * Single enable step that installs any included migrations

+ $migrations = $this->get_migration_file_list();

+

+ $this->migrator->set_migrations($migrations);

+

+ $this->migrator->update();

+

+ return !$this->migrator->finished();

+ * Single purge step that reverts any included and installed migrations

+ $migrations = $this->get_migration_file_list();

+

+ $this->migrator->set_migrations($migrations);

+

+ foreach ($migrations as $migration)

+ {

+ while ($this->migrator->migration_state($migration) !== false)

+ {

+ $this->migrator->revert($migration);

+

+ return true;

+ }

+ }

+

+

+ /**

+ * Get the list of migration files from this extension

+ *

+ * @return array

+ */

+ protected function get_migration_file_list()

+ {

+ static $migrations = false;

+

+ if ($migrations !== false)

+ {

+ return $migrations;

+ }

+

+ // Only have the finder search in this extension path directory

+ $migrations = $this->extension_finder

+ ->extension_directory('/migrations')

+ ->find_from_extension($this->extension_name, $this->extension_path);

+ $migrations = $this->extension_finder->get_classes_from_files($migrations);

+

+ return $migrations;

+ }

+

+ /**

+ * Finds all file system entries matching the configured options for one

+ * specific extension

+ *

+ * @param string $extension_name Name of the extension

+ * @param string $extension_path Relative path to the extension root directory

+ * @param bool $cache Whether the result should be cached

+ * @param bool $is_dir Directories will be returned when true, only files

+ * otherwise

+ * @return array An array of paths to found items

+ */

+ public function find_from_extension($extension_name, $extension_path, $cache = true, $is_dir = false)

+ {

+ $extensions = array(

+ $extension_name => $extension_path,

+ );

+

+ $files = array();

+ $file_list = $this->find_from_paths($extensions, $cache, $is_dir);

+

+ foreach ($file_list as $file)

+ {

+ $files[$file['named_path']] = $file['ext_name'];

+ }

+

+ return $files;

+ }

+ public function __construct(ContainerInterface $container, phpbb_db_driver $db, phpbb_config $config, phpbb_filesystem $filesystem, $extension_table, $phpbb_root_path, $php_ext = 'php', phpbb_cache_driver_interface $cache = null, $cache_name = '_ext')

+ $migrator = $this->container->get('migrator');

+

+ return new $extension_class_name($this->container, $this->get_finder(), $migrator, $name, $this->get_extension_path($name, true));

+ return new phpbb_extension_base($this->container, $this->get_finder(), $migrator, $name, $this->get_extension_path($name, true));

+ return new phpbb_extension_metadata_manager($name, $this->config, $this, $template, $this->phpbb_root_path);

+ $sql = 'SELECT COUNT(ext_name) as row_count

+ FROM ' . $this->extension_table . "

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

+ $count = $this->db->sql_fetchfield('row_count');

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

+ if ($count)

+ {

+ $sql = 'UPDATE ' . $this->extension_table . '

+ SET ' . $this->db->sql_build_array('UPDATE', $extension_data) . "

+ WHERE ext_name = '" . $this->db->sql_escape($name) . "'";

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

+ }

+ else

+ /**

+ * phpBB Config instance

+ * @var phpbb_config

+ */

+ protected $config;

+

+ /**

+ * phpBB Extension Manager

+ * @var phpbb_extension_manager

+ */

+

+ /**

+ * phpBB Template instance

+ * @var phpbb_template

+ */

+

+ /**

+ * phpBB root path

+ * @var string

+ */

+ protected $phpbb_root_path;

+

+ /**

+ * Name (including vendor) of the extension

+ * @var string

+ */

+

+ /**

+ * Metadata from the composer.json file

+ * @var array

+ */

+

+ /**

+ * Link (including root path) to the metadata file

+ * @var string

+ */

+ * @param string $ext_name Name (including vendor) of the extension

+ * @param phpbb_config $config phpBB Config instance

+ * @param phpbb_extension_manager $extension_manager An instance of the phpBBb extension manager

+ * @param phpbb_template $template phpBB Template instance

+ * @param string $phpbb_root_path Path to the phpbb includes directory.

+ public function __construct($ext_name, phpbb_config $config, phpbb_extension_manager $extension_manager, phpbb_template $template, $phpbb_root_path)

+ $this->template = $template;

+ $this->phpbb_root_path = $phpbb_root_path;

+

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Base class with some generic functions and settings.

+*

+* @package phpBB3

+*/

+abstract class phpbb_feed_base

+{

+ /**

+ * Feed helper object

+ * @var phpbb_feed_helper

+ */

+ protected $helper;

+

+ /** @var phpbb_config */

+ protected $config;

+

+ /** @var phpbb_db_driver */

+ protected $db;

+

+ /** @var phpbb_cache_driver_interface */

+ protected $cache;

+

+ /** @var phpbb_user */

+ protected $user;

+

+ /** @var phpbb_auth */

+ protected $auth;

+

+ /** @var string */

+ protected $phpEx;

+

+ /**

+ * SQL Query to be executed to get feed items

+ */

+ var $sql = array();

+

+ /**

+ * Keys specified for retrieval of title, content, etc.

+ */

+ var $keys = array();

+

+ /**

+ * Number of items to fetch. Usually overwritten by $config['feed_something']

+ */

+ var $num_items = 15;

+

+ /**

+ * Separator for title elements to separate items (for example forum / topic)

+ */

+ var $separator = "\xE2\x80\xA2"; // &bull;

+

+ /**

+ * Separator for the statistics row (Posted by, post date, replies, etc.)

+ */

+ var $separator_stats = "\xE2\x80\x94"; // &mdash;

+

+ /**

+ * Constructor

+ *

+ * @param phpbb_feed_helper $helper Feed helper

+ * @param phpbb_config $config Config object

+ * @param phpbb_db_driver $db Database connection

+ * @param phpbb_cache_driver_interface $cache Cache object

+ * @param phpbb_user $user User object

+ * @param phpbb_auth $auth Auth object

+ * @param string $phpEx php file extension

+ * @return null

+ */

+ function __construct(phpbb_feed_helper $helper, phpbb_config $config, phpbb_db_driver $db, phpbb_cache_driver_interface $cache, phpbb_user $user, phpbb_auth $auth, $phpEx)

+ {

+ $this->config = $config;

+ $this->helper = $helper;

+ $this->db = $db;

+ $this->cache = $cache;

+ $this->user = $user;

+ $this->auth = $auth;

+ $this->phpEx = $phpEx;

+

+ $this->set_keys();

+

+ // Allow num_items to be string

+ if (is_string($this->num_items))

+ {

+ $this->num_items = (int) $this->config[$this->num_items];

+

+ // A precaution

+ if (!$this->num_items)

+ {

+ $this->num_items = 10;

+ }

+ }

+ }

+

+ /**

+ * Set keys.

+ */

+ function set_keys()

+ {

+ }

+

+ /**

+ * Open feed

+ */

+ function open()

+ {

+ }

+

+ /**

+ * Close feed

+ */

+ function close()

+ {

+ if (!empty($this->result))

+ {

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

+ }

+ }

+

+ /**

+ * Set key

+ */

+ function set($key, $value)

+ {

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

+ }

+

+ /**

+ * Get key

+ */

+ function get($key)

+ {

+ return (isset($this->keys[$key])) ? $this->keys[$key] : NULL;

+ }

+

+ function get_readable_forums()

+ {

+ static $forum_ids;

+

+ if (!isset($forum_ids))

+ {

+ $forum_ids = array_keys($this->auth->acl_getf('f_read', true));

+ }

+

+ return $forum_ids;

+ }

+

+ function get_moderator_approve_forums()

+ {

+ static $forum_ids;

+

+ if (!isset($forum_ids))

+ {

+ $forum_ids = array_keys($this->auth->acl_getf('m_approve', true));

+ }

+

+ return $forum_ids;

+ }

+

+ function is_moderator_approve_forum($forum_id)

+ {

+ static $forum_ids;

+

+ if (!isset($forum_ids))

+ {

+ $forum_ids = array_flip($this->get_moderator_approve_forums());

+ }

+

+ return (isset($forum_ids[$forum_id])) ? true : false;

+ }

+

+ function get_excluded_forums()

+ {

+ static $forum_ids;

+

+ // Matches acp/acp_board.php

+ $cache_name = 'feed_excluded_forum_ids';

+

+ if (!isset($forum_ids) && ($forum_ids = $this->cache->get('_' . $cache_name)) === false)

+ {

+ $sql = 'SELECT forum_id

+ FROM ' . FORUMS_TABLE . '

+ WHERE ' . $this->db->sql_bit_and('forum_options', FORUM_OPTION_FEED_EXCLUDE, '<> 0');

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

+

+ $forum_ids = array();

+ while ($forum_id = (int) $this->db->sql_fetchfield('forum_id'))

+ {

+ $forum_ids[$forum_id] = $forum_id;

+ }

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

+

+ $this->cache->put('_' . $cache_name, $forum_ids);

+ }

+

+ return $forum_ids;

+ }

+

+ function is_excluded_forum($forum_id)

+ {

+ $forum_ids = $this->get_excluded_forums();

+

+ return isset($forum_ids[$forum_id]) ? true : false;

+ }

+

+ function get_passworded_forums()

+ {

+ return $this->user->get_passworded_forums();

+ }

+

+ function get_item()

+ {

+ static $result;

+

+ if (!isset($result))

+ {

+ if (!$this->get_sql())

+ {

+ return false;

+ }

+

+ // Query database

+ $sql = $this->db->sql_build_query('SELECT', $this->sql);

+ $result = $this->db->sql_query_limit($sql, $this->num_items);

+ }

+

+ return $this->db->sql_fetchrow($result);

+ }

+

+ function user_viewprofile($row)

+ {

+ $author_id = (int) $row[$this->get('author_id')];

+

+ if ($author_id == ANONYMOUS)

+ {

+ // Since we cannot link to a profile, we just return GUEST

+ // instead of $row['username']

+ return $this->user->lang['GUEST'];

+ }

+

+ return '<a href="' . $this->helper->append_sid('memberlist.' . $this->phpEx, 'mode=viewprofile&amp;u=' . $author_id) . '">' . $row[$this->get('creator')] . '</a>';

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Factory class to return correct object

+* @package phpBB3

+*/

+class phpbb_feed_factory

+{

+ /**

+ * Service container object

+ * @var object

+ */

+ protected $container;

+

+ /** @var phpbb_config */

+ protected $config;

+

+ /** @var phpbb_db_driver */

+ protected $db;

+

+ /**

+ * Constructor

+ *

+ * @param objec $container Container object

+ * @param phpbb_config $config Config object

+ * @param phpbb_db_driver $db Database connection

+ * @return null

+ */

+ public function __construct($container, phpbb_config $config, phpbb_db_driver $db)

+ {

+ $this->container = $container;

+ $this->config = $config;

+ $this->db = $db;

+ }

+

+ /**

+ * Return correct object for specified mode

+ *

+ * @param string $mode The feeds mode.

+ * @param int $forum_id Forum id specified by the script if forum feed provided.

+ * @param int $topic_id Topic id specified by the script if topic feed provided.

+ *

+ * @return object Returns correct feeds object for specified mode.

+ */

+ function get_feed($mode, $forum_id, $topic_id)

+ {

+ switch ($mode)

+ {

+ case 'forums':

+ if (!$this->config['feed_overall_forums'])

+ {

+ return false;

+ }

+

+ return $this->container->get('feed.forums');

+ break;

+

+ case 'topics':

+ case 'topics_new':

+ if (!$this->config['feed_topics_new'])

+ {

+ return false;

+ }

+

+ return $this->container->get('feed.topics');

+ break;

+

+ case 'topics_active':

+ if (!$this->config['feed_topics_active'])

+ {

+ return false;

+ }

+

+ return $this->container->get('feed.topics_active');

+ break;

+

+ case 'news':

+ // Get at least one news forum

+ $sql = 'SELECT forum_id

+ FROM ' . FORUMS_TABLE . '

+ WHERE ' . $this->db->sql_bit_and('forum_options', FORUM_OPTION_FEED_NEWS, '<> 0');

+ $result = $this->db->sql_query_limit($sql, 1, 0, 600);

+ $s_feed_news = (int) $this->db->sql_fetchfield('forum_id');

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

+

+ if (!$s_feed_news)

+ {

+ return false;

+ }

+

+ return $this->container->get('feed.news');

+ break;

+

+ default:

+ if ($topic_id && $this->config['feed_topic'])

+ {

+ return $this->container->get('feed.topic')

+ ->set_topic_id($topic_id);

+ }

+ else if ($forum_id && $this->config['feed_forum'])

+ {

+ return $this->container->get('feed.forum')

+ ->set_forum_id($forum_id);

+ }

+ else if ($this->config['feed_overall'])

+ {

+ return $this->container->get('feed.overall');

+ }

+

+ return false;

+ break;

+ }

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Forum feed

+*

+* This will give you the last {$this->num_items} posts made

+* within a specific forum.

+*

+* @package phpBB3

+*/

+class phpbb_feed_forum extends phpbb_feed_post_base

+{

+ var $forum_id = 0;

+ var $forum_data = array();

+

+ /**

+ * Set the Forum ID

+ *

+ * @param int $forum_id Forum ID

+ * @return phpbb_feed_forum

+ */

+ public function set_forum_id($topic_id)

+ {

+ $this->forum_id = (int) $forum_id;

+

+ return $this;

+ }

+

+ function open()

+ {

+ // Check if forum exists

+ $sql = 'SELECT forum_id, forum_name, forum_password, forum_type, forum_options

+ FROM ' . FORUMS_TABLE . '

+ WHERE forum_id = ' . $this->forum_id;

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

+ $this->forum_data = $this->db->sql_fetchrow($result);

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

+

+ if (empty($this->forum_data))

+ {

+ trigger_error('NO_FORUM');

+ }

+

+ // Forum needs to be postable

+ if ($this->forum_data['forum_type'] != FORUM_POST)

+ {

+ trigger_error('NO_FEED');

+ }

+

+ // Make sure forum is not excluded from feed

+ if (phpbb_optionget(FORUM_OPTION_FEED_EXCLUDE, $this->forum_data['forum_options']))

+ {

+ trigger_error('NO_FEED');

+ }

+

+ // Make sure we can read this forum

+ if (!$this->auth->acl_get('f_read', $this->forum_id))

+ {

+ trigger_error('SORRY_AUTH_READ');

+ }

+

+ // Make sure forum is not passworded or user is authed

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

+ {

+ $forum_ids_passworded = $this->get_passworded_forums();

+

+ if (isset($forum_ids_passworded[$this->forum_id]))

+ {

+ trigger_error('SORRY_AUTH_READ');

+ }

+

+ unset($forum_ids_passworded);

+ }

+ }

+

+ function get_sql()

+ {

+ $m_approve = ($this->auth->acl_get('m_approve', $this->forum_id)) ? true : false;

+

+ // Determine topics with recent activity

+ $sql = 'SELECT topic_id, topic_last_post_time

+ FROM ' . TOPICS_TABLE . '

+ WHERE forum_id = ' . $this->forum_id . '

+ AND topic_moved_id = 0

+ ' . ((!$m_approve) ? 'AND topic_approved = 1' : '') . '

+ ORDER BY topic_last_post_time DESC';

+ $result = $this->db->sql_query_limit($sql, $this->num_items);

+

+ $topic_ids = array();

+ $min_post_time = 0;

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

+ {

+ $topic_ids[] = (int) $row['topic_id'];

+

+ $min_post_time = (int) $row['topic_last_post_time'];

+ }

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

+

+ if (empty($topic_ids))

+ {

+ return false;

+ }

+

+ $this->sql = array(

+ 'SELECT' => 'p.post_id, p.topic_id, p.post_time, p.post_edit_time, p.post_approved, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, ' .

+ 'u.username, u.user_id',

+ 'FROM' => array(

+ POSTS_TABLE => 'p',

+ USERS_TABLE => 'u',

+ ),

+ 'WHERE' => $this->db->sql_in_set('p.topic_id', $topic_ids) . '

+ ' . ((!$m_approve) ? 'AND p.post_approved = 1' : '') . '

+ AND p.post_time >= ' . $min_post_time . '

+ AND p.poster_id = u.user_id',

+ 'ORDER_BY' => 'p.post_time DESC',

+ );

+

+ return true;

+ }

+

+ function adjust_item(&$item_row, &$row)

+ {

+ parent::adjust_item($item_row, $row);

+

+ $item_row['title'] = (isset($row['forum_name']) && $row['forum_name'] !== '') ? $row['forum_name'] . ' ' . $this->separator . ' ' . $item_row['title'] : $item_row['title'];

+ }

+

+ function get_item()

+ {

+ return ($row = parent::get_item()) ? array_merge($this->forum_data, $row) : $row;

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* 'All Forums' feed

+*

+* This will give you a list of all postable forums where feeds are enabled

+* including forum description, topic stats and post stats

+*

+* @package phpBB3

+*/

+class phpbb_feed_forums extends phpbb_feed_base

+{

+ var $num_items = 0;

+

+ function set_keys()

+ {

+ $this->set('title', 'forum_name');

+ $this->set('text', 'forum_desc');

+ $this->set('bitfield', 'forum_desc_bitfield');

+ $this->set('bbcode_uid','forum_desc_uid');

+ $this->set('updated', 'forum_last_post_time');

+ $this->set('options', 'forum_desc_options');

+ }

+

+ function get_sql()

+ {

+ $in_fid_ary = array_diff($this->get_readable_forums(), $this->get_excluded_forums());

+ if (empty($in_fid_ary))

+ {

+ return false;

+ }

+

+ // Build SQL Query

+ $this->sql = array(

+ 'SELECT' => 'f.forum_id, f.left_id, f.forum_name, f.forum_last_post_time,

+ f.forum_desc, f.forum_desc_bitfield, f.forum_desc_uid, f.forum_desc_options,

+ f.forum_topics, f.forum_posts',

+ 'FROM' => array(FORUMS_TABLE => 'f'),

+ 'WHERE' => 'f.forum_type = ' . FORUM_POST . '

+ AND ' . $this->db->sql_in_set('f.forum_id', $in_fid_ary),

+ 'ORDER_BY' => 'f.left_id ASC',

+ );

+

+ return true;

+ }

+

+ function adjust_item(&$item_row, &$row)

+ {

+ $item_row['link'] = $this->helper->append_sid('viewforum.' . $this->phpEx, 'f=' . $row['forum_id']);

+

+ if ($this->config['feed_item_statistics'])

+ {

+ $item_row['statistics'] = $this->user->lang('TOTAL_TOPICS', (int) $row['forum_topics'])

+ . ' ' . $this->separator_stats . ' ' . $this->user->lang('TOTAL_POSTS_COUNT', (int) $row['forum_posts']);

+ }

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Class with some helpful functions used in feeds

+* @package phpBB3

+*/

+class phpbb_feed_helper

+{

+ /** @var phpbb_config */

+ protected $config;

+

+ /** @var phpbb_user */

+ protected $user;

+

+ /** @var string */

+ protected $phpbb_root_path;

+

+ /**

+ * Constructor

+ *

+ * @param phpbb_config $config Config object

+ * @param phpbb_user $user User object

+ * @param string $phpbb_root_path Root path

+ * @return null

+ */

+ public function __construct(phpbb_config $config, phpbb_user $user, $phpbb_root_path)

+ {

+ $this->config = $config;

+ $this->user = $user;

+ $this->phpbb_root_path = $phpbb_root_path;

+ }

+

+ /**

+ * Run links through append_sid(), prepend generate_board_url() and remove session id

+ */

+ public function get_board_url()

+ {

+ static $board_url;

+

+ if (empty($board_url))

+ {

+ $board_url = generate_board_url();

+ }

+

+ return $board_url;

+ }

+

+ /**

+ * Run links through append_sid(), prepend generate_board_url() and remove session id

+ */

+ public function append_sid($url, $params)

+ {

+ return append_sid($this->get_board_url() . '/' . $url, $params, true, '');

+ }

+

+ /**

+ * Generate ISO 8601 date string (RFC 3339)

+ */

+ public function format_date($time)

+ {

+ static $zone_offset;

+ static $offset_string;

+

+ if (empty($offset_string))

+ {

+ $zone_offset = $this->user->create_datetime()->getOffset();

+ $offset_string = phpbb_format_timezone_offset($zone_offset);

+ }

+

+ return gmdate("Y-m-d\TH:i:s", $time + $zone_offset) . $offset_string;

+ }

+

+ /**

+ * Generate text content

+ */

+ public function generate_content($content, $uid, $bitfield, $options)

+ {

+ if (empty($content))

+ {

+ return '';

+ }

+

+ // Prepare some bbcodes for better parsing

+ $content = preg_replace("#\[quote(=&quot;.*?&quot;)?:$uid\]\s*(.*?)\s*\[/quote:$uid\]#si", "[quote$1:$uid]<br />$2<br />[/quote:$uid]", $content);

+

+ $content = generate_text_for_display($content, $uid, $bitfield, $options);

+

+ // Add newlines

+ $content = str_replace('<br />', '<br />' . "\n", $content);

+

+ // Convert smiley Relative paths to Absolute path, Windows style

+ $content = str_replace($this->phpbb_root_path . $this->config['smilies_path'], $this->get_board_url() . '/' . $this->config['smilies_path'], $content);

+

+ // 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 = preg_replace('#(onkeypress|onclick)="(.*?)"#si', '', $content);

+

+ // Firefox does not support CSS for feeds, though

+

+ // Remove font sizes

+ // $content = preg_replace('#<span style="font-size: [0-9]+%; line-height: [0-9]+%;">([^>]+)</span>#iU', '\1', $content);

+

+ // Make text strong :P

+ // $content = preg_replace('#<span style="font-weight: bold?">(.*?)</span>#iU', '<strong>\1</strong>', $content);

+

+ // Italic

+ // $content = preg_replace('#<span style="font-style: italic?">([^<]+)</span>#iU', '<em>\1</em>', $content);

+

+ // Underline

+ // $content = preg_replace('#<span style="text-decoration: underline?">([^<]+)</span>#iU', '<u>\1</u>', $content);

+

+ // Remove embed Windows Media Streams

+ $content = preg_replace( '#<\!--\[if \!IE\]>-->([^[]+)<\!--<!\[endif\]-->#si', '', $content);

+

+ // Do not use &lt; and &gt;, because we want to retain code contained in [code][/code]

+

+ // Remove embed and objects

+ $content = preg_replace( '#<(object|embed)(.*?) (value|src)=(.*?) ([^[]+)(object|embed)>#si',' <a href=$4 target="_blank"><strong>$1</strong></a> ',$content);

+

+ // Remove some specials html tag, because somewhere there are a mod to allow html tags ;)

+ $content = preg_replace( '#<(script|iframe)([^[]+)\1>#siU', ' <strong>$1</strong> ', $content);

+

+ // Remove Comments from inline attachments [ia]

+ $content = preg_replace('#<div class="(inline-attachment|attachtitle)">(.*?)<!-- ia(.*?) -->(.*?)<!-- ia(.*?) -->(.*?)</div>#si','$4',$content);

+

+ // Replace some entities with their unicode counterpart

+ $entities = array(

+ '&nbsp;' => "\xC2\xA0",

+ '&bull;' => "\xE2\x80\xA2",

+ '&middot;' => "\xC2\xB7",

+ '&copy;' => "\xC2\xA9",

+ );

+

+ $content = str_replace(array_keys($entities), array_values($entities), $content);

+

+ // Remove CDATA blocks. ;)

+ $content = preg_replace('#\<\!\[CDATA\[(.*?)\]\]\>#s', '', $content);

+

+ // Other control characters

+ $content = preg_replace('#(?:[\x00-\x1F\x7F]+|(?:\xC2[\x80-\x9F])+)#', '', $content);

+

+ return $content;

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* News feed

+*

+* This will give you {$this->num_items} first posts

+* of all topics in the selected news forums.

+*

+* @package phpBB3

+*/

+class phpbb_feed_news extends phpbb_feed_topic_base

+{

+ function get_news_forums()

+ {

+ static $forum_ids;

+

+ // Matches acp/acp_board.php

+ $cache_name = 'feed_news_forum_ids';

+

+ if (!isset($forum_ids) && ($forum_ids = $this->cache->get('_' . $cache_name)) === false)

+ {

+ $sql = 'SELECT forum_id

+ FROM ' . FORUMS_TABLE . '

+ WHERE ' . $this->db->sql_bit_and('forum_options', FORUM_OPTION_FEED_NEWS, '<> 0');

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

+

+ $forum_ids = array();

+ while ($forum_id = (int) $this->db->sql_fetchfield('forum_id'))

+ {

+ $forum_ids[$forum_id] = $forum_id;

+ }

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

+

+ $this->cache->put('_' . $cache_name, $forum_ids);

+ }

+

+ return $forum_ids;

+ }

+

+ function get_sql()

+ {

+ // Determine forum ids

+ $in_fid_ary = array_intersect($this->get_news_forums(), $this->get_readable_forums());

+ if (empty($in_fid_ary))

+ {

+ return false;

+ }

+

+ $in_fid_ary = array_diff($in_fid_ary, $this->get_passworded_forums());

+ if (empty($in_fid_ary))

+ {

+ return false;

+ }

+

+ // We really have to get the post ids first!

+ $sql = 'SELECT topic_first_post_id, topic_time

+ FROM ' . TOPICS_TABLE . '

+ WHERE ' . $this->db->sql_in_set('forum_id', $in_fid_ary) . '

+ AND topic_moved_id = 0

+ AND topic_approved = 1

+ ORDER BY topic_time DESC';

+ $result = $this->db->sql_query_limit($sql, $this->num_items);

+

+ $post_ids = array();

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

+ {

+ $post_ids[] = (int) $row['topic_first_post_id'];

+ }

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

+

+ if (empty($post_ids))

+ {

+ return false;

+ }

+

+ $this->sql = array(

+ 'SELECT' => 'f.forum_id, f.forum_name,

+ t.topic_id, t.topic_title, t.topic_poster, t.topic_first_poster_name, t.topic_replies, t.topic_replies_real, t.topic_views, t.topic_time, t.topic_last_post_time,

+ p.post_id, p.post_time, p.post_edit_time, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url',

+ 'FROM' => array(

+ TOPICS_TABLE => 't',

+ POSTS_TABLE => 'p',

+ ),

+ 'LEFT_JOIN' => array(

+ array(

+ 'FROM' => array(FORUMS_TABLE => 'f'),

+ 'ON' => 'p.forum_id = f.forum_id',

+ ),

+ ),

+ 'WHERE' => 'p.topic_id = t.topic_id

+ AND ' . $this->db->sql_in_set('p.post_id', $post_ids),

+ 'ORDER_BY' => 'p.post_time DESC',

+ );

+

+ return true;

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Board wide feed (aka overall feed)

+*

+* This will give you the newest {$this->num_items} posts

+* from the whole board.

+*

+* @package phpBB3

+*/

+class phpbb_feed_overall extends phpbb_feed_post_base

+{

+ function get_sql()

+ {

+ $forum_ids = array_diff($this->get_readable_forums(), $this->get_excluded_forums(), $this->get_passworded_forums());

+ if (empty($forum_ids))

+ {

+ return false;

+ }

+

+ // m_approve forums

+ $fid_m_approve = $this->get_moderator_approve_forums();

+ $sql_m_approve = (!empty($fid_m_approve)) ? 'OR ' . $this->db->sql_in_set('forum_id', $fid_m_approve) : '';

+

+ // Determine topics with recent activity

+ $sql = 'SELECT topic_id, topic_last_post_time

+ FROM ' . TOPICS_TABLE . '

+ WHERE ' . $this->db->sql_in_set('forum_id', $forum_ids) . '

+ AND topic_moved_id = 0

+ AND (topic_approved = 1

+ ' . $sql_m_approve . ')

+ ORDER BY topic_last_post_time DESC';

+ $result = $this->db->sql_query_limit($sql, $this->num_items);

+

+ $topic_ids = array();

+ $min_post_time = 0;

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

+ {

+ $topic_ids[] = (int) $row['topic_id'];

+

+ $min_post_time = (int) $row['topic_last_post_time'];

+ }

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

+

+ if (empty($topic_ids))

+ {

+ return false;

+ }

+

+ // Get the actual data

+ $this->sql = array(

+ 'SELECT' => 'f.forum_id, f.forum_name, ' .

+ 'p.post_id, p.topic_id, p.post_time, p.post_edit_time, p.post_approved, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, ' .

+ 'u.username, u.user_id',

+ 'FROM' => array(

+ USERS_TABLE => 'u',

+ POSTS_TABLE => 'p',

+ ),

+ 'LEFT_JOIN' => array(

+ array(

+ 'FROM' => array(FORUMS_TABLE => 'f'),

+ 'ON' => 'f.forum_id = p.forum_id',

+ ),

+ ),

+ 'WHERE' => $this->db->sql_in_set('p.topic_id', $topic_ids) . '

+ AND (p.post_approved = 1

+ ' . str_replace('forum_id', 'p.forum_id', $sql_m_approve) . ')

+ AND p.post_time >= ' . $min_post_time . '

+ AND u.user_id = p.poster_id',

+ 'ORDER_BY' => 'p.post_time DESC',

+ );

+

+ return true;

+ }

+

+ function adjust_item(&$item_row, &$row)

+ {

+ parent::adjust_item($item_row, $row);

+

+ $item_row['title'] = (isset($row['forum_name']) && $row['forum_name'] !== '') ? $row['forum_name'] . ' ' . $this->separator . ' ' . $item_row['title'] : $item_row['title'];

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Abstract class for post based feeds

+*

+* @package phpBB3

+*/

+abstract class phpbb_feed_post_base extends phpbb_feed_base

+{

+ var $num_items = 'feed_limit_post';

+

+ function set_keys()

+ {

+ $this->set('title', 'post_subject');

+ $this->set('title2', 'topic_title');

+

+ $this->set('author_id', 'user_id');

+ $this->set('creator', 'username');

+ $this->set('published', 'post_time');

+ $this->set('updated', 'post_edit_time');

+ $this->set('text', 'post_text');

+

+ $this->set('bitfield', 'bbcode_bitfield');

+ $this->set('bbcode_uid','bbcode_uid');

+

+ $this->set('enable_bbcode', 'enable_bbcode');

+ $this->set('enable_smilies', 'enable_smilies');

+ $this->set('enable_magic_url', 'enable_magic_url');

+ }

+

+ function adjust_item(&$item_row, &$row)

+ {

+ $item_row['link'] = $this->helper->append_sid('viewtopic.' . $this->phpEx, "t={$row['topic_id']}&amp;p={$row['post_id']}#p{$row['post_id']}");

+

+ if ($this->config['feed_item_statistics'])

+ {

+ $item_row['statistics'] = $this->user->lang['POSTED'] . ' ' . $this->user->lang['POST_BY_AUTHOR'] . ' ' . $this->user_viewprofile($row)

+ . ' ' . $this->separator_stats . ' ' . $this->user->format_date($row[$this->get('published')])

+ . (($this->is_moderator_approve_forum($row['forum_id']) && !$row['post_approved']) ? ' ' . $this->separator_stats . ' ' . $this->user->lang['POST_UNAPPROVED'] : '');

+ }

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Topic feed for a specific topic

+*

+* This will give you the last {$this->num_items} posts made within this topic.

+*

+* @package phpBB3

+*/

+class phpbb_feed_topic extends phpbb_feed_post_base

+{

+ var $topic_id = 0;

+ var $forum_id = 0;

+ var $topic_data = array();

+

+ /**

+ * Set the Topic ID

+ *

+ * @param int $topic_id Topic ID

+ * @return phpbb_feed_topic

+ */

+ public function set_topic_id($topic_id)

+ {

+ $this->topic_id = (int) $topic_id;

+

+ return $this;

+ }

+

+ function open()

+ {

+ $sql = 'SELECT f.forum_options, f.forum_password, t.topic_id, t.forum_id, t.topic_approved, t.topic_title, t.topic_time, t.topic_views, t.topic_replies, t.topic_type

+ FROM ' . TOPICS_TABLE . ' t

+ LEFT JOIN ' . FORUMS_TABLE . ' f

+ ON (f.forum_id = t.forum_id)

+ WHERE t.topic_id = ' . $this->topic_id;

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

+ $this->topic_data = $this->db->sql_fetchrow($result);

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

+

+ if (empty($this->topic_data))

+ {

+ trigger_error('NO_TOPIC');

+ }

+

+ $this->forum_id = (int) $this->topic_data['forum_id'];

+

+ // Make sure topic is either approved or user authed

+ if (!$this->topic_data['topic_approved'] && !$this->auth->acl_get('m_approve', $this->forum_id))

+ {

+ trigger_error('SORRY_AUTH_READ');

+ }

+

+ // Make sure forum is not excluded from feed

+ if (phpbb_optionget(FORUM_OPTION_FEED_EXCLUDE, $this->topic_data['forum_options']))

+ {

+ trigger_error('NO_FEED');

+ }

+

+ // Make sure we can read this forum

+ if (!$this->auth->acl_get('f_read', $this->forum_id))

+ {

+ trigger_error('SORRY_AUTH_READ');

+ }

+

+ // Make sure forum is not passworded or user is authed

+ if ($this->topic_data['forum_password'])

+ {

+ $forum_ids_passworded = $this->get_passworded_forums();

+

+ if (isset($forum_ids_passworded[$this->forum_id]))

+ {

+ trigger_error('SORRY_AUTH_READ');

+ }

+

+ unset($forum_ids_passworded);

+ }

+ }

+

+ function get_sql()

+ {

+ $this->sql = array(

+ 'SELECT' => 'p.post_id, p.post_time, p.post_edit_time, p.post_approved, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, ' .

+ 'u.username, u.user_id',

+ 'FROM' => array(

+ POSTS_TABLE => 'p',

+ USERS_TABLE => 'u',

+ ),

+ 'WHERE' => 'p.topic_id = ' . $this->topic_id . '

+ ' . ($this->forum_id && !$this->auth->acl_get('m_approve', $this->forum_id) ? 'AND p.post_approved = 1' : '') . '

+ AND p.poster_id = u.user_id',

+ 'ORDER_BY' => 'p.post_time DESC',

+ );

+

+ return true;

+ }

+

+ function get_item()

+ {

+ return ($row = parent::get_item()) ? array_merge($this->topic_data, $row) : $row;

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Abstract class for topic based feeds

+*

+* @package phpBB3

+*/

+abstract class phpbb_feed_topic_base extends phpbb_feed_base

+{

+ var $num_items = 'feed_limit_topic';

+

+ function set_keys()

+ {

+ $this->set('title', 'topic_title');

+ $this->set('title2', 'forum_name');

+

+ $this->set('author_id', 'topic_poster');

+ $this->set('creator', 'topic_first_poster_name');

+ $this->set('published', 'post_time');

+ $this->set('updated', 'post_edit_time');

+ $this->set('text', 'post_text');

+

+ $this->set('bitfield', 'bbcode_bitfield');

+ $this->set('bbcode_uid','bbcode_uid');

+

+ $this->set('enable_bbcode', 'enable_bbcode');

+ $this->set('enable_smilies', 'enable_smilies');

+ $this->set('enable_magic_url', 'enable_magic_url');

+ }

+

+ function adjust_item(&$item_row, &$row)

+ {

+ $item_row['link'] = $this->helper->append_sid('viewtopic.' . $this->phpEx, 't=' . $row['topic_id'] . '&amp;p=' . $row['post_id'] . '#p' . $row['post_id']);

+

+ if ($this->config['feed_item_statistics'])

+ {

+ $item_row['statistics'] = $this->user->lang['POSTED'] . ' ' . $this->user->lang['POST_BY_AUTHOR'] . ' ' . $this->user_viewprofile($row)

+ . ' ' . $this->separator_stats . ' ' . $this->user->format_date($row[$this->get('published')])

+ . ' ' . $this->separator_stats . ' ' . $this->user->lang['REPLIES'] . ' ' . (($this->is_moderator_approve_forum($row['forum_id'])) ? $row['topic_replies_real'] : $row['topic_replies'])

+ . ' ' . $this->separator_stats . ' ' . $this->user->lang['VIEWS'] . ' ' . $row['topic_views']

+ . (($this->is_moderator_approve_forum($row['forum_id']) && ($row['topic_replies_real'] != $row['topic_replies'])) ? ' ' . $this->separator_stats . ' ' . $this->user->lang['POSTS_UNAPPROVED'] : '');

+ }

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* New Topics feed

+*

+* This will give you the last {$this->num_items} created topics

+* including the first post.

+*

+* @package phpBB3

+*/

+class phpbb_feed_topics extends phpbb_feed_topic_base

+{

+ function get_sql()

+ {

+ $forum_ids_read = $this->get_readable_forums();

+ if (empty($forum_ids_read))

+ {

+ return false;

+ }

+

+ $in_fid_ary = array_diff($forum_ids_read, $this->get_excluded_forums(), $this->get_passworded_forums());

+ if (empty($in_fid_ary))

+ {

+ return false;

+ }

+

+ // We really have to get the post ids first!

+ $sql = 'SELECT topic_first_post_id, topic_time

+ FROM ' . TOPICS_TABLE . '

+ WHERE ' . $this->db->sql_in_set('forum_id', $in_fid_ary) . '

+ AND topic_moved_id = 0

+ AND topic_approved = 1

+ ORDER BY topic_time DESC';

+ $result = $this->db->sql_query_limit($sql, $this->num_items);

+

+ $post_ids = array();

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

+ {

+ $post_ids[] = (int) $row['topic_first_post_id'];

+ }

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

+

+ if (empty($post_ids))

+ {

+ return false;

+ }

+

+ $this->sql = array(

+ 'SELECT' => 'f.forum_id, f.forum_name,

+ t.topic_id, t.topic_title, t.topic_poster, t.topic_first_poster_name, t.topic_replies, t.topic_replies_real, t.topic_views, t.topic_time, t.topic_last_post_time,

+ p.post_id, p.post_time, p.post_edit_time, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url',

+ 'FROM' => array(

+ TOPICS_TABLE => 't',

+ POSTS_TABLE => 'p',

+ ),

+ 'LEFT_JOIN' => array(

+ array(

+ 'FROM' => array(FORUMS_TABLE => 'f'),

+ 'ON' => 'p.forum_id = f.forum_id',

+ ),

+ ),

+ 'WHERE' => 'p.topic_id = t.topic_id

+ AND ' . $this->db->sql_in_set('p.post_id', $post_ids),

+ 'ORDER_BY' => 'p.post_time DESC',

+ );

+

+ return true;

+ }

+

+ function adjust_item(&$item_row, &$row)

+ {

+ parent::adjust_item($item_row, $row);

+

+ $item_row['title'] = (isset($row['forum_name']) && $row['forum_name'] !== '') ? $row['forum_name'] . ' ' . $this->separator . ' ' . $item_row['title'] : $item_row['title'];

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Active Topics feed

+*

+* This will give you the last {$this->num_items} topics

+* with replies made withing the last {$this->sort_days} days

+* including the last post.

+*

+* @package phpBB3

+*/

+class phpbb_feed_topics_active extends phpbb_feed_topic_base

+{

+ var $sort_days = 7;

+

+ function set_keys()

+ {

+ parent::set_keys();

+

+ $this->set('author_id', 'topic_last_poster_id');

+ $this->set('creator', 'topic_last_poster_name');

+ }

+

+ function get_sql()

+ {

+ $forum_ids_read = $this->get_readable_forums();

+ if (empty($forum_ids_read))

+ {

+ return false;

+ }

+

+ $in_fid_ary = array_intersect($forum_ids_read, $this->get_forum_ids());

+ $in_fid_ary = array_diff($in_fid_ary, $this->get_passworded_forums());

+ if (empty($in_fid_ary))

+ {

+ return false;

+ }

+

+ // Search for topics in last X days

+ $last_post_time_sql = ($this->sort_days) ? ' AND topic_last_post_time > ' . (time() - ($this->sort_days * 24 * 3600)) : '';

+

+ // We really have to get the post ids first!

+ $sql = 'SELECT topic_last_post_id, topic_last_post_time

+ FROM ' . TOPICS_TABLE . '

+ WHERE ' . $this->db->sql_in_set('forum_id', $in_fid_ary) . '

+ AND topic_moved_id = 0

+ AND topic_approved = 1

+ ' . $last_post_time_sql . '

+ ORDER BY topic_last_post_time DESC';

+ $result = $this->db->sql_query_limit($sql, $this->num_items);

+

+ $post_ids = array();

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

+ {

+ $post_ids[] = (int) $row['topic_last_post_id'];

+ }

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

+

+ if (empty($post_ids))

+ {

+ return false;

+ }

+

+ $this->sql = array(

+ 'SELECT' => 'f.forum_id, f.forum_name,

+ t.topic_id, t.topic_title, t.topic_replies, t.topic_replies_real, t.topic_views,

+ t.topic_last_poster_id, t.topic_last_poster_name, t.topic_last_post_time,

+ p.post_id, p.post_time, p.post_edit_time, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url',

+ 'FROM' => array(

+ TOPICS_TABLE => 't',

+ POSTS_TABLE => 'p',

+ ),

+ 'LEFT_JOIN' => array(

+ array(

+ 'FROM' => array(FORUMS_TABLE => 'f'),

+ 'ON' => 'p.forum_id = f.forum_id',

+ ),

+ ),

+ 'WHERE' => 'p.topic_id = t.topic_id

+ AND ' . $this->db->sql_in_set('p.post_id', $post_ids),

+ 'ORDER_BY' => 'p.post_time DESC',

+ );

+

+ return true;

+ }

+

+ function get_forum_ids()

+ {

+ static $forum_ids;

+

+ $cache_name = 'feed_topic_active_forum_ids';

+

+ if (!isset($forum_ids) && ($forum_ids = $this->cache->get('_' . $cache_name)) === false)

+ {

+ $sql = 'SELECT forum_id

+ FROM ' . FORUMS_TABLE . '

+ WHERE forum_type = ' . FORUM_POST . '

+ AND ' . $this->db->sql_bit_and('forum_options', FORUM_OPTION_FEED_EXCLUDE, '= 0') . '

+ AND ' . $this->db->sql_bit_and('forum_flags', log(FORUM_FLAG_ACTIVE_TOPICS, 2), '<> 0');

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

+

+ $forum_ids = array();

+ while ($forum_id = (int) $this->db->sql_fetchfield('forum_id'))

+ {

+ $forum_ids[$forum_id] = $forum_id;

+ }

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

+

+ $this->cache->put('_' . $cache_name, $forum_ids, 180);

+ }

+

+ return $forum_ids;

+ }

+

+ function adjust_item(&$item_row, &$row)

+ {

+ parent::adjust_item($item_row, $row);

+

+ $item_row['title'] = (isset($row['forum_name']) && $row['forum_name'] !== '') ? $row['forum_name'] . ' ' . $this->separator . ' ' . $item_row['title'] : $item_row['title'];

+ }

+}

+ return (isset($path[0]) && $path[0] == '/' || preg_match('#^[a-z]:[/\\\]#i', $path)) ? true : false;

+ 'META' => '<meta http-equiv="refresh" content="' . $time . '; url=' . $url . '" />')

+ 'FORUM_NAME' => isset($forum_data['forum_name']) ? $forum_data['forum_name'] : '',

+ case 'url':

+ case 'email':

+ case 'color':

+ case 'date':

+ case 'time':

+ case 'datetime':

+ case 'datetime-local':

+ case 'month':

+ case 'range':

+ case 'search':

+ case 'tel':

+ case 'url':

+ case 'week':

+ case 'number':

+ $min = $max = $maxlength = '';

+ $min = ( isset($tpl_type[1]) ) ? (int) $tpl_type[1] : false;

+ if ( isset($tpl_type[2]) )

+ {

+ $max = (int) $tpl_type[2];

+ $maxlength = strlen( (string) $max );

+ }

+

+ $tpl = '<input id="' . $key . '" type="number" maxlength="' . (( $maxlength != '' ) ? $maxlength : 255) . '"' . (( $min != '' ) ? ' min="' . $min . '"' : '') . (( $max != '' ) ? ' max="' . $max . '"' : '') . ' name="' . $name . '" value="' . $new[$config_key] . '" />';

+ break;

+

+ $min = $max = $maxlength = $size = '';

+

+ $min = (int) $tpl_type[1];

+

+ if ( isset($tpl_type[2]) )

+ {

+ $max = (int) $tpl_type[2];

+ $size = $maxlength = strlen( (string) $max );

+ }

+ $tpl = '<input id="' . $key . '" type="number"' . (( $size != '' ) ? ' size="' . $size . '"' : '') . ' maxlength="' . (($maxlength != '') ? $maxlength : 255) . '"' . (( $min !== '' ) ? ' min="' . $min . '"' : '') . (( $max != '' ) ? ' max="' . $max . '"' : '') . ' name="config[' . $config_key . '_width]" value="' . $new[$config_key . '_width'] . '" /> x <input type="number"' . (( $size != '' ) ? ' size="' . $size . '"' : '') . ' maxlength="' . (($maxlength != '') ? $maxlength : 255) . '"' . (( $min !== '' ) ? ' min="' . $min . '"' : '') . (( $max != '' ) ? ' max="' . $max . '"' : '') . ' name="config[' . $config_key . '_height]" value="' . $new[$config_key . '_height'] . '" />';

+ global $user, $phpEx, $phpbb_extension_manager;

+ // add permission language files from extensions

+ $finder = $phpbb_extension_manager->get_finder();

+ $lang_files = $finder

+ ->prefix('permissions_')

+ ->suffix(".$phpEx")

+ ->core_path('language/' . $user->lang_name . '/')

+ ->extension_directory('/language/' . $user->lang_name)

+ ->find();

+ foreach ($lang_files as $lang_file => $ext_name)

+ if ($ext_name === '/')

+ $user->add_lang($lang_file);

+ }

+ else

+ {

+ $user->add_lang_ext($ext_name, $lang_file);

+ if (empty($info))

+ $sql = 'SELECT t.forum_id, f.forum_name, f.forum_password, f.parent_id

+ $filedata['post_attach'] = $local || $upload->is_valid($form_name);

+ // Whether the uploaded file is in the image category

+ $is_image = (isset($extensions[$file->get('extension')]['display_cat'])) ? $extensions[$file->get('extension')]['display_cat'] == ATTACHMENT_CATEGORY_IMAGE : false;

+ // Check Image Size, if it is an image

+ if ($is_image)

+ {

+ $file->upload->set_allowed_dimensions(0, 0, $config['img_max_width'], $config['img_max_height']);

+ }

+

+ // Admins and mods are allowed to exceed the allowed filesize

+ // Are we uploading an image *and* this image being within the image category?

+ // Only then perform additional image checks.

+ $file->move_file($config['upload_path'], false, !$is_image);

+ // Do we have to create a thumbnail?

+ $filedata['thumbnail'] = ($is_image && $config['img_create_thumbnail']) ? 1 : 0;

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

+ if ($is_image && !$file->is_image())

+ {

+ $file->remove();

+

+ // If this error occurs a user tried to exploit an IE Bug by renaming extensions

+ // Since the image category is displaying content inline we need to catch this.

+ trigger_error($user->lang['ATTACHED_IMAGE_NOT_IMAGE']);

+ }

+

+ 0 => array('TITLE' => $user->lang['FIELD_LENGTH'], 'FIELD' => '<input type="number" min="0" name="field_length" size="5" value="' . $this->vars['field_length'] . '" />'),

+ 1 => array('TITLE' => $user->lang['MIN_FIELD_CHARS'], 'FIELD' => '<input type="number" min="0" name="field_minlen" size="5" value="' . $this->vars['field_minlen'] . '" />'),

+ 2 => array('TITLE' => $user->lang['MAX_FIELD_CHARS'], 'FIELD' => '<input type="number" min="0" size="5" value="' . $this->vars['field_maxlen'] . '" />'),

+ 0 => array('TITLE' => $user->lang['FIELD_LENGTH'], 'FIELD' => '<input type="number" min="0" max="99999" name="rows" size="5" value="' . $this->vars['rows'] . '" /> ' . $user->lang['ROWS'] . '</dd><dd><input type="number" min="0" max="99999" name="columns" size="5" value="' . $this->vars['columns'] . '" /> ' . $user->lang['COLUMNS'] . ' <input type="hidden" name="field_length" value="' . $this->vars['field_length'] . '" />'),

+ 1 => array('TITLE' => $user->lang['MIN_FIELD_CHARS'], 'FIELD' => '<input type="number" min="0" max="9999999999" name="field_minlen" size="10" value="' . $this->vars['field_minlen'] . '" />'),

+ 2 => array('TITLE' => $user->lang['MAX_FIELD_CHARS'], 'FIELD' => '<input type="number" min="0" max="9999999999" name="field_maxlen" size="10" value="' . $this->vars['field_maxlen'] . '" />'),

+ 0 => array('TITLE' => $user->lang['FIELD_LENGTH'], 'FIELD' => '<input type="number" min="0" max="99999" name="field_length" size="5" value="' . $this->vars['field_length'] . '" />'),

+ 1 => array('TITLE' => $user->lang['MIN_FIELD_NUMBER'], 'FIELD' => '<input type="number" min="0" max="99999" name="field_minlen" size="5" value="' . $this->vars['field_minlen'] . '" />'),

+ 2 => array('TITLE' => $user->lang['MAX_FIELD_NUMBER'], 'FIELD' => '<input type="number" min="0" max="99999" name="field_maxlen" size="5" value="' . $this->vars['field_maxlen'] . '" />'),

+ $function_prefix = (function_exists('phpbb_validate_' . $function)) ? 'phpbb_validate_' : 'validate_';

+ if ($result = call_user_func_array($function_prefix . $function, $validate))

+ // Since errors are checked later for their language file existence, we need to make sure custom errors are not adjusted.

+ $error[] = (empty($user->lang[$result . '_' . strtoupper($var)])) ? $result : $result . '_' . strtoupper($var);

+* Validate hex colour value

+*

+* @param string $colour The hex colour value

+* @param bool $optional Whether the colour value is optional. True if an empty

+* string will be accepted as correct input, false if not.

+* @return bool|string Error message if colour value is incorrect, false if it

+* fits the hex colour code

+*/

+function phpbb_validate_hex_colour($colour, $optional = false)

+{

+ if ($colour === '')

+ {

+ return (($optional) ? false : 'WRONG_DATA');

+ }

+

+ if (!preg_match('/^([0-9a-fA-F]{6}|[0-9a-fA-F]{3})$/', $colour))

+ {

+ return 'WRONG_DATA';

+ }

+

+ return false;

+}

+

+/**

+ * Does this process own the lock?

+ *

+ * @return bool true if lock is owned

+ * false otherwise

+ */

+ public function owns_lock()

+ {

+ return (bool) $this->locked;

+ }

+

+ /**

+ * Does this process own the lock?

+ *

+ * @return bool true if lock is owned

+ * false otherwise

+ */

+ public function owns_lock()

+ {

+ return (bool) $this->lock_fp;

+ }

+

+ /**

+<?php

+/**

+*

+* @package notifications

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Notifications exception

+*

+* @package notifications

+*/

+class phpbb_notification_exception extends \Exception

+{

+ public function __toString()

+ {

+ return $this->getMessage();

+ }

+}

+ /** @var phpbb_cache_service */

+ protected $cache;

+

+ public function __construct($notification_types, $notification_methods, $phpbb_container, phpbb_user_loader $user_loader, phpbb_db_driver $db, phpbb_cache_service $cache, $user, $phpbb_root_path, $php_ext, $notification_types_table, $notifications_table, $user_notifications_table)

+ $this->cache = $cache;

+ AND nt.notification_type_id = n.notification_type_id

+ AND nt.notification_type_id = n.notification_type_id

+ $sql = 'SELECT n.*, nt.notification_type_name

+ AND nt.notification_type_id = n.notification_type_id

+ $sql = 'SELECT n.*, nt.notification_type_name

+ AND nt.notification_type_id = n.notification_type_id

+ $notification = $this->get_item_type_class($row['notification_type_name'], $row);

+ if (!isset($load_special[$row['notification_type_name']]))

+ $load_special[$row['notification_type_name']] = array();

+ $load_special[$row['notification_type_name']] = array_merge($load_special[$row['notification_type_name']], $notification->get_load_special());

+ * @param bool|string|array $notification_type_name Type identifier or array of item types (only acceptable if the $data is identical for the specified types). False to mark read for all item types

+ public function mark_notifications_read($notification_type_name, $item_id, $user_id, $time = false)

+ (($notification_type_name !== false) ? ' AND ' .

+ (is_array($notification_type_name) ? $this->db->sql_in_set('notification_type_id', $this->get_notification_type_ids($notification_type_name)) : 'notification_type_id = ' . $this->get_notification_type_id($notification_type_name))

+ : '') .

+ * @param string|array $notification_type_name Type identifier or array of item types (only acceptable if the $data is identical for the specified types)

+ public function mark_notifications_read_by_parent($notification_type_name, $item_parent_id, $user_id, $time = false)

+ WHERE notification_time <= " . (int) $time .

+ (($notification_type_name !== false) ? ' AND ' .

+ (is_array($notification_type_name) ? $this->db->sql_in_set('notification_type_id', $this->get_notification_type_ids($notification_type_name)) : 'notification_type_id = ' . $this->get_notification_type_id($notification_type_name))

+ : '') .

+ * @param string|array $notification_type_name Type identifier or array of item types (only acceptable if the $data is identical for the specified types)

+ public function add_notifications($notification_type_name, $data, array $options = array())

+ if (is_array($notification_type_name))

+ foreach ($notification_type_name as $type)

+ $item_id = $this->get_item_type_class($notification_type_name)->get_item_id($data);

+ $notify_users = $this->get_item_type_class($notification_type_name)->find_users_for_notification($data, $options);

+ $this->add_notifications_for_users($notification_type_name, $data, $notify_users);

+ * @param string|array $notification_type_name Type identifier or array of item types (only acceptable if the $data is identical for the specified types)

+ public function add_notifications_for_users($notification_type_name, $data, $notify_users)

+ if (is_array($notification_type_name))

+ foreach ($notification_type_name as $type)

+ $notification_type_id = $this->get_notification_type_id($notification_type_name);

+ $item_id = $this->get_item_type_class($notification_type_name)->get_item_id($data);

+ FROM ' . $this->notifications_table . ' n, ' . $this->notification_types_table . ' nt

+ WHERE n.notification_type_id = ' . (int) $notification_type_id . '

+ AND n.item_id = ' . (int) $item_id . '

+ AND nt.notification_type_id = n.notification_type_id

+ $notification = $this->get_item_type_class($notification_type_name);

+ $notification = $this->get_item_type_class($notification_type_name);

+ * @param string|array $notification_type_name Type identifier or array of item types (only acceptable if the $data is identical for the specified types)

+ public function update_notifications($notification_type_name, $data)

+ if (is_array($notification_type_name))

+ foreach ($notification_type_name as $type)

+ $notification = $this->get_item_type_class($notification_type_name);

+ $notification_type_id = $this->get_notification_type_id($notification_type_name);

+ SET ' . $this->db->sql_build_array('UPDATE', $update_array) . '

+ WHERE notification_type_id = ' . (int) $notification_type_id . '

+ AND item_id = ' . (int) $item_id;

+ * @param string|array $notification_type_name Type identifier or array of item types (only acceptable if the $item_id is identical for the specified types)

+ public function delete_notifications($notification_type_name, $item_id)

+ if (is_array($notification_type_name))

+ foreach ($notification_type_name as $type)

+ $notification_type_id = $this->get_notification_type_id($notification_type_name);

+

+ $sql = 'DELETE FROM ' . $this->notifications_table . '

+ WHERE notification_type_id = ' . (int) $notification_type_id . '

+ AND ' . (is_array($item_id) ? $this->db->sql_in_set('item_id', $item_id) : 'item_id = ' . (int) $item_id);

+ // Make sure to subscribe them to the base subscription

+ $this->add_subscription($item_type, $item_id, '', $user_id);

+ * @param string $notification_type_name Type identifier of the subscription

+ public function disable_notifications($notification_type_name)

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

+ * @param string $notification_type_name Type identifier of the subscription

+ public function purge_notifications($notification_type_name)

+ $notification_type_id = $this->get_notification_type_id($notification_type_name);

+

+ $sql = 'DELETE FROM ' . $this->notifications_table . '

+ WHERE notification_type_id = ' . (int) $notification_type_id;

+ $sql = 'DELETE FROM ' . $this->notification_types_table . '

+ WHERE notification_type_id = ' . (int) $notification_type_id;

+

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

+ * @param string $notification_type_name Type identifier of the subscription

+ public function enable_notifications($notification_type_name)

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

+ public function get_item_type_class($notification_type_name, $data = array())

+ $notification_type_name = (strpos($notification_type_name, 'notification.type.') === 0) ? $notification_type_name : 'notification.type.' . $notification_type_name;

+ $item = $this->load_object($notification_type_name);

+

+ /**

+ * Get the notification type id from the name

+ *

+ * @param string $notification_type_name The name

+ * @return int the notification_type_id

+ */

+ public function get_notification_type_id($notification_type_name)

+ {

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

+

+ if ($notification_type_ids === false)

+ {

+ $notification_type_ids = array();

+

+ $sql = 'SELECT notification_type_id, notification_type_name

+ FROM ' . $this->notification_types_table;

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

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

+ {

+ $notification_type_ids[$row['notification_type_name']] = (int) $row['notification_type_id'];

+ }

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

+

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

+ }

+

+ if (!isset($notification_type_ids[$notification_type_name]))

+ {

+ if (!isset($this->notification_types[$notification_type_name]) && !isset($this->notification_types['notification.type.' . $notification_type_name]))

+ {

+ throw new phpbb_notification_exception($this->user->lang('NOTIFICATION_TYPE_NOT_EXIST', $notification_type_name));

+ }

+

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

+ 'notification_type_name' => $notification_type_name,

+ 'notification_type_enabled' => 1,

+ ));

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

+

+ $notification_type_ids[$notification_type_name] = (int) $this->db->sql_nextid();

+

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

+ }

+

+ return $notification_type_ids[$notification_type_name];

+ }

+

+ /**

+ * Get notification type ids (as an array)

+ *

+ * @param array $notification_type_names Array of strings

+ * @return array Array of integers

+ */

+ public function get_notification_type_ids(array $notification_type_names)

+ {

+ $notification_type_ids = array();

+

+ foreach ($notification_type_names as $name)

+ {

+ $notification_type_ids[$name] = $this->get_notification_type_id($name);

+ }

+

+ return $notification_type_ids;

+ }

+ /** @var phpbb_cache_driver_interface */

+ return $this->config['email_enable'] && $this->user->data['user_email'];

+ /** @var phpbb_cache_driver_interface */

+ * The notification_type_id, set upon creation of the class

+ * This is the notification_type_id from the notification_types table

+ *

+ * @var int

+ */

+ protected $notification_type_id;

+

+ /**

+ * notification_type_id - ID of the item type (auto generated, from notification types table)

+ * item_id - ID of the item (e.g. post_id, msg_id)

+ * item_parent_id - Parent item id (ex: for topic => forum_id, for post => topic_id, etc)

+

+ $this->notification_type_id = $this->notification_manager->get_notification_type_id($this->get_type());

+ 'notification_type_id' => $this->notification_type_id,

+ 'notification_type_id = ' . (int) $this->notification_type_id,

+ FROM ' . $this->notifications_table . ' n, ' . $this->notification_types_table . ' nt

+ WHERE n.notification_type_id = ' . (int) $this->notification_type_id . '

+ AND n.item_parent_id = ' . (int) self::get_item_parent_id($post) . '

+ AND nt.notification_type_id = n.notification_type_id

+ FROM ' . $this->notifications_table . ' n, ' . $this->notification_types_table . ' nt

+ WHERE n.notification_type_id = ' . (int) $this->notification_type_id . '

+ AND n.item_parent_id = ' . (int) self::get_item_parent_id($post) . '

+ AND nt.notification_type_id = n.notification_type_id

+ FROM ' . $this->notifications_table . ' n, ' . $this->notification_types_table . ' nt

+ WHERE n.notification_type_id = ' . (int) $this->notification_type_id . '

+ AND n.item_parent_id = ' . (int) self::get_item_parent_id($post) . '

+ AND nt.notification_type_id = n.notification_type_id

+ FROM ' . $this->notifications_table . ' n, ' . $this->notification_types_table . ' nt

+ WHERE n.notification_type_id = ' . (int) $this->notification_type_id . '

+ AND n.item_id = ' . self::get_item_id($post) . '

+ AND nt.notification_type_id = n.notification_type_id

+ $sql = 'DELETE FROM ' . $this->notifications_table . '

+ WHERE notification_type_id = ' . (int) $this->notification_type_id . '

+ AND item_id = ' . self::get_item_id($post) . '

+ $fulltext_supported =

+ $engine === 'MyISAM' ||

+ // FULLTEXT is supported on InnoDB since MySQL 5.6.4 according to

+ // http://dev.mysql.com/doc/refman/5.6/en/innodb-storage-engine.html

+ $engine === 'InnoDB' &&

+ phpbb_version_compare($this->db->sql_server_info(true), '5.6.4', '>=');

+

+ if (!$fulltext_supported)

+ return $this->user->lang['FULLTEXT_MYSQL_NOT_SUPPORTED'];

+ <dd><input id="fulltext_native_min_chars" type="number" size="3" maxlength="3" min="0" max="255" name="config[fulltext_native_min_chars]" value="' . (int) $this->config['fulltext_native_min_chars'] . '" /></dd>

+ <dd><input id="fulltext_native_max_chars" type="number" size="3" maxlength="3" min="0" max="255" name="config[fulltext_native_max_chars]" value="' . (int) $this->config['fulltext_native_max_chars'] . '" /></dd>

+ $match = array('#\sand\s#iu', '#\sor\s#iu', '#\snot\s#iu', '#(^|\s)\+#', '#(^|\s)-#', '#(^|\s)\|#');

+ <dd><input id="fulltext_postgres_min_word_len" type="number" size="3" maxlength="3" min="0" max="255" name="config[fulltext_postgres_min_word_len]" value="' . (int) $this->config['fulltext_postgres_min_word_len'] . '" /></dd>

+ <dd><input id="fulltext_postgres_max_word_len" type="number" size="3" maxlength="3" min="0" max="255" name="config[fulltext_postgres_max_word_len]" value="' . (int) $this->config['fulltext_postgres_max_word_len'] . '" /></dd>

+ <dd><input id="fulltext_sphinx_port" type="number" size="4" maxlength="10" name="config[fulltext_sphinx_port]" value="' . $this->config['fulltext_sphinx_port'] . '" /></dd>

+ <dd><input id="fulltext_sphinx_indexer_mem_limit" type="number" size="4" maxlength="10" name="config[fulltext_sphinx_indexer_mem_limit]" value="' . $this->config['fulltext_sphinx_indexer_mem_limit'] . '" /> ' . $this->user->lang['MIB'] . '</dd>

+ * Array of default parameters

+ *

+ * @var array

+ */

+ private $default_filter_params;

+

+ /**

+ $this->filter_params = $this->default_filter_params = array(

+ 'allow_php' => $allow_php,

+ 'style_names' => $style_names,

+ 'locator' => $locator,

+ 'user' => $user,

+ 'cleanup' => true,

+ * Set filter parameters

+ *

+ * @param array $params Array of parameters (will be merged onto $this->filter_params)

+ */

+ public function set_filter_params($params)

+ {

+ $this->filter_params = array_merge(

+ $this->filter_params,

+ $params

+ );

+ }

+

+ /**

+ * Reset filter parameters to their default settings

+ */

+ public function reset_filter_params()

+ {

+ $this->filter_params = $this->default_filter_params;

+ }

+

+ /**

+ * Whether cleanup will be performed on resulting code, see compile()

+ * (Preserve whitespace)

+ *

+ * @var bool

+ */

+ private $cleanup = true;

+

+ /**

+ $this->cleanup = $this->params['cleanup'];

+ if ($this->cleanup)

+ {

+ /*

+

+ PHP removes a newline after the closing tag (if it's there).

+ This is by design:

+

+ http://www.php.net/manual/en/language.basic-syntax.phpmode.php

+ http://www.php.net/manual/en/language.basic-syntax.instruction-separation.php

+ If we were to simply preserve all whitespace, we could simply

+ replace all "?>" tags with "?>\n".

+ Doing that, would add additional newlines to the compiled

+ template in place of the IF and ENDIF statements. These

+ newlines are unwanted (and one is conditional). The IF and

+ ENDIF are usually on their own line for ease of reading.

+ This replacement preserves newlines only for statements that

+ are not the only statement on a line. It will NOT preserve

+ newlines at the end of statements in the above example.

+ */

+ $data = preg_replace('~(?<!^)(<\?php.+(?<!/\*\*/)\?>)$~m', "$1\n", $data);

+ $data = str_replace('/**/?>', "?>\n", $data);

+ $data = str_replace('?><?php', '', $data);

+ }

+ case 'ENDDEFINE':

+ return '<?php ' . $this->compile_tag_enddefine() . ' ?>';

+ break;

+

+ if (!empty($match[2]) && !isset($match[3]) && $op)

+ {

+ // DEFINE tag with ENDDEFINE

+ $array = "\$_tpldata['DEFINE']['.vars']";

+ $code = 'ob_start(); ';

+ $code .= "if (!isset($array)) { $array = array(); } ";

+ $code .= "{$array}[] = '{$match[2]}'";

+ return $code;

+ }

+

+ * Compile ENDDEFINE tag

+ *

+ * @return string compiled template code

+ */

+ private function compile_tag_enddefine()

+ {

+ $array = "\$_tpldata['DEFINE']['.vars']";

+ $code = "if (!isset($array) || !sizeof($array)) { trigger_error('ENDDEFINE tag without DEFINE in ' . basename(__FILE__), E_USER_ERROR); }";

+ $code .= "\$define_var = array_pop($array); ";

+ $code .= "\$_tpldata['DEFINE']['.'][\$define_var] = ob_get_clean();";

+ return $code;

+ }

+

+ /**

+ $this->template_compile->set_filter_params(array(

+ 'cleanup' => false,

+ ));

+

+ $this->template_compile->reset_filter_params();

+

+<?php

+/**

+*

+* @package tree

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+interface phpbb_tree_interface

+{

+ /**

+ * Inserts an item into the database table and into the tree.

+ *

+ * @param array $item The item to be added

+ * @return array Array with item data as set in the database

+ */

+ public function insert(array $additional_data);

+

+ /**

+ * Delete an item from the tree and from the database table

+ *

+ * Also deletes the subtree from the tree and from the database table

+ *

+ * @param int $item_id The item to be deleted

+ * @return array Item ids that have been deleted

+ */

+ public function delete($item_id);

+

+ /**

+ * Move an item by a given delta

+ *

+ * An item is only moved up/down within the same parent. If the delta is

+ * larger then the number of children, the item is moved to the top/bottom

+ * of the list of children within this parent.

+ *

+ * @param int $item_id The item to be moved

+ * @param int $delta Number of steps to move this item, < 0 => down, > 0 => up

+ * @return bool True if the item was moved

+ */

+ public function move($item_id, $delta);

+

+ /**

+ * Move an item down by 1

+ *

+ * @param int $item_id The item to be moved

+ * @return bool True if the item was moved

+ */

+ public function move_down($item_id);

+

+ /**

+ * Move an item up by 1

+ *

+ * @param int $item_id The item to be moved

+ * @return bool True if the item was moved

+ */

+ public function move_up($item_id);

+

+ /**

+ * Moves all children of one item to another item

+ *

+ * If the new parent already has children, the new children are appended

+ * to the list.

+ *

+ * @param int $current_parent_id The current parent item

+ * @param int $new_parent_id The new parent item

+ * @return bool True if any items where moved

+ */

+ public function move_children($current_parent_id, $new_parent_id);

+

+ /**

+ * Change parent item

+ *

+ * Moves the item to the bottom of the new parent's list of children

+ *

+ * @param int $item_id The item to be moved

+ * @param int $new_parent_id The new parent item

+ * @return bool True if the parent was set successfully

+ */

+ public function change_parent($item_id, $new_parent_id);

+

+ /**

+ * Get all items that are either ancestors or descendants of the item

+ *

+ * @param int $item_id Id of the item to retrieve the ancestors/descendants from

+ * @param bool $order_asc Order the items ascendingly (most outer ancestor first)

+ * @param bool $include_item Should the item matching the given item id be included in the list as well

+ * @return array Array of items (containing all columns from the item table)

+ * ID => Item data

+ */

+ public function get_path_and_subtree_data($item_id, $order_asc, $include_item);

+

+ /**

+ * Get all of the item's ancestors

+ *

+ * @param int $item_id Id of the item to retrieve the ancestors from

+ * @param bool $order_asc Order the items ascendingly (most outer ancestor first)

+ * @param bool $include_item Should the item matching the given item id be included in the list as well

+ * @return array Array of items (containing all columns from the item table)

+ * ID => Item data

+ */

+ public function get_path_data($item_id, $order_asc, $include_item);

+

+ /**

+ * Get all of the item's descendants

+ *

+ * @param int $item_id Id of the item to retrieve the descendants from

+ * @param bool $order_asc Order the items ascendingly

+ * @param bool $include_item Should the item matching the given item id be included in the list as well

+ * @return array Array of items (containing all columns from the item table)

+ * ID => Item data

+ */

+ public function get_subtree_data($item_id, $order_asc, $include_item);

+}

+<?php

+/**

+*

+* @package tree

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+abstract class phpbb_tree_nestedset implements phpbb_tree_interface

+{

+ /** @var phpbb_db_driver */

+ protected $db;

+

+ /** @var phpbb_lock_db */

+ protected $lock;

+

+ /** @var string */

+ protected $table_name;

+

+ /**

+ * Prefix for the language keys returned by exceptions

+ * @var string

+ */

+ protected $message_prefix = '';

+

+ /**

+ * Column names in the table

+ * @var string

+ */

+ protected $column_item_id = 'item_id';

+ protected $column_left_id = 'left_id';

+ protected $column_right_id = 'right_id';

+ protected $column_parent_id = 'parent_id';

+ protected $column_item_parents = 'item_parents';

+

+ /**

+ * Additional SQL restrictions

+ * Allows to have multiple nested sets in one table

+ * @var string

+ */

+ protected $sql_where = '';

+

+ /**

+ * List of item properties to be cached in the item_parents column

+ * @var array

+ */

+ protected $item_basic_data = array('*');

+

+ /**

+ * Construct

+ *

+ * @param phpbb_db_driver $db Database connection

+ * @param phpbb_lock_db $lock Lock class used to lock the table when moving forums around

+ * @param string $table_name Table name

+ * @param string $message_prefix Prefix for the messages thrown by exceptions

+ * @param string $sql_where Additional SQL restrictions for the queries

+ * @param array $item_basic_data Array with basic item data that is stored in item_parents

+ * @param array $columns Array with column names to overwrite

+ */

+ public function __construct(phpbb_db_driver $db, phpbb_lock_db $lock, $table_name, $message_prefix = '', $sql_where = '', $item_basic_data = array(), $columns = array())

+ {

+ $this->db = $db;

+ $this->lock = $lock;

+

+ $this->table_name = $table_name;

+ $this->message_prefix = $message_prefix;

+ $this->sql_where = $sql_where;

+ $this->item_basic_data = (!empty($item_basic_data)) ? $item_basic_data : array('*');

+

+ if (!empty($columns))

+ {

+ foreach ($columns as $column => $name)

+ {

+ $column_name = 'column_' . $column;

+ $this->$column_name = $name;

+ }

+ }

+ }

+

+ /**

+ * Returns additional sql where restrictions

+ *

+ * @param string $operator SQL operator that needs to be prepended to sql_where,

+ * if it is not empty.

+ * @param string $column_prefix Prefix that needs to be prepended to column names

+ * @return string Returns additional where statements to narrow down the tree,

+ * prefixed with operator and prepended column_prefix to column names

+ */

+ public function get_sql_where($operator = 'AND', $column_prefix = '')

+ {

+ return (!$this->sql_where) ? '' : $operator . ' ' . sprintf($this->sql_where, $column_prefix);

+ }

+

+ /**

+ * Acquires a lock on the item table

+ *

+ * @return bool True if the lock was acquired, false if it has been acquired previously

+ *

+ * @throws RuntimeException If the lock could not be acquired

+ */

+ protected function acquire_lock()

+ {

+ if ($this->lock->owns_lock())

+ {

+ return false;

+ }

+

+ if (!$this->lock->acquire())

+ {

+ throw new RuntimeException($this->message_prefix . 'LOCK_FAILED_ACQUIRE');

+ }

+

+ return true;

+ }

+

+ /**

+ * @inheritdoc

+ */

+ public function insert(array $additional_data)

+ {

+ $item_data = $this->reset_nestedset_values($additional_data);

+

+ $sql = 'INSERT INTO ' . $this->table_name . ' ' . $this->db->sql_build_array('INSERT', $item_data);

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

+

+ $item_data[$this->column_item_id] = (int) $this->db->sql_nextid();

+

+ return array_merge($item_data, $this->add_item_to_nestedset($item_data[$this->column_item_id]));

+ }

+

+ /**

+ * Add an item which already has a database row at the end of the tree

+ *

+ * @param int $item_id The item to be added

+ * @return array Array with updated data, if the item was added successfully

+ * Empty array otherwise

+ */

+ protected function add_item_to_nestedset($item_id)

+ {

+ $sql = 'SELECT MAX(' . $this->column_right_id . ') AS ' . $this->column_right_id . '

+ FROM ' . $this->table_name . '

+ ' . $this->get_sql_where('WHERE');

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

+ $current_max_right_id = (int) $this->db->sql_fetchfield($this->column_right_id);

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

+

+ $update_item_data = array(

+ $this->column_parent_id => 0,

+ $this->column_left_id => $current_max_right_id + 1,

+ $this->column_right_id => $current_max_right_id + 2,

+ $this->column_item_parents => '',

+ );

+

+ $sql = 'UPDATE ' . $this->table_name . '

+ SET ' . $this->db->sql_build_array('UPDATE', $update_item_data) . '

+ WHERE ' . $this->column_item_id . ' = ' . (int) $item_id . '

+ AND ' . $this->column_parent_id . ' = 0

+ AND ' . $this->column_left_id . ' = 0

+ AND ' . $this->column_right_id . ' = 0';

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

+

+ return ($this->db->sql_affectedrows() == 1) ? $update_item_data : array();

+ }

+

+ /**

+ * Remove an item from the tree without deleting it from the database

+ *

+ * Also removes all subitems from the tree without deleting them from the database either

+ *

+ * @param int $item_id The item to be deleted

+ * @return array Item ids that have been removed

+ */

+ protected function remove_item_from_nestedset($item_id)

+ {

+ $item_id = (int) $item_id;

+ if (!$item_id)

+ {

+ throw new OutOfBoundsException($this->message_prefix . 'INVALID_ITEM');

+ }

+

+ $items = $this->get_subtree_data($item_id);

+ $item_ids = array_keys($items);

+

+ if (empty($items) || !isset($items[$item_id]))

+ {

+ throw new OutOfBoundsException($this->message_prefix . 'INVALID_ITEM');

+ }

+

+ $this->remove_subset($item_ids, $items[$item_id]);

+

+ return $item_ids;

+ }

+

+ /**

+ * @inheritdoc

+ */

+ public function delete($item_id)

+ {

+ $removed_items = $this->remove_item_from_nestedset($item_id);

+

+ $sql = 'DELETE FROM ' . $this->table_name . '

+ WHERE ' . $this->db->sql_in_set($this->column_item_id, $removed_items) . '

+ ' . $this->get_sql_where('AND');

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

+

+ return $removed_items;

+ }

+

+ /**

+ * @inheritdoc

+ */

+ public function move($item_id, $delta)

+ {

+ if ($delta == 0)

+ {

+ return false;

+ }

+

+ $this->acquire_lock();

+

+ $action = ($delta > 0) ? 'move_up' : 'move_down';

+ $delta = abs($delta);

+

+ // Keep $this->get_sql_where() here, to ensure we are in the right tree.

+ $sql = 'SELECT *

+ FROM ' . $this->table_name . '

+ WHERE ' . $this->column_item_id . ' = ' . (int) $item_id . '

+ ' . $this->get_sql_where();

+ $result = $this->db->sql_query_limit($sql, $delta);

+ $item = $this->db->sql_fetchrow($result);

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

+

+ if (!$item)

+ {

+ $this->lock->release();

+ throw new OutOfBoundsException($this->message_prefix . 'INVALID_ITEM');

+ }

+

+ /**

+ * Fetch all the siblings between the item's current spot

+ * and where we want to move it to. If there are less than $delta

+ * siblings between the current spot and the target then the

+ * item will move as far as possible

+ */

+ $sql = "SELECT {$this->column_item_id}, {$this->column_parent_id}, {$this->column_left_id}, {$this->column_right_id}, {$this->column_item_parents}

+ FROM " . $this->table_name . '

+ WHERE ' . $this->column_parent_id . ' = ' . (int) $item[$this->column_parent_id] . '

+ ' . $this->get_sql_where() . '

+ AND ';

+

+ if ($action == 'move_up')

+ {

+ $sql .= $this->column_right_id . ' < ' . (int) $item[$this->column_right_id] . ' ORDER BY ' . $this->column_right_id . ' DESC';

+ }

+ else

+ {

+ $sql .= $this->column_left_id . ' > ' . (int) $item[$this->column_left_id] . ' ORDER BY ' . $this->column_left_id . ' ASC';

+ }

+

+ $result = $this->db->sql_query_limit($sql, $delta);

+

+ $target = false;

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

+ {

+ $target = $row;

+ }

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

+

+ if (!$target)

+ {

+ $this->lock->release();

+ // The item is already on top or bottom

+ return false;

+ }

+

+ /**

+ * $left_id and $right_id define the scope of the items that are affected by the move.

+ * $diff_up and $diff_down are the values to substract or add to each item's left_id

+ * and right_id in order to move them up or down.

+ * $move_up_left and $move_up_right define the scope of the items that are moving

+ * up. Other items in the scope of ($left_id, $right_id) are considered to move down.

+ */

+ if ($action == 'move_up')

+ {

+ $left_id = (int) $target[$this->column_left_id];

+ $right_id = (int) $item[$this->column_right_id];

+

+ $diff_up = (int) $item[$this->column_left_id] - (int) $target[$this->column_left_id];

+ $diff_down = (int) $item[$this->column_right_id] + 1 - (int) $item[$this->column_left_id];

+

+ $move_up_left = (int) $item[$this->column_left_id];

+ $move_up_right = (int) $item[$this->column_right_id];

+ }

+ else

+ {

+ $left_id = (int) $item[$this->column_left_id];

+ $right_id = (int) $target[$this->column_right_id];

+

+ $diff_up = (int) $item[$this->column_right_id] + 1 - (int) $item[$this->column_left_id];

+ $diff_down = (int) $target[$this->column_right_id] - (int) $item[$this->column_right_id];

+

+ $move_up_left = (int) $item[$this->column_right_id] + 1;

+ $move_up_right = (int) $target[$this->column_right_id];

+ }

+

+ // Now do the dirty job

+ $sql = 'UPDATE ' . $this->table_name . '

+ SET ' . $this->column_left_id . ' = ' . $this->column_left_id . ' + CASE

+ WHEN ' . $this->column_left_id . " BETWEEN {$move_up_left} AND {$move_up_right} THEN -{$diff_up}

+ ELSE {$diff_down}

+ END,

+ " . $this->column_right_id . ' = ' . $this->column_right_id . ' + CASE

+ WHEN ' . $this->column_right_id . " BETWEEN {$move_up_left} AND {$move_up_right} THEN -{$diff_up}

+ ELSE {$diff_down}

+ END

+ WHERE

+ " . $this->column_left_id . " BETWEEN {$left_id} AND {$right_id}

+ AND " . $this->column_right_id . " BETWEEN {$left_id} AND {$right_id}

+ " . $this->get_sql_where();

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

+

+ $this->lock->release();

+

+ return true;

+ }

+

+ /**

+ * @inheritdoc

+ */

+ public function move_down($item_id)

+ {

+ return $this->move($item_id, -1);

+ }

+

+ /**

+ * @inheritdoc

+ */

+ public function move_up($item_id)

+ {

+ return $this->move($item_id, 1);

+ }

+

+ /**

+ * @inheritdoc

+ */

+ public function move_children($current_parent_id, $new_parent_id)

+ {

+ $current_parent_id = (int) $current_parent_id;

+ $new_parent_id = (int) $new_parent_id;

+

+ if ($current_parent_id == $new_parent_id)

+ {

+ return false;

+ }

+

+ if (!$current_parent_id)

+ {

+ throw new OutOfBoundsException($this->message_prefix . 'INVALID_ITEM');

+ }

+

+ $this->acquire_lock();

+

+ $item_data = $this->get_subtree_data($current_parent_id);

+ if (!isset($item_data[$current_parent_id]))

+ {

+ $this->lock->release();

+ throw new OutOfBoundsException($this->message_prefix . 'INVALID_ITEM');

+ }

+

+ $current_parent = $item_data[$current_parent_id];

+ unset($item_data[$current_parent_id]);

+ $move_items = array_keys($item_data);

+

+ if (($current_parent[$this->column_right_id] - $current_parent[$this->column_left_id]) <= 1)

+ {

+ $this->lock->release();

+ return false;

+ }

+

+ if (in_array($new_parent_id, $move_items))

+ {

+ $this->lock->release();

+ throw new OutOfBoundsException($this->message_prefix . 'INVALID_PARENT');

+ }

+

+ $diff = sizeof($move_items) * 2;

+ $sql_exclude_moved_items = $this->db->sql_in_set($this->column_item_id, $move_items, true);

+

+ $this->db->sql_transaction('begin');

+

+ $this->remove_subset($move_items, $current_parent, false, true);

+

+ if ($new_parent_id)

+ {

+ // Retrieve new-parent again, it may have been changed...

+ $sql = 'SELECT *

+ FROM ' . $this->table_name . '

+ WHERE ' . $this->column_item_id . ' = ' . $new_parent_id;

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

+ $new_parent = $this->db->sql_fetchrow($result);

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

+

+ if (!$new_parent)

+ {

+ $this->db->sql_transaction('rollback');

+ $this->lock->release();

+ throw new OutOfBoundsException($this->message_prefix . 'INVALID_PARENT');

+ }

+

+ $new_right_id = $this->prepare_adding_subset($move_items, $new_parent, true);

+

+ if ($new_right_id > $current_parent[$this->column_right_id])

+ {

+ $diff = ' + ' . ($new_right_id - $current_parent[$this->column_right_id]);

+ }

+ else

+ {

+ $diff = ' - ' . abs($new_right_id - $current_parent[$this->column_right_id]);

+ }

+ }

+ else

+ {

+ $sql = 'SELECT MAX(' . $this->column_right_id . ') AS ' . $this->column_right_id . '

+ FROM ' . $this->table_name . '

+ WHERE ' . $sql_exclude_moved_items . '

+ ' . $this->get_sql_where('AND');

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

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

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

+

+ $diff = ' + ' . ($row[$this->column_right_id] - $current_parent[$this->column_left_id]);

+ }

+

+ $sql = 'UPDATE ' . $this->table_name . '

+ SET ' . $this->column_left_id . ' = ' . $this->column_left_id . $diff . ',

+ ' . $this->column_right_id . ' = ' . $this->column_right_id . $diff . ',

+ ' . $this->column_parent_id . ' = ' . $this->db->sql_case($this->column_parent_id . ' = ' . $current_parent_id, $new_parent_id, $this->column_parent_id) . ',

+ ' . $this->column_item_parents . " = ''

+ WHERE " . $this->db->sql_in_set($this->column_item_id, $move_items) . '

+ ' . $this->get_sql_where('AND');

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

+

+ $this->db->sql_transaction('commit');

+ $this->lock->release();

+

+ return true;

+ }

+

+ /**

+ * @inheritdoc

+ */

+ public function change_parent($item_id, $new_parent_id)

+ {

+ $item_id = (int) $item_id;

+ $new_parent_id = (int) $new_parent_id;

+

+ if ($item_id == $new_parent_id)

+ {

+ return false;

+ }

+

+ if (!$item_id)

+ {

+ throw new OutOfBoundsException($this->message_prefix . 'INVALID_ITEM');

+ }

+

+ $this->acquire_lock();

+

+ $item_data = $this->get_subtree_data($item_id);

+ if (!isset($item_data[$item_id]))

+ {

+ $this->lock->release();

+ throw new OutOfBoundsException($this->message_prefix . 'INVALID_ITEM');

+ }

+

+ $item = $item_data[$item_id];

+ $move_items = array_keys($item_data);

+

+ if (in_array($new_parent_id, $move_items))

+ {

+ $this->lock->release();

+ throw new OutOfBoundsException($this->message_prefix . 'INVALID_PARENT');

+ }

+

+ $diff = sizeof($move_items) * 2;

+ $sql_exclude_moved_items = $this->db->sql_in_set($this->column_item_id, $move_items, true);

+

+ $this->db->sql_transaction('begin');

+

+ $this->remove_subset($move_items, $item, false, true);

+

+ if ($new_parent_id)

+ {

+ // Retrieve new-parent again, it may have been changed...

+ $sql = 'SELECT *

+ FROM ' . $this->table_name . '

+ WHERE ' . $this->column_item_id . ' = ' . $new_parent_id;

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

+ $new_parent = $this->db->sql_fetchrow($result);

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

+

+ if (!$new_parent)

+ {

+ $this->db->sql_transaction('rollback');

+ $this->lock->release();

+ throw new OutOfBoundsException($this->message_prefix . 'INVALID_PARENT');

+ }

+

+ $new_right_id = $this->prepare_adding_subset($move_items, $new_parent, true);

+

+ if ($new_right_id > (int) $item[$this->column_right_id])

+ {

+ $diff = ' + ' . ($new_right_id - (int) $item[$this->column_right_id] - 1);

+ }

+ else

+ {

+ $diff = ' - ' . abs($new_right_id - (int) $item[$this->column_right_id] - 1);

+ }

+ }

+ else

+ {

+ $sql = 'SELECT MAX(' . $this->column_right_id . ') AS ' . $this->column_right_id . '

+ FROM ' . $this->table_name . '

+ WHERE ' . $sql_exclude_moved_items . '

+ ' . $this->get_sql_where('AND');

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

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

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

+

+ $diff = ' + ' . ($row[$this->column_right_id] - (int) $item[$this->column_left_id] + 1);

+ }

+

+ $sql = 'UPDATE ' . $this->table_name . '

+ SET ' . $this->column_left_id . ' = ' . $this->column_left_id . $diff . ',

+ ' . $this->column_right_id . ' = ' . $this->column_right_id . $diff . ',

+ ' . $this->column_parent_id . ' = ' . $this->db->sql_case($this->column_item_id . ' = ' . $item_id, $new_parent_id, $this->column_parent_id) . ',

+ ' . $this->column_item_parents . " = ''

+ WHERE " . $this->db->sql_in_set($this->column_item_id, $move_items) . '

+ ' . $this->get_sql_where('AND');

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

+

+ $this->db->sql_transaction('commit');

+ $this->lock->release();

+

+ return true;

+ }

+

+ /**

+ * @inheritdoc

+ */

+ public function get_path_and_subtree_data($item_id, $order_asc = true, $include_item = true)

+ {

+ $condition = 'i2.' . $this->column_left_id . ' BETWEEN i1.' . $this->column_left_id . ' AND i1.' . $this->column_right_id . '

+ OR i1.' . $this->column_left_id . ' BETWEEN i2.' . $this->column_left_id . ' AND i2.' . $this->column_right_id;

+

+ return $this->get_set_of_nodes_data($item_id, $condition, $order_asc, $include_item);

+ }

+

+ /**

+ * @inheritdoc

+ */

+ public function get_path_data($item_id, $order_asc = true, $include_item = true)

+ {

+ $condition = 'i1.' . $this->column_left_id . ' BETWEEN i2.' . $this->column_left_id . ' AND i2.' . $this->column_right_id . '';

+

+ return $this->get_set_of_nodes_data($item_id, $condition, $order_asc, $include_item);

+ }

+

+ /**

+ * @inheritdoc

+ */

+ public function get_subtree_data($item_id, $order_asc = true, $include_item = true)

+ {

+ $condition = 'i2.' . $this->column_left_id . ' BETWEEN i1.' . $this->column_left_id . ' AND i1.' . $this->column_right_id . '';

+

+ return $this->get_set_of_nodes_data($item_id, $condition, $order_asc, $include_item);

+ }

+

+ /**

+ * Get items that are related to the given item by the condition

+ *

+ * @param int $item_id Id of the item to retrieve the node set from

+ * @param string $condition Query string restricting the item list

+ * @param bool $order_asc Order the items ascending by their left_id

+ * @param bool $include_item Should the item matching the given item id be included in the list as well

+ * @return array Array of items (containing all columns from the item table)

+ * ID => Item data

+ */

+ protected function get_set_of_nodes_data($item_id, $condition, $order_asc = true, $include_item = true)

+ {

+ $rows = array();

+

+ $sql = 'SELECT i2.*

+ FROM ' . $this->table_name . ' i1

+ LEFT JOIN ' . $this->table_name . " i2

+ ON (($condition) " . $this->get_sql_where('AND', 'i2.') . ')

+ WHERE i1.' . $this->column_item_id . ' = ' . (int) $item_id . '

+ ' . $this->get_sql_where('AND', 'i1.') . '

+ ORDER BY i2.' . $this->column_left_id . ' ' . ($order_asc ? 'ASC' : 'DESC');

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

+

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

+ {

+ if (!$include_item && $item_id == $row[$this->column_item_id])

+ {

+ continue;

+ }

+

+ $rows[(int) $row[$this->column_item_id]] = $row;

+ }

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

+

+ return $rows;

+ }

+

+ /**

+ * Get basic data of all parent items

+ *

+ * Basic data is defined in the $item_basic_data property.

+ * Data is cached in the item_parents column in the item table

+ *

+ * @param array $item The item to get the path from

+ * @return array Array of items (containing basic columns from the item table)

+ * ID => Item data

+ */

+ public function get_path_basic_data(array $item)

+ {

+ $parents = array();

+ if ($item[$this->column_parent_id])

+ {

+ if (!$item[$this->column_item_parents])

+ {

+ $sql = 'SELECT ' . implode(', ', $this->item_basic_data) . '

+ FROM ' . $this->table_name . '

+ WHERE ' . $this->column_left_id . ' < ' . (int) $item[$this->column_left_id] . '

+ AND ' . $this->column_right_id . ' > ' . (int) $item[$this->column_right_id] . '

+ ' . $this->get_sql_where('AND') . '

+ ORDER BY ' . $this->column_left_id . ' ASC';

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

+

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

+ {

+ $parents[$row[$this->column_item_id]] = $row;

+ }

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

+

+ $item_parents = serialize($parents);

+

+ $sql = 'UPDATE ' . $this->table_name . '

+ SET ' . $this->column_item_parents . " = '" . $this->db->sql_escape($item_parents) . "'

+ WHERE " . $this->column_parent_id . ' = ' . (int) $item[$this->column_parent_id];

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

+ }

+ else

+ {

+ $parents = unserialize($item[$this->column_item_parents]);

+ }

+ }

+

+ return $parents;

+ }

+

+ /**

+ * Remove a subset from the nested set

+ *

+ * @param array $subset_items Subset of items to remove

+ * @param array $bounding_item Item containing the right bound of the subset

+ * @param bool $set_subset_zero Should the parent, left and right id of the items be set to 0, or kept unchanged?

+ * In case of removing an item from the tree, we should the values to 0

+ * In case of moving an item, we shouldkeep the original values, in order to allow "+ diff" later

+ * @return null

+ */

+ protected function remove_subset(array $subset_items, array $bounding_item, $set_subset_zero = true)

+ {

+ $acquired_new_lock = $this->acquire_lock();

+

+ $diff = sizeof($subset_items) * 2;

+ $sql_subset_items = $this->db->sql_in_set($this->column_item_id, $subset_items);

+ $sql_not_subset_items = $this->db->sql_in_set($this->column_item_id, $subset_items, true);

+

+ $sql_is_parent = $this->column_left_id . ' <= ' . (int) $bounding_item[$this->column_right_id] . '

+ AND ' . $this->column_right_id . ' >= ' . (int) $bounding_item[$this->column_right_id];

+

+ $sql_is_right = $this->column_left_id . ' > ' . (int) $bounding_item[$this->column_right_id];

+

+ $set_left_id = $this->db->sql_case($sql_is_right, $this->column_left_id . ' - ' . $diff, $this->column_left_id);

+ $set_right_id = $this->db->sql_case($sql_is_parent . ' OR ' . $sql_is_right, $this->column_right_id . ' - ' . $diff, $this->column_right_id);

+

+ if ($set_subset_zero)

+ {

+ $set_left_id = $this->db->sql_case($sql_subset_items, 0, $set_left_id);

+ $set_right_id = $this->db->sql_case($sql_subset_items, 0, $set_right_id);

+ }

+

+ $sql = 'UPDATE ' . $this->table_name . '

+ SET ' . (($set_subset_zero) ? $this->column_parent_id . ' = ' . $this->db->sql_case($sql_subset_items, 0, $this->column_parent_id) . ',' : '') . '

+ ' . $this->column_left_id . ' = ' . $set_left_id . ',

+ ' . $this->column_right_id . ' = ' . $set_right_id . '

+ ' . ((!$set_subset_zero) ? ' WHERE ' . $sql_not_subset_items . ' ' . $this->get_sql_where('AND') : $this->get_sql_where('WHERE'));

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

+

+ if ($acquired_new_lock)

+ {

+ $this->lock->release();

+ }

+ }

+

+ /**

+ * Prepare adding a subset to the nested set

+ *

+ * @param array $subset_items Subset of items to add

+ * @param array $new_parent Item containing the right bound of the new parent

+ * @return int New right id of the parent item

+ */

+ protected function prepare_adding_subset(array $subset_items, array $new_parent)

+ {

+ $diff = sizeof($subset_items) * 2;

+ $sql_not_subset_items = $this->db->sql_in_set($this->column_item_id, $subset_items, true);

+

+ $set_left_id = $this->db->sql_case($this->column_left_id . ' > ' . (int) $new_parent[$this->column_right_id], $this->column_left_id . ' + ' . $diff, $this->column_left_id);

+ $set_right_id = $this->db->sql_case($this->column_right_id . ' >= ' . (int) $new_parent[$this->column_right_id], $this->column_right_id . ' + ' . $diff, $this->column_right_id);

+

+ $sql = 'UPDATE ' . $this->table_name . '

+ SET ' . $this->column_left_id . ' = ' . $set_left_id . ',

+ ' . $this->column_right_id . ' = ' . $set_right_id . '

+ WHERE ' . $sql_not_subset_items . '

+ ' . $this->get_sql_where('AND');

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

+

+ return $new_parent[$this->column_right_id] + $diff;

+ }

+

+ /**

+ * Resets values required for the nested set system

+ *

+ * @param array $item Original item data

+ * @return array Original item data + nested set defaults

+ */

+ protected function reset_nestedset_values(array $item)

+ {

+ $item_data = array_merge($item, array(

+ $this->column_parent_id => 0,

+ $this->column_left_id => 0,

+ $this->column_right_id => 0,

+ $this->column_item_parents => '',

+ ));

+

+ unset($item_data[$this->column_item_id]);

+

+ return $item_data;

+ }

+

+ /**

+ * Regenerate left/right ids from parent/child relationship

+ *

+ * This method regenerates the left/right ids for the tree based on

+ * the parent/child relations. This function executes three queries per

+ * item, so it should only be called, when the set has one of the following

+ * problems:

+ * - The set has a duplicated value inside the left/right id chain

+ * - The set has a missing value inside the left/right id chain

+ * - The set has items that do not have a left/right id set

+ *

+ * When regenerating the items, the items are sorted by parent id and their

+ * current left id, so the current child/parent relationships are kept

+ * and running the function on a working set will not change the order.

+ *

+ * @param int $new_id First left_id to be used (should start with 1)

+ * @param int $parent_id parent_id of the current set (default = 0)

+ * @param bool $reset_ids Should we reset all left_id/right_id on the first call?

+ * @return int $new_id The next left_id/right_id that should be used

+ */

+ public function regenerate_left_right_ids($new_id, $parent_id = 0, $reset_ids = false)

+ {

+ if ($acquired_new_lock = $this->acquire_lock())

+ {

+ $this->db->sql_transaction('begin');

+

+ if (!$reset_ids)

+ {

+ $sql = 'UPDATE ' . $this->table_name . '

+ SET ' . $this->column_item_parents . " = ''

+ " . $this->get_sql_where('WHERE');

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

+ }

+ }

+

+ if ($reset_ids)

+ {

+ $sql = 'UPDATE ' . $this->table_name . '

+ SET ' . $this->db->sql_build_array('UPDATE', array(

+ $this->column_left_id => 0,

+ $this->column_right_id => 0,

+ $this->column_item_parents => '',

+ )) . '

+ ' . $this->get_sql_where('WHERE');

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

+ }

+

+ $sql = 'SELECT *

+ FROM ' . $this->table_name . '

+ WHERE ' . $this->column_parent_id . ' = ' . (int) $parent_id . '

+ ' . $this->get_sql_where('AND') . '

+ ORDER BY ' . $this->column_left_id . ', ' . $this->column_item_id . ' ASC';

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

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

+ {

+ // First we update the left_id for this module

+ if ($row[$this->column_left_id] != $new_id)

+ {

+ $sql = 'UPDATE ' . $this->table_name . '

+ SET ' . $this->db->sql_build_array('UPDATE', array($this->column_left_id => $new_id)) . '

+ WHERE ' . $this->column_item_id . ' = ' . (int) $row[$this->column_item_id];

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

+ }

+ $new_id++;

+

+ // Then we go through any children and update their left/right id's

+ $new_id = $this->regenerate_left_right_ids($new_id, $row[$this->column_item_id]);

+

+ // Then we come back and update the right_id for this module

+ if ($row[$this->column_right_id] != $new_id)

+ {

+ $sql = 'UPDATE ' . $this->table_name . '

+ SET ' . $this->db->sql_build_array('UPDATE', array($this->column_right_id => $new_id)) . '

+ WHERE ' . $this->column_item_id . ' = ' . (int) $row[$this->column_item_id];

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

+ }

+ $new_id++;

+ }

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

+

+ if ($acquired_new_lock)

+ {

+ $this->db->sql_transaction('commit');

+ $this->lock->release();

+ }

+

+ return $new_id;

+ }

+}

+<?php

+/**

+*

+* @package tree

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+class phpbb_tree_nestedset_forum extends phpbb_tree_nestedset

+{

+ /**

+ * Construct

+ *

+ * @param phpbb_db_driver $db Database connection

+ * @param phpbb_lock_db $lock Lock class used to lock the table when moving forums around

+ * @param string $table_name Table name

+ */

+ public function __construct(phpbb_db_driver $db, phpbb_lock_db $lock, $table_name)

+ {

+ parent::__construct(

+ $db,

+ $lock,

+ $table_name,

+ 'FORUM_NESTEDSET_',

+ '',

+ array(

+ 'forum_id',

+ 'forum_name',

+ 'forum_type',

+ ),

+ array(

+ 'item_id' => 'forum_id',

+ 'item_parents' => 'forum_parents',

+ )

+ );

+ }

+}

+ $sql = 'SELECT g.*, t.teampage_position AS group_teampage

+ FROM ' . GROUPS_TABLE . ' g

+ LEFT JOIN ' . TEAMPAGE_TABLE . ' t

+ ON (t.group_id = g.group_id)

+ WHERE g.group_id = ' . $group_id;

+ 'legend' => $group_row['group_legend'],

+ 'teampage' => $group_row['group_teampage'],

+

+ // Merge any avatars errors into the primary error array

+ $error = array_merge($error, $phpbb_avatar_manager->localize_errors($user, $avatar_error));

+ // Validate submitted colour value

+ if ($colour_error = validate_data($submit_ary, array('colour' => array('hex_colour', true))))

+ {

+ // Replace "error" string with its real, localised form

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

+ }

+

+ // However there are some attributes that need to be set everytime,

+ // otherwise the group gets removed from the feature.

+ $set_attributes = array('legend', 'teampage');

+ 'teampage' => 'int',

+ if (isset($submit_ary[$test]) && ($action == 'add' || $group_row['group_' . $test] != $submit_ary[$test] || isset($group_attributes['group_avatar']) && strpos($test, 'avatar') === 0 || in_array($test, $set_attributes)))

+ $cache->destroy('sql', TEAMPAGE_TABLE);

+ if (isset($phpbb_avatar_manager) && !$update)

+ {

+ // Merge any avatars errors into the primary error array

+ $error = array_merge($error, $phpbb_avatar_manager->localize_errors($user, $avatar_error));

+ }

+

+ $template->assign_vars(array(

+ strtoupper($block) . '_COLS' => sizeof($notification_methods) + 2,

+ ));

+ $sql = 'SELECT forum_id, forum_name, forum_password

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

+ if (!empty($forum_data['forum_password']))

+ login_forum_box($forum_data);

+ if (!$config['allow_password_reset'])

+ {

+ trigger_error($user->lang('UCP_PASSWORD_RESET_DISABLED', '<a href="mailto:' . htmlspecialchars($config['board_contact']) . '">', '</a>'));

+ }

+