- 'avatar_min_width' => array('lang' => 'MIN_AVATAR_SIZE', 'validate' => 'int:0', 'type' => false, 'method' => false, 'explain' => false,),

- 'avatar_min_height' => array('lang' => 'MIN_AVATAR_SIZE', 'validate' => 'int:0', 'type' => false, 'method' => false, 'explain' => false,),

- 'avatar_max_width' => array('lang' => 'MAX_AVATAR_SIZE', 'validate' => 'int:0', 'type' => false, 'method' => false, 'explain' => false,),

- 'avatar_max_height' => array('lang' => 'MAX_AVATAR_SIZE', 'validate' => 'int:0', 'type' => false, 'method' => false, 'explain' => false,),

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

- 'cookie_secure' => array('lang' => 'COOKIE_SECURE', 'validate' => 'bool', 'type' => 'radio:disabled_enabled', 'explain' => true)

- 'auth_method' => array('lang' => 'AUTH_METHOD', 'validate' => 'string', 'type' => 'select', 'method' => 'select_auth_method', 'explain' => false)

- $sql = 'SELECT u.user_email, u.username, u.username_clean, u.user_lang, u.user_jabber, u.user_notify_type

- FROM ' . USERS_TABLE . ' u, ' . USER_GROUP_TABLE . ' ug

- WHERE ug.group_id = ' . $group_id . '

- AND u.user_type IN (' . USER_NORMAL . ', ' . USER_FOUNDER . ')

- ORDER BY u.user_lang, u.user_notify_type';

- $sql = 'SELECT username, username_clean, user_email, user_jabber, user_notify_type, user_lang

- FROM ' . USERS_TABLE . '

- WHERE user_allow_massemail = 1

- AND user_type IN (' . USER_NORMAL . ', ' . USER_FOUNDER . ')

- ORDER BY user_lang, user_notify_type';

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

- // Indexing enabled for this forum or global announcement?

- // Global announcements get indexed by default.

- if (!$row['forum_id'] || (isset($forums[$row['forum_id']]) && $forums[$row['forum_id']]))

- $db->sql_freeresult($result);

- define('TEMPLATE_BITFIELD', $bitfield->get_base64());

- $template_file = str_replace('..', '.', $template_file);

- $sql_ary['bbcode_bitfield'] = TEMPLATE_BITFIELD;

- 'orphan' => array('title' => 'ACP_ORPHAN_ATTACHMENTS', 'auth' => 'acl_a_attach', 'cat' => array('ACP_ATTACHMENTS'))

- $this->acl[$f] .= str_pad(base_convert($subseq, 36, 2), 31, 0, STR_PAD_LEFT);

- $noise[$i] = new char_cube3d($noise_bitmaps, mt_rand(1, count($noise_bitmaps['data'])));

- 'A' => $chars['A'][mt_rand(0, min(count($chars['A']), $config['captcha_gd_fonts']) -1)],

- 'B' => $chars['B'][mt_rand(0, min(count($chars['B']), $config['captcha_gd_fonts']) -1)],

- 'C' => $chars['C'][mt_rand(0, min(count($chars['C']), $config['captcha_gd_fonts']) -1)],

- 'D' => $chars['D'][mt_rand(0, min(count($chars['D']), $config['captcha_gd_fonts']) -1)],

- 'E' => $chars['E'][mt_rand(0, min(count($chars['E']), $config['captcha_gd_fonts']) -1)],

- 'F' => $chars['F'][mt_rand(0, min(count($chars['F']), $config['captcha_gd_fonts']) -1)],

- 'G' => $chars['G'][mt_rand(0, min(count($chars['G']), $config['captcha_gd_fonts']) -1)],

- 'H' => $chars['H'][mt_rand(0, min(count($chars['H']), $config['captcha_gd_fonts']) -1)],

- 'I' => $chars['I'][mt_rand(0, min(count($chars['I']), $config['captcha_gd_fonts']) -1)],

- 'J' => $chars['J'][mt_rand(0, min(count($chars['J']), $config['captcha_gd_fonts']) -1)],

- 'K' => $chars['K'][mt_rand(0, min(count($chars['K']), $config['captcha_gd_fonts']) -1)],

- 'L' => $chars['L'][mt_rand(0, min(count($chars['L']), $config['captcha_gd_fonts']) -1)],

- 'M' => $chars['M'][mt_rand(0, min(count($chars['M']), $config['captcha_gd_fonts']) -1)],

- 'N' => $chars['N'][mt_rand(0, min(count($chars['N']), $config['captcha_gd_fonts']) -1)],

- 'O' => $chars['O'][mt_rand(0, min(count($chars['O']), $config['captcha_gd_fonts']) -1)],

- 'P' => $chars['P'][mt_rand(0, min(count($chars['P']), $config['captcha_gd_fonts']) -1)],

- 'Q' => $chars['Q'][mt_rand(0, min(count($chars['Q']), $config['captcha_gd_fonts']) -1)],

- 'R' => $chars['R'][mt_rand(0, min(count($chars['R']), $config['captcha_gd_fonts']) -1)],

- 'S' => $chars['S'][mt_rand(0, min(count($chars['S']), $config['captcha_gd_fonts']) -1)],

- 'T' => $chars['T'][mt_rand(0, min(count($chars['T']), $config['captcha_gd_fonts']) -1)],

- 'U' => $chars['U'][mt_rand(0, min(count($chars['U']), $config['captcha_gd_fonts']) -1)],

- 'V' => $chars['V'][mt_rand(0, min(count($chars['V']), $config['captcha_gd_fonts']) -1)],

- 'W' => $chars['W'][mt_rand(0, min(count($chars['W']), $config['captcha_gd_fonts']) -1)],

- 'X' => $chars['X'][mt_rand(0, min(count($chars['X']), $config['captcha_gd_fonts']) -1)],

- 'Y' => $chars['Y'][mt_rand(0, min(count($chars['Y']), $config['captcha_gd_fonts']) -1)],

- 'Z' => $chars['Z'][mt_rand(0, min(count($chars['Z']), $config['captcha_gd_fonts']) -1)],

- // $this->delete_code(); commented out to allow posting.php to repeat the question

- function delete_code()

- {

- global $db, $user;

-

- $sql = 'DELETE FROM ' . CONFIRM_TABLE . "

- WHERE confirm_id = '" . $db->sql_escape($confirm_id) . "'

- AND session_id = '" . $db->sql_escape($user->session_id) . "'

- AND confirm_type = " . $this->type;

- $db->sql_query($sql);

- }

-

- // $this->delete_code(); commented out to allow posting.php to repeat the question

- * API function - clean the entry

- */

- function delete_code()

- {

- global $db, $user;

-

- $sql = 'DELETE FROM ' . CAPTCHA_QA_CONFIRM_TABLE . "

- WHERE confirm_id = '" . $db->sql_escape($confirm_id) . "'

- AND session_id = '" . $db->sql_escape($user->session_id) . "'

- AND confirm_type = " . $this->type;

- $db->sql_query($sql);

- }

-

- /**

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

- * @param string $value New configuration value

- * @param bool $cache Whether this variable should be cached or if it

- * changes too frequently to be efficiently cached.

- public function set($key, $value, $cache = true)

- * @param string $value New configuration value

- * @param bool $cache Whether this variable should be cached or if it

- public function set_atomic($key, $old_value, $value, $cache = true)

- $this->config[$key] = $value;

- * @param bool $cache Whether this variable should be cached or if it

- function increment($key, $increment, $cache = true)

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

- * @param string $value New configuration value

- * @param bool $cache Whether this variable should be cached or if it

- * changes too frequently to be efficiently cached.

- public function set($key, $value, $cache = true)

- $this->set_atomic($key, false, $value, $cache);

- * @param bool $cache Whether this variable should be cached or if it

- public function set_atomic($key, $old_value, $new_value, $cache = true)

- 'is_dynamic' => ($cache) ? 0 : 1));

- if ($cache)

- * @param bool $cache Whether this variable should be cached or if it

- function increment($key, $increment, $cache = true)

- $this->set($key, '0', $cache);

- if ($cache)

-

- /**

- * Returns whether this cron task can be run in shutdown function.

- *

- * By the time shutdown sequence invokes a particular piece of code,

- * resources that that code requires may already be released.

- * If so, a particular cron task may be marked shutdown function-

- * unsafe, and it will be executed in normal program flow.

- *

- * Generally speaking cron tasks should start off as shutdown function-

- * safe, and only be marked shutdown function-unsafe if a problem

- * is discovered.

- *

- * @return bool Whether the cron task is shutdown function-safe.

- */

- public function is_shutdown_function_safe()

- {

- return true;

- }

-

- /**

- * Returns whether this cron task can be run in shutdown function.

- *

- * A user reported that using the mail() function during shutdown

- * function execution does not work. Therefore if email is delivered

- * via the mail() function (as opposed to SMTP) queue cron task marks

- * itself shutdown function-unsafe.

- *

- * @return bool

- */

- public function is_shutdown_function_safe()

- {

- global $config;

- // A user reported using the mail() function while using shutdown does not work. We do not want to risk that.

- return !$config['smtp_delivery'];

- }

-

- /**

- * Returns whether this cron task can be run in shutdown function.

- *

- * By the time shutdown sequence invokes a particular piece of code,

- * resources that that code requires may already be released.

- * If so, a particular cron task may be marked shutdown function-

- * unsafe, and it will be executed in normal program flow.

- *

- * Generally speaking cron tasks should start off as shutdown function-

- * safe, and only be marked shutdown function-unsafe if a problem

- * is discovered.

- *

- * @return bool

- */

- public function is_shutdown_function_safe();

- $this->db_connect_id = ($this->persistency) ? @ibase_pconnect($use_database, $this->user, $sqlpassword, false, false, 3) : @ibase_connect($use_database, $this->user, $sqlpassword, false, false, 3);

- $this->service_handle = (function_exists('ibase_service_attach') && $this->server) ? @ibase_service_attach($this->server, $this->user, $sqlpassword) : false;

- 'message' => @ibase_errmsg(),

- $this->m_row_count = count($this->m_rows);

-

- preg_match_all('/\'(?:[^\']++|\'\')*+\'|[\d-.]+/', $regs[3], $vals, PREG_PATTERN_ORDER);

- 'message' => (!$this->db_connect_id) ? @pg_last_error() : @pg_last_error($this->db_connect_id),

-function request_var($var_name, $default, $multibyte = false, $cookie = false, phpbb_request_interface $request = null)

- set_config('rand_seed', $config['rand_seed'], true);

- if (substr($setting, 0, 3) != '$H$')

- // Get global announcement info

- if ($global_announce_list && sizeof($global_announce_list))

- {

- if (!isset($forum_mark_time[0]))

- {

- global $db;

-

- $sql = 'SELECT mark_time

- FROM ' . FORUMS_TRACK_TABLE . "

- WHERE user_id = {$user->data['user_id']}

- AND forum_id = 0";

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

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

- $db->sql_freeresult($result);

-

- if ($row)

- {

- $mark_time[0] = $row['mark_time'];

- }

- }

- else

- {

- if ($forum_mark_time[0] !== false)

- {

- $mark_time[0] = $forum_mark_time[0];

- }

- }

- }

-

- if ($global_announce_list && isset($global_announce_list[$topic_id]))

- {

- $last_read[$topic_id] = (isset($mark_time[0])) ? $mark_time[0] : $user_lastmark;

- }

- else

- {

- $last_read[$topic_id] = $user_lastmark;

- }

- global $config, $user;

- AND forum_id " .

- (($global_announce_list && sizeof($global_announce_list)) ? "IN (0, $forum_id)" : "= $forum_id");

- if ($global_announce_list && isset($global_announce_list[$topic_id]))

- {

- $last_read[$topic_id] = (isset($mark_time[0])) ? $mark_time[0] : $user_lastmark;

- }

- else

- {

- $last_read[$topic_id] = $user_lastmark;

- }

- if ($global_announce_list && sizeof($global_announce_list))

- {

- if (isset($tracking_topics['f'][0]))

- {

- $mark_time[0] = base_convert($tracking_topics['f'][0], 36, 10) + $config['board_startdate'];

- }

- }

- if ($global_announce_list && isset($global_announce_list[$topic_id]))

- {

- $last_read[$topic_id] = (isset($mark_time[0])) ? $mark_time[0] : $user_lastmark;

- }

- else

- {

- $last_read[$topic_id] = $user_lastmark;

- }

- global $db, $tracking_topics, $user, $config;

-* @param bool $use_unicode whether or not to take advantage of PCRE supporting unicode

- }

- if (!defined('IN_CRON') && !$config['use_system_cron'] && $run_cron && !$config['board_disable'])

-<?php

-/**

-*

-* @package acp

-* @version $Id$

-* @copyright (c) 2005 phpBB Group

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

-*

-*/

-

-/**

-* Header for acp pages

-*/

-function adm_page_header($page_title)

-{

- global $config, $db, $user, $template;

- global $phpbb_root_path, $phpbb_admin_path, $phpEx, $SID, $_SID;

-

- if (defined('HEADER_INC'))

- {

- return;

- }

-

- define('HEADER_INC', true);

-

- // gzip_compression

- if ($config['gzip_compress'])

- {

- if (@extension_loaded('zlib') && !headers_sent())

- {

- ob_start('ob_gzhandler');

- }

- }

-

- $template->assign_vars(array(

- 'PAGE_TITLE' => $page_title,

- 'USERNAME' => $user->data['username'],

-

- 'SID' => $SID,

- '_SID' => $_SID,

- 'SESSION_ID' => $user->session_id,

- 'ROOT_PATH' => $phpbb_admin_path,

-

- 'U_LOGOUT' => append_sid("{$phpbb_root_path}ucp.$phpEx", 'mode=logout'),

- 'U_ADM_LOGOUT' => append_sid("{$phpbb_admin_path}index.$phpEx", 'action=admlogout'),

- 'U_ADM_INDEX' => append_sid("{$phpbb_admin_path}index.$phpEx"),

- 'U_INDEX' => append_sid("{$phpbb_root_path}index.$phpEx"),

-

- 'T_IMAGES_PATH' => "{$phpbb_root_path}images/",

- 'T_SMILIES_PATH' => "{$phpbb_root_path}{$config['smilies_path']}/",

- 'T_AVATAR_PATH' => "{$phpbb_root_path}{$config['avatar_path']}/",

- 'T_AVATAR_GALLERY_PATH' => "{$phpbb_root_path}{$config['avatar_gallery_path']}/",

- 'T_ICONS_PATH' => "{$phpbb_root_path}{$config['icons_path']}/",

- 'T_RANKS_PATH' => "{$phpbb_root_path}{$config['ranks_path']}/",

- 'T_UPLOAD_PATH' => "{$phpbb_root_path}{$config['upload_path']}/",

-

- 'ICON_MOVE_UP' => '<img src="' . $phpbb_admin_path . 'images/icon_up.gif" alt="' . $user->lang['MOVE_UP'] . '" title="' . $user->lang['MOVE_UP'] . '" />',

- 'ICON_MOVE_UP_DISABLED' => '<img src="' . $phpbb_admin_path . 'images/icon_up_disabled.gif" alt="' . $user->lang['MOVE_UP'] . '" title="' . $user->lang['MOVE_UP'] . '" />',

- 'ICON_MOVE_DOWN' => '<img src="' . $phpbb_admin_path . 'images/icon_down.gif" alt="' . $user->lang['MOVE_DOWN'] . '" title="' . $user->lang['MOVE_DOWN'] . '" />',

- 'ICON_MOVE_DOWN_DISABLED' => '<img src="' . $phpbb_admin_path . 'images/icon_down_disabled.gif" alt="' . $user->lang['MOVE_DOWN'] . '" title="' . $user->lang['MOVE_DOWN'] . '" />',

- 'ICON_EDIT' => '<img src="' . $phpbb_admin_path . 'images/icon_edit.gif" alt="' . $user->lang['EDIT'] . '" title="' . $user->lang['EDIT'] . '" />',

- 'ICON_EDIT_DISABLED' => '<img src="' . $phpbb_admin_path . 'images/icon_edit_disabled.gif" alt="' . $user->lang['EDIT'] . '" title="' . $user->lang['EDIT'] . '" />',

- 'ICON_DELETE' => '<img src="' . $phpbb_admin_path . 'images/icon_delete.gif" alt="' . $user->lang['DELETE'] . '" title="' . $user->lang['DELETE'] . '" />',

- 'ICON_DELETE_DISABLED' => '<img src="' . $phpbb_admin_path . 'images/icon_delete_disabled.gif" alt="' . $user->lang['DELETE'] . '" title="' . $user->lang['DELETE'] . '" />',

- 'ICON_SYNC' => '<img src="' . $phpbb_admin_path . 'images/icon_sync.gif" alt="' . $user->lang['RESYNC'] . '" title="' . $user->lang['RESYNC'] . '" />',

- 'ICON_SYNC_DISABLED' => '<img src="' . $phpbb_admin_path . 'images/icon_sync_disabled.gif" alt="' . $user->lang['RESYNC'] . '" title="' . $user->lang['RESYNC'] . '" />',

-

- 'S_USER_LANG' => $user->lang['USER_LANG'],

- 'S_CONTENT_DIRECTION' => $user->lang['DIRECTION'],

- 'S_CONTENT_ENCODING' => 'UTF-8',

- 'S_CONTENT_FLOW_BEGIN' => ($user->lang['DIRECTION'] == 'ltr') ? 'left' : 'right',

- 'S_CONTENT_FLOW_END' => ($user->lang['DIRECTION'] == 'ltr') ? 'right' : 'left',

- ));

-

- // application/xhtml+xml not used because of IE

- header('Content-type: text/html; charset=UTF-8');

-

- header('Cache-Control: private, no-cache="set-cookie"');

- header('Expires: 0');

- header('Pragma: no-cache');

-

- return;

-}

-

-/**

-* Page footer for acp pages

-*/

-function adm_page_footer($copyright_html = true)

-{

- global $db, $config, $template, $user, $auth, $cache;

- global $starttime, $phpbb_root_path, $phpbb_admin_path, $phpEx;

- global $request;

-

- // Output page creation time

- if (defined('DEBUG'))

- {

- $mtime = explode(' ', microtime());

- $totaltime = $mtime[0] + $mtime[1] - $starttime;

-

- if ($request->variable('explain', false) && $auth->acl_get('a_') && defined('DEBUG_EXTRA') && method_exists($db, 'sql_report'))

- {

- $db->sql_report('display');

- }

-

- $debug_output = sprintf('Time : %.3fs | ' . $db->sql_num_queries() . ' Queries | GZIP : ' . (($config['gzip_compress']) ? 'On' : 'Off') . (($user->load) ? ' | Load : ' . $user->load : ''), $totaltime);

-

- if ($auth->acl_get('a_') && defined('DEBUG_EXTRA'))

- {

- if (function_exists('memory_get_usage'))

- {

- if ($memory_usage = memory_get_usage())

- {

- global $base_memory_usage;

- $memory_usage -= $base_memory_usage;

- $memory_usage = get_formatted_filesize($memory_usage);

-

- $debug_output .= ' | Memory Usage: ' . $memory_usage;

- }

- }

-

- $debug_output .= ' | <a href="' . build_url() . '&amp;explain=1">Explain</a>';

- }

- }

-

- $template->assign_vars(array(

- 'DEBUG_OUTPUT' => (defined('DEBUG')) ? $debug_output : '',

- 'TRANSLATION_INFO' => (!empty($user->lang['TRANSLATION_INFO'])) ? $user->lang['TRANSLATION_INFO'] : '',

- 'S_COPYRIGHT_HTML' => $copyright_html,

- 'VERSION' => $config['version'])

- );

-

- $template->display('body');

-

- garbage_collection();

- exit_handler();

-}

-

-/**

-* Generate back link for acp pages

-*/

-function adm_back_link($u_action)

-{

- global $user;

- return '<br /><br /><a href="' . $u_action . '">&laquo; ' . $user->lang['BACK_TO_PREV'] . '</a>';

-}

-

-/**

-* Build select field options in acp pages

-*/

-function build_select($option_ary, $option_default = false)

-{

- global $user;

-

- $html = '';

- foreach ($option_ary as $value => $title)

- {

- $selected = ($option_default !== false && $value == $option_default) ? ' selected="selected"' : '';

- $html .= '<option value="' . $value . '"' . $selected . '>' . $user->lang[$title] . '</option>';

- }

-

- return $html;

-}

-

-/**

-* Build radio fields in acp pages

-*/

-function h_radio($name, &$input_ary, $input_default = false, $id = false, $key = false)

-{

- global $user;

-

- $html = '';

- $id_assigned = false;

- foreach ($input_ary as $value => $title)

- {

- $selected = ($input_default !== false && $value == $input_default) ? ' checked="checked"' : '';

- $html .= '<label><input type="radio" name="' . $name . '"' . (($id && !$id_assigned) ? ' id="' . $id . '"' : '') . ' value="' . $value . '"' . $selected . (($key) ? ' accesskey="' . $key . '"' : '') . ' class="radio" /> ' . $user->lang[$title] . '</label>';

- $id_assigned = true;

- }

-

- return $html;

-}

-

-/**

-* Build configuration template for acp configuration pages

-*/

-function build_cfg_template($tpl_type, $key, &$new, $config_key, $vars)

-{

- global $user, $module;

-

- $tpl = '';

- $name = 'config[' . $config_key . ']';

-

- // Make sure there is no notice printed out for non-existent config options (we simply set them)

- if (!isset($new[$config_key]))

- {

- $new[$config_key] = '';

- }

-

- switch ($tpl_type[0])

- {

- case 'text':

- case 'password':

- $size = (int) $tpl_type[1];

- $maxlength = (int) $tpl_type[2];

-

- $tpl = '<input id="' . $key . '" type="' . $tpl_type[0] . '"' . (($size) ? ' size="' . $size . '"' : '') . ' maxlength="' . (($maxlength) ? $maxlength : 255) . '" name="' . $name . '" value="' . $new[$config_key] . '" />';

- break;

-

- case 'dimension':

- $size = (int) $tpl_type[1];

- $maxlength = (int) $tpl_type[2];

-

- $tpl = '<input id="' . $key . '" type="text"' . (($size) ? ' size="' . $size . '"' : '') . ' maxlength="' . (($maxlength) ? $maxlength : 255) . '" name="config[' . $config_key . '_width]" value="' . $new[$config_key . '_width'] . '" /> x <input type="text"' . (($size) ? ' size="' . $size . '"' : '') . ' maxlength="' . (($maxlength) ? $maxlength : 255) . '" name="config[' . $config_key . '_height]" value="' . $new[$config_key . '_height'] . '" />';

- break;

-

- case 'textarea':

- $rows = (int) $tpl_type[1];

- $cols = (int) $tpl_type[2];

-

- $tpl = '<textarea id="' . $key . '" name="' . $name . '" rows="' . $rows . '" cols="' . $cols . '">' . $new[$config_key] . '</textarea>';

- break;

-

- case 'radio':

- $key_yes = ($new[$config_key]) ? ' checked="checked"' : '';

- $key_no = (!$new[$config_key]) ? ' checked="checked"' : '';

-

- $tpl_type_cond = explode('_', $tpl_type[1]);

- $type_no = ($tpl_type_cond[0] == 'disabled' || $tpl_type_cond[0] == 'enabled') ? false : true;

-

- $tpl_no = '<label><input type="radio" name="' . $name . '" value="0"' . $key_no . ' class="radio" /> ' . (($type_no) ? $user->lang['NO'] : $user->lang['DISABLED']) . '</label>';

- $tpl_yes = '<label><input type="radio" id="' . $key . '" name="' . $name . '" value="1"' . $key_yes . ' class="radio" /> ' . (($type_no) ? $user->lang['YES'] : $user->lang['ENABLED']) . '</label>';

-

- $tpl = ($tpl_type_cond[0] == 'yes' || $tpl_type_cond[0] == 'enabled') ? $tpl_yes . $tpl_no : $tpl_no . $tpl_yes;

- break;

-

- case 'select':

- case 'custom':

-

- $return = '';

-

- if (isset($vars['method']))

- {

- $call = array($module->module, $vars['method']);

- }

- else if (isset($vars['function']))

- {

- $call = $vars['function'];

- }

- else

- {

- break;

- }

-

- if (isset($vars['params']))

- {

- $args = array();

- foreach ($vars['params'] as $value)

- {

- switch ($value)

- {

- case '{CONFIG_VALUE}':

- $value = $new[$config_key];

- break;

-

- case '{KEY}':

- $value = $key;

- break;

- }

-

- $args[] = $value;

- }

- }

- else

- {

- $args = array($new[$config_key], $key);

- }

-

- $return = call_user_func_array($call, $args);

-

- if ($tpl_type[0] == 'select')

- {

- $tpl = '<select id="' . $key . '" name="' . $name . '">' . $return . '</select>';

- }

- else

- {

- $tpl = $return;

- }

-

- break;

-

- default:

- break;

- }

-

- if (isset($vars['append']))

- {

- $tpl .= $vars['append'];

- }

-

- return $tpl;

-}

-

-/**

-* Going through a config array and validate values, writing errors to $error. The validation method accepts parameters separated by ':' for string and int.

-* The first parameter defines the type to be used, the second the lower bound and the third the upper bound. Only the type is required.

-*/

-function validate_config_vars($config_vars, &$cfg_array, &$error)

-{

- global $phpbb_root_path, $user;

- $type = 0;

- $min = 1;

- $max = 2;

-

- foreach ($config_vars as $config_name => $config_definition)

- {

- if (!isset($cfg_array[$config_name]) || strpos($config_name, 'legend') !== false)

- {

- continue;

- }

-

- if (!isset($config_definition['validate']))

- {

- continue;

- }

-

- $validator = explode(':', $config_definition['validate']);

-

- // Validate a bit. ;) (0 = type, 1 = min, 2= max)

- switch ($validator[$type])

- {

- case 'string':

- $length = strlen($cfg_array[$config_name]);

-

- // the column is a VARCHAR

- $validator[$max] = (isset($validator[$max])) ? min(255, $validator[$max]) : 255;

-

- if (isset($validator[$min]) && $length < $validator[$min])

- {

- $error[] = sprintf($user->lang['SETTING_TOO_SHORT'], $user->lang[$config_definition['lang']], $validator[$min]);

- }

- else if (isset($validator[$max]) && $length > $validator[2])

- {

- $error[] = sprintf($user->lang['SETTING_TOO_LONG'], $user->lang[$config_definition['lang']], $validator[$max]);

- }

- break;

-

- case 'bool':

- $cfg_array[$config_name] = ($cfg_array[$config_name]) ? 1 : 0;

- break;

-

- case 'int':

- $cfg_array[$config_name] = (int) $cfg_array[$config_name];

-

- if (isset($validator[$min]) && $cfg_array[$config_name] < $validator[$min])

- {

- $error[] = sprintf($user->lang['SETTING_TOO_LOW'], $user->lang[$config_definition['lang']], $validator[$min]);

- }

- else if (isset($validator[$max]) && $cfg_array[$config_name] > $validator[$max])

- {

- $error[] = sprintf($user->lang['SETTING_TOO_BIG'], $user->lang[$config_definition['lang']], $validator[$max]);

- }

-

- if (strpos($config_name, '_max') !== false)

- {

- // Min/max pairs of settings should ensure that min <= max

- // Replace _max with _min to find the name of the minimum

- // corresponding configuration variable

- $min_name = str_replace('_max', '_min', $config_name);

-

- if (isset($cfg_array[$min_name]) && is_numeric($cfg_array[$min_name]) && $cfg_array[$config_name] < $cfg_array[$min_name])

- {

- // A minimum value exists and the maximum value is less than it

- $error[] = sprintf($user->lang['SETTING_TOO_LOW'], $user->lang[$config_definition['lang']], (int) $cfg_array[$min_name]);

- }

- }

- break;

-

- // Absolute path

- case 'script_path':

- if (!$cfg_array[$config_name])

- {

- break;

- }

-

- $destination = str_replace('\\', '/', $cfg_array[$config_name]);

-

- if ($destination !== '/')

- {

- // Adjust destination path (no trailing slash)

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

- {

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

- }

-

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

-

- if ($destination[0] != '/')

- {

- $destination = '/' . $destination;

- }

- }

-

- $cfg_array[$config_name] = trim($destination);

-

- break;

-

- // Absolute path

- case 'lang':

- if (!$cfg_array[$config_name])

- {

- break;

- }

-

- $cfg_array[$config_name] = basename($cfg_array[$config_name]);

-

- if (!file_exists($phpbb_root_path . 'language/' . $cfg_array[$config_name] . '/'))

- {

- $error[] = $user->lang['WRONG_DATA_LANG'];

- }

- break;

-

- // Relative path (appended $phpbb_root_path)

- case 'rpath':

- case 'rwpath':

- if (!$cfg_array[$config_name])

- {

- break;

- }

-

- $destination = $cfg_array[$config_name];

-

- // Adjust destination path (no trailing slash)

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

- {

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

- }

-

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

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

- {

- $destination = '';

- }

-

- $cfg_array[$config_name] = trim($destination);

-

- // Path being relative (still prefixed by phpbb_root_path), but with the ability to escape the root dir...

- case 'path':

- case 'wpath':

-

- if (!$cfg_array[$config_name])

- {

- break;

- }

-

- $cfg_array[$config_name] = trim($cfg_array[$config_name]);

-

- // Make sure no NUL byte is present...

- if (strpos($cfg_array[$config_name], "\0") !== false || strpos($cfg_array[$config_name], '%00') !== false)

- {

- $cfg_array[$config_name] = '';

- break;

- }

-

- if (!file_exists($phpbb_root_path . $cfg_array[$config_name]))

- {

- $error[] = sprintf($user->lang['DIRECTORY_DOES_NOT_EXIST'], $cfg_array[$config_name]);

- }

-

- if (file_exists($phpbb_root_path . $cfg_array[$config_name]) && !is_dir($phpbb_root_path . $cfg_array[$config_name]))

- {

- $error[] = sprintf($user->lang['DIRECTORY_NOT_DIR'], $cfg_array[$config_name]);

- }

-

- // Check if the path is writable

- if ($config_definition['validate'] == 'wpath' || $config_definition['validate'] == 'rwpath')

- {

- if (file_exists($phpbb_root_path . $cfg_array[$config_name]) && !phpbb_is_writable($phpbb_root_path . $cfg_array[$config_name]))

- {

- $error[] = sprintf($user->lang['DIRECTORY_NOT_WRITABLE'], $cfg_array[$config_name]);

- }

- }

-

- break;

- }

- }

-

- return;

-}

-

-/**

-* Checks whatever or not a variable is OK for use in the Database

-* param mixed $value_ary An array of the form array(array('lang' => ..., 'value' => ..., 'column_type' =>))'

-* param mixed $error The error array

-*/

-function validate_range($value_ary, &$error)

-{

- global $user;

-

- $column_types = array(

- 'BOOL' => array('php_type' => 'int', 'min' => 0, 'max' => 1),

- 'USINT' => array('php_type' => 'int', 'min' => 0, 'max' => 65535),

- 'UINT' => array('php_type' => 'int', 'min' => 0, 'max' => (int) 0x7fffffff),

- // Do not use (int) 0x80000000 - it evaluates to different

- // values on 32-bit and 64-bit systems.

- // Apparently -2147483648 is a float on 32-bit systems,

- // despite fitting in an int, thus explicit cast is needed.

- 'INT' => array('php_type' => 'int', 'min' => (int) -2147483648, 'max' => (int) 0x7fffffff),

- 'TINT' => array('php_type' => 'int', 'min' => -128, 'max' => 127),

-

- 'VCHAR' => array('php_type' => 'string', 'min' => 0, 'max' => 255),

- );

- foreach ($value_ary as $value)

- {

- $column = explode(':', $value['column_type']);

- $max = $min = 0;

- $type = 0;

- if (!isset($column_types[$column[0]]))

- {

- continue;

- }

- else

- {

- $type = $column_types[$column[0]];

- }

-

- switch ($type['php_type'])

- {

- case 'string' :

- $max = (isset($column[1])) ? min($column[1],$type['max']) : $type['max'];

- if (strlen($value['value']) > $max)

- {

- $error[] = sprintf($user->lang['SETTING_TOO_LONG'], $user->lang[$value['lang']], $max);

- }

- break;

-

- case 'int':

- $min = (isset($column[1])) ? max($column[1],$type['min']) : $type['min'];

- $max = (isset($column[2])) ? min($column[2],$type['max']) : $type['max'];

- if ($value['value'] < $min)

- {

- $error[] = sprintf($user->lang['SETTING_TOO_LOW'], $user->lang[$value['lang']], $min);

- }

- else if ($value['value'] > $max)

- {

- $error[] = sprintf($user->lang['SETTING_TOO_BIG'], $user->lang[$value['lang']], $max);

- }

- break;

- }

- }

-}

- if (!$row['forum_id'])

- if ($auth->acl_getf_global('f_read'))

- {

- if (!$default_forum_id)

- {

- $sql = 'SELECT forum_id

- FROM ' . FORUMS_TABLE . '

- WHERE forum_type = ' . FORUM_POST;

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

- $default_forum_id = (int) $db->sql_fetchfield('forum_id', false, $f_result);

- $db->sql_freeresult($f_result);

- }

-

- $is_auth[$row['topic_id']] = $default_forum_id;

- }

- }

- else

- {

- if ($auth->acl_get('f_read', $row['forum_id']))

- {

- $is_auth[$row['topic_id']] = $row['forum_id'];

- }

- // Check for unread global announcements (index page only)

- $ga_unread = false;

- if ($root_data['forum_id'] == 0)

- {

- $unread_ga_list = get_unread_topics($user->data['user_id'], 'AND t.forum_id = 0', '', 1);

-

- if (!empty($unread_ga_list))

- {

- $ga_unread = true;

- }

- }

-

- // Add 0 to forums array to mark global announcements correctly

- $forum_ids[] = 0;

- // Mark the first visible forum on index as unread if there's any unread global announcement

- if ($ga_unread && !empty($forum_ids_moderator) && $forum_id == $forum_ids_moderator[0])

- {

- $forum_unread = true;

- }

-

- 'S_CHECKED' => ($cur_topic_type == $topic_value['const'] || ($forum_id == 0 && $topic_value['const'] == POST_GLOBAL)) ? ' checked="checked"' : '',

- // We do not use the constants here, because some were not available in PHP 4.3.x

- if ($data['topic_type'] != POST_GLOBAL)

- {

- $sql_data[FORUMS_TABLE] .= 'forum_topics_real = forum_topics_real - 1';

- $sql_data[FORUMS_TABLE] .= ($data['topic_approved']) ? ', forum_posts = forum_posts - 1, forum_topics = forum_topics - 1' : '';

- }

- if ($data['topic_type'] != POST_GLOBAL)

- {

- $sql_data[FORUMS_TABLE] = ($data['post_approved']) ? 'forum_posts = forum_posts - 1' : '';

- }

- if ($data['topic_type'] != POST_GLOBAL)

- {

- $sql_data[FORUMS_TABLE] = ($data['post_approved']) ? 'forum_posts = forum_posts - 1' : '';

- }

- if ($data['topic_type'] != POST_GLOBAL)

- {

- $sql_data[FORUMS_TABLE] = ($data['post_approved']) ? 'forum_posts = forum_posts - 1' : '';

- }

- 'forum_id' => ($topic_type == POST_GLOBAL) ? 0 : $data['forum_id'],

- 'forum_id' => ($topic_type == POST_GLOBAL) ? 0 : $data['forum_id'],

- 'forum_id' => ($topic_type == POST_GLOBAL) ? 0 : $data['forum_id'],

- if ($topic_type != POST_GLOBAL)

- if ($post_approval)

- {

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_posts = forum_posts + 1';

- }

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_topics_real = forum_topics_real + 1' . (($post_approval) ? ', forum_topics = forum_topics + 1' : '');

- if ($post_approval && $topic_type != POST_GLOBAL)

- 'forum_id' => ($topic_type == POST_GLOBAL) ? 0 : $data['forum_id'],

- $make_global = false;

-

- // Are we globalising or unglobalising?

- if ($post_mode == 'edit_first_post' || $post_mode == 'edit_topic')

- {

- if (!sizeof($topic_row))

- {

- $sql = 'SELECT topic_type, topic_replies, topic_replies_real, topic_approved, topic_last_post_id

- FROM ' . TOPICS_TABLE . '

- WHERE topic_id = ' . $data['topic_id'];

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

- $topic_row = $db->sql_fetchrow($result);

- $db->sql_freeresult($result);

- }

-

- // globalise/unglobalise?

- if (($topic_row['topic_type'] != POST_GLOBAL && $topic_type == POST_GLOBAL) || ($topic_row['topic_type'] == POST_GLOBAL && $topic_type != POST_GLOBAL))

- {

- if (!empty($sql_data[FORUMS_TABLE]['stat']) && implode('', $sql_data[FORUMS_TABLE]['stat']))

- {

- $db->sql_query('UPDATE ' . FORUMS_TABLE . ' SET ' . implode(', ', $sql_data[FORUMS_TABLE]['stat']) . ' WHERE forum_id = ' . $data['forum_id']);

- }

-

- $make_global = true;

- $sql_data[FORUMS_TABLE]['stat'] = array();

- }

-

- // globalise

- if ($topic_row['topic_type'] != POST_GLOBAL && $topic_type == POST_GLOBAL)

- {

- // Decrement topic/post count

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_posts = forum_posts - ' . ($topic_row['topic_replies_real'] + 1);

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_topics_real = forum_topics_real - 1' . (($topic_row['topic_approved']) ? ', forum_topics = forum_topics - 1' : '');

-

- // Update forum_ids for all posts

- $sql = 'UPDATE ' . POSTS_TABLE . '

- SET forum_id = 0

- WHERE topic_id = ' . $data['topic_id'];

- $db->sql_query($sql);

- }

- // unglobalise

- else if ($topic_row['topic_type'] == POST_GLOBAL && $topic_type != POST_GLOBAL)

- {

- // Increment topic/post count

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_posts = forum_posts + ' . ($topic_row['topic_replies_real'] + 1);

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_topics_real = forum_topics_real + 1' . (($topic_row['topic_approved']) ? ', forum_topics = forum_topics + 1' : '');

-

- // Update forum_ids for all posts

- $sql = 'UPDATE ' . POSTS_TABLE . '

- SET forum_id = ' . $data['forum_id'] . '

- WHERE topic_id = ' . $data['topic_id'];

- $db->sql_query($sql);

- }

- }

-

- // only applicable if the topic is not global and it is approved

- // we also check to make sure we are not dealing with globaling the latest topic (pretty rare but still needs to be checked)

- if ($topic_type != POST_GLOBAL && !$make_global && ($post_approved || !$data['post_approved']))

- else if ($make_global)

- {

- // somebody decided to be a party pooper, we must recalculate the whole shebang (maybe)

- $sql = 'SELECT forum_last_post_id

- FROM ' . FORUMS_TABLE . '

- WHERE forum_id = ' . (int) $data['forum_id'];

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

- $forum_row = $db->sql_fetchrow($result);

- $db->sql_freeresult($result);

-

- // we made a topic global, go get new data

- if ($topic_row['topic_type'] != POST_GLOBAL && $topic_type == POST_GLOBAL && $forum_row['forum_last_post_id'] == $topic_row['topic_last_post_id'])

- {

- // we need a fresh change of socks, everything has become invalidated

- $sql = 'SELECT MAX(topic_last_post_id) as last_post_id

- FROM ' . TOPICS_TABLE . '

- WHERE forum_id = ' . (int) $data['forum_id'] . '

- AND topic_approved = 1';

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

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

- $db->sql_freeresult($result);

-

- // any posts left in this forum?

- if (!empty($row['last_post_id']))

- {

- $sql = 'SELECT p.post_id, p.post_subject, p.post_time, p.poster_id, p.post_username, u.user_id, u.username, u.user_colour

- FROM ' . POSTS_TABLE . ' p, ' . USERS_TABLE . ' u

- WHERE p.poster_id = u.user_id

- AND p.post_id = ' . (int) $row['last_post_id'];

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

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

- $db->sql_freeresult($result);

-

- // salvation, a post is found! jam it into the forums table

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_post_id = ' . (int) $row['post_id'];

- $sql_data[FORUMS_TABLE]['stat'][] = "forum_last_post_subject = '" . $db->sql_escape($row['post_subject']) . "'";

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_post_time = ' . (int) $row['post_time'];

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_poster_id = ' . (int) $row['poster_id'];

- $sql_data[FORUMS_TABLE]['stat'][] = "forum_last_poster_name = '" . $db->sql_escape(($row['poster_id'] == ANONYMOUS) ? $row['post_username'] : $row['username']) . "'";

- $sql_data[FORUMS_TABLE]['stat'][] = "forum_last_poster_colour = '" . $db->sql_escape($row['user_colour']) . "'";

- }

- else

- {

- // just our luck, the last topic in the forum has just been globalized...

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_post_id = 0';

- $sql_data[FORUMS_TABLE]['stat'][] = "forum_last_post_subject = ''";

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_post_time = 0';

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_poster_id = 0';

- $sql_data[FORUMS_TABLE]['stat'][] = "forum_last_poster_name = ''";

- $sql_data[FORUMS_TABLE]['stat'][] = "forum_last_poster_colour = ''";

- }

- }

- else if ($topic_row['topic_type'] == POST_GLOBAL && $topic_type != POST_GLOBAL && $forum_row['forum_last_post_id'] < $topic_row['topic_last_post_id'])

- {

- // this post has a higher id, it is newer

- $sql = 'SELECT p.post_id, p.post_subject, p.post_time, p.poster_id, p.post_username, u.user_id, u.username, u.user_colour

- FROM ' . POSTS_TABLE . ' p, ' . USERS_TABLE . ' u

- WHERE p.poster_id = u.user_id

- AND p.post_id = ' . (int) $topic_row['topic_last_post_id'];

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

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

- $db->sql_freeresult($result);

-

- // salvation, a post is found! jam it into the forums table

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_post_id = ' . (int) $row['post_id'];

- $sql_data[FORUMS_TABLE]['stat'][] = "forum_last_post_subject = '" . $db->sql_escape($row['post_subject']) . "'";

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_post_time = ' . (int) $row['post_time'];

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_poster_id = ' . (int) $row['poster_id'];

- $sql_data[FORUMS_TABLE]['stat'][] = "forum_last_poster_name = '" . $db->sql_escape(($row['poster_id'] == ANONYMOUS) ? $row['post_username'] : $row['username']) . "'";

- $sql_data[FORUMS_TABLE]['stat'][] = "forum_last_poster_colour = '" . $db->sql_escape($row['user_colour']) . "'";

- }

- }

- if ($make_global)

- $search->index($mode, $data['post_id'], $data['message'], $subject, $poster_id, ($topic_type == POST_GLOBAL) ? 0 : $data['forum_id']);

- markread('topic', (($topic_type == POST_GLOBAL) ? 0 : $data['forum_id']), $data['topic_id'], time());

- AND forum_id = ' . (($topic_type == POST_GLOBAL) ? 0 : $data['forum_id']);

- if ($topic_type == POST_GLOBAL)

- {

- $sql = 'SELECT MAX(topic_last_post_time) as forum_last_post_time

- FROM ' . TOPICS_TABLE . '

- WHERE forum_id = 0';

- }

- else

- {

- $sql = 'SELECT forum_last_post_time

- FROM ' . FORUMS_TABLE . '

- WHERE forum_id = ' . $data['forum_id'];

- }

- update_forum_tracking_info((($topic_type == POST_GLOBAL) ? 0 : $data['forum_id']), $forum_last_post_time, $f_mark_time, false);

- // Count the number if ! occurrences (not allowed in vars)

- trigger_error('LENGTH_BAN_INVALID');

- trigger_error('NO_USER_SPECIFIED');

- trigger_error('NO_USERS');

- trigger_error('NO_IPS_DEFINED');

- trigger_error('NO_EMAILS_DEFINED');

- trigger_error('NO_MODE');

- if (!$password)

- $let = '\p{L}';

- $let = '[[:lower:][:upper:]]';

- $let = '[a-zA-Z]';

- case 'PASS_TYPE_CASE':

- $chars[] = $low;

- $chars[] = $upp;

- break;

- $chars[] = $let;

- break;

- case 'PASS_TYPE_SYMBOL':

- $chars[] = $num;

- $chars[] = $sym;

- break;

- $sql = "SELECT t.topic_id

- FROM " . TOPICS_TABLE . " t

- WHERE t.forum_id IN($forum_id, 0)

- " . (($auth->acl_get('m_approve', $forum_id)) ? '' : 'AND t.topic_approved = 1') . "

- $topic_tracking_info = get_topic_tracking($forum_id, $topic_list, $topic_rows, array($forum_id => $forum_info['mark_time']), array());

- $topic_tracking_info = get_complete_topic_tracking($forum_id, $topic_list, array());

- WHERE forum_id IN (0, ' . implode(', ', $forum_list) . ')

- $global_id = $forum_list[0];

-

- WHERE forum_id IN (0, ' . implode(', ', $forum_list) . ')

- $global_topic = ($row['forum_id']) ? false : true;

- if ($global_topic)

- {

- $row['forum_id'] = $global_id;

- }

-

- 'U_MCP_FORUM' => (!$global_topic) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=main&amp;mode=forum_view&amp;f=' . $row['forum_id']) : '',

- 'U_FORUM' => (!$global_topic) ? append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $row['forum_id']) : '',

- 'FORUM_NAME' => (!$global_topic) ? $forum_names[$row['forum_id']] : $user->lang['GLOBAL_ANNOUNCEMENT'],

- AND p.forum_id IN (0, ' . implode(', ', $forum_list) . ')';

- $global_id = $forum_list[0];

-

- AND p.forum_id IN (0, ' . implode(', ', $forum_list) . ')',

- $global_topic = ($row['forum_id']) ? false : true;

- if ($global_topic)

- {

- $row['forum_id'] = $global_id;

- }

-

- 'U_MCP_FORUM' => (!$global_topic) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'f=' . $row['forum_id'] . "&amp;i=$id&amp;mode=forum_view") : '',

- 'U_FORUM' => (!$global_topic) ? append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $row['forum_id']) : '',

- 'FORUM_NAME' => (!$global_topic) ? $row['forum_name'] : $user->lang['GLOBAL_ANNOUNCEMENT'],

- // Add forum_id 0 for global announcements

- $forum_list[] = 0;

-

- if ($new_topic_type != POST_GLOBAL)

- WHERE " . $db->sql_in_set('topic_id', $topic_ids) . '

- AND forum_id <> 0';

-

- // Reset forum id if a global topic is within the array

- $to_forum_id = request_var('to_forum_id', 0);

-

- if ($to_forum_id)

- {

- $sql = 'UPDATE ' . TOPICS_TABLE . "

- SET topic_type = $new_topic_type, forum_id = $to_forum_id

- WHERE " . $db->sql_in_set('topic_id', $topic_ids) . '

- AND forum_id = 0';

- $db->sql_query($sql);

-

- // Update forum_ids for all posts

- $sql = 'UPDATE ' . POSTS_TABLE . "

- SET forum_id = $to_forum_id

- WHERE " . $db->sql_in_set('topic_id', $topic_ids) . '

- AND forum_id = 0';

- $db->sql_query($sql);

-

- // Do a little forum sync stuff

- $sql = 'SELECT SUM(t.topic_replies + t.topic_approved) as topic_posts, COUNT(t.topic_approved) as topics_authed

- FROM ' . TOPICS_TABLE . ' t

- WHERE ' . $db->sql_in_set('t.topic_id', $topic_ids);

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

- $row_data = $db->sql_fetchrow($result);

- $db->sql_freeresult($result);

-

- $sync_sql = array();

-

- if ($row_data['topic_posts'])

- {

- $sync_sql[$to_forum_id][] = 'forum_posts = forum_posts + ' . (int) $row_data['topic_posts'];

- }

-

- if ($row_data['topics_authed'])

- {

- $sync_sql[$to_forum_id][] = 'forum_topics = forum_topics + ' . (int) $row_data['topics_authed'];

- }

-

- $sync_sql[$to_forum_id][] = 'forum_topics_real = forum_topics_real + ' . (int) sizeof($topic_ids);

-

- foreach ($sync_sql as $forum_id_key => $array)

- {

- $sql = 'UPDATE ' . FORUMS_TABLE . '

- SET ' . implode(', ', $array) . '

- WHERE forum_id = ' . $forum_id_key;

- $db->sql_query($sql);

- }

-

- sync('forum', 'forum_id', $to_forum_id);

- }

- }

- else

- {

- // Get away with those topics already being a global announcement by re-calculating $topic_ids

- $sql = 'SELECT topic_id

- FROM ' . TOPICS_TABLE . '

- WHERE ' . $db->sql_in_set('topic_id', $topic_ids) . '

- AND forum_id <> 0';

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

-

- $topic_ids = array();

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

- {

- $topic_ids[] = $row['topic_id'];

- }

- $db->sql_freeresult($result);

-

- if (sizeof($topic_ids))

- {

- // Delete topic shadows for global announcements

- $sql = 'DELETE FROM ' . TOPICS_TABLE . '

- WHERE ' . $db->sql_in_set('topic_moved_id', $topic_ids);

- $db->sql_query($sql);

-

- $sql = 'UPDATE ' . TOPICS_TABLE . "

- SET topic_type = $new_topic_type, forum_id = 0

- WHERE " . $db->sql_in_set('topic_id', $topic_ids);

- $db->sql_query($sql);

-

- // Update forum_ids for all posts

- $sql = 'UPDATE ' . POSTS_TABLE . '

- SET forum_id = 0

- WHERE ' . $db->sql_in_set('topic_id', $topic_ids);

- $db->sql_query($sql);

-

- // Do a little forum sync stuff

- $sql = 'SELECT SUM(t.topic_replies + t.topic_approved) as topic_posts, COUNT(t.topic_approved) as topics_authed

- FROM ' . TOPICS_TABLE . ' t

- WHERE ' . $db->sql_in_set('t.topic_id', $topic_ids);

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

- $row_data = $db->sql_fetchrow($result);

- $db->sql_freeresult($result);

-

- $sync_sql = array();

-

- if ($row_data['topic_posts'])

- {

- $sync_sql[$forum_id][] = 'forum_posts = forum_posts - ' . (int) $row_data['topic_posts'];

- }

-

- if ($row_data['topics_authed'])

- {

- $sync_sql[$forum_id][] = 'forum_topics = forum_topics - ' . (int) $row_data['topics_authed'];

- }

-

- $sync_sql[$forum_id][] = 'forum_topics_real = forum_topics_real - ' . (int) sizeof($topic_ids);

-

- foreach ($sync_sql as $forum_id_key => $array)

- {

- $sql = 'UPDATE ' . FORUMS_TABLE . '

- SET ' . implode(', ', $array) . '

- WHERE forum_id = ' . $forum_id_key;

- $db->sql_query($sql);

- }

-

- sync('forum', 'forum_id', $forum_id);

- }

- // Global topic involved?

- $global_involved = false;

-

- if ($new_topic_type != POST_GLOBAL)

- {

- $sql = 'SELECT forum_id

- FROM ' . TOPICS_TABLE . '

- WHERE ' . $db->sql_in_set('topic_id', $topic_ids) . '

- AND forum_id = 0';

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

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

- $db->sql_freeresult($result);

-

- if ($row)

- {

- $global_involved = true;

- }

- }

-

- if ($global_involved)

- {

- global $template;

-

- $template->assign_vars(array(

- 'S_FORUM_SELECT' => make_forum_select(request_var('f', $forum_id), false, false, true, true),

- 'S_CAN_LEAVE_SHADOW' => false,

- 'ADDITIONAL_MSG' => (sizeof($topic_ids) == 1) ? $user->lang['SELECT_FORUM_GLOBAL_ANNOUNCEMENT'] : $user->lang['SELECT_FORUM_GLOBAL_ANNOUNCEMENTS'])

- );

-

- confirm_box(false, $l_new_type, build_hidden_fields($s_hidden_fields), 'mcp_move.html');

- }

- else

- {

- confirm_box(false, $l_new_type, build_hidden_fields($s_hidden_fields));

- }

- if ($topic_info['topic_type'] != POST_GLOBAL)

- {

- $topics_removed++;

- $topic_posts_removed += $topic_info['topic_replies'];

- if ($topic_info['topic_approved'])

- {

- $topics_authed_removed++;

- $topic_posts_removed++;

- }

- // If we have moved a global announcement, we need to correct the topic type

- if ($row['topic_type'] == POST_GLOBAL)

- {

- $sql = 'UPDATE ' . TOPICS_TABLE . '

- SET topic_type = ' . POST_ANNOUNCE . '

- WHERE topic_id = ' . (int) $row['topic_id'];

- $db->sql_query($sql);

- }

-

- if ($topic_data['enable_indexing'])

- {

- // Select the search method and do some additional checks to ensure it can actually be utilised

- $search_type = basename($config['search_type']);

- if (!file_exists($phpbb_root_path . 'includes/search/' . $search_type . '.' . $phpEx))

- trigger_error('NO_SUCH_SEARCH_MODULE');

- }

- if (!class_exists($search_type))

- {

- include("{$phpbb_root_path}includes/search/$search_type.$phpEx");

- }

- $error = false;

- $search = new $search_type($error);

- $search_mode = 'post';

- if ($error)

- trigger_error($error);

- }

- else

- {

- $search_type = false;

- }

- foreach ($topic_data as $topic_id => $topic_row)

- {

- if ($search_type)

- $search->index($search_mode, $sql_ary['post_id'], $sql_ary['post_text'], $sql_ary['post_subject'], $sql_ary['poster_id'], ($topic_row['topic_type'] == POST_GLOBAL) ? 0 : $to_forum_id);

- $global_id = $forum_list[0];

-

- FROM ' . FORUMS_TABLE . "

- WHERE forum_id IN (0, $forum_list)";

- $global_id = $forum_id;

- FROM ' . POSTS_TABLE . ' p, ' . TOPICS_TABLE . ' t' . (($sort_order_sql[0] == 'u') ? ', ' . USERS_TABLE . ' u' : '') . "

- WHERE p.forum_id IN (0, $forum_list)

- " . (($sort_order_sql[0] == 'u') ? 'AND u.user_id = p.poster_id' : '') . '

- if ($row['forum_id'])

- {

- $forum_names[] = $row['forum_id'];

- }

- WHERE forum_id IN (0, $forum_list)

- if ($row['forum_id'])

- {

- $forum_names[] = $row['forum_id'];

- }

- $global_topic = ($row['forum_id']) ? false : true;

- if ($global_topic)

- {

- $row['forum_id'] = $global_id;

- }

-

- 'U_VIEWFORUM' => (!$global_topic) ? append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $row['forum_id']) : '',

- 'FORUM_NAME' => (!$global_topic) ? $forum_names[$row['forum_id']] : $user->lang['GLOBAL_ANNOUNCEMENT'],

-

- if ($post_data['forum_id'])

- {

- $forum_id_list[$post_data['forum_id']] = 1;

- }

- if ($post_data['forum_id'])

- {

- $total_topics++;

- }

- if ($post_data['forum_id'])

- {

- $total_posts++;

- // Increment by topic_replies if we approve a topic...

- // This works because we do not adjust the topic_replies when re-approving a topic after an edit.

- if ($post_data['topic_first_post_id'] == $post_id && $post_data['topic_replies'])

- {

- $total_posts += $post_data['topic_replies'];

- }

- $global_id = $forum_id;

- $global_topic = ($row['forum_id']) ? false : true;

- if ($global_topic)

- {

- $row['forum_id'] = $global_id;

- }

-

- 'U_VIEWFORUM' => (!$global_topic) ? append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $row['forum_id']) : '',

- 'FORUM_NAME' => (!$global_topic) ? $forum_data[$row['forum_id']]['forum_name'] : $user->lang['GLOBAL_ANNOUNCEMENT'],

- 'code' => array('bbcode_id' => 8, 'regexp' => array('#\[code(?:=([a-z]+))?\](.+\[/code\])#ise' => "\$this->bbcode_code('\$1', '\$2')")),

- 'quote' => array('bbcode_id' => 0, 'regexp' => array('#\[quote(?:=&quot;(.*?)&quot;)?\](.+)\[/quote\]#ise' => "\$this->bbcode_quote('\$0')")),

- 'attachment' => array('bbcode_id' => 12, 'regexp' => array('#\[attachment=([0-9]+)\](.*?)\[/attachment\]#ise' => "\$this->bbcode_attachment('\$1', '\$2')")),

- 'b' => array('bbcode_id' => 1, 'regexp' => array('#\[b\](.*?)\[/b\]#ise' => "\$this->bbcode_strong('\$1')")),

- 'i' => array('bbcode_id' => 2, 'regexp' => array('#\[i\](.*?)\[/i\]#ise' => "\$this->bbcode_italic('\$1')")),

- 'url' => array('bbcode_id' => 3, 'regexp' => array('#\[url(=(.*))?\](.*)\[/url\]#iUe' => "\$this->validate_url('\$2', '\$3')")),

- 'img' => array('bbcode_id' => 4, 'regexp' => array('#\[img\](.*)\[/img\]#iUe' => "\$this->bbcode_img('\$1')")),

- 'size' => array('bbcode_id' => 5, 'regexp' => array('#\[size=([\-\+]?\d+)\](.*?)\[/size\]#ise' => "\$this->bbcode_size('\$1', '\$2')")),

- 'color' => array('bbcode_id' => 6, 'regexp' => array('!\[color=(#[0-9a-f]{3}|#[0-9a-f]{6}|[a-z\-]+)\](.*?)\[/color\]!ise' => "\$this->bbcode_color('\$1', '\$2')")),

- 'u' => array('bbcode_id' => 7, 'regexp' => array('#\[u\](.*?)\[/u\]#ise' => "\$this->bbcode_underline('\$1')")),

- 'list' => array('bbcode_id' => 9, 'regexp' => array('#\[list(?:=(?:[a-z0-9]|disc|circle|square))?].*\[/list]#ise' => "\$this->bbcode_parse_list('\$0')")),

- 'email' => array('bbcode_id' => 10, 'regexp' => array('#\[email=?(.*?)?\](.*?)\[/email\]#ise' => "\$this->validate_email('\$1', '\$2')")),

- 'flash' => array('bbcode_id' => 11, 'regexp' => array('#\[flash=([0-9]+),([0-9]+)\](.*?)\[/flash\]#ie' => "\$this->bbcode_flash('\$1', '\$2', '\$3')"))

- $num_matches = preg_match_all('#(?<=^|[\n .])(?:' . implode('|', $match) . ')(?![^<>]*>)#', $this->message, $matches);

- $this->message = trim(preg_replace(explode(chr(0), '#(?<=^|[\n .])' . implode('(?![^<>]*>)#' . chr(0) . '#(?<=^|[\n .])', $match) . '(?![^<>]*>)#'), $replace, $this->message));

- $message = 'Illegal use of $' . $this->name . '. You must use the request class or request_var() to access input data. Found in %s on line %d. This error message was generated';

- // Bot user, if they have a SID in the Request URI we need to get rid of it

- // otherwise they'll index this page with the SID, duplicate content oh my!

- if (isset($_GET['sid']))

- {

- redirect(build_url(array('sid')));

- }

- if (!file_exists($filename) || @filesize($filename) === 0)

- // Get cleaned up list... return only those forums not having the f_read permission

- $forum_ary = $auth->acl_getf('!f_read', true);

- // Determine first forum the user is able to read into - for global announcement link

- $sql = 'SELECT forum_id

- FROM ' . FORUMS_TABLE . '

- WHERE forum_type = ' . FORUM_POST;

-

- if (sizeof($forum_ary))

- {

- $sql .= ' AND ' . $db->sql_in_set('forum_id', $forum_ary, true);

- }

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

- $g_forum_id = (int) $db->sql_fetchfield('forum_id');

- $db->sql_freeresult($result);

-

- WHERE t.forum_id = 0

- AND t.topic_type = " . POST_GLOBAL . '

- if ($g_forum_id)

- $topic_tracking_info = array();

- $topic_tracking_info = get_topic_tracking(0, $topic_list, $rowset, false, $topic_list);

- $topic_tracking_info = get_complete_topic_tracking(0, $topic_list, $topic_list);

- 'U_LAST_POST' => append_sid("{$phpbb_root_path}viewtopic.$phpEx", "f=$g_forum_id&amp;t=$topic_id&amp;p=" . $row['topic_last_post_id']) . '#p' . $row['topic_last_post_id'],

- 'U_NEWEST_POST' => append_sid("{$phpbb_root_path}viewtopic.$phpEx", "f=$g_forum_id&amp;t=$topic_id&amp;view=unread") . '#unread',

- 'U_VIEW_TOPIC' => append_sid("{$phpbb_root_path}viewtopic.$phpEx", "f=$g_forum_id&amp;t=$topic_id"))

- $topic_tracking_info += get_topic_tracking($f_id, $topic_row['topics'], $rowset, array($f_id => $topic_row['forum_mark_time']), ($f_id == 0) ? $global_announce_list : false);

- $topic_tracking_info += get_complete_topic_tracking($f_id, $topic_row['topics'], $global_announce_list);

- 'S_GLOBAL_TOPIC' => (!$forum_id) ? true : false,

- 'PAGINATION' => topic_generate_pagination($replies, append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . (($row['forum_id']) ? $row['forum_id'] : $forum_id) . "&amp;t=$topic_id")),

- 'U_ICQ' => ($user_info['user_icq']) ? 'http://www.icq.com/people/webmsg.php?to=' . urlencode($user_info['user_icq']) : '',

- 'lang' => array('match', false, '#^[a-z0-9_\-]{2,}$#i'),

- if (file_exists($user->lang_path . $use_lang . '/'))

- 'lang' => array('match', false, '#^[a-z_\-]{2,}$#i'),

-/**

-* A wrapper function for the normalizer which takes care of including the class if required and modifies the passed strings

-* to be in NFC (Normalization Form Composition).

-*

-* @param mixed $strings a string or an array of strings to normalize

-* @return mixed the normalized content, preserving array keys if array given.

-*/

-function utf8_normalize_nfc($strings)

- if (empty($strings))

- return $strings;

- }

- if (!class_exists('utf_normalizer'))

- {

- global $phpbb_root_path, $phpEx;

- include($phpbb_root_path . 'includes/utf/utf_normalizer.' . $phpEx);

- }

- if (!is_array($strings))

- {

- utf_normalizer::nfc($strings);

- else if (is_array($strings))

- foreach ($strings as $key => $string)

- if (is_array($string))

- foreach ($string as $_key => $_string)

- utf_normalizer::nfc($strings[$key][$_key]);

- }

- else

- {

- utf_normalizer::nfc($strings[$key]);

- }

- return $strings;