+ protected function path_to_app()

+ {

+ return '';

+ }

+

+ array('controller2', array('t' => 1, 'f' => 2), true, false, '/' . $this->path_to_app() . 'app.php/foo/bar?t=1&f=2', 'parameters in params-argument as array'),

+ array('controller2', array('t' => 1, 'f' => 2), false, false, '/' . $this->path_to_app() . 'app.php/foo/bar?t=1&f=2', 'parameters in params-argument as array'),

+ array('controller3', array('p' => 3, 't' => 1, 'f' => 2), true, false, '/' . $this->path_to_app() . 'app.php/foo/bar/p-3?t=1&f=2', 'parameters in params-argument as array'),

+ array('controller3', array('p' => 3, 't' => 1, 'f' => 2), false, false, '/' . $this->path_to_app() . 'app.php/foo/bar/p-3?t=1&f=2', 'parameters in params-argument as array'),

+ array('controller2', array('t' => 1, 'f' => 2), true, 'custom-sid', '/' . $this->path_to_app() . 'app.php/foo/bar?t=1&f=2&sid=custom-sid', 'params-argument (array) using session_id'),

+ array('controller2', array('t' => 1, 'f' => 2), false, 'custom-sid', '/' . $this->path_to_app() . 'app.php/foo/bar?t=1&f=2&sid=custom-sid', 'params-argument (array) using session_id'),

+ array('controller3', array('p' => 3, 't' => 1, 'f' => 2), true, 'custom-sid', '/' . $this->path_to_app() . 'app.php/foo/bar/p-3?t=1&f=2&sid=custom-sid', 'params-argument (array) using session_id'),

+ array('controller2', array('t' => 1, 'f' => 2, '#' => 'anchor'), true, false, '/' . $this->path_to_app() . 'app.php/foo/bar?t=1&f=2#anchor', 'anchor in params-argument (array)'),

+ array('controller2', array('t' => 1, 'f' => 2, '#' => 'anchor'), false, false, '/' . $this->path_to_app() . 'app.php/foo/bar?t=1&f=2#anchor', 'anchor in params-argument (array)'),

+ array('controller3', array('p' => 3, 't' => 1, 'f' => 2, '#' => 'anchor'), true, false, '/' . $this->path_to_app() . 'app.php/foo/bar/p-3?t=1&f=2#anchor', 'anchor in params-argument (array)'),

+ array('controller2', array('t' => 1, 'f' => 2, '#' => 'anchor'), true, 'custom-sid', '/' . $this->path_to_app() . 'app.php/foo/bar?t=1&f=2&sid=custom-sid#anchor', 'anchor in params-argument (array) using session_id'),

+ array('controller2', array('t' => 1, 'f' => 2, '#' => 'anchor'), false, 'custom-sid', '/' . $this->path_to_app() . 'app.php/foo/bar?t=1&f=2&sid=custom-sid#anchor', 'anchor in params-argument (array) using session_id'),

+ array('controller3', array('p' => 3, 't' => 1, 'f' => 2, '#' => 'anchor'), true, 'custom-sid', '/' . $this->path_to_app() . 'app.php/foo/bar/p-3?t=1&f=2&sid=custom-sid#anchor', 'anchor in params-argument (array) using session_id'),

+ array('controller2', array(), true, false, '/' . $this->path_to_app() . 'app.php/foo/bar', 'no params using empty array'),

+ array('controller2', array(), false, false, '/' . $this->path_to_app() . 'app.php/foo/bar', 'no params using empty array'),

+ array('controller3', array('p' => 3), true, false, '/' . $this->path_to_app() . 'app.php/foo/bar/p-3', 'no params using empty array'),

+ array('controller2', array('t' => 1, 'f' => 2), true, false, '/' . $this->path_to_app() . 'foo/bar?t=1&f=2', 'parameters in params-argument as array'),

+ array('controller2', array('t' => 1, 'f' => 2), false, false, '/' . $this->path_to_app() . 'foo/bar?t=1&f=2', 'parameters in params-argument as array'),

+ array('controller3', array('p' => 3, 't' => 1, 'f' => 2), true, false, '/' . $this->path_to_app() . 'foo/bar/p-3?t=1&f=2', 'parameters in params-argument as array'),

+ array('controller3', array('p' => 3, 't' => 1, 'f' => 2), false, false, '/' . $this->path_to_app() . 'foo/bar/p-3?t=1&f=2', 'parameters in params-argument as array'),

+ array('controller2', array('t' => 1, 'f' => 2), true, 'custom-sid', '/' . $this->path_to_app() . 'foo/bar?t=1&f=2&sid=custom-sid', 'params-argument (array) using session_id'),

+ array('controller2', array('t' => 1, 'f' => 2), false, 'custom-sid', '/' . $this->path_to_app() . 'foo/bar?t=1&f=2&sid=custom-sid', 'params-argument (array) using session_id'),

+ array('controller3', array('p' => 3, 't' => 1, 'f' => 2), true, 'custom-sid', '/' . $this->path_to_app() . 'foo/bar/p-3?t=1&f=2&sid=custom-sid', 'params-argument (array) using session_id'),

+ array('controller2', array('t' => 1, 'f' => 2, '#' => 'anchor'), true, false, '/' . $this->path_to_app() . 'foo/bar?t=1&f=2#anchor', 'anchor in params-argument (array)'),

+ array('controller2', array('t' => 1, 'f' => 2, '#' => 'anchor'), false, false, '/' . $this->path_to_app() . 'foo/bar?t=1&f=2#anchor', 'anchor in params-argument (array)'),

+ array('controller3', array('p' => 3, 't' => 1, 'f' => 2, '#' => 'anchor'), true, false, '/' . $this->path_to_app() . 'foo/bar/p-3?t=1&f=2#anchor', 'anchor in params-argument (array)'),

+ array('controller2', array('t' => 1, 'f' => 2, '#' => 'anchor'), true, 'custom-sid', '/' . $this->path_to_app() . 'foo/bar?t=1&f=2&sid=custom-sid#anchor', 'anchor in params-argument (array) using session_id'),

+ array('controller2', array('t' => 1, 'f' => 2, '#' => 'anchor'), false, 'custom-sid', '/' . $this->path_to_app() . 'foo/bar?t=1&f=2&sid=custom-sid#anchor', 'anchor in params-argument (array) using session_id'),

+ array('controller3', array('p' => 3, 't' => 1, 'f' => 2, '#' => 'anchor'), true, 'custom-sid', '/' . $this->path_to_app() . 'foo/bar/p-3?t=1&f=2&sid=custom-sid#anchor', 'anchor in params-argument (array) using session_id'),

+ array('controller2', array(), true, false, '/' . $this->path_to_app() . 'foo/bar', 'no params using empty array'),

+ array('controller2', array(), false, false, '/' . $this->path_to_app() . 'foo/bar', 'no params using empty array'),

+ array('controller3', array('p' => 3), true, false, '/' . $this->path_to_app() . 'foo/bar/p-3', 'no params using empty array'),

+ array('controller2', array('t' => 1, 'f' => 2), true, false, 'http://localhost/' . $this->path_to_app() . 'app.php/foo/bar?t=1&f=2', 'parameters in params-argument as array'),

+ array('controller2', array('t' => 1, 'f' => 2), false, false, 'http://localhost/' . $this->path_to_app() . 'app.php/foo/bar?t=1&f=2', 'parameters in params-argument as array'),

+ array('controller3', array('p' => 3, 't' => 1, 'f' => 2), true, false, 'http://localhost/' . $this->path_to_app() . 'app.php/foo/bar/p-3?t=1&f=2', 'parameters in params-argument as array'),

+ array('controller3', array('p' => 3, 't' => 1, 'f' => 2), false, false, 'http://localhost/' . $this->path_to_app() . 'app.php/foo/bar/p-3?t=1&f=2', 'parameters in params-argument as array'),

+ array('controller2', array('t' => 1, 'f' => 2), true, 'custom-sid', 'http://localhost/' . $this->path_to_app() . 'app.php/foo/bar?t=1&f=2&sid=custom-sid', 'params-argument (array) using session_id'),

+ array('controller2', array('t' => 1, 'f' => 2), false, 'custom-sid', 'http://localhost/' . $this->path_to_app() . 'app.php/foo/bar?t=1&f=2&sid=custom-sid', 'params-argument (array) using session_id'),

+ array('controller3', array('p' => 3, 't' => 1, 'f' => 2), true, 'custom-sid', 'http://localhost/' . $this->path_to_app() . 'app.php/foo/bar/p-3?t=1&f=2&sid=custom-sid', 'params-argument (array) using session_id'),

+ array('controller2', array('t' => 1, 'f' => 2, '#' => 'anchor'), true, false, 'http://localhost/' . $this->path_to_app() . 'app.php/foo/bar?t=1&f=2#anchor', 'anchor in params-argument (array)'),

+ array('controller2', array('t' => 1, 'f' => 2, '#' => 'anchor'), false, false, 'http://localhost/' . $this->path_to_app() . 'app.php/foo/bar?t=1&f=2#anchor', 'anchor in params-argument (array)'),

+ array('controller3', array('p' => 3, 't' => 1, 'f' => 2, '#' => 'anchor'), true, false, 'http://localhost/' . $this->path_to_app() . 'app.php/foo/bar/p-3?t=1&f=2#anchor', 'anchor in params-argument (array)'),

+ array('controller2', array('t' => 1, 'f' => 2, '#' => 'anchor'), true, 'custom-sid', 'http://localhost/' . $this->path_to_app() . 'app.php/foo/bar?t=1&f=2&sid=custom-sid#anchor', 'anchor in params-argument (array) using session_id'),

+ array('controller2', array('t' => 1, 'f' => 2, '#' => 'anchor'), false, 'custom-sid', 'http://localhost/' . $this->path_to_app() . 'app.php/foo/bar?t=1&f=2&sid=custom-sid#anchor', 'anchor in params-argument (array) using session_id'),

+ array('controller3', array('p' => 3, 't' => 1, 'f' => 2, '#' => 'anchor'), true, 'custom-sid', 'http://localhost/' . $this->path_to_app() . 'app.php/foo/bar/p-3?t=1&f=2&sid=custom-sid#anchor', 'anchor in params-argument (array) using session_id'),

+ array('controller2', array(), true, false, 'http://localhost/' . $this->path_to_app() . 'app.php/foo/bar', 'no params using empty array'),

+ array('controller2', array(), false, false, 'http://localhost/' . $this->path_to_app() . 'app.php/foo/bar', 'no params using empty array'),

+ array('controller3', array('p' => 3), true, false, 'http://localhost/' . $this->path_to_app() . 'app.php/foo/bar/p-3', 'no params using empty array'),

+ array('controller2', array('t' => 1, 'f' => 2), true, false, '//localhost/' . $this->path_to_app() . 'app.php/foo/bar?t=1&f=2', 'parameters in params-argument as array'),

+ array('controller2', array('t' => 1, 'f' => 2), false, false, '//localhost/' . $this->path_to_app() . 'app.php/foo/bar?t=1&f=2', 'parameters in params-argument as array'),

+ array('controller3', array('p' => 3, 't' => 1, 'f' => 2), true, false, '//localhost/' . $this->path_to_app() . 'app.php/foo/bar/p-3?t=1&f=2', 'parameters in params-argument as array'),

+ array('controller3', array('p' => 3, 't' => 1, 'f' => 2), false, false, '//localhost/' . $this->path_to_app() . 'app.php/foo/bar/p-3?t=1&f=2', 'parameters in params-argument as array'),

+ array('controller2', array('t' => 1, 'f' => 2), true, 'custom-sid', '//localhost/' . $this->path_to_app() . 'app.php/foo/bar?t=1&f=2&sid=custom-sid', 'params-argument (array) using session_id'),

+ array('controller2', array('t' => 1, 'f' => 2), false, 'custom-sid', '//localhost/' . $this->path_to_app() . 'app.php/foo/bar?t=1&f=2&sid=custom-sid', 'params-argument (array) using session_id'),

+ array('controller3', array('p' => 3, 't' => 1, 'f' => 2), true, 'custom-sid', '//localhost/' . $this->path_to_app() . 'app.php/foo/bar/p-3?t=1&f=2&sid=custom-sid', 'params-argument (array) using session_id'),

+ array('controller2', array('t' => 1, 'f' => 2, '#' => 'anchor'), true, false, '//localhost/' . $this->path_to_app() . 'app.php/foo/bar?t=1&f=2#anchor', 'anchor in params-argument (array)'),

+ array('controller2', array('t' => 1, 'f' => 2, '#' => 'anchor'), false, false, '//localhost/' . $this->path_to_app() . 'app.php/foo/bar?t=1&f=2#anchor', 'anchor in params-argument (array)'),

+ array('controller3', array('p' => 3, 't' => 1, 'f' => 2, '#' => 'anchor'), true, false, '//localhost/' . $this->path_to_app() . 'app.php/foo/bar/p-3?t=1&f=2#anchor', 'anchor in params-argument (array)'),

+ array('controller2', array('t' => 1, 'f' => 2, '#' => 'anchor'), true, 'custom-sid', '//localhost/' . $this->path_to_app() . 'app.php/foo/bar?t=1&f=2&sid=custom-sid#anchor', 'anchor in params-argument (array) using session_id'),

+ array('controller2', array('t' => 1, 'f' => 2, '#' => 'anchor'), false, 'custom-sid', '//localhost/' . $this->path_to_app() . 'app.php/foo/bar?t=1&f=2&sid=custom-sid#anchor', 'anchor in params-argument (array) using session_id'),

+ array('controller3', array('p' => 3, 't' => 1, 'f' => 2, '#' => 'anchor'), true, 'custom-sid', '//localhost/' . $this->path_to_app() . 'app.php/foo/bar/p-3?t=1&f=2&sid=custom-sid#anchor', 'anchor in params-argument (array) using session_id'),

+ array('controller2', array(), true, false, '//localhost/' . $this->path_to_app() . 'app.php/foo/bar', 'no params using empty array'),

+ array('controller2', array(), false, false, '//localhost/' . $this->path_to_app() . 'app.php/foo/bar', 'no params using empty array'),

+ array('controller3', array('p' => 3), true, false, '//localhost/' . $this->path_to_app() . 'app.php/foo/bar/p-3', 'no params using empty array'),

+ array('controller2', array('t' => 1, 'f' => 2), true, false, 'http://localhost/' . $this->path_to_app() . 'foo/bar?t=1&f=2', 'parameters in params-argument as array'),

+ array('controller2', array('t' => 1, 'f' => 2), false, false, 'http://localhost/' . $this->path_to_app() . 'foo/bar?t=1&f=2', 'parameters in params-argument as array'),

+ array('controller3', array('p' => 3, 't' => 1, 'f' => 2), true, false, 'http://localhost/' . $this->path_to_app() . 'foo/bar/p-3?t=1&f=2', 'parameters in params-argument as array'),

+ array('controller3', array('p' => 3, 't' => 1, 'f' => 2), false, false, 'http://localhost/' . $this->path_to_app() . 'foo/bar/p-3?t=1&f=2', 'parameters in params-argument as array'),

+ array('controller2', array('t' => 1, 'f' => 2), true, 'custom-sid', 'http://localhost/' . $this->path_to_app() . 'foo/bar?t=1&f=2&sid=custom-sid', 'params-argument (array) using session_id'),

+ array('controller2', array('t' => 1, 'f' => 2), false, 'custom-sid', 'http://localhost/' . $this->path_to_app() . 'foo/bar?t=1&f=2&sid=custom-sid', 'params-argument (array) using session_id'),

+ array('controller3', array('p' => 3, 't' => 1, 'f' => 2), true, 'custom-sid', 'http://localhost/' . $this->path_to_app() . 'foo/bar/p-3?t=1&f=2&sid=custom-sid', 'params-argument (array) using session_id'),

+ array('controller2', array('t' => 1, 'f' => 2, '#' => 'anchor'), true, false, 'http://localhost/' . $this->path_to_app() . 'foo/bar?t=1&f=2#anchor', 'anchor in params-argument (array)'),

+ array('controller2', array('t' => 1, 'f' => 2, '#' => 'anchor'), false, false, 'http://localhost/' . $this->path_to_app() . 'foo/bar?t=1&f=2#anchor', 'anchor in params-argument (array)'),

+ array('controller3', array('p' => 3, 't' => 1, 'f' => 2, '#' => 'anchor'), true, false, 'http://localhost/' . $this->path_to_app() . 'foo/bar/p-3?t=1&f=2#anchor', 'anchor in params-argument (array)'),

+ array('controller2', array('t' => 1, 'f' => 2, '#' => 'anchor'), true, 'custom-sid', 'http://localhost/' . $this->path_to_app() . 'foo/bar?t=1&f=2&sid=custom-sid#anchor', 'anchor in params-argument (array) using session_id'),

+ array('controller2', array('t' => 1, 'f' => 2, '#' => 'anchor'), false, 'custom-sid', 'http://localhost/' . $this->path_to_app() . 'foo/bar?t=1&f=2&sid=custom-sid#anchor', 'anchor in params-argument (array) using session_id'),

+ array('controller3', array('p' => 3, 't' => 1, 'f' => 2, '#' => 'anchor'), true, 'custom-sid', 'http://localhost/' . $this->path_to_app() . 'foo/bar/p-3?t=1&f=2&sid=custom-sid#anchor', 'anchor in params-argument (array) using session_id'),

+ array('controller2', array(), true, false, 'http://localhost/' . $this->path_to_app() . 'foo/bar', 'no params using empty array'),

+ array('controller2', array(), false, false, 'http://localhost/' . $this->path_to_app() . 'foo/bar', 'no params using empty array'),

+ array('controller3', array('p' => 3), true, false, 'http://localhost/' . $this->path_to_app() . 'foo/bar/p-3', 'no params using empty array'),

+ array('controller2', array('t' => 1, 'f' => 2), true, false, '//localhost/' . $this->path_to_app() . 'foo/bar?t=1&f=2', 'parameters in params-argument as array'),

+ array('controller2', array('t' => 1, 'f' => 2), false, false, '//localhost/' . $this->path_to_app() . 'foo/bar?t=1&f=2', 'parameters in params-argument as array'),

+ array('controller3', array('p' => 3, 't' => 1, 'f' => 2), true, false, '//localhost/' . $this->path_to_app() . 'foo/bar/p-3?t=1&f=2', 'parameters in params-argument as array'),

+ array('controller3', array('p' => 3, 't' => 1, 'f' => 2), false, false, '//localhost/' . $this->path_to_app() . 'foo/bar/p-3?t=1&f=2', 'parameters in params-argument as array'),

+ array('controller2', array('t' => 1, 'f' => 2), true, 'custom-sid', '//localhost/' . $this->path_to_app() . 'foo/bar?t=1&f=2&sid=custom-sid', 'params-argument (array) using session_id'),

+ array('controller2', array('t' => 1, 'f' => 2), false, 'custom-sid', '//localhost/' . $this->path_to_app() . 'foo/bar?t=1&f=2&sid=custom-sid', 'params-argument (array) using session_id'),

+ array('controller3', array('p' => 3, 't' => 1, 'f' => 2), true, 'custom-sid', '//localhost/' . $this->path_to_app() . 'foo/bar/p-3?t=1&f=2&sid=custom-sid', 'params-argument (array) using session_id'),

+ array('controller2', array('t' => 1, 'f' => 2, '#' => 'anchor'), true, false, '//localhost/' . $this->path_to_app() . 'foo/bar?t=1&f=2#anchor', 'anchor in params-argument (array)'),

+ array('controller2', array('t' => 1, 'f' => 2, '#' => 'anchor'), false, false, '//localhost/' . $this->path_to_app() . 'foo/bar?t=1&f=2#anchor', 'anchor in params-argument (array)'),

+ array('controller3', array('p' => 3, 't' => 1, 'f' => 2, '#' => 'anchor'), true, false, '//localhost/' . $this->path_to_app() . 'foo/bar/p-3?t=1&f=2#anchor', 'anchor in params-argument (array)'),

+ array('controller2', array('t' => 1, 'f' => 2, '#' => 'anchor'), true, 'custom-sid', '//localhost/' . $this->path_to_app() . 'foo/bar?t=1&f=2&sid=custom-sid#anchor', 'anchor in params-argument (array) using session_id'),

+ array('controller2', array('t' => 1, 'f' => 2, '#' => 'anchor'), false, 'custom-sid', '//localhost/' . $this->path_to_app() . 'foo/bar?t=1&f=2&sid=custom-sid#anchor', 'anchor in params-argument (array) using session_id'),

+ array('controller3', array('p' => 3, 't' => 1, 'f' => 2, '#' => 'anchor'), true, 'custom-sid', '//localhost/' . $this->path_to_app() . 'foo/bar/p-3?t=1&f=2&sid=custom-sid#anchor', 'anchor in params-argument (array) using session_id'),

+ array('controller2', array(), true, false, '//localhost/' . $this->path_to_app() . 'foo/bar', 'no params using empty array'),

+ array('controller2', array(), false, false, '//localhost/' . $this->path_to_app() . 'foo/bar', 'no params using empty array'),

+ array('controller3', array('p' => 3), true, false, '//localhost/' . $this->path_to_app() . 'foo/bar/p-3', 'no params using empty array'),

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

+*

+*/

+

+require_once dirname(__FILE__) . '/common_helper_route.php';

+

+class phpbb_controller_helper_route_other_app_test extends phpbb_controller_common_helper_route

+{

+ protected function get_phpbb_root_path()

+ {

+ return './../';

+ }

+

+ protected function get_uri()

+ {

+ return '/foo/app.php';

+ }

+

+ protected function get_script_name()

+ {

+ return 'app.php';

+ }

+

+ protected function path_to_app()

+ {

+ return 'foo/';

+ }

+}

+

+

+ public function relative_format_date_data()

+ {

+ // If the current time is too close to the testing time,

+ // the relative time will use "x minutes ago" instead of "today ..."

+ // So we use 18:01 in the morning and 06:01 in the afternoon.

+ $testing_time = date('H') <= 12 ? '18:01' : '06:01';

+

+ return array(

+ array(

+ date('Y-m-d', time() + 2 * 86400) . ' ' . $testing_time, false,

+ date('Y-m-d', time() + 2 * 86400) . ' ' . $testing_time,

+ ),

+

+ array(

+ date('Y-m-d', time() + 86400) . ' ' . $testing_time, false,

+ 'Tomorrow ' . $testing_time,

+ ),

+ array(

+ date('Y-m-d', time() + 86400) . ' ' . $testing_time, true,

+ date('Y-m-d', time() + 86400) . ' ' . $testing_time,

+ ),

+

+ array(

+ date('Y-m-d') . ' ' . $testing_time, false,

+ 'Today ' . $testing_time,

+ ),

+ array(

+ date('Y-m-d') . ' ' . $testing_time, true,

+ date('Y-m-d') . ' ' . $testing_time,

+ ),

+

+ array(

+ date('Y-m-d', time() - 86400) . ' ' . $testing_time, false,

+ 'Yesterday ' . $testing_time,

+ ),

+ array(

+ date('Y-m-d', time() - 86400) . ' ' . $testing_time, true,

+ date('Y-m-d', time() - 86400) . ' ' . $testing_time,

+ ),

+

+ array(

+ date('Y-m-d', time() - 2 * 86400) . ' ' . $testing_time, false,

+ date('Y-m-d', time() - 2 * 86400) . ' ' . $testing_time,

+ ),

+ );

+ }

+

+ /**

+ * @dataProvider relative_format_date_data()

+ */

+ public function test_relative_format_date($timestamp, $forcedate, $expected)

+ {

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

+ $user->timezone = new DateTimeZone('UTC');

+ $user->lang['datetime'] = array(

+ 'TODAY' => 'Today',

+ 'TOMORROW' => 'Tomorrow',

+ 'YESTERDAY' => 'Yesterday',

+ 'AGO' => array(

+ 0 => 'less than a minute ago',

+ 1 => '%d minute ago',

+ 2 => '%d minutes ago',

+ ),

+ );

+

+ $timestamp = $user->get_timestamp_from_format('Y-m-d H:i', $timestamp, new DateTimeZone('UTC'));

+ $this->assertEquals($expected, $user->format_date($timestamp, '|Y-m-d| H:i', $forcedate));

+ }

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2014 phpBB Group

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

+*

+*/

+

+require_once dirname(__FILE__) . '/../../phpBB/includes/functions.php';

+require_once dirname(__FILE__) . '/../../phpBB/includes/functions_user.php';

+require_once dirname(__FILE__) . '/../../phpBB/includes/utf/utf_tools.php';

+

+class phpbb_functions_user_delete_user_test extends phpbb_database_test_case

+{

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

+ protected $db;

+

+ public function getDataSet()

+ {

+ return $this->createXMLDataSet(dirname(__FILE__) . '/fixtures/delete_user.xml');

+ }

+

+ protected function setUp()

+ {

+ parent::setUp();

+

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

+

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

+ $config = new \phpbb\config\config(array(

+ 'load_online_time' => 5,

+ 'search_type' => '\phpbb\search\fulltext_mysql',

+ ));

+ set_config(false, false, false, $config);

+ set_config_count(false, false, false, $config);

+ $cache = new phpbb_mock_null_cache();

+ $phpbb_dispatcher = new phpbb_mock_event_dispatcher();

+ $phpbb_container = new phpbb_mock_container_builder();

+ $phpbb_container->set('notification_manager', new phpbb_mock_notification_manager());

+ }

+

+ public function first_last_post_data()

+ {

+ return array(

+ array(

+ 'retain', false,

+ array(

+ array('post_id' => 1, 'poster_id' => ANONYMOUS, 'post_username' => ''),

+ array('post_id' => 2, 'poster_id' => ANONYMOUS, 'post_username' => 'Other'),

+ array('post_id' => 3, 'poster_id' => ANONYMOUS, 'post_username' => ''),

+ array('post_id' => 4, 'poster_id' => ANONYMOUS, 'post_username' => 'Other'),

+ ),

+ array(

+ array(

+ 'topic_id' => 1,

+ 'topic_poster' => ANONYMOUS, 'topic_first_poster_name' => '', 'topic_first_poster_colour' => '',

+ 'topic_last_poster_id' => ANONYMOUS, 'topic_last_poster_name' => '', 'topic_last_poster_colour' => '',

+ ),

+ array(

+ 'topic_id' => 2,

+ 'topic_poster' => ANONYMOUS, 'topic_first_poster_name' => 'Other', 'topic_first_poster_colour' => '',

+ 'topic_last_poster_id' => ANONYMOUS, 'topic_last_poster_name' => 'Other', 'topic_last_poster_colour' => '',

+ ),

+ array(

+ 'topic_id' => 3,

+ 'topic_poster' => ANONYMOUS, 'topic_first_poster_name' => '', 'topic_first_poster_colour' => '',

+ 'topic_last_poster_id' => ANONYMOUS, 'topic_last_poster_name' => '', 'topic_last_poster_colour' => '',

+ ),

+ array(

+ 'topic_id' => 4,

+ 'topic_poster' => ANONYMOUS, 'topic_first_poster_name' => 'Other', 'topic_first_poster_colour' => '',

+ 'topic_last_poster_id' => ANONYMOUS, 'topic_last_poster_name' => 'Other', 'topic_last_poster_colour' => '',

+ ),

+ ),

+ array(

+ array('forum_id' => 1, 'forum_last_poster_id' => ANONYMOUS, 'forum_last_poster_name' => '', 'forum_last_poster_colour' => ''),

+ array('forum_id' => 2, 'forum_last_poster_id' => ANONYMOUS, 'forum_last_poster_name' => 'Other', 'forum_last_poster_colour' => ''),

+ array('forum_id' => 3, 'forum_last_poster_id' => ANONYMOUS, 'forum_last_poster_name' => '', 'forum_last_poster_colour' => ''),

+ array('forum_id' => 4, 'forum_last_poster_id' => ANONYMOUS, 'forum_last_poster_name' => 'Other', 'forum_last_poster_colour' => ''),

+ ),

+ ),

+ array(

+ 'remove', false,

+ array(

+ array('post_id' => 2, 'poster_id' => ANONYMOUS, 'post_username' => 'Other'),

+ array('post_id' => 4, 'poster_id' => ANONYMOUS, 'post_username' => 'Other'),

+ ),

+ array(

+ array(

+ 'topic_id' => 2,

+ 'topic_poster' => ANONYMOUS, 'topic_first_poster_name' => 'Other', 'topic_first_poster_colour' => '',

+ 'topic_last_poster_id' => ANONYMOUS, 'topic_last_poster_name' => 'Other', 'topic_last_poster_colour' => '',

+ ),

+ array(

+ 'topic_id' => 4,

+ 'topic_poster' => ANONYMOUS, 'topic_first_poster_name' => 'Other', 'topic_first_poster_colour' => '',

+ 'topic_last_poster_id' => ANONYMOUS, 'topic_last_poster_name' => 'Other', 'topic_last_poster_colour' => '',

+ ),

+ ),

+ array(

+ array('forum_id' => 1, 'forum_last_poster_id' => 0, 'forum_last_poster_name' => '', 'forum_last_poster_colour' => ''),

+ array('forum_id' => 2, 'forum_last_poster_id' => ANONYMOUS, 'forum_last_poster_name' => 'Other', 'forum_last_poster_colour' => ''),

+ array('forum_id' => 3, 'forum_last_poster_id' => 0, 'forum_last_poster_name' => '', 'forum_last_poster_colour' => ''),

+ array('forum_id' => 4, 'forum_last_poster_id' => ANONYMOUS, 'forum_last_poster_name' => 'Other', 'forum_last_poster_colour' => ''),

+ ),

+ ),

+ array(

+ 'retain', true,

+ array(

+ array('post_id' => 1, 'poster_id' => ANONYMOUS, 'post_username' => 'Foobar'),

+ array('post_id' => 2, 'poster_id' => ANONYMOUS, 'post_username' => 'Other'),

+ array('post_id' => 3, 'poster_id' => ANONYMOUS, 'post_username' => 'Foobar'),

+ array('post_id' => 4, 'poster_id' => ANONYMOUS, 'post_username' => 'Other'),

+ ),

+ array(

+ array(

+ 'topic_id' => 1,

+ 'topic_poster' => ANONYMOUS, 'topic_first_poster_name' => 'Foobar', 'topic_first_poster_colour' => '',

+ 'topic_last_poster_id' => ANONYMOUS, 'topic_last_poster_name' => 'Foobar', 'topic_last_poster_colour' => '',

+ ),

+ array(

+ 'topic_id' => 2,

+ 'topic_poster' => ANONYMOUS, 'topic_first_poster_name' => 'Other', 'topic_first_poster_colour' => '',

+ 'topic_last_poster_id' => ANONYMOUS, 'topic_last_poster_name' => 'Other', 'topic_last_poster_colour' => '',

+ ),

+ array(

+ 'topic_id' => 3,

+ 'topic_poster' => ANONYMOUS, 'topic_first_poster_name' => 'Foobar', 'topic_first_poster_colour' => '',

+ 'topic_last_poster_id' => ANONYMOUS, 'topic_last_poster_name' => 'Foobar', 'topic_last_poster_colour' => '',

+ ),

+ array(

+ 'topic_id' => 4,

+ 'topic_poster' => ANONYMOUS, 'topic_first_poster_name' => 'Other', 'topic_first_poster_colour' => '',

+ 'topic_last_poster_id' => ANONYMOUS, 'topic_last_poster_name' => 'Other', 'topic_last_poster_colour' => '',

+ ),

+ ),

+ array(

+ array('forum_id' => 1, 'forum_last_poster_id' => ANONYMOUS, 'forum_last_poster_name' => 'Foobar', 'forum_last_poster_colour' => ''),

+ array('forum_id' => 2, 'forum_last_poster_id' => ANONYMOUS, 'forum_last_poster_name' => 'Other', 'forum_last_poster_colour' => ''),

+ array('forum_id' => 3, 'forum_last_poster_id' => ANONYMOUS, 'forum_last_poster_name' => 'Foobar', 'forum_last_poster_colour' => ''),

+ array('forum_id' => 4, 'forum_last_poster_id' => ANONYMOUS, 'forum_last_poster_name' => 'Other', 'forum_last_poster_colour' => ''),

+ ),

+ ),

+ array(

+ 'remove', true,

+ array(

+ array('post_id' => 2, 'poster_id' => ANONYMOUS, 'post_username' => 'Other'),

+ array('post_id' => 4, 'poster_id' => ANONYMOUS, 'post_username' => 'Other'),

+ ),

+ array(

+ array(

+ 'topic_id' => 2,

+ 'topic_poster' => ANONYMOUS, 'topic_first_poster_name' => 'Other', 'topic_first_poster_colour' => '',

+ 'topic_last_poster_id' => ANONYMOUS, 'topic_last_poster_name' => 'Other', 'topic_last_poster_colour' => '',

+ ),

+ array(

+ 'topic_id' => 4,

+ 'topic_poster' => ANONYMOUS, 'topic_first_poster_name' => 'Other', 'topic_first_poster_colour' => '',

+ 'topic_last_poster_id' => ANONYMOUS, 'topic_last_poster_name' => 'Other', 'topic_last_poster_colour' => '',

+ ),

+ ),

+ array(

+ array('forum_id' => 1, 'forum_last_poster_id' => 0, 'forum_last_poster_name' => '', 'forum_last_poster_colour' => ''),

+ array('forum_id' => 2, 'forum_last_poster_id' => ANONYMOUS, 'forum_last_poster_name' => 'Other', 'forum_last_poster_colour' => ''),

+ array('forum_id' => 3, 'forum_last_poster_id' => 0, 'forum_last_poster_name' => '', 'forum_last_poster_colour' => ''),

+ array('forum_id' => 4, 'forum_last_poster_id' => ANONYMOUS, 'forum_last_poster_name' => 'Other', 'forum_last_poster_colour' => ''),

+ ),

+ ),

+ );

+ }

+

+ /**

+ * @dataProvider first_last_post_data

+ */

+ public function test_first_last_post_info($mode, $retain_username, $expected_posts, $expected_topics, $expected_forums)

+ {

+ $this->assertFalse(user_delete($mode, 2, $retain_username));

+

+ $sql = 'SELECT post_id, poster_id, post_username

+ FROM ' . POSTS_TABLE . '

+ ORDER BY post_id ASC';

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

+ $this->assertEquals($expected_posts, $this->db->sql_fetchrowset($result), 'Post table poster info is mismatching after deleting a user.');

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

+

+ $sql = 'SELECT topic_id, topic_poster, topic_first_poster_name, topic_first_poster_colour, topic_last_poster_id, topic_last_poster_name, topic_last_poster_colour

+ FROM ' . TOPICS_TABLE . '

+ ORDER BY topic_id ASC';

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

+ $this->assertEquals($expected_topics, $this->db->sql_fetchrowset($result), 'Topic table first/last poster info is mismatching after deleting a user.');

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

+

+ $sql = 'SELECT forum_id, forum_last_poster_id, forum_last_poster_name, forum_last_poster_colour

+ FROM ' . FORUMS_TABLE . '

+ ORDER BY forum_id ASC';

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

+ $this->assertEquals($expected_forums, $this->db->sql_fetchrowset($result), 'Forum table last poster info is mismatching after deleting a user.');

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

+ }

+

+ public function report_attachment_data()

+ {

+ return array(

+ array(

+ 'retain',

+ array(

+ array('post_id' => 1, 'post_reported' => 1, 'post_edit_user' => 1, 'post_delete_user' => 1),

+ array('post_id' => 2, 'post_reported' => 1, 'post_edit_user' => 1, 'post_delete_user' => 1),

+ array('post_id' => 3, 'post_reported' => 0, 'post_edit_user' => 1, 'post_delete_user' => 1),

+ array('post_id' => 4, 'post_reported' => 0, 'post_edit_user' => 1, 'post_delete_user' => 1),

+ ),

+ array(

+ array('report_id' => 1, 'post_id' => 1, 'user_id' => 1),

+ array('report_id' => 3, 'post_id' => 2, 'user_id' => 1),

+ ),

+ array(

+ array('topic_id' => 1, 'topic_reported' => 1, 'topic_delete_user' => 1),

+ array('topic_id' => 2, 'topic_reported' => 1, 'topic_delete_user' => 1),

+ array('topic_id' => 3, 'topic_reported' => 0, 'topic_delete_user' => 1),

+ array('topic_id' => 4, 'topic_reported' => 0, 'topic_delete_user' => 1),

+ ),

+ array(

+ array('attach_id' => 1, 'post_msg_id' => 1, 'poster_id' => 1),

+ array('attach_id' => 2, 'post_msg_id' => 2, 'poster_id' => 1),

+ array('attach_id' => 3, 'post_msg_id' => 0, 'poster_id' => 1), // TODO should be deleted: PHPBB3-13089

+ ),

+ ),

+ array(

+ 'remove',

+ array(

+ array('post_id' => 2, 'post_reported' => 1, 'post_edit_user' => 1, 'post_delete_user' => 1),

+ array('post_id' => 4, 'post_reported' => 0, 'post_edit_user' => 1, 'post_delete_user' => 1),

+ ),

+ array(

+ array('report_id' => 3, 'post_id' => 2, 'user_id' => 1),

+ ),

+ array(

+ array('topic_id' => 2, 'topic_reported' => 1, 'topic_delete_user' => 1),

+ array('topic_id' => 4, 'topic_reported' => 0, 'topic_delete_user' => 1),

+ ),

+ array(

+ array('attach_id' => 2, 'post_msg_id' => 2, 'poster_id' => 1),

+ array('attach_id' => 3, 'post_msg_id' => 0, 'poster_id' => 2), // TODO should be deleted: PHPBB3-13089

+ ),

+ ),

+ );

+ }

+

+ /**

+ * @dataProvider report_attachment_data

+ */

+ public function test_report_attachment_info($mode, $expected_posts, $expected_reports, $expected_topics, $expected_attach)

+ {

+ $this->assertFalse(user_delete($mode, 2));

+

+ $sql = 'SELECT post_id, post_reported, post_edit_user, post_delete_user

+ FROM ' . POSTS_TABLE . '

+ ORDER BY post_id ASC';

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

+ $this->assertEquals($expected_posts, $this->db->sql_fetchrowset($result), 'Post report status content is mismatching after deleting a user.');

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

+

+ $sql = 'SELECT report_id, post_id, user_id

+ FROM ' . REPORTS_TABLE . '

+ ORDER BY report_id ASC';

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

+ $this->assertEquals($expected_reports, $this->db->sql_fetchrowset($result), 'Report table content is mismatching after deleting a user.');

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

+

+ $sql = 'SELECT topic_id, topic_reported, topic_delete_user

+ FROM ' . TOPICS_TABLE . '

+ ORDER BY topic_id ASC';

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

+ $this->assertEquals($expected_topics, $this->db->sql_fetchrowset($result), 'Topic report status is mismatching after deleting a user.');

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

+

+ $sql = 'SELECT attach_id, post_msg_id, poster_id

+ FROM ' . ATTACHMENTS_TABLE . '

+ ORDER BY attach_id ASC';

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

+ $this->assertEquals($expected_attach, $this->db->sql_fetchrowset($result), 'Attachment table content is mismatching after deleting a user.');

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

+ }

+

+ public function delete_data()

+ {

+ return array(

+ array(

+ 'retain',

+ array(array('user_id' => 1, 'user_posts' => 4)),

+ array(array('user_id' => 1, 'zebra_id' => 3)),

+ array(array('ban_id' => 2), array('ban_id' => 3)),

+ array(array('session_id' => '12345678901234567890123456789013')),

+ array(

+ array('log_id' => 2, 'user_id' => 1, 'reportee_id' => 1),

+ array('log_id' => 3, 'user_id' => 1, 'reportee_id' => 1),

+ ),

+ array(

+ array('msg_id' => 1, 'author_id' => 3, 'message_edit_user' => 3),

+ array('msg_id' => 2, 'author_id' => 1, 'message_edit_user' => 1),

+ ),

+ ),

+ array(

+ 'remove',

+ array(array('user_id' => 1, 'user_posts' => 2)),

+ array(array('user_id' => 1, 'zebra_id' => 3)),

+ array(array('ban_id' => 2), array('ban_id' => 3)),

+ array(array('session_id' => '12345678901234567890123456789013')),

+ array(

+ array('log_id' => 2, 'user_id' => 1, 'reportee_id' => 1),

+ array('log_id' => 3, 'user_id' => 1, 'reportee_id' => 1),

+ ),

+ array(

+ array('msg_id' => 1, 'author_id' => 3, 'message_edit_user' => 3),

+ array('msg_id' => 2, 'author_id' => 1, 'message_edit_user' => 1),

+ ),

+ ),

+ );

+ }

+

+ /**

+ * @dataProvider delete_data

+ */

+ public function test_delete_data($mode, $expected_users, $expected_zebra, $expected_ban, $expected_sessions, $expected_logs, $expected_pms)

+ {

+ $this->assertFalse(user_delete($mode, 2));

+

+ $sql = 'SELECT user_id, user_posts

+ FROM ' . USERS_TABLE . '

+ ORDER BY user_id ASC';

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

+ $this->assertEquals($expected_users, $this->db->sql_fetchrowset($result), 'User table content is mismatching after deleting a user.');

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

+

+ $sql = 'SELECT user_id, zebra_id

+ FROM ' . ZEBRA_TABLE . '

+ ORDER BY user_id ASC, zebra_id ASC';

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

+ $this->assertEquals($expected_zebra, $this->db->sql_fetchrowset($result), 'Zebra table content is mismatching after deleting a user.');

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

+

+ $sql = 'SELECT ban_id

+ FROM ' . BANLIST_TABLE . '

+ ORDER BY ban_id ASC';

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

+ $this->assertEquals($expected_ban, $this->db->sql_fetchrowset($result), 'Ban table content is mismatching after deleting a user.');

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

+

+ $sql = 'SELECT session_id

+ FROM ' . SESSIONS_TABLE . '

+ ORDER BY session_id ASC';

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

+ $this->assertEquals($expected_sessions, $this->db->sql_fetchrowset($result), 'Session table content is mismatching after deleting a user.');

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

+

+ $sql = 'SELECT log_id, user_id, reportee_id

+ FROM ' . LOG_TABLE . '

+ ORDER BY log_id ASC';

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

+ $this->assertEquals($expected_logs, $this->db->sql_fetchrowset($result), 'Log table content is mismatching after deleting a user.');

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

+

+ $sql = 'SELECT msg_id, author_id, message_edit_user

+ FROM ' . PRIVMSGS_TABLE . '

+ ORDER BY msg_id ASC';

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

+ $this->assertEquals($expected_pms, $this->db->sql_fetchrowset($result), 'Private messages table content is mismatching after deleting a user.');

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

+ }

+

+ public function delete_user_id_data()

+ {

+ return array(

+ array(

+ 'retain',

+ array(

+ USER_GROUP_TABLE,

+ TOPICS_WATCH_TABLE,

+ FORUMS_WATCH_TABLE,

+ ACL_USERS_TABLE,

+ TOPICS_TRACK_TABLE,

+ TOPICS_POSTED_TABLE,

+ FORUMS_TRACK_TABLE,

+ PROFILE_FIELDS_DATA_TABLE,

+ MODERATOR_CACHE_TABLE,

+ DRAFTS_TABLE,

+ BOOKMARKS_TABLE,

+ SESSIONS_KEYS_TABLE,

+ PRIVMSGS_FOLDER_TABLE,

+ PRIVMSGS_RULES_TABLE,

+ ),

+ ),

+ array(

+ 'remove',

+ array(

+ USER_GROUP_TABLE,

+ TOPICS_WATCH_TABLE,

+ FORUMS_WATCH_TABLE,

+ ACL_USERS_TABLE,

+ TOPICS_TRACK_TABLE,

+ TOPICS_POSTED_TABLE,

+ FORUMS_TRACK_TABLE,

+ PROFILE_FIELDS_DATA_TABLE,

+ MODERATOR_CACHE_TABLE,

+ DRAFTS_TABLE,

+ BOOKMARKS_TABLE,

+ SESSIONS_KEYS_TABLE,

+ PRIVMSGS_FOLDER_TABLE,

+ PRIVMSGS_RULES_TABLE,

+ ),

+ ),

+ );

+ }

+

+ /**

+ * @dataProvider delete_user_id_data

+ */

+ public function test_delete_user_id_data($mode, $cleaned_tables)

+ {

+ $this->assertFalse(user_delete($mode, 2));

+

+ foreach ($cleaned_tables as $table)

+ {

+ $sql = 'SELECT user_id

+ FROM ' . $table . '

+ WHERE user_id = 2';

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

+ $this->assertFalse($this->db->sql_fetchfield('user_id'), 'Found data for deleted user in table: ' . $table);

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

+

+ $sql = 'SELECT user_id

+ FROM ' . $table . '

+ WHERE user_id = 3';

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

+ $this->assertEquals(3, $this->db->sql_fetchfield('user_id'), 'Missing data for user in table: ' . $table);

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

+ }

+ }

+}

+<?xml version="1.0" encoding="UTF-8" ?>

+<dataset>

+ <table name="phpbb_attachments">

+ <column>attach_id</column>

+ <column>post_msg_id</column>

+ <column>topic_id</column>

+ <column>in_message</column>

+ <column>poster_id</column>

+ <column>is_orphan</column>

+ <column>attach_comment</column>

+ <row>

+ <value>1</value>

+ <value>1</value>

+ <value>1</value>

+ <value>0</value>

+ <value>2</value>

+ <value>0</value>

+ <value></value>

+ </row>

+ <row>

+ <value>2</value>

+ <value>2</value>

+ <value>2</value>

+ <value>0</value>

+ <value>1</value>

+ <value>0</value>

+ <value></value>

+ </row>

+ <row>

+ <value>3</value>

+ <value>0</value>

+ <value>0</value>

+ <value>0</value>

+ <value>2</value>

+ <value>1</value>

+ <value></value>

+ </row>

+ </table>

+ <table name="phpbb_banlist">

+ <column>ban_id</column>

+ <column>ban_userid</column>

+ <column>ban_email</column>

+ <column>ban_reason</column>

+ <column>ban_give_reason</column>

+ <row>

+ <value>1</value>

+ <value>2</value>

+ <value></value>

+ <value></value>

+ <value></value>

+ </row>

+ <row>

+ <value>2</value>

+ <value>3</value>

+ <value></value>

+ <value></value>

+ <value></value>

+ </row>

+ <row>

+ <value>3</value>

+ <value>0</value>

+ <value></value>

+ <value></value>

+ <value></value>

+ </row>

+ </table>

+ <table name="phpbb_forums">

+ <column>forum_id</column>

+ <column>forum_last_poster_id</column>

+ <column>forum_last_poster_name</column>

+ <column>forum_last_poster_colour</column>

+ <column>forum_parents</column>

+ <column>forum_desc</column>

+ <column>forum_rules</column>

+ <row>

+ <value>1</value>

+ <value>2</value>

+ <value></value>

+ <value>00AA00</value>

+ <value></value>

+ <value></value>

+ <value></value>

+ </row>

+ <row>

+ <value>2</value>

+ <value>1</value>

+ <value>Other</value>

+ <value></value>

+ <value></value>

+ <value></value>

+ <value></value>

+ </row>

+ <row>

+ <value>3</value>

+ <value>2</value>

+ <value></value>

+ <value>00AA00</value>

+ <value></value>

+ <value></value>

+ <value></value>

+ </row>

+ <row>

+ <value>4</value>

+ <value>1</value>

+ <value>Other</value>

+ <value></value>

+ <value></value>

+ <value></value>

+ <value></value>

+ </row>

+ </table>

+ <table name="phpbb_log">

+ <column>log_id</column>

+ <column>user_id</column>

+ <column>reportee_id</column>

+ <column>log_operation</column>

+ <column>log_data</column>

+ <row>

+ <value>1</value>

+ <value>1</value>

+ <value>2</value>

+ <value></value>

+ <value></value>

+ </row>

+ <row>

+ <value>2</value>

+ <value>2</value>

+ <value>1</value>

+ <value></value>

+ <value></value>

+ </row>

+ <row>

+ <value>3</value>

+ <value>1</value>

+ <value>1</value>

+ <value></value>

+ <value></value>

+ </row>

+ <row>

+ <value>4</value>

+ <value>2</value>

+ <value>2</value>

+ <value></value>

+ <value></value>

+ </row>

+ </table>

+ <table name="phpbb_posts">

+ <column>post_id</column>

+ <column>poster_id</column>

+ <column>post_edit_user</column>

+ <column>post_delete_user</column>

+ <column>post_username</column>

+ <column>topic_id</column>

+ <column>forum_id</column>

+ <column>post_visibility</column>

+ <column>post_time</column>

+ <column>post_text</column>

+ <column>post_reported</column>

+ <row>

+ <value>1</value>

+ <value>2</value>

+ <value>2</value>

+ <value>2</value>

+ <value></value>

+ <value>1</value>

+ <value>1</value>

+ <value>1</value>

+ <value>1</value>

+ <value></value>

+ <value>1</value>

+ </row>

+ <row>

+ <value>2</value>

+ <value>1</value>

+ <value>1</value>

+ <value>1</value>

+ <value>Other</value>

+ <value>2</value>

+ <value>2</value>

+ <value>1</value>

+ <value>1</value>

+ <value></value>

+ <value>1</value>

+ </row>

+ <row>

+ <value>3</value>

+ <value>2</value>

+ <value>2</value>

+ <value>2</value>

+ <value></value>

+ <value>3</value>

+ <value>3</value>

+ <value>1</value>

+ <value>1</value>

+ <value></value>

+ <value>1</value>

+ </row>

+ <row>

+ <value>4</value>

+ <value>1</value>

+ <value>1</value>

+ <value>1</value>

+ <value>Other</value>

+ <value>4</value>

+ <value>4</value>

+ <value>1</value>

+ <value>1</value>

+ <value></value>

+ <value>1</value>

+ </row>

+ </table>

+ <table name="phpbb_privmsgs">

+ <column>msg_id</column>

+ <column>author_id</column>

+ <column>message_edit_user</column>

+ <column>message_text</column>

+ <column>to_address</column>

+ <column>bcc_address</column>

+ <row>

+ <value>1</value>

+ <value>3</value>

+ <value>3</value>

+ <value></value>

+ <value></value>

+ <value></value>

+ </row>

+ <row>

+ <value>2</value>

+ <value>2</value>

+ <value>2</value>

+ <value></value>

+ <value></value>

+ <value></value>

+ </row>

+ </table>

+ <table name="phpbb_privmsgs_to">

+ <column>msg_id</column>

+ <column>user_id</column>

+ <column>author_id</column>

+ <row>

+ <value>1</value>

+ <value>3</value>

+ <value>3</value>

+ </row>

+ <row>

+ <value>1</value>

+ <value>2</value>

+ <value>3</value>

+ </row>

+ <row>

+ <value>2</value>

+ <value>3</value>

+ <value>2</value>

+ </row>

+ <row>

+ <value>2</value>

+ <value>2</value>

+ <value>2</value>

+ </row>

+ </table>

+ <table name="phpbb_reports">

+ <column>report_id</column>

+ <column>post_id</column>

+ <column>user_id</column>

+ <column>report_text</column>

+ <column>reported_post_text</column>

+ <row>

+ <value>1</value>

+ <value>1</value>

+ <value>1</value>

+ <value>Post Removed?</value>

+ <value></value>

+ </row>

+ <row>

+ <value>2</value>

+ <value>3</value>

+ <value>2</value>

+ <value>Post Removed?</value>

+ <value></value>

+ </row>

+ <row>

+ <value>3</value>

+ <value>2</value>

+ <value>1</value>

+ <value>Keep</value>

+ <value></value>

+ </row>

+ <row>

+ <value>4</value>

+ <value>4</value>

+ <value>2</value>

+ <value>Remove Report</value>

+ <value></value>

+ </row>

+ </table>

+ <table name="phpbb_sessions">

+ <column>session_id</column>

+ <column>session_user_id</column>

+ <column>session_page</column>

+ <row>

+ <value>12345678901234567890123456789012</value>

+ <value>2</value>

+ <value></value>

+ </row>

+ <row>

+ <value>12345678901234567890123456789013</value>

+ <value>3</value>

+ <value></value>

+ </row>

+ </table>

+ <table name="phpbb_topics">

+ <column>topic_id</column>

+ <column>forum_id</column>

+ <column>topic_reported</column>

+ <column>topic_poster</column>

+ <column>topic_delete_user</column>

+ <column>topic_first_poster_name</column>

+ <column>topic_first_poster_colour</column>

+ <column>topic_last_poster_id</column>

+ <column>topic_last_poster_name</column>

+ <column>topic_last_poster_colour</column>

+ <row>

+ <value>1</value>

+ <value>1</value>

+ <value>1</value>

+ <value>2</value>

+ <value>2</value>

+ <value></value>

+ <value>00AA00</value>

+ <value>2</value>

+ <value></value>

+ <value>00AA00</value>

+ </row>

+ <row>

+ <value>2</value>

+ <value>2</value>

+ <value>1</value>

+ <value>1</value>

+ <value>1</value>

+ <value>Other</value>

+ <value></value>

+ <value>1</value>

+ <value>Other</value>

+ <value></value>

+ </row>

+ <row>

+ <value>3</value>

+ <value>3</value>

+ <value>1</value>

+ <value>2</value>

+ <value>2</value>

+ <value></value>

+ <value>00AA00</value>

+ <value>2</value>

+ <value></value>

+ <value>00AA00</value>

+ </row>

+ <row>

+ <value>4</value>

+ <value>4</value>

+ <value>1</value>

+ <value>1</value>

+ <value>1</value>

+ <value>Other</value>

+ <value></value>

+ <value>1</value>

+ <value>Other</value>

+ <value></value>

+ </row>

+ </table>

+ <table name="phpbb_users">

+ <column>user_id</column>

+ <column>username</column>

+ <column>username_clean</column>

+ <column>user_permissions</column>

+ <column>user_sig</column>

+ <column>user_posts</column>

+ <row>

+ <value>1</value>

+ <value>Anonymous</value>

+ <value>anonymous</value>

+ <value></value>

+ <value></value>

+ <value>2</value>

+ </row>

+ <row>

+ <value>2</value>

+ <value>Foobar</value>

+ <value>foobar</value>

+ <value></value>

+ <value></value>

+ <value>2</value>

+ </row>

+ </table>

+ <table name="phpbb_zebra">

+ <column>user_id</column>

+ <column>zebra_id</column>

+ <row>

+ <value>1</value>

+ <value>2</value>

+ </row>

+ <row>

+ <value>1</value>

+ <value>3</value>

+ </row>

+ <row>

+ <value>2</value>

+ <value>1</value>

+ </row>

+ </table>

+ <table name="phpbb_user_group">

+ <column>user_id</column>

+ <row>

+ <value>2</value>

+ </row>

+ <row>

+ <value>3</value>

+ </row>

+ </table>

+ <table name="phpbb_topics_watch">

+ <column>user_id</column>

+ <row>

+ <value>2</value>

+ </row>

+ <row>

+ <value>3</value>

+ </row>

+ </table>

+ <table name="phpbb_forums_watch">

+ <column>user_id</column>

+ <row>

+ <value>2</value>

+ </row>

+ <row>

+ <value>3</value>

+ </row>

+ </table>

+ <table name="phpbb_acl_users">

+ <column>user_id</column>

+ <row>

+ <value>2</value>

+ </row>

+ <row>

+ <value>3</value>

+ </row>

+ </table>

+ <table name="phpbb_topics_track">

+ <column>user_id</column>

+ <row>

+ <value>2</value>

+ </row>

+ <row>

+ <value>3</value>

+ </row>

+ </table>

+ <table name="phpbb_forums_track">

+ <column>user_id</column>

+ <row>

+ <value>2</value>

+ </row>

+ <row>

+ <value>3</value>

+ </row>

+ </table>

+ <table name="phpbb_topics_posted">

+ <column>user_id</column>

+ <row>

+ <value>2</value>

+ </row>

+ <row>

+ <value>3</value>

+ </row>

+ </table>

+ <table name="phpbb_profile_fields_data">

+ <column>user_id</column>

+ <column>pf_phpbb_interests</column>

+ <column>pf_phpbb_occupation</column>

+ <row>

+ <value>2</value>

+ <value></value>

+ <value></value>

+ </row>

+ <row>

+ <value>3</value>

+ <value></value>

+ <value></value>

+ </row>

+ </table>

+ <table name="phpbb_moderator_cache">

+ <column>user_id</column>

+ <row>

+ <value>2</value>

+ </row>

+ <row>

+ <value>3</value>

+ </row>

+ </table>

+ <table name="phpbb_bookmarks">

+ <column>user_id</column>

+ <row>

+ <value>2</value>

+ </row>

+ <row>

+ <value>3</value>

+ </row>

+ </table>

+ <table name="phpbb_sessions_keys">

+ <column>user_id</column>

+ <row>

+ <value>2</value>

+ </row>

+ <row>

+ <value>3</value>

+ </row>

+ </table>

+ <table name="phpbb_privmsgs_folder">

+ <column>user_id</column>

+ <row>

+ <value>2</value>

+ </row>

+ <row>

+ <value>3</value>

+ </row>

+ </table>

+ <table name="phpbb_privmsgs_rules">

+ <column>user_id</column>

+ <column>rule_string</column>

+ <row>

+ <value>2</value>

+ <value></value>

+ </row>

+ <row>

+ <value>3</value>

+ <value></value>

+ </row>

+ </table>

+ <table name="phpbb_drafts">

+ <column>user_id</column>

+ <column>draft_message</column>

+ <row>

+ <value>2</value>

+ <value></value>

+ </row>

+ <row>

+ <value>3</value>

+ <value></value>

+ </row>

+ </table>

+</dataset>

+ // UTF-8 string tests

+ array(

+ 'ö äö äö ä',

+ array('field_validation' => '[\p{Lu}\p{Ll}0-9]+'),

+ 'FIELD_INVALID_CHARS_LETTER_NUM_ONLY-field',

+ 'Required field should reject spaces in UTF-8 letternumeric only field',

+ ),

+ array(

+ 'Имя123',

+ array('field_validation' => '[\p{Lu}\p{Ll}0-9]+'),

+ false,

+ 'Required field should accept UTF-8 letternumeric only field',

+ ),

+ array(

+ 'Ö äö äö- ä+',

+ array('field_validation' => '[\p{Lu}\p{Ll}0-9_]+'),

+ 'FIELD_INVALID_CHARS_LETTER_NUM_UNDERSCORE-field',

+ 'Required field should reject spacers in UTF-8 letternumeric with underscore field',

+ ),

+ array(

+ 'Правильное.Имя123',

+ array('field_validation' => '[\p{Lu}\p{Ll}0-9.]+'),

+ false,

+ 'Required field should accept UTF-8 letternumeric field with dots',

+ ),

+ array(

+ 'Неправильное.,имя123',

+ array('field_validation' => '[\p{Lu}\p{Ll}0-9.]+'),

+ 'FIELD_INVALID_CHARS_LETTER_NUM_DOTS-field',

+ 'Required field should reject comma in UTF-8 letternumeric field with dots',

+ ),

+ array(

+ 'Ö äö äö- ä+',

+ array('field_validation' => '[\p{Lu}\p{Ll}0-9\x20_+\-\[\]]+'),

+ false,

+ 'Required field should accept spacers in UTF-8 letternumeric with spacers field',

+ ),

+ array(

+ 'skype.test.name,_this',

+ array('field_validation' => '[\p{Lu}\p{Ll}][\p{Lu}\p{Ll}0-9.,\-_]+'),

+ false,

+ 'Required field should accept alphanumeric value for UTF-8 letternumeric field with punctuations',

+ ),

+ array(

+ '1skype.this.should.fail',

+ array('field_validation' => '[\p{Lu}\p{Ll}][\p{Lu}\p{Ll}0-9.,\-_]+'),

+ 'FIELD_INVALID_CHARS_LETTER_NUM_PUNCTUATION-field',

+ 'Required field should reject field having leading numeric for UTF-8 letternumeric field with punctuations',

+ ),

+ <table name="phpbb_banlist">

+ <column>ban_id</column>

+ <column>ban_userid</column>

+ <column>ban_email</column>

+ <column>ban_reason</column>

+ <column>ban_give_reason</column>

+ </table>

+ // Calling second-granularity time functions twice isn't guaranteed to

+ // give the same results. As long as they're in the right order, allow

+ // a 1 second difference.

+ $this->assertGreaterThanOrEqual(

+ $expected, $actual,

+ 'Expected second time to be after (or equal to) the previous one'

+ );

+ $this->assertLessThanOrEqual(

+ 1,

+ abs($actual - $expected),

+ "Expected $actual to be within 1 second of $expected."

+ );