| [ Index ] |
PHP Cross Reference of Unnamed Project |
[Summary view] [Print] [Text view]
1 <?php 2 /** 3 * 4 * @package mcp 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 define('IN_PHPBB', true); 15 $phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './'; 16 $phpEx = substr(strrchr(__FILE__, '.'), 1); 17 include($phpbb_root_path . 'common.' . $phpEx); 18 include($phpbb_root_path . 'includes/functions_admin.' . $phpEx); 19 require($phpbb_root_path . 'includes/functions_module.' . $phpEx); 20 21 // Start session management 22 $user->session_begin(); 23 $auth->acl($user->data); 24 $user->setup('mcp'); 25 26 $module = new p_master(); 27 28 // Setting a variable to let the style designer know where he is... 29 $template->assign_var('S_IN_MCP', true); 30 31 // Basic parameter data 32 $id = request_var('i', ''); 33 34 if (isset($_REQUEST['mode']) && is_array($_REQUEST['mode'])) 35 { 36 $mode = request_var('mode', array('')); 37 list($mode, ) = each($mode); 38 } 39 else 40 { 41 $mode = request_var('mode', ''); 42 } 43 44 // Only Moderators can go beyond this point 45 if (!$user->data['is_registered']) 46 { 47 if ($user->data['is_bot']) 48 { 49 redirect(append_sid("{$phpbb_root_path}index.$phpEx")); 50 } 51 52 login_box('', $user->lang['LOGIN_EXPLAIN_MCP']); 53 } 54 55 $quickmod = (isset($_REQUEST['quickmod'])) ? true : false; 56 $action = request_var('action', ''); 57 $action_ary = request_var('action', array('' => 0)); 58 59 $forum_action = request_var('forum_action', ''); 60 if ($forum_action !== '' && !empty($_POST['sort'])) 61 { 62 $action = $forum_action; 63 } 64 65 if (sizeof($action_ary)) 66 { 67 list($action, ) = each($action_ary); 68 } 69 unset($action_ary); 70 71 if ($mode == 'topic_logs') 72 { 73 $id = 'logs'; 74 $quickmod = false; 75 } 76 77 $post_id = request_var('p', 0); 78 $topic_id = request_var('t', 0); 79 $forum_id = request_var('f', 0); 80 $report_id = request_var('r', 0); 81 $user_id = request_var('u', 0); 82 $username = utf8_normalize_nfc(request_var('username', '', true)); 83 84 if ($post_id) 85 { 86 // We determine the topic and forum id here, to make sure the moderator really has moderative rights on this post 87 $sql = 'SELECT topic_id, forum_id 88 FROM ' . POSTS_TABLE . " 89 WHERE post_id = $post_id"; 90 $result = $db->sql_query($sql); 91 $row = $db->sql_fetchrow($result); 92 $db->sql_freeresult($result); 93 94 $topic_id = (int) $row['topic_id']; 95 $forum_id = (int) ($row['forum_id']) ? $row['forum_id'] : $forum_id; 96 } 97 else if ($topic_id) 98 { 99 $sql = 'SELECT forum_id 100 FROM ' . TOPICS_TABLE . " 101 WHERE topic_id = $topic_id"; 102 $result = $db->sql_query($sql); 103 $row = $db->sql_fetchrow($result); 104 $db->sql_freeresult($result); 105 106 $forum_id = (int) $row['forum_id']; 107 } 108 109 // If the user doesn't have any moderator powers (globally or locally) he can't access the mcp 110 if (!$auth->acl_getf_global('m_')) 111 { 112 // Except he is using one of the quickmod tools for users 113 $user_quickmod_actions = array( 114 'lock' => 'f_user_lock', 115 'make_sticky' => 'f_sticky', 116 'make_announce' => 'f_announce', 117 'make_global' => 'f_announce', 118 'make_normal' => array('f_announce', 'f_sticky') 119 ); 120 121 $allow_user = false; 122 if ($quickmod && isset($user_quickmod_actions[$action]) && $user->data['is_registered'] && $auth->acl_gets($user_quickmod_actions[$action], $forum_id)) 123 { 124 $topic_info = get_topic_data(array($topic_id)); 125 if ($topic_info[$topic_id]['topic_poster'] == $user->data['user_id']) 126 { 127 $allow_user = true; 128 } 129 } 130 131 if (!$allow_user) 132 { 133 trigger_error('NOT_AUTHORISED'); 134 } 135 } 136 137 // if the user cannot read the forum he tries to access then we won't allow mcp access either 138 if ($forum_id && !$auth->acl_get('f_read', $forum_id)) 139 { 140 trigger_error('NOT_AUTHORISED'); 141 } 142 143 if ($forum_id) 144 { 145 $module->acl_forum_id = $forum_id; 146 } 147 148 // Instantiate module system and generate list of available modules 149 $module->list_modules('mcp'); 150 151 if ($quickmod) 152 { 153 $mode = 'quickmod'; 154 155 switch ($action) 156 { 157 case 'lock': 158 case 'unlock': 159 case 'lock_post': 160 case 'unlock_post': 161 case 'make_sticky': 162 case 'make_announce': 163 case 'make_global': 164 case 'make_normal': 165 case 'fork': 166 case 'move': 167 case 'delete_post': 168 case 'delete_topic': 169 $module->load('mcp', 'main', 'quickmod'); 170 return; 171 break; 172 173 case 'topic_logs': 174 // Reset start parameter if we jumped from the quickmod dropdown 175 if (request_var('start', 0)) 176 { 177 $_REQUEST['start'] = 0; 178 } 179 180 $module->set_active('logs', 'topic_logs'); 181 break; 182 183 case 'merge_topic': 184 $module->set_active('main', 'forum_view'); 185 break; 186 187 case 'split': 188 case 'merge': 189 $module->set_active('main', 'topic_view'); 190 break; 191 192 default: 193 trigger_error("$action not allowed as quickmod", E_USER_ERROR); 194 break; 195 } 196 } 197 else 198 { 199 // Select the active module 200 $module->set_active($id, $mode); 201 } 202 203 // Hide some of the options if we don't have the relevant information to use them 204 if (!$post_id) 205 { 206 $module->set_display('main', 'post_details', false); 207 $module->set_display('warn', 'warn_post', false); 208 } 209 210 if ($mode == '' || $mode == 'unapproved_topics' || $mode == 'unapproved_posts') 211 { 212 $module->set_display('queue', 'approve_details', false); 213 } 214 215 if ($mode == '' || $mode == 'reports' || $mode == 'reports_closed' || $mode == 'pm_reports' || $mode == 'pm_reports_closed' || $mode == 'pm_report_details') 216 { 217 $module->set_display('reports', 'report_details', false); 218 } 219 220 if ($mode == '' || $mode == 'reports' || $mode == 'reports_closed' || $mode == 'pm_reports' || $mode == 'pm_reports_closed' || $mode == 'report_details') 221 { 222 $module->set_display('pm_reports', 'pm_report_details', false); 223 } 224 225 if (!$topic_id) 226 { 227 $module->set_display('main', 'topic_view', false); 228 $module->set_display('logs', 'topic_logs', false); 229 } 230 231 if (!$forum_id) 232 { 233 $module->set_display('main', 'forum_view', false); 234 $module->set_display('logs', 'forum_logs', false); 235 } 236 237 if (!$user_id && $username == '') 238 { 239 $module->set_display('notes', 'user_notes', false); 240 $module->set_display('warn', 'warn_user', false); 241 } 242 243 // Load and execute the relevant module 244 $module->load_active(); 245 246 // Assign data to the template engine for the list of modules 247 $module->assign_tpl_vars(append_sid("{$phpbb_root_path}mcp.$phpEx")); 248 249 // Generate urls for letting the moderation control panel being accessed in different modes 250 $template->assign_vars(array( 251 'U_MCP' => append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=main'), 252 'U_MCP_FORUM' => ($forum_id) ? append_sid("{$phpbb_root_path}mcp.$phpEx", "i=main&mode=forum_view&f=$forum_id") : '', 253 'U_MCP_TOPIC' => ($forum_id && $topic_id) ? append_sid("{$phpbb_root_path}mcp.$phpEx", "i=main&mode=topic_view&t=$topic_id") : '', 254 'U_MCP_POST' => ($forum_id && $topic_id && $post_id) ? append_sid("{$phpbb_root_path}mcp.$phpEx", "i=main&mode=post_details&t=$topic_id&p=$post_id") : '', 255 )); 256 257 // Generate the page, do not display/query online list 258 $module->display($module->get_page_title(), false); 259 260 /** 261 * Functions used to generate additional URL paramters 262 */ 263 function _module__url($mode, &$module_row) 264 { 265 return extra_url(); 266 } 267 268 function _module_notes_url($mode, &$module_row) 269 { 270 if ($mode == 'front') 271 { 272 return ''; 273 } 274 275 global $user_id; 276 return ($user_id) ? "&u=$user_id" : ''; 277 } 278 279 function _module_warn_url($mode, &$module_row) 280 { 281 if ($mode == 'front' || $mode == 'list') 282 { 283 global $forum_id; 284 285 return ($forum_id) ? "&f=$forum_id" : ''; 286 } 287 288 if ($mode == 'warn_post') 289 { 290 global $forum_id, $post_id; 291 292 $url_extra = ($forum_id) ? "&f=$forum_id" : ''; 293 $url_extra .= ($post_id) ? "&p=$post_id" : ''; 294 295 return $url_extra; 296 } 297 else 298 { 299 global $user_id; 300 301 return ($user_id) ? "&u=$user_id" : ''; 302 } 303 } 304 305 function _module_main_url($mode, &$module_row) 306 { 307 return extra_url(); 308 } 309 310 function _module_logs_url($mode, &$module_row) 311 { 312 return extra_url(); 313 } 314 315 function _module_ban_url($mode, &$module_row) 316 { 317 return extra_url(); 318 } 319 320 function _module_queue_url($mode, &$module_row) 321 { 322 return extra_url(); 323 } 324 325 function _module_reports_url($mode, &$module_row) 326 { 327 return extra_url(); 328 } 329 330 function extra_url() 331 { 332 global $forum_id, $topic_id, $post_id, $report_id, $user_id; 333 334 $url_extra = ''; 335 $url_extra .= ($forum_id) ? "&f=$forum_id" : ''; 336 $url_extra .= ($topic_id) ? "&t=$topic_id" : ''; 337 $url_extra .= ($post_id) ? "&p=$post_id" : ''; 338 $url_extra .= ($user_id) ? "&u=$user_id" : ''; 339 $url_extra .= ($report_id) ? "&r=$report_id" : ''; 340 341 return $url_extra; 342 } 343 344 /** 345 * Get simple topic data 346 */ 347 function get_topic_data($topic_ids, $acl_list = false, $read_tracking = false) 348 { 349 global $auth, $db, $config, $user; 350 static $rowset = array(); 351 352 $topics = array(); 353 354 if (!sizeof($topic_ids)) 355 { 356 return array(); 357 } 358 359 // cache might not contain read tracking info, so we can't use it if read 360 // tracking information is requested 361 if (!$read_tracking) 362 { 363 $cache_topic_ids = array_intersect($topic_ids, array_keys($rowset)); 364 $topic_ids = array_diff($topic_ids, array_keys($rowset)); 365 } 366 else 367 { 368 $cache_topic_ids = array(); 369 } 370 371 if (sizeof($topic_ids)) 372 { 373 $sql_array = array( 374 'SELECT' => 't.*, f.*', 375 376 'FROM' => array( 377 TOPICS_TABLE => 't', 378 ), 379 380 'LEFT_JOIN' => array( 381 array( 382 'FROM' => array(FORUMS_TABLE => 'f'), 383 'ON' => 'f.forum_id = t.forum_id' 384 ) 385 ), 386 387 'WHERE' => $db->sql_in_set('t.topic_id', $topic_ids) 388 ); 389 390 if ($read_tracking && $config['load_db_lastread']) 391 { 392 $sql_array['SELECT'] .= ', tt.mark_time, ft.mark_time as forum_mark_time'; 393 394 $sql_array['LEFT_JOIN'][] = array( 395 'FROM' => array(TOPICS_TRACK_TABLE => 'tt'), 396 'ON' => 'tt.user_id = ' . $user->data['user_id'] . ' AND t.topic_id = tt.topic_id' 397 ); 398 399 $sql_array['LEFT_JOIN'][] = array( 400 'FROM' => array(FORUMS_TRACK_TABLE => 'ft'), 401 'ON' => 'ft.user_id = ' . $user->data['user_id'] . ' AND t.forum_id = ft.forum_id' 402 ); 403 } 404 405 $sql = $db->sql_build_query('SELECT', $sql_array); 406 $result = $db->sql_query($sql); 407 408 while ($row = $db->sql_fetchrow($result)) 409 { 410 if (!$row['forum_id']) 411 { 412 // Global Announcement? 413 $row['forum_id'] = request_var('f', 0); 414 } 415 416 $rowset[$row['topic_id']] = $row; 417 418 if ($acl_list && !$auth->acl_gets($acl_list, $row['forum_id'])) 419 { 420 continue; 421 } 422 423 $topics[$row['topic_id']] = $row; 424 } 425 $db->sql_freeresult($result); 426 } 427 428 foreach ($cache_topic_ids as $id) 429 { 430 if (!$acl_list || $auth->acl_gets($acl_list, $rowset[$id]['forum_id'])) 431 { 432 $topics[$id] = $rowset[$id]; 433 } 434 } 435 436 return $topics; 437 } 438 439 /** 440 * Get simple post data 441 */ 442 function get_post_data($post_ids, $acl_list = false, $read_tracking = false) 443 { 444 global $db, $auth, $config, $user; 445 446 $rowset = array(); 447 448 if (!sizeof($post_ids)) 449 { 450 return array(); 451 } 452 453 $sql_array = array( 454 'SELECT' => 'p.*, u.*, t.*, f.*', 455 456 'FROM' => array( 457 USERS_TABLE => 'u', 458 POSTS_TABLE => 'p', 459 TOPICS_TABLE => 't', 460 ), 461 462 'LEFT_JOIN' => array( 463 array( 464 'FROM' => array(FORUMS_TABLE => 'f'), 465 'ON' => 'f.forum_id = t.forum_id' 466 ) 467 ), 468 469 'WHERE' => $db->sql_in_set('p.post_id', $post_ids) . ' 470 AND u.user_id = p.poster_id 471 AND t.topic_id = p.topic_id', 472 ); 473 474 if ($read_tracking && $config['load_db_lastread']) 475 { 476 $sql_array['SELECT'] .= ', tt.mark_time, ft.mark_time as forum_mark_time'; 477 478 $sql_array['LEFT_JOIN'][] = array( 479 'FROM' => array(TOPICS_TRACK_TABLE => 'tt'), 480 'ON' => 'tt.user_id = ' . $user->data['user_id'] . ' AND t.topic_id = tt.topic_id' 481 ); 482 483 $sql_array['LEFT_JOIN'][] = array( 484 'FROM' => array(FORUMS_TRACK_TABLE => 'ft'), 485 'ON' => 'ft.user_id = ' . $user->data['user_id'] . ' AND t.forum_id = ft.forum_id' 486 ); 487 } 488 489 $sql = $db->sql_build_query('SELECT', $sql_array); 490 $result = $db->sql_query($sql); 491 unset($sql_array); 492 493 while ($row = $db->sql_fetchrow($result)) 494 { 495 if (!$row['forum_id']) 496 { 497 // Global Announcement? 498 $row['forum_id'] = request_var('f', 0); 499 } 500 501 if ($acl_list && !$auth->acl_gets($acl_list, $row['forum_id'])) 502 { 503 continue; 504 } 505 506 if (!$row['post_approved'] && !$auth->acl_get('m_approve', $row['forum_id'])) 507 { 508 // Moderators without the permission to approve post should at least not see them. ;) 509 continue; 510 } 511 512 $rowset[$row['post_id']] = $row; 513 } 514 $db->sql_freeresult($result); 515 516 return $rowset; 517 } 518 519 /** 520 * Get simple forum data 521 */ 522 function get_forum_data($forum_id, $acl_list = 'f_list', $read_tracking = false) 523 { 524 global $auth, $db, $user, $config; 525 526 $rowset = array(); 527 528 if (!is_array($forum_id)) 529 { 530 $forum_id = array($forum_id); 531 } 532 533 if (!sizeof($forum_id)) 534 { 535 return array(); 536 } 537 538 if ($read_tracking && $config['load_db_lastread']) 539 { 540 $read_tracking_join = ' LEFT JOIN ' . FORUMS_TRACK_TABLE . ' ft ON (ft.user_id = ' . $user->data['user_id'] . ' 541 AND ft.forum_id = f.forum_id)'; 542 $read_tracking_select = ', ft.mark_time'; 543 } 544 else 545 { 546 $read_tracking_join = $read_tracking_select = ''; 547 } 548 549 $sql = "SELECT f.* $read_tracking_select 550 FROM " . FORUMS_TABLE . " f$read_tracking_join 551 WHERE " . $db->sql_in_set('f.forum_id', $forum_id); 552 $result = $db->sql_query($sql); 553 554 while ($row = $db->sql_fetchrow($result)) 555 { 556 if ($acl_list && !$auth->acl_gets($acl_list, $row['forum_id'])) 557 { 558 continue; 559 } 560 561 if ($auth->acl_get('m_approve', $row['forum_id'])) 562 { 563 $row['forum_topics'] = $row['forum_topics_real']; 564 } 565 566 $rowset[$row['forum_id']] = $row; 567 } 568 $db->sql_freeresult($result); 569 570 return $rowset; 571 } 572 573 /** 574 * Get simple pm data 575 */ 576 function get_pm_data($pm_ids) 577 { 578 global $db, $auth, $config, $user; 579 580 $rowset = array(); 581 582 if (!sizeof($pm_ids)) 583 { 584 return array(); 585 } 586 587 $sql_array = array( 588 'SELECT' => 'p.*, u.*', 589 590 'FROM' => array( 591 USERS_TABLE => 'u', 592 PRIVMSGS_TABLE => 'p', 593 ), 594 595 'WHERE' => $db->sql_in_set('p.msg_id', $pm_ids) . ' 596 AND u.user_id = p.author_id', 597 ); 598 599 $sql = $db->sql_build_query('SELECT', $sql_array); 600 $result = $db->sql_query($sql); 601 unset($sql_array); 602 603 while ($row = $db->sql_fetchrow($result)) 604 { 605 $rowset[$row['msg_id']] = $row; 606 } 607 $db->sql_freeresult($result); 608 609 return $rowset; 610 } 611 612 /** 613 * sorting in mcp 614 * 615 * @param string $where_sql should either be WHERE (default if ommited) or end with AND or OR 616 * 617 * $mode reports and reports_closed: the $where parameters uses aliases p for posts table and r for report table 618 * $mode unapproved_posts: the $where parameters uses aliases p for posts table and t for topic table 619 */ 620 function mcp_sorting($mode, &$sort_days, &$sort_key, &$sort_dir, &$sort_by_sql, &$sort_order_sql, &$total, $forum_id = 0, $topic_id = 0, $where_sql = 'WHERE') 621 { 622 global $db, $user, $auth, $template; 623 624 $sort_days = request_var('st', 0); 625 $min_time = ($sort_days) ? time() - ($sort_days * 86400) : 0; 626 627 switch ($mode) 628 { 629 case 'viewforum': 630 $type = 'topics'; 631 $default_key = 't'; 632 $default_dir = 'd'; 633 634 $sql = 'SELECT COUNT(topic_id) AS total 635 FROM ' . TOPICS_TABLE . " 636 $where_sql forum_id = $forum_id 637 AND topic_type NOT IN (" . POST_ANNOUNCE . ', ' . POST_GLOBAL . ") 638 AND topic_last_post_time >= $min_time"; 639 640 if (!$auth->acl_get('m_approve', $forum_id)) 641 { 642 $sql .= 'AND topic_approved = 1'; 643 } 644 break; 645 646 case 'viewtopic': 647 $type = 'posts'; 648 $default_key = 't'; 649 $default_dir = 'a'; 650 651 $sql = 'SELECT COUNT(post_id) AS total 652 FROM ' . POSTS_TABLE . " 653 $where_sql topic_id = $topic_id 654 AND post_time >= $min_time"; 655 656 if (!$auth->acl_get('m_approve', $forum_id)) 657 { 658 $sql .= 'AND post_approved = 1'; 659 } 660 break; 661 662 case 'unapproved_posts': 663 $type = 'posts'; 664 $default_key = 't'; 665 $default_dir = 'd'; 666 $where_sql .= ($topic_id) ? ' p.topic_id = ' . $topic_id . ' AND' : ''; 667 668 $sql = 'SELECT COUNT(p.post_id) AS total 669 FROM ' . POSTS_TABLE . ' p, ' . TOPICS_TABLE . " t 670 $where_sql " . $db->sql_in_set('p.forum_id', ($forum_id) ? array($forum_id) : array_intersect(get_forum_list('f_read'), get_forum_list('m_approve'))) . ' 671 AND p.post_approved = 0 672 AND t.topic_id = p.topic_id 673 AND t.topic_first_post_id <> p.post_id'; 674 675 if ($min_time) 676 { 677 $sql .= ' AND post_time >= ' . $min_time; 678 } 679 break; 680 681 case 'unapproved_topics': 682 $type = 'topics'; 683 $default_key = 't'; 684 $default_dir = 'd'; 685 686 $sql = 'SELECT COUNT(topic_id) AS total 687 FROM ' . TOPICS_TABLE . " 688 $where_sql " . $db->sql_in_set('forum_id', ($forum_id) ? array($forum_id) : array_intersect(get_forum_list('f_read'), get_forum_list('m_approve'))) . ' 689 AND topic_approved = 0'; 690 691 if ($min_time) 692 { 693 $sql .= ' AND topic_time >= ' . $min_time; 694 } 695 break; 696 697 case 'pm_reports': 698 case 'pm_reports_closed': 699 case 'reports': 700 case 'reports_closed': 701 $pm = (strpos($mode, 'pm_') === 0) ? true : false; 702 703 $type = ($pm) ? 'pm_reports' : 'reports'; 704 $default_key = 't'; 705 $default_dir = 'd'; 706 $limit_time_sql = ($min_time) ? "AND r.report_time >= $min_time" : ''; 707 708 if ($topic_id) 709 { 710 $where_sql .= ' p.topic_id = ' . $topic_id . ' AND '; 711 } 712 else if ($forum_id) 713 { 714 $where_sql .= ' p.forum_id = ' . $forum_id . ' AND '; 715 } 716 else if (!$pm) 717 { 718 $where_sql .= ' ' . $db->sql_in_set('p.forum_id', get_forum_list(array('!f_read', '!m_report')), true, true) . ' AND '; 719 } 720 721 if ($mode == 'reports' || $mode == 'pm_reports') 722 { 723 $where_sql .= ' r.report_closed = 0 AND '; 724 } 725 else 726 { 727 $where_sql .= ' r.report_closed = 1 AND '; 728 } 729 730 if ($pm) 731 { 732 $sql = 'SELECT COUNT(r.report_id) AS total 733 FROM ' . REPORTS_TABLE . ' r, ' . PRIVMSGS_TABLE . " p 734 $where_sql r.post_id = 0 735 AND p.msg_id = r.pm_id 736 $limit_time_sql"; 737 } 738 else 739 { 740 $sql = 'SELECT COUNT(r.report_id) AS total 741 FROM ' . REPORTS_TABLE . ' r, ' . POSTS_TABLE . " p 742 $where_sql r.pm_id = 0 743 AND p.post_id = r.post_id 744 $limit_time_sql"; 745 } 746 break; 747 748 case 'viewlogs': 749 $type = 'logs'; 750 $default_key = 't'; 751 $default_dir = 'd'; 752 753 $sql = 'SELECT COUNT(log_id) AS total 754 FROM ' . LOG_TABLE . " 755 $where_sql " . $db->sql_in_set('forum_id', ($forum_id) ? array($forum_id) : array_intersect(get_forum_list('f_read'), get_forum_list('m_'))) . ' 756 AND log_time >= ' . $min_time . ' 757 AND log_type = ' . LOG_MOD; 758 break; 759 } 760 761 $sort_key = request_var('sk', $default_key); 762 $sort_dir = request_var('sd', $default_dir); 763 $sort_dir_text = array('a' => $user->lang['ASCENDING'], 'd' => $user->lang['DESCENDING']); 764 765 switch ($type) 766 { 767 case 'topics': 768 $limit_days = array(0 => $user->lang['ALL_TOPICS'], 1 => $user->lang['1_DAY'], 7 => $user->lang['7_DAYS'], 14 => $user->lang['2_WEEKS'], 30 => $user->lang['1_MONTH'], 90 => $user->lang['3_MONTHS'], 180 => $user->lang['6_MONTHS'], 365 => $user->lang['1_YEAR']); 769 $sort_by_text = array('a' => $user->lang['AUTHOR'], 't' => $user->lang['POST_TIME'], 'tt' => $user->lang['TOPIC_TIME'], 'r' => $user->lang['REPLIES'], 's' => $user->lang['SUBJECT'], 'v' => $user->lang['VIEWS']); 770 771 $sort_by_sql = array('a' => 't.topic_first_poster_name', 't' => 't.topic_last_post_time', 'tt' => 't.topic_time', 'r' => (($auth->acl_get('m_approve', $forum_id)) ? 't.topic_replies_real' : 't.topic_replies'), 's' => 't.topic_title', 'v' => 't.topic_views'); 772 $limit_time_sql = ($min_time) ? "AND t.topic_last_post_time >= $min_time" : ''; 773 break; 774 775 case 'posts': 776 $limit_days = array(0 => $user->lang['ALL_POSTS'], 1 => $user->lang['1_DAY'], 7 => $user->lang['7_DAYS'], 14 => $user->lang['2_WEEKS'], 30 => $user->lang['1_MONTH'], 90 => $user->lang['3_MONTHS'], 180 => $user->lang['6_MONTHS'], 365 => $user->lang['1_YEAR']); 777 $sort_by_text = array('a' => $user->lang['AUTHOR'], 't' => $user->lang['POST_TIME'], 's' => $user->lang['SUBJECT']); 778 $sort_by_sql = array('a' => 'u.username_clean', 't' => 'p.post_time', 's' => 'p.post_subject'); 779 $limit_time_sql = ($min_time) ? "AND p.post_time >= $min_time" : ''; 780 break; 781 782 case 'reports': 783 $limit_days = array(0 => $user->lang['ALL_REPORTS'], 1 => $user->lang['1_DAY'], 7 => $user->lang['7_DAYS'], 14 => $user->lang['2_WEEKS'], 30 => $user->lang['1_MONTH'], 90 => $user->lang['3_MONTHS'], 180 => $user->lang['6_MONTHS'], 365 => $user->lang['1_YEAR']); 784 $sort_by_text = array('a' => $user->lang['AUTHOR'], 'r' => $user->lang['REPORTER'], 'p' => $user->lang['POST_TIME'], 't' => $user->lang['REPORT_TIME'], 's' => $user->lang['SUBJECT']); 785 $sort_by_sql = array('a' => 'u.username_clean', 'r' => 'ru.username', 'p' => 'p.post_time', 't' => 'r.report_time', 's' => 'p.post_subject'); 786 break; 787 788 case 'pm_reports': 789 $limit_days = array(0 => $user->lang['ALL_REPORTS'], 1 => $user->lang['1_DAY'], 7 => $user->lang['7_DAYS'], 14 => $user->lang['2_WEEKS'], 30 => $user->lang['1_MONTH'], 90 => $user->lang['3_MONTHS'], 180 => $user->lang['6_MONTHS'], 365 => $user->lang['1_YEAR']); 790 $sort_by_text = array('a' => $user->lang['AUTHOR'], 'r' => $user->lang['REPORTER'], 'p' => $user->lang['POST_TIME'], 't' => $user->lang['REPORT_TIME'], 's' => $user->lang['SUBJECT']); 791 $sort_by_sql = array('a' => 'u.username_clean', 'r' => 'ru.username', 'p' => 'p.message_time', 't' => 'r.report_time', 's' => 'p.message_subject'); 792 break; 793 794 case 'logs': 795 $limit_days = array(0 => $user->lang['ALL_ENTRIES'], 1 => $user->lang['1_DAY'], 7 => $user->lang['7_DAYS'], 14 => $user->lang['2_WEEKS'], 30 => $user->lang['1_MONTH'], 90 => $user->lang['3_MONTHS'], 180 => $user->lang['6_MONTHS'], 365 => $user->lang['1_YEAR']); 796 $sort_by_text = array('u' => $user->lang['SORT_USERNAME'], 't' => $user->lang['SORT_DATE'], 'i' => $user->lang['SORT_IP'], 'o' => $user->lang['SORT_ACTION']); 797 798 $sort_by_sql = array('u' => 'u.username_clean', 't' => 'l.log_time', 'i' => 'l.log_ip', 'o' => 'l.log_operation'); 799 $limit_time_sql = ($min_time) ? "AND l.log_time >= $min_time" : ''; 800 break; 801 } 802 803 if (!isset($sort_by_sql[$sort_key])) 804 { 805 $sort_key = $default_key; 806 } 807 808 $sort_order_sql = $sort_by_sql[$sort_key] . ' ' . (($sort_dir == 'd') ? 'DESC' : 'ASC'); 809 810 $s_limit_days = $s_sort_key = $s_sort_dir = $sort_url = ''; 811 gen_sort_selects($limit_days, $sort_by_text, $sort_days, $sort_key, $sort_dir, $s_limit_days, $s_sort_key, $s_sort_dir, $sort_url); 812 813 $template->assign_vars(array( 814 'S_SELECT_SORT_DIR' => $s_sort_dir, 815 'S_SELECT_SORT_KEY' => $s_sort_key, 816 'S_SELECT_SORT_DAYS' => $s_limit_days) 817 ); 818 819 if (($sort_days && $mode != 'viewlogs') || in_array($mode, array('reports', 'unapproved_topics', 'unapproved_posts')) || $where_sql != 'WHERE') 820 { 821 $result = $db->sql_query($sql); 822 $total = (int) $db->sql_fetchfield('total'); 823 $db->sql_freeresult($result); 824 } 825 else 826 { 827 $total = -1; 828 } 829 } 830 831 /** 832 * Validate ids 833 * 834 * @param array &$ids The relevant ids to check 835 * @param string $table The table to find the ids in 836 * @param string $sql_id The ids relevant column name 837 * @param array $acl_list A list of permissions the user need to have 838 * @param mixed $singe_forum Limit to one forum id (int) or the first forum found (true) 839 * 840 * @return mixed False if no ids were able to be retrieved, true if at least one id left. 841 * Additionally, this value can be the forum_id assigned if $single_forum was set. 842 * Therefore checking the result for with !== false is the best method. 843 */ 844 function check_ids(&$ids, $table, $sql_id, $acl_list = false, $single_forum = false) 845 { 846 global $db, $auth; 847 848 if (!is_array($ids) || empty($ids)) 849 { 850 return false; 851 } 852 853 $sql = "SELECT $sql_id, forum_id FROM $table 854 WHERE " . $db->sql_in_set($sql_id, $ids); 855 $result = $db->sql_query($sql); 856 857 $ids = array(); 858 $forum_id = false; 859 860 while ($row = $db->sql_fetchrow($result)) 861 { 862 if ($acl_list && $row['forum_id'] && !$auth->acl_gets($acl_list, $row['forum_id'])) 863 { 864 continue; 865 } 866 867 if ($acl_list && !$row['forum_id'] && !$auth->acl_getf_global($acl_list)) 868 { 869 continue; 870 } 871 872 // Limit forum? If not, just assign the id. 873 if ($single_forum === false) 874 { 875 $ids[] = $row[$sql_id]; 876 continue; 877 } 878 879 // Limit forum to a specific forum id? 880 // This can get really tricky, because we do not want to create a failure on global topics. :) 881 if ($row['forum_id']) 882 { 883 if ($single_forum !== true && $row['forum_id'] == (int) $single_forum) 884 { 885 $forum_id = (int) $single_forum; 886 } 887 else if ($forum_id === false) 888 { 889 $forum_id = $row['forum_id']; 890 } 891 892 if ($row['forum_id'] == $forum_id) 893 { 894 $ids[] = $row[$sql_id]; 895 } 896 } 897 else 898 { 899 // Always add a global topic 900 $ids[] = $row[$sql_id]; 901 } 902 } 903 $db->sql_freeresult($result); 904 905 if (!sizeof($ids)) 906 { 907 return false; 908 } 909 910 // If forum id is false and ids populated we may have only global announcements selected (returning 0 because of (int) $forum_id) 911 912 return ($single_forum === false) ? true : (int) $forum_id; 913 } 914 915 ?>
title
Description
Body
title
Description
Body
title
Description
Body
title
Body
| Generated: Wed Oct 2 15:03:47 2013 | Cross-referenced by PHPXref 0.7.1 |