$s_assigned_groups = array();

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

{

$s_assigned_groups[$row['cat_id']][] = $row['group_name'];

}

$db->sql_freeresult($result);

$sql = 'SELECT group_id

FROM ' . EXTENSION_GROUPS_TABLE . "

WHERE LOWER(group_name) = '" . $db->sql_escape(utf8_strtolower($new_group_name)) . "'";

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

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

$group_id = $db->sql_nextid();

}

add_log('admin', 'LOG_ATTACH_EXTGROUP_' . strtoupper($action), $group_name);

}

'U_EDIT' => $this->u_action . "&action=edit&g={$row['group_id']}",

'U_DELETE' => $this->u_action . "&action=delete&g={$row['group_id']}",

'CATEGORY' => $cat_lang[$row['cat_id']],

)

);

$group_name = array();

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

{

$group_name[] = $row;

}

$db->sql_freeresult($result);

$old_tz = $user->timezone;

$old_dst = $user->dst;

$dateformat_options = '';

case 'mssql':

case 'mssql_odbc':

while (($sql = $fgetd($fp, "GO\n", $read, $seek, $eof)) !== false)

{

$db->sql_query($sql);

)

);

foreach ($tables_ary as $field => $tables)

{

$start = 0;

$sql = "SELECT $field

FROM " . POSTS_TABLE . '

WHERE forum_id = ' . $forum_id;

$ids = array();

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

}

}

}

}

unset($ids);

case 'mssql':

case 'mssql_odbc':

// We are defining the biggest common value, because of the possibility to edit the min/max values of each field.

$sql = 'ALTER TABLE [' . PROFILE_FIELDS_DATA_TABLE . "] ADD [$field_ident] ";

// Standard? What's that?

case 'mssql':

case 'mssql_odbc':

// Change the reports using this reason to 'other'

$sql = "DECLARE @ptrval binary(16)

LEFT JOIN ' . SESSIONS_TABLE . ' s ON (s.session_user_id = u.user_id)

WHERE u.user_id = ' . $user_id . '

ORDER BY s.session_time DESC';

$user_row = $db->sql_fetchrow($result);

$db->sql_freeresult($result);

WHERE user_id = $user_id";

$db->sql_query($sql);

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

}

LEFT JOIN ' . SESSIONS_TABLE . ' s ON (s.session_user_id = u.user_id)

WHERE u.user_id = ' . $user_id . '

ORDER BY s.session_time DESC';

$user_row = $db->sql_fetchrow($result);

$db->sql_freeresult($result);

}

$this->persistency = $persistency;

if ($this->db_connect_id)

{

switch ($db->sql_layer)

{

case 'firebird':

case 'postgres':

break;

// MySQL, SQlite, mssql, mssql_odbc, oracle

{

$type = (!$type) ? 'MX' : $type;

{

// @exec('nslookup -retry=1 -timout=1 -type=' . escapeshellarg($type) . ' ' . escapeshellarg($host), $output);

@exec('nslookup -type=' . escapeshellarg($type) . ' ' . escapeshellarg($host) . '.', $output);

return false;

}

return NULL;

}

}

}

}

if ($mode == 'topic_review')

case 'sqlite':

case 'mssql':

case 'mssql_odbc':

$right_delim = ']';

$left_delim = '[';

break;

{

if ($get_info)

{

}

else

{

{

$upload_ary['type'] = rtrim(str_replace('content-type: ', '', strtolower($line)));

}

else if (stripos($line, '404 not found') !== false)

{

$file = new fileerror($user->lang[$this->error_prefix . 'URL_NOT_FOUND']);

if ($config['max_' . $this->mode . '_img_height'] || $config['max_' . $this->mode . '_img_width'])

{

if ($stats === false)

{

'S_COMPOSE_PM' => true,

'S_EDIT_POST' => ($action == 'edit'),

'S_SHOW_PM_ICONS' => $s_pm_icons,

'S_BBCODE_CHECKED' => ($bbcode_checked) ? ' checked="checked"' : '',

'S_SMILIES_ALLOWED' => $smilies_status,

'S_SMILIES_CHECKED' => ($smilies_checked) ? ' checked="checked"' : '',

'3.0.7-RC2' => array(),

// No changes from 3.0.7 to 3.0.7-PL1

'3.0.7' => array(),

);

}

*****************************************************************************/

function change_database_data(&$no_updates, $version)

{

switch ($version)

{

// No changes from 3.0.7 to 3.0.7-PL1

case '3.0.7':

break;

}

}

function main($mode, $sub)

{

$this->tpl_name = 'install_update';

$this->page_title = 'UPDATE_INSTALLATION';

$user->session_begin();

$auth->acl($user->data);

// If we are within the intro page we need to make sure we get up-to-date version info

if ($sub == 'intro')

// still, the acp template is never stored in the database

$user->theme['template_storedb'] = false;

// Get current and latest version

if (($latest_version = $cache->get('_version_info')) === false)

{

$template->assign_vars(array(

'S_INTRO' => true,

));

// Make sure the update list is destroyed.

'S_UP_TO_DATE' => $up_to_date,

'S_VERSION_CHECK' => true,

'LATEST_VERSION' => $this->latest_version,

'CURRENT_VERSION' => $this->current_version)

'S_DB_UPDATE' => true,

'S_DB_UPDATE_FINISHED' => ($config['version'] == $this->update_info['version']['to']) ? true : false,

'U_DB_UPDATE' => append_sid($phpbb_root_path . 'install/database_update.' . $phpEx, 'type=1&language=' . $user->data['user_lang']),

));

break;

// Refresh the page if we are still not finished...

if ($update_list['status'] != -1)

{

meta_refresh(2, $refresh_url);

$template->assign_vars(array(

$file_part = $filename;

}

if (isset($file_struct['as_expected']) && $file_struct['as_expected'])

{

'S_FILE_CHECK' => true,

'S_ALL_UP_TO_DATE' => $all_up_to_date,

'S_VERSION_UP_TO_DATE' => $up_to_date,

));

if ($all_up_to_date)

$params[] = 'download=1';

}

meta_refresh(3, $redirect_url);

$template->assign_vars(array(

$template->assign_vars(array(

'S_DOWNLOAD_FILES' => true,

'RADIO_BUTTONS' => $radio_buttons,

'S_HIDDEN_FIELDS' => $s_hidden_fields)

);

'S_FTP_UPLOAD' => true,

'UPLOAD_METHOD' => $method,

'S_HIDDEN_FIELDS' => $s_hidden_fields,

));

$template->assign_vars(array(

'S_UPLOAD_SUCCESS' => true,

);

return;

}

'DISPLAY_INLINED_EXPLAIN' => 'If set to No image attachments will show as a link.',

'DISPLAY_ORDER' => 'Attachment display order',

'DISPLAY_ORDER_EXPLAIN' => 'Display attachments ordered by time.',

'EDIT_EXTENSION_GROUP' => 'Edit extension group',

'EXCLUDE_ENTERED_IP' => 'Enable this to exclude the entered IP/hostname.',

'EXCLUDE_FROM_ALLOWED_IP' => 'Exclude IP from allowed IPs/hostnames',

'EXTENSION_GROUP_DELETED' => 'Extension group successfully deleted.',

'EXTENSION_GROUP_EXIST' => 'The extension group %s already exists.',

'GO_TO_EXTENSIONS' => 'Go to extension management screen',

'GROUP_NAME' => 'Group name',

'NEW_MEMBER_POST_LIMIT' => 'New member post limit',

'NEW_MEMBER_POST_LIMIT_EXPLAIN' => 'New members are within the <em>Newly Registered Users</em> group until they reach this number of posts. You can use this group to keep them from using the PM system or to review their posts. <strong>A value of 0 disables this feature.</strong>',

'NEW_MEMBER_GROUP_DEFAULT' => 'Set Newly Registered Users group to default',

'ACC_ADMIN' => 'By Admin',

'ACC_DISABLE' => 'Disable',

'DB_ERR_QUERY_FIRST_TABLE' => 'Error while executing <var>query_first</var>, %s (“%s”).',

'DB_ERR_SELECT' => 'Error while running <code>SELECT</code> query.',

'DB_HOST' => 'Database server hostname or DSN',

'DB_NAME' => 'Database name',

'DB_PASSWORD' => 'Database password',

'DB_PORT' => 'Database server port',

'DEFAULT_INSTALL_POST' => 'This is an example post in your phpBB3 installation. Everything seems to be working. You may delete this post if you like and continue to set up your board. During the installation process your first category and your first forum are assigned an appropriate set of permissions for the predefined usergroups administrators, bots, global moderators, guests, registered users and registered COPPA users. If you also choose to delete your first category and your first forum, do not forget to assign permissions for all these usergroups for all new categories and forums you create. It is recommended to rename your first category and your first forum and copy permissions from these while creating new categories and forums. Have fun!',

'FORUMS_FIRST_CATEGORY' => 'Your first category',

'FORUMS_TEST_FORUM_DESC' => 'Description of your first forum.',

'FORUMS_TEST_FORUM_TITLE' => 'Your first forum',

'S_DISPLAY_USERNAME' => (!$user->data['is_registered'] || ($mode == 'edit' && $post_data['poster_id'] == ANONYMOUS)) ? true : false,

'S_SHOW_TOPIC_ICONS' => $s_topic_icons,

'S_DELETE_ALLOWED' => ($mode == 'edit' && (($post_id == $post_data['topic_last_post_id'] && $post_data['poster_id'] == $user->data['user_id'] && $auth->acl_get('f_delete', $forum_id) && !$post_data['post_edit_locked'] && ($post_data['post_time'] > time() - ($config['delete_time'] * 60) || !$config['delete_time'])) || $auth->acl_get('m_delete', $forum_id))) ? true : false,

'S_BBCODE_CHECKED' => ($bbcode_checked) ? ' checked="checked"' : '',

'S_SMILIES_ALLOWED' => $smilies_status,

'S_SMILIES_CHECKED' => ($smilies_checked) ? ' checked="checked"' : '',

case 'mssql':

case 'mssql_odbc':

$sql = 'SELECT search_time, search_keywords

FROM ' . SEARCH_RESULTS_TABLE . '

WHERE DATALENGTH(search_keywords) > 0

{S_FORM_TOKEN}

{QR_HIDDEN_FIELDS}

<input type="submit" accesskey="s" tabindex="6" name="post" value="{L_SUBMIT}" class="button1" />&nbsp;

</fieldset>

<a href="" class="right-box up" onclick="hide_qr(false); return false;" title="{L_COLLAPSE_QR}">{L_COLLAPSE_QR}</a>

<span class="corners-bottom"><span></span></span></div>

</h3>

<div id="topicreview">

<!-- BEGIN history_row -->

<div class="post <!-- IF history_row.S_ROW_COUNT is even -->bg1<!-- ELSE -->bg2<!-- ENDIF -->">

<div class="inner"><span class="corners-top"><span></span></span>