+$phpbb_hook = new phpbb_hook(array('exit_handler', 'phpbb_user_session_handler', 'append_sid', array('phpbb_template', 'display')));

+

+/**

+* Main event which is triggered on every page

+*

+* You can use this event to load function files and initiate objects

+*

+* NOTE: At this point the global session ($user) and permissions ($auth)

+* do NOT exist yet. If you need to use the user object

+* (f.e. to include language files) or need to check permissions,

+* please use the core.user_setup event instead!

+*

+* @event core.common

+* @since 3.1-A1

+*/

+$phpbb_dispatcher->dispatch('core.common');

+$search = new $search_type($error, $phpbb_root_path, $phpEx, $auth, $config, $db, $user);

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

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

+$archive = $request->variable('archive', '.tar');

+if (!$config['allow_attachments'] && !$config['allow_pm_attach'])

+ trigger_error('ATTACHMENT_FUNCTIONALITY_DISABLED');

+if ($download_id)

+{

+ // Attachment id (only 1 attachment)

+ $sql_where = "attach_id = $download_id";

+}

+else if ($post_msg_id)

+{

+ // Post id or private message id (multiple attachments)

+ $sql_where = "post_msg_id = $post_msg_id AND is_orphan = 0";

+}

+else if ($topic_id)

+{

+ // Topic id (multiple attachments)

+ $sql_where = "topic_id = $topic_id AND is_orphan = 0";

+}

+else

+ trigger_error('NO_ATTACHMENT_SELECTED');

+$sql = 'SELECT attach_id, post_msg_id, topic_id, in_message, is_orphan, physical_filename, real_filename, extension, mimetype, filesize, filetime

+ WHERE $sql_where";

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

+

+$attachments = $attachment_ids = array();

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

+{

+ $attachment_id = (int) $row['attach_id'];

+

+ $row['physical_filename'] = utf8_basename($row['physical_filename']);

+

+ $attachment_ids[$attachment_id] = $attachment_id;

+ $attachments[$attachment_id] = $row;

+}

+// Make $attachment the first of the attachments we fetched.

+$attachment = current($attachments);

+

+if (empty($attachments))

+else if (!download_allowed())

+ send_status_line(403, 'Forbidden');

+ trigger_error($user->lang['LINKAGE_FORBIDDEN']);

+else if ($download_id)

+ // sizeof($attachments) == 1

+ if (!$attachment['in_message'] && !$config['allow_attachments'] || $attachment['in_message'] && !$config['allow_pm_attach'])

+ trigger_error('ATTACHMENT_FUNCTIONALITY_DISABLED');

+ if ($attachment['is_orphan'])

+ // We allow admins having attachment permissions to see orphan attachments...

+ $own_attachment = ($auth->acl_get('a_attach') || $attachment['poster_id'] == $user->data['user_id']) ? true : false;

+

+ if (!$own_attachment || ($attachment['in_message'] && !$auth->acl_get('u_pm_download')) || (!$attachment['in_message'] && !$auth->acl_get('u_download')))

+ send_status_line(404, 'Not Found');

+ trigger_error('ERROR_NO_ATTACHMENT');

+

+ // Obtain all extensions...

+ $extensions = $cache->obtain_attach_extensions(true);

+ if (!$attachment['in_message'])

+ phpbb_download_handle_forum_auth($db, $auth, $attachment['topic_id']);

+ else

+ {

+ // Attachment is in a private message.

+ $row['forum_id'] = false;

+ phpbb_download_handle_pm_auth($db, $auth, $user->data['user_id'], $attachment['post_msg_id']);

+ }

+

+ $extensions = array();

+ if (!extension_allowed($row['forum_id'], $attachment['extension'], $extensions))

+ {

+ send_status_line(404, 'Forbidden');

+ trigger_error(sprintf($user->lang['EXTENSION_DISABLED_AFTER_POSTING'], $attachment['extension']));

+ }

+ }

+

+ $download_mode = (int) $extensions[$attachment['extension']]['download_mode'];

+ $display_cat = $extensions[$attachment['extension']]['display_cat'];

+

+ if (($display_cat == ATTACHMENT_CATEGORY_IMAGE || $display_cat == ATTACHMENT_CATEGORY_THUMB) && !$user->optionget('viewimg'))

+ {

+ $display_cat = ATTACHMENT_CATEGORY_NONE;

+ }

+

+ if ($display_cat == ATTACHMENT_CATEGORY_FLASH && !$user->optionget('viewflash'))

+ {

+ $display_cat = ATTACHMENT_CATEGORY_NONE;

+ }

+ if ($thumbnail)

+ {

+ $attachment['physical_filename'] = 'thumb_' . $attachment['physical_filename'];

+ }

+ else if ($display_cat == ATTACHMENT_CATEGORY_NONE && !$attachment['is_orphan'] && !phpbb_http_byte_range($attachment['filesize']))

+ {

+ // Update download count

+ phpbb_increment_downloads($db, $attachment['attach_id']);

+ }

+ if ($display_cat == ATTACHMENT_CATEGORY_IMAGE && $mode === 'view' && (strpos($attachment['mimetype'], 'image') === 0) && ((strpos(strtolower($user->browser), 'msie') !== false) && (strpos(strtolower($user->browser), 'msie 8.0') === false)))

+ {

+ wrap_img_in_html(append_sid($phpbb_root_path . 'download/file.' . $phpEx, 'id=' . $attachment['attach_id']), $attachment['real_filename']);

+ file_gc();

+ }

+ else

+ {

+ // Determine the 'presenting'-method

+ if ($download_mode == PHYSICAL_LINK)

+ // This presenting method should no longer be used

+ if (!@is_dir($phpbb_root_path . $config['upload_path']))

+ send_status_line(500, 'Internal Server Error');

+ trigger_error($user->lang['PHYSICAL_DOWNLOAD_NOT_POSSIBLE']);

+ redirect($phpbb_root_path . $config['upload_path'] . '/' . $attachment['physical_filename']);

+ file_gc();

+ }

+ else

+ send_file_to_browser($attachment, $config['upload_path'], $display_cat);

+ file_gc();

+}

+else

+{

+ // sizeof($attachments) >= 1

+ if ($attachment['in_message'])

+ {

+ phpbb_download_handle_pm_auth($db, $auth, $user->data['user_id'], $attachment['post_msg_id']);

+ }

+ else

+ {

+ phpbb_download_handle_forum_auth($db, $auth, $attachment['topic_id']);

+ }

+ if (!class_exists('compress'))

+ require $phpbb_root_path . 'includes/functions_compress.' . $phpEx;

+ if (!in_array($archive, compress::methods()))

+ {

+ $archive = '.tar';

+ }

+ if ($post_msg_id)

+ {

+ if ($attachment['in_message'])

+ {

+ $sql = 'SELECT message_subject AS attach_subject

+ FROM ' . PRIVMSGS_TABLE . "

+ WHERE msg_id = $post_msg_id";

+ }

+ else

+ {

+ $sql = 'SELECT post_subject AS attach_subject, forum_id

+ FROM ' . POSTS_TABLE . "

+ WHERE post_id = $post_msg_id";

+ }

+ }

+ else

+ {

+ $sql = 'SELECT topic_title AS attach_subject, forum_id

+ FROM ' . TOPICS_TABLE . "

+ WHERE topic_id = $topic_id";

+ }

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

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

+ $db->sql_freeresult($result);

+ if (empty($row))

+ {

+ send_status_line(404, 'Not Found');

+ trigger_error('ERROR_NO_ATTACHMENT');

+ }

+ $clean_name = phpbb_download_clean_filename($row['attach_subject']);

+ $suffix = '_' . (($post_msg_id) ? $post_msg_id : $topic_id) . '_' . $clean_name;

+ $archive_name = 'attachments' . $suffix;

+ $store_name = 'att_' . time() . '_' . unique_id();

+ $archive_path = "{$phpbb_root_path}store/{$store_name}{$archive}";

+ if ($archive === '.zip')

+ {

+ $compress = new compress_zip('w', $archive_path);

+ }

+ else

+ {

+ $compress = new compress_tar('w', $archive_path, $archive);

+ }

+ $extensions = array();

+ $files_added = 0;

+ $forum_id = ($attachment['in_message']) ? false : (int) $row['forum_id'];

+ $disallowed = array();

+ foreach ($attachments as $attach)

+ if (!extension_allowed($forum_id, $attach['extension'], $extensions))

+ {

+ $disallowed[$attach['extension']] = $attach['extension'];

+ continue;

+ }

+

+ $prefix = '';

+ if ($topic_id)

+ $prefix = $attach['post_msg_id'] . '_';

+ $compress->add_custom_file("{$phpbb_root_path}files/{$attach['physical_filename']}", "{$prefix}{$attach['real_filename']}");

+ $files_added++;

+

+ $compress->close();

+

+ if ($files_added)

+ phpbb_increment_downloads($db, $attachment_ids);

+ $compress->download($store_name, $archive_name);

+ }

+

+ unlink($archive_path);

+

+ if (!$files_added)

+ {

+ // None of the attachments had a valid extension

+ $disallowed = implode($user->lang['COMMA_SEPARATOR'], $disallowed);

+ send_status_line(404, 'Forbidden');

+ trigger_error($user->lang('EXTENSION_DISABLED_AFTER_POSTING', $disallowed));

+

+ file_gc();

+ global $db, $user, $auth, $template, $cache, $request, $phpbb_dispatcher;

+ /**

+ * Request forum data and operate on it (parse texts, etc.)

+ *

+ * @event core.acp_manage_forums_request_data

+ * @var string action Type of the action: add|edit

+ * @var array forum_data Array with new forum data

+ * @since 3.1-A1

+ */

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

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

+

+ // Initialise $row, so we always have it in the event

+ $row = array();

+

+ /**

+ * Initialise data before we display the add/edit form

+ *

+ * @event core.acp_manage_forums_initialise_data

+ * @var string action Type of the action: add|edit

+ * @var bool update Do we display the form only

+ * or did the user press submit

+ * @var int forum_id When editing: the forum id,

+ * when creating: the parent forum id

+ * @var array row Array with current forum data

+ * empty when creating new forum

+ * @var array forum_data Array with new forum data

+ * @var string parents_list List of parent options

+ * @since 3.1-A1

+ */

+ $vars = array('action', 'update', 'forum_id', 'row', 'forum_data', 'parents_list');

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

+

+ $template_data = array(

+ );

+

+ /**

+ * Modify forum template data before we display the form

+ *

+ * @event core.acp_manage_forums_display_form

+ * @var string action Type of the action: add|edit

+ * @var bool update Do we display the form only

+ * or did the user press submit

+ * @var int forum_id When editing: the forum id,

+ * when creating: the parent forum id

+ * @var array row Array with current forum data

+ * empty when creating new forum

+ * @var array forum_data Array with new forum data

+ * @var string parents_list List of parent options

+ * @var array errors Array of errors, if you add errors

+ * ensure to update the template variables

+ * S_ERROR and ERROR_MSG to display it

+ * @var array template_data Array with new forum data

+ * @since 3.1-A1

+ */

+ $vars = array('action', 'update', 'forum_id', 'row', 'forum_data', 'parents_list', 'errors', 'template_data');

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

+

+ $template->assign_vars($template_data);

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

+ /**

+ * Validate the forum data before we create/update the forum

+ *

+ * @event core.acp_manage_forums_validate_data

+ * @var array forum_data Array with new forum data

+ * @var array errors Array of errors, should be strings and not

+ * language key.

+ * @since 3.1-A1

+ */

+ $vars = array('forum_data', 'errors');

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

+

+ /**

+ * Remove invalid values from forum_data_sql that should not be updated

+ *

+ * @event core.acp_manage_forums_update_data_before

+ * @var array forum_data Array with forum data

+ * @var array forum_data_sql Array with data we are going to update

+ * If forum_data_sql[forum_id] is set, we update

+ * that forum, otherwise a new one is created.

+ * @since 3.1-A1

+ */

+ $vars = array('forum_data', 'forum_data_sql');

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

+

+ $is_new_forum = !isset($forum_data_sql['forum_id']);

+

+ if ($is_new_forum)

+ /**

+ * Event after a forum was updated or created

+ *

+ * @event core.acp_manage_forums_update_data_after

+ * @var array forum_data Array with forum data

+ * @var array forum_data_sql Array with data we updated

+ * @var bool is_new_forum Did we create a forum or update one

+ * If you want to overwrite this value,

+ * ensure to set forum_data_sql[forum_id]

+ * @var array errors Array of errors, should be strings and not

+ * language key.

+ * @since 3.1-A1

+ */

+ $vars = array('forum_data', 'forum_data_sql', 'is_new_forum', 'errors');

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

+

+ global $db, $user, $phpbb_dispatcher;

+ /**

+ * Event when we move all children of one forum to another

+ *

+ * This event may be triggered, when a forum is deleted

+ *

+ * @event core.acp_manage_forums_move_children

+ * @var int from_id If of the current parent forum

+ * @var int to_id If of the new parent forum

+ * @var array errors Array of errors, should be strings and not

+ * language key.

+ * @since 3.1-A1

+ */

+ $vars = array('from_id', 'to_id', 'errors');

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

+

+ // Return if there were errors

+ if (!empty($errors))

+ {

+ return $errors;

+ }

+

+ global $db, $phpbb_dispatcher;

+

+ $errors = array();

+

+ /**

+ * Event when we move content from one forum to another

+ *

+ * @event core.acp_manage_forums_move_children

+ * @var int from_id If of the current parent forum

+ * @var int to_id If of the new parent forum

+ * @var bool sync Shall we sync the "to"-forum's data

+ * @var array errors Array of errors, should be strings and not

+ * language key. If this array is not empty,

+ * The content will not be moved.

+ * @since 3.1-A1

+ */

+ $vars = array('from_id', 'to_id', 'sync', 'errors');

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

+

+ // Return if there were errors

+ if (!empty($errors))

+ {

+ return $errors;

+ }

+ global $phpbb_root_path, $phpEx, $user, $auth, $config, $db;

+ $search = new $type($error, $phpbb_root_path, $phpEx, $auth, $config, $db, $user);

+ global $phpbb_dispatcher;

+

+ default:

+ /**

+ * Run custom quicktool code

+ *

+ * @event core.acp_users_overview_run_quicktool

+ * @var array user_row Current user data

+ * @var string action Quick tool that should be run

+ * @since 3.1-A1

+ */

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

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

+ break;

+ /**

+ * Modify user data before we update it

+ *

+ * @event core.acp_users_overview_modify_data

+ * @var array user_row Current user data

+ * @var array data Submitted user data

+ * @var array sql_ary User data we udpate

+ * @since 3.1-A1

+ */

+ $vars = array('user_row', 'data', 'sql_ary');

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

+

+ /**

+ * Add additional quick tool options and overwrite user data

+ *

+ * @event core.acp_users_display_overview

+ * @var array user_row Array with user data

+ * @var array quick_tool_ary Ouick tool options

+ * @since 3.1-A1

+ */

+ $vars = array('user_row', 'quick_tool_ary');

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

+

+ $s_action_options = '<option class="sep" value="">' . $user->lang['SELECT_OPTION'] . '</option>';

+ foreach ($quick_tool_ary as $value => $lang)

+ {

+ $s_action_options .= '<option value="' . $value . '">' . $user->lang['USER_ADMIN_' . $lang] . '</option>';

+ }

+

+ function sql_save($query, $query_result, $ttl)

+

+ return $query_id;

+ public function sql_save($query, $query_result, $ttl);

+ function sql_save($query, $query_result, $ttl)

+

+ return $query_id;

+ function sql_save($query, $query_result, $ttl)

+ global $phpbb_root_path, $phpEx, $config, $error, $auth, $db, $user;

+ $search = new $search_type($error, $phpbb_root_path, $phpEx, $auth, $config, $db, $user);

+ if ($cache->sql_exists($query_id))

+ if (!is_object($query_id) && $cache->sql_exists($query_id))

+ $this->query_result = $cache->sql_save($query, $this->query_result, $cache_ttl);

+ if ($cache->sql_exists($query_id))

+ if ($cache->sql_exists($query_id))

+ $this->query_result = $cache->sql_save($query, $this->query_result, $cache_ttl);

+ if ($cache->sql_exists($query_id))

+ if ($cache->sql_exists($query_id))

+ if ($cache->sql_exists($query_id))

+ $this->query_result = $cache->sql_save($query, $this->query_result, $cache_ttl);

+ if ($cache->sql_exists($query_id))

+ if ($cache->sql_exists($query_id))

+ $this->query_result = $cache->sql_save($query, $this->query_result, $cache_ttl);

+ if ($cache->sql_exists($query_id))

+ if ($cache->sql_exists($query_id))

+ $this->query_result = $cache->sql_save($query, $this->query_result, $cache_ttl);

+ if ($cache->sql_exists($query_id))

+ if ($cache->sql_exists($query_id))

+ if ($cache->sql_exists($query_id))

+ $this->query_result = $cache->sql_save($query, $this->query_result, $cache_ttl);

+ if (!is_object($query_id) && $cache->sql_exists($query_id))

+ if (!is_object($query_id) && $cache->sql_exists($query_id))

+ if (!is_object($query_id) && $cache->sql_exists($query_id))

+ $this->query_result = $cache->sql_save($query, $this->query_result, $cache_ttl);

+ if ($cache->sql_exists($query_id))

+ if ($cache->sql_exists($query_id))

+ if ($cache->sql_exists($query_id))

+ $this->query_result = $cache->sql_save($query, $this->query_result, $cache_ttl);

+ if ($cache->sql_exists($query_id))

+ if ($cache->sql_exists($query_id))

+ if ($cache->sql_exists($query_id))

+ $this->query_result = $cache->sql_save($query, $this->query_result, $cache_ttl);

+ if ($cache->sql_exists($query_id))

+ if ($cache->sql_exists($query_id))

+ if ($cache->sql_exists($query_id))

+ * Request class object

+ * @var phpbb_request

+ * DBAL class object

+ * @var dbal

+ * User class object

+ * @var phpbb_user

+ * Template class object

+ * @var phpbb_template

+ * Config object

+ * @var phpbb_config

+ * PHP Extension

+ * @var string

+ * Relative path to board root

+ * @var string

+ // A listener can set this variable to `true` when it overrides this function

+ $page_header_override = false;

+

+ /**

+ * Execute code and/or overwrite page_header()

+ *

+ * @event core.page_header

+ * @var string page_title Page title

+ * @var bool display_online_list Do we display online users list

+ * @var string item Restrict online users to a certain

+ * session item, e.g. forum for

+ * session_forum_id

+ * @var int item_id Restrict online users to item id

+ * @var bool page_header_override Shall we return instead of running

+ * the rest of page_header()

+ * @since 3.1-A1

+ */

+ $vars = array('page_title', 'display_online_list', 'item_id', 'item', 'page_header_override');

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

+

+ if ($page_header_override)

+ {

+ return;

+ }

+

+ global $request, $phpbb_dispatcher;

+

+ // A listener can set this variable to `true` when it overrides this function

+ $page_footer_override = false;

+

+ /**

+ * Execute code and/or overwrite page_footer()

+ *

+ * @event core.page_footer

+ * @var bool run_cron Shall we run cron tasks

+ * @var bool page_footer_override Shall we return instead of running

+ * the rest of page_footer()

+ * @since 3.1-A1

+ */

+ $vars = array('run_cron', 'page_footer_override');

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

+

+ if ($page_footer_override)

+ {

+ return;

+ }

+ global $phpbb_dispatcher;

+

+ /**

+ * Unload some objects, to free some memory, before we finish our task

+ *

+ * @event core.garbage_collection

+ * @since 3.1-A1

+ */

+ $phpbb_dispatcher->dispatch('core.garbage_collection');

+ global $phpbb_dispatcher;

+ // A listener can set this variable to `true` when it overrides this function

+ $adm_page_header_override = false;

+

+ /**

+ * Execute code and/or overwrite adm_page_header()

+ *

+ * @event core.adm_page_header

+ * @var string page_title Page title

+ * @var bool adm_page_header_override Shall we return instead of

+ * running the rest of adm_page_header()

+ * @since 3.1-A1

+ */

+ $vars = array('page_title', 'adm_page_header_override');

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

+

+ if ($adm_page_header_override)

+ {

+ return;

+ }

+

+ global $request, $phpbb_dispatcher;

+

+ // A listener can set this variable to `true` when it overrides this function

+ $adm_page_footer_override = false;

+

+ /**

+ * Execute code and/or overwrite adm_page_footer()

+ *

+ * @event core.adm_page_footer

+ * @var bool copyright_html Shall we display the copyright?

+ * @var bool adm_page_footer_override Shall we return instead of

+ * running the rest of adm_page_footer()

+ * @since 3.1-A1

+ */

+ $vars = array('copyright_html', 'adm_page_footer_override');

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

+

+ if ($adm_page_footer_override)

+ {

+ return;

+ }

+ global $user, $module, $phpbb_dispatcher;

+ /**

+ * Overwrite the html code we display for the config value

+ *

+ * @event core.build_config_template

+ * @var array tpl_type Config type array:

+ * 0 => data type

+ * 1 [optional] => string: size, int: minimum

+ * 2 [optional] => string: max. length, int: maximum

+ * @var string key Should be used for the id attribute in html

+ * @var array new Array with the config values we display

+ * @var string name Should be used for the name attribute

+ * @var array vars Array with the options for the config

+ * @var string tpl The resulting html code we display

+ * @since 3.1-A1

+ */

+ $vars = array('tpl_type', 'key', 'new', 'name', 'vars', 'tpl');

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

+

+ global $phpbb_root_path, $user, $phpbb_dispatcher;

+

+

+ default:

+ /**

+ * Validate a config value

+ *

+ * @event core.validate_config_variable

+ * @var array cfg_array Array with config values

+ * @var string config_name Name of the config we validate

+ * @var array config_definition Array with the options for

+ * this config

+ * @var array error Array of errors, the errors should

+ * be strings only, language keys are

+ * not replaced afterwards

+ * @since 3.1-A1

+ */

+ $vars = array('cfg_array', 'config_name', 'config_definition', 'error');

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

+ break;

+ global $db, $config, $phpbb_root_path, $phpEx, $auth, $user;

+ $search = new $search_type($error, $phpbb_root_path, $phpEx, $auth, $config, $db, $user);

+ global $request, $phpbb_dispatcher;

+ /**

+ * Event to modify the SQL query before the forum data is queried

+ *

+ * @event core.display_forums_modify_sql

+ * @var array sql_ary The SQL array to get the data of the forums

+ * @since 3.1-A1

+ */

+ $vars = array('sql_ary');

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

+

+ /**

+ * Event to modify the data set of a forum

+ *

+ * This event is triggered once per forum

+ *

+ * @event core.display_forums_modify_row

+ * @var int branch_root_id Last top-level forum

+ * @var array row The data of the forum

+ * @since 3.1-A1

+ */

+ $vars = array('branch_root_id', 'row');

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

+

+

+ /**

+ * Event to modify the forum rows data set

+ *

+ * This event is triggered once per forum

+ *

+ * @event core.display_forums_modify_forum_rows

+ * @var array forum_rows Data array of all forums we display

+ * @var array subforums Data array of all subforums we display

+ * @var int branch_root_id Current top-level forum

+ * @var int parent_id Current parent forum

+ * @var array row The data of the forum

+ * @since 3.1-A1

+ */

+ $vars = array('forum_rows', 'subforums', 'branch_root_id', 'parent_id', 'row');

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

+ $forum_row = array(

+ 'U_LAST_POST' => $last_post_url,

+ /**

+ * Modify the template data block of the forum

+ *

+ * This event is triggered once per forum

+ *

+ * @event core.display_forums_modify_template_vars

+ * @var array forum_row Template data of the forum

+ * @var array row The data of the forum

+ * @since 3.1-A1

+ */

+ $vars = array('forum_row', 'row');

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

+

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

+

+ global $db, $template, $user, $phpbb_dispatcher;

+ $custom_tags = array(

+ );

+

+ /**

+ * Modify the template data block of a bbcode

+ *

+ * This event is triggered once per bbcode

+ *

+ * @event core.display_custom_bbcodes_modify_row

+ * @var array custom_tags Template data of the bbcode

+ * @var array row The data of the bbcode

+ * @since 3.1-A1

+ */

+ $vars = array('custom_tags', 'row');

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

+

+ $template->assign_block_vars('custom_tags', $custom_tags);

+

+ /**

+ * Display custom bbcodes

+ *

+ * @event core.display_custom_bbcodes

+ * @since 3.1-A1

+ */

+ $phpbb_dispatcher->dispatch('core.display_custom_bbcodes');

+ global $phpbb_dispatcher;

+

+ $overwrite_avatar = '';

+

+ /**

+ * Overwrite users avatar

+ *

+ * @event core.display_custom_bbcodes_modify_row

+ * @var string avatar Users assigned avatar name

+ * @var int avatar_type Type of avatar

+ * @var string avatar_width Width of users avatar

+ * @var string avatar_height Height of users avatar

+ * @var string alt Language string for alt tag within image

+ * Can be a language key or text

+ * @var bool ignore_config Ignores config and force displaying avatar

+ * @var string overwrite_avatar If set, this string will be the avatar

+ * @since 3.1-A1

+ */

+ $vars = array('avatar', 'avatar_type', 'avatar_width', 'avatar_height', 'alt', 'ignore_config', 'overwrite_avatar');

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

+

+ if ($overwrite_avatar)

+ {

+ return $overwrite_avatar;

+ }

+

+/**

+* Generate a list of archive types available for compressing attachments

+*

+* @param string $param_key Either topic_id or post_id

+* @param string $param_val The value of the topic or post id

+* @param string $phpbb_root_path The root path of the phpBB installation

+* @param string $phpEx The PHP extension

+*

+* @return array Array containing the link and the type of compression

+*/

+function phpbb_gen_download_links($param_key, $param_val, $phpbb_root_path, $phpEx)

+{

+ if (!class_exists('compress'))

+ {

+ require $phpbb_root_path . 'includes/functions_compress.' . $phpEx;

+ }

+

+ $methods = compress::methods();

+ $links = array();

+

+ foreach ($methods as $method)

+ {

+ $type = array_pop(explode('.', $method));

+ $params = array('archive' => $method);

+ $params[$param_key] = $param_val;

+

+ $links[] = array(

+ 'LINK' => append_sid("{$phpbb_root_path}download/file.$phpEx", $params),

+ 'TYPE' => $type,

+ );

+ }

+

+ return $links;

+}

+

+/**

+* Increments the download count of all provided attachments

+*

+* @param dbal $db The database object

+* @param array|int $ids The attach_id of each attachment

+*

+* @return null

+*/

+function phpbb_increment_downloads($db, $ids)

+{

+ if (!is_array($ids))

+ {

+ $ids = array($ids);

+ }

+

+ $sql = 'UPDATE ' . ATTACHMENTS_TABLE . '

+ SET download_count = download_count + 1

+ WHERE ' . $db->sql_in_set('attach_id', $ids);

+ $db->sql_query($sql);

+}

+

+/**

+* Handles authentication when downloading attachments from a post or topic

+*

+* @param dbal $db The database object

+* @param phpbb_auth $auth The authentication object

+* @param int $topic_id The id of the topic that we are downloading from

+*

+* @return null

+*/

+function phpbb_download_handle_forum_auth($db, $auth, $topic_id)

+{

+ $sql = 'SELECT t.forum_id, f.forum_password, f.parent_id

+ FROM ' . TOPICS_TABLE . ' t, ' . FORUMS_TABLE . " f

+ WHERE t.topic_id = " . (int) $topic_id . "

+ AND t.forum_id = f.forum_id";

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

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

+ $db->sql_freeresult($result);

+

+ if ($auth->acl_get('u_download') && $auth->acl_get('f_download', $row['forum_id']))

+ {

+ if ($row && $row['forum_password'])

+ {

+ // Do something else ... ?

+ login_forum_box($row);

+ }

+ }

+ else

+ {

+ send_status_line(403, 'Forbidden');

+ trigger_error('SORRY_AUTH_VIEW_ATTACH');

+ }

+}

+

+/**

+* Handles authentication when downloading attachments from PMs

+*

+* @param dbal $db The database object

+* @param phpbb_auth $auth The authentication object

+* @param int $user_id The user id

+* @param int $msg_id The id of the PM that we are downloading from

+*

+* @return null

+*/

+function phpbb_download_handle_pm_auth($db, $auth, $user_id, $msg_id)

+{

+ if (!$auth->acl_get('u_pm_download'))

+ {

+ send_status_line(403, 'Forbidden');

+ trigger_error('SORRY_AUTH_VIEW_ATTACH');

+ }

+

+ $allowed = phpbb_download_check_pm_auth($db, $user_id, $msg_id);

+

+ if (!$allowed)

+ {

+ send_status_line(403, 'Forbidden');

+ trigger_error('ERROR_NO_ATTACHMENT');

+ }

+}

+

+/**

+* Checks whether a user can download from a particular PM

+*

+* @param dbal $db The database object

+* @param int $user_id The user id

+* @param int $msg_id The id of the PM that we are downloading from

+*

+* @return bool Whether the user is allowed to download from that PM or not

+*/

+function phpbb_download_check_pm_auth($db, $user_id, $msg_id)

+{

+ // Check if the attachment is within the users scope...

+ $sql = 'SELECT msg_id

+ FROM ' . PRIVMSGS_TO_TABLE . '

+ WHERE msg_id = ' . (int) $msg_id . '

+ AND (

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

+ OR author_id = ' . (int) $user_id . '

+ )';

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

+ $allowed = (bool) $db->sql_fetchfield('msg_id');

+ $db->sql_freeresult($result);

+

+ return $allowed;

+}

+

+/**

+* Cleans a filename of any characters that could potentially cause a problem on

+* a user's filesystem.

+*

+* @param string $filename The filename to clean

+*

+* @return string The cleaned filename

+*/

+function phpbb_download_clean_filename($filename)

+{

+ $bad_chars = array("'", "\\", ' ', '/', ':', '*', '?', '"', '<', '>', '|');

+

+ // rawurlencode to convert any potentially 'bad' characters that we missed

+ $filename = rawurlencode(str_replace($bad_chars, '_', $filename));

+

+ // Turn the %xx entities created by rawurlencode to _

+ $filename = preg_replace("/%(\w{2})/", '_', $filename);

+

+ return $filename;

+}

+ global $db, $user, $config, $template, $phpbb_dispatcher;

+ /**

+ * This event is called after the smilies are populated

+ *

+ * @event core.generate_smilies_after

+ * @var string mode Mode of the smilies: window|inline

+ * @var int forum_id The forum ID we are currently in

+ * @var bool display_link Shall we display the "more smilies" link?

+ * @since 3.1-A1

+ */

+ $vars = array('mode', 'forum_id', 'display_link');

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

+

+ $search = new $search_type($error, $phpbb_root_path, $phpEx, $auth, $config, $db, $user);

+ global $config, $db, $cache, $phpbb_dispatcher;

+ /**

+ * Update a username when it is changed

+ *

+ * @event core.update_username

+ * @var string old_name The old username that is replaced

+ * @var string new_name The new username

+ * @since 3.1-A1

+ */

+ $vars = array('old_name', 'new_name');

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

+

+ global $cache, $config, $db, $user, $auth, $phpbb_dispatcher;

+ /**

+ * Event before a user is deleted

+ *

+ * @event core.delete_user_before

+ * @var string mode Mode of deletion (retain/delete posts)

+ * @var int user_id ID of the deleted user

+ * @var mixed post_username Guest username that is being used or false

+ * @since 3.1-A1

+ */

+ $vars = array('mode', 'user_id', 'post_username');

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

+

+ /**

+ * Event after a user is deleted

+ *

+ * @event core.delete_user_after

+ * @var string mode Mode of deletion (retain/delete posts)

+ * @var int user_id ID of the deleted user

+ * @var mixed post_username Guest username that is being used or false

+ * @since 3.1-A1

+ */

+ $vars = array('mode', 'user_id', 'post_username');

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

+

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

+ /**

+ * Event after a group is deleted

+ *

+ * @event core.delete_group_after

+ * @var int group_id ID of the deleted group

+ * @var string group_name Name of the deleted group

+ * @since 3.1-A1

+ */

+ $vars = array('group_id', 'group_name');

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

+

+ global $db, $auth, $config, $phpbb_dispatcher;

+ /**

+ * Event before users are removed from a group

+ *

+ * @event core.group_delete_user_before

+ * @var int group_id ID of the group from which users are deleted

+ * @var string group_name Name of the group

+ * @var array user_id_ary IDs of the users which are removed

+ * @var array username_ary names of the users which are removed

+ * @since 3.1-A1

+ */

+ $vars = array('group_id', 'group_name', 'user_id_ary', 'username_ary');

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

+

+ global $cache, $db, $phpbb_dispatcher;

+ /**

+ * Event when the default group is set for an array of users

+ *

+ * @event core.user_set_default_group

+ * @var int group_id ID of the group

+ * @var array user_id_ary IDs of the users

+ * @var array group_attributes Group attributes which were changed

+ * @var array update_listing Update the list of moderators and foes

+ * @var array sql_ary User attributes which were changed

+ * @since 3.1-A1

+ */

+ $vars = array('group_id', 'user_id_ary', 'group_attributes', 'update_listing', 'sql_ary');

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

+

+ global $request, $phpbb_dispatcher;

+ /**

+ * Modify the topic data before it is assigned to the template in MCP

+ *

+ * @event core.mcp_view_forum_modify_topicrow

+ * @var array row Array with topic data

+ * @var array topic_row Template array with topic data

+ * @since 3.1-A1

+ */

+ $vars = array('row', 'topic_row');

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

+

+ $search = new $search_type($error, $phpbb_root_path, $phpEx, $auth, $config, $db, $user);

+ global $auth, $db, $config, $phpbb_root_path, $phpEx, $user;

+ $search = new $search_type($error, $phpbb_root_path, $phpEx, $auth, $config, $db, $user);

+ protected $stats = array();

+ protected $split_words = array();

+ protected $config;

+ protected $db;

+ protected $user;

+ public $word_length = array();

+ public $search_query;

+ public $common_words = array();

+ /**

+ * Constructor

+ * Creates a new phpbb_search_fulltext_mysql, which is used as a search backend.

+ *

+ * @param string|bool $error Any error that occurs is passed on through this reference variable otherwise false

+ */

+ public function __construct(&$error, $phpbb_root_path, $phpEx, $auth, $config, $db, $user)

+ $this->config = $config;

+ $this->db = $db;

+ $this->user = $user;

+ $this->word_length = array('min' => $this->config['fulltext_mysql_min_word_len'], 'max' => $this->config['fulltext_mysql_max_word_len']);

+ *

+ * @return string|bool Language key of the error/incompatiblity occured

+ public function init()

+ if ($this->db->sql_layer != 'mysql4' && $this->db->sql_layer != 'mysqli')

+ return $this->user->lang['FULLTEXT_MYSQL_INCOMPATIBLE_DATABASE'];

+ $result = $this->db->sql_query('SHOW TABLE STATUS LIKE \'' . POSTS_TABLE . '\'');

+ $info = $this->db->sql_fetchrow($result);

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

+ return $this->user->lang['FULLTEXT_MYSQL_NOT_MYISAM'];

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

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

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

+ public function split_keywords(&$keywords, $terms)

+ if ($this->config['max_num_search_keywords'] && sizeof($this->split_words) > $this->config['max_num_search_keywords'])

+ trigger_error($this->user->lang('MAX_NUM_SEARCH_KEYWORDS_REFINE', $this->config['max_num_search_keywords'], sizeof($this->split_words)));

+ if (($clean_len < $this->config['fulltext_mysql_min_word_len']) || ($clean_len > $this->config['fulltext_mysql_max_word_len']))

+ * @param string $text contains post text/subject

+ public function split_message($text)

+ if (utf8_strlen($text[$i]) < $this->config['fulltext_mysql_min_word_len'] || utf8_strlen($text[$i]) > $this->config['fulltext_mysql_max_word_len'])

+ public function keyword_search($type, $fields, $terms, $sort_by_sql, $sort_key, $sort_dir, $sort_days, $ex_fid_ary, $m_approve_fid_ary, $topic_id, $author_ary, $author_name, &$id_ary, $start, $per_page)

+ $m_approve_fid_sql = ' AND (p.post_approved = 1 OR ' . $this->db->sql_in_set('p.forum_id', $m_approve_fid_ary, true) . ')';

+ $sql_author = ' AND (' . $this->db->sql_in_set('p.poster_id', array_diff($author_ary, array(ANONYMOUS)), false, true) . ' OR p.post_username ' . $author_name . ')';

+ $sql_author = ' AND ' . $this->db->sql_in_set('p.poster_id', $author_ary);

+ $sql_where_options .= (sizeof($ex_fid_ary)) ? ' AND ' . $this->db->sql_in_set('p.forum_id', $ex_fid_ary, true) : '';

+ WHERE MATCH ($sql_match) AGAINST ('" . $this->db->sql_escape(htmlspecialchars_decode($this->search_query)) . "' IN BOOLEAN MODE)

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

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

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

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

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

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

+ public function author_search($type, $firstpost_only, $sort_by_sql, $sort_key, $sort_dir, $sort_days, $ex_fid_ary, $m_approve_fid_ary, $topic_id, $author_ary, $author_name, &$id_ary, $start, $per_page)

+ $sql_author = '(' . $this->db->sql_in_set('p.poster_id', array_diff($author_ary, array(ANONYMOUS)), false, true) . ' OR p.post_username ' . $author_name . ')';

+ $sql_author = $this->db->sql_in_set('p.poster_id', $author_ary);

+ $sql_fora = (sizeof($ex_fid_ary)) ? ' AND ' . $this->db->sql_in_set('p.forum_id', $ex_fid_ary, true) : '';

+ $m_approve_fid_sql = ' AND (p.post_approved = 1 OR ' . $this->db->sql_in_set('p.forum_id', $m_approve_fid_ary, true) . ')';

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

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

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

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

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

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

+ * @param string $mode contains the post mode: edit, post, reply, quote ...

+ * @param int $post_id contains the post id of the post to index

+ * @param string $message contains the post text of the post

+ * @param string $subject contains the subject of the post to index

+ * @param int $poster_id contains the user id of the poster

+ * @param int $forum_id contains the forum id of parent forum of the post

+ public function index($mode, $post_id, &$message, &$subject, $poster_id, $forum_id)

+ public function index_remove($post_ids, $author_ids, $forum_ids)

+ public function tidy()

+ *

+ * @return string|bool error string is returned incase of errors otherwise false

+ public function create_index($acp_module, $u_action)

+ if ($this->db->sql_layer == 'mysqli' || version_compare($this->db->sql_server_info(true), '4.1.3', '>='))

+ if ($this->db->sql_layer == 'mysqli' || version_compare($this->db->sql_server_info(true), '4.1.3', '>='))

+ $this->db->sql_query('ALTER TABLE ' . POSTS_TABLE . ' ' . implode(', ', $alter));

+ $this->db->sql_query('TRUNCATE TABLE ' . SEARCH_RESULTS_TABLE);

+ *

+ * @return string|bool error string is returned incase of errors otherwise false

+ public function delete_index($acp_module, $u_action)

+ $this->db->sql_query('ALTER TABLE ' . POSTS_TABLE . ' ' . implode(', ', $alter));

+ $this->db->sql_query('TRUNCATE TABLE ' . SEARCH_RESULTS_TABLE);

+ public function index_created()

+ public function index_stats()

+ $this->user->lang['FULLTEXT_MYSQL_TOTAL_POSTS'] => ($this->index_created()) ? $this->stats['total_posts'] : 0,

+ /**

+ * Computes the stats and store them in the $this->stats associative array

+ */

+ protected function get_stats()

+ if (strpos($this->db->sql_layer, 'mysql') === false)

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

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

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

+ $this->stats['total_posts'] = empty($this->stats) ? 0 : $this->db->get_estimated_row_count(POSTS_TABLE);

+ *

+ * @return associative array containing template and config variables

+ public function acp()

+ <dt><label>' . $this->user->lang['MIN_SEARCH_CHARS'] . ':</label><br /><span>' . $this->user->lang['FULLTEXT_MYSQL_MIN_SEARCH_CHARS_EXPLAIN'] . '</span></dt>

+ <dd>' . $this->config['fulltext_mysql_min_word_len'] . '</dd>

+ <dt><label>' . $this->user->lang['MAX_SEARCH_CHARS'] . ':</label><br /><span>' . $this->user->lang['FULLTEXT_MYSQL_MAX_SEARCH_CHARS_EXPLAIN'] . '</span></dt>

+ <dd>' . $this->config['fulltext_mysql_max_word_len'] . '</dd>

+ protected $stats = array();

+ public $word_length = array();

+ public $search_query;

+ public $common_words = array();

+ protected $must_contain_ids = array();

+ protected $must_not_contain_ids = array();

+ protected $must_exclude_one_ids = array();

+

+ protected $phpbb_root_path;

+ protected $php_ext;

+ protected $config;

+ protected $db;

+ protected $user;

+ public function __construct(&$error, $phpbb_root_path, $phpEx, $auth, $config, $db, $user)

+ $this->phpbb_root_path = $phpbb_root_path;

+ $this->php_ext = $phpEx;

+ $this->config = $config;

+ $this->db = $db;

+ $this->user = $user;

+ $this->word_length = array('min' => $this->config['fulltext_native_min_chars'], 'max' => $this->config['fulltext_native_max_chars']);

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

+ public function split_keywords($keywords, $terms)

+ if ($this->config['max_num_search_keywords'] && $num_keywords > $this->config['max_num_search_keywords'])

+ trigger_error($this->user->lang('MAX_NUM_SEARCH_KEYWORDS_REFINE', $this->config['max_num_search_keywords'], $num_keywords));

+ WHERE ' . $this->db->sql_in_set('word_text', $exact_words) . '

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

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

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

+ $id_words[] = '\'' . $this->db->sql_escape(str_replace('*', '%', $word_part)) . '\'';

+ $this->{$mode . '_ids'}[] = '\'' . $this->db->sql_escape(str_replace('*', '%', $word)) . '\'';

+ trigger_error(sprintf($this->user->lang['WORD_IN_NO_POST'], $word));

+ public function keyword_search($type, $fields, $terms, $sort_by_sql, $sort_key, $sort_dir, $sort_days, $ex_fid_ary, $m_approve_fid_ary, $topic_id, $author_ary, $author_name, &$id_ary, $start, $per_page)

+ $sql_where[] = $this->db->sql_in_set("m$m_num.word_id", $word_ids);

+ 'ON' => $this->db->sql_in_set("m$m_num.word_id", $this->must_not_contain_ids) . (($title_match) ? " AND m$m_num.$title_match" : '') . " AND m$m_num.post_id = m0.post_id"

+ $sql_where[] = '(p.post_approved = 1 OR ' . $this->db->sql_in_set('p.forum_id', $m_approve_fid_ary, true) . ')';

+ $sql_author = '(' . $this->db->sql_in_set('p.poster_id', array_diff($author_ary, array(ANONYMOUS)), false, true) . ' OR p.post_username ' . $author_name . ')';

+ $sql_author = $this->db->sql_in_set('p.poster_id', $author_ary);

+ $sql_where[] = $this->db->sql_in_set('p.forum_id', $ex_fid_ary, true);

+ switch ($this->db->sql_layer)

+ FROM (' . $this->db->sql_build_query('SELECT', $sql_array_count) . ')';

+ $sql = (!$sql) ? $this->db->sql_build_query('SELECT', $sql_array_count) : $sql;

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

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

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

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

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

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

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

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

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

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

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

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

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

+ public function author_search($type, $firstpost_only, $sort_by_sql, $sort_key, $sort_dir, $sort_days, $ex_fid_ary, $m_approve_fid_ary, $topic_id, $author_ary, $author_name, &$id_ary, $start, $per_page)

+ $sql_author = '(' . $this->db->sql_in_set('p.poster_id', array_diff($author_ary, array(ANONYMOUS)), false, true) . ' OR p.post_username ' . $author_name . ')';

+ $sql_author = $this->db->sql_in_set('p.poster_id', $author_ary);

+ $sql_fora = (sizeof($ex_fid_ary)) ? ' AND ' . $this->db->sql_in_set('p.forum_id', $ex_fid_ary, true) : '';

+ $m_approve_fid_sql = ' AND (p.post_approved = 1 OR ' . $this->db->sql_in_set('p.forum_id', $m_approve_fid_ary, true) . ')';

+ switch ($this->db->sql_layer)

+ if ($this->db->sql_layer == 'sqlite')

+ $sql_time" . (($this->db->sql_layer == 'sqlite') ? ')' : '');

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

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

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

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

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

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

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

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

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

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

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

+ public function split_message($text)

+ public function index($mode, $post_id, &$message, &$subject, $poster_id, $forum_id)

+ if (!$this->config['fulltext_native_load_upd'])

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

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

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

+ WHERE ' . $this->db->sql_in_set('word_text', $unique_add_words);

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

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

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

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

+ $this->db->sql_return_on_error(true);

+ $this->db->sql_multi_insert(SEARCH_WORDLIST_TABLE, $sql_ary);

+ $this->db->sql_return_on_error(false);

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

+ WHERE ' . $this->db->sql_in_set('word_id', $sql_in) . '

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

+ WHERE ' . $this->db->sql_in_set('word_id', $sql_in) . '

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

+ $this->db->sql_return_on_error(true);

+ WHERE ' . $this->db->sql_in_set('word_text', $word_ary);

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

+ WHERE ' . $this->db->sql_in_set('word_text', $word_ary);

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

+ $this->db->sql_return_on_error(false);

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

+ public function index_remove($post_ids, $author_ids, $forum_ids)

+ WHERE ' . $this->db->sql_in_set('m.post_id', $post_ids) . '

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

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

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

+ WHERE ' . $this->db->sql_in_set('word_id', $title_word_ids) . '

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

+ WHERE ' . $this->db->sql_in_set('word_id', $message_word_ids) . '

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

+ WHERE ' . $this->db->sql_in_set('post_id', $post_ids);

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

+ public function tidy()

+ if (!$this->config['fulltext_native_load_upd'])

+ if ($this->config['num_posts'] >= 100 && $this->config['fulltext_native_common_thres'])

+ $common_threshold = ((double) $this->config['fulltext_native_common_thres']) / 100.0;

+ WHERE word_count > ' . floor($this->config['num_posts'] * $common_threshold) . '

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

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

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

+ WHERE ' . $this->db->sql_in_set('word_id', $sql_in);

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

+ WHERE ' . $this->db->sql_in_set('word_id', $sql_in);

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

+ public function delete_index($acp_module, $u_action)

+ switch ($this->db->sql_layer)

+ $this->db->sql_query('DELETE FROM ' . SEARCH_WORDLIST_TABLE);

+ $this->db->sql_query('DELETE FROM ' . SEARCH_WORDMATCH_TABLE);

+ $this->db->sql_query('DELETE FROM ' . SEARCH_RESULTS_TABLE);

+ $this->db->sql_query('TRUNCATE TABLE ' . SEARCH_WORDLIST_TABLE);

+ $this->db->sql_query('TRUNCATE TABLE ' . SEARCH_WORDMATCH_TABLE);

+ $this->db->sql_query('TRUNCATE TABLE ' . SEARCH_RESULTS_TABLE);

+ public function index_created()

+ public function index_stats()

+ $this->user->lang['TOTAL_WORDS'] => $this->stats['total_words'],

+ $this->user->lang['TOTAL_MATCHES'] => $this->stats['total_matches']);

+ protected function get_stats()

+ $this->stats['total_words'] = $this->db->get_estimated_row_count(SEARCH_WORDLIST_TABLE);

+ $this->stats['total_matches'] = $this->db->get_estimated_row_count(SEARCH_WORDMATCH_TABLE);

+ protected function cleanup($text, $allowed_chars = null, $encoding = 'utf-8')

+ $file = $this->phpbb_root_path . 'includes/utf/data/search_indexer_' . $idx . '.' . $this->php_ext;

+ public function acp()

+ <dt><label for="fulltext_native_load_upd">' . $this->user->lang['YES_SEARCH_UPDATE'] . ':</label><br /><span>' . $this->user->lang['YES_SEARCH_UPDATE_EXPLAIN'] . '</span></dt>

+ <dd><label><input type="radio" id="fulltext_native_load_upd" name="config[fulltext_native_load_upd]" value="1"' . (($this->config['fulltext_native_load_upd']) ? ' checked="checked"' : '') . ' class="radio" /> ' . $this->user->lang['YES'] . '</label><label><input type="radio" name="config[fulltext_native_load_upd]" value="0"' . ((!$this->config['fulltext_native_load_upd']) ? ' checked="checked"' : '') . ' class="radio" /> ' . $this->user->lang['NO'] . '</label></dd>

+ <dt><label for="fulltext_native_min_chars">' . $this->user->lang['MIN_SEARCH_CHARS'] . ':</label><br /><span>' . $this->user->lang['MIN_SEARCH_CHARS_EXPLAIN'] . '</span></dt>

+ <dd><input id="fulltext_native_min_chars" type="text" size="3" maxlength="3" name="config[fulltext_native_min_chars]" value="' . (int) $this->config['fulltext_native_min_chars'] . '" /></dd>

+ <dt><label for="fulltext_native_max_chars">' . $this->user->lang['MAX_SEARCH_CHARS'] . ':</label><br /><span>' . $this->user->lang['MAX_SEARCH_CHARS_EXPLAIN'] . '</span></dt>

+ <dd><input id="fulltext_native_max_chars" type="text" size="3" maxlength="3" name="config[fulltext_native_max_chars]" value="' . (int) $this->config['fulltext_native_max_chars'] . '" /></dd>

+ <dt><label for="fulltext_native_common_thres">' . $this->user->lang['COMMON_WORD_THRESHOLD'] . ':</label><br /><span>' . $this->user->lang['COMMON_WORD_THRESHOLD_EXPLAIN'] . '</span></dt>

+ <dd><input id="fulltext_native_common_thres" type="text" size="3" maxlength="3" name="config[fulltext_native_common_thres]" value="' . (double) $this->config['fulltext_native_common_thres'] . '" /> %</dd>

+ protected $stats = array();

+ protected $split_words = array();

+ protected $tsearch_usable = false;

+ protected $version;

+ protected $tsearch_query;

+ protected $phrase_search = false;

+ protected $config;

+ protected $db;

+ protected $user;

+ public function __construct(&$error, $phpbb_root_path, $phpEx, $auth, $config, $db, $user)

+ $this->config = $config;

+ $this->db = $db;

+ $this->user = $user;

+ $this->word_length = array('min' => $this->config['fulltext_postgres_min_word_len'], 'max' => $this->config['fulltext_postgres_max_word_len']);

+ if ($this->db->sql_layer == 'postgres')

+ $pgsql_version = explode(',', substr($this->db->sql_server_info(), 10));

+ public function init()

+ if ($this->db->sql_layer != 'postgres')

+ return $this->user->lang['FULLTEXT_POSTGRES_INCOMPATIBLE_DATABASE'];

+ return $this->user->lang['FULLTEXT_POSTGRES_TS_NOT_USABLE'];

+ public function split_keywords(&$keywords, $terms)

+ if (($clean_len < $this->config['fulltext_postgres_min_word_len']) || ($clean_len > $this->config['fulltext_postgres_max_word_len']))

+ public function split_message($text)

+ if (utf8_strlen($text[$i]) < $this->config['fulltext_postgres_min_word_len'] || utf8_strlen($text[$i]) > $this->config['fulltext_postgres_max_word_len'])

+ public function keyword_search($type, $fields, $terms, $sort_by_sql, $sort_key, $sort_dir, $sort_days, $ex_fid_ary, $m_approve_fid_ary, $topic_id, $author_ary, $author_name, &$id_ary, $start, $per_page)

+ $m_approve_fid_sql = ' AND (p.post_approved = 1 OR ' . $this->db->sql_in_set('p.forum_id', $m_approve_fid_ary, true) . ')';

+ $sql_author = '(' . $this->db->sql_in_set('p.poster_id', array_diff($author_ary, array(ANONYMOUS)), false, true) . ' OR p.post_username ' . $author_name . ')';

+ $sql_author = ' AND ' . $this->db->sql_in_set('p.poster_id', $author_ary);

+ $sql_where_options .= (sizeof($ex_fid_ary)) ? ' AND ' . $this->db->sql_in_set('p.forum_id', $ex_fid_ary, true) : '';

+ $tmp_sql_match[] = "to_tsvector ('" . $this->db->sql_escape($this->config['fulltext_postgres_ts_name']) . "', " . $sql_match_column . ") @@ to_tsquery ('" . $this->db->sql_escape($this->config['fulltext_postgres_ts_name']) . "', '" . $this->db->sql_escape($this->tsearch_query) . "')";

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

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

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

+ public function author_search($type, $firstpost_only, $sort_by_sql, $sort_key, $sort_dir, $sort_days, $ex_fid_ary, $m_approve_fid_ary, $topic_id, $author_ary, $author_name, &$id_ary, $start, $per_page)

+ $sql_author = '(' . $this->db->sql_in_set('p.poster_id', array_diff($author_ary, array(ANONYMOUS)), false, true) . ' OR p.post_username ' . $author_name . ')';

+ $sql_author = $this->db->sql_in_set('p.poster_id', $author_ary);

+ $sql_fora = (sizeof($ex_fid_ary)) ? ' AND ' . $this->db->sql_in_set('p.forum_id', $ex_fid_ary, true) : '';

+ $m_approve_fid_sql = ' AND (p.post_approved = 1 OR ' . $this->db->sql_in_set('p.forum_id', $m_approve_fid_ary, true) . ')';

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

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

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

+ public function index($mode, $post_id, &$message, &$subject, $poster_id, $forum_id)

+ public function index_remove($post_ids, $author_ids, $forum_ids)

+ public function tidy()

+ public function create_index($acp_module, $u_action)

+ $this->db->sql_query("CREATE INDEX " . POSTS_TABLE . "_" . $this->config['fulltext_postgres_ts_name'] . "_post_subject ON " . POSTS_TABLE . " USING gin (to_tsvector ('" . $this->db->sql_escape($this->config['fulltext_postgres_ts_name']) . "', post_subject))");

+ $this->db->sql_query("CREATE INDEX " . POSTS_TABLE . "_" . $this->config['fulltext_postgres_ts_name'] . "_post_text ON " . POSTS_TABLE . " USING gin (to_tsvector ('" . $this->db->sql_escape($this->config['fulltext_postgres_ts_name']) . "', post_text))");

+ $this->db->sql_query('TRUNCATE TABLE ' . SEARCH_RESULTS_TABLE);

+ public function delete_index($acp_module, $u_action)

+ $this->db->sql_query('DROP INDEX ' . $this->stats['post_subject']['relname']);

+ $this->db->sql_query('DROP INDEX ' . $this->stats['post_text']['relname']);

+ $this->db->sql_query('TRUNCATE TABLE ' . SEARCH_RESULTS_TABLE);

+ public function index_created()

+ public function index_stats()

+ $this->user->lang['FULLTEXT_POSTGRES_TOTAL_POSTS'] => ($this->index_created()) ? $this->stats['total_posts'] : 0,

+ protected function get_stats()

+ if ($this->db->sql_layer != 'postgres')

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

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

+ if ($row['relname'] == POSTS_TABLE . '_' . $this->config['fulltext_postgres_ts_name'] . '_post_text' || $row['relname'] == POSTS_TABLE . '_post_text')

+ else if ($row['relname'] == POSTS_TABLE . '_' . $this->config['fulltext_postgres_ts_name'] . '_post_subject' || $row['relname'] == POSTS_TABLE . '_post_subject')

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

+ $this->stats['total_posts'] = $this->config['num_posts'];

+ public function acp()

+ <dt><label>' . $this->user->lang['FULLTEXT_POSTGRES_VERSION_CHECK'] . '</label><br /><span>' . $this->user->lang['FULLTEXT_POSTGRES_VERSION_CHECK_EXPLAIN'] . '</span></dt>

+ <dd>' . (($this->tsearch_usable) ? $this->user->lang['YES'] : $this->user->lang['NO']) . ' (PostgreSQL ' . $this->version . ')</dd>

+ <dt><label>' . $this->user->lang['FULLTEXT_POSTGRES_TS_NAME'] . '</label><br /><span>' . $this->user->lang['FULLTEXT_POSTGRES_TS_NAME_EXPLAIN'] . '</span></dt>

+ if ($this->db->sql_layer == 'postgres' && $this->tsearch_usable)

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

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

+ $tpl .= '<option value="' . $row['ts_name'] . '"' . ($row['ts_name'] === $this->config['fulltext_postgres_ts_name'] ? ' selected="selected"' : '') . '>' . $row['ts_name'] . '</option>';

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

+ $tpl .= '<option value="' . $this->config['fulltext_postgres_ts_name'] . '" selected="selected">' . $this->config['fulltext_postgres_ts_name'] . '</option>';

+ <dt><label for="fulltext_postgres_min_word_len">' . $this->user->lang['FULLTEXT_POSTGRES_MIN_WORD_LEN'] . ':</label><br /><span>' . $this->user->lang['FULLTEXT_POSTGRES_MIN_WORD_LEN_EXPLAIN'] . '</span></dt>

+ <dd><input id="fulltext_postgres_min_word_len" type="text" size="3" maxlength="3" name="config[fulltext_postgres_min_word_len]" value="' . (int) $this->config['fulltext_postgres_min_word_len'] . '" /></dd>

+ <dt><label for="fulltext_postgres_max_word_len">' . $this->user->lang['FULLTEXT_POSTGRES_MAX_WORD_LEN'] . ':</label><br /><span>' . $this->user->lang['FULLTEXT_POSTGRES_MAX_WORD_LEN_EXPLAIN'] . '</span></dt>

+ <dd><input id="fulltext_postgres_max_word_len" type="text" size="3" maxlength="3" name="config[fulltext_postgres_max_word_len]" value="' . (int) $this->config['fulltext_postgres_max_word_len'] . '" /></dd>

+ protected $stats = array();

+ protected $split_words = array();

+ protected $id;

+ protected $indexes;

+ protected $sphinx;

+ protected $phpbb_root_path;

+ protected $php_ext;

+ protected $auth;

+ protected $config;

+ protected $db;

+ protected $db_tools;

+ protected $dbtype;

+ protected $user;

+ protected $config_file_data = '';

+ public function __construct(&$error, $phpbb_root_path, $phpEx, $auth, $config, $db, $user)

+ $this->phpbb_root_path = $phpbb_root_path;

+ $this->php_ext = $phpEx;

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

+ if (!class_exists('SphinxClient'))

+ {

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

+ }

+

+ // Initialize sphinx client

+ public function init()

+ protected function config_generate()

+ include($this->phpbb_root_path . 'config.' . $this->php_ext);

+ public function split_keywords(&$keywords, $terms)

+ public function keyword_search($type, $fields, $terms, $sort_by_sql, $sort_key, $sort_dir, $sort_days, $ex_fid_ary, $m_approve_fid_ary, $topic_id, $author_ary, $author_name, &$id_ary, $start, $per_page)

+ while (!$result && (strpos($this->sphinx->GetLastError(), "errno=111,") !== false) && $retries--)

+ if ($this->sphinx->GetLastError())

+ {

+ add_log('critical', 'LOG_SPHINX_ERROR', $this->sphinx->GetLastError());

+ if ($this->auth->acl_get('a_'))

+ {

+ trigger_error($this->user->lang('SPHINX_SEARCH_FAILED', $this->sphinx->GetLastError()));

+ }

+ else

+ {

+ trigger_error($this->user->lang('SPHINX_SEARCH_FAILED_LOG'));

+ }

+ }

+

+ public function author_search($type, $firstpost_only, $sort_by_sql, $sort_key, $sort_dir, $sort_days, $ex_fid_ary, $m_approve_fid_ary, $topic_id, $author_ary, $author_name, &$id_ary, $start, $per_page)

+ public function index($mode, $post_id, &$message, &$subject, $poster_id, $forum_id)

+ public function index_remove($post_ids, $author_ids, $forum_ids)

+ public function tidy($create = false)

+ public function create_index($acp_module, $u_action)

+ public function delete_index($acp_module, $u_action)

+ public function index_created($allow_new_files = true)

+ public function index_stats()

+ protected function get_stats()

+ public function acp()

+ $result = $this->call_hook($handle, __FUNCTION__);

+ * @param string $method Method name of the caller.

+ private function call_hook($handle, $method)

+ if (!empty($phpbb_hook) && $phpbb_hook->call_hook(array(__CLASS__, $method), $handle, $this))

+ if ($phpbb_hook->hook_return(array(__CLASS__, $method)))

+ $result = $phpbb_hook->hook_return_result(array(__CLASS__, $method));

+ global $phpbb_root_path, $request, $phpEx, $config, $phpbb_dispatcher;

+ $msg_data = array(

+ 'S_HAS_MULTIPLE_ATTACHMENTS' => (sizeof($attachments) > 1),

+ 'U_FORWARD_PM' => ($config['forward_pm'] && $auth->acl_get('u_sendpm') && $auth->acl_get('u_pm_forward')) ? "$url&amp;mode=compose&amp;action=forward&amp;f=$folder_id&amp;p=" . $message_row['msg_id'] : '',

+ /**

+ * Modify pm and sender data before it is assigned to the template

+ *

+ * @event core.ucp_pm_view_messsage

+ * @var mixed id Active module category (can be int or string)

+ * @var string mode Active module

+ * @var int folder_id ID of the folder the message is in

+ * @var int msg_id ID of the private message

+ * var array folder Array with data of user's message folders

+ * @var array message_row Array with message data

+ * @var array cp_row Array with senders custom profile field data

+ * @var array msg_data Template array with message data

+ * @since 3.1-A1

+ */

+ $vars = array('id', 'mode', 'folder_id', 'msg_id', 'folder', 'message_row', 'cp_row', 'msg_data');

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

+

+ $template->assign_vars($msg_data);

+

+ $methods = phpbb_gen_download_links('post_msg_id', $msg_id, $phpbb_root_path, $phpEx);

+ foreach ($methods as $method)

+ {

+ $template->assign_block_vars('dl_method', $method);

+ }

+

+ global $config, $db, $user, $auth, $template, $phpbb_root_path, $phpEx, $request, $phpbb_dispatcher;

+ $user_ids = $data['usernames'];

+

+ /**

+ * Remove users from friends/foes

+ *

+ * @event core.ucp_remove_zebra

+ * @var string mode Zebra type: friends|foes

+ * @var array user_ids User ids we remove

+ * @since 3.1-A1

+ */

+ $vars = array('user_ids');

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

+

+ AND ' . $db->sql_in_set('zebra_id', $user_ids);

+ /**

+ * Add users to friends/foes

+ *

+ * @event core.ucp_add_zebra

+ * @var string mode Zebra type:

+ * friends|foes

+ * @var array sql_ary Array of

+ * entries we add

+ * @since 3.1-A1

+ */

+ $vars = array('mode', 'sql_ary');

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

+

+ global $phpbb_dispatcher;

+ $user_lang_name = (file_exists($this->lang_path . $this->data['user_lang'] . "/common.$phpEx")) ? $this->data['user_lang'] : basename($config['default_lang']);

+ $user_date_format = $this->data['user_dateformat'];

+ $user_lang_name = basename($config['default_lang']);

+ $user_date_format = $config['default_dateformat'];

+ $user_lang_name = $config['default_lang'] = $accept_lang;

+ $user_lang_name = $config['default_lang'] = $accept_lang;

+ $user_data = $this->data;

+

+ /**

+ * Event to load language files and modify user data on every page

+ *

+ * @event core.user_setup

+ * @var array user_data Array with user's data row

+ * @var string user_lang_name Basename of the user's langauge

+ * @var string user_date_format User's date/time format

+ * @var string user_timezone User's timezone, should be one of

+ * http://www.php.net/manual/en/timezones.php

+ * @var mixed lang_set String or array of language files

+ * @var mixed style_id Style we are going to display

+ * @since 3.1-A1

+ */

+ $vars = array('user_data', 'user_lang_name', 'user_date_format', 'user_timezone', 'lang_set', 'style_id');

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

+

+ $this->data = $user_data;

+ $this->lang_name = $user_lang_name;

+ $this->date_format = $user_date_format;

+

+$page_title = $user->lang['INDEX'];

+

+/**

+* You can use this event to modify the page title and load data for the index

+*

+* @event core.index_modify_page_title

+* @var string page_title Title of the index page

+* @since 3.1-A1

+*/

+$vars = array('page_title');

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

+

+page_header($page_title);

+ // No changes from 3.0.11-RC2 to 3.0.11

+ '3.0.11-RC2' => array(),

+ // No changes from 3.0.11-RC2 to 3.0.11

+ case '3.0.11-RC2':

+ break;

+

+ global $template, $user, $phpbb_root_path, $phpEx, $db, $lang, $config, $cache, $auth;

+ $convert->fulltext_search = new $search_type($error, $phpbb_root_path, $phpEx, $auth, $config, $db, $user);

+ global $db, $lang, $phpbb_root_path, $phpEx, $config, $auth, $user;

+ $search = new phpbb_search_fulltext_native($error, $phpbb_root_path, $phpEx, $auth, $config, $db, $user);

+ $modified = ($update_list !== false) ? @filemtime($cache->get_driver()->cache_dir . 'data_update_list.' . $phpEx) : 0;

+ 'LOG_SPHINX_ERROR' => '<strong>Sphinx Error</strong><br />» %s',

+ 'DOWNLOAD_ALL' => 'Download all',

+ 'DOWNLOAD_ALL_ATTACHMENTS' => 'Download all attachments',

+ 'SPHINX_SEARCH_FAILED' => 'Search failed: %s',

+ 'SPHINX_SEARCH_FAILED_LOG' => 'Sorry, search could not be performed. More information about this failure has been logged in the error log.',

+ /**

+ * Modify user data before we display the profile

+ *

+ * @event core.memberlist_view_profile

+ * @var array member Title of the index page

+ * @var bool user_notes_enabled Is the mcp user notes module

+ * enabled?

+ * @var bool warn_user_enabled Is the mcp warnings module

+ * enabled?

+ * @var bool zebra_enabled Is the ucp zebra module

+ * enabled?

+ * @var bool friends_enabled Is the ucp friends module

+ * enabled?

+ * @var bool foes_enabled Is the ucp foes module

+ * enabled?

+ * @since 3.1-A1

+ */

+ $vars = array('member', 'user_notes_enabled', 'warn_user_enabled', 'zebra_enabled', 'friends_enabled', 'foes_enabled');

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

+

+ global $config, $auth, $template, $user, $phpEx, $phpbb_root_path, $phpbb_dispatcher;

+ $template_data = array(

+

+ /**

+ * Preparing a user's data before displaying it in profile and memberlist

+ *

+ * @event core.memberlist_prepare_profile_data

+ * @var array data Array with user's data

+ * @var array template_data Template array with user's data

+ * @since 3.1-A1

+ */

+ $vars = array('data', 'template_data');

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

+

+ return $template_data;

+ $search = new $search_type($error, $phpbb_root_path, $phpEx, $auth, $config, $db, $user);

+ <!-- IF TOTAL_MESSAGES -->{TOTAL_MESSAGES} &bull; <!-- ENDIF -->

+ <dl class="attachbox">

+ <dt>

+ {L_ATTACHMENTS}

+ <!-- IF S_HAS_MULTIPLE_ATTACHMENTS -->

+ <div class="dl_links">

+ <strong>{L_DOWNLOAD_ALL}:</strong>

+ <ul>

+ <!-- BEGIN dl_method -->

+ <li>[ <a href="{dl_method.LINK}">{dl_method.TYPE}</a> ]</li>

+ <!-- END dl_method -->

+ </ul>

+ </div>

+ <!-- ENDIF -->

+ </dt>

+ <!-- BEGIN attachment -->

+ <dd>{attachment.DISPLAY_ATTACHMENT}</dd>

+ <!-- END attachment -->

+ </dl>

+ <dt>

+ {L_ATTACHMENTS}

+ <!-- IF postrow.S_MULTIPLE_ATTACHMENTS -->

+ <div class="dl_links">

+ <strong>{L_DOWNLOAD_ALL}:</strong>

+ <ul>

+ <!-- BEGIN dl_method -->

+ <li>[ <a href="{postrow.dl_method.LINK}">{postrow.dl_method.TYPE}</a> ]</li>

+ <!-- END dl_method -->

+ </ul>

+ </div>

+ <!-- ENDIF -->

+ </dt>

+ <!-- IF S_HAS_ATTACHMENTS -->

+ <div class="dl_links">

+ <strong>{L_DOWNLOAD_ALL_ATTACHMENTS}:</strong>

+ <ul>

+ <!-- BEGIN dl_method -->

+ <li>[ <a href="{dl_method.LINK}">{dl_method.TYPE}</a> ]</li>

+ <!-- END dl_method -->

+ </ul>

+ </div>

+ <!-- ENDIF -->

+

+

+.topic-actions div.dl_links {

+ padding: 10px 0 0 10px;

+}

+

+div.dl_links {

+ display: inline-block;

+ text-transform: none;

+}

+

+.dl_links strong {

+ font-weight: bold;

+}

+

+.dl_links ul {

+ list-style-type: none;

+ margin: 0;

+ display: inline-block;

+}

+

+.dl_links li {

+ display: inline-block;

+}

+ padding: 5px 10px;

+ border-radius: 7px;

+/**

+* Use this event to enable and disable additional UCP modules

+*

+* @event core.ucp_display_module_before

+* @var p_master module Object holding all modules and their status

+* @var mixed id Active module category (can be the int or string)

+* @var string mode Active module

+* @since 3.1-A1

+*/

+$vars = array('module', 'id', 'mode');

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

+

+ $topic_row = array(

+ 'S_TOPIC_TYPE_SWITCH' => ($s_type_switch == $s_type_switch_test) ? -1 : $s_type_switch_test,

+ /**

+ * Modify the topic data before it is assigned to the template

+ *

+ * @event core.viewforum_modify_topicrow

+ * @var array row Array with topic data

+ * @var array topic_row Template array with topic data

+ * @since 3.1-A1

+ */

+ $vars = array('row', 'topic_row');

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

+

+ $template->assign_block_vars('topicrow', $topic_row);

+

+

+$sql_ary = array(

+ 'SELECT' => 'u.user_id, u.username, u.username_clean, u.user_type, u.user_colour, s.session_id, s.session_time, s.session_page, s.session_ip, s.session_browser, s.session_viewonline, s.session_forum_id',

+ 'FROM' => array(

+ USERS_TABLE => 'u',

+ SESSIONS_TABLE => 's',

+ ),

+ 'WHERE' => 'u.user_id = s.session_user_id

+ ((!$show_guests) ? ' AND s.session_user_id <> ' . ANONYMOUS : ''),

+ 'ORDER_BY' => $order_by,

+);

+

+/**

+* Modify the SQL query for getting the user data to display viewonline list

+*

+* @event core.viewonline_modify_sql

+* @var array sql_ary The SQL array

+* @var bool show_guests Do we display guests in the list

+* @since 3.1-A1

+*/

+$vars = array('sql_ary', 'show_guests');

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

+

+$result = $db->sql_query($db->sql_build_query('SELECT', $sql_ary));

+ /**

+ * Overwrite the location's name and URL, which are displayed in the list

+ *

+ * @event core.viewonline_overwrite_location

+ * @var array on_page File name and query string

+ * @var array row Array with the users sql row

+ * @var string location Page name to displayed in the list

+ * @var string location_url Page url to displayed in the list

+ * @since 3.1-A1

+ */

+ $vars = array('on_page', 'row', 'location', 'location_url');

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

+

+/**

+* Event to modify the SQL query before the post and poster data is retrieved

+*

+* @event core.viewtopic_get_post_data

+* @var array sql_ary The SQL array to get the data of posts and posters

+* @since 3.1-A1

+*/

+$vars = array('sql_ary');

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

+

+ $user_cache_data = array(

+ /**

+ * Modify the guest user's data displayed with the posts

+ *

+ * @event core.viewtopic_cache_guest_data

+ * @var array user_cache_data Array with the user's data

+ * @var int poster_id Poster's user id

+ * @var array row Array with original user and post data

+ * @since 3.1-A1

+ */

+ $vars = array('user_cache_data', 'poster_id', 'row');

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

+

+ $user_cache[$poster_id] = $user_cache_data;

+

+ $user_cache_data = array(

+ /**

+ * Modify the users' data displayed with their posts

+ *

+ * @event core.viewtopic_cache_user_data

+ * @var array user_cache_data Array with the user's data

+ * @var int poster_id Poster's user id

+ * @var array row Array with original user and post data

+ * @since 3.1-A1

+ */

+ $vars = array('user_cache_data', 'poster_id', 'row');

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

+

+ $user_cache[$poster_id] = $user_cache_data;

+

+$template->assign_vars(array(

+ 'S_HAS_ATTACHMENTS' => !empty($attachments),

+));

+

+$methods = phpbb_gen_download_links('topic_id', $topic_id, $phpbb_root_path, $phpEx);

+foreach ($methods as $method)

+{

+ $template->assign_block_vars('dl_method', $method);

+}

+

+ $post_row = array(

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

+ $user_poster_data = $user_cache[$poster_id];

+

+ /**

+ * Modify the posts template block

+ *

+ * @event core.viewtopic_modify_post_row

+ * @var array row Array with original post and user data

+ * @var array cp_row Custom profile field data of the poster

+ * @var array user_poster_data Poster's data from user cache

+ * @var array post_row Template block array of the post

+ * @since 3.1-A1

+ */

+ $vars = array('row', 'cp_row', 'user_poster_data', 'post_row');

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

+

+ $post_row = array_merge($post_row, $cp_row['row']);

+ $template->assign_block_vars('postrow', $post_row);

+

+ $methods = phpbb_gen_download_links('post_msg_id', $row['post_id'], $phpbb_root_path, $phpEx);

+ foreach ($methods as $method)

+ {

+ $template->assign_block_vars('postrow.dl_method', $method);

+ }

+$page_title = $topic_data['topic_title'] . ($start ? ' - ' . sprintf($user->lang['PAGE_TITLE_NUMBER'], floor($start / $config['posts_per_page']) + 1) : '');

+

+/**

+* You can use this event to modify the page title of the viewtopic page

+*

+* @event core.viewtopic_modify_page_title

+* @var string page_title Title of the index page

+* @var array topic_data Array with topic data

+* @var int forum_id Forum ID of the topic

+* @var int start Start offset used to calculate the page

+* @since 3.1-A1

+*/

+$vars = array('page_title', 'topic_data', 'forum_id', 'start');

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

+

+page_header($page_title, true, $forum_id);