'allow_bookmarks' => array('lang' => 'ALLOW_BOOKMARKS', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true),

'allow_birthdays' => array('lang' => 'ALLOW_BIRTHDAYS', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true),

'display_last_subject' => array('lang' => 'DISPLAY_LAST_SUBJECT', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true),

'allow_quick_reply' => array('lang' => 'ALLOW_QUICK_REPLY', 'validate' => 'bool', 'type' => 'custom', 'method' => 'quick_reply', 'explain' => true),

'legend2' => 'ACP_SUBMIT_CHANGES',

'DISABLE_BOARD_EXPLAIN' => 'This will make the board unavailable to users who are neither administrators nor moderators. You can also enter a short (255 character) message to display if you wish.',

'DISPLAY_LAST_SUBJECT' => 'Display subject of last added post on forum list',

'DISPLAY_LAST_SUBJECT_EXPLAIN' => 'The subject of the last added post will be displayed in the forum list with a hyperlink to the post. Subjects from password protected forums and forums in which user doesn’t have read access are not shown.',

'GUEST_STYLE' => 'Guest style',

'GUEST_STYLE_EXPLAIN' => 'The board style for guests.',

'OVERRIDE_STYLE' => 'Override user style',

'POST_TOPIC' => 'Post a new topic',

'POST_UNAPPROVED_ACTION' => 'Post awaiting approval:',

'POST_UNAPPROVED' => 'This post has not been approved.',

'POWERED_BY' => 'Powered by %s',

'PREVIEW' => 'Preview',

'PREVIOUS' => 'Previous', // Used in pagination

*/

public function is_visible($mode, $forum_id, $data)

{

/**

* Allow changing the result of calling is_visible

}

else

{

return '(' . $where_sql . ')';

}

<!-- EVENT viewtopic_body_postrow_post_details_after -->

<!-- IF postrow.S_POST_UNAPPROVED -->

<form method="post" class="mcp_approve" action="{postrow.U_APPROVE_ACTION}">

<p class="post-notice unapproved">

<span><i class="icon fa-question icon-red fa-fw" aria-hidden="true"></i></span>

{S_FORM_TOKEN}

</p>

</form>

<!-- ELSEIF postrow.S_POST_DELETED -->

<form method="post" class="mcp_approve" action="{postrow.U_APPROVE_ACTION}">

<p class="post-notice deleted">

// Replies

$replies = $phpbb_content_visibility->get_count('topic_posts', $row, $topic_forum_id) - 1;

if ($row['topic_status'] == ITEM_MOVED)

{

'S_HAS_ATTACHMENTS' => (!empty($attachments[$row['post_id']])) ? true : false,

'S_MULTIPLE_ATTACHMENTS' => !empty($attachments[$row['post_id']]) && count($attachments[$row['post_id']]) > 1,

'S_POST_UNAPPROVED' => ($row['post_visibility'] == ITEM_UNAPPROVED || $row['post_visibility'] == ITEM_REAPPROVE) ? true : false,

'S_POST_DELETED' => ($row['post_visibility'] == ITEM_DELETED) ? true : false,

'L_POST_DELETED_MESSAGE' => $l_deleted_message,

'S_POST_REPORTED' => ($row['post_reported'] && $auth->acl_get('m_report', $forum_id)) ? true : false,

<table name="phpbb_topics">

<column>topic_id</column>

<column>forum_id</column>

<column>topic_visibility</column>

<column>topic_title</column>

<row>

<value>1</value>

<value>1</value>

<value>0</value>

<value>Unapproved</value>

</row>

<row>

<value>2</value>

<value>1</value>

<value>1</value>

<value>Approved</value>

</row>

<value>3</value>

<value>1</value>

<value>2</value>

<value>Softdeleted</value>

</row>

</table>

<table name="phpbb_posts">

<column>post_id</column>

<column>topic_id</column>

<column>forum_id</column>

<column>post_visibility</column>

<column>post_text</column>

<row>

<value>1</value>

<value>1</value>

<value>0</value>

<value>Unapproved</value>

</row>

<row>

<value>2</value>

<value>2</value>

<value>1</value>

<value>1</value>

<value>Approved</value>

</row>

<value>3</value>

<value>3</value>

<value>1</value>

<value>2</value>

<value>Softdeleted</value>

</row>

</table>

</dataset>

public function get_visibility_sql_data()

{

return array(

array(

'phpbb_posts',

'post', 1, '',

array(

array('m_approve', 1, true),

array('post_id' => 1),

array('post_id' => 2),

array('post_id' => 3),

),

),

array(

'phpbb_posts',

'post', 1, '',

array(

),

array('post_id' => 2),

),

),

array(

'phpbb_topics',

'topic', 1, '',

array(

array('m_approve', 1, true),

array('topic_id' => 1),

array('topic_id' => 2),

array('topic_id' => 3),

),

),

array(

'phpbb_topics',

'topic', 1, '',

array(),

array(

array('topic_id' => 2),

),

),

);

}

/**

* @dataProvider get_visibility_sql_data

*/

{

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

$lang_loader = new \phpbb\language\language_file_loader($phpbb_root_path, $phpEx);

$lang = new \phpbb\language\language($lang_loader);

$user = new \phpbb\user($lang, '\phpbb\datetime');

$phpbb_dispatcher = new phpbb_mock_event_dispatcher();

$content_visibility = new \phpbb\content_visibility($auth, $config, $phpbb_dispatcher, $db, $user, $phpbb_root_path, $phpEx, FORUMS_TABLE, POSTS_TABLE, TOPICS_TABLE, USERS_TABLE);

FROM ' . $table . '

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

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

}

}