+ $super_global = ($cookie) ? '_COOKIE' : '_REQUEST';

+ if (!isset($GLOBALS[$super_global][$var_name]) || is_array($GLOBALS[$super_global][$var_name]) != is_array($default))

+ $var = $GLOBALS[$super_global][$var_name];

+ $sql_update = 'CAST(CAST(config_value as integer) + ' . (int) $increment . ' as VARCHAR(255))';

+*

+* @param int $value filesize in bytes

+* @param bool $string_only true if language string should be returned

+* @param array $allowed_units only allow these units (data array indexes)

+*

+* @return mixed data array if $string_only is false

+* @author bantu

+function get_formatted_filesize($value, $string_only = true, $allowed_units = false)

+ $available_units = array(

+ 'gb' => array(

+ 'min' => 1073741824, // pow(2, 30)

+ 'index' => 3,

+ 'si_unit' => 'GB',

+ 'iec_unit' => 'GIB',

+ ),

+ 'mb' => array(

+ 'min' => 1048576, // pow(2, 20)

+ 'index' => 2,

+ 'si_unit' => 'MB',

+ 'iec_unit' => 'MIB',

+ ),

+ 'kb' => array(

+ 'min' => 1024, // pow(2, 10)

+ 'index' => 1,

+ 'si_unit' => 'KB',

+ 'iec_unit' => 'KIB',

+ ),

+ 'b' => array(

+ 'min' => 0,

+ 'index' => 0,

+ 'si_unit' => 'BYTES', // Language index

+ 'iec_unit' => 'BYTES', // Language index

+ ),

+ );

+

+ foreach ($available_units as $si_identifier => $unit_info)

+ if (!empty($allowed_units) && $si_identifier != 'b' && !in_array($si_identifier, $allowed_units))

+ {

+ continue;

+ }

+

+ if ($value >= $unit_info['min'])

+ {

+ $unit_info['si_identifier'] = $si_identifier;

+

+ break;

+ }

+ unset($available_units);

+ for ($i = 0; $i < $unit_info['index']; $i++)

+ $value /= 1024;

+ $value = round($value, 2);

+

+ // Lookup units in language dictionary

+ $unit_info['si_unit'] = (isset($user->lang[$unit_info['si_unit']])) ? $user->lang[$unit_info['si_unit']] : $unit_info['si_unit'];

+ $unit_info['iec_unit'] = (isset($user->lang[$unit_info['iec_unit']])) ? $user->lang[$unit_info['iec_unit']] : $unit_info['iec_unit'];

+ // Default to IEC

+ $unit_info['unit'] = $unit_info['iec_unit'];

+

+ if (!$string_only)

+ $unit_info['value'] = $value;

+

+ return $unit_info;

+ return $value . ' ' . $unit_info['unit'];

+* Hashes an email address to a big integer

+*

+* @param string $email Email address

+*

+* @return string Big Integer

+*/

+function phpbb_email_hash($email)

+{

+ return crc32(strtolower($email)) . strlen($email);

+}

+

+/**

+/**

+* Test if a file/directory is writable

+*

+* This function calls the native is_writable() when not running under

+* Windows and it is not disabled.

+*

+* @param string $file Path to perform write test on

+* @return bool True when the path is writable, otherwise false.

+*/

+function phpbb_is_writable($file)

+{

+ if (strtolower(substr(PHP_OS, 0, 3)) === 'win' || !function_exists('is_writable'))

+ {

+ if (file_exists($file))

+ {

+ // Canonicalise path to absolute path

+ $file = phpbb_realpath($file);

+

+ if (is_dir($file))

+ {

+ // Test directory by creating a file inside the directory

+ $result = @tempnam($file, 'i_w');

+

+ if (is_string($result) && file_exists($result))

+ {

+ unlink($result);

+

+ // Ensure the file is actually in the directory (returned realpathed)

+ return (strpos($result, $file) === 0) ? true : false;

+ }

+ }

+ else

+ {

+ $handle = @fopen($file, 'r+');

+

+ if (is_resource($handle))

+ {

+ fclose($handle);

+ return true;

+ }

+ }

+ }

+ else

+ {

+ // file does not exist test if we can write to the directory

+ $dir = dirname($file);

+

+ if (file_exists($dir) && is_dir($dir) && phpbb_is_writable($dir))

+ {

+ return true;

+ }

+ }

+

+ return false;

+ }

+ else

+ {

+ return is_writable($file);

+ }

+}

+

+ $tz_select .= '<option title="' . $zone . '" value="' . $offset . '"' . $selected . '>' . $zone_trunc . '</option>';

+ // $forum_id[] = 0;

+* Get list of unread topics

+*

+* @param int $user_id User ID (or false for current user)

+* @param string $sql_extra Extra WHERE SQL statement

+* @param string $sql_sort ORDER BY SQL sorting statement

+* @param string $sql_limit Limits the size of unread topics list, 0 for unlimited query

+*

+* @return array[int][int] Topic ids as keys, mark_time of topic as value

+*/

+function get_unread_topics($user_id = false, $sql_extra = '', $sql_sort = '', $sql_limit = 1001)

+{

+ global $config, $db, $user;

+

+ $user_id = ($user_id === false) ? (int) $user->data['user_id'] : (int) $user_id;

+

+ // Data array we're going to return

+ $unread_topics = array();

+

+ if (empty($sql_sort))

+ {

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

+ }

+

+ if ($config['load_db_lastread'] && $user->data['is_registered'])

+ {

+ // Get list of the unread topics

+ $last_mark = $user->data['user_lastmark'];

+

+ $sql_array = array(

+ 'SELECT' => 't.topic_id, t.topic_last_post_time, tt.mark_time as topic_mark_time, ft.mark_time as forum_mark_time',

+

+ 'FROM' => array(TOPICS_TABLE => 't'),

+

+ 'LEFT_JOIN' => array(

+ array(

+ 'FROM' => array(TOPICS_TRACK_TABLE => 'tt'),

+ 'ON' => "tt.user_id = $user_id AND t.topic_id = tt.topic_id AND tt.mark_time > $last_mark",

+ ),

+ array(

+ 'FROM' => array(FORUMS_TRACK_TABLE => 'ft'),

+ 'ON' => "ft.user_id = $user_id AND t.forum_id = ft.forum_id AND ft.mark_time > $last_mark",

+ ),

+ ),

+

+ 'WHERE' => "

+ (

+ (tt.mark_time IS NOT NULL AND t.topic_last_post_time > tt.mark_time) OR

+ (tt.mark_time IS NULL AND ft.mark_time IS NOT NULL AND t.topic_last_post_time > ft.mark_time) OR

+ (

+ ((tt.mark_time IS NULL AND ft.mark_time IS NULL) OR (tt.mark_time < $last_mark AND ft.mark_time < $last_mark))

+ AND t.topic_last_post_time > $last_mark

+ )

+ )

+ $sql_extra

+ $sql_sort",

+ );

+

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

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

+

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

+ {

+ $topic_id = (int) $row['topic_id'];

+ $unread_topics[$topic_id] = ($row['topic_mark_time']) ? (int) $row['topic_mark_time'] : (($row['forum_mark_time']) ? (int) $row['forum_mark_time'] : $last_mark);

+ }

+ $db->sql_freeresult($result);

+ }

+ else if ($config['load_anon_lastread'] || $user->data['is_registered'])

+ {

+ global $tracking_topics;

+

+ if (empty($tracking_topics))

+ {

+ $tracking_topics = request_var($config['cookie_name'] . '_track', '', false, true);

+ $tracking_topics = ($tracking_topics) ? tracking_unserialize($tracking_topics) : array();

+ }

+

+ if (!$user->data['is_registered'])

+ {

+ $user_lastmark = (isset($tracking_topics['l'])) ? base_convert($tracking_topics['l'], 36, 10) + $config['board_startdate'] : 0;

+ }

+ else

+ {

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

+ }

+

+ $sql = 'SELECT t.topic_id, t.forum_id, t.topic_last_post_time

+ FROM ' . TOPICS_TABLE . ' t

+ WHERE t.topic_last_post_time > ' . $user_lastmark . "

+ $sql_extra

+ $sql_sort";

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

+

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

+ {

+ $forum_id = (int) $row['forum_id'];

+ $topic_id = (int) $row['topic_id'];

+ $topic_id36 = base_convert($topic_id, 10, 36);

+

+ if (isset($tracking_topics['t'][$topic_id36]))

+ {

+ $last_read = base_convert($tracking_topics['t'][$topic_id36], 36, 10) + $config['board_startdate'];

+

+ if ($row['topic_last_post_time'] > $last_read)

+ {

+ $unread_topics[$topic_id] = $last_read;

+ }

+ }

+ else if (isset($tracking_topics['f'][$forum_id]))

+ {

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

+

+ if ($row['topic_last_post_time'] > $mark_time)

+ {

+ $unread_topics[$topic_id] = $mark_time;

+ }

+ }

+ else

+ {

+ $unread_topics[$topic_id] = $user_lastmark;

+ }

+ }

+ $db->sql_freeresult($result);

+ }

+

+ return $unread_topics;

+}

+

+/**

+ $url_delim = (strpos($base_url, '?') === false) ? '?' : ((strpos($base_url, '?') === strlen($base_url) - 1) ? '' : '&amp;');

+ $url_parts = @parse_url($url);

+ if (strpos($url, 'sid=') !== false)

+ // All kind of links

+ $url = preg_replace('/(\?)?(&amp;|&)?sid=[a-z0-9]+/', '', $url);

+ // if the sid was the first param, make the old second as first ones

+ $url = preg_replace("/$phpEx(&amp;|&)+?/", "$phpEx?", $url);

+ // We need to be cautious here.

+ // On some situations, the redirect path is an absolute URL, sometimes a relative path

+ // For a relative path, let's prefix it with $phpbb_root_path to point to the correct location,

+ // else we use the URL directly.

+ $url_parts = @parse_url($redirect);

+

+ // URL

+ if ($url_parts !== false && !empty($url_parts['scheme']) && !empty($url_parts['host']))

+ {

+ return str_replace('&', '&amp;', $redirect);

+ }

+

+ $user_id = request_var('confirm_uid', 0);

+ 'confirm_uid' => $user->data['user_id'],

+ 'sess' => $user->session_id,

+ 'sid' => $user->session_id,

+ ));

+ page_header(((!isset($user->lang[$title])) ? $user->lang['CONFIRM'] : $user->lang[$title]), false);

+ if (!class_exists('phpbb_captcha_factory'))

+ {

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

+ }

+

+ $captcha = phpbb_captcha_factory::get_instance($config['captcha_plugin']);

+ $captcha->init(CONFIRM_LOGIN);

+ // $captcha->reset();

+ 'CAPTCHA_TEMPLATE' => $captcha->get_template(),

+ if ($redirect)

+ {

+ $s_hidden_fields['redirect'] = $redirect;

+ }

+

+ 'U_RESEND_ACTIVATION' => ($config['require_activation'] == USER_ACTIVATION_SELF && $config['email_enable']) ? append_sid("{$phpbb_root_path}ucp.$phpEx", 'mode=resend_act') : '',

+ page_header($user->lang['LOGIN'], false);

+ // In phpBB 3.1.x i want to have logging in a class to be able to control it

+ // For now, we need a quite hakish approach to circumvent logging for some actions

+ // @todo implement cleanly

+ if (!empty($GLOBALS['skip_add_log']))

+ {

+ return false;

+ }

+

+ if (error_reporting() == 0 && $errno != E_USER_ERROR && $errno != E_USER_WARNING && $errno != E_USER_NOTICE)

+ if (!defined('E_DEPRECATED'))

+ {

+ define('E_DEPRECATED', 8192);

+ }

+

+

+ // we are writing an image - the user won't see the debug, so let's place it in the log

+ if (defined('IMAGE_OUTPUT') || defined('IN_CRON'))

+ {

+ add_log('critical', 'LOG_IMAGE_GENERATION_ERROR', $errfile, $errline, $msg_text);

+ }

+ if (defined('DEBUG') || defined('IN_CRON') || defined('IMAGE_OUTPUT'))

+ {

+ // let's avoid loops

+ $db->sql_return_on_error(true);

+ add_log('critical', 'LOG_GENERAL_ERROR', $msg_title, $msg_text);

+ $db->sql_return_on_error(false);

+ }

+

+ // Do not send 200 OK, but service unavailable on errors

+ header('HTTP/1.1 503 Service Unavailable');

+

+ page_header($msg_title, false);

+

+ // PHP4 compatibility

+ case E_DEPRECATED:

+ return true;

+ break;

+* @param int $item_id Limits the search to the item with this id

+* @param string $item The name of the item which is stored in the session table as session_{$item}_id

+function obtain_guest_count($item_id = 0, $item = 'forum')

+ if ($item_id)

+ $reading_sql = ' AND s.session_' . $item . '_id = ' . (int) $item_id;

+* @param int $item_id Limits the search to the item with this id

+* @param string $item The name of the item which is stored in the session table as session_{$item}_id

+function obtain_users_online($item_id = 0, $item = 'forum')

+ if ($item_id !== 0)

+ $reading_sql = ' AND s.session_' . $item . '_id = ' . (int) $item_id;

+ $online_users['guests_online'] = obtain_guest_count($item_id, $item);

+* @param int $item_id Indicate that the data is limited to one item and not global

+* @param string $item The name of the item which is stored in the session table as session_{$item}_id

+function obtain_users_online_string($online_users, $item_id = 0, $item = 'forum')

+ // Need caps version of $item for language-strings

+ $item_caps = strtoupper($item);

+ if ($item_id === 0)

+ $l_online = ($online_users['guests_online'] === 1) ? $user->lang['BROWSING_' . $item_caps . '_GUEST'] : $user->lang['BROWSING_' . $item_caps . '_GUESTS'];

+ $online_userlist = sprintf($user->lang['BROWSING_' . $item_caps], $online_userlist);

+/**

+* Get option bitfield from custom data

+*

+* @param int $bit The bit/value to get

+* @param int $data Current bitfield to check

+* @return bool Returns true if value of constant is set in bitfield, else false

+*/

+function phpbb_optionget($bit, $data)

+{

+ return ($data & 1 << (int) $bit) ? true : false;

+}

+

+/**

+* Set option bitfield

+*

+* @param int $bit The bit/value to set/unset

+* @param bool $set True if option should be set, false if option should be unset.

+* @param int $data Current bitfield to change

+*

+* @return int The new bitfield

+*/

+function phpbb_optionset($bit, $set, $data)

+{

+ if ($set && !($data & 1 << $bit))

+ {

+ $data += 1 << $bit;

+ }

+ else if (!$set && ($data & 1 << $bit))

+ {

+ $data -= 1 << $bit;

+ }

+

+ return $data;

+}

+function page_header($page_title = '', $display_online_list = true, $item_id = 0, $item = 'forum')

+ /**

+ * Load online data:

+ * For obtaining another session column use $item and $item_id in the function-parameter, whereby the column is session_{$item}_id.

+ */

+ $item_id = max($item_id, 0);

+

+ $online_users = obtain_users_online($item_id, $item);

+ $user_online_strings = obtain_users_online_string($online_users, $item_id, $item);

+ $forum_id = request_var('f', 0);

+ $topic_id = request_var('t', 0);

+

+ $s_feed_news = false;

+

+ // Get option for news

+ if ($config['feed_enable'])

+ {

+ $sql = 'SELECT forum_id

+ FROM ' . FORUMS_TABLE . '

+ WHERE ' . $db->sql_bit_and('forum_options', FORUM_OPTION_FEED_NEWS, '<> 0');

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

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

+ $db->sql_freeresult($result);

+ }

+

+ // Determine board url - we may need it later

+ $board_url = generate_board_url() . '/';

+ $web_path = (defined('PHPBB_USE_BOARD_URL_PATH') && PHPBB_USE_BOARD_URL_PATH) ? $board_url : $phpbb_root_path;

+

+ 'S_USER_NEW' => $user->data['user_new'],

+ 'BOARD_URL' => $board_url,

+ 'U_SEARCH_UNREAD' => append_sid("{$phpbb_root_path}search.$phpEx", 'search_id=unreadposts'),

+ 'U_TERMS_USE' => append_sid("{$phpbb_root_path}ucp.$phpEx", 'mode=terms'),

+ 'U_PRIVACY' => append_sid("{$phpbb_root_path}ucp.$phpEx", 'mode=privacy'),

+ 'U_FEED' => generate_board_url() . "/feed.$phpEx",

+ 'S_FORUM_ID' => $forum_id,

+ 'S_TOPIC_ID' => $topic_id,

+

+ 'S_LOGIN_ACTION' => (!defined('ADMIN_START')) ? append_sid("{$phpbb_root_path}ucp.$phpEx", 'mode=login') . '&amp;redirect=' . urlencode(str_replace('&amp;', '&', build_url())) : append_sid("index.$phpEx", false, true, $user->session_id) . '&amp;redirect=' . urlencode(str_replace('&amp;', '&', build_url())),

+

+ 'S_ENABLE_FEEDS' => ($config['feed_enable']) ? true : false,

+ 'S_ENABLE_FEEDS_FORUMS' => ($config['feed_overall_forums']) ? true : false,

+ 'S_ENABLE_FEEDS_TOPICS' => ($config['feed_overall_topics']) ? true : false,

+ 'S_ENABLE_FEEDS_NEWS' => ($s_feed_news) ? true : false,

+

+ 'T_THEME_PATH' => "{$web_path}styles/" . $user->theme['theme_path'] . '/theme',

+ 'T_TEMPLATE_PATH' => "{$web_path}styles/" . $user->theme['template_path'] . '/template',

+ 'T_SUPER_TEMPLATE_PATH' => (isset($user->theme['template_inherit_path']) && $user->theme['template_inherit_path']) ? "{$web_path}styles/" . $user->theme['template_inherit_path'] . '/template' : "{$web_path}styles/" . $user->theme['template_path'] . '/template',

+ 'T_IMAGESET_PATH' => "{$web_path}styles/" . $user->theme['imageset_path'] . '/imageset',

+ 'T_IMAGESET_LANG_PATH' => "{$web_path}styles/" . $user->theme['imageset_path'] . '/imageset/' . $user->data['user_lang'],

+ 'T_IMAGES_PATH' => "{$web_path}images/",

+ 'T_SMILIES_PATH' => "{$web_path}{$config['smilies_path']}/",

+ 'T_AVATAR_PATH' => "{$web_path}{$config['avatar_path']}/",

+ 'T_AVATAR_GALLERY_PATH' => "{$web_path}{$config['avatar_gallery_path']}/",

+ 'T_ICONS_PATH' => "{$web_path}{$config['icons_path']}/",

+ 'T_RANKS_PATH' => "{$web_path}{$config['ranks_path']}/",

+ 'T_UPLOAD_PATH' => "{$web_path}{$config['upload_path']}/",

+ 'T_STYLESHEET_LINK' => (!$user->theme['theme_storedb']) ? "{$web_path}styles/" . $user->theme['theme_path'] . '/theme/stylesheet.css' : append_sid("{$phpbb_root_path}style.$phpEx", 'id=' . $user->theme['style_id'] . '&amp;lang=' . $user->data['user_lang']),

+ 'T_THEME_NAME' => $user->theme['theme_path'],

+ 'T_TEMPLATE_NAME' => $user->theme['template_path'],

+ 'T_SUPER_TEMPLATE_NAME' => (isset($user->theme['template_inherit_path']) && $user->theme['template_inherit_path']) ? $user->theme['template_inherit_path'] : $user->theme['template_path'],

+ 'T_IMAGESET_NAME' => $user->theme['imageset_path'],

+ 'T_IMAGESET_LANG_NAME' => $user->data['user_lang'],

+ 'T_IMAGES' => 'images',

+ 'T_SMILIES' => $config['smilies_path'],

+ 'T_AVATAR' => $config['avatar_path'],

+ 'T_AVATAR_GALLERY' => $config['avatar_gallery_path'],

+ 'T_ICONS' => $config['icons_path'],

+ 'T_RANKS' => $config['ranks_path'],

+ 'T_UPLOAD' => $config['upload_path'],

+

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

+ $call_cron = false;

+ $call_cron = true;

+ $time_now = (!empty($user->time_now) && is_int($user->time_now)) ? $user->time_now : time();

+

+ // Any old lock present?

+ if (!empty($config['cron_lock']))

+ {

+ $cron_time = explode(' ', $config['cron_lock']);

+

+ // If 1 hour lock is present we do not call cron.php

+ if ($cron_time[0] + 3600 >= $time_now)

+ {

+ $call_cron = false;

+ }

+ }

+ }

+

+ // Call cron job?

+ if ($call_cron)

+ {

+ if ($time_now - $config['queue_interval'] > $config['last_queue_run'] && !defined('IN_ADMIN') && file_exists($phpbb_root_path . 'cache/queue.' . $phpEx))

+ else if (method_exists($cache, 'tidy') && $time_now - $config['cache_gc'] > $config['cache_last_gc'])

+ else if ($config['warnings_expire_days'] && ($time_now - $config['warnings_gc'] > $config['warnings_last_gc']))

+ else if ($time_now - $config['database_gc'] > $config['database_last_gc'])

+ else if ($time_now - $config['search_gc'] > $config['search_last_gc'])

+ else if ($time_now - $config['session_gc'] > $config['session_last_gc'])