+ global $cache, $phpbb_container;

+ $phpbb_avatar_manager = $phpbb_container->get('avatar.manager');

+ $avatar_drivers = $phpbb_avatar_manager->get_all_drivers();

+

+ $avatar_vars = array();

+ foreach ($avatar_drivers as $current_driver)

+ {

+ $driver = $phpbb_avatar_manager->get_driver($current_driver, false);

+

+ /*

+ * First grab the settings for enabling/disabling the avatar

+ * driver and afterwards grab additional settings the driver

+ * might have.

+ */

+ $avatar_vars += $phpbb_avatar_manager->get_avatar_settings($driver);

+ $avatar_vars += $driver->prepare_form_acp($user);

+ }

+

+

+ if (!empty($avatar_vars))

+ {

+ $display_vars['vars'] += $avatar_vars;

+ }

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

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

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

+ $user->add_lang(array('install', 'acp/extensions', 'migrator'));

+ try

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

+ {

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

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

+ }

+ }

+ catch (phpbb_db_migration_exception $e)

+ {

+ $template->assign_var('MIGRATOR_ERROR', $e->getLocalisedMessage($user));

+ try

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

+ {

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

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

+ }

+ }

+ catch (phpbb_db_migration_exception $e)

+ {

+ $template->assign_var('MIGRATOR_ERROR', $e->getLocalisedMessage($user));

+ phpbb_cache_moderators($db, $cache, $auth);

+

+ phpbb_cache_moderators($db, $cache, $auth);

+ global $request, $phpbb_container;

+ $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;

+ else if (empty($mark_ary))

+ {

+ trigger_error($user->lang['NO_USERS'] . adm_back_link($this->u_action . '&action=list&g=' . $group_id), E_USER_WARNING);

+ }

+ group_user_attributes('default', $group_id, $mark_ary, false, $group_name, $group_row);

+ trigger_error($user->lang['GROUP_DEFS_UPDATED'] . adm_back_link($this->u_action . '&action=list&g=' . $group_id));

+ }

+ else

+ {

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

+ 'mark' => $mark_ary,

+ 'g' => $group_id,

+ 'i' => $id,

+ 'mode' => $mode,

+ 'action' => $action))

+ );

+ }

+ break;

+ case 'set_default_on_all':

+ if (confirm_box(true))

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

+

+

+ trigger_error($user->lang['GROUP_DEFS_UPDATED'] . adm_back_link($this->u_action . '&action=list&g=' . $group_id));

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

+ 'mark' => $mark_ary,

+ 'g' => $group_id,

+ 'i' => $id,

+ 'mode' => $mode,

+ 'action' => $action))

+ );

+ if (empty($mark_ary))

+ {

+ trigger_error($user->lang['NO_USERS'] . adm_back_link($this->u_action . '&action=list&g=' . $group_id), E_USER_WARNING);

+ }

+ // Setup avatar data for later

+ $avatars_enabled = false;

+ $avatar_drivers = null;

+ $avatar_data = null;

+ $avatar_error = array();

+

+ if ($config['allow_avatar'])

+ {

+ $phpbb_avatar_manager = $phpbb_container->get('avatar.manager');

+ $avatar_drivers = $phpbb_avatar_manager->get_enabled_drivers();

+

+ // This is normalised data, without the group_ prefix

+ $avatar_data = phpbb_avatar_manager::clean_row($group_row);

+ }

+

+ if ($config['allow_avatar'])

+ // Handle avatar

+ $driver_name = $phpbb_avatar_manager->clean_driver_name($request->variable('avatar_driver', ''));

+ if (in_array($driver_name, $avatar_drivers) && !$request->is_set_post('avatar_delete'))

+ $driver = $phpbb_avatar_manager->get_driver($driver_name);

+ $result = $driver->process_form($request, $template, $user, $avatar_data, $avatar_error);

+ if ($result && empty($avatar_error))

+ $result['avatar_type'] = $driver_name;

+ $submit_ary = array_merge($submit_ary, $result);

+ else

+ $driver = $phpbb_avatar_manager->get_driver($user->data['user_avatar_type']);

+ if ($driver)

+ $driver->delete($avatar_data);

+ // Removing the avatar

+ $submit_ary['avatar_type'] = '';

+ $submit_ary['avatar'] = '';

+ $submit_ary['avatar_width'] = 0;

+ $submit_ary['avatar_height'] = 0;

+ 'avatar_type' => 'string',

+ 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', array(GROUPS_TABLE, TEAMPAGE_TABLE));

+ // Load up stuff for avatars

+ if ($config['allow_avatar'])

+ {

+ $avatars_enabled = false;

+ $selected_driver = $phpbb_avatar_manager->clean_driver_name($request->variable('avatar_driver', $avatar_data['avatar_type']));

+

+ foreach ($avatar_drivers as $current_driver)

+ {

+ $driver = $phpbb_avatar_manager->get_driver($current_driver);

+ $avatars_enabled = true;

+ $config_name = $phpbb_avatar_manager->get_driver_config_name($driver);

+ $template->set_filenames(array(

+ 'avatar' => "acp_avatar_options_{$config_name}.html",

+ ));

+ if ($driver->prepare_form($request, $template, $user, $avatar_data, $avatar_error))

+ {

+ $driver_name = $phpbb_avatar_manager->prepare_driver_name($current_driver);

+ $driver_upper = strtoupper($driver_name);

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

+ 'L_TITLE' => $user->lang($driver_upper . '_TITLE'),

+ 'L_EXPLAIN' => $user->lang($driver_upper . '_EXPLAIN'),

+

+ 'DRIVER' => $driver_name,

+ 'SELECTED' => $current_driver == $selected_driver,

+ 'OUTPUT' => $template->assign_display('avatar'),

+ ));

+ }

+ }

+ $avatar = phpbb_get_group_avatar($group_row, 'GROUP_AVATAR', true);

+

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

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

+

+ 'S_AVATARS_ENABLED' => ($config['allow_avatar'] && $avatars_enabled),

+ 'AVATAR' => empty($avatar) ? '<img src="' . $phpbb_admin_path . 'images/no_avatar.gif" alt="" />' : $avatar,

+ 'U_DEFAULT_ALL' => "{$this->u_action}&amp;action=set_default_on_all&amp;g=$group_id",

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

+ $field = $request->variable('field', '');

+ $action = $request->variable('action', '');

+ $group_id = $request->variable('g', 0);

+ $teampage_id = $request->variable('t', 0);

+ $category_id = $request->variable('c', 0);

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

+

+ $group_position = $phpbb_container->get('groupposition.' . $field);

+ if ($field == 'teampage')

+ try

+ {

+ switch ($action)

+ {

+ case 'add':

+ $group_position->add_group_teampage($group_id, $category_id);

+ break;

+ case 'add_category':

+ $group_position->add_category_teampage($request->variable('category_name', '', true));

+ break;

+ case 'delete':

+ $group_position->delete_teampage($teampage_id);

+ break;

+ case 'move_up':

+ $group_position->move_up_teampage($teampage_id);

+ break;

+ case 'move_down':

+ $group_position->move_down_teampage($teampage_id);

+ break;

+ }

+ }

+ catch (phpbb_groupposition_exception $exception)

+ {

+ trigger_error($user->lang($exception->getMessage()) . adm_back_link($this->u_action), E_USER_WARNING);

+ }

+ }

+ else if ($field == 'legend')

+ {

+ try

+ {

+ switch ($action)

+ {

+ case 'add':

+ $group_position->add_group($group_id);

+ break;

+ case 'delete':

+ $group_position->delete_group($group_id);

+ break;

+

+ case 'move_up':

+ $group_position->move_up($group_id);

+ break;

+

+ case 'move_down':

+ $group_position->move_down($group_id);

+ break;

+ }

+ }

+ catch (phpbb_groupposition_exception $exception)

+ {

+ trigger_error($user->lang($exception->getMessage()) . adm_back_link($this->u_action), E_USER_WARNING);

+ }

+ }

+ else

+ {

+ switch ($action)

+ {

+ case 'set_config_teampage':

+ $config->set('teampage_forums', $request->variable('teampage_forums', 0));

+ $config->set('teampage_memberships', $request->variable('teampage_memberships', 0));

+ break;

+

+ case 'set_config_legend':

+ $config->set('legend_sort_groupname', $request->variable('legend_sort_groupname', 0));

+ break;

+ }

+ }

+

+ if (($action == 'move_up' || $action == 'move_down') && $request->is_ajax())

+ {

+ $json_response = new phpbb_json_response;

+ $json_response->send(array('success' => true));

+ ORDER BY group_legend ASC, group_type DESC, group_name ASC';

+ 'GROUP_NAME' => $group_name,

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

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

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

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

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

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

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

+ 'GROUP_NAME' => $group_name,

+ 'GROUP_SPECIAL' => ($row['group_type'] == GROUP_SPECIAL),

+ ));

+ $category_url_param = (($category_id) ? '&amp;c=' . $category_id : '');

+

+ $sql = 'SELECT t.*, g.group_name, g.group_colour, g.group_type

+ FROM ' . TEAMPAGE_TABLE . ' t

+ LEFT JOIN ' . GROUPS_TABLE . ' g

+ ON (t.group_id = g.group_id)

+ WHERE t.teampage_parent = ' . $category_id . '

+ OR t.teampage_id = ' . $category_id . '

+ ORDER BY t.teampage_position ASC';

+ $category_data = array();

+ if ($row['teampage_id'] == $category_id)

+ $template->assign_vars(array(

+ 'CURRENT_CATEGORY_NAME' => $row['teampage_name'],

+ continue;

+ }

+

+ if ($row['group_id'])

+ {

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

+ $group_type = $user->lang[phpbb_groupposition_teampage::group_type_language($row['group_type'])];

+ $group_name = $row['teampage_name'];

+ $group_type = '';

+

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

+ 'GROUP_NAME' => $group_name,

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

+ 'GROUP_TYPE' => $group_type,

+

+ 'U_CATEGORY' => (!$row['group_id']) ? "{$this->u_action}&amp;c=" . $row['teampage_id'] : '',

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

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

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

+ ));

+ }

+ $db->sql_freeresult($result);

+

+ $sql = 'SELECT g.group_id, g.group_name, g.group_colour, g.group_type

+ FROM ' . GROUPS_TABLE . ' g

+ LEFT JOIN ' . TEAMPAGE_TABLE . ' t

+ ON (t.group_id = g.group_id)

+ WHERE t.teampage_id IS NULL

+ ORDER BY g.group_type DESC, g.group_name ASC';

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

+

+ $s_group_select_teampage = '';

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

+ {

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

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

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

+ 'GROUP_NAME' => $group_name,

+ 'GROUP_SPECIAL' => ($row['group_type'] == GROUP_SPECIAL),

+ ));

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

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

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

+ 'U_ACTION_TEAMPAGE_CAT' => $this->u_action . '&amp;field=teampage_cat',

+ 'S_TEAMPAGE_CATEGORY' => $category_id,

+ global $config, $db, $cache, $user, $auth, $template, $request;

+

+

+

+

+

+ phpbb_cache_moderators($db, $cache, $auth);

+

+

+ *

+ * @param string $module

+ * @param bool|string $module_class

+ * @param bool $use_all_available Use all available instead of just all

+ * enabled extensions

+ * @return array

+ function get_module_infos($module = '', $module_class = false, $use_all_available = false)

+ ->get_classes(true, $use_all_available);

+ $info_class = $module . '_info';

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

+ global $phpbb_container;

+ $phpbb_container->get('cache.driver')->destroy('_modules_' . $p_class);

+ $phpbb_container->get('cache.driver')->destroy('sql', MODULES_TABLE);

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

+ phpbb_cache_moderators($db, $cache, $auth);

+ phpbb_update_foes($db, $auth, $group_id, $user_id);

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

+ phpbb_cache_moderators($db, $cache, $auth);

+ phpbb_update_foes($db, $auth, $group_id, $user_id);

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

+ phpbb_cache_moderators($db, $cache, $auth);

+ $userdata = $auth->obtain_user_data($user_id);

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

+ phpbb_cache_moderators($db, $cache, $auth);

+

+

+

+ 'RANK_IMAGE' => ($edit_img) ? $phpbb_root_path . $config['ranks_path'] . '/' . $edit_img : htmlspecialchars($phpbb_admin_path) . 'images/spacer.gif',

+

+

+ );

+ global $db, $cache, $auth;

+

+ phpbb_cache_moderators($db, $cache, $auth);

+ global $phpbb_container;

+ 'user_avatar_type' => '',

+ $phpbb_avatar_manager = $phpbb_container->get('avatar.manager');

+ $driver = $phpbb_avatar_manager->get_driver($user_row['user_avatar_type']);

+ if ($driver)

+ $driver->delete($user_row);

+ $avatars_enabled = false;

+ if ($config['allow_avatar'])

+ $phpbb_avatar_manager = $phpbb_container->get('avatar.manager');

+ $avatar_drivers = $phpbb_avatar_manager->get_enabled_drivers();

+ // This is normalised data, without the user_ prefix

+ $avatar_data = phpbb_avatar_manager::clean_row($user_row);

+

+ if ($submit)

+ if (check_form_key($form_name))

+ {

+ $driver_name = $phpbb_avatar_manager->clean_driver_name($request->variable('avatar_driver', ''));

+

+ if (in_array($driver_name, $avatar_drivers) && !$request->is_set_post('avatar_delete'))

+ {

+ $driver = $phpbb_avatar_manager->get_driver($driver_name);

+ $result = $driver->process_form($request, $template, $user, $avatar_data, $error);

+

+ if ($result && empty($error))

+ {

+ // Success! Lets save the result in the database

+ $result = array(

+ 'user_avatar_type' => $driver_name,

+ 'user_avatar' => $result['avatar'],

+ 'user_avatar_width' => $result['avatar_width'],

+ 'user_avatar_height' => $result['avatar_height'],

+ );

+

+ $sql = 'UPDATE ' . USERS_TABLE . '

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

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

+

+ $db->sql_query($sql);

+ trigger_error($user->lang['USER_AVATAR_UPDATED'] . adm_back_link($this->u_action . '&amp;u=' . $user_id));

+ }

+ }

+ else

+ {

+ $driver = $phpbb_avatar_manager->get_driver($user->data['user_avatar_type']);

+ if ($driver)

+ {

+ $driver->delete($avatar_data);

+ }

+

+ // Removing the avatar

+ $result = array(

+ 'user_avatar' => '',

+ 'user_avatar_type' => '',

+ 'user_avatar_width' => 0,

+ 'user_avatar_height' => 0,

+ );

+

+ $sql = 'UPDATE ' . USERS_TABLE . '

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

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

+

+ $db->sql_query($sql);

+ trigger_error($user->lang['USER_AVATAR_UPDATED'] . adm_back_link($this->u_action . '&amp;u=' . $user_id));

+ }

+ }

+ else

+ {

+ }

+ $selected_driver = $phpbb_avatar_manager->clean_driver_name($request->variable('avatar_driver', $user_row['user_avatar_type']));

+ foreach ($avatar_drivers as $current_driver)

+ {

+ $driver = $phpbb_avatar_manager->get_driver($current_driver);

+ $avatars_enabled = true;

+ $config_name = $phpbb_avatar_manager->get_driver_config_name($driver);

+ $template->set_filenames(array(

+ 'avatar' => "acp_avatar_options_{$config_name}.html",

+ ));

+ if ($driver->prepare_form($request, $template, $user, $avatar_data, $error))

+ {

+ $driver_name = $phpbb_avatar_manager->prepare_driver_name($current_driver);

+ $driver_upper = strtoupper($driver_name);

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

+ 'L_TITLE' => $user->lang($driver_upper . '_TITLE'),

+ 'L_EXPLAIN' => $user->lang($driver_upper . '_EXPLAIN'),

+ 'DRIVER' => $driver_name,

+ 'SELECTED' => $current_driver == $selected_driver,

+ 'OUTPUT' => $template->assign_display('avatar'),

+ ));

+ }

+ }

+ // Replace "error" strings with their real, localised form

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

+

+ $avatar = phpbb_get_user_avatar($user_row, 'USER_AVATAR', true);

+

+ 'S_AVATAR' => true,

+ 'ERROR' => (!empty($error)) ? implode('<br />', $error) : '',

+ 'AVATAR' => (empty($avatar) ? '<img src="' . $phpbb_admin_path . 'images/no_avatar.gif" alt="" />' : $avatar),

+

+ 'S_FORM_ENCTYPE' => ' enctype="multipart/form-data"',

+

+ 'L_AVATAR_EXPLAIN' => sprintf($user->lang['AVATAR_EXPLAIN'], $config['avatar_max_width'], $config['avatar_max_height'], $config['avatar_filesize'] / 1024),

+

+ 'S_AVATARS_ENABLED' => ($config['allow_avatar'] && $avatars_enabled),

+ 'title' => 'ACP_EXTENSION_MANAGEMENT',

+ 'main' => array('title' => 'ACP_EXTENSIONS', 'auth' => 'acl_a_extensions', 'cat' => array('ACP_EXTENSION_MANAGEMENT')),

+ * Retrieves data wanted by acl function from the database for the

+ * specified user.

+ *

+ * @param int $user_id User ID

+ * @return array User attributes

+ */

+ public function obtain_user_data($user_id)

+ {

+ global $db;

+

+ $sql = 'SELECT user_id, username, user_permissions, user_type

+ FROM ' . USERS_TABLE . '

+ WHERE user_id = ' . $user_id;

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

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

+ $db->sql_freeresult($result);

+ return $user_data;

+ }

+

+ /**

+ * if the option is prefixed with !, then the result becomes negated

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2011 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Base class for avatar drivers

+* @package phpBB3

+*/

+abstract class phpbb_avatar_driver implements phpbb_avatar_driver_interface

+{

+ /**

+ * Avatar driver name

+ * @var string

+ */

+ protected $name;

+

+ /**

+ * Current board configuration

+ * @var phpbb_config

+ */

+ protected $config;

+

+ /**

+ * Current $phpbb_root_path

+ * @var string

+ */

+ protected $phpbb_root_path;

+

+ /**

+ * Current $php_ext

+ * @var string

+ */

+ protected $php_ext;

+

+ /**

+ * Cache driver

+ * @var phpbb_cache_driver_interface

+ */

+ protected $cache;

+

+ /**

+ * Array of allowed avatar image extensions

+ * Array is used for setting the allowed extensions in the fileupload class

+ * and as a base for a regex of allowed extensions, which will be formed by

+ * imploding the array with a "|".

+ *

+ * @var array

+ */

+ protected $allowed_extensions = array(

+ 'gif',

+ 'jpg',

+ 'jpeg',

+ 'png',

+ );

+

+ /**

+ * Construct a driver object

+ *

+ * @param phpbb_config $config phpBB configuration

+ * @param phpbb_request $request Request object

+ * @param string $phpbb_root_path Path to the phpBB root

+ * @param string $php_ext PHP file extension

+ * @param phpbb_cache_driver_interface $cache Cache driver

+ */

+ public function __construct(phpbb_config $config, $phpbb_root_path, $php_ext, phpbb_cache_driver_interface $cache = null)

+ {

+ $this->config = $config;

+ $this->phpbb_root_path = $phpbb_root_path;

+ $this->php_ext = $php_ext;

+ $this->cache = $cache;

+ }

+

+ /**

+ * @inheritdoc

+ */

+ public function get_custom_html($user, $row, $alt = '')

+ {

+ return '';

+ }

+

+ /**

+ * @inheritdoc

+ */

+ public function prepare_form_acp($user)

+ {

+ return array();

+ }

+

+ /**

+ * @inheritdoc

+ */

+ public function delete($row)

+ {

+ return true;

+ }

+

+ /**

+ * @inheritdoc

+ */

+ public function get_template_name()

+ {

+ $driver = preg_replace('#^phpbb_avatar_driver_#', '', get_class($this));

+ $template = "ucp_avatar_options_$driver.html";

+

+ return $template;

+ }

+

+ /**

+ * @inheritdoc

+ */

+ public function get_name()

+ {

+ return $this->name;

+ }

+

+ /**

+ * Sets the name of the driver.

+ *

+ * @param string $name Driver name

+ */

+ public function set_name($name)

+ {

+ $this->name = $name;

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Handles avatars hosted at gravatar.com

+* @package phpBB3

+*/

+class phpbb_avatar_driver_gravatar extends phpbb_avatar_driver

+{

+ /**

+ * The URL for the gravatar service

+ */

+ const GRAVATAR_URL = '//secure.gravatar.com/avatar/';

+

+ /**

+ * @inheritdoc

+ */

+ public function get_data($row)

+ {

+ return array(

+ 'src' => $row['avatar'],

+ 'width' => $row['avatar_width'],

+ 'height' => $row['avatar_height'],

+ );

+ }

+

+ /**

+ * @inheritdoc

+ */

+ public function get_custom_html($user, $row, $alt = '')

+ {

+ return '<img src="' . $this->get_gravatar_url($row) . '" ' .

+ ($row['avatar_width'] ? ('width="' . $row['avatar_width'] . '" ') : '') .

+ ($row['avatar_height'] ? ('height="' . $row['avatar_height'] . '" ') : '') .

+ 'alt="' . ((!empty($user->lang[$alt])) ? $user->lang[$alt] : $alt) . '" />';

+ }

+

+ /**

+ * @inheritdoc

+ */

+ public function prepare_form($request, $template, $user, $row, &$error)

+ {

+ $template->assign_vars(array(

+ 'AVATAR_GRAVATAR_WIDTH' => (($row['avatar_type'] == $this->get_name() || $row['avatar_type'] == 'gravatar') && $row['avatar_width']) ? $row['avatar_width'] : $request->variable('avatar_gravatar_width', 0),

+ 'AVATAR_GRAVATAR_HEIGHT' => (($row['avatar_type'] == $this->get_name() || $row['avatar_type'] == 'gravatar') && $row['avatar_height']) ? $row['avatar_height'] : $request->variable('avatar_gravatar_width', 0),

+ 'AVATAR_GRAVATAR_EMAIL' => (($row['avatar_type'] == $this->get_name() || $row['avatar_type'] == 'gravatar') && $row['avatar']) ? $row['avatar'] : '',

+ ));

+

+ return true;

+ }

+

+ /**

+ * @inheritdoc

+ */

+ public function process_form($request, $template, $user, $row, &$error)

+ {

+ $row['avatar'] = $request->variable('avatar_gravatar_email', '');

+ $row['avatar_width'] = $request->variable('avatar_gravatar_width', 0);

+ $row['avatar_height'] = $request->variable('avatar_gravatar_height', 0);

+

+ if (!function_exists('validate_data'))

+ {

+ require($this->phpbb_root_path . 'includes/functions_user' . $this->php_ext);

+ }

+

+ $validate_array = validate_data(

+ array(

+ 'email' => $row['avatar'],

+ ),

+ array(

+ 'email' => array(

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

+ array('email'))

+ )

+ );

+

+ $error = array_merge($error, $validate_array);

+

+ if (!empty($error))

+ {

+ return false;

+ }

+

+ // Make sure getimagesize works...

+ if (function_exists('getimagesize') && ($row['avatar_width'] <= 0 || $row['avatar_height'] <= 0))

+ {

+ /**

+ * default to the minimum of the maximum allowed avatar size if the size

+ * is not or only partially entered

+ */

+ $row['avatar_width'] = $row['avatar_height'] = min($this->config['avatar_max_width'], $this->config['avatar_max_height']);

+ $url = $this->get_gravatar_url($row);

+

+ if (($row['avatar_width'] <= 0 || $row['avatar_height'] <= 0) && (($image_data = getimagesize($url)) === false))

+ {

+ $error[] = 'UNABLE_GET_IMAGE_SIZE';

+ return false;

+ }

+

+ if (!empty($image_data) && ($image_data[0] <= 0 || $image_data[1] <= 0))

+ {

+ $error[] = 'AVATAR_NO_SIZE';

+ return false;

+ }

+

+ $row['avatar_width'] = ($row['avatar_width'] && $row['avatar_height']) ? $row['avatar_width'] : $image_data[0];

+ $row['avatar_height'] = ($row['avatar_width'] && $row['avatar_height']) ? $row['avatar_height'] : $image_data[1];

+ }

+

+ if ($row['avatar_width'] <= 0 || $row['avatar_height'] <= 0)

+ {

+ $error[] = 'AVATAR_NO_SIZE';

+ return false;

+ }

+

+ if ($this->config['avatar_max_width'] || $this->config['avatar_max_height'])

+ {

+ if ($row['avatar_width'] > $this->config['avatar_max_width'] || $row['avatar_height'] > $this->config['avatar_max_height'])

+ {

+ $error[] = array('AVATAR_WRONG_SIZE', $this->config['avatar_min_width'], $this->config['avatar_min_height'], $this->config['avatar_max_width'], $this->config['avatar_max_height'], $row['avatar_width'], $row['avatar_height']);

+ return false;

+ }

+ }

+

+ if ($this->config['avatar_min_width'] || $this->config['avatar_min_height'])

+ {

+ if ($row['avatar_width'] < $this->config['avatar_min_width'] || $row['avatar_height'] < $this->config['avatar_min_height'])

+ {

+ $error[] = array('AVATAR_WRONG_SIZE', $this->config['avatar_min_width'], $this->config['avatar_min_height'], $this->config['avatar_max_width'], $this->config['avatar_max_height'], $row['avatar_width'], $row['avatar_height']);

+ return false;

+ }

+ }

+

+ return array(

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

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

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

+ );

+ }

+

+ /**

+ * Build gravatar URL for output on page

+ *

+ * @return string Gravatar URL

+ */

+ protected function get_gravatar_url($row)

+ {

+ $url = self::GRAVATAR_URL;

+ $url .= md5(strtolower(trim($row['avatar'])));

+

+ if ($row['avatar_width'] || $row['avatar_height'])

+ {

+ $url .= '?s=' . max($row['avatar_width'], $row['avatar_height']);

+ }

+

+ return $url;

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2011 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Interface for avatar drivers

+* @package phpBB3

+*/

+interface phpbb_avatar_driver_interface

+{

+ /**

+ * Returns the name of the driver.

+ *

+ * @return string Name of driver.

+ */

+ public function get_name();

+

+ /**

+ * Get the avatar url and dimensions

+ *

+ * @param array $row User data or group data that has been cleaned with

+ * phpbb_avatar_manager::clean_row

+ * @return array Avatar data, must have keys src, width and height, e.g.

+ * ['src' => '', 'width' => 0, 'height' => 0]

+ */

+ public function get_data($row);

+

+ /**

+ * Returns custom html if it is needed for displaying this avatar

+ *

+ * @param phpbb_user $user phpBB user object

+ * @param array $row User data or group data that has been cleaned with

+ * phpbb_avatar_manager::clean_row

+ * @param string $alt Alternate text for avatar image

+ *

+ * @return string HTML

+ */

+ public function get_custom_html($user, $row, $alt = '');

+

+ /**

+ * Prepare form for changing the settings of this avatar

+ *

+ * @param phpbb_request $request Request object

+ * @param phpbb_template $template Template object

+ * @param phpbb_user $user User object

+ * @param array $row User data or group data that has been cleaned with

+ * phpbb_avatar_manager::clean_row

+ * @param array &$error Reference to an error array that is filled by this

+ * function. Key values can either be a string with a language key or

+ * an array that will be passed to vsprintf() with the language key in

+ * the first array key.

+ *

+ * @return bool True if form has been successfully prepared

+ */

+ public function prepare_form($request, $template, $user, $row, &$error);

+

+ /**

+ * Prepare form for changing the acp settings of this avatar

+ *

+ * @param phpbb_user $user phpBB user object

+ *

+ * @return array Array of configuration options as consumed by acp_board.

+ * The setting for enabling/disabling the avatar will be handled by

+ * the avatar manager.

+ */

+ public function prepare_form_acp($user);

+

+ /**

+ * Process form data

+ *

+ * @param phpbb_request $request Request object

+ * @param phpbb_template $template Template object

+ * @param phpbb_user $user User object

+ * @param array $row User data or group data that has been cleaned with

+ * phpbb_avatar_manager::clean_row

+ * @param array &$error Reference to an error array that is filled by this

+ * function. Key values can either be a string with a language key or

+ * an array that will be passed to vsprintf() with the language key in

+ * the first array key.

+ *

+ * @return array Array containing the avatar data as follows:

+ * ['avatar'], ['avatar_width'], ['avatar_height']

+ */

+ public function process_form($request, $template, $user, $row, &$error);

+

+ /**

+ * Delete avatar

+ *

+ * @param array $row User data or group data that has been cleaned with

+ * phpbb_avatar_manager::clean_row

+ *

+ * @return bool True if avatar has been deleted or there is no need to delete,

+ * i.e. when the avatar is not hosted locally.

+ */

+ public function delete($row);

+

+ /**

+ * Get the avatar driver's template name

+ *

+ * @return string Avatar driver's template name

+ */

+ public function get_template_name();

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2011 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Handles avatars selected from the board gallery

+* @package phpBB3

+*/

+class phpbb_avatar_driver_local extends phpbb_avatar_driver

+{

+ /**

+ * @inheritdoc

+ */

+ public function get_data($row)

+ {

+ return array(

+ 'src' => $this->phpbb_root_path . $this->config['avatar_gallery_path'] . '/' . $row['avatar'],

+ 'width' => $row['avatar_width'],

+ 'height' => $row['avatar_height'],

+ );

+ }

+

+ /**

+ * @inheritdoc

+ */

+ public function prepare_form($request, $template, $user, $row, &$error)

+ {

+ $avatar_list = $this->get_avatar_list($user);

+ $category = $request->variable('avatar_local_cat', '');

+

+ foreach ($avatar_list as $cat => $null)

+ {

+ if (!empty($avatar_list[$cat]))

+ {

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

+ 'NAME' => $cat,

+ 'SELECTED' => ($cat == $category),

+ ));

+ }

+

+ if ($cat != $category)

+ {

+ unset($avatar_list[$cat]);

+ }

+ }

+

+ if (!empty($avatar_list[$category]))

+ {

+ $template->assign_vars(array(

+ 'AVATAR_LOCAL_SHOW' => true,

+ ));

+

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

+ $row_count = $col_count = $avatar_pos = 0;

+ $avatar_count = sizeof($avatar_list[$category]);

+

+ reset($avatar_list[$category]);

+

+ while ($avatar_pos < $avatar_count)

+ {

+ $img = current($avatar_list[$category]);

+ next($avatar_list[$category]);

+

+ if ($col_count == 0)

+ {

+ ++$row_count;

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

+ ));

+ }

+

+ $template->assign_block_vars('avatar_local_row.avatar_local_col', array(

+ 'AVATAR_IMAGE' => $this->phpbb_root_path . $this->config['avatar_gallery_path'] . '/' . $img['file'],

+ 'AVATAR_NAME' => $img['name'],

+ 'AVATAR_FILE' => $img['filename'],

+ ));

+

+ $template->assign_block_vars('avatar_local_row.avatar_local_option', array(

+ 'AVATAR_FILE' => $img['filename'],

+ 'S_OPTIONS_AVATAR' => $img['filename']

+ ));

+

+ $col_count = ($col_count + 1) % $table_cols;

+

+ ++$avatar_pos;

+ }

+ }

+

+ return true;

+ }

+

+ /**

+ * @inheritdoc

+ */

+ public function prepare_form_acp($user)

+ {

+ return array(

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

+ );

+ }

+

+ /**

+ * @inheritdoc

+ */

+ public function process_form($request, $template, $user, $row, &$error)

+ {

+ $avatar_list = $this->get_avatar_list($user);

+ $category = $request->variable('avatar_local_cat', '');

+

+ $file = $request->variable('avatar_local_file', '');

+

+ if (empty($category) || empty($file))

+ {

+ $error[] = 'NO_AVATAR_SELECTED';

+ return false;

+ }

+

+ if (!isset($avatar_list[$category][urldecode($file)]))

+ {

+ $error[] = 'AVATAR_URL_NOT_FOUND';

+ return false;

+ }

+

+ return array(

+ 'avatar' => ($category != $user->lang['MAIN']) ? $category . '/' . $file : $file,

+ 'avatar_width' => $avatar_list[$category][urldecode($file)]['width'],

+ 'avatar_height' => $avatar_list[$category][urldecode($file)]['height'],

+ );

+ }

+

+ /**

+ * Get a list of avatars that are locally available

+ * Results get cached for 24 hours (86400 seconds)

+ *

+ * @param phpbb_user $user User object

+ *

+ * @return array Array containing the locally available avatars

+ */

+ protected function get_avatar_list($user)

+ {

+ $avatar_list = ($this->cache == null) ? false : $this->cache->get('avatar_local_list');

+

+ if ($avatar_list === false)

+ {

+ $avatar_list = array();

+ $path = $this->phpbb_root_path . $this->config['avatar_gallery_path'];

+

+ $iterator = new RecursiveIteratorIterator(new RecursiveDirectoryIterator($path, FilesystemIterator::SKIP_DOTS | FilesystemIterator::UNIX_PATHS), RecursiveIteratorIterator::SELF_FIRST);

+ foreach ($iterator as $file_info)

+ {

+ $file_path = $file_info->getPath();

+ $image = $file_info->getFilename();

+

+ // Match all images in the gallery folder

+ if (preg_match('#^[^&\'"<>]+\.(?:' . implode('|', $this->allowed_extensions) . ')$#i', $image) && is_file($file_path . '/' . $image))

+ {

+ if (function_exists('getimagesize'))

+ {

+ $dims = getimagesize($file_path . '/' . $image);

+ }

+ else

+ {

+ $dims = array(0, 0);

+ }

+ $cat = ($path == $file_path) ? $user->lang['MAIN'] : str_replace("$path/", '', $file_path);

+ $avatar_list[$cat][$image] = array(

+ 'file' => ($cat != $user->lang['MAIN']) ? rawurlencode($cat) . '/' . rawurlencode($image) : rawurlencode($image),

+ 'filename' => rawurlencode($image),

+ 'name' => ucfirst(str_replace('_', ' ', preg_replace('#^(.*)\..*$#', '\1', $image))),

+ 'width' => $dims[0],

+ 'height' => $dims[1],

+ );

+ }

+ }

+ ksort($avatar_list);

+

+ if ($this->cache != null)

+ {

+ $this->cache->put('avatar_local_list', $avatar_list, 86400);

+ }

+ }

+

+ return $avatar_list;

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2011 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Handles avatars hosted remotely

+* @package phpBB3

+*/

+class phpbb_avatar_driver_remote extends phpbb_avatar_driver

+{

+ /**

+ * @inheritdoc

+ */

+ public function get_data($row)

+ {

+ return array(

+ 'src' => $row['avatar'],

+ 'width' => $row['avatar_width'],

+ 'height' => $row['avatar_height'],

+ );

+ }

+

+ /**

+ * @inheritdoc

+ */

+ public function prepare_form($request, $template, $user, $row, &$error)

+ {

+ $template->assign_vars(array(

+ 'AVATAR_REMOTE_WIDTH' => ((in_array($row['avatar_type'], array(AVATAR_REMOTE, $this->get_name(), 'remote'))) && $row['avatar_width']) ? $row['avatar_width'] : $request->variable('avatar_remote_width', 0),

+ 'AVATAR_REMOTE_HEIGHT' => ((in_array($row['avatar_type'], array(AVATAR_REMOTE, $this->get_name(), 'remote'))) && $row['avatar_height']) ? $row['avatar_height'] : $request->variable('avatar_remote_width', 0),

+ 'AVATAR_REMOTE_URL' => ((in_array($row['avatar_type'], array(AVATAR_REMOTE, $this->get_name(), 'remote'))) && $row['avatar']) ? $row['avatar'] : '',

+ ));

+

+ return true;

+ }

+

+ /**

+ * @inheritdoc

+ */

+ public function process_form($request, $template, $user, $row, &$error)

+ {

+ $url = $request->variable('avatar_remote_url', '');

+ $width = $request->variable('avatar_remote_width', 0);

+ $height = $request->variable('avatar_remote_height', 0);

+

+ if (!preg_match('#^(http|https|ftp)://#i', $url))

+ {

+ $url = 'http://' . $url;

+ }

+

+ if (!function_exists('validate_data'))

+ {

+ require($this->phpbb_root_path . 'includes/functions_user' . $this->php_ext);

+ }

+

+ $validate_array = validate_data(

+ array(

+ 'url' => $url,

+ ),

+ array(

+ 'url' => array('string', true, 5, 255),

+ )

+ );

+

+ $error = array_merge($error, $validate_array);

+

+ if (!empty($error))

+ {

+ return false;

+ }

+

+ // Check if this url looks alright

+ // This isn't perfect, but it's what phpBB 3.0 did, and might as well make sure everything is compatible

+ if (!preg_match('#^(http|https|ftp)://(?:(.*?\.)*?[a-z0-9\-]+?\.[a-z]{2,4}|(?:\d{1,3}\.){3,5}\d{1,3}):?([0-9]*?).*?\.('. implode('|', $this->allowed_extensions) . ')$#i', $url))

+ {

+ $error[] = 'AVATAR_URL_INVALID';

+ return false;

+ }

+

+ // Make sure getimagesize works...

+ if (function_exists('getimagesize'))

+ {

+ if (($width <= 0 || $height <= 0) && (($image_data = getimagesize($url)) === false))

+ {

+ $error[] = 'UNABLE_GET_IMAGE_SIZE';

+ return false;

+ }

+

+ if (!empty($image_data) && ($image_data[0] <= 0 || $image_data[1] <= 0))

+ {

+ $error[] = 'AVATAR_NO_SIZE';

+ return false;

+ }

+

+ $width = ($width && $height) ? $width : $image_data[0];

+ $height = ($width && $height) ? $height : $image_data[1];

+ }

+

+ if ($width <= 0 || $height <= 0)

+ {

+ $error[] = 'AVATAR_NO_SIZE';

+ return false;

+ }

+

+ if (!class_exists('fileupload'))

+ {

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

+ }

+

+ $types = fileupload::image_types();

+ $extension = strtolower(filespec::get_extension($url));

+

+ if (!empty($image_data) && (!isset($types[$image_data[2]]) || !in_array($extension, $types[$image_data[2]])))

+ {

+ if (!isset($types[$image_data[2]]))

+ {

+ $error[] = 'UNABLE_GET_IMAGE_SIZE';

+ }

+ else

+ {

+ $error[] = array('IMAGE_FILETYPE_MISMATCH', $types[$image_data[2]][0], $extension);

+ }

+

+ return false;

+ }

+

+ if ($this->config['avatar_max_width'] || $this->config['avatar_max_height'])

+ {

+ if ($width > $this->config['avatar_max_width'] || $height > $this->config['avatar_max_height'])

+ {

+ $error[] = array('AVATAR_WRONG_SIZE', $this->config['avatar_min_width'], $this->config['avatar_min_height'], $this->config['avatar_max_width'], $this->config['avatar_max_height'], $width, $height);

+ return false;

+ }

+ }

+

+ if ($this->config['avatar_min_width'] || $this->config['avatar_min_height'])

+ {

+ if ($width < $this->config['avatar_min_width'] || $height < $this->config['avatar_min_height'])

+ {

+ $error[] = array('AVATAR_WRONG_SIZE', $this->config['avatar_min_width'], $this->config['avatar_min_height'], $this->config['avatar_max_width'], $this->config['avatar_max_height'], $width, $height);

+ return false;

+ }

+ }

+

+ return array(

+ 'avatar' => $url,

+ 'avatar_width' => $width,

+ 'avatar_height' => $height,

+ );

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2011 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Handles avatars uploaded to the board

+* @package phpBB3

+*/

+class phpbb_avatar_driver_upload extends phpbb_avatar_driver

+{

+ /**

+ * @inheritdoc

+ */

+ public function get_data($row, $ignore_config = false)

+ {

+ return array(

+ 'src' => $this->phpbb_root_path . 'download/file' . $this->php_ext . '?avatar=' . $row['avatar'],

+ 'width' => $row['avatar_width'],

+ 'height' => $row['avatar_height'],

+ );

+ }

+

+ /**

+ * @inheritdoc

+ */

+ public function prepare_form($request, $template, $user, $row, &$error)

+ {

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

+ {

+ return false;

+ }

+

+ $template->assign_vars(array(

+ 'S_UPLOAD_AVATAR_URL' => ($this->config['allow_avatar_remote_upload']) ? true : false,

+ 'AVATAR_UPLOAD_SIZE' => $this->config['avatar_filesize'],

+ ));

+

+ return true;

+ }

+

+ /**

+ * @inheritdoc

+ */

+ public function process_form($request, $template, $user, $row, &$error)

+ {

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

+ {

+ return false;

+ }

+

+ if (!class_exists('fileupload'))

+ {

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

+ }

+

+ $upload = new fileupload('AVATAR_', $this->allowed_extensions, $this->config['avatar_filesize'], $this->config['avatar_min_width'], $this->config['avatar_min_height'], $this->config['avatar_max_width'], $this->config['avatar_max_height'], (isset($this->config['mime_triggers']) ? explode('|', $this->config['mime_triggers']) : false));

+

+ $url = $request->variable('avatar_upload_url', '');

+ $upload_file = $request->file('avatar_upload_file');

+

+ if (!empty($upload_file['name']))

+ {

+ $file = $upload->form_upload('avatar_upload_file');

+ }

+ elseif (!empty($this->config['allow_avatar_remote_upload']) && !empty($url))

+ {

+ $file = $upload->remote_upload($url);

+ }

+ else

+ {

+ $error[] = 'NO_AVATAR_SELECTED';

+ return false;

+ }

+

+ $prefix = $this->config['avatar_salt'] . '_';

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

+

+ $destination = $this->config['avatar_path'];

+

+ // Adjust destination path (no trailing slash)

+ if (substr($destination, -1, 1) == '/' || substr($destination, -1, 1) == '\\')

+ {

+ $destination = substr($destination, 0, -1);

+ }

+

+ $destination = str_replace(array('../', '..\\', './', '.\\'), '', $destination);

+ if ($destination && ($destination[0] == '/' || $destination[0] == "\\"))

+ {

+ $destination = '';

+ }

+

+ // Move file and overwrite any existing image

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

+

+ if (sizeof($file->error))

+ {

+ $file->remove();

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

+ return false;

+ }

+

+ return array(

+ 'avatar' => $row['id'] . '_' . time() . '.' . $file->get('extension'),

+ 'avatar_width' => $file->get('width'),

+ 'avatar_height' => $file->get('height'),

+ );

+ }

+

+ /**

+ * @inheritdoc

+ */

+ public function prepare_form_acp($user)

+ {

+ return array(

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

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

+ 'avatar_path' => array('lang' => 'AVATAR_STORAGE_PATH', 'validate' => 'rwpath', 'type' => 'text:20:255', 'explain' => true),

+ );

+ }

+

+ /**

+ * @inheritdoc

+ */

+ public function delete($row)

+ {

+ $ext = substr(strrchr($row['avatar'], '.'), 1);

+ $filename = $this->phpbb_root_path . $this->config['avatar_path'] . '/' . $this->config['avatar_salt'] . '_' . $row['id'] . '.' . $ext;

+

+ if (file_exists($filename))

+ {

+ @unlink($filename);

+ }

+

+ return true;

+ }

+

+ /**

+ * Check if user is able to upload an avatar

+ *

+ * @return bool True if user can upload, false if not

+ */

+ protected function can_upload()

+ {

+ return (file_exists($this->phpbb_root_path . $this->config['avatar_path']) && phpbb_is_writable($this->phpbb_root_path . $this->config['avatar_path']) && (@ini_get('file_uploads') || strtolower(@ini_get('file_uploads')) == 'on'));

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2011 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* @package avatar

+*/

+class phpbb_avatar_manager

+{

+ /**

+ * phpBB configuration

+ * @var phpbb_config

+ */

+ protected $config;

+

+ /**

+ * Array that contains a list of enabled drivers

+ * @var array

+ */

+ static protected $enabled_drivers = false;

+

+ /**

+ * Array that contains all available avatar drivers which are passed via the

+ * service container

+ * @var array

+ */

+ protected $avatar_drivers;

+

+ /**

+ * Service container object

+ * @var object

+ */

+ protected $container;

+

+ /**

+ * Construct an avatar manager object

+ *

+ * @param phpbb_config $config phpBB configuration

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

+ * @param object $container Container object

+ */

+ public function __construct(phpbb_config $config, $avatar_drivers, $container)

+ {

+ $this->config = $config;

+ $this->avatar_drivers = $avatar_drivers;

+ $this->container = $container;

+ }

+

+ /**

+ * Get the driver object specified by the avatar type

+ *

+ * @param string $avatar_type Avatar type; by default an avatar's service container name

+ * @param bool $load_enabled Load only enabled avatars

+ *

+ * @return object Avatar driver object

+ */

+ public function get_driver($avatar_type, $load_enabled = true)

+ {

+ if (self::$enabled_drivers === false)

+ {

+ $this->load_enabled_drivers();

+ }

+

+ $avatar_drivers = ($load_enabled) ? self::$enabled_drivers : $this->get_all_drivers();

+

+ // Legacy stuff...

+ switch ($avatar_type)

+ {

+ case AVATAR_GALLERY:

+ $avatar_type = 'avatar.driver.local';

+ break;

+ case AVATAR_UPLOAD:

+ $avatar_type = 'avatar.driver.upload';

+ break;

+ case AVATAR_REMOTE:

+ $avatar_type = 'avatar.driver.remote';

+ break;

+ }

+

+ if (!isset($avatar_drivers[$avatar_type]))

+ {

+ return null;

+ }

+

+ /*

+ * There is no need to handle invalid avatar types as the following code

+ * will cause a ServiceNotFoundException if the type does not exist

+ */

+ $driver = $this->container->get($avatar_type);

+

+ return $driver;

+ }

+

+ /**

+ * Load the list of enabled drivers

+ * This is executed once and fills self::$enabled_drivers

+ */

+ protected function load_enabled_drivers()

+ {

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

+ {

+ self::$enabled_drivers = array();

+ foreach ($this->avatar_drivers as $driver)

+ {

+ if ($this->is_enabled($driver))

+ {

+ self::$enabled_drivers[$driver->get_name()] = $driver->get_name();

+ }

+ }

+ asort(self::$enabled_drivers);

+ }

+ }

+

+ /**

+ * Get a list of all avatar drivers

+ *

+ * As this function will only be called in the ACP avatar settings page, it

+ * doesn't make much sense to cache the list of all avatar drivers like the

+ * list of the enabled drivers.

+ *

+ * @return array Array containing a list of all avatar drivers

+ */

+ public function get_all_drivers()

+ {

+ $drivers = array();

+

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

+ {

+ foreach ($this->avatar_drivers as $driver)

+ {

+ $drivers[$driver->get_name()] = $driver->get_name();

+ }

+ asort($drivers);

+ }

+

+ return $drivers;

+ }

+

+ /**

+ * Get a list of enabled avatar drivers

+ *

+ * @return array Array containing a list of the enabled avatar drivers

+ */

+ public function get_enabled_drivers()

+ {

+ if (self::$enabled_drivers === false)

+ {

+ $this->load_enabled_drivers();

+ }

+

+ return self::$enabled_drivers;

+ }

+

+ /**

+ * Strip out user_ and group_ prefixes from keys

+ *

+ * @param array $row User data or group data

+ *

+ * @return array User data or group data with keys that have been

+ * stripped from the preceding "user_" or "group_"

+ */

+ static public function clean_row($row)

+ {

+ $keys = array_keys($row);

+ $values = array_values($row);

+

+ $keys = array_map(array('phpbb_avatar_manager', 'strip_prefix'), $keys);

+

+ return array_combine($keys, $values);

+ }

+

+ /**

+ * Strip prepending user_ or group_ prefix from key

+ *

+ * @param string Array key

+ * @return string Key that has been stripped from its prefix

+ */

+ static protected function strip_prefix($key)

+ {

+ return preg_replace('#^(?:user_|group_)#', '', $key);

+ }

+

+ /**

+ * Clean driver names that are returned from template files

+ * Underscores are replaced with dots

+ *

+ * @param string $name Driver name

+ *

+ * @return string Cleaned driver name

+ */

+ static public function clean_driver_name($name)

+ {

+ return str_replace('_', '.', $name);

+ }

+

+ /**

+ * Prepare driver names for use in template files

+ * Dots are replaced with underscores

+ *

+ * @param string $name Clean driver name

+ *

+ * @return string Prepared driver name

+ */

+ static public function prepare_driver_name($name)

+ {

+ return str_replace('.', '_', $name);

+ }

+

+ /**

+ * Check if avatar is enabled

+ *

+ * @param object $driver Avatar driver object

+ *

+ * @return bool True if avatar is enabled, false if it's disabled

+ */

+ public function is_enabled($driver)

+ {

+ $config_name = $this->get_driver_config_name($driver);

+

+ return $this->config["allow_avatar_{$config_name}"];

+ }

+

+ /**

+ * Get the settings array for enabling/disabling an avatar driver

+ *

+ * @param object $driver Avatar driver object

+ *

+ * @return array Array of configuration options as consumed by acp_board

+ */

+ public function get_avatar_settings($driver)

+ {

+ $config_name = $this->get_driver_config_name($driver);

+

+ return array(

+ 'allow_avatar_' . $config_name => array('lang' => 'ALLOW_' . strtoupper($config_name), 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => false),

+ );

+ }

+

+ /**

+ * Get the config name of an avatar driver

+ *

+ * @param object $driver Avatar driver object

+ *

+ * @return string Avatar driver config name

+ */

+ public function get_driver_config_name($driver)

+ {

+ return preg_replace('#^phpbb_avatar_driver_#', '', get_class($driver));

+ }

+

+ /**

+ * Replace "error" strings with their real, localized form

+ *

+ * @param phpbb_user phpBB User object

+ * @param array $error Array containing error strings

+ * Key values can either be a string with a language key or an array

+ * that will be passed to vsprintf() with the language key in the

+ * first array key.

+ *

+ * @return array Array containing the localized error strings

+ */

+ public function localize_errors(phpbb_user $user, $error)

+ {

+ foreach ($error as $key => $lang)

+ {

+ if (is_array($lang))

+ {

+ $lang_key = array_shift($lang);

+ $error[$key] = vsprintf($user->lang($lang_key), $lang);

+ }

+ else

+ {

+ $error[$key] = $user->lang("$lang");

+ }

+ }

+

+ return $error;

+ }

+}

+ * {@inheritDoc}

+ function sql_save(phpbb_db_driver $db, $query, $query_result, $ttl)

+ * @param phpbb_db_driver $db Database connection

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

+ * {@inheritDoc}

+ function sql_save(phpbb_db_driver $db, $query, $query_result, $ttl)

+ * {@inheritDoc}

+ function sql_save(phpbb_db_driver $db, $query, $query_result, $ttl)

+ /**

+ * Cache driver.

+ *

+ * @var phpbb_cache_driver_interface

+ */

+ protected $driver;

+

+ /**

+ * The config.

+ *

+ * @var phpbb_config

+ */

+ protected $config;

+

+ /**

+ * Database connection.

+ *

+ * @var phpbb_db_driver

+ */

+ protected $db;

+

+ /**

+ * Root path.

+ *

+ * @var string

+ */

+ protected $phpbb_root_path;

+

+ /**

+ * PHP extension.

+ *

+ * @var string

+ */

+ protected $php_ext;

+ * @param phpbb_config $config The config

+ * @param phpbb_db_driver $db Database connection

+ * @param string $phpbb_root_path Root path

+ * @param string $php_ext PHP extension

+ public function __construct(phpbb_cache_driver_interface $driver, phpbb_config $config, phpbb_db_driver $db, $phpbb_root_path, $php_ext)

+ $this->config = $config;

+ $this->db = $db;

+ $this->phpbb_root_path = $phpbb_root_path;

+ $this->php_ext = $php_ext;

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

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

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

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

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

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

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

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

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

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

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

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

+ switch ($this->db->sql_layer)

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

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

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

+ $filename = $this->phpbb_root_path . 'styles/' . $style['style_path'] . '/style.cfg';

+ if (!isset($parsed_array['filetime']) || (($this->config['load_tplcompile'] && @filemtime($filename) > $parsed_array['filetime'])))

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

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

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

+ for ($i = (int) floor($width / 2); $i < $end; $i++)

+define('MIGRATIONS_TABLE', $table_prefix . 'migrations');

+define('NOTIFICATION_TYPES_TABLE', $table_prefix . 'notification_types');

+define('NOTIFICATIONS_TABLE', $table_prefix . 'notifications');

+define('TEAMPAGE_TABLE', $table_prefix . 'teampage');

+define('USER_NOTIFICATIONS_TABLE', $table_prefix . 'user_notifications');

+ 'lang' => array_filter($user->lang['datetime'], 'is_string'),

+ function phpbb_db_tools(phpbb_db_driver $db, $return_statements = false)

+ * Setter for {@link $return_statements return_statements}.

+ *

+ * @param bool $return_statements True if SQL should not be executed but returned as strings

+ * @return null

+ */

+ public function set_return_statements($return_statements)

+ {

+ $this->return_statements = $return_statements;

+ }

+

+ /**

+ * drop_tables: Drop tables

+ * add_tables: Add tables

+ // remove default cosntraints first

+ // http://msdn.microsoft.com/en-us/library/aa175912%28v=sql.80%29.aspx

+ $statements[] = "DECLARE @drop_default_name VARCHAR(100), @cmd VARCHAR(1000)

+ SET @drop_default_name =

+ (SELECT so.name FROM sysobjects so

+ JOIN sysconstraints sc ON so.id = sc.constid

+ WHERE object_name(so.parent_obj) = '{$table_name}'

+ AND so.xtype = 'D'

+ AND sc.colid = (SELECT colid FROM syscolumns

+ WHERE id = object_id('{$table_name}')

+ AND name = '{$column_name}'))

+ IF @drop_default_name <> ''

+ BEGIN

+ SET @cmd = 'ALTER TABLE [{$table_name}] DROP CONSTRAINT [' + @drop_default_name + ']'

+ EXEC(@cmd)

+ END";

+ if ($cache && $cache->sql_exists($query_id))

+ if ($cache && !is_object($query_id) && $cache->sql_exists($query_id))

+ global $cache, $starttime, $phpbb_root_path, $phpbb_admin_path, $user;

+ <link href="' . htmlspecialchars($phpbb_admin_path) . 'style/admin.css" rel="stylesheet" type="text/css" media="screen" />

+ $this->query_result = ($cache && $cache_ttl) ? $cache->sql_load($query) : false;

+ if ($cache && $cache_ttl)

+ $this->query_result = $cache->sql_save($this, $query, $this->query_result, $cache_ttl);

+ if ($cache && $cache->sql_exists($query_id))

+ if ($cache && $cache->sql_exists($query_id))

+ $this->query_result = ($cache && $cache_ttl) ? $cache->sql_load($query) : false;

+ if ($cache && $cache_ttl)

+ $this->query_result = $cache->sql_save($this, $query, $this->query_result, $cache_ttl);

+ if ($cache && $cache->sql_exists($query_id))

+ if ($cache && $cache->sql_exists($query_id))

+ if ($cache && $cache->sql_exists($query_id))

+ $this->query_result = ($cache && $cache_ttl) ? $cache->sql_load($query) : false;

+ if ($cache && $cache_ttl)

+ $this->query_result = $cache->sql_save($this, $query, $this->query_result, $cache_ttl);

+ if ($cache && $cache->sql_exists($query_id))

+ if ($cache && $cache->sql_exists($query_id))

+ $this->query_result = ($cache && $cache_ttl) ? $cache->sql_load($query) : false;

+ $this->query_result = $cache->sql_save($this, $query, $this->query_result, $cache_ttl);

+ $this->query_result = ($cache && $cache_ttl) ? $cache->sql_load($query) : false;

+ if ($cache && $cache_ttl)

+ $this->query_result = $cache->sql_save($this, $query, $this->query_result, $cache_ttl);

+ if ($cache && $cache->sql_exists($query_id))

+ if ($cache && $cache->sql_exists($query_id))

+ if ($cache && $cache->sql_exists($query_id))

+ $this->query_result = ($cache && $cache_ttl) ? $cache->sql_load($query) : false;

+ if ($cache && $cache_ttl)

+ $this->query_result = $cache->sql_save($this, $query, $this->query_result, $cache_ttl);

+ if ($cache && !is_object($query_id) && $cache->sql_exists($query_id))

+ if ($cache && !is_object($query_id) && $cache->sql_exists($query_id))

+ if ($cache && !is_object($query_id) && $cache->sql_exists($query_id))

+ $this->query_result = ($cache && $cache_ttl) ? $cache->sql_load($query) : false;

+ if ($cache && $cache_ttl)

+ $this->query_result = $cache->sql_save($this, $query, $this->query_result, $cache_ttl);

+ if ($cache && $cache->sql_exists($query_id))

+ if ($cache && $cache->sql_exists($query_id))

+ if ($cache && $cache->sql_exists($query_id))

+ $this->query_result = ($cache && $cache_ttl) ? $cache->sql_load($query) : false;

+ if ($cache && $cache_ttl)

+ $this->query_result = $cache->sql_save($this, $query, $this->query_result, $cache_ttl);

+ if ($cache && $cache->sql_exists($query_id))

+ if ($cache && $cache->sql_exists($query_id))

+ if ($cache && $cache->sql_exists($query_id))

+ $this->query_result = ($cache && $cache_ttl) ? $cache->sql_load($query) : false;

+ if ($cache && $cache_ttl)

+ $this->query_result = $cache->sql_save($this, $query, $this->query_result, $cache_ttl);

+ if ($cache && $cache->sql_exists($query_id))

+ if ($cache && $cache->sql_exists($query_id))

+ if ($cache && $cache->sql_exists($query_id))

+<?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_30x_3_0_1 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return version_compare($this->config['version'], '3.0.1', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_1_rc1');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.0.1')),

+ );

+ }

+}

+<?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_30x_3_0_10 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return version_compare($this->config['version'], '3.0.10', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_10_rc3');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.0.10')),

+ );

+ }

+}

+<?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_30x_3_0_10_rc1 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return version_compare($this->config['version'], '3.0.10-rc1', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_9');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.add', array('email_max_chunk_size', 50)),

+

+ array('config.update', array('version', '3.0.10-rc1')),

+ );

+ }

+}

+<?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_30x_3_0_10_rc2 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return version_compare($this->config['version'], '3.0.10-rc2', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_10_rc1');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.0.10-rc2')),

+ );

+ }

+}

+<?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_30x_3_0_10_rc3 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return version_compare($this->config['version'], '3.0.10-rc3', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_10_rc2');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.0.10-rc3')),

+ );

+ }

+}

+<?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_30x_3_0_11 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return version_compare($this->config['version'], '3.0.11', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_11_rc2');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.0.11')),

+ );

+ }

+}

+<?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_30x_3_0_11_rc1 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return version_compare($this->config['version'], '3.0.11-rc1', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_10');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('custom', array(array(&$this, 'cleanup_deactivated_styles'))),

+ array('custom', array(array(&$this, 'delete_orphan_private_messages'))),

+

+ array('config.update', array('version', '3.0.11-rc1')),

+ );

+ }

+

+ public function cleanup_deactivated_styles()

+ {

+ // Updates users having current style a deactivated one

+ $sql = 'SELECT style_id

+ FROM ' . STYLES_TABLE . '

+ WHERE style_active = 0';

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

+

+ $deactivated_style_ids = array();

+ while ($style_id = $this->db->sql_fetchfield('style_id', false, $result))

+ {

+ $deactivated_style_ids[] = (int) $style_id;

+ }

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

+

+ if (!empty($deactivated_style_ids))

+ {

+ $sql = 'UPDATE ' . USERS_TABLE . '

+ SET user_style = ' . (int) $this->config['default_style'] .'

+ WHERE ' . $this->db->sql_in_set('user_style', $deactivated_style_ids);

+ $this->sql_query($sql);

+ }

+ }

+

+ public function delete_orphan_private_messages()

+ {

+ // Delete orphan private messages

+ $batch_size = 500;

+

+ $sql_array = array(

+ 'SELECT' => 'p.msg_id',

+ 'FROM' => array(

+ PRIVMSGS_TABLE => 'p',

+ ),

+ 'LEFT_JOIN' => array(

+ array(

+ 'FROM' => array(PRIVMSGS_TO_TABLE => 't'),

+ 'ON' => 'p.msg_id = t.msg_id',

+ ),

+ ),

+ 'WHERE' => 't.user_id IS NULL',

+ );

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

+

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

+

+ $delete_pms = array();

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

+ {

+ $delete_pms[] = (int) $row['msg_id'];

+ }

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

+

+ if (!empty($delete_pms))

+ {

+ $sql = 'DELETE FROM ' . PRIVMSGS_TABLE . '

+ WHERE ' . $this->db->sql_in_set('msg_id', $delete_pms);

+ $this->sql_query($sql);

+

+ // Return false to have the Migrator call this function again

+ return false;

+ }

+ }

+}

+<?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_30x_3_0_11_rc2 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return version_compare($this->config['version'], '3.0.11-rc2', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_11_rc1');

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'add_columns' => array(

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

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

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'drop_columns' => array(

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

+ 'field_show_novalue',

+ ),

+ ),

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.0.11-rc2')),

+ );

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+/** @todo DROP LOGIN_ATTEMPT_TABLE.attempt_id in 3.0.12-RC1 **/

+

+class phpbb_db_migration_data_30x_3_0_12_rc1 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return version_compare($this->config['version'], '3.0.12-rc1', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_11');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('custom', array(array(&$this, 'update_module_auth'))),

+ array('custom', array(array(&$this, 'update_bots'))),

+ array('custom', array(array(&$this, 'disable_bots_from_receiving_pms'))),

+

+ array('config.update', array('version', '3.0.12-rc1')),

+ );

+ }

+

+ public function disable_bots_from_receiving_pms()

+ {

+ // Disable receiving pms for bots

+ $sql = 'SELECT user_id

+ FROM ' . BOTS_TABLE;

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

+

+ $bot_user_ids = array();

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

+ {

+ $bot_user_ids[] = (int) $row['user_id'];

+ }

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

+

+ if (!empty($bot_user_ids))

+ {

+ $sql = 'UPDATE ' . USERS_TABLE . '

+ SET user_allow_pm = 0

+ WHERE ' . $this->db->sql_in_set('user_id', $bot_user_ids);

+ $this->sql_query($sql);

+ }

+ }

+

+ public function update_module_auth()

+ {

+ $sql = 'UPDATE ' . MODULES_TABLE . '

+ SET module_auth = \'acl_u_sig\'

+ WHERE module_class = \'ucp\'

+ AND module_basename = \'profile\'

+ AND module_mode = \'signature\'';

+ $this->sql_query($sql);

+ }

+

+ public function update_bots()

+ {

+ // Update bots

+ if (!function_exists('user_delete'))

+ {

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

+ }

+

+ $bots_updates = array(

+ // Bot Deletions

+ 'NG-Search [Bot]' => false,

+ 'Nutch/CVS [Bot]' => false,

+ 'OmniExplorer [Bot]' => false,

+ 'Seekport [Bot]' => false,

+ 'Synoo [Bot]' => false,

+ 'WiseNut [Bot]' => false,

+

+ // Bot Updates

+ // Bot name to bot user agent map

+ 'Baidu [Spider]' => 'Baiduspider',

+ 'Exabot [Bot]' => 'Exabot',

+ 'Voyager [Bot]' => 'voyager/',

+ 'W3C [Validator]' => 'W3C_Validator',

+ );

+

+ foreach ($bots_updates as $bot_name => $bot_agent)

+ {

+ $sql = 'SELECT user_id

+ FROM ' . USERS_TABLE . '

+ WHERE user_type = ' . USER_IGNORE . "

+ AND username_clean = '" . $this->db->sql_escape(utf8_clean_string($bot_name)) . "'";

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

+ $bot_user_id = (int) $this->db->sql_fetchfield('user_id');

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

+

+ if ($bot_user_id)

+ {

+ if ($bot_agent === false)

+ {

+ $sql = 'DELETE FROM ' . BOTS_TABLE . "

+ WHERE user_id = $bot_user_id";

+ $this->sql_query($sql);

+

+ user_delete('remove', $bot_user_id);

+ }

+ else

+ {

+ $sql = 'UPDATE ' . BOTS_TABLE . "

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

+ WHERE user_id = $bot_user_id";

+ $this->sql_query($sql);

+ }

+ }

+ }

+ }

+}

+<?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_30x_3_0_1_rc1 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return version_compare($this->config['version'], '3.0.1-rc1', '>=');

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'add_columns' => array(

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

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

+ ),

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

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

+ ),

+ ),

+ 'drop_keys' => array(

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

+ 'group_legend',

+ ),

+ ),

+ 'add_index' => array(

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

+ 'session_forum_id' => array('session_forum_id'),

+ ),

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

+ 'group_legend_name' => array('group_legend', 'group_name'),

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'drop_columns' => array(

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

+ 'display_subforum_list',

+ ),

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

+ 'session_forum_id',

+ ),

+ ),

+ 'add_index' => array(

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

+ 'group_legend' => array('group_legend'),

+ ),

+ ),

+ 'drop_keys' => array(

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

+ 'session_forum_id',

+ ),

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

+ 'group_legend_name',

+ ),

+ ),

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('custom', array(array(&$this, 'fix_unset_last_view_time'))),

+ array('custom', array(array(&$this, 'reset_smiley_size'))),

+

+ array('config.update', array('version', '3.0.1-rc1')),

+ );

+ }

+

+ public function fix_unset_last_view_time()

+ {

+ $sql = 'UPDATE ' . $this->table_prefix . "topics

+ SET topic_last_view_time = topic_last_post_time

+ WHERE topic_last_view_time = 0";

+ $this->sql_query($sql);

+ }

+

+ public function reset_smiley_size()

+ {

+ // Update smiley sizes

+ $smileys = array('icon_e_surprised.gif', 'icon_eek.gif', 'icon_cool.gif', 'icon_lol.gif', 'icon_mad.gif', 'icon_razz.gif', 'icon_redface.gif', 'icon_cry.gif', 'icon_evil.gif', 'icon_twisted.gif', 'icon_rolleyes.gif', 'icon_exclaim.gif', 'icon_question.gif', 'icon_idea.gif', 'icon_arrow.gif', 'icon_neutral.gif', 'icon_mrgreen.gif', 'icon_e_ugeek.gif');

+

+ foreach ($smileys as $smiley)

+ {

+ if (file_exists($this->phpbb_root_path . 'images/smilies/' . $smiley))

+ {

+ list($width, $height) = getimagesize($this->phpbb_root_path . 'images/smilies/' . $smiley);

+

+ $sql = 'UPDATE ' . SMILIES_TABLE . '

+ SET smiley_width = ' . $width . ', smiley_height = ' . $height . "

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

+

+ $this->sql_query($sql);

+ }

+ }

+ }

+}

+<?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_30x_3_0_2 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return version_compare($this->config['version'], '3.0.2', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_2_rc2');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.0.2')),

+ );

+ }

+}

+<?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_30x_3_0_2_rc1 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return version_compare($this->config['version'], '3.0.2-rc1', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_1');

+ }

+

+ public function update_data()

+ {

+ return array(

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

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

+ array('config.add', array('mime_triggers', 'body|head|html|img|plaintext|a href|pre|script|table|title')),

+

+ array('config.update', array('version', '3.0.2-rc1')),

+ );

+ }

+}

+<?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_30x_3_0_2_rc2 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return version_compare($this->config['version'], '3.0.2-rc2', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_2_rc1');

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'change_columns' => array(

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

+ 'draft_subject' => array('STEXT_UNI', ''),

+ ),

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

+ 'forum_last_post_subject' => array('STEXT_UNI', ''),

+ ),

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

+ 'post_subject' => array('STEXT_UNI', '', 'true_sort'),

+ ),

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

+ 'message_subject' => array('STEXT_UNI', ''),

+ ),

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

+ 'topic_title' => array('STEXT_UNI', '', 'true_sort'),

+ 'topic_last_post_subject' => array('STEXT_UNI', ''),

+ ),

+ ),

+ 'drop_keys' => array(

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

+ 'session_forum_id',

+ ),

+ ),

+ 'add_index' => array(

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

+ 'session_fid' => array('session_forum_id'),

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'add_index' => array(

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

+ 'session_forum_id' => array(

+ 'session_forum_id',

+ ),

+ ),

+ ),

+ 'drop_keys' => array(

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

+ 'session_fid',

+ ),

+ ),

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.0.2-rc2')),

+ );

+ }

+}

+<?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_30x_3_0_3 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return version_compare($this->config['version'], '3.0.3', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_3_rc1');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.0.3')),

+ );

+ }

+}

+<?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_30x_3_0_3_rc1 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return version_compare($this->config['version'], '3.0.3-rc1', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_2');

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'add_columns' => array(

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

+ 'template_inherits_id' => array('UINT:4', 0),

+ 'template_inherit_path' => array('VCHAR', ''),

+ ),

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

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

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'drop_columns' => array(

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

+ 'template_inherits_id',

+ 'template_inherit_path',

+ ),

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

+ 'group_max_recipients',

+ ),

+ ),

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.add', array('enable_queue_trigger', '0')),

+ array('config.add', array('queue_trigger_posts', '3')),

+ array('config.add', array('pm_max_recipients', '0')),

+ array('custom', array(array(&$this, 'set_group_default_max_recipients'))),

+ array('config.add', array('dbms_version', $this->db->sql_server_info(true))),

+ array('permission.add', array('u_masspm_group', true, 'u_masspm')),

+ array('custom', array(array(&$this, 'correct_acp_email_permissions'))),

+

+ array('config.update', array('version', '3.0.3-rc1')),

+ );

+ }

+

+ public function correct_acp_email_permissions()

+ {

+ $sql = 'UPDATE ' . $this->table_prefix . 'modules

+ SET module_auth = \'acl_a_email && cfg_email_enable\'

+ WHERE module_class = \'acp\'

+ AND module_basename = \'email\'';

+ $this->sql_query($sql);

+ }

+

+ public function set_group_default_max_recipients()

+ {

+ // Set maximum number of recipients for the registered users, bots, guests group

+ $sql = 'UPDATE ' . GROUPS_TABLE . ' SET group_max_recipients = 5

+ WHERE ' . $this->db->sql_in_set('group_name', array('GUESTS', 'REGISTERED', 'REGISTERED_COPPA', 'BOTS'));

+ $this->sql_query($sql);

+ }

+}

+<?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_30x_3_0_4 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return version_compare($this->config['version'], '3.0.4', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_4_rc1');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('custom', array(array(&$this, 'rename_log_delete_topic'))),

+

+ array('config.update', array('version', '3.0.4')),

+ );

+ }

+

+ public function rename_log_delete_topic()

+ {

+ if ($this->db->sql_layer == 'oracle')

+ {

+ // log_operation is CLOB - but we can change this later

+ $sql = 'UPDATE ' . $this->table_prefix . "log

+ SET log_operation = 'LOG_DELETE_TOPIC'

+ WHERE log_operation LIKE 'LOG_TOPIC_DELETED'";

+ $this->sql_query($sql);

+ }

+ else

+ {

+ $sql = 'UPDATE ' . $this->table_prefix . "log

+ SET log_operation = 'LOG_DELETE_TOPIC'

+ WHERE log_operation = 'LOG_TOPIC_DELETED'";

+ $this->sql_query($sql);

+ }

+ }

+}

+<?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_30x_3_0_4_rc1 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return version_compare($this->config['version'], '3.0.4-rc1', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_3');

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'add_columns' => array(

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

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

+ ),

+ ),

+ 'change_columns' => array(

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

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

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

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

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

+ ),

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

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

+ ),

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

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

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

+ ),

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

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

+ ),

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

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

+ ),

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

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

+ ),

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

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

+ ),

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

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

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'drop_columns' => array(

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

+ 'field_show_profile',

+ ),

+ ),

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('custom', array(array(&$this, 'update_custom_profile_fields'))),

+

+ array('config.update', array('version', '3.0.4-rc1')),

+ );

+ }

+

+ public function update_custom_profile_fields()

+ {

+ // Update the Custom Profile Fields based on previous settings to the new format

+ $sql = 'SELECT field_id, field_required, field_show_on_reg, field_hide

+ FROM ' . PROFILE_FIELDS_TABLE;

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

+

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

+ {

+ $sql_ary = array(

+ 'field_required' => 0,

+ 'field_show_on_reg' => 0,

+ 'field_hide' => 0,

+ 'field_show_profile'=> 0,

+ );

+

+ if ($row['field_required'])

+ {

+ $sql_ary['field_required'] = $sql_ary['field_show_on_reg'] = $sql_ary['field_show_profile'] = 1;

+ }

+ else if ($row['field_show_on_reg'])

+ {

+ $sql_ary['field_show_on_reg'] = $sql_ary['field_show_profile'] = 1;

+ }

+ else if ($row['field_hide'])

+ {

+ // Only administrators and moderators can see this CPF, if the view is enabled, they can see it, otherwise just admins in the acp_users module

+ $sql_ary['field_hide'] = 1;

+ }

+ else

+ {

+ // equivelant to "none", which is the "Display in user control panel" option

+ $sql_ary['field_show_profile'] = 1;

+ }

+

+ $this->sql_query('UPDATE ' . $this->table_prefix . 'profile_fields SET ' . $this->db->sql_build_array('UPDATE', $sql_ary) . ' WHERE field_id = ' . $row['field_id'], $errored, $error_ary);

+ }

+

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

+ }

+}

+<?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_30x_3_0_5 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return version_compare($this->config['version'], '3.0.5', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_5_rc1part2');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.0.5')),

+ );

+ }

+}

+<?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_30x_3_0_5_rc1 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return version_compare($this->config['version'], '3.0.5-rc1', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_4');

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'change_columns' => array(

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

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

+ ),

+ ),

+ );

+ }

+

+ public function update_data()

+ {

+ $search_indexing_state = $this->config['search_indexing_state'];

+

+ return array(

+ array('config.add', array('captcha_gd_wave', 0)),

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

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

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

+ array('config.add', array('max_num_search_keywords', 10)),

+ array('config.remove', array('search_indexing_state')),

+ array('config.add', array('search_indexing_state', $search_indexing_state, true)),

+ array('custom', array(array(&$this, 'hash_old_passwords'))),

+ array('custom', array(array(&$this, 'update_ichiro_bot'))),

+ );

+ }

+

+ public function hash_old_passwords()

+ {

+ $sql = 'SELECT user_id, user_password

+ FROM ' . $this->table_prefix . 'users

+ WHERE user_pass_convert = 1';

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

+

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

+ {

+ if (strlen($row['user_password']) == 32)

+ {

+ $sql_ary = array(

+ 'user_password' => phpbb_hash($row['user_password']),

+ );

+

+ $this->sql_query('UPDATE ' . $this->table_prefix . 'users SET ' . $this->db->sql_build_array('UPDATE', $sql_ary) . ' WHERE user_id = ' . $row['user_id']);

+ }

+ }

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

+ }

+

+ public function update_ichiro_bot()

+ {

+ // Adjust bot entry

+ $sql = 'UPDATE ' . $this->table_prefix . "bots

+ SET bot_agent = 'ichiro/'

+ WHERE bot_agent = 'ichiro/2'";

+ $this->sql_query($sql);

+ }

+

+ public function remove_duplicate_auth_options()

+ {

+ // Before we are able to add a unique key to auth_option, we need to remove duplicate entries

+ $sql = 'SELECT auth_option

+ FROM ' . $this->table_prefix . 'acl_options

+ GROUP BY auth_option

+ HAVING COUNT(*) >= 2';

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

+

+ $auth_options = array();

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

+ {

+ $auth_options[] = $row['auth_option'];

+ }

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

+

+ // Remove specific auth options

+ if (!empty($auth_options))

+ {

+ foreach ($auth_options as $option)

+ {

+ // Select auth_option_ids... the largest id will be preserved

+ $sql = 'SELECT auth_option_id

+ FROM ' . ACL_OPTIONS_TABLE . "

+ WHERE auth_option = '" . $db->sql_escape($option) . "'

+ ORDER BY auth_option_id DESC";

+ // sql_query_limit not possible here, due to bug in postgresql layer

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

+

+ // Skip first row, this is our original auth option we want to preserve

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

+

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

+ {

+ // Ok, remove this auth option...

+ $this->sql_query('DELETE FROM ' . ACL_OPTIONS_TABLE . ' WHERE auth_option_id = ' . $row['auth_option_id']);

+ $this->sql_query('DELETE FROM ' . ACL_ROLES_DATA_TABLE . ' WHERE auth_option_id = ' . $row['auth_option_id']);

+ $this->sql_query('DELETE FROM ' . ACL_GROUPS_TABLE . ' WHERE auth_option_id = ' . $row['auth_option_id']);

+ $this->sql_query('DELETE FROM ' . ACL_USERS_TABLE . ' WHERE auth_option_id = ' . $row['auth_option_id']);

+ }

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

+ }

+ }

+ }

+}

+<?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_30x_3_0_5_rc1part2 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return version_compare($this->config['version'], '3.0.5-rc1', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_5_rc1');

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'drop_keys' => array(

+ $this->table_prefix . 'acl_options' => array('auth_option'),

+ ),

+ 'add_unique_index' => array(

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

+ 'auth_option' => array('auth_option'),

+ ),

+ ),

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.0.5-rc1')),

+ );

+ }

+}

+<?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_30x_3_0_6 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return version_compare($this->config['version'], '3.0.6', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_6_rc4');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.0.6')),

+ );

+ }

+}

+<?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_30x_3_0_6_rc1 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return version_compare($this->config['version'], '3.0.6-rc1', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_5');

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'add_columns' => array(

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

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

+ ),

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

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

+ 'user_reminded' => array('TINT:4', 0),

+ 'user_reminded_time' => array('TIMESTAMP', 0),

+ ),

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

+ 'group_skip_auth' => array('BOOL', 0, 'after' => 'group_founder_manage'),

+ ),

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

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

+ ),

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

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

+ ),

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

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

+ ),

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

+ 'forum_options' => array('UINT:20', 0),

+ ),

+ ),

+ 'change_columns' => array(

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

+ 'user_options' => array('UINT:11', 230271),

+ ),

+ ),

+ 'add_index' => array(

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

+ 'post_id' => array('post_id'),

+ 'pm_id' => array('pm_id'),

+ ),

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

+ 'post_username' => array('post_username:255'),

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'drop_columns' => array(

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

+ 'attempts',

+ ),

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

+ 'user_new',

+ 'user_reminded',

+ 'user_reminded_time',

+ ),

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

+ 'group_skip_auth',

+ ),

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

+ 'message_reported',

+ ),

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

+ 'pm_id',

+ ),

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

+ 'field_show_on_vt',

+ ),

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

+ 'forum_options',

+ ),

+ ),

+ 'drop_keys' => array(

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

+ 'post_id',

+ 'pm_id',

+ ),

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

+ 'post_username',

+ ),

+ ),

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.add', array('captcha_plugin', 'phpbb_captcha_nogd')),

+ array('if', array(

+ ($this->config['captcha_gd']),

+ array('config.update', array('captcha_plugin', 'phpbb_captcha_gd')),

+ )),

+

+ array('config.add', array('feed_enable', 0)),

+ array('config.add', array('feed_limit', 10)),

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

+ array('config.add', array('feed_overall_forums_limit', 15)),

+ array('config.add', array('feed_overall_topics', 0)),

+ array('config.add', array('feed_overall_topics_limit', 15)),

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

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

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

+

+ array('config.add', array('smilies_per_page', 50)),

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

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

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

+ array('config.add', array('new_member_post_limit', 0)),

+ array('config.add', array('new_member_group_default', 0)),

+ array('config.add', array('delete_time', $this->config['edit_time'])),

+

+ array('config.add', array('allow_avatar', 0)),

+ array('if', array(

+ ($this->config['allow_avatar_upload'] || $this->config['allow_avatar_local'] || $this->config['allow_avatar_remote']),

+ array('config.update', array('allow_avatar', 1)),

+ )),

+ array('config.add', array('allow_avatar_remote_upload', 0)),

+ array('if', array(

+ ($this->config['allow_avatar_remote'] && $this->config['allow_avatar_upload']),

+ array('config.update', array('allow_avatar_remote_upload', 1)),

+ )),

+

+ array('module.add', array(

+ 'acp',

+ 'ACP_BOARD_CONFIGURATION',

+ array(

+ 'module_basename' => 'acp_board',

+ 'modes' => array('feed'),

+ ),

+ )),

+ array('module.add', array(

+ 'acp',

+ 'ACP_CAT_USERS',

+ array(

+ 'module_basename' => 'acp_users',

+ 'modes' => array('warnings'),

+ ),

+ )),

+ array('module.add', array(

+ 'acp',

+ 'ACP_SERVER_CONFIGURATION',

+ array(

+ 'module_basename' => 'acp_send_statistics',

+ 'modes' => array('send_statistics'),

+ ),

+ )),

+ array('module.add', array(

+ 'acp',

+ 'ACP_FORUM_BASED_PERMISSIONS',

+ array(

+ 'module_basename' => 'acp_permissions',

+ 'modes' => array('setting_forum_copy'),

+ ),

+ )),

+ array('module.add', array(

+ 'mcp',

+ 'MCP_REPORTS',

+ array(

+ 'module_basename' => 'mcp_pm_reports',

+ 'modes' => array('pm_reports','pm_reports_closed','pm_report_details'),

+ ),

+ )),

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

+ array('custom', array(array(&$this, 'set_user_options_default'))),

+

+ array('config.update', array('version', '3.0.6-rc1')),

+ );

+ }

+

+ public function set_user_options_default()

+ {

+ // 229376 is the added value to enable all three signature options

+ $sql = 'UPDATE ' . USERS_TABLE . ' SET user_options = user_options + 229376';

+ $this->sql_query($sql);

+ }

+

+ public function add_newly_registered_group()

+ {

+ // Add newly_registered group... but check if it already exists (we always supported running the updater on any schema)

+ $sql = 'SELECT group_id

+ FROM ' . GROUPS_TABLE . "

+ WHERE group_name = 'NEWLY_REGISTERED'";

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

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

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

+

+ if (!$group_id)

+ {

+ $sql = 'INSERT INTO ' . GROUPS_TABLE . " (group_name, group_type, group_founder_manage, group_colour, group_legend, group_avatar, group_desc, group_desc_uid, group_max_recipients) VALUES ('NEWLY_REGISTERED', 3, 0, '', 0, '', '', '', 5)";

+ $this->sql_query($sql);

+

+ $group_id = $this->db->sql_nextid();

+ }

+

+ // Insert new user role... at the end of the chain

+ $sql = 'SELECT role_id

+ FROM ' . ACL_ROLES_TABLE . "

+ WHERE role_name = 'ROLE_USER_NEW_MEMBER'

+ AND role_type = 'u_'";

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

+ $u_role = (int) $this->db->sql_fetchfield('role_id');

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

+

+ if (!$u_role)

+ {

+ $sql = 'SELECT MAX(role_order) as max_order_id

+ FROM ' . ACL_ROLES_TABLE . "

+ WHERE role_type = 'u_'";

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

+ $next_order_id = (int) $this->db->sql_fetchfield('max_order_id');

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

+

+ $next_order_id++;

+

+ $sql = 'INSERT INTO ' . ACL_ROLES_TABLE . " (role_name, role_description, role_type, role_order) VALUES ('ROLE_USER_NEW_MEMBER', 'ROLE_DESCRIPTION_USER_NEW_MEMBER', 'u_', $next_order_id)";

+ $this->sql_query($sql);

+ $u_role = $this->db->sql_nextid();

+

+ // Now add the correct data to the roles...

+ // The standard role says that new users are not able to send a PM, Mass PM, are not able to PM groups

+ $sql = 'INSERT INTO ' . ACL_ROLES_DATA_TABLE . " (role_id, auth_option_id, auth_setting) SELECT $u_role, auth_option_id, 0 FROM " . ACL_OPTIONS_TABLE . " WHERE auth_option LIKE 'u_%' AND auth_option IN ('u_sendpm', 'u_masspm', 'u_masspm_group')";

+ $this->sql_query($sql);

+

+ // Add user role to group

+ $sql = 'INSERT INTO ' . ACL_GROUPS_TABLE . " (group_id, forum_id, auth_option_id, auth_role_id, auth_setting) VALUES ($group_id, 0, 0, $u_role, 0)";

+ $this->sql_query($sql);

+ }

+

+ // Insert new forum role

+ $sql = 'SELECT role_id

+ FROM ' . ACL_ROLES_TABLE . "

+ WHERE role_name = 'ROLE_FORUM_NEW_MEMBER'

+ AND role_type = 'f_'";

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

+ $f_role = (int) $this->db->sql_fetchfield('role_id');

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

+

+ if (!$f_role)

+ {

+ $sql = 'SELECT MAX(role_order) as max_order_id

+ FROM ' . ACL_ROLES_TABLE . "

+ WHERE role_type = 'f_'";

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

+ $next_order_id = (int) $this->db->sql_fetchfield('max_order_id');

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

+

+ $next_order_id++;

+

+ $sql = 'INSERT INTO ' . ACL_ROLES_TABLE . " (role_name, role_description, role_type, role_order) VALUES ('ROLE_FORUM_NEW_MEMBER', 'ROLE_DESCRIPTION_FORUM_NEW_MEMBER', 'f_', $next_order_id)";

+ $this->sql_query($sql);

+ $f_role = $this->db->sql_nextid();

+

+ $sql = 'INSERT INTO ' . ACL_ROLES_DATA_TABLE . " (role_id, auth_option_id, auth_setting) SELECT $f_role, auth_option_id, 0 FROM " . ACL_OPTIONS_TABLE . " WHERE auth_option LIKE 'f_%' AND auth_option IN ('f_noapprove')";

+ $this->sql_query($sql);

+ }

+

+ // Set every members user_new column to 0 (old users) only if there is no one yet (this makes sure we do not execute this more than once)

+ $sql = 'SELECT 1

+ FROM ' . USERS_TABLE . '

+ WHERE user_new = 0';

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

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

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

+

+ if (!$row)

+ {

+ $sql = 'UPDATE ' . USERS_TABLE . ' SET user_new = 0';

+ $this->sql_query($sql);

+ }

+

+ // To mimick the old "feature" we will assign the forum role to every forum, regardless of the setting (this makes sure there are no "this does not work!!!! YUO!!!" posts...

+ // Check if the role is already assigned...

+ $sql = 'SELECT forum_id

+ FROM ' . ACL_GROUPS_TABLE . '

+ WHERE group_id = ' . $group_id . '

+ AND auth_role_id = ' . $f_role;

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

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

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

+

+ // Not assigned at all... :/

+ if (!$is_options)

+ {

+ // Get postable forums

+ $sql = 'SELECT forum_id

+ FROM ' . FORUMS_TABLE . '

+ WHERE forum_type != ' . FORUM_LINK;

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

+

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

+ {

+ $this->sql_query('INSERT INTO ' . ACL_GROUPS_TABLE . ' (group_id, forum_id, auth_option_id, auth_role_id, auth_setting) VALUES (' . $group_id . ', ' . (int) $row['forum_id'] . ', 0, ' . $f_role . ', 0)');

+ }

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

+ }

+

+ // Clear permissions...

+ include_once($this->phpbb_root_path . 'includes/acp/auth.' . $this->php_ext);

+ $auth_admin = new auth_admin();

+ $auth_admin->acl_clear_prefetch();

+ }

+}

+<?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_30x_3_0_6_rc2 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return version_compare($this->config['version'], '3.0.6-rc2', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_6_rc1');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.0.6-rc2')),

+ );

+ }

+}

+<?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_30x_3_0_6_rc3 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return version_compare($this->config['version'], '3.0.6-rc3', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_6_rc2');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('custom', array(array(&$this, 'update_cp_fields'))),

+

+ array('config.update', array('version', '3.0.6-rc3')),

+ );

+ }

+

+ public function update_cp_fields()

+ {

+ // Update the Custom Profile Fields based on previous settings to the new format

+ $sql = 'UPDATE ' . PROFILE_FIELDS_TABLE . '

+ SET field_show_on_vt = 1

+ WHERE field_hide = 0

+ AND (field_required = 1 OR field_show_on_reg = 1 OR field_show_profile = 1)';

+ $this->sql_query($sql);

+ }

+}

+<?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_30x_3_0_6_rc4 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return version_compare($this->config['version'], '3.0.6-rc4', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_6_rc3');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.0.6-rc4')),

+ );

+ }

+}

+<?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_30x_3_0_7 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return version_compare($this->config['version'], '3.0.7', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_7_rc2');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.0.7')),

+ );

+ }

+}

+<?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_30x_3_0_7_pl1 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return version_compare($this->config['version'], '3.0.7-pl1', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_7');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.0.7-pl1')),

+ );

+ }

+}

+<?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_30x_3_0_7_rc1 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return version_compare($this->config['version'], '3.0.7-rc1', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_6');

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'drop_keys' => array(

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

+ 'log_time',

+ ),

+ ),

+ 'add_index' => array(

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

+ 'topic_id' => array('topic_id'),

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'add_index' => array(

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

+ 'log_time' => array('log_time'),

+ ),

+ ),

+ 'drop_keys' => array(

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

+ 'topic_id',

+ ),

+ ),

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

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

+ array('config.add', array('feed_http_auth', 0)),

+ array('config.add', array('feed_limit_post', $this->config['feed_limit'])),

+ array('config.add', array('feed_limit_topic', $this->config['feed_overall_topics_limit'])),

+ array('config.add', array('feed_topics_new', $this->config['feed_overall_topics'])),

+ array('config.add', array('feed_topics_active', $this->config['feed_overall_topics'])),

+ array('custom', array(array(&$this, 'delete_text_templates'))),

+

+ array('config.update', array('version', '3.0.7-rc1')),

+ );

+ }

+

+ public function delete_text_templates()

+ {

+ // Delete all text-templates from the template_data

+ $sql = 'DELETE FROM ' . STYLES_TEMPLATE_DATA_TABLE . '

+ WHERE template_filename ' . $this->db->sql_like_expression($this->db->any_char . '.txt');

+ $this->sql_query($sql);

+ }

+}

+<?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_30x_3_0_7_rc2 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return version_compare($this->config['version'], '3.0.7-rc2', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_7_rc1');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('custom', array(array(&$this, 'update_email_hash'))),

+

+ array('config.update', array('version', '3.0.7-rc2')),

+ );

+ }

+

+ public function update_email_hash($start = 0)

+ {

+ $limit = 1000;

+

+ $sql = 'SELECT user_id, user_email, user_email_hash

+ FROM ' . USERS_TABLE . '

+ WHERE user_type <> ' . USER_IGNORE . "

+ AND user_email <> ''";

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

+

+ $i = 0;

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

+ {

+ $i++;

+

+ // Snapshot of the phpbb_email_hash() function

+ // We cannot call it directly because the auto updater updates the DB first. :/

+ $user_email_hash = sprintf('%u', crc32(strtolower($row['user_email']))) . strlen($row['user_email']);

+

+ if ($user_email_hash != $row['user_email_hash'])

+ {

+ $sql_ary = array(

+ 'user_email_hash' => $user_email_hash,

+ );

+

+ $sql = 'UPDATE ' . USERS_TABLE . '

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

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

+ $this->sql_query($sql);

+ }

+ }

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

+

+ if ($i < $limit)

+ {

+ // Completed

+ return;

+ }

+

+ // Return the next start, will be sent to $start when this function is called again

+ return $start + $limit;

+ }

+}

+<?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_30x_3_0_8 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return version_compare($this->config['version'], '3.0.8', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_8_rc1');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.0.8')),

+ );

+ }

+}

+<?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_30x_3_0_8_rc1 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return version_compare($this->config['version'], '3.0.8-rc1', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_7_pl1');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('custom', array(array(&$this, 'update_file_extension_group_names'))),

+ array('custom', array(array(&$this, 'update_module_auth'))),

+ array('custom', array(array(&$this, 'update_bots'))),

+ array('custom', array(array(&$this, 'delete_orphan_shadow_topics'))),

+ array('module.add', array(

+ 'acp',

+ 'ACP_MESSAGES',

+ array(

+ 'module_basename' => 'acp_board',

+ 'modes' => array('post'),

+ ),

+ )),

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

+ array('config.update_if_equals', array(600, 'queue_interval', 60)),

+ array('config.update_if_equals', array(50, 'email_package_size', 20)),

+

+ array('config.update', array('version', '3.0.8-rc1')),

+ );

+ }

+

+ public function update_file_extension_group_names()

+ {

+ // Update file extension group names to use language strings.

+ $sql = 'SELECT lang_dir

+ FROM ' . LANG_TABLE;

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

+

+ $extension_groups_updated = array();

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

+ {

+ $lang_dir = basename($lang_dir);

+

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

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

+ // or they are in language/.../install.php when we're updating from 3.0.7-PL1 or earlier.

+ // On an already updated board, they can also already be in language/.../acp/attachments.php

+ // in the board root.

+ $lang_files = array(

+ "{$this->phpbb_root_path}install/update/new/language/$lang_dir/acp/attachments.{$this->php_ext}",

+ "{$this->phpbb_root_path}language/$lang_dir/install.{$this->php_ext}",

+ "{$this->phpbb_root_path}language/$lang_dir/acp/attachments.{$this->php_ext}",

+ );

+

+ foreach ($lang_files as $lang_file)

+ {

+ if (!file_exists($lang_file))

+ {

+ continue;

+ }

+

+ $lang = array();

+ include($lang_file);

+

+ foreach($lang as $lang_key => $lang_val)

+ {

+ if (isset($extension_groups_updated[$lang_key]) || strpos($lang_key, 'EXT_GROUP_') !== 0)

+ {

+ continue;

+ }

+

+ $sql_ary = array(

+ 'group_name' => substr($lang_key, 10), // Strip off 'EXT_GROUP_'

+ );

+

+ $sql = 'UPDATE ' . EXTENSION_GROUPS_TABLE . '

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

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

+ $this->sql_query($sql);

+

+ $extension_groups_updated[$lang_key] = true;

+ }

+ }

+ }

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

+ }

+

+ public function update_module_auth()

+ {

+ $sql = 'UPDATE ' . MODULES_TABLE . '

+ SET module_auth = \'cfg_allow_avatar && (cfg_allow_avatar_local || cfg_allow_avatar_remote || cfg_allow_avatar_upload || cfg_allow_avatar_remote_upload)\'

+ WHERE module_class = \'ucp\'

+ AND module_basename = \'profile\'

+ AND module_mode = \'avatar\'';

+ $this->sql_query($sql);

+ }

+

+ public function update_bots()

+ {

+ $bot_name = 'Bing [Bot]';

+ $bot_name_clean = utf8_clean_string($bot_name);

+

+ $sql = 'SELECT user_id

+ FROM ' . USERS_TABLE . "

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

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

+ $bing_already_added = (bool) $this->db->sql_fetchfield('user_id');

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

+

+ if (!$bing_already_added)

+ {

+ $bot_agent = 'bingbot/';

+ $bot_ip = '';

+ $sql = 'SELECT group_id, group_colour

+ FROM ' . GROUPS_TABLE . "

+ WHERE group_name = 'BOTS'";

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

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

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

+

+ if (!$group_row)

+ {

+ // default fallback, should never get here

+ $group_row['group_id'] = 6;

+ $group_row['group_colour'] = '9E8DA7';

+ }

+

+ if (!function_exists('user_add'))

+ {

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

+ }

+

+ $user_row = array(

+ 'user_type' => USER_IGNORE,

+ 'group_id' => $group_row['group_id'],

+ 'username' => $bot_name,

+ 'user_regdate' => time(),

+ 'user_password' => '',

+ 'user_colour' => $group_row['group_colour'],

+ 'user_email' => '',

+ 'user_lang' => $this->config['default_lang'],

+ 'user_style' => $this->config['default_style'],

+ 'user_timezone' => 0,

+ 'user_dateformat' => $this->config['default_dateformat'],

+ 'user_allow_massemail' => 0,

+ );

+

+ $user_id = user_add($user_row);

+

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

+ 'bot_active' => 1,

+ 'bot_name' => (string) $bot_name,

+ 'user_id' => (int) $user_id,

+ 'bot_agent' => (string) $bot_agent,

+ 'bot_ip' => (string) $bot_ip,

+ ));

+

+ $this->sql_query($sql);

+ }

+ }

+

+ public function delete_orphan_shadow_topics()

+ {

+ // Delete shadow topics pointing to not existing topics

+ $batch_size = 500;

+

+ // Set of affected forums we have to resync

+ $sync_forum_ids = array();

+

+ $sql_array = array(

+ 'SELECT' => 't1.topic_id, t1.forum_id',

+ 'FROM' => array(

+ TOPICS_TABLE => 't1',

+ ),

+ 'LEFT_JOIN' => array(

+ array(

+ 'FROM' => array(TOPICS_TABLE => 't2'),

+ 'ON' => 't1.topic_moved_id = t2.topic_id',

+ ),

+ ),

+ 'WHERE' => 't1.topic_moved_id <> 0

+ AND t2.topic_id IS NULL',

+ );

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

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

+

+ $topic_ids = array();

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

+ {

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

+

+ $sync_forum_ids[(int) $row['forum_id']] = (int) $row['forum_id'];

+ }

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

+

+ if (!empty($topic_ids))

+ {

+ $sql = 'DELETE FROM ' . TOPICS_TABLE . '

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

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

+

+ // Sync the forums we have deleted shadow topics from.

+ sync('forum', 'forum_id', $sync_forum_ids, true, true);

+

+ return false;

+ }

+ }

+}

+<?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_30x_3_0_9 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return version_compare($this->config['version'], '3.0.9', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_9_rc4');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.0.9')),

+ );

+ }

+}