diff options
| author | Meik Sievertsen <acydburn@phpbb.com> | 2003-11-06 15:05:50 +0000 |
|---|---|---|
| committer | Meik Sievertsen <acydburn@phpbb.com> | 2003-11-06 15:05:50 +0000 |
| commit | 558b8ee7ff52183b2d70e67afaa2bc39be9f6a70 (patch) | |
| tree | d56192e21f8e38e512ef29182691a4870ba316a3 /phpBB/includes/ucp/ucp_attachments.php | |
| parent | 75ccd0e13cea666fafe63a9bfb99b1513d7d1126 (diff) | |
| download | forums-558b8ee7ff52183b2d70e67afaa2bc39be9f6a70.tar forums-558b8ee7ff52183b2d70e67afaa2bc39be9f6a70.tar.gz forums-558b8ee7ff52183b2d70e67afaa2bc39be9f6a70.tar.bz2 forums-558b8ee7ff52183b2d70e67afaa2bc39be9f6a70.tar.xz forums-558b8ee7ff52183b2d70e67afaa2bc39be9f6a70.zip | |
UCP -> Attachments
git-svn-id: file:///svn/phpbb/trunk@4652 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/includes/ucp/ucp_attachments.php')
| -rw-r--r-- | phpBB/includes/ucp/ucp_attachments.php | 152 |
1 files changed, 152 insertions, 0 deletions
diff --git a/phpBB/includes/ucp/ucp_attachments.php b/phpBB/includes/ucp/ucp_attachments.php new file mode 100644 index 0000000000..7b731300b3 --- /dev/null +++ b/phpBB/includes/ucp/ucp_attachments.php @@ -0,0 +1,152 @@ +<?php +// ------------------------------------------------------------- +// +// $Id$ +// +// FILENAME : ucp_attachments.php +// STARTED : Mon Nov 03, 2003 +// COPYRIGHT : � 2001, 2003 phpBB Group +// WWW : http://www.phpbb.com/ +// LICENCE : GPL vs2.0 [ see /docs/COPYING ] +// +// ------------------------------------------------------------- + +// +// * Use this for ucp integration - changeable user id +// + +class ucp_attachments extends module +{ + function ucp_attachments($id, $mode) + { + global $template, $user, $db, $config, $phpEx, $phpbb_root_path, $SID; + + $start = request_var('start', 0); + $delete = (isset($_POST['delete'])) ? true : false; + $confirm = (isset($_POST['confirm'])) ? true : false; + $delete_ids = isset($_REQUEST['attachment']) ? array_keys(array_map('intval', $_REQUEST['attachment'])) : array(); + + if ($delete && $confirm && sizeof($delete_ids)) + { + include($phpbb_root_path . 'includes/functions_admin.' . $phpEx); + delete_attachments('attach', $delete_ids); + + meta_refresh(3, "ucp.$phpEx$SID&i=$id"); + $message = ((sizeof($delete_ids) == 1) ? $user->lang['ATTACHMENT_DELETED'] : $user->lang['ATTACHMENTS_DELETED']) . '<br /><br />' . sprintf($user->lang['RETURN_UCP'], "<a href=\"ucp.$phpEx$SID&i=$id\">", '</a>'); + trigger_error($message); + } + else if ($delete && sizeof($delete_ids)) + { + $s_hidden_fields = '<input type="hidden" name="delete" value="1" />'; + foreach ($delete_ids as $attachment_id) + { + $s_hidden_fields .= '<input type="hidden" name="attachment[' . $attachment_id . ']" value="1" />'; + } + + // Confirm Attachment Deletion + $template->assign_vars(array( + 'S_CONFIRM_DELETE' => true, + 'S_HIDDEN_FIELDS' => $s_hidden_fields, + 'L_TITLE' => $user->lang['UCP_ATTACH'], + + 'MESSAGE_TITLE' => $user->lang['CONFIRM'], + 'MESSAGE_TEXT' => (sizeof($delete_ids) == 1) ? $user->lang['CONFIRM_DELETE_ATTACHMENT'] : $user->lang['CONFIRM_DELETE_ATTACHMENTS'], + 'S_UCP_ACTION' => "ucp.$phpEx$SID&i=$id") + ); + + $this->display($user->lang['UCP_ATTACHMENTS'], 'ucp_attachments.html'); + exit; + } + + $sort_key = request_var('sk', 'a'); + $sort_dir = request_var('sd', 'a'); + + // Select box eventually + $sort_key_text = array('a' => $user->lang['SORT_FILENAME'], 'b' => $user->lang['SORT_COMMENT'], 'c' => $user->lang['SORT_EXTENSION'], 'd' => $user->lang['SORT_SIZE'], 'e' => $user->lang['SORT_DOWNLOADS'], 'f' => $user->lang['SORT_POST_TIME'], 'g' => $user->lang['SORT_TOPIC_TITLE']); + $sort_key_sql = array('a' => 'a.real_filename', 'b' => 'a.comment', 'c' => 'a.extension', 'd' => 'a.filesize', 'e' => 'a.download_count', 'f' => 'a.filetime', 'g' => 't.topic_title'); + + $sort_dir_text = array('a' => $user->lang['ASCENDING'], 'd' => $user->lang['DESCENDING']); + + $s_sort_key = ''; + foreach ($sort_key_text as $key => $value) + { + $selected = ($sort_key == $key) ? ' selected="selected"' : ''; + $s_sort_key .= '<option value="' . $key . '"' . $selected . '>' . $value . '</option>'; + } + + $s_sort_dir = ''; + foreach ($sort_dir_text as $key => $value) + { + $selected = ($sort_dir == $key) ? ' selected="selected"' : ''; + $s_sort_dir .= '<option value="' . $key . '"' . $selected . '>' . $value . '</option>'; + } + + $order_by = $sort_key_sql[$sort_key] . ' ' . (($sort_dir == 'a') ? 'ASC' : 'DESC'); + + $sql = 'SELECT COUNT(*) as num_attachments + FROM ' . ATTACHMENTS_TABLE . ' + WHERE poster_id = ' . $user->data['user_id']; + $result = $db->sql_query_limit($sql, 1); + $num_attachments = $db->sql_fetchfield('num_attachments', 0, $result); + $db->sql_freeresult($result); + + $sql = 'SELECT a.*, t.topic_title + FROM ' . ATTACHMENTS_TABLE . ' a, ' . TOPICS_TABLE . ' t + WHERE a.topic_id = t.topic_id + AND a.poster_id = ' . $user->data['user_id'] . ' + ORDER BY ' . $order_by; + $result = $db->sql_query_limit($sql, $config['posts_per_page'], $start); + + $i = 0; + while ($row = $db->sql_fetchrow($result)) + { + $topic_title = (strlen($row['topic_title']) > 32) ? substr($row['topic_title'], 0, 30) . '...' : $row['topic_title']; + $view_topic = "{$phpbb_root_path}viewtopic.$phpEx$SID&t=" . $row['topic_id'] . '&p=' . $row['post_id'] . '#' . $row['post_id']; + $topic_title = '<a href="' . $view_topic . '" class="gen" target="_blank">' . $topic_title . '</a>'; + + $template->assign_block_vars('attachrow', array( + 'ROW_NUMBER' => $i + ($start + 1), + 'S_ROW_COUNT' => $i, + + 'ATTACH_ID' => $row['attach_id'], + 'FILENAME' => $row['real_filename'], + 'COMMENT' => str_replace("\n", '<br />', $row['comment']), + 'EXTENSION' => $row['extension'], + + 'SIZE' => ($row['filesize'] >= 1048576) ? (round($row['filesize'] / 1048576 * 100) / 100) . ' ' . $user->lang['MB'] : (($row['filesize'] >= 1024) ? (round($row['filesize'] / 1024 * 100) / 100) . ' ' . $user->lang['KB'] : $row['filesize'] . ' ' . $user->lang['BYTES']), + 'DOWNLOAD_COUNT' => $row['download_count'], + 'POST_TIME' => $user->format_date($row['filetime'], $user->lang['DATE_FORMAT']), + 'TOPIC_TITLE' => $topic_title, + + 'U_VIEW_ATTACHMENT' => $phpbb_root_path . 'download.' . $phpEx . $SID . '&id=' . $row['attach_id']) + ); + $i++; + } + $db->sql_freeresult($result); + + $template->assign_vars(array( + 'PAGE_NUMBER' => on_page($num_attachments, $config['posts_per_page'], $start), + 'PAGINATION' => generate_pagination("ucp.$phpEx$SID&i=$id&sk=$sort_key&sd=$sort_dir", $num_attachments, $config['posts_per_page'], $start), + + 'L_TITLE' => $user->lang['UCP_ATTACH'], + + 'U_SORT_FILENAME' => "ucp.$phpEx$SID&i=$id&sk=a&sd=" . (($sort_key == 'a' && $sort_dir == 'a') ? 'd' : 'a'), + 'U_SORT_FILE_COMMENT' => "ucp.$phpEx$SID&i=$id&sk=b&sd=" . (($sort_key == 'b' && $sort_dir == 'a') ? 'd' : 'a'), + 'U_SORT_EXTENSION' => "ucp.$phpEx$SID&i=$id&sk=c&sd=" . (($sort_key == 'c' && $sort_dir == 'a') ? 'd' : 'a'), + 'U_SORT_FILESIZE' => "ucp.$phpEx$SID&i=$id&sk=d&sd=" . (($sort_key == 'd' && $sort_dir == 'a') ? 'd' : 'a'), + 'U_SORT_DOWNLOADS' => "ucp.$phpEx$SID&i=$id&sk=e&sd=" . (($sort_key == 'e' && $sort_dir == 'a') ? 'd' : 'a'), + 'U_SORT_POST_TIME' => "ucp.$phpEx$SID&i=$id&sk=f&sd=" . (($sort_key == 'f' && $sort_dir == 'a') ? 'd' : 'a'), + 'U_SORT_TOPIC_TITLE' => "ucp.$phpEx$SID&i=$id&sk=g&sd=" . (($sort_key == 'f' && $sort_dir == 'a') ? 'd' : 'a'), + + 'S_DISPLAY_MARK_ALL' => ($num_attachments) ? true : false, + 'S_DISPLAY_PAGINATION' => ($num_attachments) ? true : false, + 'S_UCP_ACTION' => "ucp.$phpEx$SID&i=$id", + 'S_SORT_OPTIONS' => $s_sort_key, + 'S_ORDER_SELECT' => $s_sort_dir) + ); + + $this->display($user->lang['UCP_ATTACHMENTS'], 'ucp_attachments.html'); + } +} + +?>
\ No newline at end of file |