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

+*

+* @return string

+ // [a, z] + [0, 9] = 36

+ return substr(strtoupper(base_convert(unique_id(), 16, 36)), 0, $num_chars);

+}

+

+/**

+* Generates a user-friendly alphanumeric random string of given length

+* We remove 0 and O so users cannot confuse those in passwords etc.

+*

+* @return string

+*/

+function gen_rand_string_friendly($num_chars = 8)

+{

+

+ // Remove Z and Y from the base_convert(), replace 0 with Z and O with Y

+ // [a, z] + [0, 9] - {z, y} = [a, z] + [0, 9] - {0, o} = 34

+ if (is_readable($filename) && phpbb_is_writable($filename))

+ if ((!($perms & CHMOD_READ) || is_readable($filename)) && (!($perms & CHMOD_WRITE) || phpbb_is_writable($filename)))

+ if ((!($perms & CHMOD_READ) || is_readable($filename)) && (!($perms & CHMOD_WRITE) || phpbb_is_writable($filename)))

+* @param string $sql_limit_offset Sets the offset of the first row to search, 0 to search from the start

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

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

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

+ if ($key === '')

+ {

+ continue;

+ }

+

+/**

+* Outputs correct status line header.

+*

+* Depending on php sapi one of the two following forms is used:

+*

+* Status: 404 Not Found

+*

+* HTTP/1.x 404 Not Found

+*

+* HTTP version is taken from HTTP_VERSION environment variable,

+* and defaults to 1.0.

+*

+* Sample usage:

+*

+* send_status_line(404, 'Not Found');

+*

+* @param int $code HTTP status code

+* @param string $message Message for the status code

+* @return void

+*/

+function send_status_line($code, $message)

+{

+ if (substr(strtolower(@php_sapi_name()), 0, 3) === 'cgi')

+ {

+ // in theory, we shouldn't need that due to php doing it. Reality offers a differing opinion, though

+ header("Status: $code $message", true, $code);

+ }

+ else

+ {

+ if (isset($_SERVER['HTTP_VERSION']))

+ {

+ $version = $_SERVER['HTTP_VERSION'];

+ }

+ else

+ {

+ $version = 'HTTP/1.0';

+ }

+ header("$version $code $message", true, $code);

+ }

+}

+

+ // Regex written by James Watts and Francisco Jose Martin Moreno

+ // http://fightingforalostcause.net/misc/2006/compare-email-regex.php

+ return '([\w\!\#$\%\&\'\*\+\-\/\=\?\^\`{\|\}\~]+\.)*(?:[\w\!\#$\%\'\*\+\-\/\=\?\^\`{\|\}\~]|&)+@((((([a-z0-9]{1}[a-z0-9\-]{0,62}[a-z0-9]{1})|[a-z])\.)+[a-z]{2,6})|(\d{1,3}\.){3}\d{1,3}(\:\d{1,5})?)';

+ return '#^(?:(?:(?:[\dA-F]{1,4}:){6}(?:[\dA-F]{1,4}:[\dA-F]{1,4}|(?:(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])\.){3}(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])))|(?:::(?:[\dA-F]{1,4}:){0,5}(?:[\dA-F]{1,4}(?::[\dA-F]{1,4})?|(?:(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])\.){3}(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])))|(?:(?:[\dA-F]{1,4}:):(?:[\dA-F]{1,4}:){4}(?:[\dA-F]{1,4}:[\dA-F]{1,4}|(?:(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])\.){3}(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])))|(?:(?:[\dA-F]{1,4}:){1,2}:(?:[\dA-F]{1,4}:){3}(?:[\dA-F]{1,4}:[\dA-F]{1,4}|(?:(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])\.){3}(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])))|(?:(?:[\dA-F]{1,4}:){1,3}:(?:[\dA-F]{1,4}:){2}(?:[\dA-F]{1,4}:[\dA-F]{1,4}|(?:(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])\.){3}(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])))|(?:(?:[\dA-F]{1,4}:){1,4}:(?:[\dA-F]{1,4}:)(?:[\dA-F]{1,4}:[\dA-F]{1,4}|(?:(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])\.){3}(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])))|(?:(?:[\dA-F]{1,4}:){1,5}:(?:[\dA-F]{1,4}:[\dA-F]{1,4}|(?:(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])\.){3}(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])))|(?:(?:[\dA-F]{1,4}:){1,6}:[\dA-F]{1,4})|(?:(?:[\dA-F]{1,4}:){1,7}:)|(?:::))$#i';

+* @param string $host Fully-Qualified Domain Name

+* @param string $type Resource record type to lookup

+* Supported types are: MX (default), A, AAAA, NS, TXT, CNAME

+* Other types may work or may not work

+* @return mixed true if entry found,

+* false if entry not found,

+* null if this function is not supported by this environment

+*

+* Since null can also be returned, you probably want to compare the result

+* with === true or === false,

+*

+* @author bantu

+function phpbb_checkdnsrr($host, $type = 'MX')

+ // The dot indicates to search the DNS root (helps those having DNS prefixes on the same domain)

+ if (substr($host, -1) == '.')

+ {

+ $host_fqdn = $host;

+ $host = substr($host, 0, -1);

+ }

+ else

+ {

+ $host_fqdn = $host . '.';

+ }

+ // $host has format some.host.example.com

+ // $host_fqdn has format some.host.example.com.

+ // If we're looking for an A record we can use gethostbyname()

+ if ($type == 'A' && function_exists('gethostbyname'))

+ return (@gethostbyname($host_fqdn) == $host_fqdn) ? false : true;

+ }

+

+ // checkdnsrr() is available on Windows since PHP 5.3,

+ // but until 5.3.3 it only works for MX records

+ // See: http://bugs.php.net/bug.php?id=51844

+

+ // Call checkdnsrr() if

+ // we're looking for an MX record or

+ // we're not on Windows or

+ // we're running a PHP version where #51844 has been fixed

+

+ // checkdnsrr() supports AAAA since 5.0.0

+ // checkdnsrr() supports TXT since 5.2.4

+ if (

+ ($type == 'MX' || DIRECTORY_SEPARATOR != '\\' || version_compare(PHP_VERSION, '5.3.3', '>=')) &&

+ ($type != 'AAAA' || version_compare(PHP_VERSION, '5.0.0', '>=')) &&

+ ($type != 'TXT' || version_compare(PHP_VERSION, '5.2.4', '>=')) &&

+ function_exists('checkdnsrr')

+ )

+ {

+ return checkdnsrr($host_fqdn, $type);

+ }

+

+ // dns_get_record() is available since PHP 5; since PHP 5.3 also on Windows,

+ // but on Windows it does not work reliable for AAAA records before PHP 5.3.1

+

+ // Call dns_get_record() if

+ // we're not looking for an AAAA record or

+ // we're not on Windows or

+ // we're running a PHP version where AAAA lookups work reliable

+ if (

+ ($type != 'AAAA' || DIRECTORY_SEPARATOR != '\\' || version_compare(PHP_VERSION, '5.3.1', '>=')) &&

+ function_exists('dns_get_record')

+ )

+ {

+ // dns_get_record() expects an integer as second parameter

+ // We have to convert the string $type to the corresponding integer constant.

+ $type_constant = 'DNS_' . $type;

+ $type_param = (defined($type_constant)) ? constant($type_constant) : DNS_ANY;

+

+ // dns_get_record() might throw E_WARNING and return false for records that do not exist

+ $resultset = @dns_get_record($host_fqdn, $type_param);

+

+ if (empty($resultset) || !is_array($resultset))

+ return false;

+ }

+ else if ($type_param == DNS_ANY)

+ {

+ // $resultset is a non-empty array

+ return true;

+ }

+

+ foreach ($resultset as $result)

+ {

+ if (

+ isset($result['host']) && $result['host'] == $host &&

+ isset($result['type']) && $result['type'] == $type

+ )

+ {

+ return true;

+ }

+ return false;

+ }

+

+ // If we're on Windows we can still try to call nslookup via exec() as a last resort

+ if (DIRECTORY_SEPARATOR == '\\' && function_exists('exec'))

+ {

+ @exec('nslookup -type=' . escapeshellarg($type) . ' ' . escapeshellarg($host_fqdn), $output);

+ $line = trim($line);

+

+ if (empty($line))

+ // Squash tabs and multiple whitespaces to a single whitespace.

+ $line = preg_replace('/\s+/', ' ', $line);

+

+ switch ($type)

+ case 'MX':

+ if (stripos($line, "$host MX") === 0)

+ {

+ return true;

+ }

+ break;

+

+ case 'NS':

+ if (stripos($line, "$host nameserver") === 0)

+ {

+ return true;

+ }

+ break;

+

+ case 'TXT':

+ if (stripos($line, "$host text") === 0)

+ {

+ return true;

+ }

+ break;

+

+ case 'CNAME':

+ if (stripos($line, "$host canonical name") === 0)

+ {

+ return true;

+ }

+

+ default:

+ case 'A':

+ case 'AAAA':

+ if (!empty($host_matches))

+ {

+ // Second line

+ if (stripos($line, "Address: ") === 0)

+ {

+ return true;

+ }

+ else

+ {

+ $host_matches = false;

+ }

+ }

+ else if (stripos($line, "Name: $host") === 0)

+ {

+ // First line

+ $host_matches = true;

+ }

+ break;

+ send_status_line(503, 'Service Unavailable');

+ if ($msg_text == 'ERROR_NO_ATTACHMENT' || $msg_text == 'NO_FORUM' || $msg_text == 'NO_TOPIC' || $msg_text == 'NO_USER')

+ {

+ send_status_line(404, 'Not Found');

+ }

+

+ send_status_line(401, 'Unauthorized');

+

+ send_status_line(401, 'Unauthorized');

+ 'S_LOAD_UNREADS' => ($config['load_unreads_search'] && ($config['load_anon_lastread'] || $user->data['is_registered'])) ? true : false,

+

+ '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'] . '&lang=' . $user->data['user_lang']),