+include($phpbb_root_path . 'includes/functions_posting.' . $phpEx);

+ // check for similar value of old_size in Extension Groups. If so, update these values.

+ break;

+

+ case 'orphan':

+ $l_title = 'ORPHAN_ATTACHMENTS';

+ break;

+

+ default:

+ trigger_error('NO_MODE');

+ $extension_explain_list = request_var('extension_explain_list', '');

+ $sql = 'DELETE

+ FROM ' . EXTENSIONS_TABLE . '

+ WHERE extension_id IN (' . implode(', ', $extension_id_list) . ')';

+ $db->sql_query($sql);

+

+ $add_extension = strtolower(request_var('add_extension', ''));

+ $add_extension_explain = request_var('add_extension_explain', '');

+ WHERE extension = '" . $db->sql_escape($add_extension) . "'";

+ $sql_ary = array(

+ 'group_id' => $add_extension_group,

+ 'extension' => $add_extension,

+ 'comment' => $add_extension_explain

+ );

+

+ $db->sql_query('INSERT INTO ' . EXTENSIONS_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary));

+ $extension_group_list = request_var('extension_group_list', '');

+ $upload_icon_list = request_var('upload_icon_list', '');

+ $size_select_list = request_var('size_select_list', 'b');

+ $l_group_list = array();

+ $l_group_list[] = $row['group_name'];

+ $sql ='"UPDATE ' . EXTENSIONS_TABLE . '

+ WHERE group_id IN (' . implode(', ', $group_delete_list) . ')';

+ add_log('admin', 'LOG_ATTACH_EXTGROUP_DEL', implode(', ', $l_group_list));

+ FROM ' . EXTENSION_GROUPS_TABLE . "

+ WHERE group_name = '" . $db->sql_escape($extension_group) . "'";

+<?php

+

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

+{

+ $delete_files = array_keys(request_var('delete', ''));

+ $add_files = array_keys(request_var('add', ''));

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

+

+ foreach ($delete_files as $delete)

+ {

+ phpbb_unlink($upload_dir . '/' . $delete);

+ }

+

+ if (sizeof($delete_files))

+ {

+ add_log('admin', sprintf($user->lang['LOG_ATTACH_ORPHAN_DEL'], implode(', ', $delete_files)));

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

+ }

+

+ $upload_list = array();

+ foreach ($add_files as $file)

+ {

+ if (!in_array($file, $delete_files) && $post_ids[$file])

+ {

+ $upload_list[$post_ids[$file]] = $file;

+ }

+ }

+ unset($add_files);

+

+ if (sizeof($upload_list))

+ {

+?>

+ <h2><?php echo $user->lang['UPLOADING_FILES']; ?></h2>

+<?php

+ include($phpbb_root_path . 'includes/message_parser.' . $phpEx);

+ $message_parser = new parse_message(0);

+

+ $sql = 'SELECT forum_id, forum_name

+ FROM ' . FORUMS_TABLE;

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

+

+ $forum_names = array();

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

+ {

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

+ }

+ $db->sql_freeresult($result);

+

+ $sql = 'SELECT forum_id, topic_id, post_id

+ FROM ' . POSTS_TABLE . '

+ WHERE post_id IN (' . implode(', ', array_keys($upload_list)) . ')';

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

+

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

+ {

+ echo sprintf($user->lang['UPLOADING_FILE_TO'], $upload_list[$row['post_id']], $row['post_id']) . '<br />';

+ if (!$auth->acl_get('f_attach', $row['forum_id']))

+ {

+ echo '<span style="color:red">' . sprintf($user->lang['UPLOAD_DENIED_FORUM'], $forum_names[$row['forum_id']]) . '</span><br /><br />';

+ }

+ else

+ {

+ upload_file($row['post_id'], $row['topic_id'], $row['forum_id'], $upload_dir, $upload_list[$row['post_id']]);

+ }

+ }

+ }

+}

+

+

+$modes = array('manage', 'cats', 'extensions', 'ext_groups', 'orphan');

+<form name="attachments" method="post" action="admin_attachments.<?php echo "$phpEx$SID&amp;mode=$mode"; ?>">

+// Configuration

+// Special Categories

+ $db->sql_freeresult($result);

+

+// Extension Groups

+ $filename_list .= '<option value="' . $img . '">' . htmlspecialchars($img) . '</option>';

+ $size = request_var('size', 0);

+// Extensions

+

+// Orphan Attachments

+if ($mode == 'orphan')

+{

+ $attach_filelist = array();

+

+ $dir = @opendir($upload_dir);

+ while ($file = @readdir($dir))

+ {

+ if (is_file($upload_dir . '/' . $file) && filesize($upload_dir . '/' . $file) && $file != '.htaccess')

+ {

+ $attach_filelist[$file] = $file;

+ }

+ }

+ @closedir($dir);

+

+?>

+

+<script language="Javascript" type="text/javascript">

+<!--

+function marklist(match, name, status)

+{

+ len = eval('document.' + match + '.length');

+ object = eval('document.' + match);

+ for (i = 0; i < len; i++)

+ {

+ result = eval('object.elements[' + i + '].name.search(/' + name + '.+/)');

+ if (result != -1)

+ object.elements[i].checked = status;

+ }

+}

+//-->

+</script>

+

+<?php

+ $sql = 'SELECT physical_filename

+ FROM ' . ATTACHMENTS_DESC_TABLE;

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

+

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

+ {

+ unset($attach_filelist[$row['physical_filename']]);

+ }

+ $db->sql_freeresult($result);

+

+?>

+

+ <table class="bg" cellspacing="1" cellpadding="4" border="0" align="center" width="99%">

+ <tr>

+ <th align="center" colspan="5">Orphan Attachments</th>

+ </tr>

+ <tr>

+ <td class="spacer" colspan="5" height="1"><img src="../images/spacer.gif" alt="" width="1" height="1" /></td>

+ </tr>

+ <tr>

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

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

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

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

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

+ </tr>

+

+<?php

+ $i = 0;

+ foreach ($attach_filelist as $file)

+ {

+ $row_class = (++$i % 2 == 0) ? 'row2' : 'row1';

+ $filesize = @filesize($upload_dir . '/' . $file);

+ $size_lang = ($filesize >= 1048576) ? $user->lang['MB'] : ( ($filesize >= 1024) ? $user->lang['KB'] : $user->lang['BYTES'] );

+ $filesize = ($filesize >= 1048576) ? round((round($filesize / 1048576 * 100) / 100), 2) : (($filesize >= 1024) ? round((round($filesize / 1024 * 100) / 100), 2) : $filesize);

+?>

+<tr>

+ <td class="<?php echo $row_class; ?>"><a href="<?php echo $upload_dir . '/' . $file; ?>" class="gen" target="file"><?php echo $file; ?></a></td>

+ <td class="<?php echo $row_class; ?>"><?php echo $filesize . ' ' . $size_lang; ?></td>

+ <td class="<?php echo $row_class; ?>"><b class="gen">ID: </b><input type="text" name="post_id[<?php echo $file; ?>]" class="post" size="7" maxlength="10" value="<?php echo (!empty($post_ids[$file])) ? $post_ids[$file] : ''; ?>" /></td>

+ <td class="<?php echo $row_class; ?>"><input type="checkbox" name="add[<?php echo $file; ?>]" /></td>

+ <td class="<?php echo $row_class; ?>"><input type="checkbox" name="delete[<?php echo $file; ?>]" /></td>

+</tr>

+<?php

+ }

+

+?>

+ <tr>

+ <td class="cat" colspan="3"><input type="submit" name="submit" value="<?php echo $user->lang['SUBMIT']; ?>" class="btnmain" />&nbsp;&nbsp;<input type="reset" value="<?php echo $user->lang['RESET']; ?>" class="btnlite" /></td>

+ <td class="cat" align="left"><b><span class="gensmall"><a href="javascript:marklist('attachments', 'add', true);" class="gensmall"><?php echo $user->lang['MARK_ALL']; ?></a> :: <a href="javascript:marklist('attachments', 'add', false);" class="gensmall"><?php echo $user->lang['UNMARK_ALL']; ?></a></span></b></td>

+ <td class="cat" align="left"><b><span class="gensmall"><a href="javascript:marklist('attachments', 'delete', true);" class="gensmall"><?php echo $user->lang['MARK_ALL']; ?></a> :: <a href="javascript:marklist('attachments', 'delete', false);" class="gensmall"><?php echo $user->lang['UNMARK_ALL']; ?></a></span></b></td>

+ </tr>

+</table>

+<?php

+}

+

+// Upload already uploaded file... huh? are you kidding?

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

+ global $message_parser, $db, $user;

+

+ $message_parser->attachment_data = array();

+

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

+ $message_parser->filename_data['filename'] = $upload_dir . '/' . $filename;

+

+ $filedata = upload_attachment($filename, true, $upload_dir . '/' . $filename);

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

+ $message_parser->attachment_data = array(

+ 'physical_filename' => $filedata['destination_filename'],

+ 'real_filename' => $filedata['filename'],

+ 'comment' => $message_parser->filename_data['filecomment'],

+ 'extension' => $filedata['extension'],

+ 'mimetype' => $filedata['mimetype'],

+ 'filesize' => $filedata['filesize'],

+ 'filetime' => $filedata['filetime'],

+ 'thumbnail' => $filedata['thumbnail']

+ );

+

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

+ $filedata['post_attach'] = FALSE;

+ // Submit Attachment

+ $attach_sql = $message_parser->attachment_data;

+

+ $db->sql_transaction();

+

+ $sql = 'INSERT INTO ' . ATTACHMENTS_DESC_TABLE . ' ' . $db->sql_build_array('INSERT', $attach_sql);

+ $db->sql_query($sql);

+

+ $attach_sql = array(

+ 'attach_id' => $db->sql_nextid(),

+ 'post_id' => $post_id,

+ 'privmsgs_id' => 0,

+ 'user_id_from' => $user->data['user_id'],

+ 'user_id_to' => 0

+ );

+

+ $sql = 'INSERT INTO ' . ATTACHMENTS_TABLE . ' ' . $db->sql_build_array('INSERT', $attach_sql);

+ $db->sql_query($sql);

+

+ $sql = 'UPDATE ' . POSTS_TABLE . "

+ SET post_attachment = 1

+ WHERE post_id = $post_id";

+ $db->sql_query($sql);

+

+ $sql = 'UPDATE ' . TOPICS_TABLE . "

+ SET topic_attachment = 1

+ WHERE topic_id = $topic_id";

+ $db->sql_query($sql);

+

+ $db->sql_transaction('commit');

+

+ add_log('admin', sprintf($user->lang['LOG_ATTACH_FILEUPLOAD'], $post_id, $filename));

+ echo '<span style="color:green">' . $user->lang['SUCCESSFULLY_UPLOADED'] . '</span><br /><br />';

+ }

+ else if (sizeof($filedata['error']))

+ {

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

+ }

+ if ($config_name == 'bump_interval' && $submit)

+ {

+ $new['bump_interval'] = request_var('bump_interval', 0) . request_var('bump_type', '');

+ }

+

+ $bump_type = (string) preg_replace('#^[0-9]+([m|h|d])$#', '\1', $new['bump_interval']);

+ $bump_time = (int) preg_replace('#^([0-9]+)[m|h|d]$#', '\1', $new['bump_interval']);

+

+ $s_bump_type = '';

+ $types = array('m' => 'MINUTES', 'h' => 'HOURS', 'd' => 'DAYS');

+ foreach ($types as $type => $lang)

+ {

+ $selected = ($type == $bump_type) ? 'selected="selected" ' : '';

+ $s_bump_type .= '<option value="' . $type . '" ' . $selected . '>' . $user->lang[$lang] . '</option>';

+ }

+ <td class="row1"><b><?php echo $user->lang['BUMP_INTERVAL']; ?>: </b><br /><span class="gensmall"><?php echo $user->lang['BUMP_INTERVAL_EXPLAIN']; ?></span></td>

+ <td class="row2"><input class="post" type="text" size="3" maxlength="4" name="bump_interval" value="<?php echo $bump_time ?>" />&nbsp;<select name="bump_type"><?php echo $s_bump_type; ?></select></td>

+ </tr>

+ <tr>