+ 'display_last_subject' => array('lang' => 'DISPLAY_LAST_SUBJECT', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true),

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

+ return array(

+ 'status' => LOGIN_ERROR_EXTERNAL_AUTH,

+ 'error_msg' => 'LDAP_NO_SERVER_CONNECTION',

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

+ );

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

+ }

+

+ /**

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

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ function sql_lower_text($column_name)

+ {

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

+ }

+

+ /**

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

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

+

+/**

+* Casts a numeric string $input to an appropriate numeric type (i.e. integer or float)

+*

+* @param string $input A numeric string.

+*

+* @return int|float Integer $input if $input fits integer,

+* float $input otherwise.

+*/

+function phpbb_to_numeric($input)

+{

+ return ($input > PHP_INT_MAX) ? (float) $input : (int) $input;

+}

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

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

+ $last_post_subject_truncated = truncate_string(censor_text($last_post_subject), 30, 255, false, $user->lang['ELLIPSIS']);

+ $last_post_subject = $last_post_time = $last_post_url = $last_post_subject_truncated = '';

+ 'S_DISPLAY_SUBJECT' => ($last_post_subject && $config['display_last_subject'] && !$row['forum_password'] && $auth->acl_get('f_read', $row['forum_id'])) ? true : false,

+ 'LAST_POST_SUBJECT' => (!$row['forum_password'] && $auth->acl_get('f_read', $row['forum_id'])) ? censor_text($last_post_subject) : "",

+ 'LAST_POST_SUBJECT_TRUNCATED' => (!$row['forum_password'] && $auth->acl_get('f_read', $row['forum_id'])) ? $last_post_subject_truncated : "",

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

+ // Part 1: get PMs the user received

+ $sql = 'SELECT msg_id, author_id, folder_id, pm_unread, pm_new

+ FROM ' . PRIVMSGS_TO_TABLE . '

+ WHERE user_id = ' . $user_id;

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

+

+ $undelivered_msg = $undelivered_user = $delete_ids = array();

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

+ {

+ if ($row['author_id'] == $user_id && $row['folder_id'] == PRIVMSGS_NO_BOX)

+ {

+ // Undelivered messages

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

+

+ if (isset($undelivered_user[$row['user_id']]))

+ {

+ ++$undelivered_user[$row['user_id']];

+ }

+ else

+ {

+ $undelivered_user[$row['user_id']] = 1;

+ }

+ }

+

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

+ }

+ $db->sql_freeresult($result);

+

+ // Part 2: get PMs the user sent

+ $sql = 'SELECT msg_id, author_id, folder_id, pm_unread, pm_new

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

+ {

+ if ($row['author_id'] == $user_id && $row['folder_id'] == PRIVMSGS_NO_BOX)

+ {

+ // Undelivered messages

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

+

+ if (isset($undelivered_user[$row['user_id']]))

+ {

+ ++$undelivered_user[$row['user_id']];

+ }

+ else

+ {

+ $undelivered_user[$row['user_id']] = 1;

+ }

+ }

+

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

+ }

+ $db->sql_freeresult($result);

+

+ if (empty($delete_ids))

+ {

+ return false;

+ }

+

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

+

+ if (sizeof($undelivered_msg))

+ {

+ $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

+ if (isset($undelivered_user[$user_id]))

+ {

+ $sql = 'UPDATE ' . USERS_TABLE . '

+ SET user_new_privmsg = 0,

+ user_unread_privmsg = 0

+ WHERE user_id = ' . $user_id;

+ $db->sql_query($sql);

+ unset($undelivered_user[$user_id]);

+ }

+

+ foreach ($undelivered_user as $_user_id => $count)

+ {

+ $sql = 'UPDATE ' . USERS_TABLE . '

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

+ user_unread_privmsg = user_unread_privmsg - ' . $count . '

+ WHERE user_id = ' . $_user_id;

+ $db->sql_query($sql);

+ }

+

+ // Delete private message data

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

+ WHERE user_id = $user_id

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

+ $db->sql_query($sql);

+

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

+}

+

+/**

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

+<?php

+/**

+*

+* @package phpBB

+* @copyright (c) 2011 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Wrapper class for ini_get function.

+*

+* Provides easier handling of the different interpretations of ini values.

+*

+* @package phpBB

+*/

+class phpbb_php_ini

+{

+ /**

+ * Simple wrapper for ini_get()

+ * See http://php.net/manual/en/function.ini-get.php

+ *

+ * @param string $varname The configuration option name.

+ * @return bool|string False if configuration option does not exist,

+ * the configuration option value (string) otherwise.

+ */

+ public function get($varname)

+ {

+ return ini_get($varname);

+ }

+

+ /**

+ * Gets the configuration option value as a trimmed string.

+ *

+ * @param string $varname The configuration option name.

+ * @return bool|string False if configuration option does not exist,

+ * the configuration option value (string) otherwise.

+ */

+ public function get_string($varname)

+ {

+ $value = $this->get($varname);

+

+ if ($value === false)

+ {

+ return false;

+ }

+

+ return trim($value);

+ }

+

+ /**

+ * Gets configuration option value as a boolean.

+ * Interprets the string value 'off' as false.

+ *

+ * @param string $varname The configuration option name.

+ * @return bool False if configuration option does not exist.

+ * False if configuration option is disabled.

+ * True otherwise.

+ */

+ public function get_bool($varname)

+ {

+ $value = $this->get_string($varname);

+

+ if (empty($value) || strtolower($value) == 'off')

+ {

+ return false;

+ }

+

+ return true;

+ }

+

+ /**

+ * Gets configuration option value as an integer.

+ *

+ * @param string $varname The configuration option name.

+ * @return bool|int False if configuration option does not exist,

+ * false if configuration option value is not numeric,

+ * the configuration option value (integer) otherwise.

+ */

+ public function get_int($varname)

+ {

+ $value = $this->get_string($varname);

+

+ if (!is_numeric($value))

+ {

+ return false;

+ }

+

+ return (int) $value;

+ }

+

+ /**

+ * Gets configuration option value as a float.

+ *

+ * @param string $varname The configuration option name.

+ * @return bool|float False if configuration option does not exist,

+ * false if configuration option value is not numeric,

+ * the configuration option value (float) otherwise.

+ */

+ public function get_float($varname)

+ {

+ $value = $this->get_string($varname);

+

+ if (!is_numeric($value))

+ {

+ return false;

+ }

+

+ return (float) $value;

+ }

+

+ /**

+ * Gets configuration option value in bytes.

+ * Converts strings like '128M' to bytes (integer or float).

+ *

+ * @param string $varname The configuration option name.

+ * @return bool|int|float False if configuration option does not exist,

+ * false if configuration option value is not well-formed,

+ * the configuration option value otherwise.

+ */

+ public function get_bytes($varname)

+ {

+ $value = $this->get_string($varname);

+

+ if ($value === false)

+ {

+ return false;

+ }

+

+ if (is_numeric($value))

+ {

+ // Already in bytes.

+ return phpbb_to_numeric($value);

+ }

+ else if (strlen($value) < 2)

+ {

+ // Single character.

+ return false;

+ }

+ else if (strlen($value) < 3 && $value[0] === '-')

+ {

+ // Two characters but the first one is a minus.

+ return false;

+ }

+

+ $value_lower = strtolower($value);

+ $value_numeric = phpbb_to_numeric($value);

+

+ switch ($value_lower[strlen($value_lower) - 1])

+ {

+ case 'g':

+ $value_numeric *= 1024;

+ case 'm':

+ $value_numeric *= 1024;

+ case 'k':

+ $value_numeric *= 1024;

+ break;

+

+ default:

+ // It's not already in bytes (and thus numeric)

+ // and does not carry a unit.

+ return false;

+ }

+

+ return $value_numeric;

+ }

+}

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

+ $session_id = $request->variable('sid', '');

+ if (defined('NEED_SID') && (empty($session_id) || $this->session_id !== $session_id))

+ {

+ send_status_line(401, 'Not authorized');

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

+ }

+

+ // if session id is set

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

+// vendor/autoload.php. If this file exists it will be

+ if (!file_exists($phpbb_root_path . 'vendor/autoload.php'))

+ require($phpbb_root_path . 'vendor/autoload.php');