?  search:
summary | log | graphiclog1 | graphiclog2 | commit | commitdiff | tree | refs | edit | fork
blame | history | raw | HEAD
merge revisions i missed... hopefully not breaking things - did not check every change.
[phpbb.git] / phpBB / includes / acp / acp_main.php
blob3e66f49afa4ddd25f0095877bb214b34c7f10b50
1 <?php
2 /**
3 *
4 * @package acp
5 * @version $Id$
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 * @package acp
21 */
22 class acp_main
23 {
24 var $u_action;
25
26 function main($id, $mode)
27 {
28 global $config, $db, $user, $auth, $template;
29
30 // Show restore permissions notice
31 if ($user->data['user_perm_from'] && $auth->acl_get('a_switchperm'))
32 {
33 $this->tpl_name = 'acp_main';
34 $this->page_title = 'ACP_MAIN';
35
36 $sql = 'SELECT user_id, username, user_colour
37 FROM ' . USERS_TABLE . '
38 WHERE user_id = ' . $user->data['user_perm_from'];
39 $result = $db->sql_query($sql);
40 $user_row = $db->sql_fetchrow($result);
41 $db->sql_freeresult($result);
42
43 $perm_from = '<strong' . (($user_row['user_colour']) ? ' style="color: #' . $user_row['user_colour'] . '">' : '>');
44 $perm_from .= ($user_row['user_id'] != ANONYMOUS) ? '<a href="' . append_sid('memberlist', 'mode=viewprofile&amp;u=' . $user_row['user_id']) . '">' : '';
45 $perm_from .= $user_row['username'];
46 $perm_from .= ($user_row['user_id'] != ANONYMOUS) ? '</a>' : '';
47 $perm_from .= '</strong>';
48
49 $template->assign_vars(array(
50 'S_RESTORE_PERMISSIONS' => true,
51 'U_RESTORE_PERMISSIONS' => append_sid('ucp', 'mode=restore_perm'),
52 'PERM_FROM' => $perm_from,
53 'L_PERMISSIONS_TRANSFERRED_EXPLAIN' => sprintf($user->lang['PERMISSIONS_TRANSFERRED_EXPLAIN'], $perm_from, append_sid('ucp', 'mode=restore_perm')),
54 ));
55
56 return;
57 }
58
59 $action = request_var('action', '');
60
61 if ($action)
62 {
63 if ($action === 'admlogout')
64 {
65 $user->unset_admin();
66 $redirect_url = append_sid(PHPBB_ROOT_PATH . 'index.' . PHP_EXT);
67 meta_refresh(3, $redirect_url);
68 trigger_error($user->lang['ADM_LOGGED_OUT'] . '<br /><br />' . sprintf($user->lang['RETURN_INDEX'], '<a href="' . $redirect_url . '">', '</a>'));
69 }
70
71 if (!confirm_box(true))
72 {
73 switch ($action)
74 {
75 case 'online':
76 $confirm = true;
77 $confirm_lang = 'RESET_ONLINE_CONFIRM';
78 break;
79 case 'stats':
80 $confirm = true;
81 $confirm_lang = 'RESYNC_STATS_CONFIRM';
82 break;
83 case 'user':
84 $confirm = true;
85 $confirm_lang = 'RESYNC_POSTCOUNTS_CONFIRM';
86 break;
87 case 'date':
88 $confirm = true;
89 $confirm_lang = 'RESET_DATE_CONFIRM';
90 break;
91 case 'db_track':
92 $confirm = true;
93 $confirm_lang = 'RESYNC_POST_MARKING_CONFIRM';
94 break;
95 case 'purge_cache':
96 $confirm = true;
97 $confirm_lang = 'PURGE_CACHE_CONFIRM';
98 break;
99
100 default:
101 $confirm = true;
102 $confirm_lang = 'CONFIRM_OPERATION';
103 }
104
105 if ($confirm)
106 {
107 confirm_box(false, $user->lang[$confirm_lang], build_hidden_fields(array(
108 'i' => $id,
109 'mode' => $mode,
110 'action' => $action,
111 )));
112 }
113 }
114 else
115 {
116 switch ($action)
117 {
118
119 case 'online':
120 if (!$auth->acl_get('a_board'))
121 {
122 trigger_error($user->lang['NO_AUTH_OPERATION'] . adm_back_link($this->u_action), E_USER_WARNING);
123 }
124
125 set_config('record_online_users', 1, true);
126 set_config('record_online_date', time(), true);
127 add_log('admin', 'LOG_RESET_ONLINE');
128 break;
129
130 case 'stats':
131 if (!$auth->acl_get('a_board'))
132 {
133 trigger_error($user->lang['NO_AUTH_OPERATION'] . adm_back_link($this->u_action), E_USER_WARNING);
134 }
135
136 $sql = 'SELECT COUNT(post_id) AS stat
137 FROM ' . POSTS_TABLE . '
138 WHERE post_approved = 1';
139 $result = $db->sql_query($sql);
140 set_config('num_posts', (int) $db->sql_fetchfield('stat'), true);
141 $db->sql_freeresult($result);
142
143 $sql = 'SELECT COUNT(topic_id) AS stat
144 FROM ' . TOPICS_TABLE . '
145 WHERE topic_approved = 1';
146 $result = $db->sql_query($sql);
147 set_config('num_topics', (int) $db->sql_fetchfield('stat'), true);
148 $db->sql_freeresult($result);
149
150 $sql = 'SELECT COUNT(user_id) AS stat
151 FROM ' . USERS_TABLE . '
152 WHERE user_type IN (' . USER_NORMAL . ',' . USER_FOUNDER . ')';
153 $result = $db->sql_query($sql);
154 set_config('num_users', (int) $db->sql_fetchfield('stat'), true);
155 $db->sql_freeresult($result);
156
157 $sql = 'SELECT COUNT(attach_id) as stat
158 FROM ' . ATTACHMENTS_TABLE . '
159 WHERE is_orphan = 0';
160 $result = $db->sql_query($sql);
161 set_config('num_files', (int) $db->sql_fetchfield('stat'), true);
162 $db->sql_freeresult($result);
163
164 $sql = 'SELECT SUM(filesize) as stat
165 FROM ' . ATTACHMENTS_TABLE . '
166 WHERE is_orphan = 0';
167 $result = $db->sql_query($sql);
168 set_config('upload_dir_size', (float) $db->sql_fetchfield('stat'), true);
169 $db->sql_freeresult($result);
170
171 if (!function_exists('update_last_username'))
172 {
173 include(PHPBB_ROOT_PATH . 'includes/functions_user.' . PHP_EXT);
174 }
175 update_last_username();
176
177 add_log('admin', 'LOG_RESYNC_STATS');
178 break;
179
180 case 'user':
181 if (!$auth->acl_get('a_board'))
182 {
183 trigger_error($user->lang['NO_AUTH_OPERATION'] . adm_back_link($this->u_action), E_USER_WARNING);
184 }
185
186 // Resync post counts
187 $start = 0;
188 $step = ($config['num_posts']) ? (max((int) ($config['num_posts'] / 5), 20000)) : 20000;
189
190 $db->sql_query('UPDATE ' . USERS_TABLE . ' SET user_posts = 0');
191
192 do
193 {
194 $sql = 'SELECT COUNT(post_id) AS num_posts, poster_id
195 FROM ' . POSTS_TABLE . '
196 WHERE post_id BETWEEN ' . ($start + 1) . ' AND ' . ($start + $step) . '
197 AND post_postcount = 1 AND post_approved = 1
198 GROUP BY poster_id';
199 $result = $db->sql_query($sql);
200
201 if ($row = $db->sql_fetchrow($result))
202 {
203 do
204 {
205 $sql = 'UPDATE ' . USERS_TABLE . " SET user_posts = user_posts + {$row['num_posts']} WHERE user_id = {$row['poster_id']}";
206 $db->sql_query($sql);
207 }
208 while ($row = $db->sql_fetchrow($result));
209
210 $start += $step;
211 }
212 else
213 {
214 $start = 0;
215 }
216 $db->sql_freeresult($result);
217 }
218 while ($start);
219
220 add_log('admin', 'LOG_RESYNC_POSTCOUNTS');
221
222 break;
223
224 case 'date':
225 if (!$auth->acl_get('a_board'))
226 {
227 trigger_error($user->lang['NO_AUTH_OPERATION'] . adm_back_link($this->u_action), E_USER_WARNING);
228 }
229
230 set_config('board_startdate', time() - 1);
231 add_log('admin', 'LOG_RESET_DATE');
232 break;
233
234 case 'db_track':
235 if ($db->truncate)
236 {
237 $db->sql_query('TRUNCATE TABLE ' . TOPICS_POSTED_TABLE);
238 }
239 else
240 {
241 $db->sql_query('DELETE FROM ' . TOPICS_POSTED_TABLE);
242 }
243
244 // This can get really nasty... therefore we only do the last six months
245 $get_from_time = time() - (6 * 4 * 7 * 24 * 60 * 60);
246
247 // Select forum ids, do not include categories
248 $sql = 'SELECT forum_id
249 FROM ' . FORUMS_TABLE . '
250 WHERE forum_type <> ' . FORUM_CAT;
251 $result = $db->sql_query($sql);
252
253 $forum_ids = array();
254 while ($row = $db->sql_fetchrow($result))
255 {
256 $forum_ids[] = $row['forum_id'];
257 }
258 $db->sql_freeresult($result);
259
260 // Any global announcements? ;)
261 $forum_ids[] = 0;
262
263 // Now go through the forums and get us some topics...
264 foreach ($forum_ids as $forum_id)
265 {
266 $sql = 'SELECT p.poster_id, p.topic_id
267 FROM ' . POSTS_TABLE . ' p, ' . TOPICS_TABLE . ' t
268 WHERE t.forum_id = ' . $forum_id . '
269 AND t.topic_moved_id = 0
270 AND t.topic_last_post_time > ' . $get_from_time . '
271 AND t.topic_id = p.topic_id
272 AND p.poster_id <> ' . ANONYMOUS . '
273 GROUP BY p.poster_id, p.topic_id';
274 $result = $db->sql_query($sql);
275
276 $posted = array();
277 while ($row = $db->sql_fetchrow($result))
278 {
279 $posted[$row['poster_id']][] = $row['topic_id'];
280 }
281 $db->sql_freeresult($result);
282
283 $sql_ary = array();
284 foreach ($posted as $user_id => $topic_row)
285 {
286 foreach ($topic_row as $topic_id)
287 {
288 $sql_ary[] = array(
289 'user_id' => (int) $user_id,
290 'topic_id' => (int) $topic_id,
291 'topic_posted' => 1,
292 );
293 }
294 }
295 unset($posted);
296
297 if (sizeof($sql_ary))
298 {
299 $db->sql_multi_insert(TOPICS_POSTED_TABLE, $sql_ary);
300 }
301 }
302
303 add_log('admin', 'LOG_RESYNC_POST_MARKING');
304 break;
305
306 case 'purge_cache':
307 if ((int) $user->data['user_type'] !== USER_FOUNDER)
308 {
309 trigger_error($user->lang['NO_AUTH_OPERATION'] . adm_back_link($this->u_action), E_USER_WARNING);
310 }
311
312 global $cache;
313 $cache->purge();
314
315 // Clear permissions
316 $auth->acl_clear_prefetch();
317 cache_moderators();
318
319 add_log('admin', 'LOG_PURGE_CACHE');
320 break;
321 }
322 }
323 }
324
325 // Get forum statistics
326 $total_posts = $config['num_posts'];
327 $total_topics = $config['num_topics'];
328 $total_users = $config['num_users'];
329 $total_files = $config['num_files'];
330
331 $start_date = $user->format_date($config['board_startdate']);
332
333 $boarddays = (time() - $config['board_startdate']) / 86400;
334
335 $posts_per_day = sprintf('%.2f', $total_posts / $boarddays);
336 $topics_per_day = sprintf('%.2f', $total_topics / $boarddays);
337 $users_per_day = sprintf('%.2f', $total_users / $boarddays);
338 $files_per_day = sprintf('%.2f', $total_files / $boarddays);
339
340 $upload_dir_size = get_formatted_filesize($config['upload_dir_size']);
341
342 $avatar_dir_size = 0;
343
344 if ($avatar_dir = @opendir(PHPBB_ROOT_PATH . $config['avatar_path']))
345 {
346 while (($file = readdir($avatar_dir)) !== false)
347 {
348 if ($file[0] != '.' && $file != 'CVS' && strpos($file, 'index.') === false)
349 {
350 $avatar_dir_size += filesize(PHPBB_ROOT_PATH . $config['avatar_path'] . '/' . $file);
351 }
352 }
353 closedir($avatar_dir);
354
355 $avatar_dir_size = get_formatted_filesize($avatar_dir_size);
356 }
357 else
358 {
359 // Couldn't open Avatar dir.
360 $avatar_dir_size = $user->lang['NOT_AVAILABLE'];
361 }
362
363 if ($posts_per_day > $total_posts)
364 {
365 $posts_per_day = $total_posts;
366 }
367
368 if ($topics_per_day > $total_topics)
369 {
370 $topics_per_day = $total_topics;
371 }
372
373 if ($users_per_day > $total_users)
374 {
375 $users_per_day = $total_users;
376 }
377
378 if ($files_per_day > $total_files)
379 {
380 $files_per_day = $total_files;
381 }
382
383 if ($config['allow_attachments'] || $config['allow_pm_attach'])
384 {
385 $sql = 'SELECT COUNT(attach_id) AS total_orphan
386 FROM ' . ATTACHMENTS_TABLE . '
387 WHERE is_orphan = 1
388 AND filetime < ' . (time() - 3*60*60);
389 $result = $db->sql_query($sql);
390 $total_orphan = (int) $db->sql_fetchfield('total_orphan');
391 $db->sql_freeresult($result);
392 }
393 else
394 {
395 $total_orphan = false;
396 }
397
398 $dbsize = get_database_size();
399
400 $template->assign_vars(array(
401 'TOTAL_POSTS' => $total_posts,
402 'POSTS_PER_DAY' => $posts_per_day,
403 'TOTAL_TOPICS' => $total_topics,
404 'TOPICS_PER_DAY' => $topics_per_day,
405 'TOTAL_USERS' => $total_users,
406 'USERS_PER_DAY' => $users_per_day,
407 'TOTAL_FILES' => $total_files,
408 'FILES_PER_DAY' => $files_per_day,
409 'START_DATE' => $start_date,
410 'AVATAR_DIR_SIZE' => $avatar_dir_size,
411 'DBSIZE' => $dbsize,
412 'UPLOAD_DIR_SIZE' => $upload_dir_size,
413 'TOTAL_ORPHAN' => $total_orphan,
414 'S_TOTAL_ORPHAN' => ($total_orphan === false) ? false : true,
415 'GZIP_COMPRESSION' => ($config['gzip_compress']) ? $user->lang['ON'] : $user->lang['OFF'],
416 'DATABASE_INFO' => $db->sql_server_info(),
417 'BOARD_VERSION' => $config['version'],
418
419 'U_ACTION' => $this->u_action,
420 'U_ADMIN_LOG' => append_sid(PHPBB_ADMIN_PATH . 'index.' . PHP_EXT, 'i=logs&amp;mode=admin'),
421 'U_INACTIVE_USERS' => append_sid(PHPBB_ADMIN_PATH . 'index.' . PHP_EXT, 'i=inactive&amp;mode=list'),
422
423 'S_ACTION_OPTIONS' => ($auth->acl_get('a_board')) ? true : false,
424 'S_FOUNDER' => ($user->data['user_type'] == USER_FOUNDER) ? true : false,
425 )
426 );
427
428 $log_data = array();
429 $log_count = 0;
430
431 if ($auth->acl_get('a_viewlogs'))
432 {
433 view_log('admin', $log_data, $log_count, 5);
434
435 foreach ($log_data as $row)
436 {
437 $template->assign_block_vars('log', array(
438 'USERNAME' => $row['username_full'],
439 'IP' => $row['ip'],
440 'DATE' => $user->format_date($row['time']),
441 'ACTION' => $row['action'])
442 );
443 }
444 }
445
446 if ($auth->acl_get('a_user'))
447 {
448 $inactive = array();
449 $inactive_count = 0;
450
451 view_inactive_users($inactive, $inactive_count, 10);
452
453 foreach ($inactive as $row)
454 {
455 $template->assign_block_vars('inactive', array(
456 'INACTIVE_DATE' => $user->format_date($row['user_inactive_time']),
457 'JOINED' => $user->format_date($row['user_regdate']),
458 'LAST_VISIT' => (!$row['user_lastvisit']) ? ' - ' : $user->format_date($row['user_lastvisit']),
459 'REASON' => $row['inactive_reason'],
460 'USER_ID' => $row['user_id'],
461 'USERNAME' => $row['username'],
462 'U_USER_ADMIN' => append_sid(PHPBB_ADMIN_PATH . 'index.' . PHP_EXT, "i=users&amp;mode=overview&amp;u={$row['user_id']}"))
463 );
464 }
465
466 $option_ary = array('activate' => 'ACTIVATE', 'delete' => 'DELETE');
467 if ($config['email_enable'])
468 {
469 $option_ary += array('remind' => 'REMIND');
470 }
471
472 $template->assign_vars(array(
473 'S_INACTIVE_USERS' => true,
474 'S_INACTIVE_OPTIONS' => build_select($option_ary))
475 );
476 }
477
478 // Warn if install is still present
479 if (file_exists(PHPBB_ROOT_PATH . 'install'))
480 {
481 $template->assign_var('S_REMOVE_INSTALL', true);
482 }
483
484 if (!defined('PHPBB_DISABLE_CONFIG_CHECK') && file_exists(PHPBB_ROOT_PATH . 'config.' . PHP_EXT) && is_writable(PHPBB_ROOT_PATH . 'config.' . PHP_EXT))
485 {
486 // World-Writable? (000x)
487 $template->assign_var('S_WRITABLE_CONFIG', (bool) (@fileperms(PHPBB_ROOT_PATH . 'config.' . PHP_EXT) & 0x0002));
488 }
489
490 $this->tpl_name = 'acp_main';
491 $this->page_title = 'ACP_MAIN';
492 }
493 }
494
495 ?>
phpbb is a php-based BBS (buletin board system)