- 'U_ACTION' => $this->u_action,

- )

- 'S_THUMBNAIL_SUPPORT' => (!$this->new_config['img_imagick'] && (!isset($supported_types['format']) || !sizeof($supported_types['format']))) ? false : true,

- )

- 'L_REMOVE_IPS' => $user->lang['REMOVE_' . $allow_deny . '_IPS'],

- )

- $extension_change_list = (isset($_POST['extension_change_list'])) ? array_map('intval', $_POST['extension_change_list']) : array();

- $group_select_list = (isset($_POST['group_select'])) ? array_map('intval', $_POST['group_select']) : array();

- $db->sql_query($sql);

- $extension_id_list = (isset($_POST['extension_id_list'])) ? array_map('intval', $_POST['extension_id_list']) : array();

- if ($add_extension != '' && $add)

-

-

- $allowed_forums = isset($_POST['allowed_forums']) ? array_map('intval', array_values($_POST['allowed_forums'])) : array();

- $allow_in_pm = isset($_POST['allow_in_pm']) ? true : false;

- $allow_group = (isset($_POST['allow_group'])) ? 1 : 0;

- 'allow_group' => $allow_group,

- 'allow_in_pm' => ($allow_in_pm) ? 1 : 0

- $extension_list = isset($_REQUEST['extensions']) ? array_map('intval', array_values($_REQUEST['extensions'])) : array();

-

- 'action' => $action,

-

-

-

- 'PHPBB_ROOT_PATH' => $phpbb_root_path,

- 'IMG_PATH' => $img_path,

- 'ACTION' => $action,

- 'GROUP_ID' => $group_id,

- 'GROUP_NAME' => $ext_group_row['group_name'],

- 'ALLOW_GROUP' => $ext_group_row['allow_group'],

- 'ALLOW_IN_PM' => $ext_group_row['allow_in_pm'],

- 'UPLOAD_ICON_SRC' => $phpbb_root_path . $img_path . '/' . $ext_group_row['upload_icon'],

- 'EXTGROUP_FILESIZE' => $ext_group_row['max_filesize'],

- 'L_LEGEND' => $user->lang[strtoupper($action) . '_EXTENSION_GROUP'],

- )

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

-

- break;

-

- case 'deactivate':

- case 'activate':

-

- if (!$group_id)

- {

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

- }

-

- $sql = 'UPDATE ' . EXTENSION_GROUPS_TABLE . '

- SET allow_group = ' . (($action == 'activate') ? '1' : '0') . "

- WHERE group_id = $group_id";

- $db->sql_query($sql);

-

- $this->rewrite_extensions();

- ORDER BY allow_group DESC, group_name';

- $act_deact = 'activate';

- $s_add_spacer = ($row['allow_group'] == 0 && $act_deact == 'deactivate') ? true : false;

-

- $act_deact = ($row['allow_group']) ? 'deactivate' : 'activate';

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

- 'L_ACT_DEACT' => $user->lang[strtoupper($act_deact)],

- $unip_sql = array_map('intval', $_POST['unip']);

- 'send_encoding' => array('lang' => 'SEND_ENCODING', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true),

- $j++;

- 'S_MOVE_FORUM_OPTIONS' => make_forum_select($forum_data['parent_id'], $subforums_id)) // , false, true, false???

- $log_action_forums = 'FORUMS';

- $log_action_forums = 'MOVE_FORUMS';

-

- // the forum name has changed, clear the parents list of child forums

- SET forum_parents = ''

- WHERE left_id > " . $row['left_id'] . '

- AND right_id < ' . $row['right_id'];

- if ($group_perm_from && $action == 'add')

- // From the mysql documentation:

- // Prior to MySQL 4.0.14, the target table of the INSERT statement cannot appear in the FROM clause of the SELECT part of the query. This limitation is lifted in 4.0.14.

- // Due to this we stay on the safe side if we do the insertion "the manual way"

-

- // Copy permisisons from/to the acl groups table (only group_id gets changed)

- $sql = 'SELECT forum_id, auth_option_id, auth_role_id, auth_setting

- FROM ' . ACL_GROUPS_TABLE . '

- $groups_sql_ary = array();

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

- $groups_sql_ary[] = array(

- 'group_id' => (int) $group_id,

- 'forum_id' => (int) $row['forum_id'],

- 'auth_option_id' => (int) $row['auth_option_id'],

- 'auth_role_id' => (int) $row['auth_role_id'],

- 'auth_setting' => (int) $row['auth_setting']

- );

- $db->sql_freeresult($result);

-

- // Now insert the data

- $db->sql_multi_insert(ACL_GROUPS_TABLE, $groups_sql_ary);

-

- $auth->acl_clear_prefetch();

- 'S_GROUP_OPTIONS' => group_select_options(0),

- $image_id = (isset($_POST['id'])) ? array_map('intval', $_POST['id']) : array();

- $image_order = (isset($_POST['order'])) ? array_map('intval', $_POST['order']) : array();

- $image_width = (isset($_POST['width'])) ? array_map('intval', $_POST['width']) : array();

- $image_height = (isset($_POST['height'])) ? array_map('intval', $_POST['height']) : array();

- $image_add = (isset($_POST['add_img'])) ? array_map('intval', $_POST['add_img']) : array();

- $image_display_on_posting = (isset($_POST['display_on_posting'])) ? array_map('intval', $_POST['display_on_posting']) : array();

- $sql = "DELETE FROM $table

- WHERE {$fields}_id = $icon_id";

- $db->sql_query($sql);

-

- switch ($mode)

- case 'smilies':

- break;

- case 'icons':

- // Reset appropriate icon_ids

- $db->sql_query('UPDATE ' . TOPICS_TABLE . "

- SET icon_id = 0

- WHERE icon_id = $icon_id");

- $db->sql_query('UPDATE ' . POSTS_TABLE . "

- SET icon_id = 0

- WHERE icon_id = $icon_id");

- break;

-

- $notice = $user->lang[$lang . '_DELETED'];

-

- $cache->destroy('icons');

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

- 'S_GROUP_OPTIONS' => group_select_options(false))

- 'S_ADD_GROUP_OPTIONS' => group_select_options(false, $items['group_ids']),

- // Ok, they want to delete their rank

- if ($rank_id)

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

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

- $sql = 'SELECT word

- FROM ' . WORDS_TABLE . "

- WHERE word_id = $word_id";

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

- $deleted_word = $db->sql_fetchfield('word');

- $db->sql_freeresult($result);

- $sql = 'DELETE FROM ' . WORDS_TABLE . "

- WHERE word_id = $word_id";

- $db->sql_query($sql);

- $cache->destroy('word_censors');

- add_log('admin', 'LOG_WORD_DELETE', $deleted_word);

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

-

- 'version_check' => array('title' => 'ACP_VERSION_CHECK', 'auth' => 'acl_a_', 'cat' => array('ACP_AUTOMATION')),

- function obtain_attach_extensions($forum_id = false)

-

- AND g.allow_group = 1';

- $extensions = array('_allowed_' => array());

- 'max_filesize' => (int) $row['max_filesize']

- if ($row['allow_in_pm'])

- $allowed_forums = array_merge($allowed_forums, array(0));

- // Store allowed extensions forum wise

- $extensions['_allowed_'][$extension] = (!sizeof($allowed_forums)) ? 0 : $allowed_forums;

- if ($forum_id !== false)

- $return = array();

- foreach ($extensions['_allowed_'] as $extension => $check)

- $allowed = false;

- // Check for private messaging AND all forums allowed

- if (sizeof($check) == 1 && $check[0] == 0)

- {

- $allowed = true;

- }

- else

- {

- $allowed = (!in_array($forum_id, $check)) ? false : true;

- }

- $allowed = ($forum_id === 0) ? false : true;

-* @param int $forum_id The forum id the attachments are displayed in (0 for private messages)

- $extensions = $cache->obtain_attach_extensions();

- $download_link = (!$force_physical && $attachment['attach_id']) ? append_sid("{$phpbb_root_path}download.$phpEx", 'id=' . $attachment['attach_id'] . '&amp;f=' . $forum_id) : $filename;

- $thumbnail_link = (!$force_physical && $attachment['attach_id']) ? append_sid("{$phpbb_root_path}download.$phpEx", 'id=' . $attachment['attach_id'] . '&amp;t=1&amp;f=' . $forum_id) : $thumbnail_filename;

-* Check if extension is allowed to be posted within forum X (forum_id 0 == private messaging)

- if (!sizeof($extensions))

- $extensions = $cache->obtain_attach_extensions();

- if (!isset($extensions['_allowed_'][$extension]))

- {

- return false;

- }

-

- $check = $extensions['_allowed_'][$extension];

-

- if (is_array($check))

- {

- // Check for private messaging AND all forums allowed

- if (sizeof($check) == 1 && $check[0] == 0)

- {

- return true;

- }

-

- return (!in_array($forum_id, $check)) ? false : true;

- }

-

- return ($forum_id == 0) ? false : true;

- if ($config['send_encoding'])

- {

- header('Content-type: text/html; charset=UTF-8');

- }

-* Generate list of groups

-function group_select_options($group_id, $exclude_ids = false)

- $forum_sql = 'AND ' . $db->sql_in_set('forum_id', $forum_id);

- $sql = 'SELECT *

- FROM ' . MODERATOR_CACHE_TABLE . "

- WHERE display_on_index = 1

- $forum_sql";

- $forum_moderators[$row['forum_id']][] = (!empty($row['user_id'])) ? '<a href="' . append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=viewprofile&amp;u=' . $row['user_id']) . '">' . $row['username'] . '</a>' : '<a href="' . append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=group&amp;g=' . $row['group_id']) . '">' . $row['group_name'] . '</a>';

- 'ACTIVE_FORUM_PCT' => sprintf($user->lang['POST_PCT_ACTIVE'], $active_f_pct),

- 'ACTIVE_TOPIC_PCT' => sprintf($user->lang['POST_PCT_ACTIVE'], $active_t_pct),

- $extensions = $cache->obtain_attach_extensions($forum_id);

- $msg_ids = (isset($_POST['marked_msg_id'])) ? array_map('intval', $_POST['marked_msg_id']) : array();

- else if (preg_match('#^([\w\-_]\.?){2,}$#is', trim($ban_item)))

- {

- // hostname

- $ip_ary = gethostbynamel(trim($ban_item));

-

- foreach ($ip_ary as $ip)

- {

- if ($ip)

- {

- $banlist_ary[] = $ip;

- }

- }

- }

- $delete_ids = isset($_REQUEST['attachment']) ? array_keys(array_map('intval', $_REQUEST['attachment'])) : array();

- $forums = (isset($_POST['f'])) ? array_map('intval', array_keys($_POST['f'])) : array();

- $topics = (isset($_POST['t'])) ? array_map('intval', array_keys($_POST['t'])) : array();

- $topics = (isset($_POST['t'])) ? array_map('intval', array_keys($_POST['t'])) : array();

- $drafts = (!empty($_POST['d'])) ? array_map('intval', array_keys($_POST['d'])) : array();

- $move_msg_ids = (isset($_POST['marked_msg_id'])) ? array_map('intval', $_POST['marked_msg_id']) : array();

- parse_attachments(0, $preview_message, $attachment_data, $update_count, true);

- parse_attachments(0, $message, $attachments, $update_count);