if ($mode == 'attach')

{

$config_sizes = array('max_filesize' => 'size', 'attachment_quota' => 'quota_size', 'max_filesize_pm' => 'pm_size');

foreach ($config_sizes as $cfg_key => $var)

{

{

$sql = 'SELECT group_id

FROM ' . EXTENSION_GROUPS_TABLE . "

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

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

{

$upload_icon = request_var('upload_icon', 'no_image');

$size_select = request_var('size_select', 'b');

$forum_select = request_var('forum_select', false);

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

$max_filesize = ($size_select == 'kb') ? round($max_filesize * 1024) : (($size_select == 'mb') ? round($max_filesize * 1048576) : $max_filesize);

$group_ary = array(

'group_name' => $group_name,

'cat_id' => request_var('special_category', ATTACHMENT_CATEGORY_NONE),

'download_mode' => request_var('download_mode', INLINE_LINK),

'upload_icon' => ($upload_icon == 'no_image') ? '' : $upload_icon,

'max_filesize' => $max_filesize,

if ($submit && $mode == 'orphan')

{

$post_ids = request_var('post_id', 0);

foreach ($delete_files as $delete)

$action = request_var('action', 'show');

$group_id = request_var('g', 0);

$action = (($action == 'add' || $action == 'edit') && $submit && !sizeof($error)) ? 'show' : $action;

{

$action = 'show';

}

WHERE group_id = $group_id";

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

$group_name = $db->sql_fetchfield('group_name', 0, $result);

$sql = 'DELETE

FROM ' . EXTENSION_GROUPS_TABLE . "

WHERE group_id = $group_id";

<th>&nbsp;<?php echo $user->lang['ADD_EXTENSION']; ?>&nbsp;</th>

</tr>

<tr>

<td class="row2" align="center" valign="middle"><?php echo (($submit) ? group_select('add_group_select', $add_extension_group) : group_select('add_group_select')) ?></td>

<td class="row1" align="center" valign="middle"><input type="checkbox" name="add_extension_check" /></td>

</tr>

adm_page_footer();

// Build Select for category items

{

global $db, $user;

{

$sql = 'SELECT cat_id

FROM ' . EXTENSION_GROUPS_TABLE . '

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

$cat_type = (!($row = $db->sql_fetchrow($result))) ? ATTACHMENT_CATEGORY_NONE : $row['cat_id'];

}

// Extension group select

{

global $db, $user;

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

$group_name[] = $row;

{

{

$selected = ($i == 0) ? ' selected="selected"' : '';

}

{

$sql = "SELECT download_mode

FROM " . EXTENSION_GROUPS_TABLE . "

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

$download_mode = (!($row = $db->sql_fetchrow($result))) ? INLINE_LINK : $row['download_mode'];

return $group_select;

}

function upload_file($post_id, $topic_id, $forum_id, $upload_dir, $filename)

{

global $message_parser, $db, $user, $phpbb_root_path;

$message_parser->filename_data['filecomment'] = '';

$message_parser->filename_data['filename'] = $phpbb_root_path . $upload_dir . '/' . basename($filename);

if ($filedata['post_attach'] && !sizeof($filedata['error']))

{

echo '<span style="color:red">' . sprintf($user->lang['ADMIN_UPLOAD_ERROR'], implode("<br />\t", $filedata['error'])) . '</span><br /><br />';

}

}

// Search Imagick

function search_imagemagick()

// Do we have general permissions?

if (!$auth->acl_get('a_bbcode'))

{

}

// Set up general vars

// Set up mode-specific vars

switch ($mode)

{

case 'add':

$bbcode_match = $bbcode_tpl = '';

case 'edit':

$sql = 'SELECT bbcode_match, bbcode_tpl

{

trigger_error('BBCODE_NOT_EXIST');

}

$bbcode_match = $row['bbcode_match'];

$bbcode_tpl = htmlspecialchars($row['bbcode_tpl']);

case 'modify':

$sql = 'SELECT bbcode_id

{

trigger_error('BBCODE_NOT_EXIST');

}

// No break here

case 'create':

$bbcode_match = htmlspecialchars(stripslashes($_POST['bbcode_match']));

$bbcode_tpl = stripslashes($_POST['bbcode_tpl']);

}

// Do major work

<?php

adm_page_footer();

case 'modify':

case 'create':

$data = build_regexp($bbcode_match, $bbcode_tpl);

$sql_ary = array(

);

if ($mode == 'create')

HAVING MIN(b2.bbcode_id) > b1.bbcode_id + 1

ORDER BY b1.bbcode_id ASC';

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

{

}

else

{

FROM ' . BBCODES_TABLE;

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

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

if (empty($row['min_id']) || $row['min_id'] >= NUM_CORE_BBCODES)

{

add_log('admin', $log_action, $data['bbcode_tag']);

trigger_error($lang);

case 'delete':

$sql = 'SELECT bbcode_tag

$db->sql_query('DELETE FROM ' . BBCODES_TABLE . " WHERE bbcode_id = $bbcode_id");

add_log('admin', 'LOG_BBCODE_DELETE', $row['bbcode_tag']);

}

// No break here

</tr>

<?php

}

?>

$sp_replace = preg_replace('#\[/?' . $bbcode_tag . '#ie', "strtolower('\$0')", $sp_replace);

return array(

);

}

// End Functions

// -----------------------------

?> \ No newline at end of file

WHERE bot_id $id";

$db->sql_query($sql);

}

break;

case 'deactivate':

WHERE bot_id $id";

$db->sql_query($sql);

}

break;

case 'delete':

$db->sql_transaction('commit');

add_log('admin', 'LOG_BOT_DELETE', implode(', ', $bot_name_ary));

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

}

{

$error[] = $user->lang['ERR_BOT_NO_MATCHES'];

}

if ($bot_ip && !preg_match('#^[\d\.,:]+$#', $bot_ip))

{

if (!$ip_list = gethostbynamel($bot_ip))

$db->sql_transaction('commit');

add_log('admin', 'LOG_BOT_' . $log, $bot_name);

trigger_error($user->lang['BOT_' . $log]);

}

ORDER BY u.user_lastvisit DESC';

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

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

{

$row_class = ($row_class == 'row1') ? 'row2' : 'row1';

<tr>

<td class="row1" width="40%"><b><?php echo $user->lang[$l_type . '_NAME']; ?>:</b></td>

<td class="row2"><?php

$style_copyright = '(c) 2004 Tom Beddard';

echo ($action == 'add') ? '<input class="post" type="text" name="name" maxlength="30" size="30" value="' . $name . '" />' : '<b>' . ${$type . '_name'} . '</b>';

}

/**

* Generate board url

*/

function generate_board_url()

$linecount = sizeof($lines);

$in_comment = false;

{

{

$in_comment = true;

}

$output .= $lines[$i] . "\n";

}

{

$in_comment = false;

}

include_once($phpbb_root_path . 'includes/functions_upload.php');

$upload = new fileupload();

if (!$filedata['post_attach'])

{

return $filedata;

}

// Opera adds the name to the mime type

$this->mimetype = (strpos($this->mimetype, '; name') !== false) ? str_replace(strstr($this->mimetype, '; name'), '', $this->mimetype) : $this->mimetype;

$this->extension = array_pop(explode('.', strtolower($this->realname)));

// Try to get real filesize from temporary folder (not always working) ;)

function is_uploaded()

{

}

function remove()

}

// Move file from another location to phpBB

{

}

/**

$bot = false;

// Pull bot information from DB and loop through it

{

if ($row['bot_agent'] && preg_match('#' . preg_quote($row['bot_agent'], '#') . '#i', $this->browser))

{

break;

}

}

// Garbage collection ... remove old sessions updating user information

// if necessary. It means (potentially) 11 queries but only infrequently

$style = ($style) ? $style : ((!$config['override_user_style'] && $this->data['user_id'] != ANONYMOUS) ? $this->data['user_style'] : $config['default_style']);

}

switch (SQL_LAYER)

{

case 'mssql':

WHERE s.style_id IN ($style, " . $config['default_style'] . ')

AND t.template_id = s.template_id

AND c.theme_id = s.theme_id

break;

default:

FROM ' . STYLES_TABLE . ' s, ' . STYLES_TPL_TABLE . ' t, ' . STYLES_CSS_TABLE . ' c, ' . STYLES_IMAGE_TABLE . " i

WHERE s.style_id IN ($style, " . $config['default_style'] . ')

AND t.template_id = s.template_id

AND c.theme_id = s.theme_id

break;

}

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

}

else

{

{

}

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

// Grab all topic data

$rowset = $announcement_list = $topic_list = array();

$sql_approved = ($auth->acl_get('m_approve', $forum_id)) ? '' : 'AND t.topic_approved = 1';

$sql_select = (($config['load_db_lastread'] || $config['load_db_track']) && $user->data['is_registered']) ? ', tt.mark_type, tt.mark_time' : '';

}

// Obtain other topics

$sql_where = ($forum_data['forum_type'] == FORUM_POST || !sizeof($active_forum_ary)) ? "= $forum_id" : 'IN (' . implode(', ', $active_forum_ary['forum_id']) . ')';

FROM $sql_from

WHERE t.forum_id $sql_where

AND t.topic_type NOT IN (" . POST_ANNOUNCE . ', ' . POST_GLOBAL . ")

if ($user->data['is_registered'])

{

}

// Join to forum table on topic forum_id unless topic forum_id is zero

}

$sql = 'SELECT u.username, u.user_id, u.user_colour, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_jabber, u.user_regdate, u.user_msnm, u.user_allow_viewemail, u.user_allow_viewonline, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_sig_bbcode_bitfield, u.user_avatar, u.user_avatar_type, u.user_avatar_width, u.user_avatar_height, z.friend, z.foe, p.*

WHERE p.post_id IN (' . implode(', ', $post_list) . ')

AND u.user_id = p.poster_id';

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

}

}

}

$db->sql_freeresult($result);

// Load custom profile fields

FROM ' . TOPICS_TRACK_TABLE . '

WHERE user_id = ' . $user->data['user_id'] . "

AND topic_id = $topic_id";

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

$db->sql_freeresult($result);