-

-

- case 'mysql':

- case 'mysql4':

- $sql = 'VALUES ' . implode(', ', preg_replace('#^(.*?)$#', '(\1)', $sql_subary));

- break;

-

-<?php

-/**

-*

-* This file is part of the phpBB Forum Software package.

-*

-* @copyright (c) phpBB Limited <https://www.phpbb.com>

-* @license GNU General Public License, version 2 (GPL-2.0)

-*

-* For full copyright and license information, please see

-* the docs/CREDITS.txt file.

-*

-*/

-

-//

-// Security message:

-//

-// This script is potentially dangerous.

-// Remove or comment the next line (die(".... ) to enable this script.

-// Do NOT FORGET to either remove this script or disable it after you have used it.

-//

-die("Please read the first lines of this script for instructions on how to enable it");

-@set_time_limit(300);

-

-$db = $dbhost = $dbuser = $dbpasswd = $dbport = $dbname = '';

-

-define('IN_PHPBB', 1);

-define('ANONYMOUS', 1);

-$phpEx = substr(strrchr(__FILE__, '.'), 1);

-$phpbb_root_path='./../';

-include($phpbb_root_path . 'config.'.$phpEx);

-require($phpbb_root_path . 'includes/acm/acm_' . $acm_type . '.'.$phpEx);

-require($phpbb_root_path . 'includes/db/' . $dbms . '.'.$phpEx);

-include($phpbb_root_path . 'includes/functions.'.$phpEx);

-

-$cache = new acm();

-$db = new sql_db();

-

-// Connect to DB

-$db->sql_connect($dbhost, $dbuser, $dbpasswd, $dbname, $dbport, false);

-

-$start = 0;

-do

-{

- // Batch query for group members, call group_user_del

- $sql = "SELECT user_id, user_email

- FROM {$table_prefix}users

- LIMIT $start, 100";

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

-

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

- {

- do

- {

- $sql = "UPDATE {$table_prefix}users

- SET user_email_hash = " . (crc32(strtolower($row['user_email'])) . strlen($row['user_email'])) . '

- WHERE user_id = ' . $row['user_id'];

- $db->sql_query($sql);

-

- $start++;

- }

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

-

- echo "<br />Batch -> $start\n";

- flush();

- }

- else

- {

- $start = 0;

- }

- $db->sql_freeresult($result);

-}

-while ($start);

-

-echo "<p><b>Done</b></p>\n";

- 'mysql_40',

-<?php

-/**

-*

-* This file is part of the phpBB Forum Software package.

-*

-* @copyright (c) phpBB Limited <https://www.phpbb.com>

-* @license GNU General Public License, version 2 (GPL-2.0)

-*

-* For full copyright and license information, please see

-* the docs/CREDITS.txt file.

-*

-*/

-

-/**

-* This file creates SQL statements to upgrade phpBB on MySQL 3.x/4.0.x to 4.1.x/5.x

-*/

-

-//

-// Security message:

-//

-// This script is potentially dangerous.

-// Remove or comment the next line (die(".... ) to enable this script.

-// Do NOT FORGET to either remove this script or disable it after you have used it.

-//

-die("Please read the first lines of this script for instructions on how to enable it");

-

-define('IN_PHPBB', true);

-$phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './';

-$phpEx = substr(strrchr(__FILE__, '.'), 1);

-include($phpbb_root_path . 'common.' . $phpEx);

-

-$prefix = $table_prefix;

-

-$newline = "\n";

-

-if (PHP_SAPI !== 'cli')

-{

- $newline = '<br>';

-}

-

-$sql = 'DESCRIBE ' . POSTS_TABLE . ' post_text';

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

-

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

-

-$db->sql_freeresult($result);

-

-$mysql_indexer = $drop_index = false;

-

-if (strtolower($row['Type']) === 'mediumtext')

-{

- $mysql_indexer = true;

-}

-

-if (strtolower($row['Key']) === 'mul')

-{

- $drop_index = true;

-}

-

-echo "USE $dbname;$newline$newline";

-

-

-@set_time_limit(0);

-

-$finder = new \phpbb\finder(new \phpbb\filesystem\filesystem(), $phpbb_root_path);

-$classes = $finder->core_path('phpbb/')

- ->directory('/db/migration/data')

- ->get_classes();

-

-$factory = new \phpbb\db\tools\factory();

-$db_tools = $factory->get($db, true);

-

-$schema_generator = new \phpbb\db\migration\schema_generator($classes, $config, $db, $db_tools, $phpbb_root_path, $phpEx, $table_prefix);

-$schema_data = $schema_generator->get_schema();

-$dbms_type_map = \phpbb\db\tools\tools::get_dbms_type_map();

-

-foreach ($schema_data as $table_name => $table_data)

-{

- $table_name = str_replace('phpbb_', $prefix, $table_name);

- // Write comment about table

- echo "# Table: '{$table_name}'$newline";

-

- // Create Table statement

- $generator = $textimage = false;

-

- // Do we need to DROP a fulltext index before we alter the table?

- if ($table_name == ($prefix . 'posts') && $drop_index)

- {

- echo "ALTER TABLE {$table_name}{$newline}";

- echo "DROP INDEX post_text,{$newline}DROP INDEX post_subject,{$newline}DROP INDEX post_content;{$newline}{$newline}";

- }

-

- $line = "ALTER TABLE {$table_name} $newline";

-

- // Table specific so we don't get overlap

- $modded_array = array();

-

- // Write columns one by one...

- foreach ($table_data['COLUMNS'] as $column_name => $column_data)

- {

- // Get type

- if (strpos($column_data[0], ':') !== false)

- {

- list($orig_column_type, $column_length) = explode(':', $column_data[0]);

- $column_type = sprintf($dbms_type_map['mysql_41'][$orig_column_type . ':'], $column_length);

-

- if (isset($dbms_type_map['mysql_40'][$orig_column_type . ':']['limit']) &&

- isset($dbms_type_map['mysql_40'][$orig_column_type . ':']['limit'][0]))

- {

- switch ($dbms_type_map['mysql_40'][$orig_column_type . ':']['limit'][0])

- {

- case 'mult':

- if (($column_length * $dbms_type_map['mysql_40'][$orig_column_type . ':']['limit'][1]) > $dbms_type_map['mysql_40'][$orig_column_type . ':']['limit'][2])

- {

- $modded_array[$column_name] = $column_type;

- }

- break;

- }

- }

-

- $orig_column_type .= ':';

- }

- else

- {

- $orig_column_type = $column_data[0];

- $other_column_type = $dbms_type_map['mysql_40'][$column_data[0]];

- if ($other_column_type == 'text' || $other_column_type == 'blob')

- {

- $modded_array[$column_name] = $column_type;

- }

- $column_type = $dbms_type_map['mysql_41'][$column_data[0]];

- }

-

- // Adjust default value if db-dependent specified

- if (is_array($column_data[1]))

- {

- $column_data[1] = (isset($column_data[1][$dbms])) ? $column_data[1][$dbms] : $column_data[1]['default'];

- }

-

- $line .= "\tMODIFY {$column_name} {$column_type} ";

-

- // For hexadecimal values do not use single quotes

- if (!is_null($column_data[1]) && substr($column_type, -4) !== 'text' && substr($column_type, -4) !== 'blob')

- {

- $line .= (strpos($column_data[1], '0x') === 0) ? "DEFAULT {$column_data[1]} " : "DEFAULT '{$column_data[1]}' ";

- }

- $line .= 'NOT NULL';

-

- if (isset($column_data[2]))

- {

- if ($column_data[2] == 'auto_increment')

- {

- $line .= ' auto_increment';

- }

- else if ($column_data[2] == 'true_sort')

- {

- $line .= ' COLLATE utf8_unicode_ci';

- }

- else if ($column_data[2] == 'no_sort')

- {

- $line .= ' COLLATE utf8_bin';

- }

- }

- else if (preg_match('/(?:var)?char|(?:medium)?text/i', $column_type))

- {

- $line .= ' COLLATE utf8_bin';

- }

-

- $line .= ",$newline";

- }

-

- // Write Keys

- if (isset($table_data['KEYS']))

- {

- foreach ($table_data['KEYS'] as $key_name => $key_data)

- {

- $temp = '';

- if (!is_array($key_data[1]))

- {

- $key_data[1] = array($key_data[1]);

- }

-

- $temp .= ($key_data[0] == 'INDEX') ? "\tADD KEY" : '';

- $temp .= ($key_data[0] == 'UNIQUE') ? "\tADD UNIQUE" : '';

- $repair = false;

- foreach ($key_data[1] as $key => $col_name)

- {

- if (isset($modded_array[$col_name]))

- {

- $repair = true;

- }

- }

- if ($repair)

- {

- $line .= "\tDROP INDEX " . $key_name . ",$newline";

- $line .= $temp;

- $line .= ' ' . $key_name . ' (' . implode(', ', $key_data[1]) . "),$newline";

- }

- }

- }

-

- //$line .= "\tCONVERT TO CHARACTER SET `utf8`$newline";

- $line .= "\tDEFAULT CHARSET=utf8 COLLATE=utf8_bin;$newline$newline";

-

- echo $line . "$newline";

-

- // Do we now need to re-add the fulltext index? ;)

- if ($table_name == ($prefix . 'posts') && $drop_index)

- {

- echo "ALTER TABLE $table_name ADD FULLTEXT (post_subject), ADD FULLTEXT (post_text), ADD FULLTEXT post_content (post_subject, post_text);{$newline}";

- }

-}

-

-// IP regular expressions

-

-$dec_octet = '(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])';

-$h16 = '[\dA-F]{1,4}';

-$ipv4 = "(?:$dec_octet\.){3}$dec_octet";

-$ls32 = "(?:$h16:$h16|$ipv4)";

-

-$ipv6_construct = array(

- array(false, '', '{6}', $ls32),

- array(false, '::', '{0,5}', "(?:$h16(?::$h16)?|$ipv4)"),

- array('', ':', '{4}', $ls32),

- array('{1,2}', ':', '{3}', $ls32),

- array('{1,3}', ':', '{2}', $ls32),

- array('{1,4}', ':', '', $ls32),

- array('{1,5}', ':', false, $ls32),

- array('{1,6}', ':', false, $h16),

- array('{1,7}', ':', false, ''),

- array(false, '::', false, '')

-);

-

-$ipv6 = '(?:';

-foreach ($ipv6_construct as $ip_type)

-{

- $ipv6 .= '(?:';

- if ($ip_type[0] !== false)

- {

- $ipv6 .= "(?:$h16:)" . $ip_type[0];

- }

- $ipv6 .= $ip_type[1];

- if ($ip_type[2] !== false)

- {

- $ipv6 .= "(?:$h16:)" . $ip_type[2];

- }

- $ipv6 .= $ip_type[3] . ')|';

-}

-$ipv6 = substr($ipv6, 0, -1) . ')';

-

-echo 'IPv4: ' . $ipv4 . "<br />\nIPv6: " . $ipv6 . "<br />\n";

-

-// IP regular expressions

-

-$dec_octet = '(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])';

-$h16 = '[\dA-F]{1,4}';

-$ipv4 = "(?:$dec_octet\.){3}$dec_octet";

-$ls32 = "(?:$h16:$h16|$ipv4)";

-

-$ipv6_construct = array(

- array(false, '', '{6}', $ls32),

- array(false, '::', '{0,5}', "(?:$h16(?::$h16)?|$ipv4)"),

- array('', ':', '{4}', $ls32),

- array('{1,2}', ':', '{3}', $ls32),

- array('{1,3}', ':', '{2}', $ls32),

- array('{1,4}', ':', '', $ls32),

- array('{1,5}', ':', false, $ls32),

- array('{1,6}', ':', false, $h16),

- array('{1,7}', ':', false, ''),

- array(false, '::', false, '')

-);

-

-$ipv6 = '(?:';

-foreach ($ipv6_construct as $ip_type)

-{

- $ipv6 .= '(?:';

- if ($ip_type[0] !== false)

- {

- $ipv6 .= "(?:$h16:)" . $ip_type[0];

- }

- $ipv6 .= $ip_type[1];

- if ($ip_type[2] !== false)

- {

- $ipv6 .= "(?:$h16:)" . $ip_type[2];

- }

- $ipv6 .= $ip_type[3] . ')|';

-}

-$ipv6 = substr($ipv6, 0, -1) . ')';

-

-echo 'IPv4: ' . $ipv4 . "<br /><br />\n\nIPv6: " . $ipv6 . "<br /><br />\n\n";

-

-$no_ancient_greek_musical = '\x{1D200}-\x{1D24F}'; // \p{block=Ancient_Greek_Musical_Notation}

-<?php

-/**

-* Corrects user_email_hash values if DB moved from 32-bit system to 64-bit system or vice versa.

-* The CRC32 function in PHP generates different results for both systems.

-* @PHP dev team: no, a hexdec() applied to it does not solve the issue. And please document it.

-*

-*/

-die("Please read the first lines of this script for instructions on how to enable it");

-

-set_time_limit(0);

-

-define('IN_PHPBB', true);

-$phpbb_root_path = './../';

-$phpEx = substr(strrchr(__FILE__, '.'), 1);

-include($phpbb_root_path . 'common.' . $phpEx);

-

-// Start session management

-$user->session_begin();

-$auth->acl($user->data);

-$user->setup();

-

-$start = $request->variable('start', 0);

-$num_items = 1000;

-

-echo '<br />Updating user email hashes' . "\n";

-

-$sql = 'SELECT user_id, user_email

- FROM ' . USERS_TABLE . '

- ORDER BY user_id ASC';

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

-

-$echos = 0;

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

-{

- $echos++;

-

- $sql = 'UPDATE ' . USERS_TABLE . "

- SET user_email_hash = '" . $db->sql_escape(phpbb_email_hash($row['user_email'])) . "'

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

- $db->sql_query($sql);

-

- if ($echos == 200)

- {

- echo '<br />';

- $echos = 0;

- }

-

- echo '.';

- flush();

-}

-$db->sql_freeresult($result);

-

-echo 'FINISHED';

-

-// Done

-$db->sql_close();