+ $db_tools = $phpbb_container->get('dbal.tools');

+ $db_tools->sql_column_remove(PROFILE_FIELDS_DATA_TABLE, 'pf_' . $field_ident);

+ $db_tools->sql_column_add(PROFILE_FIELDS_DATA_TABLE, $field_ident, array($profile_field->get_database_column_type(), null));

+ $sql_sort = 'ORDER BY t.topic_last_post_time DESC, t.topic_last_post_id DESC';

+ * Check the form key. Required for all altering actions not secured by confirm_box

+ *

+ * @param string $form_name The name of the form; has to match the name used

+ * in add_form_key, otherwise no restrictions apply

+ * @param int $timespan The maximum acceptable age for a submitted form

+ * in seconds. Defaults to the config setting.

+ * @return bool True, if the form key was valid, false otherwise

+ */

+function check_form_key($form_name, $timespan = false)

+ global $config, $request, $user;

+ if ($request->is_set_post('creation_time') && $request->is_set_post('form_token'))

+ $creation_time = abs($request->variable('creation_time', 0));

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

+* @param array $row Row cleaned by \phpbb\avatar\manager::clean_row

+ // Category

+ $cat_row = array(

+ 'U_VIEWFORUM' => append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $row['forum_id']),

+ /**

+ * Modify the template data block of the 'category'

+ *

+ * This event is triggered once per 'category'

+ *

+ * @event core.display_forums_modify_category_template_vars

+ * @var array cat_row Template data of the 'category'

+ * @var bool catless The flag indicating whether the 'category' has a parent category

+ * @var bool last_catless The flag indicating whether the last forum had a parent category

+ * @var array root_data Array with the root forum data

+ * @var array row The data of the 'category'

+ * @since 3.1.0-RC4

+ */

+ $vars = array(

+ 'cat_row',

+ 'catless',

+ 'last_catless',

+ 'root_data',

+ 'row',

+ );

+ extract($phpbb_dispatcher->trigger_event('core.display_forums_modify_category_template_vars', compact($vars)));

+

+ $template->assign_block_vars('forumrow', $cat_row);

+

+ $sort_by_sql = array('a' => 't.topic_first_poster_name', 't' => array('t.topic_last_post_time', 't.topic_last_post_id'), 'tt' => 't.topic_time', 'r' => (($auth->acl_get('m_approve', $forum_id)) ? 't.topic_posts_approved + t.topic_posts_unapproved + t.topic_posts_softdeleted' : 't.topic_posts_approved'), 's' => 't.topic_title', 'v' => 't.topic_views');

+ $sort_by_sql = array('a' => 'u.username_clean', 't' => array('p.post_time', 'p.post_id'), 's' => 'p.post_subject');

+ $sort_by_sql = array('a' => 'u.username_clean', 'r' => 'ru.username', 'p' => array('p.post_time', 'p.post_id'), 't' => 'r.report_time', 's' => 'p.post_subject');

+ $direction = ($sort_dir == 'd') ? 'DESC' : 'ASC';

+

+ if (is_array($sort_by_sql[$sort_key]))

+ {

+ $sort_order_sql = implode(' ' . $direction . ', ', $sort_by_sql[$sort_key]) . ' ' . $direction;

+ }

+ else

+ {

+ $sort_order_sql = $sort_by_sql[$sort_key] . ' ' . $direction;

+ }

+ $sql_sort = ($mode == 'post_review') ? 'ASC' : 'DESC';

+ ORDER BY p.post_time ' . $sql_sort . ', p.post_id ' . $sql_sort;

+ ORDER BY p.post_time ASC, p.post_id ASC';

+ ORDER BY p.post_time ASC, p.post_id ASC";

+ ORDER BY post_time ASC, post_id ASC';

+ $mimetype = $this->mimetype_guesser->guess($filename, $this->uploadname);

+

+ if ($mimetype !== 'application/octet-stream')

+ {

+ $this->mimetype = $mimetype;

+ }

+ ORDER BY post_time DESC, post_id DESC';

+ ORDER BY p.post_time DESC, p.post_id DESC';

+ 'ORDER_BY' => 'p.post_time DESC, p.post_id DESC',

+ * @var string action Topic quick moderation action name

+ * @var bool quickmod Flag indicating whether MCP is in quick moderation mode

+ * @change 3.1.0-RC4 Added variables: action, quickmod

+ $vars = array('action', 'quickmod');

+ extract($phpbb_dispatcher->trigger_event('core.modify_quickmod_actions', compact($vars)));

+ ORDER BY post_time ASC, post_id ASC";

+ global $config, $phpbb_root_path, $phpEx, $action, $phpbb_container, $phpbb_dispatcher;

+

+ /**

+ * Alter sql query to get report id of all reports for requested forum and topic or just forum

+ *

+ * @event core.mcp_reports_get_reports_query_before

+ * @var string sql String with the query to be executed

+ * @var array forum_list List of forums that contain the posts

+ * @var int topic_id topic_id in the page request

+ * @var string limit_time_sql String with the SQL code to limit the time interval of the post (Note: May be empty string)

+ * @var string sort_order_sql String with the ORDER BY SQL code used in this query

+ * @since 3.1.0-RC4

+ */

+ $vars = array(

+ 'sql',

+ 'forum_list',

+ 'topic_id',

+ 'limit_time_sql',

+ 'sort_order_sql',

+ );

+ extract($phpbb_dispatcher->trigger_event('core.mcp_reports_get_reports_query_before', compact($vars)));

+

+ 'NUM_ATTACHMENTS' => $user->lang('NUM_ATTACHMENTS', $num_attachments),

+ ORDER BY t.topic_last_post_time DESC, t.topic_last_post_id DESC';

+ 'ORDER_BY' => 't.topic_last_post_time DESC, t.topic_last_post_id DESC'

+ 'ORDER_BY' => 't.topic_last_post_time DESC, t.topic_last_post_id DESC'

+ if (!check_form_key('ucp_pm_options'))

+ {

+ trigger_error('FORM_INVALID');

+ }

+

+ 'topic_st' => request_var('topic_st', (!empty($user->data['user_topic_show_days'])) ? (int) $user->data['user_topic_show_days'] : 0),

+ 'post_st' => request_var('post_st', (!empty($user->data['user_post_show_days'])) ? (int) $user->data['user_post_show_days'] : 0),

+ 'topic_sk' => array(

+ array('string', false, 1, 1),

+ array('match', false, '#(a|r|s|t|v)#'),

+ ),

+ 'topic_sd' => array(

+ array('string', false, 1, 1),

+ array('match', false, '#(a|d)#'),

+ ),

+ 'post_sk' => array(

+ array('string', false, 1, 1),

+ array('match', false, '#(a|s|t)#'),

+ ),

+ 'post_sd' => array(

+ array('string', false, 1, 1),

+ array('match', false, '#(a|d)#'),

+ ),

+ $sort_by_topic_sql = array('a' => 't.topic_first_poster_name', 't' => array('t.topic_last_post_time', 't.topic_last_post_id'), 'r' => 't.topic_posts_approved', 's' => 't.topic_title', 'v' => 't.topic_views');