/**

*

* @package ucp

* @version $Id: ucp_attachments.php 8479 2008-03-29 00:22:48Z naderman $

* @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)

	{

		global $template, $user, $db, $config, $phpEx, $phpbb_root_path;

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

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

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

		$delete		= (isset($_POST['delete'])) ? true : false;

		$confirm	= (isset($_POST['confirm'])) ? true : false;

		$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 = ' . $user->data['user_id'] . '

					AND is_orphan = 0

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

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

			$delete_ids = array();

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

			{

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

			}

			$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.' . $phpEx);

				}

				delete_attachments('attach', $delete_ids);

				meta_refresh(3, $this->u_action);

				$message = ((sizeof($delete_ids) == 1) ? $user->lang['ATTACHMENT_DELETED'] : $user->lang['ATTACHMENTS_DELETED']) . '

' . sprintf($user->lang['RETURN_UCP'], '', '');

				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' => $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.attach_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>';

		}

		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 = ' . $user->data['user_id'] . '

				AND is_orphan = 0';

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

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

		$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 = ' . $user->data['user_id'] . "

				AND a.is_orphan = 0

			ORDER BY $order_by";

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

		$row_count = 0;

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

		{

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

			do

			{

				if ($row['in_message'])

				{

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

				}

				else

				{

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

				}

				$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'			=> $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("{$phpbb_root_path}download/file.$phpEx", 'id=' . $row['attach_id']),

					'U_VIEW_TOPIC'		=> $view_topic)

				);

				$row_count++;

			}

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

		}

		$db->sql_freeresult($result);

		$template->assign_vars(array(

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

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

			'TOTAL_ATTACHMENTS'		=> $num_attachments,

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

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

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

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

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

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

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

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

	}

}

?>