-<?php

-/**

-*

-* @package ucp

-* @version $Id$

-* @copyright (c) 2005 phpBB Group

-* @license http://opensource.org/licenses/gpl-license.php GNU Public License

-*

-*/

-

-/**

-* @ignore

-*/

-if (!defined('IN_PHPBB'))

-{

- exit;

-}

-

-/**

-* ucp_attachments

-* User attachments

-* @package ucp

-*/

-class ucp_attachments

-{

- var $u_action;

-

- function main($id, $mode)

- {

- $start = request_var('start', 0);

- $sort_key = request_var('sk', 'a');

- $sort_dir = request_var('sd', 'a');

-

- $delete = phpbb_request::is_set_post('delete');

- $confirm = phpbb_request::is_set_post('confirm');

- $delete_ids = array_keys(request_var('attachment', array(0)));

-

- if ($delete && sizeof($delete_ids))

- {

- // Validate $delete_ids...

- $sql = 'SELECT attach_id

- FROM ' . ATTACHMENTS_TABLE . '

- WHERE poster_id = ' . phpbb::$user->data['user_id'] . '

- AND is_orphan = 0

- AND ' . phpbb::$db->sql_in_set('attach_id', $delete_ids);

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

-

- $delete_ids = array();

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

- {

- $delete_ids[] = $row['attach_id'];

- }

- phpbb::$db->sql_freeresult($result);

- }

-

- if ($delete && sizeof($delete_ids))

- {

- $s_hidden_fields = array(

- 'delete' => 1

- );

-

- foreach ($delete_ids as $attachment_id)

- {

- $s_hidden_fields['attachment'][$attachment_id] = 1;

- }

-

- if (confirm_box(true))

- {

- if (!function_exists('delete_attachments'))

- {

- include_once(PHPBB_ROOT_PATH . 'includes/functions_admin.' . PHP_EXT);

- }

-

- delete_attachments('attach', $delete_ids);

-

- meta_refresh(3, $this->u_action);

- $message = ((sizeof($delete_ids) == 1) ? phpbb::$user->lang['ATTACHMENT_DELETED'] : phpbb::$user->lang['ATTACHMENTS_DELETED']) . '<br /><br />' . sprintf(phpbb::$user->lang['RETURN_UCP'], '<a href="' . $this->u_action . '">', '</a>');

- trigger_error($message);

- }

- else

- {

- confirm_box(false, (sizeof($delete_ids) == 1) ? 'DELETE_ATTACHMENT' : 'DELETE_ATTACHMENTS', build_hidden_fields($s_hidden_fields));

- }

- }

-

- // Select box eventually

- $sort_key_text = array('a' => phpbb::$user->lang['SORT_FILENAME'], 'b' => phpbb::$user->lang['SORT_COMMENT'], 'c' => phpbb::$user->lang['SORT_EXTENSION'], 'd' => phpbb::$user->lang['SORT_SIZE'], 'e' => phpbb::$user->lang['SORT_DOWNLOADS'], 'f' => phpbb::$user->lang['SORT_POST_TIME'], 'g' => phpbb::$user->lang['SORT_TOPIC_TITLE']);

- $sort_key_sql = array('a' => 'a.real_filename', 'b' => 'a.attach_comment', 'c' => 'a.extension', 'd' => 'a.filesize', 'e' => 'a.download_count', 'f' => 'a.filetime', 'g' => 't.topic_title');

-

- $sort_dir_text = array('a' => phpbb::$user->lang['ASCENDING'], 'd' => phpbb::$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>';

- }

-

- if (!isset($sort_key_sql[$sort_key]))

- {

- $sort_key = 'a';

- }

-

- $order_by = $sort_key_sql[$sort_key] . ' ' . (($sort_dir == 'a') ? 'ASC' : 'DESC');

-

- $sql = 'SELECT COUNT(attach_id) as num_attachments

- FROM ' . ATTACHMENTS_TABLE . '

- WHERE poster_id = ' . phpbb::$user->data['user_id'] . '

- AND is_orphan = 0';

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

- $num_attachments = phpbb::$db->sql_fetchfield('num_attachments');

- phpbb::$db->sql_freeresult($result);

-

- $sql = 'SELECT a.*, t.topic_title, p.message_subject as message_title

- FROM ' . ATTACHMENTS_TABLE . ' a

- LEFT JOIN ' . TOPICS_TABLE . ' t ON (a.topic_id = t.topic_id AND a.in_message = 0)

- LEFT JOIN ' . PRIVMSGS_TABLE . ' p ON (a.post_msg_id = p.msg_id AND a.in_message = 1)

- WHERE a.poster_id = ' . phpbb::$user->data['user_id'] . "

- AND a.is_orphan = 0

- ORDER BY $order_by";

- $result = phpbb::$db->sql_query_limit($sql, phpbb::$config['topics_per_page'], $start);

-

- $row_count = 0;

- if ($row = phpbb::$db->sql_fetchrow($result))

- {

- phpbb::$template->assign_var('S_ATTACHMENT_ROWS', true);

-

- do

- {

- if ($row['in_message'])

- {

- $view_topic = append_sid('ucp', "i=pm&amp;p={$row['post_msg_id']}");

- }

- else

- {

- $view_topic = append_sid('viewtopic', "t={$row['topic_id']}&amp;p={$row['post_msg_id']}") . "#p{$row['post_msg_id']}";

- }

-

- phpbb::$template->assign_block_vars('attachrow', array(

- 'ROW_NUMBER' => $row_count + ($start + 1),

- 'FILENAME' => $row['real_filename'],

- 'COMMENT' => bbcode_nl2br($row['attach_comment']),

- 'EXTENSION' => $row['extension'],

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

- 'DOWNLOAD_COUNT' => $row['download_count'],

- 'POST_TIME' => phpbb::$user->format_date($row['filetime']),

- 'TOPIC_TITLE' => ($row['in_message']) ? $row['message_title'] : $row['topic_title'],

-

- 'ATTACH_ID' => $row['attach_id'],

- 'POST_ID' => $row['post_msg_id'],

- 'TOPIC_ID' => $row['topic_id'],

-

- 'S_IN_MESSAGE' => $row['in_message'],

-

- 'U_VIEW_ATTACHMENT' => append_sid('download/file', 'id=' . $row['attach_id']),

- 'U_VIEW_TOPIC' => $view_topic,

- ));

-

- $row_count++;

- }

- while ($row = phpbb::$db->sql_fetchrow($result));

- }

- phpbb::$db->sql_freeresult($result);

-

- phpbb::$template->assign_vars(array(

- 'PAGE_NUMBER' => on_page($num_attachments, phpbb::$config['topics_per_page'], $start),

- 'PAGINATION' => generate_pagination($this->u_action . "&amp;sk=$sort_key&amp;sd=$sort_dir", $num_attachments, phpbb::$config['topics_per_page'], $start),

- 'TOTAL_ATTACHMENTS' => $num_attachments,

-

- 'L_TITLE' => phpbb::$user->lang['UCP_ATTACHMENTS'],

-

- 'U_SORT_FILENAME' => $this->u_action . "&amp;sk=a&amp;sd=" . (($sort_key == 'a' && $sort_dir == 'a') ? 'd' : 'a'),

- 'U_SORT_FILE_COMMENT' => $this->u_action . "&amp;sk=b&amp;sd=" . (($sort_key == 'b' && $sort_dir == 'a') ? 'd' : 'a'),

- 'U_SORT_EXTENSION' => $this->u_action . "&amp;sk=c&amp;sd=" . (($sort_key == 'c' && $sort_dir == 'a') ? 'd' : 'a'),

- 'U_SORT_FILESIZE' => $this->u_action . "&amp;sk=d&amp;sd=" . (($sort_key == 'd' && $sort_dir == 'a') ? 'd' : 'a'),

- 'U_SORT_DOWNLOADS' => $this->u_action . "&amp;sk=e&amp;sd=" . (($sort_key == 'e' && $sort_dir == 'a') ? 'd' : 'a'),

- 'U_SORT_POST_TIME' => $this->u_action . "&amp;sk=f&amp;sd=" . (($sort_key == 'f' && $sort_dir == 'a') ? 'd' : 'a'),

- 'U_SORT_TOPIC_TITLE' => $this->u_action . "&amp;sk=g&amp;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' => $this->u_action,

- 'S_SORT_OPTIONS' => $s_sort_key,

- 'S_ORDER_SELECT' => $s_sort_dir,

- ));

-

- $this->tpl_name = 'ucp_attachments';

- $this->page_title = 'UCP_ATTACHMENTS';

- }

-}

-

-?> \ No newline at end of file