$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 $
|| #######################################################################
\*=========================================================================*/
