+ - pyrus set auto_discover 1

+[](http://www.phpbb.com)

+ php ../composer.phar install --dev

+ <property name="newversion" value="3.0.11" />

+ <property name="olderversions" value="3.0.2, 3.0.3, 3.0.4, 3.0.5, 3.0.6, 3.0.7, 3.0.7-PL1, 3.0.8, 3.0.9, 3.0.11-RC1, 3.0.11-RC2" />

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

+ 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 $db, $user, $phpbb_admin_path, $phpbb_root_path, $phpEx, $template, $request, $cache, $auth, $config;

+ $this->php_ext = $phpEx;

+ $this->u_base_action = append_sid("{$phpbb_admin_path}index.{$this->php_ext}", "i={$id}");

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

+ return $parsed_array;

+ // Re-parse cfg file

+

+ 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

+ global $phpEx, $phpbb_root_path;

+ $this->php_ext = $phpEx;

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

+ * @var array

+ */

+ protected $filelist = array();

+

+ /**

+ * Checks if a file by that name as already been added and, if it has,

+ * returns a new, unique name.

+ *

+ * @param string $name The filename

+ * @return string A unique filename

+ */

+ protected function unique_filename($name)

+ {

+ if (isset($this->filelist[$name]))

+ {

+ $start = $name;

+ $ext = '';

+ $this->filelist[$name]++;

+

+ // Separate the extension off the end of the filename to preserve it

+ $pos = strrpos($name, '.');

+ if ($pos !== false)

+ {

+ $start = substr($name, 0, $pos);

+ $ext = substr($name, $pos);

+ }

+

+ return $start . '_' . $this->filelist[$name] . $ext;

+ }

+

+ $this->filelist[$name] = 0;

+ return $name;

+ }

+

+ /**

+ $name = $this->unique_filename($name);

+ $name = $this->unique_filename($name);

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

+ }

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

+

+ $sql = "SELECT t.* $sql_select

+ FROM $sql_from

+ WHERE t.topic_type = " . POST_GLOBAL . '

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

+ ORDER BY t.topic_last_post_time DESC';

+

+

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

+ $msg_data = array(

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

+

+ 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',

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

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

+

+ $post_row = array(

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

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

+class phpbb_cache_test extends phpbb_database_test_case

+ public function getDataSet()

+ {

+ return $this->createXMLDataSet(dirname(__FILE__) . '/fixtures/config.xml');

+ }

+

+ parent::setUp();

+

+

+ parent::tearDown();

+

+ public function test_cache_sql()

+ {

+ $driver = new phpbb_cache_driver_file($this->cache_dir);

+

+ global $db, $cache;

+ $db = $this->new_dbal();

+ $cache = new phpbb_cache_service($driver);

+

+ $sql = "SELECT * FROM phpbb_config

+ WHERE config_name = 'foo'";

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

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

+

+ $this->assertFileExists($this->cache_dir . 'sql_' . md5(preg_replace('/[\n\r\s\t]+/', ' ', $sql)) . '.php');

+

+ $sql = "SELECT * FROM phpbb_config

+ WHERE config_name = 'foo'";

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

+

+ $this->assertEquals($first_result, $db->sql_fetchrow($result));

+

+ $sql = "SELECT * FROM phpbb_config

+ WHERE config_name = 'bar'";

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

+

+ $this->assertNotEquals($first_result, $db->sql_fetchrow($result));

+

+ $db->sql_close();

+ }

+<?xml version="1.0" encoding="UTF-8" ?>

+<dataset>

+ <table name="phpbb_config">

+ <column>config_name</column>

+ <column>config_value</column>

+ <column>is_dynamic</column>

+ <row>

+ <value>foo</value>

+ <value>23</value>

+ <value>0</value>

+ </row>

+ <row>

+ <value>bar</value>

+ <value>42</value>

+ <value>1</value>

+ </row>

+ </table>

+</dataset>

+ global $user, $phpbb_dispatcher;

+ $phpbb_dispatcher = new phpbb_mock_event_dispatcher();

+ global $user, $phpbb_dispatcher;

+ $phpbb_dispatcher = new phpbb_mock_event_dispatcher();

+ global $user, $phpbb_dispatcher;

+ $phpbb_dispatcher = new phpbb_mock_event_dispatcher();

+ global $user, $phpbb_dispatcher;

+ $phpbb_dispatcher = new phpbb_mock_event_dispatcher();

+ global $user, $phpbb_dispatcher;

+ $phpbb_dispatcher = new phpbb_mock_event_dispatcher();

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

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+class phpbb_mock_event_dispatcher

+{

+ public function trigger_event($eventName, $data)

+ {

+ return array();

+ }

+}