[ Index ] |
PHP Cross Reference of phpBB-3.1.12-deutsch |
[Summary view] [Print] [Text view]
1 <?php 2 /** 3 * 4 * This file is part of the phpBB Forum Software package. 5 * 6 * @copyright (c) phpBB Limited <https://www.phpbb.com> 7 * @license GNU General Public License, version 2 (GPL-2.0) 8 * 9 * For full copyright and license information, please see 10 * the docs/CREDITS.txt file. 11 * 12 */ 13 14 /** 15 * @ignore 16 */ 17 if (!defined('IN_PHPBB')) 18 { 19 exit; 20 } 21 22 /** 23 * ucp_groups 24 */ 25 class ucp_groups 26 { 27 var $u_action; 28 29 function main($id, $mode) 30 { 31 global $config, $phpbb_root_path, $phpEx, $phpbb_admin_path; 32 global $db, $user, $auth, $cache, $template; 33 global $request, $phpbb_container; 34 35 $user->add_lang('groups'); 36 37 $return_page = '<br /><br />' . sprintf($user->lang['RETURN_PAGE'], '<a href="' . $this->u_action . '">', '</a>'); 38 39 $mark_ary = request_var('mark', array(0)); 40 $submit = $request->variable('submit', false, false, \phpbb\request\request_interface::POST); 41 $delete = $request->variable('delete', false, false, \phpbb\request\request_interface::POST); 42 $error = $data = array(); 43 44 switch ($mode) 45 { 46 case 'membership': 47 48 $this->page_title = 'UCP_USERGROUPS_MEMBER'; 49 50 if ($submit || isset($_POST['change_default'])) 51 { 52 $action = (isset($_POST['change_default'])) ? 'change_default' : request_var('action', ''); 53 $group_id = ($action == 'change_default') ? request_var('default', 0) : request_var('selected', 0); 54 55 if (!$group_id) 56 { 57 trigger_error('NO_GROUP_SELECTED'); 58 } 59 60 $sql = 'SELECT group_id, group_name, group_type 61 FROM ' . GROUPS_TABLE . " 62 WHERE group_id IN ($group_id, {$user->data['group_id']})"; 63 $result = $db->sql_query($sql); 64 65 $group_row = array(); 66 while ($row = $db->sql_fetchrow($result)) 67 { 68 $row['group_name'] = ($row['group_type'] == GROUP_SPECIAL) ? $user->lang['G_' . $row['group_name']] : $row['group_name']; 69 $group_row[$row['group_id']] = $row; 70 } 71 $db->sql_freeresult($result); 72 73 if (!sizeof($group_row)) 74 { 75 trigger_error('GROUP_NOT_EXIST'); 76 } 77 78 switch ($action) 79 { 80 case 'change_default': 81 // User already having this group set as default? 82 if ($group_id == $user->data['group_id']) 83 { 84 trigger_error($user->lang['ALREADY_DEFAULT_GROUP'] . $return_page); 85 } 86 87 if (!$auth->acl_get('u_chggrp')) 88 { 89 trigger_error($user->lang['NOT_AUTHORISED'] . $return_page); 90 } 91 92 // User needs to be member of the group in order to make it default 93 if (!group_memberships($group_id, $user->data['user_id'], true)) 94 { 95 trigger_error($user->lang['NOT_MEMBER_OF_GROUP'] . $return_page); 96 } 97 98 if (confirm_box(true)) 99 { 100 group_user_attributes('default', $group_id, $user->data['user_id']); 101 102 add_log('user', $user->data['user_id'], 'LOG_USER_GROUP_CHANGE', sprintf($user->lang['USER_GROUP_CHANGE'], $group_row[$user->data['group_id']]['group_name'], $group_row[$group_id]['group_name'])); 103 104 meta_refresh(3, $this->u_action); 105 trigger_error($user->lang['CHANGED_DEFAULT_GROUP'] . $return_page); 106 } 107 else 108 { 109 $s_hidden_fields = array( 110 'default' => $group_id, 111 'change_default'=> true 112 ); 113 114 confirm_box(false, sprintf($user->lang['GROUP_CHANGE_DEFAULT'], $group_row[$group_id]['group_name']), build_hidden_fields($s_hidden_fields)); 115 } 116 117 break; 118 119 case 'resign': 120 121 // User tries to resign from default group but is not allowed to change it? 122 if ($group_id == $user->data['group_id'] && !$auth->acl_get('u_chggrp')) 123 { 124 trigger_error($user->lang['NOT_RESIGN_FROM_DEFAULT_GROUP'] . $return_page); 125 } 126 127 if (!($row = group_memberships($group_id, $user->data['user_id']))) 128 { 129 trigger_error($user->lang['NOT_MEMBER_OF_GROUP'] . $return_page); 130 } 131 list(, $row) = each($row); 132 133 $sql = 'SELECT group_type 134 FROM ' . GROUPS_TABLE . ' 135 WHERE group_id = ' . $group_id; 136 $result = $db->sql_query($sql); 137 $group_type = (int) $db->sql_fetchfield('group_type'); 138 $db->sql_freeresult($result); 139 140 if ($group_type != GROUP_OPEN && $group_type != GROUP_FREE) 141 { 142 trigger_error($user->lang['CANNOT_RESIGN_GROUP'] . $return_page); 143 } 144 145 if (confirm_box(true)) 146 { 147 group_user_del($group_id, $user->data['user_id']); 148 149 add_log('user', $user->data['user_id'], 'LOG_USER_GROUP_RESIGN', $group_row[$group_id]['group_name']); 150 151 meta_refresh(3, $this->u_action); 152 trigger_error($user->lang[($row['user_pending']) ? 'GROUP_RESIGNED_PENDING' : 'GROUP_RESIGNED_MEMBERSHIP'] . $return_page); 153 } 154 else 155 { 156 $s_hidden_fields = array( 157 'selected' => $group_id, 158 'action' => 'resign', 159 'submit' => true 160 ); 161 162 confirm_box(false, ($row['user_pending']) ? 'GROUP_RESIGN_PENDING' : 'GROUP_RESIGN_MEMBERSHIP', build_hidden_fields($s_hidden_fields)); 163 } 164 165 break; 166 167 case 'join': 168 169 $sql = 'SELECT ug.*, u.username, u.username_clean, u.user_email 170 FROM ' . USER_GROUP_TABLE . ' ug, ' . USERS_TABLE . ' u 171 WHERE ug.user_id = u.user_id 172 AND ug.group_id = ' . $group_id . ' 173 AND ug.user_id = ' . $user->data['user_id']; 174 $result = $db->sql_query($sql); 175 $row = $db->sql_fetchrow($result); 176 $db->sql_freeresult($result); 177 178 if ($row) 179 { 180 if ($row['user_pending']) 181 { 182 trigger_error($user->lang['ALREADY_IN_GROUP_PENDING'] . $return_page); 183 } 184 185 trigger_error($user->lang['ALREADY_IN_GROUP'] . $return_page); 186 } 187 188 // Check permission to join (open group or request) 189 if ($group_row[$group_id]['group_type'] != GROUP_OPEN && $group_row[$group_id]['group_type'] != GROUP_FREE) 190 { 191 trigger_error($user->lang['CANNOT_JOIN_GROUP'] . $return_page); 192 } 193 194 if (confirm_box(true)) 195 { 196 if ($group_row[$group_id]['group_type'] == GROUP_FREE) 197 { 198 group_user_add($group_id, $user->data['user_id']); 199 } 200 else 201 { 202 group_user_add($group_id, $user->data['user_id'], false, false, false, 0, 1); 203 } 204 205 add_log('user', $user->data['user_id'], 'LOG_USER_GROUP_JOIN' . (($group_row[$group_id]['group_type'] == GROUP_FREE) ? '' : '_PENDING'), $group_row[$group_id]['group_name']); 206 207 meta_refresh(3, $this->u_action); 208 trigger_error($user->lang[($group_row[$group_id]['group_type'] == GROUP_FREE) ? 'GROUP_JOINED' : 'GROUP_JOINED_PENDING'] . $return_page); 209 } 210 else 211 { 212 $s_hidden_fields = array( 213 'selected' => $group_id, 214 'action' => 'join', 215 'submit' => true 216 ); 217 218 confirm_box(false, ($group_row[$group_id]['group_type'] == GROUP_FREE) ? 'GROUP_JOIN' : 'GROUP_JOIN_PENDING', build_hidden_fields($s_hidden_fields)); 219 } 220 221 break; 222 223 case 'demote': 224 225 if (!($row = group_memberships($group_id, $user->data['user_id']))) 226 { 227 trigger_error($user->lang['NOT_MEMBER_OF_GROUP'] . $return_page); 228 } 229 list(, $row) = each($row); 230 231 if (!$row['group_leader']) 232 { 233 trigger_error($user->lang['NOT_LEADER_OF_GROUP'] . $return_page); 234 } 235 236 if (confirm_box(true)) 237 { 238 group_user_attributes('demote', $group_id, $user->data['user_id']); 239 240 add_log('user', $user->data['user_id'], 'LOG_USER_GROUP_DEMOTE', $group_row[$group_id]['group_name']); 241 242 meta_refresh(3, $this->u_action); 243 trigger_error($user->lang['USER_GROUP_DEMOTED'] . $return_page); 244 } 245 else 246 { 247 $s_hidden_fields = array( 248 'selected' => $group_id, 249 'action' => 'demote', 250 'submit' => true 251 ); 252 253 confirm_box(false, 'USER_GROUP_DEMOTE', build_hidden_fields($s_hidden_fields)); 254 } 255 256 break; 257 } 258 } 259 260 $sql = 'SELECT g.*, ug.group_leader, ug.user_pending 261 FROM ' . GROUPS_TABLE . ' g, ' . USER_GROUP_TABLE . ' ug 262 WHERE ug.user_id = ' . $user->data['user_id'] . ' 263 AND g.group_id = ug.group_id 264 ORDER BY g.group_type DESC, g.group_name'; 265 $result = $db->sql_query($sql); 266 267 $group_id_ary = array(); 268 $leader_count = $member_count = $pending_count = 0; 269 while ($row = $db->sql_fetchrow($result)) 270 { 271 $block = ($row['group_leader']) ? 'leader' : (($row['user_pending']) ? 'pending' : 'member'); 272 273 switch ($row['group_type']) 274 { 275 case GROUP_OPEN: 276 $group_status = 'OPEN'; 277 break; 278 279 case GROUP_CLOSED: 280 $group_status = 'CLOSED'; 281 break; 282 283 case GROUP_HIDDEN: 284 $group_status = 'HIDDEN'; 285 break; 286 287 case GROUP_SPECIAL: 288 $group_status = 'SPECIAL'; 289 break; 290 291 case GROUP_FREE: 292 $group_status = 'FREE'; 293 break; 294 } 295 296 $template->assign_block_vars($block, array( 297 'GROUP_ID' => $row['group_id'], 298 'GROUP_NAME' => ($row['group_type'] == GROUP_SPECIAL) ? $user->lang['G_' . $row['group_name']] : $row['group_name'], 299 'GROUP_DESC' => ($row['group_type'] <> GROUP_SPECIAL) ? generate_text_for_display($row['group_desc'], $row['group_desc_uid'], $row['group_desc_bitfield'], $row['group_desc_options']) : $user->lang['GROUP_IS_SPECIAL'], 300 'GROUP_SPECIAL' => ($row['group_type'] <> GROUP_SPECIAL) ? false : true, 301 'GROUP_STATUS' => $user->lang['GROUP_IS_' . $group_status], 302 'GROUP_COLOUR' => $row['group_colour'], 303 304 'U_VIEW_GROUP' => append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=group&g=' . $row['group_id']), 305 306 'S_GROUP_DEFAULT' => ($row['group_id'] == $user->data['group_id']) ? true : false, 307 'S_ROW_COUNT' => ${$block . '_count'}++) 308 ); 309 310 $group_id_ary[] = (int) $row['group_id']; 311 } 312 $db->sql_freeresult($result); 313 314 // Hide hidden groups unless user is an admin with group privileges 315 $sql_and = ($auth->acl_gets('a_group', 'a_groupadd', 'a_groupdel')) ? '<> ' . GROUP_SPECIAL : 'NOT IN (' . GROUP_SPECIAL . ', ' . GROUP_HIDDEN . ')'; 316 317 $sql = 'SELECT group_id, group_name, group_colour, group_desc, group_desc_uid, group_desc_bitfield, group_desc_options, group_type, group_founder_manage 318 FROM ' . GROUPS_TABLE . ' 319 WHERE ' . ((sizeof($group_id_ary)) ? $db->sql_in_set('group_id', $group_id_ary, true) . ' AND ' : '') . " 320 group_type $sql_and 321 ORDER BY group_type DESC, group_name"; 322 $result = $db->sql_query($sql); 323 324 $nonmember_count = 0; 325 while ($row = $db->sql_fetchrow($result)) 326 { 327 switch ($row['group_type']) 328 { 329 case GROUP_OPEN: 330 $group_status = 'OPEN'; 331 break; 332 333 case GROUP_CLOSED: 334 $group_status = 'CLOSED'; 335 break; 336 337 case GROUP_HIDDEN: 338 $group_status = 'HIDDEN'; 339 break; 340 341 case GROUP_SPECIAL: 342 $group_status = 'SPECIAL'; 343 break; 344 345 case GROUP_FREE: 346 $group_status = 'FREE'; 347 break; 348 } 349 350 $template->assign_block_vars('nonmember', array( 351 'GROUP_ID' => $row['group_id'], 352 'GROUP_NAME' => ($row['group_type'] == GROUP_SPECIAL) ? $user->lang['G_' . $row['group_name']] : $row['group_name'], 353 'GROUP_DESC' => ($row['group_type'] <> GROUP_SPECIAL) ? generate_text_for_display($row['group_desc'], $row['group_desc_uid'], $row['group_desc_bitfield'], $row['group_desc_options']) : $user->lang['GROUP_IS_SPECIAL'], 354 'GROUP_SPECIAL' => ($row['group_type'] <> GROUP_SPECIAL) ? false : true, 355 'GROUP_CLOSED' => ($row['group_type'] <> GROUP_CLOSED || $auth->acl_gets('a_group', 'a_groupadd', 'a_groupdel')) ? false : true, 356 'GROUP_STATUS' => $user->lang['GROUP_IS_' . $group_status], 357 'S_CAN_JOIN' => ($row['group_type'] == GROUP_OPEN || $row['group_type'] == GROUP_FREE) ? true : false, 358 'GROUP_COLOUR' => $row['group_colour'], 359 360 'U_VIEW_GROUP' => append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=group&g=' . $row['group_id']), 361 362 'S_ROW_COUNT' => $nonmember_count++) 363 ); 364 } 365 $db->sql_freeresult($result); 366 367 $template->assign_vars(array( 368 'S_CHANGE_DEFAULT' => ($auth->acl_get('u_chggrp')) ? true : false, 369 'S_LEADER_COUNT' => $leader_count, 370 'S_MEMBER_COUNT' => $member_count, 371 'S_PENDING_COUNT' => $pending_count, 372 'S_NONMEMBER_COUNT' => $nonmember_count, 373 374 'S_UCP_ACTION' => $this->u_action) 375 ); 376 377 break; 378 379 case 'manage': 380 381 $this->page_title = 'UCP_USERGROUPS_MANAGE'; 382 $action = (isset($_POST['addusers'])) ? 'addusers' : request_var('action', ''); 383 $group_id = request_var('g', 0); 384 385 include($phpbb_root_path . 'includes/functions_display.' . $phpEx); 386 387 add_form_key('ucp_groups'); 388 389 if ($group_id) 390 { 391 $sql = 'SELECT g.*, t.teampage_position AS group_teampage 392 FROM ' . GROUPS_TABLE . ' g 393 LEFT JOIN ' . TEAMPAGE_TABLE . ' t 394 ON (t.group_id = g.group_id) 395 WHERE g.group_id = ' . $group_id; 396 $result = $db->sql_query($sql); 397 $group_row = $db->sql_fetchrow($result); 398 $db->sql_freeresult($result); 399 400 if (!$group_row) 401 { 402 trigger_error($user->lang['NO_GROUP'] . $return_page); 403 } 404 405 // Check if the user is allowed to manage this group if set to founder only. 406 if ($user->data['user_type'] != USER_FOUNDER && $group_row['group_founder_manage']) 407 { 408 trigger_error($user->lang['NOT_ALLOWED_MANAGE_GROUP'] . $return_page, E_USER_WARNING); 409 } 410 411 $group_name = $group_row['group_name']; 412 $group_type = $group_row['group_type']; 413 414 $avatar = phpbb_get_group_avatar($group_row, 'GROUP_AVATAR', true); 415 416 $template->assign_vars(array( 417 'GROUP_NAME' => ($group_type == GROUP_SPECIAL) ? $user->lang['G_' . $group_name] : $group_name, 418 'GROUP_INTERNAL_NAME' => $group_name, 419 'GROUP_COLOUR' => (isset($group_row['group_colour'])) ? $group_row['group_colour'] : '', 420 'GROUP_DESC_DISP' => generate_text_for_display($group_row['group_desc'], $group_row['group_desc_uid'], $group_row['group_desc_bitfield'], $group_row['group_desc_options']), 421 'GROUP_TYPE' => $group_row['group_type'], 422 423 'AVATAR' => (empty($avatar) ? '<img src="' . $phpbb_admin_path . 'images/no_avatar.gif" alt="" />' : $avatar), 424 'AVATAR_IMAGE' => (empty($avatar) ? '<img src="' . $phpbb_admin_path . 'images/no_avatar.gif" alt="" />' : $avatar), 425 'AVATAR_WIDTH' => (isset($group_row['group_avatar_width'])) ? $group_row['group_avatar_width'] : '', 426 'AVATAR_HEIGHT' => (isset($group_row['group_avatar_height'])) ? $group_row['group_avatar_height'] : '', 427 )); 428 } 429 430 switch ($action) 431 { 432 case 'edit': 433 434 if (!$group_id) 435 { 436 trigger_error($user->lang['NO_GROUP'] . $return_page); 437 } 438 439 if (!($row = group_memberships($group_id, $user->data['user_id']))) 440 { 441 trigger_error($user->lang['NOT_MEMBER_OF_GROUP'] . $return_page); 442 } 443 list(, $row) = each($row); 444 445 if (!$row['group_leader']) 446 { 447 trigger_error($user->lang['NOT_LEADER_OF_GROUP'] . $return_page); 448 } 449 450 $file_uploads = (@ini_get('file_uploads') || strtolower(@ini_get('file_uploads')) == 'on') ? true : false; 451 $user->add_lang(array('acp/groups', 'acp/common')); 452 453 $data = $submit_ary = array(); 454 455 $update = (isset($_POST['update'])) ? true : false; 456 457 $error = array(); 458 459 // Setup avatar data for later 460 $avatars_enabled = false; 461 $avatar_drivers = null; 462 $avatar_data = null; 463 $avatar_error = array(); 464 465 /** @var \phpbb\avatar\manager $phpbb_avatar_manager */ 466 $phpbb_avatar_manager = $phpbb_container->get('avatar.manager'); 467 468 if ($config['allow_avatar']) 469 { 470 $avatar_drivers = $phpbb_avatar_manager->get_enabled_drivers(); 471 472 // This is normalised data, without the group_ prefix 473 $avatar_data = \phpbb\avatar\manager::clean_row($group_row, 'group'); 474 } 475 476 // Handle deletion of avatars 477 if ($request->is_set_post('avatar_delete')) 478 { 479 if (confirm_box(true)) 480 { 481 $phpbb_avatar_manager->handle_avatar_delete($db, $user, $avatar_data, GROUPS_TABLE, 'group_'); 482 $cache->destroy('sql', GROUPS_TABLE); 483 484 $message = ($action == 'edit') ? 'GROUP_UPDATED' : 'GROUP_CREATED'; 485 trigger_error($user->lang[$message] . $return_page); 486 } 487 else 488 { 489 confirm_box(false, $user->lang('CONFIRM_AVATAR_DELETE'), build_hidden_fields(array( 490 'avatar_delete' => true, 491 'i' => $id, 492 'mode' => $mode, 493 'g' => $group_id, 494 'action' => $action)) 495 ); 496 } 497 } 498 499 // Did we submit? 500 if ($update) 501 { 502 $group_name = utf8_normalize_nfc(request_var('group_name', '', true)); 503 $group_desc = utf8_normalize_nfc(request_var('group_desc', '', true)); 504 $group_type = request_var('group_type', GROUP_FREE); 505 506 $allow_desc_bbcode = request_var('desc_parse_bbcode', false); 507 $allow_desc_urls = request_var('desc_parse_urls', false); 508 $allow_desc_smilies = request_var('desc_parse_smilies', false); 509 510 $submit_ary = array( 511 'colour' => request_var('group_colour', ''), 512 'rank' => request_var('group_rank', 0), 513 'receive_pm' => isset($_REQUEST['group_receive_pm']) ? 1 : 0, 514 'message_limit' => request_var('group_message_limit', 0), 515 'max_recipients'=> request_var('group_max_recipients', 0), 516 'legend' => $group_row['group_legend'], 517 'teampage' => $group_row['group_teampage'], 518 ); 519 520 if ($config['allow_avatar']) 521 { 522 // Handle avatar 523 $driver_name = $phpbb_avatar_manager->clean_driver_name($request->variable('avatar_driver', '')); 524 $config_name = preg_replace('#^avatar\.driver.#', '', $driver_name); 525 526 if (in_array($driver_name, $avatar_drivers) && !$request->is_set_post('avatar_delete')) 527 { 528 $driver = $phpbb_avatar_manager->get_driver($driver_name); 529 $result = $driver->process_form($request, $template, $user, $avatar_data, $avatar_error); 530 531 if ($result && empty($avatar_error)) 532 { 533 $result['avatar_type'] = $driver_name; 534 535 $submit_ary = array_merge($submit_ary, $result); 536 } 537 } 538 539 // Merge any avatars errors into the primary error array 540 $error = array_merge($error, $phpbb_avatar_manager->localize_errors($user, $avatar_error)); 541 } 542 543 if (!check_form_key('ucp_groups')) 544 { 545 $error[] = $user->lang['FORM_INVALID']; 546 } 547 548 // Validate submitted colour value 549 if ($colour_error = validate_data($submit_ary, array('colour' => array('hex_colour', true)))) 550 { 551 // Replace "error" string with its real, localised form 552 $error = array_merge($error, $colour_error); 553 } 554 555 if (!sizeof($error)) 556 { 557 // Only set the rank, colour, etc. if it's changed or if we're adding a new 558 // group. This prevents existing group members being updated if no changes 559 // were made. 560 // However there are some attributes that need to be set everytime, 561 // otherwise the group gets removed from the feature. 562 $set_attributes = array('legend', 'teampage'); 563 564 $group_attributes = array(); 565 $test_variables = array( 566 'rank' => 'int', 567 'colour' => 'string', 568 'avatar' => 'string', 569 'avatar_type' => 'string', 570 'avatar_width' => 'int', 571 'avatar_height' => 'int', 572 'receive_pm' => 'int', 573 'legend' => 'int', 574 'teampage' => 'int', 575 'message_limit' => 'int', 576 'max_recipients'=> 'int', 577 ); 578 579 foreach ($test_variables as $test => $type) 580 { 581 if (isset($submit_ary[$test]) && ($action == 'add' || $group_row['group_' . $test] != $submit_ary[$test] || isset($group_attributes['group_avatar']) && strpos($test, 'avatar') === 0 || in_array($test, $set_attributes))) 582 { 583 settype($submit_ary[$test], $type); 584 $group_attributes['group_' . $test] = $group_row['group_' . $test] = $submit_ary[$test]; 585 } 586 } 587 588 if (!($error = group_create($group_id, $group_type, $group_name, $group_desc, $group_attributes, $allow_desc_bbcode, $allow_desc_urls, $allow_desc_smilies))) 589 { 590 $cache->destroy('sql', GROUPS_TABLE); 591 $cache->destroy('sql', TEAMPAGE_TABLE); 592 593 $message = ($action == 'edit') ? 'GROUP_UPDATED' : 'GROUP_CREATED'; 594 trigger_error($user->lang[$message] . $return_page); 595 } 596 } 597 598 if (sizeof($error)) 599 { 600 $error = array_map(array(&$user, 'lang'), $error); 601 $group_rank = $submit_ary['rank']; 602 603 $group_desc_data = array( 604 'text' => $group_desc, 605 'allow_bbcode' => $allow_desc_bbcode, 606 'allow_smilies' => $allow_desc_smilies, 607 'allow_urls' => $allow_desc_urls 608 ); 609 } 610 } 611 else if (!$group_id) 612 { 613 $group_name = utf8_normalize_nfc(request_var('group_name', '', true)); 614 $group_desc_data = array( 615 'text' => '', 616 'allow_bbcode' => true, 617 'allow_smilies' => true, 618 'allow_urls' => true 619 ); 620 $group_rank = 0; 621 $group_type = GROUP_OPEN; 622 } 623 else 624 { 625 $group_desc_data = generate_text_for_edit($group_row['group_desc'], $group_row['group_desc_uid'], $group_row['group_desc_options']); 626 $group_rank = $group_row['group_rank']; 627 } 628 629 $sql = 'SELECT * 630 FROM ' . RANKS_TABLE . ' 631 WHERE rank_special = 1 632 ORDER BY rank_title'; 633 $result = $db->sql_query($sql); 634 635 $rank_options = '<option value="0"' . ((!$group_rank) ? ' selected="selected"' : '') . '>' . $user->lang['USER_DEFAULT'] . '</option>'; 636 while ($row = $db->sql_fetchrow($result)) 637 { 638 $selected = ($group_rank && $row['rank_id'] == $group_rank) ? ' selected="selected"' : ''; 639 $rank_options .= '<option value="' . $row['rank_id'] . '"' . $selected . '>' . $row['rank_title'] . '</option>'; 640 } 641 $db->sql_freeresult($result); 642 643 $type_free = ($group_type == GROUP_FREE) ? ' checked="checked"' : ''; 644 $type_open = ($group_type == GROUP_OPEN) ? ' checked="checked"' : ''; 645 $type_closed = ($group_type == GROUP_CLOSED) ? ' checked="checked"' : ''; 646 $type_hidden = ($group_type == GROUP_HIDDEN) ? ' checked="checked"' : ''; 647 648 // Load up stuff for avatars 649 if ($config['allow_avatar']) 650 { 651 $avatars_enabled = false; 652 $selected_driver = $phpbb_avatar_manager->clean_driver_name($request->variable('avatar_driver', $avatar_data['avatar_type'])); 653 654 // Assign min and max values before generating avatar driver html 655 $template->assign_vars(array( 656 'AVATAR_MIN_WIDTH' => $config['avatar_min_width'], 657 'AVATAR_MAX_WIDTH' => $config['avatar_max_width'], 658 'AVATAR_MIN_HEIGHT' => $config['avatar_min_height'], 659 'AVATAR_MAX_HEIGHT' => $config['avatar_max_height'], 660 )); 661 662 foreach ($avatar_drivers as $current_driver) 663 { 664 $driver = $phpbb_avatar_manager->get_driver($current_driver); 665 666 $avatars_enabled = true; 667 $template->set_filenames(array( 668 'avatar' => $driver->get_template_name(), 669 )); 670 671 if ($driver->prepare_form($request, $template, $user, $avatar_data, $avatar_error)) 672 { 673 $driver_name = $phpbb_avatar_manager->prepare_driver_name($current_driver); 674 $driver_upper = strtoupper($driver_name); 675 $template->assign_block_vars('avatar_drivers', array( 676 'L_TITLE' => $user->lang($driver_upper . '_TITLE'), 677 'L_EXPLAIN' => $user->lang($driver_upper . '_EXPLAIN'), 678 679 'DRIVER' => $driver_name, 680 'SELECTED' => $current_driver == $selected_driver, 681 'OUTPUT' => $template->assign_display('avatar'), 682 )); 683 } 684 } 685 } 686 687 if (isset($phpbb_avatar_manager) && !$update) 688 { 689 // Merge any avatars errors into the primary error array 690 $error = array_merge($error, $phpbb_avatar_manager->localize_errors($user, $avatar_error)); 691 } 692 693 $template->assign_vars(array( 694 'S_EDIT' => true, 695 'S_INCLUDE_SWATCH' => true, 696 'S_FORM_ENCTYPE' => ' enctype="multipart/form-data"', 697 'S_ERROR' => (sizeof($error)) ? true : false, 698 'S_SPECIAL_GROUP' => ($group_type == GROUP_SPECIAL) ? true : false, 699 'S_AVATARS_ENABLED' => ($config['allow_avatar'] && $avatars_enabled), 700 'S_GROUP_MANAGE' => true, 701 702 'ERROR_MSG' => (sizeof($error)) ? implode('<br />', $error) : '', 703 'GROUP_RECEIVE_PM' => (isset($group_row['group_receive_pm']) && $group_row['group_receive_pm']) ? ' checked="checked"' : '', 704 'GROUP_MESSAGE_LIMIT' => (isset($group_row['group_message_limit'])) ? $group_row['group_message_limit'] : 0, 705 'GROUP_MAX_RECIPIENTS' => (isset($group_row['group_max_recipients'])) ? $group_row['group_max_recipients'] : 0, 706 707 'GROUP_DESC' => $group_desc_data['text'], 708 'S_DESC_BBCODE_CHECKED' => $group_desc_data['allow_bbcode'], 709 'S_DESC_URLS_CHECKED' => $group_desc_data['allow_urls'], 710 'S_DESC_SMILIES_CHECKED'=> $group_desc_data['allow_smilies'], 711 712 'S_RANK_OPTIONS' => $rank_options, 713 714 'GROUP_TYPE_FREE' => GROUP_FREE, 715 'GROUP_TYPE_OPEN' => GROUP_OPEN, 716 'GROUP_TYPE_CLOSED' => GROUP_CLOSED, 717 'GROUP_TYPE_HIDDEN' => GROUP_HIDDEN, 718 'GROUP_TYPE_SPECIAL' => GROUP_SPECIAL, 719 720 'GROUP_FREE' => $type_free, 721 'GROUP_OPEN' => $type_open, 722 'GROUP_CLOSED' => $type_closed, 723 'GROUP_HIDDEN' => $type_hidden, 724 725 'S_UCP_ACTION' => $this->u_action . "&action=$action&g=$group_id", 726 'L_AVATAR_EXPLAIN' => phpbb_avatar_explanation_string(), 727 )); 728 729 break; 730 731 case 'list': 732 733 if (!$group_id) 734 { 735 trigger_error($user->lang['NO_GROUP'] . $return_page); 736 } 737 738 if (!($row = group_memberships($group_id, $user->data['user_id']))) 739 { 740 trigger_error($user->lang['NOT_MEMBER_OF_GROUP'] . $return_page); 741 } 742 list(, $row) = each($row); 743 744 if (!$row['group_leader']) 745 { 746 trigger_error($user->lang['NOT_LEADER_OF_GROUP'] . $return_page); 747 } 748 749 $user->add_lang(array('acp/groups', 'acp/common')); 750 $start = request_var('start', 0); 751 752 // Grab the leaders - always, on every page... 753 $sql = 'SELECT u.user_id, u.username, u.username_clean, u.user_colour, u.user_regdate, u.user_posts, u.group_id, ug.group_leader, ug.user_pending 754 FROM ' . USERS_TABLE . ' u, ' . USER_GROUP_TABLE . " ug 755 WHERE ug.group_id = $group_id 756 AND u.user_id = ug.user_id 757 AND ug.group_leader = 1 758 ORDER BY ug.user_pending DESC, u.username_clean"; 759 $result = $db->sql_query($sql); 760 761 while ($row = $db->sql_fetchrow($result)) 762 { 763 $template->assign_block_vars('leader', array( 764 'USERNAME' => $row['username'], 765 'USERNAME_COLOUR' => $row['user_colour'], 766 'USERNAME_FULL' => get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']), 767 'U_USER_VIEW' => get_username_string('profile', $row['user_id'], $row['username']), 768 'S_GROUP_DEFAULT' => ($row['group_id'] == $group_id) ? true : false, 769 'JOINED' => ($row['user_regdate']) ? $user->format_date($row['user_regdate']) : ' - ', 770 'USER_POSTS' => $row['user_posts'], 771 'USER_ID' => $row['user_id']) 772 ); 773 } 774 $db->sql_freeresult($result); 775 776 // Total number of group members (non-leaders) 777 $sql = 'SELECT COUNT(user_id) AS total_members 778 FROM ' . USER_GROUP_TABLE . " 779 WHERE group_id = $group_id 780 AND group_leader = 0"; 781 $result = $db->sql_query($sql); 782 $total_members = (int) $db->sql_fetchfield('total_members'); 783 $db->sql_freeresult($result); 784 785 // Grab the members 786 $sql = 'SELECT u.user_id, u.username, u.username_clean, u.user_colour, u.user_regdate, u.user_posts, u.group_id, ug.group_leader, ug.user_pending 787 FROM ' . USERS_TABLE . ' u, ' . USER_GROUP_TABLE . " ug 788 WHERE ug.group_id = $group_id 789 AND u.user_id = ug.user_id 790 AND ug.group_leader = 0 791 ORDER BY ug.user_pending DESC, u.username_clean"; 792 $result = $db->sql_query_limit($sql, $config['topics_per_page'], $start); 793 794 $pending = false; 795 $approved = false; 796 797 while ($row = $db->sql_fetchrow($result)) 798 { 799 if ($row['user_pending'] && !$pending) 800 { 801 $template->assign_block_vars('member', array( 802 'S_PENDING' => true) 803 ); 804 $template->assign_var('S_PENDING_SET', true); 805 806 $pending = true; 807 } 808 else if (!$row['user_pending'] && !$approved) 809 { 810 $template->assign_block_vars('member', array( 811 'S_APPROVED' => true) 812 ); 813 $template->assign_var('S_APPROVED_SET', true); 814 815 $approved = true; 816 } 817 818 $template->assign_block_vars('member', array( 819 'USERNAME' => $row['username'], 820 'USERNAME_COLOUR' => $row['user_colour'], 821 'USERNAME_FULL' => get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']), 822 'U_USER_VIEW' => get_username_string('profile', $row['user_id'], $row['username']), 823 'S_GROUP_DEFAULT' => ($row['group_id'] == $group_id) ? true : false, 824 'JOINED' => ($row['user_regdate']) ? $user->format_date($row['user_regdate']) : ' - ', 825 'USER_POSTS' => $row['user_posts'], 826 'USER_ID' => $row['user_id']) 827 ); 828 } 829 $db->sql_freeresult($result); 830 831 $s_action_options = ''; 832 $options = array('default' => 'DEFAULT', 'approve' => 'APPROVE', 'deleteusers' => 'DELETE'); 833 834 foreach ($options as $option => $lang) 835 { 836 $s_action_options .= '<option value="' . $option . '">' . $user->lang['GROUP_' . $lang] . '</option>'; 837 } 838 839 $pagination = $phpbb_container->get('pagination'); 840 $base_url = $this->u_action . "&action=$action&g=$group_id"; 841 $start = $pagination->validate_start($start, $config['topics_per_page'], $total_members); 842 $pagination->generate_template_pagination($base_url, 'pagination', 'start', $total_members, $config['topics_per_page'], $start); 843 844 $template->assign_vars(array( 845 'S_LIST' => true, 846 'S_ACTION_OPTIONS' => $s_action_options, 847 848 'U_ACTION' => $this->u_action . "&g=$group_id", 849 'S_UCP_ACTION' => $this->u_action . "&g=$group_id", 850 'U_FIND_USERNAME' => append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=searchuser&form=ucp&field=usernames'), 851 )); 852 853 break; 854 855 case 'approve': 856 857 if (!$group_id) 858 { 859 trigger_error($user->lang['NO_GROUP'] . $return_page); 860 } 861 862 if (!($row = group_memberships($group_id, $user->data['user_id']))) 863 { 864 trigger_error($user->lang['NOT_MEMBER_OF_GROUP'] . $return_page); 865 } 866 list(, $row) = each($row); 867 868 if (!$row['group_leader']) 869 { 870 trigger_error($user->lang['NOT_LEADER_OF_GROUP'] . $return_page); 871 } 872 873 $user->add_lang('acp/groups'); 874 875 // Approve, demote or promote 876 group_user_attributes('approve', $group_id, $mark_ary, false, false); 877 878 trigger_error($user->lang['USERS_APPROVED'] . '<br /><br />' . sprintf($user->lang['RETURN_PAGE'], '<a href="' . $this->u_action . '&action=list&g=' . $group_id . '">', '</a>')); 879 880 break; 881 882 case 'default': 883 884 if (!$group_id) 885 { 886 trigger_error($user->lang['NO_GROUP'] . $return_page); 887 } 888 889 if (!($row = group_memberships($group_id, $user->data['user_id']))) 890 { 891 trigger_error($user->lang['NOT_MEMBER_OF_GROUP'] . $return_page); 892 } 893 list(, $row) = each($row); 894 895 if (!$row['group_leader']) 896 { 897 trigger_error($user->lang['NOT_LEADER_OF_GROUP'] . $return_page); 898 } 899 900 $group_row['group_name'] = ($group_row['group_type'] == GROUP_SPECIAL) ? $user->lang['G_' . $group_row['group_name']] : $group_row['group_name']; 901 902 if (confirm_box(true)) 903 { 904 if (!sizeof($mark_ary)) 905 { 906 $start = 0; 907 908 do 909 { 910 $sql = 'SELECT user_id 911 FROM ' . USER_GROUP_TABLE . " 912 WHERE group_id = $group_id 913 ORDER BY user_id"; 914 $result = $db->sql_query_limit($sql, 200, $start); 915 916 $mark_ary = array(); 917 if ($row = $db->sql_fetchrow($result)) 918 { 919 do 920 { 921 $mark_ary[] = $row['user_id']; 922 } 923 while ($row = $db->sql_fetchrow($result)); 924 925 group_user_attributes('default', $group_id, $mark_ary, false, $group_row['group_name'], $group_row); 926 927 $start = (sizeof($mark_ary) < 200) ? 0 : $start + 200; 928 } 929 else 930 { 931 $start = 0; 932 } 933 $db->sql_freeresult($result); 934 } 935 while ($start); 936 } 937 else 938 { 939 group_user_attributes('default', $group_id, $mark_ary, false, $group_row['group_name'], $group_row); 940 } 941 942 $user->add_lang('acp/groups'); 943 944 trigger_error($user->lang['GROUP_DEFS_UPDATED'] . '<br /><br />' . sprintf($user->lang['RETURN_PAGE'], '<a href="' . $this->u_action . '&action=list&g=' . $group_id . '">', '</a>')); 945 } 946 else 947 { 948 $user->add_lang('acp/common'); 949 950 confirm_box(false, $user->lang['CONFIRM_OPERATION'], build_hidden_fields(array( 951 'mark' => $mark_ary, 952 'g' => $group_id, 953 'i' => $id, 954 'mode' => $mode, 955 'action' => $action)) 956 ); 957 } 958 959 // redirect to last screen 960 redirect($this->u_action . '&action=list&g=' . $group_id); 961 962 break; 963 964 case 'deleteusers': 965 966 $user->add_lang(array('acp/groups', 'acp/common')); 967 968 if (!($row = group_memberships($group_id, $user->data['user_id']))) 969 { 970 trigger_error($user->lang['NOT_MEMBER_OF_GROUP'] . $return_page); 971 } 972 list(, $row) = each($row); 973 974 if (!$row['group_leader']) 975 { 976 trigger_error($user->lang['NOT_LEADER_OF_GROUP'] . $return_page); 977 } 978 979 $group_row['group_name'] = ($group_row['group_type'] == GROUP_SPECIAL) ? $user->lang['G_' . $group_row['group_name']] : $group_row['group_name']; 980 981 if (confirm_box(true)) 982 { 983 if (!$group_id) 984 { 985 trigger_error($user->lang['NO_GROUP'] . $return_page); 986 } 987 988 $error = group_user_del($group_id, $mark_ary, false, $group_row['group_name']); 989 990 if ($error) 991 { 992 trigger_error($user->lang[$error] . '<br /><br />' . sprintf($user->lang['RETURN_PAGE'], '<a href="' . $this->u_action . '&action=list&g=' . $group_id . '">', '</a>')); 993 } 994 995 trigger_error($user->lang['GROUP_USERS_REMOVE'] . '<br /><br />' . sprintf($user->lang['RETURN_PAGE'], '<a href="' . $this->u_action . '&action=list&g=' . $group_id . '">', '</a>')); 996 } 997 else 998 { 999 confirm_box(false, $user->lang['CONFIRM_OPERATION'], build_hidden_fields(array( 1000 'mark' => $mark_ary, 1001 'g' => $group_id, 1002 'i' => $id, 1003 'mode' => $mode, 1004 'action' => $action)) 1005 ); 1006 } 1007 1008 // redirect to last screen 1009 redirect($this->u_action . '&action=list&g=' . $group_id); 1010 1011 break; 1012 1013 case 'addusers': 1014 1015 $user->add_lang(array('acp/groups', 'acp/common')); 1016 1017 $names = utf8_normalize_nfc(request_var('usernames', '', true)); 1018 1019 if (!$group_id) 1020 { 1021 trigger_error($user->lang['NO_GROUP'] . $return_page); 1022 } 1023 1024 if (!$names) 1025 { 1026 trigger_error($user->lang['NO_USERS'] . $return_page); 1027 } 1028 1029 if (!($row = group_memberships($group_id, $user->data['user_id']))) 1030 { 1031 trigger_error($user->lang['NOT_MEMBER_OF_GROUP'] . $return_page); 1032 } 1033 list(, $row) = each($row); 1034 1035 if (!$row['group_leader']) 1036 { 1037 trigger_error($user->lang['NOT_LEADER_OF_GROUP'] . $return_page); 1038 } 1039 1040 $name_ary = array_unique(explode("\n", $names)); 1041 $group_name = ($group_row['group_type'] == GROUP_SPECIAL) ? $user->lang['G_' . $group_row['group_name']] : $group_row['group_name']; 1042 1043 $default = request_var('default', 0); 1044 1045 if (confirm_box(true)) 1046 { 1047 // Add user/s to group 1048 if ($error = group_user_add($group_id, false, $name_ary, $group_name, $default, 0, 0, $group_row)) 1049 { 1050 trigger_error($user->lang[$error] . $return_page); 1051 } 1052 1053 trigger_error($user->lang['GROUP_USERS_ADDED'] . '<br /><br />' . sprintf($user->lang['RETURN_PAGE'], '<a href="' . $this->u_action . '&action=list&g=' . $group_id . '">', '</a>')); 1054 } 1055 else 1056 { 1057 $s_hidden_fields = array( 1058 'default' => $default, 1059 'usernames' => $names, 1060 'g' => $group_id, 1061 'i' => $id, 1062 'mode' => $mode, 1063 'action' => $action 1064 ); 1065 1066 confirm_box(false, $user->lang('GROUP_CONFIRM_ADD_USERS', sizeof($name_ary), implode($user->lang['COMMA_SEPARATOR'], $name_ary)), build_hidden_fields($s_hidden_fields)); 1067 } 1068 1069 trigger_error($user->lang['NO_USERS_ADDED'] . '<br /><br />' . sprintf($user->lang['RETURN_PAGE'], '<a href="' . $this->u_action . '&action=list&g=' . $group_id . '">', '</a>')); 1070 1071 break; 1072 1073 default: 1074 $user->add_lang('acp/common'); 1075 1076 $sql = 'SELECT g.group_id, g.group_name, g.group_colour, g.group_desc, g.group_desc_uid, g.group_desc_bitfield, g.group_desc_options, g.group_type, ug.group_leader 1077 FROM ' . GROUPS_TABLE . ' g, ' . USER_GROUP_TABLE . ' ug 1078 WHERE ug.user_id = ' . $user->data['user_id'] . ' 1079 AND g.group_id = ug.group_id 1080 AND ug.group_leader = 1 1081 ORDER BY g.group_type DESC, g.group_name'; 1082 $result = $db->sql_query($sql); 1083 1084 while ($value = $db->sql_fetchrow($result)) 1085 { 1086 $template->assign_block_vars('leader', array( 1087 'GROUP_NAME' => ($value['group_type'] == GROUP_SPECIAL) ? $user->lang['G_' . $value['group_name']] : $value['group_name'], 1088 'GROUP_DESC' => generate_text_for_display($value['group_desc'], $value['group_desc_uid'], $value['group_desc_bitfield'], $value['group_desc_options']), 1089 'GROUP_TYPE' => $value['group_type'], 1090 'GROUP_ID' => $value['group_id'], 1091 'GROUP_COLOUR' => $value['group_colour'], 1092 1093 'U_LIST' => $this->u_action . "&action=list&g={$value['group_id']}", 1094 'U_EDIT' => $this->u_action . "&action=edit&g={$value['group_id']}") 1095 ); 1096 } 1097 $db->sql_freeresult($result); 1098 1099 break; 1100 } 1101 1102 break; 1103 } 1104 1105 $this->tpl_name = 'ucp_groups_' . $mode; 1106 } 1107 }
title
Description
Body
title
Description
Body
title
Description
Body
title
Body
Generated: Thu Jan 11 00:25:41 2018 | Cross-referenced by PHPXref 0.7.1 |