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

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

+ $sql = 'SELECT MAX(post_id) as max_post_id

+ static $required = array('name', 'phpbb_version', 'copyright');

+ return array(

+ 'status' => LOGIN_ERROR_EXTERNAL_AUTH,

+ 'error_msg' => 'LDAP_NO_SERVER_CONNECTION',

+ 'user_row' => array('user_id' => ANONYMOUS),

+ );

+ $template = new phpbb_template($phpbb_root_path, $phpEx, $config, $user, $style_resource_locator);

+ // Adjust default value if db-dependent specified

+ $statements[] = 'ALTER TABLE ' . $table_name . ' ADD UNIQUE INDEX ' . $index_name . '(' . implode(', ', $column) . ')';

+ * Seek to given row number

+ * rownum is zero-based

+ */

+ function sql_rowseek($rownum, &$query_id)

+ {

+ global $cache;

+

+ if ($query_id === false)

+ {

+ $query_id = $this->query_result;

+ }

+

+ if (isset($cache->sql_rowset[$query_id]))

+ {

+ return $cache->sql_rowseek($rownum, $query_id);

+ }

+

+ if ($query_id === false)

+ {

+ return false;

+ }

+

+ $this->sql_freeresult($query_id);

+ $query_id = $this->sql_query($this->last_query_text);

+

+ if ($query_id === false)

+ {

+ return false;

+ }

+

+ // We do not fetch the row for rownum == 0 because then the next resultset would be the second row

+ for ($i = 0; $i < $rownum; $i++)

+ {

+ if (!$this->sql_fetchrow($query_id))

+ {

+ return false;

+ }

+ }

+

+ return true;

+ }

+

+ /**

+* @version Version 0.1 / slightly modified for phpBB 3.1.x (using $H$ as hash type identifier)

+ $sql = 'SELECT t.forum_id

+ FROM ' . TOPICS_TABLE . ' t

+ LEFT JOIN ' . TOPICS_TRACK_TABLE . ' tt

+ ON (tt.topic_id = t.topic_id

+ AND tt.user_id = ' . $user->data['user_id'] . ')

+ AND (tt.topic_id IS NULL

+ OR tt.mark_time < t.topic_last_post_time)';

+ 'T_ASSETS_VERSION' => $config['assets_version'],

+ 'T_STYLESHEET_LINK' => "{$web_path}styles/" . rawurlencode($user->theme['style_path']) . '/theme/stylesheet.css?assets_version=' . $config['assets_version'],

+ 'T_STYLESHEET_LANG_LINK' => "{$web_path}styles/" . rawurlencode($user->theme['style_path']) . '/theme/' . $user->lang_name . '/stylesheet.css?assets_version=' . $config['assets_version'],

+ 'T_JQUERY_LINK' => ($config['load_jquery_cdn'] && !empty($config['load_jquery_url'])) ? $config['load_jquery_url'] : "{$web_path}assets/javascript/jquery.js?assets_version=" . $config['assets_version'],

+/**

+* Creates the output to be stored in a phpBB config.php file

+*

+* @param array $data Array containing the database connection information

+* @param string $dbms The name of the DBAL class to use

+* @param array $load_extensions Array of additional extensions that should be loaded

+* @param bool $debug If the debug constants should be enabled by default or not

+*

+* @return string The output to write to the file

+*/

+ $config_data .= "// phpBB 3.1.x auto-generated configuration file\n// Do not change anything in this file!\n";

+ $tpl = new phpbb_template($phpbb_root_path, $phpEx, $config, $user, $style_resource_locator);

+ $style = new phpbb_style($phpbb_root_path, $phpEx, $config, $user, $style_resource_locator, $style_path_provider, $tpl);

+

+ $style->set_custom_style($template_lang . '_email', array($template_path, $fallback_template_path), '');

+* Delete all PM(s) for a given user and delete the ones without references

+*

+* @param int $user_id ID of the user whose private messages we want to delete

+*

+* @return boolean False if there were no pms found, true otherwise.

+*/

+function phpbb_delete_user_pms($user_id)

+{

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

+

+ $user_id = (int) $user_id;

+

+ if (!$user_id)

+ {

+ return false;

+ }

+

+ // Get PM Information for later deleting

+ // The two queries where split, so we can use our indexes

+ // Part 1: get PMs the user received

+ $sql = 'SELECT msg_id, author_id, folder_id, pm_unread, pm_new

+ FROM ' . PRIVMSGS_TO_TABLE . '

+ WHERE user_id = ' . $user_id;

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

+

+ $undelivered_msg = $undelivered_user = $delete_ids = array();

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

+ {

+ if ($row['author_id'] == $user_id && $row['folder_id'] == PRIVMSGS_NO_BOX)

+ {

+ // Undelivered messages

+ $undelivered_msg[] = $row['msg_id'];

+

+ if (isset($undelivered_user[$row['user_id']]))

+ {

+ ++$undelivered_user[$row['user_id']];

+ }

+ else

+ {

+ $undelivered_user[$row['user_id']] = 1;

+ }

+ }

+

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

+ }

+ $db->sql_freeresult($result);

+

+ // Part 2: get PMs the user sent

+ $sql = 'SELECT msg_id, author_id, folder_id, pm_unread, pm_new

+ FROM ' . PRIVMSGS_TO_TABLE . '

+ WHERE author_id = ' . $user_id . '

+ AND folder_id = ' . PRIVMSGS_NO_BOX;

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

+

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

+ {

+ if ($row['author_id'] == $user_id && $row['folder_id'] == PRIVMSGS_NO_BOX)

+ {

+ // Undelivered messages

+ $undelivered_msg[] = $row['msg_id'];

+

+ if (isset($undelivered_user[$row['user_id']]))

+ {

+ ++$undelivered_user[$row['user_id']];

+ }

+ else

+ {

+ $undelivered_user[$row['user_id']] = 1;

+ }

+ }

+

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

+ }

+ $db->sql_freeresult($result);

+

+ if (empty($delete_ids))

+ {

+ return false;

+ }

+

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

+

+ if (sizeof($undelivered_msg))

+ {

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

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

+ $db->sql_query($sql);

+ }

+

+ // Reset the userīs pm count to 0

+ if (isset($undelivered_user[$user_id]))

+ {

+ $sql = 'UPDATE ' . USERS_TABLE . '

+ SET user_new_privmsg = 0,

+ user_unread_privmsg = 0

+ WHERE user_id = ' . $user_id;

+ $db->sql_query($sql);

+ unset($undelivered_user[$user_id]);

+ }

+

+ foreach ($undelivered_user as $_user_id => $count)

+ {

+ $sql = 'UPDATE ' . USERS_TABLE . '

+ SET user_new_privmsg = user_new_privmsg - ' . $count . ',

+ user_unread_privmsg = user_unread_privmsg - ' . $count . '

+ WHERE user_id = ' . $_user_id;

+ $db->sql_query($sql);

+ }

+

+ // Delete private message data

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

+ WHERE user_id = $user_id

+ AND " . $db->sql_in_set('msg_id', $delete_ids);

+ $db->sql_query($sql);

+

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

+ $sql = 'SELECT msg_id

+ FROM ' . PRIVMSGS_TO_TABLE . '

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

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

+

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

+ {

+ unset($delete_ids[$row['msg_id']]);

+ }

+ $db->sql_freeresult($result);

+

+ if (!empty($delete_ids))

+ {

+ // Check if there are any attachments we need to remove

+ if (!function_exists('delete_attachments'))

+ {

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

+ }

+

+ delete_attachments('message', $delete_ids, false);

+

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

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

+ $db->sql_query($sql);

+ }

+

+ // Set the remaining author id to anonymous

+ // This way users are still able to read messages from users being removed

+ $sql = 'UPDATE ' . PRIVMSGS_TO_TABLE . '

+ SET author_id = ' . ANONYMOUS . '

+ WHERE author_id = ' . $user_id;

+ $db->sql_query($sql);

+

+ $sql = 'UPDATE ' . PRIVMSGS_TABLE . '

+ SET author_id = ' . ANONYMOUS . '

+ WHERE author_id = ' . $user_id;

+ $db->sql_query($sql);

+

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

+

+ return true;

+}

+

+/**

+ // Clean the private messages tables from the user

+ if (!function_exists('phpbb_delete_user_pms'))

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

+ phpbb_delete_user_pms($user_id);

+* Verifies whether a style ID corresponds to an active style.

+*

+* @param int $style_id The style_id of a style which should be checked if activated or not.

+* @return boolean

+*/

+function phpbb_style_is_active($style_id)

+{

+ global $db;

+

+ $sql = 'SELECT style_active

+ FROM ' . STYLES_TABLE . '

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

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

+

+ $style_is_active = (bool) $db->sql_fetchfield('style_active');

+ $db->sql_freeresult($result);

+

+ return $style_is_active;

+}

+

+/**

+ get_user_rank($user_row['user_rank'], $user_row['user_posts'], $rank_title, $rank_img, $rank_img_src);

+ get_user_rank($user_row['user_rank'], $user_row['user_posts'], $rank_title, $rank_img, $rank_img_src);

+// vendor/autoload.php. If this file exists it will be

+ if (!file_exists($phpbb_root_path . 'vendor/autoload.php'))

+ require($phpbb_root_path . 'vendor/autoload.php');

+class phpbb_style_resource_locator implements phpbb_template_locator

+ * Template class.

+ * @var phpbb_template

+ * phpBB root path

+ * @var string

+ * PHP file extension

+ * @var string

+ * phpBB config instance

+ * @var phpbb_config

+ * Current user

+ * @var phpbb_user

+ * @param phpbb_template $template template

+ public function __construct($phpbb_root_path, $phpEx, $config, $user, phpbb_style_resource_locator $locator, phpbb_style_path_provider_interface $provider, phpbb_template $template)

+ $this->template->context = new phpbb_template_context();

+stream_filter_register('phpbb_template', 'phpbb_template_filter');

+class phpbb_template_compile

+class phpbb_template_context

+ * Users should alter template variables via functions in phpbb_template.

+class phpbb_template_filter extends php_user_filter

+ * Get the allow_php option, root directory and locator from params,

+

+

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2011 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+

+/**

+* Resource locator interface.

+*

+* Objects implementing this interface maintain mapping from template handles

+* to source template file paths and locate templates.

+*

+* Locates style files.

+*

+* Resource locator is aware of styles tree, and can return actual

+* filesystem paths (i.e., the "child" style or the "parent" styles)

+* depending on what files exist.

+*

+* Root paths stored in locator are paths to style directories. Templates are

+* stored in subdirectory that $template_path points to.

+*

+* @package phpBB3

+*/

+interface phpbb_template_locator

+{

+ /**

+ * Sets the template filenames for handles. $filename_array

+ * should be a hash of handle => filename pairs.

+ *

+ * @param array $filname_array Should be a hash of handle => filename pairs.

+ */

+ public function set_filenames(array $filename_array);

+

+ /**

+ * Determines the filename for a template handle.

+ *

+ * The filename comes from array used in a set_filenames call,

+ * which should have been performed prior to invoking this function.

+ * Return value is a file basename (without path).

+ *

+ * @param $handle string Template handle

+ * @return string Filename corresponding to the template handle

+ */

+ public function get_filename_for_handle($handle);

+

+ /**

+ * Determines the source file path for a template handle without

+ * regard for styles tree.

+ *

+ * This function returns the path in "primary" style directory

+ * corresponding to the given template handle. That path may or

+ * may not actually exist on the filesystem. Because this function

+ * does not perform stat calls to determine whether the path it

+ * returns actually exists, it is faster than get_source_file_for_handle.

+ *

+ * Use get_source_file_for_handle to obtain the actual path that is

+ * guaranteed to exist (which might come from the parent style

+ * directory if primary style has parent styles).

+ *

+ * This function will trigger an error if the handle was never

+ * associated with a template file via set_filenames.

+ *

+ * @param $handle string Template handle

+ * @return string Path to source file path in primary style directory

+ */

+ public function get_virtual_source_file_for_handle($handle);

+

+ /**

+ * Determines the source file path for a template handle, accounting

+ * for styles tree and verifying that the path exists.

+ *

+ * This function returns the actual path that may be compiled for

+ * the specified template handle. It will trigger an error if

+ * the template handle was never associated with a template path

+ * via set_filenames or if the template file does not exist on the

+ * filesystem.

+ *

+ * Use get_virtual_source_file_for_handle to just resolve a template

+ * handle to a path without any filesystem or styles tree checks.

+ *

+ * @param string $handle Template handle (i.e. "friendly" template name)

+ * @param bool $find_all If true, each root path will be checked and function

+ * will return array of files instead of string and will not

+ * trigger a error if template does not exist

+ * @return string Source file path

+ */

+ public function get_source_file_for_handle($handle, $find_all = false);

+

+ /**

+ * Locates source file path, accounting for styles tree and verifying that

+ * the path exists.

+ *

+ * Unlike previous functions, this function works without template handle

+ * and it can search for more than one file. If more than one file name is

+ * specified, it will return location of file that it finds first.

+ *

+ * @param array $files List of files to locate.

+ * @param bool $return_default Determines what to return if file does not

+ * exist. If true, function will return location where file is

+ * supposed to be. If false, function will return false.

+ * @param bool $return_full_path If true, function will return full path

+ * to file. If false, function will return file name. This

+ * parameter can be used to check which one of set of files

+ * is available.

+ * @return string or boolean Source file path if file exists or $return_default is

+ * true. False if file does not exist and $return_default is false

+ */

+ public function get_first_file_location($files, $return_default = false, $return_full_path = true);

+}

+interface phpbb_template_renderer

+ * @param phpbb_template_context $context Template context to use

+class phpbb_template_renderer_eval implements phpbb_template_renderer

+ * @param phpbb_template $template template object

+ * @param phpbb_template_context $context Template context to use

+class phpbb_template_renderer_include implements phpbb_template_renderer

+ * @param phpbb_template_context $context Template context to use

+class phpbb_template

+ * Template context.

+ * @var phpbb_template_context

+ * Path of the cache directory for the template

+ * @var string

+ * phpBB root path

+ * @var string

+ * PHP file extension

+ * @var string

+ * phpBB config instance

+ * @var phpbb_config

+ * Current user

+ * @var phpbb_user

+ * Template locator

+ * @var phpbb_template_locator

+ * @param phpbb_template_locator $locator template locator

+ public function __construct($phpbb_root_path, $phpEx, $config, $user, phpbb_template_locator $locator)

+ * Returns an object implementing phpbb_template_renderer, or null

+ * @return phpbb_template_renderer Template renderer object, or null on failure

+ * @uses phpbb_template_compile is used to compile template source

+ return new phpbb_template_renderer_include($output_file, $this);

+ $compile = new phpbb_template_compile($this->config['tpl_allow_php'], $this->locator, $this->phpbb_root_path);

+ $renderer = new phpbb_template_renderer_include($output_file, $this);

+ $renderer = new phpbb_template_renderer_eval($code, $this);

+ // Docstring is copied from phpbb_template_context method with the same name.

+ // Docstring is copied from phpbb_template_context method with the same name.

+ $file .= (strpos($file, '?') === false) ? '?' : '&';

+ $file .= 'assets_version=' . $this->config['assets_version'];

+

+ if ($config['override_user_style'])

+ {

+ $data['style'] = (int) $config['default_style'];

+ }

+ else if (!phpbb_style_is_active($data['style']))

+ {

+ $data['style'] = (int) $user->data['user_style'];

+ }

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

+ $phpbb_style->set_style();

+* according to the PHP manual. Therefore we provide our own locale independent