+ "s9e/text-formatter": "dev-release/php5.3",

+ "hash": "25df57c9c90534dcc86d31175b248719",

+ "notification-url": "http://packagist.org/downloads/",

+ "name": "s9e/text-formatter",

+ "version": "dev-release/php5.3",

+ "source": {

+ "type": "git",

+ "url": "https://github.com/s9e/TextFormatter.git",

+ "reference": "4e0d311a3c56d0db4a7789e31457053be8148283"

+ },

+ "dist": {

+ "type": "zip",

+ "url": "https://api.github.com/repos/s9e/TextFormatter/zipball/4e0d311a3c56d0db4a7789e31457053be8148283",

+ "reference": "4e0d311a3c56d0db4a7789e31457053be8148283",

+ "shasum": ""

+ },

+ "require": {

+ "ext-dom": "*",

+ "ext-filter": "*",

+ "lib-pcre": ">=7.2",

+ "php": ">=5.3.3"

+ },

+ "suggest": {

+ "ext-intl": "Allows international URLs to be accepted by the URL filter",

+ "ext-json": "Enables the generation of a JavaScript parser",

+ "ext-mbstring": "Enables some optimizations in the PHP renderer",

+ "ext-tokenizer": "Enables optimizations in the PHP renderer",

+ "ext-xsl": "Enables the XSLT renderer",

+ "ext-zlib": "Enables gzip compression when scraping content via the MediaEmbed plugin"

+ },

+ "type": "library",

+ "autoload": {

+ "psr-4": {

+ "s9e\\TextFormatter\\": "src"

+ }

+ },

+ "notification-url": "https://packagist.org/downloads/",

+ "license": [

+ "MIT"

+ ],

+ "description": "Multi-purpose text formatting and markup library. Plugins offer support for BBCodes, Markdown, emoticons, HTML, embedding media (YouTube, etc...), enhanced typography and more.",

+ "keywords": [

+ "bbcode",

+ "bbcodes",

+ "blog",

+ "censor",

+ "embed",

+ "emoji",

+ "emoticons",

+ "engine",

+ "forum",

+ "html",

+ "markdown",

+ "markup",

+ "media",

+ "parser",

+ "shortcodes"

+ ],

+ "time": "2015-03-30 22:52:16"

+ },

+ {

+ "notification-url": "http://packagist.org/downloads/",

+ "email": "fabien@symfony.com"

+ "email": "mrook@php.net"

+ "s9e/text-formatter": 20,

+ - { resource: services_text_formatter.yml }

+# ----- DB Extractor -----

+ dbal.extractor.factory:

+ class: phpbb\db\extractor\factory

+ arguments:

+ - @dbal.conn.driver

+ - @service_container

+

+ dbal.extractor:

+ class: phpbb\db\extractor\extractor_interface

+ factory: ["@dbal.extractor.factory", get]

+

+# ----- DB Extractors for different drivers -----

+# Scope MUST be prototype for all the handlers to work correctly.

+ dbal.extractor.extractors.mssql_extractor:

+ class: phpbb\db\extractor\mssql_extractor

+ scope: prototype

+ arguments:

+ - %core.root_path%

+ - @request

+ - @dbal.conn.driver

+

+ dbal.extractor.extractors.mysql_extractor:

+ class: phpbb\db\extractor\mysql_extractor

+ scope: prototype

+ arguments:

+ - %core.root_path%

+ - @request

+ - @dbal.conn.driver

+

+ dbal.extractor.extractors.oracle_extractor:

+ class: phpbb\db\extractor\oracle_extractor

+ scope: prototype

+ arguments:

+ - %core.root_path%

+ - @request

+ - @dbal.conn.driver

+

+ dbal.extractor.extractors.postgres_extractor:

+ class: phpbb\db\extractor\postgres_extractor

+ scope: prototype

+ arguments:

+ - %core.root_path%

+ - @request

+ - @dbal.conn.driver

+

+ dbal.extractor.extractors.sqlite3_extractor:

+ class: phpbb\db\extractor\sqlite3_extractor

+ scope: prototype

+ arguments:

+ - %core.root_path%

+ - @request

+ - @dbal.conn.driver

+

+ dbal.extractor.extractors.sqlite_extractor:

+ class: phpbb\db\extractor\sqlite_extractor

+ scope: prototype

+ arguments:

+ - %core.root_path%

+ - @request

+ - @dbal.conn.driver

+

+parameters:

+ text_formatter.cache.dir: %core.root_path%cache/%core.environment%/

+ text_formatter.cache.parser.key: _text_formatter_parser

+ text_formatter.cache.renderer.key: _text_formatter_renderer

+

+services:

+ text_formatter.cache:

+ alias: text_formatter.s9e.factory

+

+ text_formatter.data_access:

+ class: phpbb\textformatter\data_access

+ arguments:

+ - @dbal.conn

+ - %tables.bbcodes%

+ - %tables.smilies%

+ - %tables.styles%

+ - %tables.words%

+ - %core.root_path%styles/

+

+ text_formatter.parser:

+ alias: text_formatter.s9e.parser

+

+ text_formatter.renderer:

+ alias: text_formatter.s9e.renderer

+

+ text_formatter.utils:

+ alias: text_formatter.s9e.utils

+

+ text_formatter.s9e.factory:

+ class: phpbb\textformatter\s9e\factory

+ arguments:

+ - @text_formatter.data_access

+ - @cache.driver

+ - @dispatcher

+ - %text_formatter.cache.dir%

+ - %text_formatter.cache.parser.key%

+ - %text_formatter.cache.renderer.key%

+

+ text_formatter.s9e.parser:

+ class: phpbb\textformatter\s9e\parser

+ arguments:

+ - @cache.driver

+ - %text_formatter.cache.parser.key%

+ - @user

+ - @text_formatter.s9e.factory

+ - @dispatcher

+

+ text_formatter.s9e.renderer:

+ class: phpbb\textformatter\s9e\renderer

+ arguments:

+ - @cache.driver

+ - %text_formatter.cache.dir%

+ - %text_formatter.cache.renderer.key%

+ - @text_formatter.s9e.factory

+ - @dispatcher

+ calls:

+ - [configure_smilies_path, [@config, @path_helper]]

+ - [configure_user, [@user, @config, @auth]]

+

+ text_formatter.s9e.utils:

+ class: phpbb\textformatter\s9e\utils

+ tables.bbcodes: %core.table_prefix%bbcodes

+ tables.smilies: %core.table_prefix%smilies

+ tables.styles: %core.table_prefix%styles

+ tables.words: %core.table_prefix%words

+ <li><a href="#v313">Changes since 3.1.3</a></li>

+ <li><a href="#v313rc1">Changes since 3.1.3-RC1</a></li>

+ <a name="v313"></a><h3>Changes since 3.1.3</h3>

+

+ <h4>Bug</h4>

+ <ul>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-8050">PHPBB3-8050</a>] - Avatar &amp; Long PM recipients list break out of template</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-8250">PHPBB3-8250</a>] - Forum selections in MCP queue not working</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-8494">PHPBB3-8494</a>] - Cannot install two boards on the same postgresql database</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11424">PHPBB3-11424</a>] - Quick-Mod Tools race condition results in NO_MODE</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-12368">PHPBB3-12368</a>] - Updating database fails in upgrade from 3.0 when trying twice without purging the cache</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13348">PHPBB3-13348</a>] - sql_freeresult() should be called in feed base class</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13414">PHPBB3-13414</a>] - download/file.php 304 Not Modified bug</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13433">PHPBB3-13433</a>] - A dot in email address leads to unwanted extraneous dot</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13463">PHPBB3-13463</a>] - Mark read icon displays on wrong side in RTL</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13469">PHPBB3-13469</a>] - Soft delete fails with error message</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13472">PHPBB3-13472</a>] - Notification for admin activation of user doesn't get pruned after the user is deleted</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13477">PHPBB3-13477</a>] - File caching of extensions' version check file doesn't work</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13493">PHPBB3-13493</a>] - $helper-&gt;route gives wrong path for guests with trailing slashes and mod_rewrite disabled</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13522">PHPBB3-13522</a>] - Q&amp;A Captcha ACP, admins can add blank answers</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13538">PHPBB3-13538</a>] - Add tests for pagination in nested loops</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13542">PHPBB3-13542</a>] - Add $error to core UCP event for better validating of new UCP options</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13550">PHPBB3-13550</a>] - Invalid JSON response returned when plupload dir is not writable</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13551">PHPBB3-13551</a>] - Authentication method- LDAP- entered value 'ldap base dn' does not display</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13555">PHPBB3-13555</a>] - Poll options preview rendered incorrectly by &lt;br /&gt; collision</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13563">PHPBB3-13563</a>] - No Private Message button shown in memberlist for subsilver2</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13568">PHPBB3-13568</a>] - Imagick path validated as relative path although ACP asks for absolute path</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13569">PHPBB3-13569</a>] - Use sql_freeresult for $result assignments and remove unneeded $result assignments</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13570">PHPBB3-13570</a>] - Mysqli extension supports persistent connection since PHP 5.3.0</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13577">PHPBB3-13577</a>] - Skip tests requiring fileinfo if fileinfo is not enabled</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13586">PHPBB3-13586</a>] - Allow '0' as username with Jabber notifications</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13587">PHPBB3-13587</a>] - SQL syntax errors in get_prune_users()</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13588">PHPBB3-13588</a>] - Information message for disabled fsockopen() is not displayed correctly</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13590">PHPBB3-13590</a>] - Remember me login keys should be centered</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13597">PHPBB3-13597</a>] - Modify variable-variable syntax to be compatible with PHP7</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13612">PHPBB3-13612</a>] - Functional test of extension fails if ext requires page refresh</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13615">PHPBB3-13615</a>] - Avatar Gallery shows categories but no images in subsilver2</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13617">PHPBB3-13617</a>] - Bot session continuation with invalid f= query paramter causes SQL error</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13618">PHPBB3-13618</a>] - Small grammatical typo in the English FAQ regarding COPPA</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13631">PHPBB3-13631</a>] - Fix variable name in core.phpbb_content_visibility_get_global_visibility_before event</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13639">PHPBB3-13639</a>] - Unused class icon-search-advanced references nonexistent image</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13644">PHPBB3-13644</a>] - Type hint dispatcher_interface instead of dispatcher</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13649">PHPBB3-13649</a>] - Subforum tooltip always displays &quot;no unread posts&quot; on viewforum.php</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13655">PHPBB3-13655</a>] - $phpbb_dispatcher undefined in phpbb_mcp_sorting()</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13657">PHPBB3-13657</a>] - Start testing against PHP7</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13666">PHPBB3-13666</a>] - data-clicked attribute is not always removed on ajax form submissions</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13667">PHPBB3-13667</a>] - Big buttons are incorrectly aligned in Chrome on Windows</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13670">PHPBB3-13670</a>] - Fix fatal function name must be a string in functional tests</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13698">PHPBB3-13698</a>] - Incorrect password message shows unparsed &quot;Board Administrator&quot;-link</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13702">PHPBB3-13702</a>] - Page is zoomed in by default on iOS devices in landscape mode</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13703">PHPBB3-13703</a>] - Uploaded avatars are not loading correctly when passing through the events</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13719">PHPBB3-13719</a>] - Remove superfluous $search_options in acp_search.php </li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13721">PHPBB3-13721</a>] - URL Rewriting doesn't work on IIS7</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13723">PHPBB3-13723</a>] - Update docs/AUTHORS for 3.1.4-RC1</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13726">PHPBB3-13726</a>] - Responsive breadcrumbs JavaScript incorrectly calculates width of hidden items</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13727">PHPBB3-13727</a>] - Responsive breadcrumbs JavaScript doesn't reset wrap- classes when resizing</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13732">PHPBB3-13732</a>] - Update composer for PHP7 compatibility</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13736">PHPBB3-13736</a>] - Replace colons with colon lang keys in Contact us page</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13738">PHPBB3-13738</a>] - Sami still refers to develop-* branches</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13741">PHPBB3-13741</a>] - Remove outdated comments in CSS files</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13742">PHPBB3-13742</a>] - Local avatar driver is not generating correct urls on index</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13743">PHPBB3-13743</a>] - Missing global vars $phpbb_root_path and $phpEx in message_parser.php</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13747">PHPBB3-13747</a>] - Fix test_validate_path_linux method</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13749">PHPBB3-13749</a>] - Add missing slash to base uri in helper route tests</li>

+ </ul>

+ <h4>Improvement</h4>

+ <ul>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13313">PHPBB3-13313</a>] - Add a core php event to the mass email form</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13467">PHPBB3-13467</a>] - Add a CONTRIBUTING file to the project on Github</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13510">PHPBB3-13510</a>] - Add template event before/after the pagination on viewtopic</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13512">PHPBB3-13512</a>] - Add template events to viewtopic_body.html before/after the post details</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13518">PHPBB3-13518</a>] - Add core event to markread() in functions.php</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13532">PHPBB3-13532</a>] - Add core event to get_unread_topics() in functions.php</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13533">PHPBB3-13533</a>] - Add template events to the header of search_results.html</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13535">PHPBB3-13535</a>] - Add ucp_profile.php core event to allow modifying account settings on editing</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13536">PHPBB3-13536</a>] - Add UCP/ACP core events to allow modifying user profile data on editing</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13537">PHPBB3-13537</a>] - Add core events on mcp_queue for approval and disapproval</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13540">PHPBB3-13540</a>] - Add events to the topic review while posting and moderating posts</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13578">PHPBB3-13578</a>] - Add ucp_register.php core event</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13591">PHPBB3-13591</a>] - Add functions.php core event to the function obtain_users_online_string()</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13595">PHPBB3-13595</a>] - Remove unused instances of the bbcode class</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13596">PHPBB3-13596</a>] - Add display_forums() core event to allow modifying forums list data</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13600">PHPBB3-13600</a>] - Add core event to allow extensions to create a custom help page</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13602">PHPBB3-13602</a>] - Add template event overall_header_navbar_before</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13628">PHPBB3-13628</a>] - Add template events into ucp profile html files</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13635">PHPBB3-13635</a>] - Add sql_ary to UCP profile event</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13637">PHPBB3-13637</a>] - Add php event for modifying the data when composing a PM</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13643">PHPBB3-13643</a>] - kernel_terminate_subscriber should have a very low priority</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13650">PHPBB3-13650</a>] - New core event for UCP profile mode</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13658">PHPBB3-13658</a>] - [Event] - Before and after deletion of topics</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13675">PHPBB3-13675</a>] - Add validate to acp_profile event and add template events</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13679">PHPBB3-13679</a>] - Add template event overall_header_searchbox_before</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13701">PHPBB3-13701</a>] - New posting_pm_layout.html template events to wrap &quot;include posting_pm_header.html&quot;</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13710">PHPBB3-13710</a>] - Add template events around smilies display</li>

+ </ul>

+ <h4>New Feature</h4>

+ <ul>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13336">PHPBB3-13336</a>] - New core events for user activation</li>

+ </ul>

+ <h4>Sub-task</h4>

+ <ul>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13142">PHPBB3-13142</a>] - [Event] - Before query to list unapproved and deleted posts</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13592">PHPBB3-13592</a>] - Add core event to allow changing get_visibility_sql's result</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13621">PHPBB3-13621</a>] - Fix event phpbb_content_visibility_get_forums_visibility_before to get where_sql working as specified</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13625">PHPBB3-13625</a>] - Add more variables to core.viewforum_get_topic_data</li>

+ </ul>

+ <h4>Task</h4>

+ <ul>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-9457">PHPBB3-9457</a>] - [Accessibility] - Add WAI-ARIA landmarks to the Prosilver template files</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-12599">PHPBB3-12599</a>] - Update documentation styling</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13572">PHPBB3-13572</a>] - Upgrade composer to 1.0.0-alpha9</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13626">PHPBB3-13626</a>] - Add branch aliases</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13634">PHPBB3-13634</a>] - Update README to show new branch names</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13640">PHPBB3-13640</a>] - Rearrange order of color css rules</li>

+ </ul>

+

+overall_header_navbar_before

+===

+* Locations:

+ + styles/prosilver/template/overall_header.html

+* Since: 3.1.4-RC1

+* Purpose: Add content before the navigation bar

+

+posting_editor_bbcode_status_after

+===

+* Locations:

+ + styles/prosilver/template/posting_editor.html

+* Since: 3.1.4-RC1

+* Purpose: Add content after bbcode status

+

+posting_editor_smilies_after

+===

+* Locations:

+ + styles/prosilver/template/posting_editor.html

+* Since: 3.1.4-RC1

+* Purpose: Add content after smilies

+

+posting_editor_smilies_before

+===

+* Locations:

+ + styles/prosilver/template/posting_editor.html

+* Since: 3.1.4-RC1

+* Purpose: Add content before the smilies

+

+posting_pm_layout_include_pm_header_after

+===

+* Locations:

+ + styles/prosilver/template/posting_pm_layout.html

+* Since: 3.1.4-RC1

+* Purpose: Add content after the include of posting_pm_header.html

+

+posting_pm_layout_include_pm_header_before

+===

+* Locations:

+ + styles/prosilver/template/posting_pm_layout.html

+* Since: 3.1.4-RC1

+* Purpose: Add content before the include of posting_pm_header.html

+

+posting_poll_body_options_after

+===

+* Locations:

+ + styles/prosilver/template/posting_poll_body.html

+* Since: 3.1.4-RC1

+* Purpose: Add content after the poll options on creating a poll

+

+ global $db, $user, $auth, $template, $cache, $request, $phpbb_dispatcher, $phpbb_container;

+ $phpbb_container->get('text_formatter.cache')->invalidate();

+ $phpbb_container->get('text_formatter.cache')->invalidate();

+ $phpbb_container->get('text_formatter.cache')->invalidate();

+ $extractor = $phpbb_container->get('dbal.extractor');

+ $extractor->init_extractor($format, $filename, $time, $download, $store);

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

+ $phpbb_container->get('text_formatter.cache')->invalidate();

+ $phpbb_container->get('text_formatter.cache')->invalidate();

+ $phpbb_container->get('text_formatter.cache')->invalidate();

+ $phpbb_container->get('text_formatter.cache')->invalidate();

+ // Remove old renderers from the text_formatter service. Since this

+ // operation is performed after the cache is purged, there is not "current"

+ // renderer and in effect all renderers will be purged

+ $phpbb_container->get('text_formatter.cache')->tidy();

+

+ /** @var \phpbb\textformatter\cache_interface */

+ protected $text_formatter_cache;

+

+ global $db, $user, $phpbb_admin_path, $phpbb_root_path, $phpEx, $template, $request, $cache, $auth, $config, $phpbb_container;

+ $this->text_formatter_cache = $phpbb_container->get('text_formatter.cache');

+ // Invalidate the text formatter's cache for the new styles to take effect

+ if (!empty($installed_names))

+ {

+ $this->text_formatter_cache->invalidate();

+ }

+

+ global $db, $user, $auth, $template, $cache, $phpbb_log, $request, $phpbb_container;

+ $phpbb_container->get('text_formatter.cache')->invalidate();

+ $phpbb_container->get('text_formatter.cache')->invalidate();

+*

+* NOTE: special chars are kept encoded

+*

+* @param string &$message Original message, passed by reference

+* @param string $bbcode_uid BBCode UID

+* @return null

+ global $phpbb_container;

+ if (preg_match('#^<[rt][ >]#', $message))

+ $message = htmlspecialchars($phpbb_container->get('text_formatter.utils')->unparse($message), ENT_COMPAT);

+ if ($bbcode_uid)

+ {

+ $match = array('<br />', "[/*:m:$bbcode_uid]", ":u:$bbcode_uid", ":o:$bbcode_uid", ":$bbcode_uid");

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

+ }

+ else

+ {

+ $match = array('<br />');

+ $replace = array("\n");

+ }

+ $message = str_replace($match, $replace, $message);

+ $match = get_preg_expression('bbcode_htm');

+ $replace = array('\1', '\1', '\2', '\1', '', '');

+ $message = preg_replace($match, $replace, $message);

+ }

+* Strips all bbcode from a text in place

+ global $phpbb_container;

+

+ if (preg_match('#^<[rt][ >]#', $text))

+ $text = $phpbb_container->get('text_formatter.utils')->clean_formatting($text);

+ else

+ {

+ if (!$uid)

+ {

+ $uid = '[0-9a-z]{5,}';

+ }

+ $text = preg_replace("#\[\/?[a-z0-9\*\+\-]+(?:=(?:&quot;.*&quot;|[^\]]*))?(?::[a-z])?(\:$uid)\]#", ' ', $text);

+ $match = get_preg_expression('bbcode_htm');

+ $replace = array('\1', '\1', '\2', '\1', '', '');

+ $text = preg_replace($match, $replace, $text);

+ }

+ global $phpbb_dispatcher, $phpbb_container;

+ if (preg_match('#^<[rt][ >]#', $text))

+ $renderer = $phpbb_container->get('text_formatter.renderer');

+ // Temporarily switch off viewcensors if applicable

+ $old_censor = $renderer->get_viewcensors();

+ if ($old_censor !== $censor_text)

+ $renderer->set_viewcensors($censor_text);

+ $text = $renderer->render($text);

+

+ // Restore the previous value

+ if ($old_censor !== $censor_text)

+ $renderer->set_viewcensors($old_censor);

+ }

+ else

+ {

+ if ($censor_text)

+ $text = censor_text($text);

+ // Parse bbcode if bbcode uid stored and bbcode enabled

+ if ($uid && ($flags & OPTION_FLAG_BBCODE))

+ {

+ if (!class_exists('bbcode'))

+ {

+ global $phpbb_root_path, $phpEx;

+ include($phpbb_root_path . 'includes/bbcode.' . $phpEx);

+ }

+

+ if (empty($bbcode))

+ {

+ $bbcode = new bbcode($bitfield);

+ }

+ else

+ {

+ $bbcode->bbcode($bitfield);

+ }

+ $bbcode->bbcode_second_pass($text, $uid);

+ }

+

+ $text = bbcode_nl2br($text);

+ $text = smiley_text($text, !($flags & OPTION_FLAG_SMILIES));

+ }

+ if ($quickmod)

+ {

+ switch ($action)

+ {

+ case 'lock':

+ case 'unlock':

+ case 'make_announce':

+ case 'make_sticky':

+ case 'make_global':

+ case 'make_normal':

+ case 'make_onindex':

+ case 'move':

+ case 'fork':

+ case 'delete_topic':

+ trigger_error('TOPIC_NOT_EXIST');

+ break;

+

+ case 'lock_post':

+ case 'unlock_post':

+ case 'delete_post':

+ trigger_error('POST_NOT_EXIST');

+ break;

+ }

+ }

+

+ // The following lines are for extensions which include message_parser.php

+ // while $phpbb_root_path and $phpEx are out of the script scope

+ // which may lead to the 'Undefined variable' and 'failed to open stream' errors

+ if (!isset($phpbb_root_path))

+ {

+ global $phpbb_root_path;

+ }

+

+ if (!isset($phpEx))

+ {

+ global $phpEx;

+ }

+

+ global $config, $db, $user, $phpbb_dispatcher, $phpbb_container;

+ // Get the parser

+ $parser = $phpbb_container->get('text_formatter.parser');

+ // Set the parser's options

+ ($allow_bbcode) ? $parser->enable_bbcodes() : $parser->disable_bbcodes();

+ ($allow_magic_url) ? $parser->enable_magic_url() : $parser->disable_magic_url();

+ ($allow_smilies) ? $parser->enable_smilies() : $parser->disable_smilies();

+ ($allow_img_bbcode) ? $parser->enable_bbcode('img') : $parser->disable_bbcode('img');

+ ($allow_flash_bbcode) ? $parser->enable_bbcode('flash') : $parser->disable_bbcode('flash');

+ ($allow_quote_bbcode) ? $parser->enable_bbcode('quote') : $parser->disable_bbcode('quote');

+ ($allow_url_bbcode) ? $parser->enable_bbcode('url') : $parser->disable_bbcode('url');

+ // Set some config values

+ $parser->set_vars(array(

+ 'max_font_size' => $config['max_' . $this->mode . '_font_size'],

+ 'max_img_height' => $config['max_' . $this->mode . '_img_height'],

+ 'max_img_width' => $config['max_' . $this->mode . '_img_width'],

+ 'max_smilies' => $config['max_' . $this->mode . '_smilies'],

+ 'max_urls' => $config['max_' . $this->mode . '_urls']

+ ));

+ // Parse this message

+ $this->message = $parser->parse(htmlspecialchars_decode($this->message, ENT_QUOTES));

+ // Check for errors

+ $errors = $parser->get_errors();

+ if ($errors)

+ $this->warn_msg = array_merge($this->warn_msg, $errors);

+

+ global $phpbb_container, $phpbb_dispatcher;

+ // NOTE: message_status is unreliable for detecting unparsed text because some callers

+ // change $this->message without resetting $this->message_status to 'plain' so we

+ // inspect the message instead

+ //if ($this->message_status == 'plain')

+ if (!preg_match('/^<[rt][ >]/', $this->message))

+ // There's a bug when previewing a topic with no poll, because the empty title of the poll

+ // gets parsed but $this->message still ends up empty. This fixes it, until a proper fix is

+ // devised

+ if ($this->message === '')

+ $this->message = $phpbb_container->get('text_formatter.parser')->parse($this->message);

+ $this->message = $phpbb_container->get('text_formatter.renderer')->render($this->message);

+ // Parse Poll Option text

+ $poll['poll_options'] = explode("\n", trim($poll['poll_option_text']));

+ $poll['poll_options_size'] = sizeof($poll['poll_options']);

+ foreach ($poll['poll_options'] as &$poll_option)

+ {

+ $this->message = $poll_option;

+ $poll_option = $this->parse($poll['enable_bbcode'], ($config['allow_post_links']) ? $poll['enable_urls'] : false, $poll['enable_smilies'], $poll['img_status'], false, false, $config['allow_post_links'], false, 'poll');

+ }

+ unset($poll_option);

+ $poll['poll_option_text'] = implode("\n", $poll['poll_options']);

+

+ $this->message = $tmp_message;

+ 'phpbb_version' => '3.1.4',

+ // Ignore errors when the functions or types already exist

+ // to allow installing phpBB twice in the same database with

+ // a different prefix

+ $db->sql_query($sql);

+ 'EXTENSION_REMOVE_HEADLINE' => 'Completely removing an extension from your board',

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