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

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

+ // Delete shadow topics pointing to topics in this forum

+ delete_topic_shadows($forum_id);

+

+ if ($user_id == ANONYMOUS)

+ {

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

+ }

+

+ $user_actkey = gen_rand_string(mt_rand(6, 10));

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

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

+ // Unescape the asterisk to simplify further conversions

+ $row['word'] = str_replace('\*', '*', preg_quote($row['word'], '#'));

+

+ // Replace the asterisk inside the pattern, at the start and at the end of it with regexes

+ $row['word'] = preg_replace(array('#(?<=[\p{Nd}\p{L}_])\*(?=[\p{Nd}\p{L}_])#iu', '#^\*#', '#\*$#'), array('([\x20]*?|[\p{Nd}\p{L}_-]*?)', '[\p{Nd}\p{L}_-]*?', '[\p{Nd}\p{L}_-]*?'), $row['word']);

+

+ // Generate the final substitution

+ $censors['match'][] = '#(?<![\p{Nd}\p{L}_-])(' . $row['word'] . ')(?![\p{Nd}\p{L}_-])#iu';

+ $this->code = gen_rand_string_friendly(mt_rand(CAPTCHA_MIN_CHARS, CAPTCHA_MAX_CHARS));

+ $this->code = gen_rand_string_friendly(mt_rand(CAPTCHA_MIN_CHARS, CAPTCHA_MAX_CHARS));

+ $this->code = gen_rand_string_friendly(mt_rand(CAPTCHA_MIN_CHARS, CAPTCHA_MAX_CHARS));

+ $this->code = gen_rand_string_friendly(mt_rand(CAPTCHA_MIN_CHARS, CAPTCHA_MAX_CHARS));

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

+ $code = 0;

+ $code = $error['code'];

+

+ return array(

+ 'message' => $error,

+ 'code' => $code,

+ );

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

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

+ }

+*

+* @return string

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

+ return strtoupper(base_convert(unique_id(), 16, 36));

+}

+

+/**

+* 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 ($key === '')

+ {

+ continue;

+ }

+

+ // 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})?)';

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

+ $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'];

+* Deletes shadow topics pointing to a specified forum.

+*

+* @param int $forum_id The forum id

+* @param string $sql_more Additional WHERE statement, e.g. t.topic_time < (time() - 1234)

+* @param bool $auto_sync Will call sync() if this is true

+*

+* @return array Array with affected forums

+*

+* @author bantu

+function delete_topic_shadows($forum_id, $sql_more = '', $auto_sync = true)

+ global $db;

+ if (!$forum_id)

+ // Nothing to do.

+ return;

+ }

+ // Set of affected forums we have to resync

+ $sync_forum_ids = array();

+ // Amount of topics we select and delete at once.

+ $batch_size = 500;

+ do

+ {

+ $sql = 'SELECT t2.forum_id, t2.topic_id

+ FROM ' . TOPICS_TABLE . ' t2, ' . TOPICS_TABLE . ' t

+ WHERE t2.topic_moved_id = t.topic_id

+ AND t.forum_id = ' . (int) $forum_id . '

+ ' . (($sql_more) ? 'AND ' . $sql_more : '');

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

+

+ $topic_ids = array();

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

+ {

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

+

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

+ }

+ $db->sql_freeresult($result);

+

+ if (!empty($topic_ids))

+ {

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

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

+ $db->sql_query($sql);

+ }

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

+ sync('forum', 'forum_id', $sync_forum_ids, true, true);

+

+ return $sync_forum_ids;

+ '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');

+ /*

+ * 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.

+

+ */

+ $title = $row['message_subject'];

+

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

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

+ $tokens = '+-|()*';

+

+ $keywords = trim($this->cleanup($keywords, $tokens));

+ case '*':

+ if ($i === 0 || ($keywords[$i - 1] !== '*' && strcspn($keywords[$i - 1], $tokens) === 0))

+ {

+ if ($i === $n - 1 || ($keywords[$i + 1] !== '*' && strcspn($keywords[$i + 1], $tokens) === 0))

+ {

+ $keywords = substr($keywords, 0, $i) . substr($keywords, $i + 1);

+ }

+ }

+ break;

+ // 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';

+ $user_actkey = gen_rand_string(mt_rand(6, 10));

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

+ $user_actkey = gen_rand_string(mt_rand(6, 10));

+ $user_password = gen_rand_string_friendly(max(8, mt_rand((int) $config['min_pass_chars'], (int) $config['max_pass_chars'])));

+ $user_actkey = gen_rand_string(mt_rand(6, 10));