$grouplink = '../joinrequests.php?' . vB::getCurrentSession()->get('sessionurl') . "usergroupid=%d"; } // get array of all usergroup leaders $bbuserleader = array(); $leaders = array(); $groupleaders = $vbulletin->db->query_read("\n\t\tSELECT ugl.*, user.username\n\t\tFROM " . TABLE_PREFIX . "usergroupleader AS ugl\n\t\tINNER JOIN " . TABLE_PREFIX . "user AS user USING(userid)\n\t"); while ($groupleader = $vbulletin->db->fetch_array($groupleaders)) { if ($groupleader['userid'] == $vbulletin->userinfo['userid']) { $bbuserleader[] = $groupleader['usergroupid']; } $leaders["{$groupleader['usergroupid']}"]["{$groupleader['userid']}"] = sprintf($userlink, $groupleader['userid'], $groupleader['username']); } unset($groupleader); $vbulletin->db->free_result($groupleaders); if (empty($bbuserleader) and !($permissions['adminpermissions'] & $vbulletin->bf_ugp_adminpermissions['cancontrolpanel'])) { print_modcp_stop_message2('no_permission'); } $requests = $vbulletin->db->query_read("\n\t\tSELECT usergrouprequest.usergroupid, COUNT(usergrouprequestid) AS requests\n\t\tFROM " . TABLE_PREFIX . "usergrouprequest AS usergrouprequest\n\t\tLEFT JOIN " . TABLE_PREFIX . "user AS user USING (userid)\n\t\tWHERE user.userid IS NOT NULL\n\t\tGROUP BY usergroupid\n\t"); while ($request = $vbulletin->db->fetch_array($requests)) { $vbulletin->usergroupcache["{$request['usergroupid']}"]['requests'] = $request['requests']; } unset($request); $vbulletin->db->free_result($requests); print_form_header('', ''); print_table_header($vbphrase['join_requests_manager'], 4); print_cells_row(array($vbphrase['usergroup'], $vbphrase['usergroup_leader'], $vbphrase['join_requests'], $vbphrase['controls']), 1); foreach ($vbulletin->usergroupcache as $usergroupid => $usergroup) { if ($usergroup['ispublicgroup'] and in_array($usergroupid, $bbuserleader)) { print_cells_row(array($usergroup['title'], iif(empty($leaders["{$usergroupid}"]), "<i>{$vbphrase['n_a']}</i>", implode(', ', $leaders["{$usergroupid}"])), vb_number_format($usergroup['requests']), construct_link_code($vbphrase['view_join_requests_gcpuser'], sprintf($grouplink, $usergroupid)))); } }
$pagenav = "<strong>{$vbphrase['go_to_page']}</strong>"; for ($thispage = 1; $thispage <= $pagecount; $thispage++) { if ($thispage == $vbulletin->GPC['pagenumber']) { $pagenav .= " <strong>[{$thispage}]</strong> "; } else { $pagenav .= " <a href=\"banning.php?do=modify&page={$thispage}" . vB::getCurrentSession()->get('sessionurl') . "\" class=\"normal\">{$thispage}</a> "; } } print_description_row($pagenav, false, 8, '', 'right'); } print_cells_row($headercell, 1); while ($user = $vbulletin->db->fetch_array($permusers)) { print_cells_row(construct_banned_user_row($user, $canunbanuser)); } print_submit_row($vbphrase['ban_user'], 0, 8); } if (!$havebanned) { if ($canbanuser) { print_stop_message('no_users_banned_from_x_board_click_here', '<b>' . $vbulletin->options['bbtitle'] . '</b>', 'banning.php?' . vB::getCurrentSession()->get('sessionurl') . 'do=banuser'); } else { print_modcp_stop_message2(array('no_users_banned_from_x_board', '<b>' . $vbulletin->options['bbtitle'] . '</b>')); } } } print_cp_footer(); /*=========================================================================*\ || ####################################################################### || # Downloaded: 15:45, Tue Sep 8th 2015 || # CVS: $RCSfile$ - $Revision: 83432 $ || ####################################################################### \*=========================================================================*/