+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_v301 extends phpbb_db_migration

+{

+ function depends_on()

+ {

+ return array('phpbb_db_migration_v301rc1');

+ }

+

+ function update_schema()

+ {

+ return array();

+ }

+

+ function update_data()

+ {

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_v3010 extends phpbb_db_migration

+{

+ function depends_on()

+ {

+ return array('phpbb_db_migration_v3010rc3');

+ }

+

+ function update_schema()

+ {

+ return array();

+ }

+

+ function update_data()

+ {

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_v3010rc1 extends phpbb_db_migration

+{

+ function depends_on()

+ {

+ return array('phpbb_db_migration_v309');

+ }

+

+ function update_schema()

+ {

+ return array();

+ }

+

+ function update_data()

+ {

+ if (!isset($config['email_max_chunk_size']))

+ {

+ set_config('email_max_chunk_size', '50');

+ }

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_v3010rc2 extends phpbb_db_migration

+{

+ function depends_on()

+ {

+ return array('phpbb_db_migration_v3010rc1');

+ }

+

+ function update_schema()

+ {

+ return array();

+ }

+

+ function update_data()

+ {

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_v3010rc3 extends phpbb_db_migration

+{

+ function depends_on()

+ {

+ return array('phpbb_db_migration_v3010rc2');

+ }

+

+ function update_schema()

+ {

+ return array();

+ }

+

+ function update_data()

+ {

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_v3011 extends phpbb_db_migration

+{

+ function depends_on()

+ {

+ return array('phpbb_db_migration_v3011rc2');

+ }

+

+ function update_schema()

+ {

+ return array();

+ }

+

+ function update_data()

+ {

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_v3011rc1 extends phpbb_db_migration

+{

+ function depends_on()

+ {

+ return array('phpbb_db_migration_v3010');

+ }

+

+ function update_schema()

+ {

+ return array();

+ }

+

+ function update_data()

+ {

+ // Updates users having current style a deactivated one

+ $sql = 'SELECT style_id

+ FROM ' . STYLES_TABLE . '

+ WHERE style_active = 0';

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

+

+ $deactivated_style_ids = array();

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

+ {

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

+ }

+ $db->sql_freeresult($result);

+

+ if (!empty($deactivated_style_ids))

+ {

+ $sql = 'UPDATE ' . USERS_TABLE . '

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

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

+ _sql($sql, $errored, $error_ary);

+ }

+

+ // 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 = $db->sql_build_query('SELECT', $sql_array);

+

+ do

+ {

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

+

+ $delete_pms = array();

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

+ {

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

+ }

+ $db->sql_freeresult($result);

+

+ if (!empty($delete_pms))

+ {

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

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

+ _sql($sql, $errored, $error_ary);

+ }

+ }

+ while (sizeof($delete_pms) == $batch_size);

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_v3011rc2 extends phpbb_db_migration

+{

+ function depends_on()

+ {

+ return array('phpbb_db_migration_v3011rc1');

+ }

+

+ function update_schema()

+ {

+ return array(

+ 'add_columns' => array(

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

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

+ ),

+ ),

+ );

+ }

+

+ function update_data()

+ {

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_v3012rc1 extends phpbb_db_migration

+{

+ function depends_on()

+ {

+ return array('phpbb_db_migration_v3011');

+ }

+

+ function update_schema()

+ {

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

+ return array();

+ }

+

+ function update_data()

+ {

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_v301rc1 extends phpbb_db_migration

+{

+ function depends_on()

+ {

+ return array();

+ }

+

+ 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'),

+ ),

+ ),

+ );

+ }

+

+ function update_data()

+ {

+ return array(

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

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

+ );

+ }

+

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

+ }

+

+ 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_v302 extends phpbb_db_migration

+{

+ function depends_on()

+ {

+ return array('phpbb_db_migration_v302rc2');

+ }

+

+ function update_schema()

+ {

+ return array();

+ }

+

+ function update_data()

+ {

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_v301rc1 extends phpbb_db_migration

+{

+ function depends_on()

+ {

+ return array('phpbb_db_migration_v301');

+ }

+

+ function update_schema()

+ {

+ return array();

+ }

+

+ 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')),

+ );

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_v302rc1 extends phpbb_db_migration

+{

+ function depends_on()

+ {

+ return array('phpbb_db_migration_v302rc1');

+ }

+

+ 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'),

+ ),

+ ),

+ );

+ }

+

+ function update_data()

+ {

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_v303 extends phpbb_db_migration

+{

+ function depends_on()

+ {

+ return array('phpbb_db_migration_v302rc2');

+ }

+

+ function update_schema()

+ {

+ return array();

+ }

+

+ function update_data()

+ {

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_v303rc1 extends phpbb_db_migration

+{

+ function depends_on()

+ {

+ return array('phpbb_db_migration_v302');

+ }

+

+ 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),

+ ),

+ ),

+ );

+ }

+

+ 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('set_group_default_max_recipients'))

+

+ // Not prefilling yet

+ set_config('dbms_version', '');

+

+ // Add new permission u_masspm_group and duplicate settings from u_masspm

+ include_once($phpbb_root_path . 'includes/acp/auth.' . $phpEx);

+ $auth_admin = new auth_admin();

+

+ // Only add the new permission if it does not already exist

+ if (empty($auth_admin->acl_options['id']['u_masspm_group']))

+ {

+ $auth_admin->acl_add_option(array('global' => array('u_masspm_group')));

+

+ // Now the tricky part, filling the permission

+ $old_id = $auth_admin->acl_options['id']['u_masspm'];

+ $new_id = $auth_admin->acl_options['id']['u_masspm_group'];

+

+ $tables = array(ACL_GROUPS_TABLE, ACL_ROLES_DATA_TABLE, ACL_USERS_TABLE);

+

+ foreach ($tables as $table)

+ {

+ $sql = 'SELECT *

+ FROM ' . $table . '

+ WHERE auth_option_id = ' . $old_id;

+ $result = _sql($sql, $errored, $error_ary);

+

+ $sql_ary = array();

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

+ {

+ $row['auth_option_id'] = $new_id;

+ $sql_ary[] = $row;

+ }

+ $db->sql_freeresult($result);

+

+ if (sizeof($sql_ary))

+ {

+ $db->sql_multi_insert($table, $sql_ary);

+ }

+ }

+

+ // Remove any old permission entries

+ $auth_admin->acl_clear_prefetch();

+ }

+

+ /**

+ * Do not resync post counts here. An admin may do this later from the ACP

+ $start = 0;

+ $step = ($config['num_posts']) ? (max((int) ($config['num_posts'] / 5), 20000)) : 20000;

+

+ $sql = 'UPDATE ' . USERS_TABLE . ' SET user_posts = 0';

+ _sql($sql, $errored, $error_ary);

+

+ do

+ {

+ $sql = 'SELECT COUNT(post_id) AS num_posts, poster_id

+ FROM ' . POSTS_TABLE . '

+ WHERE post_id BETWEEN ' . ($start + 1) . ' AND ' . ($start + $step) . '

+ AND post_postcount = 1 AND post_approved = 1

+ GROUP BY poster_id';

+ $result = _sql($sql, $errored, $error_ary);

+

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

+ {

+ do

+ {

+ $sql = 'UPDATE ' . USERS_TABLE . " SET user_posts = user_posts + {$row['num_posts']} WHERE user_id = {$row['poster_id']}";

+ _sql($sql, $errored, $error_ary);

+ }

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

+

+ $start += $step;

+ }

+ else

+ {

+ $start = 0;

+ }

+ $db->sql_freeresult($result);

+ }

+ while ($start);

+ */

+

+ $sql = 'UPDATE ' . MODULES_TABLE . '

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

+ WHERE module_class = \'acp\'

+ AND module_basename = \'email\'';

+ _sql($sql, $errored, $error_ary);

+ }

+

+ 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_v304 extends phpbb_db_migration

+{

+ function depends_on()

+ {

+ return array('phpbb_db_migration_v304rc1');

+ }

+

+ function update_schema()

+ {

+ return array();

+ }

+

+ function update_data()

+ {

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

+ {

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

+ $sql = 'UPDATE ' . LOG_TABLE . "

+ SET log_operation = 'LOG_DELETE_TOPIC'

+ WHERE log_operation LIKE 'LOG_TOPIC_DELETED'";

+ _sql($sql, $errored, $error_ary);

+ }

+ else

+ {

+ $sql = 'UPDATE ' . LOG_TABLE . "

+ SET log_operation = 'LOG_DELETE_TOPIC'

+ WHERE log_operation = 'LOG_TOPIC_DELETED'";

+ _sql($sql, $errored, $error_ary);

+ }

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_v304rc1 extends phpbb_db_migration

+{

+ function depends_on()

+ {

+ return array('phpbb_db_migration_v303');

+ }

+

+ 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),

+ ),

+ ),

+ );

+ }

+

+ function update_data()

+ {

+ // 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 = _sql($sql, $errored, $error_ary);

+

+ while ($row = $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;

+ }

+

+ _sql('UPDATE ' . PROFILE_FIELDS_TABLE . ' SET ' . $db->sql_build_array('UPDATE', $sql_ary) . ' WHERE field_id = ' . $row['field_id'], $errored, $error_ary);

+ }

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_v305 extends phpbb_db_migration

+{

+ function depends_on()

+ {

+ return array('phpbb_db_migration_v305rc1');

+ }

+

+ function update_schema()

+ {

+ return array();

+ }

+

+ function update_data()

+ {

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_v305rc1 extends phpbb_db_migration

+{

+ function depends_on()

+ {

+ return array('phpbb_db_migration_v304');

+ }

+

+ function update_schema()

+ {

+ return array(

+ 'change_columns' => array(

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

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

+ ),

+ ),

+ );

+ }

+

+ function update_data()

+ {

+ // Captcha config variables

+ set_config('captcha_gd_wave', 0);

+ set_config('captcha_gd_3d_noise', 1);

+ set_config('captcha_gd_fonts', 1);

+ set_config('confirm_refresh', 1);

+

+ // Maximum number of keywords

+ set_config('max_num_search_keywords', 10);

+

+ // Remove static config var and put it back as dynamic variable

+ $sql = 'UPDATE ' . CONFIG_TABLE . "

+ SET is_dynamic = 1

+ WHERE config_name = 'search_indexing_state'";

+ _sql($sql, $errored, $error_ary);

+

+ // Hash old MD5 passwords

+ $sql = 'SELECT user_id, user_password

+ FROM ' . USERS_TABLE . '

+ WHERE user_pass_convert = 1';

+ $result = _sql($sql, $errored, $error_ary);

+

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

+ {

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

+ {

+ $sql_ary = array(

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

+ );

+

+ _sql('UPDATE ' . USERS_TABLE . ' SET ' . $db->sql_build_array('UPDATE', $sql_ary) . ' WHERE user_id = ' . $row['user_id'], $errored, $error_ary);

+ }

+ }

+ $db->sql_freeresult($result);

+

+ // Adjust bot entry

+ $sql = 'UPDATE ' . BOTS_TABLE . "

+ SET bot_agent = 'ichiro/'

+ WHERE bot_agent = 'ichiro/2'";

+ _sql($sql, $errored, $error_ary);

+

+

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

+

+ // We get duplicate entries first

+ $sql = 'SELECT auth_option

+ FROM ' . ACL_OPTIONS_TABLE . '

+ GROUP BY auth_option

+ HAVING COUNT(*) >= 2';

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

+

+ $auth_options = array();

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

+ {

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

+ }

+ $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 = $db->sql_query($sql);

+

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

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

+

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

+ {

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

+ _sql('DELETE FROM ' . ACL_OPTIONS_TABLE . ' WHERE auth_option_id = ' . $row['auth_option_id'], $errored, $error_ary);

+ _sql('DELETE FROM ' . ACL_ROLES_DATA_TABLE . ' WHERE auth_option_id = ' . $row['auth_option_id'], $errored, $error_ary);

+ _sql('DELETE FROM ' . ACL_GROUPS_TABLE . ' WHERE auth_option_id = ' . $row['auth_option_id'], $errored, $error_ary);

+ _sql('DELETE FROM ' . ACL_USERS_TABLE . ' WHERE auth_option_id = ' . $row['auth_option_id'], $errored, $error_ary);

+ }

+ $db->sql_freeresult($result);

+ }

+ }

+

+ // Now make auth_option UNIQUE, by dropping the old index and adding a UNIQUE one.

+ $changes = array(

+ 'drop_keys' => array(

+ ACL_OPTIONS_TABLE => array('auth_option'),

+ ),

+ );

+

+ global $db_tools;

+

+ $statements = $db_tools->perform_schema_changes($changes);

+

+ foreach ($statements as $sql)

+ {

+ _sql($sql, $errored, $error_ary);

+ }

+

+ $changes = array(

+ 'add_unique_index' => array(

+ ACL_OPTIONS_TABLE => array(

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

+ ),

+ ),

+ );

+

+ $statements = $db_tools->perform_schema_changes($changes);

+

+ foreach ($statements as $sql)

+ {

+ _sql($sql, $errored, $error_ary);

+ }

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_v306 extends phpbb_db_migration

+{

+ function depends_on()

+ {

+ return array('phpbb_db_migration_v306rc4');

+ }

+

+ function update_schema()

+ {

+ return array();

+ }

+

+ function update_data()

+ {

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_v306rc1 extends phpbb_db_migration

+{

+ function depends_on()

+ {

+ return array('phpbb_db_migration_v305');

+ }

+

+ 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 . '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'),

+ ),

+ ),

+ );

+ }

+

+ function update_data()

+ {

+ // Let's see if the GD Captcha can be enabled... we simply look for what *is* enabled...

+ if (!empty($config['captcha_gd']) && !isset($config['captcha_plugin']))

+ {

+ set_config('captcha_plugin', 'phpbb_captcha_gd');

+ }

+ else if (!isset($config['captcha_plugin']))

+ {

+ set_config('captcha_plugin', 'phpbb_captcha_nogd');

+ }

+

+ // Entries for the Feed Feature

+ set_config('feed_enable', '0');

+ set_config('feed_limit', '10');

+

+ set_config('feed_overall_forums', '1');

+ set_config('feed_overall_forums_limit', '15');

+

+ set_config('feed_overall_topics', '0');

+ set_config('feed_overall_topics_limit', '15');

+

+ set_config('feed_forum', '1');

+ set_config('feed_topic', '1');

+ set_config('feed_item_statistics', '1');

+

+ // Entries for smiley pagination

+ set_config('smilies_per_page', '50');

+

+ // Entry for reporting PMs

+ set_config('allow_pm_report', '1');

+

+ // Install modules

+ $modules_to_install = array(

+ 'feed' => array(

+ 'base' => 'board',

+ 'class' => 'acp',

+ 'title' => 'ACP_FEED_SETTINGS',

+ 'auth' => 'acl_a_board',

+ 'cat' => 'ACP_BOARD_CONFIGURATION',

+ 'after' => array('signature', 'ACP_SIGNATURE_SETTINGS')

+ ),

+ 'warnings' => array(

+ 'base' => 'users',

+ 'class' => 'acp',

+ 'title' => 'ACP_USER_WARNINGS',

+ 'auth' => 'acl_a_user',

+ 'display' => 0,

+ 'cat' => 'ACP_CAT_USERS',

+ 'after' => array('feedback', 'ACP_USER_FEEDBACK')

+ ),

+ 'send_statistics' => array(

+ 'base' => 'send_statistics',

+ 'class' => 'acp',

+ 'title' => 'ACP_SEND_STATISTICS',

+ 'auth' => 'acl_a_server',

+ 'cat' => 'ACP_SERVER_CONFIGURATION'

+ ),

+ 'setting_forum_copy' => array(

+ 'base' => 'permissions',

+ 'class' => 'acp',

+ 'title' => 'ACP_FORUM_PERMISSIONS_COPY',

+ 'auth' => 'acl_a_fauth && acl_a_authusers && acl_a_authgroups && acl_a_mauth',

+ 'cat' => 'ACP_FORUM_BASED_PERMISSIONS',

+ 'after' => array('setting_forum_local', 'ACP_FORUM_PERMISSIONS')

+ ),

+ 'pm_reports' => array(

+ 'base' => 'pm_reports',

+ 'class' => 'mcp',

+ 'title' => 'MCP_PM_REPORTS_OPEN',

+ 'auth' => 'aclf_m_report',

+ 'cat' => 'MCP_REPORTS'

+ ),

+ 'pm_reports_closed' => array(

+ 'base' => 'pm_reports',

+ 'class' => 'mcp',

+ 'title' => 'MCP_PM_REPORTS_CLOSED',

+ 'auth' => 'aclf_m_report',

+ 'cat' => 'MCP_REPORTS'

+ ),

+ 'pm_report_details' => array(

+ 'base' => 'pm_reports',

+ 'class' => 'mcp',

+ 'title' => 'MCP_PM_REPORT_DETAILS',

+ 'auth' => 'aclf_m_report',

+ 'cat' => 'MCP_REPORTS'

+ ),

+ );

+

+ _add_modules($modules_to_install);

+

+ // 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 = $db->sql_query($sql);

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

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

+ _sql($sql, $errored, $error_ary);

+

+ $group_id = $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 = $db->sql_query($sql);

+ $u_role = (int) $db->sql_fetchfield('role_id');

+ $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 = $db->sql_query($sql);

+ $next_order_id = (int) $db->sql_fetchfield('max_order_id');

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

+ _sql($sql, $errored, $error_ary);

+ $u_role = $db->sql_nextid();

+

+ if (!$errored)

+ {

+ // 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')";

+ _sql($sql, $errored, $error_ary);

+

+ // 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)";

+ _sql($sql, $errored, $error_ary);

+ }

+ }

+

+ // Insert new forum role

+ $sql = 'SELECT role_id

+ FROM ' . ACL_ROLES_TABLE . "

+ WHERE role_name = 'ROLE_FORUM_NEW_MEMBER'

+ AND role_type = 'f_'";

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

+ $f_role = (int) $db->sql_fetchfield('role_id');

+ $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 = $db->sql_query($sql);

+ $next_order_id = (int) $db->sql_fetchfield('max_order_id');

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

+ _sql($sql, $errored, $error_ary);

+ $f_role = $db->sql_nextid();

+

+ if (!$errored)

+ {

+ $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')";

+ _sql($sql, $errored, $error_ary);

+ }

+ }

+

+ // 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 = $db->sql_query_limit($sql, 1);

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

+ $db->sql_freeresult($result);

+

+ if (!$row)

+ {

+ $sql = 'UPDATE ' . USERS_TABLE . ' SET user_new = 0';

+ _sql($sql, $errored, $error_ary);

+ }

+

+ // Newly registered users limit

+ if (!isset($config['new_member_post_limit']))

+ {

+ set_config('new_member_post_limit', (!empty($config['enable_queue_trigger'])) ? $config['queue_trigger_posts'] : 0);

+ }

+

+ if (!isset($config['new_member_group_default']))

+ {

+ set_config('new_member_group_default', 0);

+ }

+

+ // 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 = $db->sql_query($sql);

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

+ $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 = $db->sql_query($sql);

+

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

+ {

+ _sql('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)', $errored, $error_ary);

+ }

+ $db->sql_freeresult($result);

+ }

+

+ // Clear permissions...

+ include_once($phpbb_root_path . 'includes/acp/auth.' . $phpEx);

+ $auth_admin = new auth_admin();

+ $auth_admin->acl_clear_prefetch();

+

+ if (!isset($config['allow_avatar']))

+ {

+ if ($config['allow_avatar_upload'] || $config['allow_avatar_local'] || $config['allow_avatar_remote'])

+ {

+ set_config('allow_avatar', '1');

+ }

+ else

+ {

+ set_config('allow_avatar', '0');

+ }

+ }

+

+ if (!isset($config['allow_avatar_remote_upload']))

+ {

+ if ($config['allow_avatar_remote'] && $config['allow_avatar_upload'])

+ {

+ set_config('allow_avatar_remote_upload', '1');

+ }

+ else

+ {

+ set_config('allow_avatar_remote_upload', '0');

+ }

+ }

+

+ // Minimum number of characters

+ if (!isset($config['min_post_chars']))

+ {

+ set_config('min_post_chars', '1');

+ }

+

+ if (!isset($config['allow_quick_reply']))

+ {

+ set_config('allow_quick_reply', '1');

+ }

+

+ // Set every members user_options column to enable

+ // bbcode, smilies and URLs for signatures by default

+ $sql = 'SELECT user_options

+ FROM ' . USERS_TABLE . '

+ WHERE user_type IN (' . USER_NORMAL . ', ' . USER_FOUNDER . ')';

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

+ $user_option = (int) $db->sql_fetchfield('user_options');

+ $db->sql_freeresult($result);

+

+ // Check if we already updated the database by checking bit 15 which we used to store the sig_bbcode option

+ if (!($user_option & 1 << 15))

+ {

+ // 229376 is the added value to enable all three signature options

+ $sql = 'UPDATE ' . USERS_TABLE . ' SET user_options = user_options + 229376';

+ _sql($sql, $errored, $error_ary);

+ }

+

+ if (!isset($config['delete_time']))

+ {

+ set_config('delete_time', $config['edit_time']);

+ }

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_v306rc2 extends phpbb_db_migration

+{

+ function depends_on()

+ {

+ return array('phpbb_db_migration_v306rc1');

+ }

+

+ function update_schema()

+ {

+ return array();

+ }

+

+ function update_data()

+ {

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_v306rc3 extends phpbb_db_migration

+{

+ function depends_on()

+ {

+ return array('phpbb_db_migration_v306rc2');

+ }

+

+ function update_schema()

+ {

+ return array();

+ }

+

+ function update_data()

+ {

+ // 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)';

+ _sql($sql, $errored, $error_ary);

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_v306rc4 extends phpbb_db_migration

+{

+ function depends_on()

+ {

+ return array('phpbb_db_migration_v306rc3');

+ }

+

+ function update_schema()

+ {

+ return array();

+ }

+

+ function update_data()

+ {

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_v307 extends phpbb_db_migration

+{

+ function depends_on()

+ {

+ return array('phpbb_db_migration_v307rc2');

+ }

+

+ function update_schema()

+ {

+ return array();

+ }

+

+ function update_data()

+ {

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_v307pl1 extends phpbb_db_migration

+{

+ function depends_on()

+ {

+ return array('phpbb_db_migration_v307');

+ }

+

+ function update_schema()

+ {

+ return array();

+ }

+

+ function update_data()

+ {

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_v307rc1 extends phpbb_db_migration

+{

+ function depends_on()

+ {

+ return array('phpbb_db_migration_v306');

+ }

+

+ 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'),

+ ),

+ ),

+ );

+ }

+

+ function update_data()

+ {

+ // ATOM Feeds

+ set_config('feed_overall', '1');

+ set_config('feed_http_auth', '0');

+ set_config('feed_limit_post', (string) (isset($config['feed_limit']) ? (int) $config['feed_limit'] : 15));

+ set_config('feed_limit_topic', (string) (isset($config['feed_overall_topics_limit']) ? (int) $config['feed_overall_topics_limit'] : 10));

+ set_config('feed_topics_new', (!empty($config['feed_overall_topics']) ? '1' : '0'));

+ set_config('feed_topics_active', (!empty($config['feed_overall_topics']) ? '1' : '0'));

+

+ // Delete all text-templates from the template_data

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

+ WHERE template_filename ' . $db->sql_like_expression($db->any_char . '.txt');

+ _sql($sql, $errored, $error_ary);

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_v307rc2 extends phpbb_db_migration

+{

+ function depends_on()

+ {

+ return array('phpbb_db_migration_v307rc1');

+ }

+

+ function update_schema()

+ {

+ return array();

+ }

+

+ function update_data()

+ {

+ $sql = 'SELECT user_id, user_email, user_email_hash

+ FROM ' . USERS_TABLE . '

+ WHERE user_type <> ' . USER_IGNORE . "

+ AND user_email <> ''";

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

+

+ $i = 0;

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

+ {

+ // 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 ' . $db->sql_build_array('UPDATE', $sql_ary) . '

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

+ _sql($sql, $errored, $error_ary, ($i % 100 == 0));

+

+ ++$i;

+ }

+ }

+ $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_v308 extends phpbb_db_migration

+{

+ function depends_on()

+ {

+ return array('phpbb_db_migration_v308rc1');

+ }

+

+ function update_schema()

+ {

+ return array();

+ }

+

+ function update_data()

+ {

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_v308rc1 extends phpbb_db_migration

+{

+ function depends_on()

+ {

+ return array('phpbb_db_migration_v307pl1');

+ }

+

+ function update_schema()

+ {

+ return array();

+ }

+

+ function update_data()

+ {

+ // Update file extension group names to use language strings.

+ $sql = 'SELECT lang_dir

+ FROM ' . LANG_TABLE;

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

+

+ $extension_groups_updated = array();

+ while ($lang_dir = $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(

+ "{$phpbb_root_path}install/update/new/language/$lang_dir/acp/attachments.$phpEx",

+ "{$phpbb_root_path}language/$lang_dir/install.$phpEx",

+ "{$phpbb_root_path}language/$lang_dir/acp/attachments.$phpEx",

+ );

+

+ 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 ' . $db->sql_build_array('UPDATE', $sql_ary) . "

+ WHERE group_name = '" . $db->sql_escape($lang_val) . "'";

+ _sql($sql, $errored, $error_ary);

+

+ $extension_groups_updated[$lang_key] = true;

+ }

+ }

+ }

+ $db->sql_freeresult($result);

+

+ // Install modules

+ $modules_to_install = array(

+ 'post' => array(

+ 'base' => 'board',

+ 'class' => 'acp',

+ 'title' => 'ACP_POST_SETTINGS',

+ 'auth' => 'acl_a_board',

+ 'cat' => 'ACP_MESSAGES',

+ 'after' => array('message', 'ACP_MESSAGE_SETTINGS')

+ ),

+ );

+

+ _add_modules($modules_to_install);

+

+ // update

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

+ _sql($sql, $errored, $error_ary);

+

+ // add Bing Bot

+ $bot_name = 'Bing [Bot]';

+ $bot_name_clean = utf8_clean_string($bot_name);

+

+ $sql = 'SELECT user_id

+ FROM ' . USERS_TABLE . "

+ WHERE username_clean = '" . $db->sql_escape($bot_name_clean) . "'";

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

+ $bing_already_added = (bool) $db->sql_fetchfield('user_id');

+ $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 = $db->sql_query($sql);

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

+ $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($phpbb_root_path . 'includes/functions_user.' . $phpEx);

+ }

+

+ $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' => $config['default_lang'],

+ 'user_style' => $config['default_style'],

+ 'user_timezone' => 0,

+ 'user_dateformat' => $config['default_dateformat'],

+ 'user_allow_massemail' => 0,

+ );

+

+ $user_id = user_add($user_row);

+

+ $sql = 'INSERT INTO ' . BOTS_TABLE . ' ' . $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,

+ ));

+

+ _sql($sql, $errored, $error_ary);

+ }

+ // end Bing Bot addition

+

+ // Delete shadow topics pointing to not existing topics

+ $batch_size = 500;

+

+ // Set of affected forums we have to resync

+ $sync_forum_ids = array();

+

+ do

+ {

+ $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 = $db->sql_build_query('SELECT', $sql_array);

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

+

+ $topic_ids = array();

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

+ {

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

+

+ $sync_forum_ids[(int) $row['forum_id']] = (int) $row['forum_id'];

+ }

+ $db->sql_freeresult($result);

+

+ if (!empty($topic_ids))

+ {

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

+ WHERE ' . $db->sql_in_set('topic_id', $topic_ids);

+ $db->sql_query($sql);

+ }

+ }

+ while (sizeof($topic_ids) == $batch_size);

+

+ // Sync the forums we have deleted shadow topics from.

+ sync('forum', 'forum_id', $sync_forum_ids, true, true);

+

+ // Unread posts search load switch

+ set_config('load_unreads_search', '1');

+

+ // Reduce queue interval to 60 seconds, email package size to 20

+ if ($config['queue_interval'] == 600)

+ {

+ set_config('queue_interval', '60');

+ }

+

+ if ($config['email_package_size'] == 50)

+ {

+ set_config('email_package_size', '20');

+ }

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_v309 extends phpbb_db_migration

+{

+ function depends_on()

+ {

+ return array('phpbb_db_migration_v309rc4');

+ }

+

+ function update_schema()

+ {

+ return array();

+ }

+

+ function update_data()

+ {

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_v309rc1 extends phpbb_db_migration

+{

+ function depends_on()

+ {

+ return array('phpbb_db_migration_v308');

+ }

+

+ function update_schema()

+ {

+ return array(

+ 'add_tables' => array(

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

+ 'COLUMNS' => array(

+ // this column was removed from the database updater

+ // after 3.0.9-RC3 was released. It might still exist

+ // in 3.0.9-RCX installations and has to be dropped in

+ // 3.0.12 after the db_tools class is capable of properly

+ // removing a primary key.

+ // 'attempt_id' => array('UINT', NULL, 'auto_increment'),

+ 'attempt_ip' => array('VCHAR:40', ''),

+ 'attempt_browser' => array('VCHAR:150', ''),

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

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

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

+ 'username' => array('VCHAR_UNI:255', 0),

+ 'username_clean' => array('VCHAR_CI', 0),

+ ),

+ //'PRIMARY_KEY' => 'attempt_id',

+ 'KEYS' => array(

+ 'att_ip' => array('INDEX', array('attempt_ip', 'attempt_time')),

+ 'att_for' => array('INDEX', array('attempt_forwarded_for', 'attempt_time')),

+ 'att_time' => array('INDEX', array('attempt_time')),

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

+ ),

+ ),

+ ),

+ 'change_columns' => array(

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

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

+ ),

+ ),

+ );

+ }

+

+ function update_data()

+ {

+ set_config('ip_login_limit_max', '50');

+ set_config('ip_login_limit_time', '21600');

+ set_config('ip_login_limit_use_forwarded', '0');

+

+ // Update file extension group names to use language strings, again.

+ $sql = 'SELECT group_id, group_name

+ FROM ' . EXTENSION_GROUPS_TABLE . '

+ WHERE group_name ' . $db->sql_like_expression('EXT_GROUP_' . $db->any_char);

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

+

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

+ {

+ $sql_ary = array(

+ 'group_name' => substr($row['group_name'], 10), // Strip off 'EXT_GROUP_'

+ );

+

+ $sql = 'UPDATE ' . EXTENSION_GROUPS_TABLE . '

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

+ WHERE group_id = ' . $row['group_id'];

+ _sql($sql, $errored, $error_ary);

+ }

+ $db->sql_freeresult($result);

+

+ global $db_tools, $table_prefix;

+

+ // Recover from potentially broken Q&A CAPTCHA table on firebird

+ // Q&A CAPTCHA was uninstallable, so it's safe to remove these

+ // without data loss

+ if ($db_tools->sql_layer == 'firebird')

+ {

+ $tables = array(

+ $table_prefix . 'captcha_questions',

+ $table_prefix . 'captcha_answers',

+ $table_prefix . 'qa_confirm',

+ );

+ foreach ($tables as $table)

+ {

+ if ($db_tools->sql_table_exists($table))

+ {

+ $db_tools->sql_table_drop($table);

+ }

+ }

+ }

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_v309rc2 extends phpbb_db_migration

+{

+ function depends_on()

+ {

+ return array('phpbb_db_migration_v309rc1');

+ }

+

+ function update_schema()

+ {

+ return array();

+ }

+

+ function update_data()

+ {

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_v309rc3 extends phpbb_db_migration

+{

+ function depends_on()

+ {

+ return array('phpbb_db_migration_v309rc2');

+ }

+

+ function update_schema()

+ {

+ return array();

+ }

+

+ function update_data()

+ {

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_v309rc4 extends phpbb_db_migration

+{

+ function depends_on()

+ {

+ return array('phpbb_db_migration_v309rc3');

+ }

+

+ function update_schema()

+ {

+ return array();

+ }

+

+ function update_data()

+ {

+ }

+}