+<?php

+

+class phpbb_avatar_driver_barfoo extends phpbb_avatar_driver

+{

+ public function get_data($row)

+ {

+ return array();

+ }

+

+ public function prepare_form($request, $template, $user, $row, &$error)

+ {

+ return false;

+ }

+

+ public function process_form($request, $template, $user, $row, &$error)

+ {

+ return false;

+ }

+}

+<?php

+

+class phpbb_avatar_driver_foobar extends phpbb_avatar_driver

+{

+ public function get_data($row)

+ {

+ return array();

+ }

+

+ public function prepare_form($request, $template, $user, $row, &$error)

+ {

+ return false;

+ }

+

+ public function process_form($request, $template, $user, $row, &$error)

+ {

+ return false;

+ }

+}

+<?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__) . '/driver/foobar.php';

+

+class phpbb_avatar_manager_test extends PHPUnit_Framework_TestCase

+{

+ public function setUp()

+ {

+ global $phpbb_root_path, $phpEx;

+

+ // Mock phpbb_container

+ $this->phpbb_container = $this->getMock('Symfony\Component\DependencyInjection\ContainerInterface');

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

+ ->method('get')

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

+

+ // Prepare dependencies for avatar manager and driver

+ $config = new phpbb_config(array());

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

+ $cache = $this->getMock('phpbb_cache_driver_interface');

+

+ $this->avatar_foobar = $this->getMock('phpbb_avatar_driver_foobar', array('get_name'), array($config, $phpbb_root_path, $phpEx, $cache));

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

+ ->method('get_name')

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

+ $this->avatar_barfoo = $this->getMock('phpbb_avatar_driver_barfoo', array('get_name'));

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

+ ->method('get_name')

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

+

+ $avatar_drivers = array($this->avatar_foobar, $this->avatar_barfoo);

+

+ $config['allow_avatar_' . get_class($this->avatar_foobar)] = true;

+ $config['allow_avatar_' . get_class($this->avatar_barfoo)] = false;

+

+ // Set up avatar manager

+ $this->manager = new phpbb_avatar_manager($config, $avatar_drivers, $this->phpbb_container);

+ }

+

+ public function test_get_driver()

+ {

+ $driver = $this->manager->get_driver('avatar.driver.foobar', false);

+ $this->assertEquals('avatar.driver.foobar', $driver);

+

+ $driver = $this->manager->get_driver('avatar.driver.foo_wrong', false);

+ $this->assertNull($driver);

+

+ $driver = $this->manager->get_driver('avatar.driver.foobar');

+ $this->assertEquals('avatar.driver.foobar', $driver);

+

+ $driver = $this->manager->get_driver('avatar.driver.foo_wrong');

+ $this->assertNull($driver);

+ }

+

+ public function test_get_all_drivers()

+ {

+ $drivers = $this->manager->get_all_drivers();

+ $this->assertArrayHasKey('avatar.driver.foobar', $drivers);

+ $this->assertArrayHasKey('avatar.driver.barfoo', $drivers);

+ $this->assertEquals('avatar.driver.foobar', $drivers['avatar.driver.foobar']);

+ $this->assertEquals('avatar.driver.barfoo', $drivers['avatar.driver.barfoo']);

+ }

+

+ public function test_get_enabled_drivers()

+ {

+ $drivers = $this->manager->get_enabled_drivers();

+ $this->assertArrayHasKey('avatar.driver.foobar', $drivers);

+ $this->assertArrayNotHasKey('avatar.driver.barfoo', $drivers);

+ $this->assertEquals('avatar.driver.foobar', $drivers['avatar.driver.foobar']);

+ }

+

+ public function test_get_avatar_settings()

+ {

+ $avatar_settings = $this->manager->get_avatar_settings($this->avatar_foobar);

+

+ $expected_settings = array(

+ 'allow_avatar_' . get_class($this->avatar_foobar) => array('lang' => 'ALLOW_' . strtoupper(get_class($this->avatar_foobar)), 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => false),

+ );

+

+ $this->assertEquals($expected_settings, $avatar_settings);

+ }

+

+ public function database_row_data()

+ {

+ return array(

+ array(

+ array(

+ 'user_avatar' => '',

+ 'user_avatar_type' => '',

+ 'user_avatar_width' => '',

+ 'user_avatar_height' => '',

+ ),

+ array(

+ 'avatar' => '',

+ 'avatar_type' => '',

+ 'avatar_width' => '',

+ 'avatar_height' => '',

+ ),

+ ),

+ array(

+ array(

+ 'group_avatar' => '',

+ 'group_avatar_type' => '',

+ 'group_avatar_width' => '',

+ 'group_avatar_height' => '',

+ ),

+ array(

+ 'avatar' => '',

+ 'avatar_type' => '',

+ 'avatar_width' => '',

+ 'avatar_height' => '',

+ ),

+ ),

+ array(

+ array(),

+ array(

+ 'avatar' => '',

+ 'avatar_type' => '',

+ 'avatar_width' => '',

+ 'avatar_height' => '',

+ ),

+ ),

+ array(

+ array(

+ 'foobar_avatar' => '',

+ 'foobar_avatar_type' => '',

+ 'foobar_avatar_width' => '',

+ 'foobar_avatar_height' => '',

+ ),

+ array(

+ 'foobar_avatar' => '',

+ 'foobar_avatar_type' => '',

+ 'foobar_avatar_width' => '',

+ 'foobar_avatar_height' => '',

+ ),

+ ),

+ );

+ }

+

+ /**

+ * @dataProvider database_row_data

+ */

+ public function test_clean_row(array $input, array $output)

+ {

+ $cleaned_row = array();

+

+ $cleaned_row = phpbb_avatar_manager::clean_row($input);

+ foreach ($output as $key => $null)

+ {

+ $this->assertArrayHasKey($key, $cleaned_row);

+ }

+ }

+}

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+class phpbb_config_db_text_test extends phpbb_database_test_case

+{

+ private $db;

+ private $config_text;

+

+ public function getDataSet()

+ {

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

+ }

+

+ public function setUp()

+ {

+ parent::setUp();

+

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

+ $this->config_text = new phpbb_config_db_text($this->db, 'phpbb_config_text');

+ }

+

+ public function test_get()

+ {

+ $this->assertSame('23', $this->config_text->get('foo'));

+ $this->assertSame('string-de-ding', $this->config_text->get('meh'));

+ }

+

+ public function test_get_nonexisting()

+ {

+ $this->assertNull($this->config_text->get('noooooo'));

+ }

+

+ public function test_set_new_get()

+ {

+ $this->config_text->set('barz', 'phpbb');

+ $this->assertSame('phpbb', $this->config_text->get('barz'));

+ }

+

+ public function test_set_replace_get()

+ {

+ $this->config_text->set('foo', '24');

+ $this->assertSame('24', $this->config_text->get('foo'));

+ }

+

+ public function test_set_get_long_string()

+ {

+ $expected = str_repeat('ABC', 10000);

+ $this->config_text->set('long', $expected);

+ $this->assertSame($expected, $this->config_text->get('long'));

+ }

+

+ public function test_delete_get()

+ {

+ $this->config_text->delete('foo');

+ $this->assertNull($this->config_text->get('foo'));

+

+ $this->assertSame('42', $this->config_text->get('bar'));

+ $this->assertSame('string-de-ding', $this->config_text->get('meh'));

+ }

+

+ public function test_get_array_empty()

+ {

+ $this->assertEmpty($this->config_text->get_array(array('key1', 'key2')));

+ }

+

+ public function test_get_array_subset()

+ {

+ $expected = array(

+ 'bar' => '42',

+ 'foo' => '23',

+ );

+

+ $actual = $this->config_text->get_array(array_keys($expected));

+ ksort($actual);

+

+ $this->assertSame($expected, $actual);

+ }

+

+ public function test_set_array_get_array_subset()

+ {

+ $set_array_param = array(

+ // New entry

+ 'baby' => 'phpBB',

+ // Entry update

+ 'bar' => '64',

+ );

+

+ $this->config_text->set_array($set_array_param);

+

+ $expected = array_merge($set_array_param, array(

+ 'foo' => '23',

+ ));

+

+ $actual = $this->config_text->get_array(array_keys($expected));

+ ksort($actual);

+

+ $this->assertSame($expected, $actual);

+ }

+

+ public function test_delete_array_get_remaining()

+ {

+ $this->config_text->delete_array(array('foo', 'bar'));

+

+ $this->assertNull($this->config_text->get('bar'));

+ $this->assertNull($this->config_text->get('foo'));

+

+ $this->assertSame('string-de-ding', $this->config_text->get('meh'));

+ }

+}

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

+<dataset>

+ <table name="phpbb_config_text">

+ <column>config_name</column>

+ <column>config_value</column>

+ <row>

+ <value>foo</value>

+ <value>23</value>

+ </row>

+ <row>

+ <value>bar</value>

+ <value>42</value>

+ </row>

+ <row>

+ <value>meh</value>

+ <value>string-de-ding</value>

+ </row>

+ </table>

+</dataset>

+

+ $this->migrator = new phpbb_db_migrator(

+ $this->config,

+ $this->db,

+ $this->db_tools,

+ 'phpbb_migrations',

+ dirname(__FILE__) . '/../../phpBB/',

+ 'php',

+ 'phpbb_',

+ $tools

+ );

+ $this->extension_manager = new phpbb_extension_manager(

+ new phpbb_mock_container_builder(),

+ $this->db,

+ $this->config,

+ $this->migrator,

+ 'phpbb_ext',

+ dirname(__FILE__) . '/../../phpBB/',

+ '.php',

+ null

+ );

+ global $phpbb_root_path, $phpEx, $skip_add_log, $db, $user, $phpbb_log;

+ $cache = new phpbb_mock_cache;

+ $phpbb_dispatcher = new phpbb_mock_event_dispatcher();

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

+ $phpbb_log = new phpbb_log($db, $user, $auth, $phpbb_dispatcher, $phpbb_root_path, 'adm/', $phpEx, LOG_TABLE);

+

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+class phpbb_dbal_sql_insert_buffer_test extends phpbb_database_test_case

+{

+ protected $db;

+ protected $buffer;

+

+ public function setUp()

+ {

+ parent::setUp();

+

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

+ $this->buffer = new phpbb_db_sql_insert_buffer($this->db, 'phpbb_config', 2);

+ $this->assert_config_count(2);

+ }

+

+ public function getDataSet()

+ {

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

+ }

+

+ public function test_multi_insert_disabled_insert_and_flush()

+ {

+ $this->db->multi_insert = false;

+ $this->assertTrue($this->buffer->insert($this->get_row(1)));

+ $this->assert_config_count(3);

+ $this->assertFalse($this->buffer->flush());

+ $this->assert_config_count(3);

+ }

+

+ public function test_multi_insert_enabled_insert_and_flush()

+ {

+ $this->check_multi_insert_support();

+ $this->assertFalse($this->buffer->insert($this->get_row(1)));

+ $this->assert_config_count(2);

+ $this->assertTrue($this->buffer->flush());

+ $this->assert_config_count(3);

+ }

+

+ public function test_multi_insert_disabled_insert_with_flush()

+ {

+ $this->db->multi_insert = false;

+ $this->assertTrue($this->buffer->insert($this->get_row(1)));

+ $this->assert_config_count(3);

+ $this->assertTrue($this->buffer->insert($this->get_row(2)));

+ $this->assert_config_count(4);

+ }

+

+ public function test_multi_insert_enabled_insert_with_flush()

+ {

+ $this->check_multi_insert_support();

+ $this->assertFalse($this->buffer->insert($this->get_row(1)));

+ $this->assert_config_count(2);

+ $this->assertTrue($this->buffer->insert($this->get_row(2)));

+ $this->assert_config_count(4);

+ }

+

+ public function test_multi_insert_disabled_insert_all_and_flush()

+ {

+ $this->db->multi_insert = false;

+ $this->assertTrue($this->buffer->insert_all($this->get_rows(3)));

+ $this->assert_config_count(5);

+ }

+

+ public function test_multi_insert_enabled_insert_all_and_flush()

+ {

+ $this->check_multi_insert_support();

+ $this->assertTrue($this->buffer->insert_all($this->get_rows(3)));

+ $this->assert_config_count(4);

+ $this->assertTrue($this->buffer->flush());

+ $this->assert_config_count(5);

+ }

+

+ protected function assert_config_count($num_configs)

+ {

+ $sql = 'SELECT COUNT(*) AS num_configs

+ FROM phpbb_config';

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

+ $this->assertEquals($num_configs, $this->db->sql_fetchfield('num_configs'));

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

+ }

+

+ protected function check_multi_insert_support()

+ {

+ if (!$this->db->multi_insert)

+ {

+ $this->markTestSkipped('Database does not support multi_insert');

+ }

+ }

+

+ protected function get_row($rownum)

+ {

+ return array(

+ 'config_name' => "name$rownum",

+ 'config_value' => "value$rownum",

+ 'is_dynamic' => '0',

+ );

+ }

+

+ protected function get_rows($n)

+ {

+ $result = array();

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

+ {

+ $result[] = $this->get_row($i);

+ }

+ return $result;

+ }

+}

+ /**

+ * These do not work because of changes with PHPBB3-11386

+ * They do not seem neccessary to me, so I am commenting them out for now

+ $finder = new phpbb_extension_finder(

+ $this->extension_manager,

+ dirname(__FILE__) . '/',

+ new phpbb_mock_cache(array(

+ '_ext_finder' => array(

+ md5(serialize($query)) => array('file_name' => 'extension'),

+ ),

+ ))

+ );

+ */

+ $this->extension_manager = $this->create_extension_manager();

+ $extension_manager = $this->create_extension_manager(false);

+ protected function create_extension_manager($with_cache = true)

+ {

+

+ $config = new phpbb_config(array());

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

+ $db_tools = new phpbb_db_tools($db);

+ $phpbb_root_path = __DIR__ . './../../phpBB/';

+ $php_ext = 'php';

+ $table_prefix = 'phpbb_';

+

+ $migrator = new phpbb_db_migrator(

+ $config,

+ $db,

+ $db_tools,

+ 'phpbb_migrations',

+ $phpbb_root_path,

+ $php_ext,

+ $table_prefix,

+ array()

+ );

+ return new phpbb_extension_manager(

+ new phpbb_mock_container_builder(),

+ $db,

+ $config,

+ $migrator,

+ 'phpbb_ext',

+ dirname(__FILE__) . '/',

+ '.' . $php_ext,

+ ($with_cache) ? new phpbb_mock_cache() : null

+ );

+ }

+ $this->db_tools = new phpbb_db_tools($this->db);

+ $this->table_prefix = 'phpbb_';

+ $this->migrator = new phpbb_db_migrator(

+ $this->config,

+ $this->db,

+ $this->db_tools,

+ 'phpbb_migrations',

+ $this->phpbb_root_path,

+ 'php',

+ $this->table_prefix,

+ array()

+ );

+ new phpbb_mock_container_builder(),

+ $this->migrator,

+<?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_notification_test extends phpbb_functional_test_case

+{

+ static public function user_subscription_data()

+ {

+ return array(

+ // Rows inserted by phpBB/install/schemas/schema_data.sql

+ // Also see PHPBB3-11460

+ array('post_notification', true),

+ array('topic_notification', true),

+ array('post_email', true),

+ array('topic_email', true),

+

+ // Default behaviour for in-board notifications:

+ // If user did not opt-out, in-board notifications are on.

+ array('bookmark_notification', true),

+ array('quote_notification', true),

+

+ // Default behaviour for email notifications:

+ // If user did not opt-in, email notifications are off.

+ array('bookmark_email', false),

+ array('quote_email', false),

+ );

+ }

+

+ /**

+ * @dataProvider user_subscription_data

+ */

+ public function test_user_subscriptions($checkbox_name, $expected_status)

+ {

+ $this->login();

+ $crawler = $this->request('GET', 'ucp.php?i=ucp_notifications&mode=notification_options');

+ $this->assert_response_success();

+

+ $cplist = $crawler->filter('.cplist');

+ if ($expected_status)

+ {

+ $this->assert_checkbox_is_checked($cplist, $checkbox_name);

+ }

+ else

+ {

+ $this->assert_checkbox_is_unchecked($cplist, $checkbox_name);

+ }

+ }

+}

+ global $auth, $cache, $db, $phpbb_dispatcher, $user, $phpbb_container, $phpbb_log, $phpbb_root_path, $phpEx;

+ $phpbb_log = new phpbb_log($db, $user, $auth, $phpbb_dispatcher, $phpbb_root_path, 'adm/', $phpEx, LOG_TABLE);

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

+<dataset>

+ <table name="phpbb_groups">

+ <column>group_id</column>

+ <column>group_desc</column>

+ <row>

+ <value>1</value>

+ <value></value>

+ </row>

+ <row>

+ <value>2</value>

+ <value></value>

+ </row>

+ <row>

+ <value>3</value>

+ <value></value>

+ </row>

+ <row>

+ <value>4</value>

+ <value></value>

+ </row>

+ <row>

+ <value>5</value>

+ <value></value>

+ </row>

+ <row>

+ <value>6</value>

+ <value></value>

+ </row>

+ <row>

+ <value>7</value>

+ <value></value>

+ </row>

+ <row>

+ <value>8</value>

+ <value></value>

+ </row>

+ </table>

+ <table name="phpbb_teampage">

+ <column>teampage_id</column>

+ <column>group_id</column>

+ <column>teampage_name</column>

+ <column>teampage_position</column>

+ <column>teampage_parent</column>

+ <row>

+ <value>1</value>

+ <value>1</value>

+ <value></value>

+ <value>1</value>

+ <value>0</value>

+ </row>

+ <row>

+ <value>2</value>

+ <value>0</value>

+ <value>category - 2 children</value>

+ <value>2</value>

+ <value>0</value>

+ </row>

+ <row>

+ <value>3</value>

+ <value>2</value>

+ <value></value>

+ <value>3</value>

+ <value>2</value>

+ </row>

+ <row>

+ <value>4</value>

+ <value>3</value>

+ <value></value>

+ <value>4</value>

+ <value>2</value>

+ </row>

+ <row>

+ <value>5</value>

+ <value>0</value>

+ <value>category2 - 2 children</value>

+ <value>5</value>

+ <value>0</value>

+ </row>

+ <row>

+ <value>6</value>

+ <value>4</value>

+ <value></value>

+ <value>6</value>

+ <value>5</value>

+ </row>

+ <row>

+ <value>7</value>

+ <value>5</value>

+ <value></value>

+ <value>7</value>

+ <value>5</value>

+ </row>

+ <row>

+ <value>8</value>

+ <value>6</value>

+ <value></value>

+ <value>8</value>

+ <value>0</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_groupposition_legend_test extends phpbb_database_test_case

+{

+ public function getDataSet()

+ {

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

+ }

+

+ public function get_group_value_data()

+ {

+ return array(

+ array(1, 0, ''),

+ array(3, 2, ''),

+ array(4, 0, 'phpbb_groupposition_exception'),

+ );

+ }

+

+ /**

+ * @dataProvider get_group_value_data

+ */

+ public function test_get_group_value($group_id, $expected, $throws_exception)

+ {

+ global $cache;

+

+ $cache = new phpbb_mock_cache;

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

+ $user = new phpbb_user;

+ $user->lang = array();

+

+ if ($throws_exception)

+ {

+ $this->setExpectedException($throws_exception);

+ }

+

+ $test_class = new phpbb_groupposition_legend($db, $user);

+ $this->assertEquals($expected, $test_class->get_group_value($group_id));

+ }

+

+ public function test_get_group_count()

+ {

+ global $cache;

+

+ $cache = new phpbb_mock_cache;

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

+ $user = new phpbb_user;

+ $user->lang = array();

+

+ $test_class = new phpbb_groupposition_legend($db, $user);

+ $this->assertEquals(2, $test_class->get_group_count());

+ }

+

+ public function add_group_data()

+ {

+ return array(

+ array(

+ 1,

+ true,

+ array(

+ array('group_id' => 1, 'group_legend' => 3),

+ array('group_id' => 2, 'group_legend' => 1),

+ array('group_id' => 3, 'group_legend' => 2),

+ ),

+ ),

+ array(

+ 2,

+ false,

+ array(

+ array('group_id' => 1, 'group_legend' => 0),

+ array('group_id' => 2, 'group_legend' => 1),

+ array('group_id' => 3, 'group_legend' => 2),

+ ),

+ ),

+ );

+ }

+

+ /**

+ * @dataProvider add_group_data

+ */

+ public function test_add_group($group_id, $expected_added, $expected)

+ {

+ global $cache;

+

+ $cache = new phpbb_mock_cache;

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

+ $user = new phpbb_user;

+ $user->lang = array();

+

+ $test_class = new phpbb_groupposition_legend($db, $user);

+ $this->assertEquals($expected_added, $test_class->add_group($group_id));

+

+ $result = $db->sql_query('SELECT group_id, group_legend

+ FROM ' . GROUPS_TABLE . '

+ ORDER BY group_id ASC');

+

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

+ }

+

+ public function delete_group_data()

+ {

+ return array(

+ array(

+ 1,

+ false,

+ false,

+ array(

+ array('group_id' => 1, 'group_legend' => 0),

+ array('group_id' => 2, 'group_legend' => 1),

+ array('group_id' => 3, 'group_legend' => 2),

+ ),

+ ),

+ array(

+ 2,

+ false,

+ true,

+ array(

+ array('group_id' => 1, 'group_legend' => 0),

+ array('group_id' => 2, 'group_legend' => 0),

+ array('group_id' => 3, 'group_legend' => 1),

+ ),

+ ),

+ array(

+ 3,

+ false,

+ true,

+ array(

+ array('group_id' => 1, 'group_legend' => 0),

+ array('group_id' => 2, 'group_legend' => 1),

+ array('group_id' => 3, 'group_legend' => 0),

+ ),

+ ),

+ array(

+ 1,

+ true,

+ false,

+ array(

+ array('group_id' => 1, 'group_legend' => 0),

+ array('group_id' => 2, 'group_legend' => 1),

+ array('group_id' => 3, 'group_legend' => 2),

+ ),

+ ),

+ array(

+ 2,

+ true,

+ true,

+ array(

+ array('group_id' => 1, 'group_legend' => 0),

+ array('group_id' => 2, 'group_legend' => 1),

+ array('group_id' => 3, 'group_legend' => 1),

+ ),

+ ),

+ array(

+ 3,

+ true,

+ true,

+ array(

+ array('group_id' => 1, 'group_legend' => 0),

+ array('group_id' => 2, 'group_legend' => 1),

+ array('group_id' => 3, 'group_legend' => 2),

+ ),

+ ),

+ );

+ }

+

+ /**

+ * @dataProvider delete_group_data

+ */

+ public function test_delete_group($group_id, $skip_group, $expected_deleted, $expected)

+ {

+ global $cache;

+

+ $cache = new phpbb_mock_cache;

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

+ $user = new phpbb_user;

+ $user->lang = array();

+

+ $test_class = new phpbb_groupposition_legend($db, $user);

+ $this->assertEquals($expected_deleted, $test_class->delete_group($group_id, $skip_group));

+

+ $result = $db->sql_query('SELECT group_id, group_legend

+ FROM ' . GROUPS_TABLE . '

+ ORDER BY group_id ASC');

+

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

+ }

+

+ public function move_up_data()

+ {

+ return array(

+ array(

+ 1,

+ false,

+ array(

+ array('group_id' => 1, 'group_legend' => 0),

+ array('group_id' => 2, 'group_legend' => 1),

+ array('group_id' => 3, 'group_legend' => 2),

+ ),

+ ),

+ array(

+ 2,

+ false,

+ array(

+ array('group_id' => 1, 'group_legend' => 0),

+ array('group_id' => 2, 'group_legend' => 1),

+ array('group_id' => 3, 'group_legend' => 2),

+ ),

+ ),

+ array(

+ 3,

+ true,

+ array(

+ array('group_id' => 1, 'group_legend' => 0),

+ array('group_id' => 2, 'group_legend' => 2),

+ array('group_id' => 3, 'group_legend' => 1),

+ ),

+ ),

+ );

+ }

+

+ /**

+ * @dataProvider move_up_data

+ */

+ public function test_move_up($group_id, $excepted_moved, $expected)

+ {

+ global $cache;

+

+ $cache = new phpbb_mock_cache;

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

+ $user = new phpbb_user;

+ $user->lang = array();

+

+ $test_class = new phpbb_groupposition_legend($db, $user);

+ $this->assertEquals($excepted_moved, $test_class->move_up($group_id));

+

+ $result = $db->sql_query('SELECT group_id, group_legend

+ FROM ' . GROUPS_TABLE . '

+ ORDER BY group_id ASC');

+

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

+ }

+

+ public function move_down_data()

+ {

+ return array(

+ array(

+ 1,

+ false,

+ array(

+ array('group_id' => 1, 'group_legend' => 0),

+ array('group_id' => 2, 'group_legend' => 1),

+ array('group_id' => 3, 'group_legend' => 2),

+ ),

+ ),

+ array(

+ 2,

+ true,

+ array(

+ array('group_id' => 1, 'group_legend' => 0),

+ array('group_id' => 2, 'group_legend' => 2),

+ array('group_id' => 3, 'group_legend' => 1),

+ ),

+ ),

+ array(

+ 3,

+ false,

+ array(

+ array('group_id' => 1, 'group_legend' => 0),

+ array('group_id' => 2, 'group_legend' => 1),

+ array('group_id' => 3, 'group_legend' => 2),

+ ),

+ ),

+ );

+ }

+

+ /**

+ * @dataProvider move_down_data

+ */

+ public function test_move_down($group_id, $excepted_moved, $expected)

+ {

+ global $cache;

+

+ $cache = new phpbb_mock_cache;

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

+ $user = new phpbb_user;

+ $user->lang = array();

+

+ $test_class = new phpbb_groupposition_legend($db, $user);

+ $this->assertEquals($excepted_moved, $test_class->move_down($group_id));

+

+ $result = $db->sql_query('SELECT group_id, group_legend

+ FROM ' . GROUPS_TABLE . '

+ ORDER BY group_id ASC');

+

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

+ }

+

+ public function move_data()

+ {

+ return array(

+ array(

+ 1,

+ 1,

+ false,

+ array(

+ array('group_id' => 1, 'group_legend' => 0),

+ array('group_id' => 2, 'group_legend' => 1),

+ array('group_id' => 3, 'group_legend' => 2),

+ ),

+ ),

+ array(

+ 1,

+ -1,

+ false,

+ array(

+ array('group_id' => 1, 'group_legend' => 0),

+ array('group_id' => 2, 'group_legend' => 1),

+ array('group_id' => 3, 'group_legend' => 2),

+ ),

+ ),

+ array(

+ 3,

+ 3,

+ true,

+ array(

+ array('group_id' => 1, 'group_legend' => 0),

+ array('group_id' => 2, 'group_legend' => 2),

+ array('group_id' => 3, 'group_legend' => 1),

+ ),

+ ),

+ array(

+ 2,

+ 0,

+ false,

+ array(

+ array('group_id' => 1, 'group_legend' => 0),

+ array('group_id' => 2, 'group_legend' => 1),

+ array('group_id' => 3, 'group_legend' => 2),

+ ),

+ ),

+ array(

+ 2,

+ -1,

+ true,

+ array(

+ array('group_id' => 1, 'group_legend' => 0),

+ array('group_id' => 2, 'group_legend' => 2),

+ array('group_id' => 3, 'group_legend' => 1),

+ ),

+ ),

+ array(

+ 2,

+ -3,

+ true,

+ array(

+ array('group_id' => 1, 'group_legend' => 0),

+ array('group_id' => 2, 'group_legend' => 2),

+ array('group_id' => 3, 'group_legend' => 1),

+ ),

+ ),

+ array(

+ 3,

+ -1,

+ false,

+ array(

+ array('group_id' => 1, 'group_legend' => 0),

+ array('group_id' => 2, 'group_legend' => 1),

+ array('group_id' => 3, 'group_legend' => 2),

+ ),

+ ),

+ );

+ }

+

+ /**

+ * @dataProvider move_data

+ */

+ public function test_move($group_id, $increment, $excepted_moved, $expected)

+ {

+ global $cache;

+

+ $cache = new phpbb_mock_cache;

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

+ $user = new phpbb_user;

+ $user->lang = array();

+

+ $test_class = new phpbb_groupposition_legend($db, $user);

+ $this->assertEquals($excepted_moved, $test_class->move($group_id, $increment));

+

+ $result = $db->sql_query('SELECT group_id, group_legend

+ FROM ' . GROUPS_TABLE . '

+ ORDER BY group_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/utf/utf_tools.php';

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

+

+class phpbb_groupposition_teampage_test extends phpbb_database_test_case

+{

+ public function getDataSet()

+ {

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

+ }

+

+ public function get_group_value_data()

+ {

+ return array(

+ array(2, 3, ''),

+ array(6, 8, ''),

+ array(10, 0, 'phpbb_groupposition_exception'),

+ );

+ }

+

+ /**

+ * @dataProvider get_group_value_data

+ */

+ public function test_get_group_value($group_id, $expected, $throws_exception)

+ {

+ global $cache;

+

+ $cache = new phpbb_mock_cache;

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

+ $user = new phpbb_user;

+ $user->lang = array();

+

+ if ($throws_exception)

+ {

+ $this->setExpectedException($throws_exception);

+ }

+

+ $test_class = new phpbb_groupposition_teampage($db, $user, $cache);

+ $this->assertEquals($expected, $test_class->get_group_value($group_id));

+ }

+

+ public function test_get_group_count()

+ {

+ global $cache;

+

+ $cache = new phpbb_mock_cache;

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

+ $user = new phpbb_user;

+ $user->lang = array();

+

+ $test_class = new phpbb_groupposition_teampage($db, $user, $cache);

+ $this->assertEquals(8, $test_class->get_group_count());

+ }

+

+ public function add_group_teampage_data()

+ {

+ return array(

+ array(

+ 1,

+ 2,

+ false,

+ array(

+ array('teampage_position' => 1, 'group_id' => 1, 'teampage_parent' => 0, 'teampage_name' => ''),

+ array('teampage_position' => 2, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category - 2 children'),

+ array('teampage_position' => 3, 'group_id' => 2, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 4, 'group_id' => 3, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 5, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category2 - 2 children'),

+ array('teampage_position' => 6, 'group_id' => 4, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 7, 'group_id' => 5, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 8, 'group_id' => 6, 'teampage_parent' => 0, 'teampage_name' => ''),

+ ),

+ ),

+ array(

+ 6,

+ 2,

+ false,

+ array(

+ array('teampage_position' => 1, 'group_id' => 1, 'teampage_parent' => 0, 'teampage_name' => ''),

+ array('teampage_position' => 2, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category - 2 children'),

+ array('teampage_position' => 3, 'group_id' => 2, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 4, 'group_id' => 3, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 5, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category2 - 2 children'),

+ array('teampage_position' => 6, 'group_id' => 4, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 7, 'group_id' => 5, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 8, 'group_id' => 6, 'teampage_parent' => 0, 'teampage_name' => ''),

+ ),

+ ),

+ array(

+ 7,

+ 2,

+ true,

+ array(

+ array('teampage_position' => 1, 'group_id' => 1, 'teampage_parent' => 0, 'teampage_name' => ''),

+ array('teampage_position' => 2, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category - 2 children'),

+ array('teampage_position' => 3, 'group_id' => 2, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 4, 'group_id' => 3, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 5, 'group_id' => 7, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 6, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category2 - 2 children'),

+ array('teampage_position' => 7, 'group_id' => 4, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 8, 'group_id' => 5, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 9, 'group_id' => 6, 'teampage_parent' => 0, 'teampage_name' => ''),

+ ),

+ ),

+ array(

+ 7,

+ 0,

+ true,

+ array(

+ array('teampage_position' => 1, 'group_id' => 1, 'teampage_parent' => 0, 'teampage_name' => ''),

+ array('teampage_position' => 2, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category - 2 children'),

+ array('teampage_position' => 3, 'group_id' => 2, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 4, 'group_id' => 3, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 5, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category2 - 2 children'),

+ array('teampage_position' => 6, 'group_id' => 4, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 7, 'group_id' => 5, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 8, 'group_id' => 6, 'teampage_parent' => 0, 'teampage_name' => ''),

+ array('teampage_position' => 9, 'group_id' => 7, 'teampage_parent' => 0, 'teampage_name' => ''),

+ ),

+ ),

+ );

+ }

+

+ /**

+ * @dataProvider add_group_teampage_data

+ */

+ public function test_add_group_teampage($group_id, $parent_id, $expected_added, $expected)

+ {

+ global $cache;

+

+ $cache = new phpbb_mock_cache;

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

+ $user = new phpbb_user;

+ $user->lang = array();

+

+ $test_class = new phpbb_groupposition_teampage($db, $user, $cache);

+ $this->assertEquals($expected_added, $test_class->add_group_teampage($group_id, $parent_id));

+

+ $result = $db->sql_query('SELECT teampage_position, group_id, teampage_parent, teampage_name

+ FROM ' . TEAMPAGE_TABLE . '

+ ORDER BY teampage_position ASC');

+

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

+ }

+

+ public function add_category_teampage_data()

+ {

+ return array(

+ array(

+ 'new',

+ true,

+ array(

+ array('teampage_position' => 1, 'group_id' => 1, 'teampage_parent' => 0, 'teampage_name' => ''),

+ array('teampage_position' => 2, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category - 2 children'),

+ array('teampage_position' => 3, 'group_id' => 2, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 4, 'group_id' => 3, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 5, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category2 - 2 children'),

+ array('teampage_position' => 6, 'group_id' => 4, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 7, 'group_id' => 5, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 8, 'group_id' => 6, 'teampage_parent' => 0, 'teampage_name' => ''),

+ array('teampage_position' => 9, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'new'),

+ ),

+ ),

+ );

+ }

+

+ /**

+ * @dataProvider add_category_teampage_data

+ */

+ public function test_add_category_teampage($group_name, $expected_added, $expected)

+ {

+ global $cache;

+

+ $cache = new phpbb_mock_cache;

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

+ $user = new phpbb_user;

+ $user->lang = array();

+

+ $test_class = new phpbb_groupposition_teampage($db, $user, $cache);

+ $this->assertEquals($expected_added, $test_class->add_category_teampage($group_name));

+

+ $result = $db->sql_query('SELECT teampage_position, group_id, teampage_parent, teampage_name

+ FROM ' . TEAMPAGE_TABLE . '

+ ORDER BY teampage_position ASC');

+

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

+ }

+

+ public function delete_group_data()

+ {

+ return array(

+ array(

+ 1,

+ true,

+ array(

+ array('teampage_position' => 1, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category - 2 children'),

+ array('teampage_position' => 2, 'group_id' => 2, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 3, 'group_id' => 3, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 4, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category2 - 2 children'),

+ array('teampage_position' => 5, 'group_id' => 4, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 6, 'group_id' => 5, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 7, 'group_id' => 6, 'teampage_parent' => 0, 'teampage_name' => ''),

+ ),

+ ),

+ array(

+ 2,

+ true,

+ array(

+ array('teampage_position' => 1, 'group_id' => 1, 'teampage_parent' => 0, 'teampage_name' => ''),

+ array('teampage_position' => 2, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category - 2 children'),

+ array('teampage_position' => 3, 'group_id' => 3, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 4, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category2 - 2 children'),

+ array('teampage_position' => 5, 'group_id' => 4, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 6, 'group_id' => 5, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 7, 'group_id' => 6, 'teampage_parent' => 0, 'teampage_name' => ''),

+ ),

+ ),

+ array(

+ 6,

+ true,

+ array(

+ array('teampage_position' => 1, 'group_id' => 1, 'teampage_parent' => 0, 'teampage_name' => ''),

+ array('teampage_position' => 2, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category - 2 children'),

+ array('teampage_position' => 3, 'group_id' => 2, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 4, 'group_id' => 3, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 5, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category2 - 2 children'),

+ array('teampage_position' => 6, 'group_id' => 4, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 7, 'group_id' => 5, 'teampage_parent' => 5, 'teampage_name' => ''),

+ ),

+ ),

+ );

+ }

+

+ /**

+ * @dataProvider delete_group_data

+ */

+ public function test_delete_group($group_id, $expected_deleted, $expected)

+ {

+ global $cache;

+

+ $cache = new phpbb_mock_cache;

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

+ $user = new phpbb_user;

+ $user->lang = array();

+

+ $test_class = new phpbb_groupposition_teampage($db, $user, $cache);

+ $this->assertEquals($expected_deleted, $test_class->delete_group($group_id, false));

+

+ $result = $db->sql_query('SELECT teampage_position, group_id, teampage_parent, teampage_name

+ FROM ' . TEAMPAGE_TABLE . '

+ ORDER BY teampage_position ASC');

+

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

+ }

+

+ public function delete_teampage_data()

+ {

+ return array(

+ array(

+ 1,

+ true,

+ array(

+ array('teampage_position' => 1, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category - 2 children'),

+ array('teampage_position' => 2, 'group_id' => 2, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 3, 'group_id' => 3, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 4, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category2 - 2 children'),

+ array('teampage_position' => 5, 'group_id' => 4, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 6, 'group_id' => 5, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 7, 'group_id' => 6, 'teampage_parent' => 0, 'teampage_name' => ''),

+ ),

+ ),

+ array(

+ 2,

+ true,

+ array(

+ array('teampage_position' => 1, 'group_id' => 1, 'teampage_parent' => 0, 'teampage_name' => ''),

+ array('teampage_position' => 2, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category2 - 2 children'),

+ array('teampage_position' => 3, 'group_id' => 4, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 4, 'group_id' => 5, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 5, 'group_id' => 6, 'teampage_parent' => 0, 'teampage_name' => ''),

+ ),

+ ),

+ );

+ }

+

+ /**

+ * @dataProvider delete_teampage_data

+ */

+ public function test_delete_teampage($teampage_id, $expected_deleted, $expected)

+ {

+ global $cache;

+

+ $cache = new phpbb_mock_cache;

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

+ $user = new phpbb_user;

+ $user->lang = array();

+

+ $test_class = new phpbb_groupposition_teampage($db, $user, $cache);

+ $this->assertEquals($expected_deleted, $test_class->delete_teampage($teampage_id, false));

+

+ $result = $db->sql_query('SELECT teampage_position, group_id, teampage_parent, teampage_name

+ FROM ' . TEAMPAGE_TABLE . '

+ ORDER BY teampage_position ASC');

+

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

+ }

+

+ public function move_data()

+ {

+ return array(

+ array(

+ 1,

+ 1,

+ false,

+ array(

+ array('teampage_position' => 1, 'group_id' => 1, 'teampage_parent' => 0, 'teampage_name' => ''),

+ array('teampage_position' => 2, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category - 2 children'),

+ array('teampage_position' => 3, 'group_id' => 2, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 4, 'group_id' => 3, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 5, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category2 - 2 children'),

+ array('teampage_position' => 6, 'group_id' => 4, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 7, 'group_id' => 5, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 8, 'group_id' => 6, 'teampage_parent' => 0, 'teampage_name' => ''),

+ ),

+ ),

+ array(

+ 2,

+ 1,

+ false,

+ array(

+ array('teampage_position' => 1, 'group_id' => 1, 'teampage_parent' => 0, 'teampage_name' => ''),

+ array('teampage_position' => 2, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category - 2 children'),

+ array('teampage_position' => 3, 'group_id' => 2, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 4, 'group_id' => 3, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 5, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category2 - 2 children'),

+ array('teampage_position' => 6, 'group_id' => 4, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 7, 'group_id' => 5, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 8, 'group_id' => 6, 'teampage_parent' => 0, 'teampage_name' => ''),

+ ),

+ ),

+ array(

+ 5,

+ 1,

+ true,

+ array(

+ array('teampage_position' => 1, 'group_id' => 1, 'teampage_parent' => 0, 'teampage_name' => ''),

+ array('teampage_position' => 2, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category - 2 children'),

+ array('teampage_position' => 3, 'group_id' => 2, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 4, 'group_id' => 3, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 5, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category2 - 2 children'),

+ array('teampage_position' => 6, 'group_id' => 5, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 7, 'group_id' => 4, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 8, 'group_id' => 6, 'teampage_parent' => 0, 'teampage_name' => ''),

+ ),

+ ),

+ array(

+ 6,

+ 1,

+ true,

+ array(

+ array('teampage_position' => 1, 'group_id' => 1, 'teampage_parent' => 0, 'teampage_name' => ''),

+ array('teampage_position' => 2, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category - 2 children'),

+ array('teampage_position' => 3, 'group_id' => 2, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 4, 'group_id' => 3, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 5, 'group_id' => 6, 'teampage_parent' => 0, 'teampage_name' => ''),

+ array('teampage_position' => 6, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category2 - 2 children'),

+ array('teampage_position' => 7, 'group_id' => 4, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 8, 'group_id' => 5, 'teampage_parent' => 5, 'teampage_name' => ''),

+ ),

+ ),

+ array(

+ 1,

+ -1,

+ true,

+ array(

+ array('teampage_position' => 1, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category - 2 children'),

+ array('teampage_position' => 2, 'group_id' => 2, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 3, 'group_id' => 3, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 4, 'group_id' => 1, 'teampage_parent' => 0, 'teampage_name' => ''),

+ array('teampage_position' => 5, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category2 - 2 children'),

+ array('teampage_position' => 6, 'group_id' => 4, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 7, 'group_id' => 5, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 8, 'group_id' => 6, 'teampage_parent' => 0, 'teampage_name' => ''),

+ ),

+ ),

+ array(

+ 2,

+ -1,

+ true,

+ array(

+ array('teampage_position' => 1, 'group_id' => 1, 'teampage_parent' => 0, 'teampage_name' => ''),

+ array('teampage_position' => 2, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category - 2 children'),

+ array('teampage_position' => 3, 'group_id' => 3, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 4, 'group_id' => 2, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 5, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category2 - 2 children'),

+ array('teampage_position' => 6, 'group_id' => 4, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 7, 'group_id' => 5, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 8, 'group_id' => 6, 'teampage_parent' => 0, 'teampage_name' => ''),

+ ),

+ ),

+ array(

+ 5,

+ -1,

+ false,

+ array(

+ array('teampage_position' => 1, 'group_id' => 1, 'teampage_parent' => 0, 'teampage_name' => ''),

+ array('teampage_position' => 2, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category - 2 children'),

+ array('teampage_position' => 3, 'group_id' => 2, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 4, 'group_id' => 3, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 5, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category2 - 2 children'),

+ array('teampage_position' => 6, 'group_id' => 4, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 7, 'group_id' => 5, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 8, 'group_id' => 6, 'teampage_parent' => 0, 'teampage_name' => ''),

+ ),

+ ),

+ array(

+ 6,

+ -1,

+ false,

+ array(

+ array('teampage_position' => 1, 'group_id' => 1, 'teampage_parent' => 0, 'teampage_name' => ''),

+ array('teampage_position' => 2, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category - 2 children'),

+ array('teampage_position' => 3, 'group_id' => 2, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 4, 'group_id' => 3, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 5, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category2 - 2 children'),

+ array('teampage_position' => 6, 'group_id' => 4, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 7, 'group_id' => 5, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 8, 'group_id' => 6, 'teampage_parent' => 0, 'teampage_name' => ''),

+ ),

+ ),

+ array(

+ 6,

+ 3,

+ true,

+ array(

+ array('teampage_position' => 1, 'group_id' => 6, 'teampage_parent' => 0, 'teampage_name' => ''),

+ array('teampage_position' => 2, 'group_id' => 1, 'teampage_parent' => 0, 'teampage_name' => ''),

+ array('teampage_position' => 3, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category - 2 children'),

+ array('teampage_position' => 4, 'group_id' => 2, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 5, 'group_id' => 3, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 6, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category2 - 2 children'),

+ array('teampage_position' => 7, 'group_id' => 4, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 8, 'group_id' => 5, 'teampage_parent' => 5, 'teampage_name' => ''),

+ ),

+ ),

+ );

+ }

+

+ /**

+ * @dataProvider move_data

+ */

+ public function test_move($group_id, $move_delta, $excepted_moved, $expected)

+ {

+ global $cache;

+

+ $cache = new phpbb_mock_cache;

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

+ $user = new phpbb_user;

+ $user->lang = array();

+

+ $test_class = new phpbb_groupposition_teampage($db, $user, $cache);

+ $this->assertEquals($excepted_moved, $test_class->move($group_id, $move_delta));

+

+ $result = $db->sql_query('SELECT teampage_position, group_id, teampage_parent, teampage_name

+ FROM ' . TEAMPAGE_TABLE . '

+ ORDER BY teampage_position ASC');

+

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

+ }

+

+ public function move_teampage_data()

+ {

+ return array(

+ array(

+ 1,

+ 1,

+ false,

+ array(

+ array('teampage_position' => 1, 'group_id' => 1, 'teampage_parent' => 0, 'teampage_name' => ''),

+ array('teampage_position' => 2, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category - 2 children'),

+ array('teampage_position' => 3, 'group_id' => 2, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 4, 'group_id' => 3, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 5, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category2 - 2 children'),

+ array('teampage_position' => 6, 'group_id' => 4, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 7, 'group_id' => 5, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 8, 'group_id' => 6, 'teampage_parent' => 0, 'teampage_name' => ''),

+ ),

+ ),

+ array(

+ 2,

+ 1,

+ true,

+ array(

+ array('teampage_position' => 1, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category - 2 children'),

+ array('teampage_position' => 2, 'group_id' => 2, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 3, 'group_id' => 3, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 4, 'group_id' => 1, 'teampage_parent' => 0, 'teampage_name' => ''),

+ array('teampage_position' => 5, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category2 - 2 children'),

+ array('teampage_position' => 6, 'group_id' => 4, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 7, 'group_id' => 5, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 8, 'group_id' => 6, 'teampage_parent' => 0, 'teampage_name' => ''),

+ ),

+ ),

+ array(

+ 5,

+ 1,

+ true,

+ array(

+ array('teampage_position' => 1, 'group_id' => 1, 'teampage_parent' => 0, 'teampage_name' => ''),

+ array('teampage_position' => 2, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category2 - 2 children'),

+ array('teampage_position' => 3, 'group_id' => 4, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 4, 'group_id' => 5, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 5, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category - 2 children'),

+ array('teampage_position' => 6, 'group_id' => 2, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 7, 'group_id' => 3, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 8, 'group_id' => 6, 'teampage_parent' => 0, 'teampage_name' => ''),

+ ),

+ ),

+ array(

+ 6,

+ 1,

+ false,

+ array(

+ array('teampage_position' => 1, 'group_id' => 1, 'teampage_parent' => 0, 'teampage_name' => ''),

+ array('teampage_position' => 2, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category - 2 children'),

+ array('teampage_position' => 3, 'group_id' => 2, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 4, 'group_id' => 3, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 5, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category2 - 2 children'),

+ array('teampage_position' => 6, 'group_id' => 4, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 7, 'group_id' => 5, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 8, 'group_id' => 6, 'teampage_parent' => 0, 'teampage_name' => ''),

+ ),

+ ),

+ array(

+ 1,

+ -1,

+ true,

+ array(

+ array('teampage_position' => 1, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category - 2 children'),

+ array('teampage_position' => 2, 'group_id' => 2, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 3, 'group_id' => 3, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 4, 'group_id' => 1, 'teampage_parent' => 0, 'teampage_name' => ''),

+ array('teampage_position' => 5, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category2 - 2 children'),

+ array('teampage_position' => 6, 'group_id' => 4, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 7, 'group_id' => 5, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 8, 'group_id' => 6, 'teampage_parent' => 0, 'teampage_name' => ''),

+ ),

+ ),

+ array(

+ 2,

+ -1,

+ true,

+ array(

+ array('teampage_position' => 1, 'group_id' => 1, 'teampage_parent' => 0, 'teampage_name' => ''),

+ array('teampage_position' => 2, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category2 - 2 children'),

+ array('teampage_position' => 3, 'group_id' => 4, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 4, 'group_id' => 5, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 5, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category - 2 children'),

+ array('teampage_position' => 6, 'group_id' => 2, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 7, 'group_id' => 3, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 8, 'group_id' => 6, 'teampage_parent' => 0, 'teampage_name' => ''),

+ ),

+ ),

+ array(

+ 5,

+ -1,

+ true,

+ array(

+ array('teampage_position' => 1, 'group_id' => 1, 'teampage_parent' => 0, 'teampage_name' => ''),

+ array('teampage_position' => 2, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category - 2 children'),

+ array('teampage_position' => 3, 'group_id' => 2, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 4, 'group_id' => 3, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 5, 'group_id' => 6, 'teampage_parent' => 0, 'teampage_name' => ''),

+ array('teampage_position' => 6, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category2 - 2 children'),

+ array('teampage_position' => 7, 'group_id' => 4, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 8, 'group_id' => 5, 'teampage_parent' => 5, 'teampage_name' => ''),

+ ),

+ ),

+ array(

+ 6,

+ -1,

+ true,

+ array(

+ array('teampage_position' => 1, 'group_id' => 1, 'teampage_parent' => 0, 'teampage_name' => ''),

+ array('teampage_position' => 2, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category - 2 children'),

+ array('teampage_position' => 3, 'group_id' => 2, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 4, 'group_id' => 3, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 5, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category2 - 2 children'),

+ array('teampage_position' => 6, 'group_id' => 5, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 7, 'group_id' => 4, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 8, 'group_id' => 6, 'teampage_parent' => 0, 'teampage_name' => ''),

+ ),

+ ),

+ array(

+ 8,

+ 3,

+ true,

+ array(

+ array('teampage_position' => 1, 'group_id' => 6, 'teampage_parent' => 0, 'teampage_name' => ''),

+ array('teampage_position' => 2, 'group_id' => 1, 'teampage_parent' => 0, 'teampage_name' => ''),

+ array('teampage_position' => 3, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category - 2 children'),

+ array('teampage_position' => 4, 'group_id' => 2, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 5, 'group_id' => 3, 'teampage_parent' => 2, 'teampage_name' => ''),

+ array('teampage_position' => 6, 'group_id' => 0, 'teampage_parent' => 0, 'teampage_name' => 'category2 - 2 children'),

+ array('teampage_position' => 7, 'group_id' => 4, 'teampage_parent' => 5, 'teampage_name' => ''),

+ array('teampage_position' => 8, 'group_id' => 5, 'teampage_parent' => 5, 'teampage_name' => ''),

+ ),

+ ),

+ );

+ }

+

+ /**

+ * @dataProvider move_teampage_data

+ */

+ public function test_move_teampage($teampage_id, $move_delta, $excepted_moved, $expected)

+ {

+ global $cache;

+

+ $cache = new phpbb_mock_cache;

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

+ $user = new phpbb_user;

+ $user->lang = array();

+

+ $test_class = new phpbb_groupposition_teampage($db, $user, $cache);

+ $this->assertEquals($excepted_moved, $test_class->move_teampage($teampage_id, $move_delta));

+

+ $result = $db->sql_query('SELECT teampage_position, group_id, teampage_parent, teampage_name

+ FROM ' . TEAMPAGE_TABLE . '

+ ORDER BY teampage_position 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';

+

+class phpbb_log_add_test extends phpbb_database_test_case

+{

+ public function getDataSet()

+ {

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

+ }

+

+ public function test_log_enabled()

+ {

+ global $phpbb_root_path, $phpEx, $db, $phpbb_dispatcher;

+

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

+ $cache = new phpbb_mock_cache;

+ $phpbb_dispatcher = new phpbb_mock_event_dispatcher();

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

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

+

+ $log = new phpbb_log($db, $user, $auth, $phpbb_dispatcher, $phpbb_root_path, 'adm/', $phpEx, LOG_TABLE);

+

+ $this->assertTrue($log->is_enabled(), 'Initialise failed');

+

+ $log->disable();

+ $this->assertFalse($log->is_enabled(), 'Disable all failed');

+

+ $log->enable();

+ $this->assertTrue($log->is_enabled(), 'Enable all failed');

+

+ $log->disable('admin');

+ $this->assertFalse($log->is_enabled('admin'), 'Disable admin failed');

+ $this->assertTrue($log->is_enabled('user'), 'User should be enabled, is disabled');

+ $this->assertTrue($log->is_enabled(), 'Disable admin disabled all');

+

+ $log->enable('admin');

+ $this->assertTrue($log->is_enabled('admin'), 'Enable admin failed');

+ }

+

+ public function test_log_add()

+ {

+ global $phpbb_root_path, $phpEx, $db, $phpbb_dispatcher;

+

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

+ $cache = new phpbb_mock_cache;

+ $phpbb_dispatcher = new phpbb_mock_event_dispatcher();

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

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

+

+ $log = new phpbb_log($db, $user, $auth, $phpbb_dispatcher, $phpbb_root_path, 'adm/', $phpEx, LOG_TABLE);

+

+ $mode = 'critical';

+ $user_id = ANONYMOUS;

+ $log_ip = 'user_ip';

+ $log_time = time();

+ $log_operation = 'LOG_OPERATION';

+ $additional_data = array();

+

+ // Add an entry successful

+ $this->assertEquals(1, $log->add($mode, $user_id, $log_ip, $log_operation, $log_time));

+

+ // Disable logging for all types

+ $log->disable();

+ $this->assertFalse($log->add($mode, $user_id, $log_ip, $log_operation, $log_time), 'Disable for all types failed');

+ $log->enable();

+

+ // Disable logging for same type

+ $log->disable('critical');

+ $this->assertFalse($log->add($mode, $user_id, $log_ip, $log_operation, $log_time), 'Disable for same type failed');

+ $log->enable();

+

+ // Disable logging for different type

+ $log->disable('admin');

+ $this->assertEquals(2, $log->add($mode, $user_id, $log_ip, $log_operation, $log_time), 'Disable for different types failed');

+ $log->enable();

+

+ // Invalid mode specified

+ $this->assertFalse($log->add('mode_does_not_exist', $user_id, $log_ip, $log_operation, $log_time));

+ }

+}

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

+<dataset>

+ <table name="phpbb_log">

+ <column>log_id</column>

+ <column>log_type</column>

+ <column>user_id</column>

+ <column>forum_id</column>

+ <column>topic_id</column>

+ <column>reportee_id</column>

+ <column>log_ip</column>

+ <column>log_time</column>

+ <column>log_operation</column>

+ <column>log_data</column>

+ </table>

+</dataset>

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

+<dataset>

+ <table name="phpbb_log">

+ <column>log_id</column>

+ <column>log_type</column>

+ <column>user_id</column>

+ <column>forum_id</column>

+ <column>topic_id</column>

+ <column>reportee_id</column>

+ <column>log_ip</column>

+ <column>log_time</column>

+ <column>log_operation</column>

+ <column>log_data</column>

+ <row>

+ <value>1</value>

+ <value>0</value>

+ <value>1</value>

+ <value>0</value>

+ <value>0</value>

+ <value>0</value>

+ <value>127.0.0.1</value>

+ <value>1</value>

+ <value>LOG_INSTALL_INSTALLED</value>

+ <value>a:1:{i:0;s:9:"3.1.0-dev";}</value>

+ </row>

+ <row>

+ <value>2</value>

+ <value>0</value>

+ <value>1</value>

+ <value>0</value>

+ <value>0</value>

+ <value>0</value>

+ <value>127.0.0.1</value>

+ <value>1</value>

+ <value>LOG_KEY_NOT_EXISTS</value>

+ <value>a:1:{i:0;s:15:"additional_data";}</value>

+ </row>

+ <row>

+ <value>3</value>

+ <value>2</value>

+ <value>1</value>

+ <value>0</value>

+ <value>0</value>

+ <value>0</value>

+ <value>127.0.0.1</value>

+ <value>1</value>

+ <value>LOG_CRITICAL</value>

+ <value>a:1:{i:0;s:13:"critical data";}</value>

+ </row>

+ <row>

+ <value>4</value>

+ <value>1</value>

+ <value>1</value>

+ <value>12</value>

+ <value>34</value>

+ <value>0</value>

+ <value>127.0.0.1</value>

+ <value>1</value>

+ <value>LOG_MOD</value>

+ <value></value>

+ </row>

+ <row>

+ <value>5</value>

+ <value>1</value>

+ <value>1</value>

+ <value>12</value>

+ <value>45</value>

+ <value>0</value>

+ <value>127.0.0.1</value>

+ <value>1</value>

+ <value>LOG_MOD</value>

+ <value></value>

+ </row>

+ <row>

+ <value>6</value>

+ <value>1</value>

+ <value>1</value>

+ <value>23</value>

+ <value>56</value>

+ <value>0</value>

+ <value>127.0.0.1</value>

+ <value>1</value>

+ <value>LOG_MOD</value>

+ <value></value>

+ </row>

+ <row>

+ <value>7</value>

+ <value>1</value>

+ <value>1</value>

+ <value>12</value>

+ <value>45</value>

+ <value>0</value>

+ <value>127.0.0.1</value>

+ <value>1</value>

+ <value>LOG_MOD2</value>

+ <value></value>

+ </row>

+ <row>

+ <value>8</value>

+ <value>3</value>

+ <value>1</value>

+ <value>0</value>

+ <value>0</value>

+ <value>2</value>

+ <value>127.0.0.1</value>

+ <value>1</value>

+ <value>LOG_USER</value>

+ <value>a:1:{i:0;s:5:"admin";}</value>

+ </row>

+ <row>

+ <value>9</value>

+ <value>3</value>

+ <value>1</value>

+ <value>0</value>

+ <value>0</value>

+ <value>1</value>

+ <value>127.0.0.1</value>

+ <value>1</value>

+ <value>LOG_USER</value>

+ <value>a:1:{i:0;s:5:"guest";}</value>

+ </row>

+ </table>

+ <table name="phpbb_users">

+ <column>user_id</column>

+ <column>username</column>

+ <column>username_clean</column>

+ <column>user_permissions</column>

+ <column>user_sig</column>

+ <column>user_occ</column>

+ <column>user_interests</column>

+ <row>

+ <value>1</value>

+ <value>Anonymous</value>

+ <value>Anonymous</value>

+ <value></value>

+ <value></value>

+ <value></value>

+ <value></value>

+ </row>

+ <row>

+ <value>2</value>

+ <value>admin</value>

+ <value>admin</value>

+ <value></value>

+ <value></value>

+ <value></value>

+ <value></value>

+ </row>

+ </table>

+ <table name="phpbb_topics">

+ <column>topic_id</column>

+ <column>forum_id</column>

+ <row>

+ <value>34</value>

+ <value>12</value>

+ </row>

+ <row>

+ <value>45</value>

+ <value>12</value>

+ </row>

+ <row>

+ <value>56</value>

+ <value>23</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

+*

+*/

+

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

+

+class phpbb_log_function_add_log_test extends phpbb_database_test_case

+{

+ public function getDataSet()

+ {

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

+ }

+

+ public static function test_add_log_function_data()

+ {

+ return array(

+ /**

+ * Case documentation

+ array(

+ // Row that is in the database afterwards

+ array(

+ 'user_id' => ANONYMOUS,

+ 'log_type' => LOG_MOD,

+ 'log_operation' => 'LOG_MOD_ADDITIONAL',

+ // log_data will be serialized

+ 'log_data' => array(

+ 'argument3',

+ ),

+ 'reportee_id' => 0,

+ 'forum_id' => 56,

+ 'topic_id' => 78,

+ ),

+ // user_id Can also be false, then ANONYMOUS is used

+ false,

+ // log_mode Used to determine the log_type

+ 'mod',

+ // Followed by some additional arguments

+ // forum_id, topic_id and reportee_id are specified before log_operation

+ // The rest is specified afterwards.

+ 56,

+ 78,

+ 'LOG_MOD_ADDITIONAL', // log_operation

+ 'argument3',

+ ),

+ */

+ array(

+ array(

+ 'user_id' => 2,

+ 'log_type' => LOG_CRITICAL,

+ 'log_operation' => 'LOG_NO_ADDITIONAL',

+ 'log_data' => '',

+ 'reportee_id' => 0,

+ 'forum_id' => 0,

+ 'topic_id' => 0,

+ ),

+ 2, 'critical', 'LOG_NO_ADDITIONAL',

+ ),

+ array(

+ array(

+ 'user_id' => 2,

+ 'log_type' => LOG_CRITICAL,

+ 'log_operation' => 'LOG_ONE_ADDITIONAL',

+ 'log_data' => array(

+ 'argument1',

+ ),

+ 'reportee_id' => 0,

+ 'forum_id' => 0,

+ 'topic_id' => 0,

+ ),

+ 2, 'critical', 'LOG_ONE_ADDITIONAL', 'argument1',

+ ),

+ array(

+ array(

+ 'user_id' => ANONYMOUS,

+ 'log_type' => LOG_ADMIN,

+ 'log_operation' => 'LOG_TWO_ADDITIONAL',

+ 'log_data' => array(

+ 'argument1',

+ 'argument2',

+ ),

+ 'reportee_id' => 0,

+ 'forum_id' => 0,

+ 'topic_id' => 0,

+ ),

+ false, 'admin', 'LOG_TWO_ADDITIONAL', 'argument1', 'argument2',

+ ),

+ array(

+ array(

+ 'user_id' => ANONYMOUS,

+ 'log_type' => LOG_USERS,

+ 'log_operation' => 'LOG_USERS_ADDITIONAL',

+ 'log_data' => array(

+ 'argument2',

+ ),

+ 'reportee_id' => 2,

+ 'forum_id' => 0,

+ 'topic_id' => 0,

+ ),

+ false, 'user', 2, 'LOG_USERS_ADDITIONAL', 'argument2',

+ ),

+ array(

+ array(

+ 'user_id' => ANONYMOUS,

+ 'log_type' => LOG_MOD,

+ 'log_operation' => 'LOG_MOD_TOPIC_AND_FORUM',

+ 'log_data' => '',

+ 'reportee_id' => 0,

+ 'forum_id' => 12,

+ 'topic_id' => 34,

+ ),

+ false, 'mod', 12, 34, 'LOG_MOD_TOPIC_AND_FORUM',

+ ),

+ array(

+ array(

+ 'user_id' => ANONYMOUS,

+ 'log_type' => LOG_MOD,

+ 'log_operation' => 'LOG_MOD_ADDITIONAL',

+ 'log_data' => array(

+ 'argument3',

+ ),

+ 'reportee_id' => 0,

+ 'forum_id' => 56,

+ 'topic_id' => 78,

+ ),

+ false, 'mod', 56, 78, 'LOG_MOD_ADDITIONAL', 'argument3',

+ ),

+ array(

+ array(

+ ),

+ false, 'mode_does_not_exist', 'LOG_MOD_ADDITIONAL', 'argument1',

+ ),

+ );

+ }

+

+ /**

+ * @dataProvider test_add_log_function_data

+ */

+ public function test_add_log_function($expected, $user_id, $mode, $required1, $additional1 = null, $additional2 = null, $additional3 = null)

+ {

+ global $db, $cache, $user, $phpbb_log, $phpbb_dispatcher, $phpbb_root_path, $phpEx;

+

+ if ($expected)

+ {

+ // Serialize the log data if we have some

+ if (is_array($expected['log_data']))

+ {

+ $expected['log_data'] = serialize($expected['log_data']);

+ }

+ $expected = array($expected);

+ }

+

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

+ $cache = new phpbb_mock_cache;

+ $phpbb_dispatcher = new phpbb_mock_event_dispatcher();

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

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

+

+ $phpbb_log = new phpbb_log($db, $user, $auth, $phpbb_dispatcher, $phpbb_root_path, 'adm/', $phpEx, LOG_TABLE);

+

+ $user->ip = 'user_ip';

+ if ($user_id)

+ {

+ $user->data['user_id'] = $user_id;

+ }

+

+ if ($additional3 != null)

+ {

+ add_log($mode, $required1, $additional1, $additional2, $additional3);

+ }

+ else if ($additional2 != null)

+ {

+ add_log($mode, $required1, $additional1, $additional2);

+ }

+ else if ($additional1 != null)

+ {

+ add_log($mode, $required1, $additional1);

+ }

+ else

+ {

+ add_log($mode, $required1);

+ }

+

+ $result = $db->sql_query('SELECT user_id, log_type, log_operation, log_data, reportee_id, forum_id, topic_id

+ FROM ' . LOG_TABLE);

+

+ $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/utf/utf_tools.php';

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

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

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

+

+class phpbb_log_function_view_log_test extends phpbb_database_test_case

+{

+ public function getDataSet()

+ {

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

+ }

+

+ public static function test_view_log_function_data()

+ {

+ global $phpEx, $phpbb_dispatcher;

+ $phpbb_dispatcher = new phpbb_mock_event_dispatcher();

+

+ $expected_data_sets = array(

+ 1 => array(

+ 'id' => 1,

+

+ 'reportee_id' => 0,

+ 'reportee_username' => '',

+ 'reportee_username_full'=> '',

+

+ 'user_id' => 1,

+ 'username' => 'Anonymous',

+ 'username_full' => 'Anonymous',

+

+ 'ip' => '127.0.0.1',

+ 'time' => 1,

+ 'forum_id' => 0,

+ 'topic_id' => 0,

+

+ 'viewforum' => '',

+ 'action' => 'installed: 3.1.0-dev',

+ ),

+ 2 => array(

+ 'id' => 2,

+

+ 'reportee_id' => 0,

+ 'reportee_username' => '',

+ 'reportee_username_full'=> '',

+

+ 'user_id' => 1,

+ 'username' => 'Anonymous',

+ 'username_full' => 'Anonymous',

+

+ 'ip' => '127.0.0.1',

+ 'time' => 1,

+ 'forum_id' => 0,

+ 'topic_id' => 0,

+

+ 'viewforum' => '',

+ 'action' => '{LOG KEY NOT EXISTS}<br />additional_data',

+ ),

+ 3 => array(

+ 'id' => 3,

+

+ 'reportee_id' => 0,

+ 'reportee_username' => '',

+ 'reportee_username_full'=> '',

+

+ 'user_id' => 1,

+ 'username' => 'Anonymous',

+ 'username_full' => 'Anonymous',

+

+ 'ip' => '127.0.0.1',

+ 'time' => 1,

+ 'forum_id' => 0,

+ 'topic_id' => 0,

+

+ 'viewforum' => '',

+ 'action' => '{LOG CRITICAL}<br />critical data',

+ ),

+ 4 => array(

+ 'id' => 4,

+

+ 'reportee_id' => 0,

+ 'reportee_username' => '',

+ 'reportee_username_full'=> '',

+

+ 'user_id' => 1,

+ 'username' => 'Anonymous',

+ 'username_full' => 'Anonymous',

+

+ 'ip' => '127.0.0.1',

+ 'time' => 1,

+ 'forum_id' => 12,

+ 'topic_id' => 34,

+

+ 'viewforum' => '',

+ 'action' => '{LOG MOD}',

+ 'viewtopic' => '',

+ 'viewlogs' => '',

+ ),

+ 5 => array(

+ 'id' => 5,

+

+ 'reportee_id' => 0,

+ 'reportee_username' => '',

+ 'reportee_username_full'=> '',

+

+ 'user_id' => 1,

+ 'username' => 'Anonymous',

+ 'username_full' => 'Anonymous',

+

+ 'ip' => '127.0.0.1',

+ 'time' => 1,

+ 'forum_id' => 12,

+ 'topic_id' => 45,

+

+ 'viewforum' => '',

+ 'action' => '{LOG MOD}',

+ 'viewtopic' => '',

+ 'viewlogs' => '',

+ ),

+ 6 => array(

+ 'id' => 6,

+

+ 'reportee_id' => 0,

+ 'reportee_username' => '',

+ 'reportee_username_full'=> '',

+

+ 'user_id' => 1,

+ 'username' => 'Anonymous',

+ 'username_full' => 'Anonymous',

+

+ 'ip' => '127.0.0.1',

+ 'time' => 1,

+ 'forum_id' => 23,

+ 'topic_id' => 56,

+

+ 'viewforum' => append_sid("phpBB/viewforum.$phpEx", 'f=23'),

+ 'action' => '{LOG MOD}',

+ 'viewtopic' => append_sid("phpBB/viewtopic.$phpEx", 'f=23&amp;t=56'),

+ 'viewlogs' => append_sid("phpBB/mcp.$phpEx", 'i=logs&amp;mode=topic_logs&amp;t=56'),

+ ),

+ 7 => array(

+ 'id' => 7,

+

+ 'reportee_id' => 0,

+ 'reportee_username' => '',

+ 'reportee_username_full'=> '',

+

+ 'user_id' => 1,

+ 'username' => 'Anonymous',

+ 'username_full' => 'Anonymous',

+

+ 'ip' => '127.0.0.1',

+ 'time' => 1,

+ 'forum_id' => 12,

+ 'topic_id' => 45,

+

+ 'viewforum' => '',

+ 'action' => '{LOG MOD2}',

+ 'viewtopic' => '',

+ 'viewlogs' => '',

+ ),

+ 8 => array(

+ 'id' => 8,

+

+ 'reportee_id' => 2,

+ 'reportee_username' => 'admin',

+ 'reportee_username_full'=> 'admin',

+

+ 'user_id' => 1,

+ 'username' => 'Anonymous',

+ 'username_full' => 'Anonymous',

+

+ 'ip' => '127.0.0.1',

+ 'time' => 1,

+ 'forum_id' => 0,

+ 'topic_id' => 0,

+

+ 'viewforum' => '',

+ 'action' => '{LOG USER}<br />admin',

+ ),

+ 9 => array(

+ 'id' => 9,

+

+ 'reportee_id' => 1,

+ 'reportee_username' => 'Anonymous',

+ 'reportee_username_full'=> 'Anonymous',

+

+ 'user_id' => 1,

+ 'username' => 'Anonymous',

+ 'username_full' => 'Anonymous',

+

+ 'ip' => '127.0.0.1',

+ 'time' => 1,

+ 'forum_id' => 0,

+ 'topic_id' => 0,

+

+ 'viewforum' => '',

+ 'action' => '{LOG USER}<br />guest',

+ ),

+ );

+

+ $test_cases = array(

+ /**

+ * Case documentation

+ array(

+ // Array of datasets that should be in $log after running the function

+ 'expected' => array(5, 7),

+ // Offset that will be returned from the function

+ 'expected_returned' => 0,

+ // view_log parameters (see includes/functions_admin.php for docblock)

+ // $log is ommited!

+ 'mod', 5, 0, 12, 45,

+ ),

+ */

+ array(

+ 'expected' => array(1, 2),

+ 'expected_returned' => 0,

+ 'admin', false,

+ ),

+ array(

+ 'expected' => array(1),

+ 'expected_returned' => 0,

+ 'admin', false, 1,

+ ),

+ array(

+ 'expected' => array(2),

+ 'expected_returned' => 1,

+ 'admin', false, 1, 1,

+ ),

+ array(

+ 'expected' => array(2),

+ 'expected_returned' => 1,

+ 'admin', 0, 1, 1,

+ ),

+ array(

+ 'expected' => array(2),

+ 'expected_returned' => 1,

+ 'admin', 0, 1, 5,

+ ),

+ array(

+ 'expected' => array(3),

+ 'expected_returned' => 0,

+ 'critical', false,

+ ),

+ array(

+ 'expected' => array(),

+ 'expected_returned' => null,

+ 'mode_does_not_exist', false,

+ ),

+ array(

+ 'expected' => array(4, 5, 7),

+ 'expected_returned' => 0,

+ 'mod', 0, 5, 0, 12,

+ ),

+ array(

+ 'expected' => array(5, 7),

+ 'expected_returned' => 0,

+ 'mod', 0, 5, 0, 12, 45,

+ ),

+ array(

+ 'expected' => array(6),

+ 'expected_returned' => 0,

+ 'mod', 0, 5, 0, 23,

+ ),

+ array(

+ 'expected' => array(8),

+ 'expected_returned' => 0,

+ 'user', 0, 5, 0, 0, 0, 2,

+ ),

+ array(

+ 'expected' => array(8, 9),

+ 'expected_returned' => 0,

+ 'users', 0,

+ ),

+ );

+

+ foreach ($test_cases as $case => $case_data)

+ {

+ foreach ($case_data['expected'] as $data_set => $expected)

+ {

+ $test_cases[$case]['expected'][$data_set] = $expected_data_sets[$expected];

+ }

+ }

+

+ return $test_cases;

+ }

+

+ /**

+ * @dataProvider test_view_log_function_data

+ */

+ public function test_view_log_function($expected, $expected_returned, $mode, $log_count, $limit = 5, $offset = 0, $forum_id = 0, $topic_id = 0, $user_id = 0, $limit_days = 0, $sort_by = 'l.log_id ASC', $keywords = '')

+ {

+ global $cache, $db, $user, $auth, $phpbb_log, $phpbb_dispatcher, $phpbb_root_path, $phpEx;

+

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

+ $cache = new phpbb_mock_cache;

+ $phpbb_dispatcher = new phpbb_mock_event_dispatcher();

+

+ // Create auth mock

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

+ $acl_get_map = array(

+ array('f_read', 23, true),

+ array('m_', 23, true),

+ );

+ $acl_gets_map = array(

+ array('a_', 'm_', 23, true),

+ );

+

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

+ ->method('acl_get')

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

+ $this->anything())

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

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

+ ->method('acl_gets')

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

+ $this->anything())

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

+

+ $user = new phpbb_mock_user;

+ $user->optionset('viewcensors', false);

+ // Test sprintf() of the data into the action

+ $user->lang = array(

+ 'LOG_INSTALL_INSTALLED' => 'installed: %s',

+ );

+

+ $phpbb_log = new phpbb_log($db, $user, $auth, $phpbb_dispatcher, $phpbb_root_path, 'adm/', $phpEx, LOG_TABLE);

+

+ $log = array();

+ $this->assertEquals($expected_returned, view_log($mode, $log, $log_count, $limit, $offset, $forum_id, $topic_id, $user_id, $limit_days, $sort_by, $keywords));

+

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

+ }

+}

+ protected $services = array();

+ protected $parameters = array();

+

+ $this->services[$id] = $service;

+ if ($this->has($id))

+ {

+ return $this->services[$id];

+ }

+

+ throw new Exception('Could not find service: ' . $id);

+ return isset($this->services[$id]);

+ if ($this->hasParameter($name))

+ {

+ return $this->parameters[$name];

+ }

+

+ throw new Exception('Could not find parameter: ' . $name);

+ return isset($this->parameters[$name]);

+ $this->parameters[$name] = $value;

+<?php

+/**

+*

+* @package notifications

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Notifications service class

+* @package notifications

+*/

+class phpbb_mock_notification_manager

+{

+ public function load_notifications()

+ {

+ return array(

+ 'notifications' => array(),

+ 'unread_count' => 0,

+ );

+ }

+

+ public function mark_notifications_read()

+ {

+ }

+

+ public function mark_notifications_read_by_parent()

+ {

+ }

+

+ public function mark_notifications_read_by_id()

+ {

+ }

+

+

+ public function add_notifications()

+ {

+ return array();

+ }

+

+ public function add_notifications_for_users()

+ {

+ }

+

+ public function update_notifications()

+ {

+ }

+

+ public function delete_notifications()

+ {

+ }

+

+ public function get_subscription_types()

+ {

+ return array();

+ }

+

+ public function get_subscription_methods()

+ {

+ return array();

+ }

+

+

+ public function get_global_subscriptions()

+ {

+ return array();

+ }

+

+ public function add_subscription()

+ {

+ }

+

+ public function delete_subscription()

+ {

+ }

+

+ public function load_users()

+ {

+ }

+

+ public function get_user()

+ {

+ return null;

+ }

+}

+<?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_notifications_auth extends phpbb_auth

+{

+ function acl_get_list($user_id = false, $opts = false, $forum_id = false)

+ {

+ $user_id = (!is_array($user_id)) ? array($user_id) : $user_id;

+ $opts = (!is_array($opts)) ? array($opts) : $opts;

+ $forum_id = (!is_array($forum_id)) ? array($forum_id) : $forum_id;

+

+ $auth_list = array();

+

+ foreach ($forum_id as $fid)

+ {

+ foreach ($opts as $opt)

+ {

+ $auth_list[$fid][$opt] = array();

+

+ foreach ($user_id as $uid)

+ {

+ $auth_list[$fid][$opt][] = $uid;

+ }

+ }

+ }

+

+ return $auth_list;

+ }

+

+ function acl_get($opt, $f = 0)

+ {

+ return true;

+ }

+}

+<?php

+/**

+*

+* @package notifications

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Notifications service class

+* @package notifications

+*/

+class phpbb_mock_notifications_notification_manager extends phpbb_notification_manager

+{

+ public function set_var($name, $value)

+ {

+ $this->$name = $value;

+ }

+

+ // Extra dependencies for get_*_class functions

+ protected $auth = null;

+ protected $cache = null;

+ protected $config = null;

+ public function setDependencies($auth, $cache, $config)

+ {

+ $this->auth = $auth;

+ $this->cache = $cache;

+ $this->config = $config;

+ }

+

+ /**

+ * Helper to get the notifications item type class and set it up

+ */

+ public function get_item_type_class($item_type, $data = array())

+ {

+ $item_type = 'phpbb_notification_type_' . $item_type;

+

+ $item = new $item_type($this->user_loader, $this->db, $this->cache, $this->user, $this->auth, $this->config, $this->phpbb_root_path, $this->php_ext, $this->notification_types_table, $this->notifications_table, $this->user_notifications_table);

+

+ $item->set_notification_manager($this);

+

+ $item->set_initial_data($data);

+

+ return $item;

+ }

+

+ /**

+ * Helper to get the notifications method class and set it up

+ */

+ public function get_method_class($method_name)

+ {

+ $method_name = 'phpbb_notification_method_' . $method_name;

+

+ $method = new $method_name($this->user_loader, $this->db, $this->cache, $this->user, $this->auth, $this->config, $this->phpbb_root_path, $this->php_ext, $this->notification_types_table, $this->notifications_table, $this->user_notifications_table);

+

+ $method->set_notification_manager($this);

+

+ return $method;

+ }

+}

+<?php

+/**

+*

+* @package notifications

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+class phpbb_notification_type_test extends phpbb_notification_type_base

+{

+ public function get_type()

+ {

+ return 'test';

+ }

+

+ public static function get_item_id($post)

+ {

+ return (int) $post['post_id'];

+ }

+

+ public static function get_item_parent_id($post)

+ {

+ return (int) $post['topic_id'];

+ }

+

+ public function find_users_for_notification($post, $options = array())

+ {

+ return $this->check_user_notification_options(array(0), $options);

+ }

+

+ public function create_insert_array($post, $pre_create_data = array())

+ {

+ $this->notification_time = $post['post_time'];

+

+ return parent::create_insert_array($post, $pre_create_data);

+ }

+

+ public function create_update_array($type_data)

+ {

+ $data = $this->create_insert_array($type_data);

+

+ // Unset data unique to each row

+ unset(

+ $data['notification_id'],

+ $data['notification_read'],

+ $data['user_id']

+ );

+

+ return $data;

+ }

+

+ public function get_title()

+ {

+ return 'test title';

+ }

+

+ public function users_to_query()

+ {

+ return array();

+ }

+

+ public function get_url()

+ {

+ return '';

+ }

+

+ public function get_email_template()

+ {

+ return false;

+ }

+

+ public function get_email_template_variables()

+ {

+ return array();

+ }

+}

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

+<dataset>

+ <table name="phpbb_notifications">

+ </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_notification_test extends phpbb_database_test_case

+{

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

+

+ public function getDataSet()

+ {

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

+ }

+

+ protected function setUp()

+ {

+ parent::setUp();

+

+ global $phpbb_root_path, $phpEx;

+

+ include_once(__DIR__ . '/ext/test/notification/type/test.' . $phpEx);

+

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

+ $this->config = new phpbb_config(array(

+ 'allow_privmsg' => true,

+ 'allow_bookmarks' => true,

+ 'allow_topic_notify' => true,

+ 'allow_forum_notify' => true,

+ ));

+ $this->user = new phpbb_mock_user();

+ $this->user_loader = new phpbb_user_loader($this->db, $phpbb_root_path, $phpEx, 'phpbb_users');

+ $this->auth = new phpbb_mock_notifications_auth();

+ $this->cache = new phpbb_mock_cache();

+

+ $this->container = new phpbb_mock_container_builder();

+

+ $this->notifications = new phpbb_mock_notifications_notification_manager(

+ array(),

+ array(),

+ $this->container,

+ $this->user_loader,

+ $this->db,

+ $this->user,

+ $phpbb_root_path,

+ $phpEx,

+ 'phpbb_notification_types',

+ 'phpbb_notifications',

+ 'phpbb_user_notifications'

+ );

+

+ $this->notifications->setDependencies($this->auth, $this->cache, $this->config);

+

+ $types = array();

+ foreach (array(

+ 'test',

+ 'approve_post',

+ 'approve_topic',

+ 'bookmark',

+ 'disapprove_post',

+ 'disapprove_topic',

+ 'pm',

+ 'post',

+ 'post_in_queue',

+ 'quote',

+ 'report_pm',

+ 'report_pm_closed',

+ 'report_post',

+ 'report_post_closed',

+ 'topic',

+ 'topic_in_queue',

+ ) as $type)

+ {

+ $class = $this->build_type('phpbb_notification_type_' . $type);

+

+ $types[$type] = $class;

+ $this->container->set('notification.type.' . $type, $class);

+ }

+

+ $this->notifications->set_var('notification_types', $types);

+ }

+

+ protected function build_type($type)

+ {

+ global $phpbb_root_path, $phpEx;

+

+ return new $type($this->user_loader, $this->db, $this->cache, $this->user, $this->auth, $this->config, $phpbb_root_path, $phpEx, 'phpbb_notification_types', 'phpbb_notifications', 'phpbb_user_notifications');

+ }

+

+ public function test_get_subscription_types()

+ {

+ $subscription_types = $this->notifications->get_subscription_types();

+

+ $this->assertArrayHasKey('NOTIFICATION_GROUP_MISCELLANEOUS', $subscription_types);

+ $this->assertArrayHasKey('NOTIFICATION_GROUP_POSTING', $subscription_types);

+

+ $this->assertArrayHasKey('bookmark', $subscription_types['NOTIFICATION_GROUP_POSTING']);

+ $this->assertArrayHasKey('post', $subscription_types['NOTIFICATION_GROUP_POSTING']);

+ $this->assertArrayHasKey('quote', $subscription_types['NOTIFICATION_GROUP_POSTING']);

+ $this->assertArrayHasKey('topic', $subscription_types['NOTIFICATION_GROUP_POSTING']);

+

+ $this->assertArrayHasKey('pm', $subscription_types['NOTIFICATION_GROUP_MISCELLANEOUS']);

+

+ //get_subscription_types

+ //get_subscription_methods

+ }

+

+ public function test_subscriptions()

+ {

+ $this->notifications->delete_subscription('post', 0, '', 2);

+

+ $this->assertArrayNotHasKey('post', $this->notifications->get_global_subscriptions(2));

+

+ $this->notifications->add_subscription('post', 0, '', 2);

+

+ $this->assertArrayHasKey('post', $this->notifications->get_global_subscriptions(2));

+ }

+

+ public function test_notifications()

+ {

+ // Used to test post notifications later

+ $this->db->sql_query('INSERT INTO ' . TOPICS_WATCH_TABLE . ' ' . $this->db->sql_build_array('INSERT', array(

+ 'topic_id' => 2,

+ 'notify_status' => NOTIFY_YES,

+ 'user_id' => 0,

+ )));

+

+ $this->assertEquals(array(

+ 'notifications' => array(),

+ 'unread_count' => 0,

+ 'total_count' => 0,

+ ), $this->notifications->load_notifications(array(

+ 'count_unread' => true,

+ )));

+

+ $this->notifications->add_notifications('test', array(

+ 'post_id' => '1',

+ 'topic_id' => '1',

+ 'post_time' => 1349413321,

+ ));

+

+ $this->notifications->add_notifications('test', array(

+ 'post_id' => '2',

+ 'topic_id' => '2',

+ 'post_time' => 1349413322,

+ ));

+

+ $this->notifications->add_notifications('test', array(

+ 'post_id' => '3',

+ 'topic_id' => '2',

+ 'post_time' => 1349413323,

+ ));

+

+ $this->notifications->add_notifications(array('quote', 'bookmark', 'post', 'test'), array(

+ 'post_id' => '4',

+ 'topic_id' => '2',

+ 'post_time' => 1349413324,

+ 'poster_id' => 2,

+ 'topic_title' => 'test-title',

+ 'post_subject' => 'Re: test-title',

+ 'forum_id' => 2,

+ 'forum_name' => 'Your first forum',

+ ));

+

+ $this->db->sql_query('INSERT INTO ' . BOOKMARKS_TABLE . ' ' . $this->db->sql_build_array('INSERT', array(

+ 'topic_id' => 2,

+ 'user_id' => 0,

+ )));

+

+ $this->notifications->add_notifications(array('quote', 'bookmark', 'post', 'test'), array(

+ 'post_id' => '5',

+ 'topic_id' => '2',

+ 'post_time' => 1349413325,

+ 'poster_id' => 2,

+ 'topic_title' => 'test-title',

+ 'post_subject' => 'Re: test-title',

+ 'forum_id' => 2,

+ 'forum_name' => 'Your first forum',

+ ));

+

+ $this->notifications->delete_subscription('test');

+

+ $this->notifications->add_notifications('test', array(

+ 'post_id' => '6',

+ 'topic_id' => '2',

+ 'post_time' => 1349413326,

+ ));

+

+ $notifications = $this->notifications->load_notifications(array(

+ 'count_unread' => true,

+ ));

+

+ $expected = array(

+ 1 => array(

+ 'item_type' => 'test',

+ 'item_id' => 1,

+ 'item_parent_id' => 1,

+ 'user_id' => 0,

+ 'notification_read' => 0,

+ 'notification_time' => 1349413321,

+ 'notification_data' => array(),

+ ),

+ 2 => array(

+ 'item_type' => 'test',

+ 'item_id' => 2,

+ 'item_parent_id' => 2,

+ 'user_id' => 0,

+ 'notification_read' => 0,

+ 'notification_time' => 1349413322,

+ 'notification_data' => array(),

+ ),

+ 3 => array(

+ 'item_type' => 'test',

+ 'item_id' => 3,

+ 'item_parent_id' => 2,

+ 'user_id' => 0,

+ 'notification_read' => 0,

+ 'notification_time' => 1349413323,

+ 'notification_data' => array(),

+ ),

+ 4 => array(

+ 'item_type' => 'post',

+ 'item_id' => 4,

+ 'item_parent_id' => 2,

+ 'user_id' => 0,

+ 'notification_read' => 0,

+ 'notification_time' => 1349413324,

+ 'notification_data' => array(

+ 'poster_id' => 2,

+ 'topic_title' => 'test-title',

+ 'post_subject' => 'Re: test-title',

+ 'post_username' => '',

+ 'forum_id' => 2,

+ 'forum_name' => 'Your first forum',

+ ),

+ ),

+ 5 => array(

+ 'item_type' => 'bookmark',

+ 'item_id' => 5,

+ 'item_parent_id' => 2,

+ 'user_id' => 0,

+ 'notification_read' => 0,

+ 'notification_time' => 1349413325,

+ 'notification_data' => array(

+ 'poster_id' => 2,

+ 'topic_title' => 'test-title',

+ 'post_subject' => 'Re: test-title',

+ 'post_username' => '',

+ 'forum_id' => 2,

+ 'forum_name' => 'Your first forum',

+ ),

+ ),

+ );

+

+ $this->assertEquals(sizeof($expected), $notifications['unread_count']);

+

+ $notifications = $notifications['notifications'];

+

+ foreach ($expected as $notification_id => $notification_data)

+ {

+ //echo $notifications[$notification_id];

+

+ $this->assertEquals($notification_id, $notifications[$notification_id]->notification_id, 'notification_id');

+

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

+ {

+ $this->assertEquals($value, $notifications[$notification_id]->$key, $key . ' ' . $notification_id);

+ }

+ }

+

+ // Now test updating -------------------------------

+

+ $this->notifications->update_notifications('test', array(

+ 'post_id' => '1',

+ 'topic_id' => '2', // change parent_id

+ 'post_time' => 1349413321,

+ ));

+

+ $this->notifications->update_notifications('test', array(

+ 'post_id' => '3',

+ 'topic_id' => '2',

+ 'post_time' => 1234, // change time

+ ));

+

+ $this->notifications->update_notifications(array('quote', 'bookmark', 'post', 'test'), array(

+ 'post_id' => '5',

+ 'topic_id' => '2',

+ 'poster_id' => 2,

+ 'topic_title' => 'test-title2', // change topic_title

+ 'post_subject' => 'Re: test-title2', // change post_subject

+ 'forum_id' => 3, // change forum_id

+ 'forum_name' => 'Your second forum', // change forum_name

+ ));

+

+ $notifications = $this->notifications->load_notifications(array(

+ 'count_unread' => true,

+ ));

+

+ $expected = array(

+ 1 => array(

+ 'item_type' => 'test',

+ 'item_id' => 1,

+ 'item_parent_id' => 2,

+ 'user_id' => 0,

+ 'notification_read' => 0,

+ 'notification_time' => 1349413321,

+ 'notification_data' => array(),

+ ),

+ 2 => array(

+ 'item_type' => 'test',

+ 'item_id' => 2,

+ 'item_parent_id' => 2,

+ 'user_id' => 0,

+ 'notification_read' => 0,

+ 'notification_time' => 1349413322,

+ 'notification_data' => array(),

+ ),

+ 3 => array(

+ 'item_type' => 'test',

+ 'item_id' => 3,

+ 'item_parent_id' => 2,

+ 'user_id' => 0,

+ 'notification_read' => 0,

+ 'notification_time' => 1234,

+ 'notification_data' => array(),

+ ),

+ 4 => array(

+ 'item_type' => 'post',

+ 'item_id' => 4,

+ 'item_parent_id' => 2,

+ 'user_id' => 0,

+ 'notification_read' => 0,

+ 'notification_time' => 1349413324,

+ 'notification_data' => array(

+ 'poster_id' => 2,

+ 'topic_title' => 'test-title',

+ 'post_subject' => 'Re: test-title',

+ 'post_username' => '',

+ 'forum_id' => 2,

+ 'forum_name' => 'Your first forum',

+ ),

+ ),

+ 5 => array(

+ 'item_type' => 'bookmark',

+ 'item_id' => 5,

+ 'item_parent_id' => 2,

+ 'user_id' => 0,

+ 'notification_read' => 0,

+ 'notification_time' => 1349413325,

+ 'notification_data' => array(

+ 'poster_id' => 2,

+ 'topic_title' => 'test-title2',

+ 'post_subject' => 'Re: test-title2',

+ 'post_username' => '',

+ 'forum_id' => 3,

+ 'forum_name' => 'Your second forum',

+ ),

+ ),

+ );

+

+ $this->assertEquals(sizeof($expected), $notifications['unread_count']);

+

+ $notifications = $notifications['notifications'];

+

+ foreach ($expected as $notification_id => $notification_data)

+ {

+ //echo $notifications[$notification_id];

+

+ $this->assertEquals($notification_id, $notifications[$notification_id]->notification_id, 'notification_id');

+

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

+ {

+ $this->assertEquals($value, $notifications[$notification_id]->$key, $key . ' ' . $notification_id);

+ }

+ }

+ }

+}

+ global $db, $phpbb_container;

+ $phpbb_container = new phpbb_mock_container_builder();

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

+

+ $config = new phpbb_config(array());

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

+ $db_tools = new phpbb_db_tools($db);

+

+ $migrator = new phpbb_db_migrator(

+ $config,

+ $db,

+ $db_tools,

+ self::$config['table_prefix'] . 'migrations',

+ $phpbb_root_path,

+ $php_ext,

+ self::$config['table_prefix'],

+ array()

+ );

+ $extension_manager = new phpbb_extension_manager(

+ new phpbb_mock_container_builder(),

+ $db,

+ $config,

+ $migrator,

+ self::$config['table_prefix'] . 'ext',

+ dirname(__FILE__) . '/',

+ '.' . $php_ext,

+ $this->get_cache_driver()

+ );

+ return $extension_manager;

+ 'email_enable' => true,

+ 'smtp_delivery' => true,

+ 'smtp_host' => 'nxdomain.phpbb.com',

+ 'smtp_auth' => '',

+ 'smtp_user' => 'nxuser',

+ 'smtp_pass' => 'nxpass',

+

+ /**

+ * Asserts that exactly one checkbox with name $name exists within the scope

+ * of $crawler and that the checkbox is checked.

+ *

+ * @param Symfony\Component\DomCrawler\Crawler $crawler

+ * @param string $name

+ * @param string $message

+ *

+ * @return null

+ */

+ public function assert_checkbox_is_checked($crawler, $name, $message = '')

+ {

+ $this->assertSame(

+ 'checked',

+ $this->assert_find_one_checkbox($crawler, $name)->attr('checked'),

+ $message ?: "Failed asserting that checkbox $name is checked."

+ );

+ }

+

+ /**

+ * Asserts that exactly one checkbox with name $name exists within the scope

+ * of $crawler and that the checkbox is unchecked.

+ *

+ * @param Symfony\Component\DomCrawler\Crawler $crawler

+ * @param string $name

+ * @param string $message

+ *

+ * @return null

+ */

+ public function assert_checkbox_is_unchecked($crawler, $name, $message = '')

+ {

+ $this->assertSame(

+ '',

+ $this->assert_find_one_checkbox($crawler, $name)->attr('checked'),

+ $message ?: "Failed asserting that checkbox $name is unchecked."

+ );

+ }

+

+ /**

+ * Searches for an input element of type checkbox with the name $name using

+ * $crawler. Contains an assertion that only one such checkbox exists within

+ * the scope of $crawler.

+ *

+ * @param Symfony\Component\DomCrawler\Crawler $crawler

+ * @param string $name

+ * @param string $message

+ *

+ * @return Symfony\Component\DomCrawler\Crawler

+ */

+ public function assert_find_one_checkbox($crawler, $name, $message = '')

+ {

+ $query = sprintf('//input[@type="checkbox" and @name="%s"]', $name);

+ $result = $crawler->filterXPath($query);

+

+ $this->assertEquals(

+ 1,

+ sizeof($result),

+ $message ?: 'Failed asserting that exactly one checkbox with name' .

+ " $name exists in crawler scope."

+ );

+

+ return $result;

+ }

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

+<dataset>

+ <table name="phpbb_users">

+ <column>user_id</column>

+ <column>username</column>

+ <column>username_clean</column>

+ <row>

+ <value>1</value>

+ <value>Guest</value>

+ <value>guest</value>

+ </row>

+ <row>

+ <value>2</value>

+ <value>Admin</value>

+ <value>admin</value>

+ </row>

+ <row>

+ <value>3</value>

+ <value>Test</value>

+ <value>test</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

+*

+*/

+

+include_once(__DIR__ . '/../../phpBB/includes/utf/utf_tools.php');

+

+class phpbb_user_loader_test extends phpbb_database_test_case

+{

+ protected $db;

+ protected $user_loader;

+

+ public function getDataSet()

+ {

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

+ }

+

+ public function setUp()

+ {

+ parent::setUp();

+

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

+ $this->user_loader = new phpbb_user_loader($this->db, __DIR__ . '/../../phpBB/', 'php', 'phpbb_users');

+ }

+

+ public function test_load_get()

+ {

+ $this->user_loader->load_users(array(2));

+

+ $user = $this->user_loader->get_user(1);

+ $this->assertEquals(1, $user['user_id']);

+ $this->assertEquals('Guest', $user['username']);

+

+ $user = $this->user_loader->get_user(2);

+ $this->assertEquals(2, $user['user_id']);

+ $this->assertEquals('Admin', $user['username']);

+ }

+

+ public function test_load_get_unloaded()

+ {

+ $this->user_loader->load_users(array(2));

+

+ $user = $this->user_loader->get_user(3);

+ $this->assertEquals(1, $user['user_id']);

+ $this->assertEquals('Guest', $user['username']);

+

+ $user = $this->user_loader->get_user(3, true);

+ $this->assertEquals(3, $user['user_id']);

+ $this->assertEquals('Test', $user['username']);

+ }

+

+ public function test_load_user_by_username()

+ {

+ $user_id = $this->user_loader->load_user_by_username('Test');

+ $user = $this->user_loader->get_user($user_id);

+ $this->assertEquals(3, $user['user_id']);

+ $this->assertEquals('Test', $user['username']);

+ }

+}