+<dl>

+ <dt><label for="avatar_gravatar_email">{L_GRAVATAR_AVATAR_EMAIL}{L_COLON}</label><br /><span>{L_GRAVATAR_AVATAR_EMAIL_EXPLAIN}</span></dt>

+ <dd><input type="text" name="avatar_gravatar_email" id="avatar_gravatar_email" value="{AVATAR_GRAVATAR_EMAIL}" class="inputbox" /></dd>

+</dl>

+<dl>

+ <dt><label for="avatar_gravatar_width">{L_GRAVATAR_AVATAR_SIZE}{L_COLON}</label><br /><span>{L_GRAVATAR_AVATAR_SIZE_EXPLAIN}</span></dt>

+ <dd>

+ <input type="text" name="avatar_gravatar_width" id="avatar_gravatar_width" size="3" value="{AVATAR_GRAVATAR_WIDTH}" class="inputbox autowidth" /> {L_PIXEL} &times;&nbsp;

+ <input type="text" name="avatar_gravatar_height" id="avatar_gravatar_height" size="3" value="{AVATAR_GRAVATAR_HEIGHT}" class="inputbox autowidth" /> {L_PIXEL}

+ </dd>

+</dl>

+<dl>

+ <dt><label for="category">{L_AVATAR_CATEGORY}{L_COLON}</label></dt>

+ <dd><select name="avatar_local_cat" id="category">

+ <option value="">{L_NO_AVATAR_CATEGORY}</option>

+ <!-- BEGIN avatar_local_cats -->

+ <option value="{avatar_local_cats.NAME}"<!-- IF avatar_local_cats.SELECTED --> selected="selected"<!-- ENDIF -->>{avatar_local_cats.NAME}</option>

+ <!-- END avatar_local_cats -->

+ </select>&nbsp;<input type="submit" value="{L_GO}" name="avatar_local_go" class="button2" /></dd>

+</dl>

+ <!-- IF AVATAR_LOCAL_SHOW -->

+ <table>

+ <!-- BEGIN avatar_local_row -->

+ <tr>

+ <!-- BEGIN avatar_local_col -->

+ <td class="row1" style="text-align: center;"><img src="{avatar_local_row.avatar_local_col.AVATAR_IMAGE}" alt="{avatar_local_row.avatar_local_col.AVATAR_NAME}" title="{avatar_local_row.avatar_local_col.AVATAR_NAME}"/></td>

+ <!-- END avatar_local_col -->

+ </tr>

+ <tr>

+ <!-- BEGIN avatar_local_option -->

+ <td class="row2" style="text-align: center;"><input type="radio" name="avatar_local_file" id="av-{avatar_local_row.S_ROW_COUNT}-{avatar_local_row.avatar_local_option.S_ROW_COUNT}" value="{avatar_local_row.avatar_local_option.AVATAR_FILE}" /></td>

+ <!-- END avatar_local_option -->

+ </tr>

+ <!-- END avatar_local_row -->

+ </table>

+ <!-- ENDIF -->

+<dl>

+ <dt><label for="avatar_remote_url">{L_LINK_REMOTE_AVATAR}{L_COLON}</label><br /><span>{L_LINK_REMOTE_AVATAR_EXPLAIN}</span></dt>

+ <dd><input type="text" name="avatar_remote_url" id="avatar_remote_url" value="{AVATAR_REMOTE_URL}" class="inputbox" /></dd>

+</dl>

+<dl>

+ <dt><label for="avatar_remote_width">{L_LINK_REMOTE_SIZE}{L_COLON}</label><br /><span>{L_LINK_REMOTE_SIZE_EXPLAIN}</span></dt>

+ <dd>

+ <input type="text" name="avatar_remote_width" id="avatar_remote_width" size="3" value="{AVATAR_REMOTE_WIDTH}" class="inputbox autowidth" /> {L_PIXEL} &times;&nbsp;

+ <input type="text" name="avatar_remote_height" id="avatar_remote_height" size="3" value="{AVATAR_REMOTE_HEIGHT}" class="inputbox autowidth" /> {L_PIXEL}

+ </dd>

+</dl>

+<dl>

+ <dt><label for="avatar_upload_file">{L_UPLOAD_AVATAR_FILE}{L_COLON}</label></dt>

+ <dd><input type="hidden" name="MAX_FILE_SIZE" value="{AVATAR_UPLOAD_SIZE}" /><input type="file" name="avatar_upload_file" id="avatar_upload_file" class="inputbox autowidth" /></dd>

+</dl>

+

+<!-- IF S_UPLOAD_AVATAR_URL -->

+ <dl>

+ <dt><label for="avatar_upload_url">{L_UPLOAD_AVATAR_URL}{L_COLON}</label><br /><span>{L_UPLOAD_AVATAR_URL_EXPLAIN}</span></dt>

+ <dd><input type="text" name="avatar_upload_url" id="avatar_upload_url" value="" class="inputbox" /></dd>

+ </dl>

+<!-- ENDIF -->

+ <!-- IF MIGRATOR_ERROR -->

+ <div class="errorbox">

+ <p><strong>{L_MIGRATION_EXCEPTION_ERROR}</strong></p>

+ <p>{MIGRATOR_ERROR}</p>

+ <p><a href="{U_RETURN}">{L_RETURN}</a></p>

+ </div>

+ <!-- ELSEIF PRE -->

+ <!-- IF MIGRATOR_ERROR -->

+ <div class="errorbox">

+ <p><strong>{L_MIGRATION_EXCEPTION_ERROR}</strong></p>

+ <p>{MIGRATOR_ERROR}</p>

+ <p><a href="{U_RETURN}">{L_RETURN}</a></p>

+ </div>

+ <!-- ELSEIF PRE -->

+ <form id="settings" method="post" action="{U_ACTION}" enctype="multipart/form-data">

+ <dd>{AVATAR}</dd>

+ <dd><label for="avatar_delete"><input type="checkbox" name="avatar_delete" id="avatar_delete" /> {L_DELETE_AVATAR}</label></dd>

+ <dl>

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

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

+ <option value="">{L_NO_AVATAR_CATEGORY}</option>

+ <!-- BEGIN avatar_drivers -->

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

+ <!-- END avatar_drivers -->

+ </select></dd>

+ </dl>

+ <div id="avatar_options">

+ <!-- BEGIN avatar_drivers -->

+ <div id="avatar_option_{avatar_drivers.DRIVER}">

+ <p>{avatar_drivers.L_EXPLAIN}</p>

+ {avatar_drivers.OUTPUT}

+ </div>

+ <!-- END avatar_drivers -->

+ </div>

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

+

+ <input class="button1" type="submit" name="update" value="{L_SUBMIT}" />&nbsp;

+ <input class="button2" type="reset" name="reset" value="{L_RESET}" />

+ <tr data-down="{legend.U_MOVE_DOWN}" data-up="{legend.U_MOVE_UP}">

+ <td><strong<!-- IF legend.GROUP_COLOUR --> style="color: {legend.GROUP_COLOUR}"<!-- ENDIF -->>{legend.GROUP_NAME}</strong></td>

+ <span class="up">{ICON_MOVE_UP_DISABLED}</span>

+ <span class="down"><a href="{legend.U_MOVE_DOWN}" data-ajax="row_down" data-overlay="false">{ICON_MOVE_DOWN}</a></span>

+ <span class="up"><a href="{legend.U_MOVE_UP}" data-ajax="row_up" data-overlay="false">{ICON_MOVE_UP}</a></span>

+ <span class="down"><a href="{legend.U_MOVE_DOWN}" data-ajax="row_down" data-overlay="false">{ICON_MOVE_DOWN}</a></span>

+ <span class="up"><a href="{legend.U_MOVE_UP}" data-ajax="row_up" data-overlay="false">{ICON_MOVE_UP}</a></span>

+ <span class="down">{ICON_MOVE_DOWN_DISABLED}</span>

+ <span class="up">{ICON_MOVE_UP_DISABLED}</span>

+ <span class="down">{ICON_MOVE_DOWN_DISABLED}</span>

+ <form id="legend_add_group" method="post" action="{U_ACTION_LEGEND}">

+ <select name="g">

+ <option value="0">{L_SELECT_GROUP}</option>

+ <!-- BEGIN add_legend -->

+ <option<!-- IF add_legend.GROUP_SPECIAL --> class="sep"<!-- ENDIF --> value="{add_legend.GROUP_ID}">{add_legend.GROUP_NAME}</option>

+ <!-- END add_legend -->

+ </select>

+ <dt><label for="teampage_memberships">{L_TEAMPAGE_MEMBERSHIPS}{L_COLON}</label></dt>

+ <input class="button1" type="submit" name="update" value="{L_SUBMIT}" />&nbsp;

+ <input class="button2" type="reset" name="reset" value="{L_RESET}" />

+ <!-- IF S_TEAMPAGE_CATEGORY and CURRENT_CATEGORY_NAME --><p><strong><a href="{U_ACTION}">{L_TEAMPAGE}</a> &raquo; {CURRENT_CATEGORY_NAME}</strong></p><!-- ENDIF -->

+

+ <tr data-down="{teampage.U_MOVE_DOWN}" data-up="{teampage.U_MOVE_UP}">

+ <td>

+ <!-- IF teampage.U_CATEGORY -->

+ <a href="{teampage.U_CATEGORY}">{teampage.GROUP_NAME}</a>

+ <!-- ELSE -->

+ <strong<!-- IF teampage.GROUP_COLOUR --> style="color: {teampage.GROUP_COLOUR}"<!-- ENDIF -->>{teampage.GROUP_NAME}</strong>

+ <!-- ENDIF -->

+ </td>

+ <td style="text-align: center;"><!-- IF teampage.GROUP_TYPE -->{teampage.GROUP_TYPE}<!-- ELSE -->-<!-- ENDIF -->

+ </td></td>

+ <span class="up">{ICON_MOVE_UP_DISABLED}</span>

+ <span class="down"><a href="{teampage.U_MOVE_DOWN}" data-ajax="row_down" data-overlay="false">{ICON_MOVE_DOWN}</a></span>

+ <span class="up"><a href="{teampage.U_MOVE_UP}" data-ajax="row_up" data-overlay="false">{ICON_MOVE_UP}</a></span>

+ <span class="down"><a href="{teampage.U_MOVE_DOWN}" data-ajax="row_down" data-overlay="false">{ICON_MOVE_DOWN}</a></span>

+ <span class="up"><a href="{teampage.U_MOVE_UP}" data-ajax="row_up" data-overlay="false">{ICON_MOVE_UP}</a></span>

+ <span class="down">{ICON_MOVE_DOWN_DISABLED}</span>

+ <span class="up">{ICON_MOVE_UP_DISABLED}</span>

+ <span class="down">{ICON_MOVE_DOWN_DISABLED}</span>

+ <!-- IF not S_TEAMPAGE_CATEGORY -->

+ <form id="teampage_add_category" method="post" action="{U_ACTION_TEAMPAGE}">

+ <input class="inputbox autowidth" type="text" maxlength="255" name="category_name" placeholder="{L_GROUP_CATEGORY_NAME}" />

+ <input class="button2" type="submit" name="submit" value="{L_ADD_GROUP_CATEGORY}" />

+ <input type="hidden" name="action" value="add_category" />

+ {S_FORM_TOKEN}

+ </fieldset>

+ </form>

+ <!-- ENDIF -->

+

+ <form id="teampage_add_group" method="post" action="{U_ACTION_TEAMPAGE}">

+ <fieldset class="quick">

+ <select name="g">

+ <option value="0">{L_SELECT_GROUP}</option>

+ <!-- BEGIN add_teampage -->

+ <option<!-- IF add_teampage.GROUP_SPECIAL --> class="sep"<!-- ENDIF --> value="{add_teampage.GROUP_ID}">{add_teampage.GROUP_NAME}</option>

+ <!-- END add_teampage -->

+ </select>

+ <div class="hidden">

+ <a class="template-up-img" href="#">{ICON_MOVE_UP}</a>

+ <span class="template-up-img-disabled">{ICON_MOVE_UP_DISABLED}</span>

+

+ <a class="template-down-img" href="#">{ICON_MOVE_DOWN}</a>

+ <span class="template-down-img-disabled">{ICON_MOVE_DOWN_DISABLED}</span>

+ </div>

+

+ <form id="avatar_settings" method="post" action="{U_ACTION}" enctype="multipart/form-data">

+ <!-- IF ERROR --><p class="error">{ERROR}</p><!-- ENDIF -->

+ <dt><label>{L_CURRENT_IMAGE}{L_COLON}</label><br /><span>{L_AVATAR_EXPLAIN}</span></dt>

+ <dd>{AVATAR}</dd>

+ <dd><label for="avatar_delete"><input type="checkbox" name="avatar_delete" id="avatar_delete" /> {L_DELETE_AVATAR}</label></dd>

+ </fieldset>

+ <fieldset>

+ <legend>{L_AVATAR_SELECT}</legend>

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

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

+ <option value="">{L_NO_AVATAR_CATEGORY}</option>

+ <!-- BEGIN avatar_drivers -->

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

+ <!-- END avatar_drivers -->

+ </select></dd>

+ <div id="avatar_options">

+ <!-- BEGIN avatar_drivers -->

+ <div id="avatar_option_{avatar_drivers.DRIVER}">

+ <p>{avatar_drivers.L_EXPLAIN}</p>

+ {avatar_drivers.OUTPUT}

+ </div>

+ <!-- END avatar_drivers -->

+ </div>

+ <input type="submit" name="update" value="{L_SUBMIT}" class="button1" />

+ {S_FORM_TOKEN}

+

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

+ <dt><label for="msn">{L_UCP_MSNM}{L_COLON}</label></dt>

+ <dd><input type="text" id="msn" name="msn" value="{MSN}" /></dd>

+ </dl>

+ <dl>

+ top: 150px;

+ left: 25%;

+ width: 50%;

+ text-align: left;

+.phpbb_alert label {

+ display: block;

+ margin: 8px 0;

+ padding-bottom: 8px;

+}

+

+.phpbb_alert div.alert_text > p,

+.phpbb_alert div.alert_text > label,

+.phpbb_alert div.alert_text > select,

+.phpbb_alert div.alert_text > textarea,

+.phpbb_alert div.alert_text > input {

+ font-size: 0.9em;

+}

+

+(function($) { // Avoid conflicts with other libraries

+

+"use strict";

+

+function avatarHide() {

+ $('#avatar_options > div').hide();

+

+ var selected = $('#avatar_driver').val();

+ $('#avatar_option_' + selected).show();

+}

+

+avatarHide();

+$('#avatar_driver').bind('change', avatarHide);

+

+})(jQuery); // Avoid conflicts with other libraries

+<!-- IF S_AJAX_REQUEST -->

+

+ <h3>{MESSAGE_TITLE}</h3>

+ <p>{MESSAGE_TEXT}</p>

+

+ <fieldset class="submit-buttons">

+ <input type="button" name="confirm" value="{L_YES}" class="button2" />&nbsp;

+ <input type="button" name="cancel" value="{L_NO}" class="button2" />

+ </fieldset>

+

+<!-- ELSE -->

+

+<!-- ENDIF -->

+ <div class="alert_text"></div>

+ // If confirmation is required, display a dialog to the user.

+ phpbb.confirm(res.MESSAGE_BODY, function(del) {

+// Toggle notification list

+$('#notification_list_button').click(function(e) {

+ $('#notification_list').toggle();

+ e.preventDefault();

+});

+$('#phpbb').click(function(e) {

+ var target = $(e.target);

+

+ if (!target.is('#notification_list') && !target.is('#notification_list_button') && !target.parents().is('#notification_list')) {

+ $('#notification_list').hide();

+ }

+});

+

+include($phpbb_root_path . 'includes/functions_compatibility.' . $phpEx);

+$phpbb_log = $phpbb_container->get('log');

+

+services:

+ avatar.driver.gravatar:

+ class: phpbb_avatar_driver_gravatar

+ arguments:

+ - @config

+ - %core.root_path%

+ - .%core.php_ext%

+ - @cache.driver

+ calls:

+ - [set_name, [avatar.driver.gravatar]]

+ tags:

+ - { name: avatar.driver }

+

+ avatar.driver.local:

+ class: phpbb_avatar_driver_local

+ arguments:

+ - @config

+ - %core.root_path%

+ - .%core.php_ext%

+ - @cache.driver

+ calls:

+ - [set_name, [avatar.driver.local]]

+ tags:

+ - { name: avatar.driver }

+

+ avatar.driver.remote:

+ class: phpbb_avatar_driver_remote

+ arguments:

+ - @config

+ - %core.root_path%

+ - .%core.php_ext%

+ - @cache.driver

+ calls:

+ - [set_name, [avatar.driver.remote]]

+ tags:

+ - { name: avatar.driver }

+

+ avatar.driver.upload:

+ class: phpbb_avatar_driver_upload

+ arguments:

+ - @config

+ - %core.root_path%

+ - .%core.php_ext%

+ - @cache.driver

+ calls:

+ - [set_name, [avatar.driver.upload]]

+ tags:

+ - { name: avatar.driver }

+

+ avatar.driver_collection:

+ class: phpbb_di_service_collection

+ arguments:

+ - @service_container

+ tags:

+ - { name: service_collection, tag: avatar.driver }

+services:

+ migrator:

+ class: phpbb_db_migrator

+ arguments:

+ - @config

+ - @dbal.conn

+ - @dbal.tools

+ - %tables.migrations%

+ - %core.root_path%

+ - %core.php_ext%

+ - %core.table_prefix%

+ - @migrator.tool_collection

+

+ migrator.tool_collection:

+ class: phpbb_di_service_collection

+ arguments:

+ - @service_container

+ tags:

+ - { name: service_collection, tag: migrator.tool }

+

+ migrator.tool.config:

+ class: phpbb_db_migration_tool_config

+ arguments:

+ - @config

+ tags:

+ - { name: migrator.tool }

+

+ migrator.tool.module:

+ class: phpbb_db_migration_tool_module

+ arguments:

+ - @dbal.conn

+ - @cache

+ - @user

+ - %core.root_path%

+ - %core.php_ext%

+ - %tables.modules%

+ tags:

+ - { name: migrator.tool }

+

+ migrator.tool.permission:

+ class: phpbb_db_migration_tool_permission

+ arguments:

+ - @dbal.conn

+ - @cache

+ - @auth

+ - %core.root_path%

+ - %core.php_ext%

+ tags:

+ - { name: migrator.tool }

+services:

+ notification.type_collection:

+ class: phpbb_di_service_collection

+ arguments:

+ - @service_container

+ tags:

+ - { name: service_collection, tag: notification.type }

+

+ notification.method_collection:

+ class: phpbb_di_service_collection

+ arguments:

+ - @service_container

+ tags:

+ - { name: service_collection, tag: notification.method }

+

+ notification.type.approve_post:

+ class: phpbb_notification_type_approve_post

+ scope: prototype # scope MUST be prototype for this to work! # scope MUST be prototype for this to work!

+ arguments:

+ - @user_loader

+ - @dbal.conn

+ - @cache.driver

+ - @user

+ - @auth

+ - @config

+ - %core.root_path%

+ - %core.php_ext%

+ - %tables.notification_types%

+ - %tables.notifications%

+ - %tables.user_notifications%

+ tags:

+ - { name: notification.type }

+

+ notification.type.approve_topic:

+ class: phpbb_notification_type_approve_topic

+ scope: prototype # scope MUST be prototype for this to work!

+ arguments:

+ - @user_loader

+ - @dbal.conn

+ - @cache.driver

+ - @user

+ - @auth

+ - @config

+ - %core.root_path%

+ - %core.php_ext%

+ - %tables.notification_types%

+ - %tables.notifications%

+ - %tables.user_notifications%

+ tags:

+ - { name: notification.type }

+

+ notification.type.bookmark:

+ class: phpbb_notification_type_bookmark

+ scope: prototype # scope MUST be prototype for this to work!

+ arguments:

+ - @user_loader

+ - @dbal.conn

+ - @cache.driver

+ - @user

+ - @auth

+ - @config

+ - %core.root_path%

+ - %core.php_ext%

+ - %tables.notification_types%

+ - %tables.notifications%

+ - %tables.user_notifications%

+ tags:

+ - { name: notification.type }

+

+ notification.type.disapprove_post:

+ class: phpbb_notification_type_disapprove_post

+ scope: prototype # scope MUST be prototype for this to work!

+ arguments:

+ - @user_loader

+ - @dbal.conn

+ - @cache.driver

+ - @user

+ - @auth

+ - @config

+ - %core.root_path%

+ - %core.php_ext%

+ - %tables.notification_types%

+ - %tables.notifications%

+ - %tables.user_notifications%

+ tags:

+ - { name: notification.type }

+

+ notification.type.disapprove_topic:

+ class: phpbb_notification_type_disapprove_topic

+ scope: prototype # scope MUST be prototype for this to work!

+ arguments:

+ - @user_loader

+ - @dbal.conn

+ - @cache.driver

+ - @user

+ - @auth

+ - @config

+ - %core.root_path%

+ - %core.php_ext%

+ - %tables.notification_types%

+ - %tables.notifications%

+ - %tables.user_notifications%

+ tags:

+ - { name: notification.type }

+

+ notification.type.pm:

+ class: phpbb_notification_type_pm

+ scope: prototype # scope MUST be prototype for this to work!

+ arguments:

+ - @user_loader

+ - @dbal.conn

+ - @cache.driver

+ - @user

+ - @auth

+ - @config

+ - %core.root_path%

+ - %core.php_ext%

+ - %tables.notification_types%

+ - %tables.notifications%

+ - %tables.user_notifications%

+ tags:

+ - { name: notification.type }

+

+ notification.type.post:

+ class: phpbb_notification_type_post

+ scope: prototype # scope MUST be prototype for this to work!

+ arguments:

+ - @user_loader

+ - @dbal.conn

+ - @cache.driver

+ - @user

+ - @auth

+ - @config

+ - %core.root_path%

+ - %core.php_ext%

+ - %tables.notification_types%

+ - %tables.notifications%

+ - %tables.user_notifications%

+ tags:

+ - { name: notification.type }

+

+ notification.type.post_in_queue:

+ class: phpbb_notification_type_post_in_queue

+ scope: prototype # scope MUST be prototype for this to work!

+ arguments:

+ - @user_loader

+ - @dbal.conn

+ - @cache.driver

+ - @user

+ - @auth

+ - @config

+ - %core.root_path%

+ - %core.php_ext%

+ - %tables.notification_types%

+ - %tables.notifications%

+ - %tables.user_notifications%

+ tags:

+ - { name: notification.type }

+

+ notification.type.quote:

+ class: phpbb_notification_type_quote

+ scope: prototype # scope MUST be prototype for this to work!

+ arguments:

+ - @user_loader

+ - @dbal.conn

+ - @cache.driver

+ - @user

+ - @auth

+ - @config

+ - %core.root_path%

+ - %core.php_ext%

+ - %tables.notification_types%

+ - %tables.notifications%

+ - %tables.user_notifications%

+ tags:

+ - { name: notification.type }

+

+ notification.type.report_pm:

+ class: phpbb_notification_type_report_pm

+ scope: prototype # scope MUST be prototype for this to work!

+ arguments:

+ - @user_loader

+ - @dbal.conn

+ - @cache.driver

+ - @user

+ - @auth

+ - @config

+ - %core.root_path%

+ - %core.php_ext%

+ - %tables.notification_types%

+ - %tables.notifications%

+ - %tables.user_notifications%

+ tags:

+ - { name: notification.type }

+

+ notification.type.report_pm_closed:

+ class: phpbb_notification_type_report_pm_closed

+ scope: prototype # scope MUST be prototype for this to work!

+ arguments:

+ - @user_loader

+ - @dbal.conn

+ - @cache.driver

+ - @user

+ - @auth

+ - @config

+ - %core.root_path%

+ - %core.php_ext%

+ - %tables.notification_types%

+ - %tables.notifications%

+ - %tables.user_notifications%

+ tags:

+ - { name: notification.type }

+

+ notification.type.report_post:

+ class: phpbb_notification_type_report_post

+ scope: prototype # scope MUST be prototype for this to work!

+ arguments:

+ - @user_loader

+ - @dbal.conn

+ - @cache.driver

+ - @user

+ - @auth

+ - @config

+ - %core.root_path%

+ - %core.php_ext%

+ - %tables.notification_types%

+ - %tables.notifications%

+ - %tables.user_notifications%

+ tags:

+ - { name: notification.type }

+

+ notification.type.report_post_closed:

+ class: phpbb_notification_type_report_post

+ scope: prototype # scope MUST be prototype for this to work!

+ arguments:

+ - @user_loader

+ - @dbal.conn

+ - @cache.driver

+ - @user

+ - @auth

+ - @config

+ - %core.root_path%

+ - %core.php_ext%

+ - %tables.notification_types%

+ - %tables.notifications%

+ - %tables.user_notifications%

+ tags:

+ - { name: notification.type }

+

+ notification.type.topic:

+ class: phpbb_notification_type_topic

+ scope: prototype # scope MUST be prototype for this to work!

+ arguments:

+ - @user_loader

+ - @dbal.conn

+ - @cache.driver

+ - @user

+ - @auth

+ - @config

+ - %core.root_path%

+ - %core.php_ext%

+ - %tables.notification_types%

+ - %tables.notifications%

+ - %tables.user_notifications%

+ tags:

+ - { name: notification.type }

+

+ notification.type.topic_in_queue:

+ class: phpbb_notification_type_topic_in_queue

+ scope: prototype # scope MUST be prototype for this to work!

+ arguments:

+ - @user_loader

+ - @dbal.conn

+ - @cache.driver

+ - @user

+ - @auth

+ - @config

+ - %core.root_path%

+ - %core.php_ext%

+ - %tables.notification_types%

+ - %tables.notifications%

+ - %tables.user_notifications%

+ tags:

+ - { name: notification.type }

+

+ notification.method.email:

+ class: phpbb_notification_method_email

+ scope: prototype # scope MUST be prototype for this to work!

+ arguments:

+ - @user_loader

+ - @dbal.conn

+ - @cache.driver

+ - @user

+ - @auth

+ - @config

+ - %core.root_path%

+ - %core.php_ext%

+ tags:

+ - { name: notification.method }

+

+ notification.method.jabber:

+ class: phpbb_notification_method_jabber

+ scope: prototype # scope MUST be prototype for this to work!

+ arguments:

+ - @user_loader

+ - @dbal.conn

+ - @cache.driver

+ - @user

+ - @auth

+ - @config

+ - %core.root_path%

+ - %core.php_ext%

+ tags:

+ - { name: notification.method }

+ - { resource: notifications.yml }

+ - { resource: migrator.yml }

+ - { resource: avatars.yml }

+ avatar.manager:

+ class: phpbb_avatar_manager

+ arguments:

+ - @config

+ - @avatar.driver_collection

+ - @service_container

+

+ config_text:

+ class: phpbb_config_db_text

+ arguments:

+ - @dbal.conn

+ - %tables.config_text%

+

+ dbal.tools:

+ file: %core.root_path%includes/db/db_tools.%core.php_ext%

+ class: phpbb_db_tools

+ arguments:

+ - @dbal.conn

+

+ - @service_container

+ - @migrator

+ groupposition.legend:

+ class: phpbb_groupposition_legend

+ arguments:

+ - @dbal.conn

+ - @user

+

+ groupposition.teampage:

+ class: phpbb_groupposition_teampage

+ arguments:

+ - @dbal.conn

+ - @user

+ - @cache.driver

+

+ log:

+ class: phpbb_log

+ arguments:

+ - @dbal.conn

+ - @user

+ - @auth

+ - @dispatcher

+ - %core.root_path%

+ - %core.adm_relative_path%

+ - %core.php_ext%

+ - %tables.log%

+

+ notification_manager:

+ class: phpbb_notification_manager

+ arguments:

+ - @notification.type_collection

+ - @notification.method_collection

+ - @service_container

+ - @user_loader

+ - @dbal.conn

+ - @user

+ - %core.root_path%

+ - %core.php_ext%

+ - %tables.notification_types%

+ - %tables.notifications%

+ - %tables.user_notifications%

+

+

+ user_loader:

+ class: phpbb_user_loader

+ arguments:

+ - @dbal.conn

+ - %core.root_path%

+ - %core.php_ext%

+ - %tables.users%

+ tables.config_text: %core.table_prefix%config_text

+ tables.log: %core.table_prefix%log

+ tables.notification_types: %core.table_prefix%notification_types

+ tables.notifications: %core.table_prefix%notifications

+ tables.user_notifications: %core.table_prefix%user_notifications

+ tables.users: %core.table_prefix%users

+ tables.migrations: %core.table_prefix%migrations

+ tables.modules: %core.table_prefix%modules

+ $msn = 0;

+ $sql = "INSERT INTO " . USERS_TABLE . " (user_id, username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_sig_bbcode_uid, user_avatar, user_viewemail, user_aim, user_yim, user_msnm, user_attachsig, user_allowsmilies, user_allowhtml, user_allowbbcode, user_allow_viewonline, user_notify, user_notify_pm, user_timezone, user_dateformat, user_lang, user_style, user_level, user_allow_pm, user_active, user_actkey)

+ VALUES ($new_user_id, '$username', " . time() . ", '$password', '$email', '$icq', '$website', '$occupation', '$location', '$interests', '$signature', '$signature_bbcode_uid', '$avatar_filename', $viewemail, '$aim', '$yim', '$msn', $attachsig, $allowsmilies, $allowhtml, $allowbbcode, $allowviewonline, $notifyreply, $notifypm, $user_timezone, '$user_dateformat', '$user_lang', $user_style, 0, 1, ";

+ $schema_data['phpbb_config_text'] = array(

+ 'COLUMNS' => array(

+ 'config_name' => array('VCHAR', ''),

+ 'config_value' => array('MTEXT', ''),

+ ),

+ 'PRIMARY_KEY' => 'config_name',

+ );

+

+ 'group_avatar_type' => array('VCHAR:255', ''),

+ $schema_data['phpbb_migrations'] = array(

+ 'COLUMNS' => array(

+ 'migration_name' => array('VCHAR', ''),

+ 'migration_depends_on' => array('TEXT', ''),

+ 'migration_schema_done' => array('BOOL', 0),

+ 'migration_data_done' => array('BOOL', 0),

+ 'migration_data_state' => array('TEXT', ''),

+ 'migration_start_time' => array('TIMESTAMP', 0),

+ 'migration_end_time' => array('TIMESTAMP', 0),

+ ),

+ 'PRIMARY_KEY' => 'migration_name',

+ );

+

+ $schema_data['phpbb_notification_types'] = array(

+ 'COLUMNS' => array(

+ 'notification_type' => array('VCHAR:255', ''),

+ 'notification_type_enabled' => array('BOOL', 1),

+ ),

+ 'PRIMARY_KEY' => array('notification_type', 'notification_type_enabled'),

+ );

+

+ $schema_data['phpbb_notifications'] = array(

+ 'COLUMNS' => array(

+ 'notification_id' => array('UINT', NULL, 'auto_increment'),

+ 'item_type' => array('VCHAR:255', ''),

+ 'item_id' => array('UINT', 0),

+ 'item_parent_id' => array('UINT', 0),

+ 'user_id' => array('UINT', 0),

+ 'notification_read' => array('BOOL', 0),

+ 'notification_time' => array('TIMESTAMP', 1),

+ 'notification_data' => array('TEXT_UNI', ''),

+ ),

+ 'PRIMARY_KEY' => 'notification_id',

+ 'KEYS' => array(

+ 'item_ident' => array('INDEX', array('item_type', 'item_id')),

+ 'user' => array('INDEX', array('user_id', 'notification_read')),

+ ),

+ );

+

+ $schema_data['phpbb_teampage'] = array(

+ 'COLUMNS' => array(

+ 'teampage_id' => array('UINT', NULL, 'auto_increment'),

+ 'group_id' => array('UINT', 0),

+ 'teampage_name' => array('VCHAR_UNI:255', ''),

+ 'teampage_position' => array('UINT', 0),

+ 'teampage_parent' => array('UINT', 0),

+ ),

+ 'PRIMARY_KEY' => 'teampage_id',

+ );

+

+ $schema_data['phpbb_user_notifications'] = array(

+ 'COLUMNS' => array(

+ 'item_type' => array('VCHAR:255', ''),

+ 'item_id' => array('UINT', 0),

+ 'user_id' => array('UINT', 0),

+ 'method' => array('VCHAR:255', ''),

+ 'notify' => array('BOOL', 1),

+ ),

+ );

+

+ 'user_avatar_type' => array('VCHAR:255', ''),

+ 'user_msnm' => array('VCHAR_UNI', ''),

+ 'user_msnm' => array('VCHAR_UNI', ''),

+ EXreaction (Nathan Guse)

+ rxu (Ruslan Uzdenov) [04/2010 - 12/2012]

+ $phpbb_log = $phpbb_container->get('log');

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

+

+ global $cache, $phpbb_container;

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

+ $avatar_drivers = $phpbb_avatar_manager->get_all_drivers();

+

+ $avatar_vars = array();

+ foreach ($avatar_drivers as $current_driver)

+ {

+ $driver = $phpbb_avatar_manager->get_driver($current_driver, false);

+

+ /*

+ * First grab the settings for enabling/disabling the avatar

+ * driver and afterwards grab additional settings the driver

+ * might have.

+ */

+ $avatar_vars += $phpbb_avatar_manager->get_avatar_settings($driver);

+ $avatar_vars += $driver->prepare_form_acp($user);

+ }

+

+

+ if (!empty($avatar_vars))

+ {

+ $display_vars['vars'] += $avatar_vars;

+ }

+ 'load_notifications' => array('lang' => 'LOAD_NOTIFICATIONS', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true),

+ 'board_contact' => array('lang' => 'CONTACT_EMAIL', 'validate' => 'email', 'type' => 'text:25:100', 'explain' => true),

+ 'board_email' => array('lang' => 'ADMIN_EMAIL', 'validate' => 'email', 'type' => 'text:25:100', 'explain' => true),

+ $user->add_lang(array('install', 'acp/extensions', 'migrator'));

+ try

+ if ($phpbb_extension_manager->enable_step($ext_name))

+ {

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

+ meta_refresh(0, $this->u_action . '&amp;action=enable&amp;ext_name=' . urlencode($ext_name));

+ }

+ }

+ catch (phpbb_db_migration_exception $e)

+ {

+ $template->assign_var('MIGRATOR_ERROR', $e->getLocalisedMessage($user));

+ try

+ if ($phpbb_extension_manager->purge_step($ext_name))

+ {

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

+ meta_refresh(0, $this->u_action . '&amp;action=purge&amp;ext_name=' . urlencode($ext_name));

+ }

+ }

+ catch (phpbb_db_migration_exception $e)

+ {

+ $template->assign_var('MIGRATOR_ERROR', $e->getLocalisedMessage($user));

+ global $request, $phpbb_container;

+ $sql = 'SELECT g.*, t.teampage_position AS group_teampage

+ FROM ' . GROUPS_TABLE . ' g

+ LEFT JOIN ' . TEAMPAGE_TABLE . ' t

+ ON (t.group_id = g.group_id)

+ WHERE g.group_id = ' . $group_id;

+ else if (empty($mark_ary))

+ {

+ trigger_error($user->lang['NO_USERS'] . adm_back_link($this->u_action . '&amp;action=list&amp;g=' . $group_id), E_USER_WARNING);

+ }

+ group_user_attributes('default', $group_id, $mark_ary, false, $group_name, $group_row);

+ trigger_error($user->lang['GROUP_DEFS_UPDATED'] . adm_back_link($this->u_action . '&amp;action=list&amp;g=' . $group_id));

+ }

+ else

+ {

+ confirm_box(false, $user->lang['CONFIRM_OPERATION'], build_hidden_fields(array(

+ 'mark' => $mark_ary,

+ 'g' => $group_id,

+ 'i' => $id,

+ 'mode' => $mode,

+ 'action' => $action))

+ );

+ }

+ break;

+ case 'set_default_on_all':

+ if (confirm_box(true))

+ $group_name = ($group_row['group_type'] == GROUP_SPECIAL) ? $user->lang['G_' . $group_row['group_name']] : $group_row['group_name'];

+

+

+ trigger_error($user->lang['GROUP_DEFS_UPDATED'] . adm_back_link($this->u_action . '&amp;action=list&amp;g=' . $group_id));

+ confirm_box(false, $user->lang['CONFIRM_OPERATION'], build_hidden_fields(array(

+ 'mark' => $mark_ary,

+ 'g' => $group_id,

+ 'i' => $id,

+ 'mode' => $mode,

+ 'action' => $action))

+ );

+ if (empty($mark_ary))

+ {

+ trigger_error($user->lang['NO_USERS'] . adm_back_link($this->u_action . '&amp;action=list&amp;g=' . $group_id), E_USER_WARNING);

+ }

+ // Setup avatar data for later

+ $avatars_enabled = false;

+ $avatar_drivers = null;

+ $avatar_data = null;

+ $avatar_error = array();

+

+ if ($config['allow_avatar'])

+ {

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

+ $avatar_drivers = $phpbb_avatar_manager->get_enabled_drivers();

+

+ // This is normalised data, without the group_ prefix

+ $avatar_data = phpbb_avatar_manager::clean_row($group_row);

+ }

+

+ if ($config['allow_avatar'])

+ // Handle avatar

+ $driver_name = $phpbb_avatar_manager->clean_driver_name($request->variable('avatar_driver', ''));

+ if (in_array($driver_name, $avatar_drivers) && !$request->is_set_post('avatar_delete'))

+ $driver = $phpbb_avatar_manager->get_driver($driver_name);

+ $result = $driver->process_form($request, $template, $user, $avatar_data, $avatar_error);

+ if ($result && empty($avatar_error))

+ $result['avatar_type'] = $driver_name;

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

+ else

+ $driver = $phpbb_avatar_manager->get_driver($user->data['user_avatar_type']);

+ if ($driver)

+ $driver->delete($avatar_data);

+ // Removing the avatar

+ $submit_ary['avatar_type'] = '';

+ $submit_ary['avatar'] = '';

+ $submit_ary['avatar_width'] = 0;

+ $submit_ary['avatar_height'] = 0;

+ 'avatar_type' => 'string',

+ $cache->destroy('sql', array(GROUPS_TABLE, TEAMPAGE_TABLE));

+ // Load up stuff for avatars

+ if ($config['allow_avatar'])

+ {

+ $avatars_enabled = false;

+ $selected_driver = $phpbb_avatar_manager->clean_driver_name($request->variable('avatar_driver', $avatar_data['avatar_type']));

+

+ foreach ($avatar_drivers as $current_driver)

+ {

+ $driver = $phpbb_avatar_manager->get_driver($current_driver);

+ $avatars_enabled = true;

+ $config_name = $phpbb_avatar_manager->get_driver_config_name($driver);

+ $template->set_filenames(array(

+ 'avatar' => "acp_avatar_options_{$config_name}.html",

+ ));

+ if ($driver->prepare_form($request, $template, $user, $avatar_data, $avatar_error))

+ {

+ $driver_name = $phpbb_avatar_manager->prepare_driver_name($current_driver);

+ $driver_upper = strtoupper($driver_name);

+ $template->assign_block_vars('avatar_drivers', array(

+ 'L_TITLE' => $user->lang($driver_upper . '_TITLE'),

+ 'L_EXPLAIN' => $user->lang($driver_upper . '_EXPLAIN'),

+

+ 'DRIVER' => $driver_name,

+ 'SELECTED' => $current_driver == $selected_driver,

+ 'OUTPUT' => $template->assign_display('avatar'),

+ ));

+ }

+ }

+ $avatar = phpbb_get_group_avatar($group_row, 'GROUP_AVATAR', true);

+

+ // Merge any avatar errors into the primary error array

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

+

+ 'S_AVATARS_ENABLED' => ($config['allow_avatar'] && $avatars_enabled),

+ 'AVATAR' => empty($avatar) ? '<img src="' . $phpbb_admin_path . 'images/no_avatar.gif" alt="" />' : $avatar,

+ 'U_DEFAULT_ALL' => "{$this->u_action}&amp;action=set_default_on_all&amp;g=$group_id",

+ global $config, $db, $template, $user, $request, $phpbb_container;

+ $field = $request->variable('field', '');

+ $action = $request->variable('action', '');

+ $group_id = $request->variable('g', 0);

+ $teampage_id = $request->variable('t', 0);

+ $category_id = $request->variable('c', 0);

+ else if ($field && in_array($field, array('legend', 'teampage')))

+

+ $group_position = $phpbb_container->get('groupposition.' . $field);

+ if ($field == 'teampage')

+ try

+ {

+ switch ($action)

+ {

+ case 'add':

+ $group_position->add_group_teampage($group_id, $category_id);

+ break;

+ case 'add_category':

+ $group_position->add_category_teampage($request->variable('category_name', '', true));

+ break;

+ case 'delete':

+ $group_position->delete_teampage($teampage_id);

+ break;

+ case 'move_up':

+ $group_position->move_up_teampage($teampage_id);

+ break;

+ case 'move_down':

+ $group_position->move_down_teampage($teampage_id);

+ break;

+ }

+ }

+ catch (phpbb_groupposition_exception $exception)

+ {

+ trigger_error($user->lang($exception->getMessage()) . adm_back_link($this->u_action), E_USER_WARNING);

+ }

+ }

+ else if ($field == 'legend')

+ {

+ try

+ {

+ switch ($action)

+ {

+ case 'add':

+ $group_position->add_group($group_id);

+ break;

+ case 'delete':

+ $group_position->delete_group($group_id);

+ break;

+

+ case 'move_up':

+ $group_position->move_up($group_id);

+ break;

+

+ case 'move_down':

+ $group_position->move_down($group_id);

+ break;

+ }

+ }

+ catch (phpbb_groupposition_exception $exception)

+ {

+ trigger_error($user->lang($exception->getMessage()) . adm_back_link($this->u_action), E_USER_WARNING);

+ }

+ }

+ else

+ {

+ switch ($action)

+ {

+ case 'set_config_teampage':

+ $config->set('teampage_forums', $request->variable('teampage_forums', 0));

+ $config->set('teampage_memberships', $request->variable('teampage_memberships', 0));

+ break;

+

+ case 'set_config_legend':

+ $config->set('legend_sort_groupname', $request->variable('legend_sort_groupname', 0));

+ break;

+ }

+ }

+

+ if (($action == 'move_up' || $action == 'move_down') && $request->is_ajax())

+ {

+ $json_response = new phpbb_json_response;

+ $json_response->send(array('success' => true));

+ ORDER BY group_legend ASC, group_type DESC, group_name ASC';

+ 'GROUP_NAME' => $group_name,

+ 'GROUP_COLOUR' => ($row['group_colour']) ? '#' . $row['group_colour'] : '',

+ 'GROUP_TYPE' => $user->lang[phpbb_groupposition_legend::group_type_language($row['group_type'])],

+ 'U_MOVE_DOWN' => "{$this->u_action}&amp;field=legend&amp;action=move_down&amp;g=" . $row['group_id'],

+ 'U_MOVE_UP' => "{$this->u_action}&amp;field=legend&amp;action=move_up&amp;g=" . $row['group_id'],

+ 'U_DELETE' => "{$this->u_action}&amp;field=legend&amp;action=delete&amp;g=" . $row['group_id'],

+ $template->assign_block_vars('add_legend', array(

+ 'GROUP_ID' => (int) $row['group_id'],

+ 'GROUP_NAME' => $group_name,

+ 'GROUP_SPECIAL' => ($row['group_type'] == GROUP_SPECIAL),

+ ));

+ $category_url_param = (($category_id) ? '&amp;c=' . $category_id : '');

+

+ $sql = 'SELECT t.*, g.group_name, g.group_colour, g.group_type

+ FROM ' . TEAMPAGE_TABLE . ' t

+ LEFT JOIN ' . GROUPS_TABLE . ' g

+ ON (t.group_id = g.group_id)

+ WHERE t.teampage_parent = ' . $category_id . '

+ OR t.teampage_id = ' . $category_id . '

+ ORDER BY t.teampage_position ASC';

+ $category_data = array();

+ if ($row['teampage_id'] == $category_id)

+ $template->assign_vars(array(

+ 'CURRENT_CATEGORY_NAME' => $row['teampage_name'],

+ continue;

+ }

+

+ if ($row['group_id'])

+ {

+ $group_name = ($row['group_type'] == GROUP_SPECIAL) ? $user->lang['G_' . $row['group_name']] : $row['group_name'];

+ $group_type = $user->lang[phpbb_groupposition_teampage::group_type_language($row['group_type'])];

+ $group_name = $row['teampage_name'];

+ $group_type = '';

+

+ $template->assign_block_vars('teampage', array(

+ 'GROUP_NAME' => $group_name,

+ 'GROUP_COLOUR' => ($row['group_colour']) ? '#' . $row['group_colour'] : '',

+ 'GROUP_TYPE' => $group_type,

+

+ 'U_CATEGORY' => (!$row['group_id']) ? "{$this->u_action}&amp;c=" . $row['teampage_id'] : '',

+ 'U_MOVE_DOWN' => "{$this->u_action}&amp;field=teampage&amp;action=move_down{$category_url_param}&amp;t=" . $row['teampage_id'],

+ 'U_MOVE_UP' => "{$this->u_action}&amp;field=teampage&amp;action=move_up{$category_url_param}&amp;t=" . $row['teampage_id'],

+ 'U_DELETE' => "{$this->u_action}&amp;field=teampage&amp;action=delete{$category_url_param}&amp;t=" . $row['teampage_id'],

+ ));

+ }

+ $db->sql_freeresult($result);

+

+ $sql = 'SELECT g.group_id, g.group_name, g.group_colour, g.group_type

+ FROM ' . GROUPS_TABLE . ' g

+ LEFT JOIN ' . TEAMPAGE_TABLE . ' t

+ ON (t.group_id = g.group_id)

+ WHERE t.teampage_id IS NULL

+ ORDER BY g.group_type DESC, g.group_name ASC';

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

+

+ $s_group_select_teampage = '';

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

+ {

+ $group_name = ($row['group_type'] == GROUP_SPECIAL) ? $user->lang['G_' . $row['group_name']] : $row['group_name'];

+ $template->assign_block_vars('add_teampage', array(

+ 'GROUP_ID' => (int) $row['group_id'],

+ 'GROUP_NAME' => $group_name,

+ 'GROUP_SPECIAL' => ($row['group_type'] == GROUP_SPECIAL),

+ ));

+ 'U_ACTION' => $this->u_action,

+ 'U_ACTION_LEGEND' => $this->u_action . '&amp;field=legend',

+ 'U_ACTION_TEAMPAGE' => $this->u_action . '&amp;field=teampage' . $category_url_param,

+ 'U_ACTION_TEAMPAGE_CAT' => $this->u_action . '&amp;field=teampage_cat',

+ 'S_TEAMPAGE_CATEGORY' => $category_id,

+ *

+ * @param string $module

+ * @param bool|string $module_class

+ * @param bool $use_all_available Use all available instead of just all

+ * enabled extensions

+ * @return array

+ function get_module_infos($module = '', $module_class = false, $use_all_available = false)

+ ->get_classes(true, $use_all_available);

+ $info_class = $module . '_info';

+ if (!class_exists($info_class) && file_exists($directory . $module . '.' . $phpEx))

+ global $phpbb_container;

+ 'user_avatar_type' => '',

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

+ $driver = $phpbb_avatar_manager->get_driver($user_row['user_avatar_type']);

+ if ($driver)

+ $driver->delete($user_row);

+ 'msn' => request_var('msn', $user_row['user_msnm']),

+ 'msn' => array('string', true, 5, 255),

+ 'user_msnm' => $data['msn'],

+ 'MSN' => $data['msn'],

+ $avatars_enabled = false;

+ if ($config['allow_avatar'])

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

+ $avatar_drivers = $phpbb_avatar_manager->get_enabled_drivers();

+ // This is normalised data, without the user_ prefix

+ $avatar_data = phpbb_avatar_manager::clean_row($user_row);

+

+ if ($submit)

+ if (check_form_key($form_name))

+ {

+ $driver_name = $phpbb_avatar_manager->clean_driver_name($request->variable('avatar_driver', ''));

+

+ if (in_array($driver_name, $avatar_drivers) && !$request->is_set_post('avatar_delete'))

+ {

+ $driver = $phpbb_avatar_manager->get_driver($driver_name);

+ $result = $driver->process_form($request, $template, $user, $avatar_data, $error);

+

+ if ($result && empty($error))

+ {

+ // Success! Lets save the result in the database

+ $result = array(

+ 'user_avatar_type' => $driver_name,

+ 'user_avatar' => $result['avatar'],

+ 'user_avatar_width' => $result['avatar_width'],

+ 'user_avatar_height' => $result['avatar_height'],

+ );

+

+ $sql = 'UPDATE ' . USERS_TABLE . '

+ SET ' . $db->sql_build_array('UPDATE', $result) . '

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

+

+ $db->sql_query($sql);

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

+ }

+ }

+ else

+ {

+ $driver = $phpbb_avatar_manager->get_driver($user->data['user_avatar_type']);

+ if ($driver)

+ {

+ $driver->delete($avatar_data);

+ }

+

+ // Removing the avatar

+ $result = array(

+ 'user_avatar' => '',

+ 'user_avatar_type' => '',

+ 'user_avatar_width' => 0,

+ 'user_avatar_height' => 0,

+ );

+

+ $sql = 'UPDATE ' . USERS_TABLE . '

+ SET ' . $db->sql_build_array('UPDATE', $result) . '

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

+

+ $db->sql_query($sql);

+ 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)

+ {

+ $driver = $phpbb_avatar_manager->get_driver($current_driver);

+ $avatars_enabled = true;

+ $config_name = $phpbb_avatar_manager->get_driver_config_name($driver);

+ $template->set_filenames(array(

+ 'avatar' => "acp_avatar_options_{$config_name}.html",

+ ));

+ if ($driver->prepare_form($request, $template, $user, $avatar_data, $error))

+ {

+ $driver_name = $phpbb_avatar_manager->prepare_driver_name($current_driver);

+ $driver_upper = strtoupper($driver_name);

+ $template->assign_block_vars('avatar_drivers', array(

+ 'L_TITLE' => $user->lang($driver_upper . '_TITLE'),

+ 'L_EXPLAIN' => $user->lang($driver_upper . '_EXPLAIN'),

+ 'DRIVER' => $driver_name,

+ 'SELECTED' => $current_driver == $selected_driver,

+ 'OUTPUT' => $template->assign_display('avatar'),

+ ));

+ }

+ }

+ // Replace "error" strings with their real, localised form

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

+

+ $avatar = phpbb_get_user_avatar($user_row, 'USER_AVATAR', true);

+

+ 'S_AVATAR' => true,

+ 'ERROR' => (!empty($error)) ? implode('<br />', $error) : '',

+ 'AVATAR' => (empty($avatar) ? '<img src="' . $phpbb_admin_path . 'images/no_avatar.gif" alt="" />' : $avatar),

+

+ 'S_FORM_ENCTYPE' => ' enctype="multipart/form-data"',

+

+ 'L_AVATAR_EXPLAIN' => sprintf($user->lang['AVATAR_EXPLAIN'], $config['avatar_max_width'], $config['avatar_max_height'], $config['avatar_filesize'] / 1024),

+

+ 'S_AVATARS_ENABLED' => ($config['allow_avatar'] && $avatars_enabled),

+ 'title' => 'ACP_EXTENSION_MANAGEMENT',

+ 'main' => array('title' => 'ACP_EXTENSIONS', 'auth' => 'acl_a_extensions', 'cat' => array('ACP_EXTENSION_MANAGEMENT')),

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2011 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Base class for avatar drivers

+* @package phpBB3

+*/

+abstract class phpbb_avatar_driver implements phpbb_avatar_driver_interface

+{

+ /**

+ * Avatar driver name

+ * @var string

+ */

+ protected $name;

+

+ /**

+ * Current board configuration

+ * @var phpbb_config

+ */

+ protected $config;

+

+ /**

+ * Current $phpbb_root_path

+ * @var string

+ */

+ protected $phpbb_root_path;

+

+ /**

+ * Current $php_ext

+ * @var string

+ */

+ protected $php_ext;

+

+ /**

+ * Cache driver

+ * @var phpbb_cache_driver_interface

+ */

+ protected $cache;

+

+ /**

+ * Array of allowed avatar image extensions

+ * Array is used for setting the allowed extensions in the fileupload class

+ * and as a base for a regex of allowed extensions, which will be formed by

+ * imploding the array with a "|".

+ *

+ * @var array

+ */

+ protected $allowed_extensions = array(

+ 'gif',

+ 'jpg',

+ 'jpeg',

+ 'png',

+ );

+

+ /**

+ * Construct a driver object

+ *

+ * @param phpbb_config $config phpBB configuration

+ * @param phpbb_request $request Request object

+ * @param string $phpbb_root_path Path to the phpBB root

+ * @param string $php_ext PHP file extension

+ * @param phpbb_cache_driver_interface $cache Cache driver

+ */

+ public function __construct(phpbb_config $config, $phpbb_root_path, $php_ext, phpbb_cache_driver_interface $cache = null)

+ {

+ $this->config = $config;

+ $this->phpbb_root_path = $phpbb_root_path;

+ $this->php_ext = $php_ext;

+ $this->cache = $cache;

+ }

+

+ /**

+ * @inheritdoc

+ */

+ public function get_custom_html($user, $row, $alt = '')

+ {

+ return '';

+ }

+

+ /**

+ * @inheritdoc

+ */

+ public function prepare_form_acp($user)

+ {

+ return array();

+ }

+

+ /**

+ * @inheritdoc

+ */

+ public function delete($row)

+ {

+ return true;

+ }

+

+ /**

+ * @inheritdoc

+ */

+ public function get_template_name()

+ {

+ $driver = preg_replace('#^phpbb_avatar_driver_#', '', get_class($this));

+ $template = "ucp_avatar_options_$driver.html";

+

+ return $template;

+ }

+

+ /**

+ * @inheritdoc

+ */

+ public function get_name()

+ {

+ return $this->name;

+ }

+

+ /**

+ * Sets the name of the driver.

+ *

+ * @param string $name Driver name

+ */

+ public function set_name($name)

+ {

+ $this->name = $name;

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @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;

+}

+

+/**

+* Handles avatars hosted at gravatar.com

+* @package phpBB3

+*/

+class phpbb_avatar_driver_gravatar extends phpbb_avatar_driver

+{

+ /**

+ * The URL for the gravatar service

+ */

+ const GRAVATAR_URL = '//secure.gravatar.com/avatar/';

+

+ /**

+ * @inheritdoc

+ */

+ public function get_data($row)

+ {

+ return array(

+ 'src' => $row['avatar'],

+ 'width' => $row['avatar_width'],

+ 'height' => $row['avatar_height'],

+ );

+ }

+

+ /**

+ * @inheritdoc

+ */

+ public function get_custom_html($user, $row, $alt = '')

+ {

+ return '<img src="' . $this->get_gravatar_url($row) . '" ' .

+ ($row['avatar_width'] ? ('width="' . $row['avatar_width'] . '" ') : '') .

+ ($row['avatar_height'] ? ('height="' . $row['avatar_height'] . '" ') : '') .

+ 'alt="' . ((!empty($user->lang[$alt])) ? $user->lang[$alt] : $alt) . '" />';

+ }

+

+ /**

+ * @inheritdoc

+ */

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

+ {

+ $template->assign_vars(array(

+ 'AVATAR_GRAVATAR_WIDTH' => (($row['avatar_type'] == $this->get_name() || $row['avatar_type'] == 'gravatar') && $row['avatar_width']) ? $row['avatar_width'] : $request->variable('avatar_gravatar_width', 0),

+ 'AVATAR_GRAVATAR_HEIGHT' => (($row['avatar_type'] == $this->get_name() || $row['avatar_type'] == 'gravatar') && $row['avatar_height']) ? $row['avatar_height'] : $request->variable('avatar_gravatar_width', 0),

+ 'AVATAR_GRAVATAR_EMAIL' => (($row['avatar_type'] == $this->get_name() || $row['avatar_type'] == 'gravatar') && $row['avatar']) ? $row['avatar'] : '',

+ ));

+

+ return true;

+ }

+

+ /**

+ * @inheritdoc

+ */

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

+ {

+ $row['avatar'] = $request->variable('avatar_gravatar_email', '');

+ $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);

+ }

+

+ $validate_array = validate_data(

+ array(

+ 'email' => $row['avatar'],

+ ),

+ array(

+ 'email' => array(

+ array('string', false, 6, 60),

+ array('email'))

+ )

+ );

+

+ $error = array_merge($error, $validate_array);

+

+ if (!empty($error))

+ {

+ return false;

+ }

+

+ // Make sure getimagesize works...

+ if (function_exists('getimagesize') && ($row['avatar_width'] <= 0 || $row['avatar_height'] <= 0))

+ {

+ /**

+ * default to the minimum of the maximum allowed avatar size if the size

+ * is not or only partially entered

+ */

+ $row['avatar_width'] = $row['avatar_height'] = min($this->config['avatar_max_width'], $this->config['avatar_max_height']);

+ $url = $this->get_gravatar_url($row);

+

+ if (($row['avatar_width'] <= 0 || $row['avatar_height'] <= 0) && (($image_data = getimagesize($url)) === false))

+ {

+ $error[] = 'UNABLE_GET_IMAGE_SIZE';

+ return false;

+ }

+

+ if (!empty($image_data) && ($image_data[0] <= 0 || $image_data[1] <= 0))

+ {

+ $error[] = 'AVATAR_NO_SIZE';

+ return false;

+ }

+

+ $row['avatar_width'] = ($row['avatar_width'] && $row['avatar_height']) ? $row['avatar_width'] : $image_data[0];

+ $row['avatar_height'] = ($row['avatar_width'] && $row['avatar_height']) ? $row['avatar_height'] : $image_data[1];

+ }

+

+ if ($row['avatar_width'] <= 0 || $row['avatar_height'] <= 0)

+ {

+ $error[] = 'AVATAR_NO_SIZE';

+ return false;

+ }

+

+ if ($this->config['avatar_max_width'] || $this->config['avatar_max_height'])

+ {

+ if ($row['avatar_width'] > $this->config['avatar_max_width'] || $row['avatar_height'] > $this->config['avatar_max_height'])

+ {

+ $error[] = array('AVATAR_WRONG_SIZE', $this->config['avatar_min_width'], $this->config['avatar_min_height'], $this->config['avatar_max_width'], $this->config['avatar_max_height'], $row['avatar_width'], $row['avatar_height']);

+ return false;

+ }

+ }

+

+ if ($this->config['avatar_min_width'] || $this->config['avatar_min_height'])

+ {

+ if ($row['avatar_width'] < $this->config['avatar_min_width'] || $row['avatar_height'] < $this->config['avatar_min_height'])

+ {

+ $error[] = array('AVATAR_WRONG_SIZE', $this->config['avatar_min_width'], $this->config['avatar_min_height'], $this->config['avatar_max_width'], $this->config['avatar_max_height'], $row['avatar_width'], $row['avatar_height']);

+ return false;

+ }

+ }

+

+ return array(

+ 'avatar' => $row['avatar'],

+ 'avatar_width' => $row['avatar_width'],

+ 'avatar_height' => $row['avatar_height'],

+ );

+ }

+

+ /**

+ * Build gravatar URL for output on page

+ *

+ * @return string Gravatar URL

+ */

+ protected function get_gravatar_url($row)

+ {

+ $url = self::GRAVATAR_URL;

+ $url .= md5(strtolower(trim($row['avatar'])));

+

+ if ($row['avatar_width'] || $row['avatar_height'])

+ {

+ $url .= '?s=' . max($row['avatar_width'], $row['avatar_height']);

+ }

+

+ return $url;

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2011 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Interface for avatar drivers

+* @package phpBB3

+*/

+interface phpbb_avatar_driver_interface

+{

+ /**

+ * Returns the name of the driver.

+ *

+ * @return string Name of driver.

+ */

+ public function get_name();

+

+ /**

+ * Get the avatar url and dimensions

+ *

+ * @param array $row User data or group data that has been cleaned with

+ * phpbb_avatar_manager::clean_row

+ * @return array Avatar data, must have keys src, width and height, e.g.

+ * ['src' => '', 'width' => 0, 'height' => 0]

+ */

+ public function get_data($row);

+

+ /**

+ * Returns custom html if it is needed for displaying this avatar

+ *

+ * @param phpbb_user $user phpBB user object

+ * @param array $row User data or group data that has been cleaned with

+ * phpbb_avatar_manager::clean_row

+ * @param string $alt Alternate text for avatar image

+ *

+ * @return string HTML

+ */

+ public function get_custom_html($user, $row, $alt = '');

+

+ /**

+ * Prepare form for changing the settings of this avatar

+ *

+ * @param phpbb_request $request Request object

+ * @param phpbb_template $template Template object

+ * @param phpbb_user $user User object

+ * @param array $row User data or group data that has been cleaned with

+ * phpbb_avatar_manager::clean_row

+ * @param array &$error Reference to an error array that is filled by this

+ * function. Key values can either be a string with a language key or

+ * an array that will be passed to vsprintf() with the language key in

+ * the first array key.

+ *

+ * @return bool True if form has been successfully prepared

+ */

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

+

+ /**

+ * Prepare form for changing the acp settings of this avatar

+ *

+ * @param phpbb_user $user phpBB user object

+ *

+ * @return array Array of configuration options as consumed by acp_board.

+ * The setting for enabling/disabling the avatar will be handled by

+ * the avatar manager.

+ */

+ public function prepare_form_acp($user);

+

+ /**

+ * Process form data

+ *

+ * @param phpbb_request $request Request object

+ * @param phpbb_template $template Template object

+ * @param phpbb_user $user User object

+ * @param array $row User data or group data that has been cleaned with

+ * phpbb_avatar_manager::clean_row

+ * @param array &$error Reference to an error array that is filled by this

+ * function. Key values can either be a string with a language key or

+ * an array that will be passed to vsprintf() with the language key in

+ * the first array key.

+ *

+ * @return array Array containing the avatar data as follows:

+ * ['avatar'], ['avatar_width'], ['avatar_height']

+ */

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

+

+ /**

+ * Delete avatar

+ *

+ * @param array $row User data or group data that has been cleaned with

+ * phpbb_avatar_manager::clean_row

+ *

+ * @return bool True if avatar has been deleted or there is no need to delete,

+ * i.e. when the avatar is not hosted locally.

+ */

+ public function delete($row);

+

+ /**

+ * Get the avatar driver's template name

+ *

+ * @return string Avatar driver's template name

+ */

+ public function get_template_name();

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2011 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Handles avatars selected from the board gallery

+* @package phpBB3

+*/

+class phpbb_avatar_driver_local extends phpbb_avatar_driver

+{

+ /**

+ * @inheritdoc

+ */

+ public function get_data($row)

+ {

+ return array(

+ 'src' => $this->phpbb_root_path . $this->config['avatar_gallery_path'] . '/' . $row['avatar'],

+ 'width' => $row['avatar_width'],

+ 'height' => $row['avatar_height'],

+ );

+ }

+

+ /**

+ * @inheritdoc

+ */

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

+ {

+ $avatar_list = $this->get_avatar_list($user);

+ $category = $request->variable('avatar_local_cat', '');

+

+ foreach ($avatar_list as $cat => $null)

+ {

+ if (!empty($avatar_list[$cat]))

+ {

+ $template->assign_block_vars('avatar_local_cats', array(

+ 'NAME' => $cat,

+ 'SELECTED' => ($cat == $category),

+ ));

+ }

+

+ if ($cat != $category)

+ {

+ unset($avatar_list[$cat]);

+ }

+ }

+

+ if (!empty($avatar_list[$category]))

+ {

+ $template->assign_vars(array(

+ 'AVATAR_LOCAL_SHOW' => true,

+ ));

+

+ $table_cols = isset($row['avatar_gallery_cols']) ? $row['avatar_gallery_cols'] : 4;

+ $row_count = $col_count = $avatar_pos = 0;

+ $avatar_count = sizeof($avatar_list[$category]);

+

+ reset($avatar_list[$category]);

+

+ while ($avatar_pos < $avatar_count)

+ {

+ $img = current($avatar_list[$category]);

+ next($avatar_list[$category]);

+

+ if ($col_count == 0)

+ {

+ ++$row_count;

+ $template->assign_block_vars('avatar_local_row', array(

+ ));

+ }

+

+ $template->assign_block_vars('avatar_local_row.avatar_local_col', array(

+ 'AVATAR_IMAGE' => $this->phpbb_root_path . $this->config['avatar_gallery_path'] . '/' . $img['file'],

+ 'AVATAR_NAME' => $img['name'],

+ 'AVATAR_FILE' => $img['filename'],

+ ));

+

+ $template->assign_block_vars('avatar_local_row.avatar_local_option', array(

+ 'AVATAR_FILE' => $img['filename'],

+ 'S_OPTIONS_AVATAR' => $img['filename']

+ ));

+

+ $col_count = ($col_count + 1) % $table_cols;

+

+ ++$avatar_pos;

+ }

+ }

+

+ return true;

+ }

+

+ /**

+ * @inheritdoc

+ */

+ public function prepare_form_acp($user)

+ {

+ return array(

+ 'avatar_gallery_path' => array('lang' => 'AVATAR_GALLERY_PATH', 'validate' => 'rpath', 'type' => 'text:20:255', 'explain' => true),

+ );

+ }

+

+ /**

+ * @inheritdoc

+ */

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

+ {

+ $avatar_list = $this->get_avatar_list($user);

+ $category = $request->variable('avatar_local_cat', '');

+

+ $file = $request->variable('avatar_local_file', '');

+

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

+ {

+ $error[] = 'NO_AVATAR_SELECTED';

+ return false;

+ }

+

+ if (!isset($avatar_list[$category][urldecode($file)]))

+ {

+ $error[] = 'AVATAR_URL_NOT_FOUND';

+ return false;

+ }

+

+ return array(

+ 'avatar' => ($category != $user->lang['MAIN']) ? $category . '/' . $file : $file,

+ 'avatar_width' => $avatar_list[$category][urldecode($file)]['width'],

+ 'avatar_height' => $avatar_list[$category][urldecode($file)]['height'],

+ );

+ }

+

+ /**

+ * Get a list of avatars that are locally available

+ * Results get cached for 24 hours (86400 seconds)

+ *

+ * @param phpbb_user $user User object

+ *

+ * @return array Array containing the locally available avatars

+ */

+ protected function get_avatar_list($user)

+ {

+ $avatar_list = ($this->cache == null) ? false : $this->cache->get('avatar_local_list');

+

+ if ($avatar_list === false)

+ {

+ $avatar_list = array();

+ $path = $this->phpbb_root_path . $this->config['avatar_gallery_path'];

+

+ $iterator = new RecursiveIteratorIterator(new RecursiveDirectoryIterator($path, FilesystemIterator::SKIP_DOTS | FilesystemIterator::UNIX_PATHS), RecursiveIteratorIterator::SELF_FIRST);

+ foreach ($iterator as $file_info)

+ {

+ $file_path = $file_info->getPath();

+ $image = $file_info->getFilename();

+

+ // Match all images in the gallery folder

+ if (preg_match('#^[^&\'"<>]+\.(?:' . implode('|', $this->allowed_extensions) . ')$#i', $image) && is_file($file_path . '/' . $image))

+ {

+ if (function_exists('getimagesize'))

+ {

+ $dims = getimagesize($file_path . '/' . $image);

+ }

+ else

+ {

+ $dims = array(0, 0);

+ }

+ $cat = ($path == $file_path) ? $user->lang['MAIN'] : str_replace("$path/", '', $file_path);

+ $avatar_list[$cat][$image] = array(

+ 'file' => ($cat != $user->lang['MAIN']) ? rawurlencode($cat) . '/' . rawurlencode($image) : rawurlencode($image),

+ 'filename' => rawurlencode($image),

+ 'name' => ucfirst(str_replace('_', ' ', preg_replace('#^(.*)\..*$#', '\1', $image))),

+ 'width' => $dims[0],

+ 'height' => $dims[1],

+ );

+ }

+ }

+ ksort($avatar_list);

+

+ if ($this->cache != null)

+ {

+ $this->cache->put('avatar_local_list', $avatar_list, 86400);

+ }

+ }

+

+ return $avatar_list;

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2011 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Handles avatars hosted remotely

+* @package phpBB3

+*/

+class phpbb_avatar_driver_remote extends phpbb_avatar_driver

+{

+ /**

+ * @inheritdoc

+ */

+ public function get_data($row)

+ {

+ return array(

+ 'src' => $row['avatar'],

+ 'width' => $row['avatar_width'],

+ 'height' => $row['avatar_height'],

+ );

+ }

+

+ /**

+ * @inheritdoc

+ */

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

+ {

+ $template->assign_vars(array(

+ 'AVATAR_REMOTE_WIDTH' => ((in_array($row['avatar_type'], array(AVATAR_REMOTE, $this->get_name(), 'remote'))) && $row['avatar_width']) ? $row['avatar_width'] : $request->variable('avatar_remote_width', 0),

+ 'AVATAR_REMOTE_HEIGHT' => ((in_array($row['avatar_type'], array(AVATAR_REMOTE, $this->get_name(), 'remote'))) && $row['avatar_height']) ? $row['avatar_height'] : $request->variable('avatar_remote_width', 0),

+ 'AVATAR_REMOTE_URL' => ((in_array($row['avatar_type'], array(AVATAR_REMOTE, $this->get_name(), 'remote'))) && $row['avatar']) ? $row['avatar'] : '',

+ ));

+

+ return true;

+ }

+

+ /**

+ * @inheritdoc

+ */

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

+ {

+ $url = $request->variable('avatar_remote_url', '');

+ $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;

+ }

+

+ if (!function_exists('validate_data'))

+ {

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

+ }

+

+ $validate_array = validate_data(

+ array(

+ 'url' => $url,

+ ),

+ array(

+ 'url' => array('string', true, 5, 255),

+ )

+ );

+

+ $error = array_merge($error, $validate_array);

+

+ if (!empty($error))

+ {

+ return false;

+ }

+

+ // Check if this url looks alright

+ // This isn't perfect, but it's what phpBB 3.0 did, and might as well make sure everything is compatible

+ if (!preg_match('#^(http|https|ftp)://(?:(.*?\.)*?[a-z0-9\-]+?\.[a-z]{2,4}|(?:\d{1,3}\.){3,5}\d{1,3}):?([0-9]*?).*?\.('. implode('|', $this->allowed_extensions) . ')$#i', $url))

+ {

+ $error[] = 'AVATAR_URL_INVALID';

+ return false;

+ }

+

+ // Make sure getimagesize works...

+ if (function_exists('getimagesize'))

+ {

+ if (($width <= 0 || $height <= 0) && (($image_data = getimagesize($url)) === false))

+ {

+ $error[] = 'UNABLE_GET_IMAGE_SIZE';

+ return false;

+ }

+

+ if (!empty($image_data) && ($image_data[0] <= 0 || $image_data[1] <= 0))

+ {

+ $error[] = 'AVATAR_NO_SIZE';

+ return false;

+ }

+

+ $width = ($width && $height) ? $width : $image_data[0];

+ $height = ($width && $height) ? $height : $image_data[1];

+ }

+

+ if ($width <= 0 || $height <= 0)

+ {

+ $error[] = 'AVATAR_NO_SIZE';

+ return false;

+ }

+

+ if (!class_exists('fileupload'))

+ {

+ include($this->phpbb_root_path . 'includes/functions_upload' . $this->php_ext);

+ }

+

+ $types = fileupload::image_types();

+ $extension = strtolower(filespec::get_extension($url));

+

+ if (!empty($image_data) && (!isset($types[$image_data[2]]) || !in_array($extension, $types[$image_data[2]])))

+ {

+ if (!isset($types[$image_data[2]]))

+ {

+ $error[] = 'UNABLE_GET_IMAGE_SIZE';

+ }

+ else

+ {

+ $error[] = array('IMAGE_FILETYPE_MISMATCH', $types[$image_data[2]][0], $extension);

+ }

+

+ return false;

+ }

+

+ if ($this->config['avatar_max_width'] || $this->config['avatar_max_height'])

+ {

+ if ($width > $this->config['avatar_max_width'] || $height > $this->config['avatar_max_height'])

+ {

+ $error[] = array('AVATAR_WRONG_SIZE', $this->config['avatar_min_width'], $this->config['avatar_min_height'], $this->config['avatar_max_width'], $this->config['avatar_max_height'], $width, $height);

+ return false;

+ }

+ }

+

+ if ($this->config['avatar_min_width'] || $this->config['avatar_min_height'])

+ {

+ if ($width < $this->config['avatar_min_width'] || $height < $this->config['avatar_min_height'])

+ {

+ $error[] = array('AVATAR_WRONG_SIZE', $this->config['avatar_min_width'], $this->config['avatar_min_height'], $this->config['avatar_max_width'], $this->config['avatar_max_height'], $width, $height);

+ return false;

+ }

+ }

+

+ return array(

+ 'avatar' => $url,

+ 'avatar_width' => $width,

+ 'avatar_height' => $height,

+ );

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2011 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Handles avatars uploaded to the board

+* @package phpBB3

+*/

+class phpbb_avatar_driver_upload extends phpbb_avatar_driver

+{

+ /**

+ * @inheritdoc

+ */

+ public function get_data($row, $ignore_config = false)

+ {

+ return array(

+ 'src' => $this->phpbb_root_path . 'download/file' . $this->php_ext . '?avatar=' . $row['avatar'],

+ 'width' => $row['avatar_width'],

+ 'height' => $row['avatar_height'],

+ );

+ }

+

+ /**

+ * @inheritdoc

+ */

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

+ {

+ if (!$this->can_upload())

+ {

+ return false;

+ }

+

+ $template->assign_vars(array(

+ 'S_UPLOAD_AVATAR_URL' => ($this->config['allow_avatar_remote_upload']) ? true : false,

+ 'AVATAR_UPLOAD_SIZE' => $this->config['avatar_filesize'],

+ ));

+

+ return true;

+ }

+

+ /**

+ * @inheritdoc

+ */

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

+ {

+ if (!$this->can_upload())

+ {

+ return false;

+ }

+

+ if (!class_exists('fileupload'))

+ {

+ include($this->phpbb_root_path . 'includes/functions_upload' . $this->php_ext);

+ }

+

+ $upload = new fileupload('AVATAR_', $this->allowed_extensions, $this->config['avatar_filesize'], $this->config['avatar_min_width'], $this->config['avatar_min_height'], $this->config['avatar_max_width'], $this->config['avatar_max_height'], (isset($this->config['mime_triggers']) ? explode('|', $this->config['mime_triggers']) : false));

+

+ $url = $request->variable('avatar_upload_url', '');

+ $upload_file = $request->file('avatar_upload_file');

+

+ if (!empty($upload_file['name']))

+ {

+ $file = $upload->form_upload('avatar_upload_file');

+ }

+ elseif (!empty($this->config['allow_avatar_remote_upload']) && !empty($url))

+ {

+ $file = $upload->remote_upload($url);

+ }

+ else

+ {

+ $error[] = 'NO_AVATAR_SELECTED';

+ return false;

+ }

+

+ $prefix = $this->config['avatar_salt'] . '_';

+ $file->clean_filename('avatar', $prefix, $row['id']);

+

+ $destination = $this->config['avatar_path'];

+

+ // Adjust destination path (no trailing slash)

+ if (substr($destination, -1, 1) == '/' || substr($destination, -1, 1) == '\\')

+ {

+ $destination = substr($destination, 0, -1);

+ }

+

+ $destination = str_replace(array('../', '..\\', './', '.\\'), '', $destination);

+ if ($destination && ($destination[0] == '/' || $destination[0] == "\\"))

+ {

+ $destination = '';

+ }

+

+ // Move file and overwrite any existing image

+ $file->move_file($destination, true);

+

+ if (sizeof($file->error))

+ {

+ $file->remove();

+ $error = array_merge($error, $file->error);

+ return false;

+ }

+

+ return array(

+ 'avatar' => $row['id'] . '_' . time() . '.' . $file->get('extension'),

+ 'avatar_width' => $file->get('width'),

+ 'avatar_height' => $file->get('height'),

+ );

+ }

+

+ /**

+ * @inheritdoc

+ */

+ public function prepare_form_acp($user)

+ {

+ return array(

+ 'allow_avatar_remote_upload'=> array('lang' => 'ALLOW_REMOTE_UPLOAD', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true),

+ 'avatar_filesize' => array('lang' => 'MAX_FILESIZE', 'validate' => 'int:0', 'type' => 'text:4:10', 'explain' => true, 'append' => ' ' . $user->lang['BYTES']),

+ 'avatar_path' => array('lang' => 'AVATAR_STORAGE_PATH', 'validate' => 'rwpath', 'type' => 'text:20:255', 'explain' => true),

+ );

+ }

+

+ /**

+ * @inheritdoc

+ */

+ public function delete($row)

+ {

+ $ext = substr(strrchr($row['avatar'], '.'), 1);

+ $filename = $this->phpbb_root_path . $this->config['avatar_path'] . '/' . $this->config['avatar_salt'] . '_' . $row['id'] . '.' . $ext;

+

+ if (file_exists($filename))

+ {

+ @unlink($filename);

+ }

+

+ return true;

+ }

+

+ /**

+ * Check if user is able to upload an avatar

+ *

+ * @return bool True if user can upload, false if not

+ */

+ protected function can_upload()

+ {

+ return (file_exists($this->phpbb_root_path . $this->config['avatar_path']) && phpbb_is_writable($this->phpbb_root_path . $this->config['avatar_path']) && (@ini_get('file_uploads') || strtolower(@ini_get('file_uploads')) == 'on'));

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2011 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* @package avatar

+*/

+class phpbb_avatar_manager

+{

+ /**

+ * phpBB configuration

+ * @var phpbb_config

+ */

+ protected $config;

+

+ /**

+ * Array that contains a list of enabled drivers

+ * @var array

+ */

+ static protected $enabled_drivers = false;

+

+ /**

+ * Array that contains all available avatar drivers which are passed via the

+ * service container

+ * @var array

+ */

+ protected $avatar_drivers;

+

+ /**

+ * Service container object

+ * @var object

+ */

+ protected $container;

+

+ /**

+ * Construct an avatar manager object

+ *

+ * @param phpbb_config $config phpBB configuration

+ * @param array $avatar_drivers Avatar drivers passed via the service container

+ * @param object $container Container object

+ */

+ public function __construct(phpbb_config $config, $avatar_drivers, $container)

+ {

+ $this->config = $config;

+ $this->avatar_drivers = $avatar_drivers;

+ $this->container = $container;

+ }

+

+ /**

+ * Get the driver object specified by the avatar type

+ *

+ * @param string $avatar_type Avatar type; by default an avatar's service container name

+ * @param bool $load_enabled Load only enabled avatars

+ *

+ * @return object Avatar driver object

+ */

+ public function get_driver($avatar_type, $load_enabled = true)

+ {

+ if (self::$enabled_drivers === false)

+ {

+ $this->load_enabled_drivers();

+ }

+

+ $avatar_drivers = ($load_enabled) ? self::$enabled_drivers : $this->get_all_drivers();

+

+ // Legacy stuff...

+ switch ($avatar_type)

+ {

+ case AVATAR_GALLERY:

+ $avatar_type = 'avatar.driver.local';

+ break;

+ case AVATAR_UPLOAD:

+ $avatar_type = 'avatar.driver.upload';

+ break;

+ case AVATAR_REMOTE:

+ $avatar_type = 'avatar.driver.remote';

+ break;

+ }

+

+ if (!isset($avatar_drivers[$avatar_type]))

+ {

+ return null;

+ }

+

+ /*

+ * There is no need to handle invalid avatar types as the following code

+ * will cause a ServiceNotFoundException if the type does not exist

+ */

+ $driver = $this->container->get($avatar_type);

+

+ return $driver;

+ }

+

+ /**

+ * Load the list of enabled drivers

+ * This is executed once and fills self::$enabled_drivers

+ */

+ protected function load_enabled_drivers()

+ {

+ if (!empty($this->avatar_drivers))

+ {

+ self::$enabled_drivers = array();

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

+ {

+ if ($this->is_enabled($driver))

+ {

+ self::$enabled_drivers[$driver->get_name()] = $driver->get_name();

+ }

+ }

+ asort(self::$enabled_drivers);

+ }

+ }

+

+ /**

+ * Get a list of all avatar drivers

+ *

+ * As this function will only be called in the ACP avatar settings page, it

+ * doesn't make much sense to cache the list of all avatar drivers like the

+ * list of the enabled drivers.

+ *

+ * @return array Array containing a list of all avatar drivers

+ */

+ public function get_all_drivers()

+ {

+ $drivers = array();

+

+ if (!empty($this->avatar_drivers))

+ {

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

+ {

+ $drivers[$driver->get_name()] = $driver->get_name();

+ }

+ asort($drivers);

+ }

+

+ return $drivers;

+ }

+

+ /**

+ * Get a list of enabled avatar drivers

+ *

+ * @return array Array containing a list of the enabled avatar drivers

+ */

+ public function get_enabled_drivers()

+ {

+ if (self::$enabled_drivers === false)

+ {

+ $this->load_enabled_drivers();

+ }

+

+ return self::$enabled_drivers;

+ }

+

+ /**

+ * Strip out user_ and group_ prefixes from keys

+ *

+ * @param array $row User data or group data

+ *

+ * @return array User data or group data with keys that have been

+ * stripped from the preceding "user_" or "group_"

+ */

+ static public function clean_row($row)

+ {

+ $keys = array_keys($row);

+ $values = array_values($row);

+

+ $keys = array_map(array('phpbb_avatar_manager', 'strip_prefix'), $keys);

+

+ return array_combine($keys, $values);

+ }

+

+ /**

+ * Strip prepending user_ or group_ prefix from key

+ *

+ * @param string Array key

+ * @return string Key that has been stripped from its prefix

+ */

+ static protected function strip_prefix($key)

+ {

+ return preg_replace('#^(?:user_|group_)#', '', $key);

+ }

+

+ /**

+ * Clean driver names that are returned from template files

+ * Underscores are replaced with dots

+ *

+ * @param string $name Driver name

+ *

+ * @return string Cleaned driver name

+ */

+ static public function clean_driver_name($name)

+ {

+ return str_replace('_', '.', $name);

+ }

+

+ /**

+ * Prepare driver names for use in template files

+ * Dots are replaced with underscores

+ *

+ * @param string $name Clean driver name

+ *

+ * @return string Prepared driver name

+ */

+ static public function prepare_driver_name($name)

+ {

+ return str_replace('.', '_', $name);

+ }

+

+ /**

+ * Check if avatar is enabled

+ *

+ * @param object $driver Avatar driver object

+ *

+ * @return bool True if avatar is enabled, false if it's disabled

+ */

+ public function is_enabled($driver)

+ {

+ $config_name = $this->get_driver_config_name($driver);

+

+ return $this->config["allow_avatar_{$config_name}"];

+ }

+

+ /**

+ * Get the settings array for enabling/disabling an avatar driver

+ *

+ * @param object $driver Avatar driver object

+ *

+ * @return array Array of configuration options as consumed by acp_board

+ */

+ public function get_avatar_settings($driver)

+ {

+ $config_name = $this->get_driver_config_name($driver);

+

+ return array(

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

+ );

+ }

+

+ /**

+ * Get the config name of an avatar driver

+ *

+ * @param object $driver Avatar driver object

+ *

+ * @return string Avatar driver config name

+ */

+ public function get_driver_config_name($driver)

+ {

+ return preg_replace('#^phpbb_avatar_driver_#', '', get_class($driver));

+ }

+

+ /**

+ * Replace "error" strings with their real, localized form

+ *

+ * @param phpbb_user phpBB User object

+ * @param array $error Array containing error strings

+ * Key values can either be a string with a language key or an array

+ * that will be passed to vsprintf() with the language key in the

+ * first array key.

+ *

+ * @return array Array containing the localized error strings

+ */

+ public function localize_errors(phpbb_user $user, $error)

+ {

+ foreach ($error as $key => $lang)

+ {

+ if (is_array($lang))

+ {

+ $lang_key = array_shift($lang);

+ $error[$key] = vsprintf($user->lang($lang_key), $lang);

+ }

+ else

+ {

+ $error[$key] = $user->lang("$lang");

+ }

+ }

+

+ return $error;

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Manages configuration options with an arbitrary length value stored in a TEXT

+* column. In constrast to class phpbb_config_db, values are never cached and

+* prefetched, but every get operation sends a query to the database.

+*

+* @package phpBB3

+*/

+class phpbb_config_db_text

+{

+ /**

+ * Database connection

+ * @var phpbb_db_driver

+ */

+ protected $db;

+

+ /**

+ * Name of the database table used.

+ * @var string

+ */

+ protected $table;

+

+ /**

+ * @param phpbb_db_driver $db Database connection

+ * @param string $table Table name

+ */

+ public function __construct(phpbb_db_driver $db, $table)

+ {

+ $this->db = $db;

+ $this->table = $this->db->sql_escape($table);

+ }

+

+ /**

+ * Sets the configuration option with the name $key to $value.

+ *

+ * @param string $key The configuration option's name

+ * @param string $value New configuration value

+ *

+ * @return null

+ */

+ public function set($key, $value)

+ {

+ $this->set_array(array($key => $value));

+ }

+

+ /**

+ * Gets the configuration value for the name $key.

+ *

+ * @param string $key The configuration option's name

+ *

+ * @return string|null String result on success

+ * null if there is no such option

+ */

+ public function get($key)

+ {

+ $map = $this->get_array(array($key));

+

+ return isset($map[$key]) ? $map[$key] : null;

+ }

+

+ /**

+ * Removes the configuration option with the name $key.

+ *

+ * @param string $key The configuration option's name

+ *

+ * @return null

+ */

+ public function delete($key)

+ {

+ $this->delete_array(array($key));

+ }

+

+ /**

+ * Mass set configuration options: Receives an associative array,

+ * treats array keys as configuration option names and associated

+ * array values as their configuration option values.

+ *

+ * @param array $map Map from configuration names to values

+ *

+ * @return null

+ */

+ public function set_array(array $map)

+ {

+ $this->db->sql_transaction('begin');

+

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

+ {

+ $sql = 'UPDATE ' . $this->table . "

+ SET config_value = '" . $this->db->sql_escape($value) . "'

+ WHERE config_name = '" . $this->db->sql_escape($key) . "'";

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

+

+ if (!$this->db->sql_affectedrows($result))

+ {

+ $sql = 'INSERT INTO ' . $this->table . ' ' . $this->db->sql_build_array('INSERT', array(

+ 'config_name' => $key,

+ 'config_value' => $value,

+ ));

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

+ }

+ }

+

+ $this->db->sql_transaction('commit');

+ }

+

+ /**

+ * Mass get configuration options: Receives a set of configuration

+ * option names and returns the result as a key => value map where

+ * array keys are configuration option names and array values are

+ * associated config option values.

+ *

+ * @param array $keys Set of configuration option names

+ *

+ * @return array Map from configuration names to values

+ */

+ public function get_array(array $keys)

+ {

+ $sql = 'SELECT *

+ FROM ' . $this->table . '

+ WHERE ' . $this->db->sql_in_set('config_name', $keys, false, true);

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

+

+ $map = array();

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

+ {

+ $map[$row['config_name']] = $row['config_value'];

+ }

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

+

+ return $map;

+ }

+

+ /**

+ * Mass delete configuration options.

+ *

+ * @param array $keys Set of configuration option names

+ *

+ * @return null

+ */

+ public function delete_array(array $keys)

+ {

+ $sql = 'DELETE

+ FROM ' . $this->table . '

+ WHERE ' . $this->db->sql_in_set('config_name', $keys, false, true);

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

+ }

+}

+define('MIGRATIONS_TABLE', $table_prefix . 'migrations');

+define('NOTIFICATION_TYPES_TABLE', $table_prefix . 'notification_types');

+define('NOTIFICATIONS_TABLE', $table_prefix . 'notifications');

+define('TEAMPAGE_TABLE', $table_prefix . 'teampage');

+define('USER_NOTIFICATIONS_TABLE', $table_prefix . 'user_notifications');

+ 'lang' => array_filter($user->lang['datetime'], 'is_string'),

+ function phpbb_db_tools(phpbb_db_driver $db, $return_statements = false)

+ * Setter for {@link $return_statements return_statements}.

+ *

+ * @param bool $return_statements True if SQL should not be executed but returned as strings

+ * @return null

+ */

+ public function set_return_statements($return_statements)

+ {

+ $this->return_statements = $return_statements;

+ }

+

+ /**

+ * drop_tables: Drop tables

+ * add_tables: Add tables

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_data_30x_3_0_1 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return version_compare($this->config['version'], '3.0.1', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_1_rc1');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.0.1')),

+ );

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_data_30x_3_0_10 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return version_compare($this->config['version'], '3.0.10', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_10_rc3');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.0.10')),

+ );

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_data_30x_3_0_10_rc1 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return version_compare($this->config['version'], '3.0.10-rc1', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_9');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.add', array('email_max_chunk_size', 50)),

+

+ array('config.update', array('version', '3.0.10-rc1')),

+ );

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_data_30x_3_0_10_rc2 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return version_compare($this->config['version'], '3.0.10-rc2', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_10_rc1');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.0.10-rc2')),

+ );

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_data_30x_3_0_10_rc3 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return version_compare($this->config['version'], '3.0.10-rc3', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_10_rc2');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.0.10-rc3')),

+ );

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_data_30x_3_0_11 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return version_compare($this->config['version'], '3.0.11', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_11_rc2');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.0.11')),

+ );

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_data_30x_3_0_11_rc1 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return version_compare($this->config['version'], '3.0.11-rc1', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_10');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('custom', array(array(&$this, 'cleanup_deactivated_styles'))),

+ array('custom', array(array(&$this, 'delete_orphan_private_messages'))),

+

+ array('config.update', array('version', '3.0.11-rc1')),

+ );

+ }

+

+ public function cleanup_deactivated_styles()

+ {

+ // Updates users having current style a deactivated one

+ $sql = 'SELECT style_id

+ FROM ' . STYLES_TABLE . '

+ WHERE style_active = 0';

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

+

+ $deactivated_style_ids = array();

+ while ($style_id = $this->db->sql_fetchfield('style_id', false, $result))

+ {

+ $deactivated_style_ids[] = (int) $style_id;

+ }

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

+

+ if (!empty($deactivated_style_ids))

+ {

+ $sql = 'UPDATE ' . USERS_TABLE . '

+ SET user_style = ' . (int) $this->config['default_style'] .'

+ WHERE ' . $this->db->sql_in_set('user_style', $deactivated_style_ids);

+ $this->sql_query($sql);

+ }

+ }

+

+ public function delete_orphan_private_messages()

+ {

+ // Delete orphan private messages

+ $batch_size = 500;

+

+ $sql_array = array(

+ 'SELECT' => 'p.msg_id',

+ 'FROM' => array(

+ PRIVMSGS_TABLE => 'p',

+ ),

+ 'LEFT_JOIN' => array(

+ array(

+ 'FROM' => array(PRIVMSGS_TO_TABLE => 't'),

+ 'ON' => 'p.msg_id = t.msg_id',

+ ),

+ ),

+ 'WHERE' => 't.user_id IS NULL',

+ );

+ $sql = $this->db->sql_build_query('SELECT', $sql_array);

+

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

+

+ $delete_pms = array();

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

+ {

+ $delete_pms[] = (int) $row['msg_id'];

+ }

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

+

+ if (!empty($delete_pms))

+ {

+ $sql = 'DELETE FROM ' . PRIVMSGS_TABLE . '

+ WHERE ' . $this->db->sql_in_set('msg_id', $delete_pms);

+ $this->sql_query($sql);

+

+ // Return false to have the Migrator call this function again

+ return false;

+ }

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_data_30x_3_0_11_rc2 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return version_compare($this->config['version'], '3.0.11-rc2', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_11_rc1');

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'add_columns' => array(

+ $this->table_prefix . 'profile_fields' => array(

+ 'field_show_novalue' => array('BOOL', 0),

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'drop_columns' => array(

+ $this->table_prefix . 'profile_fields' => array(

+ 'field_show_novalue',

+ ),

+ ),

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.0.11-rc2')),

+ );

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+/** @todo DROP LOGIN_ATTEMPT_TABLE.attempt_id in 3.0.12-RC1 **/

+

+class phpbb_db_migration_data_30x_3_0_12_rc1 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return version_compare($this->config['version'], '3.0.12-rc1', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_11');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('custom', array(array(&$this, 'update_module_auth'))),

+ array('custom', array(array(&$this, 'update_bots'))),

+ array('custom', array(array(&$this, 'disable_bots_from_receiving_pms'))),

+

+ array('config.update', array('version', '3.0.12-rc1')),

+ );

+ }

+

+ public function disable_bots_from_receiving_pms()

+ {

+ // Disable receiving pms for bots

+ $sql = 'SELECT user_id

+ FROM ' . BOTS_TABLE;

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

+

+ $bot_user_ids = array();

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

+ {

+ $bot_user_ids[] = (int) $row['user_id'];

+ }

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

+

+ if (!empty($bot_user_ids))

+ {

+ $sql = 'UPDATE ' . USERS_TABLE . '

+ SET user_allow_pm = 0

+ WHERE ' . $this->db->sql_in_set('user_id', $bot_user_ids);

+ $this->sql_query($sql);

+ }

+ }

+

+ public function update_module_auth()

+ {

+ $sql = 'UPDATE ' . MODULES_TABLE . '

+ SET module_auth = \'acl_u_sig\'

+ WHERE module_class = \'ucp\'

+ AND module_basename = \'profile\'

+ AND module_mode = \'signature\'';

+ $this->sql_query($sql);

+ }

+

+ public function update_bots()

+ {

+ // Update bots

+ if (!function_exists('user_delete'))

+ {

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

+ }

+

+ $bots_updates = array(

+ // Bot Deletions

+ 'NG-Search [Bot]' => false,

+ 'Nutch/CVS [Bot]' => false,

+ 'OmniExplorer [Bot]' => false,

+ 'Seekport [Bot]' => false,

+ 'Synoo [Bot]' => false,

+ 'WiseNut [Bot]' => false,

+

+ // Bot Updates

+ // Bot name to bot user agent map

+ 'Baidu [Spider]' => 'Baiduspider',

+ 'Exabot [Bot]' => 'Exabot',

+ 'Voyager [Bot]' => 'voyager/',

+ 'W3C [Validator]' => 'W3C_Validator',

+ );

+

+ foreach ($bots_updates as $bot_name => $bot_agent)

+ {

+ $sql = 'SELECT user_id

+ FROM ' . USERS_TABLE . '

+ WHERE user_type = ' . USER_IGNORE . "

+ AND username_clean = '" . $this->db->sql_escape(utf8_clean_string($bot_name)) . "'";

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

+ $bot_user_id = (int) $this->db->sql_fetchfield('user_id');

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

+

+ if ($bot_user_id)

+ {

+ if ($bot_agent === false)

+ {

+ $sql = 'DELETE FROM ' . BOTS_TABLE . "

+ WHERE user_id = $bot_user_id";

+ $this->sql_query($sql);

+

+ user_delete('remove', $bot_user_id);

+ }

+ else

+ {

+ $sql = 'UPDATE ' . BOTS_TABLE . "

+ SET bot_agent = '" . $this->db->sql_escape($bot_agent) . "'

+ WHERE user_id = $bot_user_id";

+ $this->sql_query($sql);

+ }

+ }

+ }

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_data_30x_3_0_1_rc1 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return version_compare($this->config['version'], '3.0.1-rc1', '>=');

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'add_columns' => array(

+ $this->table_prefix . 'forums' => array(

+ 'display_subforum_list' => array('BOOL', 1),

+ ),

+ $this->table_prefix . 'sessions' => array(

+ 'session_forum_id' => array('UINT', 0),

+ ),

+ ),

+ 'drop_keys' => array(

+ $this->table_prefix . 'groups' => array(

+ 'group_legend',

+ ),

+ ),

+ 'add_index' => array(

+ $this->table_prefix . 'sessions' => array(

+ 'session_forum_id' => array('session_forum_id'),

+ ),

+ $this->table_prefix . 'groups' => array(

+ 'group_legend_name' => array('group_legend', 'group_name'),

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'drop_columns' => array(

+ $this->table_prefix . 'forums' => array(

+ 'display_subforum_list',

+ ),

+ $this->table_prefix . 'sessions' => array(

+ 'session_forum_id',

+ ),

+ ),

+ 'add_index' => array(

+ $this->table_prefix . 'groups' => array(

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

+ ),

+ ),

+ 'drop_keys' => array(

+ $this->table_prefix . 'sessions' => array(

+ 'session_forum_id',

+ ),

+ $this->table_prefix . 'groups' => array(

+ 'group_legend_name',

+ ),

+ ),

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('custom', array(array(&$this, 'fix_unset_last_view_time'))),

+ array('custom', array(array(&$this, 'reset_smiley_size'))),

+

+ array('config.update', array('version', '3.0.1-rc1')),

+ );

+ }

+

+ public function fix_unset_last_view_time()

+ {

+ $sql = 'UPDATE ' . $this->table_prefix . "topics

+ SET topic_last_view_time = topic_last_post_time

+ WHERE topic_last_view_time = 0";

+ $this->sql_query($sql);

+ }

+

+ public function reset_smiley_size()

+ {

+ // Update smiley sizes

+ $smileys = array('icon_e_surprised.gif', 'icon_eek.gif', 'icon_cool.gif', 'icon_lol.gif', 'icon_mad.gif', 'icon_razz.gif', 'icon_redface.gif', 'icon_cry.gif', 'icon_evil.gif', 'icon_twisted.gif', 'icon_rolleyes.gif', 'icon_exclaim.gif', 'icon_question.gif', 'icon_idea.gif', 'icon_arrow.gif', 'icon_neutral.gif', 'icon_mrgreen.gif', 'icon_e_ugeek.gif');

+

+ foreach ($smileys as $smiley)

+ {

+ if (file_exists($this->phpbb_root_path . 'images/smilies/' . $smiley))

+ {

+ list($width, $height) = getimagesize($this->phpbb_root_path . 'images/smilies/' . $smiley);

+

+ $sql = 'UPDATE ' . SMILIES_TABLE . '

+ SET smiley_width = ' . $width . ', smiley_height = ' . $height . "

+ WHERE smiley_url = '" . $this->db->sql_escape($smiley) . "'";

+

+ $this->sql_query($sql);

+ }

+ }

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_data_30x_3_0_2 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return version_compare($this->config['version'], '3.0.2', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_2_rc2');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.0.2')),

+ );

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_data_30x_3_0_2_rc1 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return version_compare($this->config['version'], '3.0.2-rc1', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_1');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.add', array('referer_validation', '1')),

+ array('config.add', array('check_attachment_content', '1')),

+ array('config.add', array('mime_triggers', 'body|head|html|img|plaintext|a href|pre|script|table|title')),

+

+ array('config.update', array('version', '3.0.2-rc1')),

+ );

+ }

+}

+<?php

+/**