FROM ' . EXTENSION_GROUPS_TABLE . '

WHERE cat_id > 0

ORDER BY cat_id';

$s_assigned_groups = array();

{

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

}

$l_legend_cat_images = phpbb::$user->lang['SETTINGS_CAT_IMAGES'] . ' [' . phpbb::$user->lang['ASSIGNED_GROUP'] . ': ' . ((!empty($s_assigned_groups[ATTACHMENT_CATEGORY_IMAGE])) ? implode(', ', $s_assigned_groups[ATTACHMENT_CATEGORY_IMAGE]) : phpbb::$user->lang['NO_EXT_GROUP']) . ']';

$sql = 'SELECT *

FROM ' . SITELIST_TABLE;

$defined_ips = '';

$ips = array();

{

$value = ($row['site_ip']) ? $row['site_ip'] : $row['site_hostname'];

if ($value)

$ips[$row['site_id']] = $value;

}

}

$template->assign_vars(array(

'S_SECURE_DOWNLOADS' => $this->new_config['secure_downloads'],

$sql = 'SELECT *

FROM ' . EXTENSIONS_TABLE . '

ORDER BY extension_id';

{

if ($row['group_id'] != $extensions[$row['extension_id']]['group_id'])

{

$sql = 'UPDATE ' . EXTENSIONS_TABLE . '

SET group_id = ' . (int) $extensions[$row['extension_id']]['group_id'] . '

WHERE extension_id = ' . $row['extension_id'];

add_log('admin', 'LOG_ATTACH_EXT_UPDATE', $row['extension']);

}

}

// Delete Extension?

$extension_id_list = request_var('extension_id_list', array(0));

{

$sql = 'SELECT extension

FROM ' . EXTENSIONS_TABLE . '

$extension_list = '';

{

$extension_list .= ($extension_list == '') ? $row['extension'] : ', ' . $row['extension'];

}

$sql = 'DELETE

FROM ' . EXTENSIONS_TABLE . '

add_log('admin', 'LOG_ATTACH_EXT_DEL', $extension_list);

}

{

$sql = 'SELECT extension_id

FROM ' . EXTENSIONS_TABLE . "

{

$error[] = sprintf(phpbb::$user->lang['EXTENSION_EXIST'], $add_extension);

}

if (!sizeof($error))

{

'extension' => $add_extension

);

add_log('admin', 'LOG_ATTACH_EXT_ADD', $add_extension);

}

}

$sql = 'SELECT *

FROM ' . EXTENSIONS_TABLE . '

ORDER BY group_id, extension';

{

$old_group_id = $row['group_id'];

do

'GROUP_OPTIONS' => $this->group_select('group_select[]', $row['group_id']))

);

}

}

break;

$sql = 'SELECT *

FROM ' . EXTENSION_GROUPS_TABLE . "

WHERE group_id = $group_id";

if (!$ext_row)

{

{

$sql = 'SELECT group_name

FROM ' . EXTENSION_GROUPS_TABLE;

$clean_group_name = utf8_clean_string($new_group_name);

{

if (utf8_clean_string($row['group_name']) === $clean_group_name)

{

break;

}

}

}

if (!sizeof($error))

// @TODO: rewrite with the new param db functions

$sql = ($action == 'add') ? 'INSERT INTO ' . EXTENSION_GROUPS_TABLE . ' ' : 'UPDATE ' . EXTENSION_GROUPS_TABLE . ' SET ';

$sql .= ($action == 'edit') ? " WHERE group_id = $group_id" : '';

if ($action == 'add')

{

}

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

$sql = 'UPDATE ' . EXTENSIONS_TABLE . "

SET group_id = 0

WHERE group_id = $group_id";

}

if (sizeof($extension_list))

{

$sql = 'UPDATE ' . EXTENSIONS_TABLE . "

SET group_id = $group_id

}

phpbb::$acm->destroy('extensions');

$sql = 'SELECT group_name

FROM ' . EXTENSION_GROUPS_TABLE . "

WHERE group_id = $group_id";

$sql = 'DELETE

FROM ' . EXTENSION_GROUPS_TABLE . "

WHERE group_id = $group_id";

// Set corresponding Extensions to a pending Group

$sql = 'UPDATE ' . EXTENSIONS_TABLE . "

SET group_id = 0

WHERE group_id = $group_id";

add_log('admin', 'LOG_ATTACH_EXTGROUP_DEL', $group_name);

$sql = 'SELECT *

FROM ' . EXTENSION_GROUPS_TABLE . "

WHERE group_id = $group_id";

$forum_ids = (!$ext_group_row['allowed_forums']) ? array() : unserialize(trim($ext_group_row['allowed_forums']));

WHERE group_id = $group_id

OR group_id = 0

ORDER BY extension";

if ($ext_group_row['max_filesize'] == 0)

{

$sql = 'SELECT forum_id, forum_name, parent_id, forum_type, left_id, right_id

FROM ' . FORUMS_TABLE . '

ORDER BY left_id ASC';

$right = $cat_right = $padding_inc = 0;

$padding = $forum_list = $holding = '';

$padding_store = array('0' => '');

{

if ($row['forum_type'] == FORUM_CAT && ($row['left_id'] + 1 == $row['right_id']))

{

$s_forum_id_options .= $holding;

}

unset($padding_store);

$template->assign_vars(array(

$sql = 'SELECT *

FROM ' . EXTENSION_GROUPS_TABLE . '

ORDER BY allow_group DESC, allow_in_pm DESC, group_name';

$old_allow_group = $old_allow_pm = 1;

{

$s_add_spacer = ($old_allow_group != $row['allow_group'] || $old_allow_pm != $row['allow_in_pm']) ? true : false;

$old_allow_group = $row['allow_group'];

$old_allow_pm = $row['allow_in_pm'];

}

break;

{

$sql = 'SELECT *

FROM ' . ATTACHMENTS_TABLE . '

AND is_orphan = 1';

$delete_files = array();

{

phpbb_unlink($row['physical_filename'], 'file');

$delete_files[$row['attach_id']] = $row['real_filename'];

}

}

if (sizeof($delete_files))

{

$sql = 'DELETE FROM ' . ATTACHMENTS_TABLE . '

add_log('admin', 'LOG_ATTACH_ORPHAN_DEL', implode(', ', $delete_files));

$notify[] = sprintf(phpbb::$user->lang['LOG_ATTACH_ORPHAN_DEL'], implode(', ', $delete_files));

$sql = 'SELECT forum_id, forum_name

FROM ' . FORUMS_TABLE;

$forum_names = array();

{

$forum_names[$row['forum_id']] = $row['forum_name'];

}

$sql = 'SELECT forum_id, topic_id, post_id, poster_id

FROM ' . POSTS_TABLE . '

$post_info = array();

{

$post_info[$row['post_id']] = $row;

}

// Select those attachments we want to change...

$sql = 'SELECT *

FROM ' . ATTACHMENTS_TABLE . '

AND is_orphan = 1';

$files_added = $space_taken = 0;

{

$post_row = $post_info[$upload_list[$row['attach_id']]];

);

$sql = 'UPDATE ' . ATTACHMENTS_TABLE . '

WHERE attach_id = ' . $row['attach_id'];

$sql = 'UPDATE ' . POSTS_TABLE . '

SET post_attachment = 1

WHERE post_id = ' . $post_row['post_id'];

$sql = 'UPDATE ' . TOPICS_TABLE . '

SET topic_attachment = 1

WHERE topic_id = ' . $post_row['topic_id'];

$space_taken += $row['filesize'];

$files_added++;

add_log('admin', 'LOG_ATTACH_FILEUPLOAD', $post_row['post_id'], $row['real_filename']);

}

if ($files_added)

{

WHERE is_orphan = 1

AND filetime < ' . (time() - 3*60*60) . '

ORDER BY filetime DESC';

{

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

'FILESIZE' => get_formatted_filesize($row['filesize']),

'U_FILE' => append_sid('download/file', 'mode=view&amp;id=' . $row['attach_id']))

);

}

break;

}

$sql = 'SELECT cat_id

FROM ' . EXTENSION_GROUPS_TABLE . '

WHERE group_id = ' . (int) $group_id;

}

else

{

$sql = 'SELECT group_id, group_name

FROM ' . EXTENSION_GROUPS_TABLE . '

ORDER BY group_name';

$group_name = array();

{

$group_name[] = $row;

}

$row['group_id'] = 0;

$row['group_name'] = phpbb::$user->lang['NOT_ASSIGNED'];

$sql = 'SELECT site_ip, site_hostname

FROM ' . SITELIST_TABLE . "

WHERE ip_exclude = $ip_exclude";

{

$iplist_tmp = array();

$hostlist_tmp = array();

}

// break;

}

$iplist = array_unique(array_diff($iplist, $iplist_tmp));

$hostlist = array_unique(array_diff($hostlist, $hostlist_tmp));

unset($iplist_tmp);

unset($hostlist_tmp);

}

if (sizeof($iplist))

{

{

$sql = 'INSERT INTO ' . SITELIST_TABLE . " (site_ip, ip_exclude)

VALUES ($ip_entry, $ip_exclude)";

}

}

{

$sql = 'INSERT INTO ' . SITELIST_TABLE . " (site_hostname, ip_exclude)

VALUES ($host_entry, $ip_exclude)";

}

}

// Grab details of ips for logging information later

$sql = 'SELECT site_ip, site_hostname

FROM ' . SITELIST_TABLE . '

{

$l_unip_list .= (($l_unip_list != '') ? ', ' : '') . (($row['site_ip']) ? $row['site_ip'] : $row['site_hostname']);

}

$sql = 'DELETE FROM ' . SITELIST_TABLE . '

add_log('admin', 'LOG_DOWNLOAD_REMOVE_IP', $l_unip_list);

}