+$attach_id = request_var('id', 0);

+if (!$attach_id)

+ WHERE attach_id = $attach_id";

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

+if (!$attachment)

+else

+ $attachment['physical_filename'] = utf8_basename($attachment['physical_filename']);

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

+function phpbb_generate_debug_output(\phpbb\db\driver\driver_interface $db, \phpbb\config\config $config, \phpbb\auth\auth $auth, \phpbb\user $user, \phpbb\event\dispatcher_interface $phpbb_dispatcher)

+ /**

+ * Modify debug output information

+ *

+ * @event core.phpbb_generate_debug_output

+ * @var array debug_info Array of strings with debug information

+ *

+ * @since 3.1.0-RC3

+ */

+ $vars = array('debug_info');

+ extract($phpbb_dispatcher->trigger_event('core.phpbb_generate_debug_output', compact($vars)));

+

+ 'DEBUG_OUTPUT' => phpbb_generate_debug_output($db, $config, $auth, $user, $phpbb_dispatcher),

+ 'DEBUG_OUTPUT' => phpbb_generate_debug_output($db, $config, $auth, $user, $phpbb_dispatcher),

+ "VCHAR_UNI:255",

+ "",

+ "true_sort"

+ function sql_not_like_expression($expression)

+ {

+ $expression = utf8_str_replace(array('_', '%'), array("\_", "\%"), $expression);

+ $expression = utf8_str_replace(array(chr(0) . "\_", chr(0) . "\%"), array('_', '%'), $expression);

+

+ return $this->_sql_not_like_expression('NOT LIKE \'' . $this->sql_escape($expression) . '\'');

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ * Correctly adjust NOT LIKE expression for special characters

+ * Some DBMS are handling them in a different way

+ *

+ * @param string $expression The expression to use. Every wildcard is

+ * escaped, except $this->any_char and $this->one_char

+ * @return string A SQL statement like: "NOT LIKE 'bertie_%'"

+ */

+ public function sql_not_like_expression($expression);

+

+ /**

+ public function sql_not_like_expression($expression)

+ {

+ return $this->get_driver()->sql_not_like_expression($expression);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ * Build NOT LIKE expression

+ * @access private

+ */

+ function _sql_not_like_expression($expression)

+ {

+ return $expression . " ESCAPE '\\'";

+ }

+

+ /**

+ * Build NOT LIKE expression

+ * @access private

+ */

+ function _sql_not_like_expression($expression)

+ {

+ return $expression . " ESCAPE '\\'";

+ }

+

+ /**

+ * Build NOT LIKE expression

+ * @access private

+ */

+ function _sql_not_like_expression($expression)

+ {

+ return $expression;

+ }

+

+ /**

+ /**

+ * Build NOT LIKE expression

+ * @access private

+ */

+ function _sql_not_like_expression($expression)

+ {

+ return $expression . " ESCAPE '\\'";

+ }

+

+ * Build NOT LIKE expression

+ * @access private

+ */

+ function _sql_not_like_expression($expression)

+ {

+ return $expression;

+ }

+

+ /**

+ // Unlike LIKE, GLOB is unfortunately case sensitive.

+ * {@inheritDoc}

+ *

+ * For SQLite an underscore is a not-known character...

+ */

+ function sql_not_like_expression($expression)

+ {

+ // Unlike NOT LIKE, NOT GLOB is unfortunately case sensitive.

+ // We only catch * and ? here, not the character map possible on file globbing.

+ $expression = str_replace(array(chr(0) . '_', chr(0) . '%'), array(chr(0) . '?', chr(0) . '*'), $expression);

+

+ $expression = str_replace(array('?', '*'), array("\?", "\*"), $expression);

+ $expression = str_replace(array(chr(0) . "\?", chr(0) . "\*"), array('?', '*'), $expression);

+

+ return 'NOT GLOB \'' . $this->sql_escape($expression) . '\'';

+ }

+

+ /**

+ * For SQLite an underscore is an unknown character.

+ // Unlike LIKE, GLOB is unfortunately case sensitive.

+ * {@inheritDoc}

+ *

+ * For SQLite an underscore is an unknown character.

+ */

+ public function sql_not_like_expression($expression)

+ {

+ // Unlike NOT LIKE, NOT GLOB is unfortunately case sensitive

+ // We only catch * and ? here, not the character map possible on file globbing.

+ $expression = str_replace(array(chr(0) . '_', chr(0) . '%'), array(chr(0) . '?', chr(0) . '*'), $expression);

+

+ $expression = str_replace(array('?', '*'), array("\?", "\*"), $expression);

+ $expression = str_replace(array(chr(0) . "\?", chr(0) . "\*"), array('?', '*'), $expression);

+

+ return 'NOT GLOB \'' . $this->sql_escape($expression) . '\'';

+ }

+

+ /**

+<?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\v310;

+

+class topic_sort_username extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v310\dev');

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'change_columns' => array(

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

+ 'topic_first_poster_name' => array('VCHAR_UNI:255', '', 'true_sort'),

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'change_columns' => array(

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

+ 'topic_first_poster_name' => array('VCHAR_UNI:255', ''),

+ ),

+ ),

+ );

+ }

+}

+ 'field_validation' => '(?:(?!\.{2,})([^<>=+]))+',

+

+ // Update page title

+ $('title').text(

+ (unreadCount ? '(' + unreadCount + ')' : '') + $('title').text().replace(/(\(([0-9])\))/, '')

+ );

+ 'S_HAS_ATTACHMENTS' => $topic_data['topic_attachment'],

+ public function not_like_expression_data()

+ {

+ // * = any_char; # = one_char

+ return array(

+ array('barfoo', array(

+ array('username_clean' => 'foobar'),

+ array('username_clean' => 'bertie')

+ )),

+ array('bar', array(

+ array('username_clean' => 'barfoo'),

+ array('username_clean' => 'foobar'),

+ array('username_clean' => 'bertie'),

+ )),

+ array('bar*', array(

+ array('username_clean' => 'foobar'),

+ array('username_clean' => 'bertie'))

+ ),

+ array('*bar*', array(array('username_clean' => 'bertie'))),

+ array('b*r', array(

+ array('username_clean' => 'barfoo'),

+ array('username_clean' => 'foobar'),

+ array('username_clean' => 'bertie')

+ )),

+ array('b*e', array(

+ array('username_clean' => 'barfoo'),

+ array('username_clean' => 'foobar')

+ )),

+ array('#b*e', array(

+ array('username_clean' => 'barfoo'),

+ array('username_clean' => 'foobar'),

+ array('username_clean' => 'bertie')

+ )),

+ array('b####e', array(

+ array('username_clean' => 'barfoo'),

+ array('username_clean' => 'foobar')

+ )),

+ );

+ }

+

+ /**

+ * @dataProvider not_like_expression_data

+ */

+ public function test_not_like_expression($like_expression, $expected)

+ {

+ $db = $this->new_dbal();

+

+ $like_expression = str_replace('*', $db->get_any_char(), $like_expression);

+ $like_expression = str_replace('#', $db->get_one_char(), $like_expression);

+ $where = ($like_expression) ? 'username_clean ' . $db->sql_not_like_expression($like_expression) : '';

+

+ $result = $db->sql_query('SELECT username_clean

+ FROM phpbb_users

+ ' . (($where) ? ' WHERE ' . $where : '') . '

+ ORDER BY user_id ASC');

+

+ $this->assertEquals($expected, $db->sql_fetchrowset($result));

+

+ $db->sql_freeresult($result);

+ }

+

+ function sql_not_like_expression($expression)

+ {

+ }

+

+require_once __DIR__ . '/../../phpBB/includes/utf/utf_tools.php';

+

+ protected $field;

+

+ public function setUp()

+ {

+ parent::setUp();

+

+ $user = new \phpbb\user();

+ $user->add_lang('ucp');

+ $request = $this->getMock('\phpbb\request\request');

+ $template = $this->getMock('\phpbb\template\template');

+

+ $this->field = new \phpbb\profilefields\type\type_googleplus(

+ $request,

+ $template,

+ $user

+ );

+ }

+ $this->assertSame($expected, $this->field->get_profile_contact_value($value, $field_options), $description);

+ }

+

+ public function data_validate_googleplus()

+ {

+ return array(

+ array('foobar', false),

+ array('2342340929304', false),

+ array('foo<bar', 'The field “googleplus” has invalid characters.'),

+ array('klkd.klkl', false),

+ array('kl+', 'The field “googleplus” has invalid characters.'),

+ array('foo=bar', 'The field “googleplus” has invalid characters.'),

+ array('..foo', 'The field “googleplus” has invalid characters.'),

+ array('foo..bar', 'The field “googleplus” has invalid characters.'),

+ );

+ }

+

+ /**

+ * @dataProvider data_validate_googleplus

+ */

+ public function test_validate_googleplus($input, $expected)

+ {

+ $field_data = array_merge(array('lang_name' => 'googleplus'), $this->field->get_default_option_values());

+ $this->assertSame($expected, $this->field->validate_string_profile_field('string', $input, $field_data));

+ $crawler = self::request('GET', 'install/index.php?mode=install&language=en');