+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+class phpbb_auth_provider_acp_board_invalid

+{

+

+}

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+class phpbb_auth_provider_acp_board_valid extends phpbb_auth_provider_base

+{

+ public function login($username, $password)

+ {

+ return;

+ }

+}

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

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

+require_once dirname(__FILE__) . '/auth_provider/invalid.php';

+require_once dirname(__FILE__) . '/auth_provider/valid.php';

+

+class phpbb_acp_board_select_auth_method_test extends phpbb_test_case

+{

+ protected $acp_board;

+

+ public static function select_auth_method_data()

+ {

+ return array(

+ array('acp_board_valid', '<option value="acp_board_valid" selected="selected">Acp_board_valid</option>'),

+ array('acp_board_invalid', '<option value="acp_board_valid">Acp_board_valid</option>'),

+ );

+ }

+

+ public function setUp()

+ {

+ parent::setUp();

+

+ global $phpbb_container;

+ $phpbb_container = new phpbb_mock_container_builder();

+

+ $phpbb_container->set('auth.provider_collection', array(

+ 'auth.provider.acp_board_valid' => new phpbb_auth_provider_acp_board_valid,

+ 'auth.provider.acp_board_invalid' => new phpbb_auth_provider_acp_board_invalid,

+ ));

+

+ $this->acp_board = new acp_board();

+ }

+

+ /**

+ * @dataProvider select_auth_method_data

+ */

+ public function test_select_auth_method($selected, $expected)

+ {

+ $this->assertEquals($expected, $this->acp_board->select_auth_method($selected));

+ }

+}

+ ->will($this->returnArgument(0));

+ // $this->avatar_foobar will be needed later on

+ ->method('get_name')

+ ->will($this->returnValue('avatar.driver.foobar'));

+ // barfoo driver can't be mocked with constructor arguments

+ ->method('get_name')

+ ->will($this->returnValue('avatar.driver.barfoo'));

+ foreach ($this->avatar_drivers() as $driver)

+ {

+ $cur_avatar = $this->getMock('phpbb_avatar_driver_' . $driver, array('get_name'), array($config, $phpbb_root_path, $phpEx, $cache));

+ $cur_avatar->expects($this->any())

+ ->method('get_name')

+ ->will($this->returnValue('avatar.driver.' . $driver));

+ $config['allow_avatar_' . get_class($cur_avatar)] = false;

+ $avatar_drivers[] = $cur_avatar;

+ }

+

+ protected function avatar_drivers()

+ return array(

+ 'local',

+ 'upload',

+ 'remote',

+ 'gravatar',

+ );

+ $this->assertEquals(array(

+ 'avatar.driver.barfoo' => 'avatar.driver.barfoo',

+ 'avatar.driver.foobar' => 'avatar.driver.foobar',

+ 'avatar.driver.local' => 'avatar.driver.local',

+ 'avatar.driver.remote' => 'avatar.driver.remote',

+ 'avatar.driver.upload' => 'avatar.driver.upload',

+ 'avatar.driver.gravatar' => 'avatar.driver.gravatar',

+ ), $drivers);

+ public function get_driver_data_enabled()

+ {

+ return array(

+ array('avatar.driver.foobar', 'avatar.driver.foobar'),

+ array('avatar.driver.foo_wrong', null),

+ array('avatar.driver.local', null),

+ array(AVATAR_GALLERY, null),

+ array(AVATAR_UPLOAD, null),

+ array(AVATAR_REMOTE, null),

+ );

+ }

+

+ /**

+ * @dataProvider get_driver_data_enabled

+ */

+ public function test_get_driver_enabled($driver_name, $expected)

+ {

+ $driver = $this->manager->get_driver($driver_name);

+ $this->assertEquals($expected, $driver);

+ }

+

+ public function get_driver_data_all()

+ {

+ return array(

+ array('avatar.driver.foobar', 'avatar.driver.foobar'),

+ array('avatar.driver.foo_wrong', null),

+ array('avatar.driver.local', 'avatar.driver.local'),

+ array(AVATAR_GALLERY, 'avatar.driver.local'),

+ array(AVATAR_UPLOAD, 'avatar.driver.upload'),

+ array(AVATAR_REMOTE, 'avatar.driver.remote'),

+ );

+ }

+

+ /**

+ * @dataProvider get_driver_data_all

+ */

+ public function test_get_driver_all($driver_name, $expected)

+ {

+ $driver = $this->manager->get_driver($driver_name, false);

+ $this->assertEquals($expected, $driver);

+ }

+

+

+ public function test_clean_driver_name()

+ {

+ $this->assertEquals('avatar.driver.local', $this->manager->clean_driver_name('avatar_driver_local'));

+ }

+

+ public function test_prepare_driver_name()

+ {

+ $this->assertEquals('avatar_driver_local', $this->manager->prepare_driver_name('avatar.driver.local'));

+ }

+

+ public function test_localize_errors()

+ {

+ $user = $this->getMock('phpbb_user');

+ $lang_array = array(

+ array('FOOBAR_OFF', 'foobar_off'),

+ array('FOOBAR_EXPLAIN', 'FOOBAR_EXPLAIN %s'),

+ );

+ $user->expects($this->any())

+ ->method('lang')

+ ->will($this->returnValueMap($lang_array));

+

+ // Pass error as string

+ $this->assertEquals(array('foobar_off'), $this->manager->localize_errors($user, array('FOOBAR_OFF')));

+

+ // Pass error as array for vsprintf()

+ $this->assertEquals(array('FOOBAR_EXPLAIN foo'), $this->manager->localize_errors($user, array(array('FOOBAR_EXPLAIN', 'foo'))));

+

+ // Pass both types

+ $this->assertEquals(array('foobar_off', 'FOOBAR_EXPLAIN foo'), $this->manager->localize_errors($user, array(

+ 'FOOBAR_OFF',

+ array('FOOBAR_EXPLAIN', 'foo'),

+ )));

+ }

+require_once $phpbb_root_path . 'phpbb/class_loader.' . $phpEx;

+$phpbb_class_loader = new phpbb_class_loader('phpbb_', $phpbb_root_path . 'phpbb/', "php");

+ $class_loader = new phpbb_class_loader('phpbb_', $prefix . 'phpbb/');

+ $prefix .= 'phpbb/';

+ $class_loader = new phpbb_class_loader('phpbb_', $prefix . 'phpbb/', 'php', $cache);

+ $class_loader_ext = new phpbb_class_loader('phpbb_ext_', $prefix . 'phpbb/', 'php', $cache);

+ $prefix .= 'phpbb/';

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2012 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_admin.php';

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

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

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

+require_once dirname(__FILE__) . '/../mock/search.php';

+

+class phpbb_content_visibility_delete_post_test extends phpbb_database_test_case

+{

+ public function getDataSet()

+ {

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

+ }

+

+ public function delete_post_data()

+ {

+ $info_data = array(

+ 'topic_first_post_id' => 1,

+ 'topic_last_post_id' => 3,

+ 'topic_posts_approved' => 3,

+ 'topic_posts_unapproved' => 0,

+ 'topic_posts_softdeleted' => 0,

+ 'topic_visibility' => ITEM_APPROVED,

+ 'post_time' => 2,

+ 'post_visibility' => ITEM_APPROVED,

+ 'post_postcount' => true,

+ 'poster_id' => 1,

+ 'post_reported' => false,

+ );

+

+ return array(

+ array(

+ 1, 1, 2,

+ array_merge($info_data, array(

+ 'post_time' => 2,

+ )),

+ false, 'harddelete',

+ array(

+ array('post_id' => 1, 'post_visibility' => ITEM_APPROVED, 'post_delete_reason' => ''),

+ //array('post_id' => 2, 'post_visibility' => ITEM_APPROVED, 'post_delete_reason' => ''),

+ array('post_id' => 3, 'post_visibility' => ITEM_APPROVED, 'post_delete_reason' => ''),

+ ),

+ array(

+ array(

+ 'topic_visibility' => ITEM_APPROVED,

+ 'topic_first_post_id' => 1,

+ 'topic_last_post_id' => 3,

+ 'topic_posts_approved' => 2,

+ 'topic_posts_unapproved' => 0,

+ 'topic_posts_softdeleted' => 0,

+ 'topic_delete_reason' => '',

+ ),

+ ),

+ array(

+ array('forum_posts_approved' => 2, 'forum_posts_unapproved' => 0, 'forum_posts_softdeleted' => 0, 'forum_topics_approved' => 1, 'forum_topics_unapproved' => 0, 'forum_topics_softdeleted' => 0, 'forum_last_post_id' => 3),

+ ),

+ ),

+ array(

+ 1, 1, 1,

+ array_merge($info_data, array(

+ 'post_time' => 1,

+ )),

+ false, 'harddelete',

+ array(

+ //array('post_id' => 1, 'post_visibility' => ITEM_APPROVED, 'post_delete_reason' => ''),

+ array('post_id' => 2, 'post_visibility' => ITEM_APPROVED, 'post_delete_reason' => ''),

+ array('post_id' => 3, 'post_visibility' => ITEM_APPROVED, 'post_delete_reason' => ''),

+ ),

+ array(

+ array(

+ 'topic_visibility' => ITEM_APPROVED,

+ 'topic_first_post_id' => 2,

+ 'topic_last_post_id' => 3,

+ 'topic_posts_approved' => 2,

+ 'topic_posts_unapproved' => 0,

+ 'topic_posts_softdeleted' => 0,

+ 'topic_delete_reason' => '',

+ ),

+ ),

+ array(

+ array('forum_posts_approved' => 2, 'forum_posts_unapproved' => 0, 'forum_posts_softdeleted' => 0, 'forum_topics_approved' => 1, 'forum_topics_unapproved' => 0, 'forum_topics_softdeleted' => 0, 'forum_last_post_id' => 3),

+ ),

+ ),

+ array(

+ 1, 1, 3,

+ array_merge($info_data, array(

+ 'post_time' => 3,

+ )),

+ false, 'harddelete',

+ array(

+ array('post_id' => 1, 'post_visibility' => ITEM_APPROVED, 'post_delete_reason' => ''),

+ array('post_id' => 2, 'post_visibility' => ITEM_APPROVED, 'post_delete_reason' => ''),

+ //array('post_id' => 3, 'post_visibility' => ITEM_APPROVED, 'post_delete_reason' => ''),

+ ),

+ array(

+ array(

+ 'topic_visibility' => ITEM_APPROVED,

+ 'topic_first_post_id' => 1,

+ 'topic_last_post_id' => 2,

+ 'topic_posts_approved' => 2,

+ 'topic_posts_unapproved' => 0,

+ 'topic_posts_softdeleted' => 0,

+ 'topic_delete_reason' => '',

+ ),

+ ),

+ array(

+ array('forum_posts_approved' => 2, 'forum_posts_unapproved' => 0, 'forum_posts_softdeleted' => 0, 'forum_topics_approved' => 1, 'forum_topics_unapproved' => 0, 'forum_topics_softdeleted' => 0, 'forum_last_post_id' => 2),

+ ),

+ ),

+ array(

+ 1, 1, 2,

+ array_merge($info_data, array(

+ 'post_time' => 2,

+ )),

+ true, 'soft delete',

+ array(

+ array('post_id' => 1, 'post_visibility' => ITEM_APPROVED, 'post_delete_reason' => ''),

+ array('post_id' => 2, 'post_visibility' => ITEM_DELETED, 'post_delete_reason' => 'soft delete'),

+ array('post_id' => 3, 'post_visibility' => ITEM_APPROVED, 'post_delete_reason' => ''),

+ ),

+ array(

+ array(

+ 'topic_visibility' => ITEM_APPROVED,

+ 'topic_first_post_id' => 1,

+ 'topic_last_post_id' => 3,

+ 'topic_posts_approved' => 2,

+ 'topic_posts_unapproved' => 0,

+ 'topic_posts_softdeleted' => 1,

+ 'topic_delete_reason' => '',

+ ),

+ ),

+ array(

+ array('forum_posts_approved' => 2, 'forum_posts_unapproved' => 0, 'forum_posts_softdeleted' => 1, 'forum_topics_approved' => 1, 'forum_topics_unapproved' => 0, 'forum_topics_softdeleted' => 0, 'forum_last_post_id' => 3),

+ ),

+ ),

+ array(

+ 1, 1, 1,

+ array_merge($info_data, array(

+ 'post_time' => 1,

+ )),

+ true, 'soft delete',

+ array(

+ array('post_id' => 1, 'post_visibility' => ITEM_DELETED, 'post_delete_reason' => 'soft delete'),

+ array('post_id' => 2, 'post_visibility' => ITEM_APPROVED, 'post_delete_reason' => ''),

+ array('post_id' => 3, 'post_visibility' => ITEM_APPROVED, 'post_delete_reason' => ''),

+ ),

+ array(

+ array(

+ 'topic_visibility' => ITEM_APPROVED,

+ 'topic_first_post_id' => 2,

+ 'topic_last_post_id' => 3,

+ 'topic_posts_approved' => 2,

+ 'topic_posts_unapproved' => 0,

+ 'topic_posts_softdeleted' => 1,

+ 'topic_delete_reason' => '',

+ ),

+ ),

+ array(

+ array('forum_posts_approved' => 2, 'forum_posts_unapproved' => 0, 'forum_posts_softdeleted' => 1, 'forum_topics_approved' => 1, 'forum_topics_unapproved' => 0, 'forum_topics_softdeleted' => 0, 'forum_last_post_id' => 3),

+ ),

+ ),

+ array(

+ 1, 1, 3,

+ array_merge($info_data, array(

+ 'post_time' => 3,

+ )),

+ true, 'soft delete',

+ array(

+ array('post_id' => 1, 'post_visibility' => ITEM_APPROVED, 'post_delete_reason' => ''),

+ array('post_id' => 2, 'post_visibility' => ITEM_APPROVED, 'post_delete_reason' => ''),

+ array('post_id' => 3, 'post_visibility' => ITEM_DELETED, 'post_delete_reason' => 'soft delete'),

+ ),

+ array(

+ array(

+ 'topic_visibility' => ITEM_APPROVED,

+ 'topic_first_post_id' => 1,

+ 'topic_last_post_id' => 2,

+ 'topic_posts_approved' => 2,

+ 'topic_posts_unapproved' => 0,

+ 'topic_posts_softdeleted' => 1,

+ 'topic_delete_reason' => '',

+ ),

+ ),

+ array(

+ array('forum_posts_approved' => 2, 'forum_posts_unapproved' => 0, 'forum_posts_softdeleted' => 1, 'forum_topics_approved' => 1, 'forum_topics_unapproved' => 0, 'forum_topics_softdeleted' => 0, 'forum_last_post_id' => 2),

+ ),

+ ),

+

+ array(

+ 2, 2, 4,

+ array(

+ 'topic_first_post_id' => 4,

+ 'topic_last_post_id' => 4,

+ 'topic_posts_approved' => 1,

+ 'topic_posts_unapproved' => 0,

+ 'topic_posts_softdeleted' => 0,

+ 'topic_visibility' => ITEM_APPROVED,

+ 'post_time' => 4,

+ 'post_visibility' => ITEM_APPROVED,

+ 'post_postcount' => true,

+ 'poster_id' => 1,

+ 'post_reported' => false,

+ ),

+ false, 'harddelete',

+ array(

+ ),

+ array(

+ ),

+ array(

+ array('forum_posts_approved' => 0, 'forum_posts_unapproved' => 0, 'forum_posts_softdeleted' => 0, 'forum_topics_approved' => 0, 'forum_topics_unapproved' => 0, 'forum_topics_softdeleted' => 0, 'forum_last_post_id' => 0),

+ ),

+ ),

+

+ array(

+ 2, 2, 4,

+ array(

+ 'topic_first_post_id' => 4,

+ 'topic_last_post_id' => 4,

+ 'topic_posts_approved' => 1,

+ 'topic_posts_unapproved' => 0,

+ 'topic_posts_softdeleted' => 0,

+ 'topic_visibility' => ITEM_APPROVED,

+ 'post_time' => 4,

+ 'post_visibility' => ITEM_APPROVED,

+ 'post_postcount' => true,

+ 'poster_id' => 1,

+ 'post_reported' => false,

+ ),

+ true, 'soft delete',

+ array(

+ array('post_id' => 4, 'post_visibility' => ITEM_DELETED, 'post_delete_reason' => ''),

+ ),

+ array(

+ array(

+ 'topic_visibility' => ITEM_DELETED,

+ 'topic_first_post_id' => 4,

+ 'topic_last_post_id' => 4,

+ 'topic_posts_approved' => 0,

+ 'topic_posts_unapproved' => 0,

+ 'topic_posts_softdeleted' => 1,

+ 'topic_delete_reason' => 'soft delete',

+ ),

+ ),

+ array(

+ array('forum_posts_approved' => 0, 'forum_posts_unapproved' => 0, 'forum_posts_softdeleted' => 1, 'forum_topics_approved' => 0, 'forum_topics_unapproved' => 0, 'forum_topics_softdeleted' => 1, 'forum_last_post_id' => 0),

+ ),

+ ),

+ );

+ }

+

+ /**

+ * @dataProvider delete_post_data

+ */

+ public function test_delete_post($forum_id, $topic_id, $post_id, $data, $is_soft, $reason, $expected_posts, $expected_topic, $expected_forum)

+ {

+ global $auth, $cache, $config, $db, $phpbb_container, $phpbb_root_path, $phpEx;

+

+ $config['search_type'] = 'phpbb_mock_search';

+ $cache = new phpbb_mock_cache;

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

+ set_config_count(null, null, null, new phpbb_config(array('num_posts' => 3, 'num_topics' => 1)));

+

+ // Create auth mock

+ $auth = $this->getMock('phpbb_auth');

+ $auth->expects($this->any())

+ ->method('acl_get')

+ ->with($this->stringContains('_'), $this->anything())

+ ->will($this->returnValueMap(array(

+ array('m_approve', 1, true),

+ )));

+ $user = $this->getMock('phpbb_user');

+

+ $phpbb_container = new phpbb_mock_container_builder();

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

+ $phpbb_container->set('content.visibility', new phpbb_content_visibility($auth, $db, $user, $phpbb_root_path, $phpEx, FORUMS_TABLE, POSTS_TABLE, TOPICS_TABLE, USERS_TABLE));

+

+ delete_post($forum_id, $topic_id, $post_id, $data, $is_soft, $reason);

+

+ $result = $db->sql_query('SELECT post_id, post_visibility, post_delete_reason

+ FROM phpbb_posts

+ WHERE topic_id = ' . $topic_id . '

+ ORDER BY post_id ASC');

+

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

+ $db->sql_freeresult($result);

+

+ $result = $db->sql_query('SELECT topic_visibility, topic_first_post_id, topic_last_post_id, topic_posts_approved, topic_posts_unapproved, topic_posts_softdeleted, topic_delete_reason

+ FROM phpbb_topics

+ WHERE topic_id = ' . $topic_id);

+

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

+ $db->sql_freeresult($result);

+

+ $result = $db->sql_query('SELECT forum_posts_approved, forum_posts_unapproved, forum_posts_softdeleted, forum_topics_approved, forum_topics_unapproved, forum_topics_softdeleted, forum_last_post_id

+ FROM phpbb_forums

+ WHERE forum_id = ' . $forum_id);

+

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

+ $db->sql_freeresult($result);

+ }

+}

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

+<dataset>

+ <table name="phpbb_forums">

+ <column>forum_id</column>

+ <column>forum_posts_approved</column>

+ <column>forum_posts_unapproved</column>

+ <column>forum_posts_softdeleted</column>

+ <column>forum_topics_approved</column>

+ <column>forum_topics_unapproved</column>

+ <column>forum_topics_softdeleted</column>

+ <column>forum_last_post_id</column>

+ <column>forum_parents</column>

+ <column>forum_desc</column>

+ <column>forum_rules</column>

+

+ <row>

+ <value>1</value>

+ <value>3</value>

+ <value>0</value>

+ <value>0</value>

+ <value>1</value>

+ <value>0</value>

+ <value>0</value>

+ <value>3</value>

+ <value></value>

+ <value></value>

+ <value></value>

+ </row>

+ <row>

+ <value>2</value>

+ <value>1</value>

+ <value>0</value>

+ <value>0</value>

+ <value>1</value>

+ <value>0</value>

+ <value>0</value>

+ <value>4</value>

+ <value></value>

+ <value></value>

+ <value></value>

+ </row>

+ </table>

+ <table name="phpbb_topics">

+ <column>topic_id</column>

+ <column>forum_id</column>

+ <column>topic_visibility</column>

+ <column>topic_title</column>

+ <column>topic_first_post_id</column>

+ <column>topic_last_post_id</column>

+ <column>topic_delete_user</column>

+ <column>topic_delete_time</column>

+ <column>topic_delete_reason</column>

+ <column>topic_posts_approved</column>

+ <column>topic_posts_unapproved</column>

+ <column>topic_posts_softdeleted</column>

+

+ <row>

+ <value>1</value>

+ <value>1</value>

+ <value>1</value>

+ <value>Approved</value>

+ <value>1</value>

+ <value>3</value>

+ <value>0</value>

+ <value>0</value>

+ <value></value>

+ <value>3</value>

+ <value>0</value>

+ <value>0</value>

+ </row>

+ <row>

+ <value>2</value>

+ <value>2</value>

+ <value>1</value>

+ <value>Approved</value>

+ <value>4</value>

+ <value>4</value>

+ <value>0</value>

+ <value>0</value>

+ <value></value>

+ <value>1</value>

+ <value>0</value>

+ <value>0</value>

+ </row>

+ </table>

+ <table name="phpbb_posts">

+ <column>post_id</column>

+ <column>poster_id</column>

+ <column>topic_id</column>

+ <column>forum_id</column>

+ <column>post_visibility</column>

+ <column>post_time</column>

+ <column>post_text</column>

+ <column>post_delete_user</column>

+ <column>post_delete_time</column>

+ <column>post_delete_reason</column>

+ <row>

+ <value>1</value>

+ <value>1</value>

+ <value>1</value>

+ <value>1</value>

+ <value>1</value>

+ <value>1</value>

+ <value>Approved</value>

+ <value>0</value>

+ <value>0</value>

+ <value></value>

+ </row>

+ <row>

+ <value>2</value>

+ <value>1</value>

+ <value>1</value>

+ <value>1</value>

+ <value>1</value>

+ <value>2</value>

+ <value>Approved</value>

+ <value>0</value>

+ <value>0</value>

+ <value></value>

+ </row>

+ <row>

+ <value>3</value>

+ <value>1</value>

+ <value>1</value>

+ <value>1</value>

+ <value>1</value>

+ <value>3</value>

+ <value>Approved</value>

+ <value>0</value>

+ <value>0</value>

+ <value></value>

+ </row>

+

+ <row>

+ <value>4</value>

+ <value>1</value>

+ <value>2</value>

+ <value>2</value>

+ <value>1</value>

+ <value>4</value>

+ <value>Approved</value>

+ <value>0</value>

+ <value>0</value>

+ <value></value>

+ </row>

+ </table>

+ <table name="phpbb_users">

+ <column>user_id</column>

+ <column>user_posts</column>

+ <column>username</column>

+ <column>username_clean</column>

+ <column>user_permissions</column>

+ <column>user_sig</column>

+ <column>user_occ</column>

+ <column>user_interests</column>

+ <row>

+ <value>1</value>

+ <value>4</value>

+ <value>user 1</value>

+ <value>user 1</value>

+ <value></value>

+ <value></value>

+ <value></value>

+ <value></value>

+ </row>

+ </table>

+</dataset>

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

+<dataset>

+ <table name="phpbb_topics">

+ <column>topic_id</column>

+ <column>forum_id</column>

+ <column>topic_visibility</column>

+ <column>topic_title</column>

+ <row>

+ <value>1</value>

+ <value>1</value>

+ <value>0</value>

+ <value>Unapproved</value>

+ </row>

+ <row>

+ <value>2</value>

+ <value>1</value>

+ <value>1</value>

+ <value>Approved</value>

+ </row>

+ <row>

+ <value>3</value>

+ <value>1</value>

+ <value>2</value>

+ <value>Softdeleted</value>

+ </row>

+ <row>

+ <value>4</value>

+ <value>2</value>

+ <value>0</value>

+ <value>Unapproved</value>

+ </row>

+ <row>

+ <value>5</value>

+ <value>2</value>

+ <value>1</value>

+ <value>Approved</value>

+ </row>

+ <row>

+ <value>6</value>

+ <value>2</value>

+ <value>2</value>

+ <value>Softdeleted</value>

+ </row>

+ <row>

+ <value>7</value>

+ <value>3</value>

+ <value>0</value>

+ <value>Unapproved</value>

+ </row>

+ <row>

+ <value>8</value>

+ <value>3</value>

+ <value>1</value>

+ <value>Approved</value>

+ </row>

+ <row>

+ <value>9</value>

+ <value>3</value>

+ <value>2</value>

+ <value>Softdeleted</value>

+ </row>

+ </table>

+ <table name="phpbb_posts">

+ <column>post_id</column>

+ <column>topic_id</column>

+ <column>forum_id</column>

+ <column>post_visibility</column>

+ <column>post_text</column>

+ <row>

+ <value>1</value>

+ <value>1</value>

+ <value>1</value>

+ <value>0</value>

+ <value>Unapproved</value>

+ </row>

+ <row>

+ <value>2</value>

+ <value>2</value>

+ <value>1</value>

+ <value>1</value>

+ <value>Approved</value>

+ </row>

+ <row>

+ <value>3</value>

+ <value>3</value>

+ <value>1</value>

+ <value>2</value>

+ <value>Softdeleted</value>

+ </row>

+ <row>

+ <value>4</value>

+ <value>4</value>

+ <value>2</value>

+ <value>0</value>

+ <value>Unapproved</value>

+ </row>

+ <row>

+ <value>5</value>

+ <value>5</value>

+ <value>2</value>

+ <value>1</value>

+ <value>Approved</value>

+ </row>

+ <row>

+ <value>6</value>

+ <value>6</value>

+ <value>2</value>

+ <value>2</value>

+ <value>Softdeleted</value>

+ </row>

+ <row>

+ <value>7</value>

+ <value>7</value>

+ <value>3</value>

+ <value>0</value>

+ <value>Unapproved</value>

+ </row>

+ <row>

+ <value>8</value>

+ <value>8</value>

+ <value>3</value>

+ <value>1</value>

+ <value>Approved</value>

+ </row>

+ <row>

+ <value>9</value>

+ <value>9</value>

+ <value>3</value>

+ <value>2</value>

+ <value>Softdeleted</value>

+ </row>

+ </table>

+</dataset>

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

+<dataset>

+ <table name="phpbb_topics">

+ <column>topic_id</column>

+ <column>forum_id</column>

+ <column>topic_visibility</column>

+ <column>topic_title</column>

+ <row>

+ <value>1</value>

+ <value>1</value>

+ <value>0</value>

+ <value>Unapproved</value>

+ </row>

+ <row>

+ <value>2</value>

+ <value>1</value>

+ <value>1</value>

+ <value>Approved</value>

+ </row>

+ <row>

+ <value>3</value>

+ <value>1</value>

+ <value>2</value>

+ <value>Softdeleted</value>

+ </row>

+ </table>

+ <table name="phpbb_posts">

+ <column>post_id</column>

+ <column>topic_id</column>

+ <column>forum_id</column>

+ <column>post_visibility</column>

+ <column>post_text</column>

+ <row>

+ <value>1</value>

+ <value>1</value>

+ <value>1</value>

+ <value>0</value>

+ <value>Unapproved</value>

+ </row>

+ <row>

+ <value>2</value>

+ <value>2</value>

+ <value>1</value>

+ <value>1</value>

+ <value>Approved</value>

+ </row>

+ <row>

+ <value>3</value>

+ <value>3</value>

+ <value>1</value>

+ <value>2</value>

+ <value>Softdeleted</value>

+ </row>

+ </table>

+</dataset>

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

+<dataset>

+ <table name="phpbb_topics">

+ <column>topic_id</column>

+ <column>forum_id</column>

+ <column>topic_visibility</column>

+ <column>topic_title</column>

+ <column>topic_first_post_id</column>

+ <column>topic_last_post_id</column>

+ <column>topic_posts_approved</column>

+ <column>topic_posts_softdeleted</column>

+ <column>topic_posts_unapproved</column>

+ <row>

+ <value>1</value>

+ <value>1</value>

+ <value>1</value>

+ <value>Approved</value>

+ <value>2</value>

+ <value>2</value>

+ <value>1</value>

+ <value>1</value>

+ <value>1</value>

+ </row>

+

+ <row>

+ <value>2</value>

+ <value>1</value>

+ <value>1</value>

+ <value>2 Approved posts</value>

+ <value>5</value>

+ <value>6</value>

+ <value>1</value>

+ <value>1</value>

+ <value>1</value>

+ </row>

+

+ <row>

+ <value>3</value>

+ <value>1</value>

+ <value>1</value>

+ <value>Only 1 Approved posts</value>

+ <value>8</value>

+ <value>8</value>

+ <value>1</value>

+ <value>0</value>

+ <value>0</value>

+ </row>

+ </table>

+ <table name="phpbb_posts">

+ <column>post_id</column>

+ <column>poster_id</column>

+ <column>topic_id</column>

+ <column>forum_id</column>

+ <column>post_visibility</column>

+ <column>post_text</column>

+ <row>

+ <value>1</value>

+ <value>1</value>

+ <value>1</value>

+ <value>1</value>

+ <value>0</value>

+ <value>Unapproved</value>

+ </row>

+ <row>

+ <value>2</value>

+ <value>2</value>

+ <value>1</value>

+ <value>1</value>

+ <value>1</value>

+ <value>Approved</value>

+ </row>

+ <row>

+ <value>3</value>

+ <value>3</value>

+ <value>1</value>

+ <value>1</value>

+ <value>2</value>

+ <value>Softdeleted</value>

+ </row>

+

+ <row>

+ <value>4</value>

+ <value>1</value>

+ <value>2</value>

+ <value>1</value>

+ <value>0</value>

+ <value>Unapproved</value>

+ </row>

+ <row>

+ <value>5</value>

+ <value>2</value>

+ <value>2</value>

+ <value>1</value>

+ <value>1</value>

+ <value>Approved</value>

+ </row>

+ <row>

+ <value>6</value>

+ <value>2</value>

+ <value>2</value>

+ <value>1</value>

+ <value>1</value>

+ <value>Approved 2</value>

+ </row>

+ <row>

+ <value>7</value>

+ <value>3</value>

+ <value>2</value>

+ <value>1</value>

+ <value>2</value>

+ <value>Softdeleted</value>

+ </row>

+ <row>

+ <value>8</value>

+ <value>1</value>

+ <value>3</value>

+ <value>1</value>

+ <value>1</value>

+ <value>Approved</value>

+ </row>

+ </table>

+ <table name="phpbb_users">

+ <column>user_id</column>

+ <column>user_posts</column>

+ <column>username</column>

+ <column>username_clean</column>

+ <column>user_permissions</column>

+ <column>user_sig</column>

+ <column>user_occ</column>

+ <column>user_interests</column>

+ <row>

+ <value>1</value>

+ <value>1</value>

+ <value>user 1</value>

+ <value>user 1</value>

+ <value></value>

+ <value></value>

+ <value></value>

+ <value></value>

+ </row>

+ <row>

+ <value>2</value>

+ <value>1</value>

+ <value>user 2</value>

+ <value>user 2</value>

+ <value></value>

+ <value></value>

+ <value></value>

+ <value></value>

+ </row>

+ <row>

+ <value>3</value>

+ <value>1</value>

+ <value>user 3</value>

+ <value>user 3</value>

+ <value></value>

+ <value></value>

+ <value></value>

+ <value></value>

+ </row>

+ </table>

+</dataset>

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

+<dataset>

+ <table name="phpbb_topics">

+ <column>topic_id</column>

+ <column>forum_id</column>

+ <column>topic_visibility</column>

+ <column>topic_title</column>

+ <column>topic_first_post_id</column>

+ <column>topic_last_post_id</column>

+ <column>topic_delete_user</column>

+ <column>topic_delete_time</column>

+ <column>topic_delete_reason</column>

+

+ <row>

+ <value>1</value>

+ <value>1</value>

+ <value>1</value>

+ <value>Approved</value>

+ <value>1</value>

+ <value>1</value>

+ <value>0</value>

+ <value>0</value>

+ <value></value>

+ </row>

+

+ <row>

+ <value>2</value>

+ <value>1</value>

+ <value>2</value>

+ <value>Soft deleted</value>

+ <value>4</value>

+ <value>5</value>

+ <value>2</value>

+ <value>123</value>

+ <value></value>

+ </row>

+ </table>

+ <table name="phpbb_posts">

+ <column>post_id</column>

+ <column>poster_id</column>

+ <column>topic_id</column>

+ <column>forum_id</column>

+ <column>post_visibility</column>

+ <column>post_text</column>

+ <column>post_delete_user</column>

+ <column>post_delete_time</column>

+ <column>post_delete_reason</column>

+ <row>

+ <value>1</value>

+ <value>1</value>

+ <value>1</value>

+ <value>1</value>

+ <value>1</value>

+ <value>Approved</value>

+ <value>2</value>

+ <value>0</value>

+ <value></value>

+ </row>

+ <row>

+ <value>2</value>

+ <value>1</value>

+ <value>1</value>

+ <value>1</value>

+ <value>2</value>

+ <value>Soft deleted</value>

+ <value>2</value>

+ <value>123</value>

+ <value>manually</value>

+ </row>

+ <row>

+ <value>3</value>

+ <value>1</value>

+ <value>1</value>

+ <value>1</value>

+ <value>0</value>

+ <value>Unapproved</value>

+ <value>0</value>

+ <value>0</value>

+ <value></value>

+ </row>

+

+ <row>

+ <value>4</value>

+ <value>1</value>

+ <value>2</value>

+ <value>1</value>

+ <value>2</value>

+ <value>Soft deleted by topic soft delete</value>

+ <value>2</value>

+ <value>123</value>

+ <value></value>

+ </row>

+ <row>

+ <value>5</value>

+ <value>1</value>

+ <value>2</value>

+ <value>1</value>

+ <value>2</value>

+ <value>Soft deleted before the topic was soft deleted</value>

+ <value>2</value>

+ <value>120</value>

+ <value>manually</value>

+ </row>

+ <row>

+ <value>6</value>

+ <value>1</value>

+ <value>2</value>

+ <value>1</value>

+ <value>0</value>

+ <value>Unapproved before the topic was soft deleted</value>

+ <value>0</value>

+ <value>0</value>

+ <value></value>

+ </row>

+ </table>

+ <table name="phpbb_users">

+ <column>user_id</column>

+ <column>user_posts</column>

+ <column>username</column>

+ <column>username_clean</column>

+ <column>user_permissions</column>

+ <column>user_sig</column>

+ <column>user_occ</column>

+ <column>user_interests</column>

+ <row>

+ <value>1</value>

+ <value>6</value>

+ <value>user 1</value>

+ <value>user 1</value>

+ <value></value>

+ <value></value>

+ <value></value>

+ <value></value>

+ </row>

+ </table>

+</dataset>

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+class phpbb_content_visibility_get_forums_visibility_sql_test extends phpbb_database_test_case

+{

+ public function getDataSet()

+ {

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

+ }

+

+ public function get_forums_visibility_sql_data()

+ {

+ return array(

+ array(

+ 'phpbb_topics',

+ 'topic', array(1, 2, 3), '',

+ array(

+ array('m_approve', true, array(1 => true, 2 => true, 3 => true)),

+ ),

+ array(

+ array('topic_id' => 1),

+ array('topic_id' => 2),

+ array('topic_id' => 3),

+ array('topic_id' => 4),

+ array('topic_id' => 5),

+ array('topic_id' => 6),

+ array('topic_id' => 7),

+ array('topic_id' => 8),

+ array('topic_id' => 9),

+ ),

+ ),

+ array(

+ 'phpbb_topics',

+ 'topic', array(1, 2), '',

+ array(

+ array('m_approve', true, array(1 => true, 2 => true, 3 => true)),

+ ),

+ array(

+ array('topic_id' => 1),

+ array('topic_id' => 2),

+ array('topic_id' => 3),

+ array('topic_id' => 4),

+ array('topic_id' => 5),

+ array('topic_id' => 6),

+ ),

+ ),

+ array(

+ 'phpbb_topics',

+ 'topic', array(1, 2, 3), '',

+ array(

+ array('m_approve', true, array(2 => true)),

+ ),

+ array(

+ array('topic_id' => 2),

+ array('topic_id' => 4),

+ array('topic_id' => 5),

+ array('topic_id' => 6),

+ array('topic_id' => 8),

+ ),

+ ),

+ array(

+ 'phpbb_posts',

+ 'post', array(1, 2, 3), '',

+ array(

+ array('m_approve', true, array(1 => true, 2 => true, 3 => true)),

+ ),

+ array(

+ array('post_id' => 1),

+ array('post_id' => 2),

+ array('post_id' => 3),

+ array('post_id' => 4),

+ array('post_id' => 5),

+ array('post_id' => 6),

+ array('post_id' => 7),

+ array('post_id' => 8),

+ array('post_id' => 9),

+ ),

+ ),

+ array(

+ 'phpbb_posts',

+ 'post', array(1, 2), '',

+ array(

+ array('m_approve', true, array(1 => true, 2 => true, 3 => true)),

+ ),

+ array(

+ array('post_id' => 1),

+ array('post_id' => 2),

+ array('post_id' => 3),

+ array('post_id' => 4),

+ array('post_id' => 5),

+ array('post_id' => 6),

+ ),

+ ),

+ array(

+ 'phpbb_posts',

+ 'post', array(1, 2, 3), '',

+ array(

+ array('m_approve', true, array(2 => true)),

+ ),

+ array(

+ array('post_id' => 2),

+ array('post_id' => 4),

+ array('post_id' => 5),

+ array('post_id' => 6),

+ array('post_id' => 8),

+ ),

+ ),

+ );

+ }

+

+ /**

+ * @dataProvider get_forums_visibility_sql_data

+ */

+ public function test_get_forums_visibility_sql($table, $mode, $forum_ids, $table_alias, $permissions, $expected)

+ {

+ global $cache, $db, $auth, $phpbb_root_path, $phpEx;

+

+ $cache = new phpbb_mock_cache;

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

+

+ // Create auth mock

+ $auth = $this->getMock('phpbb_auth');

+ $auth->expects($this->any())

+ ->method('acl_getf')

+ ->with($this->stringContains('_'), $this->anything())

+ ->will($this->returnValueMap($permissions));

+ $user = $this->getMock('phpbb_user');

+ $content_visibility = new phpbb_content_visibility($auth, $db, $user, $phpbb_root_path, $phpEx, FORUMS_TABLE, POSTS_TABLE, TOPICS_TABLE, USERS_TABLE);

+

+ $result = $db->sql_query('SELECT ' . $mode . '_id

+ FROM ' . $table . '

+ WHERE ' . $content_visibility->get_forums_visibility_sql($mode, $forum_ids, $table_alias) . '

+ ORDER BY ' . $mode . '_id ASC');

+

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

+ }

+}

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+class phpbb_content_visibility_get_global_visibility_sql_test extends phpbb_database_test_case

+{

+ public function getDataSet()

+ {

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

+ }

+

+ public function get_global_visibility_sql_data()

+ {

+ return array(

+ array(

+ 'phpbb_topics',

+ 'topic', array(), '',

+ array(

+ array('m_approve', true, array(1 => true, 2 => true, 3 => true)),

+ ),

+ array(

+ array('topic_id' => 1),

+ array('topic_id' => 2),

+ array('topic_id' => 3),

+ array('topic_id' => 4),

+ array('topic_id' => 5),

+ array('topic_id' => 6),

+ array('topic_id' => 7),

+ array('topic_id' => 8),

+ array('topic_id' => 9),

+ ),

+ ),

+ array(

+ 'phpbb_topics',

+ 'topic', array(3), '',

+ array(

+ array('m_approve', true, array(1 => true, 2 => true, 3 => true)),

+ ),

+ array(

+ array('topic_id' => 1),

+ array('topic_id' => 2),

+ array('topic_id' => 3),

+ array('topic_id' => 4),

+ array('topic_id' => 5),

+ array('topic_id' => 6),

+ ),

+ ),

+ array(

+ 'phpbb_topics',

+ 'topic', array(), '',

+ array(

+ array('m_approve', true, array(2 => true)),

+ ),

+ array(

+ array('topic_id' => 2),

+ array('topic_id' => 4),

+ array('topic_id' => 5),

+ array('topic_id' => 6),

+ array('topic_id' => 8),

+ ),

+ ),

+ array(

+ 'phpbb_posts',

+ 'post', array(), '',

+ array(

+ array('m_approve', true, array(1 => true, 2 => true, 3 => true)),

+ ),

+ array(

+ array('post_id' => 1),

+ array('post_id' => 2),

+ array('post_id' => 3),

+ array('post_id' => 4),

+ array('post_id' => 5),

+ array('post_id' => 6),

+ array('post_id' => 7),

+ array('post_id' => 8),

+ array('post_id' => 9),

+ ),

+ ),

+ array(

+ 'phpbb_posts',

+ 'post', array(3), '',

+ array(

+ array('m_approve', true, array(1 => true, 2 => true, 3 => true)),

+ ),

+ array(

+ array('post_id' => 1),

+ array('post_id' => 2),

+ array('post_id' => 3),

+ array('post_id' => 4),

+ array('post_id' => 5),

+ array('post_id' => 6),

+ ),

+ ),

+ array(

+ 'phpbb_posts',

+ 'post', array(), '',

+ array(

+ array('m_approve', true, array(2 => true)),

+ ),

+ array(

+ array('post_id' => 2),

+ array('post_id' => 4),

+ array('post_id' => 5),

+ array('post_id' => 6),

+ array('post_id' => 8),

+ ),

+ ),

+ );

+ }

+

+ /**

+ * @dataProvider get_global_visibility_sql_data

+ */

+ public function test_get_global_visibility_sql($table, $mode, $forum_ids, $table_alias, $permissions, $expected)

+ {

+ global $cache, $db, $auth, $phpbb_root_path, $phpEx;

+

+ $cache = new phpbb_mock_cache;

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

+

+ // Create auth mock

+ $auth = $this->getMock('phpbb_auth');

+ $auth->expects($this->any())

+ ->method('acl_getf')

+ ->with($this->stringContains('_'), $this->anything())

+ ->will($this->returnValueMap($permissions));

+ $user = $this->getMock('phpbb_user');

+ $content_visibility = new phpbb_content_visibility($auth, $db, $user, $phpbb_root_path, $phpEx, FORUMS_TABLE, POSTS_TABLE, TOPICS_TABLE, USERS_TABLE);

+

+ $result = $db->sql_query('SELECT ' . $mode . '_id

+ FROM ' . $table . '

+ WHERE ' . $content_visibility->get_global_visibility_sql($mode, $forum_ids, $table_alias) . '

+ ORDER BY ' . $mode . '_id ASC');

+

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

+ }

+}

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+class phpbb_content_visibility_get_visibility_sql_test extends phpbb_database_test_case

+{

+ public function getDataSet()

+ {

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

+ }

+

+ public function get_visibility_sql_data()

+ {

+ return array(

+ array(

+ 'phpbb_posts',

+ 'post', 1, '',

+ array(

+ array('m_approve', 1, true),

+ ),

+ array(

+ array('post_id' => 1),

+ array('post_id' => 2),

+ array('post_id' => 3),

+ ),

+ ),

+ array(

+ 'phpbb_posts',

+ 'post', 1, '',

+ array(

+ ),

+ array(

+ array('post_id' => 2),

+ ),

+ ),

+ array(

+ 'phpbb_topics',

+ 'topic', 1, '',

+ array(

+ array('m_approve', 1, true),

+ ),

+ array(

+ array('topic_id' => 1),

+ array('topic_id' => 2),

+ array('topic_id' => 3),

+ ),

+ ),

+ array(

+ 'phpbb_topics',

+ 'topic', 1, '',

+ array(),

+ array(

+ array('topic_id' => 2),

+ ),

+ ),

+ );

+ }

+

+ /**

+ * @dataProvider get_visibility_sql_data

+ */

+ public function test_get_visibility_sql($table, $mode, $forum_id, $table_alias, $permissions, $expected)

+ {

+ global $cache, $db, $auth, $phpbb_root_path, $phpEx;

+

+ $cache = new phpbb_mock_cache;

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

+

+ // Create auth mock

+ $auth = $this->getMock('phpbb_auth');

+ $auth->expects($this->any())

+ ->method('acl_get')

+ ->with($this->stringContains('_'), $this->anything())

+ ->will($this->returnValueMap($permissions));

+ $user = $this->getMock('phpbb_user');

+ $content_visibility = new phpbb_content_visibility($auth, $db, $user, $phpbb_root_path, $phpEx, FORUMS_TABLE, POSTS_TABLE, TOPICS_TABLE, USERS_TABLE);

+

+ $result = $db->sql_query('SELECT ' . $mode . '_id

+ FROM ' . $table . '

+ WHERE ' . $content_visibility->get_visibility_sql($mode, $forum_id, $table_alias) . '

+ ORDER BY ' . $mode . '_id ASC');

+

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

+ }

+}

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2012 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_admin.php';

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

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

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

+

+class phpbb_content_visibility_set_post_visibility_test extends phpbb_database_test_case

+{

+ public function getDataSet()

+ {

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

+ }

+

+ public function set_post_visibility_data()

+ {

+ return array(

+ array(

+ ITEM_APPROVED,

+ 1, 1, 1,

+ 2, time(), 'approve',

+ true, false,

+ array(

+ array('post_id' => 1, 'post_visibility' => 1, 'post_delete_reason' => 'approve'),

+ array('post_id' => 2, 'post_visibility' => 1, 'post_delete_reason' => ''),

+ array('post_id' => 3, 'post_visibility' => 2, 'post_delete_reason' => ''),

+ ),

+ array(

+ array('topic_visibility' => 1, 'topic_first_post_id' => 1, 'topic_last_post_id' => 2),

+ ),

+ ),

+ array(

+ ITEM_APPROVED,

+ 3, 1, 1,

+ 2, time(), 'approve',

+ false, true,

+ array(

+ array('post_id' => 1, 'post_visibility' => 0, 'post_delete_reason' => ''),

+ array('post_id' => 2, 'post_visibility' => 1, 'post_delete_reason' => ''),

+ array('post_id' => 3, 'post_visibility' => 1, 'post_delete_reason' => 'approve'),

+ ),

+ array(

+ array('topic_visibility' => 1, 'topic_first_post_id' => 2, 'topic_last_post_id' => 3),

+ ),

+ ),

+ array(

+ ITEM_DELETED,

+ 2, 1, 1,

+ 2, time(), 'deleted',

+ true, true,

+ array(

+ array('post_id' => 1, 'post_visibility' => 0, 'post_delete_reason' => ''),

+ array('post_id' => 2, 'post_visibility' => 2, 'post_delete_reason' => 'deleted'),

+ array('post_id' => 3, 'post_visibility' => 2, 'post_delete_reason' => ''),

+ ),

+ array(

+ array('topic_visibility' => 2, 'topic_first_post_id' => 1, 'topic_last_post_id' => 3),

+ ),

+ ),

+ array(

+ ITEM_DELETED,

+ 5, 2, 1,

+ 2, time(), 'deleted',

+ true, false,

+ array(

+ array('post_id' => 4, 'post_visibility' => 0, 'post_delete_reason' => ''),

+ array('post_id' => 5, 'post_visibility' => 2, 'post_delete_reason' => 'deleted'),

+ array('post_id' => 6, 'post_visibility' => 1, 'post_delete_reason' => ''),

+ array('post_id' => 7, 'post_visibility' => 2, 'post_delete_reason' => ''),

+ ),

+ array(

+ array('topic_visibility' => 1, 'topic_first_post_id' => 6, 'topic_last_post_id' => 6),

+ ),

+ ),

+ array(

+ ITEM_DELETED,

+ 6, 2, 1,

+ 2, time(), 'deleted',

+ false, true,

+ array(

+ array('post_id' => 4, 'post_visibility' => 0, 'post_delete_reason' => ''),

+ array('post_id' => 5, 'post_visibility' => 1, 'post_delete_reason' => ''),

+ array('post_id' => 6, 'post_visibility' => 2, 'post_delete_reason' => 'deleted'),

+ array('post_id' => 7, 'post_visibility' => 2, 'post_delete_reason' => ''),

+ ),

+ array(

+ array('topic_visibility' => 1, 'topic_first_post_id' => 5, 'topic_last_post_id' => 5),

+ ),

+ ),

+ array(

+ ITEM_DELETED,

+ 8, 3, 1,

+ 2, time(), 'deleted',

+ true, true,

+ array(

+ array('post_id' => 8, 'post_visibility' => 2, 'post_delete_reason' => 'deleted'),

+ ),

+ array(

+ array('topic_visibility' => 2, 'topic_first_post_id' => 8, 'topic_last_post_id' => 8),

+ ),

+ ),

+ );

+ }

+

+ /**

+ * @dataProvider set_post_visibility_data

+ */

+ public function test_set_post_visibility($visibility, $post_id, $topic_id, $forum_id, $user_id, $time, $reason, $is_starter, $is_latest, $expected, $expected_topic)

+ {

+ global $cache, $db, $auth, $phpbb_root_path, $phpEx;

+

+ $cache = new phpbb_mock_cache;

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

+ $auth = $this->getMock('phpbb_auth');

+ $user = $this->getMock('phpbb_user');

+ $content_visibility = new phpbb_content_visibility($auth, $db, $user, $phpbb_root_path, $phpEx, FORUMS_TABLE, POSTS_TABLE, TOPICS_TABLE, USERS_TABLE);

+

+ $content_visibility->set_post_visibility($visibility, $post_id, $topic_id, $forum_id, $user_id, $time, $reason, $is_starter, $is_latest);

+

+ $result = $db->sql_query('SELECT post_id, post_visibility, post_delete_reason

+ FROM phpbb_posts

+ WHERE topic_id = ' . $topic_id . '

+ ORDER BY post_id ASC');

+

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

+ $db->sql_freeresult($result);

+

+ $result = $db->sql_query('SELECT topic_visibility, topic_first_post_id, topic_last_post_id

+ FROM phpbb_topics

+ WHERE topic_id = ' . $topic_id);

+

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

+ $db->sql_freeresult($result);

+ }

+}

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2012 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_admin.php';

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

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

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

+

+class phpbb_content_visibility_set_topic_visibility_test extends phpbb_database_test_case

+{

+ public function getDataSet()

+ {

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

+ }

+

+ public function set_topic_visibility_data()

+ {

+ return array(

+ array(

+ ITEM_DELETED, 1, 1,

+ 2, time(), 'delete', false,

+ array(

+ array('post_id' => 1, 'post_visibility' => 2, 'post_delete_reason' => ''),

+ array('post_id' => 2, 'post_visibility' => 2, 'post_delete_reason' => 'manually'),

+ array('post_id' => 3, 'post_visibility' => 0, 'post_delete_reason' => ''),

+ ),

+ array(

+ array('topic_visibility' => 2, 'topic_first_post_id' => 1, 'topic_last_post_id' => 3, 'topic_delete_reason' => 'delete'),

+ ),

+ ),

+ array(

+ ITEM_DELETED, 1, 1,

+ 2, time(), 'delete-forced', true,

+ array(

+ array('post_id' => 1, 'post_visibility' => 2, 'post_delete_reason' => ''),

+ array('post_id' => 2, 'post_visibility' => 2, 'post_delete_reason' => ''),

+ array('post_id' => 3, 'post_visibility' => 2, 'post_delete_reason' => ''),

+ ),

+ array(

+ array('topic_visibility' => 2, 'topic_first_post_id' => 1, 'topic_last_post_id' => 3, 'topic_delete_reason' => 'delete-forced'),

+ ),

+ ),

+ array(

+ ITEM_APPROVED, 2, 1,

+ 2, time(), 'approved', false,

+ array(

+ array('post_id' => 4, 'post_visibility' => 1, 'post_delete_reason' => ''),

+ array('post_id' => 5, 'post_visibility' => 2, 'post_delete_reason' => 'manually'),

+ array('post_id' => 6, 'post_visibility' => 0, 'post_delete_reason' => ''),

+ ),

+ array(

+ array('topic_visibility' => 1, 'topic_first_post_id' => 4, 'topic_last_post_id' => 4, 'topic_delete_reason' => 'approved'),

+ ),

+ ),

+ array(

+ ITEM_APPROVED, 2, 1,

+ 2, time(), 'approved-forced', true,

+ array(

+ array('post_id' => 4, 'post_visibility' => 1, 'post_delete_reason' => ''),

+ array('post_id' => 5, 'post_visibility' => 1, 'post_delete_reason' => ''),

+ array('post_id' => 6, 'post_visibility' => 1, 'post_delete_reason' => ''),

+ ),

+ array(

+ array('topic_visibility' => 1, 'topic_first_post_id' => 4, 'topic_last_post_id' => 6, 'topic_delete_reason' => 'approved-forced'),

+ ),

+ ),

+ );

+ }

+

+ /**

+ * @dataProvider set_topic_visibility_data

+ */

+ public function test_set_topic_visibility($visibility, $topic_id, $forum_id, $user_id, $time, $reason, $force_update_all, $expected_posts, $expected_topic)

+ {

+ global $cache, $db, $auth, $phpbb_root_path, $phpEx;

+

+ $cache = new phpbb_mock_cache;

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

+ $auth = $this->getMock('phpbb_auth');

+ $user = $this->getMock('phpbb_user');

+ $content_visibility = new phpbb_content_visibility($auth, $db, $user, $phpbb_root_path, $phpEx, FORUMS_TABLE, POSTS_TABLE, TOPICS_TABLE, USERS_TABLE);

+

+ $content_visibility->set_topic_visibility($visibility, $topic_id, $forum_id, $user_id, $time, $reason, $force_update_all);

+

+ $result = $db->sql_query('SELECT post_id, post_visibility, post_delete_reason

+ FROM phpbb_posts

+ WHERE topic_id = ' . $topic_id . '

+ ORDER BY post_id ASC');

+

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

+ $db->sql_freeresult($result);

+

+ $result = $db->sql_query('SELECT topic_visibility, topic_first_post_id, topic_last_post_id, topic_delete_reason

+ FROM phpbb_topics

+ WHERE topic_id = ' . $topic_id);

+

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

+ $db->sql_freeresult($result);

+ }

+}

+ include(__DIR__.'/phpbb/controller/foo.php');

+ global $phpbb_dispatcher, $phpbb_root_path, $phpEx;

+ $this->template = new phpbb_template_twig($phpbb_root_path, $phpEx, $config, $this->user, new phpbb_template_context());

+ $this->style_resource_locator = new phpbb_style_resource_locator();

+ $this->style_provider = new phpbb_style_path_provider();

+ $this->style = new phpbb_style($phpbb_root_path, $phpEx, new phpbb_config(array()), $this->user, $this->style_resource_locator, $this->style_provider, $this->template);

+ if (strpos($db->sql_layer, 'mysql') === 0 && version_compare($db->sql_server_info(true, false), '5.6', '>='))

+ {

+ $this->markTestSkipped('MySQL 5.6 fails to order things correctly. See also: http://tracker.phpbb.com/browse/PHPBB3-11571 http://bugs.mysql.com/bug.php?id=69005');

+ }

+

+ ),

+ $config_file = __DIR__ . '/fixtures/config.php';

+ $container = phpbb_create_compiled_container($config_file, $extensions, array(), $phpbb_root_path, 'php');

+ ->core_path('phpbb/default/')

+ ->core_path('phpbb/default/')

+ ->core_path('phpbb/default/')

+ 'core_path' => 'phpbb/foo',

+ $this->template = new phpbb_template_twig(

+<?php

+/**

+ *

+ * @package testing

+ * @copyright (c) 2013 phpBB Group

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

+ *

+ */

+

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

+

+/**

+ * @group functional

+ */

+class phpbb_functional_avatar_acp_groups_test extends phpbb_functional_common_avatar_test

+{

+ public function get_url()

+ {

+ return 'adm/index.php?i=acp_groups&mode=manage&action=edit&g=5';

+ }

+

+ public function avatar_acp_groups_data()

+ {

+ return array(

+ // Correct Gravatar

+ array(

+ 'GROUP_UPDATED',

+ 'avatar_driver_gravatar',

+ array(

+ 'avatar_gravatar_email' => 'test@example.com',

+ 'avatar_gravatar_width' => 80,

+ 'avatar_gravatar_height' => 80,

+ ),

+ ),

+ // Gravatar with incorrect size

+ array(

+ 'The submitted avatar is 120 wide and 120 high. Avatars must be at least 20 wide and 20 high, but no larger than 90 wide and 90 high.',

+ 'avatar_driver_gravatar',

+ array(

+ 'avatar_gravatar_email' => 'test@example.com',

+ 'avatar_gravatar_width' => 120,

+ 'avatar_gravatar_height' => 120,

+ ),

+ ),

+ // Delete avatar image to reset group settings

+ array(

+ 'GROUP_UPDATED',

+ 'avatar_driver_gravatar',

+ array(

+ 'avatar_delete' => array('tick', ''),

+ ),

+ ),

+ );

+ }

+

+ /**

+ * @dataProvider avatar_acp_groups_data

+ */

+ public function test_avatar_acp_groups($expected, $avatar_type, $data)

+ {

+ $this->assert_avatar_submit($expected, $avatar_type, $data);

+ }

+}

+<?php

+/**

+ *

+ * @package testing

+ * @copyright (c) 2013 phpBB Group

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

+ *

+ */

+

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

+

+/**

+ * @group functional

+ */

+class phpbb_functional_avatar_acp_users_test extends phpbb_functional_common_avatar_test

+{

+ public function get_url()

+ {

+ return 'adm/index.php?i=acp_users&u=2&mode=avatar';

+ }

+

+ public function avatar_acp_users_data()

+ {

+ return array(

+ // Gravatar with incorrect email

+ array(

+ 'EMAIL_INVALID_EMAIL',

+ 'avatar_driver_gravatar',

+ array(

+ 'avatar_gravatar_email' => 'test.example.com',

+ 'avatar_gravatar_width' => 80,

+ 'avatar_gravatar_height' => 80,

+ ),

+ ),

+ // Remote avatar with correct link

+ array(

+ 'USER_AVATAR_UPDATED',

+ 'avatar_driver_upload',

+ array(

+ 'avatar_upload_url' => 'https://secure.gravatar.com/avatar/55502f40dc8b7c769880b10874abc9d0.jpg',

+ ),

+ ),

+ // Reset avatar settings

+ array(

+ 'USER_AVATAR_UPDATED',

+ 'avatar_driver_gravatar',

+ array(

+ 'avatar_delete' => array('tick', ''),

+ ),

+ ),

+ );

+ }

+

+ /**

+ * @dataProvider avatar_acp_users_data

+ */

+ public function test_avatar_acp_users($expected, $avatar_type, $data)

+ {

+ $this->assert_avatar_submit($expected, $avatar_type, $data);

+ }

+}

+<?php

+/**

+ *

+ * @package testing

+ * @copyright (c) 2013 phpBB Group

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

+ *

+ */

+

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

+

+/**

+ * @group functional

+ */

+class phpbb_functional_avatar_ucp_groups_test extends phpbb_functional_common_avatar_test

+{

+ public function get_url()

+ {

+ return 'ucp.php?i=ucp_groups&mode=manage&action=edit&g=5';

+ }

+

+ public function avatar_ucp_groups_data()

+ {

+ return array(

+ // Incorrect URL

+ array(

+ 'AVATAR_URL_INVALID',

+ 'avatar_driver_upload',

+ array(

+ 'avatar_upload_url' => 'https://secure.gravatar.com/avatar/55502f40dc8b7c769880b10874abc9d0?s=80',

+ ),

+ ),

+ /*

+ // Does not work due to DomCrawler issue

+ // Valid file upload

+ array(

+ 'GROUP_UPDATED',

+ 'avatar_driver_upload',

+ array(

+ 'avatar_upload_file' => array('upload', $this->path . 'valid.jpg'),

+ ),

+ ),

+ */

+ // Correct remote avatar

+ array(

+ 'GROUP_UPDATED',

+ 'avatar_driver_remote',

+ array(

+ 'avatar_remote_url' => 'https://secure.gravatar.com/avatar/55502f40dc8b7c769880b10874abc9d0.jpg',

+ 'avatar_remote_width' => 80,

+ 'avatar_remote_height' => 80,

+ ),

+ ),

+ array(

+ 'GROUP_UPDATED',

+ 'avatar_driver_gravatar',

+ array(

+ 'avatar_delete' => array('tick', ''),

+ ),

+ ),

+ );

+ }

+

+ /**

+ * @dataProvider avatar_ucp_groups_data

+ */

+ public function test_avatar_ucp_groups($expected, $avatar_type, $data)

+ {

+ $this->assert_avatar_submit($expected, $avatar_type, $data);

+ }

+}

+<?php

+/**

+ *

+ * @package testing

+ * @copyright (c) 2013 phpBB Group

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

+ *

+ */

+

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

+

+/**

+ * @group functional

+ */

+class phpbb_functional_avatar_ucp_users_test extends phpbb_functional_common_avatar_test

+{

+ public function get_url()

+ {

+ return 'ucp.php?i=ucp_profile&mode=avatar';

+ }

+

+ public function avatar_ucp_groups_data()

+ {

+ return array(

+ // Gravatar with correct settings

+ array(

+ 'PROFILE_UPDATED',

+ 'avatar_driver_gravatar',

+ array(

+ 'avatar_gravatar_email' => 'test@example.com',

+ 'avatar_gravatar_width' => 80,

+ 'avatar_gravatar_height' => 80,

+ ),

+ ),

+ // Wrong driver selected

+ array(

+ 'NO_AVATAR_SELECTED',

+ 'avatar_driver_upload',

+ array(

+ 'avatar_remote_url' => 'https://secure.gravatar.com/avatar/55502f40dc8b7c769880b10874abc9d0.jpg',

+ 'avatar_remote_width' => 80,

+ 'avatar_remote_height' => 80,

+ ),

+ ),

+ array(

+ 'PROFILE_UPDATED',

+ 'avatar_driver_gravatar',

+ array(

+ 'avatar_delete' => array('tick', ''),

+ ),

+ ),

+ );

+ }

+

+ /**

+ * @dataProvider avatar_ucp_groups_data

+ */

+ public function test_avatar_ucp_groups($expected, $avatar_type, $data)

+ {

+ $this->assert_avatar_submit($expected, $avatar_type, $data);

+ }

+

+ public function test_display_upload_avatar()

+ {

+ $this->assert_avatar_submit('PROFILE_UPDATED',

+ 'avatar_driver_upload',

+ array(

+ 'avatar_upload_url' => 'https://secure.gravatar.com/avatar/55502f40dc8b7c769880b10874abc9d0.jpg',

+ )

+ );

+

+ $crawler = self::request('GET', $this->get_url() . '&sid=' . $this->sid);

+ $avatar_link = $crawler->filter('img')->attr('src');

+ $crawler = self::request('GET', $avatar_link . '&sid=' . $this->sid, array(), false);

+ $content = self::$client->getResponse()->getContent();

+ self::assertEquals(false, stripos(trim($content), 'debug'), 'Output contains debug message');

+ }

+}

+<?php

+/**

+ *

+ * @package testing

+ * @copyright (c) 2013 phpBB Group

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

+ *

+ */

+

+/**

+ * @group functional

+ */

+abstract class phpbb_functional_common_avatar_test extends phpbb_functional_test_case

+{

+ private $path;

+ private $form_content;

+

+ abstract function get_url();

+

+ public function setUp()

+ {

+ parent::setUp();

+ $this->path = __DIR__ . '/fixtures/files/';

+ $this->login();

+ $this->admin_login();

+ $this->add_lang(array('acp/board', 'ucp', 'acp/users', 'acp/groups'));

+ $this->set_acp_settings();

+ }

+

+ private function set_acp_settings()

+ {

+ $crawler = self::request('GET', 'adm/index.php?i=acp_board&mode=avatar&sid=' . $this->sid);

+ // Check the default entries we should have

+ $this->assertContainsLang('ALLOW_GRAVATAR', $crawler->text());

+ $this->assertContainsLang('ALLOW_REMOTE', $crawler->text());

+ $this->assertContainsLang('ALLOW_AVATARS', $crawler->text());

+ $this->assertContainsLang('ALLOW_LOCAL', $crawler->text());

+

+ // Now start setting the needed settings

+ $form = $crawler->selectButton($this->lang('SUBMIT'))->form();

+ $form['config[allow_avatar_local]']->select(1);

+ $form['config[allow_avatar_gravatar]']->select(1);

+ $form['config[allow_avatar_remote]']->select(1);

+ $form['config[allow_avatar_remote_upload]']->select(1);

+ $crawler = self::submit($form);

+ $this->assertContainsLang('CONFIG_UPDATED', $crawler->text());

+ }

+

+ public function assert_avatar_submit($expected, $type, $data, $button_text = 'SUBMIT')

+ {

+ $crawler = self::request('GET', $this->get_url() . '&sid=' . $this->sid);

+

+ // Test if setting a gravatar avatar properly works

+ $form = $crawler->selectButton($this->lang($button_text))->form();

+ $form['avatar_driver']->select($type);

+

+ foreach ($data as $key => $value)

+ {

+ if (is_array($value))

+ {

+ $form[$key]->$value[0]($value[1]);

+ }

+ else

+ {

+ $form[$key]->setValue($value);

+ }

+ }

+

+ $crawler = self::submit($form);

+

+ try

+ {

+ $this->assertContainsLang($expected, $crawler->text());

+ }

+ catch (Exception $e)

+ {

+ $this->assertContains($expected, $crawler->text());

+ }

+ }

+}

+ // Enable all avatars in the ACP

+ protected function enable_all_avatars()

+ {

+ $this->add_lang('acp/board');

+

+ $crawler = self::request('GET', 'adm/index.php?i=board&mode=avatar&sid=' . $this->sid);

+ // Check the default entries we should have

+ $this->assertContains($this->lang('ALLOW_REMOTE'), $crawler->text());

+ $this->assertContains($this->lang('ALLOW_AVATARS'), $crawler->text());

+ $this->assertContains($this->lang('ALLOW_LOCAL'), $crawler->text());

+

+ // Now start setting the needed settings

+ $form = $crawler->selectButton($this->lang('SUBMIT'))->form();

+ $form['config[allow_avatar_local]']->select(1);

+ $form['config[allow_avatar_remote]']->select(1);

+ $form['config[allow_avatar_remote_upload]']->select(1);

+ $crawler = self::submit($form);

+ $this->assertContains($this->lang('CONFIG_UPDATED'), $crawler->text());

+ }

+

+

+ public function group_avatar_min_max_data()

+ {

+ return array(

+ array('avatar_driver_upload', 'avatar_upload_url', 'foo', 'AVATAR_URL_INVALID'),

+ array('avatar_driver_upload', 'avatar_upload_url', 'foobar', 'AVATAR_URL_INVALID'),

+ array('avatar_driver_upload', 'avatar_upload_url', 'http://www.phpbb.com/' . str_repeat('f', 240) . '.png', 'TOO_LONG'),

+ array('avatar_driver_remote', 'avatar_remote_url', 'foo', 'AVATAR_URL_INVALID'),

+ array('avatar_driver_remote', 'avatar_remote_url', 'foobar', 'AVATAR_URL_INVALID'),

+ array('avatar_driver_remote', 'avatar_remote_url', 'http://www.phpbb.com/' . str_repeat('f', 240) . '.png', 'TOO_LONG'),

+ );

+ }

+

+ /**

+ * @dataProvider group_avatar_min_max_data

+ */

+ public function test_group_avatar_min_max($avatar_type, $form_name, $input, $expected)

+ {

+ $this->login();

+ $this->admin_login();

+ $this->add_lang(array('ucp', 'acp/groups'));

+ $this->enable_all_avatars();

+

+ $crawler = self::request('GET', $this->get_url() . '&g=5&sid=' . $this->sid);

+ $form = $crawler->selectButton($this->lang('SUBMIT'))->form();

+ $form['avatar_driver']->setValue($avatar_type);

+ $form[$form_name]->setValue($input);

+ $crawler = self::submit($form);

+ $this->assertContains($this->lang($expected), $crawler->text());

+ }

+ 'foo/bar/event/',

+ $this->assertContains('Can view foobar', $crawler->filter('body')->text());

+<?php

+

+/**

+*

+* @package testing

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Event listener

+*/

+use Symfony\Component\EventDispatcher\EventSubscriberInterface;

+

+class phpbb_ext_foo_bar_event_permission_listener implements EventSubscriberInterface

+{

+ static public function getSubscribedEvents()

+ {

+ return array(

+ 'core.permissions' => 'add_permissions',

+ );

+ }

+

+ public function add_permissions($event)

+ {

+ $permissions = $event['permissions'];

+ $permissions['u_foo'] = array('lang' => 'ACL_U_FOOBAR', 'cat' => 'post');

+ $event['permissions'] = $permissions;

+ }

+}

+ 'ACL_U_FOOBAR' => 'Can view foobar with permission foo',

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+/**

+* @group functional

+*/

+class phpbb_functional_forum_style_test extends phpbb_functional_test_case

+{

+ public function test_default_forum_style()

+ {

+ $crawler = self::request('GET', 'viewtopic.php?t=1&f=2');

+ $this->assertContains('styles/prosilver/', $crawler->filter('head > link[rel=stylesheet]')->attr('href'));

+

+ $crawler = self::request('GET', 'viewtopic.php?t=1');

+ $this->assertContains('styles/prosilver/', $crawler->filter('head > link[rel=stylesheet]')->attr('href'));

+

+ $crawler = self::request('GET', 'viewtopic.php?t=1&view=next');

+ $this->assertContains('styles/prosilver/', $crawler->filter('head > link[rel=stylesheet]')->attr('href'));

+ }

+

+ public function test_custom_forum_style()

+ {

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

+ $this->add_style(2, 'test_style');

+ $db->sql_query('UPDATE ' . FORUMS_TABLE . ' SET forum_style = 2 WHERE forum_id = 2');

+

+ $crawler = self::request('GET', 'viewtopic.php?t=1&f=2');

+ $this->assertContains('styles/test_style/', $crawler->filter('head > link[rel=stylesheet]')->attr('href'));

+

+ $crawler = self::request('GET', 'viewtopic.php?t=1');

+ $this->assertContains('styles/test_style/', $crawler->filter('head > link[rel=stylesheet]')->attr('href'));

+

+ $crawler = self::request('GET', 'viewtopic.php?t=1&view=next');

+ $this->assertContains('styles/test_style/', $crawler->filter('head > link[rel=stylesheet]')->attr('href'));

+

+ $db->sql_query('UPDATE ' . FORUMS_TABLE . ' SET forum_style = 0 WHERE forum_id = 2');

+ $this->delete_style(2, 'test_style');

+ }

+}

+ public function test_user_report_post()

+ {

+ $this->login();

+ $crawler = self::request('GET', 'report.php?f=2&p=1');

+ $this->assertNotContains($this->lang('CONFIRM_CODE'), $crawler->filter('html')->text());

+

+ $this->add_lang('mcp');

+ $form = $crawler->selectButton($this->lang('SUBMIT'))->form();

+ $crawler = self::submit($form);

+ $this->assertContains($this->lang('POST_REPORTED_SUCCESS'), $crawler->text());

+ }

+

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+/**

+* @group functional

+*/

+class phpbb_functional_softdelete_test extends phpbb_functional_test_case

+{

+ protected $data = array();

+

+ public function test_setup_forums()

+ {

+ $this->login();

+ $this->admin_login();

+

+ $crawler = self::request('GET', "adm/index.php?i=acp_forums&mode=manage&sid={$this->sid}");

+ $form = $crawler->selectButton('addforum')->form(array(

+ 'forum_name' => 'Soft Delete #1',

+ ));

+ $crawler = self::submit($form);

+ $form = $crawler->selectButton('update')->form(array(

+ 'forum_perm_from' => 2,

+ ));

+ $crawler = self::submit($form);

+

+ $crawler = self::request('GET', "adm/index.php?i=acp_forums&mode=manage&sid={$this->sid}");

+ $form = $crawler->selectButton('addforum')->form(array(

+ 'forum_name' => 'Soft Delete #2',

+ ));

+ $crawler = self::submit($form);

+ $form = $crawler->selectButton('update')->form(array(

+ 'forum_perm_from' => 2,

+ ));

+ $crawler = self::submit($form);

+ }

+

+ public function test_create_post()

+ {

+ $this->login();

+ $this->load_ids(array(

+ 'forums' => array(

+ 'Soft Delete #1',

+ 'Soft Delete #2',

+ ),

+ ));

+

+ $this->assert_forum_details($this->data['forums']['Soft Delete #1'], array(

+ 'forum_posts_approved' => 0,

+ 'forum_posts_unapproved' => 0,

+ 'forum_posts_softdeleted' => 0,

+ 'forum_topics_approved' => 0,

+ 'forum_topics_unapproved' => 0,

+ 'forum_topics_softdeleted' => 0,

+ 'forum_last_post_id' => 0,

+ ), 'initial comparison');

+

+ // Test creating topic

+ $post = $this->create_topic($this->data['forums']['Soft Delete #1'], 'Soft Delete Topic #1', 'This is a test topic posted by the testing framework.');

+ $crawler = self::request('GET', "viewtopic.php?t={$post['topic_id']}&sid={$this->sid}");

+

+ $this->assertContains('Soft Delete Topic #1', $crawler->filter('html')->text());

+ $this->data['topics']['Soft Delete Topic #1'] = (int) $post['topic_id'];

+ $this->data['posts']['Soft Delete Topic #1'] = (int) $this->get_parameter_from_link($crawler->filter('.post')->selectLink($this->lang('POST', '', ''))->link()->getUri(), 'p');

+

+ $this->assert_forum_details($this->data['forums']['Soft Delete #1'], array(

+ 'forum_posts_approved' => 1,

+ 'forum_posts_unapproved' => 0,

+ 'forum_posts_softdeleted' => 0,

+ 'forum_topics_approved' => 1,

+ 'forum_topics_unapproved' => 0,

+ 'forum_topics_softdeleted' => 0,

+ 'forum_last_post_id' => $this->data['posts']['Soft Delete Topic #1'],

+ ), 'after creating topic #1');

+

+ // Test creating a reply

+ $post2 = $this->create_post($this->data['forums']['Soft Delete #1'], $post['topic_id'], 'Re: Soft Delete Topic #1-#2', 'This is a test post posted by the testing framework.');

+ $crawler = self::request('GET', "viewtopic.php?t={$post2['topic_id']}&sid={$this->sid}");

+

+ $this->assertContains('Re: Soft Delete Topic #1-#2', $crawler->filter('html')->text());

+ $this->data['posts']['Re: Soft Delete Topic #1-#2'] = (int) $this->get_parameter_from_link($crawler->filter('.post')->eq(1)->selectLink($this->lang('POST', '', ''))->link()->getUri(), 'p');

+

+ $this->assert_forum_details($this->data['forums']['Soft Delete #1'], array(

+ 'forum_posts_approved' => 2,

+ 'forum_posts_unapproved' => 0,

+ 'forum_posts_softdeleted' => 0,

+ 'forum_topics_approved' => 1,

+ 'forum_topics_unapproved' => 0,

+ 'forum_topics_softdeleted' => 0,

+ 'forum_last_post_id' => $this->data['posts']['Re: Soft Delete Topic #1-#2'],

+ ), 'after replying');

+ }

+

+ public function test_softdelete_post()

+ {

+ $this->login();

+ $this->load_ids(array(

+ 'forums' => array(

+ 'Soft Delete #1',

+ 'Soft Delete #2',

+ ),

+ 'topics' => array(

+ 'Soft Delete Topic #1',

+ ),

+ 'posts' => array(

+ 'Soft Delete Topic #1',

+ 'Re: Soft Delete Topic #1-#2',

+ ),

+ ));

+

+ $this->assert_forum_details($this->data['forums']['Soft Delete #1'], array(

+ 'forum_posts_approved' => 2,

+ 'forum_posts_unapproved' => 0,

+ 'forum_posts_softdeleted' => 0,

+ 'forum_topics_approved' => 1,

+ 'forum_topics_unapproved' => 0,

+ 'forum_topics_softdeleted' => 0,

+ 'forum_last_post_id' => $this->data['posts']['Re: Soft Delete Topic #1-#2'],

+ ), 'before softdelete');

+

+ $this->add_lang('posting');

+ $crawler = self::request('GET', "posting.php?mode=delete&f={$this->data['forums']['Soft Delete #1']}&p={$this->data['posts']['Re: Soft Delete Topic #1-#2']}&sid={$this->sid}");

+ $this->assertContainsLang('DELETE_PERMANENTLY', $crawler->text());

+

+ $form = $crawler->selectButton('Yes')->form();

+ $crawler = self::submit($form);

+ $this->assertContainsLang('POST_DELETED', $crawler->text());

+

+ $this->assert_forum_details($this->data['forums']['Soft Delete #1'], array(

+ 'forum_posts_approved' => 1,

+ 'forum_posts_unapproved' => 0,

+ 'forum_posts_softdeleted' => 1,

+ 'forum_topics_approved' => 1,

+ 'forum_topics_unapproved' => 0,

+ 'forum_topics_softdeleted' => 0,

+ 'forum_last_post_id' => $this->data['posts']['Soft Delete Topic #1'],

+ ), 'after softdelete');

+

+ $crawler = self::request('GET', "viewtopic.php?t={$this->data['topics']['Soft Delete Topic #1']}&sid={$this->sid}");

+ $this->assertContains($this->lang('POST_DISPLAY', '', ''), $crawler->text());

+ }

+

+ public function test_move_softdeleted_post()

+ {

+ $this->login();

+ $this->load_ids(array(

+ 'forums' => array(

+ 'Soft Delete #1',

+ 'Soft Delete #2',

+ ),

+ 'topics' => array(

+ 'Soft Delete Topic #1',

+ ),

+ 'posts' => array(

+ 'Soft Delete Topic #1',

+ 'Re: Soft Delete Topic #1-#2',

+ ),

+ ));

+

+ $this->assert_forum_details($this->data['forums']['Soft Delete #1'], array(

+ 'forum_posts_approved' => 1,

+ 'forum_posts_unapproved' => 0,

+ 'forum_posts_softdeleted' => 1,

+ 'forum_topics_approved' => 1,

+ 'forum_topics_unapproved' => 0,

+ 'forum_topics_softdeleted' => 0,

+ 'forum_last_post_id' => $this->data['posts']['Soft Delete Topic #1'],

+ ), 'before moving #1');

+

+ $this->assert_forum_details($this->data['forums']['Soft Delete #2'], array(

+ 'forum_posts_approved' => 0,

+ 'forum_posts_unapproved' => 0,

+ 'forum_posts_softdeleted' => 0,

+ 'forum_topics_approved' => 0,

+ 'forum_topics_unapproved' => 0,

+ 'forum_topics_softdeleted' => 0,

+ 'forum_last_post_id' => 0,

+ ), 'before moving #2');

+

+ $crawler = self::request('GET', "viewtopic.php?t={$this->data['topics']['Soft Delete Topic #1']}&sid={$this->sid}");

+

+ $form = $crawler->selectButton('Go')->eq(2)->form();

+ $form['action']->select('move');

+ $crawler = self::submit($form);

+ $this->assertContainsLang('SELECT_DESTINATION_FORUM', $crawler->text());

+

+ $this->add_lang('mcp');

+ $form = $crawler->selectButton('Yes')->form();

+ $form['to_forum_id']->select($this->data['forums']['Soft Delete #2']);

+ $crawler = self::submit($form);

+ $this->assertContainsLang('TOPIC_MOVED_SUCCESS', $crawler->text());

+

+ $crawler = self::request('GET', "viewtopic.php?t={$this->data['topics']['Soft Delete Topic #1']}&sid={$this->sid}");

+ $this->assertContains('Soft Delete #2', $crawler->filter('.navlinks')->text());

+ $this->assertContains('Soft Delete Topic #1', $crawler->filter('h2')->text());

+

+ $this->assert_forum_details($this->data['forums']['Soft Delete #1'], array(

+ 'forum_posts_approved' => 0,

+ 'forum_posts_unapproved' => 0,

+ 'forum_posts_softdeleted' => 0,

+ 'forum_topics_approved' => 0,

+ 'forum_topics_unapproved' => 0,

+ 'forum_topics_softdeleted' => 0,

+ 'forum_last_post_id' => 0,

+ ), 'after moving #1');

+

+ $this->assert_forum_details($this->data['forums']['Soft Delete #2'], array(

+ 'forum_posts_approved' => 1,

+ 'forum_posts_unapproved' => 0,

+ 'forum_posts_softdeleted' => 1,

+ 'forum_topics_approved' => 1,

+ 'forum_topics_unapproved' => 0,

+ 'forum_topics_softdeleted' => 0,

+ 'forum_last_post_id' => $this->data['posts']['Soft Delete Topic #1'],

+ ), 'after moving #2');

+ }

+

+ public function test_softdelete_topic()

+ {

+ $this->login();

+ $this->load_ids(array(

+ 'forums' => array(

+ 'Soft Delete #1',

+ 'Soft Delete #2',

+ ),

+ 'topics' => array(

+ 'Soft Delete Topic #1',

+ ),

+ 'posts' => array(

+ 'Soft Delete Topic #1',

+ 'Re: Soft Delete Topic #1-#2',

+ ),

+ ));

+

+ $this->assert_forum_details($this->data['forums']['Soft Delete #1'], array(

+ 'forum_posts_approved' => 0,

+ 'forum_posts_unapproved' => 0,

+ 'forum_posts_softdeleted' => 0,

+ 'forum_topics_approved' => 0,

+ 'forum_topics_unapproved' => 0,

+ 'forum_topics_softdeleted' => 0,

+ 'forum_last_post_id' => 0,

+ ), 'before softdeleting #1');

+

+ $this->assert_forum_details($this->data['forums']['Soft Delete #2'], array(

+ 'forum_posts_approved' => 1,

+ 'forum_posts_unapproved' => 0,

+ 'forum_posts_softdeleted' => 1,

+ 'forum_topics_approved' => 1,

+ 'forum_topics_unapproved' => 0,

+ 'forum_topics_softdeleted' => 0,

+ 'forum_last_post_id' => $this->data['posts']['Soft Delete Topic #1'],

+ ), 'before softdeleting #2');

+

+ $crawler = self::request('GET', "viewtopic.php?t={$this->data['topics']['Soft Delete Topic #1']}&sid={$this->sid}");

+

+ $this->add_lang('posting');

+ $form = $crawler->selectButton('Go')->eq(2)->form();

+ $form['action']->select('delete_topic');

+ $crawler = self::submit($form);

+ $this->assertContainsLang('DELETE_PERMANENTLY', $crawler->text());

+

+ $this->add_lang('mcp');

+ $form = $crawler->selectButton('Yes')->form();

+ $crawler = self::submit($form);

+ $this->assertContainsLang('TOPIC_DELETED_SUCCESS', $crawler->text());

+

+ $crawler = self::request('GET', "viewtopic.php?t={$this->data['topics']['Soft Delete Topic #1']}&sid={$this->sid}");

+ $this->assertContains('Soft Delete #2', $crawler->filter('.navlinks')->text());

+ $this->assertContains('Soft Delete Topic #1', $crawler->filter('h2')->text());

+

+ $this->assert_forum_details($this->data['forums']['Soft Delete #1'], array(

+ 'forum_posts_approved' => 0,

+ 'forum_posts_unapproved' => 0,

+ 'forum_posts_softdeleted' => 0,

+ 'forum_topics_approved' => 0,

+ 'forum_topics_unapproved' => 0,

+ 'forum_topics_softdeleted' => 0,

+ 'forum_last_post_id' => 0,

+ ), 'after moving #1');

+

+ $this->assert_forum_details($this->data['forums']['Soft Delete #2'], array(

+ 'forum_posts_approved' => 0,

+ 'forum_posts_unapproved' => 0,

+ 'forum_posts_softdeleted' => 2,

+ 'forum_topics_approved' => 0,

+ 'forum_topics_unapproved' => 0,

+ 'forum_topics_softdeleted' => 1,

+ 'forum_last_post_id' => 0,

+ ), 'after moving #2');

+ }

+

+ public function test_move_softdeleted_topic()

+ {

+ $this->login();

+ $this->load_ids(array(

+ 'forums' => array(

+ 'Soft Delete #1',

+ 'Soft Delete #2',

+ ),

+ 'topics' => array(

+ 'Soft Delete Topic #1',

+ ),

+ 'posts' => array(

+ 'Soft Delete Topic #1',

+ 'Re: Soft Delete Topic #1-#2',

+ ),

+ ));

+

+ $this->assert_forum_details($this->data['forums']['Soft Delete #1'], array(

+ 'forum_posts_approved' => 0,

+ 'forum_posts_unapproved' => 0,

+ 'forum_posts_softdeleted' => 0,

+ 'forum_topics_approved' => 0,

+ 'forum_topics_unapproved' => 0,

+ 'forum_topics_softdeleted' => 0,

+ 'forum_last_post_id' => 0,

+ ), 'before moving #1');

+

+ $this->assert_forum_details($this->data['forums']['Soft Delete #2'], array(

+ 'forum_posts_approved' => 0,

+ 'forum_posts_unapproved' => 0,

+ 'forum_posts_softdeleted' => 2,

+ 'forum_topics_approved' => 0,

+ 'forum_topics_unapproved' => 0,

+ 'forum_topics_softdeleted' => 1,

+ 'forum_last_post_id' => 0,

+ ), 'before moving #2');

+

+ $crawler = self::request('GET', "viewtopic.php?t={$this->data['topics']['Soft Delete Topic #1']}&sid={$this->sid}");

+

+ $form = $crawler->selectButton('Go')->eq(2)->form();

+ $form['action']->select('move');

+ $crawler = self::submit($form);

+ $this->assertContainsLang('SELECT_DESTINATION_FORUM', $crawler->text());

+

+ $this->add_lang('mcp');

+ $form = $crawler->selectButton('Yes')->form();

+ $form['to_forum_id']->select($this->data['forums']['Soft Delete #1']);

+ $crawler = self::submit($form);

+ $this->assertContainsLang('TOPIC_MOVED_SUCCESS', $crawler->text());

+

+ $crawler = self::request('GET', "viewtopic.php?t={$this->data['topics']['Soft Delete Topic #1']}&sid={$this->sid}");

+ $this->assertContains('Soft Delete #1', $crawler->filter('.navlinks')->text());

+ $this->assertContains('Soft Delete Topic #1', $crawler->filter('h2')->text());

+

+ $this->assert_forum_details($this->data['forums']['Soft Delete #1'], array(

+ 'forum_posts_approved' => 0,

+ 'forum_posts_unapproved' => 0,

+ 'forum_posts_softdeleted' => 2,

+ 'forum_topics_approved' => 0,

+ 'forum_topics_unapproved' => 0,

+ 'forum_topics_softdeleted' => 1,

+ 'forum_last_post_id' => 0,

+ ), 'after moving #1');

+

+ $this->assert_forum_details($this->data['forums']['Soft Delete #2'], array(

+ 'forum_posts_approved' => 0,

+ 'forum_posts_unapproved' => 0,

+ 'forum_posts_softdeleted' => 0,

+ 'forum_topics_approved' => 0,

+ 'forum_topics_unapproved' => 0,

+ 'forum_topics_softdeleted' => 0,

+ 'forum_last_post_id' => 0,

+ ), 'after moving #2');

+ }

+

+ public function test_restore_post()

+ {

+ $this->login();

+ $this->load_ids(array(

+ 'forums' => array(

+ 'Soft Delete #1',

+ 'Soft Delete #2',

+ ),

+ 'topics' => array(

+ 'Soft Delete Topic #1',

+ ),

+ 'posts' => array(

+ 'Soft Delete Topic #1',

+ 'Re: Soft Delete Topic #1-#2',

+ ),

+ ));

+

+ $this->assert_forum_details($this->data['forums']['Soft Delete #1'], array(

+ 'forum_posts_approved' => 0,

+ 'forum_posts_unapproved' => 0,

+ 'forum_posts_softdeleted' => 2,

+ 'forum_topics_approved' => 0,

+ 'forum_topics_unapproved' => 0,

+ 'forum_topics_softdeleted' => 1,

+ 'forum_last_post_id' => 0,

+ ), 'before restoring #1');

+

+ $this->assert_forum_details($this->data['forums']['Soft Delete #2'], array(

+ 'forum_posts_approved' => 0,

+ 'forum_posts_unapproved' => 0,

+ 'forum_posts_softdeleted' => 0,

+ 'forum_topics_approved' => 0,

+ 'forum_topics_unapproved' => 0,

+ 'forum_topics_softdeleted' => 0,

+ 'forum_last_post_id' => 0,

+ ), 'before restoring #2');

+

+ $crawler = self::request('GET', "viewtopic.php?t={$this->data['topics']['Soft Delete Topic #1']}&sid={$this->sid}");

+

+ $this->add_lang('mcp');

+ $form = $crawler->selectButton($this->lang('RESTORE'))->form();

+ $crawler = self::submit($form);

+ $this->assertContainsLang('RESTORE_POST', $crawler->text());

+

+ $form = $crawler->selectButton('Yes')->form();

+ $crawler = self::submit($form);

+ $this->assertContainsLang('POST_RESTORED_SUCCESS', $crawler->text());

+

+ $crawler = self::request('GET', "viewtopic.php?t={$this->data['topics']['Soft Delete Topic #1']}&sid={$this->sid}");

+ $this->assertContains('Soft Delete #1', $crawler->filter('.navlinks')->text());

+ $this->assertContains('Soft Delete Topic #1', $crawler->filter('h2')->text());

+

+ $this->assert_forum_details($this->data['forums']['Soft Delete #1'], array(

+ 'forum_posts_approved' => 1,

+ 'forum_posts_unapproved' => 0,

+ 'forum_posts_softdeleted' => 1,

+ 'forum_topics_approved' => 1,

+ 'forum_topics_unapproved' => 0,

+ 'forum_topics_softdeleted' => 0,

+ 'forum_last_post_id' => $this->data['posts']['Soft Delete Topic #1'],

+ ), 'after restoring #1');

+

+ $this->assert_forum_details($this->data['forums']['Soft Delete #2'], array(

+ 'forum_posts_approved' => 0,

+ 'forum_posts_unapproved' => 0,

+ 'forum_posts_softdeleted' => 0,

+ 'forum_topics_approved' => 0,

+ 'forum_topics_unapproved' => 0,

+ 'forum_topics_softdeleted' => 0,

+ 'forum_last_post_id' => 0,

+ ), 'after restoring #2');

+ }

+

+ public function test_split_topic()

+ {

+ $this->login();

+ $this->load_ids(array(

+ 'forums' => array(

+ 'Soft Delete #1',

+ 'Soft Delete #2',

+ ),

+ 'topics' => array(

+ 'Soft Delete Topic #1',

+ ),

+ 'posts' => array(

+ 'Soft Delete Topic #1',

+ 'Re: Soft Delete Topic #1-#2',

+ ),

+ ));

+

+ $this->assert_forum_details($this->data['forums']['Soft Delete #1'], array(

+ 'forum_posts_approved' => 1,

+ 'forum_posts_unapproved' => 0,

+ 'forum_posts_softdeleted' => 1,

+ 'forum_topics_approved' => 1,

+ 'forum_topics_unapproved' => 0,

+ 'forum_topics_softdeleted' => 0,

+ 'forum_last_post_id' => $this->data['posts']['Soft Delete Topic #1'],

+ ), 'before splitting #1');

+

+ $this->assert_forum_details($this->data['forums']['Soft Delete #2'], array(

+ 'forum_posts_approved' => 0,

+ 'forum_posts_unapproved' => 0,

+ 'forum_posts_softdeleted' => 0,

+ 'forum_topics_approved' => 0,

+ 'forum_topics_unapproved' => 0,

+ 'forum_topics_softdeleted' => 0,

+ 'forum_last_post_id' => 0,

+ ), 'before splitting #2');

+

+ $crawler = self::request('GET', "viewtopic.php?t={$this->data['topics']['Soft Delete Topic #1']}&sid={$this->sid}");

+

+ $this->add_lang('mcp');

+ $form = $crawler->selectButton('Go')->eq(2)->form();

+ $form['action']->select('split');

+ $crawler = self::submit($form);

+ $this->assertContainsLang('SPLIT_TOPIC_EXPLAIN', $crawler->text());

+

+ $form = $crawler->selectButton('Submit')->form(array(

+ 'subject' => 'Soft Delete Topic #2',

+ ));

+ $form['to_forum_id']->select($this->data['forums']['Soft Delete #2']);

+ $form['post_id_list'][1]->tick();

+ $crawler = self::submit($form);

+

+ $form = $crawler->selectButton('Yes')->form();

+ $crawler = self::submit($form);

+ $this->assertContainsLang('TOPIC_SPLIT_SUCCESS', $crawler->text());

+

+ $crawler = self::request('GET', "viewtopic.php?t={$this->data['topics']['Soft Delete Topic #1']}&sid={$this->sid}");

+ $this->assertContains('Soft Delete Topic #1', $crawler->filter('h2')->text());

+ $this->assertNotContains('Re: Soft Delete Topic #1-#2', $crawler->text());

+

+ $this->assert_forum_details($this->data['forums']['Soft Delete #1'], array(

+ 'forum_posts_approved' => 1,

+ 'forum_posts_unapproved' => 0,

+ 'forum_posts_softdeleted' => 0,

+ 'forum_topics_approved' => 1,

+ 'forum_topics_unapproved' => 0,

+ 'forum_topics_softdeleted' => 0,

+ 'forum_last_post_id' => $this->data['posts']['Soft Delete Topic #1'],

+ ), 'after restoring #1');

+

+ $this->assert_forum_details($this->data['forums']['Soft Delete #2'], array(

+ 'forum_posts_approved' => 0,

+ 'forum_posts_unapproved' => 0,

+ 'forum_posts_softdeleted' => 1,

+ 'forum_topics_approved' => 0,

+ 'forum_topics_unapproved' => 0,

+ 'forum_topics_softdeleted' => 1,

+ 'forum_last_post_id' => 0,

+ ), 'after restoring #2');

+ }

+

+ public function test_move_topic_back()

+ {

+ $this->login();

+ $this->load_ids(array(

+ 'forums' => array(

+ 'Soft Delete #1',

+ 'Soft Delete #2',

+ ),

+ 'topics' => array(

+ 'Soft Delete Topic #1',

+ 'Soft Delete Topic #2',

+ ),

+ 'posts' => array(

+ 'Soft Delete Topic #1',

+ 'Re: Soft Delete Topic #1-#2',

+ ),

+ ));

+

+ $crawler = self::request('GET', "viewtopic.php?t={$this->data['topics']['Soft Delete Topic #2']}&sid={$this->sid}");

+

+ $form = $crawler->selectButton('Go')->eq(1)->form();

+ $form['action']->select('move');

+ $crawler = self::submit($form);

+

+ $form = $crawler->selectButton('Yes')->form();

+ $form['to_forum_id']->select($this->data['forums']['Soft Delete #1']);

+ $crawler = self::submit($form);

+

+ $this->assert_forum_details($this->data['forums']['Soft Delete #1'], array(

+ 'forum_posts_approved' => 1,

+ 'forum_posts_unapproved' => 0,

+ 'forum_posts_softdeleted' => 1,

+ 'forum_topics_approved' => 1,

+ 'forum_topics_unapproved' => 0,

+ 'forum_topics_softdeleted' => 1,

+ 'forum_last_post_id' => $this->data['posts']['Soft Delete Topic #1'],

+ ), 'after moving back');

+ }

+

+ public function test_merge_topics()

+ {

+ $this->login();

+ $this->load_ids(array(

+ 'forums' => array(

+ 'Soft Delete #1',

+ 'Soft Delete #2',

+ ),

+ 'topics' => array(

+ 'Soft Delete Topic #1',

+ 'Soft Delete Topic #2',

+ ),

+ 'posts' => array(

+ 'Soft Delete Topic #1',

+ 'Re: Soft Delete Topic #1-#2',

+ ),

+ ));

+

+ $this->assert_forum_details($this->data['forums']['Soft Delete #1'], array(

+ 'forum_posts_approved' => 1,

+ 'forum_posts_unapproved' => 0,

+ 'forum_posts_softdeleted' => 1,

+ 'forum_topics_approved' => 1,

+ 'forum_topics_unapproved' => 0,

+ 'forum_topics_softdeleted' => 1,

+ 'forum_last_post_id' => $this->data['posts']['Soft Delete Topic #1'],

+ ), 'before merging #1');

+

+ $crawler = self::request('GET', "viewtopic.php?t={$this->data['topics']['Soft Delete Topic #2']}&sid={$this->sid}");

+

+ $this->add_lang('mcp');

+ $form = $crawler->selectButton('Go')->eq(1)->form();

+ $form['action']->select('merge_topic');

+ $crawler = self::submit($form);

+ $this->assertContainsLang('SELECT_MERGE', $crawler->text());

+

+ $crawler = self::request('GET', "mcp.php?f={$this->data['forums']['Soft Delete #1']}&t={$this->data['topics']['Soft Delete Topic #2']}&i=main&mode=forum_view&action=merge_topic&to_topic_id={$this->data['topics']['Soft Delete Topic #1']}");

+ $this->assertContainsLang('MERGE_TOPICS_CONFIRM', $crawler->text());

+

+ $form = $crawler->selectButton('Yes')->form();

+ $crawler = self::submit($form);

+ $this->assertContainsLang('POSTS_MERGED_SUCCESS', $crawler->text());

+

+ $crawler = self::request('GET', "viewtopic.php?t={$this->data['topics']['Soft Delete Topic #1']}&sid={$this->sid}");

+ $this->assertContains('Soft Delete Topic #1', $crawler->filter('h2')->text());

+ $this->assertContainsLang('POST_DELETED', $crawler->filter('body')->text());

+

+ $this->assert_forum_details($this->data['forums']['Soft Delete #1'], array(

+ 'forum_posts_approved' => 1,

+ 'forum_posts_unapproved' => 0,

+ 'forum_posts_softdeleted' => 1,

+ 'forum_topics_approved' => 1,

+ 'forum_topics_unapproved' => 0,

+ 'forum_topics_softdeleted' => 0,

+ 'forum_last_post_id' => $this->data['posts']['Soft Delete Topic #1'],

+ ), 'after merging #1');

+ }

+

+ public function test_fork_topic()

+ {

+ $this->login();

+ $this->load_ids(array(

+ 'forums' => array(

+ 'Soft Delete #1',

+ 'Soft Delete #2',

+ ),

+ 'topics' => array(

+ 'Soft Delete Topic #1',

+ ),

+ 'posts' => array(

+ 'Soft Delete Topic #1',

+ 'Re: Soft Delete Topic #1-#2',

+ ),

+ ));

+

+ $this->assert_forum_details($this->data['forums']['Soft Delete #1'], array(

+ 'forum_posts_approved' => 1,

+ 'forum_posts_unapproved' => 0,

+ 'forum_posts_softdeleted' => 1,

+ 'forum_topics_approved' => 1,

+ 'forum_topics_unapproved' => 0,

+ 'forum_topics_softdeleted' => 0,

+ 'forum_last_post_id' => $this->data['posts']['Soft Delete Topic #1'],

+ ), 'before forking #1');

+

+ $this->assert_forum_details($this->data['forums']['Soft Delete #2'], array(

+ 'forum_posts_approved' => 0,

+ 'forum_posts_unapproved' => 0,

+ 'forum_posts_softdeleted' => 0,

+ 'forum_topics_approved' => 0,

+ 'forum_topics_unapproved' => 0,

+ 'forum_topics_softdeleted' => 0,

+ 'forum_last_post_id' => 0,

+ ), 'before forking #2');

+

+ $crawler = self::request('GET', "viewtopic.php?t={$this->data['topics']['Soft Delete Topic #1']}&sid={$this->sid}");

+

+ $this->add_lang('mcp');

+ $form = $crawler->selectButton('Go')->eq(2)->form();

+ $form['action']->select('fork');

+ $crawler = self::submit($form);

+ $this->assertContainsLang('FORK_TOPIC', $crawler->text());

+

+ $form = $crawler->selectButton('Yes')->form();

+ $form['to_forum_id']->select($this->data['forums']['Soft Delete #2']);

+ $crawler = self::submit($form);

+ $this->assertContainsLang('TOPIC_FORKED_SUCCESS', $crawler->text());

+

+ $this->assert_forum_details($this->data['forums']['Soft Delete #1'], array(

+ 'forum_posts_approved' => 1,

+ 'forum_posts_unapproved' => 0,

+ 'forum_posts_softdeleted' => 1,

+ 'forum_topics_approved' => 1,

+ 'forum_topics_unapproved' => 0,

+ 'forum_topics_softdeleted' => 0,

+ 'forum_last_post_id' => $this->data['posts']['Soft Delete Topic #1'],

+ ), 'after forking #1');

+

+ $this->assert_forum_details($this->data['forums']['Soft Delete #2'], array(

+ 'forum_posts_approved' => 1,

+ 'forum_posts_unapproved' => 0,

+ 'forum_posts_softdeleted' => 1,

+ 'forum_topics_approved' => 1,

+ 'forum_topics_unapproved' => 0,

+ 'forum_topics_softdeleted' => 0,

+ 'forum_last_post_id' => $this->data['posts']['Soft Delete Topic #1'] + 2,

+ ), 'after forking #2');

+ }

+

+ public function assert_forum_details($forum_id, $details, $additional_error_message = '')

+ {

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

+

+ $sql = 'SELECT ' . implode(', ', array_keys($details)) . '

+ FROM phpbb_forums

+ WHERE forum_id = ' . (int) $forum_id;

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

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

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

+

+ $this->assertEquals($details, $data, "Forum {$forum_id} does not match expected {$additional_error_message}");

+ }

+

+ public function load_ids($data)

+ {

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

+

+ if (!empty($data['forums']))

+ {

+ $sql = 'SELECT *

+ FROM phpbb_forums

+ WHERE ' . $this->db->sql_in_set('forum_name', $data['forums']);

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

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

+ {

+ if (in_array($row['forum_name'], $data['forums']))

+ {

+ $this->data['forums'][$row['forum_name']] = (int) $row['forum_id'];

+ }

+ }

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

+ }

+

+ if (!empty($data['topics']))

+ {

+ $sql = 'SELECT *

+ FROM phpbb_topics

+ WHERE ' . $this->db->sql_in_set('topic_title', $data['topics']);

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

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

+ {

+ if (in_array($row['topic_title'], $data['topics']))

+ {

+ $this->data['topics'][$row['topic_title']] = (int) $row['topic_id'];

+ }

+ }

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

+ }

+

+ if (!empty($data['posts']))

+ {

+ $sql = 'SELECT *

+ FROM phpbb_posts

+ WHERE ' . $this->db->sql_in_set('post_subject', $data['posts']);

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

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

+ {

+ if (in_array($row['post_subject'], $data['posts']))

+ {

+ $this->data['posts'][$row['post_subject']] = (int) $row['post_id'];

+ }

+ }

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

+ }

+ }

+}

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2013 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_admin.php';

+

+/**

+* @group slow

+*/

+class phpbb_functions_get_remote_file extends phpbb_test_case

+{

+ public function test_version_phpbb_com()

+ {

+ $hostname = 'version.phpbb.com';

+

+ if (!phpbb_checkdnsrr($hostname, 'A'))

+ {

+ $this->markTestSkipped(sprintf(

+ 'Could not find a DNS record for hostname %s. ' .

+ 'Assuming network is down.',

+ $hostname

+ ));

+ }

+

+ $errstr = $errno = null;

+ $file = get_remote_file($hostname, '/phpbb', '30x.txt', $errstr, $errno);

+

+ $this->assertNotEquals(

+ 0,

+ strlen($file),

+ 'Failed asserting that the response is not empty.'

+ );

+

+ $this->assertSame(

+ '',

+ $errstr,

+ 'Failed asserting that the error string is empty.'

+ );

+

+ $this->assertSame(

+ 0,

+ $errno,

+ 'Failed asserting that the error number is 0 (i.e. no error occurred).'

+ );

+

+ $lines = explode("\n", $file);

+

+ $this->assertGreaterThanOrEqual(

+ 2,

+ sizeof($lines),

+ 'Failed asserting that the version file has at least two lines.'

+ );

+

+ $this->assertStringStartsWith(

+ '3.',

+ $lines[0],

+ "Failed asserting that the first line of the version file starts with '3.'"

+ );

+

+ $this->assertNotSame(

+ false,

+ filter_var($lines[1], FILTER_VALIDATE_URL),

+ 'Failed asserting that the second line of the version file is a valid URL.'

+ );

+

+ $this->assertContains('http', $lines[1]);

+ $this->assertContains('phpbb.com', $lines[1], '', true);

+ }

+}

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+/**

+*/

+class phpbb_mock_search

+{

+

+ public function __construct($error, $phpbb_root_path, $phpEx, $auth, $config, $db, $user)

+ {

+ }

+

+ public function index_remove($post_ids, $poster_ids, $forum_ids)

+ {

+ }

+}

+

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+class phpbb_mock_sql_insert_buffer extends phpbb_db_sql_insert_buffer

+{

+ public function flush()

+ {

+ return (sizeof($this->buffer)) ? true : false;

+ }

+

+ public function get_buffer()

+ {

+ return $this->buffer;

+ }

+}

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+require_once dirname(__FILE__) . '/../mock/sql_insert_buffer.php';

+

+class phpbb_notification_convert_test extends phpbb_database_test_case

+{

+ protected $notifications, $db, $container, $user, $config, $auth, $cache;

+

+ public function getDataSet()

+ {

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

+ }

+

+ protected function setUp()

+ {

+ parent::setUp();

+

+ global $phpbb_root_path, $phpEx;

+

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

+

+ $this->migration = new phpbb_db_migration_data_310_notification_options_reconvert(

+ new phpbb_config(array()),

+ $this->db,

+ new phpbb_db_tools($this->db),

+ $phpbb_root_path,

+ $phpEx,

+ 'phpbb_'

+ );

+ }

+

+ public function test_convert()

+ {

+ $buffer = new phpbb_mock_sql_insert_buffer($this->db, 'phpbb_user_notifications');

+ $this->migration->perform_conversion($buffer, 'phpbb_user_notifications');

+

+ $expected = array_merge(

+ $this->create_expected('post', 1, 'email'),

+ $this->create_expected('topic', 1, 'email'),

+

+ $this->create_expected('post', 2, 'email'),

+ $this->create_expected('topic', 2, 'email'),

+ $this->create_expected('pm', 2, 'email'),

+

+ $this->create_expected('post', 3, 'jabber'),

+ $this->create_expected('topic', 3, 'jabber'),

+

+ $this->create_expected('post', 4, 'jabber'),

+ $this->create_expected('topic', 4, 'jabber'),

+ $this->create_expected('pm', 4, 'jabber'),

+

+ $this->create_expected('post', 5, 'both'),

+ $this->create_expected('topic', 5, 'both'),

+

+ $this->create_expected('post', 6, 'both'),

+ $this->create_expected('topic', 6, 'both'),

+ $this->create_expected('pm', 6, 'both')

+ );

+

+ $this->assertEquals($expected, $buffer->get_buffer());

+ }

+

+ protected function create_expected($type, $user_id, $method = '')

+ {

+ $return = array();

+

+ if ($method !== '')

+ {

+ $return[] = array(

+ 'item_type' => $type,

+ 'item_id' => 0,

+ 'user_id' => $user_id,

+ 'method' => '',

+ 'notify' => 1,

+ );

+ }

+

+ if ($method === 'email' || $method === 'both')

+ {

+ $return[] = array(

+ 'item_type' => $type,

+ 'item_id' => 0,

+ 'user_id' => $user_id,

+ 'method' => 'email',

+ 'notify' => 1,

+ );

+ }

+

+ if ($method === 'jabber' || $method === 'both')

+ {

+ $return[] = array(

+ 'item_type' => $type,

+ 'item_id' => 0,

+ 'user_id' => $user_id,

+ 'method' => 'jabber',

+ 'notify' => 1,

+ );

+ }

+

+ return $return;

+ }

+}

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

+<dataset>

+ <table name="phpbb_users">

+ <column>user_id</column>

+ <column>username</column>

+ <column>username_clean</column>

+ <column>user_notify_type</column>

+ <column>user_notify_pm</column>

+ <column>user_permissions</column>

+ <column>user_sig</column>

+ <column>user_occ</column>

+ <column>user_interests</column>

+ <row>

+ <value>1</value>

+ <value>1</value>

+ <value>1</value>

+ <value>0</value>

+ <value>0</value>

+ <value></value>

+ <value></value>

+ <value></value>

+ <value></value>

+ </row>

+ <row>

+ <value>2</value>

+ <value>2</value>

+ <value>2</value>

+ <value>0</value>

+ <value>1</value>

+ <value></value>

+ <value></value>

+ <value></value>

+ <value></value>

+ </row>

+ <row>

+ <value>3</value>

+ <value>3</value>

+ <value>3</value>

+ <value>1</value>

+ <value>0</value>

+ <value></value>

+ <value></value>

+ <value></value>

+ <value></value>

+ </row>

+ <row>

+ <value>4</value>

+ <value>4</value>

+ <value>4</value>

+ <value>1</value>

+ <value>1</value>

+ <value></value>

+ <value></value>

+ <value></value>

+ <value></value>

+ </row>

+ <row>

+ <value>5</value>

+ <value>5</value>

+ <value>5</value>

+ <value>2</value>

+ <value>0</value>

+ <value></value>

+ <value></value>

+ <value></value>

+ <value></value>

+ </row>

+ <row>

+ <value>6</value>

+ <value>6</value>

+ <value>6</value>

+ <value>2</value>

+ <value>1</value>

+ <value></value>

+ <value></value>

+ <value></value>

+ <value></value>

+ </row>

+ </table>

+</dataset>

+ $phpbb_container->set('content.visibility', new phpbb_content_visibility($auth, $db, $user, $phpbb_root_path, $phpEx, FORUMS_TABLE, POSTS_TABLE, TOPICS_TABLE, USERS_TABLE));

+ $this->run_template('includephp_relative.html', array(), array(), array(), "Path is relative to board root.\ntesting included php");

+ $this->run_template('includephp_variables.html', array('TEMPLATES' => 'templates'), array(), array(), "Path includes variables.\ntesting included php");

+ global $phpbb_root_path;

+

+ $path_to_php = str_replace('\\', '/', dirname(__FILE__)) . '/templates/_dummy_include.php.inc';

+ $cache_dir = $phpbb_root_path . 'cache/';

+ $this->run_template('includephp_absolute.html', array(), array(), array(), "Path is absolute.\ntesting included php");

+ $this->run_template('includephp_relative.html', array(), array(), array(), "Path is relative to board root.\ntesting included php");

+'Kappa test event in silver

+Omega test event in silver

+Zeta test event in all',

+'Kappa test event in silver_inherit

+Omega test event in silver

+Zeta test event in all',

+ $this->run_template($file, $vars, $block_vars, $destroy, $expected);

+ $this->template = new phpbb_template_twig($phpbb_root_path, $phpEx, $config, $user, new phpbb_template_context, $this->extension_manager);

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

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

+

+class phpbb_template_template_includecss_test extends phpbb_template_template_test_case_with_tree

+{

+ public function test_includecss_compilation()

+ {

+ // Reset the engine state

+ $this->setup_engine(array('assets_version' => 1));

+

+ // Prepare correct result

+ $scripts = array(

+ '<link href="' . $this->test_path . '/templates/child_only.css?assets_version=1" rel="stylesheet" type="text/css" media="screen, projection" />',

+ '<link href="' . $this->test_path . '/parent_templates/parent_only.css?assets_version=1" rel="stylesheet" type="text/css" media="screen, projection" />',

+ );

+

+ // Run test

+ $this->run_template('includecss.html', array(), array(), array(), implode('', $scripts));

+ }

+}

+ public function template_data()

+ {

+ return array(

+ /*

+ array(

+ // vars

+ // expected

+ ),

+ */

+ array(

+ array('TEST' => 1),

+ '<script type="text/javascript" src="' . $this->test_path . '/templates/parent_and_child.js?assets_version=1"></script>',

+ ),

+ array(

+ array('TEST' => 2),

+ '<script type="text/javascript" src="' . $this->test_path . '/templates/parent_and_child.js?assets_version=0"></script>',

+ ),

+ array(

+ array('TEST' => 3),

+ '<script type="text/javascript" src="' . $this->test_path . '/templates/parent_and_child.js?test=1&assets_version=0"></script>',

+ ),

+ array(

+ array('TEST' => 4),

+ '<script type="text/javascript" src="' . $this->test_path . '/templates/parent_and_child.js?test=1&amp;assets_version=0"></script>',

+ ),

+ array(

+ array('TEST' => 6),

+ '<script type="text/javascript" src="' . $this->test_path . '/parent_templates/parent_only.js?assets_version=1"></script>',

+ ),

+ array(

+ array('TEST' => 7),

+ '<script type="text/javascript" src="' . $this->test_path . '/templates/child_only.js?assets_version=1"></script>',

+ ),

+ array(

+ array('TEST' => 8),

+ '<script type="text/javascript" src="' . $this->test_path . '/templates/subdir/parent_only.js?assets_version=1"></script>',

+ ),

+ array(

+ array('TEST' => 9),

+ '<script type="text/javascript" src="' . $this->test_path . '/templates/subdir/subsubdir/parent_only.js?assets_version=1"></script>',

+ ),

+ array(

+ array('TEST' => 10),

+ '<script type="text/javascript" src="' . $this->test_path . '/templates/subdir/parent_only.js?assets_version=1"></script>',

+ ),

+ array(

+ array('TEST' => 11),

+ '<script type="text/javascript" src="' . $this->test_path . '/templates/child_only.js?test1=1&amp;test2=2&amp;assets_version=1#test3"></script>',

+ ),

+ array(

+ array('TEST' => 12),

+ '<script type="text/javascript" src="' . $this->test_path . '/parent_templates/parent_only.js?test1=1&amp;test2=2&amp;assets_version=1#test3"></script>',

+ ),

+ array(

+ array('TEST' => 14),

+ '<script type="text/javascript" src="' . $this->test_path . '/parent_templates/parent_only.js?test1=&quot;&amp;assets_version=1#test3"></script>',

+ ),

+ array(

+ array('TEST' => 15),

+ '<script type="text/javascript" src="http://phpbb.com/b.js?c=d#f"></script>',

+ ),

+ array(

+ array('TEST' => 16),

+ '<script type="text/javascript" src="http://phpbb.com/b.js?c=d&assets_version=2#f"></script>',

+ ),

+ array(

+ array('TEST' => 17),

+ '<script type="text/javascript" src="//phpbb.com/b.js"></script>',

+ ),

+ array(

+ array('TEST' => 18),

+ '<script type="text/javascript" src="' . $this->test_path . '/templates/parent_and_child.js?test=1&test2=0&amp;assets_version=1"></script>',

+ ),

+ );

+ }

+

+ /**

+ * @dataProvider template_data

+ */

+ public function test_includejs_compilation($vars, $expected)

+ $this->template->assign_vars($vars);

+ $this->run_template('includejs.html', array_merge(array('PARENT' => 'parent_only.js', 'SUBDIR' => 'subdir', 'EXT' => 'js'), $vars), array(), array(), $expected);

+ $this->run_template($file, $vars, $block_vars, $destroy, $expected);

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2013 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__) . '/template_test_case.php';

+

+class phpbb_template_template_parser_test extends phpbb_template_template_test_case

+{

+ public function test_set_filenames()

+ {

+ $this->template->set_filenames(array(

+ 'basic' => 'basic.html',

+ ));

+

+ $this->assertEquals("passpasspass<!-- DUMMY var -->", str_replace(array("\n", "\r", "\t"), '', $this->template->assign_display('basic')));

+

+ $this->template->set_filenames(array(

+ 'basic' => 'if.html',

+ ));

+

+ $this->assertEquals("03!false", str_replace(array("\n", "\r", "\t"), '', $this->template->assign_display('basic')));

+ }

+}

+ '03!false',

+ '1!false',

+ '1!false',

+ '2!false',

+ ),

+ array(

+ 'if.html',

+ array('S_TEST' => false),

+ array(),

+ array(),

+ '03false',

+ ),

+ array(

+ 'if.html',

+ array('S_TEST' => 0),

+ array(),

+ array(),

+ '03!false',

+ "first\n0 - a\nx - b\nset\n1 - a\ny - b\nset\nlast\n0 - c\n1 - c\nlast inner",

+ 'loop_nested2.html',

+ array('outer' => array(array(), array()), 'outer.middle' => array(array(), array())),

+ "o0o1m01m11",

+ 'define.html',

+ "xyz\nabc\nabc\nbar\nbar\nabc\ntest!@#$%^&*()_-=+{}[]:;\",<.>/?",

+ 'define_advanced.html',

+ array('loop' => array(array(), array(), array(), array(), array(), array(), array()), 'test' => array(array()), 'test.deep' => array(array()), 'test.deep.defines' => array(array())),

+ "abc\nzxc\ncde\nbcd",

+ "VARIABLE\n1_VARIABLE\nVARIABLE\n1_VARIABLE",

+ "Value'\n1 O'Clock\nValue\'\n1 O\'Clock",

+ array('VARIABLE' => "Value'", '1_VARIABLE' => "1 O'Clock"),

+ array(

+ 'twig.html',

+ array('VARIABLE' => 'FOObar',),

+ array(),

+ array(),

+ "13FOOBAR|foobar",

+ ),

+ $this->setExpectedException('Twig_Error_Loader');

+ $this->setExpectedException('Twig_Error_Loader');

+ public function test_template($file, array $vars, array $block_vars, array $destroy, $expected, $lang_vars = array())

+ $this->run_template($file, $vars, $block_vars, $destroy, $expected, $lang_vars);

+ public function test_assign_display()

+ $this->run_template('basic.html', array(), array(), array(), "pass\npass\npass\n<!-- DUMMY var -->");

+

+ 'test' => 'basic.html',

+ 'container' => 'variable.html',

+ $this->assertEquals("pass\npass\npass\n<!-- DUMMY var -->", $this->display('container'), "Testing assign_display($file)");

+

+

+ global $phpbb_root_path;

+ $template_text = '<!-- PHP -->echo "test";<!-- ENDPHP -->';

+ $cache_dir = $phpbb_root_path . 'cache/';

+ $fp = fopen($cache_dir . 'php.html', 'w');

+ fputs($fp, $template_text);

+ fclose($fp);

+ $this->setup_engine(array('tpl_allow_php' => true));

+

+ $this->style->set_custom_style('tests', $cache_dir, array(), '');

+

+ $this->run_template('php.html', array(), array(), array(), 'test');

+ $this->assertEquals("outer - 0middle - 0middle - 1outer - 1middle - 0middle - 1outer - 2middle - 0middle - 1", $this->display('test'), 'Ensuring template is built correctly before modification');

+ $this->assertEquals(str_replace(array("\n", "\r", "\t"), '', $expect), str_replace(array("\n", "\r", "\t"), '', $this->display('test')), $description);

+ public function test_more_alter_block_array()

+ {

+ $this->template->set_filenames(array('test' => 'loop_nested.html'));

+

+ $this->template->assign_var('TEST_MORE', true);

+

+ // @todo Change this

+ $this->template->assign_block_vars('outer', array());

+ $this->template->assign_block_vars('outer.middle', array());

+ $this->template->assign_block_vars('outer', array());

+ $this->template->assign_block_vars('outer.middle', array());

+ $this->template->assign_block_vars('outer.middle', array());

+ $this->template->assign_block_vars('outer', array());

+ $this->template->assign_block_vars('outer.middle', array());

+ $this->template->assign_block_vars('outer.middle', array());

+ $this->template->assign_block_vars('outer.middle', array());

+

+ $expect = 'outer - 0[outer|3]middle - 0[middle|1]outer - 1[outer|3]middle - 0[middle|2]middle - 1[middle|2]outer - 2[outer|3]middle - 0[middle|3]middle - 1[middle|3]middle - 2[middle|3]';

+ $this->assertEquals($expect, str_replace(array("\n", "\r", "\t"), '', $this->display('test')), 'Ensuring template is built correctly before modification');

+

+ $this->template->alter_block_array('outer', array());

+

+ $expect = 'outer - 0[outer|4]outer - 1[outer|4]middle - 0[middle|1]outer - 2[outer|4]middle - 0[middle|2]middle - 1[middle|2]outer - 3[outer|4]middle - 0[middle|3]middle - 1[middle|3]middle - 2[middle|3]';

+ $this->assertEquals($expect, str_replace(array("\n", "\r", "\t"), '', $this->display('test')), 'Ensuring S_NUM_ROWS is correct after insertion');

+

+ $this->template->alter_block_array('outer', array('VARIABLE' => 'test'), 2, 'change');

+

+ $expect = 'outer - 0[outer|4]outer - 1[outer|4]middle - 0[middle|1]outer - 2 - test[outer|4]middle - 0[middle|2]middle - 1[middle|2]outer - 3[outer|4]middle - 0[middle|3]middle - 1[middle|3]middle - 2[middle|3]';

+ $this->assertEquals($expect, str_replace(array("\n", "\r", "\t"), '', $this->display('test')), 'Ensuring S_NUM_ROWS is correct after modification');

+ }

+ protected $user;

+ $this->template->display($handle, false);

+ // reset output buffering even when an error occurred

+ global $phpbb_root_path, $phpEx;

+ $this->user = new phpbb_user;

+ $this->template = new phpbb_template_twig($phpbb_root_path, $phpEx, $config, $this->user, new phpbb_template_context());

+ $this->style = new phpbb_style($phpbb_root_path, $phpEx, $config, $this->user, $this->style_resource_locator, $this->style_provider, $this->template);

+ $this->template->clear_cache();

+ if ($this->template)

+ $this->template->clear_cache();

+ protected function run_template($file, array $vars, array $block_vars, array $destroy, $expected, $lang_vars = array())

+ // Previous functionality was $cachefile (string), which was removed, check to prevent errors

+ if (is_array($lang_vars))

+ foreach ($lang_vars as $name => $value)

+ $this->user->lang[$name] = $value;

+ $expected = str_replace(array("\n", "\r", "\t"), '', $expected);

+ $output = str_replace(array("\n", "\r", "\t"), '', $this->display('test'));

+ $this->assertEquals($expected, $output, "Testing $file");

+ $this->template = new phpbb_template_twig($phpbb_root_path, $phpEx, $config, $user, new phpbb_template_context());

+<!-- DEFINE $VALUE = 'test!@#$%^&*()_-=+{}[]:;",<.>/?' -->

+{$VALUE}

+

+<!-- IF S_TEST === false -->

+false

+<!-- ENDIF -->

+

+<!-- IF S_TEST !== false -->

+!false

+<!-- ENDIF -->

+<!-- INCLUDECSS child_only.css -->

+<!-- INCLUDECSS parent_only.css -->

+{$STYLESHEETS}

+<!-- IF TEST === 1 -->

+ <!-- INCLUDEJS parent_and_child.js -->

+<!-- ELSEIF TEST === 2 -->

+ <!-- INCLUDEJS parent_and_child.js?assets_version=0 -->

+<!-- ELSEIF TEST === 3 -->

+ <!-- INCLUDEJS parent_and_child.js?test=1&assets_version=0 -->

+<!-- ELSEIF TEST === 4 -->

+ <!-- INCLUDEJS parent_and_child.js?test=1&amp;assets_version=0 -->

+<!-- ELSEIF TEST === 6 -->

+ <!-- INCLUDEJS {PARENT} -->

+<!-- ELSEIF TEST === 7 -->

+ <!-- DEFINE $TEST = 'child_only.js' -->

+ <!-- INCLUDEJS {$TEST} -->

+<!-- ELSEIF TEST === 8 -->

+ <!-- INCLUDEJS subdir/{PARENT} -->

+<!-- ELSEIF TEST === 9 -->

+ <!-- INCLUDEJS {SUBDIR}/subsubdir/{PARENT} -->

+<!-- ELSEIF TEST === 10 -->

+ <!-- INCLUDEJS {SUBDIR}/parent_only.{EXT} -->

+<!-- ELSEIF TEST === 11 -->

+ <!-- DEFINE $TEST = 'child_only.js?test1=1&amp;test2=2#test3' -->

+ <!-- INCLUDEJS {$TEST} -->

+<!-- ELSEIF TEST === 12 -->

+ <!-- INCLUDEJS parent_only.js?test1=1&amp;test2=2#test3 -->

+<!-- ELSEIF TEST === 14 -->

+ <!-- INCLUDEJS parent_only.js?test1=&quot;#test3 -->

+<!-- ELSEIF TEST === 15 -->

+ <!-- INCLUDEJS http://phpbb.com/b.js?c=d#f -->

+<!-- ELSEIF TEST === 16 -->

+ <!-- INCLUDEJS http://phpbb.com/b.js?c=d&assets_version=2#f -->

+<!-- ELSEIF TEST === 17 -->

+ <!-- INCLUDEJS //phpbb.com/b.js -->

+<!-- ELSEIF TEST === 18 -->

+ <!-- INCLUDEJS parent_and_child.js?test=1&test2=0 -->

+<!-- ENDIF -->

+{$SCRIPTS}

+outer - {outer.S_ROW_COUNT}<!-- IF outer.VARIABLE --> - {outer.VARIABLE}<!-- ENDIF --><!-- IF TEST_MORE -->[{outer.S_BLOCK_NAME}|{outer.S_NUM_ROWS}]<!-- ENDIF -->

+<!-- BEGIN middle -->

+middle - {outer.middle.S_ROW_COUNT}<!-- IF outer.middle.VARIABLE --> - {outer.middle.VARIABLE}<!-- ENDIF --><!-- IF TEST_MORE -->[{outer.middle.S_BLOCK_NAME}|{outer.middle.S_NUM_ROWS}]<!-- ENDIF -->

+<!-- END middle -->

+<!-- BEGIN outer -->

+o{outer.S_ROW_COUNT}

+<!-- BEGIN middle -->

+m{outer.middle.S_ROW_COUNT}{outer.S_ROW_COUNT}

+<!-- END middle -->

+<!-- END outer -->

+<!-- END loop -->

+<!-- END _underscore_loop -->

+<!-- EXTENDS "twig_parent.html" -->

+

+<!-- BLOCK overwritten -->

+3{VARIABLE|upper}|{VARIABLE|lower}

+<!-- ENDBLOCK -->

+

+<!-- BLOCK notoverwritten -->

+1

+<!-- ENDBLOCK -->

+

+<!-- BLOCK overwritten -->

+2

+<!-- ENDBLOCK -->

+ * Creates a new style

+ *

+ * @param string $style_id Style ID

+ * @param string $style_path Style directory

+ * @param string $parent_style_id Parent style id. Default = 1

+ * @param string $parent_style_path Parent style directory. Default = 'prosilver'

+ */

+ protected function add_style($style_id, $style_path, $parent_style_id = 1, $parent_style_path = 'prosilver')

+ {

+ global $phpbb_root_path;

+

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

+ if (version_compare(PHPBB_VERSION, '3.1.0-dev', '<'))

+ {

+ $sql = 'INSERT INTO ' . STYLES_TABLE . ' ' . $db->sql_build_array('INSERT', array(

+ 'style_id' => $style_id,

+ 'style_name' => $style_path,

+ 'style_copyright' => '',

+ 'style_active' => 1,

+ 'template_id' => $style_id,

+ 'theme_id' => $style_id,

+ 'imageset_id' => $style_id,

+ ));

+ $db->sql_query($sql);

+

+ $sql = 'INSERT INTO ' . STYLES_IMAGESET_TABLE . ' ' . $db->sql_build_array('INSERT', array(

+ 'imageset_id' => $style_id,

+ 'imageset_name' => $style_path,

+ 'imageset_copyright' => '',

+ 'imageset_path' => $style_path,

+ ));

+ $db->sql_query($sql);

+

+ $sql = 'INSERT INTO ' . STYLES_TEMPLATE_TABLE . ' ' . $db->sql_build_array('INSERT', array(

+ 'template_id' => $style_id,

+ 'template_name' => $style_path,

+ 'template_copyright' => '',

+ 'template_path' => $style_path,

+ 'bbcode_bitfield' => 'kNg=',

+ 'template_inherits_id' => $parent_style_id,

+ 'template_inherit_path' => $parent_style_path,

+ ));

+ $db->sql_query($sql);

+

+ $sql = 'INSERT INTO ' . STYLES_THEME_TABLE . ' ' . $db->sql_build_array('INSERT', array(

+ 'theme_id' => $style_id,

+ 'theme_name' => $style_path,

+ 'theme_copyright' => '',

+ 'theme_path' => $style_path,

+ 'theme_storedb' => 0,

+ 'theme_mtime' => 0,

+ 'theme_data' => '',

+ ));

+ $db->sql_query($sql);

+

+ if ($style_path != 'prosilver' && $style_path != 'subsilver2')

+ {

+ @mkdir($phpbb_root_path . 'styles/' . $style_path, 0777);

+ @mkdir($phpbb_root_path . 'styles/' . $style_path . '/template', 0777);

+ }

+ }

+ else

+ {

+ $db->sql_multi_insert(STYLES_TABLE, array(

+ 'style_id' => $style_id,

+ 'style_name' => $style_path,

+ 'style_copyright' => '',

+ 'style_active' => 1,

+ 'style_path' => $style_path,

+ 'bbcode_bitfield' => 'kNg=',

+ 'style_parent_id' => $parent_style_id,

+ 'style_parent_tree' => $parent_style_path,

+ ));

+ }

+ }

+

+ /**

+ * Remove temporary style created by add_style()

+ *

+ * @param string $style_id Style ID

+ * @param string $style_path Style directory

+ */

+ protected function delete_style($style_id, $style_path)

+ {

+ global $phpbb_root_path;

+

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

+ $db->sql_query('DELETE FROM ' . STYLES_TABLE . ' WHERE style_id = ' . $style_id);

+ if (version_compare(PHPBB_VERSION, '3.1.0-dev', '<'))

+ {

+ $db->sql_query('DELETE FROM ' . STYLES_IMAGESET_TABLE . ' WHERE imageset_id = ' . $style_id);

+ $db->sql_query('DELETE FROM ' . STYLES_TEMPLATE_TABLE . ' WHERE template_id = ' . $style_id);

+ $db->sql_query('DELETE FROM ' . STYLES_THEME_TABLE . ' WHERE theme_id = ' . $style_id);

+

+ if ($style_path != 'prosilver' && $style_path != 'subsilver2')

+ {

+ @rmdir($phpbb_root_path . 'styles/' . $style_path . '/template');

+ @rmdir($phpbb_root_path . 'styles/' . $style_path);

+ }

+ }

+ }

+

+ /**

+ $this->assertNotContains($this->lang('LOGIN'), $crawler->filter('.navbar')->text());

+ $this->assertContains($this->lang('REGISTER'), $crawler->filter('.navbar')->text());

+ $this->assertContains($this->lang('ADMIN_PANEL'), $crawler->filter('h1')->text());

+ self::assertNotContains('[phpBB Debug]', $content);

+ * @param int $topic_id

+ 'topic_id' => $this->get_parameter_from_link($url, 't'),

+ 'post_id' => $this->get_parameter_from_link($url, 'p'),

+

+ /*

+ * Returns the requested parameter from a URL

+ *

+ * @param string $url

+ * @param string $parameter

+ * @return string Value of the parameter in the URL, null if not set

+ */

+ public function get_parameter_from_link($url, $parameter)

+ {

+ if (strpos($url, '?') === false)

+ {

+ return null;

+ }

+

+ $url_parts = explode('?', $url);

+ if (isset($url_parts[1]))

+ {

+ $url_parameters = $url_parts[1];

+ if (strpos($url_parameters, '#') !== false)

+ {

+ $url_parameters = explode('#', $url_parameters);

+ $url_parameters = $url_parameters[0];

+ }

+

+ foreach (explode('&', $url_parameters) as $url_param)

+ {

+ list($param, $value) = explode('=', $url_param);

+ if ($param == $parameter)

+ {

+ return $value;

+ }

+ }

+ }

+ return null;

+ }

+ // PHP bug #55124 (fixed in 5.4.0)

+ $path = str_replace('/./', '/', $path);

+

+require_once __DIR__ . '/../mock/filespec.php';