<project name="phpBB" description="The phpBB forum software" default="all" basedir="../">

<!-- a few settings for the build -->

<!-- no configuration should be needed beyond this point -->

<property name="oldversions" value="${olderversions}, ${prevversion}" />

<dl>

<dt><label>{L_AVATAR_TYPE}{L_COLON}</label></dt>

<dd><select name="avatar_driver" id="avatar_driver" data-togglable-settings="true">

<!-- BEGIN avatar_drivers -->

<option value="{avatar_drivers.DRIVER}"<!-- IF avatar_drivers.SELECTED --> selected="selected"<!-- ENDIF --> data-toggle-setting="#avatar_option_{avatar_drivers.DRIVER}">{avatar_drivers.L_TITLE}</option>

<!-- END avatar_drivers -->

<dl>

<dt><label>{L_AVATAR_TYPE}</label></dt>

<dd><select name="avatar_driver" id="avatar_driver" data-togglable-settings="true">

<!-- BEGIN avatar_drivers -->

<option value="{avatar_drivers.DRIVER}"<!-- IF avatar_drivers.SELECTED --> selected="selected"<!-- ENDIF --> data-toggle-setting="#avatar_option_{avatar_drivers.DRIVER}">{avatar_drivers.L_TITLE}</option>

<!-- END avatar_drivers -->

"sami/sami": "1.*",

"squizlabs/php_codesniffer": "1.*",

"symfony/browser-kit": "2.3.*",

"symfony/debug": "2.3.*",

"symfony/dom-crawler": "2.3.*",

"symfony/filesystem": "2.3.*",

"This file locks the dependencies of your project to a known state",

"Read more about it at http://getcomposer.org/doc/01-basic-usage.md#composer-lock-the-lock-file"

],

"packages": [

{

"name": "lusitanian/oauth",

},

{

"name": "symfony/config",

"target-dir": "Symfony/Component/Config",

"source": {

"type": "git",

"url": "https://github.com/symfony/Config.git",

},

"dist": {

"type": "zip",

"shasum": ""

},

"require": {

],

"authors": [

{

"name": "Symfony Community",

"homepage": "http://symfony.com/contributors"

}

],

"description": "Symfony Config Component",

"homepage": "http://symfony.com",

},

{

"name": "symfony/console",

"target-dir": "Symfony/Component/Console",

"source": {

"type": "git",

"url": "https://github.com/symfony/Console.git",

},

"dist": {

"type": "zip",

"shasum": ""

},

"require": {

],

"authors": [

{

"name": "Symfony Community",

"homepage": "http://symfony.com/contributors"

}

],

"description": "Symfony Console Component",

"homepage": "http://symfony.com",

},

{

"name": "symfony/debug",

"target-dir": "Symfony/Component/Debug",

"source": {

"type": "git",

"url": "https://github.com/symfony/Debug.git",

},

"dist": {

"type": "zip",

"shasum": ""

},

"require": {

],

"authors": [

{

"name": "Symfony Community",

"homepage": "http://symfony.com/contributors"

}

],

"description": "Symfony Debug Component",

"homepage": "http://symfony.com",

},

{

"name": "symfony/dependency-injection",

"target-dir": "Symfony/Component/DependencyInjection",

"source": {

"type": "git",

"url": "https://github.com/symfony/DependencyInjection.git",

},

"dist": {

"type": "zip",

"shasum": ""

},

"require": {

],

"authors": [

{

"name": "Symfony Community",

"homepage": "http://symfony.com/contributors"

}

],

"description": "Symfony DependencyInjection Component",

"homepage": "http://symfony.com",

},

{

"name": "symfony/event-dispatcher",

"target-dir": "Symfony/Component/EventDispatcher",

"source": {

"type": "git",

"url": "https://github.com/symfony/EventDispatcher.git",

},

"dist": {

"type": "zip",

"shasum": ""

},

"require": {

],

"authors": [

{

"name": "Symfony Community",

"homepage": "http://symfony.com/contributors"

}

],

"description": "Symfony EventDispatcher Component",

"homepage": "http://symfony.com",

},

{

"name": "symfony/filesystem",

"target-dir": "Symfony/Component/Filesystem",

"source": {

"type": "git",

"url": "https://github.com/symfony/Filesystem.git",

},

"dist": {

"type": "zip",

"shasum": ""

},

"require": {

],

"authors": [

{

"name": "Symfony Community",

"homepage": "http://symfony.com/contributors"

}

],

"description": "Symfony Filesystem Component",

"homepage": "http://symfony.com",

},

{

"name": "symfony/http-foundation",

"target-dir": "Symfony/Component/HttpFoundation",

"source": {

"type": "git",

"url": "https://github.com/symfony/HttpFoundation.git",

},

"dist": {

"type": "zip",

"shasum": ""

},

"require": {

],

"authors": [

{

"name": "Symfony Community",

"homepage": "http://symfony.com/contributors"

}

],

"description": "Symfony HttpFoundation Component",

"homepage": "http://symfony.com",

},

{

"name": "symfony/http-kernel",

"target-dir": "Symfony/Component/HttpKernel",

"source": {

"type": "git",

"url": "https://github.com/symfony/HttpKernel.git",

},

"dist": {

"type": "zip",

"shasum": ""

},

"require": {

],

"authors": [

{

"name": "Symfony Community",

"homepage": "http://symfony.com/contributors"

}

],

"description": "Symfony HttpKernel Component",

"homepage": "http://symfony.com",

},

{

"name": "symfony/routing",

"target-dir": "Symfony/Component/Routing",

"source": {

"type": "git",

"url": "https://github.com/symfony/Routing.git",

},

"dist": {

"type": "zip",

"shasum": ""

},

"require": {

],

"authors": [

{

"name": "Symfony Community",

"homepage": "http://symfony.com/contributors"

}

],

"description": "Symfony Routing Component",

"homepage": "http://symfony.com",

},

{

"name": "symfony/yaml",

"target-dir": "Symfony/Component/Yaml",

"source": {

"type": "git",

"url": "https://github.com/symfony/Yaml.git",

},

"dist": {

"type": "zip",

"shasum": ""

},

"require": {

],

"authors": [

{

"name": "Symfony Community",

"homepage": "http://symfony.com/contributors"

}

],

"description": "Symfony Yaml Component",

"homepage": "http://symfony.com",

},

{

"name": "twig/twig",

},

{

"name": "symfony/browser-kit",

"target-dir": "Symfony/Component/BrowserKit",

"source": {

"type": "git",

"url": "https://github.com/symfony/BrowserKit.git",

},

"dist": {

"type": "zip",

"shasum": ""

},

"require": {

],

"authors": [

{

"name": "Symfony Community",

"homepage": "http://symfony.com/contributors"

}

],

"description": "Symfony BrowserKit Component",

"homepage": "http://symfony.com",

},

{

"name": "symfony/css-selector",

"target-dir": "Symfony/Component/CssSelector",

"source": {

"type": "git",

"url": "https://github.com/symfony/CssSelector.git",

},

"dist": {

"type": "zip",

"shasum": ""

},

"require": {

],

"authors": [

{

"name": "Symfony Community",

"homepage": "http://symfony.com/contributors"

},

{

"name": "Jean-François Simon",

"email": "jeanfrancois.simon@sensiolabs.com"

}

],

"description": "Symfony CssSelector Component",

"homepage": "http://symfony.com",

},

{

"name": "symfony/dom-crawler",

"target-dir": "Symfony/Component/DomCrawler",

"source": {

"type": "git",

"url": "https://github.com/symfony/DomCrawler.git",

},

"dist": {

"type": "zip",

"shasum": ""

},

"require": {

],

"authors": [

{

"name": "Symfony Community",

"homepage": "http://symfony.com/contributors"

}

],

"description": "Symfony DomCrawler Component",

"homepage": "http://symfony.com",

},

{

"name": "symfony/finder",

"target-dir": "Symfony/Component/Finder",

"source": {

"type": "git",

"url": "https://github.com/symfony/Finder.git",

},

"dist": {

"type": "zip",

"shasum": ""

},

"require": {

],

"authors": [

{

"name": "Symfony Community",

"homepage": "http://symfony.com/contributors"

}

],

"description": "Symfony Finder Component",

"homepage": "http://symfony.com",

},

{

"name": "symfony/process",

"target-dir": "Symfony/Component/Process",

"source": {

"type": "git",

"url": "https://github.com/symfony/Process.git",

},

"dist": {

"type": "zip",

"shasum": ""

},

"require": {

],

"authors": [

{

"name": "Symfony Community",

"homepage": "http://symfony.com/contributors"

}

],

"description": "Symfony Process Component",

"homepage": "http://symfony.com",

}

],

"aliases": [

- %tables.auth_provider_oauth_account_assoc%

- @auth.provider.oauth.service_collection

- %tables.users%

- %core.root_path%

- %core.php_ext%

tags:

<ol>

<li><a href="#changelog">Changelog</a>

<ol style="list-style-type: lower-roman;">

<li><a href="#v310b3">Changes since 3.1.0-b3</a></li>

<li><a href="#v310b2">Changes since 3.1.0-b2</a></li>

<li><a href="#v310b1">Changes since 3.1.0-b1</a></li>

<div class="content">

<h4>Bug</h4>

<ul>

<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-12829">PHPBB3-12829</a>] - Remove check for pgsql 8.3/8.2</li>

</ul>

<h4>Bug</h4>

<ul>

</ul>

<h4>Bug</h4>

<ul>

</ul>

<h4>Bug</h4>

<ul>

</ul>

<h4>Bug</h4>

<ul>

<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-12302">PHPBB3-12302</a>] - Upgrade composer.phar to 1.0.0-alpha8</li>

</ul>

<h4>Bug</h4>

<ul>

</ul>

<h4>Bug</h4>

<ul>

<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-12147">PHPBB3-12147</a>] - Remove Travis CI notification configuration</li>

</ul>

<h4>Bug</h4>

<ul>

<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11998">PHPBB3-11998</a>] - Add console / command line client environment </li>

</ul>

<h4>Bug</h4>

<ul>

<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11913">PHPBB3-11913</a>] - Apply reorganisation of download.phpbb.com to build_announcement.php</li>

</ul>

<h4>Bug</h4>

<ul>

<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11753">PHPBB3-11753</a>] - Upgrade mysql_upgrader.php schema data.</li>

</ul>

<h4>Bug</h4>

<ul>

<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10909">PHPBB3-10909</a>] - Update Travis Test Configuration: Travis no longer supports PHP 5.3.2</li>

</ul>

<h4>Bug</h4>

<ul>

<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10480">PHPBB3-10480</a>] - Automate changelog building</li>

</ul>

<h4> Bug

</h4>

</ul>

<h4> Security

</h4>

<ul>

</ul>

<ul>

<li>[Sec] Do not expose forum content of forums with ACL entries but no actual permission in ATOM Feeds. (Bug #58595)</li>

</ul>

<ul>

<li>[Fix] Allow ban reason and length to be selected and copied in ACP and subsilver2 MCP. (Bug #51095)</li>

</ul>

<ul>

<li>[Fix] Allow whitespaces in avatar gallery names. (Bug #44955)</li>

<li>[Feature] Send anonymous statistical information to phpBB on installation and update (optional).</li>

</ul>

<ul>

<li>[Fix] Delete user entry from ban list table upon user deletion (Bug #40015 - Patch by TerraFrost)</li>

<li>[Sec] Only use forum id supplied for posting if global announcement detected. (Reported by nickvergessen)</li>

</ul>

<ul>

<li>[Fix] Allow mixed-case template directories to be inherited (Bug #36725)</li>

<li>[Sec] Ask for forum password if post within passworded forum quoted in private message. (Reported by nickvergessen)</li>

</ul>

<ul>

<li>[Fix] Correctly set topic starter if first post in topic removed (Bug #30575 - Patch by blueray2048)</li>

<li>[Sec Precaution] Stricter validation of the HTTP_HOST header (Thanks to Techie-Micheal et al for pointing out possible issues in derived code)</li>

</ul>

<ul>

<li>[Fix] Ability to set permissions on non-mysql dbms (Bug #24955)</li>

<li>[Sec] Only allow urls gone through redirect() being used within login_box(). (thanks nookieman)</li>

</ul>

<ul>

<li>[Change] Validate birthdays (Bug #15004)</li>

<li>[Fix] Find and display colliding usernames correctly when converting from one database to another (Bug #23925)</li>

</ul>

<ul>

<li>[Fix] Cleaned usernames contain only single spaces, so &quot;a_name&quot; and &quot;a__name&quot; are treated as the same name (Bug #15634)</li>

<li>[Fix] Call garbage_collection() within database updater to correctly close connections (affects Oracle for example)</li>

</ul>

<ul>

<li>[Fix] Fixed MSSQL related bug in the update system</li>

<li>[Fix] No duplication of active topics (Bug #15474)</li>

</ul>

<ul>

<li>[Fix] Submitting language changes using acp_language (Bug #14736)</li>

<li>[Fix] Able to request new password (Bug #14743)</li>

</ul>

<ul>

<li>[Feature] Removing constant PHPBB_EMBEDDED in favor of using an exit_handler(); the constant was meant to achive this more or less.</li>

<li>[Sec] New password hashing mechanism for storing passwords (#i42)</li>

</ul>

<ul>

<li>[Fix] MySQL, PostgreSQL and SQLite related database fixes (Bug #13862)</li>

<li>[Fix] odbc_autocommit causing existing result sets to be dropped (Bug #14182)</li>

</ul>

<ul>

<li>[Fix] Fixing some subsilver2 and prosilver style issues</li>

</ul>

<ul>

<li>[Fix] Re-allow searching within the memberlist</li>

</ul>

<ul>

<li>[Fix] (X)HTML issues within the templates (Bug #11255, #11255)</li>

* Since: 3.1.0-a1

* Purpose: Add entries before the user statistics part of any user profile

navbar_header_logged_out_content

===

* Locations:

* Since: 3.1.0-a4

* Purpose: Add data before posts

viewtopic_body_postrow_post_notices_after

===

* Locations:

}

}

// Did we submit?

if ($update)

{

if ($config['require_activation'] == USER_ACTIVATION_ADMIN)

{

$phpbb_notifications = $phpbb_container->get('notification_manager');

include_once($phpbb_root_path . 'includes/functions_messenger.' . $phpEx);

trigger_error($user->lang['FORM_INVALID'] . adm_back_link($this->u_action . '&amp;u=' . $user_id), E_USER_WARNING);

}

// Delete old avatar if present

$phpbb_avatar_manager = $phpbb_container->get('avatar.manager');

add_log('admin', 'LOG_USER_DEL_AVATAR', $user_row['username']);

add_log('user', $user_id, 'LOG_USER_DEL_AVATAR_USER');

trigger_error($user->lang['USER_AVATAR_UPDATED'] . adm_back_link($this->u_action . '&amp;u=' . $user_id));

}

}

}

else

{

}

}

$selected_driver = $phpbb_avatar_manager->clean_driver_name($request->variable('avatar_driver', $user_row['user_avatar_type']));

foreach ($avatar_drivers as $current_driver)

*/

// phpBB Version

// QA-related

// define('PHPBB_QA', 1);

* @param array $allowed_units only allow these units (data array indexes)

*

* @return mixed data array if $string_only is false

*/

function get_formatted_filesize($value, $string_only = true, $allowed_units = false)

{

* @param int $perms Permissions to set

*

* @return bool true on success, otherwise false

*/

function phpbb_chmod($filename, $perms = CHMOD_READ)

{

// Mark all topic notifications read for this user

$phpbb_notifications->mark_notifications_read(array(

), false, $user->data['user_id'], $post_time);

if ($config['load_db_lastread'] && $user->data['is_registered'])

$phpbb_notifications = $phpbb_container->get('notification_manager');

$phpbb_notifications->mark_notifications_read_by_parent(array(

), $forum_id, $user->data['user_id'], $post_time);

// Mark all post/quote notifications read for this user in this forum

$db->sql_freeresult($result);

$phpbb_notifications->mark_notifications_read_by_parent(array(

), $topic_ids, $user->data['user_id'], $post_time);

// Add 0 to forums array to mark global announcements correctly

// Mark post notifications read for this user in this topic

$phpbb_notifications->mark_notifications_read(array(

), $topic_id, $user->data['user_id'], $post_time);

$phpbb_notifications->mark_notifications_read_by_parent(array(

), $topic_id, $user->data['user_id'], $post_time);

if ($config['load_db_lastread'] && $user->data['is_registered'])

if (empty($sql_sort))

{

}

if ($config['load_db_lastread'] && $user->data['is_registered'])

*

* @return mixed false if specified address is not valid,

* string otherwise

*/

function phpbb_ip_normalise($address)

{

*

* @return mixed false on failure,

* string otherwise

*/

function phpbb_inet_ntop($in_addr)

{

*

* @return mixed false if address is invalid,

* in_addr representation of the given address otherwise (string)

*/

function phpbb_inet_pton($address)

{

*

* Since null can also be returned, you probably want to compare the result

* with === true or === false,

*/

function phpbb_checkdnsrr($host, $type = 'MX')

{

/**

* Get avatar

*

* @param string $alt Optional language string for alt tag within image, can be a language key or text

* @param bool $ignore_config Ignores the config-setting, to be still able to view the avatar in the UCP

*

* @param string $table constant or fullname of the table

* @param int $parent_id parent_id of the current set (default = 0)

* @param array $where contains strings to compare closer on the where statement (additional)

*/

function recalc_nested_sets(&$new_id, $pkey, $table, $parent_id = 0, $where = array())

{

* @param bool $add_log True if log entry should be added

*

* @return bool False on error

*/

function copy_forum_permissions($src_forum_id, $dest_forum_ids, $clear_dest_perms = true, $add_log = true)

{

$phpbb_notifications = $phpbb_container->get('notification_manager');

$phpbb_notifications->delete_notifications(array(

), $topic_ids);

return $return;

// Notifications types to delete

$delete_notifications_types = array(

);

/**

* @param bool $auto_sync Will call sync() if this is true

*

* @return array Array with affected forums

*/

function delete_topic_shadows($forum_id, $sql_more = '', $auto_sync = true)

{

* @param string $custom_profile_url optional parameter to specify a profile url. The user id get appended to this url as &amp;u={user_id}

*

* @return string A string consisting of what is wanted based on $mode.

*/

function get_username_string($mode, $user_id, $username, $username_colour = '', $guest_username = false, $custom_profile_url = false)

{

$limit_days = array(0 => $user->lang['ALL_TOPICS'], 1 => $user->lang['1_DAY'], 7 => $user->lang['7_DAYS'], 14 => $user->lang['2_WEEKS'], 30 => $user->lang['1_MONTH'], 90 => $user->lang['3_MONTHS'], 180 => $user->lang['6_MONTHS'], 365 => $user->lang['1_YEAR']);

$sort_by_text = array('a' => $user->lang['AUTHOR'], 't' => $user->lang['POST_TIME'], 'tt' => $user->lang['TOPIC_TIME'], 'r' => $user->lang['REPLIES'], 's' => $user->lang['SUBJECT'], 'v' => $user->lang['VIEWS']);

$limit_time_sql = ($min_time) ? "AND t.topic_last_post_time >= $min_time" : '';

break;

case 'posts':

$limit_days = array(0 => $user->lang['ALL_POSTS'], 1 => $user->lang['1_DAY'], 7 => $user->lang['7_DAYS'], 14 => $user->lang['2_WEEKS'], 30 => $user->lang['1_MONTH'], 90 => $user->lang['3_MONTHS'], 180 => $user->lang['6_MONTHS'], 365 => $user->lang['1_YEAR']);

$sort_by_text = array('a' => $user->lang['AUTHOR'], 't' => $user->lang['POST_TIME'], 's' => $user->lang['SUBJECT']);

$limit_time_sql = ($min_time) ? "AND p.post_time >= $min_time" : '';

break;

case 'reports':

$limit_days = array(0 => $user->lang['ALL_REPORTS'], 1 => $user->lang['1_DAY'], 7 => $user->lang['7_DAYS'], 14 => $user->lang['2_WEEKS'], 30 => $user->lang['1_MONTH'], 90 => $user->lang['3_MONTHS'], 180 => $user->lang['6_MONTHS'], 365 => $user->lang['1_YEAR']);

$sort_by_text = array('a' => $user->lang['AUTHOR'], 'r' => $user->lang['REPORTER'], 'p' => $user->lang['POST_TIME'], 't' => $user->lang['REPORT_TIME'], 's' => $user->lang['SUBJECT']);

break;

case 'pm_reports':

$sort_key = $default_key;

}

$s_limit_days = $s_sort_key = $s_sort_dir = $sort_url = '';

gen_sort_selects($limit_days, $sort_by_text, $sort_days, $sort_key, $sort_dir, $s_limit_days, $s_sort_key, $s_sort_dir, $sort_url);

global $config, $phpbb_root_path, $phpEx, $phpbb_container;

$phpbb_content_visibility = $phpbb_container->get('content.visibility');

// Go ahead and pull all data for this topic

$sql = 'SELECT p.post_id

AND " . $phpbb_content_visibility->get_visibility_sql('post', $forum_id, 'p.') . '

' . (($mode == 'post_review') ? " AND p.post_id > $cur_post_id" : '') . '

' . (($mode == 'post_review_edit') ? " AND p.post_id = $cur_post_id" : '') . '

$result = $db->sql_query_limit($sql, $config['posts_per_page']);

$post_list = array();

WHERE p.topic_id = $topic_id

AND p.poster_id = u.user_id

AND p.post_visibility = " . ITEM_APPROVED . '

$result = $db->sql_query_limit($sql, 1);

$row = $db->sql_fetchrow($result);

$db->sql_freeresult($result);

FROM ' . POSTS_TABLE . ' p, ' . USERS_TABLE . " u

WHERE p.topic_id = $topic_id

AND p.poster_id = u.user_id

$result = $db->sql_query_limit($sql, 1);

$row = $db->sql_fetchrow($result);

$db->sql_freeresult($result);

WHERE topic_id = $topic_id

AND " . $phpbb_content_visibility->get_visibility_sql('post', $forum_id) . '

AND post_time > ' . $data['post_time'] . '

$result = $db->sql_query_limit($sql, 1);

$next_post_id = (int) $db->sql_fetchfield('post_id');

$db->sql_freeresult($result);

{

case 'post':

$phpbb_notifications->add_notifications(array(

), $notification_data);

break;

case 'reply':

case 'quote':

$phpbb_notifications->add_notifications(array(

), $notification_data);

break;

case 'edit':

case 'edit_last_post':

$phpbb_notifications->update_notifications(array(

), $notification_data);

break;

}

switch ($mode)

{

case 'post':

break;

case 'reply':

case 'quote':

break;

case 'edit_topic':

{

case 'edit_topic':

case 'edit_first_post':

// Delete the approve_post notification so we can notify the user again,

// when his post got reapproved

break;

case 'edit':

case 'edit_last_post':

// Delete the approve_post notification so we can notify the user again,

// when his post got reapproved

break;

case 'post':

$phpbb_notifications = $phpbb_container->get('notification_manager');

$sql = 'UPDATE ' . PRIVMSGS_TO_TABLE . "

SET pm_unread = 0

$phpbb_notifications = $phpbb_container->get('notification_manager');

// Now we have to check which messages we can delete completely

$sql = 'SELECT msg_id

AND ' . $db->sql_in_set('msg_id', $delivered_msg);

$db->sql_query($sql);

}

if (!empty($undelivered_msg))

WHERE ' . $db->sql_in_set('msg_id', $undelivered_msg);

$db->sql_query($sql);

}

}

WHERE ' . $db->sql_in_set('msg_id', $delete_ids);

$db->sql_query($sql);

}

}

if ($mode == 'edit')

{

}

else

{

}

/**

/**

* FTP fsock transfer class

*/

class ftp_fsock extends transfer

{

foreach ($add_id_ary as $user_id)

{

'group_id' => $group_id,

'user_id' => $user_id,

'group_name' => $group_name,

$phpbb_notifications = $phpbb_container->get('notification_manager');

// Return false - no error

return false;

$phpbb_notifications = $phpbb_container->get('notification_manager');

'user_ids' => $user_id_ary,

'group_id' => $group_id,

'group_name' => $group_name,

));

$log = 'LOG_USERS_APPROVED';

break;

FROM ' . POSTS_TABLE . '

WHERE ' . $db->sql_in_set('forum_id', $forum_list) . '

AND ' . $db->sql_in_set('post_visibility', array(ITEM_UNAPPROVED, ITEM_REAPPROVE)) . '

$result = $db->sql_query_limit($sql, 5);

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

WHERE ' . $db->sql_in_set('p.post_id', $post_list) . '

AND t.topic_id = p.topic_id

AND p.poster_id = u.user_id

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

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

AND p.poster_id = u2.user_id

AND ' . $db->sql_in_set('p.forum_id', $forum_list),

);

/**

$sql = 'SELECT *

FROM ' . POSTS_TABLE . "

WHERE topic_id = $topic_id

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

$post_rows = array();

$phpbb_notifications = $phpbb_container->get('notification_manager');

$pm_id = $report['pm_id'];

$report_id = $report['report_id'];

{

$post_id = (int) $topic_info[$topic_id]['topic_first_post_id'];

}

else

{

}

}

$post_info = phpbb_get_post_data(array($post_id), 'm_approve', true);

// A single topic approval may also happen here, so handle deleting the respective notification.

if (!$post_data['topic_posts_approved'])

{

if ($post_data['post_visibility'] == ITEM_UNAPPROVED)

{

}

if ($post_data['post_visibility'] != ITEM_APPROVED)

{

if ($post_data['post_visibility'] == ITEM_UNAPPROVED)

{

$phpbb_notifications->add_notifications(array(

), $post_data);

}

}

$phpbb_notifications->mark_notifications_read(array(

), $post_data['post_id'], $user->data['user_id']);

// Notify Poster?

if (!$post_data['topic_posts_approved'])

{

}

else

{

}

}

}

'post_username' => $topic_data['topic_first_poster_name'],

));

// Only add notifications, if we are not reapproving post

// When the topic was already approved, but was edited and

if ($topic_data['topic_visibility'] == ITEM_UNAPPROVED)

{

$phpbb_notifications->add_notifications(array(

), $topic_data);

}

if ($notify_poster)

{

}

}

}

$topic_information[$topic_id]['topic_posts_softdeleted'] == 0 &&

$topic_information[$topic_id]['topic_posts_unapproved'] == $topic_posts_unapproved[$topic_id];

// Do we disapprove the whole topic? Remove potential notifications

if ($disapprove_all_posts_in_topic)

{

}

// Notify Poster?

{

// If there is only 1 post when disapproving the topic,

// we send the user a "disapprove topic" notification...

}

else

{

// ... otherwise there are multiple unapproved posts and

// all of them are disapproved as posts.

}

}

}

$phpbb_notifications = $phpbb_container->get('notification_manager');

if (!$report_id && $report['report_closed'])

{

AND r.pm_id = 0

$limit_time_sql

ORDER BY $sort_order_sql";

$result = $db->sql_query_limit($sql, $config['topics_per_page'], $start);

$i = 0;

if ($pm)

{

add_log('mod', 0, 0, 'LOG_PM_REPORT_' . strtoupper($action) . 'D', $post_info[$report['pm_id']]['message_subject']);

}

else

{

add_log('mod', $post_info[$report['post_id']]['forum_id'], $post_info[$report['post_id']]['topic_id'], 'LOG_REPORT_' . strtoupper($action) . 'D', $post_info[$report['post_id']]['post_subject']);

}

}

if ($pm)

{

'reporter' => $reporter['user_id'],

'closer_id' => $user->data['user_id'],

'from_user_id' => $post_info[$post_id]['author_id'],

}

else

{

'reporter' => $reporter['user_id'],

'closer_id' => $user->data['user_id'],

)));

$message_parser = new parse_message();

$message_parser->parse(true, true, true, false, false, true, true);

$pm_data = array(

'address_list' => array('u' => array($user_row['user_id'] => 'to')),

);

}

add_log('admin', 'LOG_USER_WARNING', $user_row['username']);

if ($config['require_activation'] == USER_ACTIVATION_ADMIN && !$update_password)

{

$phpbb_notifications = $phpbb_container->get('notification_manager');

include_once($phpbb_root_path . 'includes/functions_messenger.' . $phpEx);

$avatar_data = \phpbb\avatar\manager::clean_row($group_row, 'group');

}

// Did we submit?

if ($update)

{

$submit_ary = array_merge($submit_ary, $result);

}

}

// Merge any avatars errors into the primary error array

$error = array_merge($error, $phpbb_avatar_manager->localize_errors($user, $avatar_error));

FROM $sql_from

WHERE t.topic_type = " . POST_GLOBAL . '

AND ' . $db->sql_in_set('t.forum_id', $forum_ary) . '

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

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

AND t.topic_id = tw.topic_id

AND ' . $db->sql_in_set('t.forum_id', $forbidden_forum_ary, true, true),

);

$sql_array['LEFT_JOIN'] = array();

'WHERE' => 'b.user_id = ' . $user->data['user_id'] . '

AND ' . $db->sql_in_set('f.forum_id', $forbidden_forum_ary, true, true),

);

$sql_array['LEFT_JOIN'] = array();

{

foreach($notification_methods as $method => $method_data)

{

{

$phpbb_notifications->add_subscription($type, 0, $method_data['id']);

}

{

$phpbb_notifications->delete_subscription($type, 0, $method_data['id']);

}

}

{

$phpbb_notifications->add_subscription($type);

}

{

$phpbb_notifications->delete_subscription($type);

}

$limit_topic_days = array(0 => $user->lang['ALL_TOPICS'], 1 => $user->lang['1_DAY'], 7 => $user->lang['7_DAYS'], 14 => $user->lang['2_WEEKS'], 30 => $user->lang['1_MONTH'], 90 => $user->lang['3_MONTHS'], 180 => $user->lang['6_MONTHS'], 365 => $user->lang['1_YEAR']);

$sort_by_topic_text = array('a' => $user->lang['AUTHOR'], 't' => $user->lang['POST_TIME'], 'r' => $user->lang['REPLIES'], 's' => $user->lang['SUBJECT'], 'v' => $user->lang['VIEWS']);

// Post ordering options

$limit_post_days = array(0 => $user->lang['ALL_POSTS'], 1 => $user->lang['1_DAY'], 7 => $user->lang['7_DAYS'], 14 => $user->lang['2_WEEKS'], 30 => $user->lang['1_MONTH'], 90 => $user->lang['3_MONTHS'], 180 => $user->lang['6_MONTHS'], 365 => $user->lang['1_YEAR']);

trigger_error($message);

}

}

}

else

{

}

}

$selected_driver = $phpbb_avatar_manager->clean_driver_name($request->variable('avatar_driver', $user->data['user_avatar_type']));

foreach ($avatar_drivers as $current_driver)

if ($config['require_activation'] == USER_ACTIVATION_ADMIN)

{

$phpbb_notifications = $phpbb_container->get('notification_manager');

'user_id' => $user_id,

'user_actkey' => $user_row['user_actkey'],

'user_regdate' => $user_row['user_regdate'],

$convertor_data = array(

'forum_name' => 'phpBB 2.0.x',

'version' => '1.0.3',

'author' => '<a href="https://www.phpbb.com/">phpBB Limited</a>',

'dbms' => $dbms,

'dbhost' => $dbhost,

"UINT",

0

],

""

],

""

],

"pf_phpbb_facebook": [

"VCHAR",

""

],

""

],

""

],

"VCHAR",

""

],

"VCHAR",

""

],

"VCHAR",

""

],

"pf_phpbb_aol": [

"VCHAR",

""

INSERT INTO phpbb_config (config_name, config_value) VALUES ('upload_icons_path', 'images/upload_icons');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('upload_path', 'files');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('use_system_cron', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('warnings_expire_days', '90');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('warnings_gc', '14400');

INSERT INTO phpbb_profile_fields (field_name, field_type, field_ident, field_length, field_minlen, field_maxlen, field_novalue, field_default_value, field_validation, field_required, field_show_novalue, field_show_on_reg, field_show_on_pm, field_show_on_vt, field_show_on_ml, field_show_profile, field_hide, field_no_view, field_active, field_order, field_is_contact, field_contact_desc, field_contact_url) VALUES ('phpbb_googleplus', 'profilefields.type.googleplus', 'phpbb_googleplus', '20', '3', '255', '', '', '[\w]+', 0, 0, 0, 1, 1, 1, 1, 0, 0, 1, 13, 1, 'VIEW_GOOGLEPLUS_PROFILE', 'http://plus.google.com/%s');

# User Notification Options (for first user)

# POSTGRES COMMIT #

'CLI_EXTENSION_PURGE_FAILURE' => 'Could not purge extension %s',

'CLI_EXTENSION_PURGE_SUCCESS' => 'Successfully purged extension %s',

'CLI_EXTENSION_NOT_FOUND' => 'No extensions were found.',

'CLI_FIXUP_RECALCULATE_EMAIL_HASH_SUCCESS' => 'Successfully recalculated all email hashes.',

));

'CONFIRM_CODE_EXPLAIN' => 'Enter the code exactly as it appears. All letters are case insensitive.',

'CONFIRM_CODE_WRONG' => 'The confirmation code you entered was incorrect.',

'CONFIRM_OPERATION' => 'Are you sure you wish to carry out this operation?',

'CONGRATULATIONS' => 'Congratulations to',

'CONNECTION_FAILED' => 'Connection failed.',

'CONNECTION_SUCCESS' => 'Connection was successful!',

'NO_AUTH_ADMIN_USER_DIFFER' => 'You are not able to re-authenticate as a different user.',

'NO_AUTH_OPERATION' => 'You do not have the necessary permissions to complete this operation.',

'NO_AVATARS' => 'No avatars currently available',

'NO_CONNECT_TO_SMTP_HOST' => 'Could not connect to smtp host : %1$s : %2$s',

'NO_BIRTHDAYS' => 'No birthdays today',

'NO_EMAIL_MESSAGE' => 'Email message was blank.',

protected $current_uri;

/**

* phpBB root path

*

* @var string

* @param string $auth_provider_oauth_token_account_assoc

* @param \phpbb\di\service_collection $service_providers Contains \phpbb\auth\provider\oauth\service_interface

* @param string $users_table

* @param string $phpbb_root_path

* @param string $php_ext

*/

{

$this->db = $db;

$this->config = $config;

$this->auth_provider_oauth_token_account_assoc = $auth_provider_oauth_token_account_assoc;

$this->service_providers = $service_providers;

$this->users_table = $users_table;

$this->phpbb_root_path = $phpbb_root_path;

$this->php_ext = $php_ext;

}

// Temporary workaround for only having one authentication provider available

if (!$this->request->is_set('oauth_service'))

{

return $provider->login($username, $password);

}

$row['avatar_width'] = $request->variable('avatar_gravatar_width', 0);

$row['avatar_height'] = $request->variable('avatar_gravatar_height', 0);

if (!function_exists('validate_data'))

{

require($this->phpbb_root_path . 'includes/functions_user.' . $this->php_ext);

if (empty($category) || empty($file))

{

return false;

}

$width = $request->variable('avatar_remote_width', 0);

$height = $request->variable('avatar_remote_height', 0);

if (!preg_match('#^(http|https|ftp)://#i', $url))

{

$url = 'http://' . $url;

}

else

{

return false;

}

static protected $default_row = array(

'avatar' => '',

'avatar_type' => '',

);

/**

return $error;

}

}

}

$enabled = array_keys($this->manager->all_enabled());

$output->writeln('');

$disabled = array_keys($this->manager->all_disabled());

$output->writeln('');

$purged = array_diff($all, $enabled, $disabled);

}

protected function print_extension_list(OutputInterface $output, $type, array $extensions)

{

foreach ($extensions as $extension)

{

$this->routes = new RouteCollection;

foreach ($this->routing_files as $file_path)

{

$this->routes->addCollection($loader->load($file_path));

}

}

/**

* Creates the migrations table if it does not exist.

* @return null

*/

WHERE forum_id = ' . $this->forum_id . '

AND topic_moved_id = 0

AND ' . $this->content_visibility->get_visibility_sql('topic', $this->forum_id) . '

$result = $this->db->sql_query_limit($sql, $this->num_items);

$topic_ids = array();

AND ' . $this->content_visibility->get_visibility_sql('post', $this->forum_id, 'p.') . '

AND p.post_time >= ' . $min_post_time . '

AND p.poster_id = u.user_id',

);

return true;

),

'WHERE' => 'p.topic_id = t.topic_id

AND ' . $this->db->sql_in_set('p.post_id', $post_ids),

);

return true;

FROM ' . TOPICS_TABLE . '

WHERE topic_moved_id = 0

AND ' . $this->content_visibility->get_forums_visibility_sql('topic', $forum_ids) . '

$result = $this->db->sql_query_limit($sql, $this->num_items);

$topic_ids = array();

AND ' . $this->content_visibility->get_forums_visibility_sql('post', $forum_ids, 'p.') . '

AND p.post_time >= ' . $min_post_time . '

AND u.user_id = p.poster_id',

);

return true;

'WHERE' => 'p.topic_id = ' . $this->topic_id . '

AND ' . $this->content_visibility->get_visibility_sql('post', $this->forum_id, 'p.') . '

AND p.poster_id = u.user_id',

);

return true;

),

'WHERE' => 'p.topic_id = t.topic_id

AND ' . $this->db->sql_in_set('p.post_id', $post_ids),

);

return true;

WHERE topic_moved_id = 0

AND ' . $this->content_visibility->get_forums_visibility_sql('topic', $in_fid_ary) . '

' . $last_post_time_sql . '

$result = $this->db->sql_query_limit($sql, $this->num_items);

$post_ids = array();

),

'WHERE' => 'p.topic_id = t.topic_id

AND ' . $this->db->sql_in_set('p.post_id', $post_ids),

);

return true;

{

$subscription_methods[$method_name] = array(

'id' => $method->get_type(),

);

}

}

*/

public function get_item_type_class($notification_type_name, $data = array())

{

$item = $this->load_object($notification_type_name);

$item->set_initial_data($data);

*/

public function get_method_class($method_name)

{

return $this->load_object($method_name);

}

*/

public function get_type()

{

}

/**

*/

public function get_type()

{

}

/**

*/

public function get_type()

{

}

/**

*/

public function get_type()

{

}

/**

*/

public function get_type()

{

}

/**

*/

public function get_type()

{

}

/**

*/

public function get_type()

{

}

/**

*/

public function get_type()

{

}

/**

*/

public function get_type()

{

}

/**

*/

public function get_type()

{

}

/**

*/

public function get_type()

{

}

/**

*/

public function get_type()

{

}

/**

*/

public function get_type()

{

}

/**

* Array of data (including keys 'id', 'lang', and 'group')

*/

public static $notification_option = array(

'lang' => 'NOTIFICATION_TYPE_IN_MODERATION_QUEUE',

'group' => 'NOTIFICATION_GROUP_MODERATION',

);

*/

public function get_type()

{

}

/**

*/

public function get_type()

{

}

/**

* Array of data (including keys 'id', 'lang', and 'group')

*/

public static $notification_option = array(

'lang' => 'NOTIFICATION_TYPE_REPORT',

'group' => 'NOTIFICATION_GROUP_MODERATION',

);

*/

public function get_type()

{

}

/**

*/

public function get_type()

{

}

/**

* Array of data (including keys 'id' and 'lang')

*/

public static $notification_option = array(

'lang' => 'NOTIFICATION_TYPE_REPORT',

'group' => 'NOTIFICATION_GROUP_MODERATION',

);

*/

public function get_type()

{

}

/**

*/

public function get_type()

{

}

/**

*/

public function get_type()

{

}

/**

* Array of data (including keys 'id', 'lang', and 'group')

*/

public static $notification_option = array(

'lang' => 'NOTIFICATION_TYPE_IN_MODERATION_QUEUE',

'group' => 'NOTIFICATION_GROUP_MODERATION',

);

}

$names = $this->get_user_style();

$paths = array();

foreach ($style_directories as $directory)

$lang_return = $user->lang['RETURN_TOPIC'];

$lang_success = $user->lang['POST_REPORTED_SUCCESS'];

'report_text' => $report_text,

)));

}

$lang_return = $user->lang['RETURN_PM'];

$lang_success = $user->lang['PM_REPORTED_SUCCESS'];

'report_text' => $report_text,

'from_user_id' => $report_data['author_id'],

'report_id' => $report_id,

trigger_error($error);

}

// let the search module split up the keywords

if ($keywords)

{

$correct_query = $search->split_keywords($keywords, $search_terms);

if (!$correct_query || (!$search->get_search_query() && !sizeof($author_id_ary) && !$search_id))

{

$ignored = (sizeof($common_words)) ? sprintf($user->lang['IGNORED_TERMS_EXPLAIN'], implode(' ', $common_words)) . '<br />' : '';

'SEARCH_MATCHES' => $l_search_matches,

'SEARCH_WORDS' => $keywords,

'SEARCHED_QUERY' => $search->get_search_query(),

'PHRASE_SEARCH_DISABLED' => $phrase_search_disabled,

# General Information about this style

name = prosilver

copyright = © phpBB Limited, 2007

# Defining a different template bitfield

# template_bitfield = lNg=

<!-- IF S_ENABLE_FEEDS and forumrow.S_FEED_ENABLED --><!-- <a class="feed-icon-forum" title="{L_FEED} - {forumrow.FORUM_NAME}" href="{U_FEED}?f={forumrow.FORUM_ID}"><img src="{T_THEME_PATH}/images/feed.gif" alt="{L_FEED} - {forumrow.FORUM_NAME}" /></a> --><!-- ENDIF -->

<!-- IF forumrow.FORUM_IMAGE --><span class="forum-image">{forumrow.FORUM_IMAGE}</span><!-- ENDIF -->

<!-- IF forumrow.MODERATORS -->

<br /><strong>{forumrow.L_MODERATOR_STR}{L_COLON}</strong> {forumrow.MODERATORS}

<!-- ENDIF -->

</div>

</div>

<div class="panel">

<div class="inner">

</div>

</div>

<fieldset class="submit-buttons">

<input type="reset" value="{L_RESET}" name="reset" class="button2" />&nbsp;

<input type="submit" name="action[add_warning]" value="{L_SUBMIT}" class="button1" />

</div>

</div>

<div class="panel">

<div class="inner">

</div>

</div>

<fieldset class="submit-buttons">

<input type="reset" value="{L_RESET}" name="reset" class="button2" />&nbsp;

<input type="submit" name="action[add_warning]" value="{L_SUBMIT}" class="button1" />

<!-- INCLUDE simple_header.html -->

<form method="post" action="{S_IM_ACTION}">

<!-- IF AVATAR_IMG -->

<dl class="left-box">

<!-- IF RANK_TITLE --><dd style="text-align: center;">{RANK_TITLE}</dd><!-- ENDIF -->

<!-- IF RANK_IMG --><dd style="text-align: center;">{RANK_IMG}</dd><!-- ENDIF -->

</dl>

<dl class="details">

<!-- IF U_EMAIL --><dt>{L_EMAIL_ADDRESS}{L_COLON}</dt> <dd><a href="{U_EMAIL}">{L_SEND_EMAIL_USER}</a></dd><!-- ENDIF -->

<!-- IF U_PM --><dt>{L_PM}{L_COLON}</dt> <dd><a href="{U_PM}">{L_SEND_PRIVATE_MESSAGE}</a></dd><!-- ENDIF -->

<!-- BEGIN custom_fields -->

<!-- IF custom_fields.S_PROFILE_CONTACT -->

<dt>{custom_fields.PROFILE_FIELD_NAME}{L_COLON}</dt>

<!-- END smiley -->

<!-- ENDIF -->

<!-- IF S_SHOW_SMILEY_LINK and S_SMILIES_ALLOWED-->

<!-- ENDIF -->

<!-- IF BBCODE_STATUS -->

<a href="#tabs" data-subpanel="attach-panel" role="tab" aria-controls="attach-panel">

{L_ATTACHMENTS} <strong id="file-total-progress"><strong id="file-total-progress-bar"></strong></strong>

</a>

<!-- ENDIF -->

<!-- IF S_SHOW_POLL_BOX || S_POLL_DELETE -->

<li id="poll-panel-tab" class="tab">

<!-- EVENT simple_header_body_before -->

<a id="top" class="anchor" accesskey="t"></a>

<div id="page-body">

<dl>

<dt><label>{L_AVATAR_TYPE}{L_COLON}</label></dt>

<dd><select name="avatar_driver" id="avatar_driver" data-togglable-settings="true">

<!-- BEGIN avatar_drivers -->

<option value="{avatar_drivers.DRIVER}"<!-- IF avatar_drivers.SELECTED --> selected="selected"<!-- ENDIF --> data-toggle-setting="#avatar_option_{avatar_drivers.DRIVER}">{avatar_drivers.L_TITLE}</option>

<!-- END avatar_drivers -->

<!-- ENDIF -->

<div class="inner">

<dl class="postprofile" id="profile{MESSAGE_ID}">

<!-- IF REMAINDER eq 0 -->

<div>

<!-- ENDIF -->

<span class="contact-icon {contact.ID}-icon">{contact.NAME}</span>

</a>

<!-- IF REMAINDER eq 3 or contact.S_LAST_ROW -->

<!-- INCLUDE simple_header.html -->

<div class="panel">

<div class="inner">

</div>

</div>

<a href="#" onclick="window.close(); return false;">{L_CLOSE_WINDOW}</a>

<!-- IF .pagination or TOTAL_POSTS -->

<div class="pagination">

<!-- IF .pagination -->

<!-- INCLUDE pagination.html -->

<!-- ELSE -->

<!-- IF postrow.S_FIRST_UNREAD -->

<a id="unread" class="anchor"<!-- IF S_UNREAD_VIEW --> data-url="{postrow.U_MINI_POST}"<!-- ENDIF -->></a>

<!-- ENDIF -->

<div class="inner">

<dl class="postprofile" id="profile{postrow.POST_ID}"<!-- IF postrow.S_POST_HIDDEN --> style="display: none;"<!-- ENDIF -->>

<!-- IF REMAINDER eq 0 -->

<div>

<!-- ENDIF -->

<span class="contact-icon {postrow.contact.ID}-icon">{postrow.contact.NAME}</span>

</a>

<!-- IF REMAINDER eq 3 or postrow.contact.S_LAST_ROW -->

<!-- IF postrow.BUMPED_MESSAGE --><div class="notice"><br /><br />{postrow.BUMPED_MESSAGE}</div><!-- ENDIF -->

<!-- EVENT viewtopic_body_postrow_post_notices_after -->

<!-- IF postrow.SIGNATURE --><div id="sig{postrow.POST_ID}" class="signature">{postrow.SIGNATURE}</div><!-- ENDIF -->

</div>

</div>

<!-- IF .pagination or TOTAL_POSTS -->

<div class="pagination">

<!-- IF .pagination -->

<!-- INCLUDE pagination.html -->

<!-- ELSE -->

<div class="dropdown-container dropdown-button-control topic-tools">

<span title="{L_TOPIC_TOOLS}" class="button icon-button tools-icon dropdown-trigger dropdown-select"></span>

<div class="dropdown hidden">

float: right;

}

.rtl p.post-notice {

padding-left: 5px;

padding-right: 26px;

float: left;

}

.rtl .post-buttons li {

float: right;

}

margin-left: 5px;

margin-right: 0;

}

}

margin-top: 2px;

}

.post-buttons > li {

float: left;

margin-right: 3px;

}

}

#page-body {

margin: 4px 0;

clear: both;

background-repeat: no-repeat;

background-position: 100% 0;

border-radius: 7px;

}

.rowbg {

float: left;

width: auto;

text-align: left;

}

.left-box.profile-details {

float: right;

width: auto;

text-align: right;

}

dl.details {

line-height: 1.48em;

width: 76%;

float: left;

}

.postbody .ignore {

float: left;

font-size: 1.5em;

padding: 2px 0 0 0;

text-transform: none;

border: none;

font-family: "Trebuchet MS", Verdana, Helvetica, Arial, sans-serif;

vertical-align: bottom;

}

.postbody .content {

font-size: 1.3em;

overflow-x: auto;

width: 30%;

}

/* pm list in compose message if mass pm is enabled */

dl.pmlist dt {

width: 60% !important;

}

.file-status.file-working {

}

.file-status.file-uploaded {

}

.file-status.file-error {

}

.file-status {

/* Post

----------------------------------------*/

.postprofile, .postbody, .search .postbody {

display: block;

width: auto;

padding-bottom: 5px;

margin: 0;

margin-bottom: 5px;

overflow: hidden;

}

max-height: 32px;

}

}

/* Misc stuff

# General Information about this style

name = subsilver2

copyright = © 2005 phpBB Limited

# Defining a different template bitfield

# template_bitfield = lNg=

<form method="post" name="mcp" action="{U_POST_ACTION}">

<table width="100%" cellpadding="3" cellspacing="1" border="0" class="tablebg">

<tr>

<th align="center">{L_ADD_WARNING}</th>

<td class="cat" align="center"><input class="btnmain" type="submit" name="action[add_warning]" value="{L_SUBMIT}" />&nbsp;&nbsp;<input class="btnlite" type="reset" value="{L_RESET}" /></td>

</tr>

</table>

{S_FORM_TOKEN}

</form>

<form method="post" name="mcp" action="{U_POST_ACTION}">

<table width="100%" cellpadding="3" cellspacing="1" border="0" class="tablebg">

<tr>

<th align="center">{L_ADD_WARNING}</th>

<td class="cat" align="center"><input class="btnmain" type="submit" name="action[add_warning]" value="{L_SUBMIT}" />&nbsp;&nbsp;<input class="btnlite" type="reset" value="{L_RESET}" /></td>

</tr>

</table>

{S_FORM_TOKEN}

</form>

<td class="row1" width="35%"><b class="genmed">{L_AVATAR_TYPE}{L_COLON}</b></td>

<td class="row2">

<select name="avatar_driver" id="avatar_driver">

<!-- BEGIN avatar_drivers -->

<option value="{avatar_drivers.DRIVER}"<!-- IF avatar_drivers.SELECTED --> selected="selected"<!-- ENDIF -->>{avatar_drivers.L_TITLE}</option>

<!-- END avatar_drivers -->

<td class="row1" width="35%"><b class="genmed">{L_AVATAR_TYPE}{L_COLON}</b></td>

<td class="row2">

<select name="avatar_driver" id="avatar_driver" data-togglable-settings="true">

<!-- BEGIN avatar_drivers -->

<option value="{avatar_drivers.DRIVER}"<!-- IF avatar_drivers.SELECTED --> selected="selected"<!-- ENDIF --> data-toggle-setting=".avatar_option_{avatar_drivers.DRIVER}">{avatar_drivers.L_TITLE}</option>

<!-- END avatar_drivers -->

<!-- ENDIF -->

<!-- EVENT viewtopic_body_postrow_post_notices_after -->

<!-- IF not postrow.S_HAS_ATTACHMENTS --><br clear="all" /><br /><!-- ENDIF -->

<table width="100%" cellspacing="0">

$limit_days = array(0 => $user->lang['ALL_TOPICS'], 1 => $user->lang['1_DAY'], 7 => $user->lang['7_DAYS'], 14 => $user->lang['2_WEEKS'], 30 => $user->lang['1_MONTH'], 90 => $user->lang['3_MONTHS'], 180 => $user->lang['6_MONTHS'], 365 => $user->lang['1_YEAR']);

$sort_by_text = array('a' => $user->lang['AUTHOR'], 't' => $user->lang['POST_TIME'], 'r' => $user->lang['REPLIES'], 's' => $user->lang['SUBJECT'], 'v' => $user->lang['VIEWS']);

$s_limit_days = $s_sort_key = $s_sort_dir = $u_sort_param = '';

gen_sort_selects($limit_days, $sort_by_text, $sort_days, $sort_key, $sort_dir, $s_limit_days, $s_sort_key, $s_sort_dir, $u_sort_param, $default_sort_days, $default_sort_key, $default_sort_dir);

$store_reverse = true;

// Select the sort order

$sql_limit = $pagination->reverse_limit($start, $sql_limit, $topics_count);

$sql_start = $pagination->reverse_start($start, $sql_limit, $topics_count);

else

{

// Select the sort order

$sql_start = $start;

}

if ($forum_data['forum_type'] == FORUM_POST || !sizeof($active_forum_ary))

{

$sql_where = 't.forum_id = ' . $forum_id;

AND " . $phpbb_content_visibility->get_visibility_sql('post', $forum_id) . "

AND post_time > $topic_last_read

AND forum_id = $forum_id

$result = $db->sql_query_limit($sql, 1);

$row = $db->sql_fetchrow($result);

$db->sql_freeresult($result);

AND topic_moved_id = 0

AND topic_last_post_time $sql_condition {$row['topic_last_post_time']}

AND " . $phpbb_content_visibility->get_visibility_sql('topic', $row['forum_id']) . "

$result = $db->sql_query_limit($sql, 1);

$row = $db->sql_fetchrow($result);

$db->sql_freeresult($result);

$limit_days = array(0 => $user->lang['ALL_POSTS'], 1 => $user->lang['1_DAY'], 7 => $user->lang['7_DAYS'], 14 => $user->lang['2_WEEKS'], 30 => $user->lang['1_MONTH'], 90 => $user->lang['3_MONTHS'], 180 => $user->lang['6_MONTHS'], 365 => $user->lang['1_YEAR']);

$sort_by_text = array('a' => $user->lang['AUTHOR'], 't' => $user->lang['POST_TIME'], 's' => $user->lang['SUBJECT']);

$join_user_sql = array('a' => true, 't' => false, 's' => false);

$s_limit_days = $s_sort_key = $s_sort_dir = $u_sort_param = '';

// If we've got a hightlight set pass it on to pagination.

$base_url = append_sid("{$phpbb_root_path}viewtopic.$phpEx", "f=$forum_id&amp;t=$topic_id" . ((strlen($u_sort_param)) ? "&amp;$u_sort_param" : '') . (($highlight_match) ? "&amp;hilit=$highlight" : ''));

$pagination->generate_template_pagination($base_url, 'pagination', 'start', $total_posts, $config['posts_per_page'], $start);

// Send vars to template

require_once dirname(__FILE__) . '/driver/foobar.php';

{

/** @var \phpbb\avatar\manager */

protected $manager;

protected $avatar_foobar;

protected $avatar_barfoo;

public function setUp()

{

global $phpbb_root_path, $phpEx;

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

// Prepare dependencies for avatar manager and driver

$cache = $this->getMock('\phpbb\cache\driver\driver_interface');

$path_helper = new \phpbb\path_helper(

new \phpbb\symfony_request(

$guesser = new \phpbb\mimetype\guesser($guessers);

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

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

->method('get_name')

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

{

if ($driver !== 'upload')

{

}

else

{

}

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

->method('get_name')

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

$avatar_drivers[] = $cur_avatar;

}

// Set up avatar manager

}

protected function avatar_drivers()

{

return array(

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

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

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

array(AVATAR_GALLERY, null),

array(

'avatar' => '',

'avatar_type' => '',

),

),

array(

array('FOOBAR_EXPLAIN', 'foo'),

)));

}

}

public function test_all_available()

{

// barfoo and vendor3/bar should not listed due to missing composer.json. barfoo also has incorrect dir structure.

}

public function test_all_enabled()

),

// Delete avatar image to reset group settings

array(

'avatar_driver_gravatar',

array(

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

),

// Reset avatar settings

array(

'avatar_driver_gravatar',

array(

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

),

),

array(

'avatar_driver_gravatar',

array(

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

'avatar_gravatar_height' => 80,

),

),

array(

'avatar_driver_gravatar',

array(

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

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

}

{

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

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

try

{

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

{

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

}

}

}

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

$this->assertCount(1, $crawler->filter('.ext_enabled'));

$this->assertContains('phpBB Foo Extension', $crawler->filter('.ext_enabled')->eq(0)->text());

$this->assertContainsLang('EXTENSION_DISABLE', $crawler->filter('.ext_enabled')->eq(0)->text());

'foo/bar/event/',

'foo/bar/language/en/',

'foo/bar/styles/prosilver/template/',

);

static public function setUpBeforeClass()

}

/**

* Check the output of a controller using the template system

*/

public function test_controller_with_template()

return array(

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

// Also see PHPBB3-11460

// Default behaviour for in-board notifications:

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

// Default behaviour for email notifications:

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

);

}

sleep(1);

$lock = new \phpbb\lock\flock($path);

$ok = $lock->acquire();

$this->assertTrue($ok);

$this->assertTrue($lock->owns_lock());

$this->assertGreaterThan(0.5, $delta, 'First lock acquired too soon');

$this->assertFalse($lock->owns_lock());

// acquire again, this should be instantaneous

$ok = $lock->acquire();

$this->assertTrue($ok);

$this->assertTrue($lock->owns_lock());

$this->assertLessThan(0.1, $delta, 'Second lock not acquired instantaneously');

{

return array(

'test',

);

}

$types = array();

foreach ($this->get_notification_types() as $type)

{

$types[$type] = $class;

}

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

<column>notification_type_enabled</column>

<row>

<value>1</value>

<value>1</value>

</row>

</table>

<column>method</column>

<column>notify</column>

<row>

<value>0</value>

<value>2</value>

<value></value>

<value>1</value>

</row>

<row>

<value>0</value>

<value>3</value>

<value></value>

<value>1</value>

</row>

<row>

<value>0</value>

<value>4</value>

<value></value>

<value>1</value>

</row>

<row>

<value>0</value>

<value>5</value>

<value></value>

<value>1</value>

</row>

<row>

<value>0</value>

<value>6</value>

<value></value>

<column>notification_type_enabled</column>

<row>

<value>1</value>

<value>1</value>

</row>

</table>

<column>method</column>

<column>notify</column>

<row>

<value>0</value>

<value>2</value>

<value></value>

<value>1</value>

</row>

<row>

<value>0</value>

<value>3</value>

<value></value>

<value>1</value>

</row>

<row>

<value>0</value>

<value>4</value>

<value></value>

<value>1</value>

</row>

<row>

<value>0</value>

<value>5</value>

<value></value>

<value>1</value>

</row>

<row>

<value>0</value>

<value>6</value>

<value></value>

<value>1</value>

</row>

<row>

<value>0</value>

<value>7</value>

<value></value>

<value>1</value>

</row>

<row>

<value>0</value>

<value>8</value>

<value></value>

<column>notification_type_enabled</column>

<row>

<value>1</value>

<value>1</value>

</row>

</table>

<column>method</column>

<column>notify</column>

<row>

<value>0</value>

<value>2</value>

<value></value>

<value>1</value>

</row>

<row>

<value>0</value>

<value>3</value>

<value></value>

<value>1</value>

</row>

<row>

<value>0</value>

<value>4</value>

<value></value>

<value>1</value>

</row>

<row>

<value>0</value>

<value>5</value>

<value></value>

<value>1</value>

</row>

<row>

<value>0</value>

<value>6</value>

<value></value>

<value>1</value>

</row>

<row>

<value>0</value>

<value>7</value>

<value></value>

<value>0</value>

</row>

<row>

<value>0</value>

<value>9</value>

<value></value>

<column>notification_type_enabled</column>

<row>

<value>1</value>

<value>1</value>

</row>

</table>

<column>method</column>

<column>notify</column>

<row>

<value>0</value>

<value>2</value>

<value></value>

<value>1</value>

</row>

<row>

<value>0</value>

<value>3</value>

<value></value>

<value>1</value>

</row>

<row>

<value>0</value>

<value>4</value>

<value></value>

<value>1</value>

</row>

<row>

<value>0</value>

<value>5</value>

<value></value>

<value>1</value>

</row>

<row>

<value>0</value>

<value>6</value>

<value></value>

<column>notification_type_enabled</column>

<row>

<value>1</value>

<value>1</value>

</row>

</table>

<column>method</column>

<column>notify</column>

<row>

<value>0</value>

<value>2</value>

<value></value>

<value>1</value>

</row>

<row>

<value>0</value>

<value>6</value>

<value></value>

<value>1</value>

</row>

<row>

<value>0</value>

<value>7</value>

<value></value>

<value>1</value>

</row>

<row>

<value>0</value>

<value>8</value>

<value></value>

return array_merge(

parent::get_notification_types(),

array(

)

);

}

*/

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

{

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

public function test_get_notification_type_id()

{

// They should be inserted the first time

$test_type_id = $this->notifications->get_notification_type_id('test');

$this->assertEquals(array(

'test' => $test_type_id,

),

$this->notifications->get_notification_type_ids(array(

'test',

)

));

try

{

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

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

//get_subscription_types

//get_subscription_methods

public function test_subscriptions()

{

$expected_subscriptions = array(

'test' => array(''),

);

$subscriptions = $this->notifications->get_global_subscriptions(2);

$this->assert_array_content_equals($methods, $expected_subscriptions[$item_type]);

}

}

public function test_notifications()

{

$this->db->sql_query('DELETE FROM phpbb_notification_types');

foreach ($types as $id => $type)

{

$this->db->sql_query('INSERT INTO phpbb_notification_types ' .

'post_time' => 1349413323,

));

'post_id' => '4',

'topic_id' => '2',

'post_time' => 1349413324,

'user_id' => 0,

)));

'post_id' => '5',

'topic_id' => '2',

'post_time' => 1349413325,

'post_time' => 1234, // change time

));

'post_id' => '5',

'topic_id' => '2',

'poster_id' => 2,

class phpbb_notification_submit_post_type_bookmark_test extends phpbb_notification_submit_post_base

{

public function setUp()

{

class phpbb_notification_submit_post_type_post_in_queue_test extends phpbb_notification_submit_post_base

{

public function setUp()

{

class phpbb_notification_submit_post_type_post_test extends phpbb_notification_submit_post_base

{

public function setUp()

{

class phpbb_notification_submit_post_type_quote_test extends phpbb_notification_submit_post_base

{

public function setUp()

{

class phpbb_notification_submit_post_type_topic_test extends phpbb_notification_submit_post_base

{

public function setUp()

{