+ var $db_tools;

+ if (!class_exists('phpbb_db_tools'))

+ {

+ require($phpbb_root_path . 'includes/db/db_tools.' . $phpEx);

+ }

+ $this->db_tools = new phpbb_db_tools($db);

+

+ $table = array_intersect($this->db_tools->sql_list_tables(), request_var('table', array('')));

+ $tables = $this->db_tools->sql_list_tables();

+ $sql = 'SELECT MAX(post_id) as max_post_id

+ if ($auth->acl_get('a_server') && version_compare(PHP_VERSION, '5.3.2', '<'))

+ 'L_PHP_VERSION_OLD' => sprintf($user->lang['PHP_VERSION_OLD'], '<a href="http://www.phpbb.com/community/viewtopic.php?f=14&amp;t=2152375">', '</a>'),

+ 'field_show_novalue'=> 0,

+ 1 => array('field_ident', 'lang_name', 'lang_explain', 'field_option_none', 'field_show_on_reg', 'field_show_on_vt', 'field_required', 'field_show_novalue', 'field_hide', 'field_show_profile', 'field_no_view'),

+ 'field_show_novalue',

+ else if ($field_type == FIELD_BOOL && $key == 'field_default_value')

+ // 'field_length' == 1 defines radio buttons. Possible values are 1 or 2 only.

+ // 'field_length' == 2 defines checkbox. Possible values are 0 or 1 only.

+ // If we switch the type on step 2, we have to adjust field value.

+ // 1 is a common value for the checkbox and radio buttons.

+

+ // Adjust unchecked checkbox value.

+ // If we return or save settings from 2nd/3rd page

+ // and the checkbox is unchecked, set the value to 0.

+ if (isset($_REQUEST['step']) && !isset($_REQUEST[$key]))

+ {

+ $var = 0;

+ }

+

+ // If we switch to the checkbox type but former radio buttons value was 2,

+ // which is not the case for the checkbox, set it to 0 (unchecked).

+ if ($cp->vars['field_length'] == 2 && $var == 2)

+ {

+ $var = 0;

+ }

+ // If we switch to the radio buttons but the former checkbox value was 0,

+ // which is not the case for the radio buttons, set it to 0.

+ else if ($cp->vars['field_length'] == 1 && $var == 0)

+ {

+ $var = 2;

+ }

+ }

+ else if ($field_type == FIELD_BOOL && $key == 'field_default_value')

+ {

+ $_new_key_ary[$key] = request_var($key, $cp->vars[$key]);

+ }

+ 'S_FIELD_SHOW_NOVALUE'=> ($cp->vars['field_show_novalue']) ? true : false,

+ 'field_show_novalue' => $cp->vars['field_show_novalue'],

+ $min_posts = ($special_rank) ? 0 : max(0, request_var('min_posts', 0));

+ // The array key is used for sorting later on.

+ // $file is appended because $name doesn't have to be unique.

+ $new_ary[$name . $file] = array(

+ ksort($new_ary);

+

+ $sql = 'SELECT post_id

+ FROM ' . POSTS_TABLE . '

+ WHERE poster_id = '. $user_id;

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

+ $user_row['user_has_posts'] = (bool) $db->sql_fetchfield('post_id');

+ $db->sql_freeresult($result);

+

+ 'USER_HAS_POSTS' => $user_row['user_has_posts'],

+ set_var($password_new_format, stripslashes($password_old_format), 'string', true);

+ return array(

+ 'status' => LOGIN_ERROR_EXTERNAL_AUTH,

+ 'error_msg' => 'LDAP_NO_SERVER_CONNECTION',

+ 'user_row' => array('user_id' => ANONYMOUS),

+ );

+define('PHPBB_VERSION', '3.0.12-dev');

+ $statements[] = 'ALTER TABLE ' . $table_name . ' ADD UNIQUE INDEX ' . $index_name . '(' . implode(', ', $column) . ')';

+ * Seek to given row number

+ * rownum is zero-based

+ */

+ function sql_rowseek($rownum, &$query_id)

+ {

+ global $cache;

+

+ if ($query_id === false)

+ {

+ $query_id = $this->query_result;

+ }

+

+ if (isset($cache->sql_rowset[$query_id]))

+ {

+ return $cache->sql_rowseek($rownum, $query_id);

+ }

+

+ if ($query_id === false)

+ {

+ return false;

+ }

+

+ $this->sql_freeresult($query_id);

+ $query_id = $this->sql_query($this->last_query_text);

+

+ if ($query_id === false)

+ {

+ return false;

+ }

+

+ // We do not fetch the row for rownum == 0 because then the next resultset would be the second row

+ for ($i = 0; $i < $rownum; $i++)

+ {

+ if (!$this->sql_fetchrow($query_id))

+ {

+ return false;

+ }

+ }

+

+ return true;

+ }

+

+ /**

+ * Run LOWER() on DB column of type text (i.e. neither varchar nor char).

+ *

+ * @param string $column_name The column name to use

+ *

+ * @return string A SQL statement like "LOWER($column_name)"

+ */

+ function sql_lower_text($column_name)

+ {

+ return "LOWER($column_name)";

+ }

+

+ /**

+

+ /**

+ * Gets the estimated number of rows in a specified table.

+ *

+ * @param string $table_name Table name

+ *

+ * @return string Number of rows in $table_name.

+ * Prefixed with ~ if estimated (otherwise exact).

+ *

+ * @access public

+ */

+ function get_estimated_row_count($table_name)

+ {

+ return $this->get_row_count($table_name);

+ }

+

+ /**

+ * Gets the exact number of rows in a specified table.

+ *

+ * @param string $table_name Table name

+ *

+ * @return string Exact number of rows in $table_name.

+ *

+ * @access public

+ */

+ function get_row_count($table_name)

+ {

+ $sql = 'SELECT COUNT(*) AS rows_total

+ FROM ' . $this->sql_escape($table_name);

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

+ $rows_total = $this->sql_fetchfield('rows_total');

+ $this->sql_freeresult($result);

+

+ return $rows_total;

+ }

+ * {@inheritDoc}

+ */

+ function sql_lower_text($column_name)

+ {

+ return "LOWER(SUBSTRING($column_name, 1, DATALENGTH($column_name)))";

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ function sql_lower_text($column_name)

+ {

+ return "LOWER(SUBSTRING($column_name, 1, DATALENGTH($column_name)))";

+ }

+

+ /**

+ return (sizeof($row)) ? $row : false;

+ * {@inheritDoc}

+ */

+ function sql_lower_text($column_name)

+ {

+ return "LOWER(SUBSTRING($column_name, 1, DATALENGTH($column_name)))";

+ }

+

+ /**

+ * Gets the estimated number of rows in a specified table.

+ *

+ * @param string $table_name Table name

+ *

+ * @return string Number of rows in $table_name.

+ * Prefixed with ~ if estimated (otherwise exact).

+ *

+ * @access public

+ */

+ function get_estimated_row_count($table_name)

+ {

+ $table_status = $this->get_table_status($table_name);

+

+ if (isset($table_status['Engine']))

+ {

+ if ($table_status['Engine'] === 'MyISAM')

+ {

+ return $table_status['Rows'];

+ }

+ else if ($table_status['Engine'] === 'InnoDB' && $table_status['Rows'] > 100000)

+ {

+ return '~' . $table_status['Rows'];

+ }

+ }

+

+ return parent::get_row_count($table_name);

+ }

+

+ /**

+ * Gets the exact number of rows in a specified table.

+ *

+ * @param string $table_name Table name

+ *

+ * @return string Exact number of rows in $table_name.

+ *

+ * @access public

+ */

+ function get_row_count($table_name)

+ {

+ $table_status = $this->get_table_status($table_name);

+

+ if (isset($table_status['Engine']) && $table_status['Engine'] === 'MyISAM')

+ {

+ return $table_status['Rows'];

+ }

+

+ return parent::get_row_count($table_name);

+ }

+

+ /**

+ * Gets some information about the specified table.

+ *

+ * @param string $table_name Table name

+ *

+ * @return array

+ *

+ * @access protected

+ */

+ function get_table_status($table_name)

+ {

+ $sql = "SHOW TABLE STATUS

+ LIKE '" . $this->sql_escape($table_name) . "'";

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

+ $table_status = $this->sql_fetchrow($result);

+ $this->sql_freeresult($result);

+

+ return $table_status;

+ }

+

+ /**

+ * Gets the estimated number of rows in a specified table.

+ *

+ * @param string $table_name Table name

+ *

+ * @return string Number of rows in $table_name.

+ * Prefixed with ~ if estimated (otherwise exact).

+ *

+ * @access public

+ */

+ function get_estimated_row_count($table_name)

+ {

+ $table_status = $this->get_table_status($table_name);

+

+ if (isset($table_status['Engine']))

+ {

+ if ($table_status['Engine'] === 'MyISAM')

+ {

+ return $table_status['Rows'];

+ }

+ else if ($table_status['Engine'] === 'InnoDB' && $table_status['Rows'] > 100000)

+ {

+ return '~' . $table_status['Rows'];

+ }

+ }

+

+ return parent::get_row_count($table_name);

+ }

+

+ /**

+ * Gets the exact number of rows in a specified table.

+ *

+ * @param string $table_name Table name

+ *

+ * @return string Exact number of rows in $table_name.

+ *

+ * @access public

+ */

+ function get_row_count($table_name)

+ {

+ $table_status = $this->get_table_status($table_name);

+

+ if (isset($table_status['Engine']) && $table_status['Engine'] === 'MyISAM')

+ {

+ return $table_status['Rows'];

+ }

+

+ return parent::get_row_count($table_name);

+ }

+

+ /**

+ * Gets some information about the specified table.

+ *

+ * @param string $table_name Table name

+ *

+ * @return array

+ *

+ * @access protected

+ */

+ function get_table_status($table_name)

+ {

+ $sql = "SHOW TABLE STATUS

+ LIKE '" . $this->sql_escape($table_name) . "'";

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

+ $table_status = $this->sql_fetchrow($result);

+ $this->sql_freeresult($result);

+

+ return $table_status;

+ }

+

+ /**

+ $sql = 'SELECT t.forum_id

+ FROM ' . TOPICS_TABLE . ' t

+ LEFT JOIN ' . TOPICS_TRACK_TABLE . ' tt

+ ON (tt.topic_id = t.topic_id

+ AND tt.user_id = ' . $user->data['user_id'] . ')

+ AND (tt.topic_id IS NULL

+ OR tt.mark_time < t.topic_last_post_time)';

+ if (defined('DEBUG_TEST') || $diff && ($diff <= $timespan || $timespan === -1))

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

+ echo ' Powered by <a href="https://www.phpbb.com/">phpBB</a>&reg; Forum Software &copy; phpBB Group';

+ 'CREDIT_LINE' => $user->lang('POWERED_BY', '<a href="https://www.phpbb.com/">phpBB</a>&reg; Forum Software &copy; phpBB Group'),

+* remove_comments will strip the sql comment lines out of an uploaded sql file

+* specifically for mssql and postgres type files in the install....

+*

+* @deprecated Use phpbb_remove_comments() instead.

+*/

+function remove_comments(&$output)

+{

+ // Remove /* */ comments (http://ostermiller.org/findcomment.html)

+ $output = preg_replace('#/\*(.|[\r\n])*?\*/#', "\n", $output);

+

+ // Return by reference and value.

+ return $output;

+}

+

+/**

+ $sql_lower = $db->sql_lower_text('l.log_data');

+ $sql_keywords .= "$sql_lower " . implode(" OR $sql_lower ", $keywords) . ')';

+ 'COMMENTS' => 'remove_remarks',

+ 'COMMENTS' => 'remove_remarks',

+ 'COMMENTS' => 'remove_remarks',

+ 'COMMENTS' => 'remove_comments',

+ 'COMMENTS' => 'remove_comments',

+ 'COMMENTS' => 'remove_comments',

+ 'COMMENTS' => 'remove_comments',

+ 'COMMENTS' => 'remove_comments',

+ 'COMMENTS' => 'remove_remarks',

+*

+* @deprecated Use phpbb_remove_comments() instead.

+function remove_remarks(&$sql)

+ // Return by reference

+}

+

+/**

+* Removes "/* style" as well as "# style" comments from $input.

+*

+* @param string $input Input string

+*

+* @return string Input string with comments removed

+*/

+function phpbb_remove_comments($input)

+{

+ if (!function_exists('remove_comments'))

+ {

+ global $phpbb_root_path, $phpEx;

+ require($phpbb_root_path . 'includes/functions_admin.' . $phpEx);

+ }

+

+ // Remove /* */ comments

+ remove_comments($input);

+

+ // Remove # style comments

+ remove_remarks($input);

+

+ return $input;

+/**

+* Creates the output to be stored in a phpBB config.php file

+*

+* @param array $data Array containing the database connection information

+* @param string $dbms The name of the DBAL class to use

+* @param array $load_extensions Array of additional extensions that should be loaded

+* @param bool $debug If the debug constants should be enabled by default or not

+* @param bool $debug_test If the DEBUG_TEST constant should be added

+* NOTE: Only for use within the testing framework

+*

+* @return string The output to write to the file

+*/

+function phpbb_create_config_file_data($data, $dbms, $load_extensions, $debug = false, $debug_test = false)

+{

+ $load_extensions = implode(',', $load_extensions);

+

+ $config_data = "<?php\n";

+ $config_data .= "// phpBB 3.0.x auto-generated configuration file\n// Do not change anything in this file!\n";

+

+ $config_data_array = array(

+ 'dbms' => $dbms,

+ 'dbhost' => $data['dbhost'],

+ 'dbport' => $data['dbport'],

+ 'dbname' => $data['dbname'],

+ 'dbuser' => $data['dbuser'],

+ 'dbpasswd' => htmlspecialchars_decode($data['dbpasswd']),

+ 'table_prefix' => $data['table_prefix'],

+ 'acm_type' => 'file',

+ 'load_extensions' => $load_extensions,

+ );

+

+ foreach ($config_data_array as $key => $value)

+ {

+ $config_data .= "\${$key} = '" . str_replace("'", "\\'", str_replace('\\', '\\\\', $value)) . "';\n";

+ }

+

+ $config_data .= "\n@define('PHPBB_INSTALLED', true);\n";

+

+ if ($debug)

+ {

+ $config_data .= "@define('DEBUG', true);\n";

+ $config_data .= "@define('DEBUG_EXTRA', true);\n";

+ }

+ else

+ {

+ $config_data .= "// @define('DEBUG', true);\n";

+ $config_data .= "// @define('DEBUG_EXTRA', true);\n";

+ }

+

+ if ($debug_test)

+ {

+ $config_data .= "@define('DEBUG_TEST', true);\n";

+ }

+

+ return $config_data;

+}

+

+ $root_path = (defined('PHPBB_USE_BOARD_URL_PATH') && PHPBB_USE_BOARD_URL_PATH) ? generate_board_url() . '/' : $phpbb_root_path;

+

+ 'ICON_IMG' => $root_path . $config['icons_path'] . '/' . $data['img'],

+ if ($auth->acl_get('a_'))

+ {

+ $filedata['error'][] = $user->lang['ATTACH_DISK_FULL'];

+ }

+ else

+ {

+ $filedata['error'][] = $user->lang['ATTACH_QUOTA_REACHED'];

+ }

+ // Exclude guests, current user and banned users from notifications

+ if (!function_exists('phpbb_get_banned_user_ids'))

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

+ $sql_ignore_users = phpbb_get_banned_user_ids();

+ $sql_ignore_users[ANONYMOUS] = ANONYMOUS;

+ $sql_ignore_users[$user->data['user_id']] = $user->data['user_id'];

+ WHERE w.' . (($topic_notification) ? 'topic_id' : 'forum_id') . ' = ' . (($topic_notification) ? $topic_id : $forum_id) . '

+ AND ' . $db->sql_in_set('w.user_id', $sql_ignore_users, true) . '

+ AND w.notify_status = ' . NOTIFY_YES . '

+ $notify_user_id = (int) $row['user_id'];

+ $notify_rows[$notify_user_id] = array(

+ 'user_id' => $notify_user_id,

+

+ // Add users who have been already notified to ignore list

+ $sql_ignore_users[$notify_user_id] = $notify_user_id;

+ AND " . $db->sql_in_set('fw.user_id', $sql_ignore_users, true) . '

+ AND fw.notify_status = ' . NOTIFY_YES . '

+ $notify_user_id = (int) $row['user_id'];

+ $notify_rows[$notify_user_id] = array(

+ 'user_id' => $notify_user_id,

+

+ /*

+ * We also update the forums watch table for this user when we are

+ * sending out a topic notification to prevent sending out another

+ * notification in case this user is also subscribed to the forum

+ * this topic was posted in.

+ * Since an UPDATE query is used, this has no effect on users only

+ * subscribed to the topic (i.e. no row is created) and should not

+ * be a performance issue.

+ */

+ if ($row['notify_type'] === 'topic')

+ {

+ $update_notification['forum'][] = $row['user_id'];

+ }

+* @param int $bump_time The time at which topic was bumped, usually it is a current time as obtained via time().

+* Delete all PM(s) for a given user and delete the ones without references

+*

+* @param int $user_id ID of the user whose private messages we want to delete

+*

+* @return boolean False if there were no pms found, true otherwise.

+*/

+function phpbb_delete_user_pms($user_id)

+{

+ global $db, $user, $phpbb_root_path, $phpEx;

+

+ $user_id = (int) $user_id;

+

+ if (!$user_id)

+ {

+ return false;

+ }

+

+ // Get PM Information for later deleting

+ // The two queries where split, so we can use our indexes

+ $undelivered_msg = $delete_ids = array();

+

+ // Part 1: get PMs the user received

+ $sql = 'SELECT msg_id

+ FROM ' . PRIVMSGS_TO_TABLE . '

+ WHERE user_id = ' . $user_id;

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

+

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

+ {

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

+ $delete_ids[$msg_id] = $msg_id;

+ }

+ $db->sql_freeresult($result);

+

+ // Part 2: get PMs the user sent, but have yet to be received

+ // We cannot simply delete them. First we have to check,

+ // whether another user already received and read the message.

+ $sql = 'SELECT msg_id

+ FROM ' . PRIVMSGS_TO_TABLE . '

+ WHERE author_id = ' . $user_id . '

+ AND folder_id = ' . PRIVMSGS_NO_BOX;

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

+

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

+ {

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

+ $undelivered_msg[$msg_id] = $msg_id;

+ }

+ $db->sql_freeresult($result);

+

+ if (empty($delete_ids) && empty($undelivered_msg))

+ {

+ return false;

+ }

+

+ $db->sql_transaction('begin');

+

+ if (!empty($undelivered_msg))

+ {

+ // A pm is delivered, if for any recipient the message was moved

+ // from their NO_BOX to another folder. We do not delete such

+ // messages, but only delete them for users, who have not yet

+ // received them.

+ $sql = 'SELECT msg_id

+ FROM ' . PRIVMSGS_TO_TABLE . '

+ WHERE author_id = ' . $user_id . '

+ AND folder_id <> ' . PRIVMSGS_NO_BOX . '

+ AND folder_id <> ' . PRIVMSGS_OUTBOX . '

+ AND folder_id <> ' . PRIVMSGS_SENTBOX;

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

+

+ $delivered_msg = array();

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

+ {

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

+ $delivered_msg[$msg_id] = $msg_id;

+ unset($undelivered_msg[$msg_id]);

+ }

+ $db->sql_freeresult($result);

+

+ $undelivered_user = array();

+

+ // Count the messages we delete, so we can correct the user pm data

+ $sql = 'SELECT user_id, COUNT(msg_id) as num_undelivered_privmsgs

+ FROM ' . PRIVMSGS_TO_TABLE . '

+ WHERE author_id = ' . $user_id . '

+ AND folder_id = ' . PRIVMSGS_NO_BOX . '

+ AND ' . $db->sql_in_set('msg_id', array_merge($undelivered_msg, $delivered_msg)) . '

+ GROUP BY user_id';

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

+

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

+ {

+ $num_pms = (int) $row['num_undelivered_privmsgs'];

+ $undelivered_user[$num_pms][] = (int) $row['user_id'];

+

+ if (sizeof($undelivered_user[$num_pms]) > 50)

+ {

+ // If there are too many users affected the query might get

+ // too long, so we update the value for the first bunch here.

+ $sql = 'UPDATE ' . USERS_TABLE . '

+ SET user_new_privmsg = user_new_privmsg - ' . $num_pms . ',

+ user_unread_privmsg = user_unread_privmsg - ' . $num_pms . '

+ WHERE ' . $db->sql_in_set('user_id', $undelivered_user[$num_pms]);

+ $db->sql_query($sql);

+ unset($undelivered_user[$num_pms]);

+ }

+ }

+ $db->sql_freeresult($result);

+

+ foreach ($undelivered_user as $num_pms => $undelivered_user_set)

+ {

+ $sql = 'UPDATE ' . USERS_TABLE . '

+ SET user_new_privmsg = user_new_privmsg - ' . $num_pms . ',

+ user_unread_privmsg = user_unread_privmsg - ' . $num_pms . '

+ WHERE ' . $db->sql_in_set('user_id', $undelivered_user_set);

+ $db->sql_query($sql);

+ }

+

+ if (!empty($delivered_msg))

+ {

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

+ WHERE folder_id = ' . PRIVMSGS_NO_BOX . '

+ AND ' . $db->sql_in_set('msg_id', $delivered_msg);

+ $db->sql_query($sql);

+ }

+

+ if (!empty($undelivered_msg))

+ {

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

+ WHERE ' . $db->sql_in_set('msg_id', $undelivered_msg);

+ $db->sql_query($sql);

+

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

+ WHERE ' . $db->sql_in_set('msg_id', $undelivered_msg);

+ $db->sql_query($sql);

+ }

+ }

+

+ // Reset the user's pm count to 0

+ $sql = 'UPDATE ' . USERS_TABLE . '

+ SET user_new_privmsg = 0,

+ user_unread_privmsg = 0

+ WHERE user_id = ' . $user_id;

+ $db->sql_query($sql);

+

+ // Delete private message data of the user

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

+ WHERE user_id = ' . (int) $user_id;

+ $db->sql_query($sql);

+

+ if (!empty($delete_ids))

+ {

+ // Now we have to check which messages we can delete completely

+ $sql = 'SELECT msg_id

+ FROM ' . PRIVMSGS_TO_TABLE . '

+ WHERE ' . $db->sql_in_set('msg_id', $delete_ids);

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

+

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

+ {

+ unset($delete_ids[$row['msg_id']]);

+ }

+ $db->sql_freeresult($result);

+

+ if (!empty($delete_ids))

+ {

+ // Check if there are any attachments we need to remove

+ if (!function_exists('delete_attachments'))

+ {

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

+ }

+

+ delete_attachments('message', $delete_ids, false);

+

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

+ WHERE ' . $db->sql_in_set('msg_id', $delete_ids);

+ $db->sql_query($sql);

+ }

+ }

+

+ // Set the remaining author id to anonymous

+ // This way users are still able to read messages from users being removed

+ $sql = 'UPDATE ' . PRIVMSGS_TO_TABLE . '

+ SET author_id = ' . ANONYMOUS . '

+ WHERE author_id = ' . $user_id;

+ $db->sql_query($sql);

+

+ $sql = 'UPDATE ' . PRIVMSGS_TABLE . '

+ SET author_id = ' . ANONYMOUS . '

+ WHERE author_id = ' . $user_id;

+ $db->sql_query($sql);

+

+ $db->sql_transaction('commit');

+

+ return true;

+}

+

+/**

+ // Exclude guests, current user and banned users from notifications

+ if (!function_exists('phpbb_get_banned_user_ids'))

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

+ $banned_users = phpbb_get_banned_user_ids(array_keys($recipients));

+ $recipients = array_diff(array_keys($recipients), $banned_users);

+ WHERE ' . $db->sql_in_set('user_id', $recipients);

+

+

+ $user_ids = $user_id;

+

+

+ foreach ($user_ids as $user_id)

+ {

+ if (!isset($user_fields[$user_id][$used_ident]) && $this->profile_cache[$used_ident]['field_show_novalue'])

+ {

+ $user_fields[$user_id][$used_ident]['value'] = '';

+ $user_fields[$user_id][$used_ident]['data'] = $this->profile_cache[$used_ident];

+ }

+ }

+ if ($value === '' && !$ident_ary['data']['field_show_novalue'])

+ if (!$value && !$ident_ary['data']['field_show_novalue'])

+ if (!$day && !$month && !$year && !$ident_ary['data']['field_show_novalue'])

+ if ($value == $ident_ary['data']['field_novalue'] && !$ident_ary['data']['field_show_novalue'])

+ if ($ident_ary['data']['field_show_novalue'])

+ {

+ $value = $ident_ary['data']['field_novalue'];

+ }

+ else

+ {

+ return NULL;

+ }

+ if (!$value && $ident_ary['data']['field_show_novalue'])

+ {

+ $value = $ident_ary['data']['field_default_value'];

+ }

+

+ // checkbox - set the value to "true" if it has been set to 1

+ $value = (isset($_REQUEST[$profile_row['field_ident']]) && request_var($profile_row['field_ident'], $default_value) == 1) ? true : ((!isset($user->profile_fields[$user_ident]) || $preview) ? $default_value : $user->profile_fields[$user_ident]);

+ $remote_max_filesize = $this->max_filesize;

+ if (!$remote_max_filesize)

+ {

+ $max_filesize = @ini_get('upload_max_filesize');

+

+ if (!empty($max_filesize))

+ {

+ $unit = strtolower(substr($max_filesize, -1, 1));

+ $remote_max_filesize = (int) $max_filesize;

+

+ switch ($unit)

+ {

+ case 'g':

+ $remote_max_filesize *= 1024;

+ // no break

+ case 'm':

+ $remote_max_filesize *= 1024;

+ // no break

+ case 'k':

+ $remote_max_filesize *= 1024;

+ // no break

+ }

+ }

+ }

+

+ if ($remote_max_filesize && $filesize > $remote_max_filesize)

+ $max_filesize = get_formatted_filesize($remote_max_filesize, false);

+ if ($remote_max_filesize && $length && $length > $remote_max_filesize)

+ $max_filesize = get_formatted_filesize($remote_max_filesize, false);

+ // Clean the private messages tables from the user

+ if (!function_exists('phpbb_delete_user_pms'))

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

+ phpbb_delete_user_pms($user_id);

+* Verifies whether a style ID corresponds to an active style.

+*

+* @param int $style_id The style_id of a style which should be checked if activated or not.

+* @return boolean

+*/

+function phpbb_style_is_active($style_id)

+{

+ global $db;

+

+ $sql = 'SELECT style_active

+ FROM ' . STYLES_TABLE . '

+ WHERE style_id = '. (int) $style_id;

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

+

+ $style_is_active = (bool) $db->sql_fetchfield('style_active');

+ $db->sql_freeresult($result);

+

+ return $style_is_active;

+}

+

+/**

+/**

+* Gets user ids of currently banned registered users.

+*

+* @param array $user_ids Array of users' ids to check for banning,

+* leave empty to get complete list of banned ids

+* @return array Array of banned users' ids if any, empty array otherwise

+*/

+function phpbb_get_banned_user_ids($user_ids = array())

+{

+ global $db;

+

+ $sql_user_ids = (!empty($user_ids)) ? $db->sql_in_set('ban_userid', $user_ids) : 'ban_userid <> 0';

+

+ // Get banned User ID's

+ // Ignore stale bans which were not wiped yet

+ $banned_ids_list = array();

+ $sql = 'SELECT ban_userid

+ FROM ' . BANLIST_TABLE . "

+ WHERE $sql_user_ids

+ AND ban_exclude <> 1

+ AND (ban_end > " . time() . '

+ OR ban_end = 0)';

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

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

+ {

+ $user_id = (int) $row['ban_userid'];

+ $banned_ids_list[$user_id] = $user_id;

+ }

+ $db->sql_freeresult($result);

+

+ return $banned_ids_list;

+}

+

+ // Resync Topic?

+ if ($action == 'resync')

+ {

+ if (!function_exists('mcp_resync_topics'))

+ {

+ include($phpbb_root_path . 'includes/mcp/mcp_forum.' . $phpEx);

+ }

+ mcp_resync_topics(array($topic_id));

+ }

+

+ 'S_CAN_SYNC' => $auth->acl_get('m_', $topic_info['forum_id']),

+ get_user_rank($user_row['user_rank'], $user_row['user_posts'], $rank_title, $rank_img, $rank_img_src);

+ get_user_rank($user_row['user_rank'], $user_row['user_posts'], $rank_title, $rank_img, $rank_img_src);

+ $this->destroy_cache(array(), array_unique($author_ids));

+ $alter[] = 'MODIFY post_subject varchar(255) COLLATE utf8_unicode_ci DEFAULT \'\' NOT NULL';

+ $this->stats['total_posts'] = empty($this->stats) ? 0 : $db->get_estimated_row_count(POSTS_TABLE);

+ $this->destroy_cache(array_unique($word_texts), array_unique($author_ids));

+ $this->stats['total_words'] = $db->get_estimated_row_count(SEARCH_WORDLIST_TABLE);

+ $this->stats['total_matches'] = $db->get_estimated_row_count(SEARCH_WORDMATCH_TABLE);

+ $sql_where .= (($sql_where) ? ' OR ' : '') . 'search_authors ' . $db->sql_like_expression($db->any_char . ' ' . (int) $author . ' ' . $db->any_char);

+ // if no session id is set, redirect to index.php

+ if (defined('NEED_SID') && (!isset($_GET['sid']) || $this->session_id !== $_GET['sid']))

+ {

+ send_status_line(401, 'Not authorized');

+ redirect(append_sid("{$phpbb_root_path}index.$phpEx"));

+ }

+

+ // if session id is set

+ if (!empty($this->session_id))

+$level = E_ALL & ~E_NOTICE & ~E_DEPRECATED;

+if (version_compare(PHP_VERSION, '5.4.0-dev', '>='))

+{

+ // PHP 5.4 adds E_STRICT to E_ALL.

+ // Our utf8 normalizer triggers E_STRICT output on PHP 5.4.

+ // Unfortunately it cannot be made E_STRICT-clean while

+ // continuing to work on PHP 4.

+ // Therefore, in phpBB 3.0.x we disable E_STRICT on PHP 5.4+,

+ // while phpBB 3.1 will fix utf8 normalizer.

+ // E_STRICT is defined starting with PHP 5

+ if (!defined('E_STRICT'))

+ {

+ define('E_STRICT', 2048);

+ }

+ $level &= ~E_STRICT;

+}

+error_reporting($level);

+ // Prevent users from flooding the rules table

+ $sql = 'SELECT COUNT(rule_id) AS num_rules

+ FROM ' . PRIVMSGS_RULES_TABLE . '

+ WHERE user_id = ' . (int) $user->data['user_id'];

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

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

+ $db->sql_freeresult($result);

+

+ if ($num_rules >= 5000)

+ {

+ trigger_error('RULE_LIMIT_REACHED');

+ }

+

+ // Set the user_message_rules bit

+ // Unset the user_message_rules bit

+ if ($config['override_user_style'])

+ {

+ $data['style'] = (int) $config['default_style'];

+ }

+ else if (!phpbb_style_is_active($data['style']))

+ {

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

+ }