← Back to branch summary

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

« back to all changes in this revision

Viewing changes to www/php/phpBB3/includes/mcp/mcp_front.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/mcp/mcp_front.php
1
 
<?php
2
 
/**
3
 
*
4
 
* @package mcp
5
 
* @version $Id: mcp_front.php,v 1.34 2007/11/03 11:09:11 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
 
* MCP Front Panel
21
 
*/
22
 
function mcp_front_view($id, $mode, $action)
23
 
{
24
 
        global $phpEx, $phpbb_root_path, $config;
25
 
        global $template, $db, $user, $auth, $module;
26
 
 
27
 
        // Latest 5 unapproved
28
 
        if ($module->loaded('queue'))
29
 
        {
30
 
                $forum_list = get_forum_list('m_approve');
31
 
                $post_list = array();
32
 
                $forum_names = array();
33
 
 
34
 
                $forum_id = request_var('f', 0);
35
 
 
36
 
                $template->assign_var('S_SHOW_UNAPPROVED', (!empty($forum_list)) ? true : false);
37
 
                
38
 
                if (!empty($forum_list))
39
 
                {
40
 
                        $sql = 'SELECT COUNT(post_id) AS total
41
 
                                FROM ' . POSTS_TABLE . '
42
 
                                WHERE forum_id IN (0, ' . implode(', ', $forum_list) . ')
43
 
                                        AND post_approved = 0';
44
 
                        $result = $db->sql_query($sql);
45
 
                        $total = (int) $db->sql_fetchfield('total');
46
 
                        $db->sql_freeresult($result);
47
 
 
48
 
                        if ($total)
49
 
                        {
50
 
                                $global_id = $forum_list[0];
51
 
 
52
 
                                $sql = 'SELECT forum_id, forum_name
53
 
                                        FROM ' . FORUMS_TABLE . '
54
 
                                        WHERE ' . $db->sql_in_set('forum_id', $forum_list);
55
 
                                $result = $db->sql_query($sql);
56
 
 
57
 
                                while ($row = $db->sql_fetchrow($result))
58
 
                                {
59
 
                                        $forum_names[$row['forum_id']] = $row['forum_name'];
60
 
                                }
61
 
                                $db->sql_freeresult($result);
62
 
 
63
 
                                $sql = 'SELECT post_id
64
 
                                        FROM ' . POSTS_TABLE . '
65
 
                                        WHERE forum_id IN (0, ' . implode(', ', $forum_list) . ')
66
 
                                                AND post_approved = 0
67
 
                                        ORDER BY post_time DESC';
68
 
                                $result = $db->sql_query_limit($sql, 5);
69
 
 
70
 
                                while ($row = $db->sql_fetchrow($result))
71
 
                                {
72
 
                                        $post_list[] = $row['post_id'];
73
 
                                }
74
 
                                $db->sql_freeresult($result);
75
 
 
76
 
                                if (empty($post_list))
77
 
                                {
78
 
                                        $total = 0;
79
 
                                }
80
 
                        }
81
 
 
82
 
                        if ($total)
83
 
                        {
84
 
                                $sql = 'SELECT p.post_id, p.post_subject, p.post_time, p.poster_id, p.post_username, u.username, u.username_clean, t.topic_id, t.topic_title, t.topic_first_post_id, p.forum_id
85
 
                                        FROM ' . POSTS_TABLE . ' p, ' . TOPICS_TABLE . ' t, ' . USERS_TABLE . ' u
86
 
                                        WHERE ' . $db->sql_in_set('p.post_id', $post_list) . '
87
 
                                                AND t.topic_id = p.topic_id
88
 
                                                AND p.poster_id = u.user_id
89
 
                                        ORDER BY p.post_time DESC';
90
 
                                $result = $db->sql_query($sql);
91
 
 
92
 
                                while ($row = $db->sql_fetchrow($result))
93
 
                                {
94
 
                                        $global_topic = ($row['forum_id']) ? false : true;
95
 
                                        if ($global_topic)
96
 
                                        {
97
 
                                                $row['forum_id'] = $global_id;
98
 
                                        }
99
 
 
100
 
                                        $template->assign_block_vars('unapproved', array(
101
 
                                                'U_POST_DETAILS'        => append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=queue&amp;mode=approve_details&amp;f=' . $row['forum_id'] . '&amp;p=' . $row['post_id']),
102
 
                                                'U_MCP_FORUM'           => (!$global_topic) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=main&amp;mode=forum_view&amp;f=' . $row['forum_id']) : '',
103
 
                                                'U_MCP_TOPIC'           => append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=main&amp;mode=topic_view&amp;f=' . $row['forum_id'] . '&amp;t=' . $row['topic_id']),
104
 
                                                'U_FORUM'                       => (!$global_topic) ? append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $row['forum_id']) : '',
105
 
                                                'U_TOPIC'                       => append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $row['forum_id'] . '&amp;t=' . $row['topic_id']),
106
 
                                                'U_AUTHOR'                      => ($row['poster_id'] == ANONYMOUS) ? '' : append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=viewprofile&amp;u=' . $row['poster_id']),
107
 
 
108
 
                                                'FORUM_NAME'    => (!$global_topic) ? $forum_names[$row['forum_id']] : $user->lang['GLOBAL_ANNOUNCEMENT'],
109
 
                                                'POST_ID'               => $row['post_id'],
110
 
                                                'TOPIC_TITLE'   => $row['topic_title'],
111
 
                                                'AUTHOR'                => ($row['poster_id'] == ANONYMOUS) ? (($row['post_username']) ? $row['post_username'] : $user->lang['GUEST']) : $row['username'],
112
 
                                                'SUBJECT'               => ($row['post_subject']) ? $row['post_subject'] : $user->lang['NO_SUBJECT'],
113
 
                                                'POST_TIME'             => $user->format_date($row['post_time']))
114
 
                                        );
115
 
                                }
116
 
                                $db->sql_freeresult($result);
117
 
                        }
118
 
 
119
 
                        $template->assign_vars(array(
120
 
                                'S_MCP_QUEUE_ACTION'    => append_sid("{$phpbb_root_path}mcp.$phpEx", "i=queue"),
121
 
                        ));
122
 
 
123
 
                        if ($total == 0)
124
 
                        {
125
 
                                $template->assign_vars(array(
126
 
                                        'L_UNAPPROVED_TOTAL'            => $user->lang['UNAPPROVED_POSTS_ZERO_TOTAL'],
127
 
                                        'S_HAS_UNAPPROVED_POSTS'        => false)
128
 
                                );
129
 
                        }
130
 
                        else
131
 
                        {
132
 
                                $template->assign_vars(array(
133
 
                                        'L_UNAPPROVED_TOTAL'            => ($total == 1) ? $user->lang['UNAPPROVED_POST_TOTAL'] : sprintf($user->lang['UNAPPROVED_POSTS_TOTAL'], $total),
134
 
                                        'S_HAS_UNAPPROVED_POSTS'        => true)
135
 
                                );
136
 
                        }
137
 
                }
138
 
        }
139
 
 
140
 
        // Latest 5 reported
141
 
        if ($module->loaded('reports'))
142
 
        {
143
 
                $forum_list = get_forum_list('m_report');
144
 
 
145
 
                $template->assign_var('S_SHOW_REPORTS', (!empty($forum_list)) ? true : false);
146
 
 
147
 
                if (!empty($forum_list))
148
 
                {
149
 
                        $sql = 'SELECT COUNT(r.report_id) AS total
150
 
                                FROM ' . REPORTS_TABLE . ' r, ' . POSTS_TABLE . ' p
151
 
                                WHERE r.post_id = p.post_id
152
 
                                        AND r.report_closed = 0
153
 
                                        AND p.forum_id IN (0, ' . implode(', ', $forum_list) . ')';
154
 
                        $result = $db->sql_query($sql);
155
 
                        $total = (int) $db->sql_fetchfield('total');
156
 
                        $db->sql_freeresult($result);
157
 
 
158
 
                        if ($total)
159
 
                        {
160
 
                                $global_id = $forum_list[0];
161
 
 
162
 
                                $sql = $db->sql_build_query('SELECT', array(
163
 
                                        'SELECT'        => 'r.report_time, p.post_id, p.post_subject, p.post_time, u.username, u.username_clean, u.user_colour, u.user_id, u2.username as author_name, u2.username_clean as author_name_clean, u2.user_colour as author_colour, u2.user_id as author_id, t.topic_id, t.topic_title, f.forum_id, f.forum_name',
164
 
 
165
 
                                        'FROM'          => array(
166
 
                                                REPORTS_TABLE                   => 'r',
167
 
                                                REPORTS_REASONS_TABLE   => 'rr',
168
 
                                                TOPICS_TABLE                    => 't',
169
 
                                                USERS_TABLE                             => array('u', 'u2'),
170
 
                                                POSTS_TABLE                             => 'p'
171
 
                                        ),
172
 
 
173
 
                                        'LEFT_JOIN'     => array(
174
 
                                                array(
175
 
                                                        'FROM'  => array(FORUMS_TABLE => 'f'),
176
 
                                                        'ON'    => 'f.forum_id = p.forum_id'
177
 
                                                )
178
 
                                        ),
179
 
 
180
 
                                        'WHERE'         => 'r.post_id = p.post_id
181
 
                                                AND r.report_closed = 0
182
 
                                                AND r.reason_id = rr.reason_id
183
 
                                                AND p.topic_id = t.topic_id
184
 
                                                AND r.user_id = u.user_id
185
 
                                                AND p.poster_id = u2.user_id
186
 
                                                AND p.forum_id IN (0, ' . implode(', ', $forum_list) . ')',
187
 
 
188
 
                                        'ORDER_BY'      => 'p.post_time DESC'
189
 
                                ));
190
 
                                $result = $db->sql_query_limit($sql, 5);
191
 
 
192
 
                                while ($row = $db->sql_fetchrow($result))
193
 
                                {
194
 
                                        $global_topic = ($row['forum_id']) ? false : true;
195
 
                                        if ($global_topic)
196
 
                                        {
197
 
                                                $row['forum_id'] = $global_id;
198
 
                                        }
199
 
 
200
 
                                        $template->assign_block_vars('report', array(
201
 
                                                'U_POST_DETAILS'        => append_sid("{$phpbb_root_path}mcp.$phpEx", 'f=' . $row['forum_id'] . '&amp;p=' . $row['post_id'] . "&amp;i=reports&amp;mode=report_details"),
202
 
                                                'U_MCP_FORUM'           => (!$global_topic) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'f=' . $row['forum_id'] . "&amp;i=$id&amp;mode=forum_view") : '',
203
 
                                                'U_MCP_TOPIC'           => append_sid("{$phpbb_root_path}mcp.$phpEx", 'f=' . $row['forum_id'] . '&amp;t=' . $row['topic_id'] . "&amp;i=$id&amp;mode=topic_view"),
204
 
                                                'U_FORUM'                       => (!$global_topic) ? append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $row['forum_id']) : '',
205
 
                                                'U_TOPIC'                       => append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $row['forum_id'] . '&amp;t=' . $row['topic_id']),
206
 
 
207
 
                                                'REPORTER_FULL'         => get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']),
208
 
                                                'REPORTER'                      => get_username_string('username', $row['user_id'], $row['username'], $row['user_colour']),
209
 
                                                'REPORTER_COLOUR'       => get_username_string('colour', $row['user_id'], $row['username'], $row['user_colour']),
210
 
                                                'U_REPORTER'            => get_username_string('profile', $row['user_id'], $row['username'], $row['user_colour']),
211
 
 
212
 
                                                'AUTHOR_FULL'           => get_username_string('full', $row['author_id'], $row['author_name'], $row['author_colour']),
213
 
                                                'AUTHOR'                        => get_username_string('username', $row['author_id'], $row['author_name'], $row['author_colour']),
214
 
                                                'AUTHOR_COLOUR'         => get_username_string('colour', $row['author_id'], $row['author_name'], $row['author_colour']),
215
 
                                                'U_AUTHOR'                      => get_username_string('profile', $row['author_id'], $row['author_name'], $row['author_colour']),
216
 
 
217
 
                                                'FORUM_NAME'    => (!$global_topic) ? $row['forum_name'] : $user->lang['GLOBAL_ANNOUNCEMENT'],
218
 
                                                'TOPIC_TITLE'   => $row['topic_title'],
219
 
                                                'SUBJECT'               => ($row['post_subject']) ? $row['post_subject'] : $user->lang['NO_SUBJECT'],
220
 
                                                'REPORT_TIME'   => $user->format_date($row['report_time']),
221
 
                                                'POST_TIME'             => $user->format_date($row['post_time']),
222
 
                                        ));
223
 
                                }
224
 
                        }
225
 
 
226
 
                        if ($total == 0)
227
 
                        {
228
 
                                $template->assign_vars(array(
229
 
                                        'L_REPORTS_TOTAL'       =>      $user->lang['REPORTS_ZERO_TOTAL'],
230
 
                                        'S_HAS_REPORTS'         =>      false)
231
 
                                );
232
 
                        }
233
 
                        else
234
 
                        {
235
 
                                $template->assign_vars(array(
236
 
                                        'L_REPORTS_TOTAL'       => ($total == 1) ? $user->lang['REPORT_TOTAL'] : sprintf($user->lang['REPORTS_TOTAL'], $total),
237
 
                                        'S_HAS_REPORTS'         => true)
238
 
                                );
239
 
                        }
240
 
                }
241
 
        }
242
 
 
243
 
        // Latest 5 logs
244
 
        if ($module->loaded('logs'))
245
 
        {
246
 
                $forum_list = get_forum_list('m_');
247
 
 
248
 
                if (!empty($forum_list))
249
 
                {
250
 
                        // Add forum_id 0 for global announcements
251
 
                        $forum_list[] = 0;
252
 
 
253
 
                        $log_count = 0;
254
 
                        $log = array();
255
 
                        view_log('mod', $log, $log_count, 5, 0, $forum_list);
256
 
 
257
 
                        foreach ($log as $row)
258
 
                        {
259
 
                                $template->assign_block_vars('log', array(
260
 
                                        'USERNAME'              => $row['username_full'],
261
 
                                        'IP'                    => $row['ip'],
262
 
                                        'TIME'                  => $user->format_date($row['time']),
263
 
                                        'ACTION'                => $row['action'],
264
 
                                        'U_VIEW_TOPIC'  => (!empty($row['viewtopic'])) ? $row['viewtopic'] : '',
265
 
                                        'U_VIEWLOGS'    => (!empty($row['viewlogs'])) ? $row['viewlogs'] : '')
266
 
                                );
267
 
                        }
268
 
                }
269
 
 
270
 
                $template->assign_vars(array(
271
 
                        'S_SHOW_LOGS'   => (!empty($forum_list)) ? true : false,
272
 
                        'S_HAS_LOGS'    => (!empty($log)) ? true : false)
273
 
                );
274
 
        }
275
 
 
276
 
        $template->assign_var('S_MCP_ACTION', append_sid("{$phpbb_root_path}mcp.$phpEx"));
277
 
        make_jumpbox(append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=main&amp;mode=forum_view'), 0, false, 'm_', true);
278
 
}
279
 
 
280
 
?>
 
 
b'\\ No newline at end of file'