29 $block[
'showgroups'] =
true;
30 $qb =
$xoops->db()->createXoopsQueryBuilder();
32 $sql = $qb->select(
'u.uid')
33 ->addSelect(
'u.uname')
34 ->addSelect(
'u.email')
35 ->addSelect(
'u.user_viewemail')
36 ->addSelect(
'u.user_avatar')
37 ->addSelect(
'g.name AS groupname')
38 ->fromPrefix(
'groups_users_link',
'l')
39 ->leftJoinPrefix(
'l',
'users',
'u',
'l.uid=u.uid')
40 ->leftJoinPrefix(
'l',
'groups',
'g',
'l.groupid=g.groupid')
41 ->where($eb->eq(
'g.group_type',
':gtype'))
42 ->orderBy(
'l.groupid')
44 ->setParameter(
':gtype',
'Admin', \PDO::PARAM_STR);
46 if (
$result->errorCode() < 2000) {
49 while ($userinfo =
$result->fetch(PDO::FETCH_ASSOC)) {
53 if ($prev_caption != $userinfo[
'groupname']) {
54 $prev_caption = $userinfo[
'groupname'];
55 $block[
'groups'][
$i][
'name'] =
$myts->htmlSpecialChars($userinfo[
'groupname']);
58 $block[
'groups'][
$i][
'users'][] = array(
59 'id' => $userinfo[
'uid'],
60 'name' =>
$myts->htmlspecialchars($userinfo[
'uname']),
65 if ($userinfo[
'user_viewemail']) {
66 $block[
'groups'][
$i][
'users'][] = array(
67 'id' => $userinfo[
'uid'],
68 'name' =>
$myts->htmlspecialchars($userinfo[
'uname']),
69 'msg_link' => $userinfo[
'email'],
73 $block[
'groups'][
$i][
'users'][] = array(
74 'id' => $userinfo[
'uid'],
75 'name' =>
$myts->htmlspecialchars($userinfo[
'uname'])
83 $block[
'showgroups'] =
false;
97 return $block_form->render();
const POPUP_WINDOW_HEIGHT
b_system_info_edit($options)
const F_LOGO_IMAGE_FILE_IS_LOCATED_UNDER
if($xoops->isUser()&&$isAdmin) $response
b_system_info_show($options)