+ $root_path = (defined('PHPBB_USE_BOARD_URL_PATH') && PHPBB_USE_BOARD_URL_PATH) ? generate_board_url() . '/' : $this->path_helper->get_web_root_path();

+

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

+ $root_path = (defined('PHPBB_USE_BOARD_URL_PATH') && PHPBB_USE_BOARD_URL_PATH) ? generate_board_url() . '/' : $this->path_helper->get_web_root_path();

+

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

+ global $config, $db, $user;

+ global $db;

+ global $user;

+ return;

+ return;

+ global $config, $request, $phpbb_log, $template, $user;

+ $question_input = $this->acp_get_question_input();

+ 'QUESTION_TEXT' => ($question_input['question_text']) ? $question_input['question_text'] : $question['question_text'],

+ 'LANG_ISO' => ($question_input['lang_iso']) ? $question_input['lang_iso'] : $question['lang_iso'],

+ 'STRICT' => (isset($_REQUEST['strict'])) ? $question_input['strict'] : $question['strict'],

+ 'ANSWERS' => implode("\n", $question['answers']),

+ 'QUESTION_TEXT' => $question_input['question_text'],

+ 'LANG_ISO' => $question_input['lang_iso'],

+ 'STRICT' => $question_input['strict'],

+ 'ANSWERS' => (is_array($question_input['answers'])) ? implode("\n", $question_input['answers']) : '',

+ if (!$this->validate_input($question_input))

+ $this->acp_update_question($question_input, $question_id);

+ $this->acp_add_question($question_input);

+

+ return false;

+

+ // Convert answers into array and filter if answers are set

+ if (strlen($answers))

+ {

+ $answers = array_filter(array_map('trim', explode("\n", $answers)), function ($value) {

+ return $value !== '';

+ });

+ }

+

+ 'answers' => $answers,

+ return $where_sql . $this->db->sql_in_set($table_alias . 'forum_id', $approve_forums) . ')';

+ return $where_sql . $table_alias . $mode . '_visibility = ' . ITEM_APPROVED . '

+ AND ' . $this->db->sql_in_set($table_alias . 'forum_id', $forum_ids, false, true) . ')';

+ // Append page name if base URL does not contain it

+ if (!empty($page_name) && strpos($base_url, '/' . $page_name) === false)

+ {

+ $base_url .= '/' . $page_name;

+ }

+

+<?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.

+*

+*/

+

+namespace phpbb\db\extractor;

+

+use phpbb\db\extractor\exception\invalid_format_exception;

+use phpbb\db\extractor\exception\extractor_not_initialized_exception;

+

+/**

+ * Abstract base class for database extraction

+ */

+abstract class base_extractor implements extractor_interface

+{

+ /**

+ * @var string phpBB root path

+ */

+ protected $phpbb_root_path;

+

+ /**

+ * @var \phpbb\request\request_interface

+ */

+ protected $request;

+

+ /**

+ * @var \phpbb\db\driver\driver_interface

+ */

+ protected $db;

+

+ /**

+ * @var bool

+ */

+ protected $download;

+

+ /**

+ * @var bool

+ */

+ protected $store;

+

+ /**

+ * @var int

+ */

+ protected $time;

+

+ /**

+ * @var string

+ */

+ protected $format;

+

+ /**

+ * @var resource

+ */

+ protected $fp;

+

+ /**

+ * @var string

+ */

+ protected $write;

+

+ /**

+ * @var string

+ */

+ protected $close;

+

+ /**

+ * @var bool

+ */

+ protected $run_comp;

+

+ /**

+ * @var bool

+ */

+ protected $is_initialized;

+

+ /**

+ * Constructor

+ *

+ * @param string $phpbb_root_path

+ * @param \phpbb\request\request_interface $request

+ * @param \phpbb\db\driver\driver_interface $db

+ */

+ public function __construct($phpbb_root_path, \phpbb\request\request_interface $request, \phpbb\db\driver\driver_interface $db)

+ {

+ $this->phpbb_root_path = $phpbb_root_path;

+ $this->request = $request;

+ $this->db = $db;

+ $this->fp = null;

+

+ $this->is_initialized = false;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function init_extractor($format, $filename, $time, $download = false, $store = false)

+ {

+ $this->download = $download;

+ $this->store = $store;

+ $this->time = $time;

+ $this->format = $format;

+

+ switch ($format)

+ {

+ case 'text':

+ $ext = '.sql';

+ $open = 'fopen';

+ $this->write = 'fwrite';

+ $this->close = 'fclose';

+ $mimetype = 'text/x-sql';

+ break;

+ case 'bzip2':

+ $ext = '.sql.bz2';

+ $open = 'bzopen';

+ $this->write = 'bzwrite';

+ $this->close = 'bzclose';

+ $mimetype = 'application/x-bzip2';

+ break;

+ case 'gzip':

+ $ext = '.sql.gz';

+ $open = 'gzopen';

+ $this->write = 'gzwrite';

+ $this->close = 'gzclose';

+ $mimetype = 'application/x-gzip';

+ break;

+ default:

+ throw new invalid_format_exception();

+ break;

+ }

+

+ if ($download === true)

+ {

+ $name = $filename . $ext;

+ header('Cache-Control: private, no-cache');

+ header("Content-Type: $mimetype; name=\"$name\"");

+ header("Content-disposition: attachment; filename=$name");

+

+ switch ($format)

+ {

+ case 'bzip2':

+ ob_start();

+ break;

+

+ case 'gzip':

+ if (strpos($this->request->header('Accept-Encoding'), 'gzip') !== false && strpos(strtolower($this->request->header('User-Agent')), 'msie') === false)

+ {

+ ob_start('ob_gzhandler');

+ }

+ else

+ {

+ $this->run_comp = true;

+ }

+ break;

+ }

+ }

+

+ if ($store === true)

+ {

+ $file = $this->phpbb_root_path . 'store/' . $filename . $ext;

+

+ $this->fp = $open($file, 'w');

+

+ if (!$this->fp)

+ {

+ trigger_error('FILE_WRITE_FAIL', E_USER_ERROR);

+ }

+ }

+

+ $this->is_initialized = true;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function write_end()

+ {

+ static $close;

+

+ if (!$this->is_initialized)

+ {

+ throw new extractor_not_initialized_exception();

+ }

+

+ if ($this->store)

+ {

+ if ($close === null)

+ {

+ $close = $this->close;

+ }

+ $close($this->fp);

+ }

+

+ // bzip2 must be written all the way at the end

+ if ($this->download && $this->format === 'bzip2')

+ {

+ $c = ob_get_clean();

+ echo bzcompress($c);

+ }

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function flush($data)

+ {

+ static $write;

+

+ if (!$this->is_initialized)

+ {

+ throw new extractor_not_initialized_exception();

+ }

+

+ if ($this->store === true)

+ {

+ if ($write === null)

+ {

+ $write = $this->write;

+ }

+ $write($this->fp, $data);

+ }

+

+ if ($this->download === true)

+ {

+ if ($this->format === 'bzip2' || $this->format === 'text' || ($this->format === 'gzip' && !$this->run_comp))

+ {

+ echo $data;

+ }

+

+ // we can write the gzip data as soon as we get it

+ if ($this->format === 'gzip')

+ {

+ if ($this->run_comp)

+ {

+ echo gzencode($data);

+ }

+ else

+ {

+ ob_flush();

+ flush();

+ }

+ }

+ }

+ }

+}

+<?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.

+*

+*/

+

+namespace phpbb\db\extractor\exception;

+

+use phpbb\exception\runtime_exception;

+

+/**

+* This exception is thrown when invalid format is given to the extractor

+*/

+class extractor_not_initialized_exception extends runtime_exception

+{

+

+}

+<?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.

+*

+*/

+

+namespace phpbb\db\extractor\exception;

+

+/**

+* This exception is thrown when invalid format is given to the extractor

+*/

+class invalid_format_exception extends \InvalidArgumentException

+{

+

+}

+<?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.

+*

+*/

+

+namespace phpbb\db\extractor;

+

+/**

+* Database extractor interface

+*/

+interface extractor_interface

+{

+ /**

+ * Start the extraction of the database

+ *

+ * This function initialize the database extraction. It is required to call this

+ * function before calling any other extractor functions.

+ *

+ * @param string $format

+ * @param string $filename

+ * @param int $time

+ * @param bool $download

+ * @param bool $store

+ * @return null

+ * @throws \phpbb\db\extractor\exception\invalid_format_exception when $format is invalid

+ */

+ public function init_extractor($format, $filename, $time, $download = false, $store = false);

+

+ /**

+ * Writes header comments to the database backup

+ *

+ * @param string $table_prefix prefix of phpBB database tables

+ * @return null

+ * @throws \phpbb\db\extractor\exception\extractor_not_initialized_exception when calling this function before init_extractor()

+ */

+ public function write_start($table_prefix);

+

+ /**

+ * Closes file and/or dumps download data

+ *

+ * @return null

+ * @throws \phpbb\db\extractor\exception\extractor_not_initialized_exception when calling this function before init_extractor()

+ */

+ public function write_end();

+

+ /**

+ * Extracts database table structure

+ *

+ * @param string $table_name name of the database table

+ * @return null

+ * @throws \phpbb\db\extractor\exception\extractor_not_initialized_exception when calling this function before init_extractor()

+ */

+ public function write_table($table_name);

+

+ /**

+ * Extracts data from database table

+ *

+ * @param string $table_name name of the database table

+ * @return null

+ * @throws \phpbb\db\extractor\exception\extractor_not_initialized_exception when calling this function before init_extractor()

+ */

+ public function write_data($table_name);

+

+ /**

+ * Writes data to file/download content

+ *

+ * @param string $data

+ * @return null

+ * @throws \phpbb\db\extractor\exception\extractor_not_initialized_exception when calling this function before init_extractor()

+ */

+ public function flush($data);

+}

+<?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.

+*

+*/

+

+namespace phpbb\db\extractor;

+

+/**

+* A factory which serves the suitable extractor instance for the given dbal

+*/

+class factory

+{

+ /**

+ * @var \phpbb\db\driver\driver_interface

+ */

+ protected $db;

+

+ /**

+ * @var \Symfony\Component\DependencyInjection\ContainerInterface

+ */

+ protected $container;

+

+ /**

+ * Extractor factory constructor

+ *

+ * @param \phpbb\db\driver\driver_interface $db

+ * @param \Symfony\Component\DependencyInjection\ContainerInterface $container

+ */

+ public function __construct(\phpbb\db\driver\driver_interface $db, \Symfony\Component\DependencyInjection\ContainerInterface $container)

+ {

+ $this->db = $db;

+ $this->container = $container;

+ }

+

+ /**

+ * DB extractor factory getter

+ *

+ * @return \phpbb\db\extractor\extractor_interface an appropriate instance of the database extractor for the used database driver

+ * @throws \InvalidArgumentException when the database driver is unknown

+ */

+ public function get()

+ {

+ // Return the appropriate DB extractor

+ if ($this->db instanceof \phpbb\db\driver\mssql || $this->db instanceof \phpbb\db\driver\mssql_base)

+ {

+ return $this->container->get('dbal.extractor.extractors.mssql_extractor');

+ }

+ else if ($this->db instanceof \phpbb\db\driver\mysql_base)

+ {

+ return $this->container->get('dbal.extractor.extractors.mysql_extractor');

+ }

+ else if ($this->db instanceof \phpbb\db\driver\oracle)

+ {

+ return $this->container->get('dbal.extractor.extractors.oracle_extractor');

+ }

+ else if ($this->db instanceof \phpbb\db\driver\postgres)

+ {

+ return $this->container->get('dbal.extractor.extractors.postgres_extractor');

+ }

+ else if ($this->db instanceof \phpbb\db\driver\sqlite)

+ {

+ return $this->container->get('dbal.extractor.extractors.sqlite_extractor');

+ }

+ else if ($this->db instanceof \phpbb\db\driver\sqlite3)

+ {

+ return $this->container->get('dbal.extractor.extractors.sqlite3_extractor');

+ }

+

+ throw new \InvalidArgumentException('Invalid database driver given');

+ }

+}

+<?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.

+*

+*/

+

+namespace phpbb\db\extractor;

+

+use phpbb\db\extractor\exception\extractor_not_initialized_exception;

+

+class mssql_extractor extends base_extractor

+{

+ /**

+ * Writes closing line(s) to database backup

+ *

+ * @return null

+ * @throws \phpbb\db\extractor\exception\extractor_not_initialized_exception when calling this function before init_extractor()

+ */

+ public function write_end()

+ {

+ if (!$this->is_initialized)

+ {

+ throw new extractor_not_initialized_exception();

+ }

+

+ $this->flush("COMMIT\nGO\n");

+ parent::write_end();

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function write_start($table_prefix)

+ {

+ if (!$this->is_initialized)

+ {

+ throw new extractor_not_initialized_exception();

+ }

+

+ $sql_data = "--\n";

+ $sql_data .= "-- phpBB Backup Script\n";

+ $sql_data .= "-- Dump of tables for $table_prefix\n";

+ $sql_data .= "-- DATE : " . gmdate("d-m-Y H:i:s", $this->time) . " GMT\n";

+ $sql_data .= "--\n";

+ $sql_data .= "BEGIN TRANSACTION\n";

+ $sql_data .= "GO\n";

+ $this->flush($sql_data);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function write_table($table_name)

+ {

+ if (!$this->is_initialized)

+ {

+ throw new extractor_not_initialized_exception();

+ }

+

+ $sql_data = '-- Table: ' . $table_name . "\n";

+ $sql_data .= "IF OBJECT_ID(N'$table_name', N'U') IS NOT NULL\n";

+ $sql_data .= "DROP TABLE $table_name;\n";

+ $sql_data .= "GO\n";

+ $sql_data .= "\nCREATE TABLE [$table_name] (\n";

+ $rows = array();

+

+ $text_flag = false;

+

+ $sql = "SELECT COLUMN_NAME, COLUMN_DEFAULT, IS_NULLABLE, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, COLUMNPROPERTY(object_id(TABLE_NAME), COLUMN_NAME, 'IsIdentity') as IS_IDENTITY

+ FROM INFORMATION_SCHEMA.COLUMNS

+ WHERE TABLE_NAME = '$table_name'";

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

+

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

+ {

+ $line = "\t[{$row['COLUMN_NAME']}] [{$row['DATA_TYPE']}]";

+

+ if ($row['DATA_TYPE'] == 'text')

+ {

+ $text_flag = true;

+ }

+

+ if ($row['IS_IDENTITY'])

+ {

+ $line .= ' IDENTITY (1 , 1)';

+ }

+

+ if ($row['CHARACTER_MAXIMUM_LENGTH'] && $row['DATA_TYPE'] !== 'text')

+ {

+ $line .= ' (' . $row['CHARACTER_MAXIMUM_LENGTH'] . ')';

+ }

+

+ if ($row['IS_NULLABLE'] == 'YES')

+ {

+ $line .= ' NULL';

+ }

+ else

+ {

+ $line .= ' NOT NULL';

+ }

+

+ if ($row['COLUMN_DEFAULT'])

+ {

+ $line .= ' DEFAULT ' . $row['COLUMN_DEFAULT'];

+ }

+

+ $rows[] = $line;

+ }

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

+

+ $sql_data .= implode(",\n", $rows);

+ $sql_data .= "\n) ON [PRIMARY]";

+

+ if ($text_flag)

+ {

+ $sql_data .= " TEXTIMAGE_ON [PRIMARY]";

+ }

+

+ $sql_data .= "\nGO\n\n";

+ $rows = array();

+

+ $sql = "SELECT CONSTRAINT_NAME, COLUMN_NAME

+ FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE

+ WHERE TABLE_NAME = '$table_name'";

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

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

+ {

+ if (!sizeof($rows))

+ {

+ $sql_data .= "ALTER TABLE [$table_name] WITH NOCHECK ADD\n";

+ $sql_data .= "\tCONSTRAINT [{$row['CONSTRAINT_NAME']}] PRIMARY KEY CLUSTERED \n\t(\n";

+ }

+ $rows[] = "\t\t[{$row['COLUMN_NAME']}]";

+ }

+ if (sizeof($rows))

+ {

+ $sql_data .= implode(",\n", $rows);

+ $sql_data .= "\n\t) ON [PRIMARY] \nGO\n";

+ }

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

+

+ $index = array();

+ $sql = "EXEC sp_statistics '$table_name'";

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

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

+ {

+ if ($row['TYPE'] == 3)

+ {

+ $index[$row['INDEX_NAME']][] = '[' . $row['COLUMN_NAME'] . ']';

+ }

+ }

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

+

+ foreach ($index as $index_name => $column_name)

+ {

+ $index[$index_name] = implode(', ', $column_name);

+ }

+

+ foreach ($index as $index_name => $columns)

+ {

+ $sql_data .= "\nCREATE INDEX [$index_name] ON [$table_name]($columns) ON [PRIMARY]\nGO\n";

+ }

+ $this->flush($sql_data);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function write_data($table_name)

+ {

+ if (!$this->is_initialized)

+ {

+ throw new extractor_not_initialized_exception();

+ }

+

+ if ($this->db->get_sql_layer() === 'mssql')

+ {

+ $this->write_data_mssql($table_name);

+ }

+ else if($this->db->get_sql_layer() === 'mssqlnative')

+ {

+ $this->write_data_mssqlnative($table_name);

+ }

+ else

+ {

+ $this->write_data_odbc($table_name);

+ }

+ }

+

+ /**

+ * Extracts data from database table (for MSSQL driver)

+ *

+ * @param string $table_name name of the database table

+ * @return null

+ * @throws \phpbb\db\extractor\exception\extractor_not_initialized_exception when calling this function before init_extractor()

+ */

+ protected function write_data_mssql($table_name)

+ {

+ if (!$this->is_initialized)

+ {

+ throw new extractor_not_initialized_exception();

+ }

+

+ $ary_type = $ary_name = array();

+ $ident_set = false;

+ $sql_data = '';

+

+ // Grab all of the data from current table.

+ $sql = "SELECT *

+ FROM $table_name";

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

+

+ $retrieved_data = mssql_num_rows($result);

+

+ $i_num_fields = mssql_num_fields($result);

+

+ for ($i = 0; $i < $i_num_fields; $i++)

+ {

+ $ary_type[$i] = mssql_field_type($result, $i);

+ $ary_name[$i] = mssql_field_name($result, $i);

+ }

+

+ if ($retrieved_data)

+ {

+ $sql = "SELECT 1 as has_identity

+ FROM INFORMATION_SCHEMA.COLUMNS

+ WHERE COLUMNPROPERTY(object_id('$table_name'), COLUMN_NAME, 'IsIdentity') = 1";

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

+ $row2 = $this->db->sql_fetchrow($result2);

+ if (!empty($row2['has_identity']))

+ {

+ $sql_data .= "\nSET IDENTITY_INSERT $table_name ON\nGO\n";

+ $ident_set = true;

+ }

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

+ }

+

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

+ {

+ $schema_vals = $schema_fields = array();

+

+ // Build the SQL statement to recreate the data.

+ for ($i = 0; $i < $i_num_fields; $i++)

+ {

+ $str_val = $row[$ary_name[$i]];

+

+ if (preg_match('#char|text|bool|varbinary#i', $ary_type[$i]))

+ {

+ $str_quote = '';

+ $str_empty = "''";

+ $str_val = sanitize_data_mssql(str_replace("'", "''", $str_val));

+ }

+ else if (preg_match('#date|timestamp#i', $ary_type[$i]))

+ {

+ if (empty($str_val))

+ {

+ $str_quote = '';

+ }

+ else

+ {

+ $str_quote = "'";

+ }

+ }

+ else

+ {

+ $str_quote = '';

+ $str_empty = 'NULL';

+ }

+

+ if (empty($str_val) && $str_val !== '0' && !(is_int($str_val) || is_float($str_val)))

+ {

+ $str_val = $str_empty;

+ }

+

+ $schema_vals[$i] = $str_quote . $str_val . $str_quote;

+ $schema_fields[$i] = $ary_name[$i];

+ }

+

+ // Take the ordered fields and their associated data and build it

+ // into a valid sql statement to recreate that field in the data.

+ $sql_data .= "INSERT INTO $table_name (" . implode(', ', $schema_fields) . ') VALUES (' . implode(', ', $schema_vals) . ");\nGO\n";

+

+ $this->flush($sql_data);

+ $sql_data = '';

+ }

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

+

+ if ($retrieved_data && $ident_set)

+ {

+ $sql_data .= "\nSET IDENTITY_INSERT $table_name OFF\nGO\n";

+ }

+ $this->flush($sql_data);

+ }

+

+ /**

+ * Extracts data from database table (for MSSQL Native driver)

+ *

+ * @param string $table_name name of the database table

+ * @return null

+ * @throws \phpbb\db\extractor\exception\extractor_not_initialized_exception when calling this function before init_extractor()

+ */

+ protected function write_data_mssqlnative($table_name)

+ {

+ if (!$this->is_initialized)

+ {

+ throw new extractor_not_initialized_exception();

+ }

+

+ $ary_type = $ary_name = array();

+ $ident_set = false;

+ $sql_data = '';

+

+ // Grab all of the data from current table.

+ $sql = "SELECT * FROM $table_name";

+ $this->db->mssqlnative_set_query_options(array('Scrollable' => SQLSRV_CURSOR_STATIC));

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

+

+ $retrieved_data = $this->db->mssqlnative_num_rows($result);

+

+ if (!$retrieved_data)

+ {

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

+ return;

+ }

+

+ $sql = "SELECT COLUMN_NAME, DATA_TYPE

+ FROM INFORMATION_SCHEMA.COLUMNS

+ WHERE INFORMATION_SCHEMA.COLUMNS.TABLE_NAME = '" . $this->db->sql_escape($table_name) . "'";

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

+

+ $i_num_fields = 0;

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

+ {

+ $ary_type[$i_num_fields] = $row['DATA_TYPE'];

+ $ary_name[$i_num_fields] = $row['COLUMN_NAME'];

+ $i_num_fields++;

+ }

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

+

+ $sql = "SELECT 1 as has_identity

+ FROM INFORMATION_SCHEMA.COLUMNS

+ WHERE COLUMNPROPERTY(object_id('$table_name'), COLUMN_NAME, 'IsIdentity') = 1";

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

+ $row2 = $this->db->sql_fetchrow($result2);

+

+ if (!empty($row2['has_identity']))

+ {

+ $sql_data .= "\nSET IDENTITY_INSERT $table_name ON\nGO\n";

+ $ident_set = true;

+ }

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

+

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

+ {

+ $schema_vals = $schema_fields = array();

+

+ // Build the SQL statement to recreate the data.

+ for ($i = 0; $i < $i_num_fields; $i++)

+ {

+ $str_val = $row[$ary_name[$i]];

+

+ // defaults to type number - better quote just to be safe, so check for is_int too

+ if (is_int($ary_type[$i]) || preg_match('#char|text|bool|varbinary#i', $ary_type[$i]))

+ {

+ $str_quote = '';

+ $str_empty = "''";

+ $str_val = sanitize_data_mssql(str_replace("'", "''", $str_val));

+ }

+ else if (preg_match('#date|timestamp#i', $ary_type[$i]))

+ {

+ if (empty($str_val))

+ {

+ $str_quote = '';

+ }

+ else

+ {

+ $str_quote = "'";

+ }

+ }

+ else

+ {

+ $str_quote = '';

+ $str_empty = 'NULL';

+ }

+

+ if (empty($str_val) && $str_val !== '0' && !(is_int($str_val) || is_float($str_val)))

+ {

+ $str_val = $str_empty;

+ }

+

+ $schema_vals[$i] = $str_quote . $str_val . $str_quote;

+ $schema_fields[$i] = $ary_name[$i];

+ }

+

+ // Take the ordered fields and their associated data and build it

+ // into a valid sql statement to recreate that field in the data.

+ $sql_data .= "INSERT INTO $table_name (" . implode(', ', $schema_fields) . ') VALUES (' . implode(', ', $schema_vals) . ");\nGO\n";

+

+ $this->flush($sql_data);

+ $sql_data = '';

+ }

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

+

+ if ($ident_set)

+ {

+ $sql_data .= "\nSET IDENTITY_INSERT $table_name OFF\nGO\n";

+ }

+ $this->flush($sql_data);

+ }

+

+ /**

+ * Extracts data from database table (for ODBC driver)

+ *

+ * @param string $table_name name of the database table

+ * @return null

+ * @throws \phpbb\db\extractor\exception\extractor_not_initialized_exception when calling this function before init_extractor()

+ */

+ protected function write_data_odbc($table_name)

+ {

+ if (!$this->is_initialized)

+ {

+ throw new extractor_not_initialized_exception();

+ }

+

+ $ary_type = $ary_name = array();

+ $ident_set = false;

+ $sql_data = '';

+

+ // Grab all of the data from current table.

+ $sql = "SELECT *

+ FROM $table_name";

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

+

+ $retrieved_data = odbc_num_rows($result);

+

+ if ($retrieved_data)

+ {

+ $sql = "SELECT 1 as has_identity

+ FROM INFORMATION_SCHEMA.COLUMNS

+ WHERE COLUMNPROPERTY(object_id('$table_name'), COLUMN_NAME, 'IsIdentity') = 1";

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

+ $row2 = $this->db->sql_fetchrow($result2);

+ if (!empty($row2['has_identity']))

+ {

+ $sql_data .= "\nSET IDENTITY_INSERT $table_name ON\nGO\n";

+ $ident_set = true;

+ }

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

+ }

+

+ $i_num_fields = odbc_num_fields($result);

+

+ for ($i = 0; $i < $i_num_fields; $i++)

+ {

+ $ary_type[$i] = odbc_field_type($result, $i + 1);

+ $ary_name[$i] = odbc_field_name($result, $i + 1);

+ }

+

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

+ {

+ $schema_vals = $schema_fields = array();

+

+ // Build the SQL statement to recreate the data.

+ for ($i = 0; $i < $i_num_fields; $i++)

+ {

+ $str_val = $row[$ary_name[$i]];

+

+ if (preg_match('#char|text|bool|varbinary#i', $ary_type[$i]))

+ {

+ $str_quote = '';

+ $str_empty = "''";

+ $str_val = sanitize_data_mssql(str_replace("'", "''", $str_val));

+ }

+ else if (preg_match('#date|timestamp#i', $ary_type[$i]))

+ {

+ if (empty($str_val))

+ {

+ $str_quote = '';

+ }

+ else

+ {

+ $str_quote = "'";

+ }

+ }

+ else

+ {

+ $str_quote = '';

+ $str_empty = 'NULL';

+ }

+

+ if (empty($str_val) && $str_val !== '0' && !(is_int($str_val) || is_float($str_val)))

+ {

+ $str_val = $str_empty;

+ }

+

+ $schema_vals[$i] = $str_quote . $str_val . $str_quote;

+ $schema_fields[$i] = $ary_name[$i];

+ }

+

+ // Take the ordered fields and their associated data and build it

+ // into a valid sql statement to recreate that field in the data.

+ $sql_data .= "INSERT INTO $table_name (" . implode(', ', $schema_fields) . ') VALUES (' . implode(', ', $schema_vals) . ");\nGO\n";

+

+ $this->flush($sql_data);

+

+ $sql_data = '';

+

+ }

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

+

+ if ($retrieved_data && $ident_set)

+ {

+ $sql_data .= "\nSET IDENTITY_INSERT $table_name OFF\nGO\n";

+ }

+ $this->flush($sql_data);

+ }

+}

+<?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.

+*

+*/

+

+namespace phpbb\db\extractor;

+

+use phpbb\db\extractor\exception\extractor_not_initialized_exception;

+

+class mysql_extractor extends base_extractor

+{

+ /**

+ * {@inheritdoc}

+ */

+ public function write_start($table_prefix)

+ {

+ if (!$this->is_initialized)

+ {

+ throw new extractor_not_initialized_exception();

+ }

+

+ $sql_data = "#\n";

+ $sql_data .= "# phpBB Backup Script\n";

+ $sql_data .= "# Dump of tables for $table_prefix\n";

+ $sql_data .= "# DATE : " . gmdate("d-m-Y H:i:s", $this->time) . " GMT\n";

+ $sql_data .= "#\n";

+ $this->flush($sql_data);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function write_table($table_name)

+ {

+ static $new_extract;

+

+ if (!$this->is_initialized)

+ {

+ throw new extractor_not_initialized_exception();

+ }

+

+ if ($new_extract === null)

+ {

+ if ($this->db->get_sql_layer() === 'mysqli' || version_compare($this->db->sql_server_info(true), '3.23.20', '>='))

+ {

+ $new_extract = true;

+ }

+ else

+ {

+ $new_extract = false;

+ }

+ }

+

+ if ($new_extract)

+ {

+ $this->new_write_table($table_name);

+ }

+ else

+ {

+ $this->old_write_table($table_name);

+ }

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function write_data($table_name)

+ {

+ if (!$this->is_initialized)

+ {

+ throw new extractor_not_initialized_exception();

+ }

+

+ if ($this->db->get_sql_layer() === 'mysqli')

+ {

+ $this->write_data_mysqli($table_name);

+ }

+ else

+ {

+ $this->write_data_mysql($table_name);

+ }

+ }

+

+ /**

+ * Extracts data from database table (for MySQLi driver)

+ *

+ * @param string $table_name name of the database table

+ * @return null

+ * @throws \phpbb\db\extractor\exception\extractor_not_initialized_exception when calling this function before init_extractor()

+ */

+ protected function write_data_mysqli($table_name)

+ {

+ if (!$this->is_initialized)

+ {

+ throw new extractor_not_initialized_exception();

+ }

+

+ $sql = "SELECT *

+ FROM $table_name";

+ $result = mysqli_query($this->db->get_db_connect_id(), $sql, MYSQLI_USE_RESULT);

+ if ($result != false)

+ {

+ $fields_cnt = mysqli_num_fields($result);

+

+ // Get field information

+ $field = mysqli_fetch_fields($result);

+ $field_set = array();

+

+ for ($j = 0; $j < $fields_cnt; $j++)

+ {

+ $field_set[] = $field[$j]->name;

+ }

+

+ $search = array("\\", "'", "\x00", "\x0a", "\x0d", "\x1a", '"');

+ $replace = array("\\\\", "\\'", '\0', '\n', '\r', '\Z', '\\"');

+ $fields = implode(', ', $field_set);

+ $sql_data = 'INSERT INTO ' . $table_name . ' (' . $fields . ') VALUES ';

+ $first_set = true;

+ $query_len = 0;

+ $max_len = get_usable_memory();

+

+ while ($row = mysqli_fetch_row($result))

+ {

+ $values = array();

+ if ($first_set)

+ {

+ $query = $sql_data . '(';

+ }

+ else

+ {

+ $query .= ',(';

+ }

+

+ for ($j = 0; $j < $fields_cnt; $j++)

+ {

+ if (!isset($row[$j]) || is_null($row[$j]))

+ {

+ $values[$j] = 'NULL';

+ }

+ else if (($field[$j]->flags & 32768) && !($field[$j]->flags & 1024))

+ {

+ $values[$j] = $row[$j];

+ }

+ else

+ {

+ $values[$j] = "'" . str_replace($search, $replace, $row[$j]) . "'";

+ }

+ }

+ $query .= implode(', ', $values) . ')';

+

+ $query_len += strlen($query);

+ if ($query_len > $max_len)

+ {

+ $this->flush($query . ";\n\n");

+ $query = '';

+ $query_len = 0;

+ $first_set = true;

+ }

+ else

+ {

+ $first_set = false;

+ }

+ }

+ mysqli_free_result($result);

+

+ // check to make sure we have nothing left to flush

+ if (!$first_set && $query)

+ {

+ $this->flush($query . ";\n\n");

+ }

+ }

+ }

+

+ /**

+ * Extracts data from database table (for MySQL driver)

+ *

+ * @param string $table_name name of the database table

+ * @return null

+ * @throws \phpbb\db\extractor\exception\extractor_not_initialized_exception when calling this function before init_extractor()

+ */

+ protected function write_data_mysql($table_name)

+ {

+ if (!$this->is_initialized)

+ {

+ throw new extractor_not_initialized_exception();

+ }

+

+ $sql = "SELECT *

+ FROM $table_name";

+ $result = mysql_unbuffered_query($sql, $this->db->get_db_connect_id());

+

+ if ($result != false)

+ {

+ $fields_cnt = mysql_num_fields($result);

+

+ // Get field information

+ $field = array();

+ for ($i = 0; $i < $fields_cnt; $i++)

+ {

+ $field[] = mysql_fetch_field($result, $i);

+ }

+ $field_set = array();

+

+ for ($j = 0; $j < $fields_cnt; $j++)

+ {

+ $field_set[] = $field[$j]->name;

+ }

+

+ $search = array("\\", "'", "\x00", "\x0a", "\x0d", "\x1a", '"');

+ $replace = array("\\\\", "\\'", '\0', '\n', '\r', '\Z', '\\"');

+ $fields = implode(', ', $field_set);

+ $sql_data = 'INSERT INTO ' . $table_name . ' (' . $fields . ') VALUES ';

+ $first_set = true;

+ $query_len = 0;

+ $max_len = get_usable_memory();

+

+ while ($row = mysql_fetch_row($result))

+ {

+ $values = array();

+ if ($first_set)

+ {

+ $query = $sql_data . '(';

+ }

+ else

+ {

+ $query .= ',(';

+ }

+

+ for ($j = 0; $j < $fields_cnt; $j++)

+ {

+ if (!isset($row[$j]) || is_null($row[$j]))

+ {

+ $values[$j] = 'NULL';

+ }

+ else if ($field[$j]->numeric && ($field[$j]->type !== 'timestamp'))

+ {

+ $values[$j] = $row[$j];

+ }

+ else

+ {

+ $values[$j] = "'" . str_replace($search, $replace, $row[$j]) . "'";

+ }

+ }

+ $query .= implode(', ', $values) . ')';

+

+ $query_len += strlen($query);

+ if ($query_len > $max_len)

+ {

+ $this->flush($query . ";\n\n");

+ $query = '';

+ $query_len = 0;

+ $first_set = true;

+ }

+ else

+ {

+ $first_set = false;

+ }

+ }

+ mysql_free_result($result);

+

+ // check to make sure we have nothing left to flush

+ if (!$first_set && $query)

+ {

+ $this->flush($query . ";\n\n");

+ }

+ }

+ }

+

+ /**

+ * Extracts database table structure (for MySQLi or MySQL 3.23.20+)

+ *

+ * @param string $table_name name of the database table

+ * @return null

+ * @throws \phpbb\db\extractor\exception\extractor_not_initialized_exception when calling this function before init_extractor()

+ */

+ protected function new_write_table($table_name)

+ {

+ if (!$this->is_initialized)

+ {

+ throw new extractor_not_initialized_exception();

+ }

+

+ $sql = 'SHOW CREATE TABLE ' . $table_name;

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

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

+

+ $sql_data = '# Table: ' . $table_name . "\n";

+ $sql_data .= "DROP TABLE IF EXISTS $table_name;\n";

+ $this->flush($sql_data . $row['Create Table'] . ";\n\n");

+

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

+ }

+

+ /**

+ * Extracts database table structure (for MySQL verisons older than 3.23.20)

+ *

+ * @param string $table_name name of the database table

+ * @return null

+ * @throws \phpbb\db\extractor\exception\extractor_not_initialized_exception when calling this function before init_extractor()

+ */

+ protected function old_write_table($table_name)

+ {

+ if (!$this->is_initialized)

+ {

+ throw new extractor_not_initialized_exception();

+ }

+

+ $sql_data = '# Table: ' . $table_name . "\n";

+ $sql_data .= "DROP TABLE IF EXISTS $table_name;\n";

+ $sql_data .= "CREATE TABLE $table_name(\n";

+ $rows = array();

+

+ $sql = "SHOW FIELDS

+ FROM $table_name";

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

+

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

+ {

+ $line = ' ' . $row['Field'] . ' ' . $row['Type'];

+

+ if (!is_null($row['Default']))

+ {

+ $line .= " DEFAULT '{$row['Default']}'";

+ }

+

+ if ($row['Null'] != 'YES')

+ {

+ $line .= ' NOT NULL';

+ }

+

+ if ($row['Extra'] != '')

+ {

+ $line .= ' ' . $row['Extra'];

+ }

+

+ $rows[] = $line;

+ }

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

+

+ $sql = "SHOW KEYS

+ FROM $table_name";

+

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

+

+ $index = array();

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

+ {

+ $kname = $row['Key_name'];

+

+ if ($kname != 'PRIMARY')

+ {

+ if ($row['Non_unique'] == 0)

+ {

+ $kname = "UNIQUE|$kname";

+ }

+ }

+

+ if ($row['Sub_part'])

+ {

+ $row['Column_name'] .= '(' . $row['Sub_part'] . ')';

+ }

+ $index[$kname][] = $row['Column_name'];

+ }

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

+

+ foreach ($index as $key => $columns)

+ {

+ $line = ' ';

+

+ if ($key == 'PRIMARY')

+ {

+ $line .= 'PRIMARY KEY (' . implode(', ', $columns) . ')';

+ }

+ else if (strpos($key, 'UNIQUE') === 0)

+ {

+ $line .= 'UNIQUE ' . substr($key, 7) . ' (' . implode(', ', $columns) . ')';

+ }

+ else if (strpos($key, 'FULLTEXT') === 0)

+ {

+ $line .= 'FULLTEXT ' . substr($key, 9) . ' (' . implode(', ', $columns) . ')';

+ }

+ else

+ {

+ $line .= "KEY $key (" . implode(', ', $columns) . ')';

+ }

+

+ $rows[] = $line;

+ }

+

+ $sql_data .= implode(",\n", $rows);

+ $sql_data .= "\n);\n\n";

+

+ $this->flush($sql_data);

+ }

+}

+<?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.

+*

+*/

+

+namespace phpbb\db\extractor;

+

+use phpbb\db\extractor\exception\extractor_not_initialized_exception;

+

+class oracle_extractor extends base_extractor

+{

+ /**

+ * {@inheritdoc}

+ */

+ public function write_table($table_name)

+ {

+ if (!$this->is_initialized)

+ {

+ throw new extractor_not_initialized_exception();

+ }

+

+ $sql_data = '-- Table: ' . $table_name . "\n";

+ $sql_data .= "DROP TABLE $table_name\n/\n";

+ $sql_data .= "\nCREATE TABLE $table_name (\n";

+

+ $sql = "SELECT COLUMN_NAME, DATA_TYPE, DATA_PRECISION, DATA_LENGTH, NULLABLE, DATA_DEFAULT

+ FROM ALL_TAB_COLS

+ WHERE table_name = '{$table_name}'";

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

+

+ $rows = array();

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

+ {

+ $line = ' "' . $row['column_name'] . '" ' . $row['data_type'];

+

+ if ($row['data_type'] !== 'CLOB')

+ {

+ if ($row['data_type'] !== 'VARCHAR2' && $row['data_type'] !== 'CHAR')

+ {

+ $line .= '(' . $row['data_precision'] . ')';

+ }

+ else

+ {

+ $line .= '(' . $row['data_length'] . ')';

+ }

+ }

+

+ if (!empty($row['data_default']))

+ {

+ $line .= ' DEFAULT ' . $row['data_default'];

+ }

+

+ if ($row['nullable'] == 'N')

+ {

+ $line .= ' NOT NULL';

+ }

+ $rows[] = $line;

+ }

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

+

+ $sql = "SELECT A.CONSTRAINT_NAME, A.COLUMN_NAME

+ FROM USER_CONS_COLUMNS A, USER_CONSTRAINTS B

+ WHERE A.CONSTRAINT_NAME = B.CONSTRAINT_NAME

+ AND B.CONSTRAINT_TYPE = 'P'

+ AND A.TABLE_NAME = '{$table_name}'";

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

+

+ $primary_key = array();

+ $constraint_name = '';

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

+ {

+ $constraint_name = '"' . $row['constraint_name'] . '"';

+ $primary_key[] = '"' . $row['column_name'] . '"';

+ }

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

+

+ if (sizeof($primary_key))

+ {

+ $rows[] = " CONSTRAINT {$constraint_name} PRIMARY KEY (" . implode(', ', $primary_key) . ')';

+ }

+

+ $sql = "SELECT A.CONSTRAINT_NAME, A.COLUMN_NAME

+ FROM USER_CONS_COLUMNS A, USER_CONSTRAINTS B

+ WHERE A.CONSTRAINT_NAME = B.CONSTRAINT_NAME

+ AND B.CONSTRAINT_TYPE = 'U'

+ AND A.TABLE_NAME = '{$table_name}'";

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

+

+ $unique = array();

+ $constraint_name = '';

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

+ {

+ $constraint_name = '"' . $row['constraint_name'] . '"';

+ $unique[] = '"' . $row['column_name'] . '"';

+ }

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

+

+ if (sizeof($unique))

+ {

+ $rows[] = " CONSTRAINT {$constraint_name} UNIQUE (" . implode(', ', $unique) . ')';

+ }

+

+ $sql_data .= implode(",\n", $rows);

+ $sql_data .= "\n)\n/\n";

+

+ $sql = "SELECT A.REFERENCED_NAME, C.*

+ FROM USER_DEPENDENCIES A, USER_TRIGGERS B, USER_SEQUENCES C

+ WHERE A.REFERENCED_TYPE = 'SEQUENCE'

+ AND A.NAME = B.TRIGGER_NAME

+ AND B.TABLE_NAME = '{$table_name}'

+ AND C.SEQUENCE_NAME = A.REFERENCED_NAME";

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

+

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

+

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

+ {

+ $sql_data .= "\nDROP SEQUENCE \"{$row['referenced_name']}\"\n/\n";

+ $sql_data .= "\nCREATE SEQUENCE \"{$row['referenced_name']}\"";

+

+ if ($type == 'full')

+ {

+ $sql_data .= ' START WITH ' . $row['last_number'];

+ }

+

+ $sql_data .= "\n/\n";

+ }

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

+

+ $sql = "SELECT DESCRIPTION, WHEN_CLAUSE, TRIGGER_BODY

+ FROM USER_TRIGGERS

+ WHERE TABLE_NAME = '{$table_name}'";

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

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

+ {

+ $sql_data .= "\nCREATE OR REPLACE TRIGGER {$row['description']}WHEN ({$row['when_clause']})\n{$row['trigger_body']}\n/\n";

+ }

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

+

+ $sql = "SELECT A.INDEX_NAME, B.COLUMN_NAME

+ FROM USER_INDEXES A, USER_IND_COLUMNS B

+ WHERE A.UNIQUENESS = 'NONUNIQUE'

+ AND A.INDEX_NAME = B.INDEX_NAME

+ AND B.TABLE_NAME = '{$table_name}'";

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

+

+ $index = array();

+

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

+ {

+ $index[$row['index_name']][] = $row['column_name'];

+ }

+

+ foreach ($index as $index_name => $column_names)

+ {

+ $sql_data .= "\nCREATE INDEX $index_name ON $table_name(" . implode(', ', $column_names) . ")\n/\n";

+ }

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

+ $this->flush($sql_data);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function write_data($table_name)

+ {

+ if (!$this->is_initialized)

+ {

+ throw new extractor_not_initialized_exception();

+ }

+

+ $ary_type = $ary_name = array();

+

+ // Grab all of the data from current table.

+ $sql = "SELECT *

+ FROM $table_name";

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

+

+ $i_num_fields = ocinumcols($result);

+

+ for ($i = 0; $i < $i_num_fields; $i++)

+ {

+ $ary_type[$i] = ocicolumntype($result, $i + 1);

+ $ary_name[$i] = ocicolumnname($result, $i + 1);

+ }

+

+ $sql_data = '';

+

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

+ {

+ $schema_vals = $schema_fields = array();

+

+ // Build the SQL statement to recreate the data.

+ for ($i = 0; $i < $i_num_fields; $i++)

+ {

+ // Oracle uses uppercase - we use lowercase

+ $str_val = $row[strtolower($ary_name[$i])];

+

+ if (preg_match('#char|text|bool|raw|clob#i', $ary_type[$i]))

+ {

+ $str_quote = '';

+ $str_empty = "''";

+ $str_val = sanitize_data_oracle($str_val);

+ }

+ else if (preg_match('#date|timestamp#i', $ary_type[$i]))

+ {

+ if (empty($str_val))

+ {

+ $str_quote = '';

+ }

+ else

+ {

+ $str_quote = "'";

+ }

+ }

+ else

+ {

+ $str_quote = '';

+ $str_empty = 'NULL';

+ }

+

+ if (empty($str_val) && $str_val !== '0')

+ {

+ $str_val = $str_empty;

+ }

+

+ $schema_vals[$i] = $str_quote . $str_val . $str_quote;

+ $schema_fields[$i] = '"' . $ary_name[$i] . '"';

+ }

+

+ // Take the ordered fields and their associated data and build it

+ // into a valid sql statement to recreate that field in the data.

+ $sql_data = "INSERT INTO $table_name (" . implode(', ', $schema_fields) . ') VALUES (' . implode(', ', $schema_vals) . ")\n/\n";

+

+ $this->flush($sql_data);

+ }

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

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function write_start($table_prefix)

+ {

+ if (!$this->is_initialized)

+ {

+ throw new extractor_not_initialized_exception();

+ }

+

+ $sql_data = "--\n";

+ $sql_data .= "-- phpBB Backup Script\n";

+ $sql_data .= "-- Dump of tables for $table_prefix\n";

+ $sql_data .= "-- DATE : " . gmdate("d-m-Y H:i:s", $this->time) . " GMT\n";

+ $sql_data .= "--\n";

+ $this->flush($sql_data);

+ }

+}

+<?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.

+*

+*/

+

+namespace phpbb\db\extractor;

+

+use phpbb\db\extractor\exception\extractor_not_initialized_exception;

+

+class postgres_extractor extends base_extractor

+{

+ /**

+ * {@inheritdoc}

+ */

+ public function write_start($table_prefix)

+ {

+ if (!$this->is_initialized)

+ {

+ throw new extractor_not_initialized_exception();

+ }

+

+ $sql_data = "--\n";

+ $sql_data .= "-- phpBB Backup Script\n";

+ $sql_data .= "-- Dump of tables for $table_prefix\n";

+ $sql_data .= "-- DATE : " . gmdate("d-m-Y H:i:s", $this->time) . " GMT\n";

+ $sql_data .= "--\n";

+ $sql_data .= "BEGIN TRANSACTION;\n";

+ $this->flush($sql_data);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function write_table($table_name)

+ {

+ static $domains_created = array();

+

+ if (!$this->is_initialized)

+ {

+ throw new extractor_not_initialized_exception();

+ }

+

+ $sql = "SELECT a.domain_name, a.data_type, a.character_maximum_length, a.domain_default

+ FROM INFORMATION_SCHEMA.domains a, INFORMATION_SCHEMA.column_domain_usage b

+ WHERE a.domain_name = b.domain_name

+ AND b.table_name = '{$table_name}'";

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

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

+ {

+ if (empty($domains_created[$row['domain_name']]))

+ {

+ $domains_created[$row['domain_name']] = true;

+ //$sql_data = "DROP DOMAIN {$row['domain_name']};\n";

+ $sql_data = "CREATE DOMAIN {$row['domain_name']} as {$row['data_type']}";

+ if (!empty($row['character_maximum_length']))

+ {

+ $sql_data .= '(' . $row['character_maximum_length'] . ')';

+ }

+ $sql_data .= ' NOT NULL';

+ if (!empty($row['domain_default']))

+ {

+ $sql_data .= ' DEFAULT ' . $row['domain_default'];

+ }

+ $this->flush($sql_data . ";\n");

+ }

+ }

+

+ $sql_data = '-- Table: ' . $table_name . "\n";

+ $sql_data .= "DROP TABLE $table_name;\n";

+ // PGSQL does not "tightly" bind sequences and tables, we must guess...

+ $sql = "SELECT relname

+ FROM pg_class

+ WHERE relkind = 'S'

+ AND relname = '{$table_name}_seq'";

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

+ // We don't even care about storing the results. We already know the answer if we get rows back.

+ if ($this->db->sql_fetchrow($result))

+ {

+ $sql_data .= "DROP SEQUENCE {$table_name}_seq;\n";

+ $sql_data .= "CREATE SEQUENCE {$table_name}_seq;\n";

+ }

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

+

+ $field_query = "SELECT a.attnum, a.attname as field, t.typname as type, a.attlen as length, a.atttypmod as lengthvar, a.attnotnull as notnull

+ FROM pg_class c, pg_attribute a, pg_type t

+ WHERE c.relname = '" . $this->db->sql_escape($table_name) . "'

+ AND a.attnum > 0

+ AND a.attrelid = c.oid

+ AND a.atttypid = t.oid

+ ORDER BY a.attnum";

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

+

+ $sql_data .= "CREATE TABLE $table_name(\n";

+ $lines = array();

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

+ {

+ // Get the data from the table

+ $sql_get_default = "SELECT pg_get_expr(d.adbin, d.adrelid) as rowdefault

+ FROM pg_attrdef d, pg_class c

+ WHERE (c.relname = '" . $this->db->sql_escape($table_name) . "')

+ AND (c.oid = d.adrelid)

+ AND d.adnum = " . $row['attnum'];

+ $def_res = $this->db->sql_query($sql_get_default);

+ $def_row = $this->db->sql_fetchrow($def_res);

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

+

+ if (empty($def_row))

+ {

+ unset($row['rowdefault']);

+ }

+ else

+ {

+ $row['rowdefault'] = $def_row['rowdefault'];

+ }

+

+ if ($row['type'] == 'bpchar')

+ {

+ // Internally stored as bpchar, but isn't accepted in a CREATE TABLE statement.

+ $row['type'] = 'char';

+ }

+

+ $line = ' ' . $row['field'] . ' ' . $row['type'];

+

+ if (strpos($row['type'], 'char') !== false)

+ {

+ if ($row['lengthvar'] > 0)

+ {

+ $line .= '(' . ($row['lengthvar'] - 4) . ')';

+ }

+ }

+

+ if (strpos($row['type'], 'numeric') !== false)

+ {

+ $line .= '(';

+ $line .= sprintf("%s,%s", (($row['lengthvar'] >> 16) & 0xffff), (($row['lengthvar'] - 4) & 0xffff));

+ $line .= ')';

+ }

+

+ if (isset($row['rowdefault']))

+ {

+ $line .= ' DEFAULT ' . $row['rowdefault'];

+ }

+

+ if ($row['notnull'] == 't')

+ {

+ $line .= ' NOT NULL';

+ }

+

+ $lines[] = $line;

+ }

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

+

+ // Get the listing of primary keys.

+ $sql_pri_keys = "SELECT ic.relname as index_name, bc.relname as tab_name, ta.attname as column_name, i.indisunique as unique_key, i.indisprimary as primary_key

+ FROM pg_class bc, pg_class ic, pg_index i, pg_attribute ta, pg_attribute ia

+ WHERE (bc.oid = i.indrelid)

+ AND (ic.oid = i.indexrelid)

+ AND (ia.attrelid = i.indexrelid)

+ AND (ta.attrelid = bc.oid)

+ AND (bc.relname = '" . $this->db->sql_escape($table_name) . "')

+ AND (ta.attrelid = i.indrelid)

+ AND (ta.attnum = i.indkey[ia.attnum-1])

+ ORDER BY index_name, tab_name, column_name";

+

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

+

+ $index_create = $index_rows = $primary_key = array();

+

+ // We do this in two steps. It makes placing the comma easier

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

+ {

+ if ($row['primary_key'] == 't')

+ {

+ $primary_key[] = $row['column_name'];

+ $primary_key_name = $row['index_name'];

+ }

+ else

+ {

+ // We have to store this all this info because it is possible to have a multi-column key...

+ // we can loop through it again and build the statement

+ $index_rows[$row['index_name']]['table'] = $table_name;

+ $index_rows[$row['index_name']]['unique'] = ($row['unique_key'] == 't') ? true : false;

+ $index_rows[$row['index_name']]['column_names'][] = $row['column_name'];

+ }

+ }

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

+

+ if (!empty($index_rows))

+ {

+ foreach ($index_rows as $idx_name => $props)

+ {

+ $index_create[] = 'CREATE ' . ($props['unique'] ? 'UNIQUE ' : '') . "INDEX $idx_name ON $table_name (" . implode(', ', $props['column_names']) . ");";

+ }

+ }

+

+ if (!empty($primary_key))

+ {

+ $lines[] = " CONSTRAINT $primary_key_name PRIMARY KEY (" . implode(', ', $primary_key) . ")";

+ }

+

+ // Generate constraint clauses for CHECK constraints

+ $sql_checks = "SELECT conname as index_name, consrc

+ FROM pg_constraint, pg_class bc

+ WHERE conrelid = bc.oid

+ AND bc.relname = '" . $this->db->sql_escape($table_name) . "'

+ AND NOT EXISTS (

+ SELECT *

+ FROM pg_constraint as c, pg_inherits as i

+ WHERE i.inhrelid = pg_constraint.conrelid

+ AND c.conname = pg_constraint.conname

+ AND c.consrc = pg_constraint.consrc

+ AND c.conrelid = i.inhparent

+ )";

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

+

+ // Add the constraints to the sql file.

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

+ {

+ if (!is_null($row['consrc']))

+ {

+ $lines[] = ' CONSTRAINT ' . $row['index_name'] . ' CHECK ' . $row['consrc'];

+ }

+ }

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

+

+ $sql_data .= implode(", \n", $lines);

+ $sql_data .= "\n);\n";

+

+ if (!empty($index_create))

+ {

+ $sql_data .= implode("\n", $index_create) . "\n\n";

+ }

+ $this->flush($sql_data);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function write_data($table_name)

+ {

+ if (!$this->is_initialized)

+ {

+ throw new extractor_not_initialized_exception();

+ }

+

+ // Grab all of the data from current table.

+ $sql = "SELECT *

+ FROM $table_name";

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

+

+ $i_num_fields = pg_num_fields($result);

+ $seq = '';

+

+ for ($i = 0; $i < $i_num_fields; $i++)

+ {

+ $ary_type[] = pg_field_type($result, $i);

+ $ary_name[] = pg_field_name($result, $i);

+

+ $sql = "SELECT pg_get_expr(d.adbin, d.adrelid) as rowdefault

+ FROM pg_attrdef d, pg_class c

+ WHERE (c.relname = '{$table_name}')

+ AND (c.oid = d.adrelid)

+ AND d.adnum = " . strval($i + 1);

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

+ if ($row = $this->db->sql_fetchrow($result2))

+ {

+ // Determine if we must reset the sequences

+ if (strpos($row['rowdefault'], "nextval('") === 0)

+ {

+ $seq .= "SELECT SETVAL('{$table_name}_seq',(select case when max({$ary_name[$i]})>0 then max({$ary_name[$i]})+1 else 1 end FROM {$table_name}));\n";

+ }

+ }

+ }

+

+ $this->flush("COPY $table_name (" . implode(', ', $ary_name) . ') FROM stdin;' . "\n");

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

+ {

+ $schema_vals = array();

+

+ // Build the SQL statement to recreate the data.

+ for ($i = 0; $i < $i_num_fields; $i++)

+ {

+ $str_val = $row[$ary_name[$i]];

+

+ if (preg_match('#char|text|bool|bytea#i', $ary_type[$i]))

+ {

+ $str_val = str_replace(array("\n", "\t", "\r", "\b", "\f", "\v"), array('\n', '\t', '\r', '\b', '\f', '\v'), addslashes($str_val));

+ $str_empty = '';

+ }

+ else

+ {

+ $str_empty = '\N';

+ }

+

+ if (empty($str_val) && $str_val !== '0')

+ {

+ $str_val = $str_empty;

+ }

+

+ $schema_vals[] = $str_val;

+ }

+

+ // Take the ordered fields and their associated data and build it

+ // into a valid sql statement to recreate that field in the data.

+ $this->flush(implode("\t", $schema_vals) . "\n");

+ }

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

+ $this->flush("\\.\n");

+

+ // Write out the sequence statements

+ $this->flush($seq);

+ }

+

+ /**

+ * Writes closing line(s) to database backup

+ *

+ * @return null

+ * @throws \phpbb\db\extractor\exception\extractor_not_initialized_exception when calling this function before init_extractor()

+ */

+ public function write_end()

+ {

+ if (!$this->is_initialized)

+ {

+ throw new extractor_not_initialized_exception();

+ }

+

+ $this->flush("COMMIT;\n");

+ parent::write_end();

+ }

+}

+<?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.

+*

+*/

+

+namespace phpbb\db\extractor;

+

+use phpbb\db\extractor\exception\extractor_not_initialized_exception;

+

+class sqlite3_extractor extends base_extractor

+{

+ /**

+ * {@inheritdoc}

+ */

+ public function write_start($table_prefix)

+ {

+ if (!$this->is_initialized)

+ {

+ throw new extractor_not_initialized_exception();

+ }

+

+ $sql_data = "--\n";

+ $sql_data .= "-- phpBB Backup Script\n";

+ $sql_data .= "-- Dump of tables for $table_prefix\n";

+ $sql_data .= "-- DATE : " . gmdate("d-m-Y H:i:s", $this->time) . " GMT\n";

+ $sql_data .= "--\n";

+ $sql_data .= "BEGIN TRANSACTION;\n";

+ $this->flush($sql_data);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function write_table($table_name)

+ {

+ if (!$this->is_initialized)

+ {

+ throw new extractor_not_initialized_exception();

+ }

+

+ $sql_data = '-- Table: ' . $table_name . "\n";

+ $sql_data .= "DROP TABLE $table_name;\n";

+

+ $sql = "SELECT sql

+ FROM sqlite_master

+ WHERE type = 'table'

+ AND name = '" . $this->db->sql_escape($table_name) . "'

+ ORDER BY name ASC;";

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

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

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

+

+ // Create Table

+ $sql_data .= $row['sql'] . ";\n";

+

+ $result = $this->db->sql_query("PRAGMA index_list('" . $this->db->sql_escape($table_name) . "');");

+

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

+ {

+ if (strpos($row['name'], 'autoindex') !== false)

+ {

+ continue;

+ }

+

+ $result2 = $this->db->sql_query("PRAGMA index_info('" . $this->db->sql_escape($row['name']) . "');");

+

+ $fields = array();

+ while ($row2 = $this->db->sql_fetchrow($result2))

+ {

+ $fields[] = $row2['name'];

+ }

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

+

+ $sql_data .= 'CREATE ' . ($row['unique'] ? 'UNIQUE ' : '') . 'INDEX ' . $row['name'] . ' ON ' . $table_name . ' (' . implode(', ', $fields) . ");\n";

+ }

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

+

+ $this->flush($sql_data . "\n");

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function write_data($table_name)

+ {

+ if (!$this->is_initialized)

+ {

+ throw new extractor_not_initialized_exception();

+ }

+

+ $result = $this->db->sql_query("PRAGMA table_info('" . $this->db->sql_escape($table_name) . "');");

+

+ $col_types = array();

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

+ {

+ $col_types[$row['name']] = $row['type'];

+ }

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

+

+ $sql_insert = 'INSERT INTO ' . $table_name . ' (' . implode(', ', array_keys($col_types)) . ') VALUES (';

+

+ $sql = "SELECT *

+ FROM $table_name";

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

+

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

+ {

+ foreach ($row as $column_name => $column_data)

+ {

+ if (is_null($column_data))

+ {

+ $row[$column_name] = 'NULL';

+ }

+ else if ($column_data === '')

+ {

+ $row[$column_name] = "''";

+ }

+ else if (stripos($col_types[$column_name], 'text') !== false || stripos($col_types[$column_name], 'char') !== false || stripos($col_types[$column_name], 'blob') !== false)

+ {

+ $row[$column_name] = sanitize_data_generic(str_replace("'", "''", $column_data));

+ }

+ }

+ $this->flush($sql_insert . implode(', ', $row) . ");\n");

+ }

+ }

+

+ /**

+ * Writes closing line(s) to database backup

+ *

+ * @return null

+ * @throws \phpbb\db\extractor\exception\extractor_not_initialized_exception when calling this function before init_extractor()

+ */

+ public function write_end()

+ {

+ if (!$this->is_initialized)

+ {

+ throw new extractor_not_initialized_exception();

+ }

+

+ $this->flush("COMMIT;\n");

+ parent::write_end();

+ }

+}

+<?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.

+*

+*/

+

+namespace phpbb\db\extractor;

+

+use phpbb\db\extractor\exception\extractor_not_initialized_exception;

+

+class sqlite_extractor extends base_extractor

+{

+ /**

+ * {@inheritdoc}

+ */

+ public function write_start($table_prefix)

+ {

+ if (!$this->is_initialized)

+ {

+ throw new extractor_not_initialized_exception();

+ }

+

+ $sql_data = "--\n";

+ $sql_data .= "-- phpBB Backup Script\n";

+ $sql_data .= "-- Dump of tables for $table_prefix\n";

+ $sql_data .= "-- DATE : " . gmdate("d-m-Y H:i:s", $this->time) . " GMT\n";

+ $sql_data .= "--\n";

+ $sql_data .= "BEGIN TRANSACTION;\n";

+ $this->flush($sql_data);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function write_table($table_name)

+ {

+ if (!$this->is_initialized)

+ {

+ throw new extractor_not_initialized_exception();

+ }

+

+ $sql_data = '-- Table: ' . $table_name . "\n";

+ $sql_data .= "DROP TABLE $table_name;\n";

+

+ $sql = "SELECT sql

+ FROM sqlite_master

+ WHERE type = 'table'

+ AND name = '" . $this->db->sql_escape($table_name) . "'

+ ORDER BY type DESC, name;";

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

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

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

+

+ // Create Table

+ $sql_data .= $row['sql'] . ";\n";

+

+ $result = $this->db->sql_query("PRAGMA index_list('" . $this->db->sql_escape($table_name) . "');");

+

+ $ar = array();

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

+ {

+ $ar[] = $row;

+ }

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

+

+ foreach ($ar as $value)

+ {

+ if (strpos($value['name'], 'autoindex') !== false)

+ {

+ continue;

+ }

+

+ $result = $this->db->sql_query("PRAGMA index_info('" . $this->db->sql_escape($value['name']) . "');");

+

+ $fields = array();

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

+ {

+ $fields[] = $row['name'];

+ }

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

+

+ $sql_data .= 'CREATE ' . ($value['unique'] ? 'UNIQUE ' : '') . 'INDEX ' . $value['name'] . ' on ' . $table_name . ' (' . implode(', ', $fields) . ");\n";

+ }

+

+ $this->flush($sql_data . "\n");

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function write_data($table_name)

+ {

+ if (!$this->is_initialized)

+ {

+ throw new extractor_not_initialized_exception();

+ }

+

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

+

+ $sql = "SELECT *

+ FROM $table_name";

+ $result = sqlite_unbuffered_query($this->db->get_db_connect_id(), $sql);

+ $rows = sqlite_fetch_all($result, SQLITE_ASSOC);

+ $sql_insert = 'INSERT INTO ' . $table_name . ' (' . implode(', ', array_keys($col_types)) . ') VALUES (';

+ foreach ($rows as $row)

+ {

+ foreach ($row as $column_name => $column_data)

+ {

+ if (is_null($column_data))

+ {

+ $row[$column_name] = 'NULL';

+ }

+ else if ($column_data == '')

+ {

+ $row[$column_name] = "''";

+ }

+ else if (strpos($col_types[$column_name], 'text') !== false || strpos($col_types[$column_name], 'char') !== false || strpos($col_types[$column_name], 'blob') !== false)

+ {

+ $row[$column_name] = sanitize_data_generic(str_replace("'", "''", $column_data));

+ }

+ }

+ $this->flush($sql_insert . implode(', ', $row) . ");\n");

+ }

+ }

+

+ /**

+ * Writes closing line(s) to database backup

+ *

+ * @return null

+ * @throws \phpbb\db\extractor\exception\extractor_not_initialized_exception when calling this function before init_extractor()

+ */

+ public function write_end()

+ {

+ if (!$this->is_initialized)

+ {

+ throw new extractor_not_initialized_exception();

+ }

+

+ $this->flush("COMMIT;\n");

+ parent::write_end();

+ }

+}

+ // Get current avatar type of guest user

+ $sql = 'SELECT user_avatar_type

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

+ WHERE user_id = ' . ANONYMOUS;

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

+ $backup_type = $this->db->sql_fetchfield('user_avatar_type');

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

+

+ // Try to set avatar type to string

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

+ SET user_avatar_type = 'avatar.driver.upload'

+ WHERE user_id = " . ANONYMOUS;

+ $this->db->sql_return_on_error(true);

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

+ $this->db->sql_return_on_error();

+

+ // Restore avatar type of guest user to previous state

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

+ SET user_avatar_type = '{$backup_type}'

+ WHERE user_id = " . ANONYMOUS;

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

+

+ return $effectively_installed !== false;

+<?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.

+*

+*/

+

+namespace phpbb\db\migration\data\v31x;

+

+class v314rc1 extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v31x\v313',

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.1.4-RC1')),

+ );

+ }

+}

+ (int) $this->config['img_max_width'],

+ (int) $this->config['img_max_height']

+<?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.

+*

+*/

+

+namespace phpbb\textformatter;

+

+/**

+* Currently only used to signal that something that could effect the rendering has changed.

+* BBCodes, smilies, censored words, templates, etc...

+*/

+interface cache_interface

+{

+ /**

+ * Invalidate and/or regenerate this text formatter's cache(s)

+ */

+ public function invalidate();

+

+ /**

+ * Tidy/prune this text formatter's cache(s)

+ */

+ public function tidy();

+}

+<?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.

+*

+*/

+

+namespace phpbb\textformatter;

+

+/**

+* Data access layer that fetchs BBCodes, smilies and censored words from the database.

+* To be extended to include insert/update/delete operations.

+*

+* Also used to get templates.

+*/

+class data_access

+{

+ /**

+ * @var string Name of the BBCodes table

+ */

+ protected $bbcodes_table;

+

+ /**

+ * @var \phpbb\db\driver\driver_interface

+ */

+ protected $db;

+

+ /**

+ * @var string Name of the smilies table

+ */

+ protected $smilies_table;

+

+ /**

+ * @var string Name of the styles table

+ */

+ protected $styles_table;

+

+ /**

+ * @var string Path to the styles dir

+ */

+ protected $styles_path;

+

+ /**

+ * @var string Name of the words table

+ */

+ protected $words_table;

+

+ /**

+ * Constructor

+ *

+ * @param \phpbb\db\driver\driver_interface $db Database connection

+ * @param string $bbcodes_table Name of the BBCodes table

+ * @param string $smilies_table Name of the smilies table

+ * @param string $styles_table Name of the styles table

+ * @param string $words_table Name of the words table

+ * @param string $styles_path Path to the styles dir

+ */

+ public function __construct(\phpbb\db\driver\driver_interface $db, $bbcodes_table, $smilies_table, $styles_table, $words_table, $styles_path)

+ {

+ $this->db = $db;

+

+ $this->bbcodes_table = $bbcodes_table;

+ $this->smilies_table = $smilies_table;

+ $this->styles_table = $styles_table;

+ $this->words_table = $words_table;

+

+ $this->styles_path = $styles_path;

+ }

+

+ /**

+ * Return the list of custom BBCodes

+ *

+ * @return array

+ */

+ public function get_bbcodes()

+ {

+ $sql = 'SELECT bbcode_match, bbcode_tpl FROM ' . $this->bbcodes_table;

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

+ $rows = $this->db->sql_fetchrowset($result);

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

+

+ return $rows;

+ }

+

+ /**

+ * Return the list of smilies

+ *

+ * @return array

+ */

+ public function get_smilies()

+ {

+ // NOTE: smilies that are displayed on the posting page are processed first because they're

+ // typically the most used smilies and it ends up producing a slightly more efficient

+ // renderer

+ $sql = 'SELECT code, emotion, smiley_url, smiley_width, smiley_height

+ FROM ' . $this->smilies_table . '

+ ORDER BY display_on_posting DESC';

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

+ $rows = $this->db->sql_fetchrowset($result);

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

+

+ return $rows;

+ }

+

+ /**

+ * Return the list of installed styles

+ *

+ * @return array

+ */

+ protected function get_styles()

+ {

+ $sql = 'SELECT style_id, style_path, bbcode_bitfield FROM ' . $this->styles_table;

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

+ $rows = $this->db->sql_fetchrowset($result);

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

+

+ return $rows;

+ }

+

+ /**

+ * Return the bbcode.html template for every installed style

+ *

+ * @return array 2D array. style_id as keys, each element is an array with a "template" element that contains the style's bbcode.html and a "bbcodes" element that contains the name of each BBCode that is to be stylised

+ */

+ public function get_styles_templates()

+ {

+ $templates = array();

+

+ $bbcode_ids = array(

+ 'quote' => 0,

+ 'b' => 1,

+ 'i' => 2,

+ 'url' => 3,

+ 'img' => 4,

+ 'size' => 5,

+ 'color' => 6,

+ 'u' => 7,

+ 'code' => 8,

+ 'list' => 9,

+ '*' => 9,

+ 'email' => 10,

+ 'flash' => 11,

+ 'attachment' => 12,

+ );

+

+ $styles = array();

+ foreach ($this->get_styles() as $row)

+ {

+ $styles[$row['style_id']] = $row;

+ }

+

+ foreach ($styles as $style_id => $style)

+ {

+ $bbcodes = array();

+

+ // Collect the name of the BBCodes whose bit is set in the style's bbcode_bitfield

+ $template_bitfield = new \bitfield($style['bbcode_bitfield']);

+ foreach ($bbcode_ids as $bbcode_name => $bit)

+ {

+ if ($template_bitfield->get($bit))

+ {

+ $bbcodes[] = $bbcode_name;

+ }

+ }

+

+ $filename = $this->resolve_style_filename($styles, $style);

+ if ($filename === false)

+ {

+ // Ignore this style, it will use the default templates

+ continue;

+ }

+

+ $templates[$style_id] = array(

+ 'bbcodes' => $bbcodes,

+ 'template' => file_get_contents($filename),

+ );

+ }

+

+ return $templates;

+ }

+

+ /**

+ * Resolve inheritance for given style and return the path to their bbcode.html file

+ *

+ * @param array $styles Associative array of [style_id => style] containing all styles

+ * @param array $style Style for which we resolve

+ * @return string|bool Path to this style's bbcode.html, or FALSE

+ */

+ protected function resolve_style_filename(array $styles, array $style)

+ {

+ // Look for a bbcode.html in this style's dir

+ $filename = $this->styles_path . $style['style_path'] . '/template/bbcode.html';

+ if (file_exists($filename))

+ {

+ return $filename;

+ }

+

+ // Resolve using this style's parent

+ $parent_id = $style['style_parent_id'];

+ if ($parent_id && !empty($styles[$parent_id]))

+ {

+ return $this->resolve_style_filename($styles, $styles[$parent_id]);

+ }

+

+ return false;

+ }

+

+ /**

+ * Return the list of censored words

+ *

+ * @return array

+ */

+ public function get_censored_words()

+ {

+ $sql = 'SELECT word, replacement FROM ' . $this->words_table;

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

+ $rows = $this->db->sql_fetchrowset($result);

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

+

+ return $rows;

+ }

+}

+<?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.

+*

+*/

+

+namespace phpbb\textformatter;

+

+interface parser_interface

+{

+ /**

+ * Parse given text

+ *

+ * @param string $text

+ * @return string

+ */

+ public function parse($text);

+

+ /**

+ * Disable a specific BBCode

+ *

+ * @param string $name BBCode name

+ * @return null

+ */

+ public function disable_bbcode($name);

+

+ /**

+ * Disable BBCodes in general

+ */

+ public function disable_bbcodes();

+

+ /**

+ * Disable the censor

+ */

+ public function disable_censor();

+

+ /**

+ * Disable magic URLs

+ */

+ public function disable_magic_url();

+

+ /**

+ * Disable smilies

+ */

+ public function disable_smilies();

+

+ /**

+ * Enable a specific BBCode

+ *

+ * @param string $name BBCode name

+ * @return null

+ */

+ public function enable_bbcode($name);

+

+ /**

+ * Enable BBCodes in general

+ */

+ public function enable_bbcodes();

+

+ /**

+ * Enable the censor

+ */

+ public function enable_censor();

+

+ /**

+ * Enable magic URLs

+ */

+ public function enable_magic_url();

+

+ /**

+ * Enable smilies

+ */

+ public function enable_smilies();

+

+ /**

+ * Get the list of errors that were generated during last parsing

+ *

+ * @return array

+ */

+ public function get_errors();

+

+ /**

+ * Set a variable to be used by the parser

+ *

+ * - max_font_size

+ * - max_img_height

+ * - max_img_width

+ * - max_smilies

+ * - max_urls

+ *

+ * @param string $name

+ * @param mixed $value

+ * @return null

+ */

+ public function set_var($name, $value);

+

+ /**

+ * Set multiple variables to be used by the parser

+ *

+ * @param array $vars Associative array of [name => value]

+ * @return null

+ */

+ public function set_vars(array $vars);

+}

+<?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.

+*

+*/

+

+namespace phpbb\textformatter;

+

+interface renderer_interface

+{

+ /**

+ * Render given text

+ *

+ * @param string $text Text, as parsed by something that implements \phpbb\textformatter\parser

+ * @return string

+ */

+ public function render($text);

+

+ /**

+ * Set the smilies' path

+ *

+ * @return null

+ */

+ public function set_smilies_path($path);

+

+ /**

+ * Return the value of the "viewcensors" option

+ *

+ * @return bool Option's value

+ */

+ public function get_viewcensors();

+

+ /**

+ * Return the value of the "viewflash" option

+ *

+ * @return bool Option's value

+ */

+ public function get_viewflash();

+

+ /**

+ * Return the value of the "viewimg" option

+ *

+ * @return bool Option's value

+ */

+ public function get_viewimg();

+

+ /**

+ * Return the value of the "viewsmilies" option

+ *

+ * @return bool Option's value

+ */

+ public function get_viewsmilies();

+

+ /**

+ * Set the "viewcensors" option

+ *

+ * @param bool $value Option's value

+ * @return null

+ */

+ public function set_viewcensors($value);

+

+ /**

+ * Set the "viewflash" option

+ *

+ * @param bool $value Option's value

+ * @return null

+ */

+ public function set_viewflash($value);

+

+ /**

+ * Set the "viewimg" option

+ *

+ * @param bool $value Option's value

+ * @return null

+ */

+ public function set_viewimg($value);

+

+ /**

+ * Set the "viewsmilies" option

+ *

+ * @param bool $value Option's value

+ * @return null

+ */

+ public function set_viewsmilies($value);

+}

+<?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.

+*

+*/

+

+namespace phpbb\textformatter\s9e;

+

+use s9e\TextFormatter\Configurator;

+use s9e\TextFormatter\Configurator\Items\AttributeFilters\RegexpFilter;

+use s9e\TextFormatter\Configurator\Items\UnsafeTemplate;

+

+/**

+* Creates s9e\TextFormatter objects

+*/

+class factory implements \phpbb\textformatter\cache_interface

+{

+ /**

+ * @var \phpbb\cache\driver\driver_interface

+ */

+ protected $cache;

+

+ /**

+ * @var string Path to the cache dir

+ */

+ protected $cache_dir;

+

+ /**

+ * @var string Cache key used for the parser

+ */

+ protected $cache_key_parser;

+

+ /**

+ * @var string Cache key used for the renderer

+ */

+ protected $cache_key_renderer;

+

+ /**

+ * @var array Custom tokens used in bbcode.html and their corresponding token from the definition

+ */

+ protected $custom_tokens = array(

+ 'email' => array('{DESCRIPTION}' => '{TEXT}'),

+ 'flash' => array('{WIDTH}' => '{NUMBER1}', '{HEIGHT}' => '{NUMBER2}'),

+ 'img' => array('{URL}' => '{IMAGEURL}'),

+ 'list' => array('{LIST_TYPE}' => '{HASHMAP}'),

+ 'quote' => array('{USERNAME}' => '{TEXT1}'),

+ 'size' => array('{SIZE}' => '{FONTSIZE}'),

+ 'url' => array('{DESCRIPTION}' => '{TEXT}'),

+ );

+

+ /**

+ * @var \phpbb\textformatter\data_access

+ */

+ protected $data_access;

+

+ /**

+ * @var array Default BBCode definitions

+ */

+ protected $default_definitions = array(

+ 'attachment' => '[ATTACHMENT index={NUMBER} filename={TEXT;useContent}]',

+ 'b' => '[B]{TEXT}[/B]',

+ 'code' => '[CODE]{TEXT}[/CODE]',

+ 'color' => '[COLOR={COLOR}]{TEXT}[/COLOR]',

+ 'email' => '[EMAIL={EMAIL;useContent}]{TEXT}[/EMAIL]',

+ 'flash' => '[FLASH={NUMBER1},{NUMBER2} width={NUMBER1;postFilter=#flashwidth} height={NUMBER2;postFilter=#flashheight} url={URL;useContent} /]',

+ 'i' => '[I]{TEXT}[/I]',

+ 'img' => '[IMG src={IMAGEURL;useContent}]',

+ 'list' => '[LIST type={HASHMAP=1:decimal,a:lower-alpha,A:upper-alpha,i:lower-roman,I:upper-roman;optional;postFilter=#simpletext}]{TEXT}[/LIST]',

+ 'li' => '[* $tagName=LI]{TEXT}[/*]',

+ 'quote' =>

+ "[QUOTE

+ author={TEXT1;optional}

+ url={URL;optional}

+ author={PARSE=/^\\[url=(?'url'.*?)](?'author'.*)\\[\\/url]$/i}

+ author={PARSE=/^\\[url](?'author'(?'url'.*?))\\[\\/url]$/i}

+ author={PARSE=/(?'url'https?:\\/\\/[^[\\]]+)/i}

+ ]{TEXT2}[/QUOTE]",

+ 'size' => '[SIZE={FONTSIZE}]{TEXT}[/SIZE]',

+ 'u' => '[U]{TEXT}[/U]',

+ 'url' => '[URL={URL;useContent}]{TEXT}[/URL]',

+ );

+

+ /**

+ * @var array Default templates, taken from bbcode::bbcode_tpl()

+ */

+ protected $default_templates = array(

+ 'b' => '<span style="font-weight: bold"><xsl:apply-templates/></span>',

+ 'i' => '<span style="font-style: italic"><xsl:apply-templates/></span>',

+ 'u' => '<span style="text-decoration: underline"><xsl:apply-templates/></span>',

+ 'img' => '<img src="{IMAGEURL}" alt="{L_IMAGE}"/>',

+ 'size' => '<span style="font-size: {FONTSIZE}%; line-height: normal"><xsl:apply-templates/></span>',

+ 'color' => '<span style="color: {COLOR}"><xsl:apply-templates/></span>',

+ 'email' => '<a href="mailto:{EMAIL}"><xsl:apply-templates/></a>',

+ );

+

+ /**

+ * @var \phpbb\event\dispatcher_interface

+ */

+ protected $dispatcher;

+

+ /**

+ * Constructor

+ *

+ * @param \phpbb\textformatter\data_access $data_access

+ * @param \phpbb\cache\driver\driver_interface $cache

+ * @param \phpbb\event\dispatcher_interface $dispatcher

+ * @param string $cache_dir Path to the cache dir

+ * @param string $cache_key_parser Cache key used for the parser

+ * @param string $cache_key_renderer Cache key used for the renderer

+ */

+ public function __construct(\phpbb\textformatter\data_access $data_access, \phpbb\cache\driver\driver_interface $cache, \phpbb\event\dispatcher_interface $dispatcher, $cache_dir, $cache_key_parser, $cache_key_renderer)

+ {

+ $this->cache = $cache;

+ $this->cache_dir = $cache_dir;

+ $this->cache_key_parser = $cache_key_parser;

+ $this->cache_key_renderer = $cache_key_renderer;

+ $this->data_access = $data_access;

+ $this->dispatcher = $dispatcher;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function invalidate()

+ {

+ $this->regenerate();

+ }

+

+ /**

+ * {@inheritdoc}

+ *

+ * Will remove old renderers from the cache dir but won't touch the current renderer

+ */

+ public function tidy()

+ {

+ // Get the name of current renderer

+ $renderer_data = $this->cache->get($this->cache_key_renderer);

+ $renderer_file = ($renderer_data) ? $renderer_data['class'] . '.php' : null;

+

+ foreach (glob($this->cache_dir . 's9e_*') as $filename)

+ {

+ // Only remove the file if it's not the current renderer

+ if (!$renderer_file || substr($filename, -strlen($renderer_file)) !== $renderer_file)

+ {

+ unlink($filename);

+ }

+ }

+ }

+

+ /**

+ * Generate and return a new configured instance of s9e\TextFormatter\Configurator

+ *

+ * @return Configurator

+ */

+ public function get_configurator()

+ {

+ // Create a new Configurator

+ $configurator = new Configurator;

+

+ /**

+ * Modify the s9e\TextFormatter configurator before the default settings are set

+ *

+ * @event core.text_formatter_s9e_configure_before

+ * @var \s9e\TextFormatter\Configurator configurator Configurator instance

+ * @since 3.2.0-a1

+ */

+ $vars = array('configurator');

+ extract($this->dispatcher->trigger_event('core.text_formatter_s9e_configure_before', compact($vars)));

+

+ // Convert newlines to br elements by default

+ $configurator->rootRules->enableAutoLineBreaks();

+

+ // Don't automatically ignore text in places where text is not allowed

+ $configurator->rulesGenerator->remove('IgnoreTextIfDisallowed');

+

+ // Don't remove comments and instead convert them to xsl:comment elements

+ $configurator->templateNormalizer->remove('RemoveComments');

+ $configurator->templateNormalizer->add('TransposeComments');

+

+ // Set the rendering engine and configure it to save to the cache dir

+ $configurator->rendering->engine = 'PHP';

+ $configurator->rendering->engine->cacheDir = $this->cache_dir;

+ $configurator->rendering->engine->defaultClassPrefix = 's9e_renderer_';

+ $configurator->rendering->engine->enableQuickRenderer = true;

+

+ // Create custom filters for BBCode tokens that are supported in phpBB but not in

+ // s9e\TextFormatter

+ $filter = new RegexpFilter('#^' . get_preg_expression('relative_url') . '$#Du');

+ $configurator->attributeFilters->add('#local_url', $filter);

+ $configurator->attributeFilters->add('#relative_url', $filter);

+

+ // INTTEXT regexp from acp_bbcodes

+ $filter = new RegexpFilter('!^([\p{L}\p{N}\-+,_. ]+)$!Du');

+ $configurator->attributeFilters->add('#inttext', $filter);

+

+ // Create custom filters for Flash restrictions, which use the same values as the image

+ // restrictions but have their own error message

+ $configurator->attributeFilters

+ ->add('#flashheight', __NAMESPACE__ . '\\parser::filter_flash_height')

+ ->addParameterByName('max_img_height')

+ ->addParameterByName('logger');

+

+ $configurator->attributeFilters

+ ->add('#flashwidth', __NAMESPACE__ . '\\parser::filter_flash_width')

+ ->addParameterByName('max_img_width')

+ ->addParameterByName('logger');

+

+ // Create a custom filter for phpBB's per-mode font size limits

+ $configurator->attributeFilters

+ ->add('#fontsize', __NAMESPACE__ . '\\parser::filter_font_size')

+ ->addParameterByName('max_font_size')

+ ->addParameterByName('logger')

+ ->markAsSafeInCSS();

+

+ // Create a custom filter for image URLs

+ $configurator->attributeFilters

+ ->add('#imageurl', __NAMESPACE__ . '\\parser::filter_img_url')

+ ->addParameterByName('urlConfig')

+ ->addParameterByName('logger')

+ ->addParameterByName('max_img_height')

+ ->addParameterByName('max_img_width')

+ ->markAsSafeAsURL();

+

+ // Add default BBCodes

+ foreach ($this->get_default_bbcodes($configurator) as $bbcode)

+ {

+ $configurator->BBCodes->addCustom($bbcode['usage'], $bbcode['template']);

+ }

+

+ // Modify the template to disable images/flash depending on user's settings

+ foreach (array('FLASH', 'IMG') as $name)

+ {

+ $tag = $configurator->tags[$name];

+ $tag->template = '<xsl:choose><xsl:when test="$S_VIEW' . $name . '">' . $tag->template . '</xsl:when><xsl:otherwise><xsl:apply-templates/></xsl:otherwise></xsl:choose>';

+ }

+

+ // Load custom BBCodes

+ foreach ($this->data_access->get_bbcodes() as $row)

+ {

+ // Insert the board's URL before {LOCAL_URL} tokens

+ $tpl = preg_replace_callback(

+ '#\\{LOCAL_URL\\d*\\}#',

+ function ($m)

+ {

+ return generate_board_url() . '/' . $m[0];

+ },

+ $row['bbcode_tpl']

+ );

+

+ try

+ {

+ $configurator->BBCodes->addCustom($row['bbcode_match'], new UnsafeTemplate($tpl));

+ }

+ catch (\Exception $e)

+ {

+ /**

+ * @todo log an error?

+ */

+ }

+ }

+

+ // Load smilies

+ foreach ($this->data_access->get_smilies() as $row)

+ {

+ $configurator->Emoticons->add(

+ $row['code'],

+ '<img class="smilies" src="{$T_SMILIES_PATH}/' . htmlspecialchars($row['smiley_url']) . '" alt="{.}" title="' . htmlspecialchars($row['emotion']) . '"/>'

+ );

+ }

+

+ if (isset($configurator->Emoticons))

+ {

+ // Force emoticons to be rendered as text if $S_VIEWSMILIES is not set

+ $configurator->Emoticons->notIfCondition = 'not($S_VIEWSMILIES)';

+

+ // Only parse emoticons at the beginning of the text or if they're preceded by any

+ // one of: a new line, a space, a dot, or a right square bracket

+ $configurator->Emoticons->notAfter = '[^\\n .\\]]';

+ }

+

+ // Load the censored words

+ $censor = $this->data_access->get_censored_words();

+ if (!empty($censor))

+ {

+ // Use a namespaced tag to avoid collisions

+ $configurator->plugins->load('Censor', array('tagName' => 'censor:tag'));

+ foreach ($censor as $row)

+ {

+ // NOTE: words are stored as HTML, we need to decode them to plain text

+ $configurator->Censor->add(htmlspecialchars_decode($row['word']), htmlspecialchars_decode($row['replacement']));

+ }

+ }

+

+ // Load the magic links plugins. We do that after BBCodes so that they use the same tags

+ $configurator->plugins->load('Autoemail');

+ $configurator->plugins->load('Autolink', array('matchWww' => true));

+

+ // Register some vars with a default value. Those should be set at runtime by whatever calls

+ // the parser

+ $configurator->registeredVars['max_font_size'] = 0;

+ $configurator->registeredVars['max_img_height'] = 0;

+ $configurator->registeredVars['max_img_width'] = 0;

+

+ /**

+ * Modify the s9e\TextFormatter configurator after the default settings are set

+ *

+ * @event core.text_formatter_s9e_configure_after

+ * @var \s9e\TextFormatter\Configurator configurator Configurator instance

+ * @since 3.2.0-a1

+ */

+ $vars = array('configurator');

+ extract($this->dispatcher->trigger_event('core.text_formatter_s9e_configure_after', compact($vars)));

+

+ return $configurator;

+ }

+

+ /**

+ * Regenerate and cache a new parser and renderer

+ *

+ * @return array Associative array with at least two elements: "parser" and "renderer"

+ */

+ public function regenerate()

+ {

+ $configurator = $this->get_configurator();

+

+ // Get the censor helper and remove the Censor plugin if applicable

+ if (isset($configurator->Censor))

+ {

+ $censor = $configurator->Censor->getHelper();

+ unset($configurator->Censor);

+ unset($configurator->tags['censor:tag']);

+ }

+

+ $objects = $configurator->finalize();

+ $parser = $objects['parser'];

+ $renderer = $objects['renderer'];

+

+ // Cache the parser as-is

+ $this->cache->put($this->cache_key_parser, $parser);

+

+ // We need to cache the name of the renderer's generated class

+ $renderer_data = array('class' => get_class($renderer));

+ if (isset($censor))

+ {

+ $renderer_data['censor'] = $censor;

+ }

+ $this->cache->put($this->cache_key_renderer, $renderer_data);

+

+ return array('parser' => $parser, 'renderer' => $renderer);

+ }

+

+ /**

+ * Return the default BBCodes configuration

+ *

+ * @return array 2D array. Each element has a 'usage' key, a 'template' key, and an optional 'options' key

+ */

+ protected function get_default_bbcodes($configurator)

+ {

+ // For each BBCode, build an associative array matching style_ids to their template

+ $templates = array();

+ foreach ($this->data_access->get_styles_templates() as $style_id => $data)

+ {

+ foreach ($this->extract_templates($data['template']) as $bbcode_name => $template)

+ {

+ $templates[$bbcode_name][$style_id] = $template;

+ }

+

+ // Add default templates wherever missing, or for BBCodes that were not specified in

+ // this template's bitfield. For instance, prosilver has a custom template for b but its

+ // bitfield does not enable it so the default template is used instead

+ foreach ($this->default_templates as $bbcode_name => $template)

+ {

+ if (!isset($templates[$bbcode_name][$style_id]) || !in_array($bbcode_name, $data['bbcodes'], true))

+ {

+ $templates[$bbcode_name][$style_id] = $template;

+ }

+ }

+ }

+

+ // Replace custom tokens and normalize templates

+ foreach ($templates as $bbcode_name => $style_templates)

+ {

+ foreach ($style_templates as $i => $template)

+ {

+ if (isset($this->custom_tokens[$bbcode_name]))

+ {

+ $template = strtr($template, $this->custom_tokens[$bbcode_name]);

+ }

+

+ $templates[$bbcode_name][$i] = $configurator->templateNormalizer->normalizeTemplate($template);

+ }

+ }

+

+ $bbcodes = array();

+ foreach ($this->default_definitions as $bbcode_name => $usage)

+ {

+ $bbcodes[$bbcode_name] = array(

+ 'usage' => $usage,

+ 'template' => $this->merge_templates($templates[$bbcode_name]),

+ );

+ }

+

+ return $bbcodes;

+ }

+

+ /**

+ * Extract and recompose individual BBCode templates from a style's template file

+ *

+ * @param string $template Style template (bbcode.html)

+ * @return array Associative array matching BBCode names to their template

+ */

+ protected function extract_templates($template)

+ {

+ // Capture the template fragments

+ preg_match_all('#<!-- BEGIN (.*?) -->(.*?)<!-- END .*? -->#s', $template, $matches, PREG_SET_ORDER);

+

+ $fragments = array();

+ foreach ($matches as $match)

+ {

+ // Normalize the whitespace

+ $fragment = preg_replace('#>\\n\\t*<#', '><', trim($match[2]));

+

+ $fragments[$match[1]] = $fragment;

+ }

+

+ // Automatically recompose templates split between *_open and *_close

+ foreach ($fragments as $fragment_name => $fragment)

+ {

+ if (preg_match('#^(\\w+)_close$#', $fragment_name, $match))

+ {

+ $bbcode_name = $match[1];

+

+ if (isset($fragments[$bbcode_name . '_open']))

+ {

+ $templates[$bbcode_name] = $fragments[$bbcode_name . '_open'] . '<xsl:apply-templates/>' . $fragment;

+ }

+ }

+ }

+

+ // Manually recompose and overwrite irregular templates

+ $templates['list'] =

+ '<xsl:choose>

+ <xsl:when test="not(@type)">

+ ' . $fragments['ulist_open_default'] . '<xsl:apply-templates/>' . $fragments['ulist_close'] . '

+ </xsl:when>

+ <xsl:when test="contains(\'upperlowerdecim\',substring(@type,1,5))">

+ ' . $fragments['olist_open'] . '<xsl:apply-templates/>' . $fragments['olist_close'] . '

+ </xsl:when>

+ <xsl:otherwise>

+ ' . $fragments['ulist_open'] . '<xsl:apply-templates/>' . $fragments['ulist_close'] . '

+ </xsl:otherwise>

+ </xsl:choose>';

+

+ $templates['li'] = $fragments['listitem'] . '<xsl:apply-templates/>' . $fragments['listitem_close'];

+

+ $fragments['quote_username_open'] = str_replace(

+ '{USERNAME}',

+ '<xsl:choose>

+ <xsl:when test="@url">' . str_replace('{DESCRIPTION}', '{USERNAME}', $fragments['url']) . '</xsl:when>

+ <xsl:otherwise>{USERNAME}</xsl:otherwise>

+ </xsl:choose>',

+ $fragments['quote_username_open']

+ );

+

+ $templates['quote'] =

+ '<xsl:choose>

+ <xsl:when test="@author">

+ ' . $fragments['quote_username_open'] . '<xsl:apply-templates/>' . $fragments['quote_close'] . '

+ </xsl:when>

+ <xsl:otherwise>

+ ' . $fragments['quote_open'] . '<xsl:apply-templates/>' . $fragments['quote_close'] . '

+ </xsl:otherwise>

+ </xsl:choose>';

+

+ // The [attachment] BBCode uses the inline_attachment template to output a comment that

+ // is post-processed by parse_attachments()

+ $templates['attachment'] = $fragments['inline_attachment_open'] . '<xsl:comment> ia<xsl:value-of select="@index"/> </xsl:comment><xsl:value-of select="@filename"/><xsl:comment> ia<xsl:value-of select="@index"/> </xsl:comment>' . $fragments['inline_attachment_close'];

+

+ // Add fragments as templates

+ foreach ($fragments as $fragment_name => $fragment)

+ {

+ if (preg_match('#^\\w+$#', $fragment_name))

+ {

+ $templates[$fragment_name] = $fragment;

+ }

+ }

+

+ // Keep only templates that are named after an existing BBCode

+ $templates = array_intersect_key($templates, $this->default_definitions);

+

+ return $templates;

+ }

+

+ /**

+ * Merge the templates from any number of styles into one BBCode template

+ *

+ * When multiple templates are available for the same BBCode (because of multiple styles) we

+ * merge them into a single template that uses an xsl:choose construct that determines which

+ * style to use at rendering time.

+ *

+ * @param array $style_templates Associative array matching style_ids to their template

+ * @return string

+ */

+ protected function merge_templates(array $style_templates)

+ {

+ // Return the template as-is if there's only one style or all styles share the same template

+ if (count(array_unique($style_templates)) === 1)

+ {

+ return end($style_templates);

+ }

+

+ // Group identical templates together

+ $grouped_templates = array();

+ foreach ($style_templates as $style_id => $style_template)

+ {

+ $grouped_templates[$style_template][] = '$STYLE_ID=' . $style_id;

+ }

+

+ // Sort templates by frequency descending

+ $templates_cnt = array_map('sizeof', $grouped_templates);

+ array_multisort($grouped_templates, $templates_cnt);

+

+ // Remove the most frequent template from the list; It becomes the default

+ reset($grouped_templates);

+ $default_template = key($grouped_templates);

+ unset($grouped_templates[$default_template]);

+

+ // Build an xsl:choose switch

+ $template = '<xsl:choose>';

+ foreach ($grouped_templates as $style_template => $exprs)

+ {

+ $template .= '<xsl:when test="' . implode(' or ', $exprs) . '">' . $style_template . '</xsl:when>';

+ }

+ $template .= '<xsl:otherwise>' . $default_template . '</xsl:otherwise></xsl:choose>';

+

+ return $template;

+ }

+}

+<?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.

+*

+*/

+

+namespace phpbb\textformatter\s9e;

+

+use s9e\TextFormatter\Parser\BuiltInFilters;

+use s9e\TextFormatter\Parser\Logger;

+

+/**

+* s9e\TextFormatter\Parser adapter

+*/

+class parser implements \phpbb\textformatter\parser_interface

+{

+ /**

+ * @var \phpbb\event\dispatcher_interface

+ */

+ protected $dispatcher;

+

+ /**

+ * @var \s9e\TextFormatter\Parser

+ */

+ protected $parser;

+

+ /**

+ * @var \phpbb\user User object, used for translating errors

+ */

+ protected $user;

+

+ /**

+ * Constructor

+ *

+ * @param \phpbb\cache\driver_interface $cache

+ * @param string $key Cache key

+ * @param \phpbb\user $user

+ * @param factory $factory

+ * @param \phpbb\event\dispatcher_interface $dispatcher

+ */

+ public function __construct(\phpbb\cache\driver\driver_interface $cache, $key, \phpbb\user $user, factory $factory, \phpbb\event\dispatcher_interface $dispatcher)

+ {

+ $parser = $cache->get($key);

+ if (!$parser)

+ {

+ $objects = $factory->regenerate();

+ $parser = $objects['parser'];

+ }

+

+ $this->dispatcher = $dispatcher;

+ $this->parser = $parser;

+ $this->user = $user;

+ $parser = $this;

+

+ /**

+ * Configure the parser service

+ *

+ * Can be used to:

+ * - toggle features according to the user's preferences,

+ * - toggle BBCodes according to the user's permissions,

+ * - register variables or custom parsers in the s9e\TextFormatter

+ * - configure the s9e\TextFormatter parser

+ *

+ * @event core.text_formatter_s9e_parser_setup

+ * @var \phpbb\textformatter\s9e\parser parser This parser service

+ * @var \phpbb\user user Current user

+ * @since 3.2.0-a1

+ */

+ $vars = array('parser', 'user');

+ extract($dispatcher->trigger_event('core.text_formatter_s9e_parser_setup', compact($vars)));

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function parse($text)

+ {

+ $parser = $this;

+

+ /**

+ * Modify a text before it is parsed

+ *

+ * @event core.text_formatter_s9e_parse_before

+ * @var \phpbb\textformatter\s9e\parser parser This parser service

+ * @var string text The original text

+ * @since 3.2.0-a1

+ */

+ $vars = array('parser', 'text');

+ extract($this->dispatcher->trigger_event('core.text_formatter_s9e_parse_before', compact($vars)));

+

+ $xml = $this->parser->parse($text);

+

+ /**

+ * Modify a parsed text in its XML form

+ *

+ * @event core.text_formatter_s9e_parse_after

+ * @var \phpbb\textformatter\s9e\parser parser This parser service

+ * @var string xml The parsed text, in XML

+ * @since 3.2.0-a1

+ */

+ $vars = array('parser', 'xml');

+ extract($this->dispatcher->trigger_event('core.text_formatter_s9e_parse_after', compact($vars)));

+

+ return $xml;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function disable_bbcode($name)

+ {

+ $this->parser->disableTag(strtoupper($name));

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function disable_bbcodes()

+ {

+ $this->parser->disablePlugin('BBCodes');

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function disable_censor()

+ {

+ $this->parser->disablePlugin('Censor');

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function disable_magic_url()

+ {

+ $this->parser->disablePlugin('Autoemail');

+ $this->parser->disablePlugin('Autolink');

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function disable_smilies()

+ {

+ $this->parser->disablePlugin('Emoticons');

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function enable_bbcode($name)

+ {

+ $this->parser->enableTag(strtoupper($name));

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function enable_bbcodes()

+ {

+ $this->parser->enablePlugin('BBCodes');

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function enable_censor()

+ {

+ $this->parser->enablePlugin('Censor');

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function enable_magic_url()

+ {

+ $this->parser->enablePlugin('Autoemail');

+ $this->parser->enablePlugin('Autolink');

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function enable_smilies()

+ {

+ $this->parser->enablePlugin('Emoticons');

+ }

+

+ /**

+ * {@inheritdoc}

+ *

+ * This will translate the log entries found in s9e\TextFormatter's logger into phpBB error

+ * messages

+ */

+ public function get_errors()

+ {

+ $errors = array();

+

+ foreach ($this->parser->getLogger()->get() as $entry)

+ {

+ list($type, $msg, $context) = $entry;

+

+ if ($msg === 'Tag limit exceeded')

+ {

+ if ($context['tagName'] === 'E')

+ {

+ $errors[] = $this->user->lang('TOO_MANY_SMILIES', $context['tagLimit']);

+ }

+ else if ($context['tagName'] === 'URL')

+ {

+ $errors[] = $this->user->lang('TOO_MANY_URLS', $context['tagLimit']);

+ }

+ }

+ else if ($msg === 'MAX_FONT_SIZE_EXCEEDED')

+ {

+ $errors[] = $this->user->lang($msg, $context['max_size']);

+ }

+ else if (preg_match('/^MAX_(?:FLASH|IMG)_(HEIGHT|WIDTH)_EXCEEDED$/D', $msg, $m))

+ {

+ $errors[] = $this->user->lang($msg, $context['max_' . strtolower($m[1])]);

+ }

+ else if ($msg === 'Tag is disabled')

+ {

+ $name = strtolower($context['tag']->getName());

+ $errors[] = $this->user->lang('UNAUTHORISED_BBCODE', '[' . $name . ']');

+ }

+ else if ($msg === 'UNABLE_GET_IMAGE_SIZE')

+ {

+ $errors[] = $this->user->lang($msg);

+ }

+ }

+

+ return array_unique($errors);

+ }

+

+ /**

+ * Return the instance of s9e\TextFormatter\Parser used by this object

+ *

+ * @return \s9e\TextFormatter\Parser

+ */

+ public function get_parser()

+ {

+ return $this->parser;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function set_var($name, $value)

+ {

+ if ($name === 'max_smilies')

+ {

+ $this->parser->setTagLimit('E', $value ?: PHP_INT_MAX);

+ }

+ else if ($name === 'max_urls')

+ {

+ $this->parser->setTagLimit('URL', $value ?: PHP_INT_MAX);

+ }

+ else

+ {

+ $this->parser->registeredVars[$name] = $value;

+ }

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function set_vars(array $vars)

+ {

+ foreach ($vars as $name => $value)

+ {

+ $this->set_var($name, $value);

+ }

+ }

+

+ /**

+ * Filter a flash object's height

+ *

+ * @see bbcode_firstpass::bbcode_flash()

+ *

+ * @param string $height

+ * @param integer $max_height

+ * @param Logger $logger

+ * @return mixed Original value if valid, FALSE otherwise

+ */

+ static public function filter_flash_height($height, $max_height, Logger $logger)

+ {

+ if ($max_height && $height > $max_height)

+ {

+ $logger->err('MAX_FLASH_HEIGHT_EXCEEDED', array('max_height' => $max_height));

+

+ return false;

+ }

+

+ return $height;

+ }

+

+ /**

+ * Filter a flash object's width

+ *

+ * @see bbcode_firstpass::bbcode_flash()

+ *

+ * @param string $width

+ * @param integer $max_width

+ * @param Logger $logger

+ * @return mixed Original value if valid, FALSE otherwise

+ */

+ static public function filter_flash_width($width, $max_width, Logger $logger)

+ {

+ if ($max_width && $width > $max_width)

+ {

+ $logger->err('MAX_FLASH_WIDTH_EXCEEDED', array('max_width' => $max_width));

+

+ return false;

+ }

+

+ return $width;

+ }

+

+ /**

+ * Filter the value used in a [size] BBCode

+ *

+ * @see bbcode_firstpass::bbcode_size()

+ *

+ * @param string $size Original size

+ * @param integer $max_size Maximum allowed size

+ * @param Logger $logger

+ * @return mixed Original value if valid, FALSE otherwise

+ */

+ static public function filter_font_size($size, $max_size, Logger $logger)

+ {

+ if ($max_size && $size > $max_size)

+ {

+ $logger->err('MAX_FONT_SIZE_EXCEEDED', array('max_size' => $max_size));

+

+ return false;

+ }

+

+ if ($size < 1)

+ {

+ return false;

+ }

+

+ return $size;

+ }

+

+ /**

+ * Filter an image's URL to enforce restrictions on its dimensions

+ *

+ * @see bbcode_firstpass::bbcode_img()

+ *

+ * @param string $url Original URL

+ * @param array $url_config Config used by the URL filter

+ * @param Logger $logger

+ * @param integer $max_height Maximum height allowed

+ * @param integer $max_width Maximum width allowed

+ * @return string|bool Original value if valid, FALSE otherwise

+ */

+ static public function filter_img_url($url, array $url_config, Logger $logger, $max_height, $max_width)

+ {

+ // Validate the URL

+ $url = BuiltInFilters::filterUrl($url, $url_config, $logger);

+

+ if ($url === false)

+ {

+ return false;

+ }

+

+ if ($max_height || $max_width)

+ {

+ $stats = @getimagesize($url);

+

+ if ($stats === false)

+ {

+ $logger->err('UNABLE_GET_IMAGE_SIZE');

+

+ return false;

+ }

+

+ if ($max_height && $max_height < $stats[1])

+ {

+ $logger->err('MAX_IMG_HEIGHT_EXCEEDED', array('max_height' => $max_height));

+

+ return false;

+ }

+

+ if ($max_width && $max_width < $stats[0])

+ {

+ $logger->err('MAX_IMG_WIDTH_EXCEEDED', array('max_width' => $max_width));

+

+ return false;

+ }

+ }

+

+ return $url;

+ }

+}

+<?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.

+*

+*/

+

+namespace phpbb\textformatter\s9e;

+

+/**

+* s9e\TextFormatter\Renderer adapter

+*/

+class renderer implements \phpbb\textformatter\renderer_interface

+{

+ /**

+ * @var \s9e\TextFormatter\Plugins\Censor\Helper

+ */

+ protected $censor;

+

+ /**

+ * @var \phpbb\event\dispatcher_interface

+ */

+ protected $dispatcher;

+

+ /**

+ * @var \s9e\TextFormatter\Renderer

+ */

+ protected $renderer;

+

+ /**

+ * @var bool Status of the viewcensors option

+ */

+ protected $viewcensors = false;

+

+ /**

+ * @var bool Status of the viewflash option

+ */

+ protected $viewflash = false;

+

+ /**

+ * @var bool Status of the viewimg option

+ */

+ protected $viewimg = false;

+

+ /**

+ * @var bool Status of the viewsmilies option

+ */

+ protected $viewsmilies = false;

+

+ /**

+ * Constructor

+ *

+ * @param \phpbb\cache\driver\driver_interface $cache

+ * @param string $cache_dir Path to the cache dir

+ * @param string $key Cache key

+ * @param factory $factory

+ * @param \phpbb\event\dispatcher_interface $dispatcher

+ */

+ public function __construct(\phpbb\cache\driver\driver_interface $cache, $cache_dir, $key, factory $factory, \phpbb\event\dispatcher_interface $dispatcher)

+ {

+ $renderer_data = $cache->get($key);

+ if ($renderer_data)

+ {

+ $class = $renderer_data['class'];

+ if (!class_exists($class, false))

+ {

+ // Try to load the renderer class from its cache file

+ $cache_file = $cache_dir . $class . '.php';

+

+ if (file_exists($cache_file))

+ {

+ include($cache_file);

+ }

+ }

+ if (class_exists($class, false))

+ {

+ $renderer = new $class;

+ }

+ if (isset($renderer_data['censor']))

+ {

+ $censor = $renderer_data['censor'];

+ }

+ }

+ if (!isset($renderer))

+ {

+ $objects = $factory->regenerate();

+ $renderer = $objects['renderer'];

+ }

+

+ if (isset($censor))

+ {

+ $this->censor = $censor;

+ }

+ $this->dispatcher = $dispatcher;

+ $this->renderer = $renderer;

+ $renderer = $this;

+

+ /**

+ * Configure the renderer service

+ *

+ * @event core.text_formatter_s9e_renderer_setup

+ * @var \phpbb\textformatter\s9e\renderer renderer This renderer service

+ * @since 3.2.0-a1

+ */

+ $vars = array('renderer');

+ extract($dispatcher->trigger_event('core.text_formatter_s9e_renderer_setup', compact($vars)));

+ }

+

+ /**

+ * Automatically set the smilies path based on config

+ *

+ * @param \phpbb\config\config $config

+ * @param \phpbb\path_helper $path_helper

+ * @return null

+ */

+ public function configure_smilies_path(\phpbb\config\config $config, \phpbb\path_helper $path_helper)

+ {

+ /**

+ * @see smiley_text()

+ */

+ $root_path = (defined('PHPBB_USE_BOARD_URL_PATH') && PHPBB_USE_BOARD_URL_PATH) ? generate_board_url() . '/' : $path_helper->get_web_root_path();

+

+ $this->set_smilies_path($root_path . $config['smilies_path']);

+ }

+

+ /**

+ * Configure this renderer as per the user's settings

+ *

+ * Should set the locale as well as the viewcensor/viewflash/viewimg/viewsmilies options.

+ *

+ * @param \phpbb\user $user

+ * @param \phpbb\config\config $config

+ * @param \phpbb\auth\auth $auth

+ * @return null

+ */

+ public function configure_user(\phpbb\user $user, \phpbb\config\config $config, \phpbb\auth\auth $auth)

+ {

+ $censor = $user->optionget('viewcensors') || !$config['allow_nocensors'] || !$auth->acl_get('u_chgcensors');

+

+ $this->set_viewcensors($censor);

+ $this->set_viewflash($user->optionget('viewflash'));

+ $this->set_viewimg($user->optionget('viewimg'));

+ $this->set_viewsmilies($user->optionget('viewsmilies'));

+

+ // Set the stylesheet parameters

+ foreach (array_keys($this->renderer->getParameters()) as $param_name)

+ {

+ if (strpos($param_name, 'L_') === 0)

+ {

+ // L_FOO is set to $user->lang('FOO')

+ $this->renderer->setParameter($param_name, $user->lang(substr($param_name, 2)));

+ }

+ }

+

+ // Set this user's style id and other parameters

+ $this->renderer->setParameters(array(

+ 'S_IS_BOT' => $user->data['is_bot'],

+ 'S_REGISTERED_USER' => $user->data['is_registered'],

+ 'S_USER_LOGGED_IN' => ($user->data['user_id'] != ANONYMOUS),

+ 'STYLE_ID' => $user->style['style_id'],

+ ));

+ }

+

+ /**

+ * Return the instance of s9e\TextFormatter\Renderer used by this object

+ *

+ * @return \s9e\TextFormatter\Renderer

+ */

+ public function get_renderer()

+ {

+ return $this->renderer;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function get_viewcensors()

+ {

+ return $this->viewcensors;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function get_viewflash()

+ {

+ return $this->viewflash;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function get_viewimg()

+ {

+ return $this->viewimg;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function get_viewsmilies()

+ {

+ return $this->viewsmilies;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function render($xml)

+ {

+ $renderer = $this;

+

+ /**

+ * Modify a parsed text before it is rendered

+ *

+ * @event core.text_formatter_s9e_render_before

+ * @var \phpbb\textformatter\s9e\renderer renderer This renderer service

+ * @var string xml The parsed text, in its XML form

+ * @since 3.2.0-a1

+ */

+ $vars = array('renderer', 'xml');

+ extract($this->dispatcher->trigger_event('core.text_formatter_s9e_render_before', compact($vars)));

+

+ if (isset($this->censor) && $this->viewcensors)

+ {

+ // NOTE: censorHtml() is XML-safe

+ $xml = $this->censor->censorHtml($xml, true);

+ }

+

+ $html = $this->renderer->render($xml);

+ if (stripos($html, '<code') !== false)

+ {

+ $html = $this->replace_tabs_in_code($html);

+ }

+

+ /**

+ * Modify a rendered text

+ *

+ * @event core.text_formatter_s9e_render_after

+ * @var string html The rendered text's HTML

+ * @var \phpbb\textformatter\s9e\renderer renderer This renderer service

+ * @since 3.2.0-a1

+ */

+ $vars = array('html', 'renderer');

+ extract($this->dispatcher->trigger_event('core.text_formatter_s9e_render_after', compact($vars)));

+

+ return $html;

+ }

+

+ /**

+ * Replace tabs in code elements

+ *

+ * @see bbcode::bbcode_second_pass_code()

+ *

+ * @param string $html Original HTML

+ * @return string Modified HTML

+ */

+ protected function replace_tabs_in_code($html)

+ {

+ return preg_replace_callback(

+ '((<code[^>]*>)(.*?)(</code>))is',

+ function ($captures)

+ {

+ $code = $captures[2];

+

+ $code = str_replace("\t", '&nbsp; &nbsp;', $code);

+ $code = str_replace(' ', '&nbsp; ', $code);

+ $code = str_replace(' ', ' &nbsp;', $code);

+ $code = str_replace("\n ", "\n&nbsp;", $code);

+

+ // keep space at the beginning

+ if (!empty($code) && $code[0] == ' ')

+ {

+ $code = '&nbsp;' . substr($code, 1);

+ }

+

+ // remove newline at the beginning

+ if (!empty($code) && $code[0] == "\n")

+ {

+ $code = substr($code, 1);

+ }

+

+ return $captures[1] . $code . $captures[3];

+ },

+ $html

+ );

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function set_smilies_path($path)

+ {

+ $this->renderer->setParameter('T_SMILIES_PATH', $path);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function set_viewcensors($value)

+ {

+ $this->viewcensors = $value;

+ $this->renderer->setParameter('S_VIEWCENSORS', $value);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function set_viewflash($value)

+ {

+ $this->viewflash = $value;

+ $this->renderer->setParameter('S_VIEWFLASH', $value);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function set_viewimg($value)

+ {

+ $this->viewimg = $value;

+ $this->renderer->setParameter('S_VIEWIMG', $value);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function set_viewsmilies($value)

+ {

+ $this->viewsmilies = $value;

+ $this->renderer->setParameter('S_VIEWSMILIES', $value);

+ }

+}

+<?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.

+*

+*/

+

+namespace phpbb\textformatter\s9e;

+

+/**

+* Text manipulation utilities

+*/

+class utils implements \phpbb\textformatter\utils_interface

+{

+ /**

+ * Replace BBCodes and other formatting elements with whitespace

+ *

+ * NOTE: preserves smilies as text

+ *

+ * @param string $xml Parsed text

+ * @return string Plain text

+ */

+ public function clean_formatting($xml)

+ {

+ // Insert a space before <s> and <e> then remove formatting

+ $xml = preg_replace('#<[es]>#', ' $0', $xml);

+

+ return \s9e\TextFormatter\Utils::removeFormatting($xml);

+ }

+

+ /**

+ * Remove given BBCode and its content, at given nesting depth

+ *

+ * @param string $xml Parsed text

+ * @param string $bbcode_name BBCode's name

+ * @param integer $depth Minimum nesting depth (number of parents of the same name)

+ * @return string Parsed text

+ */

+ public function remove_bbcode($xml, $bbcode_name, $depth = 0)

+ {

+ return \s9e\TextFormatter\Utils::removeTag($xml, strtoupper($bbcode_name), $depth);

+ }

+

+ /**

+ * Return a parsed text to its original form

+ *

+ * @param string $xml Parsed text

+ * @return string Original plain text

+ */

+ public function unparse($xml)

+ {

+ return \s9e\TextFormatter\Unparser::unparse($xml);

+ }

+}

+<?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.

+*

+*/

+

+namespace phpbb\textformatter;

+

+/**

+* Used to manipulate a parsed text

+*/

+interface utils_interface

+{

+ /**

+ * Replace BBCodes and other formatting elements with whitespace

+ *

+ * NOTE: preserves smilies as text

+ *

+ * @param string $text Parsed text

+ * @return string Plain text

+ */

+ public function clean_formatting($text);

+

+ /**

+ * Remove given BBCode and its content, at given nesting depth

+ *

+ * @param string $text Parsed text

+ * @param string $bbcode_name BBCode's name

+ * @param integer $depth Minimum nesting depth (number of parents of the same name)

+ * @return string Parsed text

+ */

+ public function remove_bbcode($text, $bbcode_name, $depth = 0);

+

+ /**

+ * Return a parsed text to its original form

+ *

+ * @param string $text Parsed text

+ * @return string Original plain text

+ */

+ public function unparse($text);

+}