← Back to branch summary

~azzar1/unity/add-show-desktop-key

« back to all changes in this revision

Viewing changes to www/php/phpBB3/includes/ucp/ucp_attachments.php

  • Committer: William Grant
  • Date: 2009-02-23 23:47:02 UTC
  • mfrom: (1099.1.211 new-dispatch)
  • Revision ID: grantw@unimelb.edu.au-20090223234702-db4b1llly46ignwo
Merge from lp:~ivle-dev/ivle/new-dispatch.

Pretty much everything changes. Reread the setup docs. Backup your databases.
Every file is now in a different installed location, the configuration system
is rewritten, the dispatch system is rewritten, URLs are different, the
database is different, worksheets and exercises are no longer on the
filesystem, we use a templating engine, jail service protocols are rewritten,
we don't repeat ourselves, we have authorization rewritten, phpBB is gone,
and probably lots of other things that I cannot remember.

This is certainly the biggest commit I have ever made, and hopefully
the largest I ever will.

Show diffs side-by-side

added added

removed removed

Lines of Context:
www/php/phpBB3/includes/ucp/ucp_attachments.php
1
 
<?php
2
 
/**
3
 
*
4
 
* @package ucp
5
 
* @version $Id: ucp_attachments.php,v 1.29 2007/10/05 14:36:33 acydburn Exp $
6
 
* @copyright (c) 2005 phpBB Group
7
 
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
8
 
*
9
 
*/
10
 
 
11
 
/**
12
 
* @ignore
13
 
*/
14
 
if (!defined('IN_PHPBB'))
15
 
{
16
 
        exit;
17
 
}
18
 
 
19
 
/**
20
 
* ucp_attachments
21
 
* User attachments
22
 
* @package ucp
23
 
*/
24
 
class ucp_attachments
25
 
{
26
 
        var $u_action;
27
 
 
28
 
        function main($id, $mode)
29
 
        {
30
 
                global $template, $user, $db, $config, $phpEx, $phpbb_root_path;
31
 
 
32
 
                $start          = request_var('start', 0);
33
 
                $sort_key       = request_var('sk', 'a');
34
 
                $sort_dir       = request_var('sd', 'a');
35
 
 
36
 
                $delete         = (isset($_POST['delete'])) ? true : false;
37
 
                $confirm        = (isset($_POST['confirm'])) ? true : false;
38
 
                $delete_ids     = array_keys(request_var('attachment', array(0)));
39
 
 
40
 
                if ($delete && sizeof($delete_ids))
41
 
                {
42
 
                        // Validate $delete_ids...
43
 
                        $sql = 'SELECT attach_id
44
 
                                FROM ' . ATTACHMENTS_TABLE . '
45
 
                                WHERE poster_id = ' . $user->data['user_id'] . '
46
 
                                        AND is_orphan = 0
47
 
                                        AND ' . $db->sql_in_set('attach_id', $delete_ids);
48
 
                        $result = $db->sql_query($sql);
49
 
 
50
 
                        $delete_ids = array();
51
 
                        while ($row = $db->sql_fetchrow($result))
52
 
                        {
53
 
                                $delete_ids[] = $row['attach_id'];
54
 
                        }
55
 
                        $db->sql_freeresult($result);
56
 
                }
57
 
 
58
 
                if ($delete && sizeof($delete_ids))
59
 
                {
60
 
                        $s_hidden_fields = array(
61
 
                                'delete'        => 1
62
 
                        );
63
 
 
64
 
                        foreach ($delete_ids as $attachment_id)
65
 
                        {
66
 
                                $s_hidden_fields['attachment'][$attachment_id] = 1;
67
 
                        }
68
 
 
69
 
                        if (confirm_box(true))
70
 
                        {
71
 
                                if (!function_exists('delete_attachments'))
72
 
                                {
73
 
                                        include_once($phpbb_root_path . 'includes/functions_admin.' . $phpEx);
74
 
                                }
75
 
 
76
 
                                delete_attachments('attach', $delete_ids);
77
 
 
78
 
                                meta_refresh(3, $this->u_action);
79
 
                                $message = ((sizeof($delete_ids) == 1) ? $user->lang['ATTACHMENT_DELETED'] : $user->lang['ATTACHMENTS_DELETED']) . '<br /><br />' . sprintf($user->lang['RETURN_UCP'], '<a href="' . $this->u_action . '">', '</a>');
80
 
                                trigger_error($message);
81
 
                        }
82
 
                        else
83
 
                        {
84
 
                                confirm_box(false, (sizeof($delete_ids) == 1) ? 'DELETE_ATTACHMENT' : 'DELETE_ATTACHMENTS', build_hidden_fields($s_hidden_fields));
85
 
                        }
86
 
                }
87
 
 
88
 
                // Select box eventually
89
 
                $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']);
90
 
                $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');
91
 
 
92
 
                $sort_dir_text = array('a' => $user->lang['ASCENDING'], 'd' => $user->lang['DESCENDING']);
93
 
 
94
 
                $s_sort_key = '';
95
 
                foreach ($sort_key_text as $key => $value)
96
 
                {
97
 
                        $selected = ($sort_key == $key) ? ' selected="selected"' : '';
98
 
                        $s_sort_key .= '<option value="' . $key . '"' . $selected . '>' . $value . '</option>';
99
 
                }
100
 
 
101
 
                $s_sort_dir = '';
102
 
                foreach ($sort_dir_text as $key => $value)
103
 
                {
104
 
                        $selected = ($sort_dir == $key) ? ' selected="selected"' : '';
105
 
                        $s_sort_dir .= '<option value="' . $key . '"' . $selected . '>' . $value . '</option>';
106
 
                }
107
 
 
108
 
                if (!isset($sort_key_sql[$sort_key]))
109
 
                {
110
 
                        $sort_key = 'a';
111
 
                }
112
 
 
113
 
                $order_by = $sort_key_sql[$sort_key] . ' ' . (($sort_dir == 'a') ? 'ASC' : 'DESC');
114
 
 
115
 
                $sql = 'SELECT COUNT(attach_id) as num_attachments
116
 
                        FROM ' . ATTACHMENTS_TABLE . '
117
 
                        WHERE poster_id = ' . $user->data['user_id'] . '
118
 
                                AND is_orphan = 0';
119
 
                $result = $db->sql_query($sql);
120
 
                $num_attachments = $db->sql_fetchfield('num_attachments');
121
 
                $db->sql_freeresult($result);
122
 
 
123
 
                $sql = 'SELECT a.*, t.topic_title, p.message_subject as message_title
124
 
                        FROM ' . ATTACHMENTS_TABLE . ' a
125
 
                                LEFT JOIN ' . TOPICS_TABLE . ' t ON (a.topic_id = t.topic_id AND a.in_message = 0)
126
 
                                LEFT JOIN ' . PRIVMSGS_TABLE . ' p ON (a.post_msg_id = p.msg_id AND a.in_message = 1)
127
 
                        WHERE a.poster_id = ' . $user->data['user_id'] . "
128
 
                                AND a.is_orphan = 0
129
 
                        ORDER BY $order_by";
130
 
                $result = $db->sql_query_limit($sql, $config['topics_per_page'], $start);
131
 
 
132
 
                $row_count = 0;
133
 
                if ($row = $db->sql_fetchrow($result))
134
 
                {
135
 
                        $template->assign_var('S_ATTACHMENT_ROWS', true);
136
 
 
137
 
                        do
138
 
                        {
139
 
                                if ($row['in_message'])
140
 
                                {
141
 
                                        $view_topic = append_sid("{$phpbb_root_path}ucp.$phpEx", "i=pm&amp;p={$row['post_msg_id']}");
142
 
                                }
143
 
                                else
144
 
                                {
145
 
                                        $view_topic = append_sid("{$phpbb_root_path}viewtopic.$phpEx", "t={$row['topic_id']}&amp;p={$row['post_msg_id']}") . "#p{$row['post_msg_id']}";
146
 
                                }
147
 
 
148
 
                                $template->assign_block_vars('attachrow', array(
149
 
                                        'ROW_NUMBER'            => $row_count + ($start + 1),
150
 
                                        'FILENAME'                      => $row['real_filename'],
151
 
                                        'COMMENT'                       => bbcode_nl2br($row['attach_comment']),
152
 
                                        'EXTENSION'                     => $row['extension'],
153
 
                                        'SIZE'                          => ($row['filesize'] >= 1048576) ? ($row['filesize'] >> 20) . ' ' . $user->lang['MB'] : (($row['filesize'] >= 1024) ? ($row['filesize'] >> 10) . ' ' . $user->lang['KB'] : $row['filesize'] . ' ' . $user->lang['BYTES']),
154
 
                                        'DOWNLOAD_COUNT'        => $row['download_count'],
155
 
                                        'POST_TIME'                     => $user->format_date($row['filetime']),
156
 
                                        'TOPIC_TITLE'           => ($row['in_message']) ? $row['message_title'] : $row['topic_title'],
157
 
 
158
 
                                        'ATTACH_ID'                     => $row['attach_id'],
159
 
                                        'POST_ID'                       => $row['post_msg_id'],
160
 
                                        'TOPIC_ID'                      => $row['topic_id'],
161
 
 
162
 
                                        'S_IN_MESSAGE'          => $row['in_message'],
163
 
 
164
 
                                        'U_VIEW_ATTACHMENT'     => append_sid("{$phpbb_root_path}download/file.$phpEx", 'id=' . $row['attach_id']),
165
 
                                        'U_VIEW_TOPIC'          => $view_topic)
166
 
                                );
167
 
 
168
 
                                $row_count++;
169
 
                        }
170
 
                        while ($row = $db->sql_fetchrow($result));
171
 
                }
172
 
                $db->sql_freeresult($result);
173
 
 
174
 
                $template->assign_vars(array(
175
 
                        'PAGE_NUMBER'                   => on_page($num_attachments, $config['topics_per_page'], $start),
176
 
                        'PAGINATION'                    => generate_pagination($this->u_action . "&amp;sk=$sort_key&amp;sd=$sort_dir", $num_attachments, $config['topics_per_page'], $start),
177
 
                        'TOTAL_ATTACHMENTS'             => $num_attachments,
178
 
 
179
 
                        'L_TITLE'                               => $user->lang['UCP_ATTACHMENTS'],
180
 
 
181
 
                        'U_SORT_FILENAME'               => $this->u_action . "&amp;sk=a&amp;sd=" . (($sort_key == 'a' && $sort_dir == 'a') ? 'd' : 'a'),
182
 
                        'U_SORT_FILE_COMMENT'   => $this->u_action . "&amp;sk=b&amp;sd=" . (($sort_key == 'b' && $sort_dir == 'a') ? 'd' : 'a'),
183
 
                        'U_SORT_EXTENSION'              => $this->u_action . "&amp;sk=c&amp;sd=" . (($sort_key == 'c' && $sort_dir == 'a') ? 'd' : 'a'),
184
 
                        'U_SORT_FILESIZE'               => $this->u_action . "&amp;sk=d&amp;sd=" . (($sort_key == 'd' && $sort_dir == 'a') ? 'd' : 'a'),
185
 
                        'U_SORT_DOWNLOADS'              => $this->u_action . "&amp;sk=e&amp;sd=" . (($sort_key == 'e' && $sort_dir == 'a') ? 'd' : 'a'),
186
 
                        'U_SORT_POST_TIME'              => $this->u_action . "&amp;sk=f&amp;sd=" . (($sort_key == 'f' && $sort_dir == 'a') ? 'd' : 'a'),
187
 
                        'U_SORT_TOPIC_TITLE'    => $this->u_action . "&amp;sk=g&amp;sd=" . (($sort_key == 'f' && $sort_dir == 'a') ? 'd' : 'a'),
188
 
 
189
 
                        'S_DISPLAY_MARK_ALL'    => ($num_attachments) ? true : false,
190
 
                        'S_DISPLAY_PAGINATION'  => ($num_attachments) ? true : false,
191
 
                        'S_UCP_ACTION'                  => $this->u_action,
192
 
                        'S_SORT_OPTIONS'                => $s_sort_key,
193
 
                        'S_ORDER_SELECT'                => $s_sort_dir)
194
 
                );
195
 
 
196
 
                $this->tpl_name = 'ucp_attachments';
197
 
                $this->page_title = 'UCP_ATTACHMENTS';
198
 
        }
199
 
}
200
 
 
201
 
?>
 
 
b'\\ No newline at end of file'