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

return;

}

{

$error[] = sprintf($user->lang['NO_WRITE_UPLOAD'], $upload_dir);

return;

$template->assign_block_vars('ban_reason', array(

'BAN_ID' => $ban_id,

'REASON' => $reason,

));

}

}

$template->assign_block_vars('ban_give_reason', array(

'BAN_ID' => $ban_id,

'REASON' => $reason,

));

}

}

'board_disable_msg' => false,

'default_lang' => array('lang' => 'DEFAULT_LANGUAGE', 'validate' => 'lang', 'type' => 'select', 'function' => 'language_select', 'params' => array('{CONFIG_VALUE}'), 'explain' => false),

'default_dateformat' => array('lang' => 'DEFAULT_DATE_FORMAT', 'validate' => 'string', 'type' => 'custom', 'method' => 'dateformat_select', 'explain' => true),

'board_dst' => array('lang' => 'SYSTEM_DST', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => false),

'default_style' => array('lang' => 'DEFAULT_STYLE', 'validate' => 'int', 'type' => 'select', 'function' => 'style_select', 'params' => array('{CONFIG_VALUE}', false), 'explain' => false),

'override_user_style' => array('lang' => 'OVERRIDE_STYLE', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true),

'load_online_guests' => array('lang' => 'YES_ONLINE_GUESTS', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true),

'load_onlinetrack' => array('lang' => 'YES_ONLINE_TRACK', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true),

'load_birthdays' => array('lang' => 'YES_BIRTHDAYS', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true),

'load_moderators' => array('lang' => 'YES_MODERATORS', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => false),

'load_jumpbox' => array('lang' => 'YES_JUMPBOX', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => false),

'load_user_activity' => array('lang' => 'LOAD_USER_ACTIVITY', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true),

$old_tz = $user->timezone;

$old_dst = $user->dst;

$dateformat_options = '';

}

else

{

}

}

trigger_error($user->lang['CONFIG_UPDATED'] . adm_back_link($this->u_action));

}

else if ($submit)

{

}

else

{

case 'mssql':

case 'mssql_odbc':

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

{

$db->sql_query($sql);

function write_data_mssqlnative($table_name)

{

global $db;

$ident_set = false;

$sql_data = '';

// Grab all of the data from current table.

$sql = "SELECT * FROM $table_name";

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

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

{

}

{

}

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

{

{

$str_val = $row[$ary_name[$i]];

{

$str_quote = '';

$str_empty = "''";

}

$db->sql_freeresult($result);

{

$sql_data .= "\nSET IDENTITY_INSERT $table_name OFF\nGO\n";

}

$forum_data['forum_status'] = ITEM_UNLOCKED;

}

// Get data for forum rules if specified...

if ($forum_data['forum_rules'])

$forum_perm_from = request_var('forum_perm_from', 0);

$cache->destroy('sql', FORUMS_TABLE);

// Copy permissions?

if ($forum_perm_from && $forum_perm_from != $forum_data['forum_id'] &&

($action != 'edit' || empty($forum_id) || ($auth->acl_get('a_fauth') && $auth->acl_get('a_authusers') && $auth->acl_get('a_authgroups') && $auth->acl_get('a_mauth'))))

{

copy_forum_permissions($forum_perm_from, $forum_data['forum_id'], ($action == 'edit') ? true : false);

cache_moderators();

}

/* Commented out because of questionable UI workflow - re-visit for 3.0.7

else if (!$this->parent_id && $action != 'edit' && $auth->acl_get('a_fauth') && $auth->acl_get('a_authusers') && $auth->acl_get('a_authgroups') && $auth->acl_get('a_mauth'))

$message = ($action == 'add') ? $user->lang['FORUM_CREATED'] : $user->lang['FORUM_UPDATED'];

// Redirect to permissions

{

$message .= '<br /><br />' . sprintf($user->lang['REDIRECT_ACL'], '<a href="' . append_sid("{$phpbb_admin_path}index.$phpEx", 'i=permissions' . $acl_url) . '">', '</a>');

}

// redirect directly to permission settings screen if authed

{

meta_refresh(4, append_sid("{$phpbb_admin_path}index.$phpEx", 'i=permissions' . $acl_url));

}

$exclude_forums[] = $row['forum_id'];

}

$forum_data['forum_password_confirm'] = $forum_data['forum_password'];

}

$this->page_title = 'CREATE_FORUM';

$forum_id = $this->parent_id;

// Fill forum data with default values

if (!$update)

'S_PRUNE_OLD_POLLS' => ($forum_data['forum_flags'] & FORUM_FLAG_PRUNE_POLL) ? true : false,

'S_PRUNE_ANNOUNCE' => ($forum_data['forum_flags'] & FORUM_FLAG_PRUNE_ANNOUNCE) ? true : false,

'S_PRUNE_STICKY' => ($forum_data['forum_flags'] & FORUM_FLAG_PRUNE_STICKY) ? true : false,

'S_ENABLE_POST_REVIEW' => ($forum_data['forum_flags'] & FORUM_FLAG_POST_REVIEW) ? true : false,

'S_ENABLE_QUICK_REPLY' => ($forum_data['forum_flags'] & FORUM_FLAG_QUICK_REPLY) ? true : false,

'S_CAN_COPY_PERMISSIONS' => ($action != 'edit' || empty($forum_id) || ($auth->acl_get('a_fauth') && $auth->acl_get('a_authusers') && $auth->acl_get('a_authgroups') && $auth->acl_get('a_mauth'))) ? true : false,

if (!$row)

{

}

if ($row['forum_type'] == FORUM_LINK)

delete_attachments('topic', $topic_ids, false);

// Before we remove anything we make sure we are able to adjust the post counts later. ;)

$sql = 'SELECT poster_id

FROM ' . POSTS_TABLE . '

)

);

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

// Clear some vars

$group_row = array();

// Grab basic data for group, if group_id is set and exists

}

}

if (!sizeof($error))

{

// Only set the rank, colour, etc. if it's changed or if we're adding a new

$this->tpl_name = 'acp_php_info';

$this->page_title = 'ACP_PHP_INFO';

ob_start();

$phpinfo = ob_get_clean();

$phpinfo = trim($phpinfo);

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] ";

'mode' => $mode,

'prune' => 1,

'email' => request_var('email', ''),

'joined_select' => request_var('joined_select', ''),

'joined' => request_var('joined', ''),

{

global $user, $db;

if ($users)

{

}

else

{

$email = request_var('email', '');

$joined_select = request_var('joined_select', 'lt');

// Standard? What's that?

case 'mssql':

case 'mssql_odbc':

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

$sql = "DECLARE @ptrval binary(16)

$additional = '';

// If the template is stored on the filesystem try to write the file else store it in the database

{

if (!($fp = @fopen($file, 'wb')))

{

$message = $user->lang['THEME_UPDATED'];

// If the theme is stored on the filesystem try to write the file else store it in the database

{

if (!($fp = @fopen($file, 'wb')))

{

{

case 'tar':

$ext = '.tar';

break;

case 'zip':

$ext = '.zip';

break;

case 'tar.gz':

$ext = '.tar.gz';

break;

case 'tar.bz2':

$ext = '.tar.bz2';

break;

default:

{

// a rather elaborate check we have to do here once to avoid trouble later

$check = "{$phpbb_root_path}styles/" . $style_row["{$mode}_path"] . (($mode === 'theme') ? '/theme/stylesheet.css' : '/template');

{

$error[] = $user->lang['EDIT_' . strtoupper($mode) . '_STORED_DB'];

$store_db = 1;

{

$theme_data = $this->db_theme_data($style_row);

}

{

$store_db = 1;

$theme_data = $style_row['theme_data'];

}

else

{

{

$err = $this->store_in_fs('template', $style_row['template_id']);

if ($err)

// Match CSS imports

$matches = array();

if (sizeof($matches))

{

foreach ($matches[0] as $idx => $match)

{

}

}

$store_db = 0;

$error = array();

{

$sql = 'SELECT *

FROM ' . STYLES_TEMPLATE_DATA_TABLE . "

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

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

}

{

}

else

{

}

}

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

}

if ($user_row['user_type'] == USER_FOUNDER)

{

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

$server_url = generate_board_url();

$email_template = ($user_row['user_type'] == USER_NORMAL) ? 'user_reactivate_account' : 'user_resend_inactive';

if ($user_row['user_type'] == USER_NORMAL)

WHERE user_id = $user_id";

$db->sql_query($sql);

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

}

include($phpbb_root_path . 'includes/functions_display.' . $phpEx);

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

if ($submit)

{

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

}

{

trigger_error($user->lang['USER_AVATAR_UPDATED'] . adm_back_link($this->u_action . '&amp;u=' . $user_row['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);

}

'features' => array('title' => 'ACP_BOARD_FEATURES', 'auth' => 'acl_a_board', 'cat' => array('ACP_BOARD_CONFIGURATION')),

'avatar' => array('title' => 'ACP_AVATAR_SETTINGS', 'auth' => 'acl_a_board', 'cat' => array('ACP_BOARD_CONFIGURATION')),

'message' => array('title' => 'ACP_MESSAGE_SETTINGS', 'auth' => 'acl_a_board', 'cat' => array('ACP_BOARD_CONFIGURATION', 'ACP_MESSAGES')),

'signature' => array('title' => 'ACP_SIGNATURE_SETTINGS', 'auth' => 'acl_a_board', 'cat' => array('ACP_BOARD_CONFIGURATION')),

'feed' => array('title' => 'ACP_FEED_SETTINGS', 'auth' => 'acl_a_board', 'cat' => array('ACP_BOARD_CONFIGURATION')),

'registration' => array('title' => 'ACP_REGISTER_SETTINGS', 'auth' => 'acl_a_board', 'cat' => array('ACP_BOARD_CONFIGURATION')),