- * @return void

- * @return void

- * @return void

- * @return void

- * @return void

- * @return void

- * @return void

- * @return void

- * @return void

- 'board_contact' => array('lang' => 'CONTACT_EMAIL', 'validate' => 'string', 'type' => 'text:25:100', 'explain' => true),

- 'board_email' => array('lang' => 'ADMIN_EMAIL', 'validate' => 'string', 'type' => 'text:25:100', 'explain' => true),

- $table = request_var('table', array(''));

- include($phpbb_root_path . 'includes/functions_install.' . $phpEx);

- $tables = get_tables($db);

- if (!sizeof($mark_ary))

- {

- $start = 0;

- do

- $sql = 'SELECT user_id

- FROM ' . USER_GROUP_TABLE . "

- WHERE group_id = $group_id

- ORDER BY user_id";

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

-

- $mark_ary = array();

- if ($row = $db->sql_fetchrow($result))

- do

- {

- $mark_ary[] = $row['user_id'];

- }

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

- group_user_attributes('default', $group_id, $mark_ary, false, $group_name, $group_row);

- $start = (sizeof($mark_ary) < 200) ? 0 : $start + 200;

- }

- else

- {

- $start = 0;

- }

- $db->sql_freeresult($result);

- while ($start);

- }

- else

- {

- group_user_attributes('default', $group_id, $mark_ary, false, $group_name, $group_row);

-

- // Validate the length of "Maximum number of allowed recipients per private message" setting.

- // We use 16777215 as a maximum because it matches MySQL unsigned mediumint maximum value

- // which is the lowest amongst DBMSes supported by phpBB3

- if ($max_recipients_error = validate_data($submit_ary, array('max_recipients' => array('num', false, 0, 16777215))))

- $error = array_merge($error, array_map(array(&$user, 'lang'), $max_recipients_error));

- 'U_DEFAULT_ALL' => "{$this->u_action}&amp;action=default&amp;g=$group_id",

-?> \ No newline at end of file

- $sql = 'SELECT MAX(post_id)

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

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

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

- $new_ary[] = array(

- if ($info === false)

- set_var($password_new_format, stripslashes($password_old_format), 'string');

- return $user->lang['LDAP_NO_SERVER_CONNECTION'];

- for ($i = floor($width/2); $i < $end; $i++)

-define('PHPBB_VERSION', '3.0.11-dev');

- $statements[] = 'ALTER TABLE ' . $table_name . ' ADD UNIQUE INDEX (' . 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;

- }

-

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

- }

-

- /**

- $error = array(

- 'message' => @mssql_get_last_message(),

- 'code' => ''

- );

-

- // Get error code number

- $result_id = @mssql_query('SELECT @@ERROR as code', $this->db_connect_id);

- if ($result_id)

- $row = @mssql_fetch_assoc($result_id);

- $error['code'] = $row['code'];

- @mssql_free_result($result_id);

- }

- // Get full error message if possible

- $sql = 'SELECT CAST(description as varchar(255)) as message

- FROM master.dbo.sysmessages

- WHERE error = ' . $error['code'];

- $result_id = @mssql_query($sql);

-

- if ($result_id)

- {

- $row = @mssql_fetch_assoc($result_id);

- if (!empty($row['message']))

- $error['message'] .= '<br />' . $row['message'];

- @mssql_free_result($result_id);

- $this->db_connect_id = ($this->persistency) ? @odbc_pconnect($this->server, $this->user, $sqlpassword) : @odbc_connect($this->server, $this->user, $sqlpassword);

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

- }

-

- /**

- return array(

- 'message' => @odbc_errormsg(),

- 'code' => @odbc_error()

- );

- # Test for driver support, to avoid suppressed fatal error

- trigger_error('Native MS SQL Server driver for PHP is missing or needs to be updated. Version 1.1 or later is required to install phpBB3. You can download the driver from: http://www.microsoft.com/sqlserver/2005/en/us/PHP-Driver.aspx\n', E_USER_ERROR);

- error_reporting(E_ALL);

- return $row;

- }

-

- /**

- * Seek to given row number

- * rownum is zero-based

- */

- function sql_rowseek($rownum, &$query_id)

- {

- global $cache;

-

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

- {

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

- }

-

- $seek = new result_mssqlnative($query_id);

- $row = $seek->seek($rownum);

- return ($row = $seek->fetch()) ? $row : false;

- $errors = @sqlsrv_errors(SQLSRV_ERR_ERRORS);

- $error_message = '';

- $code = 0;

-

- if ($errors != null)

- foreach ($errors as $error)

- $error_message .= "SQLSTATE: ".$error[ 'SQLSTATE']."\n";

- $error_message .= "code: ".$error[ 'code']."\n";

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

- $error_message .= "message: ".$error[ 'message']."\n";

- $this->last_error_result = $error_message;

- $error = $this->last_error_result;

- $error = (isset($this->last_error_result) && $this->last_error_result) ? $this->last_error_result : array();

- return array(

- 'message' => $error,

- 'code' => $code,

- );

- $this->db_connect_id = ($this->persistency) ? @mysql_pconnect($this->server, $this->user, $sqlpassword) : @mysql_connect($this->server, $this->user, $sqlpassword, $new_link);

- if (!$this->db_connect_id)

- return array(

- 'code' => @mysql_errno()

- return array(

- 'message' => @mysql_error($this->db_connect_id),

- 'code' => @mysql_errno($this->db_connect_id)

- );

- if (!$this->db_connect_id)

- return array(

- 'code' => @mysqli_connect_errno()

- return array(

- 'message' => @mysqli_error($this->db_connect_id),

- 'code' => @mysqli_errno($this->db_connect_id)

- );

- $this->db_connect_id = ($new_link) ? @ocinlogon($this->user, $sqlpassword, $connect, 'UTF8') : (($this->persistency) ? @ociplogon($this->user, $sqlpassword, $connect, 'UTF8') : @ocilogon($this->user, $sqlpassword, $connect, 'UTF8'));

- $error = @ocierror();

- $error = (!$error) ? @ocierror($this->query_result) : $error;

- $error = (!$error) ? @ocierror($this->db_connect_id) : $error;

-

- if ($error)

- $this->last_error_result = $error;

- $error = (isset($this->last_error_result) && $this->last_error_result) ? $this->last_error_result : array();

- $this->db_connect_id = ($this->persistency) ? @sqlite_popen($this->server, 0666, $error) : @sqlite_open($this->server, 0666, $error);

- return array(

- 'message' => @sqlite_error_string(@sqlite_last_error($this->db_connect_id)),

- 'code' => @sqlite_last_error($this->db_connect_id)

- );

-* Set config value. Creates missing config entry.

-* Set dynamic config value with arithmetic operation.

-* @param int $value filesize in bytes

- return ($path[0] == '/' || (DIRECTORY_SEPARATOR == '\\' && preg_match('#^[a-z]:[/\\\]#i', $path))) ? true : false;

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

- GROUP BY t.forum_id';

- 'META' => '<meta http-equiv="refresh" content="' . $time . ';url=' . $url . '" />')

-* @return void

- if ($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,6})|(\d{1,3}\.){3}\d{1,3}(\:\d{1,5})?)';

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

-* @return void

- $sql_keywords .= 'LOWER(l.log_data) ' . implode(' OR LOWER(l.log_data) ', $keywords) . ')';

- if ($info === false)

- * @return void

-function remove_comments($sql)

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

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

-

- return $sql;

- $headers[] = 'Message-ID: <' . md5(unique_id(time())) . '@' . $config['server_name'] . '>';

- set_config('last_queue_run', time(), true);

-

- if (!file_exists($this->cache_file) || filemtime($this->cache_file) > time() - $config['queue_interval'])

- 'ICON_IMG' => $phpbb_root_path . $config['icons_path'] . '/' . $data['img'],

- // Make sure the image category only holds valid images...

- if ($cat_id == ATTACHMENT_CATEGORY_IMAGE && !$file->is_image())

- {

- $file->remove();

-

- // If this error occurs a user tried to exploit an IE Bug by renaming extensions

- // Since the image category is displaying content inline we need to catch this.

- trigger_error($user->lang['ATTACHED_IMAGE_NOT_IMAGE']);

- }

-

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

-function user_notification($mode, $subject, $topic_title, $forum_name, $forum_id, $topic_id, $post_id)

- // Get banned User ID's

- $sql = 'SELECT ban_userid

- FROM ' . BANLIST_TABLE . '

- WHERE ban_userid <> 0

- AND ban_exclude <> 1';

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

-

- $sql_ignore_users = ANONYMOUS . ', ' . $user->data['user_id'];

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

- $sql_ignore_users .= ', ' . (int) $row['ban_userid'];

- $db->sql_freeresult($result);

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

- AND w.user_id NOT IN ($sql_ignore_users)

- AND w.notify_status = " . NOTIFY_YES . '

- $notify_rows[$row['user_id']] = array(

- 'user_id' => $row['user_id'],

- if (sizeof($notify_rows))

- {

- $sql_ignore_users .= ', ' . implode(', ', array_keys($notify_rows));

- }

-

- AND fw.user_id NOT IN ($sql_ignore_users)

- AND fw.notify_status = " . NOTIFY_YES . '

- $notify_rows[$row['user_id']] = array(

- 'user_id' => $row['user_id'],

-

- // Check the permissions for post approval. Moderators are not affected.

- if (!$auth->acl_get('f_noapprove', $data['forum_id']) && !$auth->acl_get('m_approve', $data['forum_id']))

- user_notification($mode, $subject, $data['topic_title'], $data['forum_name'], $data['forum_id'], $data['topic_id'], $data['post_id']);

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

- // Additionally, do not include the sender if he is in the group he wants to send to. ;)

- if ($row['user_id'] === $user->data['user_id'])

- {

- continue;

- }

-

- // Get banned User ID's

- $sql = 'SELECT ban_userid

- FROM ' . BANLIST_TABLE . '

- WHERE ' . $db->sql_in_set('ban_userid', array_map('intval', array_keys($recipients))) . '

- AND ban_exclude = 0';

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

-

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

- unset($recipients[$row['ban_userid']]);

- $db->sql_freeresult($result);

- WHERE ' . $db->sql_in_set('user_id', array_map('intval', array_keys($recipients)));

-

-

- if ($value === '')

- if (!$value)

- if (!$day && !$month && !$year)

- // If a dropdown field is required, users

- // cannot choose the "no value" option.

- // They must choose one of the other options.

- // Therefore, here we treat a value equal to

- // the "no value" as a lack of value, i.e. NULL.

- if ($value == $ident_ary['data']['field_novalue'] && $ident_ary['data']['field_required'])

- return NULL;

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

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

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

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

- // Remove any undelivered mails...

- $sql = 'SELECT msg_id, user_id

- FROM ' . PRIVMSGS_TO_TABLE . '

- WHERE author_id = ' . $user_id . '

- AND folder_id = ' . PRIVMSGS_NO_BOX;

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

-

- $undelivered_msg = $undelivered_user = array();

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

- {

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

- $undelivered_user[$row['user_id']][] = true;

- }

- $db->sql_freeresult($result);

-

- if (sizeof($undelivered_msg))

- {

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

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

- $db->sql_query($sql);

- }

-

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

- WHERE author_id = ' . $user_id . '

- AND folder_id = ' . PRIVMSGS_NO_BOX;

- $db->sql_query($sql);

-

- // Delete all to-information

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

- WHERE user_id = ' . $user_id;

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

-

- foreach ($undelivered_user as $_user_id => $ary)

- if ($_user_id == $user_id)

- {

- continue;

- }

-

- $sql = 'UPDATE ' . USERS_TABLE . '

- SET user_new_privmsg = user_new_privmsg - ' . sizeof($ary) . ',

- user_unread_privmsg = user_unread_privmsg - ' . sizeof($ary) . '

- WHERE user_id = ' . $_user_id;

- $db->sql_query($sql);

- if ($result = call_user_func_array('validate_' . $function, $validate))

- global $config, $db, $user;

- // If the topic no longer exist, we will update the topic watch table.

- // To not let it error out on users watching both topics, we just return on an error...

- $db->sql_return_on_error(true);

- $db->sql_query('UPDATE ' . TOPICS_WATCH_TABLE . ' SET topic_id = ' . (int) $to_topic_id . ' WHERE ' . $db->sql_in_set('topic_id', $topic_ids));

- $db->sql_return_on_error(false);

- $db->sql_query('DELETE FROM ' . TOPICS_WATCH_TABLE . ' WHERE ' . $db->sql_in_set('topic_id', $topic_ids));

- // To not let it error out on users watching both topics, we just return on an error...

- $db->sql_return_on_error(true);

- $db->sql_query('UPDATE ' . TOPICS_WATCH_TABLE . ' SET topic_id = ' . (int) $to_topic_id . ' WHERE topic_id = ' . (int) $topic_id);

- $db->sql_return_on_error(false);

- $db->sql_query('DELETE FROM ' . TOPICS_WATCH_TABLE . ' WHERE topic_id = ' . (int) $topic_id);

- $rank_title = $rank_img = '';

- $rank_title = $rank_img = '';

- * @return void

- if ($engine != 'MyISAM')

- return $user->lang['FULLTEXT_MYSQL_NOT_MYISAM'];

- //$alter[] = 'MODIFY post_subject varchar(100) COLLATE utf8_unicode_ci DEFAULT \'\' NOT NULL';

- // Is session_id is set or session_id is set and matches the url param if required

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

- trigger_error('Could not get style data', E_USER_ERROR);

- 'lang' => $this->lang['datetime'],

-error_reporting(E_ALL & ~E_NOTICE & ~E_DEPRECATED);

- 'signature' => array('title' => 'UCP_PROFILE_SIGNATURE', 'auth' => '', 'cat' => array('UCP_PROFILE')),

- if (($user_row['user_inactive_reason'] == INACTIVE_MANUAL) || $user_row['user_actkey'] != $key)

- $sql = 'SELECT forum_password

- $forum_password = (string) $db->sql_fetchfield('forum_password');

- if ($forum_password)

- login_forum_box(array(

- 'forum_id' => $post['forum_id'],

- 'forum_password' => $forum_password,

- ));

- if ($to_user_id && $action == 'post')

- $message = $user->lang['MESSAGE_STORED'] . '<br /><br />' . sprintf($user->lang['VIEW_PRIVATE_MESSAGE'], '<a href="' . $return_message_url . '">', '</a>');

- // Update users message rules

- // Update users message rules

- $data['style'] = ($config['override_user_style']) ? $config['default_style'] : $data['style'];