+ $row['group_name'] = (isset($user->lang['EXT_GROUP_' . $row['group_name']])) ? $user->lang['EXT_GROUP_' . $row['group_name']] : $row['group_name'];

+ if ($group_id)

+ {

+ $sql .= ' AND group_id <> ' . $group_id;

+ }

+ $group_name = (isset($user->lang['EXT_GROUP_' . $group_name])) ? $user->lang['EXT_GROUP_' . $group_name] : $group_name;

+ 'GROUP_NAME' => (isset($user->lang['EXT_GROUP_' . $row['group_name']])) ? $user->lang['EXT_GROUP_' . $row['group_name']] : $row['group_name'],

+ $row['group_name'] = (isset($user->lang['EXT_GROUP_' . $row['group_name']])) ? $user->lang['EXT_GROUP_' . $row['group_name']] : $row['group_name'];

+ 'A_REASON' => addslashes($reason),

+ 'A_REASON' => addslashes($reason),

+ 'board_timezone' => array('lang' => 'SYSTEM_TIMEZONE', 'validate' => 'string', 'type' => 'select', 'function' => 'tz_select', 'params' => array('{CONFIG_VALUE}', 1), 'explain' => true),

+ $user->timezone = $config['board_timezone'] * 3600;

+ $user->dst = $config['board_dst'] * 3600;

+ trigger_error($user->lang['CAPTCHA_UNAVAILABLE'] . adm_back_link($this->u_action), E_USER_WARNING);

+ trigger_error($user->lang['FORM_INVALID'] . adm_back_link(), E_USER_WARNING);

+ case 'mssqlnative':

+ $forum_data['show_active'] = ($forum_data['forum_type'] == FORUM_POST) ? request_var('display_recent', true) : request_var('display_active', false);

+ $copied_permissions = false;

+ $copied_permissions = true;

+ if ($auth->acl_get('a_fauth') && !$copied_permissions)

+ if ($action == 'add' && !$copied_permissions && $auth->acl_get('a_fauth'))

+ $parents_list = make_forum_select($forum_data['parent_id'], $exclude_forums, false, false, false);

+ $parents_list = make_forum_select($this->parent_id, false, false, false, false);

+ 'S_DISPLAY_ACTIVE_TOPICS' => ($forum_data['forum_type'] == FORUM_POST) ? ($forum_data['forum_flags'] & FORUM_FLAG_ACTIVE_TOPICS) : true,

+ 'S_ENABLE_ACTIVE_TOPICS' => ($forum_data['forum_type'] == FORUM_CAT) ? ($forum_data['forum_flags'] & FORUM_FLAG_ACTIVE_TOPICS) : false,

+ trigger_error($user->lang['PARENT_NOT_EXIST'] . adm_back_link($this->u_action . '&amp;parent_id=' . $this->parent_id), E_USER_WARNING);

+ // Amount of rows we select and delete in one iteration.

+ $batch_size = 500;

+

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

+ while (sizeof($ids) == $batch_size);

+

+ phpinfo(INFO_GENERAL | INFO_CONFIGURATION | INFO_MODULES | INFO_VARIABLES);

+ case 'mssqlnative':

+ 'users' => utf8_normalize_nfc(request_var('users', '', true)),

+ 'username' => utf8_normalize_nfc(request_var('username', '', true)),

+ $users = utf8_normalize_nfc(request_var('users', '', true));

+ $username = utf8_normalize_nfc(request_var('username', '', true));

+ case 'mssqlnative':

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

+ if ($delete_type)

+ if (confirm_box(true))

+ {

+ user_delete($delete_type, $user_id, $user_row['username']);

+ add_log('admin', 'LOG_USER_DELETED', $user_row['username']);

+ trigger_error($user->lang['USER_DELETED'] . adm_back_link($this->u_action));

+ }

+ else

+ {

+ confirm_box(false, $user->lang['CONFIRM_OPERATION'], build_hidden_fields(array(

+ 'u' => $user_id,

+ 'i' => $id,

+ 'mode' => $mode,

+ 'action' => $action,

+ 'update' => true,

+ 'delete' => 1,

+ 'delete_type' => $delete_type))

+ );

+ }

+ trigger_error($user->lang['NO_MODE'] . adm_back_link($this->u_action . '&amp;u=' . $user_id), E_USER_WARNING);

+ if ($user_id == ANONYMOUS)

+ {

+ trigger_error($user->lang['CANNOT_BAN_ANONYMOUS'] . adm_back_link($this->u_action . '&amp;u=' . $user_id), E_USER_WARNING);

+ }

+

+ // Check if user has an active session

+ if ($user_row['session_id'])

+ {

+ // We'll update the session if user_allow_viewonline has changed and the user is a bot

+ // Or if it's a regular user and the admin set it to hide the session

+ if ($user_row['user_allow_viewonline'] != $sql_ary['user_allow_viewonline'] && $user_row['user_type'] == USER_IGNORE

+ || $user_row['user_allow_viewonline'] && !$sql_ary['user_allow_viewonline'])

+ {

+ // We also need to check if the user has the permission to cloak.

+ $user_auth = new auth();

+ $user_auth->acl($user_row);

+

+ $session_sql_ary = array(

+ 'session_viewonline' => ($user_auth->acl_get('u_hideonline')) ? $sql_ary['user_allow_viewonline'] : true,

+ );

+

+ $sql = 'UPDATE ' . SESSIONS_TABLE . '

+ SET ' . $db->sql_build_array('UPDATE', $session_sql_ary) . "

+ WHERE session_user_id = $user_id";

+ $db->sql_query($sql);

+

+ unset($user_auth);

+ }

+ }

+

+ if (avatar_process_user($error, $user_row, $can_upload))

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

+ 'post' => array('title' => 'ACP_POST_SETTINGS', 'auth' => 'acl_a_board', 'cat' => array('ACP_BOARD_CONFIGURATION', 'ACP_MESSAGES')),

+ return $user->lang['LDAP_SEARCH_FAILED'];

+// Notify status

+define('NOTIFY_YES', 0);

+define('NOTIFY_NO', 1);

+

+ * @param bool $use_cache forced to false for Interbase

+ function sql_server_info($raw = false, $use_cache = true)

+ /**

+ * force $use_cache false. I didn't research why the caching code there is no caching code

+ * but I assume its because the IB extension provides a direct method to access it

+ * without a query.

+ */

+

+ $use_cache = false;

+

+ * @param bool $use_cache If true, it is safe to retrieve the value from the cache

+ function sql_server_info($raw = false, $use_cache = true)

+ if (!$use_cache || empty($cache) || ($this->sql_server_version = $cache->get('mssql_version')) === false)

+ if (!empty($cache) && $use_cache)

+ * @param bool $use_cache If true, it is safe to retrieve the value from the cache

+ function sql_server_info($raw = false, $use_cache = true)

+ if (!$use_cache || empty($cache) || ($this->sql_server_version = $cache->get('mssqlodbc_version')) === false)

+ if (!empty($cache) && $use_cache)

+ * @param bool $use_cache If true, it is safe to retrieve the value from the cache

+ function sql_server_info($raw = false, $use_cache = true)

+ if (!$use_cache || empty($cache) || ($this->sql_server_version = $cache->get('mssql_version')) === false)

+ if (!empty($cache) && $use_cache)

+ * @param bool $use_cache If true, it is safe to retrieve the value from the cache

+ function sql_server_info($raw = false, $use_cache = true)

+ if (!$use_cache || empty($cache) || ($this->sql_server_version = $cache->get('mysql_version')) === false)

+ if (!empty($cache) && $use_cache)

+ * @param bool $use_cache If true, it is safe to retrieve the value from the cache

+ function sql_server_info($raw = false, $use_cache = true)

+ if (!$use_cache || empty($cache) || ($this->sql_server_version = $cache->get('mysqli_version')) === false)

+ if (!empty($cache) && $use_cache)

+ * @param bool $use_cache forced to false for Oracle

+ function sql_server_info($raw = false, $use_cache = true)

+ /**

+ * force $use_cache false. I didn't research why the caching code below is commented out

+ * but I assume its because the Oracle extension provides a direct method to access it

+ * without a query.

+ */

+

+ $use_cache = false;

+/* The code inside this comment block breaks clob handling, but does allow the

+ database restore script to work. If you want to allow no posts longer than 4KB

+ and/or need the db restore script, uncomment this.

+

+*/

+ // $sqlserver can carry a port separated by : for compatibility reasons

+ // If $sqlserver has more than one : it's probably an IPv6 address.

+ // In this case we only allow passing a port via the $port variable.

+ if (substr_count($sqlserver, ':') === 1)

+ if ($this->persistency)

+ {

+ $this->db_connect_id = (!$new_link) ? @pg_pconnect($connect_string) : @pg_pconnect($connect_string, PGSQL_CONNECT_FORCE_NEW);

+ }

+ else

+ {

+ $this->db_connect_id = (!$new_link) ? @pg_connect($connect_string) : @pg_connect($connect_string, PGSQL_CONNECT_FORCE_NEW);

+ }

+ * @param bool $use_cache If true, it is safe to retrieve the value from the cache

+ function sql_server_info($raw = false, $use_cache = true)

+ if (!$use_cache || empty($cache) || ($this->sql_server_version = $cache->get('pgsql_version')) === false)

+ if (!empty($cache) && $use_cache)

+ * @param bool $use_cache if true, it is safe to retrieve the stored value from the cache

+ function sql_server_info($raw = false, $use_cache = true)

+ if (!$use_cache || empty($cache) || ($this->sql_server_version = $cache->get('sqlite_version')) === false)

+

+ if (!empty($cache) && $use_cache)

+ {

+ $cache->put('sqlite_version', $this->sql_server_version);

+ }

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

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

+/**

+* 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\!\#$\%\'\*\+\-\/\=\?\^\`{\|\}\~]|&amp;)+@((((([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';

+ // Call checkdnsrr() if available. This is also the case on Windows with PHP 5.3 or later.

+ if (function_exists('checkdnsrr'))

+ {

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

+ return checkdnsrr($host . '.', $type);

+ }

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

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

+ {

+ send_status_line(404, 'Not Found');

+ }

+

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

+ if (!$ignore_acl && $auth->acl_gets(array('f_list', 'a_forum', 'a_forumadd', 'a_forumdel'), $row['forum_id']))

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

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

+ SET forum_id = ' . (int) $forum_row['forum_id'] . ", topic_id = $topic_id

+ $forum_ids[] = (int) $forum_row['forum_id'];

+ $table_ary = array(BOOKMARKS_TABLE, TOPICS_TRACK_TABLE, TOPICS_POSTED_TABLE, POLL_VOTES_TABLE, POLL_OPTIONS_TABLE, TOPICS_WATCH_TABLE, TOPICS_TABLE);

+ 'sig_bbcode' => array('bit' => 15, 'default' => 1),

+ 'sig_smilies' => array('bit' => 16, 'default' => 1),

+ 'sig_links' => array('bit' => 17, 'default' => 1),

+ $folder_alt = ($forum_unread) ? 'UNREAD_POSTS' : 'NO_UNREAD_POSTS';

+ $s_subforums_list[] = '<a href="' . $subforum['link'] . '" class="subforum ' . (($subforum['unread']) ? 'unread' : 'read') . '" title="' . (($subforum['unread']) ? $user->lang['UNREAD_POSTS'] : $user->lang['NO_UNREAD_POSTS']) . '">' . $subforum['name'] . '</a>';

+ $folder_alt = ($unread_topic) ? 'UNREAD_POSTS' : (($topic_row['topic_status'] == ITEM_LOCKED) ? 'TOPIC_LOCKED' : 'NO_UNREAD_POSTS');

+ $fid_m_approve = $auth->acl_getf('m_approve', true);

+ $sql_m_approve = (!empty($fid_m_approve)) ? 'OR ' . $db->sql_in_set('forum_id', array_keys($fid_m_approve)) : '';

+

+ AND (post_approved = 1

+ $sql_m_approve)

+ AND (post_approved = 1

+ $sql_m_approve)

+ if ($notify_status != NOTIFY_YES)

+ SET notify_status = " . NOTIFY_YES . "

+ VALUES ($user_id, $match_id, " . NOTIFY_YES . ')';

+ /*

+ * This code is commented out because it causes problems on some web hosts.

+ * The core problem is rather restrictive email sending limits.

+ * This code is nly useful if you have no such restrictions from the

+ * web host and the package size setting is wrong.

+

+ */

+ 'S_CHECKED' => ($cur_topic_type == POST_NORMAL) ? ' checked="checked"' : '',

+ unset($rowset[$post_list[$i]]);

+ AND w.notify_status = " . NOTIFY_YES . '

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

+ AND fw.notify_status = " . NOTIFY_YES . '

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

+ $sql = 'UPDATE ' . TOPICS_WATCH_TABLE . '

+ SET notify_status = ' . NOTIFY_NO . "

+ $sql = 'UPDATE ' . FORUMS_WATCH_TABLE . '

+ SET notify_status = ' . NOTIFY_NO . "

+ case 'mssqlnative':

+ $block = @fread($fsock, 1024);

+ $filesize += strlen($block);

+

+ if ($this->max_filesize && $filesize > $this->max_filesize)

+ {

+ $max_filesize = get_formatted_filesize($this->max_filesize, false);

+

+ $file = new fileerror(sprintf($user->lang[$this->error_prefix . 'WRONG_FILESIZE'], $max_filesize['value'], $max_filesize['unit']));

+ return $file;

+ }

+

+ $data .= $block;

+ else if ($this->max_filesize && stripos($line, 'content-length: ') !== false)

+ {

+ $length = (int) str_replace('content-length: ', '', strtolower($line));

+

+ if ($length && $length > $this->max_filesize)

+ {

+ $max_filesize = get_formatted_filesize($this->max_filesize, false);

+

+ $file = new fileerror(sprintf($user->lang[$this->error_prefix . 'WRONG_FILESIZE'], $max_filesize['value'], $max_filesize['unit']));

+ return $file;

+ }

+ }

+ $user_row['group_id'] = $add_group_id;

+ $table_ary = array(USERS_TABLE, USER_GROUP_TABLE, TOPICS_WATCH_TABLE, FORUMS_WATCH_TABLE, ACL_USERS_TABLE, TOPICS_TRACK_TABLE, TOPICS_POSTED_TABLE, FORUMS_TRACK_TABLE, PROFILE_FIELDS_DATA_TABLE, MODERATOR_CACHE_TABLE, DRAFTS_TABLE, BOOKMARKS_TABLE, SESSIONS_KEYS_TABLE, PRIVMSGS_FOLDER_TABLE, PRIVMSGS_RULES_TABLE);

+ // Do not allow banning yourself, the guest account, or founders.

+ $non_bannable = array($user->data['user_id'], ANONYMOUS);

+ $sql .= ' AND ' . $db->sql_in_set('user_id', array_merge(array_keys($founder), $non_bannable), true);

+ $sql .= ' AND ' . $db->sql_in_set('user_id', $non_bannable, true);

+function avatar_process_user(&$error, $custom_userdata = false, $can_upload = null)

+ if (is_null($can_upload))

+ {

+ $can_upload = ($config['allow_avatar_upload'] && file_exists($phpbb_root_path . $config['avatar_path']) && @is_writable($phpbb_root_path . $config['avatar_path']) && $change_avatar && (@ini_get('file_uploads') || strtolower(@ini_get('file_uploads')) == 'on')) ? true : false;

+ }

+ list($sql_ary['user_avatar_width'], $sql_ary['user_avatar_height']) = getimagesize($phpbb_root_path . $config['avatar_gallery_path'] . '/' . $category . '/' . urldecode($sql_ary['user_avatar']));

+ 'MINI_POST_IMG' => ($post_unread) ? $user->img('icon_post_target_unread', 'UNREAD_POST') : $user->img('icon_post_target', 'POST'),

+ 'MINI_POST_IMG' => ($post_unread) ? $user->img('icon_post_target_unread', 'UNREAD_POST') : $user->img('icon_post_target', 'POST'),

+ if ($config['email_enable'] || $config['jab_enable'])

+ foreach ($post_info as $post_data)

+ if ($post_data['poster_id'] == ANONYMOUS)

+ {

+ continue;

+ }

+ else

+ {

+ $show_notify = true;

+ break;

+ }

+ 'MINI_POST_IMG' => ($post_unread) ? $user->img('icon_post_target_unread', 'UNREAD_POST') : $user->img('icon_post_target', 'POST'),

+ 'MINI_POST_IMG' => ($post_unread) ? $user->img('icon_post_target_unread', 'UNREAD_POST') : $user->img('icon_post_target', 'POST'),

+ $stats = @getimagesize(htmlspecialchars_decode($in));

+ $match = array('#\sand\s#iu', '#\sor\s#iu', '#\snot\s#iu', '#(^|\s)\+#', '#(^|\s)-#', '#(^|\s)\|#');

+ // Show date <= 1 hour ago as 'xx min ago' but not greater than 60 seconds in the future

+ if ($delta <= 3600 && $delta > -60 && ($delta >= -5 || (($now / 60) % 60) == (($gmepoch / 60) % 60)) && $date_cache[$format]['is_short'] !== false && !$forcedate && isset($this->lang['datetime']['AGO']))

+ $folder_alt = ($unread_topic) ? 'UNREAD_POSTS' : (($row['topic_status'] == ITEM_LOCKED) ? 'TOPIC_LOCKED' : 'NO_UNREAD_POSTS');

+ $folder_alt = ($unread_forum) ? 'UNREAD_POSTS' : 'NO_UNREAD_POSTS';

+ 'S_BBCODE_ALLOWED' => ($bbcode_status) ? 1 : 0,

+ 'S_PM_REPORTED' => (isset($row['report_id'])) ? true : false,

+ 'U_MCP_REPORT' => (isset($row['report_id'])) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=pm_reports&amp;mode=pm_report_details&amp;r=' . $row['report_id']) : '',

+ 'REPORTED_IMG' => $user->img('icon_topic_reported', 'PM_REPORTED'),

+ $sql = 'SELECT t.*, p.root_level, p.message_time, p.message_subject, p.icon_id, p.to_address, p.message_attachment, p.bcc_address, u.username, u.username_clean, u.user_colour, p.message_reported

+ $pm_reported = array();

+ if ($row['message_reported'])

+ {

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

+ }

+ // Fetch the report_ids, if there are any reported pms.

+ if (!empty($pm_reported) && $auth->acl_getf_global('m_report'))

+ {

+ $sql = 'SELECT pm_id, report_id

+ FROM ' . REPORTS_TABLE . '

+ WHERE report_closed = 0

+ AND ' . $db->sql_in_set('pm_id', $pm_reported);

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

+

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

+ {

+ $rowset[$row['pm_id']]['report_id'] = $row['report_id'];

+ }

+ $db->sql_freeresult($result);

+ }

+

+ if (avatar_process_user($error, false, $can_upload))